The course Introduction to SQL is designed to give students a sodid fondation of SQL query language and to acquire practical skills to query databases. The course covers SQL commands for DML (Data Manipulation Language) operations such as SELECT, INSERT, UPDATE, DELETE, table joins, operators, single row and agregate functions.
The course Advanced SQL for Data Reporting and Analysis is designed to broaden your knowledge and practical skills in writing SQL queries using advanced SQL features such as the
analytical SQL functions in Oracle server, hierarchical queries and subqueries.
The course PL/SQL Programmig is an introduction to the PL/SQL programming language. The course covers PL/SQL syntax, declaring variables, conditional statements, loop statements, explicit and implicit cursors.
Oracle Database: Advanced PL/SQL Programming is a continuation of the ‘Oracle Database: PL/SQL Programing’ course and it is intended to extend your knowledge and practical skills in PL/SQL programming language. The course covers the stored procedures and functions, triggers, collections, advanced exception handling and packages.