Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Introduction to SQL

via DataCamp

Overview

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

Much of the world's raw data—from electronic medical records to customer transactions—is stored in relational databases, and the ability to manipulate and retrieve this data is an increasingly sought-after skill.

In this two-hour introduction to SQL, you'll learn the theory and practice of extracting and organizing data. You'll cover database best practices, SQL queries, and popular SQL variants like PostgreSQL and SQL Server. By the end of the course, you’ll have hands-on experience in SQL and the grounding to start applying it to your projects.

Syllabus

  • Relational Databases
    • Before writing any SQL queries, it’s important to understand the underlying data. In this chapter, we’ll discover the role of SQL in creating and querying relational databases. Using a database for a local library, we will explore database and table organization, data types and storage, and best practices for database construction.
  • Querying
    • Learn your first SQL keywords for selecting relevant data from database tables! After practicing querying skills in a database of books, you’ll customize query results using aliasing and save them as views so they can be shared. Finally, you’ll explore the differences between SQL flavors and databases such as PostgreSQL and SQL Server.

Taught by

Izzy Weber

Reviews

4.8 rating at DataCamp based on 1446 ratings

Start your review of Introduction to SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.