Duke University
Python, Bash and SQL Essentials for Data Engineering Specialization
20,260 enrolled
Duke University

Python, Bash and SQL Essentials for Data Engineering Specialization

Launch Your Career in Data Engineering. Master foundational strategies and tools to become proficient in developing data engineering and machine learning solutions

Included with Coursera Plus

Get in-depth knowledge of a subject

(350 reviews)

Beginner level

Recommended experience

Flexible schedule
4 months at 5 hours a week
Earn a career credential
Share your expertise with employers
Get in-depth knowledge of a subject

(350 reviews)

Beginner level

Recommended experience

Flexible schedule
4 months at 5 hours a week
Earn a career credential
Share your expertise with employers

Overview

  • Develop data engineering solutions with a minimal and essential subset of the Python language and the Linux environment

  • Design scripts to connect and query a SQL database using Python

  • Use a scraping library in Python to read, identify and extract data from websites

What’s included

Shareable certificate

Add to your LinkedIn profile

Taught in English
63 practice exercises

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from Duke University

Specialization - 4 course series

What you'll 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'll gain

Category: Python Programming
Category: Pandas (Python Package)
Category: Data Manipulation
Category: Git (Version Control System)
Category: Jupyter
Category: Development Environment
Category: Virtual Environment
Category: Integrated Development Environments
Category: Version Control
Category: Data Structures
Category: Software Development Tools

What you'll learn

  • Use Linux tools build data engineering solutions.

  • Develop Bash syntax to configure and control Linux.

Skills you'll gain

Category: Linux Commands
Category: Shell Script
Category: Bash (Scripting Language)
Category: File Management
Category: Scripting
Category: Linux
Category: Command-Line Interface
Category: Remote Access Systems
Category: Data Management
Category: Data Processing
Category: Unix Shell
Category: Unix Commands
Category: Linux Administration
Category: File Systems
Category: Data Pipelines

What you'll learn

  • Extract data from different sources and map it to Python data structures.

  • Design Scripts to connect and query a SQL database from within Python.

  • Apply scraping techniques to read and extract data from a website.

Skills you'll gain

Category: SQL
Category: Data Structures
Category: MySQL
Category: Web Scraping
Category: Data Import/Export
Category: Python Programming
Category: Scripting
Category: Data Manipulation
Category: Database Management
Category: Data Store
Category: Dataflow
Category: Database Systems
Category: Databases

What you'll learn

  • Construct Python Microservices with FastAPI

  • Build a Command-Line Tool in Python using Click

  • Compare multiple ways to set up and use a Jupyter notebook

Skills you'll gain

Category: AWS SageMaker
Category: Jupyter
Category: Cloud Hosting
Category: Command-Line Interface
Category: Containerization
Category: Microservices
Category: Test Automation
Category: Unit Testing
Category: Docker (Software)
Category: Python Programming
Category: Development Environment

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

Kennedy Behrman
Duke University
7 Courses57,344 learners
Noah Gift
Duke University
40 Courses186,301 learners
Alfredo Deza
Duke University
29 Courses143,539 learners

Offered by

Duke University

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Coursera Plus

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions