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

In SQL, a VIEW is a virtual table. It lets you package a complex query into a single table. We will discuss several queries in increasing difficulty to show how VIEWs can greatly simplify your work. In our examples we will introduce CROSS JOINs, Unions, the CONCAT() function, and the COALESCE() function.
Our SQL playlist starts here:
↪bit.ly/Socratica_SQL
Be sure to SUBSCRIBE for more SQL!
↪ bit.ly/SocraticaSubscribe
You may also enjoy our Python playlist:
↪bit.ly/PythonSocratica
♦♦♦♦♦♦♦♦♦♦
Ways to support our channel:
► Join our Patreon : / socratica
► Make a one-time PayPal donation: www.paypal.me/socratica
► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!
♦♦♦♦♦♦♦♦♦♦
Connect with us!
Facebook: / socraticastudios
Instagram: / socraticastudios
Twitter: / socratica
♦♦♦♦♦♦♦♦♦♦
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)
♦♦♦♦♦♦♦♦♦♦

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

[@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.

[@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!

[@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

[@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!

[@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.

[@tivchack]

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

[@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"

[@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.

[@chriswetherall5517]

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

[@ren3083]

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

[@hitmanLis]

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

[@SweetestTrade]

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

[@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!

[@sarahheintz6992]

Best tutorial on SQL I've watched so far for my exam prep :D Entertaining and straight to the point - thank you!

[@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 😊👍

[@psyferinc.3573]

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

[@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 !

[@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

[@prakashgadupoodi7549]

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

[@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

[@sandeepreddy4178]

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

[@ajinxRGB]

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

[@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 :)

[@HarshitShetty5]

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

[@paulinmt2185]

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

[@harshavardhanranger]

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

[@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 😜

[@maresolaris]

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

[@user-tk1re2hd2y]

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

[@faustopf-.]

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

[@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...

[@elijahromer6544]

This was the best SQL video I have ever watched

[@murtazajabalpurwala8124]

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

[@ilia54]

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

[@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!!

[@firesongs]

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

[@khangnguyendac7184]

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

[@jayraldempino1944]

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

[@jessicafaust2748]

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

[@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

[@ronayusan4047]

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

[@GideonTsangplus]

I agree this lady makes the best SQL video!

[@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

[@user-vy5ik1gn4b]

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

[@jeetkar6999]

SQL session taken to next level, fantastic job done

[@Gromspox]

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

[@mumtazjoyo4638]

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

[@zaurtigiev8869]

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

[@kovan111]

you are the most amazing teacher ever. Absolutely amazing

[@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

[@AndrewT34pot]

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

[@mikhailsladkomedov7415]

Amazing video with funny and illustrative examples. Thanks for making my SQL learning path interesting!

[@adriancritchley2485]

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

[@adaezeifesi4732]

You’re a fantastic teacher! Thank you!!

[@deviprasadrajuvysyaraju]

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

[@nitusain2145]

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

[@kakkurij]

Love this video series! Could you do a tutorial on ER diagrams and how to transform them to actual database? Can't wait to learn what's next!

[@syedinamulhaq5173]

Absulutely loved every single video !! Great work !

[@quahntasy]

Another excellent video. Loved it!

[@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

[@TheTrace8]

Another awesome video!!! I might end up watching everything you two have posted.

[@frankasante5594]

I really enjoyed this lesson. This is really a fun way to learn!

[@GoredGored]

Thank you Ulka, it was a quick overview.

[@NavyGunner1980]

She is Awesome! concise and to the point!

[@YourCousinJillTV]

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

[@prakharsahu7145]

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

[@maheshbabunadigoti7050]

Awesome mam, no words to describe your way of teaching....Extremely different from others....I am expecting some more videos on sql and plsql...

[@jurgenaddicks1634]

Well done, i've got another VIEW on this topic now. ;-) I like this channel !

[@spaceman3518]

I finally understood that! Thank you for brilliant overVIEW :D

[@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

[@philanglade2745]

Great video ! Looking forward to see new ones soon. Thank you !

[@smzaccaria]

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

[@grassash]

Thanks for this Simple, Effective and Entertaining lecture.

[@ademtepe2855]

Loved it, loved it, loved it! Amazing and brilliant!

[@jojolaeasy3493]

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

[@JohnnysaidWhat]

Amazing job! Actually learned sql 🎉

[@JoeWong81]

I love Socratica!!

[@islamsaied6484]

your way of explaining is beautiful

[@surenhta]

Teaching the futuristic way. Kudos :)

[@shoaibathar]

Excellent Thousands times appreciation for your efforts

[@Aborichinal]

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

[@johnathanjames2872]

Whoever edits these videos, good job!

[@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 :)))

[@cyberceel]

What a lovely way to teach!

[@simplicity3792]

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

[@7MechanicalAnimal]

Very enjoyable and informative to watch!

[@TheDataMaestro]

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

[@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.

[@juanrivera8044]

Being new to SQL this help A lot

[@xuantienpham5777]

I understand View now. Thank you!

[@MrSfaundez]

Your explanations are fantastic thank you

[@teo11300]

I love these space/Martian based themed vids. Pretty cool...!

[@joshuaerkman1444]

I Love your content everytime I watch it.

[@triplea7071]

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

[@tusharjangid2492]

Superbly Explained!

[@DJEYkanjaria]

One of the best vide'o' . Kudos to Socretica