SCHEDULE

            ITSE 1345- 29079: Course instruction and testing are fully online without required class times.

Instructor’s Name: Sajida Faiyaz

Virtual Office Hours: Virtual Office Hours: Monday & Wednesday 1:00 pm to 2:00 pm

(By appointment only)

Join Zoom Meeting
https://austincc.zoom.us/j/82385694287?pwd=rbsay5jRotnHn4Gbwj5Torr218Hkjb.1

Meeting ID: 823 8569 4287

Passcode: 623337

Office: Building 4000,       room #: 1215.04

Phone:        512-223-3195

E-mail:       sajida.faiyaz@austincc.edu

I will be holding office hours electronically. This means that you can contact me via email to set an appointment. I will also respond to any email within 24 hours (excluding weekends). If you wish to meet with me in person, please notify me in advance, and I will set an appointment.

STUDENTS EXPECT TO RECEIVE A RETURN EMAIL WITHIN 24 HOURS.

NOTE: DO NOT SEND ME ANY MESSAGE VIA BLACKBOARD

VIRTUAL OFFICE HOURS

If you’re finding it difficult to understand the concepts, remember that you’re not alone, I am here to help! I encourage you to join my virtual office hours on Wednesday from 1 pm to 2 pm via Zoom.

                                Please note that the meeting requires a prior appointment.

To schedule a time, simply email me to confirm your spot. This session is a great opportunity to ask questions, get clarifications, and work through any challenges you may be facing.

REQUIRED TEXTBOOK:                            

Approved Course Text:  Set by taskforce.

1. Oracle Database 12c PL/ SQL Programming

by mclaughlin, michael

Edition:14

Publisher:MCG

ISBN10: 0071812431

ISBN 13: 9780071812436

1. Oracle 12c: SQL Set by taskforce.

       Author:   Casteel

       Edition:   1st

       Publisher:            Cengage

      ISBN: 978-1-305-25103-8

COURSE DESCRIPTION

Credit Hours: 3

     Classroom Contact Hours per week: 2hrs 40mins

     Laboratory Contact Hours per week: 50mins

An introduction to the design and creation of relational databases. Topics include storing, retrieving, updating and displaying data using Structured Query Language (SQL) and Procedure Language (PL).

COURSE RATIONALE: 

This course is designed to teach students how to create programmed solutions using the Oracle 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.

COURSE OUTCOMES AND ASSESSMENTS

By the end of the course, students will be able:

• 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 21i SQL and PL/SQL. This will include the use of Procedures,

   Functions, Packages, and Triggers.

The course is graded using this breakdown of assignments.

Element                                                                 Percent

Orientation Quiz                                                         10%

Weekly Lab Activities                                                   10%

Weekly Quizzes                                                            10%                                                                            

Assignments                                                                 20%                                                                                                                    

Exam 1                                                                            25%

Exam 2                                                                       25%

Total                                                         100%

LETTER GRADE ASSIGNMENT

             Austin Community College’s (ACC) grading system is as follows:

Please read the following instructions carefully:

Regular and timely use of Blackboard participation in discussions and completion of work is expected of all students.  If       attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class for non-compliance.

• Each student is responsible for monitoring his/her email account frequently. 
• Students should check for e-mail and class announcements
• Students are expected to find out class assignments for missed classes and make up missed work. 
• Students are expected to find out if any changes have been made in the class or assignment schedule.
• Students are responsible for submitting a completed assignment. Make sure it is submitted otherwise you earn a zero.
• Written work must be presented in a professional manner. Work that is not submitted in a professional manner will not be evaluated and will be returned as unacceptable.
• There is a craft to writing.  Spelling, grammar, punctuation and diction (word usage) are all tools of that craft.  Writing at the collegiate level will show careful attention to these elements of craft.  Work that does not exhibit care with regard to these elements will be considered as inadequate for college writing and graded accordingly. 
• Students are expected to take the examinations on the designated dates.  If you are unable to take the exam on the scheduled date and know in advance, you are to make arrangements with your professor before the designated date.   

TENTATIVE COURSE SCHEDULE

Readings are to be completed prior to class where listed.

GENERATIVE ARTIFICIAL INTELLIGENCE (GAI) POLICY

      Computer Science and Information Technology (CSIT) Generative AI (GAI) Policy