PostgreSQL for the developer. Author's workshop - course 35,990 rub. from Specialist, training 24 academic hours, date of May 14, 2023.
Miscellaneous / / November 30, 2023
A practical teacher with more than 30 years of experience in IT, including 20 years with databases. Certified PostgreSQL trainer.
A graduate of the Moscow Aviation Institute, Anton Vladimirovich went from a programmer to the head of the database development department. As part of his professional activities, he participated in the development of automated control systems in a variety of subject areas. These include ERP, transport and warehouse logistics, media data analysis and decision support systems. He worked both in commercial organizations and in state corporations.
Anton Vladimirovich led the IT department (up to 25 people) for software development and support. Headed software development, including project decomposition, distribution of tasks between performers, compilation and updating of calendar plans, control and correction of development deadlines, risk analysis and risk management planning, maintenance of project documentation and control quality.
He was also involved in development from scratch, from analyzing business processes, forming software requirements and drawing up technical specifications to putting them into commercial operation, including the development of a database architecture. Has experience in developing high-load systems with 24/7 operation.
Among his significant achievements is the completely in-house development of the back office for the public.ru network library, which is now the largest archive and media database with the ability to flexibly search for materials for any period time. In 2008, the system was put into commercial operation.
Proficient in technologies such as C/C++, MFC, WinAPI, MS Visual Studio, SQL, T-SQL, MS SQL Server, PostgreSQL (development and implementation of data structures, server logic), UML, HTML, XML, C#: .NET.
Anton Vladimirovich is distinguished by the desire for constant development - throughout his professional career several times improved his qualifications in project management and team software development provision. His work is guided by software development methodologies such as Waterfall, RUP, Scrum, and PMBoK project management standards. During classes, he strives to adapt to the capabilities of the listener so that everyone can successfully master the material.
Module 1. Part 1 (8 ac. h.)
- Connection to the DBMS from the application program.
- Main types of client libraries.
- The concept of object-relational mapping (ORM).
- Expansion modules included in the delivery kit.
Module 2. Part 2 (8 ac. h.)
- The most important third-party extension modules: PostGIS, external data wrappers.
- Working with hierarchical structures. Recursive with queries.
- Workshop.
Module 3. Part 3 (8 ac. h.)
- Inheritance and partitioning of tables.
- Application of window functions.
- Creation of functions in procedural languages (C, Python).
- Creation of custom data types.
An introductory course to DevOps that explains and demonstrates principles, best practices, and popular tools. You will learn what Continuous Integration, Continuous Delivery and Continuous Deployment, Infrastructure as Code, Configuration Management are and what is happening in the clouds.
3,9