Roadmap for Learning SQL

  Рет қаралды 476,556

ByteByteGo

ByteByteGo

Күн бұрын

Пікірлер: 157
@jong.4864
@jong.4864 7 ай бұрын
Man, this guy is pumping these vids out! Way to go Byte
@panic_seller
@panic_seller 7 ай бұрын
Subqueries is SQL's most powerful tool, infact if you can consistently write correct subqueries, you should be a master in SQL
@MrYerak5
@MrYerak5 7 ай бұрын
You can also crash the database if you do it right
@mileselam641
@mileselam641 7 ай бұрын
CTEs > subqueries More composable, easily debuggable, more flexible, easier to read, and easier to write.
@shadowspyes
@shadowspyes 7 ай бұрын
@@mileselam641yet not as optimized
@MrNortySpock
@MrNortySpock 7 ай бұрын
@@shadowspyes CTE optimization behavior is database-specific, some databases can optimize with and around CTEs just fine.
@mileselam641
@mileselam641 7 ай бұрын
@@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.
@icns01
@icns01 7 ай бұрын
Short, high speed revision of the key concepts...Nice!👍
@lenzrun
@lenzrun 7 ай бұрын
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! 😊
@marksto6581
@marksto6581 7 ай бұрын
Thanks for the SQL basics coverage! Advanced topics may include: UNION queries, CTE / WITH queries, Triggers and Stored Procedures, etc.
@mileselam641
@mileselam641 7 ай бұрын
Those are all still part of SQL basics. Triggers and stored procedures are intermediate at best. :-)
@vjlxmi7039
@vjlxmi7039 6 ай бұрын
​@@mileselam641 then what would be the advanced topics?
@MikeTosno
@MikeTosno 7 ай бұрын
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
@RobertPodosek 7 ай бұрын
It's ByteByteGo lol.. if you're read a single one of their newsletters there's typos all over the place.
@bulatmsk
@bulatmsk 7 ай бұрын
The scheme in the start of video - is cool!
@IsraelOguche-n3f
@IsraelOguche-n3f Ай бұрын
This video reduced the tension I've been encountering while learning SQL, simplifies my learning experience
@jmarrero1108
@jmarrero1108 6 ай бұрын
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.
@SallyMwalrMusic
@SallyMwalrMusic 7 ай бұрын
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
@cesarb2679
@cesarb2679 4 ай бұрын
1:47 on the query the right table is not called "Products" but "Orders"
@-Hussainnn
@-Hussainnn 6 ай бұрын
I use SQL in data analysis, it is powerful when combined with Excel!
@theyreminisceoverus
@theyreminisceoverus 5 ай бұрын
Thank you so much for this. You have no idea of how much you covered in less than 5 minutes. Kudos!!
@lucatsf
@lucatsf 7 ай бұрын
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
@stevefrandsen7897 6 ай бұрын
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
@lucatsf 6 ай бұрын
@@stevefrandsen7897 Yeah, that's true. Thanks for the comment!
@ffred80
@ffred80 5 ай бұрын
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 .
@ZMSQLDATACorner-k3h
@ZMSQLDATACorner-k3h 2 күн бұрын
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
@ByteBite101
@ByteBite101 7 ай бұрын
You inspired me to create such explainer videos. Keep up. Great video as always
@gradientO
@gradientO 7 ай бұрын
Subscribed :-)
@icns01
@icns01 7 ай бұрын
An excellent summary and review of all the key SQL concepts AFTER you have learnt them...this is not for starters...imho.
@osoriomatucurane9511
@osoriomatucurane9511 4 ай бұрын
That is true. I could not agree anymore!
@janardannn
@janardannn 7 ай бұрын
this guy knows how to intimidate newbies with all the graphics, if i didnt know sql i would be terrified looking at all those
@W3Fi
@W3Fi 3 ай бұрын
I am wondering if you teach a whole course. In your 5-minute video, you articulated the entire SQL alphabet. It was impressive.
@Unlikelyjellyfish
@Unlikelyjellyfish 7 ай бұрын
Love the content! @2:13, the table on the bottom should be ‘Orders’. Also DATEADD needs paren @2:51
@wrona1993
@wrona1993 7 ай бұрын
Also right table at 1:55 should be "Orders"
@GambillDataEngineering
@GambillDataEngineering 5 ай бұрын
Great job packing in so much information in under 5 min!
@rasdan1192
@rasdan1192 3 ай бұрын
Damn, I knew I should've see roadmaps when learning new programming language. It makes things easier...
@СергейКондулуков-з9ч
@СергейКондулуков-з9ч 7 ай бұрын
Очень хорошее видео. Рассказать о базовых принципах SQL за 5 минут не каждому дано.
@Avegeania
@Avegeania 5 ай бұрын
Add CTE's and temp tables aswell. They'll just save you some time on repetitive code.
@vivekravi827
@vivekravi827 7 ай бұрын
Can you talk a bit about the scope of Procedural SQL, Triggers and hierarchical queries
@JohnS-er7jh
@JohnS-er7jh 5 ай бұрын
best infographics I have found that explains various tech topics. great job.
@josh-cent
@josh-cent 15 күн бұрын
What I've been studying for over 16hs in 2 days, he resumed in less than 5min
@mohamadnourbader1068
@mohamadnourbader1068 7 ай бұрын
great choice to advance the sound level, I can hear your videos better now.
@tomasmichek5842
@tomasmichek5842 5 ай бұрын
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!
@AffyBoy
@AffyBoy 2 ай бұрын
superb video : t=112 should it be orders table and not products table ? ...
@mdivyakanth
@mdivyakanth 4 ай бұрын
no intro.. no bs ... just straight to the point. ..... think about the children
@osoriomatucurane9511
@osoriomatucurane9511 4 ай бұрын
Awesome tutorial, crystal clear and concise.
@omarjimenez996
@omarjimenez996 7 ай бұрын
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
@ahounoufolabithierry5235 7 ай бұрын
Maybe Adobe Illustrator and After Effects as stated in the description
@ГеоргийТрубецкой-л2щ
@ГеоргийТрубецкой-л2щ 3 ай бұрын
Learn administration (DBA) part and developer's path are different things. This is not just about SQL learning.
@YazanAbdalghani-hk9kv
@YazanAbdalghani-hk9kv 6 ай бұрын
the video should be named learn SQL in 5 minutes. nice cover for the SQL.
@7X24Gamer
@7X24Gamer 7 ай бұрын
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
@resistentemente 7 ай бұрын
It's in the description bro!
@abhisheaksaraswat-ib1of
@abhisheaksaraswat-ib1of 6 ай бұрын
@@resistentemente, where? I think tool name is mentioned only, but how we can create the same, I tried but no success
@BINOOT
@BINOOT 2 ай бұрын
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
@zainuddinbrahim4625
@zainuddinbrahim4625 7 ай бұрын
Thanks, i am starting to learn it bit by bit
@SilentGamingDad
@SilentGamingDad 7 ай бұрын
Excelente vídeo de introdução, direto e preciso !
@AlchemistTasmi
@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
@sherlynhuso4363
@sherlynhuso4363 4 ай бұрын
I love the animation and the explanation is so clear 🥰👌
@anotherrandom1
@anotherrandom1 6 ай бұрын
Extremely useful and perfect for my adhd brain, thx
@mePrafull
@mePrafull Ай бұрын
Great animation! thank you!
@digitalindiahub
@digitalindiahub Ай бұрын
what tool is this to draw such awesome flow chart ? I really want to use it for architecture diagram
@RamVelagala
@RamVelagala 7 ай бұрын
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
@ravindranaths513
@ravindranaths513 7 ай бұрын
Could you please make a video on Wide column vs column family vs columnar vs column oriented DB
@drancerd
@drancerd 7 ай бұрын
Como siempre... Lo mejor!!! ❤ Gracias!
@sourabhbagade3538
@sourabhbagade3538 7 ай бұрын
Animation is just awesome 👍🏻
@NowayJustgoaway-v8m
@NowayJustgoaway-v8m 2 ай бұрын
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.
@TwoTeaTee
@TwoTeaTee 7 ай бұрын
Won't call this a "Roadmap"!
@The0Yapster
@The0Yapster 7 ай бұрын
why not ?
@InsightByte
@InsightByte 7 ай бұрын
More of a snippet
@itcommunity7600
@itcommunity7600 6 ай бұрын
Please provide us with a learning map IT support and Cybersecurity
@trongphucnguyen3829
@trongphucnguyen3829 7 ай бұрын
Tell me about the software used to create animations in your video. Thank you.
@Phuongang-ti6ch
@Phuongang-ti6ch 7 ай бұрын
Can you talk about stack and pointers in memory?
@indramal
@indramal 7 ай бұрын
🔴Please do a video about CQL like this.
@mounikakulkarni1115
@mounikakulkarni1115 4 ай бұрын
In DDL it's (Create, drop, alter, truncate, comment, rename) instead of (create, delete, update, rename) please update your diagram.
@TheViral_fyp
@TheViral_fyp 3 ай бұрын
R u preparing for Gate ?
@DmitriiBaranov-ib3kf
@DmitriiBaranov-ib3kf 7 ай бұрын
What about SurrealDB? 😊
@naveenverma2951
@naveenverma2951 7 ай бұрын
best summarize view. Gave much better intro.
@chirantans2162
@chirantans2162 2 ай бұрын
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!!
@Spartan-v1i
@Spartan-v1i 6 ай бұрын
Sir make video about Twitter(X) system design
@CastorPolux74
@CastorPolux74 25 күн бұрын
Excelente sumario.
@emotionalmindedstate
@emotionalmindedstate 5 ай бұрын
Но чтобы ползоваться SQL вам надо где лежат определённые данные. А что если вы не знаете где эти данные лежат и как выглядят?
@maxvaessen
@maxvaessen 7 ай бұрын
Very useful!
@jopadjr
@jopadjr 6 ай бұрын
7k+...Thanks. Great Video !!!
@Jerrel.A
@Jerrel.A 6 ай бұрын
Awesome! Thank You.
@MaheshJoshi_wellington
@MaheshJoshi_wellington 7 ай бұрын
Awesome !
@muhammadabbas9605
@muhammadabbas9605 5 ай бұрын
great job!
@abhisheaksaraswat-ib1of
@abhisheaksaraswat-ib1of 7 ай бұрын
Can you teach us how we can make these animations??
@pradeepkumarreddykondreddy7048
@pradeepkumarreddykondreddy7048 20 күн бұрын
Where is the roadmap ?
@Amit-hb9ex
@Amit-hb9ex 7 ай бұрын
Please make a detailed roadmap for Android development
@mihirpmehta
@mihirpmehta 7 ай бұрын
What tool do you use for generating this diagrams ?
@davidalves8839
@davidalves8839 2 ай бұрын
useful and beautiful 🤩👍
@PedramNG
@PedramNG 4 ай бұрын
how did you make that mindmap?
@raviss98
@raviss98 7 ай бұрын
Thanks a ton for this video
@RobinDublin
@RobinDublin 4 ай бұрын
Which software he uses to make the first diagram that he made ...can someone tell me ??
@toringoy
@toringoy 6 ай бұрын
which software do you use to make the dynamic flow diagram?
@tonym5857
@tonym5857 7 ай бұрын
Great video 👏👏👏👏
@toskito123
@toskito123 7 ай бұрын
Such valuable content
@abduvosidmalikov
@abduvosidmalikov 4 ай бұрын
Wait, you just joined without JOIN?! I think I'm gonna subscribe
@liberationexpressions
@liberationexpressions 6 ай бұрын
How do you all create these diagrams?
@nikkananda
@nikkananda 6 ай бұрын
I'm curious, what tool do you use to create your videos??
@raj_kundalia
@raj_kundalia 7 ай бұрын
Thank you!
@michaszalast6094
@michaszalast6094 5 ай бұрын
very good, but way too fast. thanks!
@jameshewitson6461
@jameshewitson6461 5 ай бұрын
Do you have a roadmap for python?
@MyWatermelonz
@MyWatermelonz 7 ай бұрын
I go out of my way to use .json or .csv for everything just to not learn sql.
@asht9193
@asht9193 7 ай бұрын
Which tool is used for these animations
@NyawttyClips
@NyawttyClips 6 күн бұрын
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
@chhavimanichoubey9437
@chhavimanichoubey9437 2 ай бұрын
the f man years of knowledge in minutes
@trytofindareasonwhy
@trytofindareasonwhy 5 ай бұрын
Amazing
@jorge.orozco
@jorge.orozco 7 ай бұрын
Why CRUD(Create, Delete, Rename(Read?), Update) is into DDL? lenguaje de DEFINITION de datos
@MrSumkinFedor
@MrSumkinFedor 7 ай бұрын
Create read update delete
@vovk_oleg
@vovk_oleg 12 күн бұрын
Perfect
@ShaheenGhiassy
@ShaheenGhiassy 7 ай бұрын
A video on how to learn AI would be amazing
@vnit4security
@vnit4security 7 ай бұрын
Nice Effect
@learnfromthegoat
@learnfromthegoat 6 ай бұрын
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!
@nourabdelahmid361
@nourabdelahmid361 4 ай бұрын
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!
@marsha3243
@marsha3243 2 ай бұрын
do u have suggestions on wheres best to create projects?
@CodingWorldHere
@CodingWorldHere 6 ай бұрын
Love ❤
@ammarasu3658
@ammarasu3658 5 ай бұрын
Comment from the terminal
@arpit1212
@arpit1212 Ай бұрын
how can someone miss he is use pokemon names.
@saitaro
@saitaro 7 ай бұрын
1:59 You forgot the value for age :)
@richardduncan3403
@richardduncan3403 7 ай бұрын
SQL 4 life :)
@michelvandermeiren8661
@michelvandermeiren8661 7 ай бұрын
SQL is the most important language to master
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Decomplexify
Рет қаралды 2 МЛН
Муж внезапно вернулся домой @Oscar_elteacher
00:43
История одного вокалиста
Рет қаралды 5 МЛН
小路飞还不知道他把路飞给擦没有了 #路飞#海贼王
00:32
路飞与唐舞桐
Рет қаралды 86 МЛН
За кого болели?😂
00:18
МЯТНАЯ ФАНТА
Рет қаралды 2,9 МЛН
APIs Explained (in 4 Minutes)
3:57
Exponent
Рет қаралды 1 МЛН
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2,2 МЛН
Introduction to SQL and duckdb (theory)
13:15
AIgineer
Рет қаралды 120
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Anton Putra
Рет қаралды 200 М.
Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)
16:48
SQL Tutorial for Beginners
44:57
Kevin Stratvert
Рет қаралды 2,2 МЛН
Database Roadmap 2024 | الدليل الشامل لقواعد البيانات
19:52