SQL and PL/SQL Programming

Overview

This course is an introductory application-oriented course covers the relational database systems RDBMS - the predominant system for business, scientific and engineering applications at present. The topics are reinforced using tools such as Oracle Server in labs. The course includes Entity-Relation model, Normalization, Relational model, Relational algebra, and data access queries as well as an introduction to SQL. It also introduces the PL/SQL programming language to the participants by giving practical knowledge in PL/SQL programming, utilizing the services provided by Oracle database in a stored procedure perspective. This includes implementation of Subprograms, Triggers, and Cursors concepts in depth.

Pre-requisite Knowledge/Skills

• Basic programming knowledge and Logical skills

Course Objective

Upon successful completion of the course, participants should be able to:

• Developing a Data Model
• Describes Basic Elements of SQL
• Work with different types of SQL Statements Data Query Language (DQL) Data Definition Language (DDL) Data Manipulation Language (DML)
• Work with Joins and sub-queries
• Understand types of constraints in SQL
• Understand that PL/SQL provides programming extensions to SQL
• Write PL/SQL code to interface with the database
• Design PL/SQL program units that execute efficiently
• Use PL/SQL programming constructs and conditional control statements
• Work with Stored Procedures and Functions
• Understand Triggers and Cursor concepts

Course Outline

The contents of this course are designed to support the course objectives. The following focus areas are included in this course:

• Module 1: DBMS Basics
• Module 2: SQL Basics
• Module 3: SQL Statements, Clauses and Operators
• Module 4: Joins and Sub Queries
• Module 5: SQL Expressions
• Module 6: Schema Object - Table
• Module 7: Constraints and Types
• Module 8: Other Schema Objects
• Module 9: Fundamentals of PL/SQL
• Module 10: SQL in PL/SQL
• Module 11: PL/SQL Control Statements
• Module 12: Subprograms – Procedures and Functions
• Module 13: Packages
• Module 14: Triggers and Cursors

Course Deliverables