CIS 9002 - ORACLE SQL: Database Design and SQL Programming
DE1: CRN # 21187Debbie J. Fields, Office: 2109
Office Hours: by apportment, please email me with date/day/time
DE1 class is entirely online
Email:
(when emailing instructor, typeCIS9002 in the subject,your name in the content of the email message)
Course webstieon Canvas:
Oracle website: ilearning.oracle.com/ilearn/en/learner/jsp/login.jsp?site=OracleAcad ,
Instructor website:
COURSE DESCRIPTION: Initial course of the OracleAcademy @ Las Positas College. The OracleAcademy educates students on the fundamentals of database design and SQL programming and provides them with the necessary skills to pursue academic and professional opportunities. Students analyze case studies to identify patterns and connections between information not obviously related and to develop solutions to make a business effective. Students become proficient business analysts, and technical experts in structured query language (SQL), and develop essential "professional skills" including teamwork, project management, presentation and interviewing techniques. In this course students gain an understanding of relational databases through the powerful Structured Query Language (SQL). Introduction to Oracle’s newest Structured Query Language used in creating, querying, manipulation, and controlling access to the data in a relational database. The SQL commands, functions, and operators supported by Oracle as extensions to standard SQL are emphasized. Students learn to create and maintain database objects such as tables, indexes, views, constraints, and sequences. Students practice SQL using SQL Workshop, an application that is available via a web browser in Oracle HTML DB. Prepare students for the Oracle Certified Professional (OCP) exam.
STUDENT LEARNING GOALS:The successful student will;
transform business requirements into an operational database;
create physical relational database tables to implement a database design;
manage a business project that delivers a database design and model for a potential client;
create, maintain, and manipulate database objects;
prepare for Introduction to Oracle 11g - SQL Certification exam;
write SQL SELECT statements that display data from single or multiple tables;
understand the physical and logical storage of the database, manage space allocation and growth;
create and manage tables views, constraints, synonyms, sequences, and indexes;
restrict, sort, aggregate, and manipulate data using both single and group functions;
REQUIRED TEXT/MATERIALS:
- OracleAcademy Curriculum - free, interactive web-based online curriculum hosted by Oracle, and Oracle Application Express (APEX) free, online programming environment hosted by Oracle
- Recommended: Any good SQL reference book
- Introduction to Oracle10g SQL Study Guide, by Chip Dawes, Sybex publisher
COURSE FORMAT: For a typical 17-week semester this class will meet for 3 lecture hours and 1.5 computer lab hours each week. For every hour in class, students should expect 2 hours of preparation.
ATTENDANCE:is expected. In an online class, attendance will be defined as regular and timely participation in assignment activities as judged by the instructor. Students may be dropped, see student DROP POLICY
DROP POLICY: The instructor may drop students who miss the first meeting of a course. The first meeting of online or hybrid Distance Education courses is the first day of the class as specified in the class schedule listing. For these courses, instructors may drop students who do not login to their Canvas course and/or complete indicated activities by the third day of class. In addition, an instructor may initiate a drop if the student is absent for a total of four (4) consecutive or six (6) cumulative instructional hours and/or two (2) consecutive weeks of instruction.” If you choose to withdraw from this course, it is your responsibility to do so within the university's deadlines.
Since this course is online, it is important for the student to communicate with the instructor on a weekly basis - submitting assignments, taking quizzes, or sending email. If I see that a student is not keeping current, I will drop the student. Keep in touch with the instructor, do not get dropped.
ACADEMIC HONESTY: All work that you submit in this course must be your own, it is a violation of academic integrity to copy someone else's work or to permit another person to copy your work. At no time is it acceptable for you to share your solutions to the homework assignments with other students, whether these solutions are complete or partial. Any similarity in form or notation, the instructor retains the right to give a failing grade for the assignment, exam, and/or course.
Please familiarize yourself with LPC's policy on academic dishonesty. It can be found, among other places, at Academic dishonesty (cheating and plagiarism) will not be tolerated. Students found cheating (fraud, deceit, or dishonesty in an academic assignment) and/or plagiarizing (using another’s work as your own) will receive a zero for the assignment or exam and the incident will be reported to the dean of student services.
GRADING:The final grade for this course is based on cumulative points earned as follows:
- Quizzes 0%-use the quizzes to study for the exams
- 2 Midterms Exams/2 Final Exams60%
- Lab Assignments 40%
The letter grade will be assigned on the following basis.
- 90-100% ‘A’ work is clearly excellent, all work completed as assigned on time, in a superior manner
- 80- 92% ‘B’ work is consistently good and above average, all work is submitted by the due date
- 70- 79% ‘C’ work is acceptable and average, minimal requirements are all met on time
- 60- 69% ‘D’ work is below average, due dates not always met, class partiticpation is not consistent
- Below 60% - ‘F”
WEEKLY TOPICAL OUTLINE & ASSIGNMENTS: Assignments are due on Friday (unless otherwise stated). You can submit assignments
- via email. Email must be received in my email in-box on/before due date
Late assignments are only accepted within one week of the due date. 50% of the maximumpossible score will be subtracted for all late assignments. Assignments submitted more than one week late will not be graded. Quizzes, mid-term and final exams are available throughout the semester. Class syllabus and mid-term/final exam dates are approximate and subject to change.
IMPORTANT DATES:
SYLLABUS and SCHEDULE CHANGES: I have tried to make this document as complete as possible; however, during the course of the semester I may be required to alter, add, or abandon certain policies/assignments. I reserve the right to make such changes as they become necessary. You will be informed of any changes.
CIS 9002 ( CRN#21187) starts August 16WEEKLY TOPICAL OUTLINE & ASSIGNMENTS: Class syllabus, assignments, and quiz dates are approximate and subject to change Course outline and assignments for: CIS 9002 starts August 16.
See Modules section in Canvas for details.
Date / Reading/Lecture Topic / Labs, Assignments / Quiz
Wednesday, August 16 – Class begins
WK1: 8/16 / Canvas,
Review Syllabus
Login to Oracle iLearning, username/password
Login to APEX
Download, unzip, upload .sql file to APEX, run script
SolveITwithSQL
DB Design – Section 0, Course Resources – Student
DB Design – Section 1: Introduction / -Canvas login
-Syllabus
-Oracle iLearning login
-Oracle APEX login
HW1
WK2: 8/21 / DB Design – Section 2: Entities & Attributes
DB Design – Section 3: Relationship Basics / HW2
DD Lab: Section 1
DD Lab: Section 2
DD Lab: Section 3
WK3: 8/28 / DB Design – Section 4: Super/Sub Types, Business
DB Design – Section 5: Relationship Fundamentals / DD Lab: Section 4
DD Lab: Section 5 / use quizzes to study for midterm and final
Sunday, August 27 – Last day to add class or drop class with NGR
Monday, August 28– Census
WK4: 9/4 / DB Design – Section 6: UIDs, Normalization
DB Design – Section 7: Arcs, Hierarchies, Recursive / DD Lab: Section 6
DD Lab: Section 7 / DB DESIGN: Mid Term Exam
Sunday, September 10 – Last day to apply for Pass/NoPass (P/NP)
WK5: 9/11 / DB Design – Section 8: Changes & Historial Modeling
DB Design – Section 9: Mapping
DB Design – Section 10: Creatinbg Database Projects / DD Lab: Section 9 / DB DESIGN: Final Exam
WK6: 9/18 / DB Program – Section 0, Course Resources – Student
DB Program – Section 1: Introduction / DP Lab: Section 1
WK7: 9/25 / DB Program – Section 2: SELECT and WHERE / DP Lab: Section 2
WK8: 10/2 / DB Program – Section 3: WHERE, ORDERBY, Intro to Functions / DP Lab: Section 3
WK9: 10/9 / DB Program – Section 4: Single Row Functions Part I
DB Program – Section 5: Single Row Functions Part II / DP Lab: Section 4
DP Lab: Section 5 / use quizzes to study for midterm and final
WK10: 10/16 / DB Program – Section 6: Joins Part I
DB Program – Section 7: Joins Part II / DP Lab: Section 6
DP Lab: Section 7
WK11: 10/23 / DB Program – Section 8: Group Functions Part I
DB Program – Section 9: Group Functions Part II / DP Lab: Section 8
DP Lab: Section 9
WK12: 10/30 / DB Program – Section 10: Subqueries
DB Program – Section 11: Ensurng Quality Queries Part 1 / DP Lab: Section 10
DP Lab: Section 11 / DB PROGRAMMING: Mid Term Exam
Sunday, November 5 – Last day to withdraw
WK13: 11/6 / DB Program – Section 12: DML
DB Program – Section 13: DDL / DP Lab: Section 12
DP Lab: Section 13
WK14: 11/13 / DB Program – Section 14: Constraints
DB Program – Section 15: Views / DP Lab: Section 14
DP Lab: Section 15
WK15: 11/20 / Thanksgiving Break: no class Wednesday, November 22 thru Saturday, November 25
WK16: 11/27 / DB Program – Section 16: Sequences & Synonyms
DB Program – Section 17: Privileges & Reqular Expressions / DP Lab: Section 16
DP Lab: Section 17
WK17: 12/4 / DB Program – Section 18: TCL
DB Program – Section 19: Final Project & Exam Review
DB Program – Section 20: Ensurng Quality Queries Part 1I / DP Lab: Section 18
DP Lab: Section 19
DP Lab: Section 20
WK18: 12/11 / All mid-terms and final exams must completed by Sunday, December 17 / DB PROGRAMMING: Final Exam
Finals Week
See Canvas calendar for due dates on assignments, quizzes, final exam
Friday, Tuesday, December 12– Last of instruction,
Wednesday, December 13 – Finals begin
Final Exam is scheduled: MUST COMPLETE FINAL EXAM BY Sunday, December 17
Fall 2017Page: 1