Topic:Databases

From Wikiversity

School:Computer Science -> Topic:Computer Programming -> Topic:Databases

Contents 1 Course Purpose 2 Learning projects 3 Prerequisites 4 Lessons 5 Learning resources 5.1 Wikipedia articles 5.2 Wikibooks 5.3 Bibliography

[edit] Course Purpose

1) The aim is to present the general principles of the database systems with a practical focus, and some implementation assignments. Those assignments may or may not include programming.

2)The course assumes that students have some programming or strong logical reasoning skills in programming languages like c or C++. Some programming data structures such as (heap files, buffer manager, B+ trees, hash indexes, various join methods) are used in the course

[edit] Learning projects

• Topic:SQL - SQL Wikipedia article, SQL at Wikibooks
• Topic:MySQL - popular Open Source database system (MySQL Wikipedia article, MySQL at Wikibooks)
• Topic:PostgreSQL - large scale, fully SQL compliant Open Source database system (PostgreSQL at Wikipedia, PostgreSQL at Wikibooks)
• Topic:Object-Oriented Programming - includes a discussion of Object-relational databases
• Topic:Web Design - includes learning materials for building dynamic websites with database-driven backends
• ...

[edit] Prerequisites

Learners interested in Topic:Databases should first enroll at School:Computer Science and Computer Programming.

• Introduction to Programming
• ...

[edit] Lessons

• Introduction to Databases
• Data structures
• Database Management Systems
• Introduction to SQL
• ...

[edit] Learning resources

[edit] Wikipedia articles

• w:Database
• w:Relational database

[edit] Wikibooks

• Databases
• Database Design
• MySQL

[edit] Bibliography

Database Management Systems, second edition by Raghu Ramakrishnan (University of Wisconsin) and Johannes Gerkhe (Cornell University)

Database Management Systems, third edition by by Raghu Ramakrishnan and Johannes Gehrke

The Relational Model

The Third Manifesto