Bases de datos con MySQL y SQLite
Learn SQL database design & development from beginner to professional. Master relational databases with practical skills. Build a strong foundation in SQL.
Course Content
Bases de datos con MySQL y SQLite is an all-levels Udemy course taught by Vladimir Rodríguez. It runs 15h 36m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 824 reviews, with 58,924 students enrolled. It is a paid course, last updated December 2024.
Learn SQL Database Development from Scratch & Get Certified!
This comprehensive course provides a complete introduction to relational databases using SQL, equipping you with the skills to become a proficient database developer. You'll earn a Database Developer SQL certificate upon completion.
We focus on two of the most in-demand database systems in the industry: MySQL and SQLite. The best part? Both are free to use, ensuring you have full access to all necessary tools for hands-on practice and project development – crucial for mastering the material and passing the course.
The unique advantage of learning both MySQL and SQLite lies in their distinct architectures and approaches. This contrasting perspective provides a deeper understanding of database management, all while leveraging the universal language of SQL.
By the end of this course, you'll be an expert in relational databases, confidently using MySQL and SQLite. You'll also gain the foundational knowledge to easily adapt and master other SQL database engines like SQL Server, PostgreSQL, Oracle, and more.
Here's a detailed breakdown of the topics covered:
============ Introduction and Preparation ============
- Course Overview & Introduction
- MySQL & SQLite Installation: Download and setup guides.
- Official Documentation: Access to comprehensive manuals for both engines.
============ SQL Fundamentals: A Quick Guide ============
- Understanding Relational Databases: Core concepts.
- Database & Table Creation: Learn to build your database structure.
- Data Import: Import data from files.
- Basic & Complex Queries: Mastering fundamental SQL commands.
- Result Ordering & Limiting: Filtering and sorting data effectively.
- Simple Calculations & Common Functions:
MAX,COUNT,AVG,MIN,SUMand more. - Data Modification & Deletion: Updating and removing records.
- Table & Database Management: Deleting tables and databases.
- Table Structure Modification (ALTER): Dynamically altering table schemas.
- Date Functions & Formatting: Working with date and time data.
- Working with Multiple Tables & Combined Queries: Join operations.
============ Data & Tables ============
- Column Data Types: Understanding different data types.
- MySQL & SQLite Options: Exploring engine-specific features.
- Table Types:
ISAM,MyISAM,Merge,Heap,InnoDB– a detailed comparison. - InnoDB Table Features: Focus on transaction support and data integrity.
- DBD Table Features: Understanding the characteristics of DBD tables.
============ Advanced SQL ============
- JOIN Operations:
INNER JOIN,LEFT JOIN,RIGHT JOIN,USING. - UNION Operations: Combining results from multiple queries.
- Subqueries: Queries within queries.
- User Variables: Managing variables within SQL sessions.
- Stored Procedures: Creating reusable SQL code.
- Transactions in InnoDB: Ensuring data consistency.
- Automatic Commits: Understanding and managing automatic transaction commits.
- Transactions in DBD: Managing transactions in DBD.
- Table Locking: Managing concurrent access to data.
- Transaction Levels: Controlling transaction isolation.
============ Query Optimization ============
- Indexing: Improving query performance.
- Full-Text Boolean Searches: Advanced text searching techniques.
- Index Removal: Identifying and removing unused indexes.
- EXPLAIN & ANALYZE: Analyzing query execution plans.
- Optimizing INSERT, UPDATE & DELETE: Performance tuning for data modification.
============ Extending SQL Engine Functionality ============
- User-Defined Functions (UDFs): Creating custom functions.
- Analyzing Aggregate Functions: Understanding and optimizing aggregate functions.
- Troubleshooting UDF Issues: Debugging and resolving UDF problems.
============ Database Design ============
- Standard Database Models: Understanding common database design patterns.
- Views & Virtual Tables: Creating logical representations of data.
- Normalization & Denormalization: Optimizing database structure.
- Database Lifecycle: Managing the entire database lifecycle.
- Case Study: Publication Tracking System – a practical design example.
- Concurrency Control: Managing simultaneous database access.
============ MySQL Database Administration ============
- Admin Access & Server Startup
- Server Configuration: Customizing MySQL settings.
- Logging & Monitoring: Tracking database activity.
- Table Analysis & Checking
- Table Repair & Optimization
- Backup & Recovery Strategies: Protecting your data
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.