Readings
This page provides readings in the foundations of computer systems and systems programming. Readings will be assigned throughout the course with individual lessons. Other readings, although optional, will increase your underestanding of the topic and provide more in-depth information.
Online Readings
Required
-
Database Management System Tutorial
from TutorialsPoint (last accessed 2017-09-01).
A general overview of database management systems including the Entity-Relationship (ER) model and the Relational model.
-
SQL Structured Query Language
from TutorialsPoint (last accessed 2017-09-01).
For learning aspects of the SQL programming language, readings will be assigned from this extensive online tutorial. Readings from other online sources may also be assigned.
-
JDBC Tutorial from TutorialsPoint
(last accessed 2017-09-01).
For learning aspects of the Java JDBC database interface standard, readings will be assigned from this extensive online tutorial. Readings from other online sources may also be assigned.
-
MongoDB Tutorial from TutorialsPoint
(last accessed 2017-09-01).
For learning aspects of the MongoDB NoSQL database system, readings will be assigned from this extensive online tutorial. Readings from other online sources may also be assigned.
Additional Reading
Here are additional tutorials and other readings. Many of them provide background on a speific database product.
-
Introduction to RDBMS.BCA Books (last accessed 2017-09-01).
Note that this online text is based on Oracle RDBMS, most of the material is equally applicable to other RDBMS as well.
-
RelaX - relational algebra calculator
(last accessed 2017-09-01).
This interactive tool helps you learn relational algebra by executing relational operations on sample data and observing the results.
-
Database Development Using the Eclipse IDE, Derby with
Eclipse Data Tools Platform in Java from bhaveshThaker
(last accessed 2017-09-01).
Covers connecting to JavaDB/Derby and basic Eclipse Data Tools Platform (DTP) features.
-
MariaDB Tutorial. from the Java T Point
(last accessed 2017-09-01).
A tutorial on the features of MariaDB.
-
Java JDBC Tutorial. from the Java T Point
(last accessed 2017-09-01).
A tutorial on the features the Java JDBC database API.
-
Java JDBC Tutorial. from the Oracle
(last accessed 2017-09-01).
A tutorial on the features the Java JDBC database API.
-
Getting Started with MongoDB. from the MongoDB
documentation project (last accessed 2017-09-01).
A tutorial on using MongoDB.
-
MongDB Java Driver Quick Tour (last acessed 2017-09-01).
Demonstrates connecting to a MongoDB using Java.
-
MongoDB Tutorial. from the Java T Point
(last accessed 2017-09-01).
A tutorial on the features of MongoDB.
-
Node.js MongoDB Driver API.
(last accessed 2019-06-01).
Documentation for the Node.js MongoDB API