An introduction to the design and creation of relational databases using Oracle. Topics include storing, retrieving, updating, and displaying data using Structured Query Language (SQL).
Upon completion of the course the student will be able to:
- Write Structured Query Language (SQL) statements using Oracle,
- select and sort data; produce reports with SQL*Plus,
- create, manage, normalize tables, incorporate constraints,
- create database objects, including views.
ORACLE® 12c: SQL
Author: CASTEEL
Edition: 3rd
Published Date: 2016
ISBN: 9781305251038
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.
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