Q1 – Find the active Branches List

Q2 – Fetching the Basic Product Details from the table

Q3 – Recent Customer Signups

Q4 – Orders Overview

Q5 – Unresolved Customer Support Tickets

Q6 – Fetching Customers Orders info using Joins

Q7 – Total Revenue made

Q8 – Average Response Time to Customers

Q9 – Active Employee Count for Departments

Q10 – Expired Products from Inventory

Q11 – Campaigns by Channel

Q12 – Active Assets Deployed in Branches

Q13 – Top 5 Products by their revenue

Q14 – Asset Depreciation Calculation

Q15 – High Cost Employees by Department

Q16 – Return of Investment on Branches

Q17 – Delivery Type Performance

Q18 – Customer Order Frequency

Q19 – Top 3 products per category

Q20 – Inventory Expiry Tracker

Q21 – Campaign Spend Efficiency

1 – Introduction to SQL Language

3 – Writing our First SQL Query

2 – Understanding the SQL Language.mov

4 –  Introduction to Databases

5 – Types of Databases

6 – SQL vs MYSQL Updated

7 – Spreadhsheets Vs Database

8 – Understanding Relational Database

9 – Project Introduction

10 – Data Types and INT

11 – BIG INT

12 – TINYINT

13 – DECIMAL

14 – FLOAT and DOUBLE

15 – BIT and BOOLEAN

16 – CHAR

17 – VARCHAR

18 – TEXT

19 – ENUM

20 – DATE and TIME

21 – DATETIME

22 – TIMESTAMP

23 – YEAR

24 – BLOB

25 – JSON

26 – Why we need Database Schema

27 – Types of Schema

28 – STAR Schema

29 – Installing Server and Workbench Installation for Mac

31 – Creating our First Database Schema

32 – Introduction to Snowflake Schema

33 – Creating a Snowflake Schema Database

34 – Primary Key

35 – Foreign Key

36 – Unique Composite and Candidate Key

37 – One to One Relationships

38 – One to many Relationships

39 – Many to Many Relationships

40 – Creating a Sample Database

41 – Create a Sample_Table

42 – Creating DATA for our Table

43 – Selecting Data CRUD Operations

44 – Altering and Updating the Table and Table information

45 – Deleting in SQL

46 – Importing Data to our MYSQL workbench

47 – SELECT  Everything

48 – Selecting Multiple Columns

49 – Select Distinct Values from a column or columns

50 – Selecting info with WHERE Clause

51 – Using Less than or Equal to with Where clause

52 – Using WHERE clause with greater than or equals to

53 – Where with AND criteria and Multiple criterion

54 – WHERE and OR

55 – WHERE and IN

56 – Understanding Wild Cards in MYSQL

57 – Wild Cards Situation Practice in MySQL workbench

Shortcomings and Operators of WHERE clause

57- Aggregation Section Introduction

63 – MAX and MIN

58 – Basic SUM

59 – Aggregations with previous learnings and Complex Situations

60 – Basic Count

61 – Complex Counting

62 – Average

1 – What is expected in this assignment

2 – Assignment Solution walkthrough

64 – Group by statement

65 – GROUP BY in MYSQL Workbench

66 – ORDER BY Statement

67 – HAVING

78 – Union All

68 – What are Joins and Why we need them

69 – Exploring the Dataset and CROSS Joins

70 – Understanding Left Join

71 – Practing Left Join with aggregations

72 – RIGHT Join

73 – RIGHT Join Example

74 – Practicing Right Join – Multi join and Aggregations

75 – Inner Join

76 – Practicing INNER JOIN

77 – Union

79 – Between and AND

80 – LIMIT

80 – NOT BETWEEN

81 – IS NOT NULL

82 – IS NULL

83 – Understanding CASE Statements updated

84 – Practicing Case Statement 1

85 – Case Statement 2

86 – Case Statement 3

87 – Introduction to SubQuery MYSQL

88 – Scalar SubQuery – MYSQL

89 – Practicing Scalar SubQuery – Q1 – MYSQL

90 – Scalar SubQuery Q2 –  MYSQL

91 – Complex Sub-Query Using Joins and Multiple Tables – MYSQL

Introduction to Window Functions – updated

• 1 – Introduction to Data Cleaning and How Significant it is 
•  2 – What is Data Cleaning 
•  3 – Key aspects of Data Cleaning 
•  4 – Key Aspects of Data Cleaning 
•  5 – Methods of Data Cleaning 
•  6 – Impact of Data Cleaning 
•  7 – Where Data Cleaning is used 
•  8 – Techniques of Data Cleaning 
•  9 – Handling Missing Values 
•  10 – Examples of Handling Missing Values 
•  11 – Data Deduplication and Identifying Duplicate information 
•  12 – Data Deduplication – Comparison Methods 
•  13 – Duplicate Detection 
•  14 – Data Deduplication Conclusion 
•  15 – Outlier Identification and Treatment 
•  16 – Example of Outlier Identification and Treatement 
•  17 – Data Normalization and Data Standardization 
•  18 – Data Formatting and Data Parsing 
•  19 – Inconsistent Data Handling 
•  20 – Error Correction and Validation 
•  21 – Data Transformation 
•  22 – Feature Engineering 
•  23 – Handling Imbalanced Data 

