SCC - Computer Programming and Analysis: Instructor Dick Grant COP2702 Oracle SQL & PL/SQL Syllabus

Home A.S.Degrees Tech Certificate Courses Professors Certifications Labs

COP2702 Intro to SQL Syllabus

I reserve the right to change this syllabus at any time.

Instructor:	Dick Grant
Phone:	407-328-2055
	Office Hours
Office:	V102F Sanford
Email:	grantd@scc-fl.edu
Textbook:		Oracle 10g: SQL by Joan Casteel ISBN 13: 978-1-4188-3629-0 ISBN 10: 1-4188-3629-X This book contains a CD with Oracle 10g. Visit the SCC Bookstore online.

Course Description

Course Objectives

Attendance

Grading

Projects

Exams

Questions

Withdrawals

Academic Integrity

Emergency Notification

Class Schedule

Welcome Letter

Course Description:

This course covers the concepts of a relational database and the industry standard Structured Query Language (SQL). In addition, it prepares students for the Introduction to Oracle: SQL certification exam from Oracle Corporation. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. This is not an introductory course. The prerequisite is CGS2540C Database Management or instructor permission.

Course Objectives:

Upon completion of this course, the student will be able to:

write and execute simple Structured Query Language (SQL) statements.

create arithmetic statements using SQL.

select data from a relational database using specified criteria and present the data in a sorted sequence.

use predefined SQL functions.

retrieve data from multiple tables in a relational database.

create and execute subqueries.

format output retrieved from a relational database.

update data in a relational database by using data manipulation statements.

create and manage tables including keys, indices, and constraints.

create and use views and sequences.

control user access via privileges, passwords, roles.

use Oracles date and time routines.

use hierarchical retrieval statements

Attendance:

Students taking this course on campus:

Attendance will be taken at each class meeting. No part of your final grade depends directly on attendance. However, your attendance is critical for success in this course. It is college policy that the instructor may withdraw a student who has missed 10% or more of the scheduled class meetings.

When this course is offered on campus you can optionally "attend" class electronically via the Internet. Students taking this option do not need to attend campus classes. To "attend" class you must accomplish the following items. I will withdraw you from class automatically if you fail to meet any of these requirements.

Complete the check in process before the end of the first week of class. Inform me you will be taking the class online.

Log in to the Angel course site at least once every two weeks.

Substantially complete and submit assignments. I will automatically withdraw you from class if you fail to substantially complete and submit any two consecutive assignments.

Exceptions to the above are granted under extraordinary circumstances such as illness, military commitments, or religious holidays.

Grading:

Category	Points	Pct of Grade
Chapter Assignments	270 points	62%
Midterm Exam	100 points	19%
Final Exam	100 points	19%
Total	470 points	100%

Final letter grade will be assigned based on the percentage of total points the student earns.

Percentage of Points	Grade
90% and up	A
80% - 89%	B
70% - 79%	C
60% - 69%	D
Below 60%	F

Projects:

It is important for you to complete the chapter assignments in a timely manner. Each chapter project builds upon the work completed in earlier chapters. Projects are due at the end of the week on the dates indicated on the syllabus. That is, I must have an email from you with the assignment attached before midnight on the last day of the week indicated. The maximum score attainable will be reduced by 50% if I receive your project after that point in time but before midnight on the same day of the following week. Projects handed in more than 1 week late will receive a score of zero points. The exact due date of assignments are listed in the course calendar in Angel and the syllabus distributed in class.

You may not turn in the same project more than once. If a project has multiple parts (for example parts A and B), you must turn in all parts at the same time. You cannot turn in one part one week and the other part another week.

Graded projects will be returned to you via email within one week after the due date or within one week after your submission - whichever is later. Your grade for the project will be included in the returned project. Grades are posted to a grade book available to you. You should regularly check this grade book to monitor your progress and class standing. The grade book is accessible from a link on the class home page.

Exams:

If you are taking this class online, you will take the midterm and final exam via the Internet. There is no component of the exams that require you to be on campus. If you are taking this class on campus, you can take the exam on campus or via the Internet. The exact due date of exams are listed in the course calendar in Angel and the syllabus distributed in class. Exams completed after the due date will receive a grade of zero. Only under emergency situations will you be able to make up a missed exam without prior approval. I require written documentation to support any request to take an exam outside the normal schedule.

