SQL for Business Analytics
Learn this in-demand database management language to extract, transform, and analyze databases with precision.
Taught by Instructors with Experience At
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
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
- Course Overview
- Databases and SQL
- Tables and Keys
- Installing mySQL for Windows
- Installing mySQL for Mac
- MySQL Workbench Overview
- SQL Data Types
- Creating Databases
- Creating Tables
- Inserting Data into Tables
- Constraints and Defaults
- Update and Delete Tables
- Importing a database
- SELECT
- SELECT AS
- SELECT WHERE
- Practice Exercises
- DISTINCT & BETWEEN
- LIKE Operator
- REGEXP (Regular Expression)
- Practice Exercises
- Saving Your Query Scripts
- Aggregation Functions
- GROUP BY
- HAVING
- Practice Exercises
- Window Functions Theory
- Window Function Practice
- Rank Functions
- Lag and Lead
- Practice Exercises
- Types of JOINS
- INNER JOIN
- LEFT & RIGHT JOIN
- Multiple Tables
- Multiple Databases
- Practice Exercises
- Unions
- String Functions
- Date & Time Functions
- IF Function
- Case Statement
- Cast Function
- Practice Exercises
- Subqueries Part 1
- Subqueries Part 2
- 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
- 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
- Exporting and Importing to Excel and Power BI
- Creating a Live Connection with Excel and Power BI
- Next Steps
- Conceptual Questions Level 1 & 2
- Practical Question Level 3
- Practical Question Level 4
- Practical Question Level 5
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!
What our students say
Highly Recommend!
Yakuphan Alptekin
Informative
Tam Tran
Thank you!
Keith Aul
Just What I Needed!
Daniel Mwabila
Excellent
Bilal Kamara
Very detailed
Steven Huang
A Very Complete Course!
Teo Ballbe
Makes sense!
Ikmareka Hunt
I grow tremendously
Antonio Newman
Wonderful Course!
Ebenezer Anane
Awesome Course!
Andy Giro
Awesome learning Power BI
Jim Brooks
Recommend to those in finance
Aditiya Kusuma
I like this course and recommend it
Tom Munt-Davies
Exceeded my expectations
Khin Yaminn
I cannot recommend their courses highly enough!
Justin Galczynski
Well Done!
Tristan Chiu
Exceptional Training Solution!
Michael Penna
The Best!
Jasmine Akujobi
Clear Explanations!
Russell Tankoua
Great job!
Marco Franceschini
Great course
Tim Lorentz
I love that it's interactive
Ashley Thompson
Great Explanations!
Jamie Forschner
Engaging
Justin Risin
Excellent Experience!
David Rodrigues
Excellent
Joseph Daher
Keep up the good work!
Jennifer Ng
Beginner friendly
Julian Mascio
Well paced
Reeta Sooknah
Just What I was Looking For!
Rashed Al-Romaithi
Amazing Course!
Erik Reznicek
Clear, concise instruction
Matt Pounch
Great stuff!
David H
I do recommend it!
Vladimir Sobur
Very, very helpful!
Marco Horn
Perfect!
Murilo Cangueiro
This course is worth it!
Selasi Kwame
Super Helpful!
Isabella West
Learned a lot
Hai Nguyen
Extremely Impressed
Josh McDonald
Cheers!
Marvel Tanudjaja
Very Valuable
Robert Remondino
Amazing, Detailed and Realistic!
Ishaan Mathur
Worth the Money!
Jamaal Tobias
Great Content!
Naseef Kamal
Our Students Now Work At
Meet Your Instructors
Kenji Farre
Learn the skills you need to advance your career
Select the course or bundle that works best for you
- {yes} Understand essential terminology for databases, tables, and keys
- {yes} Import, clean, and analyze data in SQL
- {yes} Dozens of practice exercises to test your knowledge
- {yes} Learn industry best practices
- {yes} Ask our instructions questions if you get stuck
- {yes} McDonald's case study project
- {yes} Olympics case study projects
- {yes} Downloadable datasets and PDF files
- {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 & Macros Course
- {no} Get 4 courses for a discounted price
- {yes} Understand essential terminology for databases, tables, and keys
- {yes} Import, clean, and analyze data in SQL
- {yes} Dozens of practice exercises to test your knowledge
- {yes} Learn industry best practices
- {yes} Ask our instructions questions if you get stuck
- {yes} McDonald's case study project
- {yes} Olympics case study projects
- {yes} Downloadable datasets and PDF files
- {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 & Macros Course
- {yes} Get 4 courses for a discounted price
FAQs
Frequently Asked Questions
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.
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.
Absolutely! You will have access to the instructors to ask anything about the course content using the discussions forum in each lesson.
Yes, you can access the course content on any device including a smartphone, tablet, or computer. All you need is an internet connection.
You will have lifetime access to the lessons and materials. The course can be taken on both smartphone and computer.
For any other general inquiries, please contact us at info@careerprinciples.com