Oracle Database SQL Workshop

This course is a combination of Oracle Database: SQL Workshop I and Oracle Database: SQL Workshop II courses. The Oracle Database SQL Workshop course provides step-by-step instructions on how to use a combination of database modelling and development  techniques to address your business challenges.

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

• Identify the major structural components of the Oracle Database
• Create reports of aggregated data
• Write SELECT statements that include queries
• Retrieve row and column data from tables
• Run data manipulation statements (DML) in Oracle Database 12c
• Create tables to store data
• Utilize views to display data
• Control database access to specific objects
• Manage schema objects
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Manage objects with data dictionary views
• Write multiple-column sub-queries
• Employ SQL functions to retrieve customized data
• Use scalar and correlated sub-queries
• Create reports of sorted and restricted data