50592A Advanced SQL Azure

650€

Acest curs de 4 zile reprezintă o analiză detaliată a soluției SQL Azure, ofera Cloud de baze de date în Windows Azure, prezinta elementele de bază privind furnizarea de servere și baze de date, validarea Azure TSQL și modul în care este implementată și gestionată securitatea. Subiectele avansate includ partiționarea cu sharpening, optimizarea design-ului bazei de date, copierea de rezervă și sincronizarea prin Synchronization Framework și Azure Data Sync și migrarea diferitelor scenarii de baze de date în SQL Azure.

Publicul tinta pentru acest curs este format din experții IT care doresc să învețe să mențină bazele de date SQL Azure și arhitecții care doresc să învețe să utilizeze SQL Azure în aplicațiile lor.

După finalizarea acestui curs, participantii vor putea:

•Învața să proiecteze soluții de stocare de date de înaltă performanță bazate pe cloud folosind SQL Azure. Subiectele includ securitatea, programarea, menținerea, optimizarea, migrarea și sincronizarea cu SQL Azure.  De asemenea,  este explorat SQL Azure Reporting.

Detalii curs

  • Durata 4 zile
  • Nivel 300
  • Limba curs Engleza/Romana
  • Limba suport Engleza
  • Cursanti/grupa 10
  • Examen
  • Certificare
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

In this module we will explore what SQL Azure is, it’s architecture, ways that you can use it in your applications and most importantly how much it costs!

Lessons

  • Introduction to SQL Azure

Lab : Setup Azure Account

After completing this module, students will be able to:
  • Determine the cost of storing data in Windows Azure
  • Setup SQL Azure databases through Developer Portal

Module 3: SQL Azure RDBMS Support

In this module we take a look at supported Azure T-SQL including creating tables, columns and indexes. We will also explore how to work with temp tables and transactions.

Lessons

  • RDBMS Support

Lab : Creating Databases and Tables

Lab : Exploring Valid SQL Azure TSQL

After completing this module, students will be able to:
  • Create SQL Azure Databases and Tables
  • Understand what TSQL is supported
  • Create SQL Azure views and stored procedures

Module 4: SQL Azure Security

In this module we take a look at the lessons of the module!

Lessons

  • SQL Azure Security

Lab : SQL Azure Security

After completing this module, students will be able to:
  • Describe how SQL Azure security works
  • Create and assign firewall rules
  • Create server logins
  • Assign permissions to users
  • Assign rights to objects

Module 5: Programming SQL Azure

In this module we take a look at the various ways to access SQL Azure, some of the tools that make working with SQL Azure easier (Entity Framework and LINQ), and an advanced coverage of Sharding.

Lessons

  • Programming SQL Azure
  • Accessing SQL Azure

Lab : Connecting to SQL Azure

Lab : Programming SQL Azure

Lab : Securing Data at Rest

Lab : Implementing Partitions and Shards

After completing this module, students will be able to:
  • 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

Module 6: Maintaining and Optimizing SQL Azure

In this module we take a look at how to maintain SQL Azure databases, how to optimize databases and how to troubleshoot connectivity problems (DoS and Throttling).

Lessons

  • Optimizing
  • Maintaining
  • Troubleshooting

Lab : Maintaining SQL Azure

Lab : Performing Baselines

Lab : Backup SQL Azure

Lab : Restore SQL Azure

Lab : Using Query Analyzer and Client Statistics

After completing this module, students will be able to:
  • 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

Module 7: Migrating and Synchronizing to SQL Azure

In this module we take a look at how to migrate your databases to SQL Azure and how you can use Microsoft Synchronization Framework and Azure Data Sync to synchronize your Azure databases with on-premise databases.

Lessons

  • Synchronizing to SQL Azure
  • Migrating to SQL Azure

Lab : Migrating to SQL Azure

Lab : Using Microsoft Sync Framework

Lab : Using Azure Data Sync

After completing this module, students will be able to:
  • 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

Module 8: Business Intelligence with SQL Azure

In this module we take a look at SQL Azure Reporting Services and how to use PowerPivot to connect Excel 2010 to SQL Azure data.

Lessons

  • PowerPivot and SQL Azure
  • SQL Azure Reporting

Lab : Business Intelligence with SQL Azure

Lab : PowerPivot with SQL Azure

After completing this module, students will be able to:
  • Create SQL Azure Reporting Services Server instances
  • Create data sources in SQL Azure Reporting
  • Create reports and deploy them to SQL Azure Reporting