Aprende MySQL sin dolor (con phpMyAdmin)

This course will guide you step by step from the basics to advanced techniques of MySQL, the database used on millions of websites around the world. You will learn to design, create and manage databases efficiently, using the popular phpMyAdmin manager.

What will you learn in this course?

• MySQL Basics: You will understand Basic database terms, column types, general concepts about database design and column types.
• Creation and database management: You will learn to create databases, tables, insert records, import data from files and from Excel, update and delete records.
• Advanced SQL queries: You will master SELECT statements with WHERE, ORDER BY, GROUP BY, HAVING, LIMIT, etc., to obtain the information you need precisely.
• Management of dates and functions: You will learn to work with dates and times in MySQL, using the basic functions to perform calculations and comparisons.
• Table concatenation: You will discover how to join tables using the different types of JOIN statements, to obtain information from several tables at the same time.
• Table modification and optimization: You will learn how to modify tables with ALTER TABLE, optimize their performance, change access keys, lock and unlock tables, and make backups.
• Indexes and users: You will learn to create, manipulate and delete indexes, as well as create, delete and manage database users.
• Relationships between tables: You will learn to create and manipulate foreign keys to establish relationships between tables and maintain data integrity.

Who is this course for?

• Web designers and developers: If you want to learn how to use MySQL to create dynamic websites and web applications, this course is for you.
• Computer science students and professionals: If you are studying or working in the field of computing and want to expand your knowledge about databases, this course will be very useful for you.
• Anyone interested in learning MySQL: If you have basic computer knowledge and want to learn how to manage this database, this course will guide you step by step.

Requirements:

• A personal computer running Windows or macOS.
• Internet connection.
• Willingness to learn and experiment with MySQL.

Download this course now and start your journey to becoming a MySQL expert!