Course Details

azure Data Engineer

Azure Data Engineer Training in Hyderabad with Live Projects

Join online and offline Azure Data Engineer training in Hyderabad at my institute, Fugen Academy, with hands-on learning, real-time projects, mock interviews, resume support, and job assistance.

Live Classes

5

Pavan

Azure Data Engineer Interview Preparation Roadmap

  • Resume Preparation

  • Naukri / LinkedIn Profile Optimization

  • Technical Preparation

  • Previous Interview Questions Practice

  • Mock Tests

  • Mock Interviews

  • Interview Scheduling Strategy

  • HR & Salary Preparation

  • Final Readiness Checklist

  • End-to-End Data Engineer Job Preparation

Course content

Ex: All Sections

Introduction to Azure Data Engineering
Preview

57:14 min

1 hr : 07 min

1 hr : 07 min

1 hr : 07 min

  • Installation -dockers, PGSQL, MSSQL

  • Creating DATABASE, SCHEMA

  • DDL,DML, DQL

  • WHERE operator (Filter Data)

  • Data Sorting

  • Constraint

  • Aggregate Function

  • Group by, Having

  • single row & Window Functions

  • set operators, Joins

  • Joins

  • Sub Query

  • CTE

  • DWH, ETL, data modeling(Facts & dim), SCD,acid,Normalization

  • VIEWS, Temp Tables & MV

  • Procedure & Functions

  • Merge

  • SQL Project

47:33 min

  • Find Average

2:58 min
  • SubqueryGet contribution yearwise

  • Get TOP & BOTTOM Products

  • Joins Challenge

  • Identify and delete duplicate rows

  • Custom Merging

  • MissingData-FindMissingDepartments

  • Find2ndLargestSalary

  • 2nd Largest Salary In Each Department

  • Row Numbering

  • Find Alternate Rows

  • Palindrome

  • Find Duplicate Emails

  • Update Correct Gender

  • Transform Student Info

  • Defect Classification

  • Daily Running Total

  • MTD Total

  • QTD Total

  • YTD Total

  • Previous Year Sales And YOY Growth

  • 3 month moving sum

Preview
2:58 min
  • Installation -VSCODE

  • PY- comments, print, variables, input, concatenate, interpolation

  • If - else, elsif, for loop, while loop, break & continue

  • List- introduction, indexing, len, Existence, Loop,Add, RemoveItems

  • List-Count,Copy,Reverse&Sort, UpdatingLists

  • Set, tuple, dictionary

  • String Operations

  • List Comprehensions

  • dir

  • DateTime Moduletimedelta, monthdelta,relativedeltaM odule

  • DateTime Module-Formatting

  • Exception Handling

  • Functions-Introduction, ScopeOfVariable,Arguments,DocStr ings

  • None,Random

  • Lambda

  • MAP, Reduce, Recursion, Generators, Decorators

  • PANDAS, Project on Pandas

37:41 min

  • pdf

  • Flatten List

  • Get Len Of Each Sublist In List

  • Get Common Items in 2 Lists

  • Sort Sublists In Order by Len

  • Find Missing numbers in list

  • Zip and print elements in lists

  • FrequencyOfItemsInList

37:41 min

  • Cloud Computing

  • Cloud Providers

  • Azure Introduction

  • Create Azure Trial Account

  • Getting Started With Azure

  • Create Data Lake

  • Create Azure SQL Server And Database

  • Create Data Factory

  • Upgrade To Pay-as-you-go

  • Hive Meta Store

  • Introduction To Unity Catalog

  • Setting Up Unity Catalog

  • Managed Identity

  • Create Catalog, Schema & Table

  • Auto Loader

  • Data Governance

  • Implementing Data Governance

  • Lakehouse Federation

  • Lakehouse Federation For SQL Server

  • Copy Files On Basis Of File Types

  • Volume In Unity Catalog

  • Introduction To Delta Live Tables

  • Data Quality (Expectations) In DLT

  • Demo

Preview
2:58 min
  • Introduction To Databricks And PySpark

  • Introduction To Apache Spark

  • Spark Components And API

  • Spark Architecture

  • RDD

  • Create RDD From List

  • Control Partitions In RDD

  • Create RDD From Text File

  • Transformations On RDD

  • Lineage Graph

  • Understanding DAG Fundamentals

  • Map Reduce Working

  • Reduce By Key Vs Reduce By Key Locally

  • Group By Key

  • Filter Transformation On RDD

  • Extract Top Bottom From RDD

  • Save RDD As Text File

  • Coalesce And Repartition On RDD

  • Repartition Optimization

  • Shuffle Process

  • Introduction To Accumulators

  • Implementing Accumulators

  • Broadcast Variables

  • Introduction To DataFrames

  • Read CSV In DataFrame

  • DataFrame Insights

  • Select Columns From DataFrame

  • Add Modify Columns In DataFrame

  • Drop Columns In DataFrame

  • Rename Columns In DataFrame

  • Sort Columns In DataFrame

  • Filter Data In DataFrame

  • Remove Duplicates From DataFrame

  • Combine DataFrames

  • Pattern Based Filters In DataFrame

  • Add Column On Basis Of Condition In PySpark

  • Case Conversion In DataFrame

  • Aggregations On DataFrame

  • Aggregations With GroupBy

  • Pivot & Unpivot On DataFrame

  • Window Functions

  • Fill Null Values In DataFrame

  • Read CSV Options

  • Impose Schema On DataFrame

  • Write Modes In DataFrame

  • Date Functions

  • Convert RDD To DF And Vice Versa

  • Explode

  • Working With Array Type Column

  • DBUtils

  • Access ADLS Gen2 Using Access Key

  • Sign Up For Azure Databricks

  • Calling Other Notebooks

  • Read JSON Files

  • Read Multiple Files And Get File Names

  • Parquet File Format

  • Access ADLS Using SAS Token

  • Access ADLS Using OAuth

  • Read & Write Parquet Files

  • Delta Format

  • Create Temp Views

  • Create Managed And Unmanaged Tables

  • Partitioning

  • Bucketing

  • Control Number Of Records While Writing

  • Max Partition Bytes

  • Spark Query Execution Plans

  • Joins

  • Spark Execution Plans For Transformations

  • Broadcast Hash Join Algorithm

  • Sort Merge Join Algorithm

  • Shuffle Hash Join Algorithm

  • Sort Merge Bucket Join

  • Join Hints

  • Spark SQL

  • Spark Memory Management

  • Garbage Collection

  • CPU Terminologies

  • How Spark Processes Data

  • Databricks Compute & Clusters

  • Cluster Manager

  • Resource Allocation

  • Dynamic Allocation

  • Serialization And Deserialization

  • Cache And Persist

  • Hash Functions

  • JDBC

  • Incremental Load ADLS To SQL DB – Multiple Tables Using Watermark

  • Incremental Load ADLS To SQL DB – Using Watermark

  • Incremental Load ADLS To SQL DB – Using Hash Function

  • Incremental Load ADLS To SQL DB – Using Metadata

  • Spark Architecture Deep Dive (Optional Advanced Topic)

  • Demo

Preview
2:58 min
  • History Of Data Architectures

  • ReadAndWriteDeltaFormat

  • Deltalog

  • Version History and time travel

  • check pointing

  • Create Delta Table

  • Generated Columns

  • Create Partitioned Table

  • Schema Evolution

  • Copy Into

  • Merge

  • Column Statistics

  • Optimize - Vacuum - Zorder

  • Liquid Clustering

  • Change Data Feed

  • Reorg Table

  • Deletion Vectors

  • SCD - Type 1 & 2

  • Hive Meta Store

  • Demo

Preview
2:58 min
  • History Of Data Architectures

  • ReadAndWriteDeltaFormat

  • Deltalog

  • Version History and time travel

  • check pointing

  • Create Delta Table

  • Generated Columns

  • Create Partitioned Table

  • Schema Evolution

  • Copy Into

  • Merge

  • Column Statistics

  • Optimize - Vacuum - Zorder

  • Liquid Clustering

  • Change Data Feed

  • Reorg Table

  • Deletion Vectors

  • SCD - Type 1 & 2

  • Hive Meta Store

Requirements

  • You’ll need a copy of Sketch. A free plan is available on the Sketch website.
  • Don’t forget to download Sketch for collaborative design work. It offers a free plan with basic features.
  • Consider trying Adobe XD, a powerful design tool with a free starter plan.
  • Check out InVision Studio, another great design tool with a free version.
  • Explore Axure RP for prototyping. It has a free trial available for testing.

Course Description

Join our Sketch UI/UX Design Essentials course to unleash your creativity! Learn design principles, wireframing, and prototyping to create engaging visuals, whether you’re a beginner or refining your skills.

  • But her ready least set lived spite solid
  • Frequently partiality possession resolution at or appearance
  • No visited raising gravity outward subject my cottage Mr be

Dive into the world of design with our Sketch UI/UX Design Essentials course! This
course is perfect for anyone eager to learn the ins and outs of user interface &
experience design. You’ll explore essential techniques for creating intuitive layouts,
engaging prototypes, and visually appealing designs.

Instructor

Billy Vasquez

UI/UX Design Expert

  • 4.7 Instructor Rating

  • 250,163 Reviews

  • 803,986 Students

  • 35 Courses

Billy Vasquez is a talented UI/UX designer known for his innovative approach to user-centered design. With a keen eye for detail, he crafts seamless interfaces that enhance user experiences. His passion for design drives him to create engaging and functional products that resonate with users.

Course Rating

Elegant, functional, inspiring!

Sketch UI UX Design Essentials transformed our design process, enhancing creativity and efficiency. A must-have resource for designers!

Emily Carter

IT Enthusiast Leader

Smart, sleek, effective!

Sketch UI UX Design Essentials revolutionized our approach to design, boosting productivity and creativity. Highly recommend for all designers!

Michael Brown

Technology Passion Advocate

Accessible, vibrant, seamless!

Sketch UI UX Design Essentials transformed our design process, enhancing creativity and efficiency. A must-have resource for designers!

Sophia Turner

Digital Innovation Champion

Bold, innovative, user-centric!

Sketch UI UX Design Essentials transformed our design process, enhancing creativity and efficiency. A must-have resource for designers!

Daniel Wilson

Tech Visionary Expert

Call Now Button