Oracle Academy: Database Design + Programming with PL/SQL

The course spans more than 60 hours over 14 days, 2 days per week,
Starting Date: Sunday  28/10/2018
Ending Date:   Sunday  16/12/2018
​
Days: Sunday & Tuesday
Time: From 4:00 to 8:00                   
​Location: iHub Studio, Faculty of Engineering, ASU
​CHEP Training Credit: 7 weeks
Cost: Two Credit Hours

​Instructor
​Eng. Hassan Wageh

Registration Status

Open

Database Design and Programming with SQL​

Learning Objectives
This course engages students to analyze complex business scenarios and create a data model—a conceptual representation of an organization’s information. Participants implement their database design by creating a physical database using SQL. Basic SQL syntax and the rules for constructing valid SQL statements are reviewed. This course culminates with a project that challenges students to design, implement, and demonstrate a database solution for a business or organization.​

Topics
Database Design 

• Introduction
• Entities and Attributes
• Relationship Basics
• Super/Sub Types and Business Rules
• Relationship Fundamentals
• UIDs and Normalization
• Arcs, Hierarchies, and Recursive Modeling
  Mapping
• Creating Database Projects
• Presenting Database Projects  

Database Programming with SQL

• Introduction
• SELECT and WHERE
• WHERE, ORDER BY, and Intro to Functions
• Single Row Functions Part I 
• Single Row Functions Part II
• JOINs
• Group Functions
• Subqueries
• Ensuring Quality Queries Part I
• DML
• DDL
• Constraints
• Views
• Sequences and Synonyms
• Privileges and Regular Expressions
• TCL

​​
More Information

Eligible students

Vertical Divider

Programming with PL/SQL

Learning ​Objectives
​This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more. In this module, you will learn to:

• Conditionally control code flow (loops, control structures).
• Create stored procedures and functions.
• Use PL/SQL packages to group and contain related constructs.
• Create triggers to solve business challenges.
• Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
• Create custom packages for applications.
• Write Dynamic SQL code for applications.

​

Topics

• Introduction
• Working with Oracle Cloud Exadata Express Cloud Service
• Introduction to PL/SQL
• Declare PL/SQL Variables
• Write Anonymous PL/SQL Blocks
• SQL Statements in a PL/SQL block
• Control Structures
• Composite Data Types
• Explicit Cursors
• Exception Handling
• Stored Procedures
• Stored Functions
• Debugging Subprograms
• Packages
• Deploying Packages
• Implement Oracle-Supplied Packages in Application Development
• Dynamic SQL
• Triggers
• Creating Compound, DDL, and Event Database Triggers
• PL/SQL Compiler
• Manage Dependencies

​More Information

Students of Computer Science, Communications, MCTA, and Software engineers from 1st and 2nd year are welcome to apply. 

​Attendees should bring their laptops because there will be a huge part of practical application.
​