Portal:Databases

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

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

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
• MariaDB

Prerequisites

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

• Introduction to Programming
• ...

Lessons

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

Introductory course

This course is intended to serve as a quick-and-dirty introduction to Relational Databases, leading the reader to a point where they could create a useful small database for home or small business use.

• Introduction to Relational Databases
• Designing a Relational Database
• Datatypes
• Generating the Databases
• Querying to the Database

Learning resources

Forums

• Wikiversity forum for general discussion of databases. On this page, people will answer the questions you pose about databases.

Wikipedia articles

• w:Database
• w:Relational database

Wikibooks

• Databases
• Database Design
• MySQL

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