Preview SQL Bootcamp for Business, Product, & Data Analysts

Getting Started

01 - Introduction

02 - Installation of SQL Server 2019 & SSMS

03 - Connect To Sql Server

04 - Create Sample Database (MediaStoreDb)

05 - Generate a Database Relationship Diagram

06 - Get all Customer Details

07 - Get all Album Details

08 - Get Customer Fields

09 - Get Track Fields -

10 - Get Employee Fields

11 - Display Customer Phone Number using Custom Field Name

12 - Display Track Unit Price using Custom Field Alias

13 - Get Customers Unique Countries

14 - Get Employee Titles

15 - Get Tracks having Track Length Condition

16 - Customers having Last Name Condition

17 - Tracks Starting With The Letters A - F

18 - Tracks Not Starting With The Letters A - F

19 - Get Invoices Between Two Dates

20 - Get Customers from California and Florida

21 - Get Management Level Employees

22 - Get IT Staff Level Employees

23 - Customers in USA, Canada with Custom Last Name

24 - Customers not from USA with Custom Last Name

25 - Customers Missing a State Code

26 - Customers Living in Berlin Sorted

27 - Most Recent Orders between Two Dates

28 - Employees Sorted by Title and Last Name

29 - Tracks Having a Composer Sorted by Name

30 - Last Five Invoices Created

31 - Top 10% of Tracks by Length

32 - First Ever Invoice Created

33 - Total Price of Each Invoice

34 - Total Price of Each Invoice with Condition

35 - Average Track Length

36 - Customer Count by Country

37 - Countries Having Less than 5 Customers

38 - Invoice Count per Customer

39 - Longest Running Track and Total Tracks

40 - Average Runtime, Total Price, Highest Bytes,Total Tracks (All Albums)

41 - Average Runtime, Total Price, Highest Bytes,Total Tracks (Per Album)

42 - Customer Display Name (Last, First)

43 - Apply 50% Discount of Track's Unit Price

44 - Tracks Having Runtime Smaller than Average

45 - Customers with Invoices More Than Some Amount

46 - Tracks Having No Sales

47 - Genres Having No Sales

48 - Customer, Invoice Info for Orders Placed Before March

49 - Invoice Details for a Specific Customer

50 - Total Daily Sales by Sales Agent

51 - Customers Having Zero Orders Placed

52 - Albums that Generated Zero Sales

53 - Overview

54 - Create and Alter Your First Stored Procedure

55 - Excel GetCustomers Report

Preview - SQL Bootcamp for Business, Product, & Data Analysts