SQL and PL/SQL Programming

SQL and PL/SQL Programming

Course Code:

PSQ01

Course Duration:

100 hours

Course Delivery:

70 hours

Workshop:

08 hours

Project Work:

22 hours

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

For Faculty

  • Course Material
  • Course Slides
  • Facilitator Guide
  • Student Exercises
  • Case Studies
  • Certification from ICT Academy of Tamil Nadu

For Student

  • Course Material
  • Orientation session by ICT Academy of Tamil Nadu / Industry Experts
  • Exercises
  • Case Studies
  • Online Assessment
  • Certification from ICT Academy of Tamil Nadu