Bryson

Brother is preaching…. THESE LAST 2 YEARS PEOPLE HAVE GOT EDUCATED!!!

The fastest way to lose a good man..

@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?

Den of thieves!

@BRICSinfo The reason for suctioning South Africa.

The Irish don’t play 🇮🇪🇵🇸

@MuskratPiss Here’s an explanation of the actual market wide criminal conspiracy that GameStop exposed and how and why short sellers could actually blow up the entire global economy.

😮

5. Be Delusional • Have 100% faith in yourself. • Doubt anyone who says you can't. • Keep working hard every day. It's the 'fake it till you make it' strategy. This mindset will keep you moving forward until you achieve your goals. Adam Sandler did the same ↓

@noahkagan By far the recent one with @tferriss and @JonBatiste One of a kind. x.com/thedanielaros/…

@rektfencer hmu 🤙🏼

I gave you $PNUT before it did 1384x I gave you #MOODENG before it did 1238x I gave you $POPCAT before it did 417x I gave you $ACT before it did 29x I gave you $WIF before it did 90x I gave you $BRETT before it did 730x I gave you $MYRO before it did 29x DMs been going WILD asking for the next 100x. Alright, I’ve got it. The next 100x runner. So early, so low MC, I can’t even post it here. But I’ll share it with a few who actually want it. RT. Like. Drop a comment. Make sure you’re following me + keeping DMs open

@JackPosobiec Good news. Ron Paul had this one right long ago.

@BRICSinfo This is taken out of context.. provide the full interview 🙄

JUST IN: 🇮🇱🇮🇷 Donald Trump says Israel should strike Iran's nuclear facilities.

Thank you Javier Bardem for your decency, your courage, and love for all human beings. You are a beacon of light, amigo.

I just published Stock Investing: A Comprehensive Guide to the Australian Market 2024 link.medium.com/JtNsnrqDhNb

“Look at the footage it looks ridiculous” Joe Rogan discusses the 1969 Moon Landing from 55 years ago. Once you can accept this level of human deceit the rest is easy.

Paul Graham one-pager on how to start a startup:

Meet Big Pharma’s greatest Barbara O’Neill. This 71-year-old woman’s banned healing methods have saved millions of lives. I've collected her top 8 lessons