Study Guide - TrIxXr4kDz/SQL GitHub Wiki

TEST MOD 2 Query- pulling data from a database, another name for a select statement Joins – bring two tables together by one common key, usually the primary or unique values Types of joins - Left, right, inner, outer, full outer. Union – joins two select statements together Having clause – a where clause that allows aggregate functions or use a where clause on a group by Subquery- trying to find out if another table has records that are the same or exist/don’t exist. Select statement inside another select statement. Count * - looks up all the rows data including nulls. Cartesian join – two tables joining and displays any possibility of data avail, bad join Aggregate functions - avg, sum, min, max, count(column), count (*). 4 set operators – union, union all, intersect, minus