Monthly Archives: July 2022

Subquery Example Challenge

Quiz What is the top channel used by each account to market products? How often was that same channel used? However, we will need to do two aggregations and two subqueries to make this happen. Let’s find the number of times each … Continue reading

Posted in Study Notes | Tagged | Leave a comment

SQL Subqueries: Dependencies

Simple the inner subquery is completely independent from the outer query Correlated the inner subquery is dependent on a clause in the outer query The second concept to consider before writing any code is the dependency of your subquery to … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Subquery Examples

Inline Subquery creates a table that you could then query again in the FROM statement Expert Tip Note that you should not include an alias when you write a subquery in a conditional statement. This is because the subquery is treated as … Continue reading

Posted in Study Notes | Tagged | Leave a comment

SQL Subquery Formatting

The first concept that helps when thinking about the format of a subquery is the placement of it: with, nested, inline, or scalar. The second concept to consider is an indentation, which helps heighten readability for your future self or … Continue reading

Posted in Study Notes | Tagged | Leave a comment

SQL Placements

Nested query within another query embedded within the WHERE clause when a user wants to filter an output using a condition met from another table advantageous for readability Use Case for a Nested Subquery When a user wants to filter an … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Ch 1 – O’Reilly’s Learning Web Design

https://styleguides.io – Website Style Guide Resources Authoring/markup (HTML) process of preparing content for delivery on the web page, or more specifically, marking up the content with HTML tags that describe it’s content and function HTML (HyperText Markup Language) authoring language … Continue reading

Posted in Books | Tagged | Leave a comment

Study Notes #22

SQL Subqueries & Temporary Tables Subquery a query within a query a query has both SELECT and FROM clauses to signify what you want to extract from a table and what table you’d like to pull data from. A query that includes subquery, as … Continue reading

Posted in Study Notes | Tagged | Leave a comment

Looking Ahead

I have at least 3 full years ahead of me. Who knows what will happen? Can I do this? 3 full years of commitment. At least 24 modules, 24 mid terms, how many courseworks, how many finals? How much time … Continue reading

Posted in Journal | Leave a comment

Almost a year learning Analytics

Things are starting to get harder, but more interesting. I am starting to be torn between Data Science and Web Development. My work is more aligned with Web Development. It was my initial goal, that was why I started all … Continue reading

Posted in Journal | Leave a comment

Study Notes #21

SQL GROUP BY allows creating segments that will aggregate independent from one another allows to take the sum of data limited to each account rather than across the entire dataset goes in between the WHERE and ORDER clause you should … Continue reading

Posted in Study Notes | Tagged | Leave a comment