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
Database Basics
Free!
Click to download lesson slide(s)
SQL Installation and Orientation
Style Guide
Free!
Click to download lesson slide(s)
SQL Query Basics
Free!
Click to download lesson slide(s)
Exercise 1
Functions and Operations
Exercise 2
Query Framework
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
“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 MoreDon't miss out on any updates and new courses that are coming soon!
