Databases - free course from Otus, training 6 months, Date: December 2, 2023.

Miscellaneous / by admin / December 05, 2023

The course is intended for developers and administrators who are ready to master working with databases
The goal of the course is to teach the student to effectively work with any database (both relational and non-relational) using the structured query language SQL. The course provides a deep dive into DBMS. After completing it, you will not have to put out fires as a result of suboptimally laid foundations.

On the course you:
- learn to design databases and create an optimal structure for their storage;
- you will distinguish between the main DBMSs that may be useful to a developer (PostgreSQL, MySQL, Redis, MongoDB, Cassandra, etc.);
- master the syntax and features of SQL, DDL, DML;
- you will be able to optimize slow queries and deal with incorrect SQL queries;
- you will become more confident in working with indexes, learn how to optimize, profile and update databases.

Who is this course for:
- for developers who encounter databases in their work;
- for those who have at least six months of experience working with DBMS and want to gain a deeper understanding of the structure of all internal processes.

instagram viewer

Highly practical orientation
Effective modular training
The teacher is an expert and professional with 20 years of experience in the industry
Author's program

Dmitry Kirillov

courses

Higher pedagogical education. Has been involved in commercial development for over 20 years. Co-founder and technical director of one of the largest online business registration services in Russia. Stack: Java, PHP. Professional interests: functional programming, data typing, development...

Evgeny Aristov

courses

I have been developing software in Java/Spring, C#, PHP for over 20 years. Database architect PostgreSQL, MongoDB, MSSQL, Oracle, MySQL, MariaDB, Couchbase, etc. Deploy database as on-premise Google Cloud Platform, AWS, Azure,...

I have been developing software in Java/Spring, C#, PHP for over 20 years. Database architect PostgreSQL, MongoDB, MSSQL, Oracle, MySQL, MariaDB, Couchbase, etc. DB deployment both on-premise Google Cloud Platform, AWS, Azure, Yandex Cloud, and Kubernetes, DBaaS, MultiCloud. During this time, more than a hundred projects were designed and developed for chain stores, fitness centers, hotels, and the financial sector. Vast experience in building and operating virtualization systems VmWare ESXi, Hyper-V. Author of books on PostgreSQL. New "PostgreSQL 14. Optimization, Kubernetes, cluster, cloud." Program Manager

Victor Korobkov

courses

More than 15 years of experience in the IT industry, more than 20 years of teaching experience. Currently: - programmer at the Center for Intelligent Geoinformation Technologies (CIGIT) of the Federal State Budgetary Educational Institution of Higher Education "ASU"; - senior lecturer at the Department of Automated information processing and control systems in the areas of “Programming and fundamentals of algorithmization”, “Databases”, “Artificial intelligence systems”;- co-founder of the small innovative enterprise ForeSays LLC - scientific research in the field of natural and technical sciences, software development provision. Skills: C/C++ programming, Delphi; design and development of databases: DBMS MSVisualFoxPro, MSAccess, MSSQLServer, PostgreSQL. Has 2 patents and 8 certificates of registration of computer programs Teacher

Entities and Relationships
-Topic 1. Database design
-Topic 2.Components of a modern DBMS
-Topic 3. Migration problems
-Topic 4.CAP Theorem
-Topic 5.Seminar: design

PostgreSQL
-Topic 6. Internal architecture of the PostgreSQL DBMS
-Topic 7.DDL: creating, modifying and deleting objects in PostgreSQL
-Topic 8.Transactions, MVCC, ACID
-Topic 9.DML: insert, update, delete, select data
-Topic 10. Data types in PostgreSQL
-Topic 11.Indices
-Topic 12.DML: aggregation and sorting, CTE, analytical functions
-Theme 13.Pentaho Report Designer
-Topic 14.OLAP: Postgres + pentaho
-Topic 15. Stored procedures and triggers
-Topic 16.Performance optimization. Profiling. Monitoring
-Topic 17.Backup and recovery
-Topic 18. Replication
-Topic 19.Clustering: patroni
-Topic 20.Seminar on PostgreSQL

MySQL
-Topic 21. Internal architecture of the MySQL DBMS
-Topic 22. Data types in MySQL
-Topic 23.DDL: creating, modifying and deleting objects in MySQL
-Topic 24.DML: inserting, updating, deleting, retrieving data
-Topic 25.Transactions, MVCC, ACID
-Topic 26.DML: Aggregation and Sorting
-Topic 27.Indices
-Topic 28.CTE and analytical functions
-Topic 29.Performance optimization. Profiling. Monitoring
-Topic 30. Stored procedures and triggers
-Topic 31.Backup and recovery
-Topic 32. Replication
-Topic 33.MySQL - Percona XtraDB Cluster
-Topic 34.MySQL - InnoDB Cluster
-Topic 35.MySQL NDB Cluster - sharding
-Topic 36.Seminar on Mysql

NoSQL (Redis, Tarantool, MongoDB, Cassandra)
-Topic 37.Working with tarantool
-Topic 38.NoSQL: Redis
-Topic 39.Basic features of mongodb
-Topic 40.map-reduce framework
-Topic 41. Architecture and application of cassandra
-Topic 42. Cassandra Query Language
-Topic 43.Elasticsearch
-Theme 44.Clickhouse

Final project
-Topic 45. Selection of topic and organization of project work
-Topic 46.Seminar on created projects
-Topic 47.Protection of design work
-Topic 48. Summing up the course

Tags cloud

Miscellaneous

Rating

Views

Comments