Introduction to relational and non-relational database theory and the practical applications of a contemporary databases. Topics may adapt to changes in industry practices. For this course, Weatherford College maintains lab hours open to all students. Each semester, departmental faculty members and tutors post hours in these labs when they are available to assist students.
Upon completion of the course the student will be able to:
- Identify and differentiate the application of relational and non-relational databases;
- identify database terminology and concepts;
- plan, define, and design a database;
- design and generate tables, forms, and reports;
- devise and process queries.
Upon completion of the course, students will be able to:
- Identify database terminology and concepts;
- plan, define, and design a database;
- design and generate tables, forms, and reports; and
- devise and process queries.
SHELLMAN GUIDE TO SQL-MINDTAP (1 TERM) 9780357419755 10TH 21 CENGAGE L
Final Grades:
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%
Quizzes:
- Quizzes will be closed after the due date. Quizzes cannot be submitted late.
- Answers will be automatically submitted
- Quizzes can be reviewed (with corrected answers) after the quiz has closed
- The lowest quiz grade will be dropped to allow for a missed quiz
- Quizzes are open-book
- Print a copy to keep for study guides for the midterm and final exams
Exams:
The 2 exams (Mid-Term and Final) MUST be taken in person and will be closed-book. Material on the exams will come mostly from the prior quizzes. A picture ID is required at exam time. Check the course schedule for the scheduled date and time of the two exams. If you are unable to come at the scheduled time, make prior arrangements with the instructor.
Assignments:
Assignments are due as specified in the assignment section of each week's material. Assignments are considered late after midnight of the due date. Assignments will be accepted late with a deduction of 10 points per week. Grade and feedback from the instructor are posted each week on the assignment itself.
Attendance Policy:
Attendance will be documented by timely submission of assignments.
Lab Availability:
All assignments and quizzes can be done from home or office. A lab in the Technology Building is available for use during open lab hours. Lab location and hours for the current semester will be posted on the course home page.
Equipment required for use from home or office:
- Working computer with Internet Access
- Flash drive
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.
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, (C11) serve customers, (C12) lead, (C13) negotiate, 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, and (F6) speaking.
- Thinking Skills — (F7) to think creatively, (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