Data Analyst with AI Certification
Course Content
Class 23 – Introduction of SQL | Basic SQL Clauses (SELECT, FROM)
-
Data Analyst with AI – Session 23
01:01:02
Class 24 – WHERE and GROUP BY Clauses in SQL
Class 25 – WHERE | GROUP BY (Revision) | HAVING | ORDER BY | Comments
Class 26 – Aggregation (SUM, COUNT, AVG) Numeric (ROUND, CEILING, FLOOR)
Class 27 – Date Types & Parts Date Function (DATEDIFF, GETDATE, DATEADD)
Class 28 – String Functions (CONCAT, LEFT, UPPER, LOWER, REPLACE)
Class 29 – String Functions (RIGHT, SUBSTRING, Dynamic String Functions
Class 30 – Comparison Operators Conditional Functions (AND, OR, IS)
Class 31 – Conditional Functions (LIKE, IIF Function) Analytic Buckets
Class 32 – Basics of Data Normalization
Class 33 – Foundations of SQL Joins ERD Diagram Fact vs Dim Tables
Class 34 – Advanced Analysis with JOINS Exporting Results RIGHT JOIN
Class 35 – Star and Snowflake Schema Appending Data (UNION and UNION ALL)
Class 36 – Creating VIEWS in SQL Server Exporting SQL Results to POWER BI
Class 37 – Sub Queries (Scalar, Multi Rows, Derived Column)
Class 38 – Sub Queries (Derived Column, Derived Table & Co-Related)
Class 39 – Advanced Co-Related Sub Query | Common Table Expressions (CTEs)
Class 40 – Derived Table Windows Function (OVER, PARTITION BY, ORDER BY)
Class 41 – WINDOW Functions (ROW_NUMBER, RANK, DENSE_RANK, LAG)
Class 42 – Introduction of MySQL Software | Data Analysis using MySQL
Class 43 – WINDOWS Functions | Sub Queries (Column_Table)
Class 44 – DDL (ALTER, CREATE, RENAME) | DML (INSERT, UPDATE, SET, DELETE)
Class 45 – Data Cleaning in SQL | SUBSTRING_INDEX | STR_TO_DATE Function
Class 46 – Introduction of 365 Hardware Store Database
Class 47 – Custom Functions in SQL How to make Function in MySQL
Class 48 – Advanced Custom Functions | Multiple Layer SQL JOINS
Class 49 – Stored Procedures in SQL and MySQL for Dynamic Inputs
Class 50 – User Management in SQL USING Clause in SQL
Student Ratings & Reviews
No Review Yet