A tanfolyamról
MariaDB is one of the most popular database servers and it has been developed by the original developers of MySQL. MariaDB is open source and as a relational database it provides SQL interface for data access. This comprehensive MariaDB training is designed particularly for developers. Being open source, the security releases are transparent and quick.
The course gives a complete understanding of a MariaDB (or MySQL) database with practical experience of using SQL commands.
Who Should Attend This Course
- Application Developers
- IT Developers
- Professionals interested in learning MariaDB
What You Will Learn
-
MariaDB Basics
Understand the basics of MariaDB and learn how to install MariaDB in your environment -
Database Structures
Learn about the different database structures that you can utilize in MariaDB framework -
MariaDB Functions
Explore how you can create and utilize a range of functions using MariaDB to meet your needs -
Data Handling
Learn how to perform data handling in MariaDB and the numerous benefits of using MariaDB -
Data Migration
Understand how to perform data migration in an easy and compatible manner using MariaDB -
High Performance
Learn how MariaDB can provide an improved performance and is radically faster than MySQL
On completion of the MariaDB for developers training, you will be able to develop an understanding of the following topics:
- Basics of MariaDB and Installation of MariaDB
- Database structures in MariaDB
- Functions in MariaDB
- Data handling in MariaDB
We provide the course in English.
Tematika
Curriculum
1. The Software Installation
Topics
- Installing MySQL and MariaDB
- The basics and the MySQL client
2. The Database Structures used in MariaDB
Topics
- Creating databases and tables
- Altering tables
3. Basics on handling data
Topics
- Inserting data
- Selecting data
- Updating and deleting data
- Joining and subquerying data
4. Built-in functions
Topics
- String functions
- Date and time functions
- Aggregate and numeric functions
Kinek ajánljuk
Előfeltételek
Prerequisites
There are no prerequisites for this course.