Install SQLectron

Connect to PostgreSQL - Credentials

Connect to PostgreSQL Using SQLectron

Import Course Data Using SQLectron

FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver

Selectception: A Select Query Inside Another Select Query!

Auto Data Conversion in SQL

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

In-Depth Look into Join Types in SQL

Outer Join - Right, Left & Full

Constraints in SQL

Primary Keys

NOT NULL Constraint

UNIQUE Constraint

DEFAULT Constraint

Foreign Keys

Use Foreign Keys with Joins - Books & Publishers

Foreign Keys - Properties

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