The Advanced SQL Course
4.8 /5- Offered byUDEMY
The Advanced SQL Course at UDEMY Overview
Duration | 6 hours |
Total fee | ₹3,499 |
Mode of learning | Online |
Difficulty level | Advanced |
Credential | Certificate |
The Advanced SQL Course at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Learn from 51 downloadable resources and 45 articles
- Comes with 30 days money back guarantee and full lifetime access
The Advanced SQL Course at UDEMY Course details
- For Students aiming to take their SQL skills to the next level
- For Individuals looking to pursue a career in a data related field
- Analytical (Window) Functions
- Regular Expressions (RegEx)
- Materialized Views
- Extensions to Group By
- Correlated Subqueries
- Common Table Expressions
- Hierarchical Queries
- Data Cleansing
- Data Manipulation
- We will be using Oracle APEX which is a web-based application -you will be set up with your own virtual database hosted on the cloud
- We will be using Oracle APEX the course has been designed to highlight key differences between some of the main Database Management Systems such as MySQL and Microsoft SQL Server
- The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible
- Each section of the course has been specifically tailored to give the optimal learning experience, sections are packed with quizzes, assignments and real world type scenarios to give you an opportunity to develop your practical skills
The Advanced SQL Course at UDEMY Curriculum
Introduction & Course setup
Oracle APEX Account Set Up
Oracle APEX Overview
Dataset Installation (Automatic)
(Optional) Manual Data Installation
Dataset Overview
Dual Table
Understanding Explain Plans In Oracle
Data cleansing and manipulation
Coalesce and NVL
Trim and Pad
Greatest and Least
Unpivoting Tables
Regular Expressions (RegEx)
Regular Expressions And Metacharacters
Pattern Matching With The '.' '+' '?' '*' Metacharacters
Pattern Matching With The '\d' and '\w' Metacharacters
Pattern Matching With Intervals, Lists and Groups
Pattern Matching Continued
Introduction To RegEx Functions In Oracle
Class Metacharacters
Concluding Thoughts On RegEx
Analytical (window) functions
An Introduction To The Over Clause
The Over Clause - Partition By
The Over Clause - Order By
An Introduction To Window Frames
Window Frame - Rows
Window Frame - Range
Window Frame - Default Behaviour
Quick Note on Window Frames
Group by Extension
Introduction To Group By Extensions
ROLLUP
CUBE
Quick Video On Why I Am Using NVL()
GROUPING_ID Function
Grouping Sets
Combining Columns
Hierarchical Queries
Introduction To Hierarchical Queries
The Connect By & Start With Clauses
The Level Pseudocolumn
Ordering Your Hierarchical Query Results
Formatting Your Hierarchical Query
Filtering Your Results
Correlated Subqueries and common table expressions
Recap On Subqueries
Correlated Subqueries, Where Exists And Where Not Exists
Common Table Expressions (CTEs)
Recursive CTEs
Materialized views
Quick Recap On Views
What Are Materialized Views?
Syntax
Simple And Complex Materialized Views
Refresh Types
On Commit / On Demand
Manually Refreshing Your Materialized View
The Advanced SQL Course at UDEMY Faculty details
The Advanced SQL Course at UDEMY Entry Requirements
- Prerequisite: Basic level experience of SQL such as performing SQL SELECT Commands, using the Where clause, Group By clause and performing table joins
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?