Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     

Contact Us   -   Why Choose Wintrac   -   Clients    

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

View the Course Outline

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

Course includes 10+ hours of total training time...

  • 10 modules of training
  • Over 10 hours of media run time
  • Sample code
Format Modules Retail Price
SQL Azure



Buy Now!

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
  • Establish an Unencrypted Connection via SSMS to SQL Azure
  • SQL Azure Security
  • Firewall
  • Application Connection
  • 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
  • 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

back to top

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.

back to top

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