WF - 340 - Introduction to Relational Databases (RDBMS)
Course Description
Are you ready to dive into the world of data engineering? In this beginner level course, you will gain a solid understanding of how data is stored, processed, and accessed in relational databases (RDBMSes). You will work with different types of databases that are appropriate for various data processing requirements.
You will begin this course by being introduced to relational database concepts, as well as several industry standard relational databases, including IBM DB2, MySQL, and PostgreSQL. Next, you’ll utilize RDBMS tools used by professionals such as phpMyAdmin and pgAdmin for creating and maintaining relational databases. You will also use the command line and SQL statements to create and manage tables. This course incorporates hands-on, practical exercises to help you demonstrate your learning. You will work with real databases and explore real-world datasets. You will create database instances and populate them with tables and data. At the end of this course, you will complete a final assignment where you will apply your accumulated knowledge from this course and demonstrate that you have the skills to: design a database for a specific analytics requirement, normalize tables, create tables and views in the database, load and access data. No prior knowledge of databases or programming is required. Anyone can audit this course at no-charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course.
Learner Outcomes
-
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
Applies Towards the Following Certificates
- IBM Business Intelligence (BI) Analyst Professional Certificate : IBM Business Intelligence (BI) Analyst Professional Certificate