No items found.

SQL for Business Analytics

Learn this in-demand database management language to extract, transform, and analyze databases with precision.

play icon

Taught by Instructors with Experience At

Overview

What you’ll learn

Most of the world's data is stored in databases, so being able to extract, transform, and analyze databases with precision using SQL is an essential skill for the modern analyst. After completing this course, you'll know how to create databases, manipulate data, and write SQL queries to unlock valuable business insights. As with many coding languages, SQL can be daunting, so we start with the very basics and progressively work towards more complex subjects. if you get stuck along the way, you can always ask our instructors questions!

70+ High Quality Lessons

Downloadable Datasets and PDF files

Real-World Case Study Projects

Lifetime Access on Any Device

Student Profiles

Who are these courses for?

University Students

If you're a college student looking to secure an internship or full-time job in a top tier business, finance, or investment firm, these courses are for you.

Working Professionals

If you're a working professional looking to level up your technical career skills, these courses are for you.

Career Switchers

If you're looking to boost your technical skills to better your chances of switching into a business or finance role, this course is for you.

Understand SQL and Database Fundamentals

We teach you all of the confusing terminology such as relational database management systems, schemas, joins, unions, window functions, and much more. Once you're comfortable with these, we go over industry best practices to make sure you learn the correct way.

Practice Using Real-World Scenarios

To make this course job-relevant, we simulate real-world scenarios where you'll be working as an analyst exploring real databases, responding to questions from different divisions, and writing your own queries to extract the relevant information.

Level Up Your Career in Data or Business

This courses is specifically tailored to current or aspiring professionals in data-driven roles such as data analysts, financial analysts, or business analysts. These are among the most lucrative careers in the world. By learning SQL, you'll be better equipped for today's fast-paced business world.

Course Curriculum

Module 1: Introduction to SQL and Databases
  • Course Overview
  • Databases and SQL
  • Tables and Keys
  • Installing mySQL for Windows
  • Installing mySQL for Mac
  • MySQL Workbench Overview
Module 2: Creating Databases, Tables, and Values
  • SQL Data Types
  • Creating Databases
  • Creating Tables
  • Inserting Data into Tables
  • Constraints and Defaults
  • Update and Delete Tables
Module 3: Basic SQL Queries
  • Importing a database
  • SELECT
  • SELECT AS
  • SELECT WHERE
  • Practice Exercises
  • DISTINCT & BETWEEN
  • LIKE Operator
  • REGEXP (Regular Expression)
  • Practice Exercises
  • Saving Your Query Scripts

Module 4: Group By & Window Functions
  • Aggregation Functions
  • GROUP BY
  • HAVING
  • Practice Exercises
  • Window Functions Theory
  • Window Function Practice
  • Rank Functions
  • Lag and Lead
  • Practice Exercises
Module 5: Multiple Tables with JOIN
  • Types of JOINS
  • INNER JOIN
  • LEFT & RIGHT JOIN
  • Multiple Tables
  • Multiple Databases
  • Practice Exercises
  • Unions
Module 6: Advanced Functions & Queries
  • String Functions
  • Date & Time Functions
  • IF Function
  • Case Statement
  • Cast Function
  • Practice Exercises
  • Subqueries Part 1
  • Subqueries Part 2
Module 7: McDonald's Restaurant Analysis Case Study
  • Importing the Dataset
  • Removing Duplicates
  • Fixing Errors
  • Rounding Consistency
  • Splitting Columns
  • Blank and Null Values
  • Finance Team Data Analysis
  • Compliance Team Data Analysis
  • Marketing Team Data Analysis
Module 8: Olympics Analysis Case Study
  • Importing the Dataset
  • Removing Duplicates (Different Method)
  • Working with Blank Values
  • Data Types
  • Capital Letter Consistency
  • Data Analysis Part 1
  • Data Analysis Part 2
  • Data Analysis Part 3
Module 9: Working With Other Applications
  • Exporting and Importing to Excel and Power BI
  • Creating a Live Connection with Excel and Power BI
  • Next Steps
Bonus Module: SQL Interview Questions
  • Conceptual Questions Level 1 & 2
  • Practical Question Level 3
  • Practical Question Level 4
  • Practical Question Level 5

Get Certified!

Impress recruiters with your resume

Upon completion of all course lessons, you will receive a digital certificate with your credentials. Furthermore, you can add it to your LinkedIn to show your skills to recruiters!

career principle certificate
Testimonials

What our students say

This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.

Our Students Now Work At

Instructors

Meet Your Instructors

Kenji Farre

Senior Instructor
Hey there, I’m Kenji, a Cornell University graduate and Microsoft MVP with work experience at companies like Amazon, Goldman Sachs, and PwC. Over the past year, our tutorials have helped 15M+ people level up their Excel, Business, and Data skills. I know exactly where the pain points are -I’ve lived them myself. Looking forward to getting started!
Course Pricing

Learn the skills you need to advance your career

Select the course or bundle that works best for you

SQL for Business Analytics
Single Course
Was:
$179.00
Includes:
  • {yes} Understand essential database terms
  • {yes} Import, clean, and analyze data in SQL
  • {yes} Dozens of practice exercises to test your knowledge
  • {yes} Learn industry best practices
  • {yes} McDonald's case study project
  • {yes} Olympics case study projects
  • {yes} Downloadable datasets and PDFs
  • {yes} Earn the SQL course certificate
  • {no} Access to the full Excel Course
  • {no} Access to the full Power BI Course
  • {no} Access to the full VBA Course
  • {no} Get 4 courses for the price of 2.5
Get started
Bundle
Was:
Includes:
Get started
The Data Analyst Program
Career Track
Was:
$449.00
Includes:
  • {yes} Understand essential database terms
  • {yes} Import, clean, and analyze data in SQL
  • {yes} Dozens of practice exercises to test your knowledge
  • {yes} Learn industry best practices
  • {yes} McDonald's case study project
  • {yes} Olympics case study projects
  • {yes} Downloadable datasets and PDFs
  • {yes} Earn the SQL course certificate
  • {yes} Access to the full Excel Course
  • {yes} Access to the full Power BI Course
  • {yes} Access to the full VBA Course
  • {yes} Get 4 courses for the price of 2.5
Get started

FAQs

Frequently Asked Questions

Do I need to know some SQL before I take this course?

Not at all! This is a beginner-friendly course so you don't need any previous experience with SQL or coding/programming. It can be an advantage if you are already familiar with Excel, but it's not a requirement.

What relational database management system do you use?

In this SQL course we use MySQL which is the most popular relational database management system and is free to install for both Mac and Windows operating systems.

What if I get stuck? Can I ask questions about the content?

Absolutely! You will have access to the instructors to ask anything about the course content using the discussions forum in each lesson.

Can I access the course on my smartphone?

Yes, you can access the course content on any device including a smartphone, tablet, or computer. All you need is an internet connection.

How long will I have the course materials for?

You will have lifetime access to the lessons and materials. The course can be taken on both smartphone and computer.

More questions?

For any other general inquiries, please contact us at info@careerprinciples.com