Monday, June 18, 2018
Wednesday, January 10, 2018
Database Management and Design
https://stevevincent.info/CIS2210_2018index.html
CIS 2210 - Database Management and Design
Other useful web sites: | |||||||
Wednesday, January 3, 2018
Database Management Using SQL
CIS 331: Database Management Using SQL
![]() | ![]() |
Database Management, Chapter 1: Introduction to Database Management
Database Management, Chapter 2: The Relational Model 1: Introduction, QBE, and Relational Algebra
Where do I get the SSH client to use at home?
Handout on Connecting to MySQL on Crux with SSH Client
Handout on backslash commands in MySQL
Guide to MySQL, Chapter 2: Database Design Fundamentals
Guide to MySQL, Chapter 3: An Introducton to SQL
Guide to MySQL, Chapter 4: Single-Table Queries
Study Guide for First Test
Project Requirements
Guide to MySQL, Chapter 5: Multiple-Table Queries
Database Management, Chapter 5: Database Design 1: Normalization
Database Management, Chapter 7: DBMS Functions
Study Guide for Second Test
Guide to MySQL, Chapter 6: Updating Data
Guide to MySQL, Chapter 7: Database Administration
Guide to MySQL, Chapter 8: MySQL Special Topics
Study Guide for Third Test
Database Systems: The Complete Book - see the student projects on this site for ideas about yours
Tech Web Encyclopedia
One Look - a great site for looking up any word
What Is...? - great for looking up technical terms
Marshall Brain's How Stuff Works - great articles on technology
SQLcourse - lessons and practice with SQL
MySQL Online Manual - lessons and practice with MySQL
Sunday, June 10, 2012
Database Systems
| Topic | HTML | |
|---|---|---|
| All Chapters | Not available | View PDF |
| Chapter 1. Introduction to the Module | View HTML | View PDF |
| Chapter 2. The Relational Model | View HTML | View PDF |
| Chapter 3. Introduction to SQL | View HTML | View PDF |
| Chapter 4. Intermediate SQL | View HTML | View PDF |
| Chapter 5. Advanced SQL | View HTML | View PDF |
| Chapter 6. Entity-Relationship Modelling | View HTML | View PDF |
| Chapter 7. Enhanced Entity-Relationship Modelling | View HTML | View PDF |
| Chapter 8. Data Normalisation | View HTML | View PDF |
| Chapter 9. Advanced Data Normalization | View HTML | View PDF |
| Chapter 10. Declarative Constraints and Database Triggers | View HTML | View PDF |
| Chapter 11. File organization and indexes | View HTML | View PDF |
| Chapter 12. Database Security | View HTML | View PDF |
| Chapter 13. Concurrency Control | View HTML | View PDF |
| Chapter 14. Backup and Recovery | View HTML | View PDF |
| Chapter 15. Distributed Database Systems | View HTML | View PDF |
| Chapter 16. Object-Oriented Database Systems | View HTML | View PDF |
| Chapter 17. Web-Database Connectivity | View HTML | View PDF |
| Chapter 18. Temporal Databases | View HTML | View PDF |
| Chapter 19. Data Warehousing and Data Mining | View HTML | View PDF |
| Chapter 20. Database Administration and Tuning | View HTML | View PDF |
| Appendix 1. Answers to Review Questions | View HTML | View PDF |
Common JOIN Pitfalls (And How to Avoid Them)
Common JOIN Pitfalls (And How to Avoid Them) Pitfall 1: Row Explosion (Duplicate Rows) When one side has multiple matches, result rows mul...
-
Relational model stores data in the form of tables. This concept purposed by Dr. E.F. Codd, a researcher of IBM in the year 1960s. The re...
-
Relational Algebra- Relational Algebra is a procedural query language which takes a relation as an input and generates a relation as an ou...

Review for the mid-term test
