IBM
Data Engineering Foundations Specialization

Ends tomorrow: Get a Black Friday boost with $160 off 10,000+ programs. Save now.

IBM

Data Engineering Foundations Specialization

Build the Foundation for a Data Engineering Career. Develop hands-on experience with Python, SQL, and Relational Databases and master the fundamentals of the Data Engineering ecosystem.

Abhishek Gagneja
Joseph Santarcangelo
Rav Ahuja

Instructors: Abhishek Gagneja +6 more

21,386 already enrolled

Included with Coursera Plus

Get in-depth knowledge of a subject
4.7

(1,432 reviews)

Beginner level

Recommended experience

2 months to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
4.7

(1,432 reviews)

Beginner level

Recommended experience

2 months to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Working knowledge of Data Engineering Ecosystem and Lifecycle. Viewpoints and tips from Data professionals on starting a career in this domain.

  • Python programming basics including data structures, logic, working with files, invoking APIs, using libraries such as Pandas and Numpy, doing ETL.

  • Relational Database fundamentals including Database Design, Creating Schemas, Tables, Constraints, and working with MySQL, PostgreSQL & IBM Db2.

  • SQL query language, SELECT, INSERT, UPDATE, DELETE statements, database functions, stored procs, working with multiple tables, JOINs, & transactions.

Skills you'll gain

  • Category: Python Programming
  • Category: Data Architecture
  • Category: IBM DB2
  • Category: Data Store
  • Category: Databases
  • Category: Data Governance
  • Category: Data Pipelines
  • Category: Extract, Transform, Load
  • Category: Stored Procedure
  • Category: Big Data
  • Category: Data Warehousing
  • Category: Database Design
  • Category: SQL
  • Category: Data Transformation
  • Category: Programming Principles
  • Category: MySQL
  • Category: Relational Databases
  • Category: Database Management Systems
  • Category: Web Scraping
  • Category: Data Import/Export

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

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 IBM

Specialization - 5 course series

What you'll learn

  • List basic skills required for an entry-level data engineering role.

  • Discuss various stages and concepts in the data engineering lifecycle.

  • Describe data engineering technologies such as Relational Databases, NoSQL Data Stores, and Big Data Engines.

  • Summarize concepts in data security, governance, and compliance.

Skills you'll gain

Category: Data Pipelines
Category: Extract, Transform, Load
Category: Data Warehousing
Category: Data Architecture
Category: Data Security
Category: NoSQL
Category: Data Store
Category: Apache Spark
Category: Data Governance
Category: Relational Databases
Category: Big Data
Category: SQL
Category: Data Science
Category: Apache Hadoop
Category: Data Lakes
Category: Databases

What you'll learn

  • Develop a foundational understanding of Python programming by learning basic syntax, data types, expressions, variables, and string operations.

  • Apply Python programming logic using data structures, conditions and branching, loops, functions, exception handling, objects, and classes.

  • Demonstrate proficiency in using Python libraries such as Pandas and Numpy and developing code using Jupyter Notebooks.

  • Access and extract web-based data by working with REST APIs using requests and performing web scraping with BeautifulSoup.

Skills you'll gain

Category: Python Programming
Category: Pandas (Python Package)
Category: NumPy
Category: Web Scraping
Category: Data Structures
Category: Application Programming Interface (API)
Category: Data Manipulation
Category: Object Oriented Programming (OOP)
Category: JSON
Category: Jupyter
Category: Data Processing
Category: Automation
Category: Scripting
Category: Data Analysis
Category: Computer Programming
Category: Data Import/Export
Category: Restful API
Category: Programming Principles

What you'll learn

  • Demonstrate your skills in Python for working with and manipulating data

  • Implement webscraping and use APIs to extract data with Python

  • Play the role of a Data Engineer working on a real project to extract, transform, and load data

  • Use Jupyter notebooks and IDEs to complete your project

Skills you'll gain

Category: Data Manipulation
Category: Extract, Transform, Load
Category: Web Scraping
Category: Python Programming
Category: Restful API
Category: SQL
Category: Unit Testing
Category: Databases
Category: Integrated Development Environments
Category: Data Transformation
Category: Data Processing
Category: Code Review
Category: Application Programming Interface (API)
Category: Style Guides

What you'll learn

  • Describe data, databases, relational databases, and cloud databases.

  • Describe information and data models, relational databases, and relational model concepts (including schemas and tables). 

  • Explain an Entity Relationship Diagram and design a relational database for a specific use case.

  • Develop a working knowledge of popular DBMSes including MySQL, PostgreSQL, and IBM DB2

Skills you'll gain

Category: Relational Databases
Category: Database Design
Category: SQL
Category: MySQL
Category: PostgreSQL
Category: Database Architecture and Administration
Category: Data Manipulation
Category: Data Modeling
Category: Data Management
Category: Databases
Category: IBM DB2
Category: Data Integrity
Category: Command-Line Interface
Category: Database Management Systems

What you'll learn

  • Analyze data within a database using SQL and Python.

  • Create a relational database and work with multiple tables using DDL commands.

  • Construct basic to intermediate level SQL queries using DML commands.

  • Compose more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins.

Skills you'll gain

Category: SQL
Category: Pandas (Python Package)
Category: Data Manipulation
Category: Relational Databases
Category: Jupyter
Category: Data Analysis
Category: Databases
Category: Stored Procedure
Category: Python Programming
Category: Transaction Processing
Category: Query Languages

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

Abhishek Gagneja
Abhishek Gagneja
IBM
6 Courses250,369 learners
Joseph Santarcangelo
Joseph Santarcangelo
IBM
36 Courses2,240,481 learners

Offered by

IBM

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

Frequently asked questions