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.
This course is designed to broaden your knowledge and practical skills in writing SQL queries using the advanced features of the SQL language, analysing data and building reports with standard tools such as MS Excel and MS Access.
The course PL/SQL Programmig is an introduction to PL/SQL programming language. The course covers the 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.