SQL 11g

About Training

DESCRIPTION

Duration: 20 hours
Target Audience: Professionals who want to develop programs that use the language for SQL relational databases.
Requirements: Database Basics.

Course objectives

• Know the SQL language sub-divisions – DML, DDL and DCL
• Understanding on competition of transactions
• Know the Oracle SQL functions
◦ Mathematics, treatment strings, conversion
◦ Operations with dates, numbers and strings
◦ NVL, DECODE, CASE, TO_CHAR, TO_DATE, TO_NUMBER, etc.

Course content

Introduction to SQL Manipulating Objects
Data Query statement – SELECT
Data Handling Instructions – DML
INSERT and INSERT with SELECT
UPDATE
DELETE
MERGE
Data Control Instructions – DCL
GRANT
REVOKE
AUDIT and NOAUDIT
 Creating, changing, and deleting
Tables
Indexes
Views
Synonyms
Using the Data Dictionary Using Functions
 Querying
User tables
User Contents
User Visions
User Synonym
 Character Handling Functions
Data Handling Functions
Numbers Handling Functions (Mathematics)
Working with Joins Working with Subqueries
 JOINS standard syntax Oracle
Syntax JOINS ANSI-92
NATURAL, INNER, LEFT, RIGHT and OUTER JOIN
 Subquery in the WHERE, EXISTS clause
Virtual tables (subquery in FROM)
Subquery in the SELECT clause
Using Aggregate Functions Working with Record Groups Operators
 Character Handling Functions
Data Handling Functions
Numbers Handling Functions (Mathematics)
UNION, UNION ALL, MINUS, INTERSECT
02.fw20H

Hire

 SQL 11g PL/SQL 11g Management 11g Backup 11g Performance 11g

Our Clients