Our E-learning curriculum is specifically designed with the busy professional in mind. All of our programs are produced using advanced learning concepts that encompass learning techniques that are designed for adult learning. E- learning is very popular today for a very good reason – It Works! People everywhere are discovering that they can fulfill their learning objectives conveniently (at their own pace, on their own time) and affordably (online classes start at a fraction of the cost of traditional classroom training).
Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software – saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format – allowing you to get the most out of your time online.
Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.
COURSE PREREQISITES
Before attending this course, students must have:
- Familiarity with data processing concepts and techniques
AFTER COMPLETING THIS COURSE, YOU WILL BE ABLE TO:
- 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 in the Oracle Database 11g
- Run data definition language (DDL) statements to create and manage schema objects
- Identify the major structural components of the Oracle Database 11g
COURSE FEATURES:
- Instructor led training by the industry’s finest experts delivered via streaming video online or DVD
- Software demonstrations where the instructor shows you how to perform a task onscreen.
- Interactive multimedia presentations
- Easy to navigate controls
- Course bookmarking which allows you to resume training where you left off the last session.
- Hands-on activities and labs
- Review Questions
- Practice Exam Simulators with three different training and testing modes. These simulators can also be used for pre- and post-testing.
- Free technology upgrades for one year
- Educational support
COURSE OUTLINE
Introduction to Oracle SQL
Relational Database Systems
Examining SQL
SQL Developer and SQL Plus
Examining the Database and Schema
Module Summary
Review Quiz
Select Statements
Basic Select Statements
Selecting Columns and Using Arithmetic Operators
Operator Precedence
Concatenation Operator
Displaying the Table Structure
Module Summary
Review Quiz
Where and Order By Clauses
Implementing the Where Clause
Comparison Operators
Logical Operators
Rules of Precedence
Substitution Variables
Module Summary
Review Quiz
Single Row Functions
Types of Single Row Functions
Working with Dates
Module Summary
Review Quiz
Group Functions
Types of Group Functions
Creating Groups of Data
Multi Column Grouping
Module Summary
Review Quiz
Joins
Natural Joins
Nonequijoins and Outer Joins
Cartesian Joins
Module Summary
Review Quiz
Sub-Queries
Single Row Subqueries
Multiple Row Subqueries
Null Values
Module Summary
Review Quiz
Set Operators
Union and Union All Operators
Intersect and Minus Operators
Select Statements and the Order By Clause
Module Summary
Review Quiz
Data Manipulation Language
Insert Statements
Update Statement
Delete Statement
Database Transactions
Module Summary
Review Quiz
Data Definition Language
Creating Tables
Data Types and Constraints
Altering a Table Statement
Module Summary
Review Quiz
Schema Objects
Views
Sequences
Indexes
Synonyms
Module Summary
Review Quiz
User Privileges
Creating a User
System Privileges
Role and Object Privileges
Granting and Revoking Privileges
Module Summary
Review Quiz
Schema Objects
Altering a Table
Adding Constraints
Dropping Constraints
Indexes
Dropping Tables and Flashback Table
Create and Use External Tables
Module Summary
Review Quiz
Oracle Data Dictionary Views
Using the Oracle Data Dictionary
Types of Views and Querying the Data Dictionary
View Information
Module Summary
Review Quiz
Large Data Sets
Using Subqueries
Default values and Copying Rows
Multi Table Insert
Merge Statement
Flash Back Version Query
Module Summary
Review Quiz
Time Zones
Time Zone Functions
Time Stamp Data Types
Interval Data Types
Available Functions
Module Summary
Review Quiz
Advanced Sub-Queries
Pairwise and Nonpairwise Comparison Queries
Scalar Subquery
Correlated Subquery
Exist Operator and With Clause
Module Summary
Review Quiz
Regular Expressions
Using Regular Expressions
Using Subexpressions and Check Constraint Expressions
Module Summary
Review Quiz
Course Review
To order contact Specialized Solutions at:
Specialized Solutions
Corporate Training Division
3727 Jonlen Drive
Cincinnati, OH 45227
Toll Free – 1-877-291-9797
Direct – 513-878-1116