📚 Syllabus & Course Curriculum
Data Science & Analytics
Module-by-module breakdown of SQL & Power BI Program: From Foundations to Advanced Techniques, from foundations to a certified capstone project.
Outline
Introduction to SQL and Databases • DBMS vs. RDBMS Understanding • SQL Standards Overview • SQL Sub-languages
Outline
Declaring Column-Level Constraints • Declaring Row-Level Constraints • Adding Constraints to Existing Tables • Types of Integrity Constraints: NOT NULL, UNIQUE Key, PRIMARY Key, Referential Integrity, Check Integrity
Outline
Importance and Uses of Joins • Types of Joins: Equi Join, Non-Equi Join, Self Join, Outer Join, Left and Right Outer Join, Full Outer Join, Cross Join (Project Implementation: Project 3) • Utilizing Set Operators within a Single Table • Working with Set Operator Types: UNION, UNION ALL, INTERSECT, MINUS
Outline
Explanation of Scalar Functions • Overview of Aggregate Functions • Introduction to Date and Time Functions • Creating and Using Stored Procedures
Outline
Brief Overview of Window Functions • Introduction to Common Table Expressions (CTEs) • High-Level Understanding of Advanced Joins and Subqueries • Creating Complex Reports with SQL (Introduce Basic Concepts)
Outline
Overview of Advanced Data Modeling Techniques • Introduce Working with Complex Data Structures • Discuss Hierarchies and Time Intelligence • Introduction to Advanced DAX Functions and Formulas
Earn government-registered certification in SQL & Power BI Program: From Foundations to Advanced Techniques
e-Certificate and e-Marksheet issued on successful completion.
