Skip to main content

Course

Introduction to SQL

Basic45 min

Learn how to create and query relational databases using SQL in just two hours.

Sql30 min - 1 hr1,500 XP1.6M+Statement of accomplishment

Create Your Free Account

Continue with Google
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Training a Team?

Try for Business

Course Description

Get an Introduction to SQL in Two Hours

Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Being able to wrangle and extract data from these databases using SQL is an essential skill within the data industry and in increasing demand.

In just two hours, you'll get to know the theory and the practice through bite-sized videos and interactive exercises where you can put your new-found skills to the test.

Learn how Relational Databases are Organized

SQL is an essential language for building and maintaining relational databases, which opens the door to a range of careers in the data industry and beyond. You’ll start this course by covering data organization, tables, and best practices for database construction.

Write Your First SQL Queries

The second half of this course looks at creating SQL queries for selecting data that you need from your database. You’ll have the chance to practice your querying skills before moving on to customizing and saving your results.

Understand the Difference Between PostgreSQL and SQL Server

PostgreSQL and SQL Server are two of the most popular SQL flavors. You’ll finish off this course by looking at the differences, benefits, and applications of each. By the end of the course, you’ll have some hands-on experience in learning SQL and the grounding to start applying it to projects or continue your learning in a more specialized direction.

Feels like what you want to learn?

Start Course for Free

What you'll learn

  • Define SQL and explain how relational databases organize and store structured data.
  • Identify tables, fields, records, and data types within a database schema.
  • Write basic SQL queries to select and retrieve data from relational tables.
  • Apply SQL clauses like SELECT, FROM, DISTINCT, and AS to customize query results.
  • Compare SQL flavors and recognize how SQL syntax varies across common database systems.

Prerequisites

There are no prerequisites for this course

Curriculum

Course outline

1

Introduction to SQL

  • Meet Databases & SQL

    You will understand what databases are, how they're structured with tables, and what SQL is used for in working with data.

  • Write Your First SQL

    You will write your first SQL queries to select, limit, sort, and find top/bottom records from database tables.

  • Complete Your SQL Foundation

    You will complete your SQL foundation by learning to handle unique values, rename columns, understand SQL flavors, and grasp how databases work in practice.

S

Introduction to SQL

Course
Complete

Earn Statement of Accomplishment

Enroll Now

Grow your data skills with DataCamp for Mobile

Make progress on the go with our mobile courses and daily 5-minute coding challenges.