•  1 – Data Collection Introduction 
•  2 – Where and why we need data collection 
•  3 – Types of Data Collection 
•  4 – Mobile and Web Analytics Framework 
•  5 – User Engagement Analytics Frameworks 
•  6 – Centralized Logging Frameworks 
•  7 – Real time Data Streaming Frameworks 
•  8 -Cloud-Based Data Collection Frameworks 
•  9 – Observability Frameworks 
•  10 – Business Evolution and Frameworks at different stages of the business 2 
•  11 – Tools for Data Collection Frameworks 

•  1 – Introduction to the Data Standardization Course 
•  2 – Impact of Data Standardization 
•  3 – Aspects of Data Standardization 
•  4-Frameworks of Data Standardization 
•  5 -Data Wrangling 
•  6 – Data Standardization 
•  7 – Data Orchestration 
•  8 – Data Blending 
•  9 – Data Cleaning 
•  10 – Data Transformation 
•  11 – Data Integration and Data Enrichment 
•  12 – Types of Data Standardization and General Data Standards 
•  13 – Demo of Data Standardization for General Data Standardization frameworks 
•  14 – Demo of Complex Data Standardization 

•  1 – Course Introduction 
•  2 – Where Surveys are Used 
•  3 – Impact of a Survey – McDonald Example 
•  4 – Types of Surveys 
•  5 – Components of a Survey 
•  6 – Introduction to the Project 
•  7 – Background Information and Defining Objectives 
•  8 – Creating Survey Questions – Section Introduction 
•  9 – Thinking Themes – Key Themes 
•  10 – Brainstorming Questions 
•  11 – Prioritizing Questions 
•  12 – Question Types 
•  13 – Crafting Clear Questions 
•  14 – Avoid Double Barreled Questions 
•  15 – Consider Response Options 
•  16 – Neutral Language Question Flow and Sensitivity 
•  17 – Forming Questions in Chatgpt 
•  18 – Creating the Quesstionaire in Google forms and Creating Options 
•  19 – Logical Branching 
•  20 – Piloting and Administrative Modes 
•  21 – Admistrative Methods 
•  22 – Conclusion 

•  1 – MPPT – Course problem Introduction 
•  2 – MPPT – Applying Layout of the LAVA Framework 
•  3 – MPPT – Applying Alignment of LAVA Framework 
•  4 – MPPT – Applying Visual Heirarchy of LAVA Framework 
•  5 – MPPT – Audit and Review of LAVA Framework 
•  6 – MPPT – Creating a New Presentation 
•  7 – MPPT – Exploring the Interface of PowerPoint 
•  8 –  MPPT – Managing the Slides 
•  9 – MPPT – Inserting TEXT to the Layouts and Formatting it 
•  10 – MPPT Adding text to your slides 
•  11 –  MPPT – Inserting Images and Icons 
•  12 – MPPT – Inserting Tables into our Slides 
•  13 – MPPT – Inserting Smartart and Shapes into the Slides 
•  14 –  MPPT – Inserting Charts and Graphs into the Slide 
•  15 – MPPT – Inserting Multimedia Video , Audio and Screen Recording 
•  16 – MPPT – Inserting Hyperlinks and Action Buttons to the Slides 
•  17 –  MPPT – Designing and Theming your slides 
•  18 – MPPT – Adding and Customising Animations 
•  19 – MPPT – Applying and Customising Slide Transitions 
•  20 – Slide Master 
•  21 – Motion Paths 
•  22 – Advanced Formatting 
•  23 – Sections 
•  24 – Accessibility Features 
•  25 – AI in our Presentations 
•  26- AI for Design and Formatting 
•  27 – Applying Design Changes to all other Slides 
•  28 – Add Ins.screenstudio 
•  29 – Feedback Flow and Improving Slides with ChatGPT 
•  30 – Pop AI 
•  31 – AI in PPT – Dectopus 
•  32 – AI with PPT – Gamma App 
•  33 – Introduction to the Capstone Project and Course Intro 
•  34 – Background and Overlay Objects 
•  35 – Text Objects in Title Slide 
•  36 – Animating the Slide without Navigating it 
•  37 – Creating Progress Bar chart 
•  38 – Animating the Progress Bar Chart Slide 
•  39 – Market Research Slide 
•  40 – Creating Timelines Chart 
•  41 – Creating Icons text and Titles 
•  42 – Animating the Timeline Slide