Download LinkedIn – Top Five Things to Know in Advanced SQL 2023-8

Description

Top Five Things to Know in 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 a review of basic SQL concepts and then gradually enters more advanced topics. During the course, practical exercises are included to better understand these concepts and their application in solving real business problems. By completing this course, students will be able to:

• Understand the uses and limitations of various advanced functions in SQL
• 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, practical exercises, course tests and practice files on the GitHub platform. Note that some sections are locked and you need to purchase a course to access them.

What you will learn:

• Understanding the concept of subquery in SQL
• Getting to know how to write Scalar Subqueries and Multiple-Row Subqueries
• Distinguishing between Correlated Subqueries and Uncorrelated Subqueries
• Practice and learn to make subsets to solve problems
• Familiarity with common table expressions (CTE) and how to write them
• Understanding the concept of recursive CTEs
• Compare and differentiate between CTE and subcategory
• Practice and learn to construct CTE to solve problems
• Familiarity with window functions and their use
• Understanding the concept and how to use the ROW_NUMBER() function
• Practice and learn row calculation using ROW_NUMBER()
• Familiarity with LAG() and LEAD() functions and their use
• Practice and learn to use LAG() and LEAD() functions to solve problems (such as determining the last order value)
• Familiarity with window functions for ranking (Ranking Window Functions)
• Understanding the difference between the RANK() and DENSE_RANK() functions
• Practice and learn to use RANK() and DENSE_RANK() functions to rank data

This course is suitable for people who:

• They have basic knowledge of basic SQL commands.
• Looking to improve their skills in data analysis using SQL.
• Interested in solving real business problems using SQL.

Details of the Top Five Things to Know in Advanced SQL course

• Publisher: LinkedIn
• teacher: Kendall Ruber
• Education level: Intermediate
• Training duration: 1 hour and 35 minutes

Course headings

Course images

Sample video of the course

download link

Download file – 191 MB

File(s) password: www.downloadly.ir

Size

191 MB