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.
Attended session
Tuesday 30 April · 15:30h - 19:30h
Attended session
Thursday 2 May · 15:30h - 19:30h
Attended session
Monday 6 May · 15:30h - 19:30h
Cibernàrium-22@, Carrer Roc Boronat, 117 - 127, (Sant Martí) BARCELONA
Language: Catalan
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:
Edition 1
Attended session
Tuesday 11 June · 16:00h - 20:00h
Attended session
Thursday 13 June · 16:00h - 20:00h
Attended session
Tuesday 18 June · 16:00h - 20:00h
Cibernàrium-22@, Carrer Roc Boronat, 117 - 127, (Sant Martí) BARCELONA
Language: Catalan
>> 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.
Session types: Multisession
Duration: 12 hours