Download PDF
of this course

MS50592 - Advanced SQL Azure (MS50592)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration : 4 Days

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.

Who Should Attend

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

Course Certifications

This course is part of the following Certifications:

Prerequisites

Before attending this course, students must have:

  • Understanding of basic SQL concepts (TSQL and tables)

Course Objectives

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.

Course Content

Module 1 : Overview

A simple introduction module 

After completing this module , students will be able to :

Understand your course , classroom , classmates , facility and instructor

 

Module 2 : Introduction to SQL Azure

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

Lessons 

  • Introduction to SQL Aure

Lab : Setup Azure Account

After completing this module , students will be able to :

  • Determine the cost of storing data in Windows Azure 
  • Setup SQL Azure databases through Developer Portal

 

Module 3 : SQL Azure RDBMS Support

In this module we will 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

Lab : Exploring Valid SQL Azure TSQL

After completing this module , students will be able to :

  • Create SQL Azure Databases and Tables
  • Under what TSQL is supported
  • Created SQL Azure Views and stored procedures

 

Module 4 ; SQL Azure Security 

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

Lessons 

  • SQL Azure Security 

Lab : SQL Azure Security 

After completing this module , students will be able to ;

  • Desribe how SQL Azure security works
  • Create and assign firewall rules
  • creates server logins
  • Assign permissions to users 
  • Assign rights to objects

 

Module 5 : 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 

Lab : Programming SQL Azure

Lab : Securing Data at Rest 

Lab : Implementing Partitions and Shards

After completing this module , students will be able to :

  • Connect to SQL Azure from your favourite tools
  • Porgram SQL Azure with Entity Framework
  • Secure your SQL Azure Data at Rest
  • Implement partitions using sharding 
  • Understand how to use Enzo SQL Shard SDK

 

Module 6 : Maintaining and Optimimzing 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 Throtting ).

Lessons

  • Optimizing 
  • Maintaining 
  • Troubleshooting

Lab : Maintaining SQL Azure

Lab : Performing Baselines

Lab : Backup SQL Azure

Lab : Restoe SQL Azure 

Lab : Using Query Analyzer and Client Statistics

After completing this module , students will be able to :

  • Maintain SQL Azure
  • Perform baselines for on-premise and SQL Azure Databases
  • Perform backups of SQL Azure using various tools
  • Perform a restore of SQL Azure
  • Use Query Analyzer and Client Statistics

 

Module 7 : Migrating and Synchronizing to SQL Azure

In this modile 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 databses

Lessons 

  • Synchronizing to SQL Azure 
  • Migrating to SQL Azure

Lab : Migrating to SQL Azure 

Lab : Using Microsoft Sync Framework

Lab : Using Azure Data Sync

After completing this module , students will be able to ;

  • Export your on-premise database schemas for SQL Azure
  • Migrate data to SQL Azure using various tools
  • Synchronize data with SQL Azure using Azure Data Sync
  • Synchronize data with SQL Azure using Microsoft Synchronization Framework

 

Module 8 : 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 

Lab : PowerPivot with SQL Azure 

After completing this moduel , students will be able to :

  • Create SQL Azure Reporting Services instances
  • Create data sources in SQL Azure Reporting 
  • Create reports and deploy them to SQL Azure Reporting 

Course ID: MS50592


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register