Manage databases with MySQL
Manage databases with MySQL
The objective of the activity will be to learn how to create a database and be able to manage it using SQL queries. We will start with simple examples and models that will allow us to create our database. As practice we will learn to connect the database with a website. Highly recommended for those who need to manage information in an orderly manner.
Specific goals | Temary
OBJECTIVES
- Learn to create a database
- Understand SQL language
- Connect a database to a website
SYLLABUS
- Introduction to databases
- Types of databases
- MySQL databases
- Database installation
- Using Xampp
- Database managers
- Comparison of hosting services to store databases
- Initialization of a database with PhpMyAdmin
- Design and creation of a database
- Table creation
- Types of fields
- Basic and most used functionalities.
- SQL Language
- Basic modeling
- Table and field creation. Basic SQL instructions
- ORDER BY and GROUP BY instructions
- JOIN instructions
- COUNT, SUM, MAX, MIN, AVG instructions
- HAVING instructions
- Import and export of the database
- Data export in SQL format
- Import of an Excel file to our databases
- Database administration
- Copy, move, delete, empty, and optimize the database
- Database configuration
- SQL search queries
- SQL subqueries
- Connecting a database to a website
- Practice with basic PHP programming of a CRM
Recommended previous training:
Editions
Tue 11/06/24 (16:00-20:00h)
Thu 13/06/24 (16:00-20:00h)
Tue 18/06/24 (16:00-20:00h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
Fri 12/07/24 (10:00-14:00h)
Fri 19/07/24 (10:00-14:00h)
Fri 26/07/24 (10:00-14:00h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
General information
>> In case the format is virtual via streaming, it will be conducted through the free Microsoft Teams platform. Registered individuals will receive the invitation link and access instructions via email before the session begins.
>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.
>> The language in which each session is conducted is specified in the description of each activity.
>> Any of Cibernàrium's training activities may be recorded through an image capture system for subsequent dissemination through a medium or support within the scope of Barcelona Activa's mission to contribute to economic promotion and employment. In the recording process, images of attendees may be captured. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.
Course ratings
Lesson taught by
KALE MOYANO