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

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

Uploaded March 2019 | Updated September 2026, 3 weeks ago

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 : patreon.com/socratica
► Make a one-time PayPal donation: paypal.me/socratica
► We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9

Thank you!

♦♦♦♦♦♦♦♦♦♦

Connect with us!

Facebook: facebook.com/SocraticaStudios
Instagram: instagram.com/SocraticaStudios
Twitter: twitter.com/Socratica

♦♦♦♦♦♦♦♦♦♦

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

♦♦♦♦♦♦♦♦♦♦

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

How to Build a Simple Budget That Works 💰 Personal Finance

Chemistry: Ideal Gas Law + 5 example problems

BUY or LEASE a Car? 🚗 Personal Finance

SQL Joins Explained |¦| Joins in SQL |¦| SQL Tutorial

Covariance Explained ← Probability & Statistics

Threads and Threading in Python

This Card Choice Could Cost You More Than You Think 💰 Personal Finance

$Text Preprocessing « NLP « Machine Learning – Mathematica Essentials Mathematica Essentials - the first PRO COURSE from Socratica Buy here: https://www.socratica.com/courses/mathematica-essentials Learn along with free Mathematica notebooks available on github: https://github.com/socratica/wolfram 𝙒𝘼𝙉𝙏 𝙈𝙊𝙍𝙀? https://snu.socratica.com/mathematica To be notified about updates to our first Pro Course Mathematica Essentials,, join our mailing list at: https://snu.socratica.com/mathematica Natural Language Processing (NLP) is a specialized field within machine learning, focused on interpreting and processing HUMAN language, or natural language. This is crucial, as only a fraction of the population knows a computer language. In this video, we explore the basics of text preprocessing, using Mathematica to demonstrate some of the techniques including tokenization (creating a list of words without punctuation), normalization (putting data into standard form, for instance, no capital letters), removing stop words, stemming and/or lemmatization (replacing similar words with a common stem or a representative word). BTW—Socratica offers a pro course, Mathematica Essentials, providing key concepts for mastering Wolfram products: https://www.socratica.com/courses/mathematica-essentials You can jump to sections of the video here: 0:00 What is Natural Language Processing (NLP) 0:58 What is Preprocessing? 1:36 Intro to Text Preprocessing 2:22 Sample Text before Preprocessing 3:00 Tokenization (List of words) 3:55 Case normalization (standard form, no capitals) 4:33 Removing Stop words (little information) 5:42 Stemming & Lemmatization Thank you to our VIP Patreon Members who helped make this video possible! KW, M Andrews, Jim Woodworth, Massimiliano Pala, Marcos Silveira, Christopher Kemsley, Eric Eccleston, Jeremy Shimanek, Michael Shebanow, Alvin Khaled, Kevin B, John Krawiec, Umar Khan, and Tracy Karin Prell — we are so happy to have you on our team! — Thank you kind friends! 💜🦉 ✷✷✷ We recommend the following (affiliate links): The Wolfram Language https://amzn.to/3D4jqvz The Mythical Man Month - Essays on Software Engineering & Project Management http://amzn.to/2tYdNeP Innumeracy: Mathematical Illiteracy and Its Consequences http://amzn.to/2ri1nf7 Mindset by Carol Dweck https://amzn.to/2q9y8Nj How to Be a Great Student (our first book!) ebook: https://amzn.to/2Lh3XSP Paperback: https://amzn.to/3t5jeH3 Kindle Unlimited: https://amzn.to/3atr8TJ ✷✷✷ If you find our work at Socratica valuable, please consider becoming our Patron on Patreon! https://www.patreon.com/socratica If you would prefer to make a one-time donation, you can also use Socratica Paypal https://www.paypal.me/socratica ✷✷✷ Written & Produced by Michael Harrison & Kimberly Hatch Harrison Edited by Megi Shuke About our Instructors: Michael earned his BS in Math from Caltech, and did his graduate work in Math at UC Berkeley and University of Washington, specializing in Number Theory. A self-taught programmer, Michael taught both Math and Computer Programming at the college level. He applied this knowledge as a financial analyst (quant) and as a programmer at Google. Kimberly earned her BS in Biology and another BS in English at Caltech. She did her graduate work in Molecular Biology at Princeton, specializing in Immunology and Neurobiology. Kimberly spent 16+ years as a research scientist and a dozen years as a biology and chemistry instructor. Michael and Kimberly Harrison co-founded Socratica. Their mission? To create the education of the future. ✷✷✷ Welcome to Socratica! We make SMART videos focusing on STEM - science, math, programming. Subscribe here: http://bit.ly/SocraticaSubscribe PLAYLISTS Study Tips http://bit.ly/StudyTipsPlaylist Python programming http://bit.ly/PythonSocratica SQL programming http://bit.ly/SQL_Socratica Chemistry http://bit.ly/Chemistry_Playlist Abstract Algebra http://bit.ly/AbstractAlgebra Astronomy http://bit.ly/AstronomySocratica Biology http://bit.ly/BiologySocratica Calculus http://bit.ly/CalculusSocratica Geometry https://bit.ly/GeometrySocratica Mathematica http://bit.ly/SocraticaMathematica #MachineLearning #TextPreprocessing #Mathematica$

Perfect Numbers, Mersenne Primes, Abundant Numbers & Deficient Numbers || NUMBER THEORY

Ideals in Ring Theory (Abstract Algebra)

PREDICT THE FUTURE — Study Tips #shorts

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