HOT
blank

The Advanced SQL Course

Development

Rating4.6
Enroll Now

The Advanced SQL Course, available at $89.99, has an average rating of 4.55, with 138 lectures, 2 quizzes, based on 2163 reviews, and has 49238 subscribers.

You will learn about Students will master advanced SQL functions and operations Analytical (Window) Functions Regular Expressions (RegEx) Materialized Views Group By Extensions Hierarchical Queries Common Table Expressions (CTEs) Advanced Subqueries Data Cleansing Data Manipulation This course is ideal for individuals who are Students aiming to take their SQL skills to the next level and master advanced SQL functions and operations or Individuals looking to pursue a career in a data related field It is particularly useful for Students aiming to take their SQL skills to the next level and master advanced SQL functions and operations or Individuals looking to pursue a career in a data related field.

Enroll now: The Advanced SQL Course

Summary

Title: The Advanced SQL Course

Price: $89.99

Average Rating: 4.55

Number of Lectures: 138

Number of Quizzes: 2

Number of Published Lectures: 138

Number of Published Quizzes: 2

Number of Curriculum Items: 140

Number of Published Curriculum Objects: 140

Original Price: £54.99

Quality Status: approved

Status: Live

What You Will Learn

  • Students will master advanced SQL functions and operations
  • Analytical (Window) Functions
  • Regular Expressions (RegEx)
  • Materialized Views
  • Group By Extensions
  • Hierarchical Queries
  • Common Table Expressions (CTEs)
  • Advanced Subqueries
  • Data Cleansing
  • Data Manipulation

Who Should Attend

  • Students aiming to take their SQL skills to the next level and master advanced SQL functions and operations
  • Individuals looking to pursue a career in a data related field

Target Audiences

  • Students aiming to take their SQL skills to the next level and master advanced SQL functions and operations
  • Individuals looking to pursue a career in a data related field

If you have some experience with SQL and want to develop your query skills to the next level from intermediate to advanced then this is the perfect course for you!

No downloads or software installation required. 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! Although 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, so what you learn in this course can be applied across all platforms supporting SQL.

This course will cover:

  • Analytical (Window) Functions

  • Regular Expressions (RegEx)

  • Materialized Views

  • Extensions to Group By

  • Correlated Subqueries

  • Common Table Expressions

  • Hierarchical Queries

  • Data Cleansing

  • Data Manipulation

The lectures in this course are arranged into short, bite-sized chunks. 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.

As your instructor I have 10+ years of professional experience consulting and working for a range of publicly listed companies. I have worked extensively across multiple database management systems including Oracle, MySQL and Microsoft SQL Server.

I hope to see you enrolled in the course!

Course Curriculum

Chapter 1: Introduction & Course Set Up

Lecture 1: Course Overview & Prerequisite Knowledge

Lecture 2: Oracle APEX Account Set Up

Lecture 3: Oracle APEX Overview

Lecture 4: Dataset Installation (Automatic)

Lecture 5: (Optional) Manual Data Installation

Lecture 6: Dataset Overview

Lecture 7: Dual Table

Lecture 8: Understanding Explain Plans In Oracle

Chapter 2: Data Cleansing And Manipulation

Lecture 1: Section Overview

Lecture 2: Coalesce and NVL

Lecture 3: Trim and Pad

Lecture 4: Greatest and Least

Lecture 5: Pivoting Tables

Lecture 6: Unpivoting Tables

Lecture 7: Assignment Question 1

Lecture 8: Assignment Question 1 Solution

Lecture 9: Assignment Question 1 Solution (SQL Code)

Lecture 10: Assignment Question 2

Lecture 11: Assignment Question 2 Solution

Lecture 12: Assignment Question 2 Solution (SQL Code)

Chapter 3: Regular Expressions (RegEx)

Lecture 1: Section Overview

Lecture 2: Regular Expressions And Metacharacters

Lecture 3: Pattern Matching With The '.' '+' '?' '*' Metacharacters

Lecture 4: Pattern Matching With The 'd' and 'w' Metacharacters

