Skip to main content

Helpful Resources to Prep for this Course

· 3 min read
Jennifer Batara

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 Python and 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​

  • General

    • Git (Cloning, Committing)
    • Bash Shell Commands

  • Python

    • Reading and Writing Functions and Classes
    • Ability to understand and write list comprehensions
    • A basic understanding of the Pandas package, its use to manipulate data

  • SQL

    • 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.

Git​

Video Resource​

* Learn Git in 15 Minutes (Video) by Colt Steele

Text Resources​

Git Handbook by Github Guides

Github Git Cheat Sheet

  • Great cheat sheet when I... I mean you forget those git commands 😅

Bonus​

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.

Unix Shell​

Video Resource​

Beginner's Guide to the Bash Terminal by Joe Collins

  • A long (1 hour 15 minute) video tutorial on the Bash Terminal

Text Resources​

The Linux Command Line for Beginners by Ubuntu

  • A quick tutorial for those that have never used the terminal before

Basic Unix Commands

  • Nice list of commonly used UNIX commands

Python​

College Lectures (Videos) + Textbook​

*Introduction to Computer Science and Programming in Python

  • 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​

Learn Python - Full Course for Beginners[Tutorial] by freeCodeCamp.org

  • 4 hour tutorial covering introductory python topics

Text Walk Throughs​

LearnPython.org

Pandas​

Video Resource​

Data Anlysis with Python - Full Course for Beginners (Numpy, Pandas, Matplotlib, Seaborn)

Text Resources​

Kaggle 10 Minutes to Pandas by Pandas

SQL​

Video Resource​

SQL Tutorial - Full Database Course for Beginners by freeCodeCamp.org

Text Resource​

SQL Tutorial by w3schools.com

danger

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!