IIRF Online > Development > Database Design & Development > Oracle SQL > Oracle SQL - The Ultimate Course: SQL Made Practical
Oracle SQL - The Ultimate Course: SQL Made Practical by Udemy
From beginner or intermediate to SQL genius: A Hands-On Oracle SQL training to Become a Professional SQL Developer.
Course Highlights
- You will be able to use Oracle SQL to retrieve, filter, analyze, format and present information from Oracle databases.
- You will be able to use SQL to insert, modify and delete information from Oracle databases.
- You will understand Oracle SQL code written by other people and feel confident to modify it.
- You will be able to write the SQL code needed to solve the most common problems found in real work situations and academic tests.
- Please note that PL/SQL is not covered in this course.
Skills you will learn!
Curriculum
5 Topics
Welcome to the Course and Curriculum Overview
Use Udemy's Features Wisely!
Let’s run some SQL code right away!
How to take Full Advantage of the Course
IMPORTANT: Practice Challenges and Coding Exercises
8 Topics
Introduction
How to take the course without installing any program
Setting Up and using Apex to take the course on the browser
Using Live SQL to take the course on the browser
Downloading and installing Oracle Database Express Edition 18c
Taking the Course on a Mac or Windows "Home" Computer
Downloading and installing Oracle Sql Developer
Oracle Sql Developer Basics
7 Topics
Introduction
Basic Database Concepts
What is SQL?
Basic Oracle Database Concepts and Architecture
The Multitenant Architecture
Basic Oracle Database Peculiarities
Section Recap (BC)
9 Topics
Introduction to retrieving information from an Oracle database.
Creating the first Test Tables
Basic Oracle Datatypes
The SELECT Statement in its Simplest Form
Practice Challenge: Basic SELECT Statement
Column and Table Aliases in Oracle
Section Quiz (RIFD)
Solution to the practice challenges in this section (RIFD)
Section Recap (RIFD)
20 Topics
Introduction to filtering and sorting results from Oracle SQL queries.
Filtering Results (Introducing the WHERE Clause)
Practice Challenge: Filtering Results
More complex WHERE Conditions
Practice Challenge: More complex WHERE Conditions
Solution to the More Complex Conditions Challenge
Filtering Duplicate Rows (DISTINCT Clause)
Ordering the Results (ORDER BY Clause) Part 1
Ordering the Results (ORDER BY Clause) Part 2
Understanding and Handling NULLs
Practice Challenge: Understanding and Handling NULLs
Understanding and Handling NULLs Part 2
NULL-handling Functions in Oracle SQL
Practice Challenge: NULL-handling Functions in Oracle SQL
NULL-handling Functions in Oracle SQL Part 2
Practice Challenge: NULL-handling Functions in Oracle SQL Part 2
Section Quiz (FSR)
Solution to the practice challenges in this section (FSR)
Section Recap (FSR)
Coding Exercise: Filtering and Sorting Results
12 Topics
Introduction to the use of Operators in Oracle SQL.
Comparison Operators (=<>ANYALL)
SQL Operators (LIKE IN BETWEEN IS NULL)
Practice Challenge: SQL Operators
Logical Operators (AND OR NOT)
Practice Challenge: Logical Operators
Substitution Variables
Practice Challenge: Substitution Variables
Section Quiz (O)
Solution to the practice challenges in this section (O)
Section Recap (O)
Coding Exercise: Operators
11 Topics
Introduction to Group Operations in Oracle SQL.
Aggregate Functions (MIN MAX SUM COUNT AVG)
Practice Challenge: Aggregate Functions
Grouping Rows (The GROUP BY Clause)
Practice Challenge: Grouping Rows
Filtering Group Results (HAVING Clause)
Practice Challenge: Filtering Group Results
Section Quiz (GO)
Solution to the practice challenges in this section (GO)
Section Recap (GO)
Coding Exercise: Group Operations
17 Topics
Introduction to Subqueries in Oracle SQL.
Understanding Subqueries
Practice Challenge: Subqueries
Common Questions About Subqueries
Inline Views
Practice Challenge: Inline Views
Subquery Factoring (The WITH Clause)
Practice Challenge: Subquery Factoring
Top-N Queries (And Intro to ANALYTIC Functions)
Practice Challenge: Top-N Queries
The Row Limiting Clause
Practice Challenge: The Row Limiting Clause
Section Quiz (S)
Solution to the practice challenges in this section (S)
Section Recap (S)
Coding Exercise: Subqueries
Coding Exercise: Subqueries Part 2
20 Topics
Introduction to Single Row Functions in Oracle SQL.
What is a Function?
Text Functions
Practice Challenge: Text Functions
Numeric Functions
Practice Challenge: Numeric Functions
Date Functions
Practice Challenge: Date Functions
Conversion Functions Part 1
Conversion Functions Part 2
Practice Challenge: Conversion Functions
Implicit Conversions Are Evil!
The DECODE Function and CASE Expressions
Practice Challenge: The DECODE Function and CASE Expressions
Date Arithmetic
Practice Challenge: Date Arithmetic
Section Quiz (F)
Solution to the practice challenges in this section (F)
Section Recap (F)
Coding Exercise: Functions and CASE Expressions
9 Topics
Introduction
Solving the Problem with the Traditional Method
Pivot
Practice Challenge: Pivot
Unpivot
Practice Challenge: Unpivot
Section Quiz (TRC)
Solution to the practice challenges in this section (TRC)
Section Recap (TRC)
26 Topics
Introduction to the Analytic Functions Section
Analytic Functions Explained
The Partition Clause
Practice Challenge: The Partition Clause
The Analytic Order By Clause
The Windowing Clause
Practice Challenge: The Windowing Clause
Solution to the Windowing Clause Practice Challenge
Analytic COUNT SUM MIN and MAX
Practice Challenge: Common Analytic Functions
Ranking Functions
Practice Challenge: Ranking Functions
The LISTAGG Function
Practice Challenge: The LISTAGG Function
The LAG and LEAD Functions
Practice Challenge: The LAG and LEAD Functions
The FIRST and LAST Functions
Practice Challenge: The FIRST and LAST Functions
The FIRST_VALUE and LAST_VALUE Functions
Practice Challenge: The FIRST_VALUE and LAST_VALUE Functions
Section Quiz (AF)
Solution to the practice challenges in this section (AF)
Section Recap (AF)
Coding Exercise: Analytic Functions Part 1
Coding Exercise: Analytic Functions Part 2
Coding Exercise: Analytic Functions Part 3
13 Topics
Introduction to Set Operators in Oracle SQL.
The UNION and UNION ALL Operators
Practice Challenge: The UNION and UNION ALL Operators
The INTERSECT Operator
Practice Challenge: The INTERSECT Operator
The MINUS Operator
Practice Challenge: The MINUS Operator
Combining Set Operators in the Same Query
Practice Challenge: Combining Set Operators in the Same Query
Section Quiz (SO)
Solution to the practice challenges in this section (SE)
Section Recap (SO)
Coding Exercise: Set Operators
13 Topics
Introduction to SQL Joins.
Practice Challenge: Introduction to SQL Joins
Table Joins Explained
A more Complex Test Schema
Practice Challenge: Querying a more Complex Test Schema
Inner Joins
Practice Challenge: Inner Joins
Other Types of Joins (Equijoins Non Equijoins Self Cross and Outer Joins)
Practice Challenge: Other Types of Joins
Outer Joins in Detail
Section Quiz (SDMT)
Solution to the practice challenges in this section (SDMT)
Section Recap (SDMT)
15 Topics
Introduction
What is a Hierarchical Query?
The Hierarchical Query Clause
Practice Challenge: The Hierarchical Query Clause
Hierarchical Pseudo-Columns
Practice Challenge: Hierarchical Pseudo-Columns
Other Hierarchical Operators and Functions
Practice Challenge: Hierarchical Operators and Functions
Understanding The Execution of Hierarchical Queries
Practice Challenge: Understanding The Execution of Hierarchical Queries
Sorting The Results of Hierarchical Queries
Practice Challenge: Sorting The Results of Hierarchical Queries
Section Quiz (HQ)
Solution to the practice challenges in this section (HQ)
Section Recap (HQ)
1 Topic
SELECT statement extended practice
14 Topics
Introduction to Data Modification
Database Transactions
The INSERT Statement
Practice Challenge: The INSERT Statement
The UPDATE Statement
Practice Challenge: The UPDATE Statement
The DELETE Statement
Practice Challenge: The DELETE Statement
The MERGE Statement (Part 1)
The MERGE Statement (Part 2)
Practice Challenge: The MERGE Statement
Section Quiz (CCDT)
Solution to the practice challenges in this section (CCDT)
Section Recap (CCDT)
19 Topics
Introduction to DDL in the Oracle database.
Creating and Dropping Tables
Practice Challenge: Creating and Dropping Tables
Changing the Definition of Tables
Practice Challenge: Changing the Definition of Tables
Adding Dropping and Disabling Constraints
Practice Challenge: Constraints
Sequences
Practice Challenge: Sequences
Indexes (Part 1)
Indexes (Part 2)
Practice Challenge: Indexes
Views (Part 1)
Practice Challenge: Views 1
Views (Part 2)
Practice Challenge: Views 2
Section Quiz (DDL)
Solution to the practice challenges in this section (DDL)
Section Recap (DDL)
13 Topics
Introduction (CUA)
User Accounts Basics
Practice Challenge: User Accounts
User Privileges Part 1
User Privileges Part 2
Practice Challenge: User Privileges
User Roles
Practice Challenge: User Roles
Related Data Dictionary Views
Synonyms
Practice Challenge: Synonyms
Solution to the practice challenges in this section (CUA)
Section Recap (CUA)
1 Topic
Solutions to the Extended Practice problems (Section 15)
2 Topics
Bonus
Conclusion
Oracle SQL - The Ultimate Course: SQL Made Practical
Related Oracle SQL Courses
Thank You!
Your review has been submitted successfully.