Introduction to Database Management Systems

Time Thursdays 5:30pm to 9:35pm
Room 828 Aptos Main Campus
Live Online
Roll Call
Units 4
Transfers CSU
Book Database Concepts (7th Edition)
David M. Kroenke and David J. Auer
Pearson ISBN-13 978-0133544626
Links Canvas

Course Calendar

Week Topic Reading
1 Welcome
2 Introduction to DBMS Chapter 1
3 The Relational Model Chapter 2
4 The Relational Model Chapter 2
5 The Relational Model Chapter 2
6 SQL - SELECT Chapter 3
7 SQL - SELECT Chapter 3
8 Midterm
9 Spring Break
10 SQL - Creating Tables Chapter 3
11 SQL - Subqueries and Joins Chapter 3
12 SQL - Outer Joins Chapter 3
13 Data Modeling Chapter 4
14 Database Design Chapter 4
15 Transactions and Concurrency Chapter 6
16 Accounts and Security Chapter 6
17 Final

Course Description

Teaches the the use and administration of a Client/Server Relational Database Management System. Covers the installation and administration of MySQL Client/Server Relational Database Management Installation along with the design, creation and administration of enterprise databases, performance tuning, security, and disaster recovery. Additional topics include: SQL (Structured Query Language), data types, functions, normalization, and a brief introduction to server-level programming and language interfaces for developing database-driven websites, emphasizing PHP systems. May be offered in a Distance-Learning Format.

Learning Outcomes

  1. Implement and analyze databases.
  2. Maintain database management systems and data.

Objectives

  1. Discuss the functionality of relational database management systems.
  2. Install a relational database management system.
  3. Apply administration utilities to administer a database management system.
  4. Identify how information is physically stored in a database.
  5. Synthesize a database query using SQL.
  6. Write and debug SQL statements inserting, updating, and deleting records in a database.
  7. Create and drop user databases.
  8. Create, rename, modify, and delete tables and indexes.
  9. Design a database with efficient data retrieval that is easy to maintain.
  10. Populate a database using import methods and database transfer tools.
  11. Describe and implement transactions and locking.
  12. Describe and perform the process of securing a database.
  13. Analyze the security of a database installation.
  14. Describe the security architecture in a database and assign user privileges.
  15. Discuss security best practices.
  16. Administer repair of a corrupted database.
  17. Create and implement a backup and restore strategy.
  18. Describe and implement methods for optimizing database performance.

Grading Policy

  • 60% Labs
  • 20% Midterm
  • 20% Final