This course is part of the Python, Bash and SQL Essentials for Data Engineering Specialization

4.5
stars
106 ratings

Kennedy Behrman +2 more instructors

10,106 already enrolled

Offered By

Python, Bash and SQL Essentials for Data Engineering SpecializationDuke University

About this Course

62,893 recent views

In this first course of the Python, Bash and SQL Essentials for Data Engineering Specialization, you will learn how to set up a version-controlled Python working environment which can utilize third party libraries. You will learn to use Python and the powerful Pandas library for data analysis and manipulation. Additionally, you will also be introduced to Vim and Visual Studio Code, two popular tools for writing software. This course is valuable for beginning and intermediate students in order to begin transforming and manipulating data as a data engineer.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 4 in the

Python, Bash and SQL Essentials for Data Engineering Specialization

Beginner Level

No prior Python experience required.

Approx. 38 hours to complete

English

What you will learn

Setup a provisioned Python project environment
Use Pandas libraries to read and write data into data structures and files
Employ Vim and Visual Studio Code to write Python code

Skills you will gain

Vim
Python Programming
Pandas
Visual Studio Code
Data Structure

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 4 in the

Python, Bash and SQL Essentials for Data Engineering Specialization

Beginner Level

No prior Python experience required.

Approx. 38 hours to complete

English

Instructors

Instructor rating

4.72/5 (34 Ratings)

Offered by

Duke University

Syllabus - What you will learn from this course

Content Rating96%(1,136 ratings)

Week1

Week 1

9 hours to complete

Getting Started with Python

9 hours to complete

15 videos (Total 72 min), 3 readings, 5 quizzes

15 videos

Overview of Python, Bash and SQL Essentials for Data Engineering7mMeet your Course Instructor: Kennedy Behrman41sOverview of Key Concepts5mIntroduction to Setting Up Your Python Environment31sInstalling Packages with pip in Python6mSaving Requirements File in Python3mCreating and Using a Python Virtual Environment5mExpression Statements in Python3mAssignment Statements in Python5mImport Statements in Python4mOther Simple Statements in Python5mCompound Statements in Python5mIf Statements in Python6mWhile Loops in Python4mFunctions in Python7m

3 readings

Meet your Supporting Instructors: Alfredo Deza and Noah Gift10mCourse Structure and Discussion Etiquette10mEvaluating to True or False10m

5 practice exercises

Assignment Statements30mImport Statements30mIf Statements30mWhile Loops30mPython Statements30m

Week2

Week 2

10 hours to complete

Essential Python

10 hours to complete

12 videos (Total 65 min)

12 videos

Introduction to Python Essentials34sSequences in Python8mLists and Tuples in Python5mStrings in Python10mCreating Range Objects in Python2mCreating Dictionaries in Python4mAccessing Dictionary Data in Python3mDictionary Views in Python2mSets and Set Operations in Python6mList Comprehensions in Python6mGenerator Expressions in Python4mGenerator Functions in Python7m

8 practice exercises

Sequence Operations30mLists and Tuples30mRange Objects30mAccessing Data in Dictionaries30mSets and Set Operations30mList Comprehensions30mGenerator Expressions30mEssential Python Concepts30m

Week3

Week 3

10 hours to complete

Data in Python: Pandas and Alternatives

10 hours to complete

10 videos (Total 63 min)

10 videos

Introduction to Data in Python: Pandas and Alternatives36sCreating Pandas DataFrames in Python4mInvestigating Data in a Pandas DataFrame6mSelecting Data in a Pandas DataFrame6mManipulating Pandas DataFrames4mUpdating Pandas DataFrame Data5mApplying Functions in a Pandas DataFrame6mCreating NumPy Arrays in Python15mSpark and PySpark DataFrames in Python6mCreating Dask DataFrames in Python6m

4 practice exercises

NumPy30mPySpark30mDask30mPandas and Alternatives30m

Week4

