Workshop: The Cloud Workshop for the SQL Professional
A Microsoft Course from the SQL Server team
About this Workshop
Welcome to this Microsoft solutions workshop on The Cloud Workshop for the SQL Professional.
In this course you will learn how to solve modern data challenges with Azure SQL using a hands-on lab approach.
This course is intended to be taken as a self-paced or instructor-led workshop. A supplement slide deck is available for this course in the slides folder.
This course is designed for data professionals who have a basic working knowledge of SQL Server and the T-SQL language.
Setup
This workshop is broken up into several modules than can all be taken together or in groups:
- Modules 1 and 2 are fundamentals about Azure and Azure SQL but have no hands-on exercises. You can review the materials in the supplied presentation. It is highly recommend to review these module slides before working on the hands-on exercises for the rest of the modules.
- Modules 3 and 4 are about SQL Server on Azure Virtual Machines and designed to be completed together.
- Modules 5 and 6 are about Azure SQL Managed Instance and designed to be taken together.
- Module 7 is about Azure SQL Database can be taken independently from other modules.
In order to complete the exercises in this workshop you will need the following:
- Download the lab files from https://aka.ms/cloudsqlworkshopfiles for all modules.
- You will need an Azure subscription that has Azure Role-Based Control (RBAC) rights and resource quotas to deploy Azure Virtual Machines, Azure SQL Managed Instances, and Azure SQL Database depending on what modules you complete.
- You will need rights to deploy a SQL Server 2022 virtual machine from the marketplace for Modules 3 and 4. You can use Developer Edition to save costs.
- Module 7 requires the ability to use an additional Microsoft Entra ID account but you can skip that exercise in that module if you don't have this.
Workshop Modules
All instructions for completing hands-on exercises for all modules can be found by navigating to the workshop folder. Each module has a separate folder with exercise instructions and in some cases scripts to use. Modules 1 and 2 are only presentations and do not have hands-on exercises.
Contributing
Microsoft and any contributors grant you a license to the Microsoft documentation and other content in this repository under the Creative Commons Attribution 4.0 International Public License, see the LICENSE file, and grant you a license to any code in the repository under the MIT License, see the LICENSE-CODE file. All license files are found in the LICENSE directory.
This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.
When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.
Trademarks
This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.