Instructor Renuka Kumar, Associate Professor
School of Applied and Information Technology
Office Location: Essex N 334 (enter through N 313)
7201 Rossville Boulevard, Baltimore, MD 21237
Office Phone Number: 443-840-1630
Department Phone Number: 443-840-2215; Fax Number: 443-840-1485
Email address: rkumar@ccbcmd.edu
Office Hours: Monday & Wednesday
8:00 - 9:00 am and 10:00 - 11:30 am.
Course Description
Introduction to SQL Using Oracle provides
an introduction to the Oracle relational database, structured query language and
database concepts. Students will create tables, establish relationships,
enforce integrity constraints and manipulate data. Additional database objects,
database security, transaction control, and user creation and management will
also be introduced.
Course Objectives
Upon completion of
this course the student will be able to:
1. explain oracle database
concepts and terminology;
2. utilize Oracle client
software;
3. analyze database
structure;
4. execute and modify SQL
(Structured Query Language) select statements;
5. upload and execute SQL
scripts;
6. define database object
types;
7. create and modify tables;
8. create and use sequences;
9. create and use indexes;
10. implement and modify
constraints;
11. create views;
12. develop effective
security policies;
13. create and manage users;
14. analyze performance
handling;
15. develop subqueries;
16. query the data
dictionary;
17. manipulate data using
single-row and group functions;
18. collaborate with group
members; and
19. assess
database vulnerabilities.
Books
Oracle
11G: SQL, 2nd Edition
Joan Casteel ISBN-10: 1439041288 ISBN-13: 9781439041284
640 Pages Paperbound
© 2010 Published
Course Requirements
You will have weekly Assignments
and Quizzes for this course. You will also be required to complete a Midterm
and a Final Exam. Points are allocated according to the following scale:
|
Assignments |
130 |
|
Chapter Quizzes |
130 |
|
Midterm Exam |
120 |
|
Final Exam |
120 |
|
Total Points |
500 |
The following grade
scale will be used to determine your semester grade:
|
Grade |
Points |
|
A |
450 or more |
|
B |
400 - 449 |
|
C |
350 - 399 |
|
D |
300 - 349 |
|
F |
below 300 |
Course Policies:
This is an online
distance learning course. We do not meet in a traditional face to face
classroom setting. You do not need to come to the college except to take the Final
Exam during final exam week or to meet with the instructor during posted office
hours (see Instructor Information page).
Students must complete
all course requirements in the appropriate sequence and in a timely manner as
posted in the Content folder. You should visit the Blackboard online classroom
every day to check mail, read announcements and discussion board postings and
complete assignments and quizzes.
Announcements
This is the tool that I
will use to communicate with you as a class. Any updates, changes, errors,
notices, reminders etc. will be posted in Announcements. You will see the
current Announcements listed under the Course Name every time you log into
Blackboard.
You are responsible for
reading all announcements posted by the instructor. Check announcements each
time you log in to Blackboard making sure to read all announcements posted
since the last time you logged in.
Communication
The best way to
communicate with me is through Blackboard email. If you do not have access to
Blackboard you may contact me through my office email at rkumar@ccbcmd.edu . Please be sure to
reference your class and section, for example, CSIT 156 WEI. Except for
Saturdays, Sundays and holidays I will normally respond to email within 48
hours.
You may also post your
questions to the Blackboard Discussion Board. General questions should be
posted under the Cyber Cafe topic heading.
Discussion Board
Participation in online discussions
is recommended. The purpose of the discussions is to stimulate study and
discussion of the weekly reading assignments. For each chapter reading you
should post your questions and observations on the discussion board under the
SQL Textbook topic. General questions should be posted under the Cyber Cafe
topic.
Solutions to the End of
Chapter Multiple Choice questions in the textbook have already been posted on
the Discussion Board. Solutions to the Hands-on Assignments will also be posted
here 7 days after the due date. Be sure to compare your work with these
solutions.
Assignments
All assigned exercises
must be completed as assigned and submitted according to the due date. See the
Course Schedule for a list of the due dates. All assignments will be posted in
the Course Content folder for the week assigned. Work is assigned on a Monday
and is due by midnight the following Sunday. Late
assignments will be accepted up
to one week past the due date but only for partial credit - a 50% penalty will
be applied. Please note that
assignments will be removed from your view seven days after the due date.
Click on the assignment
name to access the submission box. You are only allowed one attempt per
assignment so make sure that your assignment is complete before you hit the
Submit button. You can always save your assignment as a Draft if you are not
ready to turn it in.
You MUST use
Oracle Application Express (APEX) to complete the assignments. For each
assignment you will need to submit the SQL used as well as the results of the
query in APEX. You can submit your screen captures in a PowerPoint file, Word
document or a file in Rich Text Format (.rtf) file. Do NOT submit Word
Perfect files - these files cannot be opened by me. A grade will not be given
if files are submitted in a format other than those outlined above. For
directions on how to Capture a Screen Image or how to Create Rich Text format
(.rtf) files using your word processing program see instructions posted in the
Student Resource folder.
Assignments are graded after
the due date and will be returned to you within 7 days of the due date. You can
review the grade received and instructor comments through the My Grades page.
All chapter assignments have a Grading Form which you should review for each
assignment to get feedback on the assignment. Solutions to the assignments will
be posted on the Discussion Board after all assignments have been graded.
Quizzes
You will be assigned a
Practice Quiz every week. All assigned quizzes must be completed as assigned and submitted according to the due date. See the Course
Schedule for a list of the due dates. All quizzes will be posted in the Course
Content folder for the week assigned. Work is assigned on a Monday and is due
by midnight the following Sunday. Quizzes completed late will be accepted up
to one week past the due date but only for partial credit - a 50% penalty will
be applied. Please note that quizzes will be removed from your view seven
days after the due date.
Chapter Quizzes are
multiple choice exams. You are allowed ONE attempt to complete the
quiz, however, you may save the quiz once started to complete later.
Feedback for the quiz will be available through the My Grades page.
Exams
You are required to take
a Midterm and a Final exam. These exams may only be taken once and must be
taken by the due date. You MUST take this exam at a CCBC Testing Center -
appointments are required. Click here to access the CCBC
Testing Center Home Page (http://www.ccbcmd.edu/testing/index.html).
No make up exams are
allowed. If you are not able to
take the exam at the Testing Center you must make arrangements for a proctored
setting and must contact be at least two weeks prior to the exam to get
approval for the arrangement.
Answers for the Midterm
and Final exam will be available for review when all students have completed
the exams.
Hints for Success
Here are some tips you
should follow which will help you to succeed in this course:
·
Set aside a specific
time each week to work on this course.
·
Keep in touch with me
and your classmates by frequently checking your course Announcements and
Messages on Blackboard.
·
Familiarize yourself
with published deadlines.
·
Ask for help when you
need it.
·
Keep up with the work.
Important Dates
Last day to drop classes with 100%
refund* January 27, Friday
Spring semester classes begin January
30, Monday
Last day for schedule adjustments February
4, Saturday
Last day to drop classes with 50%
refund* February
17, Friday
Mid-Terms (due by faculty) March
19, Monday
Spring Recess (College closed) March
31 - April 9, Saturday - Monday
College reopens, classes resume April
10, Tuesday
Last day to withdraw with
"W" or change to audit status April
10, Tuesday
Last day of classes for Spring
semester May
12, Saturday
Spring semester final examinations May 13
- 19, Sunday - Saturday
Final grades entered in SIMON by
faculty by 4:30 p.m. May 22,
Tuesday
Grades available to students in
SIMON May
29, Tuesday
College Policies
Log in to MyCCBC and
go to the MySyllabiPolicies tab to read and view the college policies. Detailed
information on the Code of Academic Integrity, writing policy, Services for
students with disabilities, and more can be found on the CCBC Student Portal
under the https://myccbc.ccbcmd.edu/Pages/Default.aspx. Additionally, Blackboard Help tutorials can be found under the
HELP tab.
Blackboard Accessibility
Blackboard, the learning
management system for this course, is in compliance with accessibility
standards.
For more information
on this topic, please visit the website :
http://www.blackboard.com/Teaching-Learning/Learn-Resources/Accessibility.aspx