Oracle Database 12c: Advanced SQL

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

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?