Thanks for your interest in learning more about Data Engineering! We've complied a list of pre-requisites that you should be familiar with before starting this course. This course starts at a mid-level and assumes you have a general understanding of computers. We don't require much, but we do need you to know Python and SQL well. We would heavily rely and build upon those skills throughout the course.
If you're just starting out...
Below is a list of helpful resources to bring you up to speed with
SQL so that you can confidently follow along with the Data Engineering Bootcamp material!
Here is a list of things you should be comfortable with before starting the course:
Need to Know
- Git (Cloning, Committing)
- Bash Shell Commands
- Reading and Writing Functions and Classes
- Ability to understand and write list comprehensions
- A basic understanding of the
Pandaspackage, its use to manipulate data
- basic queries
- basic joins
Some things to note:
- Each category has at least one video and one text based resource to facilitate different learning styles.
- Links with a "*" denotes sources previously used by the author early in their learning Journey.
- Great cheat sheet when I... I mean you forget those git commands 😅
I HIGHLY recommend reading this blogpost by Chris Beams on *How to Write a Git Commit Message! Although not everyone will agree with the "standard formatting practices" listed out in this post, the general information on how to write a good commit message still apply. Let's help our fellow devs out and write GOOD COMMITS. That's the end of my public service announcement. Thanks.
- A long (1 hour 15 minute) video tutorial on the Bash Terminal
- A quick tutorial for those that have never used the terminal before
- Nice list of commonly used UNIX commands
College Lectures (Videos) + Textbook
- An excellent resource for those that like traditional, college lectures. To get the most out of this course, make sure to do the homework assignments. The textbook that goes along with this course is a good resource as well.
Video Walk Throughs
- 4 hour tutorial covering introductory python topics
Text Walk Throughs
The links in the below paragraph need to be updated!
If you have any questions, or suggestions for other resources that you have found helpful, be sure to drop by in our Tura Labs Slack Channel to let us know!