The Advanced SQL Course 2021

如果您对 SQL 有一定的经验，并希望将您的查询技能从中级到高级提升到一个新的水平，那么这门课程非常适合您！

无需下载或安装软件。我们将使用 Oracle APEX，这是一个基于 Web 的应用程序——您将使用托管在云上的自己的虚拟数据库进行设置！虽然我们将使用 Oracle APEX，但本课程旨在强调一些主要数据库管理系统（如 MySQL 和 Microsoft SQL Server）之间的主要差异，因此您在本课程中学到的知识可以应用于所有支持 SQL 的平台。

本课程中的讲座被安排成简短的、一口大小的块。该课程旨在全面而简洁，以使学习体验尽可能简单。课程的每个部分都经过专门定制，以提供最佳的学习体验，各部分都包含测验、作业和现实世界类型的场景，让您有机会发展您的实践技能。

作为您的导师，我拥有 10 多年的专业咨询经验，并为一系列上市公司工作。我曾在多个数据库管理系统（包括 Oracle、MySQL 和 Microsoft SQL Server）上进行过广泛的工作。

Genre: eLearning | MP4 | Video: h264, 1280×720 | Audio: AAC, 48.0 KHz
Language: English | Size: 2.80 GB | Duration: 6h 18m
Level up your SQL query skills and go from intermediate to advanced level

What you’ll 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

Description
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!

Who this course is for:
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