Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

SQL Masterclass: SQL for Data Analytics

Video Introducing this tutorial

Introduction :
Course Overview

Installation and getting started :
Course Resources
This is a milestone!
Installing and setting up PostgreSQL
If pgAdmin is not opening...

Case Study : Demo :
Case Study Part 1
Case Study Part 2

Fundamental SQL statements :
CREATE
Exercise 1: Create DB and Table
Solutions to all Exercises
INSERT
Import data from File
Exercise 2: Inserting and Importing
SELECT statement
SELECT DISTINCT
WHERE
Logical Operators
Exercise 3: SELECT & WHERE
UPDATE
DELETE
ALTER
Exercise 4: Updating Table
Fundamental SQL statements

Restore and Back-up :
Restore and Back-up
Debugging restoration issues
Creating DB using CSV files
Debugging summary and Code for CSV files
Exercise 5: Restore and Back-up

Selection commands: Filtering :
IN
BETWEEN
LIKE
Exercise 6: In, Like & Between

Selection commands: Ordering :
Side Lecture: Commenting in SQL
ORDER BY
LIMIT
Exercise 7: Sorting

Alias :
AS

Aggregate Commands :
COUNT
SUM
AVERAGE
MIN & MAX
Exercise 8: Aggregate functions
Quiz

Group By Commands :
GROUP BY
HAVING
Exercise 9: Group By
Quiz
Conditional Statement
CASE WHEN

JOINS :
Introduction to Joins
Concepts of Joining and Combining Data
Preparing the data
Inner Join
Left Join
Right Join
Full Outer Join
Cross Join
Intersect and Intersect ALL
Except
Union
Exercise 10: Joins
Quiz

Subqueries :
Subqueries
Exercise 11: Subqueries

Views and Indexes :
VIEWS
INDEX
Exercise 12: Views

String Functions :
LENGTH
UPPER LOWER
REPLACE
TRIM, LTRIM, RTRIM
CONCATENATION
SUBSTRING
LIST AGGREGATION
Exercise 13: String Functions

Mathematical Functions :
CEIL & FLOOR
RANDOM
SETSEED
ROUND
POWER
Exercise 14: Mathematical Functions

Date-Time Functions :
CURRENT DATE & TIME
AGE
EXTRACT
Exercise 15: Date-time functions

PATTERN (STRING) MATCHING :
PATTERN MATCHING BASICS
ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
Exercise 16: Pattern Matching

Data Type conversion functions :
Converting Numbers/ Date to String
Converting String to Numbers/ Date

User Access Control Functions :
User Access Control

Bonus Section: Nail that Interview! :
Tablespace
PRIMARY KEY & FOREIGN KEY
ACID compliance
Truncate
Practice Test 1
SQL Quiz

Performance tuning tips :
TIP 1 (EXPLAIN)
TIP 2
TIP 3
TIP 4 (VACCUM)
TIP 5
TIP 6 (STRING FUNCTIONS)
TIP 7 (JOINS)
TIP 8 (SCHEMAS)

Bonus Section : Database Basics :
What is SQL
Tables and DBMS
Types of SQL commands
PostgreSQL
The final milestone!
Congratulations & About your certificate