Advanced SQL Azure Training Course
Course 50592
|
|
Your satisfaction is our top priority
"The instructor is a very knowledgeable teacher with tons of good will to help, very available and his personality is fantastic."
-Amine B.
View more testimonials >
"The instructor is a very knowledgeable teacher with tons of good will to help, very available and his personality is fantastic."
-Amine B.
View more testimonials >
Course Overview
This class 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. Audience
Course 50592: Advanced SQL Azure is targeted at IT professionals that want to learn to maintain SQL Azure databases and architects that want to learn to leverage SQL Azure in their applications. Course Outline
Module 1: Overview A simple introduction module. After completing this module, students will be able to:
Module 2: Introduction to SQL Azure In this module we will explore what SQL Azure is, it's architecture, ways that you can use it in your applications and most importantly how much it costs! Lessons
Module 3: SQL Azure RDBMS Support In this module we 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
Module 4: SQL Azure Security Lessons
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
Module 6: Maintaining and Optimizing 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 and Throttling). Lessons
Module 7: Migrating and Synchronizing to SQL Azure In this module 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 databases. Lessons
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
|
Have a Microsoft Voucher? |
Alexandria | Atlanta | Austin | Baltimore | Birmingham | Buffalo | Boise | Boston | Boulder | Charleston | Charlotte | Chicago | Cincinnati | Cleveland | Columbus | Dallas | Denver | Des Moines | Detroit | Hartford | Houston | Indianapolis | Jacksonville | Kalamazoo | Las Vegas | Los Angeles | Melville | Nashville | New Orleans | New York | Orlando | Overland Park | Palm Beach Gardens | Philadelphia | Phoenix | Pittsburgh | Princeton | Providence | Raleigh | Reno | Salt Lake City | San Antonio | San Diego | San Francisco | Savannah | Scottsdale | Seattle | St. Louis | Tallahassee | Tampa | Toronto | Washington DC | Wichita