Complete-Advanced-SQL-Series

This repository contains everything you need to become proficient in Advanced SQL

Youtube for all the implemented projects and tech interview resources - Ignito Youtube Channel

Complete Cheat Sheet for Tech Interviews - How to prepare efficiently

I took theses Projects Based Courses to Build Industry aligned Data Science and ML skills

Part 1 - How to solve Any ML System Design Problem

---

---

Basics 

Structured Query Language

Query Structure

Conditions

Joins

Stored Procedures

Aggregations

Wild cards

Grouping Data

Aggregation Functions

Filtering

Sequences

Group By, Order By

Having Clause

Write Sub queries

Grouping Sets

Analytical Functions

Window Functions

Row Numbering 

Percentile

Advanced windowing techniques

BigQuery

BigQuery Basics

SELECT, FROM, WHERE and Date and Extract in BigQuery

Common Expression Table

UNNEST Clause

SQL vs NoSQL Database

Advanced Functions

Triggers

Pivot

Cursors

Views

Indexes

Auto Increment

Performance Tuning SQL Queries

Query Optimizations in. SQL

Performance Tuning in SQL

MySQL, PostgreSQL and MongoDB

Introduction to MySQL

Introduction to PostgreSQL

Introduction to Mongo DB

Comparison between MySQL and PostgreSQL and Mongo DB

Introduction to SQL and NoSQL Databases

MySQL in Depth

PostgreSQL in Depth