
Logo courtesy Wordle.net
California State University Stanislaus
CS 4250: Database Management Systems
Fall 2021
3:00 - 3:50 pm, M W F, DBH 101 starting Oct 1. (via Zoom until Oct 1.) Dr. Megan Thomas
[Syllabus
] [Announcements]
[Calendar/Lecture Notes]
[Homeworks]
[Resources]
[Fun News]
Welcome to CS4250, an introduction to database management systems.
Topics include:
Modeling, development, and implementation of database systems using storage structures,
data definition languages, and data manipulation languages for the relational approach
to database management. Database integrity and security problems. Historical development
of database systems.
Prerequisite: CS 3100.
Announcements and Upcoming Events
Homeworks
Project Overview
Books at the CSU Stanislaus Library
- Database Systems: The Complete Book by Garcia-Molina, Ullman and Widom,
three extremely well-respected database researchers and professors at Stanford University.
- Database Management Systems by Raghu Ramakrishnan and Johannes Gherke,
excellent, systems-oriented introduction to the field of database management.
- Database Tuning by Dennis Sasha and Philippe Bonet. A clear
presentation of how database design decisions impact database performance.
Also discusses IBM, Oracle and Microsoft systems and how design choices can impact them.
- MySQL and mSQL by Randy Yarger.
- MySQL by Paul DuBois (electronic).
- Readings in Database Systems by M. Stonebraker. A collection of
influential papers in DBMS research history.
The Ramakrishnan and Garcia-Molina/Ullman/Widom textbooks are both
available at the university library.
Campus Resources
DBMS Resources
- IBM's DB2, etc
- MySQL
- Oracle
- PostgreSQL
- Microsoft SQL Server
- SQLite
-
'cd' (Unix/Mac) or 'chdir' (Windows/ Command Prompt) your command line window into
whatever folder you put the files you downloaded and unzipped, and type ./sqlite3
(Unix/Mac) or .\sqlite3 (Windows) and the SQLite command line tool should start up.
- I've put the start-up file of SQL commands here.
I usually copy-and-paste the ch5-demo.sql file's contents into the sqlite3 command
prompt. (There is an import command, but it has occasionally behaved oddly for me.)
- Basic instructions for the command line SQLite are here.
- SQL for Web Nerds by Philip
Greenspun, a free, on-line only database textbook with a focus on Oracle DBMSs
- SQLFiddle.com appears to be a web site
that allows uers to "fiddle around" with SQL.
- JDBC Tutorial,
courtesy Jeff Ullman
- JDBC Tutorial,
courtesy Oracle
- MySQL Tutorial - pure tutorial web site
- Execute PHP
MySQL On-line, a PHP testing facility provided by http://www.tutorialspoint.com/
- XML Tutorial, courtesy w3schools.com
- XML Tutorial, courtesy zvon.com
- Phlonx's Third Normal Form Tutorial,
with numerous illustrative diagrams
- Lynda.com's databases-related courses --
all videos. You would need to authenticate yourself as a CSU Stanislaus student to
view the videos.
-
- XKCD on SQL
- "Hard drive teardown", EngineerGuy video
Fun News Items
- "4 strategies for managing your job search anxiety" (Fast Company, 4 May 2021)
- "Systems Engineer, Web App Developer: Best Entry-Level Jobs in Tech?" (Dice.com, 27 April 2021)
- "The 10 Best States For Tech Job Openings", CRN.com, 15 Apr 2021.
- "LinkedIn: Top 15 In-Demand Jobs in 2021", 14 Jan 2021. (Scroll down. Keep scrolling.)
- A podcast episode to listen to: "Episode 454: Thomas Richter on Postgres as an OLAP database" (IEEE Software Engineering Radio, 8 Apr 2021). Listen to this towards the end of a semester, when you will know more of the DBMS vocabulary.
- "50 Technology Skills That Remote Employers Want", Dice.com, December 2020
-
"The 5 top tech skills companies want in new hires right now", Fortune magazine,
6 Feb 2020.
- "Tech Professions Dominate Rankings of Best Jobs in the U.S.", IEEE Spectrum 'View from the Valley', 17 Jan 2020.
- "Cybersecurity Needs YOU" by CSU News, Oct 2019
- "SQL, Java Top List of Most In-Demand Tech Skills",
IEEE Job Site, Nov. 2019.
- "How To Get Your Data Scientist Career Started", Forbes.com, Apr. 14, 2019
- "Data
Center Love: Tech Chiefs Show Off the Gear That Keeps Everything Humming"
by CIO Journal Staff, of the Wall Street Journal, on Dec. 31, 2015.
- "Data Modeling for Analytical Data Warehouses,"
an interview with Michael Blaha (3/3/2012) ODBMS Industry Watch.
- "Under the Hood at Google and Facebook:
A peek at the data centers, servers, and software that keep us feeling connected"
IEEE Spectrum, June 2011.
- Database
Normalization for the Real World: nice article walking
one through the steps of database normalization, with larger- than- can- fit- on- a-
PowerPoint- slide relation examples.