Portal:Databases
School:Computer Science -> Topic:Computer Programming -> Topic:Databases
Course Purpose
[edit | edit source]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
[edit | edit source]- 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
[edit | edit source]Learners interested in Topic:Databases should first enroll at School:Computer Science and Computer Programming.
Lessons
[edit | edit source]- Introduction to Databases
- Data structures
- Database Management Systems
- Introduction to SQL
- Oracle Database
Introductory course
[edit | edit source]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
[edit | edit source]Forums
[edit | edit source]- Wikiversity forum for general discussion of databases. On this page, people will answer the questions you pose about databases.
Wikipedia articles
[edit | edit source]Wikibooks
[edit | edit source]Bibliography
[edit | edit source]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