Roadmap for Learning SQL
ฝัง
- เผยแพร่เมื่อ 31 พ.ค. 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!
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?
Como siempre... Lo mejor!!! ❤ Gracias!
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 use SQL in data analysis, it is powerful when combined with Excel!
Excelente vídeo de introdução, direto e preciso !
You inspired me to create such explainer videos. Keep up. Great video as always
Subscribed :-)
great choice to advance the sound level, I can hear your videos better now.
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
which software do you use to make the dynamic flow diagram?
Animation is just awesome 👍🏻
this guy knows how to intimidate newbies with all the graphics, if i didnt know sql i would be terrified looking at all those
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
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.
Awesome !
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!
What tool do you use for generating this diagrams ?
Extremely useful and perfect for my adhd brain, thx
Tell me about the software used to create animations in your video. Thank you.
I'm curious, what tool do you use to create your videos??
Thank you!
Thanks a ton for this video
Very useful!
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"
7k+...Thanks. Great Video !!!
Great video 👏👏👏👏
Очень хорошее видео. Рассказать о базовых принципах SQL за 5 минут не каждому дано.
Such valuable content
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
What about SurrealDB? 😊
How do you all create these diagrams?
the video should be named learn SQL in 5 minutes.
nice cover for the SQL.
Can you talk about stack and pointers in memory?
🔴Please do a video about CQL like this.
Can you teach us how we can make these animations??
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
Why CRUD(Create, Delete, Rename(Read?), Update) is into DDL? lenguaje de DEFINITION de datos
Create read update delete
Nice Effect
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
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
Love ❤
Won't call this a "Roadmap"!
why not ?
More of a snippet
Please provide us with a learning map IT support and Cybersecurity
best summarize view. Gave much better intro.
Which tool is used for these animations
its in the info
A video on how to learn AI would be amazing
I go out of my way to use .json or .csv for everything just to not learn sql.
Sir make video about Twitter(X) system design
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!
SQL 4 life :)
1:59 You forgot the value for age :)
you look like neural network
SQL is the most important language to master
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?)