SQL Fundamentals


Level 5

Approx to complete

100% online and self-paced

Subscribe to get access to BIDA™ and other programs

From $497/year

Learn More


SQL Fundamentals Course Overview

SQL plays a foundational role in Business Intelligence as it provides us with a way to extract data from databases for use in other BI tools. 

This course covers SQL’s foundational syntax and essential transformations with practical, hands-on examples. To do this, learners are provided with access to an Azure Data Studio data warehouse from which they can run the queries taught throughout this course. Connecting to the data warehouse is simple and can be from a Windows, iOS, or Linux computer.

This course will walk you through retrieving and filtering data from a database with basic SQL syntax, transforming that data with functions, combining data from multiple tables, best practices when using SQL and common mistakes. By the end of this course, you'll have the core skills business analysts need to extract data from a database using SQL.

SQL Fundamentals Learning Objectives

Upon completing this course, you will be able to:

  • Retrieve and filter data using basic SQL syntax

  • Transform data with the help of numerical, date, and text functions

  • Identify strategies for constructing an unbiased sample

  • Understand essential terminology related to SQL, databases, and data warehouses

Chapter 3 learning objectives

SQL Fundamentals is a Course from CFI’s BIDA™ Program

CFI's upcoming Business Intelligence & Data Analyst (BIDA)™ program will cover all the basic, intermediate, and advanced topics about business intelligence and data analysis. This program will teach you the quantitative methods used in the finance and capital markets industry. It is ideal for students who want to learn how to analyze complex data.

Common career paths for students who take the BIDA™ program are Business Intelligence, Asset Management, Data Analyst, Quantitative Analyst, and other finance careers.

Students can sign up for updates and reserve a spot in the Business Intelligence & Data Analyst (BIDA)™ Program on the student dashboard. 

Who Should Take This Course?

The SQL Fundamentals is perfect for those with zero prior experience with SQL or for those who just want a refresher on the fundamentals and best practices. As with any coding language, SQL can be daunting to learn, which is why this course starts with super simple examples and works slowly up to more complex theories. Every concept and step is explained clearly and with as non-technical language as possible.

What You'll Learn


Become a certified Business Intelligence & Data Analyst (BIDA)™

SQL Fundamentals is part of the Business Intelligence & Data Analyst (BIDA)™ certification, which includes 17 BIDA courses + all future courses in the program.

Business Intelligence & Data Analyst (BIDA)™ Certification
  • Skills Learned Data Visualization, Data Warehousing and Transformation, Data Modeling and Analysis
  • Career Prep Business Intelligence Analyst, Data Scientist, Data Visualization Specialist

What Our Students Say

Great course
great course i have ever seen fro SQl , everythingwas organized . Lectures were not stretched , onpoint . The best part is you get to practise real time on datawarehouse , gives feel like actual business work

Jahanvee Narang

Detailed Course
Very detailed, easy to follow, and challenging. Once you finish, you feel confident using SQL.

Javier Guerra

The course is really great and I would definitely recommend this to others. Thanks CFI

Muzammil Kholia

Amazing & worthwhile course. Highly recommend.
This course allowed me to now be able to know how to write queries on demand (provided the database is in decent condition) to get the results needed by business stakeholders. The theory part was also so important for teaching me how to converse with our tech team and developers - thus knowing what to ask for and being able to provide reasonable explanations as to why.

Michael Kelly

See More

Frequently Asked Questions

How do I enroll in this course?
Are there any additional fees or costs?
What currency are your courses priced in?
Can I download the Excel files and financial modeling templates for the course?
How long do I have to complete the courses?
Are CFI courses officially accredited?
How do I earn my certificates?
Can I email the instructor if I have questions?
Will these courses help me advance my career?
What is included in the subscription?
More Questions?