Oracle Database 12c: Advanced SQL
MP4 | Video: 720p | Duration: 2:36:44 | English | Subtitles: VTT | 340.4 MB

Mastering SQL is an essential skill for any Oracle professionalR12;and the first step in becoming a true Oracle expert. In this course, Oracle instructor and consultant David Yahalom covers advanced aspects of coding using SQL in an Oracle Database 12c environment. David goes over key topics that can help you develop your Oracle SQL expertise, including database concurrency; transactions; Oracle-specific schema objects such as indexes and PL/SQL procedures, functions, and packages; and table partitioning.



Topics include:



Setting up the Oracle Database 12c environment
Writing subqueries and inline views
Creating table indexes to boost query performance
Using the Oracle Data Dictionary
Database transactions
Creating sequences and triggers
Table partitioning benefits
Using LIST, RANGE, and HASH partitions