CSE2006

Database Systems

Core Courses

Prerequisites:CSE1006

A thorough introduction to database systems covering relational modelling, entity-relationship design, normalisation, SQL, transactions, performance tuning, distributed databases, and big data. Students learn to design, query, and manage robust databases for real-world applications.

15 Chapters

Chapters

From Raw Data to Information

Understanding Data Models and Database Design Foundations

Ch 3

Understanding Tables, Keys, and Relational Operations

12 min

Unlock all chapters — plans from $6/mo

Ch 4

Entity Relationship Modeling Foundations

17 min

Unlock all chapters — plans from $6/mo

Ch 5

Building Better Data Models with Advanced Design Techniques

14 min

Unlock all chapters — plans from $6/mo

Ch 6

Structuring Tables Through Normalization

10 min

Unlock all chapters — plans from $6/mo

Ch 7

Fundamentals of SQL Queries and Data Retrieval

14 min

Unlock all chapters — plans from $6/mo

Ch 8

Advanced SQL Concepts

16 min

Unlock all chapters — plans from $6/mo

Ch 9

Designing and Building Databases

13 min

Unlock all chapters — plans from $6/mo

Ch 10

Managing Transactions and Concurrent Access

13 min

Unlock all chapters — plans from $6/mo

Ch 11

Achieving Fast Database Queries Through Performance Tuning

14 min

Unlock all chapters — plans from $6/mo

Ch 12

Introduction to Distributed Database Systems

20 min

Unlock all chapters — plans from $6/mo

Ch 13

Business Intelligence and Data Warehousing

13 min

Unlock all chapters — plans from $6/mo

Ch 14

Understanding Big Data and Nonrelational Databases

13 min

Unlock all chapters — plans from $6/mo

Ch 16

Managing Data Resources and Organizational Security

14 min

Unlock all chapters — plans from $6/mo