SQL VIEWS + Complex Queries, Cross Joins, Unions, and more! |¦| SQL Tutorial

[@Socratica]

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!! 💜🦉

[@vasiovasio]

Do you can tell us the name of the program, SQL client that you use in this series? Thank you!

[@MrRandsauce]

you're cool

[@unabonger777]

@@vasiovasio pgAdmin

[@vasiovasio]

@@unabonger777 Thank you!

[@paulhetherington3854]

Under score - istt below - the Ln! Hence; it needs - a Ln!

[@dharmaturtle]

I've never been so entertained while learning SQL. Amazing job.

[@hawnannahian9538]

dharmaturtle Same here. She is so funny🤩 I like her

[@anthonygonsalvis121]

Wait till you watch her (old) Python series!

[@TheSoulCrisis]

It's amazing how well your brain absorbs material when you're having fun with it!

[@wjrasmussen666]

I wish she was doing more videos!

[@skylersaville2590]

Right?! This is amazing!

[@elsins9790]

The combination of being funny, intelligent and being creepy at the same time. I just love it. ❤️

[@olzhasarystanov9582]

This is one of the most underrated channels in IT community. The material quality is decent and concepts are easy to grasp because of entertaining style. Thank you for your work

[@Socratica]

Thank you so much for your kind words!! It inspires us to keep making videos. It *has* been hard for people to find our channel, for some reason. KZbin is so unpredictable in its recommendations. It is a HUGE help if you share our videos on social media or by email with your friends/ teachers/ fellow students/ coworkers. THANK you, Socratica Friend! 💜🦉

[@Ninja_Reborn]

Wow, THIS is how courses should be done. Not just plain information, but contextualized with relateable scenarios and jokes, and adequate soundrack + sound fx. I'm in love with this series!

[@hassansyed6087]

What a comprehensive explanation with good visuals that makes things easy to understand for newcomers. Thank you for this !

[@rheaa-menon]

I have never been more entertained and curious while learning database systems; I developed a strong dislike for the subject because of a teacher with very questionable teaching skills but you guys made me thoroughly enjoy the subject. Thank you so much!

[@InternationalBigshot]

I've been SQLing for years but this taught me something new.

[@cyberceel]

Dare I say it changed your point of.. view..

[@arsalsohail298]

I must say, my concepts got renewed.

[@mcan543]

#KeyTakeAways 1:13 To restrict some of your columns use VIEW 3:09 To simplify complex and frequently used queries use VIEW 3:47 CONCAT function can be used to create unique ids from unified tables. 6:44 CROSS JOIN and COALESCE

[@SweetestTrade]

This is one of the best SQL video I've seen on KZbin! This video actually helped me remember what SQL Views are.

[@hamzac.4555]

she killed me at the end, view, overview, review, you... It looked like her rapper side was taking over. Keep it up !

[@joeyc666]

and then whispers "Subscribe"

[@hitmanLis]

Music + animation + humor + beauty +details = just perfect!

[@tamyabs3560]

im studying software engineering in college, and our SQL teacher is less than qualified, he barely explains the material and only gives attention to the more "understanding" students, i gave up on him a few weeks ago cause he made the whole SQL subject seem impossible to grasp, until i watched this series, thank you so much!!

[@rafaelagentry7809]

omg i loved this!!! i am a huge science fiction nerd and i instantly wanted to learn about databases that included stuff about mars. this was fun!

[@Socratica]

We're so glad you enjoyed it! We had so much fun making these videos.

[@felix954]

How crazy is it that I learned more SQL from this KZbin playlist than from the "Professor" and College level course I am taking? Thank you Socratica and Cyber-Ulka !

[@parvavlogs3722]

1:13 To restrict some of your columns use VIEW 3:09 To simplify complex and frequently used queries use VIEW 3:47 CONCAT function can be used to create unique ids from unified tables. 6:44 CROSS JOIN and COALESCE

[@neenersx3]

WHY AM I JUST FINDING OUT ABOUT THIS CHANNEL???? I am halfway through my database systems class (failing) but this channel is giving me hope :)

[@jeffreyphillips4376]

"Grumble" Hahahahaha Great content, fantastic acting. I learn a lot from these videos, and the delivery is remarkable. You guys make a great team!

[@murtazajabalpurwala8124]

you are the best tutor in the world and the most unique experience of learning.

[@jacobshore]

Examples from the video: www.db-fiddle.com/f/tDULuaaBegoN3kSw5fgbb3/8 Thanks for the tutorial! The production value of these videos are great. SQL tutorials have never been so entertaining.

[@Hybe123]

Wow, you're a godsend! I'm not sure why socratica didn't do something like you did, but ok. Makes me think most of people just look at the lessons. The key is to do them in my opinion.

[@nabinpokhrel6129]

THANKS

[@ren3083]

This SQL series is absolutely awesome, understanding all that muuuuuuuch better now. Thank you for this great work!

