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:

Be sure to SUBSCRIBE for more SQL!

You may also enjoy our Python playlist:

♦♦♦♦♦♦♦♦♦♦

Ways to support our channel:

►  We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9

Thank you!

♦♦♦♦♦♦♦♦♦♦

Connect with us!

♦♦♦♦♦♦♦♦♦♦

♦♦♦♦♦♦♦♦♦♦

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

[dharmaturtle]

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

[elsins]

The combination of being funny, intelligent and being creepy at the same time.

I just love it. ❤️

[olzhasarystanov]

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

[mcan]

#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

[InternationalBigshot]

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

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

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

[jeffreyphillips]

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

[chriswetherall]

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

[SweetestTrade]

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

[hamzac.]

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

[rafaelagentry]

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!

[ren]

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

[HarshitShetty]

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

[felix]

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

[sarahheintz]

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

[illlanoize]

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

[syedb]

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

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