Databases In-Depth – Complete Course

From the creator

Learn all about databases in this course designed to help you understand the complexities of database architecture and optimization. From understanding the foundational components like transaction management and storage engines to mastering advanced indexing techniques and exploring the inner workings of SQLite, this course equips you with the knowledge to efficiently manage and optimize data systems. ✏️ Course developed by @KeertiPurswani Resources: https://register.educosys.com/new-courses/25-databases ❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba) ⭐️ Contents ⭐️ 0:00:00 Coming Up 0:00:49 Intro 0:01:49 Course structure 0:03:56 Client and Network Layer 0:05:39 Frontend Component 0:09:46 About Educosys 0:11:26 Execution Engine 0:12:41 Transaction Management 0:16:59 Storage Engine 0:21:58 OS Interaction Component 0:22:41 Distribution Components 0:25:01 Revision 0:30:14 RAM Vs Hard Disk 0:31:56 How Hard Disk works 0:34:26 Time taken to find in 1 million records 0:37:46 Educosys 0:39:26 Optimisation using Index Table 0:47:11 Multi-level Indexing 0:49:21 BTree Visualisation 0:50:06 Complexity Comparison of BSTs, Arrays and BTrees 0:57:06 Structure of BTree 0:59:56 Characteristics of BTrees 1:06:41 BTrees Vs B+ Trees 1:08:06 Intro for SQLite 1:09:35 SQLite Basics and Intro 1:12:07 MySQL, PostgreSQL Vs SQLite 1:13:05 GitHub and Documentation 1:14:05

Published 2024-10-09 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.