MariaDb, the OpenSource database derived from MySQL
MariaDb, the OpenSource database derived from MySQL
We will learn about the different applications and advantages of this OpenSource database. A fairly unknown database engine that is fully compatible with today's programming languages. But its main point and which goes in line with the spirit of the Cibernarium, is the fact that it is OpenSource (open source) and easy to use.
Specific goals | Temary
Learn the types of data.
Work with a database using objects.
Know how to interconnect a PHP script with MariaDB.
Learn to implement CRUD actions (Create, Update, Delete) with MariaDB.
CONTENT
1.- Introduction to databases:
- Database
- Relational databases
- Standardization of databases
2.- Starting MariaDB:
- Install MariaDB on debian GNU/Linux 7
- Access the MariaDB console
- Utility commands
- Create database and add users
3.- SQL statements by categories:
- DDL instructions
- DML instructions
- TCL instructions
- SCL instructions
- Embedded SQL instructions
4.- Data type:
- Basic instructions
- Create tables and data types
Recommended and complementary activities to increase knowledge of the subject:
Editions
Mon 28/10/24 (15:30-18:30h)
Tue 29/10/24 (15:30-18:30h)
Thu 31/10/24 (15:30-18:30h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
General information
IMPORTANT: If the format is virtual streaming, it will be done through the free Microsoft Teams platform. Registrants will receive an 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 given is reported in the description of each activity.
>> Any of the training actions of Cibernàrium may be recorded through an image capture system whose purpose is its subsequent dissemination through a medium or support in the field of Barcelona Activa's mission to contribute to economic promotion and employment.
In the recording process, images of those attending the training may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to
use these images for the above purpose.
Course ratings
Lesson taught by
TINOCO MARCO
Related courses
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.