SQL For Beginners

Who should take the course

Introduction to SQL

Complete Cheat Sheet

Installing MySQL on Mac

Installing MySQL on Windows

Creating Databases

Creating Databases Quiz

How to Retrieve Data

SELECT clause

Exercise 1

Solution 1

Exercise 2

Solution 2

SELECT clause Quiz

Combining Multiple Conditions

Excercise 3

Solution 3

IN Operator

Exercise 4

Solution 4

IN Operator Quiz

BETWEEN Operator

Retrieving Rows That Match Pattern

Retrieving Rows That Match Pattern Quiz

Regular Expression

Get Records with Missing Values

Sorting Data in SQL

Sorting Data in SQL Quiz

Limitting Number of Returned Queries

SELECT Columns From Multiple Tables

Combine Columns From Multiple Databases

Combine Columns From Multiple Databases Quiz

Joining A Table With Itself

Joining More Than Two Tables

Combining Values to Identify Items (Compound JOIN Condition)

JOIN Quiz

Implicit Syntax

OUTER JOIN

OUTER JOIN With Multiple Tables

OUTER JOIN Quiz

Getting All The Employees And Managers

Simplifying Queries

NATURAL JOIN

NATURAL JOIN Quiz

CROSS JOIN

Combinig ROWS From Multiple Tables

INSERT, UPDATE And DELETE Data

INSERT, UPDATE And DELETE Data Quiz

Inserting Dat

Inserting Multiple Rows In One Go

INSERT Data Into Multiple Tables

INSERT Data Into Multiple Tables Quiz

Copy Data From One Table To The Other

Copy Data From One Table To The Other Cont

Updating Single Record SQL

Updating Single Record SQL Quiz

Updating Multiple Records SQL

Sub Query In SQL

How to DELETE Data

How to DELETE Data Quiz