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!! 💜🦉
9:38 convert NULL quantity to ZERO. Here is the full code: SELECT s.supply_id, ISNULL(i.quantity,0) AS quantity, s.name, s.description FROM (SELECT * FROM inventory WHERE base_id = 1 ) AS i RIGHT JOIN supply AS s ON i.supply_id = s.supply_id ORDER BY s.supply_id ;
YA'LL ARE KILLING ME WITH THE HUMOR, I am seriously 10 seconds in and cracking up looking forward to learning the way yall deliver this information. THANKS A BILLION
Educational AND highly entertaining. Love her sense of humor and smile! Never have I clicked so fast for the next tutorial video. Great work Socratica and team! The supply descriptions are hilarious 😂 and the graphics & sound effects throughout the vid are superb!
She is a Fantastic teacher. Top work on the editing guys, I am a visual person and concepts are better understood visually. I would be glad if you guys can share the csv files for the martian course as well for us to practice.
THANK YOU for this awesome video series on SQL and especially JOINS! I've never had so much fun watching..........any coding video and this is such a blast. You guys rock for this.
I love the way they teach while having fun at the same time. In a short video, they explained all the three joins and sub-query, Alias as well. Thanks for this video.
Hello Ms Socratica, I am not kidding.. Even though I'm proficient in all computer science-related concepts, I am always confused with SQL Joins. You have explained things with soo much ease, I literally fell in love with you and your approach. I'm more confident with joins now in just 11 mins. Thank you soo much.
The way this was put together was perfect. I get so f-ing bored in class and have a hard time paying attention. THIS taught me more than in 1 hour of lecture. THANK YOU!
Wow! This Playlist is the best I've ever seen! Thanks so much! It's unbelievable how well this is done! Are you just geniuses or do you have a ridiculously high Budget? Amazing… really… absolutely amazing...
What a goofy, loony chick. I love it! And funny too. Makes it such a relaxed learning environment. The voice... the hypnotic, expressive eyes... the ease with which I've learned things thru these videos. What a great presentation. What a great teacher! Instead of just poking my way thru a basic 'How To' type of book until my very simple SQL usage does what I hope it to do, I'm actually learning stuff on how to do things correctly & efficiently. You, madam, are brilliant in your technique!
This lady is interesting to watch. Sometimes I catch myself smiling in between and then the other voice in my head would say "Common, I thought you were studying? So why the smiles ?" Hahaha. Thank you, Socratica.
Extremely well done. It is a little over the top but honestly you are explaining things none of the other vids have so far which were all the difference to me in understanding this concept. Thank you!!
Outstanding way to teach a subject. I have never seen anything close to this. There are many good videos all around but the vídeos of this young lady are really from another world.
One of the best methods for teaching. Examples are easy to understand and interesting. Even a child will love and learn these clips. Please continue what you're doing. Thank you.
Can you imagine if all education was themed like this? 😂😂. This is literally the most entertaining computer science video I've ever watched. "the reviews have been overwhelmingly online"😂😂😂😂
Socratica. This is extremely helpful. People one question: My professor said inner join woll cause problems by having cartesian product. How do I solve for it? And how would that ever happen?
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!! 💜🦉
still waiting...
あっくぇえええt387っq0っっっっくぁぱー⁰あpーああ⁰⁰あーーーあー1っq3q5い0
I love this woman's attitude and sense of humor and the content is also well taught... This channel definitely deserves more likes and subscribes
She's an sql master.
Such innovative style of teaching....I was scared of SQL joins till date...then I found Socratica!!
I like her doing these videos.
Second that
4 dislikes? I think they are from Mercury
16 at the moment, we got some extra-galactic activity from Andromeda
🤣🤣
Lol na they some dirty belters!! Mercurians are hot!! Leave them alone!! Lol. I watch too much tv. Lol
😭😭
😂
i love when someone teaches me like im the dumbest person on earth,like this :d
You joke, but that's the best way to drive home the fundamentals - the most important part
On Mars.
9:38 convert NULL quantity to ZERO. Here is the full code:
SELECT s.supply_id, ISNULL(i.quantity,0) AS quantity, s.name, s.description
FROM (SELECT * FROM inventory WHERE base_id = 1 ) AS i
RIGHT JOIN supply AS s
ON i.supply_id = s.supply_id
ORDER BY s.supply_id
;
YA'LL ARE KILLING ME WITH THE HUMOR, I am seriously 10 seconds in and cracking up looking forward to learning the way yall deliver this information. THANKS A BILLION
Christ, this is some of the best tutorials I've seen. Thank you for sharing, keep up with the excellent work!
Hats off to your creative ways to teaching. keep moving forward >>>
Replace NULL with zero:
SELECT ISNULL(myColumn, 0 ) FROM myTable
You really should have used IFNULL(i.quantity, 0) rather than the ISNULL.
SELECT COALESCE(myColumn , 0) FROM myTable;
Educational AND highly entertaining. Love her sense of humor and smile! Never have I clicked so fast for the next tutorial video. Great work Socratica and team!
The supply descriptions are hilarious 😂 and the graphics & sound effects throughout the vid are superb!
watching these to prepare for a job interview. The cuteness factor is really helping put me in the right mindset. I appreciate this so much!!
GOOD LUCK in your interview!! 💜🦉
Actually you're helping me getting prepared for my exam next week. Great clips with really good examples.
Excellent and Ha ! Ha !
What I like about Socratica....
No beating around the bush
Straight to the point
Videos are not too long
Clear explanations
Hot lady of course 👏😀
She is a Fantastic teacher. Top work on the editing guys, I am a visual person and concepts are better understood visually.
I would be glad if you guys can share the csv files for the martian course as well for us to practice.
This video was posted in my SQL class and so far it has been the thing that helps most in my lab assignment. Thank you!
This is wonderful to hear - we're so glad you're watching! Please say thanks to your instructor for us!! It helps us so much to get the word out.💜🦉
THANK YOU for this awesome video series on SQL and especially JOINS! I've never had so much fun watching..........any coding video and this is such a blast. You guys rock for this.
Wow. I never imagined joins were so entertaining... thanks a lot. Finally after 12 years of completing btech I now understand how joins work.
Idk what it is that makes these tutorials better than all the others. I think it’s her way of communication
You are my hero!!! Never change your instructions methods, please. People like myself need you.
the amount of effort and great sense of humor this lady has put in , so much appreciated.
I love the way they teach while having fun at the same time. In a short video, they explained all the three joins and sub-query, Alias as well. Thanks for this video.
Thank you for the videos! Hope you will keep publishing more videos on SQL.
Hello Ms Socratica, I am not kidding.. Even though I'm proficient in all computer science-related concepts, I am always confused with SQL Joins. You have explained things with soo much ease, I literally fell in love with you and your approach. I'm more confident with joins now in just 11 mins. Thank you soo much.
Maybe I should comment more, this an incredible futuristic professionalism that is completely amazing. Beyond compare!
thank you thank you that'll you had an exam and was so worried about joins. your an amazing teacher!!!
Waiting for Socratica's NoSql DB tutorial. I have subscribed, liked and commented and many will follow if you make a NoSQL DB tutorial.
Yeah. I hope she fulfills our request for NOSQL tutorials.
The way this was put together was perfect. I get so f-ing bored in class and have a hard time paying attention. THIS taught me more than in 1 hour of lecture. THANK YOU!
Wow! This Playlist is the best I've ever seen! Thanks so much! It's unbelievable how well this is done! Are you just geniuses or do you have a ridiculously high Budget? Amazing… really… absolutely amazing...
Wow, I was lost in sql till I clicked on these videos. Superb job
I used to hate building databases.... Boring... Socratica makes it enjoyable! Thank you Socratica!
Very insightful video I was searching for. For years I could not understand joins and related syntaxes but now finally I got it! Thank you a lot!
I wish I could Cite to a youtube links in scientific papers.
You made my data analysis really fas...
Thank you....
What a goofy, loony chick. I love it! And funny too. Makes it such a relaxed learning environment. The voice... the hypnotic, expressive eyes... the ease with which I've learned things thru these videos. What a great presentation. What a great teacher!
Instead of just poking my way thru a basic 'How To' type of book until my very simple SQL usage does what I hope it to do, I'm actually learning stuff on how to do things correctly & efficiently.
You, madam, are brilliant in your technique!
SQL is very important... thank god u have got this tutoring recorded. The best way for me to learn to learn is to watch this first.
You made it so easy mam, I request you to please make more videos like this, I will definitely contribute on patreon once I have a job.☺
Thank you.. You are better than hollywood actor.. Kind of you.
Thank you for the SQL video! It was incredibly informative. 😊🙏🎥💻
The best SQL tutorials ever...damn! I love this and thanks a million
Great video, and entertaining too - now I understand how to use the JOIN functions in SQL much better, thank you!
This lady is interesting to watch. Sometimes I catch myself smiling in between and then the other voice in my head would say "Common, I thought you were studying? So why the smiles ?" Hahaha.
Thank you, Socratica.
Am I the only one in love with this cyborg? great videos. I just have to keep up a bit faster than usual. Which is a good and bad thing.
This lady is the best!
You are just what I needed! I feel much more confident that I'll pass my test! Thank You!
I love the nerd humor too!
She and/or the person that wrote the script has a great sense of humor
This helps so much. Joins were killing me this made it simple. love it thanks.
Extremely well done. It is a little over the top but honestly you are explaining things none of the other vids have so far which were all the difference to me in understanding this concept. Thank you!!
Socratica, you are one of the best humans this side of Mars.
I really enjoy this SQL series, very helpful. Thank you for making it so fun !
The quality of your content is elite. You guys are the best💗
this the first SQL video I have watched that is not boring. this video just motivates me!!!
education is supposed to be entertaining. Bang on Socratica !! learnt and laughed . cheers
the way she describes sql is soo satisfying
Seriously stellar! Humor and information are 100% Thanks for this!
Haven't found any better video on SQL than this.
One of the best learning video series for SQL! Kudos to your creativity and execution :)💕
this channels should be deserve millions of millions subscribe and views
i am a fan of this channel by now. this soundtrack, the william gibson -vibes, your acting!
10/10
Outstanding way to teach a subject. I have never seen anything close to this. There are many good videos all around but the vídeos of this young lady are really from another world.
Thank you, Mario!!
You deserve more likes and viwes😍
Very good - reluctant to mention, that as an OOP programmer, using the words "base" and "super" for table names give me indigestion
One of the best methods for teaching. Examples are easy to understand and interesting. Even a child will love and learn these clips. Please continue what you're doing. Thank you.
This is the absolute best video on SQL joins I have watched. Most charming girl!
Easily the best video concerning SQL that I have watched. Not sure what else can be done any better.
Amazing content, thank you so much for helping me understand the basics of SQL!!
Google should hire you to make videos for them, because this explains SQL better than their data analytics certification courses.
I love these videos so much! Thank you for making studying easier for me!
You saved me, my exam is in a few days and I didn´t undertand the subject until now. Thanks a lot!
YOU ARE A LIFE SAVIOR QUEEN!!!!!
0:16 seconds in and smashed like, love the star wars reference!
Can you imagine if all education was themed like this? 😂😂. This is literally the most entertaining computer science video I've ever watched. "the reviews have been overwhelmingly online"😂😂😂😂
"We are on Mars because there is a picture of mars on our screen" xD Lmao
This is taught so well. Easier than a book
Heyy!! This was a really nice video!
Great discovery for me. GOOD JOB!
i like the teaching method of socratica . thank you
i havent see many of your videos yet, but i have already started loving them
We're so glad you've found us! Thanks for your nice comment!! 💜🦉
truly, a video of the year
Your videos are hilarious. Glad to see Mark Watney returned to Mars after his mishap. Thank you!
0:08 punchline within 10 seconds? Bold move!
I love your content!!!
this is one of the best tutorials i have ever
seen......thank you
Appreciate the wonderful illustration.
Even knowledge can be entertained. Hence it proved.
Honestly thought i'd get lost by the subquery bit but got an understanding of it when thinking about it.
It was incredible. Thanks Socratica.
This was the best explanation, I have seen so far!
Providing the sample database you use in the example would be very helpful.
Socratica. This is extremely helpful. People one question: My professor said inner join woll cause problems by having cartesian product. How do I solve for it? And how would that ever happen?
I recommend Socratica to my classmates! (:
Absolutely in love with the videos!! Thanks a lot!! Did not expect all the fun in these videos :')))
the pop culture referance in these videos are good!
Pretty easy to learn. Include this with your studies.
I love the way you explain this!
Thank you for these videos, they are most helpful! Looking forward to more SQL videos! :)
Thank you so so much you helped me in my final exam.
'The reviews from critics have been overwhelmingly online' 🤣
I wish you guys had uploaded these tables or the SQL codes to quickly create them. But overall, amazing tutorials!
Amazing! Just found your channel and it's amazing, thank you!
Congratulations on your tutorials. Really helpful, on point, entertaining.
I cant believe how informative and fun this is!!