Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Java Programming
Print Page
View other Oracle Courses availableOracle Database 10g: Introduction to SQL - Part II
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.
- Cost: €1295.00
- Duration: 3 days
- Cork Date: Jan 17-19, Mar 21-23, May 16-18
- Limerick Date: Feb 27-29, Apr 17-19
- Dublin Date: Feb 7-9, Apr 16-18, Jun 25-27
- This course is also available as a customised client specific course.
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
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()
character functions
about greatest(), least()
SQL FUNCTIONS: NUMERIC:
SQL FUNCTIONS: DATE:
date format functions
date arithmetic functions
date arithmetic functions
DATABASE OBJECTS: RELATIONAL VIEWS:
about relational views
updating view data
maintaining view definitions
alter view
drop view
updating view data
maintaining view definitions
alter view
drop view
DATABASE OBJECTS: DATA DICTIONARY STORAGE:
user_updatable_columns
understanding the data dictionary structure
understanding the data dictionary structure
DATABASE OBJECTS: INDEXES:
about indexes
use b-tree 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
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
object security
DATA INTEGRITY USING CONSTRAINTS:
not null constraint
check constraint
unique constraint
primary key constraint
references 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
renaming & dropping constraints
enabling & disabling constraints
deferred enforcement
set constraints
handling constraint exceptions
data dictionary storage
OPTIONAL :
break
compute
column
ttitle & btitle
compute
column
ttitle & btitle