Roadmap for Learning SQL
Вставка
- Опубліковано 8 чер 2024
- Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: bit.ly/bytebytegoytTopic
Animation tools: Adobe Illustrator and After Effects.
Checkout our bestselling System Design Interview books:
Volume 1: amzn.to/3Ou7gkd
Volume 2: amzn.to/3HqGozy
The digital version of System Design Interview books: bit.ly/3mlDSk9
ABOUT US:
Covering topics and trends in large-scale system design, from the authors of the best-selling System Design Interview series. - Наука та технологія
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!👍
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.
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! 😊
The scheme in the start of video - is cool!
Thank you so much for this. You have no idea of how much you covered in less than 5 minutes. Kudos!!
best infographics I have found that explains various tech topics. great job.
Excelente vídeo de introdução, direto e preciso !
Great job packing in so much information in under 5 min!
Como siempre... Lo mejor!!! ❤ Gracias!
You inspired me to create such explainer videos. Keep up. Great video as always
Subscribed :-)
I use SQL in data analysis, it is powerful when combined with Excel!
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?
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.
Extremely useful and perfect for my adhd brain, thx
Thanks, i am starting to learn it bit by bit
great choice to advance the sound level, I can hear your videos better now.
Animation is just awesome 👍🏻
Awesome! Thank You.
An excellent summary and review of all the key SQL concepts AFTER you have learnt them...this is not for starters...imho.
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 .
Awesome !
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"
Thank you!
Thanks a ton for this video
Very useful!
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
this guy knows how to intimidate newbies with all the graphics, if i didnt know sql i would be terrified looking at all those
Очень хорошее видео. Рассказать о базовых принципах SQL за 5 минут не каждому дано.
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
7k+...Thanks. Great Video !!!
Great video 👏👏👏👏
Can you talk a bit about the scope of Procedural SQL, Triggers and hierarchical queries
Could you please make a video on Wide column vs column family vs columnar vs column oriented DB
Such valuable content
Tell me about the software used to create animations in your video. Thank you.
🔴Please do a video about CQL like this.
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
I'm curious, what tool do you use to create your videos??
Can you talk about stack and pointers in memory?
What tool do you use for generating this diagrams ?
What about SurrealDB? 😊
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
Nice Effect
Love ❤
which software do you use to make the dynamic flow diagram?
the video should be named learn SQL in 5 minutes.
nice cover for the SQL.
Which tool is used for these animations
Please make a detailed roadmap for Android development
Can you teach us how we can make these animations??
How do you all create these diagrams?
best summarize view. Gave much better intro.
Won't call this a "Roadmap"!
why not ?
More of a snippet
I go out of my way to use .json or .csv for everything just to not learn sql.
Why CRUD(Create, Delete, Rename(Read?), Update) is into DDL? lenguaje de DEFINITION de datos
Create read update delete
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!
Please provide us with a learning map IT support and Cybersecurity
Sir make video about Twitter(X) system design
A video on how to learn AI would be amazing
SQL 4 life :)
1:59 You forgot the value for age :)
SQL is the most important language to master
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.
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!
Roadmap? To learn SQL? LOLOLOL what level of degradation we are?)