Szkolenia MariaDB

Szkolenia MariaDB

MariaDB database courses

Testi...Client Testimonials

MariaDB Database Administration

Training material was very informative. Learned a lot

Yaw Asamoah - FEDERAL AVIATION ADMINISTRATION

MariaDB Database Administration

lessons and examples

Kelly Taylor - FEDERAL AVIATION ADMINISTRATION

MariaDB Database Administration

he adapted to the experience of the group - gave us great value for a beginners course.

Rich Mickey - FEDERAL AVIATION ADMINISTRATION

MariaDB Database Administration

Enjoyed the pace, delivery and technical knowhow of the trainer

Junaid Kalang - Capita CSL

Plany Szkoleń MariaDB

Kod Nazwa Czas trwania Charakterystyka kursu
mariadbdev MariaDB 10 Developer Course 28 godz. Created DBAs, Administrators and developers who are interested with getting involved in MariaDB 10 based on Linux system. Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Database Concept and SQL and to show it is very easy to understand how to use SQL and manage MariaDB on Linux system. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities After this course, you can apply the knowledge, which you obtained through this course, to the other database systems such as MySQL, Oracle Database, MSSQL Server and PostgreSQL as well. It can be deliver on any distribution (Ubuntu, CentOS are commonly used) This course covers these kinds of topics: Chapter 00 MariaDB 10 Developer Course Introduction Chapter 01 MariaDB 10 Introduction Chapter 02 Startup MariaDB 10 Chapter 03 MariaDB Tools - Command & GUI Chapter 04 Retrieving Data using SQL Chapter 05 Filtering Data using SQL Chapter 06 Summarizing, Grouping & Combining Chapter 07 Database, Table & Indexes Chapter 08 Inserting, Updating & Deleting Data Chapter 09 Table Joins Chapter 10 Subqueries Chapter 11 Views Chapter 12 Stored Procedures Chapter 13 Triggers Chapter 14 MariaDB Datatypes Chapter 15 Transaction Processing Chapter 16 MariaDB User Management Chapter 17 MariaDB Client Tools
mariadbgc MariaDB Galera Cluster Administration 21 godz. This course is intended for database administrators. The course presents options for High-Availability solutions using Galera Cluster. You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster. Topic overview Why I need them and what are High-Availability solutions? Cluster concepts ​What is MariaDB Galera Cluster and what it offers to my organization? Galera Cluster Management How to start with Galera - what should I now before installation? Architecture and functionality First steps - Installation Going deeper - Configuration and Set-up Almost like a pro - Administration Performance Operations and operation modes Upgrade Galera Backups and restoring ​Controlling state transfer between nodes Load balancing Monitoring How to deal with Galera multi- master configuration Advanced features Security Scalability Replication ​Advanced configuration
mariadbadmin MariaDB Database Administration 14 godz. MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties. The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery. Installing MariaDB server Installing in Ubuntu/Debian Installing in other Linux Distributions Installation on Windows MariaDB Server Files and Scripts MariaDB Programs MariaDB Server MariaDB Client GUI Tools MariaDB Server Configuration Server Options The Server SQL Mode Server System Variables Dynamic System Variables Server Status Variables Shutdown Process MariaDB Security Issues Securing MariaDB Against Attacks Security-Related Options Security Issues with LOAD DATA LOCAL MariaDB Access Privilege System MariaDB Privilege System Overview Privileges Provided by MariaDB Connecting to the MariaDB Server - Stages Access Control, Stage 1: Connection Verification Access Control, Stage 2: Request Verification Access Denied Errors MariaDB User Account Management Users and Passwords Creating New Users Deleting User Accounts Limiting User Resources Changing Passwords MariaDB Database Maintenance Backup and Recovery Point-in-Time Recovery Maintenance and Crash Recovery myisamchk Syntax and Options Getting Table Information MariaDB Local Setting National Characters and Sorting MariaDB Server Time Zone MariaDB Log Files Error Log General Query Log Update Log Binary Log Slow Query Log Log File Maintenance and Rotation Running Multiple MariaDB Servers on the Same Machine Running Multiple Servers in Windows Running Multiple Servers in Windows as Services Running Multiple Servers in Unix and Linux Using Client Tools in a Multi-Server Environment MariaDB Query Cache The Concept of Query Cache Testing Query Cache with SELECT Configuring Query Cache Checking Query Cache Status and Maintenance The CONNECT Storage Engine Installing the CONNECT storage engine Creating and dropping CONNECT tables Reading and writing CSV data using CONNECT Reading and writing XML data using CONNECT Accessing MariaDB tables using CONNECT Using the XCOL table type Using the PIVOT table type Using the OCCUR table type Exploring Dynamic and Virtual Columns in MariaDB Creating tables with dynamic columns Inserting, updating, and deleting dynamic column data Reading data from a dynamic column Using virtual columns Performance and Usage Statistics Installing the Audit Plugin Using the Audit Plugin Using engine-independent table statistics Using extended statistics Enabling the performance schema Using the performance schema Optimizing and Tuning MariaDB Using SHOW STATUS Controlling MariaDB optimizer strategies Using extended Keys with InnoDB and XtraDB Configuring the MyISAM segmented key cache Configuring threadpool Configuring the Aria pagecache Optimizing queries with the subquery cache Optimizing semijoin subqueries Using microseconds in DATETIME columns Updating the DATETIME and TIMESTAMP columns automatically  
dnswebmaildb Top 4 Linux/Unix Servers - DNS,Web,Mail and Database 35 godz. Created Linux/Unix Administrators and developers who are interested with getting involved in LInux/Unix Servers Even beginners, who have the basic skill and knowledge on Linux, can catch up with this course just if you follow the instructor's lab and explanation in detail. This course is intended to practice enough Managing Linux Servers and to show it is very easy to understand Linux/Unix servers. This course will be delivered to audience with 40% lectures, 50% labs and 10% Q&A. This five-day course strongly emphasizes lab-based activities. You'll learn how to deploy and manage Top 4 Linux Servers that provide highly useful network services to a mission-critical enterprise environment. It can be deliver on any distribution (Fedora, CentOS are commonly used) This course covers these kinds of topics: Bind as a ;DNS server Apache as a Web Server Postfix as a Mail Server MariaDB as a Database Server Through this course, you will learn from the installation to High level features of each server.
mariadbadv Advanced MariaDB for High Availability and Performance 28 godz. MariaDB is a fork of MySQL and one of the most popular database servers. In this instructor-led, live training, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering. Audience Developers Database administrators System administrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Introduction Installing and configuring MariaDB Overview of MariaDB architecture Backing up and restoring MariaDB Point-in-Time-Recovery (PiTR) Securing MariaDB Configuring MariaDB for high availability Master-slave replication Master-master replication Setting up virtual IPs Read/write distribution Active-active clustering with Galera Cluster Load balancing Performance tuning in MariaDB Hardware and performance Schema tuning Indexing SQL query Tuning Profiling Closing remarks

