Self-Paced : Advanced SQL Azure

Duration : 7.5 hrs. Videos

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

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)

Regular Price : ~~$49.99~~
Special Price :$9.99

Self-Paced : Advanced SQL Azure

This course includes: