SQL for Data Analytics (2 day, extended hours)

2 days, extended hours each day.
 
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 implement TSQL for data retrieval and analysis, and be well-prepared for further coursework requiring this knowledge, such as courses for Azure Synapse Analytics, Azure Data Bricks, Azure Machine Learning, and Power BI.
 
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!
 
While based on sound principles informed by instructional science and years of experience, it’s really very easy to understand. My goal, in the end, is to have you leave the class with a robust mental model of TSQL and its use within Microsoft’s analytical platforms. Having a mental model of the system means having enough conceptual understanding of what’s happening and why, so that your hands-on development of TSQL code to solve real-world analytical problems can happen accurately and efficiently once you’re back on the job solving real-world problems.
 
The course design takes a hands-on, project-based approach to learning and helping you build that mental model. This means that both conceptual content and hands-on exercises are oriented toward solving real-world analytical problems within a learning environment that simulates real-world systems to the extent manageable by students.

Learning Goals:
 
Understanding database queries within analytical/reporting application architectures
Basic database concepts for data analysts
Creating Azure SQL databases
Query development tools such as SQL Server Management Studio
A deep dive into the SELECT query, including (but not limited to) joins, subqueries, derived tables, common table expressions, and views
Implementing a data model as a star schema using views
Creating an Azure Synapse Analytics workspace and running SQL queries against large text files using serverless SQL pools
Using SQL in the process of Importing, combining, and visualizing data from an Azure SQL database and an Azure Synapse Analytics Serverless SQL pool in Power BI

The course is composed of six content modules. Each module contains four items in the course materials section of the Cubansandwichpress.com Web site:
 
.pdf file which serves as the written courseware or book on which everything else is based
Pre-recorded video of an annotated presentation on the module’s topics
.pdf file containing hands-on lab instructions
Video demonstration of how to successfully complete the hands-on lab
 
In addition to the above, students attend a live, instructor-led presentation followed by a question & answer session. Each instructor-led session is followed by a hands-on lab session. An instructor is available during the hands-on lab sessions to answer questions, provide coaching, etc.