SQL Azure

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

SQL Azure is Microsoft’s RDBMS for the cloud. Because it is based on SQL Server, developers can apply what they know about SQL Server to SQL Azure immediately. SQL Azure is its own product and, over time, developers will discover that they need to know some extra items in order to be fully productive on this platform.

At the end of the training, participants will be able to:

Pre-requisite

  1. Knowledge of TSQL
  2. Experience using Visual Studio

Duarion

5 days

Course Outline

  • What is SQL Azure?
  • SQL Azure Architecture
  • SQL Azure Security
  • Provision and Connect to Database
  • Comparing SQL Azure to SQL Server
  • SQL Azure Pricing
  • Understanding the SQL Azure Bill
  • A Real SQL Azure Bill
  • Candidate Applications
  • SQL Azure Scenarios/Taxonomy
  • Deployment Architecture
  • Microsoft Tooling
  • Using the SQL Azure Tools
  • Development Choices
  • Developing with SQL Azure
  • Connection Termination
  • What can move?
  • Migrating Access with the Access SSMA
  • Migrating Databases
  • Preparing for the move
  • Migration Tasks
  • Planning your migration
  • Common Hurdles
  • Tools
  • Migrating a database with existing tools.
  • OData overview
  • OData Query String Parameters
  • $filter Expressions
  • Supporting JSON
  • SQL Azure and OData
  • What is Business Intelligence?
  • Tools to Analyze Data
  • Using SSRS with SQL Azure

Reviews