Description
Solve real-world data problems with the SQL course. Join instructor Jess Ramos in this advanced, project-based course to practice solving real-world business problems and improve your SQL skills. Using a technology company as a case study, Jess helps you hone your skills as a SQL programmer with eleven specific, business-focused programming challenges. Practice analyzing products with CTEs, transforming data with CASE, combining multiple data sources with UNION, dealing with hierarchical data with self-joins, solving advanced problems with window functions, and other practical applications of SQL. This course includes code challenges developed by CoderPad. Code Challenges are interactive programming exercises with real-time feedback, so you can practice coding to improve your programming skills.
What you will learn in the Solve Real-World Data Problems with SQL course
- Summarizing customer data for management
- Combination of aggregate functions with CTE
- Introduction to CTEs
- Solution: Create descriptive statistics with CTE
- Solution: Explore variable distributions with CTE
- Solution: Pay funnel analysis with CTE
- Converting status codes into business sense
- Recoding and binning values with CASE
- Introduction to the case
- Solution: Create binary columns with CASE
- Solution: Create mass columns with CASE
- And…
Course details
- Editor: LinkedIn
- Teacher: Jess Ramos
- Education level: Intermediate
- Training duration: 2 hours and 8 minutes
Course headings
Course pictures
Sample video of the course
installation Guide
After extracting, you can watch it with your favorite player.
English subtitles
Quality: 720p
Download link
free download software
Size
186MB