Check Imported Data

SQL Data Types

Finally Some Fun! Extracting Data Based on Requirements

Filter Data by Range Using BETWEEN

Filter Data by Set of Values Using IN

Filter Data by Date

More Filtering by Date

Another Query Filtering by Date

Filter Data by Strings (Names, Addresses, ...)

More Filtering by Strings

More Filtering by Strings 2

More Filtering by Strings 3

How to Ignore Caps when Filtering by String

AND Operator

OR Operator

NOT Operator

Basic Math Operations

Modulo Operator

It's Payday! Calculate The Net Salary for Employees

Filter Data with Math Equations

Concatenate Strings with '||' Operator

Concatenate Strings with Numbers

A Report for Payroll

Order Records by Column

Order Records by Multiple Columns

How Alias Names Cannot Be Used with WHERE

LIMIT Record Count Fetched by Your Query

Fetch A Field's Unique Values Using DISTINCT

Using DISTINCT Keyword with Multiple Columns

What is a NULL Value Anyway?

Build More Sophisticated Queries with CASE Statements

Your Knowledge So Far Under A Great Test

Let Me Introduce You to Functions

SUM Function

AVG (Average) Function

COUNT Function

MIN & MAX Functions

How To Count Your Field's Unique Values

GROUP BY Clause: Use Functions with Dimensions

GROUP BY More Than One Dimension

Now For Some Tough Workout

Filter By Aggregate Functions with HAVING Clause

Character Functions - CONCAT & LENGTH

Character Functions - LPAD & RPAD

Character Functions - TRIM

Character Functions - REPLACE

Character Functions - SUBSTR

Number Functions - MOD & ROUND

Number Functions - TRUNC

Selectception: A Select Query Inside Another Select Query!

Cast Date to Character

Cast Number to Character

Cast Timestamp to Character

Cast Character to Number

Cast Character to Date & Timestamp

UNION

UNION ALL

Important Note about Combining Queries

INTERSECT

EXCEPT

Employees & Departments Tables Revised

Entity Relationship Diagram (ERD)

Cartesian Join

Table Aliases with Joins

Why I Don't Recommend Cartesian Joins

Inner Join

Outer Join - Right, Left & Full

INSERT a New Record to a Table

Insert Without Specifying Column Names

UPDATE a Record's Field Values

CAUTION! How an UPDATE Query Can Go Wrong

Update a Record Using Single-Row Functions

A Good Exercise: Extract Employee's Email Address

Solution: Extract Employee's Email Address

DELETE a Table's Record

Insert Records with Nested Select Queries

Bookstore Data Set: Let's Move It to Database

Create Your First Table!

Insert Data to Your New Table

Change Column Data Type

Rename Column

Add a New Column to Table

Primary Keys

NOT NULL Constraint

UNIQUE Constraint

DEFAULT Constraint

Foreign Keys

Use Foreign Keys with Joins - Books & Publishers

Foreign Keys - Properties

Drop Column

DROP Table

Create a New Table with Select Statement

A Trick to Create an Empty Table with Select Statement

Insert New Records Using Select Statement

Views

Schemas

Create & Use Schemas

Introduction to Access Control

Create User

Grant SELECT to User

Grant Insert & Update to User

Revoke Privilege from User

User Groups