SQL VIEWS + Complex Queries, Cross Joins, Unions, and more! |¦| SQL Tutorial
Vložit
- čas přidán 28. 03. 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!! 💜🦉
I've never been so entertained while learning SQL. Amazing job.
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
Try not to laugh challenge - SQL version!! 😂😎👍
I've been SQLing for years but this taught me something new.
ERROR: UNION types integer and character varying[] cannot be matched why it returns a message like that?
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!
I like how in most of the videos dealing with tables with people in it, I see Elon Musk
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!
The puns at the end hahahahahha
The combination of being funny, intelligent and being creepy at the same time.
#KeyTakeAways
she killed me at the end, view, overview, review, you... It looked like her rapper side was taking over. Keep it up !
This is one of the best SQL video I've seen on CZcams! This video actually helped me remember what SQL Views are.
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!!
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!
Music + animation + humor + beauty +details = just perfect!
How crazy is it that I learned more SQL from this CZcams playlist than from the "Professor" and College level course I am taking?
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 :)
Examples from the video: