ORACLE DATABASE 11g: SQL ESSENTIALS SELF-STUDY TRAINING GUIDE

How This Course Is Organised

The Oracle Database 11g SQL Essentials course provides step-by-step instructions on how to perform a variety of SQL development tasks for activities based on real-life work scenarios. The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.

 

This course provides step-by-step instructions for SQL Database Application Development tasks using Oracle SQL Developer Tool. Students learn to build an Oracle Database and then develop database related applications using SQL.

 

This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

 

The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.

 

Certification 

This course will assist in preparation for the Oracle Database Administration and Application DevelopmentI OCP Certification exams.

 

Duration           

N/A

Audience 

Business Analysts

Functional Implementer

Semantic Layer Modellers

Database Administrators

Technical Consultant

Business Intelligence Developer

Application Developers

Prerequisites:

Familiarity with data processing concepts and techniques

 

Course Objectives:

Run data definition language (DDL) statements to create and manage schema objects
Identify the major structural components of the Oracle Database 11g

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

Course Topics:

Overview

Business Scenario

The Evolution of Oracle

Milestones

 

Introduction to Databases and the Relational Model

Key Oracle DBMS Concepts

Data Modeling and Database Design

Stages of System Development

Basic Types of Data Relationships

The Role of Ordinality and Normalisation

Relational Database Components

 

Oracle Database11g Development Tools

Oracle SQL Developer

Navigate SQL Developer

Exploring Database Objects

SQL*Plus and SQL Workshop

Connecting to the  SQL*Plus Interface

 

Introduction to Oracle Database11g

Oracle Database11g Options

Database Management Packs

Oracle Database11g Related Products

 

Introduction to SQL

Understanding SQL Processing

Understanding the Optimizer

Embedded SQL

 

Data Definition Language

Creating a Database Connection

Creating Tables

Modifying Tables

Managing Constraints

Deleting Tables

Exploring Constraint Information

 

Data Manipulation Language

Creating Queries

Selecting Columns in a Table

Selecting Individual Columns in a Table

 

Using Column Aliases

Selecting Rows

Joining Tables

Using the ORDER BY Clause

Joining Tables with an ON Clause

Applying Conditions to a Join

Joining A Table To Itself

Understanding Outer Joins

Creating Outer Joins

Displaying Data From Multiple Tables

Selecting from the DUAL Table

Selecting SEQUENCE Values

 

Using Subqueries

Understanding Subqueries

Creating Subqueries

Creating Not-in-List Subqueries

Creating Does-Not-Exist (True or False) Subqueries

Creating Correlated Subqueries

Subquery Factoring

 

Working with UNIONS

Understanding UNIONS

Creating UNION Queries

Creating UNION ALL Queries

 

Using Functions

Using Character Functions

Using Numeric Functions

Using Date Functions

Formatting Dates

Using the NVL Function

 

Understanding Aggregate Functions

Using Group Functions

Using Group BY Function

Excluding Group Data With Having

 

Data Manipulation Language (DML) Statements

Inserting Data

Updating Single Row of Data

Updating Multiple Rows of Data

Using the FOR UPDATE Clause

Deleting Data

Using the WITH CHECK OPTION Clause

Commit and Rolling Back Transactions

 

Data Control Language

Database Security Model

Creating a Database User Account

Unlocking a Database User Account

Granting System Privileges

Granting System Privileges to User

Granting Object Privileges

Granting And Revoking Object Privileges

Granting And Revoking Object Privileges to User

Using Synonyms For Database Transparency

NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY CBT AND E-LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER CBT OR E-LEARNING FORMAT. PRICES DIFFER

What is a Training Guide?

In a nutshell, Self-Study Training Guide products are similar to Microsoft’s step-by-step books except Self-Study Training Guide products come with far more theory and practice; updated every quarter and are delivered on CD-ROM in e-Book format with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality courseware / Training Guides which are regularly UPDATED every 3 months with FREE UPGRADES to the LATEST EDITION:

A NEW, very effective and proven way of publishing and learning.

These factors give Training Guides a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods. Training Guides not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

 

NOTE: WebLearning Publishing Courseware/Training Guide products are no longer available in Hard-copy Print format. They are now delivered in eBook Format with FULL LICENCE KEY..

The WebLearning unique Methodology

All WebLearning® Training Guide courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: ANEW, very effective and proven way of learning. You need to register your product to qualify for FREE UPGRADES.

 

FACT:

• Material retention with Self-study Courseware is 35% better than with conventional training methods
• Your learning curve with Self-study Courseware is 20%-40% less than conventional methods
• The cost of Self-study Courseware training is over 95% less than Classroom training
• Self-study Courseware are self pacing, hands-on and offer step-by- step guide to actual software being studied