Description

Deliver an Elastic Data Warehouse as a Service

Deliver an Elastic Data Warehouse as a Service
MP4 | Video: AVC 1280×720 | Audio: AAC 44KHz 2ch | Duration: 43M | 1.05 GB Genre: eLearning | Language: English
Want an overview of the newly announced Azure SQL Data Warehouse? Dive into the system’s architecture, and get answers to key questions, like how to scale the service quickly, what some of the challenges with separated storage and compute are, and what’s possible next. In this Azure SQL database training session, demos explore some of the truly innovative and differentiating features that can leave competitors in the dust. Learn about the capabilities of the service and about how to quickly build, scale, and manage the service at cloud scale.

• Microsoft has recently released this brand new service, which is a big success for the data team at Microsoft. Synapse contained very rich features, not only to the engine itself to increase performance, but also to add new functionality in providing a unified analytics experience for diff data teams.
• In the most recent study conducted by GigaOm in January 2019 for the TPC-H benchmark report shows that Synapse Analytics is 14 times fast and still 94% cheaper than any other leading service in the market.
• And that’s why clients are shifting to Azure and Azure is growing at nearly twice the rate of Amazon Web Services. Azure Synapse Analytics truly is a game-changer in Data processing and Analytics.
• According to a 2019 Dice report, there was an 88% year-over-year growth in job postings for data engineers, which was the highest growth rate among all technology jobs. If you are interested in this domain, there cannot be a better time to start learning Azure Synapse Analytics Data Warehouse then now.
• I hope you will join me on this exciting journey of learning this technology.

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

Internal and Architecture

• In this module where you are going to learn Azure Data Warehouse famous MPP or Massive parallel processing architecture.
• And then we’ll discuss various cloud data warehousing internal but important concepts like storage and data distribution through Hash, round-robin and replicated tables
• We will learn not only different Data types and table types like columnstore, heap and Clustered B-tree index, but we will also learn best practices around, how to partition our data into these diff table types.
• We will discuss in detail about distribution key and how to analyses the table to find the best distribution key according to partition.
• Then we’ll discuss how to apply these concepts in dimensional modeling.
• And then finally we’ll take a case of Microsoft’s famous Adventure works DW, we will download and restore it in our on-premises management studio, and we will analyze the distribution and the data types for Data Warehouse and we will prepare it to migrate to Cloud data warehousing.