Logo courtesy Wordclouds.com
California State University Stanislaus
CS 4250: Database Management Systems
11:00 - 12:15 pm, Tu Th, CX 102, Dr. Megan Thomas
Welcome to CS4250, an introduction to database management systems.
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
"Software Engineering Jobs Dominate List of Best Careers for 2017", IEEE Spectrum, 22 March 2017.
Here is a small chunk of the midterm you will
take on Thursday.
Schema from class exercise: CREATE TABLE BookAwardWinners (lastname CHAR(20), firstname CHAR(20), title CHAR(30), year INTEGER, award CHAR(10), age INTEGER, PRIMARY KEY (lastname, title, award))
Goofy schema, and not normalized.
|| "Data Scientist, DevOps Engineer and DBA Among Top IT Jobs for 2017" (Datamation.com, Jan 2017)
|| Wellness Workshops
for students at CSU Stanislaus -- stress management, managing time and other
tricky issues, etc. Offered by CSU Stanislaus Counseling Services
|| Welcome to CS 4250!
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.
CSU Stanislaus Dreamers: Resources
for AB540 and undocumented students
- IBM's DB2, etc
- Microsoft SQL Server
- 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,
- Execute PHP
MySQL On-line, a PHP testing facility provided by http://www.tutorialspoint.com/
- XML Tutorial, courtesy w3schools.com, and XML Tutorial, courtesy zvon.com
- XML Tutorial, courtesy zvon.com
- Phlonx's Third Normal Form Tutorial,
with numerous illustrative diagrams
- Lynda.com's "Foundations of Programming: Databases" course --
all videos. You would need to authenticate yourself as a CSU Stanislaus student to
view the videos.
Fun News Items
- "These Tech Jobs Are Set To Get a Major Pay Bump" (Fortune, Dec 2, 2016)
- "Want a sure-fire well-paid job? Train to fight computer hackers" (Sacramento Bee, 7 Oct 2016)
"Beyond Just 'Big' Data" (IEEE Spectrum, 28 Jul 2015) -- notice the comment
about jobs related to big data...
"How to Break Into Some of the Fastest-Growing Tech Fields" (theinstitute by IEEE, September 2016)
- XKCD on SQL
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.
- IBM, Universities Team Up To Build Data Scientists:
Big Blue program aims to prepare students for a workplace increasingly driven by data"
- "Job Hunting in the Internet Age: A Techwise Conversation with Mike Junge, Google's senior recruiter"
"Top secret Visa data center banks on security, even has moat", (USA Today, 3/2012)
Security guards, power back-ups, earthquake and hurricane protection... credit
card companies take protecting data seriously.
- "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.
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.