Course Overview
- Course Title: Curso Completo de Bases de Datos: Aprende SQL y MySQL
- Instructor: Álvaro Chirou, Walter Coto, Kevin García
- Target Audience:
- Beginners in database management and SQL programming
- IT professionals seeking to expand skills in MySQL and database administration
- Developers looking to integrate databases into web applications
- Prerequisites:
- Computer with internet access (no prior database knowledge required)
Curriculum Highlights
- Key Topics Covered:
- Database fundamentals (from zero)
- SQL queries (SELECT, INSERT, UPDATE, DELETE, JOINs)
- MySQL database engine (setup, configuration, optimization)
- Database administration (user roles, permissions, backups)
- Views (creation, usage, and benefits)
- Triggers (disparadores) (event-based automation)
- Transactions (ACID properties, COMMIT, ROLLBACK)
- Stored procedures & routines (reusable SQL code blocks)
- Cardinality in databases (one-to-one, one-to-many, many-to-many relationships)
- Web database integration (connecting MySQL to web apps)
- Key Skills Learned:
- Write complex SQL queries for data retrieval and manipulation
- Design and normalize database schemas
- Administer MySQL databases (security, performance tuning)
- Automate tasks with triggers and stored procedures
- Implement database-driven web applications
- Understand relational database theory (keys, indexes, relationships)
Course Format
- Duration: 29.5 hours on-demand video
- Format: Self-paced online course (lifetime access)
- Resources:
- 10 downloadable resources (SQL scripts, cheat sheets, exercises)
- Assignments (practical exercises for hands-on learning)
- Certificate of completion
- Mobile & TV access (learn on-the-go)
- Q&A support (instructor responses to student questions)
Additional Information
- Language: Spanish
- Last Updated: Regularly updated (free updates for enrolled students)
- Student Enrollment: 699,661+ students (across instructors' courses)
- Instructor Ratings: 4.5/5 (from 98,212+ reviews)