SQL for Business Analysis

  • SQL And Relationship Database
  • Set Up SQL Database
    • Connect to database
    • Create new table
    • Import data
  • Pull Out Data from Database
    • SQL Language Basics
    • Case study 1 – Using SQL query to import data
    • Case study 2 – Conditional filter and sort
    • Case study 3 – Automating connection and querying
  • Query to Join & Combine Database
    • Different join types
    • Define alias for a column
    • Combine AND and OR together to create more complex filtering criteria
    • Use wildcard in SQL language
    • Case study 4 – Search for inactive customers in CRM data
    • Case study 5 – Find new customers in sales data
    • Case study 6 – Find your best-selling product
  • Calculations, Conditional Logic & Functions
    • Calculated columns
    • Use conditional logic in calculation
    • Use built in functions to perform more complex calculations
    • Case study 6 –Create calculated columns for sales amount, COGS and margin for the sales data
    • Case study 7 –Calculate freight expense based on country information
    • Case study 8 – Get Product category and size information
  • Transform SQL Results with String Functions
    • Get the length of a string
    • Select part of a string
    • Remove space and change case
    • Case study 9 – Merge record data with GROUP BY and string functions
  • Process Number Calculation with Number Functions
    • Data type & numeric value
    • Division and rounding numbers
    • Use aggregate functions
    • Aggregate distinct values in database
  • Preparing for Business Analytics
    • Case study 10 – Rolling calculations
    • Case study 11 – Date time calculations
    • Case study 12 – Year over year calculations
    • Save your queries by creating a view
    • Queries, functions and procedures

4 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *