Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Azure Data Engineer Associate Certification Guide
  • Table Of Contents Toc
Azure Data Engineer Associate Certification Guide

Azure Data Engineer Associate Certification Guide - Second Edition

By : Palmieri, Surendra Mettapalli, Alex
4.6 (16)
close
close
Azure Data Engineer Associate Certification Guide

Azure Data Engineer Associate Certification Guide

4.6 (16)
By: Palmieri, Surendra Mettapalli, Alex

Overview of this book

One of the top global cloud providers, Azure offers extensive data hosting and processing services, driving widespread cloud adoption and creating a high demand for skilled data engineers. The Azure Data Engineer Associate (DP-203) certification is a vital credential, demonstrating your proficiency as an Azure data engineer to prospective employers. This comprehensive exam guide is designed for both beginners and seasoned professionals, aligned with the latest DP-203 certification exam, to help you pass the exam on your first try. The book provides a foundational understanding of IaaS, PaaS, and SaaS, starting with core concepts like virtual machines (VMs), VNETS, and App Services and progressing to advanced topics such as data storage, processing, and security. What sets this exam guide apart is its hands-on approach, seamlessly integrating theory with practice through real-world examples, practical exercises, and insights into Azure's evolving ecosystem. Additionally, you'll unlock lifetime access to supplementary practice material on an online platform, including mock exams, interactive flashcards, and exam tips, ensuring a comprehensive exam prep experience. By the end of this book, you’ll not only be ready to excel in the DP-203 exam, but also be equipped to tackle complex challenges as an Azure data engineer.
Table of Contents (17 chapters)
close
close
Lock Free Chapter
1
Part 1: Azure Basics
3
Part 2: Data Storage
6
Part 3:Data Processing
11
Part 4:Secure, Monitor, and Optimize Data Storage and Processing

Transforming Data Using T-SQL

T-SQL is a procedural language that is used by both dedicated and Serverless SQL ingess in Synapse. Similar to the transformations that you have seen in Spark, T-SQL also provides a rich set of transformations.

Note

This section primarily focuses on the Transform data by using Transact-SQL (T-SQL) in Azure Synapse Analytics concept of the DP-203: Data Engineering on Microsoft Azure exam.

The following are some of the most important ones:

  • SELECT: This command is used to select data from a subset of columns. Its syntax is as follows:
    SELECT[firstName], [lastName] from dbo.Driver WHERE [city] = ‘New York’;
  • ORDER BY: This command is used to sort rows by a particular column. Its syntax is as follows:
    SELECT [firstName], [lastName] from dbo.Driver ORDER BY [firstName];
  • DISTINCT: This command is used to select unique rows from the input. Its syntax is as follows:
    SELECT DISTINCT [firstName], [lastName] from dbo.Driver;
  • ...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Azure Data Engineer Associate Certification Guide
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon