Introduction to SQL Azure
Index

Collapse All Expand All Language Filter: All Language Filter: Multiple Language Filter: Visual Basic Language Filter: C#

Visual Basic Usage
C#

#### Hands-On Lab

# Introduction to SQL Azure

Lab version:2.0.0

Last updated:9/19/2011

# Contents

### Overview

### Exercise 1: Preparing Your SQL Azure Account

Task 1 – Retrieving your SQL Azure Server Name

### Exercise 2: Working with Data Basic DDL and DML

Task 1 – Creating a New Database

Task 2 – Managing your Database with the Database Manager for SQL Azure

Task 3 – Managing your Database with SQL Server Management Studio

Task 4 – Creating Logins and Database Users

Task 5 – Creating Tables, Indices, and Queries

### Exercise 3: Build a Windows Azure Application that Accesses SQL Azure

Task 1 – Loading the Sample Database into SQL Azure

Task 2 – Creating the Visual Studio Project

### Exercise 4: Connecting via Client Libraries

Task 1 – Opening the Begin Solution and Exploring the Common Functionalities

Task 2 – Connecting to SQL Azure Using ADO.NET

Task 3 – Connecting to SQL Azure Using ODBC

Task 4 – Connecting to SQL Azure Using OLEDB

Task 5 – Connecting to SQL Azure Using Entity Framework

Task 6 – Connecting to SQL Azure via Non-Microsoft Technologies

### Summary