Price: $1150
Duration: 2 Days
Audience:
Level:
Technology: .NET
Delivery Method:
Software Assurance Value:
Microsoft CPE:
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.
Specific subject areas to be explored and objectives to be reached are:
The target audience for this course is all Oracle professionals. 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.
SQL DATA DEFINITION LANGUAGE • ABOUT SQL DDL • CREATE TABLE STATEMENT • ALTER TABLE STATEMENT • DROP TABLE STATEMENT • SUPPORTIVE STATEMENTSDATABASE 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 STRUCTUREDATABASE 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 AUTHORIZATIONDATABASE OBJECTS: SECURITY • USER ID PASSWORDS• OBJECT SECURITY DATA INTEGRITY USING CONSTRAINTS• NOT NULL CONSTRAINT• CHECK CONSTRAINT • UNIQUE CONSTRAINT • PRIMARY KEY CONSTRAINT • REFERENCES CONSTRAINTMANAGING CONSTRAINT DEFINITIONS• MANAGING CONSTRAINTS• RENAMING & DROPPING CONSTRAINTS • ENABLING & DISABLING CONSTRAINTS• DEFERRED ENFORCEMENT • SET CONSTRAINTS• HANDLING CONSTRAINT EXCEPTIONS• DATA DICTIONARY STORAGEOPTIONAL – ADVANCED SQL*PLUS REPORTS • BREAK • COMPUTE• COLUMN• TTITLE & BTITLE OPTIONAL – BUILDING SQL*PLUS SCRIPTS• USING SQL*PLUS VARIABLES • DEFINE & UNDEFINE • ACCEPT• PROMPT• PAUSE
Before attending this course, students must have: