This course is designed for professionals who want to deepen their expertise in cloud data platform solutions with the Microsoft suite of services. This comprehensive training provides an overview of the Microsoft cloud data platform, covering core components such as Microsoft SQL Server and various cloud data offerings such as Cortana Analytics Suite, and data visualization techniques. Students will gain hands-on experience implementing SQL Server on Azure virtual machines, understanding the intricacies of virtual machine components, storage architecture, and deployment models.
The course also delves into the implementation of the SQL database, covering scalability options, performance tuning, and service level recommendations. Important aspects such as high availability (HA), disaster recovery (DR) strategies for SQL databases, and hybrid HA/DR scenarios with SQL Server are thoroughly explored. Designing and implementing security takes center stage in Module 6, where students learn about SQL database firewalls, Active Directory integration, encryption, and threat detection. To keep things running smoothly, the course also offers information on monitoring and managing Azure implementations using tools such as Azure Automation and Operational Insights.
Finally, it concludes with hands-on examples that guide learners through real-world scenarios for SQL Server and SQL database solutions, including hybrid environments and “lift and shift” migrations. After completing this course, students will be well prepared to design, implement, and manage reliable, secure, and scalable data platform solutions in the cloud, enhancing their professional abilities in the ever-evolving cloud environment.
Course prerequisites
To get the most out of the Designing and Implementing Cloud Data Platform Solutions course, it’s important to prepare with a basic understanding of certain issues. Here are the minimum prerequisites:
- Basic knowledge of Microsoft Windows operating systems and their basic functions;
- Familiarity with database concepts, including relational databases such as Microsoft SQL Server;
- Understanding of basic SQL syntax and database design principles;
- Some experience or familiarity with cloud computing concepts and technologies, including Microsoft Azure;
- A basic understanding of data storage and management in cloud environments.
Please note that while these prerequisites are intended to provide a foundation for the course, the instructors have the skills to guide students of all skill levels through the material to ensure a well-rounded learning experience.