Nombre de jours

1 day(s)

Audience

This course is intended for IT Pros that want to learn to maintain Microsoft Azure SQL databases and architects that want to learn to leverage Microsoft Azure SQL databases in their applications.

Prerequisites

Before attending this course, students must have an understanding of basic SQL concepts (TSQL and tables) and a basic knowledge of the Microsoft Windows operating system and its core functionality.

Objectives

After completing this course, participants will be able to design high performance cloud based data storage solutions using SQL Azure. Topics include security, maintaining, optimizing, migrating and synchronizing with SQL Azure. SQL Azure Reporting is also explored.

Methods

Instructor led training alternated with demos and exercises. Each student disposes of a workstation. All the labs for this course can be performed using the provided virtual machines and a trial subscription to Microsoft Azure.

Description

This course is an in-depth look at Microsoft Azure SQL Database, the database cloud offering in Micorsoft Azure. Learn the basics around server and database provisioning, valid Azure TSQL, and how security is implemented and managed. Advanced topics include database migration, backup and synchronization via Azure SQL Data Sync, cloud reporting using Report Builder and Visual Studio Report Server, designing and tuning for scalability and the building of cloud solutions. Microsoft Live account and Microsoft Azure subscription will be created during the course. No personal information is required.

Contents

• Module 1: Getting started with Microsoft Azure SQL Database
  • the concept of cloud computing
  • Subscribing Microsoft Azure
  • Creating a server
  • Creating a Microsoft Azure Database
• Module 2: Configuration and pricing
  • Using the Microsoft Azure platform Management Portal
  • Using the Azure Preview Portal
  • Using SQL Server Management Studio
  • Using PowerShell
  • Budgeting for SQL Database
• Module 3: Differences between SQL Server and Microsoft Azure SQL Database
  • Size limitations
  • Connection limitations
  • Unsupported features
• Module 4: Migrating Databases
  • Migrating data using Transact_SQL scripts
  • SQL Data-tier applications
  • SQL Server Bulk Copy (bcp)
  • SQL Database Migration Wizard
• Module 5: Security and Backup
  • Addressing major cloud concerns
  • Securing SQL Database
  • Backing up SQL Database
• Module 6: Cloud reporting
  • Creating a SQL Server Reporting Services Virtual machine
  • Using Report Builder
  • Using Visual Studio Report Server Projects
  • Implementing Report security
  • Shutting down the SSRS Virtual machine
• Module 7: Microsoft Azure SQL Data Sync
  • What is SQL Data Sync
  • Creating the SQL Database
  • Working with SQL Data Sync
  • Pitfalls and best practices
• Module 8: Designing and tuning for scalability and high performance
  • Achieving high performance in the cloud
  • Creating a RESTfull web API
  • Managing SQL Database connections
  • Reducing network latency
  • Effectively using SQL Database
  • Optimizing Queries
  • Scaling up SQL Database
  • Partitioning Data
• Module 9: Monitoring and management
  • Monitoring
  • Programming the Service Management REST API
• Module 10: Building cloud solutions
  • Creating the SQL Database
  • Extending the SQL Database
  • Creating the data access layer
  • Creating the website
  • Creating the ASP.NET Web API services
  • Creating the Windows application