Azure SQL Data Warehouse Synapse Analytics – Module 1 (Free)
Cloud Data Warehouse in Azure Synapse Analytics Service (formerly Azure SQL Data Warehouse)
What you’ll learn
Azure SQL Data Warehouse Synapse Analytics – Module 1 (Free)
- Azure Synapse Analytics Service Basics
- Azure SQL Data Warehouse Architecture
- Traditional Data Warehouse Architecture
- Modern Data Warehouse Architecture
Requirements
-
Basic T-SQL and Database concepts
-
Azure Free trial Subscription
Description
Important Note:
Please note that this is NOT a full course but a single module of the full-length course, and intended to cover very basic fundamental concepts for absolute beginners.
This module is NOT GOOD for you if:
- You are already experienced in this technology
- You are looking for intermediate or advanced concepts
- You are looking for practical examples or a demo
This module is GOOD for you if:
- You want to understand the basic fundamental concepts of this technology.
This is a free module to help others. If you are not in the intended audience, IÂ request you to please feel free to unenroll.
Where IÂ can find a full-length course?
Please look at the bonus lecture at the end.
What will students learn in this course?
- Azure SQL Data Warehouse
- Azure Synapse Analytics Service
- MPP, Types, Partitioning, etc.
- PolyBase loading techniques
- Security
- Configuration
- Backup and Restore
- Managing Workloads
- Monitoring
Level
- Beginners
Intended Audience
- Database and BI developers who want to learn how to implement these technologies in Azure Cloud.
- Anyone who wants to start learning warehousing and Data Engineering in the Azure cloud.
Language
- English
- If you are not comfortable with English, please do not take a course, captions are not good enough to understand the course.
Expected Outcomes
In this course
- You will learn the difference between Traditional vs Modern vs Synapse Data warehouse architecture
- You will learn why the Microsoft Synapse Analytics service is going to be a game-changer in the Data Analytics
- You will learn how to provision, configure and scale Azure Synapse Analytics service
Target Students
- Beginners in Azure Platform
- Data Engineers
- Data Scientist
- Database and BI developers
- Database Administrators
- Data Analyst or similar profiles
Prerequisites
- Basic T-SQL and Database concepts
- Azure Free trial Subscription
Course In Detail
Azure Synapse Analytics Service
- Why we should consider warehousing solutions in the cloud
- And then we’ll discuss Microsoft’s brand new Azure Synapse analytics service, and how this service brings together enterprise data warehousing and Big Data analytics, and provide a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
- Advantages of Synapse analytics service over other cloud-based analytics services.
- We will discuss the difference between Traditional vs Modern vs Synapse Architecture.
- You will also see Azure Synapse studio which provides a unified experience for all Data Professionals. So, whether you are Data Engineer, Data scientist, Database administrator, business analyst, or any other IT professional, you will find your space in Synapse studio.
- And then finally in Demo, we’ll provision a new Azure Synapse Analytics Service, we will see how to pause or resume compute node which is very important, and how to set firewall rules and connect with SQL Server Management studio
[Tags]
Microsoft SQL Server, Azure SQL Server, Azure SQL Data Warehouse, Data Factory, Data Lake, Azure Storage, Azure Synapse Analytics Service, PolyBase, Azure monitoring, Azure Security, Data Warehouse, SSIS
Who this course is for:
- Beginners in Azure Platform
- Data Engineers
- Data Scientist
- Database and BI developers
- Database Administrators
- Data Analyst or similar profiles
Add Comment