Complete Python And Projects — Mega Compilation
Everything that you need to know in Python with Projects…
Welcome back peeps. This post covers everything you need to know in Python right from basics to advanced level and some python projects that you can implement.
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