Home‎ > ‎

CIS 54

Introduction to Client/Server Relational Database Management Systems

 Time Wednesdays 5:30pm to 9:35pm 
 Room 828 Aptos Main Campus
 Live Online 
 Archives
 Roll Call
 Lab Open Lab - 1 hour per week TBA
 Units 4
 Transfers CSU
 Book Database Concepts (7th Edition)
 David M. Kroenke and David J. Auer
 Pearson ISBN-13 978-0133544626
 Status Version 2: Alpha 
 Calendar, assignments subject to change
 Links Canvas 

Course Calendar

DateTopicReadingLab
January 25, 2017 Welcome   
February 1, 2017 Introduction to DBMS Chapter 1 Lab 1 - Get Access 
February 8, 2017 The Relational Model Chapter 2 Lab 2 - Your First Schema 
February 15, 2017 The Relational Model Chapter 2 Lab 3 - Keys 
February 22, 2017 The Relational Model Chapter 2  
March 1, 2017 SQL - SELECT Part 1 Chapter 3 Lab 4 - FDs 
March 8, 2017 SQL - SELECT Part 2 Chapter 3 Lab 5 - Normalization and SELECT 
March 15, 2017 Practice Midterm  Lab 6 - Restaurant Schema 
March 22, 2017 Spring Break   
March 29, 2017 SQL - Creating Tables Chapter 3  
April 5, 2017 SQL - Subqueries and Joins Chapter 3 Lab 7 - Populate your Schema 
April 12, 2017 SQL - Outer Joins Chapter 3 Lab 8: Multiple Queries 
April 19, 2017 Data Modeling Chapter 4 Lab 9: Queries and Updates 
April 26, 2017 Database Design Chapter 5  
May 3, 2017 Transactions and Concurrency Chapter 6 Lab 10: Project Specification 
May 10, 2017 Database Security Chapter 6 Lab 11: Project Implementation 
Showing 16 items from page CIS 54 Calendar sorted by Date. View more »

Video Archives

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.

Student Learner 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
TBA (To Be Arranged) Lab Hours
This course meets weekly at the times shown in the Cabrillo Schedule of Classes and above. In addition each student is required to spend lab time every week in either the CIS Lab (room 830) or online using the CIS VLab. Students may choose the time and day for their TBA Lab Hours where they will work on lab assignments designed to give them practical hands-on experience and continue the learning process. These TBA lab hours are required, tracked, and graded. It is the student’s responsibility to complete the TBA lab hours, which start on Week 1 of the term, and record their attendance. Tip: A great time to do TBA lab hours is in the CIS Lab when the instructor is there. If that is not possible, questions can always be posted on the electronic help forum which is monitored by the instructor.

Late Work Will Not Be Accepted
Homework is due before class on the calendar date where the homework is listed. Please complete all assignments on time as they will not be accepted if they are late. This will help both the student and instructor keep the class moving and avoid log jams at the end of the term. If an assignment is not complete by the deadline it is better to make an incomplete submission for partial credit than no submission at all. There may be extra credit work for students needing extra points.

Classroom Etiquette
It is important to have an effective, distraction-free classroom environment for learning. To minimize distractions all cell-phones should be turned off or at least silenced. Never carry on conversations during the lecture as this is probably the most annoying distraction possible to those sitting nearby.

For students in the physical classroom, computers can be turned on for viewing lecture slides locally, Google-ing related technical information, and doing classroom exercises. A student's full attention is desired so the computers should not be used during lecture for email or anything that would distract them or others from the material being taught.

For students in the virtual classroom, use the "Raise hand" icon in CCC Confer to let the instructor know you have a question. The chat window can be used to ask questions and communicate with the instructor or other classmates. For students dialing in please use *6 on your phone to mute/unmute your line so background noises in your location don't distract the class.

Please plan on coming to all classes. If class will be missed let the instructor know ahead of time. It is the student's responsibility to get any missed material or information from other classmates (the forum is a good way to do this). Please note that being disruptive is grounds for being dropped from the class by the instructor.

Academic Conduct
Instructors at Cabrillo will not tolerate any forms of academic dishonesty. We do not accept remarkably similar assignments. Students who engage in violations of academic integrity (cheating, plagiarizing print or electronic sources, copying computer files, web site content) as outlined in Cabrillo's "Student Rights and Responsibilities" document are subject to disciplinary action by the instructor including receiving an "F" for the assignment, being dropped from the course with a "W" or being issued an "F" for the course.

Special Learning Needs
Veterans or students with disabilities, including "invisible" disabilities such as chronic diseases, learning, and psychological disabilities, are encouraged to explain their needs and appropriate accommodations to the instructor during office hours. Please bring a verification of your disability from the Learning Skills or DSPS offices and a counselor or specialist's recommendations for accommodating your needs.

As required by the Americans with Disabilities Act (ADA), accommodations are provided to insure equal opportunity for students with verified disabilities. If you need assistance with an accommodation, please contact the Learning Skills Program at 831-479-6220 (for students with learning disabilities and attention deficit disorders) or Disabled Student Programs and Services (DSPS) at 831-479-6379 or 831-479-6421 (TTY) to make arrangements as soon as possible.

Students interested in receiving accommodations and services can contact the ASC at (831) 479-6379 to schedule an appointment to meet with one of the ASC counselors. Please arrive 15 minutes prior to the scheduled appointment to fill out necessary paperwork.

ASC is located outside Room 1073 in The Hub, upstairs behind the library.

Missing Classes and Drops
It is the student's responsibility to officially withdraw from classes. If you miss more than two classes or two lab assignments, the instructor may drop you from the course enrollment unless prior arrangements have been made and agreed to.