SQL

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