Skip to main content

Video: Answering Real-World Questions with SQL Queries

In this video tutorial, you'll break down real-world questions to construct complex queries using CASE statements, subqueries, and common table expressions.
Apr 2019  · 1 min read

If you would like to learn more about using SQL to analyze data, take Mona Khalil's Intermediate SQL course.

Working directly in a SQL database allows you to spend less time in Spreadsheets. The ability to summarize, pivot, and transform your data can potentially save you hours of time and dozens of errors each week!

In this video, Mona Khalil, a Curriculum Lead at DataCamp, will show you the steps necessary to examine the contents of a database, make sense of the information in the database, and break down real-world questions into the steps necessary to construct complex queries using CASE statements, subqueries, and common table expressions.

Kaggle Dataset Link: https://www.kaggle.com/benhamner/sf-bay-area-bike-share

Intermediate SQL Queries

Beginner
4 hours
1,485,245
Master the basics of querying tables in relational databases such as MySQL, SQL Server, and PostgreSQL.
See DetailsRight Arrow
Start Course

SQL for Joining Data

Beginner
5 hours
353,518
Join two or three tables together into one, combine tables using set theory, and work with subqueries in PostgreSQL.

Intermediate SQL Server

Beginner
4 hours
46,030
In this course, you will use T-SQL, the flavor of SQL used in Microsoft's SQL Server for data analysis.
See all coursesRight Arrow
Related
Data Science Concept Vector Image

How to Become a Data Scientist in 8 Steps

Find out everything you need to know about becoming a data scientist, and find out whether it’s the right career for you!
Jose Jorge Rodriguez Salgado's photo

Jose Jorge Rodriguez Salgado

12 min

What is SQL Used For? 7 Top SQL Uses

Discover the uses of SQL in industries and specific jobs. Plus, learn why the SQL language is so versatile and in demand.
Natassha Selvaraj's photo

Natassha Selvaraj

11 min

DC Data in Soccer Infographic.png

How Data Science is Changing Soccer

With the Fifa 2022 World Cup upon us, learn about the most widely used data science use-cases in soccer.
Richie Cotton's photo

Richie Cotton

SQL Window Functions Cheat Sheet

With this SQL Window Functions cheat sheet, you'll have a handy reference guide to the various types of window functions in SQL.
DataCamp Team's photo

DataCamp Team

10 min

COALESCE SQL Function

COALESCE() is one of the handiest functions in SQL. Read this tutorial to learn how to master it.
Travis Tang 's photo

Travis Tang

FORMAT() SQL FUNCTION

FORMAT() is one of the most commonly used functions in SQL. Learn its main applications in this tutorial.
Travis Tang 's photo

Travis Tang

See MoreSee More