Language Selector

catalàespañolenglish
Català Castellano English

Menu Display

Breadcrumb

Activity Record

Specialized
 

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

  1. Introduction to databases
    • Types of databases
    • MySQL databases
  2. Database installation
    • Using Xampp
    • Database managers
  3. Comparison of hosting services to store databases
  4. Initialization of a database with PhpMyAdmin
    • Design and creation of a database
    • Table creation
    • Types of fields
    • Basic and most used functionalities.
  5. 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
  6. Import and export of the database
    • Data export in SQL format
    • Import of an Excel file to our databases
  7. Database administration
    • Copy, move, delete, empty, and optimize the database
    • Database configuration
  8. SQL search queries
  9. SQL subqueries
  10. Connecting a database to a website
    • Practice with basic PHP programming of a CRM

Recommended previous training:


Online Course - Introduction to relational databases

Editions

Edition 1

Wed 10/07/24 (15:30-19:30h)

Tue 16/07/24 (15:30-19:30h)

Thu 18/07/24 (15:30-19:30h)

Cibernàrium-22@

Carrer Roc Boronat, 117 - 127,

BARCELONA

Language: Catalan
Places available Sign me up
Edition 2

Wed 18/09/24 (15:30-19:30h)

Thu 19/09/24 (15:30-19:30h)

Fri 20/09/24 (15:30-19:30h)

Cibernàrium-22@

Carrer Roc Boronat, 117 - 127,

BARCELONA

Language: Catalan
Opening of registration 03/09/2024 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.

Wed 10/07/24 (15:30-19:30h)
Modality: Attended session
Tue 16/07/24 (15:30-19:30h)
Modality: Attended session
Thu 18/07/24 (15:30-19:30h)
Modality: Attended session
Duration: 3 sessions
Cibernàrium-22@ - Carrer Roc Boronat, 117 - 127,
BARCELONA
Duration: 3 sessions
Price: This activity is free
Level: Specialized
Theme: Programming

Course ratings

Average
9.47

Lesson taught by

ISMAEL

KALE MOYANO

Average
9.56

Related courses

  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

Wed 10/07/24 15:30-19:30h

Cibernàrium-22@

Carrer Roc Boronat, 117 - 127,

BARCELONA

Attended session

Tue 16/07/24 15:30-19:30h

Cibernàrium-22@

Carrer Roc Boronat, 117 - 127,

BARCELONA

Attended session

Thu 18/07/24 15:30-19:30h

Cibernàrium-22@

Carrer Roc Boronat, 117 - 127,

BARCELONA

Manage databases with MySQL: Edition 2

Attended session

Wed 18/09/24 15:30-19:30h

Cibernàrium-22@

Carrer Roc Boronat, 117 - 127,

BARCELONA

Attended session

Thu 19/09/24 15:30-19:30h

Cibernàrium-22@

Carrer Roc Boronat, 117 - 127,

BARCELONA

Attended session

Fri 20/09/24 15:30-19:30h

Cibernàrium-22@

Carrer Roc Boronat, 117 - 127,

BARCELONA

Personal information

Full Name:

Screen Name: 20101

Email: default@liferay.com

I agree registration conditions