Description
Solve Real-World Data Problems with SQL course. Join instructor Jess Ramos in this intermediate, project-based course to practice solving real business problems and improve your SQL skills. Using a technology company as a case study, Jess helps you hone your skills as an 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 uses of SQL. This course includes code challenges designed by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can practice coding to advance your coding skills.
What you will learn in the Solve Real-World Data Problems with SQL course
- Summarizing customer data for leadership
- Combining aggregate functions with CTE
- Introduction to CTEs
- Solution: Draw descriptive statistics with CTE
- Solution: Explore variable distributions with CTE
- Solution: Pay Funnel Analysis with CTE
- Translating status codes into business acumen
- Recoding and binning values using CASE
- Introduction to CASE
- Solution: Create binary columns with CASE
- Solution: Create bulk columns with CASE
- And…
Course details
- Publisher: Linkedin
- teacher: Jess Ramos
- Education level: Intermediate
- Training duration: 2 hours and 8 minutes
Course headings
Course images
Sample video of the course
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
186 MB
Be the first to comment