Bases de datos from edX

El curso inicia con una introducción que presenta definiciones importantes en el área de las bases de datos, algunos datos históricos relevantes, herramientas para diseñar, crear, administrar bases de datos y el modelo relacional que permite crear modelos físicos a partir de estas.

Posteriormente, se presentan conceptos de bases de datos relacionales relacionados con el lenguaje SQL como creación, modificación, eliminación de tablas, inserción actualización, eliminación de datos, consultas, subconsultas anidadas, vistas, funciones, procedimientos almacenados, disparadores, consultas recursivas y consultas OLAP.

Finalmente, se presentan conceptos relacionados con el diseño de bases de datos mediante el modelo entidad relación y procesos de normalización exponiendo desde la primera forma normal hasta la cuarta forma normal.

What you'll learn

● Conocer aspectos históricos relacionados con bases de datos

● Crear modelos relacionales respetando aspectos de integridad

● Crear bases de datos usando el lenguaje SQL

● Manipular datos de las bases de datos usando el lenguaje SQL

● Consultar de diferentes formas los datos almacenados en bases de datos usando el lenguaje SQL

● Crear funciones usando el lenguaje plpgsql

● Crear disparadores usando el lenguaje plpgsql

● Consultar datos con base en medidas y dimensiones para análisis OLAP

● Diseñar bases de datos a partir del análisis del negocio usando modelo entidad relación

● Diseñar bases de datos normalizadas

What's inside

Syllabus

Tema 1. Introducción

● Introducción a las bases de datos

● Introducción a postgres

Tema 2. Bases de datos relacionales

● Introducción a SQL

● SQL intermedio

● SQL avanzado

Tema 3. Diseño de bases de datos

● Modelo entidad relación

● Normalización

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Explores bases de datos relacionales, que es un estándar en la industria de TI

Enseña SQL, que ayuda a los alumnos a administrar y manipular datos

Desarrolla habilidades en diseño de bases de datos, que son fundamentales para optimizar el almacenamiento y recuperación de datos

Diseñado para estudiantes con conocimientos previos en bases de datos o que buscan desarrollar habilidades en esta área

Puede requerir que los alumnos tengan acceso a un software de base de datos compatible con SQL

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Bases de datos with these activities:

Review previous database knowledge

Show steps

Refreshes foundational knowledge in database principles, preparing for a smoother learning experience during the course.

Browse courses on Databases

Show steps

Review notes, assignments, or old exams related to database concepts.
Go through relevant textbook chapters or online resources to cover core database principles.

Review Relational Algebra Concepts

Show steps

Strengthens understanding of the theoretical foundations of database operations, improving comprehension of advanced topics.

Browse courses on Relational Algebra

Show steps

Revisit textbooks or online materials on relational algebra.
Solve practice problems involving relational algebra expressions.

Compile a Glossary of Database Terminology

Show steps

Enhances understanding of database concepts by creating a comprehensive glossary of relevant terms.

Show steps

Collect and organize a list of database-related terms and their definitions.
Use flashcards or a digital tool to memorize the terms and their meanings.

Four other activities

Expand to see all activities and additional details

Show all seven activities

SQL Queries Practice

Show steps

Reinforces SQL syntax and query writing skills, building a solid foundation for database manipulation.

Browse courses on SQL

Show steps

Solve practice problems or exercises involving SQL queries.
Utilize online resources or textbooks to enhance understanding of SQL syntax.

Follow Tutorials on Database Optimization

Show steps

Gains practical insights into techniques for improving database performance.

Browse courses on Database Optimization

Show steps

Search for tutorials or articles on database optimization techniques.
Follow the instructions and apply the techniques to enhance database performance.

Design a Simple Database Schema

Show steps

Applies knowledge of database design principles to create a functional database schema.

Browse courses on Database Design

Show steps

Identify the entities and relationships involved in a real-world scenario.
Draw an entity relationship diagram (ERD).
Translate the ERD into a database schema using SQL.

Practice Creating and Manipulating Stored Procedures

Show steps

Develops proficiency in writing and utilizing stored procedures to enhance database functionality.

Browse courses on Stored Procedures

Show steps

Create several stored procedures for different database operations.
Test and debug the stored procedures to ensure correct functionality.

Career center

Learners who complete Bases de datos will develop knowledge and skills that may be useful to these careers:

Database Developer

Database Developers are experts in the design, development, and management of high-performance database systems. This course can help you gain the skills necessary for a successful career as a Database Developer. You will learn how to use SQL to create, modify, and delete data from databases, as well as how to design and normalize databases using the entity-relationship model. This course can also help you prepare for certification as a Database Administrator (DBA).

See salaries and explore the career path for Database Developer

Data Analyst

Data Analysts use their knowledge of data and statistical methods to identify trends and patterns in data. This course can help you develop the skills necessary to become a successful Data Analyst. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model. This course can also help you prepare for certification as a Data Science Professional.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts help organizations improve their performance by identifying and solving business problems. This course can help you develop the skills necessary to become a successful Business Analyst. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model. This course can also help you prepare for certification as a Business Analysis Professional.

See salaries and explore the career path for Business Analyst

Systems Analyst

Systems Analysts design, develop, and implement information systems. This course can help you develop the skills necessary to become a successful Systems Analyst. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model. This course can also help you prepare for certification as an Information Technology Professional.

See salaries and explore the career path for Systems Analyst

Software Engineer

Software Engineers design, develop, and maintain software systems. This course can help you develop the skills necessary to become a successful Software Engineer. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Software Engineer

Data Scientist

Data Scientists use their knowledge of data, statistics, and machine learning to build models that can predict future events. This course can help you develop the skills necessary to become a successful Data Scientist. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Data Scientist

Database Administrator

Database Administrators manage and maintain databases. This course can help you develop the skills necessary to become a successful Database Administrator. You will learn how to use SQL to create, modify, and delete data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Database Administrator

Information Security Analyst

Information Security Analysts protect computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction. This course can help you develop the skills necessary to become a successful Information Security Analyst. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Information Security Analyst

Computer Programmer

Computer Programmers write and test code that makes computers perform tasks. This course can help you develop the skills necessary to become a successful Computer Programmer. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Computer Programmer

Web Developer

Web Developers design and develop websites. This course can help you develop the skills necessary to become a successful Web Developer. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Web Developer

Mobile Developer

Mobile Developers design and develop mobile applications. This course can help you develop the skills necessary to become a successful Mobile Developer. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Mobile Developer

Data Engineer

Data Engineers design, build, and maintain data pipelines. This course can help you develop the skills necessary to become a successful Data Engineer. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Data Engineer

Database Architect

Database Architects design and implement database systems. This course can help you develop the skills necessary to become a successful Database Architect. You will learn how to use SQL to create, modify, and delete data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Database Architect

Computer Scientist

Computer Scientists research and develop new computer technologies. This course can help you develop the skills necessary to become a successful Computer Scientist. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Computer Scientist

Information Systems Manager

Information Systems Managers plan, direct, and coordinate the implementation and operation of computer systems and networks. This course can help you develop the skills necessary to become a successful Information Systems Manager. You will learn how to use SQL to query data from databases, as well as how to design and normalize databases using the entity-relationship model.

See salaries and explore the career path for Information Systems Manager