SQL Azure Training - Product Information


We have 3 seperate SQL Azure training products. Here are the product details:

1. SQL Azure Video Tutorials - Basic Package - DVD Format:


The SQL Azure training dvd has all the SQL Azure video tutorials on a DVD. This SQL Azure training dvd will be mailed to you after the purchase is completed.

This product includes the following 9 lessons:

  • How to sign up for SQL Azure from Windows Azure Platform?
  • How to create a SQL Azure database?
  • Working with SQL tables in Microsoft SQL azure
  • How to Import data to SQL azure from SQL Server 2008?
  • Configure Security Administration in SQL Azure Cloud Databases
  • Project Houston - Management Tool for SQL Azure
  • Creating SQL Azure stored procedures and views in SQL Azure
  • Working with SQL Joins, Primary Key (PK) and Foreign Keys (FK)in Azure SQL database
  • How to migrate a complete database from local SQL Server 2008 to Cloud SQL Azure?

2. SQL Azure Video Tutorials - Basic Package - Online Download Format:


Using the download format, all the SQL Azure training videos are available from one of our ftp sites. After the purchase, you will be emailed instructions on how to download all the files directly to your computer. With this option, you do not have to wait for snail mail and will have instant access to the SQL Azure training online.

This product includes the following 9 lessons:

  • How to sign up for SQL Azure from Windows Azure Platform?
  • How to create a SQL Azure database?
  • Working with SQL tables in Microsoft SQL azure
  • How to Import data to SQL azure from SQL Server 2008?
  • Configure Security Administration in SQL Azure Cloud Databases
  • Project Houston - Management Tool for SQL Azure
  • Creating SQL Azure stored procedures and views in SQL Azure
  • Working with SQL Joins, Primary Key (PK) and Foreign Keys (FK)in Azure SQL database
  • How to migrate a complete database from local SQL Server 2008 to Cloud SQL Azure?

3. SQL Azure Video Tutorials - Unlimited Package (1 year) - Online Download Format:


This option will give you unlimited access to our member section. This section includes SQL Azure video lessons and Transact SQL scripts. As our trainers come up with new database training material on SQL Azure, you will be the first one to access this unreleased content. This is an excellent way to learn SQL Azure online.

This product includes the following 9 lessons:

  • How to sign up for SQL Azure from Windows Azure Platform?
  • How to create a SQL Azure database?
  • Working with SQL tables in Microsoft SQL azure
  • How to Import data to SQL azure from SQL Server 2008?
  • Configure Security Administration in SQL Azure Cloud Databases
  • Project Houston - Management Tool for SQL Azure
  • Creating SQL Azure stored procedures and views in SQL Azure
  • Working with SQL Joins, Primary Key (PK) and Foreign Keys (FK)in Azure SQL database
  • How to migrate a complete database from local SQL Server 2008 to Cloud SQL Azure?

PLUS the follow Transact SQL scripts:

  • create_database_SQL_Azure_0001.sql
  • create_table_SQL_Azure_0002.sql
  • how-to-create-sql-azure-login-0003.sql
  • sql-azure-database-user-0004.sql
  • using-aggregate-functions-sql-server-0005.sql
  • missing-extended-stored-procedures-Azure-0006.sql
  • sql-statements-not-supported-sql-azure-0007.sql
  • alter-table-cloud-database-sql-azure-0008.sql
  • create-primary-key-foreign-key-constraints-0009.sql
  • assign-database-role-and-manage-permissions-0010.sql
  • how-to-use-sql-select-in-azure-0011.sql
  • using-sql-update-qry-azure-0012.sql
  • delete-records-in-sql-azure-database-0013.sql
  • insert-data-into-sql-azure-table-0014sql.sql
  • how-to-create-stored-procedure-cloud-db-0015.sql

We have some of the above Transact SQL scripts for FREE download here ...


SQL Azure Training - Detailed Information

Here is detailed information on SQL Azure video tutorial lessons:

How to sign up for SQL Azure from Windows Azure Platform?

