House Bill 2504 Spring 2011 Course Syllabus ITSE-1345-01 (Intro Oracle SQL)
Spring 2011 Course Syllabus
ITSE-1345-01 (Intro Oracle SQL)
|Instructor||Schipplein, Patricia Lynn|
|Course ID #||10188|
|Course Title||Intro 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.|
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.|
3 assignments per chapter including Topic Review, Question Review, programs for a total of 30 daily grades
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
Subqueries and merge statements
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.
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||
Class Assignments : 20%
Final Exam: 20%
|Final Exam Date||May 16, 2011 - 10:00 AM|
Copyright ©2010 Lamar State College - Port Arthur. All Rights Reserved.