Advanced use of Oracle SQL. Topics include hierarchical queries, set based queries, correlated subqueries, scripting, and scripting generation.
Pre-Requisites: ITSE 1359 Introduction to Oracle SQL
Upon completion of the course the student will be able to:
- 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.
ORACLE 11G:PL/SQL PROGRAMMING
Author: CASTEEL
Edition: 2ND 13
Published Date: 2013
ISBN: 9781133947363
Publisher: CENGAGE L
Assignments 40%
Midterm Exam 30%
Final Exam 30%
Final grades will be calculated by the following scale:
A: 90% and above
B: 80 to 89%
C: 70 to 79%
D: 60 to 69%
F: less than 60%
Lecture, hands-on computer activities, reading and writing assignments, quizzes, and exams. Reading, lab practice, exams, and assignments are accessed and submitted through the Canvas virtual classroom.
Additional requirements for use from home or office:
- Desktop or Laptop Computer
- Internet Access
- Webcam
Database Programming Certificate:
- Students work with desktop database programs
- Students work with client-server applications
- Students solve business computer problems through programming techniques and procedures using appropriate languages and software
Any student with a documented disability (e.g. learning, psychiatric, vision, hearing, etc.) may contact the Office on the Weatherford College Weatherford Campus to request reasonable accommodations. Phone: 817-598-6350 Office Location: Office Number 118 in the Student Services Building, upper floor. Physical Address: Weatherford College 225 College Park Drive Weatherford, TX.
Academic Integrity is fundamental to the educational mission of Weatherford College, and the College expects its students to maintain high standards of personal and scholarly conduct. Academic dishonesty of any kind will not be tolerated. Academic dishonesty includes, but is not limited to, cheating on an examination or other academic work, plagiarism, collusion, and the abuse of resource materials including unauthorized use of Generative AI. Departments may adopt discipline specific guidelines on Generative AI usage approved by the instructional dean. Any student who is demonstrated to have engaged in any of these activities will be subject to immediate disciplinary action in accordance with institutional procedures.
Any student who faces challenges securing basic resources such as food, clothing, or housing and believes this may affect their performance in their course of study is urged to contact the Director of Student Resources, Dr. Deborah Cregger, for support at (817) 598-6444. Her office is on the first floor of Student Services. If the student prefers, they may contact their instructor, who can reach out on their behalf.
A student shall retain all rights to work created as part of instruction or using College District technology resources.
The Secretary’s Commission on Achieving Necessary Skills (SCANS) identified competencies in the area of Resources, Interpersonal, Information, Systems, and Technology; and foundation skills in the areas of Basic Skills and Personal Qualities.
WORKPLACE COMPETENCIES — Effective workers can productively use:
- Resources — They know how to allocate (C1) time
- Information — They can (C5) acquire and evaluate data, (C6) organize, and maintain files, and (C8) use computers to process information.
- Interpersonal Skills — They can work on (C9) teams, and (C14) work well with people from culturally diverse backgrounds.
- Systems — They (C15) understand social, organizational, and technological systems
- Technology — They can (C19) apply technology to specific tasks
FOUNDATION SKILLS — Competent workers in the high-performance workplace need:
- Basic Skills — (F1) reading, and (F5) listening
- Thinking Skills — (F8) to make decisions, (F9) to solve problems, (F10) to visualize, (F11) the ability to learn, and (F12) to reason.
- Personal Qualities — (F13) individual responsibility, (F14) self-esteem, (F15) sociability, (F16) self-management, and (F17) integrity