Lecture 5: Pattern Matching With Intervals, Lists and Groups

Lecture 6: Pattern Matching Continued

Lecture 7: Introduction To RegEx Functions In Oracle

Lecture 8: REGEXP_LIKE & Assignment Questions

Lecture 9: REGEXP_INSTR & Assignment Questions

Lecture 10: REGEXP_SUBSTR & Assignment Questions

Lecture 11: REGEXP_REPLACE & Assignment Questions

Lecture 12: Class Metacharacters

Lecture 13: Concluding Thoughts On RegEx

Lecture 14: Useful External Resources

Chapter 4: Analytical (Window) Functions

Lecture 1: Section Overview

Lecture 2: Introduction to Analytical Functions

Lecture 3: An Introduction To The Over Clause

Lecture 4: The Over Clause – Partition By

Lecture 5: The Over Clause – Order By

Lecture 6: An Introduction To Window Frames

Lecture 7: Window Frame – Rows

Lecture 8: Window Frame – Range

Lecture 9: Window Frame – Default Behaviour

Lecture 10: Quick Note on Window Frames

Lecture 11: Main Types Of Window Functions

Lecture 12: Aggregate Functions – SUM, AVG, MAX, MIN and COUNT

Lecture 13: Analytical Functions – LAG, LEAD, NTILE and NTH_VALUE

Lecture 14: Ranking Functions – ROW_NUMBER, RANK and DENSE_RANK

Lecture 15: Distribution Functions – PERCENT_RANK and CUME_DIST

Lecture 16: Order of Execution

Lecture 17: Practice Scenario Walkthrough 1

Lecture 18: Practice Scenario Walkthrough 2

Lecture 19: Practice Scenario Walkthrough 3

Lecture 20: Practice Scenario Walkthrough 4

Lecture 21: Assignment Data Preparation

Lecture 22: Assignment Data Preparation (SQL Code)

Lecture 23: Assignment Question 1

Lecture 24: Assignment Question 1 Solution

Lecture 25: Assignment Question 1 Solution (SQL Code)

Lecture 26: Assignment Question 2

Lecture 27: Assignment Question 2 Solution

Lecture 28: Assignment Question 2 Solution (SQL Code)

Lecture 29: Assignment Question 3

Lecture 30: Assignment Question 3 Solution

Lecture 31: Note on Assignment Solution

Lecture 32: Assignment Question 3 Solution (SQL Code)

Lecture 33: BONUS (Running Totals): Assignment Question 4

Lecture 34: BONUS (Running Totals): Assignment Question 4 Solution (SQL Code)

Chapter 5: Group By Extensions

Lecture 1: Section Overview

Lecture 2: Introduction To Group By Extensions

Lecture 3: ROLLUP

Lecture 4: CUBE

Lecture 5: Quick Video On Why I Am Using NVL()

Lecture 6: GROUPING_ID Function

Lecture 7: Grouping Sets

Lecture 8: Combining Columns

Lecture 9: Useful External Resources

Lecture 10: Assignment Question 1

Lecture 11: Assignment Question 1 Solution

Lecture 12: Assignment Question 1 Solution (SQL Code)

Lecture 13: Assignment Question 2

Lecture 14: Assignment Question 2 Solution

Lecture 15: Assignment Question 2 Solution (SQL Code)

Lecture 16: Assignment Question 3

Lecture 17: Assignment Question 3 Solution

Lecture 18: Assignment Question 3 Solution (SQL Code)

Chapter 6: Hierarchical Queries

Lecture 1: Section Overview

Lecture 2: Introduction To Hierarchical Queries

Lecture 3: The Connect By & Start With Clauses

Lecture 4: The Level Pseudocolumn

Lecture 5: CONNECT_BY_ROOT & SYS_CONNECT_BY_PATH

Lecture 6: Ordering Your Hierarchical Query Results

Lecture 7: Formatting Your Hierarchical Query

Instructors

Rating Distribution

  • 1 stars: 11 votes
  • 2 stars: 28 votes
  • 3 stars: 163 votes
  • 4 stars: 801 votes
  • 5 stars: 1160 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024