Course Title:  Advanced Oracle PL/SQL

Course Prefix & Number: ITSE 2354

Section Number:  0350 

Term Code: 2020 FA

Semester Credit Hours: 3

Lecture Hours: 32

Lab Hours: 32

Course Description (NCTC Catalog):

ITSE 2354 – Advanced Oracle PL/SQL (3 credit hours)

In this Advanced Oracle PL/SQL course, you explore the advanced features of PL/SQL to design and tune PL/SQL. You will learn how it interfaces with the database and other applications in the most efficient manner.

Course Prerequisite(s):  ITSE 1345     INTRODUCTION TO ORACLE PL/SQL

Course Type:

X Academic General Education Course (from Academic Course Guide Manual but not in NCTC Core)

X  Academic NCTC Core Curriculum Course

X  WECM Course

Name of Instructor:

Manuel Trevino, Jr.

Campus/Office Location:

IT Career Connection Center, room 102                                          (Online office Hours are available by appointment)

Telephone Number:

 940-498-6440   extension 6516   *

E-mail Address:

mtrevino@nctc.edu   *

Name of Chair/Coordinator:

Susan Svane

Office Location:

Room 233

Telephone Number:

940-498-6292

E-mail Address:

ssavne@nctc.edu

# of Graded Course Elements

Graded Course Elements

Points per Assignment

Total Points

Points Contribution to Overall

15

Lab Assignments

100

1500

41.67%

10

Discussion Forum Assignments

20

200

5.56%

15

Quizzes

100

1500

41.67%

4

4 Exams                          

100

400

11.10%

TOTAL

3600

100%

*Students found plagiarizing in an assignment in this course may receive an "F" for the course along with a report turned into the Dean for Scholastic Dishonesty.

*Students with continued absences and discussion posts that add no value will receive a “0” for the assignment. The class discussion forums and exams will be used to determine regular attendance.

Total

Points

Letter

Grade

Final %

Grading in this course is point driven. The maximum number of points may vary semester to semester.  

Labs and Discussion assignments will be graded within two weeks after due date.

3240 - 3600

A

90 to 100

2880 - 3239

B

80 to 89.9

2520 - 2879

C

70 to 79.9

2160 - 2519

D

60 to 69.9

<=2159

F

< 60

• Retrieve data including SET operators, correlated subqueries, and hierarchical queries

• Write SQL scripts that execute remote procedure calls

• Create a package to group together variables, cursors, exceptions, procedures, and functions

• Invoke a package constraint

Please observe appropriate communication etiquette when addressing fellow classmates as well as your instructor.  Questions may be asked at any time.  Please email or call instructor (contact information provided above).

College education is intended to broaden the student’s knowledge base.  Any and all material read, discussed, heard, or observed is subject to being referenced on an examination.  Do not expect the body of knowledge to be narrowed by “reviews” from which test questions will be selected.  Exams are closed book.

NOTICE: The instructor does not do behavior management. The expectation is that you, as college students, will learn to modify the behavior of your peers through the channels available in your contextual universe.  If the instructor is forced to manage your behavior such will be accomplished via the following procedure:

• You will be warned by the instructor that your behavior is not acceptable.
• You will be suspended from class access and not return until:
  a.   You have met with the Dean of Students (Roxanne Del Rio)
  b.   You have signed a letter of probation
  c.   The Dean of Students notifies the instructor that you have done ‘a’ and ‘b’, and that you may return to class.
• A third event will result in your probation becoming suspension and you will be removed from the class permanently.

Syllabi statement regarding potential Conversion of Onsite Classes to Online/Remote Format: North Central Texas College students should be aware that in the event of a college closure due to COVID-19, onsite classes will be converted to an online/remote format. Students should plan ahead to ensure they have access to the computer equipment (either PC, MAC, or tablet), webcam, and internet connectivity to continue their classes in an online/remote format. Please read all your official North Central Texas College student emails as the transition from onsite to online/remote might require a reorganization in your personal situation. Students will be granted a 72-hour transition and grace period. Online classes will continue as scheduled without disruption. Wear a mask, stay safe, and contact your Instructor as the situation arises. These policies and procedures were updated on July 30, 2020 and are subject to change.

Syllabi Statement Regarding Face Coverings: Per the North Central Texas College guidance on face coverings on campus, in the instructional setting, faculty and students must wear face coverings, such as masks or face shields. Students without coverings, or those who do not comply with the rules relating to face coverings, will not be able to participate in on-campus classroom activities. To request an exception to this requirement, students should contact the NCTC HR Office of Enrollment Management (ccove@nctc.edu). Failure to comply with the face coverings requirement may result in the Instructor directing the student to leave the classroom. Any student asked to leave the classroom may be referred to the student conduct officer. These policies and procedures were updated on July 30, 2020 and are subject to change.

