Connect to PostgreSQL - Credentials

Connect to PostgreSQL Using SQLectron

Import Course Data Using SQLectron

FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver

Fetch A Field's Unique Values Using DISTINCT

Using DISTINCT Keyword with Multiple Columns

What is a NULL Value?

Build More Sophisticated Queries with CASE Statements

Your Knowledge So Far Under A Great Test

Introduction 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 - UPPER, LOWER & INITCAP

Character Functions - CONCAT & LENGTH

Character Functions - LPAD & RPAD

Character Functions - TRIM

Character Functions - SUBSTR

Character Functions - REPLACE

Number Functions - MOD & ROUND

Number Functions - TRUNC

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

SQL Data Types Revised

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

Drop Column

DROP Table