@@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! 😊
As a web developer with 10 years of experience, this is an extremely packed video covering everything you should know as a backend dev regarding everyday sql. Super helpful for someone who just introduced to SQL or someone seeking to refresh their memory(most probably before an interview, eh?) Keep up the good work!
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 .
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
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.
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?
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!
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
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
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
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!
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
I think this is normal. If you want to learn SQL, honestly I would first understand how relational databases work (tables, primary keys, foreign keys, data types, constraints). Once you wrap your head around this, find a reason to use a relational database in a project and just start writing SQL as needed to accomplish your goal. Just using it is the best way to learn it. More important than learning the technology is understanding how it can help you accomplish a goal. Then just start using it.
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!
This is honestly how I approach most technologies. I’m more concerned with learning what they are capable of so I can use them in a project than I am learning the technologies themselves. You will learn them in the process of using them. SQL is easy once you understand how relational databases work (tables, primary keys, foreign keys, data types, constraints). Wrap your head around this and SQL will make sense without much hassle.
Man, this guy is pumping these vids out! Way to go Byte
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.
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!👍
As a web developer with 10 years of experience, this is an extremely packed video covering everything you should know as a backend dev regarding everyday sql. Super helpful for someone who just introduced to SQL or someone seeking to refresh their memory(most probably before an interview, eh?)
Keep up the good work!
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?
1:47 on the query the right table is not called "Products" but "Orders"
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 .
The scheme in the start of video - is cool!
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.
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
Thank you so much for this. You have no idea of how much you covered in less than 5 minutes. Kudos!!
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
This video reduced the tension I've been encountering while learning SQL, simplifies my learning experience
You inspired me to create such explainer videos. Keep up. Great video as always
Subscribed :-)
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.
Great job packing in so much information in under 5 min!
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
what tool is this to draw such awesome flow chart ? I really want to use it for architecture diagram
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
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"
best infographics I have found that explains various tech topics. great job.
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!
Can you talk a bit about the scope of Procedural SQL, Triggers and hierarchical queries
Add CTE's and temp tables aswell. They'll just save you some time on repetitive code.
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
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!
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
Why CRUD(Create, Delete, Rename(Read?), Update) is into DDL? lenguaje de DEFINITION de datos
Create read update delete
Но чтобы ползоваться SQL вам надо где лежат определённые данные. А что если вы не знаете где эти данные лежат и как выглядят?
What about SurrealDB? 😊
superb video : t=112 should it be orders table and not products table ? ...
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 ?
Tell me about the software used to create animations in your video. Thank you.
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
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...
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!!
Can you talk about stack and pointers in memory?
Learn administration (DBA) part and developer's path are different things. This is not just about SQL learning.
Очень хорошее видео. Рассказать о базовых принципах SQL за 5 минут не каждому дано.
Awesome tutorial, crystal clear and concise.
Could you please make a video on Wide column vs column family vs columnar vs column oriented DB
Como siempre... Lo mejor!!! ❤ Gracias!
Can you teach us how we can make these animations??
Where is the roadmap ?
What tool do you use for generating this diagrams ?
Excelente vídeo de introdução, direto e preciso !
I'm curious, what tool do you use to create your videos??
Which software he uses to make the first diagram that he made ...can someone tell me ??
which software do you use to make the dynamic flow diagram?
I go out of my way to use .json or .csv for everything just to not learn sql.
I love the animation and the explanation is so clear 🥰👌
Please provide us with a learning map IT support and Cybersecurity
Which tool is used for these animations
great choice to advance the sound level, I can hear your videos better now.
Extremely useful and perfect for my adhd brain, thx
how did you make that mindmap?
How do you all create these diagrams?
no intro.. no bs ... just straight to the point. ..... think about the children
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!
Do you have a roadmap for python?
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 👍🏻
What I've been studying for over 16hs in 2 days, he resumed in less than 5min
the video should be named learn SQL in 5 minutes.
nice cover for the SQL.
Thanks, i am starting to learn it bit by bit
Sir make video about Twitter(X) system design
Great animation! thank you!
how can someone miss he is use pokemon names.
useful and beautiful 🤩👍
Won't call this a "Roadmap"!
why not ?
More of a snippet
Great video 👏👏👏👏
🔴Please do a video about CQL like this.
Awesome! Thank You.
Awesome !
Please make a detailed roadmap for Android development
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
I think this is normal. If you want to learn SQL, honestly I would first understand how relational databases work (tables, primary keys, foreign keys, data types, constraints). Once you wrap your head around this, find a reason to use a relational database in a project and just start writing SQL as needed to accomplish your goal. Just using it is the best way to learn it.
More important than learning the technology is understanding how it can help you accomplish a goal. Then just start using it.
Very useful!
1:59 You forgot the value for age :)
7k+...Thanks. Great Video !!!
Excelente sumario.
Thanks a ton for this video
Wait, you just joined without JOIN?! I think I'm gonna subscribe
great job!
awsome content
Thank you!
Such valuable content
the f man years of knowledge in minutes
A video on how to learn AI would be amazing
best summarize view. Gave much better intro.
very good, but way too fast. thanks!
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?
Love ❤
SQL is the most important language to master
Perfect
Amazing
imagine needing to learn sql, just use it
This is honestly how I approach most technologies. I’m more concerned with learning what they are capable of so I can use them in a project than I am learning the technologies themselves. You will learn them in the process of using them.
SQL is easy once you understand how relational databases work (tables, primary keys, foreign keys, data types, constraints). Wrap your head around this and SQL will make sense without much hassle.