Are you ready to dive into the world of data engineering? You’ll need a solid understanding of how data is stored, processed, and accessed. You’ll need to identify the different types of database that are appropriate for the kind of data you are working with and what processing the data requires.
Offered By
About this Course
33,008 recent views
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 4 of 5 in the
Beginner Level
Computer and IT literacy. Curiosity about how data is managed.
Approx. 13 hours to complete
English
Subtitles: English
What you will learn
Fundamental Relational Database concepts. Types of RDBMS objects. Popular database systems.
Design a relational database and its schema. Create Entity Relationship Diagrams (ERD). Normalize data.
Work hands-on with Relational Databases such MySQL, PostgreSQL and Db2 using web tools and command line.
Create tables and load data. Export data from one database and import into another RDBMS.
Skills you will gain
Database (DB) DesignDatabase ArchitecturePostgresqlMySQL• Relational Database Management Systems (RDBMS)
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 4 of 5 in the
Beginner Level
Computer and IT literacy. Curiosity about how data is managed.
Approx. 13 hours to complete
English
Subtitles: English
Offered by
IBM
IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world.
Syllabus - What you will learn from this course
3 hours to complete
Relational Database Concepts
A relational database organizes data into tables that can be linked—or related—based on data common to each. By storing your business data in a relational database, you can retrieve and analyze the data to make important business decisions.
3 hours to complete
13 videos (Total 72 min), 3 readings, 4 quizzes
3 hours to complete
Using Relational Databases
In this module, you will learn how to use a RDBMS GUI or web interface and SQL statements to create and manage the tables in a relational database and populate them with data. You will also learn how to employ some database design techniques that help improve the integrity of your data and the performance of your queries, including the use of Primary and Foreign keys to define relationships, indexes, normalization, and relational model constraints.
3 hours to complete
11 videos (Total 55 min), 2 readings, 4 quizzes
4 hours to complete
MySQL and PostgreSQL
MySQL and PostreSQL are two common RDBMS tools for creating and managing relational databases. Both are free and open-source, have download/install and cloud versions, and offer both command-line and desktop and/or web interface options. In this module, you will learn the basics of creating databases and tables, defining keys and constraints in tables, and loading a database with data using MySQL and PostgreSQL. You will also learn how to define views in PostgreSQL to limit access to sensitive data and simplify data retrieval.
4 hours to complete
7 videos (Total 31 min), 2 readings, 10 quizzes
4 hours to complete
Course Assignment
This module contains the final project for this course. You will consolidate the skills that you learned throughout this course by applying them to a specific scenario. To complete the project successfully, you must demonstrate that you have the skills to design a database from a new set of data, including creating an ERD to identify entities, attributes, and relationships. You will normalize tables, create your database, and load some data. You will also demonstrate some database management tasks by working with views.
4 hours to complete
1 video (Total 8 min), 2 readings, 4 quizzes
About the Data Engineering Foundations Specialization
Data engineering is one of the fastest-growing tech occupations, where the demand for skilled data engineers far outweighs the supply. The goal of data engineering is to make quality data available for fact-finding and data-driven decision making. This Specialization from IBM will help anyone interested in pursuing a career in data engineering by teaching fundamental skills to get started in this field. No prior data engineering experience is required to succeed in this Specialization.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.
