Day 7 of 15 Days of Advanced SQL Series
Welcome back peeps. Hope all’s well. Last two weeks have been crazy busy at work for me (plus I was traveling).
Day 1 : SQL Basics and Kick start of Advanced SQL Series
Day 2 : SQL Basics, Query Structure, Built In functions Conditions
Day 3 : Most Important Commands, Joins and Filters
Day 4 : Set Theory Operations, Stored Procedures and CASE statements in SQL
Day 5 : Wildcards, Aggregation and Sequences in SQL
Day 6 : Subqueries, Group by, order by and Having clauses in SQL and Analytical Functions
Day 7 : Window Functions, Grouping Sets and Constraints in SQL
Day 8 : BigQuery Basics, SELECT, FROM, WHERE and Date and Extract in BigQuery
Day 9 : Common Expression Table, UNNEST Clause, SQL vs NoSQL Databases
Day 10 : Triggers, Pivot and Cursors in SQL
Day 11 : Views, Indexes and Auto Increment in SQL
Day 12 : Query optimizations, Performance tuning in SQL
Day 14 : MySQL in Depth
