20 LPA Job Tips to Help You Land Your dream Job | RoadMap Of Azure Data Engineering 🔥🔥 |
Hey Geeks,
Combo course package : https://www.geekcoders.co.in/courses/...
I have prepared many courses on Azure Data Engineering
1. Build Azure End to. End Project
https://www.geekcoders.co.in/courses/...
2. Build Delta Lake project
https://www.geekcoders.co.in/courses/...
3. Master in Azure Data Factory with ETL Project and PowerBi
https://www.geekcoders.co.in/courses/...
4. Master in Python
https://www.geekcoders.co.in/courses/...
Rating: 4.8 out of 5
If you are planning to become Azure DataEngineer then this video is for you.
I have explained tools and languages which are required to become AzureDataEngineer
Python – Intermediate
• Variable
• Control Statement
• Condition Statement
• List,Tuple,Set,Dict
• Functions
• OOPS Concept
• Exception Handling
• File I/O
• MultiThreading
SQL -Intermediate
• DML,DCL,DDL COMMANDS
• All types of constraint
• WHERE,GroupBY,HAVING
• MIN,MAX,SUM,COUNT,AVG
• INNER,LEFT,RIGHT,SELF,CROSS,FULL OUTER JOIN
• WINDOW FUNCTIONS -ROW NUMBER,RANK AND DENSE RANK, ETC
• CTE,VIEW, STORED PROCEDURE
• INDEXING- CLUSTER INDEX AND NON CLUSTERED INDEX
• HANDS-ON SQL QUERY QUESTIONS
Azure Cloud
• How many type of services Azure provides?
• What is the difference between IAAS,PAAS,SAAS?
• What is VM ?
• What is resource group, Tenant and Subscription in Azure?
Azure Storage Account
• What is blob ? why to use it ?
• How many blob azure provides?
• What is ADLS GEN2 why to use it ?
• Basics of Table,Queue and File.
AzureDataFactory
• What is AzureDataFactory
• What is IR?
• What is linked services and datasets?
• Multiple type of triggers
• Different type of activities and their uses
• DataFlow
AzureDataBricks
• What is Spark?
• What is DBFS?
• Architecture of Spark and advantages of it
• What is scope and mount point
• What is keyvault
• Basics of PySpark
• Hands-on on loading and writing data in different format
• How many types of cluster do we have and which one where to use
• PartitionBy, Repartition and Coalesce
• Broadcast variable and Accumulator
• Different types of Joins
• Different types of file format and difference among them
• When to do cache and persist
• Create Dimension and Fact table using PySpark or SPARK SQL
• What are Managed tables and External tables
• What is delta tables?
• What is SCD ?
• Setup End to End Job using Job Workflow or ADF pipeline
DataModelling and DataWarehouse Concept
• What is data modelling?
• Explain various types of data models
• Explain the fact and fact table
• Differentiate between fact table and dimension table
• Differentiate between data warehouse and database
• Difference between Database, Datawarehouse and DataMart
• List out various design schema in data modelling
• What is in-memory analytics
• What is the difference between OLTP and OLAP?
• What are the different types of cardinal relationships?
• What is the difference between Star schema and Snowflake schema?
PowerBI
• What is POWERBI?
• What is Report?
• What is Dashboard?
• What is Measures?
• What is calculated columns ?
• How to create relationship between tables in Powerbi?
• Which chart/visual should be used in the given dataset
• Design PowerBI report using dummy dataset(Ex. Covid-19 dataset)
Logic App
• What is logic App?
• How to use logic app in ADF ?
• Hands-on on small automation task to send emails to users when ADF job succeeded
AzureDevops
• What is AzureDevops?
• What is CI-CD?
• What is service connection?
• What is Artifact and build?
• Hands-on on ADB CI-CD pipeline
20 LPA Job Tips to Help You Land Your dream Job
#databricks #azuredatafactory #roadmap #azure #azuredatafactorytutorialforbeginners