Database Systems (CS 346)

Prepare to master both the conceptual foundation and the engine-level implementation of modern data management. Based on the gold-standard textbook by Silberschatz, Korth, and Sudarshan, this comprehensive course is designed to equip software engineers, CS students, and database architects with the rigorous, end-to-end expertise required to build, optimize, and scale modern database systems.

  • 15:17:20 hr(s)
  • Mon, 07-Sep-2026
  • English
  • Certified Course
Card image

About This Course

Welcome to Database Systems, a comprehensive online video course designed to take you from foundational concepts to system-level expertise. Based on the world-renowned textbook Database System Concepts (7th Edition) by Silberschatz, Korth, and Sudarshan, this course offers a university-grade exploration of both theoretical database design and low-level system internals. Whether you want to master complex SQL queries, architect fault-tolerant schemas, or understand the storage engines powering today's cloud databases, this course is your definitive guide.

 

What You Will Learn

Through structured video lectures and practical hands-on examples, you will learn to:

  • Master Relational Languages: Write robust SQL queries, ranging from basic joins to advanced nested subqueries, triggers, and windowing functions.
  • Design Bulletproof Schemas: Translate real-world requirements into conceptual models using E-R diagrams, and apply normalization theory (3NF/BCNF) to eliminate data redundancy.
  • Optimize Storage & Indexing: Understand physical file organization, buffer management, and high-performance indexing structures like B+-trees and write-optimized LSM-trees.
  • Control Concurrency & Recovery: Master ACID properties, locking protocols, snapshot isolation, and system recovery algorithms (such as ARIES) to prevent data loss.
  • Harness Big Data & Distributed Systems: Explore NoSQL key-value stores, column-oriented architectures, and distributed consensus (Raft/Paxos) across parallel networks.
  • Explore Blockchain Databases: Learn how cryptographic hash functions, consensus protocols, and smart contracts integrate with traditional enterprise database concepts.

 

Why Take This Course?

In the era of modern technology, backend developers must look beyond simple application-level SQL queries. To build scalable, high-performance systems, you need to know how database engines work under the hood. This course bridges the gap between application development and database implementation. You will acquire the deep system-level intuition needed to make informed architectural decisions, optimize queries, and resolve complex database bottlenecks.

 

Who Should Take This Course?

This course is tailored for:

  • Computer Science Students preparing for academic studies, professional examinations, or BCS qualifications.
  • Software Engineers & Backend Developers who want to master query optimization, schema design, and data indexing.
  • Database Professionals seeking a rigorous conceptual refresh of distributed systems, transaction management, and modern big data storage.
  • Prerequisites: A basic understanding of data structures, computer organization, and any high-level programming language (such as Python, Java, or C++).

What will I learn?

  • Query Optimization Mastery: Analyze query execution plans, identify execution bottlenecks, and rewrite SQL or configure indexing (B+ Trees/LSM-trees) to achieve order-of-magnitude performance gains.
  • Anomalies Prevention: Design database schemas in 3NF and BCNF, ensuring mathematical correctness and preventing data redundancy or update anomalies.
  • Concurrency & Recovery Architecting: Select and configure appropriate transaction isolation levels, locking mechanisms, and crash recovery strategies for mission-critical enterprise applications.
  • BCS Exam Readiness: Excel in the BCS Database Systems exam with comprehensive coverage of relational algebra, E-R mapping, normal forms, and distributed transaction management.

Verifiable Credentials

Every single course certificate issued by Atlanta College of Liberal Arts and Sciences (ACLAS) is verifiable via our digital registry and is eligible for institutional authentication (Apostille/IECC), ensuring your professional milestones are recognized globally as of 2026.

Curriculum

Requirements

  • Data Structures: Familiarity with basic data structures (such as arrays, hash tables, trees, and linked lists) is essential.
  • Computer Organization: A basic understanding of computer hardware architecture, memory hierarchies, and storage devices (RAM, SSD, HDD).
  • Programming Literacy: Experience in a high-level programming language such as Python, Java, or C++ to implement backend application connections.
Video Images
Preview this course
$ 45 $ 94.99
  • Lectures128
  • Skill LevelBeginner
  • LanguageEnglish
  • Quizzes2
  • CertificateYes
  • Expiry period Lifetime
Show More

Database Systems (CS 346)
$ 45 $ 94.99