It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉
@papunmohanty5968
4 жыл бұрын
Thanks for all great videos... Your explanations are simple and awesome :)
@setudutta3905
4 жыл бұрын
You guys are amazing, the quality of videos and the actress in the video is at par with a professional TV show or a movie. Excellent explanation as well !!!
@philpeko1796
4 жыл бұрын
😱👍⚡Socratica, you nailed it! This is the SQL course I recommend every day to SQL beginners. 🎇💥🎆🖐👍🖖🤘
@maheshtambe9535
3 жыл бұрын
Wish you the best. You are awesome.
@mohammadsohelkhan7996
3 жыл бұрын
Please continue SQL video series with more SQL concepts. Big fan :)
@robertl30
5 жыл бұрын
I thoroughly enjoyed the 596,000 ms spent watching this video.
@enamh89
3 жыл бұрын
The hardship is impossible to put into words...
@unjordi
3 жыл бұрын
But it lasts over 900000!
@mcmaddie
3 жыл бұрын
You might want to re-check that.
@ahmeda8201
2 жыл бұрын
956,000 ms i guess
@thisisgangadhar
2 жыл бұрын
@@ahmeda8201 nope 596000k
@CristhianDalmazzo
3 жыл бұрын
Whoever writes these scripts deserves an award. As well as this lady for delivering the lines perfectly and giving this great performance. Education and entertainment at it's best.
@TheJupiteL
4 жыл бұрын
Maaan, I graduated college 3 years ago, learning from all kinds of tutors and lecturers, but never like crazy Cyber Doctor here. I feel scared, and educated
@smoothbeak
3 жыл бұрын
Haha, "crazy cyber doctor"!
@joncrosby1
Жыл бұрын
I have 20+ years in data analytics and IT and this is one of the best videos on indexes I have found. Thank you for making this so educational and fun at the same time! I'm excited to check out your python channel next!
@Socratica
Жыл бұрын
Thank you for your kind message! We're so glad you've found us!! 💜🦉
@salence99
Жыл бұрын
Could't agree more. Fantastic
@suryas5609
Жыл бұрын
@joncrosby1, Since you have 20+ years of experience, could you please guide me how to get a job in this field? I am a Computer Science graduate and want to go to Data Analytics (I dont want to be a hard core programming developer). I have learnt SQL, Basics of Python and Data Visualization tools like Tableau and also made some dashboard to learn properly. I need your advise on how to apply for data analytics job. Should I learn any more skills? like data warehousing or cloud? Please let me know. Thank you in Advance!
@roelandriemens
5 жыл бұрын
I remember a query that ran over six hours. Ever month again year after year. One day I checked the output and that query had run only a few minutes. I asked a colleague if there was a problem. She said 'O, i created an index.....'
@Bargains20xx
5 жыл бұрын
haha nice learning experience
@spmegaman1
3 жыл бұрын
Hahaha that's brilliant 😂
@CrazyBenlols13
3 жыл бұрын
How many entries and coloumns did the tables in the database had ? 6 hours seem crazy.
@googdriveforme4115
3 жыл бұрын
It took an year to get a solution for a slow running query.. ? 😂
@diegoguisasola3858
3 жыл бұрын
@@googdriveforme4115 we wasn't looking for one lol
@rajatsaha891
4 жыл бұрын
This couldn't be easier, crisper and more interesting. Simply enjoyable!!
@giseleshuri9469
4 жыл бұрын
i just love this lady a lot.
@thedev5603
3 жыл бұрын
Me tooo
@rayhan8701
3 жыл бұрын
me too
@shreehari2589
3 жыл бұрын
Me too
@ayencoscolfield3312
3 жыл бұрын
Same here, av falling in love with her videos ever since i discovered her channel
@vibhors
3 жыл бұрын
me too
@jameskeogh9452
5 жыл бұрын
At last, I can understand mySql. Explained perfectly in a way my brain can comprehend. I will definitely be donating to keep you guys going. Thank you so much.
@liljj2k10
3 жыл бұрын
I am with you on this one
@albusdumbeldoor3128
2 жыл бұрын
Me too
@parsonsmarcus
2 жыл бұрын
As Ulka said at the end of this video, use indexes wisely! A general rule of thumb for indexes is that adding indexes to a table will speed up selects (that are constructed correctly) and slow down inserts/updates/deletes because whatever SQL system you use has to rebuild those indexes if a modifying transaction occurs.
@racheltindoy
5 жыл бұрын
I love the enthusiasm, robotic fast (not boring) narration, clear and practical examples, and the visualization! Definitely subscribing!
@microsteps211
4 жыл бұрын
She deserves an Emmy's for the quality content production. Fantastic scripts, visual and sound effects, and best actress. Love the (7-min) interlude of classical music, hilarious you. Totally loving this! Thank you Socratica, you really are awesome and indispensable!
@hadibq
Жыл бұрын
Same here about the 7min 😄
@caio-jl6qw
Жыл бұрын
Totally agree... I just love the contents this channel puts out
@nwokolobueze7291
7 ай бұрын
what was the name of the prelude, shazam could not find it.
@H1TMANactual
3 жыл бұрын
I can't believe a video on sql has quarter million views. That speaks to the quality of this video
@rosenph
2 жыл бұрын
Unbelievable! The best SQL tutorial I have ever watched. It couldn't be shorter and clearer. I bet even a child or even my grandmother could be able to understand it.
@dhananjaywadhavane4106
4 жыл бұрын
10 min ago I never thought learning can be funny and interesting at this awesome level. Good job.
@abhishekdas2512
4 жыл бұрын
This is the channel I ve been waiting for long time. Thanks KZitem algorithm.
@johnhillescobar
5 жыл бұрын
Love the comedic way you use to teach. Please, do not stop doing it!!
@piyh3962
5 жыл бұрын
I'm a professional that spends all day querying and this is the first video that explained it concisely
@morsheddld
5 жыл бұрын
wow! This video worth a lot. B4 watching this i never knew index is this essential for faster performance. Well explained. Keep uploading such Videos. Animation were superb to understand quickly. God bless u.
@abhishekpaul6094
Жыл бұрын
Great video! One tip: Adding indexes to a table will speed up select commands but will also slow down other commands like insert/update/delete because the SQL server has to reconsider the indexes if any kind of modifying transaction occurs in the future.
@Akopyan
5 жыл бұрын
I can't believe i watched the video. i learned something. and totally enjoyed every second of it.
@asdfkjhlk34
5 жыл бұрын
This is the best coding channel I HAVE EVER SEEN!!!!!!!!!!!
@chevalier5691
5 жыл бұрын
I, hereby declare that Socratica is the obvious front-runner for the first channel to reach 100 billion subs.
@travischaplin6272
2 жыл бұрын
This was fantastic. Hands down the best online lessons I've watched.
@antoinebguitar2869
5 ай бұрын
ur such a life saver, i often dont understand immediately in class but those videos make me understand almost immediately, thats quality, appreciate it, wish ppl always invested this much time in teaching
@ameyapatil1139
3 жыл бұрын
Ita amazing how something can be made informational and enjoyable both at the same time !
@AndrewKlem
5 ай бұрын
Incredible. I've spent seven hours over the past two days refreshing myself on database concepts and filling in gaps and this was my favorite 10 minutes of those seven hours by a factor of 100 billion.
@yg713
3 жыл бұрын
I learned what I needed and laughed at the same time I was learning. Thank you for adding a lot of production value to the lesson.
@christopherpink842
2 жыл бұрын
WHAT A BLAST!!!!! I watched the whole tutorial, took notes I was literally hooked learnt a lot felt like watching a movie, the production and creation of this course is PRICELESS THANK YOU , wish there was a JavaScript course like this
@hamzasaleem6154
4 жыл бұрын
This is absolutely a fantastic video , I am subscribing This channel deserves number of subscribers that even the indexing will take time to count
@blackwhite2361
3 жыл бұрын
The reason why this channel hasn't hit a million yet beats me. It should have 10 million subs. The lady is very entertaining
@aurelitojunio7795
4 жыл бұрын
Wow, one of the best explanations I've ever seen. Congrats!
@SanamSindhooShaikh
4 жыл бұрын
you have no idea, how much you have helped me.. i have no words to say thanks .. it changed my whole DB speed .. thanks million ..
@sadowizzy1105
4 жыл бұрын
Must Amazing SQL Tutorial ... You Deserve More Than A Billion Subscribers
@obedmireku3137
2 жыл бұрын
This lady is on another level. You have taken KZitem to another level
@SteinGauslaaStrindhaug
5 жыл бұрын
Love how you're insisting on reading out all times in milliseconds like a programmer, even though the GUI already has converted it into more human digestible seconds and ms.
@FeLiNe418
4 жыл бұрын
It's to make it sounds that it really takes a lot of time because 4000 is bigger than 4.
@godwinshaibu6328
Жыл бұрын
I don't think any educational material has been as entertaining as this playlist I just watched... It's mind blowing!... Totally the best investment of my time!
@AzfarRizvi
4 жыл бұрын
"The hardship is impossible to put in words." 😍
@menglin7432
4 ай бұрын
Gotta say this is the clearest examples I've ever seen
@vero0992
5 жыл бұрын
Fantastic. I'm slightly familiar with SQL because I only very occasionally need to have certain data pulled by our DBAs. Very cool @ 7:25 - I had that question. Thanks Socratica.
@bablobko
4 жыл бұрын
Just fell in love with you after hearing your laughter.
@darrenleonard
3 жыл бұрын
This was great thanks! Just had a query that was taking 2 minutes to execute. I added in about 9 indexes and it now runs in 2 seconds. Gamechanger!
@avinash7154
5 жыл бұрын
woooow really interesting and the way of her teaching and animation was awesomee....upload more videos on sql ,clear explanation ........congrats
@TheGrizzlyKnight
11 ай бұрын
WOW My jaw is on the floor at how amazing this video is! Quality, tone and speed of voice is on point. Explanations are well thought out and provide all necessary context to comprehend. Video/Audio editing is perfect with just enough to keep it interesting and remove distractions.
@adarsh902
4 жыл бұрын
I really appreciate the effort you've put in the background sounds nd editing thereby making it very interesting.
@jelulululu
12 күн бұрын
i watched two other vids on indexing but finally understood from this, very clear and linear flow of explanation . thanks
@RockitMan-ey8tx
5 жыл бұрын
I love this series. Keep up the great work!
@arpitmahadule5501
4 жыл бұрын
The way teach or explain, Its best. Concepts just penetrate into mind. Took me 4050ms to write this😂😂
@bndissanayaka
3 жыл бұрын
"The hardship is impossible to put in to words!!!" 🤣🤣
@iosifpuha6114
Жыл бұрын
This is one of the best computer science videos I've seen in my career (I'm final year 2 at uni) and whole life also, you rock!
@jorjiang1
5 жыл бұрын
one day machine will talk like human, human like machine
@waitwhat7164
Жыл бұрын
Straight to the point unlike other tutorials. I only needed the concept really..
@DARKCOP2011
5 жыл бұрын
what about : SELECT COUNT(*) FROM person WHERE last_name = 'Mohanty', AND first_name = 'Ulka'; Result: ONE! and only ONE! Messages: Successfully run. We found the best teacher in earth and mars! Total query runtime: 0 msec.
@MelancholyMadoka
3 жыл бұрын
Did not expect this level of enthusiasm; not a complaint.
@STIVESification
5 жыл бұрын
Could you please tell the Socratica to make new series of topology, or any high math
@michalkubecka9045
Жыл бұрын
This is quite a goofy video but at the end I learned everything I needed unlike from watching other videos on this topic by different content creators. Thank you for such a great video.
@sachunjyo
4 жыл бұрын
Fantastic job girl... Well explained... We learn the most when we are having fun... And you have successfully turned SQL into fun.... Love the craziness
@willgeo
4 жыл бұрын
I have never seen anyone make sql this interesting, am literally watching things i already know and use almost on a daily, but literary enjoying each and video.
@Socratica
4 жыл бұрын
You have no idea how happy this makes us! 💜🦉
@woolfel
5 жыл бұрын
You should show query planner to illustrate how RDBMS determines which query plan to use. I'm guess that is already on your list of things to cover. After that, you should cover lock escalation under concurrent load where you have a mix of reads/writes on the same table. Then for the advanced SQL indexing concepts, compare b-tree versus bitmap indexes. If you get to report queries materialized views versus dynamic views for complex multi-dimensional queries :)
@mindfree198
3 жыл бұрын
I have never learned anything so quickly in my life. Awesome Video.
@Socratica
3 жыл бұрын
This was the best compliment we could ever get. THANK YOU!! This really inspires us to make more videos. 💜🦉
@iTurkiQ
5 жыл бұрын
One of the greatest explanations I've ever seen! Well done! Anybody knows the name of the piano music? 8:11
@oliviergobet9408
4 жыл бұрын
"Quasi una fantasia" (Moonlight Sonata) by Beethoven
@alen7717
5 ай бұрын
tomorrow I have an interview and it is the best video i could find for indexing. thank you so much :)
@edvzig
5 жыл бұрын
Extremely helpful video, thanks
@narendranomprakash7984
2 жыл бұрын
This was one of the most fun tutorials I have watched in my life.
@koungmeng
5 жыл бұрын
all in RAM
@deleater
5 жыл бұрын
EVERY SINGLE COLUMN...YESSS! xD
@danielsandor8738
4 жыл бұрын
Not a big deal.
@architadesai7876
4 жыл бұрын
She couldn't get more informative, entertaining and funny and interesting! Although still she does in her other videos!
@oliverkaunds
3 жыл бұрын
Thank you for such an amazing explanation. I have one question though, the index you created was that a clustered index or a non-clustered one?
@abdiwahabadan4722
3 жыл бұрын
THIS is amazing work of serving humanity sister thank you i appreciate your work from @somalia
@shawntv7130
4 жыл бұрын
The typing effects music makes me feel like I'm in a game.
@ashwinpande7095
2 жыл бұрын
Best tutorial series on SQL HANDS. DOWN.
@priscillaamorim88
5 жыл бұрын
Great video! How can I check if a database has index before running a query?
@robertl30
5 жыл бұрын
sp_helpindex Person.
@Anna36936
2 жыл бұрын
This playlist was GLORIOUS. Thank you!!!
@maciejk125
5 жыл бұрын
I dont know how you do it, but i watch this for entertainment.
@victordoshenko
3 жыл бұрын
Your laugh like a Dr.Evil is very exciting. I understand all profit of indexes perfectly!👌
@shortcutDJ
5 жыл бұрын
these are the best tutorials because they short and sweet just like my stamina in bed.
@jkk23-g7c
2 жыл бұрын
Holy cow, this intro is just fire. Really impressed
@spwim
4 жыл бұрын
did anybody else feel like yelling : "FIRE THE LASSEEEEERRRR"
@oliverkaunds
3 жыл бұрын
She is Dr. Evil's daughter 😂
@datanerden1057
8 ай бұрын
This is the most entertaining video about something so mundane as SQL indexing! 😆
@josuemedia
4 жыл бұрын
The level of sarcasm is just the right amount and amusing! Keep up the great work :)
@ezadviper
5 жыл бұрын
9:34 I can hear somebody BTS snickers ...
@Shah_Okay
3 жыл бұрын
First time I watched...this lady killed me with her technique, presentation and the way of teaching. Wow 👏😮
@the-mush
5 жыл бұрын
"Indexes"?? Ok, we declare war on Mars for despicable crimes against human language. Your sins would not go unpunished.
@MrBlastZone3000
4 жыл бұрын
grammarist.com/usage/indexes-indices/ Although you are right that it is used in the wrong context, it is not incorrect to say "indexes".
@Elitea20
4 жыл бұрын
Yes finally a decent video that is in English and understandable for human beings
@kirbymarchbarcena
5 жыл бұрын
Oh, that laugh @0:07!
@Nsuidara
5 жыл бұрын
or 9:29 xD
@kirbymarchbarcena
5 жыл бұрын
@@Nsuidara Oh,yeah, forgot that one which not even Rita Repulsa can do better.
@davidconnelly
Жыл бұрын
26 years in web development and I've never found a video tutorial, book or talk that explains what's happening under the hood when table indexes are created and used. That was a great video but the mystery continues. Does anybody out there have a clue what's going on under the hood with table indexes? PS, thanks for the video. It was really good.
@_Alpha8
2 жыл бұрын
lovely and smart...mindblowing... one semester of SQL just done... . i loved it !!!
@fredericksandalo8909
Жыл бұрын
amazing.... she can teach me SQL all the time any time every single time.
@anshulyadav314
3 жыл бұрын
First time saw such an impressive teaching methodology
@sunandasudheepthi2606
3 жыл бұрын
Why??? WHY KZitem WHYYYYYYYYYY??? Was I not recommended this channel before my semester end??? These videos are sooo awesome that I am learning SQL even after my semester end...... yep......I subscribed for more videos.....
@DavidBranson42
Жыл бұрын
First, I really think these videos do a great job of teaching their lessons. Second, I really appreciate your commitment to the bit.
@samjamez
Жыл бұрын
First video on 'Indexes' I watched, and I completely get it. Thanks a whole lot!
@Mr88stalker88
Жыл бұрын
High quality content, I actually learned something on KZitem video. Solid work, comparison, examples. And I love that John Williams easter egg
@AcheiversOfficial
3 жыл бұрын
I thought indexes was a very complicated topic and kept postponing it. Thank you. :-) .
@Socratica
3 жыл бұрын
It brings us SO much happiness to hear we are helping people. Thank you so much for sharing this - it really inspires us to make more videos!!
@MrArteez
Жыл бұрын
thanks for teaching me! also the humor was just the right amount of corny, which I appreciate a lot. Have a great day!
@KamranRShikhalizada
2 жыл бұрын
What was that? You nailed it! I assumed I was watching a movie and when it finished, I cried ))
@ibite100
10 ай бұрын
First place to go if you want to learn anything that this channel has a series on.
@albusdumbeldoor3128
2 жыл бұрын
The best sql lesson not like other dumb channels who always deliver the content in a non entertaining way which makes me soo bored sometimes I feel like i couldn't pay any intrest anymore. But with your channel that's not the case am freaking enjoying this a lot please keep doing videos on sql and database related stuff it will be so much helpful for me. And the lady who presented the video is exceptional and the video editings are soo good man and now I discovered what am been searching for for months thank you so much guys
@sorosw2980
3 жыл бұрын
Have to say that this is the only video I have seen that makes SQL seems fun to learn. Thank you!
@rusticHuman
2 жыл бұрын
Never seen this easy explanation. I really thank you for this. Keep going!!
@BrandonSalazar1257
3 жыл бұрын
Thanks, couldn't get the hang of indexes till I watched this video
Пікірлер: 1 М.