CS270 Intro to SQL Using Oracle
|
Name: Dr. Greg
Grinberg |
Office
Location: MT408
|
|
Mailbox
Location:MT429 |
Office Phone: 301-
251-7161 |
|
Email: grigoriy.grinberg@gmail.com Course Website: www.montgomerycollege.edu/~ggrinber |
Office Hours: M 5:20pm-6:20pm W
11:00am-12:00pm R
11:00am-12:00pm |
|
Semester: Spring
2007 |
Course CRN: 33404
|
|
Class time: M
6:30pm-9:10pm |
Class location:
HU319 |
|
Class starts: 01/22 |
Class ends: 05/10 |
|
MidTerm: M, March 5th |
Spring Break March
12th – 18th |
|
Final Exam: May 7th 7:15-9:15pm |
Last date for a
refund: Jan 28th |
|
Last date to drop
without a grade or to change from audit to credit
or from credit to audit: Feb 11th |
Last date to drop a
class with a W grade: April 15th |
This course covers the
concept, design and components of Oracle Database. Involves the creation of
tables,
defining
transactions, basics of SQL, basics of PL/SQL, data types, backup and recovery,
and querying the database with SQL.
A
grade of C or better in CS 140 or consent of department
Upon the successful
completion of this course, the student will be able:
·
Describe the basic architecture and
components of the Oracle system
·
Understand the major tasks and steps
of the database design
·
Work with Oracle SQL*PLUS
environment
·
Gain the hands-on experience with
the Oracle database management system
·
Create, modify, and drop database
tables using Data Definition Language
·
Enhance the database integrity by
designing and utilizing database constraints
·
Use Data Manipulation Language to
insert, update, and delete records
·
Develop queries and SQL scripts
using basic record retrieval commands
·
Execute and test SQL and PL/SQL
statements in SQL*PLUS environment
·
Run Oracle Forms applications and
Reports
·
Control database transactions using
transaction control commands
· Introduction to the Oracle system and its major
components
· Database Concepts, Data Model, and Entity
Relationship Diagram
· File System vs. Database System
· Relational database Model vs. Object oriented
database Model
· Architecture of the Oracle Database Management
System
· Database Design Concepts and Techniques
· Oracle SQL*Plus basics
· Fundamentals of Structured Query Language (SQL):
Data definition commands, Data Manipulations commands,
Data Control commands
· Join queries and sub-queries
Oracle 9i: SQL with an Introduction to PL/SQL, by
Lannes L. Morris- Murphy, Course Technology, ISBN
061906475-7
Tardiness: Class begins promptly at the scheduled time. Students are expected to be ON TIME.
Final Grade:
Midterm Examination 20%
Final
Examination 20
%
Quizzes 10
%
Assignments
&Term Project 50 %
90 - 100 A
80 - 89 B
70 - 79 C
60 - 69 D
Below 60 F
· Assignments will be submitted by WebCT.
Late programs will not be accepted.
·
To facilitate grading, please follow
these rules when turning in assignments:
· No food or drink is permitted in any
· You are responsible for all work missed, and for
meeting assignment due dates when absent. Please call or email your instructor
if you are going to be late or absent.
· You are strongly encouraged to contact your
instructor at home by phone or e-mail if you are having difficulties, or have
any questions about assignments.
· All assignments are expected to be the result of
your own efforts, not the collaboration with others. Plagiarism or turning in
an assignment, which is essentially identical to that of another student, will
result in a zero for that assignment, with no opportunity to make up the grade.
A
student must accept responsibility for his/her decision to remain in a class
against the advice of the instructor.
All students in a course are responsible for completing the course requirements,
and faculty members are responsible for assigning grades that reflect student
accomplishments with respect to the standards set for the course.
Student Attendance: Academic Regulation 9.823 states:
Students are expected to attend all class
sessions.
“Excessive absence” is
defined as one more absence than the number of classes per week during a fall (with the number of absences
to be prorated for accelerated sessions).
In cases involving
excessive absences from class, the instructor may drop the student from the
class (resulting in a grade determined in accordance with regulation
9.645). If excessive absence from the
course takes place after the deadline to drop a course, the instructor may
record a grade of “F.”
If the student who is
registered for audit is dropped by the instructor, the grade of "W"
shall be recorded.
It is important that you attend every class. You will be responsible for all work assigned
whether you are present or absent.
Missed
Tests and Quizzes: Tests are announced far in advance. As a rule:
NO MAKEUPS without a doctor's excuse. If the final exam is not taken, the student will receive a grade of F
for the course.
Policy on Academic Integrity: Cheating, plagiarism and/or other forms of
academic dishonesty will not be tolerated. Refer to the Code of Conduct.
Each student, as an active participant in the
*The Montgomery College Student Code of Conduct
permits an instructor to assign either an “F” on an assignment or an “F” in the
course for academic dishonesty.
Student
Conduct: Students are expected to abide by the Code of
Conduct :
In order for learning to occur, it is necessary that the classroom
environment be one of mutual respect. If
a student behaves in such a way that 1) demonstrates a lack of respect, 2)
interferes with the educational process or 3) violates the Student Code of
Conduct, instructors are responsible for advising the student of the
inappropriate behavior and granting her/him an opportunity to correct it. A student who fails to correct this behavior
will be asked to leave the class and will be subject to disciplinary action, as
outlined in the Montgomery College Student Code of Conduct.
For a complete statement of Academic Regulations and Student Code of
Conduct visit:
http://www.montgomerycollege.edu/departments/academicevp/Student_PandP.htm
Audit
Policy: Academic Regulation 9.613 states:
Students wishing to register for
audit at the beginning of the semester or who wish to
change from
credit must do so prior to completion of 20 percent of the duration of the
course.
The grade of “AU” carries no credit.
Students initially registering for
audit are not required to get an instructor’s signature.
Students wishing to change from
credit to audit must obtain written approval from the
instructor. (See AR 9.614 for students wishing to change
from audit to credit.) All
students
registered for audit are required to consult with the instructor before or
during the
first class
session in which they are in audit status and are required to participate in
all
course
activities unless otherwise agreed upon by the student and instructor at the
time of
consultation. Failure to consult with the instructor or not
participate may result in the
grade of “W”
being awarded. This action may be taken
by the instructor by changing the
“AU” to “W” on the
final grade sheet.
Change from Audit to Credit 9.614 states:
A
student registered for Audit (AU) may change to credit before the completion of
20 percent of the duration of the course provided the student has written
approval of the instructor.
Statement
on Disabilities: All classes offered at
“Any student, who may
need an accommodation due to a disability, must provide a letter from
Disability Support Services authorizing the accommodations. Any student who may need assistance in the
event of an emergency evacuation must notify the Disability Support Services
office. http://www.montgomerycollege.edu/Departments/dispsvc/
Students with mobility
disabilities depend on the elevators to get to class. Please use the stairs if you are able to do
so.
There are labs available for student use--to complete
homework assignments, or for extra practice.
The software used in this class has been installed in the Computer Labs.
For more information about the computer labs, visit their Website at: http://www.mc.cc.md.us/Departments/InTechRV/
Occasionally it is
necessary for a student to take a test in the
Please turn beepers or cell phones off during the class period.
Occasionally it becomes necessary to delay the opening of school, send
students home early, or close the College entirely because of bad weather. Area radio stations broadcast information
about school closings or delayed openings beginning around
The Montgomery College Website should also have announcements posted.
http://www.montgomerycollege.edu/
Emergency Management Procedures
In the event of emergency situations involving
Detailed emergency response plans are in place
for each of
The College has published a Quick
Reference Guide, with basic information on these emergency procedures. It
includes an explanation of the communication alert codes utilized by the
college, key phone numbers, tips on what to do in the event of various types of
emergencies, and specific evacuation plans for individual college facilities.
Members of the college community are urged to familiarize themselves with this
information and to keep a copy of the guide handy.
For more information about emergency procedures, visit the College
Website at: http://www.montgomerycollege.edu/news/emergency/
|
Date |
Ch |
Topics |
PP |
|
01/22 |
1 2 |
Oracle overview Architecture, Database objects, Installation Writing Select |
Getting Started Les01 Les02 |
|
01/29 |
3 |
Restricting and Sorting Data |
Les03 |
|
02/05 |
5 |
Single-Row Functions |
Les04 |
|
02/12 |
4 |
Displaying Data from Multiple Tables Aggregating Data Using Group Functions |
Les05 |
|
02/19 |
7 |
Subqueries |
Les06 |
|
02/26 |
7 |
Multiple-Column Subqueries |
Les18 |
|
03/05 |
|
Midterm Exam |
|
|
03/12 |
|
Spring Break |
|
|
03/19 |
14 |
Producing readable Output with SQL*Plus |
Les08 |
|
03/26 |
8 |
Table Creation and Management |
Les10 |
|
04/02 |
9 |
Constraints |
Les11 |
|
04/09 |
10 |
Manipulating Data( DML) INSERT,UPDATE, DELETE, COMMIT,
ROLLBACK |
Les09 |
|
04/16 |
11 12 |
Creating View, Other DB objects, Sequence |
Les12 Les13 |
|
04/23 |
13 15 16 |
Controlling User access Backup and Recovery, PL/SQL |
Les14 |
|
04/30 |
|
Oracle Forms, Oracle Reports, Export/Import Review Course |
|
|
05/07 |
|
Final Exam Time: 7:15pm –
9:15pm |
|