Course Content
Introduction to SQL Azure
- Introduction to SQL Azure
Lab :Setup Azure Account
- Create a LiveID
- Setup Azure Account
- Add SQL Azure subscription
- Create SQL Azure server
- Create SQL Administrators
SQL Azure RDBMS Support
- RDBMS Support
Lab : Creating Databases and Tables
- Create SQL Azure Databases
- Create SQL Azure Tables
Lab : Exploring Valid SQL Azure TSQL
- Create Tables
- Create Views
- Create Stored Procedures
- Create Indexes
- Create Transactions
- Working with Temp Tables
- Invalid Azure TSQL statements
SQL Azure Security
- SQL Azure Security
Lab : SQL Azure Security
- Creating Logins and Users
- Assigning Roles
- Assigning Rights to Objects
Programming SQL Azure
- Programming SQL Azure
- Accessing SQL Azure
Lab : Connecting to SQL Azure
- Use SQL Server Management Studio
- Use SQLCMD
- Use Visual Studio 2010
Lab : Programming SQL Azure
- Connecting to SQL Azure from code (.NET)
- Working with LINQ
- Working with Entity Framework
Lab : Securing Data at Rest
- Secure data at Rest
Lab : Implementing Partitions and Shards
- Implementing Horizontal Partitions
- Implementing Vertical Partitions
- Programming with Enzo SQL Shared
Maintaining and Optimizing SQL Azure
- Optimizing
- Maintaining
- Troubleshooting
Lab : Maintaining SQL Azure
- Measure Latency to SQL Azure
- Find database size
- Monitor database sessions
- Find top 5 queries (CPU and IO)
- Rebuild a database index
Lab : Performing Baselines
- Use Enzo SQL to perform baselines
- Lab : Backup SQL Azure
- Backup SQL Azure (Azure Storage Account)
- Backup SQL Azure (SQL Management Studio)
- Backup SQL Azure (BCP)
- Backup SQL Azure (RedGate)
Lab :Restore SQL Azure
- Restore SQL Azure (Azure)
- Restore SQL Azure (SQL Management Studio)
- Restore SQL Azure (BCP)
Lab : Using Query Analyzer and Client Statistics
- Using Query Analyzer
- Using Client Statistics
Migrating and Synchronizing to SQL Azure
- Synchronizing to SQL Azure
- Migrating to SQL Azure
Lab : Migrating to SQL Azure
- Migrating the database schema
- Migrating database data
- Migrating with SQL Server Migration Assistant
- Migration with SQL Azure Migration Wizard
- Migrating with DAC Import/Export 2.0
- Migrating with SQL Server Integration Services (SSIS)
Lab : Using Microsoft Sync Framework
- Working with Microsoft Sync Framework
Lab : Using Azure Data Sync
- Working with SQL Azure Data Sync
Business Intelligence with SQL Azure
- PowerPivot and SQL Azure
- SQL Azure Reporting
- Configuring Migration Settings
Lab : Business Intelligence with SQL Azure
- Working with SQL Azure Reporting
Lab : PowerPivot with SQL Azure
- Integrating PowerPivot and SQL Azure
