Complete-Advanced-SQL-Series
This repository contains everything you need to become proficient in Advanced SQL
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
Structured Query Language
Query Structure
Conditions
Joins
Stored Procedures
Wild cards
Grouping Data
Aggregation Functions
Filtering
Sequences
Group By, Order By
Having Clause
Write Sub queries
Grouping Sets
Analytical Functions
Row Numbering
Percentile
Advanced windowing techniques
BigQuery Basics
SELECT, FROM, WHERE and Date and Extract in BigQuery
Common Expression Table
UNNEST Clause
SQL vs NoSQL Database
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