Acerca de este curso: Welcome to the specialization course Relational Database Systems. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how several types of information systems and databases are available to solve different problems and needs of the companies. Objective: A learner will be able to design, test, and implement analytical, transactional or NoSQL database systems according to business requirements by programming reliable, scalable and maintainable applications and resources using SQL and Hadoop ecosystem. Programming languages: For course 1 you will use the MYSQL language. Software to download: MySQL Workbench In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).
Para quién es esta clase: A learner with previous database systems experience will be able to design, test, and implement analytical, transactional or NoSQL database systems according to business requirements by programming reliable, scalable and maintainable applications and resources using SQL and Hadoop ecosystem. By the end of this Specialization, learners will have completed 4 progressively harder database projects.
Creada por: Universidad Nacional Autónoma de México
Enseñado por: María del Pilar Ángeles, Full time professor at the Department of Computer Engineering
Department of Computer Engineering
| Información básica | Curso 1 de 4 en Database systems Specialization |
| Nivel | Intermedio |
| Idioma | Inglés (English) |
| Requerimientos de hardware | Window o Linux. You will need: 8-10 GB of RAM and 500 GB de HDD. |
| Cómo aprobar | Aprueba todas las tareas calificadas para completar el curso. |
Programa
SEMANA 1
Information Systems
In the first module named information systems, we will learn how people, hardware, software, networks, techniques and procedures work together to automate transactional processes that companies need for their daily operations. Let's start!
2 videos, 1 lecturas, 1 cuestionarios de práctica
- Reading: Welcome to the course!
- Discussion Prompt: Welcome!
- Vídeo: Database concepts
- 练习测验: Information system
- Discussion Prompt: Have you worked with any information system?
SEMANA 2
Entity Relationship Theory and Conceptual Design
The present module is focused on Conceptual Design. The learner will be able to create an Entity Relationship Diagram through the Conceptual Design from business requirements.
2 videos, 1 cuestionarios de práctica
- Vídeo: Power Designer
- Discussion Prompt: Conceptual modelling
- 练习测验: Conceptual Design
- 同学互评: Conceptual Design: Musical System
- Discussion Prompt: Peter Chen Notation
Calificado: Conceptual Design: The Bookstore
SEMANA 3
Relational Database Theory and Logical Design
The present module is focused on Logical Design. The learner will be able to create an Relational Model from the entity-relationship diagram
2 videos, 1 cuestionarios de práctica
- Vídeo: From the conceptual model to the logical design
- Discussion Prompt: Confusion about conceptual modelling with logical modelling
- 练习测验: Logical Design
- 同学互评: Logical Design: Musical System
- Discussion Prompt: A relational model
Calificado: Logical Design: The Bookstore
SEMANA 4
Structured Query Language Data Manipulation Language
The present module is focused on Physical Design. The learner will be able to create database objects with data definition language from the Structured Query Language.
3 videos, 2 lecturas, 1 cuestionarios de práctica
- Reading: MySQL Tutorial
- Reading: Create and complete a database. Code
- Vídeo: Create and populate a database
- Vídeo: DDL Sailors
- Discussion Prompt: Create database...
- 练习测验: Physical Design
- 同学互评: Create the DDL: Musical System
Calificado: Create the DDL: The Bookstore
SEMANA 5
Structured Query Language and Advanced SQL Programming
The present module is focused on Data Manipulation Language on SQL programming to feed and query relational database objects.
3 videos
- Vídeo: SQL-Clauses
- Vídeo: DML Sailors
- Discussion Prompt: SQL processing
- 同学互评: DML Exercise
Calificado: Insert and Query to Bookstore database system
SEMANA 6
Transactions and query optimization
The present module is focused on query optimization according to type of information systems.
2 videos, 1 cuestionarios de práctica
- Vídeo: Triggers, store procedures and cursors
- Discussion Prompt: Data inconsistency...
- 练习测验: Transactions and query optimization
- 同学互评: Creating and executing transactions
Calificado: Assessment
Preguntas Frecuentes
Cómo funciona
课程作业
每门课程都像是一本互动的教科书，具有预先录制的视频、测验和项目。
来自同学的帮助
与其他成千上万的学生相联系，对想法进行辩论，讨论课程材料，并寻求帮助来掌握概念。
证书
获得正式认证的作业，并与朋友、同事和雇主分享您的成功。
Creadores
Universidad Nacional Autónoma de México
La Universidad Nacional Autónoma de México fue fundada el 21 de septiembre de 1551 con el nombre de la Real y Pontificia Universidad de México. Es la más grande e importante universidad de México e Iberoamérica. Tiene como propósito primordial estar al servicio del país y de la humanidad, formar profesionistas útiles a la sociedad, organizar y realizar investigaciones, principalmente acerca de las condiciones y problemas nacionales, y extender con la mayor amplitud posible, los beneficios de la cultura.
Tarifa
| Comprar curso | |
|---|---|
| Accede a los materiales del curso | Disponible |
| Accede a los materiales con calificación | Disponible |
| Recibe una calificación final | Disponible |
| Obtén un Certificado de curso para compartir | Disponible |
Calificaciones y revisiones
Coursera brinda acceso universal a la mejor educación del mundo, al asociarse con las mejores universidades y organizaciones, para ofrecer cursos en línea.
© 2018 Coursera Inc. Todos los derechos reservados.
