Overview
-
Explore advanced aspects of coding using SQL in an Oracle Database 12c environment.
Syllabus
-
Introduction
- Welcome
- What you need to know?
- Exercise files
- Oracle Developer VM overview
- Open Oracle SQL Developer
- Create a database connection
- Introduction to subqueries
- Using single-value subqueries
- Using multiple-value subqueries
- Using correlated subqueries
- Using multicolumn subqueries
- Using inline views
- Introduction to indexes
- Creating indexes
- Introduction to the Oracle data dictionary
- Using the DICT view
- Querying data dictionary views
- Overview of database transactions
- Database transactions in action
- Transaction locks
- 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
- Introduction to partitioning
- Table partitioning benefits
- Table partitioning types
- Using LIST partitions
- Splitting LIST partitions
- Using RANGE partitions
- Using HASH partitions
- What's next?
