Что такое ТРАНЗАКЦИИ В БД за 14 минут

Take a free quiz on this topic to reinforce your knowledge - https://qomp.club/quiz/73?topicId=4 Master the "SQL for Data and Analytics" skills course at Yandex Practicum: https://ya.cc/t/peVAkYRY5FNHXH 00:00 Video topic, source 00:27 Interesting things to learn about SQL 01:22 What the article will cover and a brief overview of transactions 02:06 What is a transaction and why is it needed 04:43 When are transactions needed 05:48 What is a connection and connection pool 07:17 How to open a transaction 07:34 How to close a transaction (COMMIT and ROLLBACK) 09:40 Why close a transaction 10:13 What is a savepoint 11:28 Autocommit and how to disable it 12:38 Summary Support the channel one-time - https://yoomoney.ru/to/410012243709514 Support the channel by subscribing - https://boosty.to/listenit Telegram channel - https://t.me/listenit_channel Yandex Zen - https://zen.yandex.ru/listenit Website with tests for channel episodes - https://qomp.club For collaboration inquiries - https://t.me/ed_akimov Link to the article - https://habr.com/ru/articles/537594/ Events and articles on IT system analysis and design - https://t.me/itsysdes_events TRANSACTION ISOLATION LEVELS in a database and MVCC in 16 minutes -    • УРОВНИ ИЗОЛЯЦИИ ТРАНЗАКЦИЙ в БД и MVCC за ...   What is ACID in 9 minutes -    • Что такое ACID за 9 минут   What is SQL and Relational Databases -    • Что такое SQL и реляционные базы данных   SQL Query Syntax: Part 1 -    • Синтаксис SQL запросов: Часть 1   What are SQL INDEXES in 10 minutes -    • Что такое SQL ИНДЕКСЫ за 10 минут: Объясне...   What is NoSQL in 6 minutes -    • Что такое NoSQL за 6 минут   Normal Database Forms: Explained in Simple Terms -    • Нормальные формы баз данных: Объясняем на ...   What is DB DENORMALIZATION in 13 minutes -    • Что такое ДЕНОРМАЛИЗАЦИЯ БД за 13 минут   What is ERD in 9 minutes -    • Что такое ERD за 9 минут   What is EVENT STORMING in 15 minutes -    • Что такое EVENT STORMING за 15 минут   What is UML in 7 minutes minutes -    • Что такое UML за 7 минут: Диаграмма классо...   What is an ERD in 9 minutes -    • Что такое ERD за 9 минут   Object-oriented programming in 10 minutes -    • Объектно-ориентированное программирование ...   What is DDD in 10 minutes with examples -    • Что такое DDD за 10 минут с примерами   What is SSO in 13 minutes -    • Что такое SSO за 13 минут   What is OAuth 2.0 and OpenID Connect in 15 minutes -    • Что такое OAuth 2.0 и OpenID Connect за 15...   What is a JWT and how to create one -    • Что такое JWT и как его создать   Compilation and interpretation in 10 minutes -    • Компиляция и интерпретация за 10 минут   What is TypeScript in 9 minutes -    • Что такое TypeScript за 9 минут   What is Scrum in 8 minutes -    • Что такое Scrum за 8 минут   Agile Overview -    • Обзор Agile. Это методология, метод или фи...   Backlog Prioritization in 4 minutes -    • Приоритизация бэклога за 4 минуты - опыт к...   What is Kanban -    • Что такое Канбан-метод - максимально коротко   What is a Kanban Board -    • Канбан-доска - это не то, что вы думаете   What are HTTP and HTTPS in 9 minutes -    • Что такое HTTP и HTTPS за 9 минут   Machine Learning for Dummies -    • Машинное обучение для чайников   What is Big Data in 6 minutes -    • Что такое Big Data за 6 минут   What is CRUD in 6 minutes -    • Что такое CRUD за 6 минут   Introduction to the REST API in 7 minutes -    • Введение в REST API за 7 минут   Differences between REST and SOAP in 4 minutes -    • Различия REST и SOAP за 4 минуты   What is middleware in 7 minutes -    • Что такое middleware за 7 минут, и как он ...   What is UML in 7 minutes -    • Что такое UML за 7 минут: Диаграмма классо...   Advertising, ANO DPO "Yandex Educational Technologies", INN 7704282033, 119021, Moscow, Timura Frunze St., Building 11, Building 2, Erid: 2Vtzqujzta6