Oracle Advanced SQL

PT27123
Summary
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, including through Oracle 18c.
Prerequisites
Oracle SQL or equivalent experience
Duration
2 Days/Lecture & Lab
Audience
Programmers, Analysts, Database Administrators, and Users who require advanced SQL techniques to access data in an Oracle database.
Topics
  • Next Level Multi-table Operations
  • Grouping Data
  • Analytic Functions
  • Hierarchical Queries
  • INSERT and MERGE
  • Introduction to SQL Performance
  • Flashback Query
  • Oracle 18c New Features

Related Scheduled Courses