#020: What to Learn First as a Data Engineer
Nov 19, 2022The biggest hurdle to data engineering is getting started.
But everyday it feels like there’s a new tool, technology or best practice.
This whirlwind of information makes learning impossible.
To help you focus, today I'll share 3 foundational topics to start with:
- Database objects
- SQL
- Reporting
Database objects aren’t flashy, but can’t be skipped
Many eager engineers jump into “modern” tools without database fundamentals.
But it becomes painfully obvious once troubleshooting is required.
It’s like trying to play a sport without knowing the positions.
Sure, you can still play the data game - but you’ll only get so far.
Example: Database vs Schema vs Table + Indexes, constraints & roles.
SQL is still the most important language
Python, data streaming and automation are sexy topics.
But eventually you’ll need to query a database.
My advice: always master SQL first.
You’ll be better prepared technically & mentally for future components.
Example: Write a query, turn it into a function and/or stored procedure.
Reporting is how most users interact with data
Great products are built with the user in mind.
Working hard is wasteful if not for the right reason.
In data, that means learning the basics of reporting.
It’ll round out your skills and help you appreciate the underlying engineering.
Example: Create a Tableau dashboard and collect user feedback
Build a database, write SQL and create a report.
Establish this foundation before filling in the (never ending) gaps.
Looking for more? Here are 2 other ways I can help you:
1. Simple Stack Academy: Join 100+ students in an end-to-end, project-based training. Simple Stack Academy teaches you a 5-Step Framework to design, build & automate reliable end-to-end data architectures using modern tools like dbt & Github. Ideal for both data engineers looking to advance their careers and data team leaders looking for a clear strategy to follow.
2. Consulting Services: Get personalized support to properly implement a well-structured, scalable, and maintainable data architecture at your company. Whether starting from scratch or migrating a legacy design, you'll get custom support each step of the way to make sure it's done right.