SQL VIEWS + Complex Queries, Cross Joins, Unions, and more! |¦| SQL Tutorial
ฝัง
- เผยแพร่เมื่อ 28 มี.ค. 2019
- 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)
♦♦♦♦♦♦♦♦♦♦
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!! 💜🦉
Do you can tell us the name of the program, SQL client that you use in this series? Thank you!
you're cool
@@vasiovasio pgAdmin
@@unabonger777 Thank you!
Under score - istt below - the Ln! Hence; it needs - a Ln!
I've never been so entertained while learning SQL. Amazing job.
dharmaturtle Same here. She is so funny🤩 I like her
Wait till you watch her (old) Python series!
It's amazing how well your brain absorbs material when you're having fun with it!
I wish she was doing more videos!
Right?! This is amazing!
The combination of being funny, intelligent and being creepy at the same time.
I just love it. ❤️
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
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. TH-cam 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! 💜🦉
I've been SQLing for years but this taught me something new.
Dare I say it changed your point of.. view..
I must say, my concepts got renewed.
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!
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!
#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
Music + animation + humor + beauty +details = just perfect!
It's 10pm in the UK on a Friday and I'm geeking out. Good job!!!!
This is one of the best SQL video I've seen on TH-cam! This video actually helped me remember what SQL Views are.
This SQL series is absolutely awesome, understanding all that muuuuuuuch better now. Thank you for this great work!
she killed me at the end, view, overview, review, you... It looked like her rapper side was taking over. Keep it up !
and then whispers "Subscribe"
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!
We're so glad you enjoyed it! We had so much fun making these videos.
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!!
Best tutorial on SQL I've watched so far for my exam prep :D Entertaining and straight to the point - thank you!
"Grumble"
Hahahahaha
Great content, fantastic acting. I learn a lot from these videos, and the delivery is remarkable. You guys make a great team!
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 :)
How crazy is it that I learned more SQL from this TH-cam playlist than from the "Professor" and College level course I am taking?
Thank you Socratica and Cyber-Ulka !
I like the teaching style and pun on words. All concepts that seemed too difficult to understand are made so simple. Thanks a ton 😊👍
i really love you. every time the info is a mess in my head you bring it all together beautifully. thank you
Amazing vid! Love how you've explained it with the graphics and storytelling. Quality content!
Whoever edits these videos, good job!
WOW, the last 2 video of this series is amazing, I didn't know SQL could be that helpful
I’ve been working on SQL for years now, but completed this video just because I thoroughly enjoyed it
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
What a delight watching this video. Clear, concise and very helpful. Thank you very much!
Great way to teach SQL! Definitely eye-catching and entertaining!
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
Absulutely loved every single video !! Great work !
Amazing. If the teachings are supposed to be like this, learning will be beautiful.
Thanks!. Looking forward to getting your uploads.
Very enjoyable and interesting. I use MySQL for in-house projects, and find this series quite useful. Brava!
What a view !! she explains it so beautifully... i love her methodology ...just amazing !!!
This was the best SQL video I have ever watched
OMG. I'm sure you don't have an idea how great you are. Thx for that kind of videos
Covers all the points in less time!! very helpful :) Thanks
One of the best tutorials i have seen i my life, amazing. thanks you.
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
This is the second video I'm watching
I love the information and the production quality
Engaging, creative and super delightful to watch tutorial. Now I like this language even more. Thank you!
Another excellent video.
Loved it!
Omg the amount of work u put into each video is really commendable, Thanks a ton dear!!
Very good channel! I love the delivery!!!!!
I think I just learned more in 8 mins than that last 2 months. Bravo!
this is just the best SQL tutorial ever!!!!!!
SQL session taken to next level, fantastic job done
Another awesome video!!! I might end up watching everything you two have posted.
I love the simple 1-2 sentence explanation in layman terms for things like cross join. Cant find that anywhere else. Thank you
Amazing video with funny and illustrative examples. Thanks for making my SQL learning path interesting!
I really liked this tutorial! It made SQL VIEWS so much easier!!!
As a beginner, I found this informative and concise. Thank You for explanations.
Try not to laugh challenge - SQL version!! 😂😎👍
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 :)))
I agree this lady makes the best SQL video!
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
I love the way you are explaining stuff in this video. It is very funny. Thank you for the great content!
you are the best tutor in the world and the most unique experience of learning.
Loved it, loved it, loved it! Amazing and brilliant!
@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...
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.
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.
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
You’re a fantastic teacher! Thank you!!
Very enjoyable and informative to watch!
I love the way you taught... great job👏
Great video ! Looking forward to see new ones soon. Thank you !
Teaching the futuristic way. Kudos :)
Thank you Ulka, it was a quick overview.
I finally understood that! Thank you for brilliant overVIEW :D
What a lovely way to teach!
you are the most amazing teacher ever. Absolutely amazing
She is Awesome! concise and to the point!
I love these space/Martian based themed vids. Pretty cool...!
I love the way you talking.
And thanks for the best information....
I really enjoyed this lesson. This is really a fun way to learn!
I love Socratica!!
This is just excellent. Mars data makes so much more sense to me than the data I'm using in my actual job.
You have unique and excellent method of teaching. I have never seen such kind of educational channel on youtube.
Keep it up guys.👍👍
I Love your content everytime I watch it.
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
That happens when a woman wants something. She gives everything for the cause. You have me Socratica as a subscriber and fan. Enjoy 😊
One of the best vide'o' . Kudos to Socretica
Amazing job! Actually learned sql 🎉
Thanks for this Simple, Effective and Entertaining lecture.
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
These video are so good!!!!!! Easy and clear!
These videos are awesome, they are so helpful! This is better than the official content on LinkedIn.
YOU ARE A BOSS QUEEN!!! I LOVEEEE YOUR CHANNEL!!
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!
your way of explaining is beautiful
Others have made similar comments but you make learning fun. I liked and subscribed.
Well done, i've got another VIEW on this topic now. ;-) I like this channel !
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).
Most useful and entertaining. Thank you!
Superbly Explained!
The last 4 sentences were straight BARZ. She had 2 drop the mic 💥
It was so awesome , never new view could be interesting
You’ve just saved me more grey hair. Thank you for the edutainment. 😊
Excellent explanation! I'm glad I subscribed the channel. Thanks!
Being new to SQL this help A lot
you guys are amazing. keep up the good work!