Introduction to Relational Databases in SQL Data Camp

Overview

Context

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. 

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 this Introduction to Relational Databases in SQL course offered by Data Camp 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.

What you'll learn

• Define PostgreSQL data types, NOT NULL, and UNIQUE attribute constraints for column-level consistency enforcement
• Differentiate 1:N and N:M relationships and implement them with foreign keys and junction tables
• Evaluate and use referential integrity actions (NO ACTION, CASCADE, SET NULL, SET DEFAULT) for consistency preservation during data modifications
• Identify advantages of relational databases over flat file storage regarding redundancy reduction and data quality preservation
• Select and apply primary, surrogate, and candidate keys for unique record identification