Saul Goodman

@EcZachly SQL

SQL has levels to it: - level 1 SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT Master these basic keywords and you’ll be well on your way to mastering SQL. - level 2 Mastering JOINs: Most common JOINs: INNER and LEFT Less common JOINs: FULL OUTER Joins you should avoid almost always: RIGHT and CROSS JOIN Mastering common table expressions (CTEs). The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later. Using variables like this you can master algorithm techniques like recursion, breadth first search and more! CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries. - level 3 Mastering window functions Window functions have 3 pieces: The function (i.e. SUM, RANK, AVG) The over clause to start the window The window definition which has 3 pieces: - how to split the window up with PARTITION BY - how to order the window with ORDER BY - how to restrict the window size with ROWS clause (useful for rolling monthly averages) Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times. - level 4 You understand table scans, b-tree indexes, and partitioning schemes to increase performance. Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post. B-trees indexes allow for efficient scanning of data in the WHERE clause. Use explain plans to understand if an index is actually being used or not! Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question. What else did I miss for mastering SQL?

@prettycyb3rgirl Hi

If you are any of these: Cybersecurity Engineers Software Developers Web Developers Mobile App Developers Data Scientists Cloud Engineers DevOps Engineers IT Support Specialists System Administrators Project Managers (Tech) UI/UX Designers Product Designers Digital Marketers Say Hi and let's connect😊

You know what I’m restarting the $100 to $10,000 challenge. I want everyone to have a fair shot at this. Last time it took me about 5 days, will try to do it faster this time. If you want to follow along, comment below to join Going to lock comments in 24 hours

@MachoCrotcho08 @sakura900_ ‼️

@sakura900_ Was that coolant into the gas tank?!???

Lifehack 😊😊😊

@Shadaya_Knight What did Rihanna say

Rihanna's attitude towards Tyla confirming what has always been known - older women hate younger women

@andresmiguer "okay?"

cuando me hacen pausar mi música solo para decime algo que me vale vrga

@MalikMcYeet 😂😂

Type shit I’d be on if I worked at TSA

@ayroned I wouldn't blame him fr

Roger Goodell would kill a fan on live television before he let 2 playoff games be played at the same time

@CbfwVeeze "oh true"

ion argue no mo, if you say you was sleep Friday & woke up Monday then ok

@AgustinCassino5 @Timberwolves @Jmcdaniels7 @NBA Spurs are gonna sweep them

@Timberwolves @Jmcdaniels7 @NBA acting like yall aren t going to get you ass wiped nex round 😭😭😂

@EdwardLong83930 @ogorlyog @FootballCravee 😂😂😂

@ogorlyog @FootballCravee That’s Mike Tomlin

🚨 DRAMA : The 49ers have been unable to get ahold of WR Brandon Aiyuk who is ghosting them. On Instagram he left this cryptic message..

@thewriterme Clickfarming

Part One- an expert tells you the three most invasive apps on your phone to delete. Number 3 is in part 2 below.

@Mvel_ee @softboywin I'm in here too. I leave work at 3PM.

@softboywin I'll lead the charge at 15:00

We cannot all be trying to head home at 5:00PM. We have to start going home in groups

@C_J_CA @HaterReport Or for health 😂

@HaterReport He’s sacrificing his son’s contract for a championship. I respect it.

LeBron gave Bronny “the look” YOU KNOW WHAT THAT MEANS lmaoo

@busenjoyer01 @phillynut1014 " it's fake news" ahh 😂😂

@phillynut1014 This is AI generated

Fun fact: At 470 feet tall, the Capital One Tower in Tysons, Virginia is the tallest building in the United States.

@Britannica 😂😂

Border Collie to the one wayward sheep:

@crypto_tlk_chrs @AdamSchefter Lmaooo

@AdamSchefter Oh ok

Ravens have unveiled their new uniforms:

@Raindropsmedia1 Y'all play too much 😂😂

Born on April 16, 1965, Martin Lawrence became one of the biggest comedy stars of the 90s through his hit sitcom Martin and films like Bad Boys, Blue Streak, Life, Big Momma's House, and Nothing to Lose. 🙏🏽 Happy 61st birthday to Martin Lawrence. 🐐 🎉

@MurrayHillGuy1 Nooo don't tell me that 😭

“We met on hinge”

@prettycxpricorn 😂

Gas prices are so high, I went to a dealership and test-drove 3 cars just to run my errands 🤣