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

Published: 29 March 2019
on channel: Socratica
295,991
11k

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:
↪http://bit.ly/Socratica_SQL

Be sure to SUBSCRIBE for more SQL!
↪ http://bit.ly/SocraticaSubscribe

You may also enjoy our Python playlist:
↪http://bit.ly/PythonSocratica

♦♦♦♦♦♦♦♦♦♦

Ways to support our channel:

►  Join our Patreon :   / socratica  
►  Make a one-time PayPal donation: https://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)

♦♦♦♦♦♦♦♦♦♦


Watch video SQL VIEWS + Complex Queries, Cross Joins, Unions, and more! |¦| SQL Tutorial online without registration, duration hours minute second in high quality. This video was added by user Socratica 29 March 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 295,991 once and liked it 11 thousand people.