PL/SQL

PL/SQL

This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Candidates explore the differences between SQL and PL/SQL.

This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Candidates explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database.
This course culminates with a project that challenges students to program, implement, and demonstrate a database solution for a business or organisation.
Students who wish to learn the techniques and tools to automate database application tasks Students who possess basic mathematical, logical, and analytical problem-solving skills Novice programmers, as well as those at advanced levels, to learning the PL/SQL programming language to an advanced level.
PL/SQL
Timeline and Prerequisite
36 Hrs
Course Duration
Prerequsite
Previous experience with at least one programming language, Should Know SQL
PL/SQL
Curriculum
  • Architecture of MS SQL Server
  • Advance SQL
  • Views
  • Working with Cursor
  • Conditional Statements
  • Loops
  • Exception Handling
  • Stored Procedures
  • Functions
  • Introduction to CTE in SQL Server
  • Import / Export
  • INDEXING
  • TRIGGERS
  • ....