Monthly Archives: 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 0, and the gloss_qty is 0. Using the accounts table, find all the companies whose names do not start with ‘C’ and end with ‘s’. When you use … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Study Notes #19

I am not sure how I missed this module. 😞 Basic SQL primary_poc – a column name on the diagram above web_events – a table name on the diagram above Database – a collection of tables that share connected data … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Study Notes #18

Aggregation no data / different from zero or space a datatype that specifies where no data exists in SQL. They are often ignored in our aggregation functions, which you will get a first look at in the next concept using COUNT. … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Study Notes #17

LEFT and RIGHT JOINs INNER JOIN – only returns rows that appear in both tables. I learned here that the result table will only show data of those rows that appear in all tables, those that don’t appear in all … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Study Notes #16

ERD Reminder Entry-Relationship Diagrams (ERD) a common way to view data in a database. It is also a key element to understanding how we can pull data from multiple tables. Tables & Columns In the Parch & Posey database there … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Study Notes #15

Relational Database tables within a database relate to one another they contain identifiers to make the content easily combined Why Would We Want to Split Data Into Separate Tables? Different contents of the tables, though they relate to another Speed … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Finding Motivation

I have been thinking about different things in my head. Things don’t get easier when I reached 30+. I think I have been so used to being alone. Responsibilities tend to overwhelm me. There are just a lot of things … Continue reading

Posted in Journal | Leave a comment

Study Notes #14

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

Posted in Study Notes | Tagged | Leave a comment

Study Notes #13

Projected Bookings per Sales Person SAMPLE FILE Sample Walk-through First, we start with the number of opportunities we expect the salesperson to close annually. Average price per unit – the average price per unit or product for manufacturing. Average units per … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Study Notes #12

Modeling refers to using certain inputs and using those inputs to predict how a business metric will perform. The time duration of your forecast will depend on the type of business and the business metric: Startups – usually forecast 6-12 … Continue reading

Posted in Study Notes | Tagged | Leave a comment