SQL Queries - Part 2

Course:
SQL

In this tutorial, we continue to explore the SQL SELECT statement. In addition to the standard SELECT, FROM, WHERE, ORDER BY, and LIMIT statements, we will also us the SELECT DISTINCT, LIKE, and BETWEEN statements.

In this tutorial, we continue to explore the SQL SELECT statement. In addition to the standard SELECT, FROM, WHERE, ORDER BY, and LIMIT statements, we will also us the SELECT DISTINCT, LIKE, and BETWEEN statements.

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.