[@prakashgadupoodi7549]

Amazing. If the teachings are supposed to be like this, learning will be beautiful. Thanks!. Looking forward to getting your uploads.

[@sandeepreddy4178]

I’ve been working on SQL for years now, but completed this video just because I thoroughly enjoyed it

[@GideonTsangplus]

I agree this lady makes the best SQL video!

[@syedb8943]

I like the teaching style and pun on words. All concepts that seemed too difficult to understand are made so simple. Thanks a ton 😊👍

[@illlanoize23]

Dear god as a cs student watching all my lectures I cannot explain how refreshing it is to hear something with a little a little presentation. They just kinda told me to do these complex queries without teaching me so this is really helpful too. I love the whole space aesthetic too w the green screens and deep bass lines my brains always been drawn to it. Reminds me of planetside 2 a bit. Thank you for this vid I’m glad I came across it. I’m off to try to find that green matrix like background image to make my pc wallpaper

[@johnsample5170]

I think I am in love. Simple, funny, highly entertaining, super creative and delivered by a beautiful young lady with super snazzy graphics. You got a new sub

[@treyannan7852]

I avoided databases for decades becoz it was boring & irrelevant at the time. Then THIS !! Made sense easily, FAST (!!!) & so much more fun. Can't Thank you enough @socratica

[@chriswetherall5517]

It's 10pm in the UK on a Friday and I'm geeking out. Good job!!!!

[@johnathanjames2872]

Whoever edits these videos, good job!

[@triplea7071]

The last 4 sentences were straight BARZ. She had 2 drop the mic 💥

[@ajinxRGB]

What a view !! she explains it so beautifully... i love her methodology ...just amazing !!!

[@psyferinc.3573]

i really love you. every time the info is a mess in my head you bring it all together beautifully. thank you

[@faustopf-.]

Engaging, creative and super delightful to watch tutorial. Now I like this language even more. Thank you!

[@jessicafaust2748]

I think I just learned more in 8 mins than that last 2 months. Bravo!

[@МухиддинМахмудов-б5щ]

OMG. I'm sure you don't have an idea how great you are. Thx for that kind of videos

[@danilomiguelangelacostadot5137]

This woman is amazing. Love the way she explains stuff , she makes everything so intriguing xD Thank you Socratica, now i have a better view over... Views :P

[@TuxMan20]

6:00 USB 6.0 cable? I'm glad that in the future, the USB Implementers Forum will come back to it's senses about naming their standards 😜

[@khangnguyendac7184]

WOW, the last 2 video of this series is amazing, I didn't know SQL could be that helpful

[@elijahromer6544]

This was the best SQL video I have ever watched

[@Socratica]

Do you love Socratica Programming videos? We have a Kickstarter to make 20 Advanced Python Lessons. Support what you love! bit.ly/PythonKickstarter

[@kovan111]

you are the most amazing teacher ever. Absolutely amazing

[@Nosilaurus]

Thank you so much for your content! I wanted to understand unions and views better and I knew that your account would provide a simple explanation that made the concepts easy to understand. It reminded me to finally subscribe too, because I forget frequently. You're the GOAT

[@harshavardhanranger]

Omg the amount of work u put into each video is really commendable, Thanks a ton dear!!

[@tivchack]

Try not to laugh challenge - SQL version!! 😂😎👍

[@tijani3141]

holly shit. I gotta give you 10/10 for creativity I could watch you guys explain sql all day and I wouldn't get bored and still remember all I learnt.

[@YourCousinJillTV]

You’ve just saved me more grey hair. Thank you for the edutainment. 😊

[@bm-ub6zc]

more women should teach computer science stuff. the way you presented your teaching was full of dedication, what i admire. you went the extra mile for using an entertaining and visual example. most computer scientists don't. they explain things very boring and incomprehensible (although on youtube there are really good ones).

[@prakharsahu7145]

this is just the best SQL tutorial ever!!!!!!

[@zaurtigiev8869]

I love the way you are explaining stuff in this video. It is very funny. Thank you for the great content!

[@anbee7056]

I was watching another video and fell asleep, when I was half awake, I saw your video and click, WOW, I am wide awake, no more sleepy time to study SQL :)))

[@prozacsf84]

That happens when a woman wants something. She gives everything for the cause. You have me Socratica as a subscriber and fan. Enjoy 😊

[@vaibhavbhatt434]

ONE OF THE BEST SIMPLE & SOBER TUTORIALS OF SQL !!! YOU REALLY DESERVE A MILLION OF SUBSCRIBERS. THUMBS UP FOR YOU. PLEASE MAKE MORE TUTORIALS ON SQL ( STORED PROCEDURE,TRIGGERS,FUNCTIONS,CTE) IT WILL BE REALLY HELPFULL

[@TheDataMaestro]

Others have made similar comments but you make learning fun. I liked and subscribed.

[@AndrewT34pot]

