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