Manage databases with MySQL
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
- Introduction to Databases
- Database Installation
- Hosting Comparison for Database Storage
- Database Initialization with PhpMyAdmin
- SQL Language
- Database Import and Export
- Database Administration
- SQL Search Queries
- SQL Subqueries
- Connecting a Database to a Website
RECOMMENDED SQL and MYSQL TRAINING ITINERARY
Level 0
Introduction to Relational Databases - Online Course
Level 1
Manage Databases with MySQL
Level 2
Advanced SQL Database Optimization
Editions
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
Mon 14/10/24 (15:30-19:30h)
Tue 15/10/24 (15:30-19:30h)
Wed 16/10/24 (15:30-19:30h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
Tue 12/11/24 (15:30-19:30h)
Wed 13/11/24 (15:30-19:30h)
Thu 14/11/24 (15:30-19:30h)
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
Related courses
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.