Skip to main content
HomeSQL

Introduction to Relational Databases in SQL

4.5+
51 reviews
Beginner

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

Start Course for Free
4 hours13 videos45 exercises151,893 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

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

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies


Course Description

Explore the Role of SQL in Relational Database Management

There are a lot of reasons why SQL is the go-to query language for relational database management. The main one is that SQL is a powerful language that can handle large amounts of data in complex ways and solve tricky analytical questions. In this course, you will gain an introduction to relational databases in SQL.

Learn how to create tables and specify their relationships, as well as how to enforce data integrity. Additionally, discover other unique features of database systems, such as constraints.

Create Your First Database

You begin the course by creating your first database with simple SQL commands. Next, you’ll learn how to update your database as the structure changes by migrating data and deleting tables.

In the final chapter, you will glue tables in foreign keys together and establish relationships that greatly benefit your data quality. Finally, you will run ad hoc analyses on your new database.

Understand the Basics of Relational Databases

By the end of the course, you will gain a basic yet essential understanding of SQL relational databases. They are widely used in various data science fields (from healthcare to finance) and have consequently become one of the crucial languages for data scientists. If you're interested in deepening your knowledge further, you may be interested in our SQL for Database Administrators, SQL Server Developer, and SQL Server for Database Administrators Tracks.
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Associate Data Engineer in SQL

Go To Track

SQL for Database Administrators

Go To Track

SQL Server Developer

Go To Track
  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.

    Play Chapter Now
    Introduction to relational databases
    50 xp
    Attributes of relational databases
    50 xp
    Query information_schema with SELECT
    100 xp
    Tables: At the core of every database
    50 xp
    CREATE your first few TABLEs
    100 xp
    ADD a COLUMN with ALTER TABLE
    100 xp
    Update your database as the structure changes
    50 xp
    RENAME and DROP COLUMNs in affiliations
    100 xp
    Migrate data with INSERT INTO SELECT DISTINCT
    100 xp
    Delete tables with DROP TABLE
    100 xp
  2. 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.

    Play Chapter Now
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

In the following Tracks

Associate Data Engineer in SQL

Go To Track

SQL for Database Administrators

Go To Track

SQL Server Developer

Go To Track

In other tracks

SQL Server for Database Administrators

collaborators

Collaborator's avatar
Sumedh Panchadhar
Collaborator's avatar
Chester Ismay
Collaborator's avatar
Mona Khalil

prerequisites

Intermediate SQL
Timo Grossenbacher HeadshotTimo Grossenbacher

Head of Newsroom Automation at Tamedia

Timo Grossenbacher is Head of Newsroom Automation at Swiss publisher Tamedia. Prior to that, he used to be a data journalist working with the Swiss Public Broadcast (SRF), where he used scripting and databases for almost every data-driven story he published. He also teaches data journalism at the University of Zurich 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

Don’t just take our word for it

*4.5
from 51 reviews
71%
20%
8%
0%
2%
  • Jean M.
    about 2 months

    A very good course

  • Ana U.
    2 months

    Excellent course! The material I learned here is very useful. It's important to have this foundation to work with data stored in many tables. I appreciate the courses and the sequential steps to build up a strong knowledge on database management systems.

  • Ileana R.
    3 months

    I think the format of the course is absolutely fantastic! I thoroughly enjoyed doing every single exercise!

  • Mamoon R.
    4 months

    Excellent

  • Taha O.
    8 months

    The course was very rich in terms of data literacy and tables constraints specifically the attributes constraints and referential integrity, I really enjoyed all the topics and I feel empowered and confident and equipped as well with the necessary knowledge to enforce data quality ,integrity and consistency, Tim the instructor facilitated the topics clearly and in good manner.

"A very good course"

Jean M.

"Excellent course! The material I learned here is very useful. It's important to have this foundation to work with data stored in many tables. I appreciate the courses and the sequential steps to build up a strong knowledge on database management systems."

Ana U.

"I think the format of the course is absolutely fantastic! I thoroughly enjoyed doing every single exercise!"

Ileana R.

FAQs

Join over 15 million learners and start Introduction to Relational Databases in SQL today!

Create Your Free Account

GoogleLinkedInFacebook

or

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