Oracle Database 10g: Introduction to SQL - Part II

Request more details:

Description:
The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. Major subject areas to be explored are: • Learn to use the SQL99 join syntax. Also, performing advanced SQL queries using techniques such as grouping and cube operations. • Moving beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others. • Understanding basic database security and object privileges. • Using the powerful set of built-in SQL functions. • Protecting the database and extending the basic data model using declarative constraints. • Developing complex SQL*Plus reports and using SQL*Plus scripts.
Prerequisites:
The course ORACLE DATABASE 10G: INTRODUCTION TO SQL –PART I is a mandatory prerequisite for this course.
SQL99 JOIN TECHNIQUES:
• cross joins
• natural joins
• inner joins
• outer joins
• anti joins
ENHANCING GROUPS WITH ROLLUP & CUBE:
USING THE CASE EXPRESSION:
SQL FUNCTIONS: CHARACTER:
• what are the sql functions?
• character functions
• about greatest(), least()
SQL FUNCTIONS: NUMERIC:
SQL FUNCTIONS: DATE:
• date format functions
• date arithmetic functions
DATABASE OBJECTS: RELATIONAL VIEWS:
• about relational views
• updating view data
• maintaining view definitions
• alter view
• drop view
DATABASE OBJECTS: DATA DICTIONARY STORAGE:
• user_updatable_columns
• understanding the data dictionary structure
DATABASE OBJECTS: INDEXES:
• about indexes
• use b-tree indexes
DATABASE OBJECTS: OTHER OBJECTS:
• creating an application schema
• more about creating tables
• defining sequences
• alter sequence & drop sequence
• alter sequence
• drop sequence
• about synonyms
• drop synonym
• create schema authorization
DATABASE OBJECTS: SECURITY:
• user id passwords
• object security
DATA INTEGRITY USING CONSTRAINTS:
• not null constraint
• check constraint
• unique constraint
• primary key constraint
• references constraint
MANAGING CONSTRAINT DEFINITIONS:
• managing constraints
• renaming & dropping constraints
• enabling & disabling constraints
• deferred enforcement
• set constraints
• handling constraint exceptions
• data dictionary storage
OPTIONAL :
• break

• compute
• column
• ttitle & btitle