Data analyst with SQL

Course Description
The role of a data scientist is to turn raw data into actionable insights. Much of the world’s raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Therefore, to be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL (pronounced ess-que-ell, or sequel). This course teaches you everything you need to know to begin working with databases today!

Intro to SQL for Data Science

This chapter provides a brief introduction to working with relational databases. You’ll learn about their structure, how to talk about them using database lingo, and how to begin an analysis by using simple SQL commands to select and summarize columns from database tables.

• Icon exercise video
  Welcome to the course!
• Icon exercise mc
  Onboarding | Tables
• Icon exercise mc
  Onboarding | Query Result
• Icon exercise interactive
  Onboarding | Errors
• Icon exercise interactive
  Onboarding | Bullet Exercises
• Icon exercise mc
  Beginning your SQL journey
• Icon exercise interactive
  SELECTing single columns
• Icon exercise interactive
  SELECTing multiple columns
• Icon exercise interactive
  SELECT DISTINCT
• Icon exercise mc
  Learning to COUNT
• Icon exercise interactive
  Practice with COUNT

Aggregate Function

This chapter builds on the first two by teaching you how to use aggregate functions to summarize your data and gain useful insights. Additionally, you’ll learn about arithmetic in SQL, and how to use aliases to make your results more readable!

• Icon exercise interactive
  Aggregate functions
• Icon exercise interactive
  Aggregate functions practice
• Icon exercise interactive
  Combining aggregate functions with WHERE
• Icon exercise mc
  A note on arithmetic
• Icon exercise interactive
  It’s AS simple AS aliasing
• Icon exercise interactive
  Even more aliasing
• HIDE CHAPTER DETAILS
  Filtering rows
  This chapter builds on the first by teaching you how to filter tables for rows satisfying some criteria of interest. You’ll learn how to use basic comparison operators, combine multiple criteria, match patterns in text, and much more.
• Icon exercise mc
  Filtering results
• Icon exercise interactive
  Simple filtering of numeric values
• Icon exercise interactive
  Simple filtering of text
• Icon exercise interactive
  WHERE AND
• Icon exercise mc
  WHERE AND OR
• Icon exercise interactive
  WHERE AND OR (2)
• Icon exercise mc
  BETWEEN
• Icon exercise interactive
  BETWEEN (2)
• Icon exercise interactive
  WHERE IN
• Icon exercise mc
  Introduction to NULL and IS NULL
• Icon exercise interactive
  NULL and IS NULL
• Icon exercise interactive
  LIKE and NOT LIKE

Sorting, grouping and joins
This chapter provides a brief introduction to sorting and grouping your results, and briefly touches on the concept of joins.

• Icon exercise mc
  ORDER BY
• Icon exercise interactive
  Sorting single columns
• Icon exercise interactive
  Sorting single columns (2)
• Icon exercise interactive
  Sorting single columns (DESC)
• Icon exercise interactive
  Sorting multiple columns
• Icon exercise mc
  GROUP BY
• Icon exercise interactive
  GROUP BY practice
• Icon exercise interactive
  GROUP BY practice (2)
• Icon exercise mc
  HAVING a great time
• Icon exercise interactive
  All together now
• Icon exercise interactive
  All together now (2)
• Icon exercise interactive
  A taste of things to come