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

Подписаться 890 тыс.

Просмотров 295 тыс.

50% 1

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/Socratic...
Be sure to SUBSCRIBE for more SQL!
↪ bit.ly/Socratic...
You may also enjoy our Python playlist:
↪bit.ly/PythonSo...
♦♦♦♦♦♦♦♦♦♦
Ways to support our channel:
► Join our Patreon : / socratica
► Make a one-time PayPal donation: www.paypal.me/...
► 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)
♦♦♦♦♦♦♦♦♦♦

Опубликовано:

26 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 406

@Socratica 5 лет назад

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 4 года назад

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

@MrRandsauce 4 года назад

you're cool

@unabonger777 4 года назад

@@vasiovasio pgAdmin

@vasiovasio 4 года назад

@@unabonger777 Thank you!

@paulhetherington3854 2 года назад

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

@dharmaturtle 4 года назад

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

@hawnannahian9538 4 года назад

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

@anthonygonsalvis121 3 года назад

Wait till you watch her (old) Python series!

@TheSoulCrisis 3 года назад

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

@wjrasmussen666 2 года назад

I wish she was doing more videos!

@skylersaville2590 Год назад

Right?! This is amazing!

@elsins9790 3 года назад

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

@olzhasarystanov9582 3 года назад

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 3 года назад

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. RU-vid 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 5 лет назад

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

@cyberceel 3 года назад

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

@arsalsohail298 3 года назад

I must say, my concepts got renewed.

@Ninja_Reborn 4 года назад

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!

@rafaelagentry7809 5 лет назад

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 5 лет назад

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

@SweetestTrade 4 года назад

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

@hitmanLis 2 года назад

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

@felix954 3 года назад

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

@tivchack 4 года назад

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

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

@neenersx3 2 года назад

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 5 лет назад

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

@treyannan7852 3 года назад

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

@jacobshore 5 лет назад

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 2 года назад

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 3 месяца назад

THANKS

@anbee7056 2 года назад

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

@murtazajabalpurwala8124 Год назад

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

@prakashgadupoodi7549 Год назад

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

@ren3083 3 года назад

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

@mcan543 4 года назад

#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

@syedb8943 2 года назад

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

@chriswetherall5517 4 года назад

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

@bm-ub6zc 3 года назад

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).

@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

@prozacsf84 3 года назад

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

@illlanoize23 3 года назад

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

@prakharsahu7145 3 года назад

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

@triplea7071 4 года назад

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

@psyferinc.3573 Год назад

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

@sandeepreddy4178 3 года назад

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

@GideonTsangplus 3 года назад

I agree this lady makes the best SQL video!

@SaimaShaikh-q9l Год назад

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

@khangnguyendac7184 11 месяцев назад

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

@johnathanjames2872 Год назад

Whoever edits these videos, good job!

@TuxMan20 5 лет назад

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 😜

@akin242002 2 года назад

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

@МухиддинМахмудов-б5щ 3 года назад

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

@ajinxRGB 2 года назад

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

@PyManRage Год назад

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

@grassash 2 года назад

Thanks for this Simple, Effective and Entertaining lecture.

@nitusain2145 3 года назад

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

@jessicafaust2748 3 года назад

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

@NavyGunner1980 4 года назад

She is Awesome! concise and to the point!

@jojolaeasy3493 2 года назад

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

@TheDataMaestro 4 года назад

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

@phuonganhngo9025 3 года назад

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

@elijahromer6544 Год назад

This was the best SQL video I have ever watched

@tijani3141 4 года назад

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.

@aaditshirke8755 2 года назад

I never imagined learning to be this fun

@teo11300 3 года назад

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

@RavikaUniverse. 2 года назад

How can be so entertaining while teaching Sql Amazing

@YourCousinJillTV 3 года назад

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

@woolfel 5 лет назад

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.

@simplicity3792 3 года назад

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

@kovan111 3 года назад

you are the most amazing teacher ever. Absolutely amazing

@GoredGored Год назад

Thank you Ulka, it was a quick overview.

@surenhta 3 года назад

Teaching the futuristic way. Kudos :)

@小野马回来啦 4 года назад

I truly doubt if you are from the future of Mars! Awesome content and excellent skills.

@taruntomar7947 4 года назад

Its like watching a funny movie. enjoying and learning at every second..

@Aborichinal Год назад

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

@Nosilaurus 2 года назад

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

@funtrain503 4 года назад

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

@adriancritchley2485 3 года назад

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

@Gromspox 3 года назад

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

@andreyivanov6239 3 года назад

I literally subscribed 30 seconds into the video

@zaurtigiev8869 3 года назад

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

@firesongs 2 года назад

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

@juanrivera8044 2 года назад

Being new to SQL this help A lot

@MiguelGarita 3 года назад

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

@damangrewal5939 3 года назад

It was so awesome , never new view could be interesting

@smokeout1218 24 дня назад

lol i loved this. they're taking over.

@vaibhavbhatt434 2 года назад

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

@joshuaerkman1444 3 года назад

I Love your content everytime I watch it.

@vijaybodkhe8379 2 года назад

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

@jayraldempino1944 4 года назад

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

@Plus1HD 3 года назад

It was nice to "VIEW" you.

@JohnnysaidWhat 2 года назад

Amazing job! Actually learned sql 🎉

@gezahagnmulatu7887 4 года назад

Very nice and easy way to understand a SQL query thank you

@GuillermoAlfonsoMorales 5 лет назад

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

@MrHatranpro 3 года назад

The man is impressed!

@sahumullasaud4837 4 года назад

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!

@cyberceel 3 года назад

What a lovely way to teach!

@rheaa-menon 3 года назад

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!

@parvavlogs3722 2 года назад

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