Digi Academy

Advanced SQL Azure

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

After completing this module, students will be able to: Understand your course, classroom, classmates, facility and instructor. 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!

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Cosa impari in questo corso?

Server
Reporting
Framework
Management
SQL

Programma

Introduction to SQL Azure


Create a LiveID


Setup Azure Account


Add SQL Azure subscription


Create SQL Azure server


Create SQL Administrators


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


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.


RDBMS Support


Create SQL Azure Databases


Create SQL Azure Tables


Create Tables


Create Views


Create Stored Procedures


Create Indexes


Create Transactions


Working with Temp Tables


Invalid Azure TSQL statements


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


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


SQL Azure Security


Creating Logins and Users


Assigning Roles


Assigning Rights to Objects


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


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.


Programming SQL Azure


Accessing SQL Azure


Use SQL Server Management Studio


Use SQLCMD


Use Visual Studio 2010


Connecting to SQL Azure from code (.NET)


Working with LINQ


Working with Entity Framework


Secure data at Rest


Implementing Horizontal Partitions


Implementing Vertical Partitions


Programming with Enzo SQL Shared


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


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).


Optimizing


Maintaining


Troubleshooting


Measure Latency to SQL Azure


Find database size


Monitor database sessions


Find top 5 queries (CPU and IO)


Rebuild a database index


Use Enzo SQL to perform baselines


Backup SQL Azure (Azure Storage Account)


Backup SQL Azure (SQL Management Studio)


Backup SQL Azure (BCP)


Backup SQL Azure (RedGate)


Restore SQL Azure (Azure)


Restore SQL Azure (SQL Management Studio)


Restore SQL Azure (BCP)


Using Query Analyzer


Using 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


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.


Synchronizing to SQL Azure


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)


Working with Microsoft Sync Framework


Working with SQL 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


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.


PowerPivot and SQL Azure


SQL Azure Reporting


Working with SQL Azure Reporting


Integrating PowerPivot and 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



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto