November 2015, SQL Simantics

Full Outer Joins

Randy Sims SQL Fundamentals I

When you want to see a list of all values from two tables in a join, even if there are no matches, you want the Full Outer join. It fills in nulls on both sides where needed.

Using IN, ANY, and ALL Queries

Randy Sims SQL Fundamentals I

ANY and ALL queries are related to IN queries in that they are used for multi-row returns. They also allow comparisons to be made (equal, not equal, greater than, less than, etc.).

Order of SQL SELECT Clause Evaluation

Randy Sims SQL Fundamentals I

SQL Clauses are evaluated in the following order: Find Where Good Snakes Have Oaths FROM clause WHERE clause GROUP BY clause SELECT clause HAVING clause ORDER BY clause

Java Programmer 1 Exam Topics

Randy Sims Java

1Z0-808 – DevCert: Java SE 8 Programmer