Course Information
Course Objective
This course teaches participants queries, insert, update and delete SQL statements, Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization.
You will also learn how to use SQL to create and manipulate tables in an Oracle Database.
This course prepares participants for Oracle Exam : 1Z0-071.
Course Fees & SkillsFuture Funding
Course Fee : 2999
Regn Fee : $50
Course fee excludes Oracle Exam.
All fees subject to prevailing GST.
Course Prerequisite
Have knowledge of general computing concepts, knowledge of command line interfaces and experience working in command line.
Course Outline
1.0 Oracle and Structured Query Language (SQL)
Download Course Brochure
2.0 Restricting and Sorting Data
3.0 Using Single-Row Functions to Customize Output
4.0 Using Conversion Functions and Conditional Expressions
5.0 Reporting Aggregated Data Using the Group Functions
6.0 Displaying Data from Multiple Tables
7.0 Using Subqueries to Solve Queries
8.0 Using the Set Operators
9.0 Manipulating Data
10.0 Using DDL Statements to Create and Manage Tables
11.0 Managing Objects with Data Dictionary Views
12.0 Controlling User Access
13.0 Managing Schema Objects
14.0 Manipulating Large Data Sets