Interactive Course

Introduction to Relational Databases in SQL

Learn how to create one of the most efficient ways of storing data - relational databases!

  • 4 hours
  • 13 Videos
  • 45 Exercises
  • 20,812 Participants
  • 3,600 XP

Loved by learners at thousands of top companies:

deloitte-grey.svg
axa-grey.svg
intel-grey.svg
lego-grey.svg
dell-grey.svg
siemens-grey.svg

Course Description

You’ve already used SQL to query data from databases. But did you know that there's a lot more you can do with databases? You can model different phenomena in your data, as well as the relationships between them. This gives your data structure and consistency, which results in better data quality. In this course, you'll experience this firsthand by working with a real-life dataset that was used to investigate questionable university affiliations. Column by column, table by table, you'll get to unlock and admire the full potential of databases. You'll learn how to create tables and specify their relationships, as well as how to enforce data integrity. You'll also discover other unique features of database systems, such as constraints.

  1. Enforce data consistency with attribute constraints

    After building a simple database, it's now time to make use of the features. You'll specify data types in columns, enforce column uniqueness, and disallow NULL values in this chapter.

  2. Glue together tables with foreign keys

    In the final chapter, you'll leverage foreign keys to connect tables and establish relationships that will greatly benefit your data quality. And you'll run ad hoc analyses on your new database.

  1. 1

    Your first database

    Free

    In this chapter, you'll create your very first database with a set of simple SQL commands. Next, you'll migrate data from existing flat tables into that database. You'll also learn how meta-information about a database can be queried.

  2. Enforce data consistency with attribute constraints

    After building a simple database, it's now time to make use of the features. You'll specify data types in columns, enforce column uniqueness, and disallow NULL values in this chapter.

  3. Uniquely identify records with key constraints

    Now let’s get into the best practices of database engineering. It's time to add primary and foreign keys to the tables. These are two of the most important concepts in databases, and are the building blocks you’ll use to establish relationships between tables.

  4. Glue together tables with foreign keys

    In the final chapter, you'll leverage foreign keys to connect tables and establish relationships that will greatly benefit your data quality. And you'll run ad hoc analyses on your new database.

What do other learners have to say?

Devon

“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group

Louis

“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden

Harvard Business School

Ronbowers

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Timo Grossenbacher
Timo Grossenbacher

Data Journalist at SRF Data

Timo Grossenbacher is a data journalist working with the Swiss Public Broadcast (SRF), where he uses scripting and databases for almost every data-driven story he publishes. He also teaches data journalism at the University of Zurich and the Zurich University of the Arts, and is the creator of rddj.info – resources for doing data journalism with R. Follow him at grssnbchr on Twitter or visit his personal website.

See More
Icon Icon Icon professional info