Day 1 of 15 Days of Advanced SQL Series
Both Basics and Advanced SQL covered…
Hello peeps. Hope all’s going well. It’s a smooth week at work and I’m traveling.
As we are nearing to the end of 30 days of Data Structures & Algorithms and System Design ( links below); here comes 15 days of Advanced SQL Series.
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