Intermediate SQL

Updated on

Course overview

Provider
Datacamp
Course type
Free trial availiable
Deadline
Flexible
Duration
4 hours
Certificate
Available on completion
Course author
Mona Khalil

Description

Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.
So you've learned how to aggregate and join data from tables in your database—now what? How do you manipulate, transform, and make the most sense of your data? This intermediate-level course will teach you several key functions necessary to wrangle, filter, and categorize information in a relational database, expand your SQL toolkit, and answer complex questions. You will learn the robust use of CASE statements, subqueries, and window functions—all while discovering some interesting facts about soccer using the European Soccer Database.

Similar courses

Datacamp
  • Flexible deadline
  • 4 hours
  • Certificate
Datacamp
  • Flexible deadline
  • 4 hours
  • Certificate
Datacamp
  • Flexible deadline
  • 4 hours
  • Certificate
  • English language

  • Recommended provider

  • Certificate available