Oracle Database 11g SQL Fundamentals
Oracle
Training
Provided by Wintrac Inc.
This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. 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
Related Software Programs or Products: Oracle 11g
Related Awards, Degrees or Certifications: This course considers subjects applicable to certification as an Oracle Database Certified SQL Expert. The topics considered are
|
|
||||||||||||||
Oracle Database 11g SQL Fundamentals
Volume I - Contents
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
PSEUDO COLUMNS & FUNCTIONS
JOINING TABLES
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
APPENDIX A
Volume II - Contents
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 - ADVANCED SQL*PLUS REPORTS
OPTIONAL - BUILDING SQL*PLUS SCRIPTS
OPTIONAL - SQL*PLUS SESSION CONTROL
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
PSEUDO COLUMNS & FUNCTIONS
JOINING TABLES
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
APPENDIX A
Volume II - Contents
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 - ADVANCED SQL*PLUS REPORTS
OPTIONAL - BUILDING SQL*PLUS SCRIPTS
OPTIONAL - SQL*PLUS SESSION CONTROL
About The Training Provider: Wintrac Inc.
Wintrac Inc. - We can offer training on a wide range of topics including
Java, C , Visual Basic, C#, .NET, XML, Linux, PowerBuilder, Oracle and
Microsoft technologies. We can also offer end user training on a variety of
topics including Office, AUTOCAD, Lotus Notes etc. You can get a partial list
of all the onsite training courses we offer at http://www. wintrac. com/ courses. htm.
Wintrac clients...
