Roadmap for Learning SQL

[@jong.4864]

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

[@lenzrun]

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! 😊

[@icns01]

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

[@bulatmsk]

The scheme in the start of video - is cool!

[@jmarrero1108]

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.

[@theyreminisceoverus]

Thank you so much for this. You have no idea of how much you covered in less than 5 minutes. Kudos!!

[@panic_seller]

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.

[@cesarb2679]

1:47 on the query the right table is not called "Products" but "Orders"

[@IsraelOguche-n3f]

This video reduced the tension I've been encountering while learning SQL, simplifies my learning experience

[@lucatsf]

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]

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]

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

[@ffred80]

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 .

[@SallyMwalrMusic]

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

[@MikeTosno]

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.

[@ByteBite101]

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

[@gradientO]

Subscribed :-)

[@GambillDataEngineering]

Great job packing in so much information in under 5 min!

[@marksto6581]

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]

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

[@-Hussainnn]

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

[@BINOOT]

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

[@JohnS-er7jh]

best infographics I have found that explains various tech topics. great job.

[@rasdan1192]

Damn, I knew I should've see roadmaps when learning new programming language. It makes things easier...

[@danfu6280]

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!

[@Unlikelyjellyfish]

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"

[@osoriomatucurane9511]

Awesome tutorial, crystal clear and concise.

[@jamesdoerr4318]

I want to learn databases. This was an excellent presentation.

[@W3Fi]

I am wondering if you teach a whole course. In your 5-minute video, you articulated the entire SQL alphabet. It was impressive.

[@sherlynhuso4363]

I love the animation and the explanation is so clear 🥰👌

[@drancerd]

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

[@SilentGamingDad]

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

[@zainuddinbrahim4625]

Thanks, i am starting to learn it bit by bit

[@mePrafull]

Great animation! thank you!

[@janardannn]

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

[@icns01]

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

[@osoriomatucurane9511]

That is true. I could not agree anymore!

[@digitalindiahub]

what tool is this to draw such awesome flow chart ? I really want to use it for architecture diagram

[@tomasmichek5842]

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!

[@sourabhbagade3538]

Animation is just awesome 👍🏻

[@anotherrandom1]

Extremely useful and perfect for my adhd brain, thx

[@mohamadnourbader1068]

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

[@davidalves8839]

useful and beautiful 🤩👍

[@omarjimenez996]

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

[@mdivyakanth]

no intro.. no bs ... just straight to the point. ..... think about the children

[@tonym5857]

Great video 👏👏👏👏

[@СергейКондулуков-з9ч]

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

[@liquid_data25]

That's great content!

[@Avegeania]

Add CTE's and temp tables aswell. They'll just save you some time on repetitive code.

[@vivekravi827]

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

[@huili1920]

awsome content

[@josh-cent]

What I've been studying for over 16hs in 2 days, he resumed in less than 5min

[@7X24Gamer]

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

[@jopadjr]

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

[@ravindranaths513]

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

[@muhammadabbas9605]

great job!

[@AlchemistTasmi]

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

[@NowayJustgoaway-v8m]

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.

[@DmitriiBaranov-ib3kf]

What about SurrealDB? 😊

[@toskito123]

Such valuable content

[@Jerrel.A]

Awesome! Thank You.

[@ZMSQLDATACorner-k3h]

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

[@maxvaessen]

Very useful!

[@YazanAbdalghani-hk9kv]

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

[@nikkananda]

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

[@Vivek_Vlogs_Bxr]

which software is used to create video for youtube?

[@AffyBoy]

superb video : t=112 should it be orders table and not products table ? ...

[@mihirpmehta]

What tool do you use for generating this diagrams ?

[@chirantans2162]

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!!

[@CastorPolux74]

Excelente sumario.

[@raviss98]

Thanks a ton for this video

[@trongphucnguyen3829]

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

[@Phuongang-ti6ch]

Can you talk about stack and pointers in memory?

[@toringoy]

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

[@asht9193]

Which tool is used for these animations

[@saabiriinmiremohamed]

thanks teacher

[@PedramNG]

how did you make that mindmap?

[@RobinDublin]

Which software he uses to make the first diagram that he made ...can someone tell me ??

[@liberationexpressions]

How do you all create these diagrams?

[@MaheshJoshi_wellington]

Awesome !

[@indramal]

🔴Please do a video about CQL like this.

[@RamVelagala]

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

[@abhisheaksaraswat-ib1of]

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

[@ГеоргийТрубецкой-л2щ]

Learn administration (DBA) part and developer's path are different things. This is not just about SQL learning.

[@raj_kundalia]

Thank you!

[@abduvosidmalikov]

Wait, you just joined without JOIN?! I think I'm gonna subscribe

[@chhavimanichoubey9437]

the f man years of knowledge in minutes

[@rishiraj2548]

In thumbnail, "filter inside group-by" has wrong connection. 😢

[@TwoTeaTee]

Won't call this a "Roadmap"!

[@The0Yapster]

why not ?

[@InsightByte]

More of a snippet

[@learnfromthegoat]

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!

[@emotionalmindedstate]

Но чтобы ползоваться SQL вам надо где лежат определённые данные. А что если вы не знаете где эти данные лежат и как выглядят?

[@pradeepkumarreddykondreddy7048]

Where is the roadmap ?

[@Amit-hb9ex]

Please make a detailed roadmap for Android development

[@trytofindareasonwhy]

Amazing

[@jameshewitson6461]

Do you have a roadmap for python?

[@itcommunity7600]

Please provide us with a learning map IT support and Cybersecurity

[@vnit4security]

Nice Effect

[@mounikakulkarni1115]

In DDL it's (Create, drop, alter, truncate, comment, rename) instead of (create, delete, update, rename) please update your diagram.

[@TheViral_fyp]

R u preparing for Gate ?

[@jorge.orozco]

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

[@MrSumkinFedor]

Create read update delete

[@saitaro]

1:59 You forgot the value for age :)

[@MyWatermelonz]

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

[@Spartan-v1i]

Sir make video about Twitter(X) system design

[@ShaheenGhiassy]

A video on how to learn AI would be amazing

[@naveenverma2951]

best summarize view. Gave much better intro.

[@vovk_oleg]

Perfect

[@ammarasu3658]

Comment from the terminal