Week 4

9 hours to complete

Python Development Environments

9 hours to complete

12 videos (Total 48 min)

12 videos

Introduction to Python Development Environments29sIntroduction to Vim Normal Mode6mSwitching from Normal to Insert and Visual Modes in Vim4mWorking with the Vim Command Line6mVim Configuration3mIntroduction to Visual Studio Code1mSetting Up Visual Studio Code2mDebugging Visual Studio Code3mWhat is Version Control?3mIntroduction to Git and Git Concepts7mVersion Control with GitHub6mSummary of Python and Pandas for Data Engineering27s

7 practice exercises

Insert and Visual Modes30mVim Command Line Mode30mFeatures of Visual Studio Code30mVersion Control30mGit Commands30mHosted Git30mCumulative Python and Pandas for Data Engineering Quiz45m

Reviews

4.5

34 reviews

5 stars
68.86%
4 stars
19.81%
3 stars
4.71%
2 stars
1.88%
1 star
4.71%

TOP REVIEWS FROM PYTHON AND PANDAS FOR DATA ENGINEERING

by SMAug 15, 2022

Great introduction to how to set up your python environment.

by NIOct 21, 2022

Great course! I wish they put introduction to VS code in the first week, so that all work can be done there, but othewise, a good beginner course.

by JMDec 5, 2022

Don't let the intro videos with the odd presentation format dissuade you, the rest of the course is excellent and uses normal slides to teach! Very good refresher, thank you!

by BLJun 29, 2022

Good for quick basics of working with bash, github, python, virtual environments and such

View all reviews

About the Python, Bash and SQL Essentials for Data Engineering Specialization

If you are interested in developing the skills needed to be a data engineer, the Python, Bash and SQL Essentials for Data Engineering Specialization is a great place to start. We live in a world that is driven by big data - from what we search online to the route we take to our favorite restaurant, and everything in between. Businesses and organizations use this data to make decisions that impact the ways in which we navigate our lives. How do engineers collect this data? How can this data be organized so that it can be appropriately analyzed? A data engineer is specialized in this initial step of accessing, cleaning and managing big data.

Data engineers today need a solid foundation in a few essential areas: Python, Bash and SQL. In Python, Bash and SQL Essentials for Data Engineering, we provide a nuts and bolts overview of these fundamental skills needed for entering the world of data engineering. Led by three professional data engineers, this Specialization will provide quick and accessible ways to learn data engineering strategies, give you a chance to practice what you’ve learned in integrated lab exercises, and then immediately apply these techniques in your professional or academic life.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Python and Pandas for Data Engineering

About this Course

What you will learn

Skills you will gain

Instructors

Kennedy Behrman

Alfredo Deza

Noah Gift

Offered by

Duke University

Syllabus - What you will learn from this course

Getting Started with Python

Essential Python

Data in Python: Pandas and Alternatives

Python Development Environments

Reviews

TOP REVIEWS FROM PYTHON AND PANDAS FOR DATA ENGINEERING

About the Python, Bash and SQL Essentials for Data Engineering Specialization

Frequently Asked Questions

Learn Something New

Popular Data Science Courses

Popular Computer Science & IT Courses

Popular Business Courses

Coursera

Community

More

Python and Pandas for Data Engineering

About this Course

What you will learn

Skills you will gain

Instructors

Kennedy Behrman

Alfredo Deza

Noah Gift

Offered by

Duke University

Syllabus - What you will learn from this course

Getting Started with Python

Essential Python

Data in Python: Pandas and Alternatives

Python Development Environments

Reviews

TOP REVIEWS FROM PYTHON AND PANDAS FOR DATA ENGINEERING

About the Python, Bash and SQL Essentials for Data Engineering Specialization

Frequently Asked Questions

Coursera Footer

Learn Something New

Popular Data Science Courses

Popular Computer Science & IT Courses

Popular Business Courses

Coursera

Community

More