Oracle Database 11g R2: SQL Fundamentals

Duration - 5 days

Objectives

The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. 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.

Certification

To prepare for the "Exam 1Z0-047: Oracle Database: SQL Certified Expert" certification, one must complete this course as well as the course ORACLE DATABASE 11G: NEW & ADVANCED FEATURES FOR DEVELOPERS.

Suggested Prerequisites

No mandatory prerequisites exist for this course. However, one or more of the following Sideris courses are suggested prerequisites:
• ENTERPRISE ARCHITECTURES FOR EXECUTIVES
• DATA MODELING: LOGICAL DATABASE DESIGN

Content

RELATIONAL DATABASES & SQL

CHOOSING A SQL & PL/SQL INTERFACE

BUILDING A SELECT STATEMENT

RESTRICTING DATA WITH THE WHERE CLAUSE

SORTING DATA WITH THE ORDER BY CLAUSE

USING THE SET OPERATORS

SUMMARY FUNCTIONS

USING SUB-QUERIES

AGGREGATING DATA WITHIN GROUPS

BUILD SIMPLE SQL*PLUS REPORTS

USE DATA DEFINITION LANGUAGE TO CREATE & MANAGE TABLES

USE DATA MANIPULATION LANGUAGE TO MANIPULATE DATA

SQL99 JOIN TECHNIQUES

ENHANCING GROUPS WITH ROLLUP & CUBE

USING THE CASE EXPRESSION SQL FUNCTIONS: CHARACTER

SQL FUNCTIONS: NUMERIC

SQL FUNCTIONS: DATE

DATABASE OBJECTS: RELATIONAL VIEWS

DATABASE OBJECTS: DATA DICTIONARY STORAGE

DATABASE OBJECTS: INDEXES

DATABASE OBJECTS: OTHER OBJECTS

DATABASE OBJECTS: SECURITY

DATA INTEGRITY USING CONSTRAINTS

MANAGING CONSTRAINT DEFINITIONS

ADVANCED SQL*PLUS REPORTS

OPTIONAL - BUILDING SQL*PLUS SCRIPTS

OPTIONAL - SQL*PLUS SESSION CONTROL

Produktų
gamintojai
ir partneriai