Click here for
printer friendly


Course:  IT 222 – Structured Query Language

Instructor:  Ms. Faith Brenner

Sections:  Y1 & V1

Faculty Office:   Room C250

Credit Hours:  3 Credit Hours
                  (2 hrs lecture & 2 hr lab per week)

Phone:  (217) 875-7211   Ext. 541

Class Days:   Thursdays (Section Y1 only)

Class Room:  C240


Class Time:  2 p.m. — 3:50 p.m. (Section Y1 only) Faculty Web Site URL:




Fall 2009
Office Hours:

On-Campus Office Hours:
Mon: 12:00 noon. — 1:00 p.m.
Tues: 1:00 p.m. — 2:00 p.m.


11:00 a.m. — 1:00 p.m.

Thurs: 1:00 p.m. — 2:00 p.m.
Fri: By appointment only

Online Office Hours:

Fri: 10:30 a.m. — 11:30 a.m.
Other: To be determined
Other Times by Appointment

Find Topic On This Syllabus  FIND
    • Welcome to this course. The participants drive this course through synchronous and asynchronous discussion and interaction. In this course, you will get a taste of what it is like to be an online student, since in a web-enhanced course, there will be work to do online as well as in the classroom. You may be in for some big surprises in regards to online learning. If you think that taking an online class is easy because you don’t have to go to class, think again! Learning online is much different than learning in a classroom. It requires you to be an active participant and to contribute to the learning process. Your participation and logging on frequently will make this a much more enjoyable experience as well as informative. You are responsible for all course work to be completed in a timely manner and submitted on time. Using the excuse that your computer ate your homework doesn’t cut it! If you are not comfortable with computers, don’t worry. That is what this class is for, to get you comfortable using the computer as well as thinking and working as an “online student.” So kick off your shoes (can’t do that in a classroom), grab a snack (can’t do that either) and let’s get going!
    • • This course introduces students to many basic computer programming topics, using coding examples from various programming languages, pseudocode, and flowcharts. The course introduces the student to different aspects of programming logic, including object-oriented, event-driven programming and structured procedural programming. It is an introductory course in programming aimed at the student with minimal background in programming. As an introductory course, students will learn basic programming logic. Students will be writing pseudocode, structured hierarchy charts, and flowcharts for programs to demonstrate proficiency in learned concepts as well as sample program code in various programming languages, which will require extensive use of a microcomputer.

    • • IT 131 or consent of full-time Information Technology instructor

    • • IT 222 introduces the student to the study of relational database systems and the practices of incorporating Structured Query Language (SQL) in the development and maintenance of those systems.  This course offers the student practical experience using case-based, problem solving learning activities using Microsoft SQL and MySQL.  This course will be driven by a semester-long threaded case study.

    • A. Learner Outcomes: Upon successful completion of the course, the student should be able to:
      • 1. Demonstrate knowledge of the basic operations of a database.
      • 2. Demonstrate knowledge of how to store and retrieve data.
      • 3. Demonstrate knowledge of how to insert, update, and delete data.
      • 4. Create, and use indexes, joins, and subqueries..
      • 5. Create a program with SQL.
      • 6. Demonstrate ability to read data models.
      • 7. Demonstrate the basics of designing a database's structure.
      • 8. Implement normalization to the third level.
    • B. SCANS:    Additional Occupational & Technical competency objectives for this course are described as SCANS (see SCANS section).
    • C. RCC Cross-Disciplinary Outcomes
      • The graduating student will:
        • 1. communicate effectively (read, write, speak, listen)
        • 2. think critically and creatively
        • 3. manage technology and evaluate information in various research and applied contexts
        • 4. act professionally and responsibly
    • D. RCC Core Values:
      • Commitment - demonstrate Commitment to improving his or her work
      • Respect - Respect all members of the class and encourage the contributions of each class member
      • Excellence - strive for Excellence by seeking to exceed expectations through vigorous development and pursuit of higher standards for themselves
      • Accountability - develop Accountability for his or her actions
      • Diversity - embrace individual and cultural Diversity that enriches the quality of the class
    • E. National/State/Local Skill Standards (Northwest Center for Emerging Technologies - IT ):
        • A. Perform Analysis
          • A1 Gather data to identify customer requirements
          • A2 Define scope of work
          • A5 Develop test requirements
        • B. Develop Structure
          • B2 Identify major subsystems and interfaces
          • B4 Develop models
        • C. Design/Develop Program
          • C1 Develop design and interface specifications
          • C3 Develop appropriate data model
          • C4 Prepare and conduct design review

    • • You will be asked to undertake these activities to help you to learn the subject matter of this course.
      • o Read all assigned articles
      • o Participate in online and/or in-class discussions
      • o Participate in a group project
      • o Complete all learning module activities in a timely manner
    • • You are expected to spend a minimum of 10 hours per week participating in this course, which includes reading the articles, participating in online discussions, and completing the activities.
    • • To participate in the online portion of this course, you need to:
      • o Have reliable computer access
      • o Have reliable access to email
      • o Have reliable access to the Internet with a recent version of an Internet Browser
      • o Have access to all required software in order to complete course projects
      • o Have appropriate study skills and self-motivation (Take the online self-evaluation to see if you meet this requirement)
    • • You are expected to be familiar with the guidelines of the American Psychological Association Style Guide when referencing all research sources
    • • You are expected to be an active participant by attending on-campus sessions and/or logging into the course on a regular basis and posting to discussion forums
    • • You are expected to demonstrate academic integrity and respect for other participants by using appropriate Netiquette
    • • You are expected to demonstrate accountability by completing all course readings, assignments, discussions, projects, and assessments in a timely manner
    • • You are expected to have basic computer literacy - know how to:
      • o use word processing to create text documents
      • o read and send e-mail, including handling of e-mail attachments
      • o use an Internet browser to search for information and view web pages
      • o manage electronic files to create and save files and to compress and uncompress files

    • • Required Text:
      • o A Guide to MySQL, First Edition by Phillip J. Pratt & Mary Z. Last,
        Thomson Learning-Course Technology, Boston, Massachusetts, 2006.
    • • Supplemental Materials:
      • o Supplemental materials may also be provided throughout the course in the form of:
        • Handouts
        • PowerPoint Presentations
        • Chapter Notes
        • Internet resources
        • Audio Files
        • Video Files
        • Flash Movies
    • • Required Supplies:
      • o Electronic storage media, which can be any of the following depending on your computer:
        • 3.5” double-sided/high-density (DS/HD) diskettes (if used, multiple diskettes required)
        • Optical Discs - CD-R or CD-RW discs (if used, multiple dics may be required)
        • Zip disk (if used, multiple discs may be required)
        • USB Flash drive (also known as jump drives or thumb drives) - recommended
      • o Paper
      • o Pen/pencil
      • o Course notebook
    • • Recommended Supplies/Materials:
      • o Stapler
      • o Graph paper for flowcharting

    • • Required Equipment:
      • o IBM Compatible microcomputer
      • o 512 MB of RAM or higher recommended
      • o Mouse
      • o DVD-ROM
      • o Removable Media Drives - depending on the storage media you will be using, you may need the following:
        • Diskette drive for floppy diskettes
        • CD-RW or DVD-RW drive for CD-R or CD-RW discs
        • Zip Drive for using Zip disks
        • USB port for using USB Flash drives
      • o Modem for Dial-up connection or Network card for direct Internet connection (high-speed connection recommended - DSL, cable, etc.)
      • o Sound card with speakers or headphone
    • • Required Software:
    • • Optional Software:
      • o Flowcharting software such as the flowcharting tools found in Microsoft Word or Microsoft Visio - this can be software specifically developed for flowcharts or drawing tools with flowchart symbols
      • o Graphics software (such as MS Paint)

    • If you are having problems with the assignments, contact the instructor.
    • If you experience technical problems, you may find the course FAQ useful to answer some of your questions, so please consult the course and online learning FAQ first.
    • • Online Technical Support - If you don't find a fix, contact the instructor (see above for contact information) or you can contact the online technical support staff at (217) 875-7211 Ext.376. You may also e-mail the Online Learning Help Desk at However, the quickest way for students to get technical help from the Online Learning Help Desk is to fill out and submit the Technical Support Request form. Information submitted on the form is immediately e-mailed to the Help Desk, which is monitored throughout the workday, as well as on evenings and weekends. A help desk staff member will contact students within 12 hours of your submission, with a quicker response time during normal business hours of 7:30 a.m. to 4:30 p.m. Monday through Friday.
    • • Technical Resource Center - The Technical Resource Center is located in C239.  To use its services, you must have a student ID.  If you do not have a computer to use for this course or you do not have all the software required, you can use the computers in this center to complete your course.   If you need to use this center, please contact Computer tutoring can also be inquired about through this e-mail.
    • If you have technical difficulties with your system, you can e-mail for help.

    • • Course Components:
      • o The course is divided into sections, an orientation and several content modules. Each has the same components to be completed:
        • an introduction
        • readings
        • assignments (individual and group)
        • discussions
        • quizzes
        • exams
        • reflection journal
    • • Course Materials:
      • o Textbook readings are required. Other required and optional reading materials and handouts are available online. Course material may be in the form of Internet resources and web pages, text documents, audio files, online videos (Flash movies), and PowerPoint presentations. Technology will be used extensively during this course for presentation of online course material.
    • • Type of Instruction:
      • o Course instruction includes lecture, discussion, hands-on laboratory, problem-solving, reading, researching, writing, and interaction with the instructor and other students, which are used to help students gain knowledge about the topic area.  Labs and projects may incorporate both individual and group learning.  The Internet will be used for additional instructional resources and research.
      • o During this course, student preparation and participation will play important roles in the overall learning environment.  Substantial preparation will be required.  Be prepared to apply concepts you learning throughout the course, integrate them into projects, and use your critical thinking skills, logical analysis, and creativity.
      • o In addition to class reading assignments, to be successful in this course, students must engage the material in hands-on computer labs – nothing else will substitute for hands-on experience.  Some of this hands-on experience may be in the class labs. However, in order to fully complete all of the hands-on assignments, you will need to work on a computer outside of class. This can be accomplished by using a home computer that meets the system requirement, or can be completed in the open computer lab (Technical Resource Center) at Richland. Furthermore, the instructor recommends highly that students form study groups to help prepare, discuss, and assimilate the course material.
    • • On-Campus Sessions:
      • o Sessions: Ideally, this course consists of two hours of lecture and two hours of laboratory each week.  Both the lecture and the lab blocks of instruction are important – concepts discussed in the lecture may be clarified during the lab sessions, and questions during the lab may spark an in-depth discussion of a particular concept.  Student participation is required in both the lecture and lab sessions. Note: lab time during class sessions alone will not be enough time to complete the programming projects.
      • o Laboratory Time: Participation in labs is mandatory.  Lab time is to be used to complete hands-on assignments and serves as an opportunity to have questions about assignments answered.
      • o In-Class Participation: Active participation in class is expected.  This may be in the form of asking or answering questions, demonstrating a procedure to the class, helping fellow classmates during labs, or working on teams assigned by the instructor for group projects.
      • o Outside Work: There will be outside work for the course that will require the use of an IBM or compatible computer. Two hours or more of study for each class hour of lecture/discussion is usually needed for satisfactory performance and completion of this class, although this amount may vary from student to student.  In addition to the laboratories during class time, there will be a need to complete assignments outside of class - typically one hour of work outside of class for each hour of in-class laboratory time. Computer programming is time-consuming, and projects cannot be done properly without allowing enough time to code and debug them.  So for this course, a minimum of five hours of outside study and work per week may be required to be successful in this class. The instructor suggests that you schedule this amount of time to study and work for this class each week.
    • • Online Sessions:
      • o Some courses may have online components. The number of online components will depend upon the type of course it is. Regardless of the amount of instruction provided online, at minimum, a total of 10 hours per week of work for this course should be anticipated and scheduled.
      • o Types of Courses with Online Components:
        • ‡ Web-Enhanced - Instruction is delivered in a traditional, on-campus classroom, although the course is technology-enhanced. A limited amount of online instruction is provided (less than 25%). These courses have regularly scheduled meetings throughout the semester.
        • ‡ Blended - Instruction is delivered in a combination of on-campus sessions and online instruction, with online instruction comprising between 25% and 50% of the course. These courses usually include regularly scheduled class meetings throughout the semester, although the class meetings are less frequent than a traditional course. Students in blended courses should contact the instructor prior to the beginning of the semester to find out when on-campus meetings will be scheduled throughout the semester.
        • ‡ Hybrid - Instruction is delivered in a combination of on-campus sessions and online instruction, with online instruction comprising between 50% and 75% of the course. Students in hybrid courses should contact the instructor prior to the beginning of the semester to find out when on-campus meetings will be scheduled throughout the semester.
        • ‡ Virtual - All instruction (100%) is delivered online. No on-campus sessions are required for the course. However, optional on-campus sessions may be offered by the instructor as needed.
      • o Online Participation: Active online participation is expected. Your participation and logging on frequently will make this a much more enjoyable experience as well as informative. Some things you could post to get your participation credit:
        • Post any website address that you searched and found on the Internet that supplements concepts covered in the course. Give a summary of the websites along with the address. Remember first come first serve.
        • Post any tips or tricks from the course material you wish to share with the class.
        • Post examples of how you have applied the course material to a real life or work situation.
        • Post any questions you have about the material. A classmate may respond with an explanation by pressing Reply (This counts for both students for their participation grade in the class). This is called student-centered learning, which should be expected in all courses that have a virtual component.
    • • Course Assignments:
      • o Assignments for the course will be 2 main types:
        • ‡ Basic Concept Assignments - These may consist of handouts given by the instructor, discussion forums, or selected questions out of your textbook.
        • ‡ Projects - These consist of activities for directly applying and integrating the concepts presented in the course. In some cases, you will be given a case scenario to use in the development of the project. These projects will require you to use critical thinking skills, logical analysis, and creativity. They may be individual or group projects.
    • • Course Assessment:
      • o Quizzes
        • Quizzes will be in either questions in written form or a practicum (requiring program coding or hands-on activities), and may follow many chapters.  Each quiz will be worth 10 points.
      • o Exams
        • Exams MAY include matching, multiple choice, fill-in, and discussion questions, writing code, as well as a practical examination on the computer.  You should try to get all your chapter work, like assigned review questions and projects, done prior to taking each exam.  Each exam will be worth 100 points.  Make-up exams are allowed only in cases of extreme hardship and only when arrangements have been made prior to the scheduled exam day.  Students are accountable for all information assigned from the text, on the computer, or discussed in class sessions (unless otherwise noted by the instructor).  Do not assume that anything not discussed, yet assigned, will not be included on an exam. Note: If you cannot take an exam at the scheduled time, notify the instructor as soon as possible, so that a special time may be scheduled. Special exams will not necessarily be the same exam as the one given during the scheduled time.
    • • Course Management System:
      • o This course will use a course management system (CMS) for a variety of learning activities.
      • o The CMS used is called Angel. The various Angel tools that will be used include:
        • Learning Modules
          • ± Chapter Notes/Study Guides
          • ± Lecture PowerPoint Presentations
          • ± Handouts
          • ± Internet Resources
          • ± Assigned Readings
        • Announcements
        • Assignments
          • ± Individual Assignments
          • ± Individual Projects
          • ± Group Projects
        • Assessments
          • ± Quizzes
          • ± Exams
          • ± Surveys
        • Calendar
        • Discussion forums
          • ± Orientation Activities
          • ± Key Terms
          • ± Required Discussion Topics
          • ± News
          • ± General Questions
          • ± Help Line
          • ± Student Lounge
        • Chat
        • E-mail
        • FAQ
        • Glossary
        • Grade Book
        • Media Library
        • My Files (for uploading / downloading files)
        • Netiquette
        • Notes
        • Online Syllabus
        • Web Links
          • ± Faculty Web Site
          • ± College Web Site
          • ± Publisher's Textbook Companion Web Site
        • Wiki
        • Who's Online

    • Learning modules will be used to organize the course material.  There will be an orientation module with specific orientation activities to familiarize students with the course and give them an opportunity to use the various tools within the course management system (Angel).  The remaining modules will present units of content materials and will all have the same types of activities.
      • o Orientation Activities Module:
        • Introductions Discussion Forum
        • Course Expectations Discussion Forum
        • Background Knowledge Survey
        • Syllabus Quiz
        • E-mail to Instructor
        • Assignment with Attachment
      • o Content Modules:
        • Unit Topic Content
          • ± Required Readings (Textbook and Internet)
          • ± Handouts
          • ± Chapter Objectives
          • ± Chapter Notes/Study Guides
          • ± Chapter PowerPoint Lectures
        • Assignments
          • ± Discussion Forums
            • § Key Term Definitions
            • § Required Discussion Topics
          • ± Individual Assignments
            • § Chapter Review Questions
            • § Individual Chapter Projects
            • § Resources Wiki
            • § Reflection Journal Entries
          • ± Unit Group Project
        • Assessments
          • ± Self-Assessments (feedback provided but not included in course grades)
          • ± Chapter Quizzes
          • ± Unit Exam
          • ± Surveys (not graded but credit / points given for taking)

    • The Frequently Asked Questions (FAQ) page is a place where you will find answers to the most common questions asked by students in this course. Review these first when you have a question - you may just find an answer! (Click on the FAQ topic heading above to take you to the FAQ page).
    • Some topics you find may find helpful are:
      • o Username and Password Issues
      • o Submitting Assignments
      • o Technology Glitches
      • o How to contact the instructor
      • o Resources for Online Students

    • Several forms of communication will be used during this course and include the following:
      • o Discussion Forum
        • The discussion forum is the heart of this online course. It is where you will discuss your work with your classmates, communicate with your group members, and post several assignments. Discussion forums will be the primary means of communication to all participants in the course (it is public) and will be central to the participatory learning environment which you will experience in this course.
      • o Chat
        • For more extended synchronous discussions among multiple class members, we will use Angel's chat tool. These sessions will be set at times that are mutually agreed upon by all participating members.
      • o E-mail
        • As an alternative to the public discussion forums, personal e-mail can be used for communication with your instructor and your classmates privately.
      • o Messages
        • You can use the instant messaging function to send messages to classmates and the teacher when they are online. This is a synchronous function when used this way. When the person you want to contact is offline, you may send the message through the mail function.
      • o Telephone
        • The telephone is still sometimes the most effective mode for troubleshooting technology problems or other issues related to the course. Your instructor's phone number and other contact information can be found in the Instructor's Office section of the course.

    • A course calendar is provided with important course information and due dates. Click on the item links on the course calendar for further details and instructions. Since most assignments will be turned in online, due dates may not correspond with on-campus session dates. It is your responsibility to refer to this calendar to ensure that you meet the required due dates.

    • Netiquette
    • Academic Integrity
      • o The RCC academic policy clearly states an expectation that each student submit his/her own work.  Perhaps more importantly, it is a matter of professional ethics and personal integrity to graciously accept accolades for a job well done, while at the same time, publicly recognizing those to whom you relied upon in you endeavors.
      • o RCC Academic Dishonesty Policy - Each student is expected to be honest in his/her class work or in the submission of information to the College. Richland regards dishonesty in classroom and laboratories, on assignments and examinations, and the submission of false and misleading information to the College as a serious offense.  A student who cheats, plagiarizes, or furnishes false, misleading information to the College is subject to disciplinary action up to and including failure of a class or suspension/expulsion from the College.
      • o In keeping with the RCC policy and in an effort to promote professional ethics and personal integrity, every written submission MUST include a citation stating that the work is either the student’s own effort, or to what extent the student received assistance from others.   For example:
        ‘This entire submission is the sole work of Joe Student.
        -(Joe Student signature)’
        ‘This submission is the work of Jane Student, with the exception of case problem 4, on which assistance was provided by Guy Brain.
        -(Jane Student signature)’
        Failure to include such a citation will result in a reduction in grade.
      • o Anyone caught cheating will receive an F and may be suspended or expelled from the college.  (This is a college policy - See Richland Community College Catalog)
    • • Assignment Submission
      • o In order to pass the course, you must submit all required assignments, as assignments are a significant portion of your total grade.  It is expected that all activities assigned will be completed. If major projects are not turned in, you may not pass the course.    
      • o Accuracy: Make sure you are following all of the instructions correctly as you are completing each assignment.  Accuracy of following these instructions is important for receiving full credit for your assignments.  Check your work carefully prior to turning assignments in.
      • o Timeliness: Each assignment should be submitted by the due listed on the course calendar. The instructor reserves the right to not assign points to unit assignments turned in after the close of a unit (learning module). Note: Weekly assignments do not change even when classes do not meet or you are absent from class. In other words, you are still responsible for the assignments. Late assignments may be penalized according to the "timeliness" scoring in the assignment rubrics.
      • o Mode of Submission: Assignments may be turned in as follows:
        • ‡ In Person: Assignments may be turned in to the instructor in person in 2 ways:
          • ± Paper Assignments - In an attempt to reduce paper usage and cut down on assignments being lost, most assignments will be turned in electronically. Although electronic submissions are preferred, occasionally paper assignments will be assigned or accepted. All assignments submitted by paper should be labeled with your full name, course number, date, name of assignment or project.  
          • ± Note: some assignments cannot be turned in on paper and must be submitted in an electronic format. Refer to the individual assignment instructions for details.
          • ± Electronic Assignments - All electronic assignments will be turned in on electronic media that is properly labeled (same as paper assignments).
        • ‡ Electronically: All assignments may be turned in as electronic documents or files. Some submissions may require you to zip the files in order to submit them. There are 2 ways to submit assignments electronically:
          • ± E-Mail - Electronic documents and files may be submitted as an attachment to an e-mail to the instructor.  
          • ± Angel - Electronic documents and files may be submitted as an attachment to the assignment links in Angel. This is the preferred way to submit assignments. In addition, some assignments may use postings to discussion boards or typing answers in the submission box of a Angel assignment.
      • o Extra Credit: The instructor may give opportunities for extra credit throughout the course, but these will be considered for extra credit only if the extra credit criteria are met. There are several ways to obtain extra credit points.
        • ‡ Additional Work: Extra credit points may be obtained by turning in any additional projects (projects not required by the instructor but designated as being eligible for extra credit), provided that the extra credit criteria has been met and all of the required material for the chapter or module has been completed. No extra projects will be accepted after the due date for required assignments for that chapter or module, unless indicated by the instructor, nor will extra credit assignments be submitted in the place of the required projects. The amount of extra credit points assigned to additional work will vary dependent on the complexity of the work and is at the discretion of the instructor.
        • ‡ Early Submission of Work: Assignments may be turned in early. However, be sure to thoroughly check your work before turning it in.  There will be no second chances.  Assignments turned in early (before the day due), will be eligible for 5 extra credit points if the extra credit criteria has been met.
        • ‡ Extra Points on Exams: Frequently, the instructor will provide opportunities to obtain extra credit points on exams by answering additional questions or completing extra credit sections of the exam. These points will be awarded based on accuracy (correctness) and completeness.
        • ‡ Extra Credit Criteria: In order to receive extra credit points for assignments, you much meet the following extra credit criteria:
          • ± Assignment must be error-free and complete
          • ± All required, assigned work must be turned in for the module prior to submitting the extra credit assignments for the module
          • ± Unexcused excessive absences (missing over a week) from class (either on-campus or online) may disqualify you from receiving extra credit points.
    • • Electronic File Procedures
      • o Student Data Files
        • Some assignments may require you to download data files before they can be completed. These may be provided by the instructor in Angel or available from the textbook publisher's website. Refer to the instructions on the individual assignments for details on what data files are required and how to obtain them.
      • o Making Backups
        • You must backup your work on a regular basis to prevent loss of your work. (Copy all files from one location to another location so that you have 2 exact copies of your work).  It is your responsibility to make a back up of your assignments before turning them in to the instructor for grading.
        • You will need to back up your work on a regular basis, as re-doing an assignment you have spent many hours working on is not a pleasant task.
      • o Virus scanning
        • You must virus check all the files with an anti-virus program before submitting any files.  This is your responsibility and if you submit any assignment with a virus, you will lose credit for those assignments.  You will need to make sure that your anti-virus software is updated regularly because new viruses are continually being invented, unfortunately.  Do not assume that you have the most up-to-date anti-virus software even if you have just purchased a new computer or new software.  You can usually update you anti-virus software by downloading updates from the Internet.  This should probably be done once a week for the most recent updates and no less than once a month. This will prevent you from potential damage to your computer as well as to other computers.
      • o E-Mail
        • ‡ E-mail Address:
          • ± Many download sites you may be using for this course require an e-mail address and correspondence for the course may required you to use e-mail. You are required to have a Richland e-mail address for this course. This e-mail account is free and available to all registered students. You may activate your account up by going to the myRichland page of Richland Community College's website and clicking on the link entitled "Activate Account" and following the directions. By activating your account, you are also able to sign in to any of the computers while on campus and access Angel courses, as this sets up your Richland NetID, for single sign-on. You must activate your account by no later than the end of the first week of class.
        • ‡ Sending E-mail:
          • ± Make sure that your e-mail includes the following:
            • § always start your subject line with the course number
            • § the subject section of your e-mail should be well-labeled to briefly but clearly state what your message is about (short description of your message)
            • § your name (put this in the body of your e-mail)
        • ‡ Sending Attachments:
          • ± When sending assignments as an e-mail attachment, in addition to the above requirements, do the following:
            • § label each one of assignments properly
            • § put the name of the assignment in the subject line of your e-mail
            • § make sure that the assignment is actually attached before sending
            • § if an assignment requires you send more than one file, make sure that you send all required files, either in one e-mail or in multiple e-mails (only if necessary) - if more than one is necessary number them like this: 1 of 3, 2 of 3, 3 of 3, etc.
            • § if you do not label your e-mailed assignments properly, you may not receive credit for your work.
        • ‡ Replies to E-mail:
          • ± The instructor will respond to questions you have which are of a personal or confidential nature by private e-mail (i.e., grades, personal issues, reasons for missed assignments, notifying instructor of absence from class). Some e-mail does not require a response, for example, turning in a project.  If there is a question in an e-mail, I will try to respond within 24 hours Monday-Friday.
    • • Student Record Keeping
      • o It is your responsibility to record your grades so that you know what you have made on assignments, projects, quizzes, and tests. Since most assignment will be submitted in Angel and graded within Angel, you may refer to the score recorded in the "my grades" section to stay up-to-date.
    • • Internet Research
      • o If using the Internet to do research, be careful to "consider the source".  When you do a search on the Internet keep in mind that everyone and anyone in the world can say what they want to about anything and anybody.  Be sure you are finding material that is from a reputable company, school, or expert in the field.
    • Resource Referencing
    • • Course Participation
      • o Active course participation is expected in this course and is part of the requirements for many of the assignments you will have online. The participants drive this course through synchronous and asynchronous discussion and interaction. It requires you to be an active participant and to contribute to the learning process. Since this course is based on student-centered learning, you will learn from each other by posting questions and responding to each others questions. Sometimes I will answer the questions, but classmates should jump in there and answer questions that come up in the discussions. Participation can be both in-class participation and online participation. Some course activities have a graded participation component and will be assigned points.
      • o The ability to contribute information and your informed opinions in meetings with colleagues and employers is an important skill. In this class, we emphasize discussion not only as a means of covering information and eliciting students’ views, but also to help students develop oral communication skills. The collaborative exercises and peer review workshops that we use to improve skills are dependent upon consistent contributions from all members of the class. Everyone is expected to be a thoughtful participant in the class. Not only do you learn less when you aren’t engaged in discussions, but you also make the class as a whole less lively, less enjoyable, and ultimately less educational for everyone. I will be observing your participation throughout the semester and will factor those observations into your participation score.
      • o Note: Since our on-campus sessions are in a computer lab, you may be tempted to send instant messages, play games, check your e-mail, or engage in other non-class-related activities during our class hour. Please note that I am neither blind nor deaf—I’m perfectly aware when students are playing instead of being attentive. Since engaging in such activities shows a lack of commitment to the class and is disrespectful to your classmates and to the instructor, violating two of the five core values (Excellence, Respect), I’ll invoke the Accountability core value and hold you responsible for your actions by severely docking your attendance/participation score. If such activities actually become disruptive to the course, you may be dropped for engaging in disruptive behavior.
    • • Attendance
      • o Regular attendance is necessary for satisfactory completion of college work.  Class attendance is recorded.  Attendance is expected in all scheduled class sessions.  (The RCC attendance policy may be found in the Academic Information & Regulations section of the RCC Bulletin).  This policy will be followed accordingly.  Students who cannot be in attendance should contact the instructor prior to the beginning of the class session that will be missed.
      • o Attendance takes the form of attending on-campus sessions and/or logging onto the online course and completing postings. Attendance does not affect number of points earned; however students will be dropped if they miss class or posting to the Angel discussion board during the first week of class or if they are not regularly attending class at midterm.  (This is college policy - See Richland Community College Catalog)  
      • o The student may be administratively dropped from the course if the student has unsatisfactory attendance during the period from midterm through the last regular week of class before finals.   However, students are not to assume they will be automatically dropped and should complete a drop slip available in the SDS office or any academic division office.  It ultimately the responsibility of the student to drop a course.
      • o Any student missing more than two consecutive classes will be considered at risk for being administratively dropped.  If a student is absent for one week plus one day, his/her name may be sent to SDS.  Students with unsatisfactory attendance will be sent a “stopped attending” letter.  Students who stop attending a class without officially dropping a class and who are not administratively dropped may receive a grade of “F” for the course.
    • • Class Rules
      • o Smoking, food, or beverages are not permitted in the classrooms.
      • o No children are to be brought to class.
      • o Pagers and cell phones should be turned off or set in the vibrate mode during class times and cell phone usage during class times will not be tolerated. If you must make a call, you should leave the classroom out of courtesy to your classmates.
      • o During class time, it is expected that students will engage in activities that enhance learning of the subject matter. Therefore playing computer games during class time is strictly prohibited.
      • o Students are asked be courteous to the instructor and classmates by refraining from behaviors that can be disruptive during lectures such as printing documents, moving around the classroom, or talking (other than during discussion times).
      • o The instructor reserves the right to ask any student to leave the classroom if he/she does not follow class rules.
    • • Use of College Computers
      • o All students using the college computers must comply with the RCC policies regarding Responsible Use of Information Technology.
        • Access to the College’s information technology facilities is a privilege granted to College students, faculty, and staff. The College reserves the rights to extend, limit, restrict, or deny privileges and access to its information resources. Individuals other than College faculty, staff, and students may be permitted access to information technology provided such access does not violate any license or contractual agreement.
        • All members of the College community who use the College’s computing, information, and communication resources must act responsibly. All users of College-owned or College-leased information technology systems must respect the rights of other users, respect the integrity of the physical facilities and controls, and comply with all pertinent licenses and contractual agreements. All users of the technology systems are bound by applicable local, state, and federal laws and regulations.
        • Information technology provides important means of communication, both public and private. Users will respect the privacy of person-to-person communication in all forms including, but not limited to, voice (telephone), text (electronic mail and file transfer), and image (graphics and television).
        • College facilities and accounts are to be used for the activities or purposes for which they are assigned. College computing resources are not to be used for commercial purposes without written authorization from the College.
    • • Early Alert System
      • o The instructor will utilize the early alert system as described in the Student Support Services section below whenever she feels that a student is at risk of being unsuccessful in the course. The purpose of this system is to make students aware of resources on campus that can allow them to achieve success in the course.
    • • Student Accountability
      • o Each student is responsible for all announcements, changes in assignments, and other information given in class, whether you are in attendance or not. Therefore, I suggest that you trade telephone numbers with a classmate in case you cannot reach me for your assignment. Better yet, attend every class. You are responsible for your learning. If you are having problems in class, you need to contact your instructor.
    • • Course Withdrawal
      • o A student may drop a course through the last day before final exam week of any term.  A grade of “W” will be recorded for the course dropped.  Students are encouraged to consult with their instructor before dropping a course.  In order to withdraw from a course, a “Change of Schedule” form must be obtained (available SDS or any academic division office) and signed by the class instructor.  Formal voluntary withdrawal from the course is the responsibility of the student.
    • • Changes to Syllabus
      • o The administration of this course may be modified from the guidelines in this syllabus when deemed necessary by the instructor for the benefit of the majority of the students. All variances from the stated guidelines in the syllabus and the course schedule will be clearly communicated to the students. The instructor may announce changes, as necessary, to any syllabus throughout the semester.
    • • College Calendar and Closings
      • o Check the RCC school calendar for school holidays and other important dates during the semester at
      • o In the event that the college has an unscheduled closing (weather or disaster-related), check the home page of the Richland website or call the main Richland phone number for a recorded message. Notification will also be made through local TV and radio station broadcasts.
    • • Learning Accommodations
      • o It is expected that tests and quizzes will be taken only in the manner specified by the instructor.  Legally documented special needs must be discussed with the instructor at least one week in advance of a special accommodation need.  The Assessment Service Center is not normally used by the instructor.  Other arrangements will be made when accommodation sheets from the Learning Accommodations Office designate a need.  If you believe you need a learning accommodation, you will need to contact the Learning Accommodations Office (see Student Support Services section below). The official accommodations will be afforded when requested.  
    • • Tutoring
    • • Human Relations Policy
      • o This course incorporates concepts regarding all races, creeds, sexes, and ethnic groupings, and the belief that they must learn to live together.

    • • RCC Enrollment and Retention Services - Student Support
      • o Admissions and Records Office
        • 217-875-7211, Ext. 255, C129
        • Students must be registered in this course through the Admissions and Records Office. If you do not appear on the faculty roster, you will be referred to Admissions and Records to determine why you are not appearing on the roster and are not registered for this course.
        • If a student is absent for one week plus one day (or less, if specified by the instructor in the course outline), his or her name may be sent to the Admissions and Records Office. Students with unsatisfactory attendance will be sent a “stopped attending” letter.
      • o Counseling and Career Services
        • C-129, 217-875-7211, Ext. 252
        • offers career and personal counseling
      • o Career and Transfer Center
        • C-129, 217-875-7211, Ext. 307
        • offers career assessments, job placement information and transfer information and assistance
      • o Learning Accommodation Services
        • C-133, 217-875-7211, Ext. 379
        • services for students with disabilities
        • ‡ Students needing accommodations: Richland Community College offers support and accommodations to students with documented disabilities by providing advisement, counseling, adaptive equipment and materials, instructional aids, tutors, note takers, interpreters, and testing accommodations, as well as many individualized services. For more information, students should contact the Learning Accommodation Services Office, Room C136. Documentation of disability is required for all services.
      • o Student Support Services/TRIO Program
        • ‡ C-143, 217-875-7211, Ext. 440
        • ‡ a program students can apply to for additional academic and personal support
      • o Student Success
        • C-129, 217-875-7211, Ext. 232
        • provides services for students experiencing academic difficulty
        • ‡ AWARE:
          • ± (Adults who are returning to education) is a program for adult students desiring academic and personal support.
        • ‡ ESP:
          • ± (Emerging Scholars Program) is a program for students who have experienced academic difficulty and desire support to become successful students.
        • ‡ ISTEP:
          • ± services and support for divorced, widowed or separated persons
      • o Student Learning Center
        • Room S117, 217-875-7211, Ext. 419
        • Offers free tutoring to students who may need help with classes or programs. Both peer and faculty tutors are available on an appointment or drop-in basis for many areas including math, biology, chemistry, reading comprehension, study skills, vocabulary building, research, and specific written assignments. Biology and chemistry tutoring is available with hours varying each semester. In cooperation with other academic programs, the SLC may offer study groups each semester. Schedules with locations and time are posted in the Center. Computers with tutorial software and word processing programs are available for student use any time the SLC is open.
      • o Testing Center
        • 217-875-7211, 238, W124
        • Provides testing services for placement in English, mathematics, and health courses. Proctors also administer CLEP and DANTES, proficiency tests, correspondence tests from other universities, and make-up tests for classes with the permission of the instructor, Constitution Test, GED practice and Constitution tests.
      • o Early Alert - Message from the Student Success Coordinator
        • If at any time the instructor believes that a student is at risk of being unsuccessful in the course, the instructor may notify the Student Success office. This office will in turn contact the student suggesting assistance options.
      • o Message from the Carl Perkins Federal Grant Administrator
        • The Perkins program is a federally-funded program designed to assist students in helping them become academically successful.  
        • For a student to be eligible for the Perkins Program, they must be enrolled in an occupational technical program pursuing a Certificate, Basic Certificate, Advanced Certificate or an Associate in Applied Science and meet one of the following requirements:
          • ± Student is enrolled in a non-traditional field for their gender (i.e. male in Office Technology)
          • ± English is the student’s second language
          • ± Student is considered low income
          • ± Student has taken or is required to take a developmental math or English (course(s) numbered below 100)
          • ± Student has a disability
          • ± Student is a single parent (including single, pregnant women) or a displaced homemaker
          • ± Any individual with other barriers to educational achievement
        • Perkins support must match the need of the students based on the criteria that they were eligible under. If a student is enrolled in an occupational area, he or she is automatically enrolled in the Perkins Program.  Students who are enrolled in selected occupational programs may receive additional academic support including, but not limited to, opportunities for job shadowing, career exploration, professional mentoring, tutoring, emergency book and transportation assistance, childcare assistance, workshops, field trips, resume writing assistance, lab fee and class supply reimbursement for qualified students and other individualized services. If you are unsure if the Perkins Program can assist you, call for a confidential appointment by contacting the Perkins Program office at 875-7211, ext. 223 or stop by E185.
        • All students should apply for financial aid (forms can be obtained from Student Development and Services on the first floor). Funding for the Carl Perkins Program is based on the number of students requesting financial aid.

    • The following is an outline of the order in which topic modules will be covered. The exact dates and due dates for assignments and exams can be found on the class calendar and are subject to change with notice.
      • o Week 1 - Orientation Module
      • o Week 2 - Introducing Relational Databases
      • o Week 3 - Database Design Fundamentals
      • o Week 4 - Introduction to SQL
      • o Week 5 - Storing and Retrieving Data: The Basics
      • o Week 6 - Single-Table Queries
      • o Week 7 - Multiple-Table Queries
      • o Week 8 - Updating Data
      • o Week 9 - Performing Advanced Data Manipulation: Indexes, Joins, and Subqueries
      • o Week 10 - Creating a Program with MySQL
      • o Week 11 - Reading a Data Model
      • o Week 12 - Basics of Designing a Database’s Structure
      • o Week 13 - Normalization
      • o Week 14 - Analyzing Data Quality Issues
      • o Week 15 - Database Administration
      • o Week 16 - Final Project
      • o Finals Week - Final Exam and Project
SQL Book