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
- 6,183 Participants
- 3,600 XP
Create Your Free Account
By continuing you accept the Terms of Use and Privacy Policy, that your data will be stored outside of the EU, and that you are 16 years or older.
Loved by learners at thousands of top companies:
Course Description
You have already used SQL for querying data from databases. But did you actually know that there's a whole lot more you can do with databases? You can model different phenomena in your data – and relationships between them. This gives your data structure as well as consistency, which results in better data quality. In this course, you'll experience this firsthand by working with a real-life data set that was used to investigate questionable affiliations of universities. Column by column, table by table, you'll get to unlock and admire the full potential of databases. In between, you'll learn how to create tables and specify their relationships as well as how to enforce data integrity. Also, you'll discover other unique features of database systems, such as constraints.
-
1
Your first database
FreeFrom 0 to 100 in 10 seconds! In this chapter, you'll create your very first database with a set of simple SQL commands. After that, you'll migrate data from existing flat tables into that database. At the same time, you'll learn how meta information about a database can be queried.
-
Uniquely identify records with key constraints
Now we're getting into database engineering at its best. It's time to add so-called primary and foreign keys to the tables. They are one of the most important concepts in databases – and will be the building blocks of relationships between tables.
-
Enforce data consistency with attribute constraints
After having built a simple database, it's time to make use of the first cool features. You'll specify data types on columns, enforce column uniqueness, and disallow "NULL" values in this chapter.
-
Glue together tables with foreign keys
In the last part of this course, you'll leverage foreign keys to connect tables to each other – and establish relationships that will greatly benefit your data quality. Lastly, you'll finally run some ad-hoc analyses on your newborn database.
-
1
Your first database
FreeFrom 0 to 100 in 10 seconds! In this chapter, you'll create your very first database with a set of simple SQL commands. After that, you'll migrate data from existing flat tables into that database. At the same time, you'll learn how meta information about a database can be queried.
-
Enforce data consistency with attribute constraints
After having built a simple database, it's time to make use of the first cool features. You'll specify data types on columns, enforce column uniqueness, and disallow "NULL" values in this chapter.
-
Uniquely identify records with key constraints
Now we're getting into database engineering at its best. It's time to add so-called primary and foreign keys to the tables. They are one of the most important concepts in databases – and will be the building blocks of relationships between tables.
-
Glue together tables with foreign keys
In the last part of this course, you'll leverage foreign keys to connect tables to each other – and establish relationships that will greatly benefit your data quality. Lastly, you'll finally run some ad-hoc analyses on your newborn database.
What do other learners have to say?
“I've used other sites, but DataCamp's been the one that I've stuck with.”
Devon Edwards Joseph
Lloyd's Banking Group
“DataCamp is the top resource I recommend for learning data science.”
Louis Maiden
Harvard Business School
“DataCamp is by far my favorite website to learn from.”
Ronald Bowers
Decision Science Analytics @ USAA
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 MoreCollaborators
-
Mona Khalil
-
Chester Ismay
-
Sumedh Panchadhar