50592A: Advanced SQL Azure


This 4-day instructor led course is an in-depth look at SQL Azure, the database cloud offering in Windows Azure. Learn the basics around server and database provisioning, valid Azure TSQL, and how security is implemented and managed. Advanced topics include partitioning with sharding, database design optimization, backup and synchronization via Synchronization Framework and Azure Data Sync and migrating various database scenarios to SQL Azure.

After completing this course, students will be able to:

  • Learn to design high performance cloud based data storage solutions using SQL Azure. Topics include security, programming, maintaining, optimizing, migrating and synchronizing with SQL Azure. SQL Azure Reporting is also explored.


IT Pros that want to learn to maintain SQL Azure databases and architects that want to learn to leverage SQL Azure in their applications.


Before attending this course, students must have:

  • Understanding of basic SQL concepts (TSQL and tables)


  • Overview
  • Introduction to SQL Azure
  • SQL Azure RDBMS Support
  • SQL Azure Security
  • Programming SQL Azure
  • Maintaining and Optimizing SQL Azure
  • Migrating and Synchronizing to SQL Azure
  • Business Intelligence with SQL Azure


A simple introduction module.

Introduction to SQL Azure

In this module we will explore what SQL Azure is, it’s architecture, ways that you can use it in your applications and most importantly how much it costs!

  • Lessons
    Introduction to SQL Azure
  • Lab : Setup Azure Account
    Create a LiveID
    Setup Azure Account
    Add SQL Azure subscription
    Create SQL Azure server
    Create SQL Administrators

SQL Azure RDBMS Support

In this module we take a look at supported Azure T-SQL including creating tables, columns and indexes. We will also explore how to work with temp tables and transactions.

  • Lessons
    RDBMS Support
  • Lab : Creating Databases and Tables
    Create SQL Azure Databases
    Create SQL Azure Tables
  • Lab : Exploring Valid SQL Azure TSQL
    Create Tables
    Create Views
    Create Stored Procedures
    Create Indexes
    Create Transactions
    Working with Temp Tables
    Invalid Azure TSQL statements

SQL Azure Security

In this module we take a look at the lessons of the module!

  • Lessons
    SQL Azure Security
  • Lab : SQL Azure Security
    Creating Logins and Users
    Assigning Roles
    Assigning Rights to Objects

Programming SQL Azure

In this module we take a look at 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
  • Lab : Connecting to SQL Azure
    Use SQL Server Management Studio
    Use SQLCMD
    Use Visual Studio 2010
  • Lab : Programming SQL Azure
    Connecting to SQL Azure from code (.NET)
    Working with LINQ
    Working with Entity Framework
  • Lab : Securing Data at Rest
    Secure data at Rest
  • Lab : Implementing Partitions and Shards
    Implementing Horizontal Partitions
    Implementing Vertical Partitions
    Programming with Enzo SQL Shared

Maintaining and Optimizing SQL Azure

In this module we take a look at how to maintain SQL Azure databases, how to optimize databases and how to troubleshoot connectivity problems (DoS and Throttling).

  • Lessons
  • Lab : Maintaining SQL Azure
    Measure Latency to SQL Azure
    Find database size
    Monitor database sessions
    Find top 5 queries (CPU and IO)
    Rebuild a database index
  • Lab : Performing Baselines
    Use Enzo SQL to perform baselines
  • Lab : Backup SQL Azure
    Backup SQL Azure (Azure Storage Account)
    Backup SQL Azure (SQL Management Studio)
    Backup SQL Azure (BCP)
    Backup SQL Azure (RedGate)
  • Lab : Restore SQL Azure
    Restore SQL Azure (Azure)
    Restore SQL Azure (SQL Management Studio)
    Restore SQL Azure (BCP)
  • Lab : Using Query Analyzer and Client Statistics
    Using Query Analyzer
    Using Client Statistics

Migrating and Synchronizing to SQL Azure

In this module we take a look at 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
  • Lab : Migrating to SQL Azure
    Migrating the database schema
    Migrating database data
    Migrating with SQL Server Migration Assistant
    Migration with SQL Azure Migration Wizard
    Migrating with DAC Import/Export 2.0
    Migrating with SQL Server Integration Services (SSIS)
  • Lab : Using Microsoft Sync Framework
    Working with Microsoft Sync Framework
  • Lab : Using Azure Data Sync
    Working with SQL Azure Data Sync

Business Intelligence with SQL Azure

In this module we take a look at 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
  • Lab : Business Intelligence with SQL Azure
    Working with SQL Azure Reporting
    Lab : PowerPivot with SQL Azure
    Integrating PowerPivot and SQL Azure

Quero saber mais informações sobre este curso

50592A: Advanced SQL Azure

Microsoft | 24h


Pretende mais informação sobre este curso?

Preencha o formulário com os seus dados e as suas questões e entraremos em contacto consigo para lhe darmos todas as informações pretendidas.