SQL VIEWS + Complex Queries, Cross Joins, Unions, and more! |¦| SQL Tutorial
Socratica
@socraticaAbout
Socratica makes high-quality educational videos on ♾️ math 🧪 science 💻 computer programming and more! We're a couple of Caltech grads who believe you deserve better videos. You'll #LearnMore with us. 🦉 Check out our COURSES on our website!
Latest Posts
Video Description
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 : https://www.patreon.com/socratica ► Make a one-time PayPal donation: https://www.paypal.me/socratica ► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank you! ♦♦♦♦♦♦♦♦♦♦ Connect with us! Facebook: https://www.facebook.com/SocraticaStudios/ Instagram: https://www.instagram.com/SocraticaStudios/ Twitter: https://twitter.com/Socratica ♦♦♦♦♦♦♦♦♦♦ SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496) ♦♦♦♦♦♦♦♦♦♦
Boost Your SQL Learning
AI-recommended products based on this video
Sunrad Sewing Kit for Kids Beginner Arts and Crafts, Make 9 Easy DIY Projects, Unicorn & Animal Felt Craft Educational Toys Learn to Sew, Birthday Gifts for Girls Kids Age 6-8-10-12+
AYASAL Lash Lift Kit Eyelash Perm Kit, with Detailed Instruction Eyelash Lift Kit, Easy for Beginner and Professional Lash Perm Kit, Achieve Salon-Quality Lashes Lift with Safe and Effective Result
RAOYI 5Pack 64GB USB Flash Drive USB Stick USB 2.0 Memory Stick Slide Retractable Thumb Drive 64G USB Drive USB Key for Data Storage (Black Red Blue Green Purple)
Netac 64GB USB Stick USB 3.0 Flash Drive, Up to 90MB/s, Thumb Drive for Data Storage, Pen Drive with Swivel Design, Memory Stick for External Storage Data/Computer/PC/Laptop/Sound
KEXIN 64GB USB Flash Drive 3 Pack - Swivel Thumb Drives with LED Indicator, High-Speed USB 2.0 (Pink/Yellow/Cyan) for Data Storage, Bulk Pen Drives Multi-Color Pack
Flash Drive 16GB 5 Pack USB 2.0 Swivel Thumb Drives Bulk Memory Stick Jump Drive Pendrive Zip Drive for Data Storage,Black/Blue/Orange/Green/Purple (16G, 5Pcs Mixed Color)
32GB USB Flash Drive 3 Pack, RAOYI Mini USB Stick Bulk Thumb Drives Jump Drive Memory Stick Lanyard for Storage and Backup, Black
Western Digital 4TB My Book Desktop External Hard Drive, USB 3.0, External HDD with Password Protection and Backup Software - WDBBGB0040HBK-NESN
