TOP Database Courses

This training provides an understanding of the fundamentals of Apache™ Hadoop® and how to develop applications that process data based on it. Participants will get acquainted with HDFS - the de facto standard for long-term reliable storage of large volumes of data, framework MapReduce, which automatically manages the parallel execution of applications on the cluster, and related projects that make up Hadoop® ecosystem.

The course is designed for advanced Excel users. The course allows you to learn how to perform complex calculations, conduct statistical analysis, and automatically collect data from several tables (even different types) into one, build queries and calls to tables to extract the necessary data using criteria, queries and D-functions, create forms to automate filling out tables, set up complex conditional formatting rules in tables and write simple ones macros.

Learn everything about working with relational and non-relational databases. Together we will go through all the stages - from designing to scaling databases using PostgreSQL, MS SQL and MySQL. Learn to work with NoSQL databases, create a data storage architecture and automate routine processes.

Training. Working with data. Acquiring programming skills in Python, one of the most popular modern programming languages ​​that is widely used in data analysis. Python with its libraries is a universal tool and allows you to solve many applied problems - from automated information collection and filling out documents to data analysis.

Introductory training on Apache Kafka, an open source distributed event streaming platform. The architectural features of Kafka that ensure high-performance data delivery are discussed.

The course provides students with knowledge of how to effectively configure SQL statements, as well as how to write them correctly. Various methods of writing SQL commands will be reviewed, and students will learn which methods are most effective in certain circumstances.

Advanced training program. This course discusses the Cyber ​​Backup backup system, which allows you to backup physical machines running Windows, Linux and MacOS, virtual machines VMware, Hyper-V, oVirt, as well as applications MySQL/MariaDB, PostgreSQL, Communigate Pro, Microsoft Exchange, SQL, SharePoint, Active Directory, databases Oracle data, as well as automatically replicate backups between storage locations and regularly check data integrity for complete confidence safety.

In this course you will learn the fundamentals of relational databases. You will learn more about DBMS architecture and the SQL language. As a result, you will learn how to create tables, add, modify and delete data.

Together and from scratch we will go through all stages of design, administration, reservation and scaling Database using PostgreSQL, MS SQL and MySQL to gain paid DBA (administrator) skills DB).

Practical course on working with PostgreSQL DBMS. We will learn how to build replications, work with backups and organize monitoring of the entire system. The course program is based on real-life tasks of operations teams.

The basics of working with Redis are covered (selecting data types, using commands, Lua scripting, transactions, pipelining, publish/subscribe), setting up data storage, optimizing configuration, usage scenarios, Redis in distributed environment.

We study the intricacies of setting up Prometheus, how to install and configure it, what queries to write, how to collect metrics, and more. Course bonus: overview of the Thanos project.

Training. Corporate governance. Information systems management. Right. Compliance. Working with data. Information Security. The program allows you to gain systemic knowledge and practical skills in the field of personal data legislation, taking into account the latest changes. On September 1, 2022, significant amendments to the Federal Law “On Personal Data” came into force. The second package of changes will take effect on March 1, 2023.

Database programming: with PostgreSQL DBMS and SQL language: theory and practice with data analysis. All the knowledge that you will gain in the course is easily applicable to other DBMSs, such as MySQL, Microsoft SQL Server, Oracle.