Courses

Introduction to SQL

course

Introduction to SQL

Data is powerful, but only if you know how to use it. That’s where SQL comes in! In this course, you’ll learn how to use the SQL standardized database language to access and manipulate data stored in databases. Once you know how to use SQL, you’ll be able to join top companies (and even governments!) that use data to make predictions and decisions about everything from what products to develop to how democracy should function. You don’t need any previous coding experience for this course, so dive right in!

Angular hero

What you'll learn

Database structures
Before you learn more about SQL we’ll help you understand how data is stored in a database.
SQL queries
Select, sort and identify data from a database using SQL queries.
Where command and logical conditions
Use where command and logical conditions to filter data.
Aggregation functions
Group data with aggregation functions.
Tables
Create tables by adding, updating and removing data.
illustration
Introduction to SQL
Introduction to SQL
Data is powerful, but only if you know how to use it. That’s where SQL comes in! In this course, you’ll learn how to use the SQL standardized database language to access and manipulate data stored in databases. Once you know how to use SQL, you’ll be able to join top companies (and even governments!) who use data to make predictions and decisions about everything from what products to develop to how democracy should function. You don’t need any previous coding experience for this course, so dive right in!

Getting Started with SQL

widgetImg
Lesson
Working with Data
widgetImg
Lesson
Running SQL Queries
widgetImg
Lesson
Relational Databases
widgetImg
Lesson
Debugging
widgetImg
Practice
Box Office
widgetImg
Practice
Store Inventory
widgetImg
Quiz
Module 1 Quiz

Going Deeper with SQL

widgetImg
Lesson
Standards & Best Practices
widgetImg
Lesson
Sorting Data
widgetImg
Practice
Employee Salary
widgetImg
Practice
Student Grade
widgetImg
Lesson
Limiting Data
widgetImg
Practice
Menu
widgetImg
Practice
Giveaway!
widgetImg
Lesson
Data Types
widgetImg
Practice
Tennis Tournament
widgetImg
Lesson
Filtering Data
widgetImg
Practice
Online Bookstore
widgetImg
Practice
Movie Ratings
widgetImg
Quiz
Module 2 Quiz

Query Techniques

widgetImg
Lesson
Pattern Matching
widgetImg
Practice
Chocolate!
widgetImg
Lesson
Advanced Pattern Matching
widgetImg
Practice
Music and Love!
widgetImg
Lesson
SQL Conditions
widgetImg
Practice
Select your Car
widgetImg
Practice
Grocery Store
widgetImg
Lesson
Data Aggregation
widgetImg
Lesson
Mixing Things Up
widgetImg
Quiz
Module 3 Quiz

Data Analysis

widgetImg
Lesson
Analyzing Data
widgetImg
Lesson
Grouping
widgetImg
Practice
Social Media Posts
widgetImg
Lesson
Grouping and Filtering
widgetImg
Practice
Sports League
widgetImg
Lesson
Cleaning Data
widgetImg
Practice
Teacher Data
widgetImg
Lesson
Fixing Data Types
widgetImg
Lesson
Making Sense of Data
widgetImg
Practice
Theater Management
widgetImg
Quiz
Module 4 Quiz
certificate

Your Certificate is close

You are doing great! Keep learning to unlock your certificate!

Blog

blog
How Marketers Use SQL
By using SQL to analyze your databases and follow a data-driven marketing strategy, you can be much more effective at organizing, analyzing, and applying data to your marketing campaigns.
Continue reading on our blog
blog
CHEAT SHEET: What Is A SQL Injection?
One of the most common web hacking techniques, an SQL injection is a method for attacking and manipulating underlying databases. From providing access to protected data, to gaining access to manipulate the database of the targeted application, this tool is a common threat for most website and application managers. Our guide walks you through this widespread threat so you can protect your own applications from it.
Continue reading on our blog
blog
What Is SQL Used For?
SQL is the commonly used acronym for Structured Query Language, the standard language for relational database management systems. SQL traces its origins all the way back to 1973, when it was initially created by a team at IBM to manipulate and retrieve the data stored in their system at the time.
Continue reading on our blog