Oracle Database 12c: Introduction to SQL Training in Australia

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

There are no prerequisites for this course.

• Data Warehouse Administrator
• PL/SQL Developer
• Application Developers
• System Analysts
• Business Analysts
• Forms Developer
• Developer

• Identify the major structural components of the Oracle Database 12c
• 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

• Introduction to Oracle Database 
• Retrieve Data using the SQL SELECT Statement
• Learn to Restrict and Sort Data
• Usage of Single-Row Functions to Customize Output
• Invoke Conversion Functions and Conditional Expressions
• Aggregate Data Using the Group Functions
• Display Data From Multiple Tables Using Joins
• Use Sub-queries to Solve Queries
• The SET Operators
• Data Manipulation Statements
• Use of DDL Statements to Create and Manage Tables
• Other Schema Objects
• Control User Access
• Management of Schema Objects
• Manage Objects with Data Dictionary Views
• Manipulate Large Data Sets
• Data Management in different Time Zones
• Retrieve Data Using Sub-queries
• Regular Expression Support