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.
Offert par
Réseau de compétences IBMÀ propos de ce cours
222 019 consultations récentes
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Niveau débutant
Computer and IT literacy. Curiosity about how data is managed.
Approx. 16Â heures pour terminer
Anglais
Sous-titres : Anglais
Ce que vous allez apprendre
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.
Implement different relational model constraints.
Compétences que vous acquerrez
- Database (DB) Design
- Database Architecture
- Postgresql
- MySQL
- Relational Database Management System (RDBMS)
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Niveau débutant
Computer and IT literacy. Curiosity about how data is managed.
Approx. 16Â heures pour terminer
Anglais
Sous-titres : Anglais
Offert par
Réseau de compétences 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.
Programme de cours : ce que vous apprendrez dans ce cours
4Â heures pour terminer
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.
4Â heures pour terminer
13 vidéos (Total 72 min), 3 lectures, 5 quiz
3Â heures pour terminer
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Â heures pour terminer
11 vidéos (Total 55 min), 2 lectures, 4 quiz
4Â heures pour terminer
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Â heures pour terminer
7 vidéos (Total 31 min), 2 lectures, 10 quiz
5Â heures pour terminer
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.
5Â heures pour terminer
1 vidéo (Total 8 min), 2 lectures, 5 quiz
Avis
- 5 stars70,25Â %
- 4 stars22,05Â %
- 3 stars4,10Â %
- 2 stars1,53Â %
- 1 star2,05Â %
Meilleurs avis pour INTRODUCTION TO RELATIONAL DATABASES (RDBMS)
par DP28 sept. 2021
Really great and gives a foundation of relational databases.
par OC7 juin 2022
The course is amazing, challenging, educating and interesting.
par MC16 mars 2022
The use of IBM services limited opportunities to study. Generally methods and common practices werre explained in great detail.
par AP28 nov. 2021
The course is well structured and well explained with extra hands on experience. I strongly recommend this course.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
À quoi ai-je droit si je m'abonne à ce Certificat ?
What is the refund policy?
D'autres questions ? Visitez le Centre d'Aide pour les Étudiants.
