Install SQLectron

Connect to PostgreSQL - Credentials

Connect to PostgreSQL Using SQLectron

Import Course Data Using SQLectron

FOR WINDOWS 32-BIT USERS: SQL Alternative - DBeaver

Check Imported Data

What is a Database?

SQL Data Types

Extracting Data Based on Requirements

Filtering Data using WHERE Keyword

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

AND, OR & NOT Operators: Which Has The Highest Priority?

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

Give Your Report Fields A Cool Name

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