Najbliższe szkolenia

Other regions

Szkolenie MariaDB, MariaDB boot camp, Szkolenia Zdalne MariaDB, szkolenie wieczorowe MariaDB, szkolenie weekendowe MariaDB , instruktor MariaDB, nauczanie wirtualne MariaDB, nauka przez internet MariaDB, e-learning MariaDB, kurs online MariaDB, lekcje UML, Trener MariaDB, wykładowca MariaDB , kurs zdalny MariaDB,Kursy MariaDB,Kurs MariaDB

Kursy w promocyjnej cenie

Szkolenie Miejscowość Data Kursu Cena szkolenia [Zdalne / Stacjonarne]
Data Analytics With R Warszawa, ul. Złota 3/11 wt., 2017-11-28 09:00 14850PLN / 5550PLN
Programowanie w ASP.NET MVC 5 Wrocław, ul.Ludwika Rydygiera 2a/22 wt., 2017-11-28 09:00 5841PLN / 2223PLN
Visual Basic for Applications (VBA) w Excel - wstęp do programowania Kraków, ul. Rzemieślnicza 1 pon., 2017-12-04 09:00 3564PLN / 2491PLN
Wprowadzenie do C# 6.0 w Visual Studio 2015/2017 Gdańsk, ul. Powstańców Warszawskich 45 pon., 2017-12-04 09:00 9890PLN / 3473PLN
Docker - zarządzanie kontenerami Warszawa, ul. Złota 3/11 wt., 2017-12-05 09:00 8910PLN / 3570PLN
Test Automation with Selenium and Jenkins Wrocław, ul.Ludwika Rydygiera 2a/22 śr., 2017-12-06 09:00 7722PLN / 3174PLN
Adobe Premiere Pro Gdańsk, ul. Powstańców Warszawskich 45 czw., 2017-12-07 09:00 3960PLN / 2480PLN
Scrum - Step by Step Kraków, ul. Rzemieślnicza 1 czw., 2017-12-07 09:00 4950PLN / 2450PLN
Certyfikacja OCUP2 UML 2.5 - Przygotowanie do egzaminu OCUP2 Foundation Warszawa, ul. Złota 3/11 śr., 2017-12-13 09:00 6930PLN / 2910PLN
Nagios Core Gdańsk, ul. Powstańców Warszawskich 45 śr., 2017-12-13 09:00 13919PLN / 4968PLN
Język SQL w bazie danych Oracle Kraków, ul. Rzemieślnicza 1 czw., 2017-12-14 09:00 2772PLN / 1493PLN
Continuous integration with Jenkin Wrocław, ul.Ludwika Rydygiera 2a/22 czw., 2017-12-14 09:00 14117PLN / 4678PLN
Adobe Illustrator Lublin, ul. Spadochroniarzy 9 czw., 2017-12-14 09:00 2871PLN / 1648PLN
Statystyka dla Naukowców Toruń, ul. Żeglarska 10/14 pon., 2017-12-18 09:00 9207PLN / 4675PLN
Oracle SQL dla początkujących Gdańsk, ul. Powstańców Warszawskich 45 pon., 2017-12-18 09:00 4752PLN / 2283PLN
Język SQL w bazie danych MySQL Poznań, Garbary 100/63 pon., 2017-12-18 09:00 2851PLN / 1113PLN
Zarządzanie konfliktem Szczecin, ul. Sienna 9 pon., 2017-12-18 09:00 5148PLN / 1530PLN
Tableau Advanced Gdynia, ul. Ejsmonda 2 pon., 2017-12-18 09:00 7425PLN / 2975PLN
Komunikacja interpersonalna Szczecin, ul. Sienna 9 pon., 2017-12-18 09:00 5148PLN / 1530PLN
SQL Advanced level for Analysts Gdynia, ul. Ejsmonda 2 wt., 2017-12-19 09:00 3861PLN / 1920PLN
Introduction to Selenium Poznań, Garbary 100/63 śr., 2017-12-20 09:00 1871PLN / 824PLN
Adobe Photoshop Warszawa, ul. Złota 3/11 śr., 2017-12-20 09:00 1881PLN / 1152PLN
Predictive Modelling with R Warszawa, ul. Złota 3/11 śr., 2017-12-27 09:00 8524PLN / 2983PLN
Oracle SQL dla początkujących Rzeszów, Plac Wolności 13 śr., 2017-12-27 09:00 4752PLN / 2133PLN
Wprowadzenie do C# 6.0 w Visual Studio 2015/2017 Wrocław, ul.Ludwika Rydygiera 2a/22 wt., 2018-01-02 09:00 9890PLN / 3273PLN
Leadership 101 Wrocław, ul.Ludwika Rydygiera 2a/22 wt., 2018-01-09 09:00 3890PLN / 1379PLN
Agile Software Testing Szczecin, ul. Sienna 9 czw., 2018-01-11 09:00 4257PLN / 2629PLN
Agile TDD Katowice ul. Opolska 22 czw., 2018-01-11 09:00 2970PLN / 1835PLN
Analiza biznesowa i systemowa z użyciem notacji UML - warsztat praktyczny dla PO w metodyce Scrum Katowice ul. Opolska 22 śr., 2018-01-17 09:00 7722PLN / 3624PLN
Adobe Creative Cloud - Montaż video Katowice ul. Opolska 22 pon., 2018-01-29 09:00 3861PLN / 2455PLN
Techniki DTP (InDesign, Photoshop, Illustrator, Acrobat) Opole, Władysława Reymonta 29 pon., 2018-02-05 09:00 5940PLN / 4230PLN
Javascript Basics Poznań, Garbary 100/63 wt., 2018-02-13 09:00 4455PLN / 1885PLN
Certified Agile Tester Katowice ul. Opolska 22 pon., 2018-04-02 09:00 8910PLN / 4720PLN
Perfect tester Szczecin, ul. Sienna 9 śr., 2018-04-04 09:00 5920PLN / 2294PLN
Kontrola jakości i ciągła integracja Katowice ul. Opolska 22 czw., 2018-04-12 09:00 2673PLN / 2037PLN

Newsletter z promocjami

Zapisz się na nasz newsletter i otrzymuj informacje o aktualnych zniżkach na kursy otwarte.
Szanujemy Twoją prywatność, dlatego Twój e-mail będzie wykorzystywany jedynie w celu wysyłki naszego newslettera, nie będzie udostępniony ani sprzedany osobom trzecim.
W dowolnej chwili możesz zmienić swoje preferencje co do otrzymywanego newslettera bądź całkowicie się z niego wypisać.

Zaufali nam