Windows Azure 2012, Part 6 of 8: SQL Azure and Websites

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.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

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

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.

Video Runtime

117 Minutes

Time to complete

157 Minutes

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)