Description
The top five things you need to know in the Advanced SQL course. This course is presented by Kendall Ruber and is designed to improve your knowledge of advanced SQL commands. The course begins with an overview of basic SQL concepts and then progresses to more advanced topics. The course includes hands-on exercises to better understand these concepts and how they apply to real-world business problems. After completing this course, students will be able to:
- Understand the uses and limitations of various advanced SQL functions.
- Appropriate application of these functions to solve business problems.
The main topics of the course are:
- Subqueries
- Common Table Expressions (CTE)
- Window functions
This course includes various sections including training videos, practice exercises, course tests, and training files on the GitHub platform. Please note that some sections are locked and require a course purchase to access them.
What you will learn:
- Understanding the concept of a subquery in SQL
- Introduction to writing scalar and multi-row subqueries.
- Difference between correlated and uncorrelated subqueries
- Practice and learn how to create subsets to solve problems.
- Knowledge of common table expressions (CTE) and how to write them.
- Understanding the concept of recursive CTEs
- Compare and differentiate CTE and subcategory
- Practice and learn to build CTE to solve problems.
- Knowledge of window functions and their use.
- Understand the concept and usage of the ROW_NUMBER() function.
- Practice and learn how to calculate rows using ROW_NUMBER().
- Introduction to the LAG() and LEAD() functions and their uses.
- Practice and learn how to use the LAG() and LEAD() functions to solve problems (such as determining the cost of a recent order).
- Introduction to Ranking Window Functions
- Understanding the difference between the RANK() and DENSE_RANK() functions
- Practice and learn how to use the RANK() and DENSE_RANK() functions to rank data.
This course is suitable for people who:
- They have basic knowledge of basic SQL commands.
- I would like to improve my data analysis skills using SQL.
- I am interested in solving real business problems using SQL.
Details on the Top 5 Things You Need to Know in the Advanced SQL Course
- Publisher: LinkedIn
- Instructor: Kendall Ruber
- Education level: Intermediate
- Duration of training: 1 hour 35 minutes.
Course headings
course images
Example video course
installation instructions
Once extracted, watch using your favorite player.
English subtitles
Quality: 720p
Download link
Password for file(s): www.downloadly.ir
size
191 MB