Mega Post— Tech Interview : The Only List of Questions You Need To Practice
Mega Compilation — Use it just as a reference/practice resource…
Welcome back peeps. I’m creating this post to help students/anyone who wants to get into tech — who are preparing for their tech interviews. While I’m sitting on the other side of the table as an interviewer now; I know how daunting the prep journey can be. Use it just as a reference/practice resource and you may bookmark this list.
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