SQL for Data Analytics Courseware (55232AC)

This course is designed as an introductory course for data scientists and data analysts who need to master Microsoft’s data analytics tools and platform.  At the end of the course, you’ll be prepared to efficiently and competently implement TSQL for data retrieval and analysis, and be well-prepared to:

1. Take on a professional project role responsible for retrieving relational database data and preparing it for analysis and loading into an analytical data store, such as a Power BI or Power Pivot data model;
2. Take additional coursework for which knowledge of TSQL is required or desirable, such as courses for Power BI and Microsoft Power Platform, Azure Synapse Analytics, Data Engineering, Python, R, etc.

With a focus on those parts of the TSQL language most useful for data retrieval and analysis, students learn the database fundamentals necessary to both efficiently create TSQL queries and create a data warehouse implemented as a star schema. By the end of the course, students are able to analyze a real-word data retrieval problem, and write queries to address it using advanced features within the SELECT statement.

Our goal is to help you efficiently achieve your learning and skill goals. We hope you’ll find this Cuban Sandwich Press course to be the best technical training course you’ve ever taken!

This is an updated version of Microsoft Community Course 55232 Writing Analytical Queries for Business Intelligence.