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…