SQL

SQL for Data Analytics (Class 19) – Derived Table | Windows Function (OVER, PARTITION BY, ORDER BY)

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »

SQL for Data Analytics (Class 18) – Advanced Co-Related Sub Query | Common Table Expressions (CTE)

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »

SQL for Data Analytics (Class 17) – Sub Queries (Derived Column , Derived Table & Co-Related)

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »

SQL for Data Analytics (Class 16) – Sub Queries (Scalar, Multi Rows, Derived Column)

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »

SQL for Data Analytics (Class 15) – Creating VIEWS in SQL Server | Exporting SQL Results to POWER BI

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »

SQL for Data Analytics (Class 14) – Star and Snowflake Schema | Appending Data (UNION and UNION ALL)

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »

SQL for Data Analytics (Class 13) – Advanced Analysis with JOINS | Exporting Results | RIGHT JOIN

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »

SQL for Data Analytics (Class 12) – Foundations of SQL Joins | ERD Diagram | Fact vs Dim Tables

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »

SQL for Data Analytics (Class-11) – Basics of Data Normalization

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »

SQL for Data Analytics (Class 10) – Conditional Functions (Nested IIF, CASE Statement)

Welcome to Class 01 of our SQL for Data Analytics series! Watch this before starting your data career, it’s the…

Read More »
Back to top button