Advanced SQL Azure

Have Queries? Ask us +91 72592 22234

Course Overview

The Advanced SQL Azure Training gives 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.

Course Content

Introduction to SQL Azure

  • 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

  • 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

  • SQL Azure Security

Lab : SQL Azure Security

  • Creating Logins and Users
  • Assigning Roles
  • Assigning Rights to Objects

Programming SQL Azure

  • 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

  • Optimizing
  • Maintaining
  • Troubleshooting

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

  • 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

  • PowerPivot and SQL Azure
  • SQL Azure Reporting
  • Configuring Migration Settings

Lab : Business Intelligence with SQL Azure

  • Working with SQL Azure Reporting

Lab : PowerPivot with SQL Azure

  • Integrating PowerPivot and SQL Azure

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234