An easier way to explain indexing is to compare it to a book. A book has an index page that shows where to find the topics in a book. So, instead of you going through the entire book to find the topic you're looking for; the index page helps you know where exactly that topic is. Saving you time. Therefore, same thing with SQL queries.
@MM-jr5sr
Жыл бұрын
This was a really good comparison,👌🏽
@TuanNguyen-ed9rb
9 ай бұрын
I have to disagree with you, your example is intuitive, but it doesn't explain how and why index is fast. Although index has fewer pages than actual table, but what if your table is huge, and index from this table has a lot of pages? it is still slow (of course faster than scan the whole table) to scan all the pages in the index. And in SQL Server, there is a type of index called clustered index, which stores the whole table data in it instead of a seoarate structure beside table data, so it is basically your book with all the pages and no index section. Other point is indexes are stored on disk just like table data, so no hardware advantage. What make index fast is how the data is stored, data is stored in B+ tree structure, which make seek operators fast.
@femikomolafe5604
Жыл бұрын
My name is Femi from Nigeria. I love data analysis because it's enables organizations/businesses get better understanding of its data and make informed decisions with it.
@bryantbimboadeyemo9869
Жыл бұрын
🇳🇬
@LaMeeLifestyle
Жыл бұрын
🇳🇬
@LaMeeLifestyle
Жыл бұрын
🇳🇬
@vice-108
Жыл бұрын
Who asked?
@umunnahgentle6440
Жыл бұрын
❤
@angelacatherine3752
Жыл бұрын
My name is Angela from Nigeria. watching your video has really helped me a lot in my career as a data analyst. Though am taking courses on coursera yet i come to watch your video for more clarity. Thanks Alex.
@nategraham3980
Ай бұрын
Yes o! So helpful! Thank you!
@J3r_B3ar
8 ай бұрын
This is, by far, the greatest Content Creator I've ever found. I'm not exactly a techie, but to avoid ending up on a soup line, I've been learning marketable skills. It's not so common for an individual to be both well-versed in dense techie topics & able to explain it in a brief, understandable, and practical way, but damn, Alex the Analyst... *Thank you*. (No, I wasn't given anything to write this, but am compelled to do so after viewing ATA's content versus those of others, which can be laughably unclear).
@arpsri9675
Жыл бұрын
Nothing can compete Microsoft Excel. It may look not fancy, but superb functionality
@jovialbivouacker99
Жыл бұрын
Hello Alex, I just found out about your channel, and I am impressed with what I have seen thus far. I’m currently studying: CompTia A+, Network +, and Security +, in hopes of changing careers from elementary education to the IT industry. Thanks for all the great information! Jalapeños!😊
@jonathanojesebholo5792
2 ай бұрын
Hello, my name is Jonathan from Nigeria. This is my last class with Alex on SQL, I watch all his videos so I’m happy to be here.
@oluwayemisiawofuye9456
Жыл бұрын
Hi! So happy to be joining. Yemi from Nigeria. I decided to make a 360 degree shift from a completely different field to tech so I get to know more and grow in the data analytics. Hoping to have a substantial amount of knowledge of SQL as a beginner.
@MinChibuikeOkoli
Жыл бұрын
Hi Yemi can we connect I'm also starting a data analysis career....so we could learn together...
@oluwayemisiawofuye9456
Жыл бұрын
@@MinChibuikeOkoli Sure, it would be a pleasure.
@cynthiaokechukwu4829
Жыл бұрын
Hi Femi, i just came across this video today and going through the comments i saw yours and chibuike’s. I wouldnt mind going the team as i making shift too from a totally different career. Hope you dont mind?
@oluwayemisiawofuye9456
Жыл бұрын
@@cynthiaokechukwu4829 Hi Cynthia, that would be a great idea. How do we go about connecting? Awaiting Chibuike's reply also.
@oluwayemisiawofuye9456
Жыл бұрын
@@MinChibuikeOkoli Hello Chibuike, how do we connect?
@MoonFrogg
Жыл бұрын
21:55 was such a helpful explanation to better understand what a join does when connecting IDs! love the video! and 53:30 is also super important and good to know for understanding employer expectations!
@BHS_Africa_Pod
Жыл бұрын
Thank yu so much for having this up. I love data and facts, it makes the world go round.
@mfk143
Жыл бұрын
Easy as you like it..sleek yet most effective...even slides are designed and curated in a way that explain almost everything related to the topic at first glance...you are the champ bro...
@abideenabisola7908
Жыл бұрын
Even if i have any difficulty understanding what our tutor says, I'm always running to Alex videos, funny enough, he recommended his video for us some days ago😊
@lavatr8322
Жыл бұрын
HOLY SHIET! This is PHENOMENAAL
@tnntts
Жыл бұрын
from Myanmar, Thank you very much for the channel!!!
@the_reads
Жыл бұрын
Thanks for this all inspiring content. I’m watching from Sierra Leone 🇸🇱.
@AlexTheAnalyst
Жыл бұрын
Thanks for watching!
@BadThetan
9 ай бұрын
I am from Louisville Kentucky and I am taking SQL as part of my computer engineering degree
@roxi.onmyjourney
Жыл бұрын
New subscriber and this is my first video. Great content.
@gloriabukachi1
Жыл бұрын
Thank you for this good information. for Alex 👏
@nmcharis
Жыл бұрын
This was so informative, thank you CarreerFoundry and Alex!
@vietndk5437
11 ай бұрын
thank you for the video
@EmmanuelKola-y7o
Жыл бұрын
Dear Alex, thanks for the insight
@Watema23
10 ай бұрын
Alex, you are doing a great work. For me, I am kind refresh what I learnt from ATLytiCS boot camp .
@toluwalaseoluwadara6711
Жыл бұрын
Hello Alex, I am joining from Lagos,Nigeria.
@linksdeath
10 ай бұрын
Man this is amazing and compared to some of the things i did in c++ i can confidently do this! thank you for the reassurance!!!
@msnadavayah
11 ай бұрын
I am in the middle of the Data Analysis course with Coursera. This video has been a great way for me to further review the SQL portion of the course. Thanks for uploading.
@adeshmishra1671
Жыл бұрын
Thanks for this wonderful tutorial ❤
@hazzard9190
11 ай бұрын
Didnt know Frodo Baggins was born in 2001. Also, Thanks for the amazing content Alex !
@Triumphant_Christians
Жыл бұрын
I just watched the replay of this live session, all i can say is thank you Alex.
@nadrest
Жыл бұрын
Hello, I'm from Indonesia. Thank you Alex for making this tutorial. That is very good and easy to understand, this really helped me. 😊
@marylynkaka5733
6 ай бұрын
Thank you Alex!
@bhaskarsharma7815
Жыл бұрын
Why no time stamps ? Please update if possible
@deborahchepkoech8120
Жыл бұрын
This is resourceful. Thank you TEAM
@mahmoudelaraby1599
Жыл бұрын
Dude, you’re here to save the day, you don’t even need someone to ask for something you upload the most awesome content, was in the bank the other day and the banker asked me about DataAnalysis content i was just about to recommend your channel but the guy already knew your channel had the best content, Greeting from Egypt 🇪🇬, God bless you and your family Alex ♥️✨
@Shtompyfootwear
Жыл бұрын
*Dwight Shrute - Assistant to the Lead Baker* pure gold.
@TamilTop5
8 ай бұрын
Thanks for the content its a good starter for beginners
@forty313
10 ай бұрын
good work alex work on SQL
@AminatJaiyeola
11 күн бұрын
my name is jaiyeola aminat i love data analysis because anaything can happeng will be abale to solve problem easily eg problem like customer behavior analysis, product performance, financial analyst. etc
@tasoscat4295
Жыл бұрын
Tasos from Australia
@jacobbolmoses8541
4 ай бұрын
Learning in South Sudan 🇸🇸
@spotthespots7731
6 ай бұрын
Looking forward to learn SQL
@mayank1334
4 ай бұрын
Great presentation! Is there a link to the slides?
@otienooliver9557
Жыл бұрын
Oliver from Kenya
@daltonbay6295
Жыл бұрын
Please can I get the sheet to practice as I watch the video
@blse2000
7 ай бұрын
Amazing. Thank you
@nicholasnjoku4778
Жыл бұрын
My name Njoku Samuel joining from Nigeria. I am intersented in data analytics
@arifuzzamansumon6865
Жыл бұрын
Thanks Alex.
@Foodiehubnaija
11 ай бұрын
Great job ❤❤❤ thank you
@engr.naeemshahzad8795
Жыл бұрын
I am joining from Pakistan
@mzkhan1576
Жыл бұрын
thank you, Alex , for clearing most of my questions before jumping into the job market. Really enjoyed the whole video. Keep it Up.
@RonaldWest-q1e
11 ай бұрын
thank you for your job!
@randyriegel8553
5 ай бұрын
I started programming around 12 years old. I've been a software engineer for 20 years (C# and SQL mainly). In college I had to take Calculus and Statistics to get my CS degree. Waste of time! I've worked and major Banks and Insurance companies. I don't think I've did much above basic algebra. As long as you know the logic the computer will do it for you.
@alro7779
11 ай бұрын
13:23 What was the purpose of the 'AS salary' statement here? I don't quite understand the meaning of 'naming' an output as it is being used here, since 'AVG(salary)' could do the job, maybe? Awesome work you're doing here, Alex! Thanks!
@MapleSyrup473
10 ай бұрын
You don’t have to include the “AS salary”, but it’s good practice to explicitly define the column name when you use a function with “group by”. If you remove “AS salary” from the query it will still give you the same output, BUT the second column wouldn’t have a name (in SQL Server it would display “No Column Name” for the second column). Just a side note: In his example, it would’ve improved readability if he used “AS avg_salary” instead.
@alro7779
10 ай бұрын
@@MapleSyrup473 Thanks!
@morela948
9 ай бұрын
I really appreciate this video but it has a title that’s not quite right. The only thing that is advanced is window function and there is a very short mention about it.
@abdullahadekunlerasheed5132
Жыл бұрын
Please can I run all these code on PopSQL
@taisiyakaripidis9828
Жыл бұрын
Thanks for the video Alex! Where can I download the dataset to follow the steps? Did I miss this part?
@alexandre_lopes
Жыл бұрын
Hello Alex, the content is amazing. Congratulations! 31:13 Could you please recommend some tools to help me to identify the bottlenecks to optimize my queries? Thank you so much
@H.s.c-1
11 ай бұрын
thanks
@riyazahamed3608
2 ай бұрын
Is this enough for a fresher to enter data analyst field
@Aloevera_fh
9 ай бұрын
I really wanted to complete the course. But I use Mac M2. I think I am not having proper guideline about how to setup. I tried through docker and terminal command. It was going okay until my azure studio is not able to find my localhost and could not get connected. I wish I could get a solution of the pretty unknown problem.. :(
@mugomuiruri2313
11 ай бұрын
good.from africa
@parulsharma5259
Жыл бұрын
from where can i get this data set
@maryankorr3319
Жыл бұрын
will this be only available for a period of time or can i watch the rest another time?
@wiz32444
4 ай бұрын
I really I am Alex videos fun.
@OnlineUser-hv5ys
10 ай бұрын
Love from Pakistan 🙂🙂
@jacklion109
10 ай бұрын
Once we got to join and sbqueries I was sweating. When we got to window functions, I started crying T-T
@mugomuiruri2313
11 ай бұрын
what of statistics?
@ogunniranbenjamen5289
Жыл бұрын
❤
@azeezwahab5188
10 ай бұрын
I am Azeez Wahab Oloyede from Nigeria. Want to be a data analyst.
@abrilgonzalez7892
11 ай бұрын
is he using SQL Server Managment Studio?
@krneki6954
11 ай бұрын
part about windows functions is just bad. better skip it
@introvertwhiz-ll2ip
5 ай бұрын
This SQL video is a waste of time. If any beginner like me in sql has came here to learn sql then please find something else.
@tonyclinton7588
Жыл бұрын
🇳🇬
@zachjones2374
Жыл бұрын
Why are there no fucking captions!!!! 😭
@RemotePossibilities1
Жыл бұрын
Now, there are closed captions and a transcript. Maybe they just hadn't had time to generate at the time you watched?
@biscuit5876
Жыл бұрын
could you do something like this for python too? I'm struggling so much with python...
@alexhigginbotham8635
Жыл бұрын
I wish I could spend some time with this guy. I would put myself at probably an intermediate skill level with SQL which is one of my main functions in my job... but I have a lot to learn.
@SahilAnand-kn8ln
Жыл бұрын
❤
@zakhelembhele7046
Жыл бұрын
I honestly don't why the sudden fascination with data analytics. All I know is, it's getting crazier by the day. But with Alex I'm getting better and better!
@yasminibrahim9708
10 ай бұрын
Is this video enough for data analyst ???!
@Helloimtheshiieet
Жыл бұрын
Terrible examples, never ever ever ever use subqueries in WHERE clause
Пікірлер: 118