July 2022

  • Study Notes #20

    SQL AND and BETWEEN Quiz Write a query that returns all the orders where the standard_qty is over 1000, the poster_qty is…

  • Study Notes #19

    I am not sure how I missed this module. 😞 Basic SQL primary_poc – a column…

  • Study Notes #18

    Aggregation no data / different from zero or space a datatype that specifies where no data…

  • Study Notes #17

    LEFT and RIGHT JOINs INNER JOIN – only returns rows that appear in both tables. I…

  • Study Notes #16

    ERD Reminder Entry-Relationship Diagrams (ERD) a common way to view data in a database. It is…

  • Study Notes #15

    Relational Database tables within a database relate to one another they contain identifiers to make the…

  • Finding Motivation

    I have been thinking about different things in my head. Things don’t get easier when I…

  • Study Notes #14

    Exercise: Bottom-Up Financial Forecasting View Spreadsheet Reference for formatting Project 2

  • Study Notes #13

    Projected Bookings per Sales Person SAMPLE FILE Sample Walk-through First, we start with the number of…

  • Study Notes #12

    Modeling refers to using certain inputs and using those inputs to predict how a business metric…