This is the second video I'm watching I love the information and the production quality

[@adriancritchley2485]

This is just excellent. Mars data makes so much more sense to me than the data I'm using in my actual job.

[@nitusain2145]

I love the way you talking. And thanks for the best information....

[@phuonganhngo9025]

omg, i've never left a comment on youtube but this video is sooooo lit. You're amazing.

[@anamashraf8996]

That was great video! It kept me engaging simultaneously helping me understand the concept in simple way. Thank You 😁

[@NavyGunner1980]

She is Awesome! concise and to the point!

[@Tanuja_Desai]

Just.........Amazing..............😍😍 don't have any word for the way you teach

[@funtrain503]

Thanks for this brilliant guide on SQL. I have been following tutorials on SQL on youtube since last ten years...and nothing helped. And your tutorial helped me in greater depth

[@Gromspox]

I really liked this tutorial! It made SQL VIEWS so much easier!!!

[@jojolaeasy3493]

Can you post more SQL videos please!? Your videos are so easy to follow and fun to watch!!

[@smzaccaria]

These videos are awesome, they are so helpful! This is better than the official content on LinkedIn.

[@smokeout1218]

lol i loved this. they're taking over.

[@SaimaShaikh-q9l]

Covers all the points in less time!! very helpful :) Thanks

[@firesongs]

I love the simple 1-2 sentence explanation in layman terms for things like cross join. Cant find that anywhere else. Thank you

[@sahumullasaud4837]

I first came across Ulka in the Python tutorials where she looks 'serious' with the jokes. Gotta say it was surprising but nice to see her weird side on the SQL videos. Lovely voice difference too. Enjoyed it!

[@jayraldempino1944]

As a beginner, I found this informative and concise. Thank You for explanations.

[@grassash]

Thanks for this Simple, Effective and Entertaining lecture.

[@islamsaied6484]

your way of explaining is beautiful

[@mumtazjoyo4638]

You have unique and excellent method of teaching. I have never seen such kind of educational channel on youtube. Keep it up guys.👍👍

[@ilia54]

One of the best tutorials i have seen i my life, amazing. thanks you.

[@shoaibathar]

Excellent Thousands times appreciation for your efforts

[@maresolaris]

What a delight watching this video. Clear, concise and very helpful. Thank you very much!

[@deviprasadrajuvysyaraju]

I love the way you taught... great job👏

[@anthonygonsalvis121]

@Socratica, thanks again for simplifying the SQL concepts. A very good example of cross join. Please consider adding a bit more of your quirkiness that we all fell in love with through your Python series. It was so addicting...

[@anna4rgkyo]

Thanks!

[@jeetkar6999]

SQL session taken to next level, fantastic job done

[@woolfel]

here's a suggestion for you. Cover when union queries are better option than multiple or subqueries. I've seen programmer mis-use both and cleaned up lots of really bad SQL. More advanced join topic, self-join queries and why they can blow up the database server consuming 100% of the CPU.

[@paulinmt2185]

Very enjoyable and interesting. I use MySQL for in-house projects, and find this series quite useful. Brava!

[@syedinamulhaq5173]

Absulutely loved every single video !! Great work !

[@PyManRage]

This view helped me understand this more than a blockhead of a lecturer that I know. Thank you sub ++

[@kshitijsaini6006]

the background eerie music keeps me awake and in suspense .. what will happen next. Teaching method is awesome .. keep it up gal.

[@GuillermoAlfonsoMorales]

Excellent video again, thanks. Ps. I love you cyborg girl.

[@Aborichinal]

Very good channel! I love the delivery!!!!!

[@joshuaerkman1444]

I Love your content everytime I watch it.

[@surenhta]

Teaching the futuristic way. Kudos :)

[@vijaybodkhe8379]

Ha Ha felt happy learning this and explaining it with smiling face and the Mars example.....Thank you for sharing the content in such innovative way..

[@ronayusan4047]

Great way to teach SQL! Definitely eye-catching and entertaining!

[@andreyivanov6239]

I literally subscribed 30 seconds into the video

[@akin242002]

I just found this video nearly 3 years after it's release, but it is still great information.

[@miriamhopeestradavega8249]

YOU ARE A BOSS QUEEN!!! I LOVEEEE YOUR CHANNEL!!

[@RavikaUniverse.]

How can be so entertaining while teaching Sql Amazing

[@AndyPerry1972]

Most of this I knew...in terms of the query...but I never knew how to create a view from it! Great video, Great channel and I will continue subscribing 👍

[@AndyPerry1972]

By the way, I still love you x x x x x

[@HarshitShetty5]

Amazing vid! Love how you've explained it with the graphics and storytelling. Quality content!

[@MiguelGarita]

It is it is !!! She's killing me !

[@SaiKrishna001]

Very Well Explained and good concept clarity, thank you and good job

[@juanrivera8044]

Being new to SQL this help A lot