Course Syllabus

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

1. Write Structured Query Language (SQL) statements, including Data Definition Language (DDL) queries and Data Manipulation Language (DML)
2. Design and develop a relational database

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?

I am available by Canvas private message or Canvas discussion forum Monday through Friday, which I monitor several times a day.  You can expect an initial reply on weekdays within 24 hours, although if your question is fairly involved, I may need to respond multiple times to address everything.  You can also get help from your group or other class members by using the Canvas discussion forums as well.  This can be especially helpful on weekends.

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

The following textbook is recommended (but not required):
Alan Beaulieu. 2008. Learning SQL. OReilly. ISBN 9780596007270

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.

Course Summary:

Date Details Due