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

Getting Started

  1. Azure207x - Databases in Azure
    5/31/2017, Mva

Azure Documentation

1. Overview
     1.1. What is SQL Data Warehouse?
     1.2. Data warehouse workload
     1.3. Distributed data
     1.4. Frequently asked questions
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.2. Connect
          3.2.1. Overview
          3.2.2. SSMS
          3.2.3. Visual Studio
          3.2.4. Install Visual Studio
          3.2.5. sqlcmd
          3.2.6. Connection strings
     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. Identity
               3.4.2.7. Partitions
               3.4.2.8. Statistics
               3.4.2.9. 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.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.6.10. PolyBase from SQL Server
          3.6.11. RedGate
          3.6.12. SSIS
     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. Manage compute
          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. Monitor
          3.9.4. Workload
     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.11. Troubleshoot
          3.11.1. 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. Azure Roadmap
     5.2. Forum
     5.3. Pricing
     5.4. Service updates
     5.5. Stack Overflow
     5.6. Videos
     5.7. Partners
          5.7.1. Business intelligence
          5.7.2. Data integration
          5.7.3. Data management

Web Content

Content Type
Build 2016 Workshops: Azure Data Services Lab

Tools

Tool Description