• Twitter
  • Facebook
  • Pinterest
  • LinkedIn
  • Qlik
  • PowerBI

Thursday, July 27, 2017

SQL Bootcamp

Whatever your focus is when working with data, it helps to know your SQL.  So, enjoying this brush-up from the "Complete SQL Bootcamp" on www.Udemy.com.

In this example using PostgreSQL, it shows how the WHERE clause is used before the HAVING clause.  ...Why?  Well, the HAVING clause was added in SQL to allow selection/filtering by the *grouped* amounts (in this case, aggregated by AVG()), while WHERE filters from the originally-selected records.

Key SQL Note:  Reminder of how different data-types work (in PostgreSQL)

Key SQL Note:  Maybe best diagram of effect of different JOIN-types

Key SQL Note:  Subqueries


Garrett's Calendar ---> Free 15-min. Consultation

Send a quick question here:


1400 N Lake Shore Drive #3C

Chicago, IL

Phone Number

(630) 730-5305

E-Billing Methods Accepted: Visa/MC/AMEX & Bitcoin