Oracle Database 12c: Advanced SQL

Offered By: LinkedIn Learning

Tags

SQL Courses PL/SQL Courses Stored Procedures Courses Subqueries Courses

Course Description

Overview

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

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

Introduction to Databases
Meta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX