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
- 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
- Introduction to Databases
- Data structures
- Database Management Systems
- Introduction to SQL
- Oracle Database
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
- Generating the Databases
- Querying to the Database
- Wikiversity forum for general discussion of databases. On this page, people will answer the questions you pose about databases.
Database Management Systems, second edition by Raghu Ramakrishnan (University of Wisconsin) and Johannes Gerkhe (Cornell University)
The Relational Model
The Third Manifesto