CS 352
Networked and Large Database SystemsGeneral InformationThis course is divided into two components: lab and lecture. The lecture part of this class covers theoretical topics that need to be addressed when one enters the realm of large databases. These topics are listed below, and include such subjects as concurrency control, distributed databases, etc. The lab part of the class explores the Oracle 10g language. The topics covered are also listed below, and include such things as table creation, SQL, PL/SQL.. List of Topics for the Theory Part of the CourseConcurrency Control RAID Technology Error Recovery System Tuning Distributed Databases Database Applications Object Relational Databases List of Topics for the Lab Part of the CourseOverview of Oracle and Creating Oracle Database Objects such as TablesCheck, Not Null, Unique, Foreign Key, Primary Key Datatypes Create,Alter ,Drop. Modify Commands Comments Indexes Creating Views Sequences Synonyms Inserting, Updating and Deleting Records Merge Command Controlling Transactions Language Divisions DDL, DML, DCL Some Common Oracle FunctionsConversion Functions Char to number Numeric, Date to Char Date to Internal date Case Conversion Dual Table Nulls Character Manipulation Number Functions Date Functions Misc Function NVL, SYSDATE, DECODE Aggregate Functions List Functions Oracle QueriesSubqueries With clause InLine Views Correlated subqueries Set Operations Union Union All Intersect Minus Joining Tables Equijoin Cross Join Nonequijoins Outer Joins Self Joins Hierarchical Queries Substitution variables Accept command Rowid pseudo column Aliases Nulls Operators Order By Clause Distinct Clause Rownum Roll Up Clause Cube Clause PL/SQL Intro to SQL Plus CommandsSQL Buffer Define and Accept Statements Substitution Variables Misc SQL Plus Commands DESC,SAV,ED,GET,STA, SPO Comments Select, Insert, Update, Delete Within a PL/SQL block Implicit and Explicit Cursors PL/SQL Records Index by Tables Overview of the LanguagePL/SQL Blocks Variables Different Data types % Type command Bind Variables Records, arrays, tables User Defined Types Print command Looping and Branching Labeling Loops Goto Statement Nested Blocks Arrays Creating environments and Formating OutputSET Commands Formatting Output Column Command Break Command Profiles Product User Creating Accounts, Granting Privileges, and RolesException HandlingWhy Take This CourseMany of our CS graduates are employed as database programmers/administrators at various companies. It is said that we live in the "information age", and databases physically store and manipulate this information. Good database personal are in great demand by many companies. The application areas for these jobs can vary greatly; from medical database to business databases, and finally to databases that store geographical data so that it can be searched and plotted. This course, along with CS350, gives the student a very solid foundation in this area. After taking this sequence of courses, the student is proficient in two highly used database languages (Oracle and Access). They also posses good database design and tuning skills from having studied database theory. Grading
The grading scale is the typical 93-100=A, 90-92=A-, 87-89=B+, 83-86=B ..etc.. Attendance also affects the course grade (as explained under course policies). If a student does not receive a passing grade for the quizzes (lab + lecture) part of their grade, then the student will not pass the course even if there overall average is a pass A short answer format is used for lecture quizzes. In answering questions, students are expected to write down their thoughts in clear, precise, and unambiguous English. A hands on format is used for lab quizzes. In order to assess a student's critical thinking skills, a question or two on each lab quiz will cover topics not talked about in class. Course PoliciesAll exams and quizzes are closed book in nature. Taping of lectures is permitted. Attendance is expected. Material will be presented in class that is not found in the text. Quizzes and tests will be drawn from the material and discussions in class. In addition, for every absence beyond the sixth, a student will loose one-fourth of a letter grade. Note that the six allowed absences (approximatly two weeks of class) are to allow for the possibility of sickness and other special circumstances. In addition, if a student has more than six unexcused absences, the CISD chairperson is notified. If a student has more than nine unexcused absences, the academic dean is be notified. This, in turn, may result in a parent conference. Except in cases of emergency, the student should make arrangements with the instructor in advance if an exam/quiz must be missed. If there is sufficient reason the instructor will schedule an exam/quiz for the student at another time. Cheating will not be tolerated in this course. If cheating is discovered, I (the instructor) will make sure that the student, if guilty, receive the most severe reprimand possible from the academic dean. Cheating not only undermines the whole learning process, but it decreases the morale of the other students in the class who spend many long hours producing their own work. Use of the Internet or any entertainment software is prohibited during class. However, if they like, a student may use a word processor to type their notes during lecture. If a student has a learning disability, physical disability, or any other exceptional circumstance that would require special considerations (example: more time to take an exam), these considerations must be discussed with the instructor before the first quiz/exam is given. Below is the official disability statement for the college: Students with disabilities who require academic accommodations and support services should please consult Mrs. Sandy Quinlivan, Associate Director of Academic Affairs. You may contact her by telephone at extension 2371 or by SVC email (sandy.quinlivan@email.stvincent.edu) or by scheduling an appointment in Academic Affairs (located directly above the post office). Reasonable accommodations do not alter the essential elements of courses, programs or activities. Students are be given a one-week grace period to turn in late assignments. If an assignment is more than one week late, however, the assignment grade is decreased by one letter grade for every week that it is late. If stormy weather or some other emergency occurs, class cancellation can be verified by calling my office phone at 724-805-2421. My voice mail greeting will indicate if class has been cancelled or not. If my voice mail greeting has not been changed to indicate that the class has been cancelled, then it will be held. |
Maintained by: Ms. Colleen Carr