Online course – Certified professional specialization in teaching the fundamentals of data engineering from Google, IBM

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.

Suggested by: Coursera (What is Coursera?)

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Understanding the ecosystem and data engineering lifecycle
  • Python skills
  • Skills in SQL and relational databases
  • Practical experience working with real tools and databases
  • Analyzing socio-economic data using SQL
  • Working with advanced SQL techniques
  • Experience with MySQL, PostgresSQL, IBM Db2, PhpMyAdmin, pgAdmin, IBM Cloud, Jupyter notebooks, Watson Studio

What you will learn in the course

Courses for which the course is suitable

  • Data Engineer
  • Data Analyst
  • SQL key
  • Python developer
  • Relational database expert
  • Socioeconomic data analyst
  • Data Solutions Developer
  • Data Project Manager
  • IBM Cloud Expert
  • Developer in Jupyter notebooks
  • Developer at Watson Studio

Internship – Series of 5 courses

Data engineering is one of the fastest growing technology professions, with the demand for skilled data engineers far exceeding the supply. The goal of data engineering is to make high-quality data available for fact-finding and data-driven decision-making.

This internship from IBM will help anyone interested in building a career in data engineering by learning the foundational skills that are important to get started in this field. No prior experience in data engineering is required to succeed in this internship.

Internship content

  • The ecosystem and data engineering lifecycle
  • Python
  • SQL and relational databases

You’ll learn the essential requirements of data engineering through engaging videos and hands-on exercises working with real tools and real-world databases. You’ll develop your understanding of data engineering, gain skills that can be directly applied to a data career, and build the foundation for your data engineering career.

After successfully completing these courses, you will have the practical knowledge and experience to delve deeper into data engineering and work on more advanced projects in the field.

Hands-on Learning Project

All courses in the specialization include a number of practice labs and assignments to help you gain practical experience and skills.

Projects range from working with data in multiple formats to converting the data and loading it into a single source, while analyzing socio-economic data using SQL and working with advanced SQL techniques.

You will work hands-on with a variety of real-world databases and tools, including:

  • MySQL
  • PostgresSQL
  • IBM Db2
  • PhpMyAdmin
  • pgAdmin
  • IBM Cloud
  • Python
  • Jupyter notebooks
  • Watson Studio

Details of the courses that make up the specialization

Introduction to Data Engineering

Course 1 • 13 hours • 4.7 (2,711 ratings)

Course Details

  • The range of basic skills required for an entry-level role in data engineering.
  • Discussion of the various stages and concepts in the data engineering life cycle.
  • Describe data engineering technologies such as relational databases, NoSQL databases, and big data engines.
  • Summary of concepts about data security, management, and compliance.

Skills you will acquire

  • Data Science
  • Data Analytics
  • Python programming
  • Numpy
  • Pandas

Python for Data Science, AI, and Development

Course 2 • 25 hours • 4.6 (38,067 ratings)

Course Details

  • Learn Python – the most popular programming language for data science and software development.
  • Implement Python programming logic: variables, data structures, branches, loops, functions, objects, and classes.
  • Demonstrate proficiency in using Python libraries such as Pandas and NumPy, and develop code using Jupyter Notebooks.
  • Get data from the internet using APIs and Python libraries like Beautiful Soup.

Skills you will acquire

  • Python programming
  • Information Engineering
  • Extraction, Transformation, and Loading (ETL)
  • Data Engineer
  • Scraping data from the internet

Python Project for Data Engineering

Course 3 • 9 hours • 4.6 (665 ratings)

Course Details

  • Demonstrate your Python skills in working with data.
  • Implement web scraping and use APIs to extract data with Python.
  • Become a data engineer working on a real project to extract, transform, and load data.
  • Utilize Jupyter Notebooks and IDEs to complete your project.

Skills you will acquire

  • Python programming
  • Cloud databases
  • Relational Database Management System (RDBMS)
  • SQL
  • Jupyter Notebooks

Introduction to Relational Databases (RDBMS)

Course 4 • 15 hours • 4.6 (586 ratings)

Course Details

  • 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.
  • Develop working knowledge of popular DBMS environments including MySQL, PostgreSQL, and IBM DB2.

Skills you will acquire

  • Data Science
  • Databases (DBMS)
  • Information Engineering
  • SQL
  • NoSQL

Databases and SQL for Data Science with Python

Course 5 • 20 hours • 4.7 (20,414 ratings)

Course Details

  • Analyze data within a database using SQL and Python.
  • Create a relational database and work with multiple tables using DDL commands.
  • Build basic to intermediate level SQL queries with DML commands.
  • Clean up more powerful queries with advanced SQL techniques like Views, Transactions, Stored Procedures, and Joins.

Skills you will acquire

  • Database Design (DB)
  • PostgreSQL
  • Relational Database Management System (RDBMS)
  • Database architecture
  • MySQL