Showing posts with label book. Show all posts
Showing posts with label book. Show all posts

Wednesday, January 10, 2018

Database Management and Design

 


https://stevevincent.info/CIS2210_2018index.html

 

CIS 2210 - Database Management and Design

Text Image

Link to Publisher's Student Site




Lesson 1: Chapter 1
Lesson 2: Chapters 2 and 3
Lesson 3: Chapters 4 and 5
Lesson 4: Chapter 6
Lesson 5: Chapter 9
Lesson 6: Chapter 7
Lesson 7: Chapter 8
Lesson 8: Chapter 15
Review for the mid-term test
Lesson 9: Chapter 10
Lesson 10: Chapter 11
Lesson 11: Chapter 16
Lesson 12: Chapter 12
Lesson 13: Chapter 13
Assignment 9 and Final Project Presentation: Altermate assignment taking the place of the two named assignments.
Lesson 14: Chapter 14
Review for the end-of-term test



Other useful web sites:
SQLcourse - lessons and practice with SQL
MySQL Online Manual - lessons and practice with MySQL

Sunday, June 10, 2012

Database Systems

 

TopicHTMLPDF
All ChaptersNot availableView PDF
Chapter 1. Introduction to the ModuleView HTMLView PDF
Chapter 2. The Relational ModelView HTMLView PDF
Chapter 3. Introduction to SQLView HTMLView PDF
Chapter 4. Intermediate SQLView HTMLView PDF
Chapter 5. Advanced SQLView HTMLView PDF
Chapter 6. Entity-Relationship ModellingView HTMLView PDF
Chapter 7. Enhanced Entity-Relationship ModellingView HTMLView PDF
Chapter 8. Data NormalisationView HTMLView PDF
Chapter 9. Advanced Data NormalizationView HTMLView PDF
Chapter 10. Declarative Constraints and Database TriggersView HTMLView PDF
Chapter 11. File organization and indexesView HTMLView PDF
Chapter 12. Database SecurityView HTMLView PDF
Chapter 13. Concurrency ControlView HTMLView PDF
Chapter 14. Backup and RecoveryView HTMLView PDF
Chapter 15. Distributed Database SystemsView HTMLView PDF
Chapter 16. Object-Oriented Database SystemsView HTMLView PDF
Chapter 17. Web-Database ConnectivityView HTMLView PDF
Chapter 18. Temporal DatabasesView HTMLView PDF
Chapter 19. Data Warehousing and Data MiningView HTMLView PDF
Chapter 20. Database Administration and TuningView HTMLView PDF
Appendix 1. Answers to Review QuestionsView HTMLView 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...