Roadmap for Learning SQL 

You can also crash the database if you do it right

CTEs > subqueries More composable, easily debuggable, more flexible, easier to read, and easier to write.

@@mileselam641yet not as optimized

@@shadowspyes CTE optimization behavior is database-specific, some databases can optimize with and around CTEs just fine.

@@shadowspyes I don't know where you got your info, but there is no inherent reason CTEs would be slower. In Postgres you can mark a CTE as MATERIALIZED or not, making them act as a typical subquery would or as a temporary table depending upon your use case, how many results you expect back, and how often you reference that dataset. Logically, CTEs and subqueries are identical. From the planner's point of view, they're actually easier to optimize. Just after their introduction, they could act as an optimization fence, but those days are long gone.

It's ByteByteGo lol.. if you're read a single one of their newsletters there's typos all over the place.

Those are all still part of SQL basics. Triggers and stored procedures are intermediate at best. :-)

​@@mileselam641 then what would be the advanced topics?

Subscribed :-)

Also right table at 1:55 should be "Orders"

Nothing wrong with being humble and double checking your work. Many people don't know the nuances of COUNTing where the data may or may not have NULLs, but they would never admit it. Better to just be wrong.

@@stevefrandsen7897 Yeah, that's true. Thanks for the comment!

That's ok in your current sphere of work , where you can google things out .But when you interview for a product company they will rip you apart with SQL questions .so better get to know it inside out .

Maybe Adobe Illustrator and After Effects as stated in the description

It's in the description bro!

@@resistentemente, where? I think tool name is mentioned only, but how we can create the same, I tried but no success

why not ?

More of a snippet

Create read update delete

Lol the irony...coz most would not agree with you. They are more bothered about prom, getting laid before they even get married etc. Skills like these are generally mocked 😏

Such a weird transphobic take to have 😂 when our education system in the US don’t even properly teach steam in general let alone personal finances. As an engineer I would not want to learn SQL in middle school. Shit too boring when children needed to learn more life skills communication, sex ed, and personal finance like taxes or buying a home.

Amazing. Every word of what you just wrote was wrong.

​@@mileselam641woke alert 🚨🚨🚨

@@nemeziz_prime Better than sleeping on the job!