CIS 50 - Introduction to Computer Information Systems

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.

Fall 2017Page: 1