-
About Me
-
Hey! My name is Rose.
I am learning to code at 37 years old. -
Find me on Youtube!
-
Get notified
-
-
Latest Posts
-
Archives
-
Important Notes
-
First Webinar - Oct 17- DM Notations
- Midterms - Jan. 8, 2024
- Finals - Mar. 5, 2024
-
Review Maths
-
Resources
-
2023 PBA April Term 2023 PBA October Term BSc Computer Science Business Analytics Nanodegree Udacity Challenge: Front End Developer CM1020 Codeacademy Code Foundations - Code Academy Coursera CS50 CSS CSS Grid Discrete Mathematics Google IT Support Professional Certificate HarvardX ITP1 Teamtreehouse Udacity University of London UoL RPL
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
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
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
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
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
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
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
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
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