Introduction to Databases and SQL

SQL is the most commonly used programming language for database management. In this course, I will introduce you to the core concepts of SQL and show you how to store, query and manipulate data with SQL. You will learn how to request, edit and delete data from a relational database, how to filter, order, limit, aggregate and group your results and join multiple tables.

By the end of this course, you will have a solid understanding about the key functions of SQL and relational databases in general.

Course structure

The course is divided into 4 main sections, each focussing on a different aspect of databases and SQL. Every section consists out of a couple easy to follow videos, showing you hands–on examples of the material, and more than enough practice assignments and coding exercises. To practice with the materials, there is no installation or setup required. The course ends with an exam that allows you to test yourself on all discussed topics and see which topic you need to put some extra time in.

Topics

The following topics will be discussed:

Section 1

Relational Database

Primary Key

Foreign Key

Entity–Relationship (E/R) Diagram

Cardinality

Section 2

Creating tables (CREATE TABLE)

Inserting data (INSERT INTO, VALUES)