We kick off this training series on SQL Azure tutorials with the first lesson, "How to signup for SQL Azure?" In order to do this, you have to sign up with Microsoft Online services. We show you how to get the process going and from the products we select Windows Azure Platform Introductory special. We login using Windows Live ID and then enter some basic profile information. Next we create Azure SQL subscription name that will be used to identify our Cloud database service from others. We go ahead and enter address information, billing info and then accept the Online subscription agreement. After our Windows Azure Platform subscription is provisioned, we can log into account using either http://SQL.azure.com or http://windows.azure.com . Once we log back into Windows Azure Platform, we cover the following topics: Project tab with the account information and Subscription ID. The instructor walks you through the steps of creating a new Azure SQL server, entering the administration information, similar in concept of the SA account in SQL server. We wrap things up by going over App Fabric, connection string and Market place information. (Duration: 12 minutes)

How to create a SQL Azure database?

In this training video on SQL Azure, we discuss how to create an azure cloud database. We will use two methods to achieve this objective: http://SQL.azure.com or SSMS (SQL Server Management Studio). In the first option, we show you how to login the Azure SQL portal with Windows Live ID. Then we cover some of the basic features after we login to our account Windows Azure account. Next we go ahead and create a web edition database of size 1 GB. We tried to test connectivity which fails on the first run. This leads us to the next topic of setting up firewall rules for SQL Azure. We go over setting up a rule for Microsoft services in addition to one for our local home office. Next we switch gears and show you how to create another SQL Azure cloud database using SQL Server Management Studio. We discuss the limited functionality in SQL azure Management Studio vs. a standalone SQL server. In SQL azure you do not have the luxury of creating a database using a graphic inter user phrase. As such we are limited to using to TSQL (Transact SQL) code. We show you an example of using TSQL in SQL Azure to create a database. We end the training demo by going over some of the other limitations in SQL azure TSQL. (Duration: 15 minutes)

Working with SQL tables in Microsoft SQL azure

We start off this video training on SQL azure by going over SQL Server management studio for SQL Server 2008 R2. In SQL Azure the SSMS environment is limited to databases, security and management tabs. For our first topic we look at CREATE TABLE sql command that it. We go over the basic SQL syntax and then demonstrate some examples of CREATE TABLE, one with CUSTOMERS table and one with ORDERS table from Northwind sample SQL database. In this Azure video, we also go over how to script an existing table and then show how to delete a table from within SSMS. Next we move on and cover the important ALTER TABLE command. This sql command can be use to add, modify and delete columns in a permanent SQL Azure table. We expand the subject by going over quite a few examples of ALTER TABLE command: how to change the field size? How to add a primary key? How to add a new column? How to delete a column? How to add a check constraint and finally how to drop an existing constraint? We end this training session on Azure tables by going over the drop table command, SP_help than also ALT + F1. (Duration: 27 minutes)

How to Import data to SQL azure from SQL Server 2008?

One of the most important thing in database administration is to import and export data from one database to another. In this training demo on SQL Azure, we will demonstrate how to move data from local on premise SQL Server 2008 to SQL Azure in the cloud environment. Before you get started, you do need to have the destination table in Azure SQL database first. Using transact SQL code we create the PRODUCTS table and also create clustered index on it. Next we use Business Intelligence Development Studio (BIDS) to create a SQL Server Integration Services (SSIS) project. We are going to configure data source from the local SQL Server instance and also create a destination to the cloud SQL Azure server. Next we configure a Data Flow task using the Control Flow tab in Visual Studio. We create an OLE DB source and point it to the local data source are created in the earlier step. After that we create an ADO Net destination and point this to the cloud SQL azure database. We have to make sure the column mappings between the source and the destination databases are proper. Once everything looks good, we go ahead and Execute the SSIS package, this fails on the first attempt. We do a little troubleshooting and find out that the Nullability is not the same between the two SQL tables. We fix the issue and rerun Integration Services package to finally move the data from local SQL database to the Cloud database. (Duration: 24 minutes)

Configure Security Administration in SQL Azure Cloud Databases

Security is a huge topic in cloud databases due to the increasing exposure to hackers and malicious software. We start off this training session on Cloud databases by discussing different layers of security including Physical, OS and Surface area security. We move onto elaborate security lingo including Principles, Roles, Schema, Encryption and Securables. In the first Azure demo the video shows you how to create Azure SQL login and then use ALTER LOGIN statement to update the password. We also discuss the differences between Server level roles and database level roles. In the second Video on SQL Azure security, we create a database user, then login to SQL Azure as the user and try to run a SELECT statement. When the statement fails, we add the user to the db_datareader role using the sp_addrolemember system stored procedure and rerun SELECT statement. We cover Catalog Views including sys.server_principals and sys.database_principals which can be used to find user and role information in the database. If you want to find which user belongs to which database, we go over that. We enclose up the Azure learning session by going over CREATE SCHEMA, GRANT, DENY commands that will help you manage permissions in SQL Server. (Duration: 28 minutes)

