Description
SQL Hands-On Practice: Solve Business Problems. This course is designed for people with intermediate SQL knowledge who want to improve their ability to solve real-world business problems using the language. Through hands-on projects led by instructor Jess Ramos, participants will tackle a variety of challenges based on real-world scenarios from a technology company. Topics covered include analyzing product data using CTEs, manipulating values with CASE statements, merging multiple data sources with UNION, working with hierarchical data using self joins, and solving complex problems with window functions. The course also includes interactive coding challenges using the CoderPad platform, which provides hands-on practice and immediate feedback to effectively develop participants’ skills.
What you will learn:
- Analyzing products using Common Table Expressions (CTEs) in SQL
- Transforming and reshaping data using the CASE statement
- Combining multiple data sources using the UNION operator
- Working with hierarchical data using Self Joins
- Solve advanced problems using Window Functions
- Summarizing customer data for presentation to management
- Combine Aggregate functions with CTEs for more complex analyses
- Investigating the distribution of variables using CTEs
- Checkout Funnel Analysis Using CTEs
- Creating binary columns using CASE
- Creating aggregated columns using CASE
- Combining product tables using UNION
- Converting columns to rows using UNION (Unpivoting)
- Communication between users and administrators using Self Join
- Compare rows in the same table using Self Join
- Extracting the latest sales data using Window Functions
- Using the Rank(), row_number(), and dense_rank() functions
- Extracting the last sale using row_number()
- Calculating Running Totals Using Window Functions
- Calculating time differences using the LEAD() function
Who is this course suitable for?
- People who have intermediate knowledge of SQL and want to improve their practical skills in solving business problems.
- SQL programmers looking to learn more advanced SQL techniques for data analysis.
- Data analysts who want to use SQL to solve real business challenges.
- Anyone who wants to gain a deeper understanding of the practical applications of SQL in business environments.
Course details
- Publisher: LinkedIn
- Instructor: Jess Ramos
- Education level: Intermediate
- Training duration: 2 hours and 8 minutes
Course topics
SQL Hands-On Practice: Solve Business Problems Course Images
Sample course video
Installation Guide
After Extract, view with your favorite player.
Subtitles: English
Quality: 720p
Download link
File size
186 MB
