CIS154 Course Syllabus

On This Page Instructor Information Course Information Course Objectives Who Should Take This Course Skills Needed Textbooks and Other Materials Grading Policies Alternate Grading Working Together Academic Dishonesty Typical Class Session Instructor Information Name Ed Parrish Email See here. Office location Room 2503 Office hours See here. Phone 477-3576 back to top Course Information Course title Introduction to Client/Server Relational Database Management Systems Course Number 154 Course description Students will learn to install, use, and administer a Client/Server Relational Database Management System. Course date 2/4/2002 through 6/1/2002 Location Room 2501 Meeting day(s) Monday Meeting time(s) 6:00 PM - 10:10 PM Prerequisite(s) CIS151. Previous programming experience (e.g. Visual Basic, Java, C++, et. al.) is useful. back to top Course Objectives   Identify the components and tools of the Client/Server RDBMS (C/S-RDBMS) Download and install the C/S-RDBMS, and use the command-line interface Design a database based upon the concepts of business process, objects and rules Create databases Administer a database using it's administration utility Add users Create, rename, modify and delete tables and indexes Describe the Normal Forms and the limits of normalization Apply normalization to a database Describe and use the C/S-RDBMS data types Populate a database using import methods and database transfer tools Explain the components, syntax and data manipulation commands within SQL (Structured Query Language) Synthesize a SQL statement using SELECT, WHERE, ORDER BY and GROUP BY Describe the principles of joining Explain and implement Inner Joins, Outer Joins, Self Joins and Unions Describe and implement methods for manipulating data within SQL Synthesize queries to insert data, update data, and delete data Describe server-level programming Describe numerical, logical, conditional, string and character functions Implement locks Describe and perform the process of establishing a database connection and retrieving a recordset Describe the process of implementing an ODBC, a Perl and a PHP interface Implement a PHP interface Utilize Time and Date Functions Describe and perform the process of securing a C/S-RDBMS database Compare and contrast the C/S-RDBMS with other client-server RDBMS's Create and implement a backup and restore strategy Administer update logging, data relocation, system functions, and repair of a corrupted database Describe the security scheme in the C/S-RDBMS and assign user privileges Describe and implement methods for performance tuning, compiling and compression back to top Who Should Take This Course   The following people will benefit from this course: IT professionals who wish to learn how to install, use, and administer a Client/Server Relational Database Management System. Database programmers who wish to understand the capabilities of Client/Server Relational Database Management Systems. Software developers who need to understand and develop applications for Client/Server Relational Database Management Systems. back to top Skills Needed File Management Create, edit, save and rename files using appropriate filenames and extensions Create directories and subdirectories (folders and subfolders) Use Windows Explorer (right click Start button) to copy, move and paste files and directories Use Windows Explorer to copy files Word Processing All written assignments must be word processed. Handwritten assignments will not be accepted. Internet/WWW You need to know how to use a web browser in order to access course materials on my web site. Database You need to have some familiarity with basic database concepts such as tables and relationships. Programming and HTML Skills Prior programming and HTML training or experience is useful preparation for this course. If you have no experience or training, then you may still take this course; but be prepared to work extra hard at times during the course. If you have had previous programming or HTML experience, but are a little rusty, you should be able to refresh your skills with little difficulty. Patience and Time If you have enough time to sit in class and in lab, but don't have 9 hours a week to devote to homework, drop this class. If you have no prior programming experience, you will need twice as much time during the first few weeks. You will need time to experiment with the details of the programming language and databases, and to design solutions to assignments and the course project. back to top Textbooks Required reading MySQL, Paul DuBois, New Riders Publishing, 0-7357-0921-1 back to top Grading Policies Assessed areas Your final grade is weighted based on your performance in the following areas: Homework Assignments 35% In-class and lab exercises and quizzes 40% Final Exam 25% In-class and lab exercises are graded based on best effort. If you make a valid attempt to complete every exercise, you will receive full credit for the exercise. For each portion of an exercise that you do not complete, I will reduce the score by one grade level. Quizes are graded based on answering questions correctly. Only correct answers receive credit. Grade interpretation Grading in each area is based on the following scale: Grade From To Description A 90% 100% Outstanding work reflecting substantial effort B 80% 89.9% Good work fully meeting that expected of a good student C 70% 79.9% Satisfactory work meeting all minimum requirements D 60% 69.9% Substandard work not meeting reasonable expectations F 0% 59.9% Unsatisfactory work If you have questions about problems you missed on any exercise or assignment, please see me right away. I want to ensure both that you understand the material and that your grades are accurate and fair. back to top Alternate Grading Credit/No Credit Option By default, everyone receives a letter grade. If you request the Credit/No Credit Option, you must complete the course work at a satisfactory (i.e. "C") or better level. For more information, see the Cabrillo Academic Policies and Procedures document. Incompletes You must complete 75% or more of all course work in order to qualify for an Incomplete grade. You have one year to complete the incomplete. back to top Working Together back to top Academic Dishonesty   Any confirmed academic dishonesty, including but not limited to copying assignments or cheating on exams, will result in disciplinary action. During exams, I expect there to be no talking, and no wandering eyes. It is your responsibility to make it abundantly clear to me that you are not cheating. Any person caught cheating will be given a grade of zero for the assignment or exam. The second offense will result in a no-pass or failing grade for the course. back to top Typical Class Session Typical Class The following is an outline of a typical class and lab session: Elapsed Time   Event 0:00    Discuss questions that have short answers or broad interest within the class 0:15    Lecture/demonstration 1:15    Break 1:30    Short quiz or graded exercise 1:45    Lecture/demonstration 2:45    Break 3:00    Start lab session -- consultation on exercises or assignments 4:05    Exit classroom/passing time back to top   Home | WebCT | Announcements | Schedule | Syllabus Expectations | Help | FAQ's | HowTo's | Samples | Links Last Updated: 7/16/2003 5:37:34 PM