Oracle and SQL (CIS150)
Professor: Priscilla Grocer
Email: Priscilla.Grocer@bristolcc.edu Check with me about
other email address to use for homework.
Course Description (from catalog):
This course is an introduction to the Oracle database. The student will learn to work with Oracle
and the structured query language SQL as they design, manipulate and access the database. In addition,
the concepts and design of relational databases will be analyzed and implemented.
The primary objective of this course is to teach the student to work with Oracle both in the
development of the database and the use of SQL and PL/SQL. Students who successfully complete Oracle
and SQL will be able to:
- Understand the concepts and logic behind the development of a normalized relational database
- Work with a basic set of data and an analysis of the data needs to create a normalized relational database.
- Create a database and tables with keys to store and maintain data.
- Generate SQL to query and maintain the database with a wide variety of criteria.
- Use the structured query language SQL to access information in one or more tables within the database.
- Write code using the Oracle Procedural Language SQL (PL/SQL) to enable the handling of more complex data manipulation problems.
There are two texts that I have used and found helpful. I would recommend that you consider getting
one of them. These are simply recommendations, not requirements.
Oracle9i: SQL with an Introduction to PL/SQL
Lannes L Morris-Murphy
Oracle Database 11g SQL
You can choose to download Oracle for use on your computer or use the school's version. We are
using Oracle 11g.
Material to be Covered: The order in the syllabus does not necessary reflect the order that
will used in the course. Please use the weekly schedule sheet to follow the assigned topics.
- Relational database
- Entity Relationship model
- Object orientation
- Introduction to Oracle
- Introduction to SQL
- SQL statements in Oracle
- Basic SQL statements
- Arithmetic expressions
- Introduction to SQL
- Limiting and Sorting data
- Using multiple tables
- Grouping functions
- Simple subqueries
- Multiple column subqueries
- Additional features
- Updating - add, changes and deletions
- Manipulating data
- Creating and maintaining tables
- Database objects and indexing
- More advanced features of Oracle and SQL
- Controlling access
- PL/SQL structure
- Writing executable code
- SQL and PL/SQL
- Control structures
- For loop
- While loop
- Composite data types
- Working with cursors
- Processing with multiple cursors
- Procedures and functions
Requirements and Grading:
The student will be expected to complete all assigned work. In
addition there will be a final exam. A schedule of assignments, projects, exams, quizzes etc. will
be posted on the Web site. Students should check on a regular basis.
- 80% Homework, programs, code and quizzes
- 10% Class participation, responsibility about work, keeping up to date, quality of work, adding
extras that are above and beyond, showing initiative, figuring out problems etc.
- 10% Final
Your committment: For each hour in class, you should plan to put in 2 to 3 hours outside of class so you
need to recognize that committment and include it in your planning.
Below there is a TENATIVE schedule of homework based on previous semesters that will give you an idea of what you need to
accomplish to be successful in the class. You are also required to read the chapters in the book and do outside
research as assigned.
||Introduction Oracle assignment
||Second Oracle assignment, quiz
||Oracle quiz, function assignment
||Oracle quiz, multiple tables and subqueries
||Views and reports in Oracle
||Oracle keys assignment
||Oracle PL/SQL Intro quiz, PL/SQL decision assignment
||Loop assignment, quiz
||scripts and programs in PL/SQL
||PL/SQL problems to write and execute
||Procedure, function assignment
||Prepare for final
||Final exam and status sheet required
It is very important that you let me know if you are having problems so we can work out a plan. I set up help
sessions you can attend every week and I also am available for help via email. Please take advantage of my
availability and don't let yourself get behind! I truly want to see you succeed!
Assignments, programs and exams are graded using either number grades or letter grades based on the
following (A=90-100, B=80-89, C=70-79, D=60-69, F=below 60). The student's grade for the course will
use the same scale and will be based on the percentages explained in the grading section. Plus and
minus grades will be given.
Many of the assignments in this class are open ended - the grading will be based on how well the
project demonstrates mastery of the material. Students who do a minimum of work will be graded
accordingly. Assignments are only accepted if they are credible work and meet the minimum
requirements and standards for that assignment. Assignments that are not accepted can be resubmitted.
Resubmission is allowed on graded assignments, with permission of the instructor. You cannot earn
an A+ on an assignment that is resubmitted. The instructor will only accept, without penalty,
resubmissions on credible work. Resubmissions must be done within a week to avoid additional
penalties for late assignments.
Note: To achieve an A+, on open-ended assignments, students must have done sufficient extra work in
development or implementation tot make the assignment standout. In doing assignments, students must
do their own work. Relying too heavily on my examples or working too closely with someone else will
Assignments are due the week after they are assigned. Late assignments will be penalized. The 10%
of the grade that deals with responsibility and involvement will loose points from late assignments.
For purposes of this class, the week will end at midnight on Thursday.
Attendance: Attendance is based on email communication. Students must report their status
once a week. This report can be combined with the submission of an assignment.
This course is offered as an in class course or as a Distance Learning,
course or as a course where the student can put together there own combination of in class and
online participation. For in-class students, it is a combination of lectures and interactive
projects with supplementary information available on the Web. Web based students will be relying on
the information at the Web site for the information being presented in class with interaction
through a variety of online techniques. Web based students are invited to attend class at any time
if they feel that hearing a lecture would be valuable. Lectures are recorded and put online and
Smartboard notes are captured and put on line. All students should read the assigned notes, study
the presentations available and avail themselves of other resources at the web site in mastering
the course material. In addition, students will be working independently on projects designed to
give them additional computer skills and practical experience in analyzing and solving problems.
When appropriate, exercises and problem solving techniques are used. This syllabus is not to be
construed as a contract in any way, shape, manner or form. This syllabus contains a suggested
course outline and will be generally followed, subject to change according to the instructor's
discretion and needs. Academic flexibility is important!
Bristol Community College Withdrawal Policy:
Students are responsible for withdrawing officially if they stop attending any or all classes. Faculty no longer have the ability to withdraw a student from a class. A
grade of "F" will be assigned to any student who stops attending a course but does not officially withdraw. Students are encouraged to meet with an advisor before making any changes
to their schedule. Withdrawals effect Satisfactory Academic Progress and can place the student at risk for academic probation or dismissal. Students who use financial aid and who
subsequently withdraw may be required to return some or all funds received. Withdrawals are accepted until the tenth week of classes. Students may withdraw online in accessBCC,
in person at any Enrollment Center, or via their college email to firstname.lastname@example.org. Email requests must come from the student's BCC college email address and must
include the student's name, BCC student ID number, and course information (CRN, course and section number). Email from non-college accounts will not be accepted. If a student
officially withdraws after the third week of classes, there will be no tuition or college fee refunds. For more information, see the College Catalog at:
http://bristolcc.smartcatalogiq.com/en/2017-2018/Catalog/Academic-Information/Withdrawal-Policy-and-Procedure. Students with questions should contact Enrollment Services via any of
the methods mentioned above or at 774-357-2590.
This is an asynchronous course with synchronous components if you
decide to attend classes. Communication includes email , blog, IM including voice, and online
office hours and help sessions. Other methods of online communications may also be used. In
addition open lab help session are scheduled and students may request in person meetings.
Students must communicate with the instructor at least once a week via email and must turn in
homework and participate in online communication to be successful.