Oracle SQL From Beginner to Pro

Description

In this course, you will :

• Teach you everything you need to know about Oracle SQL programming.
• The course begins with a section on relational database theory, then moves on to cover the data definition and manipulation components of SQL, before diving deep into queries.
• Covers user-defined objects, collections, XML, large objects, and performance.
• This course is highly recommended for anyone who wants to advance their career by adding Oracle SQL programming to their technical toolbox, as well as those who want to get certified by Oracle.

Syllabus :

1. Relational Database Theory

• Relational Database Terminology
• Interview the Data Preview
• Normalization
• ER Diagrams Preview

 

2. Schema Creation

• Schema Creation
• Schema Modification

 

3. Data Manipulation Language

• Data Manipulation Language

 

4. Queries

• Single Table Selects
• Multi-table Queries
• Subqueries
• Set Operators Translate and Replace
• Advanced Queries

 

5. PL/SQL

• PL/SQL Procedures
• PL/SQL Functions
• PL/SQL Triggers and Packages

 

6. Less Frequently Used Oracle Constructs

• User-Defined Types
• Collections
• LOBs
• XML
• Performance

Show more