ORACLE DATABASE 11G R2: SQL FUNDAMENTALS II– GTD2

Course Description

This course is well suited for non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL.

^^

Duration

3 days

^^

Target Audience

The target audience for this training course is all Oracle professionals, both business and systems professionals, who need a “how to” guide to acquire the knowledge of SQL. Further, this course is well suited for non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL. Among the specific groups for whom this course will be helpful are application developers and database administrators.

^^

Course Prerequisites

A basic knowledge of computer programming concepts is required along with an understanding of the general Oracle architecture and relational database design and modelling. Those who wish to attend this course require attendance of the course below, a similar course, or have the equivalent experience.

If you have any questions or doubts as to whether you meet the pre-requisites for this course, or indeed are wondering which course best suits you, please consult with us to discuss your suitability for course attendance.

^^

Suggested Follow on Courses

^^

Course Content

SQL99 JOIN TECHNIQUES

• CROSS JOINS

• NATURAL JOINS

• INNER JOINS

• OUTER JOINS

• ANTI JOINS

• USING NAMED SUBQUERIES

ENHANCING GROUPS WITH ROLLUP & CUBE

• USING ROLLUP

• USING CUBE

USING THE CASE EXPRESSION

SQL FUNCTIONS: CHARACTER

• STRING FORMATTING FUNCTIONS

• ASCII CODES FUNCTIONS

• PAD & TRIM FUNCTIONS

• STRING MANIPULATION FUNCTIONS

• STRING COMPARISON FUNCTIONS

• PHONETIC SEARCH FUNCTIONS

SQL FUNCTIONS: NUMERIC

• ABOUT THE NUMERIC FUNCTIONS

• NULL VALUE FUNCTIONS

SQL FUNCTIONS: DATE

• DATE FORMAT FUNCTIONS

• DATE ARITHMETIC FUNCTIONS

DATABASE OBJECTS: RELATIONAL VIEWS

• ABOUT DATABASE OBJECTS

• ABOUT RELATIONAL VIEWS

• UPDATING VIEW DATA

• MAINTAINING VIEW DEFINITIONS

• ALTER VIEW

• DROP VIEW

 

DATABASE OBJECTS: DATA DICTIONARY STORAGE

• ABOUT THE DATA DICTIONARY

• OBJECT-SPECIFIC DICTIONARY VIEWS

• USER_UPDATABLE_COLUMNS

• UNDERSTANDING THE DATA DICTIONARY STRUCTURE

DATABASE OBJECTS: INDEXES

• ABOUT INDEXES

• USE B-TREE INDEXES

 

DATABASE OBJECTS: OTHER OBJECTS

• MORE ABOUT CREATING TABLES

• ABOUT SEQUENCES

• ALTER SEQUENCE & DROP SEQUENCE

• ALTER SEQUENCE

• DROP SEQUENCE

• ABOUT SYNONYMS

• DROP SYNONYM

• CREATE SCHEMA AUTHORIZATION

DATABASE OBJECTS: SECURITY

• USER PASSWORDS

• OBJECT SECURITY

 

DATA INTEGRITY USING CONSTRAINTS

• ABOUT CONSTRAINTS

• NOT NULL CONSTRAINT

• CHECK CONSTRAINT

• UNIQUE CONSTRAINT

• PRIMARY KEY CONSTRAINT

• REFERENCES CONSTRAINT

• DEFINING CONSTRAINTS ON EXISTING TABLES

MANAGING CONSTRAINT DEFINITIONS

• RENAMING & DROPPING CONSTRAINTS

• ENABLING & DISABLING CONSTRAINTS

• DEFERRED ENFORCEMENT

• SET CONSTRAINTS

• HANDLING CONSTRAINT EXCEPTIONS

• CONSTRAINTS WITH VIEWS

• DATA DICTIONARY STORAGE

 

ADVANCED SQL*PLUS REPORTS

• BREAK

• COMPUTE

• COLUMN

• TTITLE & BTITLE

OPTIONAL – ADVANCED SQL*PLUS REPORTS

• REPORT-

• REPORT-2

• SOLUTIONS

• REPORT-1

• REPORT-2

 

OPTIONAL – BUILDING SQL*PLUS SCRIPTS

• USING SQL*PLUS VARIABLES

• DEFINE & UNDEFINE

• ACCEPT

• PROMPT

• PAUSE

OPTIONAL – SQL*PLUS SESSION CONTROL

• CONTROLLING SYSTEM VARIABLES

• SET

• SHOW

© 2011 Sideris Courseware Corporation

^^

See more Database Technologies courses