Temporary COVID-19 Attendance Policy for Face-to-Face Meetings: We are facing an unprecedented situation in which all of us must be flexible and make prudent decisions in the best interest of our families, our campus, and our community. In light of this, North Central Texas College is temporarily establishing the requirement that faculty keep records of student attendance for face-to-face course meetings as well as a documented seating chart. In addition, students who are sick or need to quarantine should not attend classes. Students will not be required to provide formal documentation from a health care provider and will not be penalized for COVID-19 related absences when proper notification to campus health officials is made in accordance with the guidelines stated below.

Faculty will:

• Notify students about important course information and delivery changes through Canvas and campus email.

Students should:

• Provide notification to campus officials (via NCTC Daily Health Check protocol through Canvas) if they have tested positive for COVID-19 or have to quarantine so we can confirm reported absence with instructors, monitor, and assist the campus community.
• Notify instructors in advance of the absence.
• Connect with that class through Webex if the class session is being transmitted in a hybrid fashion.
• Keep up with and/or make up missed classwork or assignments.
• Submit assignments digitally through Canvas or other means as announced by your instructor.
• Work with their instructors to reschedule exams, labs, and other critical academic activities described in the course syllabus.
• Check Canvas and campus email daily to receive important announcements pertaining to the course.

During this period, faculty with face-to-face meetings will establish assigned seating/work stations to facilitate roll-taking, and, if necessary, contact tracing. Additionally, we ask all members of the College community to be attentive to their health, and safeguard others, by following the CDC’s guideline to “stay home when you are sick.” You should stay home if you have symptoms. More information on what to do if you are sick is available at the CDC’s website.

Additional NCTC information is available at http://www.nctc.edu/coronavirus/index.html

CORE CURRICULUM FOUNDATIONAL COMPONENT AREA

Communication

American History

Mathematics  

Government/Political Science

Life and Physical Science

Social and Behavioral Sciences

Language, Philosophy &Culture

Component Area Option

Creative Arts

REQUIRED CORE OBJECTIVES

 X

Critical Thinking

 X

Teamwork

 X

Communication

 X

Personal Responsibility

 X

Empirical and Quantitative

 X

Social Responsibility

Last day to Withdraw

The last day to withdraw from a course with a “W” is Oct 30^th.

Holiday(s)

Labor day September 7, 2020

Thanksgiving,  November 25-29

Commencement

December 11^th  – at the Gainesville Campus (Tentative)

Student Rights & Responsibilities

NCTC Board policy FLB (Local) Student Rights and Responsibilities states that each student shall be charged with notice and knowledge of the contents and provisions of the rules and regulations concerning student conduct.  These rules and regulations are published in the Student Handbook published in conjunction with the College Catalog.

Other Pertinent Information

Dropping Courses:

If a student’s personal circumstances dictate that he or she needs to reduce his/her academic load, that student should confer with his/her advisor for assistance in adjusting the number of courses being taken.  A grade of “W” will be given to students who officially withdraw from a course, or “drop”, at least by Thursday of the 11th week of a Fall or Spring semester, or a proportional number of weeks prior to the end of a flex-entry course or summer session.  Any drops after this will be made with the approval of the instructor and the Department Chair.

It is the student’s responsibility to initiate the action necessary to drop courses under the conditions outlined above.  This requires the completion of a petition for course drop form available in the Registrar’s Office on any NCTC Campus or by going to the NCTC website at www.nctc.edu and clicking on Admissions and Registration.  Choose the forms on-line option and follow directions for submission of form.  This form must be submitted on or before the last day to drop with a “W” (see Academic Calendar in front of catalog for specific date) and it is not available until after the official date of record. Prior to the official date of record, a student should go to the Registrar’s Office and complete the required forms.

Students who register for courses are required to drop any courses they no longer wish to attend or a final grade will be assigned.  Instructors may drop students from courses for non-attendance by completing a petition for course drop. 

Scholastic Integrity

Scholastic dishonesty shall include, but not be limited to cheating on a test, plagiarism, and collusion.  See Student Handbook “Student Rights & Responsibilities:  Student Conduct [FLB (LOCAL)]” #20 on page 175.

Complaint Procedures

If the complaint involves a problem with an instructor, the student shall discuss the matter with the instructor before requesting a conference with the department chair… If the complaint involves a grade received, the student shall collect all tests, papers, daily assignments, class notes and other relevant material prior to the conference with the instructor in question.  (See Student Handbook > Discussion of Complaint)

ADA Statement