Project Houston - Management Tool for SQL Azure

"Project Houston" is a lightweight and easy to use database management tool for SQL Azure. It is a Web application that is available for download from http://SQLAzureLabs.com .This tutorial video starts off by discussing background and download location for Project Houston. We quickly jump into a demo where we first show you how to connect to SQL Azure server. Once we are in the database management tool, we go over the Object Explorer in Project Houston similar to SSMS. We demonstrate how to create a new table, add table fields and modify Azure table properties. One nice feature about Project Houston is that you can also insert data to your tables. After adding new records, we switch to query management functionality and show you how to create in new TSQL query. Moreover you have the ability to save and open an existing sql statement. When you execute the SQL statement, you do get one pane for query results and one with messages. One limitation of this is the inability to copy or export data from the Azure management tool to an external application. We end the training Azure session by going over SQL views, SQL stored procedures and examples of each database object. (Duration: 29 minutes)

Creating SQL Azure stored procedure and views in SQL Azure

In order to make your database efficient and code friendly, two major techniques you can use are stored procedures and views. A SQL stored procedure is compiled transact SQL code that can be reused in the Cloud database. Benefits of stored procedure include faster execution, parameters (variables) support, security mechanism, network usage and simplification of complex code. We go over the syntax for a common stored procedure. In our demo tutorial video on SQL azure, we create two different stored procedures. One of the stored procedures pulls data from a CUSTOMER table using City and Country input parameter. Sp_helptext command will let you review the SQL code in a stored procedure. The next stored proc processes data from PRODUCTS and CATEGORIES table. We build this one from scratch. Using an INNER JOIN between the two tables with a GROUP BY clause, we are able to pull the Average price for each PRODUCT CATEGORY. Subsequently we insert the result set into a Summary table for later review; this is still part of the Azure stored procedure. Next item is SQL view which is simply a virtual table. Advantages of SQL views include simplicity of complex SQL code, security mechanism and the ability to use a SQL view in a SELECT statement. We create a view between the CUSTOMERS and ORDERS table in our local SQL 2008 server and then in the cloud database on SQL Azure server. (Duration: 32 minutes)

Working with SQL Joins, Primary Key (PK) and Foreign Keys (FK) in Azure SQL database


We get started with this training demo by going over key database relationship terms including PRIMARY KEY, FOREIGN KEY, JOINS and REFERENTIAL INTEGRITY using the CUSTOMERS and ORDERS table relationship. You can create the relationship keys using SSMS or TSQL (Azure). We do a demo and how to create primary and foreign keys in SQL Azure. We discuss the syntax of ALTER TABLE ADD CONSTRAINT TSQL command, and then add PK and FK constraint in the ORDERS table of our cloud database. The video demonstrates the necessity of having a Clustered Index in SQL Azure table. We continue our discussion by going over types of SQL JOINS, INNER and OUTER joins. We discuss the "Old school" plus "New school" sql syntax for creating an INNER JOIN and continue with a demo on SQL Inner Join. We wrap up things by going over vital concept of Referential Integrity which prevents accidental deletion and modification of data in SQL Azure. Once again we utilize a Customer with existing Orders to bring home the point on Referential Integrity. (Duration: 25 minutes)

How to migrate a complete database from local SQL Server 2008 to Cloud SQL Azure?


We will migrate an on-premise SQL Server database to a cloud database in SQL Azure. This is the focus of our current tutorial video. At the end of this process, we would have moved all objects including SQL tables, stored procedures, SQL views and functions plus actual data from our local SQL server. The Migration toll and utility we are going to use today is SQL Azure Migration Wizard which can be downloaded from the Codeplex website, http://sqlazuremw.codeplex.com . After the download we extract and run this migration utility. First of all we need to define a local SQL Server source connection, select the database, choose which database objects to migrate and generate the SQL script. Next we define the target server in the cloud environment, select the Create Database option and choose 1 GB web edition option for SQL azure database. Finally we Execute the process which goes ahead and copies all the information from the local SQL Server to the cloud server. We do need to verify that all the migrated objects and the data indeed made it there. Finally we discuss some of the issues we ran into, like security settings with running the SQL Azure Migration Wizard. (Duration: 16 minutes)