WHY ARE WE STILL USING ORACLE 11G EXPRESS ?

As technology has advanced  there have been advances in Oracle releases -- -- however-- --  the more recent Oracle releases require significantly more hardware/software support - that is -- since Oracle is a business use  product  more than a home use product -- recent Oracle release require the software/hardware configuration to be "Professional" in configuration rather then "Home" configuration -- 

AND

for the purposes of this course which is fundamental in nature -- the older release is adequate  as a leaning tool

Course Description:

            Credit Hours: 3

            Classroom Contact Hours per week: 3

            Laboratory Contact Hours per week: 3

 An introduction to the design and creation of relational databases. Topics

Include storing, retrieving, Updating and displaying data using Structured

Query Language (SQL) integrated into Stored Procedures, Functions,

Packages and Triggers (PL/SQL Programming).

Course Rationale:  This course is designed to teach students how to create programmed solutions using the PL/SQL procedural language. As each student is required to have a working knowledge of the programming process and understanding of the functional constructs in programming, the focus of this course is on database problems and potential solutions.  

This course is part of the Computer Information Technology Database Certificate plan. Completion of this course and the prerequisite courses prepares the student for a position as an entry level Database Programmer and acts as preparation for Oracle Certification test 2.

Pre-requisite:  ITSE2309 (CIS2153)

Course Objectives/ Learning Outcomes:  

           Enhance the knowledge and understanding of Database analysis and design.
           Enhance the knowledge of the processes of Database Development and Administration using SQL and PL/SQL.
           Enhance Programming and Software Engineering skills and techniques using SQL and PL/SQL.
           Preparation of background materials and documentation needed for Technical

Support using SQL and PL/SQL.
           Use the Relational model and how it is supported by SQL and PL/SQL.
           Use the PL/SQL code constructs of IF-THEN-ELSE and LOOP types as well as syntax and command functions.
           Solve Database problems using Oracle 11g SQL and PL/SQL. This will include the use of Procedures, Functions,
           Packages, and Triggers.

                Instructor may add to but not delete any course objectives/Learning Outcomes 

SCANS ITEMS COMPETENCIES:  

Instructional Methodology: The course will have both lab and lecture. The student will be

required to do assigned readings from the text and handouts as well as scheduled individual labs to reinforce the material covered in class.  Scheduled tests will be used to assess the progress of the student toward achievement of the course objectives.

Distance Education:  Information for Distant Education General Information is available at 

https://online.austincc.edu/faq/

Students will use the Blackboard learning management system for assignment instructions, submitting assignments, and collaboration.

Technology Requirements: Internet access required or work from Computer Information Technology labs at any Austin campus and use of Student ACC e-mail account required.  To obtain your Student ACC e-mail account, visit http://www.austincc.edu/accmail/  for account information    -  MANDATORY online orientation information,   Preview course materials on Blackboard  found at http://acconline.austincc.edu/     during the first week of class   . 

Note:  A remote Oracle database to support required work is possible by downloading Oracle 11g located within the ACC Google drive.  A remote database can minimize trips to ACC computer labs to complete assignments.

            Enhance the knowledge and understanding of Database analysis and design.

           Enhance the knowledge of the processes of Database Development and Administration

             using SQL and PL/SQL.

            Enhance Programming and Software Engineering skills and techniques using SQL

          and PL/SQL.

            Preparation of background materials and documentation needed for Technical

             Support using SQL and PL/SQL.

            Use the Relational model and how it is supported by SQL and PL/SQL.

            Use the PL/SQL code constructs of IF-THEN-ELSE and LOOP types as well

             as syntax and command functions.

            Solve Database problems using Oracle 12c SQL and PL/SQL. This will include the

            use of Procedures, Functions, Packages, and Triggers.

Approved Course Text:  Required -- Set by taskforce 

             Oracle 11g PL/SQL Programming 2e – Joan Casteel –

                              ISBN   978-1-133-94736-3

             Oracle 12c: SQL

                               By Joan  Casteel  --Course Technology – CENGAGE Learning

                                ISBN-13:  978-1-305-25103-8

            Oracle Database 12c  PL/SQL Programming

                              By Michael McLaughlin – Oracle/Press McGraw Hill

                              ISBN  978-0-07-181243-6

Grade Policy: Grade will be based both on concepts and practical application.