Exam grades are posted to a grade book available to you. You should regularly check this grade book to monitor your progress and class standing.

Questions:

Your willingness to ask questions will be one of the biggest factors in your success in this class. In addition to questions in class (for campus classes), you can post questions to the course Angel bulletin Board. Check this bulletin board first to make sure your question has not already been asked and answered. If it has not asked, post your question to the bulletin board. I monitor the bulletin board throughout the day on Monday through Fridays. Other students may also answer your question. Feel free to email me directly if you have a question and you are uneasy about asking that question on the bulletin board or in class. I check email several times a day Monday through Friday. You may also make an appointment to meet with me in person if necessary.

Withdrawals:

You may withdraw from class by visiting the registration office at the Sanford/Lake Mary or Oviedo campus. The deadline to withdraw is usually the point when 70% of the class has been completed. After that deadline only I can withdraw you from class. You must send or fax a written notice to me if you miss the deadline to withdraw. If you run into problems and are unable to complete this course, I expect you to administratively withdraw from the class. Students who fail to withdraw will be graded with zeroes for the incomplete assignments and exams. Only under the most extreme emergency circumstances should you ask me to change your status to withdraw after grades are submitted. I will required written documentation for the request.

Academic Integrity:

I expect all your work in class to be your original work. Obtain my approval first if you think you need to "borrow" code from a book, the internet, a coworker, or anyone else. Do not give a copy of your project or any part of your project to another student. All people involved will be given a zero on that assignment with no means to make up the grade if the academic integrity policy is violated.

A second instance of cheating will result in a failing grade for the course for all those involved. You should also review the policy on academic integrity in the student handbook.

Emergency Notification:

In case of emergency conditions, verify the college is open and classes are being held by calling 407-328-2290 or 407-328-4277. The SCC website home page features updated announcements.

Class Schedule:

Please complete the class check in process prior to 1/11/2008 at 4:00 pm if you plan to take this course online. This is the add/drop deadline. The check in process is described in this welcome letter. Below is the class schedule. After you check in, your userid and password will allow you to access all class materials. I suggest you follow the class schedule in sequence. Do not fall behind. The topics for bulletin board discussion will be those listed below during the weeks indicated. The assignments are due by midnight on the last day of the week indicated. The exact date is listed in the class calendar. Week 1 listed below begins Wednesday, 1/9/2008 and ends Tuesday, 1/15/2008. The exact dates for each topic and assignment will be distributed with the syllabus at the first class meeting if you are taking this class on campus.

We will meet Wednesday evenings from 6:30 to 9:15 if you are taking this class on campus. Your assignments will also be due on Tuesday evenings by midnight. For example, the week 1 assignment must be completed by Tuesday 1/15 at midnight.

Week #	Topic	Assignments Due
1	Chap 1 Overview of Database Concepts Chap 2 Basic SQL SELECT Statements	Chapter 1 Quiz Chapter 2 Assignment
2	Chap 3 Table Creation and Management	Chapter 3 Assignment
3	Chap 4 Constraints	Chapter 4 Assignment
4	Chap 5 Data Manipulation and Transaction Control	Chapter 5 Assignment
5	Chap 6 Additional Database Objects	Chapter 6 Assignment
6	Chap 7 User Creation and Management	Chapter 7 Assignment
7	Midterm Exam (Chapters 1 - 7)	Midterm Exam
8	Chap 8 Restricting Rows and Sorting Data	Chapter 8 Assignment
9	Chap 9 Joining Multiple Tables	Chapter 9 Assignment
10	Chap10 Selected Single-Row Functions	Chapter 10 Assignment
11	Chap 11 Group Functions;	Chapter 11 Assignment
12	Chap 12 Subqueries and Merge	Chapter 12 Assignment
13	Chap 13 Views	Chapter 13 Assignment
14	Chapter 14 Formatting Readable Output	Chapter 14 Assignment
15	Final Exam (Chapters 8 - 14)	Final Exam