Relational Database Basics
About this Course
Please Note: Learners who successfully complete this IBM course can earn a skill badge — a detailed, verifiable and digital credential that profiles the knowledge and skills you’ve acquired in this course. Enroll to learn more, complete the course and claim your badge! This course is an introduction to the world of relational databases. You will explore the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS), learn about relational database design, and understand how to transform source data into tables with clearly defined relationships. From there, you will learn how to apply relational database design principles to your own data, and create databases, tables, and load data yourself. You’ll get an introduction to Structured Query Language (SQL) and use it to add the keys and constraints necessary in a relational database. This course includes hands-on, practical exercises to help you demonstrate your learning. You will work with several industry standard relational databases, including IBM Db2, MySQL, and PostgreSQL. Based on what you’ve learned through the course, you’ll complete a final project in which you’ll design, create, and populate a database instance containing multiple tables. No prior knowledge of databases or programming is required.Created by: IBM
Level: Introductory
Related Online Courses
While randomized controlled trials are considered to be the "gold standard" in health research, they cannot always be performed, for ethical or practical reasons. Observational studies gather... more
Today the principles and techniques of reproducible research are more important than ever, across diverse disciplines from astrophysics to political science. No one wants to do research that... more
Structured Query Language (SQL) is a standardized programming language used to manage relational databases and perform various operations on their data. This is the first course of a two-part... more
Students learn to construct a wide variety of SQL statements – from beginning to more advanced concepts – such as joins, common table expressions, window functions, etc. Students also learn the bas... more
Perhaps the most popular data science methodologies come from machine learning. What distinguishes machine learning from other computer guided decision processes is that it builds prediction... more