SQL Excel

Sql Excel: subqueries for union all
Sql Excel: exists and not exists operators
Sql Excel: not in operator
Sql Excel: correlated subqueries
Sql Excel: rewriting the in as a join
Sql Excel: subqueries and in
Sql Excel: subqueries for handling summaries
Sql Excel: subqueries and common table expressions are our friends
Sql Excel: window functions
Sql Excel: in
Sql Excel: case
Sql Excel: union all
Sql Excel: other important capabilities in sql
Sql Excel: outer joins
Sql Excel: none quit joins
Sql Excel: lookup a useful join
Sql Excel: cross joins the most general joins
Sql Excel: what it means to join tables
Sql Excel: a basic summary sql query
Sql Excel: a basic sql query
Sql Excel: dataflows sql and relational algebra
Sql Excel: sort ordering the results of a dataset
Sql Excel: join combining two tables using a key column
Sql Excel: crossjoin generating the cartesian product of two tables
Sql Excel: lookup looking up values in one table in another
Sql Excel: aggregate aggregating values
Sql Excel: append appending new calculated columns
Sql Excel: filter filtering rows based on a condition
Sql Excel: select selecting various columns in the table
Sql Excel: output outputting a table or chart
Sql Excel: read reading a database table
Sql Excel: tip
Sql Excel: what is a dataflow
Sql Excel: tips on naming things
Sql Excel: the customer id identifying customers over time
Sql Excel: purchases dataset
Sql Excel: subscription dataset
Sql Excel: the zip code tables
Sql Excel: what is an entity relationship diagram
Sql Excel: column types
Sql Excel: allowing null values
Sql Excel: what is a table 2
Sql Excel: what is a table
Sql Excel: picturing the structure of the data
Sql Excel: sql
Sql Excel: nosql and other types of databases
Sql Excel: hadoop and hive
Sql Excel: databases sql and big data