Grade Scale:

             90%  - 100%         A

            80%  -  89%          B

            70%  -  79%          C

            60%  -  69%          D

            10%  -  59%          F

Method of Determining Final Course Grade

              1   Orientation quiz (Mandatory week 1 )                   5%   =     30 points

              1   DB/SQL  Review                                                   5%     =    20 points

              3    Major  Examinations                                             30%   =  310 points

              13  Chapter Key term definitions                                5%    =    50 points

              10  End of Chapter Hand On Assignments                 15%   =   150 points

              4   Labs (77.5 ea.)                                                       30%   =   310 points

              13 “Topic”  Quizzes                                                     10%   =   130 points

                                                                                                  100%=  1000 total

Notes:

Note:1) ALL COURSE WORK IS SUBMITTED/CONDUCTED IN BLACKBOARD

         2)    Allow an average of 15 hours per assignment

         3.     Multiple attempts on submittals will be averaged (max of two attempts)

         4)     Please be aware of the grading system which is using a weighted
               average method, as such, -- for example – a grade of 80 on a lab
               would be 80% of 77.5  or   62 points toward the total points of 1000

            5)   The format of exams multiple choice, short answer, essay, matching, combination.

             6)  Submissions/Assignments/Exams/Quizzes must be in the students own

                words  --Any Copy/pasting from any source -- such as from text -- end

                of text glossary terms— On line resources ---Definitions etc.--could be

                considered   plagiarism – the idea is for the student to use his/her own

                words this also address/includes the use of any AI support

            7)  Assignments/quizzes/labs/exams --  submitted 7 days after due dates

               are subject to a minimum 20%  penalty.  Assignments due within Modules 1 and 2

              submitted within Module 4 time frame are subject to a 50% penalty 

            8)  Of special consideration --  Oracle is not Mac(Apple) compatible  -- as such  --  a student must  make appropriate accommodations 

Course/Class Policies:

Examinations:

1. One “Review”  quiz at the start of the course ( not at an ACC testing center)
2. Three (3) major  examinations will be given (see schedule)

Examinations must be taken at an ACC Testing Center or approved remote location or before scheduled dates. The examination dates and locations may be changed due to unforeseen circumstances. Any changes will be announced in class or via e-mail.  A one page notes sheet is allowed for exams

If an Exam is missed, you will have made arrangements with the Instructor in advance and have 1 week to take the make up Exam at the Test Center. Taking the make up Exam is subject to Instructor approval. If you fail to take the make up Exam in the 1 week period, a Zero will be assigned. 

Testing Center Policy http://www.austincc.edu/testctr/

Laboratory/Hand On Homework Assignments:

Laboratory/Homework assignments will be made throughout the class. Lab work will completed on the remote Oracle database created by the student of at an ACC computer lab facility available on ACC Campuses.  Assignments are due two weeks from the date assigned unless otherwise specified by the Instructor. Students may turn in late assignments for partial credit –late will be defined as more than 14 days past due date unless otherwise authorized.

Academic Integrity

A student is expected to complete his or her own projects and tests.  Students are responsible for observing the policy on academic integrity described in the Current ACC Student Handbook, under  “Student Discipline Policy, Section C”.

“Acts prohibited by the college for which discipline may be administered include scholastic dishonesty, including but not limited to cheating on an exam or quiz, plagiarizing, and unauthorized collaboration with another in preparing outside work.  Academic work submitted by students shall be the result of their own thought, research or self-expression.  Academic work is defined as, but not limited to tests, quizzes, whether taken electronically or on paper; projects, either individual or group; classroom presentations, and homework”. 

The penalty accessed will be in accordance with the current ACC Student Handbook policy. See http://www.austincc.edu/handbook/policies4.htm  for more information.

Incomplete:

A student may receive a temporary grade of “I” (Incomplete) at the end of the semester only if ALL of the following conditions are satisfied:

1. The student is unable to complete the course during the semester due to circumstances beyond their control.
2. The student must have earned at least half of the grade points needed for a “C” by the end of the semester.
3. The request for the grade must be made in person at the instructor’s office and necessary documents completed.
4. To remove an “I”, the student must complete the course by two weeks before the end of the following semester.  Failure to do so will result in the grade automatically reverting to an “F”.

Freedom of Expression Policy:

It is expected that faculty and students will respect the views of others when expressed in classroom discussions.

Attendance / Withdrawal Policy:

