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:

———————————————
»» To​ ​help​ ​us​ make videos more quickly,​ ​you​ ​can​ ​support​ Socratica at:

… ​Patreon​:
… Paypal:
… Bitcoin: 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9

Thank​ ​you!!

———————————————
»» You​ ​can​ ​also​ ​follow​ ​Socratica​ ​on:

…​ ​Twitter:​ ​@socratica
… ​Instagram:​ ​@SocraticaStudios
… ​Facebook:​ ​@SocraticaStudios

———————————————
SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)

Nguồn: https://chromano.me/

Xem thêm bài viết khác: https://chromano.me/category/cong-nghe

Leave a Reply

Your email address will not be published. Required fields are marked *