Installing and Setting up MS SQL

Installing and Setting up MySQL

Introduction

Installing and Setting up Oracle SQL

Installing PostgreSQL and pgAdmin in your System

CREATE in MySQL

CREATE in MS SQL

CREATE in PostgreSQL

Exercise 1 Create DB and Table

CREATE in OracleSQL

INSERT in PostgreSQL

INSERT in MS SQL

INSERT in MySQL

INSERT in Oracle SQL

Import data from File in PostgreSQL

Import data from File in MySQL

Import data from File in MS SQL

Import data from File in Oracle SQL

Exercise 2 Inserting and Importing data

SELECT statement in PostgreSQL

SELECT statement in MySQL

SELECT statement in Oracle SQL

SELECT statement in MS SQL

SELECT DISTINCT in MySQL

SELECT DISTINCT in PostgreSQL

SELECT DISTINCT in MS SQL

SELECT DISTINCT in Oracle SQL

WHERE in MySQL

WHERE in Oracle SQL

WHERE in MS SQL

WHERE in PostgreSQL

Logical Operators in MySQL

Logical Operators in PostgreSQL

Logical Operators in MS SQL

Logical Operators in Oracle SQL

Exercise 3 SELECT, WHERE & Logical

UPDATE in PostgreSQL

UPDATE in MySQL

UPDATE in MS SQL

UPDATE in Oracle SQL

DELETE in MySQL

DELETE in MS SQL

DELETE in PostgreSQL

ALTER Part 1 in PostgreSQL

DELETE in Oracle SQL

ALTER in MySQL

Exercise 4 Update, Delete and Alter Table

ALTER in Oracle SQL

ALTER in MS SQL

ALTER Part 2 in PostgreSQL

Restore and Back-up

Debugging restoration issues

Exercise 5 Restore and Back-up

Creating DB using CSV files

Restore and Back-up in MySQL

Restoring and Back-up in MySQL

Restoring and Back-up in MS SQL

Restoring and Back-up in MS SQL

IN in MySQL

IN in PostgreSQL

IN in MS SQL

BETWEEN in PostgreSQL

BETWEEN in MySQL

IN & BETWEEN in Oracle SQL

BETWEEN in MS SQL

LIKE in MySQL

LIKE in PostgreSQL

LIKE in MS SQL

Exercise 6 In, Like & Between

LIKE in Oracle SQL

Creating Db using CSV files in Oracle SQL

Side Lecture Commenting in SQL

ORDER BY in MySQL

ORDER BY in MS SQL

LIMIT in MySQL

LIMIT in PostgreSQL

ORDER BY in PostgreSQL

LIMIT in MS SQL

ORDER BY & LIMIT in Oracle SQL

Exercise 7 Sorting

AS in MySQL

AS in PostgreSQL

AS in Oracle SQL

AS in MS SQL

COUNT in MySQL

COUNT in PostgreSQL

SUM in MySQL

SUM in PostgreSQL

AVERAGE in PostgreSQL

AVERAGE in MySQL

MIN & MAX in MySQL

MIN & MAX in PostgreSQL

Aggregate Functions in MS SQL

Exercise 8 Aggregate functions

Aggregate Functions in Oracle SQL

GROUP BY in PostgreSQL

HAVING in MySQL

HAVING in PostgreSQL

GROUP BY in MS SQL

GROUP BY in MySQL

HAVING in MS SQL

Exercise 9 Group By

GROUP BY & HAVING in Oracle SQL

CASE WHEN in MS SQL

CASE WHEN in MySQL

CASE WHEN in PostgreSQL

CASE WHEN in Oracle SQL

Introduction to Joins

Preparing the data

Concepts of Joining and Combining Data

Inner Join in PostgreSQL

Inner Join in MySQL

Inner Join in MS SQL

Left Join in PostgreSQL

Inner Join in Oracle SQL

Right Join in MySQL

Left Join in MS SQL

Right Join in PostgreSQL

Left Join in MySQL

Right Join in MS SQL

Full Outer Join in PostgreSQL

Full Outer Join in MS SQL

Full Outer Join in MySQL

Cross Join in PostgreSQL

Left, Right & Full Outer Join in Oracle SQL

Cross Join in MS SQL

Cross Join in MySQL

Cross Join in Oracle SQL

Intersect in MySQL

Intersect and Intersect ALL in PostgreSQL

Except in MySQL

Except in PostgreSQL

Union in PostgreSQL

Union in MySQL

Intersect, Except & Union in MS SQL

Intersect, Except & Union in Oracle SQL

Exercise 10 Joins

Subqueries Subquery in FROM clause in PostgreSQL

Subqueries Subquery in WHERE clause in PostgreSQL

Subqueries Subquery in SELECT in PostgreSQL

Subqueries in MySQL

Subqueries in MS SQL

Exercise 11 Subqueries

Subqueries in Oracle SQL

VIEWS in MySQL

VIEWS in Oracle SQL

VIEWS in MS SQL

VIEWS in PostgreSQL

INDEX in MySQL

INDEX in PostgreSQL

INDEX in MS SQL

INDEX in Oracle SQL

Exercise 12 Views

LENGTH in Oracle SQL

LENGTH in PostgreSQL

UPPER LOWER in Oracle SQL

UPPER LOWER in PostgreSQL

REPLACE in Oracle SQL

REPLACE in PostgreSQL

CONCATENATION in Oracle SQL

CONCATENATION in PostgreSQL

TRIM, LTRIM, RTRIM in Oracle SQL

TRIM, LTRIM, RTRIM in PostgreSQL

SUBSTRING in Oracle SQL

SUBSTRING in PostgreSQL

LIST AGGREGATION in Oracle SQL

LIST AGGREGATION in PostgreSQL

String Functions Part 2 in MySQL

Exercise 13 String Functions

String Functions Part 1 in MySQL

String Functions in MS SQL

CEIL & FLOOR in PostgreSQL

RANDOM in PostgreSQL

SETSEED in PostgreSQL

ROUND in PostgreSQL

POWER in PostgreSQL

Mathematical Functions in MS SQL- Part 1

Mathematical Functions in MySQL

Mathematical Functions in MS SQL- Part 2

Mathematical Functions in Oracle SQL

Exercise 14 Mathematical Functions

CURRENT DATE & TIME in PostgreSQL

AGE in PostgreSQL

EXTRACT in PostgreSQL

Date-Time Functions in MS SQL

Date-Time Functions in MySQL

Date-Time Function in Oracle SQL

Extract in Oracle SQL

Exercise 15 Date-time functions

Data Type conversion to string in PostgreSQL

Data Type conversion to Number and Date in PostgreSQL

Data Type conversion in Oracle SQL

Data Type conversion in MySQL

Data Type conversion in MS SQL

PATTERN MATCHING BASICS

Advanced pattern matching Part 2 (REGULAR EXPRESSIONS)

Advanced pattern matching Part 1 (REGULAR EXPRESSIONS)

Pattern matching in MS SQL

Pattern matching in MySQL

The final milestone!

Pattern matching in Oracle SQL

Exercise 16 Pattern Matching