When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Development
SkillShare logo

SQL for Solving Problems

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
SQL for Solving Problems

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon1 hours 3 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About SQL for Solving Problems

Introduction

Defining our Schema

SELECT: The only query you need

Blueprint to Solving Problems

Problem 1 (Hint: SELECT)

Problem 2 (Hint: WHERE)

Problem 3 (Hint: JOIN)

Problem 4 (Hint: SUM, Common Table Expression)

Problem 5 (Hint: SUM, CTE, GROUP BY)

Problem 6 (Hint: GROUP BY, SUM)

Problem 7 (Hint: EXTRACT, COUNT, ORDER BY)

Problem 8 (Hint: SUM, JOIN, ORDER BY)

Problem 9 (Hint: Reuse CTE)

Problem 10 (Hint: CASE..WHEN)

Problem 11 (Hint: ROW_NUMBER)

Conclusion

What You Will Learn?

  • This course takes a problem centric approach to teaching SQL..