Relational Database Basics
Data Engineering Fundamentals,
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.
What you'll learn
- The objective of this course is to provide you with a solid understanding of relational databases and Relational Database Management Systems (RDBMS).
- After completing this course, you will be able to:
- Describe a relational database and explain relational database concepts.
- Design the schema of a relational database.
- Create database objects such as tables, keys, constraints, and views.
- Load tables with data from .CSV files.
- Demonstrate working knowledge of MySQL, PostgreSQL and IBM Db2.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 4 weeks |
Effort | 4 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructors | Rav Ahuja, Lin Joyner, Rose Malcolm |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science |
Tags | Data Analysis & Statistics |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Adjunt Instructor - Databases $56k
Relational DB Analyst $114k
.NET Web Developer / SQL Databases Consultant $119k
UNIX/Perl Developer / Oracle / SQL Server Databases $126k
Senior Software Engineer - Databases $152k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 4 weeks |
Effort | 4 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructors | Rav Ahuja, Lin Joyner, Rose Malcolm |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science |
Tags | Data Analysis & Statistics |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course