Oracle Database 11g R2: SQL Fundamentals II
- 3h 3m
- Sideris Courseware Corporation
- Sideris
- 2011
This Oracle 11g courseware training guide book will prepare students for the Oracle certification exams (OCP). This course book can be used as a user guide tutorial for ongoing reference long after the course is completed.
Audience
The target audience for this training course is all Oracle professionals, both business and systems professionals, who wish to pass the Oracle certification exams and 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.
In this Book
-
Course Introduction
-
Workshop Setup Guide
-
Understanding Data Models
-
SQL99 Join Techniques
-
SQL99 Join Techniques
-
Enhancing Groups with Rollup & Cube
-
Enhancing Groups with Rollup & Cube
-
Using the CASE Expression
-
Using the CASE Expression
-
SQL Functions—Character
-
SQL Functions—Character
-
SQL Functions—Numeric
-
SQL Functions—Numeric
-
SQL Functions—Date
-
SQL Functions—Date
-
Database Objects—Relational Views
-
Database Objects—Relational Views
-
Database Objects—Data Dictionary Storage
-
Database Objects—Data Dictionary Storage
-
Database Objects—Indexes
-
Database Objects—Indexes
-
Database Objects—Other Objects
-
Database Objects—Other Objects
-
Database Objects—Security
-
Database Objects—Security
-
Data Integrity Using Constraints
-
Data Integrity Using Constraints
-
Managing Constraint Definitions
-
Managing Constraint Definitions
-
Advanced SQL*Plus Reports
-
Advanced SQL*Plus Reports
-
Building SQL*Plus Scripts
-
Building SQL*Plus Scripts
-
SQL*Plus Session Control
-
SQL*Plus Session Control
