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.
Course Objectives
Elements that will be covered in this course are as follows:
- Learn to use the SQL99 join syntax. Also, performing advanced SQL queries using techniques 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
- SQL 1 is a prerequisites for this course.
Course Benefits
The target audience for this course is all Oracle professionals. Further, this course is well suited for non-Oracle professionals already experienced in the SQ,L 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.