Learn your way! Get started

Windows Azure 2012, Part 6: SQL Azure and Websites

with expert Mike Benkovich


Watch trailer

Windows Azure 2012, Part 6: SQL Azure and Websites Trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack
  • Power Pack Plus

Release date Release date 2/18/2013
Level Level Intermediate
Runtime Runtime 1h 57m
Closed captioning Closed captioning N/A
Transcript Transcript N/A
eBooks / courseware eBooks / courseware N/A
Hands-on labs Hands-on labs N/A
Sample code Sample code N/A
Exams Exams Included


Enterprise Solutions
Enterprise Solutions

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



Course description

This is an overview of working with SQL Azure and how it is different than SQL Server on Premise. We show creating a server, adding databases, migrating data to the database in the cloud, and some of the connection patterns for working with the data. Then you’ll be shown how to create a site and work with deployments, including TFS and GIT. You’ll see scaling, custom domain names, and web site configuration.

Prerequisites

The viewer should be familiar with web interfaces, SQL, SQL Management Studio, and Visual Studio.

Learning Paths

This course will help you prepare for the following certification and exam:
MCSD: Web Applications
70-487: Developing Windows Azure and Web Services

Meet the expert

Mike Benkovich Mike Benkovich delivers technical presentations around the U.S. as a consultant, trainer, and former Developer Evangelist for Microsoft. He has worked in a variety of professional roles including architect, project manager, developer, and technical writer. Mike is also an author of two books, published by WROX Press and APress, that show developers how to get the most from their SQL databases. Since appearing in the 1994 Microsoft DevCast, Mike has presented technical information at seminars, conferences, and corporate boardrooms across America.


Course outline



SQL Azure

Provisioning (16:46)
  • Introduction (00:34)
  • Windows Azure (00:29)
  • Start With the Basics (01:39)
  • Provision Your Server (02:16)
  • Demo: Provision a Server (01:51)
  • Demo: Create a Database (04:56)
  • Demo: Database Properties (04:41)
  • Summary (00:17)
Build Your Database (18:32)
  • Introduction (00:35)
  • Build Your Database (01:24)
  • Use Familiar Technologies (00:28)
  • Supports Popular Frameworks (00:58)
  • Compared to SQL Server (01:52)
  • Unsupported SQL Server Features (02:00)
  • Rich Client Environment (01:17)
  • Demo: Building a Database (05:34)
  • Demo: Connecting (04:09)
  • Summary (00:10)
Programming (19:26)
  • Introduction (00:33)
  • Securing a Database (00:28)
  • Benefits (02:28)
  • Feature Parity (01:12)
  • SQL Azure Compatibility (00:50)
  • Application Topologies (02:11)
  • Connect Your Application (02:56)
  • Demo: Working With Data (04:49)
  • Demo: Managing Data (03:37)
  • Summary (00:19)
Deployments and Migration (29:29)
  • Introduction (00:34)
  • Deploy Your Database (02:25)
  • Migration Options (01:44)
  • SQL Server Migration Assistant (00:21)
  • SQL Server Management Studio (01:37)
  • SQL Azure Migration Wizard (01:48)
  • SQL Azure Import and Export (01:29)
  • Demo: Migrating to SQL Azure (03:45)
  • Demo: Another Migration Option (11:32)
  • Demo: SQL Azure Synch (03:54)
  • Summary (00:16)

Azure Websites

Hello Azure Websites (14:46)
  • Introduction (00:42)
  • Windows Azure Web Sites (01:47)
  • Application Scenarios (01:36)
  • Demo: Azure Websites (03:56)
  • Demo: Website Details (02:54)
  • Demo: Website Stats (03:18)
  • Summary (00:30)
Scalability (06:23)
  • Introduction (00:39)
  • Web Sites (01:35)
  • Demo: Scaling (03:50)
  • Summary (00:18)
Frameworks (11:59)
  • Introduction (00:27)
  • Supported Web Frameworks (00:27)
  • Supported Publishing Methods (00:34)
  • Partners (00:16)
  • Demo: Publishing (03:48)
  • Demo: Load Publishing Settings (04:20)
  • Start Simple (00:48)
  • Code Smart (01:02)
  • Summary (00:13)