Microsoft SQL Azure

Email Us Phone : 503-259-0312

Order CD-ROMs Order Videos
Microsoft SQL Azure with Scott Klein

View the Course Outline

10 modules of training

Over 10 hours of media run time

Sample code

Format	Modules	Retail Price
SQL Azure
DVD-ROM	1 DVD-ROM	$395
Read about Scott Klein

Course Outline(Outlines are subject to change.)

Microsoft SQL Azure

Modules	Run Time
10	10 hours

Your company is thinking about placing its SQL Database in the cloud and you need to figure out how to do it. This course will give you the fundamentals of SQL Azure, part of Microsoft’s Azure Platform. In this course you will see what SQL Azure is, how it works and how to administer it. You’ll learn about designing a database and how to apply sharding and federations. You will then learn how to secure the database in cloud. Then how to migrate any existing databases, about reporting, datasync and application connectivity. Then wrap with an OData overview with mobile application, backing up and restoring and Azure Storage Interoperability.

In this course, you will learn:

About the Management Portal
How to use SQL Server Management studio with SQL Azure
About designing your SQL Azure database with Security in mind
To establish an eunencrypted connection via SSMS to SQL Azure
How to use the Generate Scripts Wizard
About best practices for SQL Azure reporting services
About Performance and Scalability
About syntax and monitoring for backup and restoring

Prerequisites :

Must have a good understanding of SQL Server 2005 or higher and SQL Server Management Studio.

SQL Azure Overview

Look at Management Portal
Provisioning of Account/Subscription
Creation / Provisioning of Server
Creation of Databases

Administering SQL Azure

SQL Server Management Studio
Silverlight SQL Manager
SQL Azure Service Management API - Done
Throttling / Load Balancing

Design Concepts

Design Factors
Offsite Storage
Security
Design Patterns
Sharding/Federation

Security

Establish an Unencrypted Connection via SSMS to SQL Azure
SQL Azure Security
Firewall
Application Connection

Migration

Migrating Database to SQL Azure
Generate Scripts Wizard
SSMA for Access
SQL Server Integration Services
Sync Framework
SQL Azure Data Sync Services

SQL Azure Reporting

Provided Services
Architecture
Best Practices

SQL Azure Data Sync

Key Features
SQL Azure to SQL Azure
On Premise to SQL Azure

Sharding / Federation

Performance vs. Scalability
Sharding
Introducing SQL Azure Federations

Application Connectivity

Connecting to SQL Azure
Connection Constraints
ADO.NET
WCF Data Services

SQL Azure / OData

OData Overview
Security
iPhone Example

Backup / Restore

Backup and Restore Strategy
Syntax and Monitoring
Restore

SQL Azure / Azure Storage Interoperability

Storage Infrastructure
Accessing Storage with REST
Connection Strings
SQL Azure vs. Azure Table

Your Instructor

Scott Klein, a Microsoft SQL Azure MVP, is co-founder of Blue Syntax Consulting, an Azure training, services and consulting company. Scott has been working with SQL Server for nearly 20 years, working with companies large and small all over the United States in a wide scope of fields such as medical, finance, and retail. Scott is also a veteran author, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Entity Framework 4.0, and the recently released Pro SQL Azure. Scott is President of the South Florida SQL Server Users Group and the newly formed SQL Azure PASS Virtual Chapter. He speaks frequently at SQL Saturday events and user groups, including several in Europe.

Best Replica Watches Rolex Replica Watches www.bestreplicashop.com

	About us Contact us Careers at Wintrac Our Clients Why Wintrac	Register for a free training CD-ROM drawing Refer a client or instructor and earn $$$	Wintrac Inc. 16523 SW McGwire Ct. Beaverton OR 97007
? Wintrac, Inc. All rights reserved. Site Map \| Terms of Use \| Privacy Policy