House Bill 2504

Spring 2011 Course Syllabus

ITSE-1345-01 (Intro Oracle SQL)

Faculty Information
SemesterSpring 2011
InstructorSchipplein, Patricia Lynn
Phone(409) 984-6384
Business and Technology
Chair:Michael Trahan
Telephone:(409) 984-6378
Hours:10:00-11:00 MW; 10:00-12:00 F; 9:30-11:00 TR and 12:30-2:30 TR
Building:Student Center (PAMP)
Room #:405
Course Information
Course ID #10188
Course Subject-Number-SectionITSE-1345-01
Course TitleIntro Oracle SQL
Course Description Introduction to the design and creation of relational databases using Oracle. Topics include storing, retrieving, updating and displaying data using Structured Query Language (SQL).
Course Prerequisites ITSW 1307 with a grade of C or better or instructor consent.
Required Textbooks Oracle 11g SQL by Joan Casteel, Course Technology Publishers, ISBN: 978-1-4390-4128-4

1 USB flash drive to copy master files for use at home

Note: if you use a flash drive, be sure that at least a portion of your flash drive is not encrypted. You will need to save all of your data to this unencrypted section of your data drive.

All students must purchase the textbook and must have Office 2010 (preferred) or Office 2007 installed on a computer that they can use—either at home or on campus. Note: a valid Student ID is also required in order to use open lab facilities available on the campus and to gain Internet access for outside class assignments.

For Password and Login help call Kenneth Lisby, 984-6150

Learning Objectives Write Structured Query Language (SQL) statements using Oracle; select and sort data; and produce reports with SQL*Plus; create and manage tables which include constraints; create Views and other database objects.
Major Assignments 4 Tests

3 assignments per chapter including Topic Review, Question Review, programs for a total of 30 daily grades

Discussion Topics Overview of database concepts

Basic SQL select statements

Table creation and management (create, modify and drop tables)


Data manipulation and transaction control

Additional database objects

Create users and grant privileges

Restricting rows and sorting data

Joining data from multiple tables

Selected single-row functions

Group functions

Subqueries and merge statements


Attendance Policy Research has shown a cause and effect relationship between attendance and college success.


You should attend every class meeting. The instructor reserves the right to drop you from the class if you miss more than 6 hours of class.

You are allowed 3 absences per semester without a doctor’s excuse. After the 3rd absence, I will lower your final average for the class by 2 points for each absence.

Tardiness is not acceptable. You are required to be on time. Once the class is in progress, the instructor reserves the right to deny access to the classroom or impose other penalties.

Missed quizzes will each be recorded as a zero. No makeup quizzes will be given.

You are responsible for completing and submitting all assigned homework when due and for being prepared for each class meeting. This applies even if you were absent for the previous class meeting. No late homework assignment will be accepted.

Cell phones should be set to vibrate during class time. You may quietly leave the room to answer an important call if needed—be sure to return quietly as well. Cell phones may not be visible or answered during a testing period. Any violation of this rule will result in the student receiving a zero on the test.

Academic Policies:

If you are absent and miss an exam, you will receive a grade of zero unless the instructor agrees to give you a makeup exam or make other arrangements. Requests for makeup exams are granted only if you have an exceptional reason for missing an exam--such as a medical emergency or death in the family.

Only one missing exam grade may be made up. All other missed exams will be recorded as a zero. It is the student’s responsibility to initiate arrangements for a makeup. Approval for the makeup should be cleared with the instructor prior to the date of absence. If this is not possible, the student must ask for such approval the first day upon returning to class.

The format of a makeup exam often differs substantially from that of a regularly scheduled exam.

If you are tardy for any exam or quiz, you will be allowed to take the exam but you will only have the timeframe remaining in the class awarded to complete the exam. You will not be able to make up the time you missed for being tardy.

Academic dishonesty in any form will not be tolerated. Please consult the Student Handbook for consequences of academic dishonesty. These policies will be strictly enforced.

Determination of Final Grade Tests: 60%

Class Assignments : 20%

Final Exam: 20%

Final Exam Date May 16, 2011 - 10:00 AM
Campus Policies
Lamar State College - Port Arthur

Mission Statement

Lamar State College-Port Arthur is an open-access, comprehensive public two-year college offering quality instruction leading to associate degrees and a variety of certificates. The college, a member of The Texas State University System, has provided affordable, quality educational opportunities to residents of the Southeast Texas area since 1909.Lamar State College-Port Arthur embraces the premise that education is an ongoing process that enhances career potential, broadens intellectual horizons, and enriches life. The faculty, staff, and administration share a commitment to a mission characterized by student learning, diversity, and community service. The foundations for student success include compensatory education programs designed to fulfill our commitment to accommodate students with diverse goals and backgrounds, technical education programs that provide for the acquisition of the skills and demeanor necessary for initial and continued employment, and a core curriculum that develops the values and concepts that allow the student to make a meaningful contribution in the workplace or community. Student achievement is measured by the completion of courses and programs of study, successful performance following transfer to a baccalaureate program, and the attainment of individual goals.

Lamar State College-Port Arthur operates in the belief that all individuals should be:

* Treated with dignity and respect;

* Afforded equal opportunity to acquire a complete educational experience;

* Given an opportunity to discover and develop their special aptitudes and insights;

* Provided and opportunity to equip themselves for a fulfilling life and responsible citizenship in a world characterized by change.

 College Grading Scale

Below 59F

(Some specialized programs may have different grading scales)


 Academic Dishonesty

Academic dishonesty in any form will not be tolerated.  Please consult the student handbook for consequences of academic dishonesty.  These policies will be strictly enforced.


 Facility  Policies

        No food, drinks, or tobacco products are allowed in the classroom.

        Only students enrolled in the course are allowed in the classroom.

        Cell phones and/or pagers are allowed ONLY on vibrate mode. Leaving the classroom to answer a page or phone call may constitute an absence or a tardy.


 Special Considerations

         The American with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Special Populations Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241.

Copyright ©2010 Lamar State College - Port Arthur. All Rights Reserved.