Course Description
This course introduces relational database concepts, design and administration. Students will learn the syntax and use of Structured Query Language (SQL) and how to install and run a relational database server such as MySQL and how to design relational database for applications.
Student Learning Outcomes
Class Meetings
There are no in-person class meetings at all. This course is 100% online and is available to you 24 hours a day, 7 days a week beginning on the first official day of the semester. Because of the flexibility of an online environment, you are not required to log on at any specific time for lectures or general topic discussions. I will be monitoring discussions daily. You are not required to log in every day, but you should log in at least once a week to complete required activities.
When Can You Get Help?
Instructor Contact
LaDawn Meade
Preferred Contact: Canvas private message (Inbox icon on the left)
Email: lmeade@santarosa.edu (please send Canvas private message instead when possible)
Office Hours: Saturday noon - 1pm online by canvas message or discussion. On campus or Google Hangouts by appointment.
I respond to private messages/emails within 48 hours Monday through Friday.
Textbook
You will also need access to a Database Management System (DBMS) and client software. See the module topic Getting Started Guide
Important Dates
See the academic calendar for important deadlines:
https://admissions.santarosa.edu/academic-calendar/
Dropping the Class
If you decide to discontinue this course, it is your responsibility to officially drop it.
Instructor Announcements and Q&A Forum
The instructor will post announcements on the “Instructor Announcements” page in Canvas throughout the semester. Canvas notifies students according to their preferred Notification Preferences. The Q&A Forum is a discussion forum that is visible to all students registered for this class. Use it to ask questions about the course content or requirements. You can even post error messages or problems you are encountering, but please do not post completed assignment work. Feel free to ask and answer any questions in the Q&A Forum.
Late Policy
All assignments are due at 11:59PM PST on the due date, however I do accept late work without penalty up to the final exam date. Try to stay as close to the due dates as possible so the work does not pile up, but take some extra time to complete your work if you need it, rather than turning in incomplete or incorrect work.
Exams
There will be an online midterm and a final exam.
Grading Policy
Click the “Grades” link in Canvas to keep track of your grades. I grade once a week and post grades and comments in the Canvas gradebook.
Grades will be assigned as follows:
A |
90% |
B |
80% |
C |
70% |
D |
60% |
F or FW |
<60% |
Standards of Conduct
Students who register in SRJC classes are required to abide by the SRJC Student Conduct Standards. Violation of the Standards is basis for referral to the Vice President of Student Services or dismissal from class or from the College. See the Student Code of Conduct page.
You can talk to friends and classmates about your work on the assignments. However, you should not give or receive completed work. Any and all collaboration should be documented in your submission. Giving or receiving solutions for tests or homework in whole or in part will be considered an act of academic dishonesty and result in a grade of 0 for that test or assignment. Students are encouraged to share information and ideas, but not their work. See these links on Plagiarism:
SRJC Writing Center Lessons on avoiding plagiarism
SRJC's statement on Academic Integrity
Special Needs
Every effort is made to conform to accessibility standards for all instructor-created materials. Students should contact their instructor as soon as possible if they find that they cannot access any course materials. Students with disabilities who believe they need accommodations in this class are encouraged to contact Disability Resources (527-4278).
List of assignments
Note to students: the assignments listed below do not include all course content. To view all course content, go to Modules.