VIEWS - Complex Queries, Cross Joins, Unions, and more
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.
Stay tuned! Bonus features for this video are under development...
Course Page
Course Description
In this Introduction to SQL Course, you will learn the essential queries needed to work with a relational database: How to create data (INSERT), change existing data (UPDATE), and find data (SELECT and JOINs). You will also learn how to choose a database, install PostgreSQL, speed up queries with indexes, and more.