Resource for SQL MasterClass for Data Analytics
-
Introduction 2.Installation and Getting Started
-
Case Study
- Part-1
- Part-2
-
Fundamental SQL Statement
- CREATE
- INSERT
- Import Data From File
- SELECT
- WHERE
- Logical Operators
- UPDATE
- DELETE
- ALTER
-
Restore and Back-Ups
- Restore
- CSV Files
-
Selection Commands : Filtering
- IN
- BETWEEN
- LIKE
-
Selection Commands : Ordering
- ORDER BY
- LIMIT
-
Alias
- AS
-
Aggregate Commands
- COUNT
- SUM
- AVERAGE
- MIN & MAX
-
Group By Commands
- GROUP BY
- HAVING
-
Conditional Statement
- CASE WHEN
-
JOINS
- Introduction to Joins
- Inner JOIN
- Left JOIN
- Right JOIN
- Full Outer JOIN
- Cross JOIN
- Except
- UNION
-
Subqueries
- Subqueries
-
Views and Indexes
- VIEWS
- INDEXES
-
String Functions
- LENGTH
- UPPER LOWER
- REPLACE
- TRIM, LTRIM, RTRIM
- CONCATENATION
- SUBSTRING
- LIST AGGREGATION
-
Mathematical Functions
- CEIL & FLOOR
- RANDOM
- SETSEED
- ROUND
- POWER
-
Date-Time Functiom
- CURRENT DATE & TIME
- AGE
- EXTRACT
-
Pattern(String) Matching
- Pattern Matching Basics
- Advance Pattern Matching
-
Data-Type Conversion Function
- Converting Numbers/DAta to String
- COnverting String to Numbers
-
User Access Control Function
- User Access Control
-
BONUS!!! Nail the Interview
- TableSpace
- PRIMARY KEY & FORIEGN KEY
- ACID compliance
- Truncate
-
Performance Tuning
- Vaccum
- String Function
- Joins
- Schemas
-
Practice Section
- Practice Problems
-
DataBase Basics
- SQL
- Tables & DBMS
- Types of SQL Commands
- PostgreSQL
- Join US