Why Learn SQL?

Description

Why Learn SQL?

We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.

Take-Away Skills:

In this course, you’ll learn how to communicate with relational databases through SQL. You’ll learn—and practice hands on—how to manipulate data and build queries that communicate with more than one table.

• Beginners curious about SQL
• Data analysts, Data Scientists or Data Engineers that want to learn more about SQL
• Those looking to make a move to data science or data engineering

Course content

• Introduction To SQL
  • Introduction To SQL
  • Setting Up SQL Fiddle
  • Quiz
• Basic Queries
  • Basic Queries
  • Hands On: Selecting Filtering and Ordering Data
  • Quiz
• Aggregate Queries
  • Aggregates Queries
  • Hands On: Grouping, Aggregating and Using Having
  • Quiz
• Connecting Tables using Joins
  • Intro to Joins
  • Hands On: Joins
  • Quiz
• Additional SQL Operators
  • Additional SQL Operators
  • Hands On: Case Statements, Like and Limits
  • Quiz
• SQL Challenges
  • Challenge 1
  • Challenge 2
  • Challenge 3