On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:


Search for Course:

OR5451 Oracle Advanced SQL
 
 
Duration 2 Days
Delivery Method Instructor Led, Hands-on Workshops
Public Price $1125.00


DESCRIPTION (Return to Top)

This course is intended to provide experienced Oracle developers with the advanced SQL skills needed to effectively design and code complex queries and applications required to solve enterprise business problems. Coding examples and workshops serve to reinforce the material presented in class.

This course can be taught for any Oracle version.



AUDIENCE (Return to Top)

Programmers, Analysts, Database Administrators, and Users who require advanced SQL techniques to access data in an Oracle database.



TOPICS (Return to Top)
  • Next Level Multi-table Operations
  • Grouping Data
  • Analytic Functions
  • Hierarchical Queries
  • INSERT and MERGE
  • Introduction to SQL Performance
  • Flashback Query


PREREQUISITES (Return to Top)

OR5450 Oracle SQL or equivalent experience.