What You’ll Learn:
- Learn to design high-performance cloud-based data storage solutions using SQL Azure. Topics include security, programming, maintaining, optimizing, migrating, and synchronizing with SQL Azure. SQL Azure Reporting is also explored.
Course Outline:
- Module 1: Overview
- A simple introduction module.
- After completing this module, students will be able to:
- Understand your course, classroom, classmates, facility, and instructor.
- Module 2: Introduction to SQL Azure:
- Introduction to SQL Azure
- Setup Azure Account
- Create a LiveID
- Setup Azure Account
- Add SQL Azure subscription
- Create SQL Azure server
- Create SQL Administrators
- Module 3: SQL Azure RDBMS Support:
- RDBMS Support
- Creating Databases and Tables
- Exploring Valid SQL Azure TSQL
- Module 4: SQL Azure Security:
- SQL Azure Security
- Creating Logins and Users
- Assigning Roles
- Assigning Rights to Objects
- Module 5: Programming SQL Azure:
- Programming SQL Azure
- Accessing SQL Azure
- Connecting to SQL Azure
- Programming SQL Azure
- Securing Data at Rest
- Implementing Partitions and Shards
- Module 6: Maintaining and Optimizing SQL Azure:
- Optimizing
- Maintaining
- Troubleshooting
- Maintaining SQL Azure
- Performing Baselines
- Backup SQL Azure
- Restore SQL Azure
- Using Query Analyzer and Client Statistics
- Module 7: Migrating and Synchronizing to SQL Azure:
- Synchronizing to SQL Azure
- Migrating to SQL Azure
- Module 8: Business Intelligence with SQL Azure:
- PowerPivot and SQL Azure
- SQL Azure Reporting