Introduction to Relational Databases in SQL

Offered byDataCamp

Introduction to Relational Databases in SQL
at
DataCamp
Overview

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

Duration	4 hours
Mode of learning	Online
Difficulty level	Beginner
Official Website	Go to Website
Credential	Certificate

Introduction to Relational Databases in SQL
at
DataCamp
Highlights

Earn a certificate after completion of the course
Learn from the industry best faculty

Introduction to Relational Databases in SQL
at
DataCamp
Course details

Who should do this course?

Aspiring Data Analysts and Scientists

Database Administrators

Business Analysts

Software Developers

What are the course deliverables?

Understand the fundamental concepts of relational databases and their architecture

Be able to design and create relational databases with properly defined tables and relationships

Write and execute basic to intermediate SQL queries

Perform data manipulation tasks such as inserting, updating, and deleting records

Utilize advanced querying techniques to combine and aggregate data

Apply practical skills to real-world database management scenarios

More about this course

This course is a foundational course designed to provide participants with a comprehensive understanding of relational databases and the SQL (Structured Query Language) used to manage and manipulate them

Participants will learn how to design relational databases by creating tables and defining relationships between them

The course will also cover basic SQL operations, including SELECT, INSERT, UPDATE, and DELETE statements, as well as more advanced topics like JOIN operations and data normalization

Introduction to Relational Databases in SQL
at
DataCamp
Curriculum

Introduction to relational databases

Attributes of relational databases

Query information_schema with SELECT

Tables: At the core of every database

CREATE your first few TABLEs

Better data quality with constraints

Types of database constraints

Conforming with data types

Type CASTs

Working with data types

Change types with ALTER COLUMN

Convert types USING a function

Keys and superkeys

Get to know SELECT COUNT DISTINCT

Identify keys with SELECT COUNT DISTINCT

Primary keys

Identify the primary key

ADD key CONSTRAINTs to the tables

REFERENCE a table with a FOREIGN KEY

Explore foreign key constraints

JOIN tables linked by a foreign key

Model more complex relationships

Introduction to Relational Databases in SQL
at
DataCamp
Faculty details

Timo Grossenbacher

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.