SQL

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

2 weeks ago

0 15

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

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

2 weeks ago

0 15

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

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

2 weeks ago

0 16

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

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

2 weeks ago

0 15

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

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

2 weeks ago

0 16

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

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

2 weeks ago

0 15

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

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

2 weeks ago

0 15

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

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

2 weeks ago

0 15

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

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

2 weeks ago

0 16

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

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

2 weeks ago

0 16

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

SQL

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

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

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

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

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

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

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

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

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

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

SQL for Data Analytics (Class 07) – String Functions (RIGHT, SUBSTRING, Dynamic String Functions

MS Excel Specialist (Class 22) – Interactive Excel Dashboard Design

SQL for Data Analytics (Class 05) – Date Types & Parts | Date Function (DATEDIFF, GETDATE, DATEADD)

SQL for Data Analytics (Class 06) – String Functions (CONCAT, LEFT, UPPER, LOWER, REPLACE)

SQL for Data Analytics (Class 04) – Aggregation (SUM, COUNT, AVG) | Numeric (ROUND, CEILING, FLOOR)

SQL for Data Analytics (Class 03) – WHERE and GROUP BY Clauses in SQL