Advanced concepts of database design and functionality.
Pre-requisites: ITSW 1307 Introduction to Database
Upon completion of the course the students will be able to:
- Explain relational database theory;
- collect and distribute data;
- analyze data;
- perform complex queries, data validation and table relationships.
SQL DATABASE PROGRAMMING
Author: FEHILY
Edition: 5T
Published Date: 2020
ISBN: 9781937842475
Publisher: Questing Vole Press
Final Grade Calculations
- 30% of final grade: Quizzes
- 30% of final grade: Exams
- 40% of final grade: Assignments
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.
Equipment required for use from home or office:
- Desktop or Laptop Computer
- Internet Access
- Webcam
- MySQL
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
ADA Statement:
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; (C16) they can monitor and correct performance; and (17) they can design or improve systems.
- Technology — They can (C18) select equipment and tools, (C19) apply technology to specific tasks, and (C20) maintain and troubleshoot equipment.
FOUNDATION SKILLS — Competent workers in the high-performance workplace need:
- Basic Skills — (F1) reading, (F2) writing, (F3) arithmetic and (F4) mathematics, (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