Ir al contenido principalSkip to Xpert Chatbot

IBM: Relational Database Basics

4.5 stars
47 ratings

This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS) such as MySQL, PostgreSQL, and IBM Db2.

Relational Database Basics
4 semanas
2–3 horas por semana
A tu ritmo
Avanza a tu ritmo
Gratis
Verificación opcional disponible

Hay una sesión disponible:

¡Ya se inscribieron 10,162! Una vez finalizada la sesión del curso, será archivadoAbre en una pestaña nueva.
Comienza el 2 abr
Termina el 30 jun
Inscríbete ahora
Relational Database Basics

Sobre este curso

Omitir Sobre este curso

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.

Premios

Relational Database Basics

De un vistazo

  • Institution IBM
  • Subject Análisis de datos
  • Level Introductory
  • Prerequisites
    Ninguno
  • Language English
  • Video Transcripts اَلْعَرَبِيَّةُ, Deutsch, English, Español, Français, हिन्दी, Bahasa Indonesia, Português, Kiswahili, తెలుగు, Türkçe, 中文

Lo que aprenderás

Omitir Lo que aprenderás

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.

Plan de estudios

Omitir Plan de estudios

Module 1 – Relational Database Concepts

  • Review of data fundamentals

  • Information and Data Models

  • Types of Relationships

  • Mapping Entities to Tables

  • Data Types

  • Relational Model ConceptsRelational Database Architectures and Usage Scenarios

  • Introduction to Relational Database Products

  • Db2

  • MySQL

  • PostgreSQL

Module 2 – Using Relational Databases

  • Creating Tables

  • Loading Data

  • Exporting Data

  • Primary Keys and Foreign Keys

  • Overview of Indexes

  • Normalization

  • Relational Model Constraints

Module 3 – MySQL and PostgreSQL

  • Getting started with MySQL - architecture, design focus

  • Creating Databases and Tables in MySQL

  • Loading Data in MySQL

  • Using Keys and Constraints in MySQL

  • Getting started with PostgreSQL

  • Creating Databases and loading data into PostgreSQL

  • Views

Module 4 – Database Design Project

  • Approach to Database Design

  • Final Project

Este curso es parte del programa Data Engineering Professional Certificate

Más información 
Instrucción por expertos
14 cursos de capacitación
A tu ritmo
Avanza a tu ritmo
1 año 2 meses
3 - 4 horas semanales

Formas de realizar este curso

Elige tu camino al inscribirte.

Verified Track

Audit Track

Costo

99 US$

Free

Acceso a los materiales del curso

Ilimitado

Limitado

Caduca el 30 abr

World class institutions and universities

Asistencia de edX

Certificado para compartir al finalizar

Tareas con calificación y exámenes

Visita la sección de Preguntas frecuentesen una pestaña nueva con preguntas frecuentes sobre estas modalidades.

¿Te interesa este curso para tu negocio o equipo?

Capacita a tus empleados en los temas más solicitados con edX para Negocios.