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

Forums

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

Wikipedia articles

 * Database
 * Relational database

Wikibooks

 * Databases
 * Database Design
 * MySQL