|
ORA01FND-8i-03-SG
Introduction to Oracle8i: Advanced SQL & SQL*Plus (3 Days)
Description
Essential advanced features within the Oracle SQL language are considered within this course. Building indexes, specifying declarative constraints, managing security privileges for tables and using SQL to satisfy some of the most complex query requests are all among the topics considered within this course. This course largely focuses on SQL features that are unique to the Oracle database and as such is applicable even for SQL professionals experienced in other databases.
Audience
Target audience for this course is all Oracle professionals, such as:
• Application developers
• Database administrators
• Designers
• Web application developers
Mandatory Prerequisites
• Introduction To Oracle8i: SQL & SQL*Plus
Suggested Next Courses
• Introduction to Oracle8i: PL/SQL Language
Objectives
The objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Major subject areas to be explored are:
• Defining database objects, including tables, indexes, sequences and others
• Understanding database security
• Using SQL functions
• Protecting the database with declarative constraints
• Advanced grouping and cube operations
• Processing data hierarchies
• Developing complex SQL*Plus reports
• Developing SQL*Plus scripts
Course Outline
DEFINING DATABASE OBJECTS • DESIGNING A SCHEMA • DEFINING TABLES • DEFINING INDEXES • DEFINING VIEWS • DEFINING SEQUENCES • DEFINING SYNONYMS
DATABASE SECURITY
SQL FUNCTIONS (CHARACTER)
SQL FUNCTIONS (NON-CHARACTER) • NUMERIC FUNCTIONS • DATE FORMAT FUNCTIONS • DATE ARITHMETIC FUNCTIONS • NULL VALUE FUNCTIONS
PROTECTING TABLES WITH DECLARATIVE CONSTRAINTS • WHAT ARE CONSTRAINTS? • NOT NULL • CHECK • UNIQUE • PRIMARY KEY • REFERENCES • DEFINING CONSTRAINTS ON EXISTING TABLES
MAINTAINING CONSTRAINT DEFINITIONS • MAINTAINING CONSTRAINTS • DROPPING CONSTRAINTS • ENABLING & DISABLING CONSTRAINTS • VALIDATE NEW TRANSACTIONS ONLY • DEFERRED ENFORCEMENT • SET CONSTRAINTS … DEFERRED • MANAGING CONSTRAINT EXCEPTIONS • CONSTRAINTS AND VIEWS • DATA DICTIONARY STORAGE
ENHANCING GROUPS WITH ROLLUP & CUBE
ADVANCED SQL*PLUS REPORTS • REPORT COMMANDS • BREAK • COMPUTE • COLUMN • TTITLE / BTITLE
BUILDING SQL*PLUS SCRIPTS • ABOUT SCRIPT FILES • USING SQL*PLUS VARIABLES • ACCEPT • START OR @ • PROMPT • PAUSE
PROCESSING HIERARCIES
ADVANCED SQL & SQL*PLUS FEATURES • MULTIPLE SUMMARIES WITH VIEWS • SET • SHOW
|
|
|
|
