Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Oracle Database 12c: Advanced SQL

via LinkedIn Learning

Overview

Explore advanced aspects of coding using SQL in an Oracle Database 12c environment.

Mastering SQL is an essential skill for any Oracle professional—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.

Syllabus

Introduction
  • Welcome
  • What you need to know?
  • Exercise files
1. Setting Up the Environment
  • Oracle Developer VM overview
  • Open Oracle SQL Developer
  • Create a database connection
2. Subqueries
  • Introduction to subqueries
  • Using single-value subqueries
  • Using multiple-value subqueries
  • Using correlated subqueries
  • Using multicolumn subqueries
  • Using inline views
3. Indexes
  • Introduction to indexes
  • Creating indexes
4. The Oracle Data Dictionary
  • Introduction to the Oracle data dictionary
  • Using the DICT view
  • Querying data dictionary views
5. Database Concurrency
  • Overview of database transactions
  • Database transactions in action
  • Transaction locks
6. Advanced Oracle Schema Objects
  • Introduction to sequences
  • Creating sequences
  • Using identity columns
  • Introduction to table triggers
  • Creating triggers
  • Introduction to PL/SQL procedures
  • Introduction to PL/SQL functions
  • Introduction to PL/SQL packages
  • Creating PL/SQL procedures and functions
  • Creating synonyms
  • Creating simple views
  • Creating complex views
7. Table Partitioning
  • Introduction to partitioning
  • Table partitioning benefits
  • Table partitioning types
  • Using LIST partitions
  • Splitting LIST partitions
  • Using RANGE partitions
  • Using HASH partitions
Conclusion
  • What's next?

Taught by

David Yahalom

Related Courses

Reviews

Start your review of Oracle Database 12c: Advanced SQL

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free