Search courses 👉
Professional Training

Introduction to Relational Databases in SQL

DataCamp, Online
Length
4 hours
Next course start
Start Anytime! See details
Course delivery
Self-Paced Online
Length
4 hours
Next course start
Start Anytime! See details
Course delivery
Self-Paced Online
Visit this course's homepage on the provider's site to learn more or book!

Course description

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

Upcoming start dates

1 start date available

Start Anytime!

  • Self-Paced Online
  • Online
  • English

Training Course Content

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.

Why choose DataCamp

More than 14 Million learners worldwide

80% of the Fortune 1000 use DataCamp

DataCamp
Data Science Central UK Limited, 25 Luke Street
EC2A 4EE London

DataCamp

DataCamp offers a comprehensive platform for learning data skills, specializing in training individuals and teams in data science, analytics, and AI. With a focus on interactive, hands-on learning, DataCamp provides courses across key programming languages such as Python, R, SQL,...

Read more and show all courses with this provider

Ads