Learn your way! Get started

Microsoft SQL Azure

with expert Scott Klein

Course at a glance

Included in these subscriptions:

Dev & IT Pro Video
Dev & IT Pro Power Pack

	Release date	7/22/2011
	Level	Intermediate
	Runtime	10h 37m
	Closed captioning	N/A
	Transcript	N/A
	eBooks / courseware	N/A
	Hands-on labs	N/A
	Sample code	Included
	Exams	Included

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

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 Microsofts Azure Platform. In this course you will see what SQL Azure is, how it works and how to administer it. You will learn about designing a database and how to apply sharding and federations. You will then learn how to secure the database in the cloud. Then how to migrate any existing databases, about reporting, datasync and application connectivity. Then wrap up with an OData overview with mobile application, backing up and restoring and Azure Storage Interoperability.

Prerequisites

A good understanding of SQL Server 2005 or higher and SQL Server Management Studio.

Meet the expert

Scott Klein, a Microsoft SQL Azure MVP, has been working with SQL Server for nearly 20 years, working with companies large and small all over the United States. 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.

Course outline

Module 1

SQL Azure Overview (43:41)

Introduction (02:17)
Introducing Azure Platform (01:43)
Where"s my stuff? (00:57)
History of SQL Server (01:11)
Server is not a Machine (01:04)
How it Works (02:35)
Key Benefits (03:27)
Quick Comparison (06:02)
What about the DBA? (00:40)
Size Matters (00:56)
Pricing (01:13)
Considerations (06:38)
Demo: Azure Overview (03:37)
Demo: Creating a Server (08:15)
Demo: Creating a Database (02:43)
Summary (00:15)

Module 2

Administering SQL Azure (46:30)

Introduction (00:46)
Administering SQL Azure (03:15)
Azure Management Portal (02:38)
SQL Server Management Studio (01:22)
Silverlight SQL Manager (01:49)
SQL Azure Management API (02:54)
Monitoring SQL Azure (02:03)
Throttling and Load Balancing (03:53)
Demo: Management Portal Overview (05:11)
Demo: Managing a Database (08:53)
Demo: Management Studio (07:43)
Demo: Azure vs. On Premise (05:37)
Summary (00:21)

Administering SQL Azure Demo (01:02:39)

Introduction (00:33)
Demo: Creating a Certificate (06:27)
Demo: Exporting Certificate (02:41)
Demo: Creating Application (03:14)
Demo: Firewall Rule (04:14)
Demo: Calling Code (18:23)
Demo: More Firewall Rules (18:53)
Demo: Deleting Firewall Rule (07:55)
Summary (00:15)

Module 3

Design and Development (30:52)

Introduction (00:46)
Design and Development (02:24)
Offsite Storage (01:12)
High Availability (01:47)
Performance (03:56)
Direct vs Service Connections (02:01)
Pricing (02:54)
Security (01:52)
Design Patterns (01:14)
Branching (01:16)
Other Design Concepts (02:57)
Development (00:59)
Unsupported T-SQL (02:39)
SMO (00:49)
Applications (03:32)
Summary (00:24)

Design and Development Demo (15:50)

Introduction (00:30)
Intro to Demo (01:14)
Demo: Retry Logic (02:05)
Demo: Get Sequel Context Info (05:24)
Demo: Transient Framework (06:14)
Summary (00:20)

SQL Azure Security (32:07)

Introduction (00:50)
Security Overview (01:43)
Confidentiality (00:49)
Integrity (01:02)
Availability (01:02)
SQL Azure Security (03:49)
Encryption (02:22)
Authentication, Authorization (01:11)
Comparison (02:16)
Firewall (01:06)
What is Missing? (00:33)
Best Practices (03:04)
Demo: Management Studio (06:39)
Demo: Management Portal (04:57)
Summary (00:38)

Module 4

SQL Azure Migration (44:53)

Introduction (00:47)
Migrating Database to SQL Azure (04:24)
Generate Scripts Wizard (02:18)
SQL Azure Migration Assistants (02:09)
SQL Azure Migration Wizard (01:40)
Data-tier Application Component (02:04)
SQL Server Integration Services (01:58)
Bulk Copy (01:41)
Sync Framework (03:35)
SQL Azure Data Sync Services (03:41)
Things to Consider (04:20)
Demo: Generate Scripts Wizard (15:43)
Summary (00:26)

SQL Azure Migration Demo (25:19)

Introduction (00:29)
SSIS Demo (16:15)
SSMA for MS Access (08:21)
Summary (00:13)

Module 5

SQL Azure Reporting (13:08)

