Advanced SQL Azure (Cours 50592)
Cours disponible en français ou en anglais - Training available in French or in English
Durée: 4 jours
Objectifs du cours :
This 4-day Instructor Led course This class is an in-depth look at SQL Azure, the database cloud offering in Windows Azure. Learn the basics around server and database provisioning, valid Azure TSQL, and how security is implemented and managed. Advanced topics include partitioning with sharding, database design optimization, backup and synchronization via Synchronization Framework and Azure Data Sync and migrating various database scenarios to SQL Azure.
Compétences acquises :
Les stagiaires seront à même d'effectuer les tâches suivantes :
- Determine the cost of storing data in Windows Azure
- Setup SQL Azure databases through Developer Portal
- Create SQL Azure Databases and Tables
- Understand what TSQL is supported
- Create SQL Azure views and stored procedures
- Describe how SQL Azure security works
- Create and assign firewall rules
- Create server logins
- Assign permissions to users
- Assign rights to objects
- Connect to SQL Azure from your favorite tools
- Program SQL Azure with Entity Framework
- Secure your SQL Azure Data at Rest
- Implement partitions using sharding
- Understand how to use Enzo SQL Shard SDK
- Maintain SQL Azure
- Perform baselines for on-premise and SQL Azure Databases
- Perform backups of SQL Azure using various tools
- Perform a restore of SQL Azure
- Use Query Analyzer and Client Statistics
- Export your on-premise database schemas for SQL Azure
- Migrate data to SQL Azure using various tools
- Synchronize data with SQL Azure using Azure Data Sync
- Synchronize data with SQL Azure using Microsoft Synchronization Framework
- Create SQL Azure Reporting Services Server instances
- Create data sources in SQL Azure Reporting
- Create reports and deploy them to SQL Azure Reporting
Connaissances requises :
Pour suivre ce cours, les stagiaires doivent disposer des connaissances suivantes :
- Understanding of basic SQL concepts (TSQL and tables)
Copyright © 2012 Colombus.com - All rights reserved
Tel : +41 21 661 1675 - Fax : +41 21 661 1673 - Email : info@colombus.com