Introduction to MariaDB - 3 days Online Classroom
2.650,00 EUR
- 3 days
Build a strong foundation in relational database management with MariaDB, one of the world's most popular open-source database platforms. This hands-on course introduces the core concepts of databases and SQL, enabling you to confidently create, query, manage, and maintain data in a MariaDB environment.
Key Features
Language
Course material in English
Level
Beginner level
3 days (8 hours/day) online instructor-led
40+ recommended study hours
Hands-on practical exercises
Use client tools to access MariaDB
Access to Live Labs
Post-course support documents
Ask for date confirmation!
Program completion certification included
Learning Outcomes
At the end of this program, you will be able to:
Database Fundamentals
Understand how relational databases organize data using tables, keys, and relationships, and learn the principles that ensure data integrity in client-server environments.
Practical SQL Skills
Develop the ability to write, filter, sort, and join data with SQL queries, while using functions and subqueries for more advanced data analysis.
Data Management and Administration
Learn to insert, update, and delete data safely, manage transactions, create database objects, control user access, and perform data import and export operations.
Course timeline
Day 1
Session 1: Database Concepts
- Database fundamentals and DBMS architecture
- Tables, keys, indexes, and constraints
- Data types, storage engines, and MariaDB system databases
Session 2: Using the MariaDB Client
- MariaDB client basics and database access
- Executing SQL commands and scripts
- Managing command history and output
Session 3: Basic SELECT Queries
- SQL SELECT statements
- Filtering, sorting, and logical conditions
- Aliases, expressions, and query syntax
Session 4: LIMIT, UNION, and Aggregate Functions
- Limiting and combining query results
- Aggregate functions and data summarization
- GROUP BY, ROLLUP, and HAVING clauses
Day 2
Session 5: Subqueries and Joins
- Subqueries and table relationships
- Join types, aliases, and multi-table queries
- Cartesian products and advanced joins
Session 6: Numeric and Character Functions
- Numeric and string functions
- Function testing and data manipulation
Session 7: Date, Time, and Other Functions
- Date and time data types and formats
- Date/time calculations and extraction functions
- Common utility functions for data processing
Day 3
Session 8: Databases and Tables
- Creating and managing databases and tables
- Table structures, constraints, and metadata
- Temporary, memory, and storage-engine tables
Session 9: Indexes and Views
- Index design and management
- Composite indexes and performance optimization
- Creating and maintaining views
Session 10: Managing Data
- Inserting, updating, replacing, and deleting data
- Transaction control with COMMIT, ROLLBACK, and savepoints
- Data maintenance and integrity
Session 11: Access Control
- User account management
- Granting and revoking privileges
- Database security administration
Session 12: Import and Export
- Data import and export using SQL
- Command-line backup and restore tools
- Data migration and transfer techniques
Who Should Enroll in this Program?
Aspiring Database Administrators (DBAs)
Software Developers and Application Developers
Data Analysts and Reporting Professionals
IT Support and Infrastructure Professionals
Business Intelligence Professionals
MySQL users looking to transition to MariaDB
Prerequisites
- Basic computer literacy
- Familiarity with operating systems and file management
- A general understanding of business data concepts
- Prior SQL or database experience is helpful but not required
Statements
Licensing and accreditation
The course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Question
Need corporate solutions or LMS integration?
Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!