SQL provides the largest return for the least effort. Use SQL to easily manipulate and extract your data exactly how you need it.
Freecontent below!
Learn More
Say goodbye to brute force data manipulations. SQL is here to work for you! Learning the basics of databases and SQL syntax will completely transform the time you spend in spreadsheets, in a good way. You'll also learn how to avoid common mistakes and correctly manage your work to ensure maximum accuracy.
2.0 hours of high-quality video
Before/After files
PDF slides and reference sheets
Hands-on exercises
Disclaimer!
Introduction
Watch Preview
Database Basics
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Watch Preview
SQL Installation and Orientation
Watch Preview
Style Guide
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Watch Preview
SQL Query Basics
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Exercise 1
Watch Preview
Functions and Operations
Exercise 2
Watch Preview
Query Framework
Free!
Click to watch a lesson
Exercise 3
Wrap Up
Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
What others are saying about this course!
“SQL wasn't required for my recruitment, but I have to use it constantly. I needed a basics course quick because Excel can't handle the millions of rows of data I need to analyze. This course is just what I needed to get started. I don't stress so much anymore, and I was surprised at how straight forward SQL really is.” -George
Are you ready to unlock SQL's true potential? Learning a few simple techniques such as window functions, variables, and pivoting will distill complex, time-consuming data transformations into one line of code. Yes, it's that simple! You'll also understand why query optimization matters and how it can save you and your organization time and money.
4.0 hours of high-quality video
Before/After files
PDF slides and reference sheets
Hands-on exercises
Disclaimer!
Introduction
Watch Preview
Union, Subqueries, and Window Functions
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Exercise 1
Watch Preview
Data Types and Joins
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Watch Preview
Tables and Variables
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Exercise 2
Watch Preview
More Window Functions and Group By
Watch Preview
Pivot, Unpivot, and Case Statements
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Watch Preview
Optimization
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Exercise 3
Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
What others are saying about this course!
“I've been writing queries for a while, but I've never used window functions. This one tip alone completely changes how I use SQL; I can slice my data sets and analyze the data exactly as I want. Wow! Everyone should know the patterns taught in this course.” -Lillian
“I know some SQL basics. I use that to pull data, export to Excel, and aggregate. After just 45 minutes with Matt, he taught me a few basics that turned my 500K row spreadsheet into 300 rows and saved me hours of time each week!” -Josie
“Matt’s very particular about staying organized in SQL. There’s a method to that madness – ugly code now irritates me, and I can’t live without his query framework which is taped next to my computer.” -Colton
“I got a data science degree, so I consider myself a SQL pro. Yeah, Matt showed me some tricks I didn’t know existed. I was jumping through coding hoops to solve problems that are taken care of by Matt's join tips.” -Andrea
Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
BizTrix offers the ability to mix and match course content to address team needs, including on-site trainings.
Learn More
If you are a professional who extracts, transforms, and analyzes data and does not use SQL, then this course is for you. Don’t let spreadsheet limitations or constrained, in-house BI software get in the way of answering your questions. Do exactly what you want with your data.
If you work with large volumes of data and that data is sourced from a database, then this course is for you.
If you are unsatisfied with the course, let us know. We’ll refund your purchase provided you contact us within 30 days of purchase and refrain from watching more than 25% of course content.
This course uses Microsoft SQL Server, which has a free license provisioned for development and test systems. If your system platform is a PC, then you can download and install the software easily (which is covered in the course). If your system platform is a Mac, then you will need a virtual machine or Docker container to run the software.
We accept payment via Stripe. All payments are processed securely using 128-bit SSL encryption. Furthermore, we encrypt all the data passing between our site and your device using HTTPS.
Don't miss out on any updates and new courses that are coming soon!
