top of page
SQL for Data Analytics
  • SQL for Data Analytics

SQL for Data Analytics

$1,695.00Price

SQL for Data Analytics

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.

    VIDEOS

    Free Video 1

    Free Video

    Free Video 1

    Free Video

    Lab Walkthrough 1

    Lab 1 Walktrhough

    Lab Walkthrough 2

    Lab Walkthrough 2

    Module 1 Instructor Presentation, Part 1

    Module 1, Part 1.

    Module 1 Instructor Presentation, Part 1

    Module 1, Part 1.

    Module 1 Instructor Presentation, Part 2

    Module 1, Part 2

    Module 1 Instructor Presentation, Part 2

    Module 1, Part 2

    Module 1, Lab Exercise 1

    Walkthrough of lab solution.

    Module 1, Lab Exercise 1

    Walkthrough of lab solution.

    Module 1, Lab Exercise 2

    Walkthrough of lab solution.

    No Video Found!

    TEXT

    Module 1

    Courseware Module 1

    Module 1

    Content on which the live presentation is based.

    Module 1 Lab Instructions

    Courseware Module 1 Lab Instructions

    Module 1 Lab Instructions

    Instructions for the hands-on lab following the live presentation.

    Module 2

    Content on which the live presentation is based.

    Module 2

    Courseware Module 2

    Module 2 Lab Instructions

    Courseware Module 2 Lab Instructions

    Module 2 Lab Instructions

    Instructions for the hands-on lab following the live presentation.

    Module 3

    Content on which the live presentation is based.

    Module 3

    Courseware Module 3

    Module 3 Lab Instructions

    Instructions for the hands-on lab following the live presentation.

    No Documents Found!

    LIVE SESSIONS

    SQL for Power BI Bootcamp Day 2

    Time:

    No Live Sessions Found!

    bottom of page