Day 15 of 15 Days of Advanced SQL Series
Welcome back peeps. Hope all’s well.
Happy to share that this is the last post of 15 days of Advanced SQL and what we have covered so far is listed below —
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