Innovation Hub (iHub)
  • Home
  • General info
  • ECDC
  • CNC workshop feedback
    • PLC workshop feedback
    • Formula academy
  • Coworking Space
    • iAcademy >
      • iAcademy17
      • iAcademy_Survey >
        • iClubs >
          • iClubs 2020 Registration
      • iAcademy Personal Development Track
  • Programs
    • Entrepreneurship >
      • iSpark 2020 - Wave 1
      • Seminars >
        • Seminar Registeration Form
        • Seminars Feedback
        • Seminar Material
      • iCamp
    • iGP >
      • iGP2021
      • Apply
    • ZEH >
      • 17zeh-submission-form
      • 17ZEH_technical_support_form
    • iLab16
    • internships
    • EVER
  • Calendar
  • About
    • Media
  • CIB Internship
  • Front End Web Development 2021
  • NAID assistive technologies summer internship
  • iCamp Mobile Development
  • iCamp Web Development
  • NAID assistive technologies summer internship-2nd form
  • Category
  • ASU Innovates Researchers - Semi-Finals
  • Researchers'23 Interviews
  • ​​Researchers Interviews 2
  • ASU Innovates Researchers - Bootcamp

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  02/12/2018
Ending Date:   Sunday  15/01/2019
​

Days: Sunday & Tuesday
Time:
From 4:00 to 8:00                   
​Location: iHub Studio, room 934 A, CHEP building, Third floor, 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.

​

    Registration Application 

Submit
Copyright © Innovation Hub ( iHub )  2013

  • Home
  • General info
  • ECDC
  • CNC workshop feedback
    • PLC workshop feedback
    • Formula academy
  • Coworking Space
    • iAcademy >
      • iAcademy17
      • iAcademy_Survey >
        • iClubs >
          • iClubs 2020 Registration
      • iAcademy Personal Development Track
  • Programs
    • Entrepreneurship >
      • iSpark 2020 - Wave 1
      • Seminars >
        • Seminar Registeration Form
        • Seminars Feedback
        • Seminar Material
      • iCamp
    • iGP >
      • iGP2021
      • Apply
    • ZEH >
      • 17zeh-submission-form
      • 17ZEH_technical_support_form
    • iLab16
    • internships
    • EVER
  • Calendar
  • About
    • Media
  • CIB Internship
  • Front End Web Development 2021
  • NAID assistive technologies summer internship
  • iCamp Mobile Development
  • iCamp Web Development
  • NAID assistive technologies summer internship-2nd form
  • Category
  • ASU Innovates Researchers - Semi-Finals
  • Researchers'23 Interviews
  • ​​Researchers Interviews 2
  • ASU Innovates Researchers - Bootcamp