Course Details

The course topic of this globally recognized course is divided in two parts, introduction in SQL and fundamentals of PL/SQL. The first part contains, Writing Basic SQL Select Statements, Restricting and Sorting Data, Single Row Functions, Displaying Data from Multiple Tables, Aggregating Data using Group Functions, Sub queries, Manipulating Data, Creating and Managing Tables, Including Constraints, Creating Views, Creating Other Database Objects. The second part contains, Overview of PL/SQL Programs, Creating Procedures, Creating Functions, Managing Subprograms, Creating Packages, More Package Concepts, Oracle Supplied Packages, Manipulating Large Objects, Creating Database Triggers, More Trigger Concepts, Managing Dependencies.