- Is this course good for me? Set expectation
- Introduction
- Why Warehousing in Cloud
- Traditional vs Modern Warehouse architecture
- Azure Synapse a Game changer
- Azure Synapse Benefits
- Modern vs Azure Synapse Architecture
- Demo - Azure Synapse Analytics
- Demo - Azure Synapse Studio
- Synapse unified experience for all Data Professionals
- Summary
- Bonus Lecture
What you'll learn
- Azure Synapse Analytics Service Basics
- Azure SQL Data Warehouse Architecture
- Traditional Data Warehouse Architecture
- Modern Data Warehouse Architecture
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 an intermediate or advance concepts
You are looking for practical examples or 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 in the end.
What will students learn in this course?
Azure SQL Data Warehouse
Azure Synapse Analytics Service
[Note]: This is the free version of this course. In case you are interested to learn below synapse topics further, you can look at my profile for the full version of this course.
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 in 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 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 Scientists, Database administrator, business analysts or any other IT professional, you will find your space in Synapse studio.
And then finally in Demo, we'll provision 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
Other Courses
FREE Microsoft Dynamics 365& Power Platform Developer Course
Beginner Course on Dataverse Development (Microsoft Dynamics 365 CRM , PowerApps) from Ex-Microsoft employee.
Customer Service Training | Keys To Satisfy Your Customers
An introduction to customer service and its importance in any business.
Coding and testing an authentication API [NodeJs + Cypress]
Creating +Testing An Authentication API Tutorial
How to earn on Tiktok 0 investment with us
Our real Indonesia Tikok shop as example - selling success, and ways earn on Tiktok Shop. UK Thailand Vietnam Malaysia
The Complete MailChimp Email Marketing Course For Beginners
Learn How To Set-up Your First Email Funnel and Start Earning From Your Email List
CCNA OSPF troubleshooting: Cisco CCNA and ICND2 exam prep
Prepare for the OSPF exam topic in the CCNA 200-125 or ICND2 200-105 exams. You need to learn OSPF for your exam!
About the instructors
- 4.51 Calificación
- 153018 Estudiantes
- 13 Cursos
Eshant Garg | | LearnCloud.Info | 100,000+ Enrollments
Instructor | LearnCloud.Info | Azure
I love to explain complicated things in a simple and effective way.
I have 16 years of extensive professional experience with expertise in Database and Business Intelligence Solutions, Advanced Analytics, Design and Solution Architect, Reporting, and Cloud Computing Technologies (Azure & AWS).
As a developer and architect, I have worked closely with customers, users, and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance, and government ranging from small companies to fortune 500 companies.
Outside of the technical world, I love yoga and meditation. I am a student of the ancient yogic text Bhagavad Gita and love to discuss and practice philosophical teachings.
Student feedback
Course Rating
Reviews
Session is informative.