Advanced SQL Azure training is a four-day course that provides advanced knowledge of SQL Azure, and the database cloud offering in Windows Azure. This course will drive the training from the basics around server and database provisioning, valid Azure TSQL, and learn how security is implemented and managed. Thereafter, the advanced topics will include partitioning with sharding, database design optimisation, backup and synchronisation via Synchronisation Framework and Azure Data Sync and migrating various database scenarios to SQL Azure.
After completing the Advanced SQL Azure Training, candidates will be able to design high-performance cloud-based data storage solutions using SQL Azure. The topics in the training session include security, programming, maintaining, optimising, migrating and synchronising with SQL Azure.
Module 1: Overview
A simple introduction module.
Module 2: Introduction to SQL Azure
This module describes what SQL Azure is, the architecture, and ways that you can use it in your applications and most importantly how much it costs!
Lessons
Module 3: SQL Azure RDBMS Support
This module describes the supported Azure T-SQL including creating tables, columns and indexes. We will also learn to work with temp tables and transactions.
Lessons
Module 4: SQL Azure Security
This module will take a look at the lessons of the module!
Lessons
Module 5: Programming SQL Azure
This module describes the various ways to access SQL Azure, some of the tools that make working with SQL Azure easier (Entity Framework and LINQ), and an advanced coverage of Sharding.
Lessons
Module 6: Maintaining and Optimizing SQL Azure
This module describes how to maintain SQL Azure databases, how to optimize databases and how to troubleshoot connectivity problems (DoS and Throttling).
Lessons
Module 7: Migrating and Synchronizing to SQL Azure
This module describes how to migrate your databases to SQL Azure and how you can use Microsoft Synchronization Framework and Azure Data Sync to synchronize your Azure databases with on premise databases.
Lessons
Module 8: Business Intelligence with SQL Azure
This module describes SQL Azure Reporting Services and how to use PowerPivot to connect Excel 2010 to SQL Azure data.
Lessons
This course is intended for IT Professionals who are wanting to learn to maintain SQL Azure databases and architects who want to learn to leverage SQL Azure in their applications.
Before attending this course, candidates must have:
Understanding of basic SQL concepts (TSQL and tables)
Name | Code | Fee |
---|
OR