North Central Texas College is committed to providing equal access to educational opportunities to its students with disabilities by providing assistance through “reasonable accommodations”; and a variety of services and resources through the Special Populations Office. The College does not discriminate on the basis of disabilities in admission or access to its programs. Students are responsible for notifying the office of their need for assistance at least two weeks prior to the beginning of a semester. Students with documented disabilities such as mobility, hearing or visual impairments, learning, and/or psychological disorders are eligible for services. The Special Populations Office on the Gainesville Campus is located in the Counseling/Testing Center room ASC 108 (next door to the bookstore). For assistance, call 940/668-4216 ext. 344. 

Civil Rights

In compliance with Title VI of the Civil Rights Act of 1964 (P.L.88-352), Title IX of the Education Amendments of 1972 (P.L. 92-318). and the Age Discrimination Act of 1978 (P.L. 92-256), North Central Texas College does not discriminate against or exclude from participation in any of its programs or activities, either in the student body or the staff, any person on the grounds of sex, race, color, religion, age, handicap, national origin, or veteran status.

Web Page

Visit the North Central Texas College web page for information on registration, financial aid, counseling/advising, and cost of tuition and fees. You will also find information on the catalog and semester schedules as well as courses of study. You can keep up with what is happening on campus by checking the calendar of events and the sports news. The web has information on the library as well as links to other areas of interest. Check out our web page at http://www.nctc.edu .

Additional content for this course may be found in your Canvas account. Please check there for updates and news. 

Childcare Reimbursement Program

The Childcare Reimbursement Program provides support services for NCTC students pursuing a career in a technical field of study to help them complete their career plans. The program will reimburse technical declared students a percentage of their daycare expenses if the child is attending a licensed or registered daycare facility.  This is on a first come first serve basis, and is available to students on all 5 campuses. Please note, we do not have a childcare facility on any of our 5 campuses. This is a reimbursement program only.

Students who wish to become eligible for Childcare Assistance Program need to:

• Declare in a technical field of study
• Establish financial need
• Ex: Pell Grant recipient, Food Stamp recipient, W2,  etc.
• Complete a Childcare Reimbursement Program Application and provide all necessary documentation.  The  Application can be found online at http://www.nctc.edu/StudentServices/Childcare.aspx

For more information, please contact Yvonne Sandmann on the Gainesville Campus at 940-668-4209 ext. 4321, or by email at ysandmann@nctc.edu.

Disability Services (OSD)

The Office for Students with Disabilities (OSD) provides accommodations for students who have a documented disability.  A disability is anything that can interfere with learning, such as a learning disability, psychological challenge, physical illness or injury. Accommodations may include extra time on tests, tests in a distraction reduced environment, volunteer note taker in class, etc.

On the Corinth Campus, go to room 170 or call 940-498-6207. On the Gainesville Campus, go to room 110 in the Administration (100) Building or call 940-668-4209.  Students on the Bowie, Graham, Flower Mound, and online campuses should call 940-668-4209 to arrange for an intake appointment with OSD.

North Central Texas College is on record as being committed to both the spirit and letter of federal equal opportunity legislation, including the Americans with Disabilities Act (ADA) of 1990, ADA Amendments Act of 2009, and Section 504 of the Rehabilitation Act of 1973 (P.L. 93-112).

http://www.nctc.edu/StudentServices/SupportServices/Disabilityservices.aspx

Support Services

Counseling and Testing staff offer a variety of services to current and prospective students, such as College 101, placement testing, academic advising and course registration, transfer assistance, and College Success seminars (Time Management, Study Skills, Test Anxiety, Choosing a Major, Learning Style Strategies, Career Exploration), and much more.  http://www.nctc.edu/StudentServices/CounselingTesting.aspx

Student Success offers academic coaching, tutoring, including a Writing Center, a Math Lab, free 24/7 online tutoring through Grade Results and assist new students acclimate to college by providing computer lab services for prospective students.   First generation students can also participate in TRIO which offers specialized support services.  http://www.nctc.edu/StudentServices/SupportServices.aspx

Financial Aid offers financial resources for students that qualify, visit the financial aid offices for more information.  http://www.nctc.edu/FInancialAidHome.aspx

Tobacco-Free Campus

NCTC restricts the use of all tobacco products including cigarettes, cigars, pipes and smokeless tobacco on campus property. 

NOTICE: Some grades for this course are posted in Canvas. Those grades will be correct only relative to the assignments that are graded by instructor. The course average and other numeric computations that show in Canvas may or may not be correct. As college students you should use the above provided format to follow your grade progress. Your final grade is obviously a sum of the ratios of the four component grades. The very best approach is to accumulate as many points as you can as the semester goes along. If you miss an opportunity to earn points for any reason then, those points are lost. Remember to participate in posted assignments during the time frame allowed.

NOTICE: Some assignments required participation on more than one date. Being absent on either date will cause you to NOT get points for the related assignment or activity. Attendance is mandatory. This course operates much like a business with you as the employee who is expected to show up for all work assignments.

Student Success Center

The Student Success Center is designed to help all students at NCTC develop tools to achieve their academic goals. The center links students to FREE tutoring, including a Writing Center, a Math Lab, and free online tutoring.  The program helps students acclimate to college by providing free interactive online workshops. For more information, please visit your nearest Student Success Center.

Student Success offers academic coaching, tutoring, including a Writing Center, and a Math Lab to assist new students acclimate to college by providing computer lab services for prospective students. http://www.nctc.edu/student-services/student-success/tutoring/index.html

First generation students can also participate in TRIO which offers specialized services.

http://www.nctc.edu/student-services/trio-student-support-services.html

Completion Center

The NCTC Completion Center is a comprehensive student engagement program that increases retention and completion rates of first-time, low income students. Services include:

Success coaching to address students’ academic and non-academic challenges and issues; Success Seminars, and a centralized career readiness and job placement program.

http://www.nctc.edu/student-services/completion-center/index.html

Career Services Center

The NCTC Career Services Center is the place you can go for educational and career planning. Services include: Career/Degree Exploration, Job Search Tools and Resources, Resume and Professional Portfolio Development, Interview Skills and Preparation. Our Career Advisors partner with you in making your educational journey an efficient process towards a rewarding career. http://www.nctc.edu/career-services/index.html

Counseling and Advising

Support Services, Counseling and Advising staff offer a variety of services to current and prospective students, such as College 101, placement testing, academic advising and course registration, transfer assistance, and College Success seminars (Time Management, Study Skills, Test Anxiety, Choosing a Major, Learning Style Strategies, Career Exploration) and much more.  http://www.nctc.edu/counseling-advising/index.html 

Testing Service Center

The mission of NCTC Testing Services is to provide high-quality testing services that adhere to the professional standards and guidelines to meet the needs of students, faculty, and community members. http://www.nctc.edu/testing-center/index.html

Early Alert and CARES           

The NCTC Early Alert program assists students who are at risk of failing or withdrawing from a course. Faculty and staff may refer students through the Early Alert process at any point in the semester in an effort to provide appropriate intervention and access to support services. Examples of behaviors that could prompt an Early Alert referral could be missing assignments, failing tests, excessive absences, or personal circumstances impacting academic performance. A student submitted as an Early Alert will be contacted by an academic advisor or success coach through text, phone, and/or via their NCTC e-mail address to discuss any current challenges as well as helpful resources and success strategies-we want our students to finish strong and know that education is a partnership!

The NCTC CARES (Campus Assessment Response Evaluation Services) Team is concerned not only about our students' academic success, but also their emotional and physical well-being. The CARES Team promotes a safe learning environment for students, faculty, and staff and is committed to taking a proactive approach in helping our students succeed by addressing the mental, emotional or psychological health and safety of the NCTC community. As a student, you have the ability to report concerning behavior which could impact your own safety or the safety of another NCTC student, such as stalking, harassment, physical or emotional abuse, violent or threatening behavior, or self-harm. Visit the NCTC CARES site to also locate campus and community resources, or email counseling@nctc.edu to get in touch with a member of the CARES Team directly.  As always, if you feel there is an immediate threat to your own safety or welfare (or to another student), please call 911 immediately.

Financial Aid

Financial Aid offers financial resources for students that qualify, visit the financial aid offices for more information.   http://www.nctc.edu/financial-aid/index.html

Student Success

At NCTC, student success is progress towards collegiate goals, reached in an affordable and timely manner, under professional guidance, empowering students to serve skillfully in their chosen role within their community

Equity

NCTC defines equity as encompassing the practice of acknowledging individual differences and systemic disparities when developing new programs and resources for our campus community, which may sometimes challenge our own beliefs and assumptions, in order to ensure balanced educational opportunities toward completion.

Affinity Groups

Staff and faculty representing the Employee Resource Groups (ERG’s), along with academic advisors, counselors and success coaches, serve as mentors for NCTC’s student-centered Affinity Groups.

An Affinity Group is a population of students who have specific needs, barriers or systems they are needing to navigate not only within college, but within life. Providing mentorship, support and resources for identified Affinity Groups such as Black/African American students, veterans and active military, single parents, students with disabilities, adult learners, Latinx, LGBTQ+ and students who have experienced foster care and/or homelessness, enables us to make more impactful, meaningful connections with students who are in dire need of equity and understanding.