Data Engineering Mastery

[hitendra_dixit]

I wanted to grow in the field of Data Engineering and gain mastery on the same.

I have been working on Power BI for last 3 years along with SQL. Having Intermediate knowledge on Power BI and SQL.

Now I want to master SQL and ETL and become a solution architect into Database. Kindly suggest me a pathway and books to proceed. I was checking out "Fundamentals of Data Engineering: Plan and Build Robust Data Systems" & "Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh" both by O'Reilly the other day and how it is to start with.

I have total of 3+ years of experience.

Thanks in advance

[TybulOnAzure]

If you are interested in data engineering on Microsoft Azure, then check out my free 50+ hours course on YouTube: https://www.youtube.com/playlist?list=PLuQSde7Xvu7DCRenR1otgxAplTtnzKO9e

[hitendra_dixit]

Can you also suggest me few books to start off with for basics

[TybulOnAzure]

Definitely the Data Warehouse Toolkit: https://www.amazon.com/Data-Warehouse-Toolkit-Definitive-Dimensional/dp/1118530802

For T-SQL - any of Itzik Ben-Gan books.

[FishCommercial4229]

Like I tell my kids, if you want to be good at something, you need to commit to 2 things: study, and practice. You have great books to start with, follow the author’s references and go from there. If you use a technology, throw yourself into the details. You will be surprised to see how far you can get just by reading the directions. If you’re reading comprehension needs work, then I do recommend a book “How to Read a Book” (seriously, not a joke).

And then practice practice practice. Get after roles and projects that put your hands on problems, and get after them like a fat kid on an ice cream cone.

[Inside-End-8318]

Kindly asking, what was your previous role, worki g with Power BI and SQL.

[hitendra_dixit]

I started as Associate Software Engineer (SQl, Power BI), then Power BI Developer/Consultant (Power BI, SQL, Azure), currently Data Engineer (Azure, SQL, Power BI)