Oracle Database 12c SQL & PL/SQL Fundamentals

This course will assist in preparation for the Oracle Database SQL 1Z0-071 and PL/SQL 1Z0-044 certification exams. The Oracle Database SQL and PL/SQL course provides step-by-step instructions on how to write efficient code and development techniques to address your business challenges.

On successful Completion of the Fundamentals of Modelling course you will be able to:

• Run data definition language (DDL) statements
• Identify the major structural components of the Oracle Database
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data
• Employ SQL & PL/SQL functions to generate and retrieve customized data
• Create PL/SQL Triggers
• Create PL/SQL Stored Procedures and Functions