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

Wednesday, September 13, 2017

Digging-in on SQL Server

A good analyst's skillset should have a solid foundation in databases and SQL. So, when time permits, always looking to brush-up in that department, and recently have had the chance to really dig-in on study & practice with more advanced multi-join queries, aggregation, T-SQL date & string functions, as well as refreshing some old background with SQL Server Integration Services (SSIS). ...Anyone remember when those were called "DTS Packages" (data transformation services)?

These days at least, SQL Server and its Data Tools components are freely downloadable, so was able to do some practice with SSMS 2008, and then the rest with SQL 2016 and SSMS 2017. ...More to come for sure.

One of my Review Slides for Wildcard String-Selections

Great Review Slide for Right Joins


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