Choosing a Relational Database

Course:
SQL

When learning SQL, you first need a database. In this video, we help you make your choice. There are many free, open-source options: MySQL, PostgreSQL, MariaDB, Sqlite, and many others. You can also choose an established commercial option like Oracle, SQL Server, or DB2. Better still, you can run the database on your own server or in the cloud!

When learning SQL, you first need a database. In this video, we help you make your choice. There are many free, open-source options: MySQL, PostgreSQL, MariaDB, Sqlite, and many others. You can also choose an established commercial option like Oracle, SQL Server, or DB2. Better still, you can run the database on your own server or in the cloud!

Lessons
Course Info
SQL - A Quick Overview
Choosing a Relational Database
PostgreSQL - Installation and Overview
SELECT Queries - Part 1
SQL Queries - Part 2
INSERT Queries
UPDATE Queries
DELETE Queries
JOINS Explained
JOINS Examples
VIEWS - Complex Queries, Cross Joins, Unions, and more
Indexes
Course Page
SQL
Course Description
In this Introduction to SQL Course, you will learn the essential queries needed to work with a relational database: How to create data (INSERT), change existing data (UPDATE), and find data (SELECT and JOINs). You will also learn how to choose a database, install PostgreSQL, speed up queries with indexes, and more.