CIT-28 
SQL

Instructor: Dan Owens
Office: BE-202
Phone / Text: (559) 442-4600 x8072
Email: dan.owens@fresnocitycollege.edu  
Office Hours:
T, TH 10-11:40am
F 7 - 8 by email

TUTORS

http://fccwise.fresnocitycollege.edu/tutorialcenter/schedulesubmission/tutorsearch.php

Course Materials

https://www.youtube.com/playlist?list=PLSak_q1UXfPo1qZ2d3aubLDcgGMPZc5-P 

database commands - http://bit.ly/2N99JBD

Computer

You will need access to a computer to complete the work in this course. This course will be taught using Mac / Unix terminal commands.

COURSE OBJECTIVES

Learn how to use and program SQL.

 

STUDENT LEARNING OUTCOMES

• Given a problem use a client/server database to design and create a solution demonstrating proficiency with tables, relationships, normalization, queries, data integrity, stored procedures and indexing.
• Demonstrate fluency with client/server database concepts.

  

GRADING

Your grade will be based upon attendance and assignments. See Canvas for a list of the assignments and quizzes. Inside Canvas, your  score is determined by an average of all items. All items are equally weighted.

The following grading scale will be used:

90 – 100            A
80 – 89.9           B
70 – 79.9           C
60 – 69.9           D 

 

DUE DATES

• Deadlines for assignments and quizzes will be given in class.

CLASS DEADLINE

No Late Homework Allowed

 

STUDENT ENROLLMENT

If you wish to receive credit for this class, it is your responsibility to verify that you are enrolled in the class. To verify that you are enrolled in the class, please look at WebAdvisor online or visit the registrar’s office in the student service’s building at FCC.

 

STUDENT INITIATED DROPS

If you wish to drop this course, it is your responsibility to do so. The student has the ultimate responsibility for dropping the course.

 

INSTRUCTOR INITIATED DROPS

Students may be dropped for not showing up to class. In the online class, “showing up to class” means that you are at least posting to the “official class discussion” every week. If you do not post to the “official class discussion” during the first week, you may be dropped as a “no show.” If you do not post to the “official class discussions” for two consecutive weeks, you may also be dropped.

 

REINSTATEMENT

Reinstatement must be made by formal petition and is the responsibility of the student.

 

DISABILITIES

Fresno City College is committed to creating accessible learning environments consistent with federal and state law. To obtain academic adjustments or auxiliary aids, students must be registered with the DSP&S office on campus. DSP&S can be reached at (559) 442-8237 and is located in Building 1.  If you are already registered with the DSP&S office, please provide your Notice of Accommodation form as soon as possible.

 

OTHER POLICIES

• You are not allowed to use your cellphone in class.
• The instructor reserves the right to change the schedule, the number of assignments, the syllabus, and any other information related to the course or scheduling on this syllabus or otherwise. Changes will be announced via Canvas.
• It is your responsibility to check your Fresno City College email address. If you do not check your FCC email, you may not receive emails from the instructor.
• For efficiency, there may be times when your work and/or grades will be seen or checked by other persons.
• You are expected to conduct yourself with the highest moral and ethical behavior. Any cheating, plagiarism or offensive behavior will be dealt with according to campus policy (see college catalog for details of campus policy). The college regards cheating as a serious offense. More than intelligence, more than beauty, more than money, more than a good grade, more than anything else in the world – honesty and integrity are the most valuable qualities any individual can have.