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 given 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 done 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.
Retrieve and filter data using basic SQL syntax
Transform data with the help of numerical, date, and text functions
Why stop here? Expand your skills and show your expertise with the professional certifications, specializations, and CPE credits you’re already on your way to earning.