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.
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
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.
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.
4 courses from beginner to intermediate level.01 Optional
14 courses from beginner to intermediate level.02 Required
8 courses in advanced and intermediate levels.03 Optional
Submit your BIDA checklist and order your certificate.04 Required
Get access to the Global Corporate Finance Society.05 Optional
Business Intelligence & Data Analyst (BIDA)™ courses are offered 100% online, allowing you the flexibility to start the Business Intelligence & Data Analyst (BIDA)™ program anytime and learn when it’s most convenient for you.
The program is a part of the All Access Subscription, which includes all programs and courses.
CFI courses are designed by instructors with over 21 years of financial analyst training experience.