Introduction (00:55)
SQL Azure Reporting (01:46)
Functionality (01:42)
Services Provided (02:39)
Feature Summary (01:31)
Security (01:17)
Architecture (01:59)
Best Practices (01:01)
Summary (00:16)

SQL Azure Reporting Demo (28:29)

Introduction (00:36)
Intro to Demo (03:03)
Demo: Creating a Report (06:43)
Demo: Publishing the Report (03:17)
Demo: Access from Applications (11:31)
Demo: Debugging (03:05)
Summary (00:12)

Module 6

SQL Azure Data Sync (23:28)

Introduction (00:58)
SQL Azure Data Sync Service (03:20)
Key Features (02:31)
On-Premises to Cloud Symmetry (01:43)
Extending Data (03:05)
Prerequisites (01:04)
Terms (02:11)
Sync Scenarios (01:54)
What are the Steps? (01:03)
Monitoring Syncronizations (02:06)
Best Practices (03:07)
Summary (00:21)

SQL Azure Data Sync Demo (21:01)

Introduction (00:15)
Demo: Creating a Database (02:29)
Demo: Setting up Synchronization (11:10)
Demo: Synchronization (07:04)
Summary (00:02)

Module 7

SQL Azure Federation (26:04)

Introduction (01:03)
Scalability (02:48)
Approaches (02:17)
Scalability Curves (00:51)
Scaling can be Challenging (02:57)
Sharding (00:31)
Sharding Pattern (04:31)
Introduction to Federations (03:09)
Federation Architecture (03:56)
How does this work? (02:12)
Handling Growth (01:32)
Summary (00:13)

SQL Azure Federation Demo (48:46)

Introduction (00:42)
Demo: Federation Root Database (04:58)
Demo: System Tables (09:02)
Demo: Insert Data in Table (03:53)
Demo: Splitting Federation (06:31)
Demo: Sharding Sample (10:20)
Demo: Running and Debugging App (06:43)
Demo: Execute with Thread Pool (06:00)
Summary (00:34)

Module 8

Azure Application Connectivity (27:18)

Introduction (00:55)
Connecting to SQL Azure (04:26)
SQL Azure Firewall (01:48)
Accessing Data (01:36)
Your Data in the Cloud (02:20)
Your Application in the Cloud (01:18)
Connection Constraints (02:30)
Connection Termination (06:58)
Best Practices (05:02)
Summary (00:20)

Azure App Connectivity Demo (34:20)

Introduction (00:45)
Demo: Windows Forms App (03:40)
Demo: Connect to Local Database (02:04)
Demo: Pull Data from Database (04:20)
Demo: Point to Azure Database (02:36)
Demo: Creating Web App (04:31)
Demo: Adding WCF Data Service (02:24)
Demo: Consuming Data Service (06:28)
Demo: Adding Data to List (04:34)
Demo: Running and Debugging (02:32)
Summary (00:21)

Module 9

Azure OData (11:17)

Introduction (00:41)
SQL Azure and OData (01:10)
OData Overview (01:13)
OData Producers (00:52)
OData Consumers (01:15)
OData and SQL Azure (01:58)
Enabling OData (00:31)
Security (01:44)
OData Best Practices (01:29)
Summary (00:20)

Azure OData Demo (13:33)

Introduction (00:35)
Demo: OData Enable Database (02:51)
Demo: OData Feed (03:29)
Demo: Making Application (06:20)
Summary (00:16)

Azure Backup (20:11)

Introduction (00:46)
SQL Azure Backup and Restore (03:30)
SQL Azure Backup (03:12)
As Copy Of (02:52)
Permissions Needed (00:50)
Syntax and Monitoring (01:41)
Point-In-Time Restore (02:18)
3rd Party Products (02:58)
Enzo Backup continued (01:39)
Summary (00:20)

Azure Backup Demo (15:34)

Introduction (00:41)
Demo: As Copy Of (04:15)
Demo: Enzo Backup (10:21)
Summary (00:15)

Module 10

Azure Storage (27:56)

Introduction (00:53)
Azure Storage (01:57)
Storage Infrastructure (01:45)
Windows Azure Storage (04:04)
Azure Storage Abstractions (02:37)
Accessing Storage with REST (01:25)
Using a Library (02:49)
Connection Strings (00:44)
Object Hierarchy (01:17)
Table Structure (04:10)
SQL Azure vs Azure Table (05:50)
Summary (00:20)

Azure Storage Demo (24:14)

Introduction (00:31)
Intro to Demo (02:30)
Demo: Running Guestbook (02:40)
Demo: Adding Data to Table (12:46)
Demo: Running and Debugging (05:35)
Summary (00:09)