Course overview:

• Introduction to Oracle and SQL: Writing simple queries
• SQL functions
• Extraction of data from two or more tables, Subqueries
• Table structures and data handling queries (DDL, DML)
• Constraint and View objects
• Indexes, Squences, Synonyms, SET operators
• Regular expressions, pivot and tree structured sql queries
• Oracle user management and final practice
• Preparation for the International Oracle SQL certification exam 1z0-071
• Introduction to PL/SQL