Subqueries is SQL's most powerful tool, infact if you can consistently write correct subqueries, you should be a master in SQL

@MrYerak5

Ай бұрын

You can also crash the database if you do it right

@mileselam641

Ай бұрын

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

@shadowspyes

Ай бұрын

@@mileselam641yet not as optimized

@MrNortySpock

Ай бұрын

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

@mileselam641

Ай бұрын

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

Man, this guy is pumping these vids out! Way to go Byte

Great animation! Just a heads-up, at 1:47, the table name mentioned is 'Products,' but the query refers to the 'Orders' table. Keep up the good work! 😊

Short, high speed revision of the key concepts...Nice!👍

Dude! I could of use this diagram 10 yrs ago!!! Anyone who wants to learn should have a copy of this. And keep it in your workspace.

The scheme in the start of video - is cool!

Thanks for the SQL basics coverage! Advanced topics may include: UNION queries, CTE / WITH queries, Triggers and Stored Procedures, etc.

@mileselam641

Ай бұрын

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

@vjlxmi7039

9 күн бұрын

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

Enjoying your content, thanks for putting it out! As an FYI, there is a small typo when the video talks about "Inner Joins" - I believe the visual of the table should state "Orders" instead of "Products", as this is what the SQL statement is using.

@RobertPodosek

Ай бұрын

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

Como siempre... Lo mejor!!! ❤ Gracias!

I use SQL in data analysis, it is powerful when combined with Excel!

I've been a developer for 5 years and to this day, I don't have a mastery of SQL. I know when I need to use something and I look it up, but I don't know it by heart.

@stevefrandsen7897

24 күн бұрын

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.

@lucatsf

24 күн бұрын

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

Just want to encourage you bro... You;re putting so much effort to create exceptional content... Didn't have to watch everything to see that... May God bless and reward your hardwork

Excelente vídeo de introdução, direto e preciso !

You inspired me to create such explainer videos. Keep up. Great video as always

@gradientO

Ай бұрын

Subscribed :-)

An excellent summary and review of all the key SQL concepts AFTER you have learnt them...this is not for starters...imho.

Extremely useful and perfect for my adhd brain, thx

Animation is just awesome 👍🏻

i always get this is not efficient , use this query, for example: i have a prod job which check if it runs today, it checks for data existing for today and delete and try to insert whatever it has(new data). someone suggested donot delete, ty to do a left join which is faster the above is a simple usecase(ml jobs - reruns), but where to learn all these fundamentally. it will help a lot. Thanks in advance

Thanks, i am starting to learn it bit by bit

great choice to advance the sound level, I can hear your videos better now.

Awesome! Thank You.

Tell me about the software used to create animations in your video. Thank you.

Очень хорошее видео. Рассказать о базовых принципах SQL за 5 минут не каждому дано.

What tool do you use for generating this diagrams ?

Love the content! @2:13, the table on the bottom should be ‘Orders’. Also DATEADD needs paren @2:51

@wrona1993

Ай бұрын

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

this guy knows how to intimidate newbies with all the graphics, if i didnt know sql i would be terrified looking at all those

I'm curious, what tool do you use to create your videos??

which software do you use to make the dynamic flow diagram?

Thanks a ton for this video

Awesome !

Could you please make a video on Wide column vs column family vs columnar vs column oriented DB

Can you talk a bit about the scope of Procedural SQL, Triggers and hierarchical queries

Very useful!

Thank you!

7k+...Thanks. Great Video !!!

What about SurrealDB? 😊

Can you talk about stack and pointers in memory?

It is a quite interesting and informative video. Could you tell me in what software you created the diagram that appears at the beginning of the video? Someone knows?

@ahounoufolabithierry5235

Ай бұрын

Maybe Adobe Illustrator and After Effects as stated in the description

Great video 👏👏👏👏

Such valuable content

the video should be named learn SQL in 5 minutes. nice cover for the SQL.

How do you all create these diagrams?

🔴Please do a video about CQL like this.

Why CRUD(Create, Delete, Rename(Read?), Update) is into DDL? lenguaje de DEFINITION de datos

@MrSumkinFedor

Ай бұрын

Create read update delete

Can you teach us how we can make these animations??

Please make a detailed roadmap for Android development

hi bro, your video and diagram are so amazing, could you pls let me know how to draw dynamic lines as what you have in your video? thank you sooooo much

@resistentemente

Ай бұрын

It's in the description bro!

@abhisheaksaraswat-ib1of

Ай бұрын

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

Please provide us with a learning map IT support and Cybersecurity

I go out of my way to use .json or .csv for everything just to not learn sql.

Which tool is used for these animations

@MountMatze

27 күн бұрын

its in the info

Won't call this a "Roadmap"!

@The0Yapster

Ай бұрын

why not ?

@InsightByte

Ай бұрын

More of a snippet

I am sorry to pin point this out, but by any chance, did you happen to use ai to generate your transcript? I use ai every day and I am used to some terms of ai. So from the first 30 secs of your video, I got an instinct that you might have used ai. But I cannot guarantee. Thanks for the great video though!

Nice Effect

Love ❤

best summarize view. Gave much better intro.

A video on how to learn AI would be amazing

Sir make video about Twitter(X) system design

1:59 You forgot the value for age :)

SQL is the most important language to master

SQL 4 life :)

you look like neural network

Already obsolete....Pandas is what you need to learn

stubborn academy

i wouldnt really call that a roadmap :D rather a 4 minute video about sql and different queries...

SQL should be thought in schools from like 6th grade, but we will have transgender studies instead probably.

@we_areone

Ай бұрын

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 😏

@TheKmsaboor

Ай бұрын

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.

@mileselam641

Ай бұрын

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

@nemeziz_prime

Ай бұрын

​@@mileselam641woke alert 🚨🚨🚨

@mileselam641

Ай бұрын

@@nemeziz_prime Better than sleeping on the job!

Roadmap? To learn SQL? LOLOLOL what level of degradation we are?)