SQL Data Warehouse

Official Documentation

Service Description

With SQL Data Warehouse, Data Warehouse solutions can be set up flexibly and their resources can be adapted to the specific data evaluation requirements. Compute and storage services can be scaled independently of one another, allowing the compute resources to be extended, reduced, or suspended while retaining the storage systems (for relational data or non-relational Blob storage).

Azure Documentation

1. Overview
     1.1. What is SQL Data Warehouse?
     1.2. Data warehouse workload
     1.3. Distributed data
2. Get Started
     2.1. Beginner tutorial
     2.2. Best practices
     2.3. Manage
     2.4. Get support
3. How To
     3.1. Backup and restore
          3.1.1. Backup Overview
          3.1.2. Restore Overview
               3.1.2.1. Azure portal
               3.1.2.2. PowerShell
               3.1.2.3. REST
     3.10. Security
          3.10.1. Overview
          3.10.2. Auditing
          3.10.3. Auditing for down-level clients
          3.10.4. Authentication
          3.10.5. Encryption
          3.10.6. Encryption with T-SQL
          3.10.7. Threat detection
     3.2. Connect
          3.2.1. Overview
          3.2.2. Connection strings
          3.2.3. sqlcmd
          3.2.4. SSMS
          3.2.5. Visual Studio
          3.2.6. Install Visual Studio
     3.3. Create
          3.3.1. Azure portal
          3.3.2. PowerShell
          3.3.3. T-SQL
     3.4. Develop
          3.4.1. Overview
          3.4.2. Tables
               3.4.2.1. Overview
               3.4.2.2. CTAS
               3.4.2.3. Data types
               3.4.2.4. Distributed tables
               3.4.2.5. Indexes
               3.4.2.6. Partitions
               3.4.2.7. Statistics
               3.4.2.8. Temporary
          3.4.3. Queries
               3.4.3.1. Dynamic SQL
               3.4.3.2. Group by options
               3.4.3.3. Labels
          3.4.4. T-SQL language elements
               3.4.4.1. Loops
               3.4.4.2. Stored procedures
               3.4.4.3. Transactions
               3.4.4.4. Transactions Best Practices
               3.4.4.5. User-defined schemas
               3.4.4.6. Variable assignment
               3.4.4.7. Views
     3.5. Integrate
          3.5.1. Overview
          3.5.2. Data Factory
          3.5.3. Machine Learning
          3.5.4. Machine Learning tutorial
          3.5.5. Power BI
          3.5.6. Power BI visualization
          3.5.7. Stream Analytics
     3.6. Load
          3.6.1. Overview
          3.6.10. PolyBase from SQL Server
          3.6.11. RedGate
          3.6.12. SSIS
          3.6.2. Sample data
          3.6.3. Azure Data Lake Store
          3.6.4. AZCopy
          3.6.5. BCP
          3.6.6. Data Factory
          3.6.7. PolyBase
          3.6.8. PolyBase guidance
          3.6.9. PolyBase from blob storage
     3.7. Migrate
          3.7.1. Overview
          3.7.2. Migration Utility
          3.7.3. Migrate schema
          3.7.4. Migrate code
          3.7.5. Migrate data
          3.7.6. Migrate to premium storage
     3.8. Pause and scale
          3.8.1. Overview
          3.8.2. Azure portal
          3.8.3. PowerShell
          3.8.4. REST API
          3.8.5. T-SQL
     3.9. Performance
          3.9.1. Overview
          3.9.2. Columnstore compression
          3.9.3. Queries
          3.9.4. Workload
          3.9.5. Troubleshoot
4. Reference
     4.1. Capacity limits
     4.2. T-SQL language elements
     4.3. T-SQL statements
     4.4. T-SQL system views
     4.5. PowerShell cmdlets
5. Resources
     5.1. Pricing
     5.2. Stack Overflow
     5.3. Service updates
     5.4. Forum
     5.5. Videos
     5.6. Partners
          5.6.1. Business intelligence
          5.6.2. Data integration
          5.6.3. Data management

Web Content

Content Type
Build 2016 Workshops: Azure Data Services Lab

Microsoft Virtual Academy (MVA)

Date Title
12/11/2015 Deliver an Elastic Data Warehouse as a Service

Tools

Tool Description