@@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.
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! 😊
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
Start with SELECT FROM WHERE GROUP BY HAVING ORDER BY DISTINCT TOP N OFFSET FETCH LIMIT ... FUNCTIONS... VIEWS... JOINS...SETS... CTEs ... TVC [UNION ALL] ... and the big one WINDOW FUNCTIONS... and read a good foundational book by say ITZIK BEN GAN... But it takes a LIFETIME to MASTER SQL... and this is true for every skill
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.
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.
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.
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 .
NGL, been studying SQL and SQL server for about 3 weeks, i understand everything from begining until minute 3:57 it's been so frustrating because its a relatively new topic to me it's so exhausting idk why but im glad i understand most of the video i'll do my best to also understand the last minute of the video
Great video! Just one thing I want to point out - I don't think it's a good idea to put the pop-up links for another videos mid-video (1:39) it got really distracting, otherwise - good work!
You've gained yourself a subscriber man🎉 just did a wonderful job bcz I'm broke and hunting for job painstakingly but I've knowledge about building databases only except the rest of the 〽️ part which was about to bite me in the ass later 😢😢😢bcz I added sql in my resume
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?
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
Guys, just learn the basics and go make projects and answer some exercises it's the quickiest yet enjoyable method to learn anything, trial and error will teach you not a 10 HOURS video!
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
Could you please help on how to do a project in sql. I have learned the basic and I believe the only thing I need now is to start doing my own project but I don't know how.
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!
Subqueries is SQL's most powerful tool, infact if you can consistently write correct subqueries, you should be a master in 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.
Man, this guy is pumping these vids out! Way to go Byte
Short, high speed revision of the key concepts...Nice!👍
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! 😊
This video reduced the tension I've been encountering while learning SQL, simplifies my learning experience
Thanks for the SQL basics coverage! Advanced topics may include: UNION queries, CTE / WITH queries, Triggers and Stored Procedures, etc.
Those are all still part of SQL basics. Triggers and stored procedures are intermediate at best. :-)
@@mileselam641 then what would be the advanced topics?
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
Start with SELECT FROM WHERE GROUP BY HAVING ORDER BY DISTINCT TOP N OFFSET FETCH LIMIT ... FUNCTIONS... VIEWS... JOINS...SETS... CTEs ... TVC [UNION ALL] ... and the big one WINDOW FUNCTIONS... and read a good foundational book by say ITZIK BEN GAN... But it takes a LIFETIME to MASTER SQL... and this is true for every skill
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.
It's ByteByteGo lol.. if you're read a single one of their newsletters there's typos all over the place.
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.
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 .
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!
1:47 on the query the right table is not called "Products" but "Orders"
I use SQL in data analysis, it is powerful when combined with Excel!
this guy knows how to intimidate newbies with all the graphics, if i didnt know sql i would be terrified looking at all those
Thank you so much for this. You have no idea of how much you covered in less than 5 minutes. Kudos!!
I am wondering if you teach a whole course. In your 5-minute video, you articulated the entire SQL alphabet. It was impressive.
Damn, I knew I should've see roadmaps when learning new programming language. It makes things easier...
You inspired me to create such explainer videos. Keep up. Great video as always
Subscribed :-)
no intro.. no bs ... just straight to the point. ..... think about the children
Great job packing in so much information in under 5 min!
What I've been studying for over 16hs in 2 days, he resumed in less than 5min
An excellent summary and review of all the key SQL concepts AFTER you have learnt them...this is not for starters...imho.
That is true. I could not agree anymore!
Won't call this a "Roadmap"!
why not ?
More of a snippet
best infographics I have found that explains various tech topics. great job.
Add CTE's and temp tables aswell. They'll just save you some time on repetitive code.
Очень хорошее видео. Рассказать о базовых принципах SQL за 5 минут не каждому дано.
Love the content! @2:13, the table on the bottom should be ‘Orders’. Also DATEADD needs paren @2:51
Also right table at 1:55 should be "Orders"
NGL, been studying SQL and SQL server for about 3 weeks, i understand everything from begining until minute 3:57
it's been so frustrating because its a relatively new topic to me it's so exhausting idk why but im glad i understand most of the video
i'll do my best to also understand the last minute of the video
Learn administration (DBA) part and developer's path are different things. This is not just about SQL learning.
Awesome tutorial, crystal clear and concise.
Great video! Just one thing I want to point out - I don't think it's a good idea to put the pop-up links for another videos mid-video (1:39) it got really distracting, otherwise - good work!
great choice to advance the sound level, I can hear your videos better now.
I love the animation and the explanation is so clear 🥰👌
Thanks, i am starting to learn it bit by bit
the video should be named learn SQL in 5 minutes.
nice cover for the SQL.
Can you talk a bit about the scope of Procedural SQL, Triggers and hierarchical queries
Excelente vídeo de introdução, direto e preciso !
Extremely useful and perfect for my adhd brain, thx
Great animation! thank you!
You've gained yourself a subscriber man🎉 just did a wonderful job bcz I'm broke and hunting for job painstakingly but I've knowledge about building databases only except the rest of the 〽️ part which was about to bite me in the ass later 😢😢😢bcz I added sql in my resume
Animation is just awesome 👍🏻
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?
Maybe Adobe Illustrator and After Effects as stated in the description
superb video : t=112 should it be orders table and not products table ? ...
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
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
what tool is this to draw such awesome flow chart ? I really want to use it for architecture diagram
Could you please make a video on Wide column vs column family vs columnar vs column oriented DB
Guys, just learn the basics and go make projects and answer some exercises it's the quickiest yet enjoyable method to learn anything, trial and error will teach you not a 10 HOURS video!
do u have suggestions on wheres best to create projects?
the f man years of knowledge in minutes
Very useful!
useful and beautiful 🤩👍
Wait, you just joined without JOIN?! I think I'm gonna subscribe
🔴Please do a video about CQL like this.
great job!
7k+...Thanks. Great Video !!!
Such valuable content
Excelente sumario.
Great video 👏👏👏👏
Awesome !
best summarize view. Gave much better intro.
What about SurrealDB? 😊
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
Tell me about the software used to create animations in your video. Thank you.
Como siempre... Lo mejor!!! ❤ Gracias!
Can you talk about stack and pointers in memory?
Awesome! Thank You.
Could you please help on how to do a project in sql. I have learned the basic and I believe the only thing I need now is to start doing my own project but I don't know how.
I'm curious, what tool do you use to create your videos??
Please make a detailed roadmap for Android development
Please provide us with a learning map IT support and Cybersecurity
I want the first diagram also seen on the banner cover page - how can I get it?? can u please share a link to that image? Thanks in advance!!
A video on how to learn AI would be amazing
Thanks a ton for this video
SQL is the most important language to master
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!
Thank you!
Amazing
In DDL it's (Create, drop, alter, truncate, comment, rename) instead of (create, delete, update, rename) please update your diagram.
R u preparing for Gate ?
which software do you use to make the dynamic flow diagram?
how did you make that mindmap?
Sir make video about Twitter(X) system design
What tool do you use for generating this diagrams ?
Where is the roadmap ?
Но чтобы ползоваться SQL вам надо где лежат определённые данные. А что если вы не знаете где эти данные лежат и как выглядят?
Can you teach us how we can make these animations??
this is cool and all but i dont think i can learn from videos i think i need to see it and do it im a slow learner with alot of health issues
How do you all create these diagrams?
I go out of my way to use .json or .csv for everything just to not learn sql.
Nice Effect
Perfect
Which tool is used for these animations
Which software he uses to make the first diagram that he made ...can someone tell me ??
Why CRUD(Create, Delete, Rename(Read?), Update) is into DDL? lenguaje de DEFINITION de datos
Create read update delete
very good, but way too fast. thanks!
Do you have a roadmap for python?
imagine needing to learn sql, just use it
Comment from the terminal
Already obsolete....Pandas is what you need to learn
1:59 You forgot the value for age :)
SQL is NOT granular enough to conduct an effective analysis of data. Ummmm no.