Databases In-Depth – Complete Course

Learn all about databases in this coruse 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

⭐️ 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 Architecture Overview
1:27:48 Educosys
1:29:30 Code structure
1:32:24 Tokeniser
1:35:15 Parser
1:38:33 ByteCode Generator
1:44:25 VDBE
1:52:58 Pager, BTree and OS Layer
1:56:03 Write Ahead Logging, Journaling
2:07:44 Cache Management
2:11:40 Pager in Detail
2:20:00 Pager Code walkthrough
2:25:51 Intro to next section
2:27:41 How to compile, run code, sqlite3 file
2:32:56 Debugging Open DB statement
2:36:13 Educosys
2:37:56 Reading schema while creating table
2:40:14 Tokenisation and Parsing Create Statement
2:44:55 Initialisation, Create Schema Table
2:51:24 Creation of Schema Table
2:55:41 Debugging Select Query
3:06:26 Creation of SQLite Temp Master
3:10:41 Creating Index and Inserting into Schema Table for Primary Key
3:16:36 Not Null and End Creation
3:17:55 Revision
3:22:15 Update Schema Table
3:26:01 Journaling
3:30:11 Finishing Creation of Table
3:35:24 Insertion into Table
3:40:21 Thank You!🎉 Thanks to our Champion and Sponsor supporters:
👾 Drake Milly
👾 Ulises Moralez
👾 Goddard Tan
👾 David MG
👾 Matthew Springman
👾 Claudio
👾 Oscar R.
👾 jedi-or-sith
👾 Nattira Maneerat
👾 Justin Hual

--

[KeertiPurswani]

A lot of effort went behind creating this, thank you so much for making it reach more people! Hope it helps 😇

[hq]

As someone who spent 5 hours listing and mind mapping each database and their functions yesterday, this video is my deus ex machina.

[mohamedkhodary]

I am here to say CONGRATS for reaching 10M 👏👏 well deserved

[ANUJKumar-yqg]

21:27 BASICALLY ACCURACY, SMOOTH WORKING WITHOUT ANY PIN DROP

[siddhubhai]

Golden thing came on this channel again 😍😍😍

[ibrahimhamid]

Thank you so much ma'am. This is a best course on database i have ever seen

[_ajinkya]

Time to add this course in "Gems of the channel" 😂😂

[MarcusHCrawford]

First five seconds: Subscribe!
Five seconds later: Subscribe!
Five seconds after that: Subscribe!
Look. I appreciate the work you put into this, but I’ve never seen someone plug their channel at the end of every single chapter.

[mahdi.attari]

اولین ویو باشهههه پسر شاه
ایرونی بازی در بیاره ❤😂