Course catalog
L2-DB
Intermediate level

Database Administration on Linux

6 000 UAH

4 weeks 8 lesson

18:00 - 19:30

Tue, Thu

Start of the course

14.05.2021 yr
Enroll in a course

About course

The average person has no idea how much IT has to do with databases. But the system administrator understands how many processes generally depend on databases, and knows how to manage them.

We will teach you how to administer popular databases.

What do you need to take the course?

  • You need to understand the following topics: text editors, user and group management, file and directory permissions management, Linux process management.

  • Iptables, troubleshooting for network connections, package managers, getting information about the versions of installed programs and available packages for installation in the repositories, a general understanding of the work of web servers.

Course program

Introduction

Lecture

General information, introduction.

Lecture

Basics of the SQL language. Requests.

Lecture

MySQL console commands. PHPMyAdmin.

Practice

Linux OS installation, MySQL installation, MySQL queries. Creation of databases and tables.

Databases, tables, queries

Lecture

Configuration files of MySQL, changing the MySQL configuration.

Lecture

Types of tables. System variables of MySQL. Types of cells with data, MySQL JOIN.

Practice

Filling of tables. Creation of users, assignment of privileges. MySQL JOIN.

Backup and recovery

Lecture

Methods for backing up databases and restoring them.

Lecture

Features of backing up MyISAM tables.

Lecture

Features of InnoDB table backup.

Practice

Practice for restoring databases with the MyISAM and InnoDB table types.

Getting information about MySQL. Performance statistics of MySQL

Lecture

Getting information about MySQL performance.

Lecture

Heavy and slow queries.

Lecture

Data about current requests, statistics of requests, information about performance.

Lecture

Setting up logging, error log, slow log.

Practice

Connecting log files. Logging of heavy requests. Log analyzers.

MySQL replication

Lecture

The concept of replication: terminology, application features.

Lecture

Types of replication.

Lecture

Master-Slave replication.

Lecture

Master-Master replication.

Practice

Building replication of the Master-Slave, Master-Master type.

MySQL forks

Lecture

Percona Server.

Lecture

XtraDB, Percona XtraBackup.

Lecture

MariaDB.

Lecture

Replication and sharding.

Practice

Percona server installation and configuration MariaDB.

Tuning of the DBMS

Lecture

MyISAM tuning.

Lecture

InnoDB tuning.

Lecture

Percona XtraDB tuning.

Practice

Mysqltuner. Bench tests. Load tests. Comparison of MySQL and Percona.

PostgreSQL

Lecture

PostgreSQL. General information.

Lecture

PostgreSQL directory and file structure.

Lecture

PostgreSQL commands.

Lecture

Comparison of MySQL and PostgreSQL capabilities.

Practice

Mysqltuner. Bench tests. Load tests. Comparison of MySQL and Percona. Installing PostgreSQL, creating databases, creating users. Installing PgAdmin.

PostgreSQL replication

Lecture

Types of replication.

Lecture

Master-Slave replication.

Lecture

Master-Master replication.

Practice

Building replication of the Master-Slave, Master-Master type.

MySQL Security

Setting up user privileges.

Lecture

MySQL + SSL/TLS.

Lecture

Storing MySQL databases on an encrypted partition.

Lecture

Restricting connection to MySQL (iptables, unix socket files).

Practice

Databases encryption, SSL connection to the server, connections limitation to MySQL on the iptables side.

MongoDB

Lecture

Structure of NoSQL Databases.

Lecture

MongoDB Data Types and Modeling.

Lecture

Collections and protections of MongoDB.

Indexation, aggregation, replication of MongoDB.

Practice

Installation of MongoDB, creation and deleting databases, creation and deleting collections, setting up access to databases. Control Panels for MongoDB.

CassandraDB

Lecture

Architecture and Terminology: cluster, keyspace, column family, super columns.

Lecture

Operations: mutation, get, multi_get, counters.

Lecture

Caching, key cache level, indexes, range scan, aggregation, scaling.

Practice

Installation of Apache Cassandra. Config files and directives, cqlsh command line, creation of keyspace, tables creation, querying and retrieving data. Control panels for Apache Cassandra.

Project Work

Project

Setting up a web server by technical task

Have you already seen our courses?

You will definitely find what you need 😊

Course catalog Course catalog

At the end of the course the student will know

  • basics of the SQL language, configuration files of database servers and types of tables
  • system variables MySQL and its forks
  • possible backup tools for PostgreSQL databases and its database management tools
  • principle of the structure of NoSQL databases
  • MongoDB's collection and protection, Cassandra architecture, operations and methods of scaling

At the end of the course the student will be able to

  • install MySQL database servers and its forks;
  • create users, databases and tables; manage access rights to databases
  • set up backups and be able to restore databases/tables from backups
  • set up MySQL event logs and its forks, get reports about the structure of tables and queries to databases
  • set up MySQL and its forks' replication, analyze and optimize MySQL parameters
  • set and configure MongoDB, create databases, manage collections and access to databases,
  • install and configure Apache Cassandra
  • work in the cqlsh command line, create tables, submit queries and get data,
  • configure limited access to Cassandra databases, create users and assign them rights.
Enroll in a course

Still have questions?

Ask them to our specialists
Ask a question

Sign up for the newsletter

We send a digest of interesting news every week, and notify about events, promotions and discounts