Duke University
Python, Bash and SQL Essentials for Data Engineering Specialization
20,271 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

(351 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

(351 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: Software Development Tools
Category: Jupyter
Category: Data Structures
Category: Virtual Environment
Category: Development Environment
Category: Integrated Development Environments
Category: Version Control

What you'll learn

  • Use Linux tools build data engineering solutions.

  • Develop Bash syntax to configure and control Linux.

Skills you'll gain

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

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: Data Structures
Category: SQL
Category: Python Programming
Category: Scripting
Category: Data Import/Export
Category: MySQL
Category: Web Scraping
Category: Data Store
Category: Database Systems
Category: Data Manipulation
Category: Dataflow
Category: Databases
Category: Database Management

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: Microservices
Category: Containerization
Category: Command-Line Interface
Category: Cloud Hosting
Category: Python Programming
Category: Docker (Software)
Category: Test Automation
Category: Unit Testing
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,378 learners
Noah Gift
Duke University
40 Courses186,512 learners
Alfredo Deza
Duke University
29 Courses143,735 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