Menu Display

Breadcrumb

Activity Record

Specialized
 

Manage databases with MySQL

This training will teach you how to create and manage a database, master the SQL language, and connect it to a website. You'll learn from the initial installation and setup with PhpMyAdmin to advanced administration, performing SQL queries and subqueries, as well as importing and exporting data. A comparison of hosting options will also be covered to optimize database storage.

Specific goals | Temary

OBJECTIVES

  • Learn to create a database
  • Understand SQL language
  • Connect a database to a website

COURSE CONTENT

  1. Introduction to Databases
  2. Database Installation
  3. Hosting Comparison for Database Storage
  4. Database Initialization with PhpMyAdmin
  5. SQL Language
  6. Database Import and Export
  7. Database Administration
  8. SQL Search Queries
  9. SQL Subqueries
  10. Connecting a Database to a Website

RECOMMENDED SQL and MYSQL TRAINING ITINERARY

Editions

Edition 1
Modality: Attended session
Language: Catalan
Dates: From 14/07/2025 to 18/07/2025
3 onsite sessions at:
Cibernàrium-22@ - Carrer Roc Boronat, 117 - 127, BARCELONA
  • Monday 14 July · 15:30h - 19:30h
  • Wednesday 16 July · 15:30h - 19:30h
  • Friday 18 July · 15:30h - 19:30h
  • Places available Sign me up
    Edition 2
    Modality: Attended session
    Language: Catalan
    Dates: From 08/09/2025 to 10/09/2025
    3 onsite sessions at:
    Cibernàrium-22@ - Carrer Roc Boronat, 117 - 127, BARCELONA
  • Monday 8 September · 15:30h - 19:30h
  • Tuesday 9 September · 15:30h - 19:30h
  • Wednesday 10 September · 15:30h - 19:30h
  • Opening of registration 24/08/2025 to 08:30 h.
    Edition 3
    Modality: Virtual classroom
    Language: Spanish
    Dates: From 22/09/2025 to 26/09/2025
    4 virtual classroom sessions
  • Monday 22 September · 10:00h - 13:00h
  • Tuesday 23 September · 10:00h - 13:00h
  • Thursday 25 September · 10:00h - 13:00h
  • Friday 26 September · 10:00h - 13:00h
  • Opening of registration 07/09/2025 to 08:30 h.

    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.

    Modality: Attended session
    Duration: 3 sessions (12 hours)
    Language: Catalan
    Dates: From 14/07/2025 to 18/07/2025
    Location: Cibernàrium-22@ - Carrer Roc Boronat, 117 - 127, BARCELONA

    Theme: Data / Live specialized training

    Course ratings

    Average
    9.7

    Trainer's person

    DAVID

    ERILL CARRERA

      Personal Data Protection Law

    Personal Data Protection Law

    There is a new version of Personal Information Protection law.
    Please, accept it before continuing the registration.

      You are registering

    Manage databases with MySQL: Edition 1

    Attended session

    Mon 14/07/25 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Attended session

    Wed 16/07/25 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Attended session

    Fri 18/07/25 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Manage databases with MySQL: Edition 2

    Attended session

    Mon 08/09/25 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Attended session

    Tue 09/09/25 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Attended session

    Wed 10/09/25 15:30-19:30h

    Cibernàrium-22@

    Carrer Roc Boronat, 117 - 127,

    BARCELONA

    Manage databases with MySQL: Edition 3

    Mon 22/09/25 10:00-13:00h

    Virtual classroom

    Tue 23/09/25 10:00-13:00h

    Virtual classroom

    Thu 25/09/25 10:00-13:00h

    Virtual classroom

    Fri 26/09/25 10:00-13:00h

    Virtual classroom

    Personal information

    Full Name:

    Screen Name: 20101

    Email: default@liferay.com

    I agree registration conditions