MySql: Base de datos MariaDB MySql desde cero hasta experto

Aprende a diseñar e interactuar con base de datos de cero a experto con MariaDB/MySQL así como aprender el Lenguaje SQL.

4.30 (48 reviews)
Udemy
platform
Español
language
Databases
category
MySql: Base de datos MariaDB MySql desde cero hasta experto
287
students
4 hours
content
Dec 2021
last update
$19.99
regular price

What you will learn

Generalidades de base de datos

Generalidades del servidor de base de datos MariaDB

Instalar/Arrancar servidor MariaDB (usando XAMPP)

Interactuar con servidor MariaDB usando consola

Instalar editor para SQL HeidiSQL

Cómo usar el editor de SQL HeidiSQL

Crear/Mostrar una base de datos

Eliminar una base de datos

Crear/Mostrar una tabla

Tipos de datos básicos de una tabla

Eliminar una tabla

Tipos de tablas

Insertar registros en una tabla

Leer registros de una tabla

Leer algunos campos de una tabla

Leer registros específicos de una tabla

Buscar textos parciales

Ordenar registros

Modificar registros de una tabla

Modificar algunos registros de una tabla

Borrar registros de una tabla

Borrar algunos registros de una tabla

Operadores Igual y diferente

Operador mayor que y menor que

Operadores mayor o igual que y menor o igual que

Valores que se coinciden en una lista

Negar una condición

Valores en un rango

Verifica si el valor es NULL

Verifica si el valor es diferente de NULL

Verifica si la subconsulta devuelve al menos una fila

Clave primaria y auto incremento

Clave única

Clave foránea

Usar JOIN

Usar LEFT JOIN

Usar RIGHT JOIN

Definición y estructura de una subconsulta

Función COUNT

Función MIN

Función MAX

Función SUM

Función AVG

Clausula GROUP BY

Definición de un procedimiento almacenado

Estructura de un procedimiento almacenado

Procedimiento almacenados con parámetros

Conceptos básicos de una transacción

Estructura de una transacción

Why take this course?

En este curso aprenderás a: Entender con facilidad conceptos generales de base de datos, Instalar e iniciar el servidor de base de datos MariaDB/MySQL, Diseñar base de datos relacionales, Gestionar base de datos usando el lenguaje SQL, Aplicar buenas prácticas de creación de base de datos relacionales, Conectarse al servidor de base de datos MariaDB usando el editor HeidiSQL, Crear consultas avanzadas usando el lenguaje SQL, Exportar e importar bases de datos, Crear procedimientos almacenados, funciones, triggers o disparadores, realizar backups, instalar y usar herramientas que permiten ejecutar comandos a la base de datos de forma sencilla, Crear nuevos usuarios de MySql y otorgarles privilegios, aplicar conceptos avanzados de transacciones, Usar distintas clases de índices como claves únicas, claves primarias, claves foráneas, exportar datos a distintos formatos como csv, xml, usar funciones internas de MySQl, trabajar con distintos tipos de tablas, manejar los distintos tipos de datos, usar operadores de comparación, aritméticos, usar funciones de fechas, reconocer las palabras claves del lenguaje SQL, trabajar con datos del tipo entero, varchar, enum, decimal, usar funciones de agregación, realizar consultas multi tablas, realizar sub consultas, crear vistas, ejecutar procedimientos almacenados, diseñar el diagrama entidad relación (EER) partiendo de la base de datos creada ... y muchas cosas más.                                 

Our review

🌟 **Course Review: Introduction to Databases for Accountants** 🌟 **Overview:** The course has received an overall rating of 4.30 from recent reviewers, indicating a high level of satisfaction among users. It is designed specifically for accountants looking to understand and work with databases, particularly focusing on the Entity-Relationship (ER) model. The course aims to provide a practical and concise learning experience, enabling students to apply database concepts to their professional practice. **Pros:** - **Practical Approach:** The course is praised for its hands-on approach, offering real-world applications of database principles that are highly relevant to accountants. - **Clear and Rapid Explanation:** Users appreciate the instructor's ability to deliver content quickly and clearly, minimizing unnecessary complexity and ensuring comprehension. - **Well-Structured Content:** The course is commended for its well-organized structure, which facilitates learning and allows students to follow along with ease. - **Focus on Fundamentals:** The emphasis on fundamentals, including the ER model, is highlighted as crucial for building a solid understanding of database design, which can be applied effectively in professional settings. - **Audience Relevance:** As a course tailored specifically for accountants, it addresses the needs and knowledge gaps of its target audience effectively. **Cons:** - **Data Integration Explanation:** Some reviewers felt that additional guidance on integrating data from various sources, such as importing from SQL files, would be beneficial. They suggest more coverage on data ingestion beyond manual methods, which are less common in practice. - **Didactic Interaction:** One reviewer mentioned that the interaction between the course content and the interlocutor (likely a teaching assistant or software feature) could be clearer, indicating some confusion in this area. - **ER Model Emphasis:** While the importance of the ER model is acknowledged, some users express a desire for more in-depth coverage of topics such as key types and procedural design within the ER context. - **Initial Introduction:** The course is described as a good starting point, but there is an expectation for a more comprehensive didactic approach to enhance understanding from the outset. **Additional Feedback:** - **Inclusivity of All Learning Styles:** Reviewers suggest that incorporating visual aids and interactive elements could further enhance learning engagement. - **Advanced Topics:** Some users indicate interest in more advanced topics, such as working with different types of keys and stored procedures within the ER framework, which would add depth to the course content. In summary, this course is highly recommended for accountants seeking to expand their skillset into database management, particularly those interested in mastering the Entity-Relationship model. While it serves as a solid introduction, there is room for improvement by including more practical examples of data integration and advanced ER concepts for a more comprehensive learning experience.

Charts

Price

MySql: Base de datos MariaDB MySql desde cero hasta experto - Price chart

Rating

MySql: Base de datos MariaDB MySql desde cero hasta experto - Ratings chart

Enrollment distribution

MySql: Base de datos MariaDB MySql desde cero hasta experto - Distribution chart
2471406
udemy ID
7/22/2019
course created date
8/12/2019
course indexed date
Bot
course submited by