Topic: Databases

Exploration: UC Statfinder

The UC Office of the President has this statfinder app running at and it lets you generate tables with statistics about student admissions at their schools. Big whoop. The thing is, when the numbers get real small, their program merges categories to ensure that student privacy is protected. Also, they won’t give access to the raw database nor will they let you select more than 3 categories to compare at once. So data mining this is a bit difficult. Obviously, they don’t want anybody to create something remotely automated from this data. There is no API, the numbers are probably fuzzed, the raw data is totally unavailable, and the… go on →

CRUD Operations 1: Create

Part 2: Creating database tuples – There are four primary operations to modify table data in SQL databases. Keep in mind that the following are only operations for modifying data, and that there are many more operations used to modify table structure, modify database structure, user privileges, and interrelational (between tables) operations.

Fundamentals of Databases

Part 1: Introduction to Relational Database Theory – databases and schema. Databases are a fundamental part of many enterprise-level applications. Virtually all websites on the Internet today are essentially just an interface to a database. Content is created by the user, read by the user, and edited by the user.