Students are expected to attend classes and will be held responsible for all material covered in class.  Regular attendance helps ensure satisfactory progress towards completion of the course. 

It is the student’s responsibility to complete a Withdrawal Form in the Admissions Office if they wish to withdraw from this class.  The instructor may withdraw students from this class if their absences exceed 10% of the total number of class meetings. Per ACC  calendar- last date to withdraw for this semester Nov 21st 2024  It is not the responsibility of the instructor to withdraw the students from their class even though the instructor has the prerogative to do so under the above listed circumstances.

            ALERT: state law for students.  No more than six course 

                   withdrawals throughout your undergraduate education, regardless 

                   of how many colleges you attend.    Ask a counselor for details.

Student Support Information

Department tutor information:
Locations and hours of tutors: http://cis.austincc.edu/tutoring-schedules

IT help center:

Website: http://www.austincc.edu/helpdesk/docs/contact_stu.html

Students with Disabilities Policy:

“Each ACC campus offers support services for students with documented physical or psychological disabilities.  Students with disabilities must request reasonable accommodations through the Office for Students with Disabilities on the campus where they expect to take the majority of their classes.  Students are encouraged to make this request three weeks before the start of the semester.  (Refer to the Current ACC Student Handbook)”

COLLEGE POLICIES

HEALTH & SAFETY PROTOCOLS

Statement on Academic Integrity

Austin Community College values academic integrity in the educational process.  Acts of academic dishonesty/misconduct undermine the learning process, present a disadvantage to students who earn credit honestly, and subvert the academic mission of the institution. The potential consequences of fraudulent credentials raise additional concerns for individuals and communities beyond campus who rely on institutions of higher learning to certify students' academic achievements, and expect to benefit from the claimed knowledge and skills of their graduates. Students must follow all instructions given by faculty or designated college representatives when taking examinations, placement assessments, tests, quizzes, and evaluations.  Actions constituting scholastic dishonesty include, but are not limited to, plagiarism, cheating, fabrication, collusion, falsifying documents, or the inappropriate use of the college’s information technology resources.  Further information is available at https://www.austincc.edu/about-acc/academic-integrity-and-disciplinary-process

Any course specific policies, expectations, or procedures could be included here.

Student Rights & Responsibilities

Academic freedom is a foundation and hallmark of higher education.  In the context of college-level courses, it specifically refers to the rights of free expression and respect for others with differing opinions.  Students at the college have the rights accorded by the U.S. Constitution to freedom of speech, peaceful assembly, petition, and association. This concept is accompanied by an equally demanding concept of responsibility on the part of the student.  Just as you are expected to exercise these rights with respect for state and federal law in the larger world, you are expected to exercise these rights as a student with respect for the college’s standards of conduct.  These rights carry with them the responsibility to accord the same rights to others in the college community and not to interfere with or disrupt the educational process.  Students and faculty alike should enable a climate of mutual respect and civility while fostering the freedom to debate and discuss the merits of competing ideas.

Enrollment in the college indicates acceptance of the rules set forth in the student standards of conduct policy, which is administered through the office of the campus dean of student services. Due process, through an investigation and appeal process, is assured to any student involved in disciplinary action.

Student Complaints

A defined process applies to complaints about an instructor or other college employee. You are encouraged to discuss concerns and complaints with college personnel and should expect a timely and appropriate response. When possible, students should first address their concerns through informal conferences with those immediately involved; formal due process is available when informal resolution cannot be achieved.

Student complaints may include (but are not limited to) issues regarding classroom instruction, college services and offices on the basis of actual or perceived race, color, national origin, religion, age, gender, gender identity, sexual orientation, political affiliation, or disability.

Further information about the complaints process, including the form used to submit complaints, is available at: http://www.austincc.edu/students/students-rights-and-responsibilities/student-complaint-procedures

Statement on Privacy

The Family Educational Rights and Privacy Act (FERPA) protects confidentiality of students’ educational records. Grades cannot be provided by faculty over the phone, by e-mail, or to a fellow student.

Grades are posted in Blackboard – also of note – a weighted average method is used

Safety Statement

Health and safety are of paramount importance in classrooms, laboratories, and field activities. Students are expected to learn and comply with ACC environmental, health and safety procedures and agree to follow ACC safety policies.  Emergency Procedures posters and Campus Safety Plans are posted in each classroom and should be reviewed at the beginning of each semester.  All incidents (injuries/illness/fire/property damage/near miss) should be immediately reported to the course instructor. Additional information about safety procedures and how to sign up to be notified in case of an emergency can be found at http://www.austincc.edu/emergency

