50592-SP : Self-Paced : Advanced SQL Azure

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.

Features:

• Full HD Videos
• 24x7 Access
• Access from anywhere, anytime, any device
• Embedded Quizzes
• No-Cost Cert Preps included
• Azure Pass (with $100.00 spending limit)

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

• Introduction to SQL Azure

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

• RDBMS Support

Module 4: SQL Azure Security

This module will take a look at the lessons of the module!

Lessons

• SQL Azure Security

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

• Programming SQL Azure
• Accessing SQL Azure

Module 6: Maintaining andOptimizingSQL Azure

This module describes how to maintain SQL Azure databases, how to optimize databases and how to troubleshoot connectivity problems (DoS and Throttling).

Lessons

• Optimizing
• Maintaining
• Troubleshooting

Module 7: Migrating andSynchronizingto 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

• Synchronizing to SQL Azure
• Migrating to SQL Azure

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

• PowerPivot and SQL Azure
• SQL Azure Reporting

Before attending this course, candidates must have:

• Understanding of basic SQL concepts (TSQL and tables)