Dive deep into the world of databases with this comprehensive course designed to enhance your understanding of database architecture and optimization. Explore foundational components like transaction management and storage engines, master advanced indexing techniques, and delve into the inner workings of SQLite. Gain practical knowledge on efficiently managing and optimizing data systems through hands-on examples and in-depth explanations. Cover topics ranging from client and network layers to distribution components, RAM vs. hard disk comparisons, and complex data structures like B-trees. Learn about SQLite's architecture, code structure, and debugging techniques. By the end of this course, you'll have a solid grasp on database internals, query optimization, and the intricacies of SQLite implementation.
Overview
Syllabus
Coming Up
Intro
Course structure
Client and Network Layer
Frontend Component
About Educosys
Execution Engine
Transaction Management
Storage Engine
OS Interaction Component
Distribution Components
Revision
RAM Vs Hard Disk
How Hard Disk works
Time taken to find in 1 million records
Educosys
Optimisation using Index Table
Multi-level Indexing
BTree Visualisation
Complexity Comparison of BSTs, Arrays and BTrees
Structure of BTree
Characteristics of BTrees
BTrees Vs B+ Trees
Intro for SQLite
SQLite Basics and Intro
MySQL, PostgreSQL Vs SQLite
GitHub and Documentation
Architecture Overview
Educosys
Code structure
Tokeniser
Parser
ByteCode Generator
VDBE
Pager, BTree and OS Layer
Write Ahead Logging, Journaling
Cache Management
Pager in Detail
Pager Code walkthrough
Intro to next section
How to compile, run code, sqlite3 file
Debugging Open DB statement
Educosys
Reading schema while creating table
Tokenisation and Parsing Create Statement
Initialisation, Create Schema Table
Creation of Schema Table
Debugging Select Query
Creation of SQLite Temp Master
Creating Index and Inserting into Schema Table for Primary Key
Not Null and End Creation
Revision
Update Schema Table
Journaling
Finishing Creation of Table
Insertion into Table
Thank You! Thanks to our Champion and Sponsor supporters:
Taught by
freeCodeCamp.org
