Instructor-led training
Oracle 11g Advanced SQL Programming Training in Honolulu, Hawaii
In this class, students will develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle datatypes, learn analysis and tuning techniques to increase SQL performance, and master advanced features of Oracle …
What you'll learn
In this class, students will develop deeper insight into relational
database design and RDBMS operation, learn concepts and specific SQL
syntax for extended Oracle datatypes, learn analysis and tuning
techniques to increase SQL performance, and master advanced features of
Oracle SQL for large data sets and data warehouses.
Prerequisites
Oracle 11g SQL Programming
Course Outline
Course Introduction
Course Objectives
Course Overview
Using the Workbook
Suggested References
Database Design Concepts
Relational Databases
The Relational Model
Relational Operations
The Database Design Process
Normalization
Second and Third Normal Forms
Other Normal Forms
Applications for Relational Databases
SQL Subqueries
Overview of Subqueries
Inline Views
Correlated Subqueries
EXISTS Clause vs. IN Clause
Quantified Comparisons: ANY and ALL
Scalar Subquery Expression
Subqueries and DML Statements
Inline Views
Top-N and Bottom-N analysis
CREATE TABLE and Subqueries
Hierarchical Queries
Hierarchical Data
Self Joins
Hierarchical Query
Hierarchical Pseudocolumns
SYS_CONNECT_BY_PATH
Recursive Query Factoring
Object Types
Object-Oriented Programming
Oracle's Object Relational Model
Creating Object Types
Querying Object Types
DML with Object Types
Object Methods
Object Views
VARRAYs
Nested Tables
Times, Dates, and Strings
Datetime Fields
Dates and Timestamps
Intervals
Date and Interval Literals
Date Arithmetic
Date Functions
Character Types
Session and Database Parameters
REGEXP Functions
Regular Expressions Supported by
REGEXP
Applying REGEXP Functions
Temporary Tables
Undo and Redo
Temporary Tables Defined
Data Lifetime — Transaction vs. Session
Creating Temporary Tables
Managing Temporary Tables
Storage of Temporary Tables
Effects of DML and TRUNCATE
SQL Tuning Tools
Automated Statistics Gathering
The DBMS_STATS Package
SQL Tuning Advisor
SQL Tuning Sets
SQL Access Advisor
Retrieving Execution Plans
EXPLAIN PLAN
Using DBMS_XPLAN
Interpreting Explain Plan Results
SQL Trace
TKPROF
SQL Tuning
Tuning Goals
The Optimizer
Optimizer Statistics
Identifying SQL to Tune
Optimizer Hints
Optimizer Goal Hints
Access Path Hints
Join Hints
Additional Hints
SQL Plan Management
Indexes
Indexes
B-tree and Composite Indexes
Reverse Key and Unique Indexes
Function-Based Indexes
Bitmap Indexes
Index-Organized Tables
Managing Indexes
Oracle Analytic Functions
ROLLUP
CUBE
Grouping Sets
Analytic Functions
OVER, PARTITION BY and ORDER
BY
RANK
Modeling
Model Clauses
Data Warehouse Features
Partitioned Tables
Partitioning Methods
Partition Pruning and Partition-wise
Joins
Bitmap Indexes
Training locations
Oracle 11g Advanced SQL Programming training across the U.S. and beyond.
We provide Oracle 11g Advanced SQL Programming training onsite and live online for organizations throughout the United States and internationally.
- Denver
- Atlanta
- Phoenix
- Boston
- Sacramento
- Austin
- Salt Lake City
- Raleigh
- Columbus
- Nashville
- Indianapolis
- Richmond
- and more
View all Oracle 11g Advanced SQL Programming training locations
- Denver, Colorado
- Montgomery, Alabama
- Little Rock, Arkansas
- Atlanta, Georgia
- Juneau, Alaska
- Indianapolis, Indiana
- Honolulu, Hawaii
- Trenton, New Jersey
- Springfield, Illinois
- Providence, Rhode Island
- Boston, Massachusetts
- Phoenix, Arizona
- Sacramento, California
- Dover, Delaware
- Tallahassee, Florida
- Boise, Idaho
- Richmond, Virginia
- Des Moines, Iowa
- Topeka, Kansas
- Frankfort, Kentucky
- Baton Rouge, Louisiana
- Augusta, Maine
- Annapolis, Maryland
- Lansing, Michigan
- Saint Paul, Minnesota
- Jackson, Mississippi
- Jefferson City, Missouri
- Helena, Montana
- Lincoln, Nebraska
- Carson City, Nevada
- Concord, New Hampshire
- Santa Fe, New Mexico
- Albany, New York
- Raleigh, North Carolina
- Bismarck, North Dakota
- Columbus, Ohio
- Oklahoma City, Oklahoma
- Salem, Oregon
- Harrisburg, Pennsylvania
- Columbia, South Carolina
- Pierre, South Dakota
- Nashville, Tennessee
- Austin, Texas
- Salt Lake City, Utah
- Montpelier, Vermont
- Olympia, Washington
- Charleston, West Virginia
- Madison, Wisconsin
- Cheyenne, Wyoming
- Hartford, Connecticut
- Toronto, Canada
- Berlin, Germany
- Stockholm, Sweden
- London, United Kingdom
- Dublin, Ireland
Train your team with HSG
Private, instructor-led training customized for your organization.
- Onsite or live online delivery
- Customized curriculum
- Training for groups of 3 or more
- Flexible scheduling
- Experienced instructors
Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com
Related training
Browse all Oracle, MySQL, Cassandra, Hadoop Database courses →
Ready to train your team?
Let's customize this training for your organization.
Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.