Everyone is expected to conduct themselves professionally with respect and courtesy to all. Anyone who thoughtlessly or intentionally jeopardizes the health or safety of another individual may be immediately dismissed from the day’s activity and will be referred to the Dean of Student Services for disciplinary action.

In the event of disruption of normal classroom activities due to an emergency situation or an illness outbreak, the format for this course may be modified to enable completion of the course. In that event, students will be provided an addendum to the class syllabus that will supersede the original version.

Campus Carry

The Austin Community College District concealed handgun policy ensures compliance with Section 411.2031 of the Texas Government Code (also known as the Campus Carry Law), while maintaining ACC’s commitment to provide a safe environment for its students, faculty, staff, and visitors.  Beginning August 1, 2017, individuals who are licensed to carry (LTC) may do so on campus premises except in locations and at activities prohibited by state or federal law, or the college’s concealed handgun policy.  In addition, concealed weapons are not allowed on ACC-sponsored field trips where the school owns or has chartered or leased vehicles for transportation.   

It is the responsibility of license holders to conceal their handguns at all times.  Persons who see a handgun on campus are asked to contact the ACC Police Department by dialing 222 from a campus phone or 512-223-7999.   Please refer to the concealed handgun policy online at http://austincc.edu/campuscarry

Discrimination Prohibited

The College seeks to maintain an educational environment free from any form of discrimination or harassment including but not limited to discrimination or harassment on the basis of race, color, national origin, religion, age, sex, gender, sexual orientation, gender identity, or disability.

Faculty at the College are required to report concerns regarding sexual misconduct (including all forms of sexual harassment and sex and gender-based discrimination) to the Manager of Title IX/Title VI/ADA Compliance.  Licensed clinical counselors are available across the District and serve as confidential resources for students.

Additional information about Title VI, Title IX, and ADA compliance can be found in the ACC Compliance Resource Guide available at: https://drive.google.com/file/d/1o55xINAWNvTYgI-fs-JbDyuaMFDNvAjz/view

Use of ACC email

All College e-mail communication to students will be sent solely to the student’s ACCmail account, with the expectation that such communications will be read in a timely fashion. ACC will send important information and will notify students of any college- related emergencies using this account. Students should only expect to receive email communication from their instructor using this account.  Likewise, students should use their ACCmail account when communicating with instructors and staff.  Information about ACC email accounts, including instructions for accessing it, are available at:  http://www.austincc.edu/help/accmail/questions-and-answers

For- On-line Courses – Use of an ACC Testing Center

Under certain circumstances, examinations may have to be taken in a testing center. The ACC Testing Centers follow standard procedures so students know what to expect when they arrive to take their tests. Students should familiarize themselves with the student guidelines.

Students must present an ACC student ID card or government issued ID and know their ACC ID number before they can test.

It is necessary to check in at the Testing Center kiosk before taking a test. To check in, one must know the following information:

• Student ID number
• Course prefix and number
• Course synonym
• Course section number
• Test number
• Instructor’s name

Personal belongings such as backpacks, books, and electronic devices (including, but not limited to, cell phones and smart watches) are not allowed in the Testing Center. Possession of prohibited items or accessing unapproved resources in the testing room will result in the immediate termination of the exam and possible disciplinary action.

For additional information on using the Testing Center, please go to: http://www.austincc.edu/students/testing-services/instructional-testing

STUDENT SUPPORT SERVICES

The success of our students is paramount, and ACC offers a variety of support services to help, as well as providing numerous opportunities for community engagement and personal growth.

Student Support

ACC strives to provide exemplary support to its students and offers a broad variety of opportunities and services.  Information on these campus services and resources is available at  http://www.austincc.edu/students.

 Student Accessibility Services

Students with documented disabilities who need classroom, academic, or other accommodations must request them through the office Student Accessibility Services (SAS).   SAS offices are located at each major campus.  Students are encouraged to request accommodations when they register for courses or at least three weeks before the start of the semester; otherwise, the provision of accommodations may be delayed.  Students who have received approval for accommodations from SAS for this course must provide the instructor with the document titled “Notice of Approved Accommodations” from SAS before accommodations will be provided. Accommodations will not be provided retroactively.  Arrangements by the instructor for academic accommodations can only be made after he or she receives the “Notice of Approved Accommodations” from the student.

