Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 2/18/2013 | |
| Level | Intermediate | |
| Runtime | 1h 57m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | N/A | |
| Exams | Included |
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
This course is part of the following LearnNowOnline SuccessPaths™:
Microsoft Azure
Meet the expert
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)