Man, this guy is pumping these vids out! Way to go Byte
@panic_seller7 ай бұрын
Subqueries is SQL's most powerful tool, infact if you can consistently write correct subqueries, you should be a master in SQL
@MrYerak57 ай бұрын
You can also crash the database if you do it right
@mileselam6417 ай бұрын
CTEs > subqueries More composable, easily debuggable, more flexible, easier to read, and easier to write.
@shadowspyes7 ай бұрын
@@mileselam641yet not as optimized
@MrNortySpock7 ай бұрын
@@shadowspyes CTE optimization behavior is database-specific, some databases can optimize with and around CTEs just fine.
@mileselam6417 ай бұрын
@@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.
@icns017 ай бұрын
Short, high speed revision of the key concepts...Nice!👍
@lenzrun7 ай бұрын
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! 😊
@marksto65817 ай бұрын
Thanks for the SQL basics coverage! Advanced topics may include: UNION queries, CTE / WITH queries, Triggers and Stored Procedures, etc.
@mileselam6417 ай бұрын
Those are all still part of SQL basics. Triggers and stored procedures are intermediate at best. :-)
@vjlxmi70396 ай бұрын
@@mileselam641 then what would be the advanced topics?
@MikeTosno7 ай бұрын
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.
@RobertPodosek7 ай бұрын
It's ByteByteGo lol.. if you're read a single one of their newsletters there's typos all over the place.
@bulatmsk7 ай бұрын
The scheme in the start of video - is cool!
@IsraelOguche-n3fАй бұрын
This video reduced the tension I've been encountering while learning SQL, simplifies my learning experience
@jmarrero11086 ай бұрын
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.
@SallyMwalrMusic7 ай бұрын
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
@cesarb26794 ай бұрын
1:47 on the query the right table is not called "Products" but "Orders"
@-Hussainnn6 ай бұрын
I use SQL in data analysis, it is powerful when combined with Excel!
@theyreminisceoverus5 ай бұрын
Thank you so much for this. You have no idea of how much you covered in less than 5 minutes. Kudos!!
@lucatsf7 ай бұрын
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.
@stevefrandsen78976 ай бұрын
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.
@lucatsf6 ай бұрын
@@stevefrandsen7897 Yeah, that's true. Thanks for the comment!
@ffred805 ай бұрын
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-k3h2 күн бұрын
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
@ByteBite1017 ай бұрын
You inspired me to create such explainer videos. Keep up. Great video as always
@gradientO7 ай бұрын
Subscribed :-)
@icns017 ай бұрын
An excellent summary and review of all the key SQL concepts AFTER you have learnt them...this is not for starters...imho.
@osoriomatucurane95114 ай бұрын
That is true. I could not agree anymore!
@janardannn7 ай бұрын
this guy knows how to intimidate newbies with all the graphics, if i didnt know sql i would be terrified looking at all those
@W3Fi3 ай бұрын
I am wondering if you teach a whole course. In your 5-minute video, you articulated the entire SQL alphabet. It was impressive.
@Unlikelyjellyfish7 ай бұрын
Love the content! @2:13, the table on the bottom should be ‘Orders’. Also DATEADD needs paren @2:51
@wrona19937 ай бұрын
Also right table at 1:55 should be "Orders"
@GambillDataEngineering5 ай бұрын
Great job packing in so much information in under 5 min!
@rasdan11923 ай бұрын
Damn, I knew I should've see roadmaps when learning new programming language. It makes things easier...
@СергейКондулуков-з9ч7 ай бұрын
Очень хорошее видео. Рассказать о базовых принципах SQL за 5 минут не каждому дано.
@Avegeania5 ай бұрын
Add CTE's and temp tables aswell. They'll just save you some time on repetitive code.
@vivekravi8277 ай бұрын
Can you talk a bit about the scope of Procedural SQL, Triggers and hierarchical queries
@JohnS-er7jh5 ай бұрын
best infographics I have found that explains various tech topics. great job.
@josh-cent15 күн бұрын
What I've been studying for over 16hs in 2 days, he resumed in less than 5min
@mohamadnourbader10687 ай бұрын
great choice to advance the sound level, I can hear your videos better now.
@tomasmichek58425 ай бұрын
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!
@AffyBoy2 ай бұрын
superb video : t=112 should it be orders table and not products table ? ...
@mdivyakanth4 ай бұрын
no intro.. no bs ... just straight to the point. ..... think about the children
@osoriomatucurane95114 ай бұрын
Awesome tutorial, crystal clear and concise.
@omarjimenez9967 ай бұрын
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?
@ahounoufolabithierry52357 ай бұрын
Maybe Adobe Illustrator and After Effects as stated in the description
@ГеоргийТрубецкой-л2щ3 ай бұрын
Learn administration (DBA) part and developer's path are different things. This is not just about SQL learning.
@YazanAbdalghani-hk9kv6 ай бұрын
the video should be named learn SQL in 5 minutes. nice cover for the SQL.
@7X24Gamer7 ай бұрын
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
@resistentemente7 ай бұрын
It's in the description bro!
@abhisheaksaraswat-ib1of6 ай бұрын
@@resistentemente, where? I think tool name is mentioned only, but how we can create the same, I tried but no success
@BINOOT2 ай бұрын
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
@zainuddinbrahim46257 ай бұрын
Thanks, i am starting to learn it bit by bit
@SilentGamingDad7 ай бұрын
Excelente vídeo de introdução, direto e preciso !
@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
@sherlynhuso43634 ай бұрын
I love the animation and the explanation is so clear 🥰👌
@anotherrandom16 ай бұрын
Extremely useful and perfect for my adhd brain, thx
@mePrafullАй бұрын
Great animation! thank you!
@digitalindiahubАй бұрын
what tool is this to draw such awesome flow chart ? I really want to use it for architecture diagram
@RamVelagala7 ай бұрын
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
@ravindranaths5137 ай бұрын
Could you please make a video on Wide column vs column family vs columnar vs column oriented DB
@drancerd7 ай бұрын
Como siempre... Lo mejor!!! ❤ Gracias!
@sourabhbagade35387 ай бұрын
Animation is just awesome 👍🏻
@NowayJustgoaway-v8m2 ай бұрын
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.
@TwoTeaTee7 ай бұрын
Won't call this a "Roadmap"!
@The0Yapster7 ай бұрын
why not ?
@InsightByte7 ай бұрын
More of a snippet
@itcommunity76006 ай бұрын
Please provide us with a learning map IT support and Cybersecurity
@trongphucnguyen38297 ай бұрын
Tell me about the software used to create animations in your video. Thank you.
@Phuongang-ti6ch7 ай бұрын
Can you talk about stack and pointers in memory?
@indramal7 ай бұрын
🔴Please do a video about CQL like this.
@mounikakulkarni11154 ай бұрын
In DDL it's (Create, drop, alter, truncate, comment, rename) instead of (create, delete, update, rename) please update your diagram.
@TheViral_fyp3 ай бұрын
R u preparing for Gate ?
@DmitriiBaranov-ib3kf7 ай бұрын
What about SurrealDB? 😊
@naveenverma29517 ай бұрын
best summarize view. Gave much better intro.
@chirantans21622 ай бұрын
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-v1i6 ай бұрын
Sir make video about Twitter(X) system design
@CastorPolux7425 күн бұрын
Excelente sumario.
@emotionalmindedstate5 ай бұрын
Но чтобы ползоваться SQL вам надо где лежат определённые данные. А что если вы не знаете где эти данные лежат и как выглядят?
@maxvaessen7 ай бұрын
Very useful!
@jopadjr6 ай бұрын
7k+...Thanks. Great Video !!!
@Jerrel.A6 ай бұрын
Awesome! Thank You.
@MaheshJoshi_wellington7 ай бұрын
Awesome !
@muhammadabbas96055 ай бұрын
great job!
@abhisheaksaraswat-ib1of7 ай бұрын
Can you teach us how we can make these animations??
@pradeepkumarreddykondreddy704820 күн бұрын
Where is the roadmap ?
@Amit-hb9ex7 ай бұрын
Please make a detailed roadmap for Android development
@mihirpmehta7 ай бұрын
What tool do you use for generating this diagrams ?
@davidalves88392 ай бұрын
useful and beautiful 🤩👍
@PedramNG4 ай бұрын
how did you make that mindmap?
@raviss987 ай бұрын
Thanks a ton for this video
@RobinDublin4 ай бұрын
Which software he uses to make the first diagram that he made ...can someone tell me ??
@toringoy6 ай бұрын
which software do you use to make the dynamic flow diagram?
@tonym58577 ай бұрын
Great video 👏👏👏👏
@toskito1237 ай бұрын
Such valuable content
@abduvosidmalikov4 ай бұрын
Wait, you just joined without JOIN?! I think I'm gonna subscribe
@liberationexpressions6 ай бұрын
How do you all create these diagrams?
@nikkananda6 ай бұрын
I'm curious, what tool do you use to create your videos??
@raj_kundalia7 ай бұрын
Thank you!
@michaszalast60945 ай бұрын
very good, but way too fast. thanks!
@jameshewitson64615 ай бұрын
Do you have a roadmap for python?
@MyWatermelonz7 ай бұрын
I go out of my way to use .json or .csv for everything just to not learn sql.
@asht91937 ай бұрын
Which tool is used for these animations
@NyawttyClips6 күн бұрын
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
@chhavimanichoubey94372 ай бұрын
the f man years of knowledge in minutes
@trytofindareasonwhy5 ай бұрын
Amazing
@jorge.orozco7 ай бұрын
Why CRUD(Create, Delete, Rename(Read?), Update) is into DDL? lenguaje de DEFINITION de datos
@MrSumkinFedor7 ай бұрын
Create read update delete
@vovk_oleg12 күн бұрын
Perfect
@ShaheenGhiassy7 ай бұрын
A video on how to learn AI would be amazing
@vnit4security7 ай бұрын
Nice Effect
@learnfromthegoat6 ай бұрын
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!
@nourabdelahmid3614 ай бұрын
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!
@marsha32432 ай бұрын
do u have suggestions on wheres best to create projects?