Additional information about Student Accessibility Services is available at https://www.austincc.edu/offices/student-accessibility-services-and-assistive-technology

Academic Support

ACC offers academic support services on all of its campuses. These services, which include face-to-face and online tutoring, academic coaching, and supplemental instruction, are free to enrolled ACC students. Tutors are available in a variety of subjects ranging from accounting to pharmacology. Students may receive these services on both a drop-in and referral basis. Tutoring schedules can be found at:  https://www.austincc.edu/students/tutoring/tutoring-schedules

Library Services

ACC has a full-service library at each of its campuses to support ACC courses and programs and to provide students with research and assignment assistance from expert faculty librarians, computers, course reserves, laptop and tablet check out, study spaces, and copying, printing, and scanning services.  In addition, ACC students have full rights and privileges to access Library Services online 24/7 via the ACC Library website and students can use their ACCeID logins to access all online materials, including ebooks, articles from library databases, and streaming videos.   ACC Libraries also provide an “Ask a Librarian” service, which allows  students to reach a librarian 24/7 through online chat.  Faculty librarians are also available via email, phone, and in person seven days a week during hours of operation. Visit:

• Library Website: http://library.austincc.edu
• Ask a Librarian: https://library.austincc.edu/help/ask.php
• Library Hours of Operation by Location: https://library.austincc.edu/loc/
• Email: library@austincc.edu

In partnership with ACC’s Student Support Center, ACC Libraries also maintain a limited collection of textbooks for students to borrow. Priority access to the textbook collection is given to students receiving assistance. More information is available on the ACC website by searching “Student Support Center Textbook Collection.”

Student Organizations

ACC has over seventy student organizations, offering a variety of cultural, academic, vocational, and social opportunities.  They provide a chance to meet with other students who have the same interests, engage in service-learning, participate in intramural sports, gain valuable field experience related to career goals, and much else.  Student Life coordinates many of these activities, and additional information is available at http://sites.austincc.edu/sl/.

Personal Support

Resources to support students are available at every campus. To learn more, ask your professor or visit the campus Support Center. All resources and services are free and confidential. Some examples include, among others:

• Food pantries are located in all campus Student Life offices: https://sites.austincc.edu/sl/programs/foodpantry/.   
• Assistance with childcare or utility bills is available at any campus Support Center: http://www.austincc.edu/students/support-center.
• The Student Emergency Fund can help with unexpected expenses that may cause you to withdraw from one or more classes: http://www.austincc.edu/SEF.
• Help with budgeting for college and family life is available through the Student Money Management Office: http://sites.austincc.edu/money/.  
• Drop-in child care is available at Highland Campus: http://www.austincc.edu/students/child-care/child-watch-drop-in-center

Clinical Counseling services are available throughout the ACC Student Services District to address personal and or mental health concerns: http://www.austincc.edu/students/counseling .

If an emergency occurs during operational hours, please come to the Student Services Office and let the front intake staff know that you are experiencing a crisis. They will alert appropriate personnel. You may also contact the ACC District Police at 222 (on campus) or 223-7999 (off campus or cell phone).

After Hours:

If you are struggling with a mental health or personal crisis, call one of the following numbers to connect with resources for help. However if you are afraid that you might hurt yourself or someone else, call 911 immediately.

Free Crisis Hotline Numbers:

• Austin / Travis County 24 hour Crisis & Suicide hotline: 512-472-HELP (4357)
• The Williamson County 24 hour Crisis hotline: 1-800-841-1255
• Bastrop County Family Crisis Center hotline: 1-888-311-7755
• Hays County 24 Hour Crisis Hotline: 1-877-466-0660
• National Suicide Prevention Lifeline: 1-800-273-TALK (8255)
• Crisis Text Line: Text “home” to 741741
  • Substance Abuse and Mental Health Services Administration (SAMHSA) National Helpline:   1-800-662-HELP (4357)
• National Alliance on Mental Illness (NAMI) Helpline:1-800-950-NAMI (6264)

Some faculty may consider adding a student sign-off page at the end of the syllabus to be removed and handed back to the instructor providing evidence that the student received a copy of the syllabus and had an opportunity to ask questions, but such a page is optional.