Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

   

Advanced Oracle SQL Training Course

2007-2016 by Burleson Corporation

This advanced SQL course is taught at your Company site with up to 20 students.   

This SQL course can be taught as a 3-day, 4-day or 5-day class.

Click here for on-site course prices

Optional supplemental mentoring

 

Key Features

Understand advanced Oracle SQL analytics

Learn how to traverse complex hierarchical relationships

Expand your understanding of Oracle SQL to solve complex business queries

Download working examples of Oracle analytic functions

See how to quickly format Oracle data with XML for seamless publication

Learn expert tips and tricks for writing high-quality SQL

* See how initialization parameters affect SQL optimization.

* Understand how to read an execution plan.

* Learn the importance of schema statistics.

* Learn how to apply "global" changes to tune many SQL statements at once.

* See how to locate missing indexes.

* See how to use the library cache to find SQL  opportunities.

* Understand how to prioritize your SQL  efforts.

 

  

Course Description

Our advanced Oracle SQL training is an intensive three-day, four-day, or five-day course designed to provide Oracle professionals with an in-depth understanding of Oracle SQL and how to formulate and tune SQL statements for optimal performance. Burleson instructors offer decades of real world DBA experience in Oracle features, and they will share their secrets in this intense Oracle SQL training.

Book Required

  Advanced Oracle SQL Tuning: The Definitive Reference

Donald K. Burleson,
Rampant TechPress

ISBN-13 978-0-9823061-5-4

advanced Oracle SQL training   Advanced Oracle SQL Programming: The expert guide to writing complex queries

Laurent Schneider

Audience

This SQL  course is designed for practicing Oracle DBA's and Systems Administrators professionals who have basic experience with SQL statements. Prior experience with Oracle is not required, but experience using SQL with a relational database is highly desirable.

The goal of the SQL  class is to provide a comprehensive toolkit to allow the DBA to quickly locate and tune a database workload.

Curriculum Design

This advanced SQL  course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL .  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their secrets in this intense Oracle SQL training.

Learning Objectives

By the end of this advanced SQL course the student will be able to tune advanced SQL queries including correlated subqueries and outer joins. The student will also become familiar with all of the major SQL  techniques for Oracle, including global parameter and statistics changes, adding missing indexes and adjusting optimizer statistics.  The student will also see the internals of the Oracle optimizers, and see proven techniques for  Oracle SQL statements for optimal performance.


Advanced Oracle SQL training class  
Three Day Syllabus

© 2016 by Donald K. Burleson

Note: You choose the specific SQL topics based on your specific  requirements.

Day 1: Introduction to SQL Programming

Class 1: Oracle SQL Query Overview  
Introduction   
Syntax Review           
Subquery Inline view 
Nested subquery        
Joins   
Sets    
SQL expressions        
Exercises        
Solutions        

Class 2: Oracle SQL Functions  
Oracle SQL functions
Mathematic functions
Binary functions        
Signs functions          
Rounding and truncating functions   
Modulo functions      
Functions to search and modify strings         
Regular expression functions 
Conversion functions 
NLS functions           
National character set
Logical functions with true or false values    
Null functions
Exercises        
Solutions        

Class 3: SQL Aggregate Functions       
Aggregate functions  
Standard Aggregate Functions          
Distinct          
Keep   
Nested Aggregates    
Subtotals        
PIVOT and UNPIVOT         
Exercises        
Solutions        

Class 4: Oracle SQL Analytics   
Analytics        
OVER
PARTITION  
Ranking functions      
Window         
Aggregation   
FIRST_VALUE and LAST_VALUE          
Exercises        
Solutions        

Class 5: Regular Expressions in SQL

 

 

 

DAY 3 Advanced SQL  Topics

Class 6: XML      
XML  
XML Instance
XMLTYPE    
XMLELEMENT       
XMLCONCAT and XMLFOREST 
XPATH          
XMLSEQUENCE     
XQuery          
Aggregation   
XMLSERIALIZE     
XMLCAST        
Exercises        
Solutions        

Class 7: Oracle Hierarchies        
Hierarchies     
Hierarchical Queries   
CONNECT BY, PRIOR and START WITH           
LEVEL          
ORDER SIBLINGS BY       
PRIOR           
SYS_CONNECT_BY_PATH           CONNECT_BY_ROOT       
CONNECT BY LOOP         
CONNECT BY NOCYCLE and CONNECT_BY_ISCYCLE      
CONNECT BY without PRIOR       CONNECT_BY_ISLEAF  
WHERE and JOIN    
Aggregation   
Exercises        
Solutions

Class 8: SQL For Modeling       
SQL for Modeling     
Partitions, dimensions and measures 
Update           
Upsert
CV     
Conditions     
FOR loops      
Iterations        
Reference Model       
Aggregation   
Analytics        
Ordered Rows           
Exercises        
Solutions        

Class 9:  SQL*Plus        
Starting SQL*Plus     
SQL*Plus Statements
Formatting     
Substitution Variables
HTML
Index  

 

 

Please note that while the knowledge gained from this Oracle SQL training may be valuable when preparing for OCP exams, the content of this SQL course is not for Oracle Certification, including the Certified Professional (OCP) or Oracle Certified Associate (OCA) programs.

This is a BC Oracle SQL training course (c) 2016

     
           

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.