Information Technology Tools and Applications - Advanced
Topic: MySQL in Depth
Summer 2015 Greensheet
Class Web Site
This class does not use Canvas! The class Web site is found at: http://profperry.com
This course covers the various features of SQL using MySQL in depth.
Student will learn to manipulate data in a database, create tables and indexes, handle security,
control transaction processing, and learn the basics on how to design a database.
Libr 246 - MySQL- Syllabus
Semester: Summer2015 (2015-06-01 through 2015-08-07)
Class No: 30088
The FINAL DATE of this class is 2015-08-07
No assignments or exams will be accepted after that date!
You must actively use the class Web site at least once per each week to considered in attendence that week. The following activities that show attendence are: logging into to this site, clicking on a link to read a lesson/assignment, or submitting an assignment.
Any student who fails to log in to the class Web site for 21 consecutive days during the semester will be dropped from the class and receive the grade of 'W', if dropped before the Official Withdrawal date posted on the college's Web site.
Particiption is required in the class Discussion Area and will count as 10% (10 points) of of your grade.
To receive participation credit for that week you must make at least one substantial posting to the discussion area. This can be a thoughtful question to the class, reply to another student's question, or an answer to one of the questions I pose in "Instructor Questions" discussion area.
Again, your answers must be substational (not merely "I agree!", etc.) and not a slightly reworked answer from someone else.
You will recieve a maxium of 1 point per week for participation credit no matter how many posts you make that week. No more than 10 weeks particiption will be counted. That is, 1 point per week for 10 weeks will get you the full 10 points participation credit.
Assignment Due Dates
The due dates for all assignments are listed in the "Lessons and Assignments" area. They are also listed in each assignment.
There is a 7-day grace period on all assignments. This means you can turn in an assignment up to 7 days past the due date with no penalty. (As long as it is not past the last day of the semester.)
Assignments turned in more than 7 days past their due date will receive zero points and you will not be allowed to submit the assignment unless we have a specific agreement specifying otherwise.
If you contact me before the grace period is past, I may extend an assignment due date for you, if need be. The important thing is to ontact me BEFORE time runs out!
ANOTHER NOTE: It is wise to aim to submit the assignment by the actual posted due date. That way, if you need extra help from me, you have the time to get it.
|Introduction to SQL||Quiz-01||Assignment supports SLO #1|
|Introduction to SQL||Quiz-02||Assignment supports SLO #1|
|Basic Database Design||Quiz-03||Assignment supports SLO #1|
|Basic Database Design||Quiz-04||Assignment supports SLO #1|
|Basic Select Statement||Quiz-05||Assignment supports SLO #2|
|Basic Select Statement||Quiz-06||Assignment supports SLO #2|
|Basic Select Statement||Quiz-07||Assignment supports SLO #2|
|Creating Tables||Quiz-08||Assignment supports SLO #4|
|Creating Tables||Quiz-09||Assignment supports SLO #4|
|Sorting and Functions||Quiz-10||Assignment supports SLO #2|
|Sorting and Functions||Quiz-11||Assignment supports SLO #2|
|Grouping Data||Quiz-12||Assignment supports SLO #2|
|Grouping Data||Quiz-13||Assignment supports SLO #2|
|Joins||Quiz-14||Assignment supports SLO #2|
|Joins||Quiz-15||Assignment supports SLO #2|
|Subqueries||Quiz-16||Assignment supports SLO #3|
|Subqueries||Quiz-17||Assignment supports SLO #3|
|Subqueries||Quiz-18||Assignment supports SLO #3|
|Data Manipulation||Quiz-19||Assignment supports SLO #4|
|Data Manipulation||Quiz-20||Assignment supports SLO #4|
|Data Manipulation||Quiz-21||Assignment supports SLO #4|
|Views||Quiz-22||Assignment supports SLO #2|
|Views||Quiz-23||Assignment supports SLO #2|
|Database Management||Quiz-24||Assignment supports SLO #1|
|Database Management||Quiz-25||Assignment supports SLO #1|
|Solving Bus. Problems||Quiz-26||Assignment supports SLO #1|
|Solving Bus. Problems||Quiz-27||Assignment supports SLO #1|
It is necessary to read all of the Web pages that I have posted in each Lesson and Assignments and view all of the video presentations posted as well.
Course Workload Expectations
Success in this course is based on the expectation that students will spend, for each unit of credit, a minimum of forty-five hours over the length of the course (normally 3 hours per unit per week with 1 of the hours used for lecture) for instruction or preparation/studying or course related activities including but not limited to internships, labs, clinical practica. Other course structures will have equivalent workload expectations as described in the syllabus.
Instructional time may include but is not limited to:
Working on posted modules or lessons prepared by the instructor; discussion forum interactions with the instructor and/or other students; making presentations and getting feedback from the instructor; attending office hours or other synchronous sessions with the instructor.
Student time outside of class:
In any seven-day period, a student is expected to be academically engaged through submitting an academic assignment; taking an exam or an interactive tutorial, or computer-assisted instruction; building websites, blogs, databases, social media presentations; attending a study group;contributing to an academic online discussion; writing papers; reading articles; conducting research; engaging in small group work.
LIBR 202, other prerequisites may be added depending on content.
Student Learning Outcomes
Upon successful completion of the course, students will be able to:
- Identify the features of SQL.
- Query a database using SQL.
- Utilize subqueries in the database.
- Modify data in a database using SQL.
Core Competencies (Program Learning Outcomes)
LIBR 246 supports the following core competencies:
- E Design, query, and evaluate information retrieval systems.
- G Demonstrate understanding of basic principles and standards involved in organizing information such as classification and controlled vocabulary systems, cataloging systems, metadata schemas or other systems for making information accessible to a particular clientele.
- H Demonstrate proficiency in identifying, using, and evaluating current and emerging information and communication technologies.
No Textbooks For This Course.
The standard SJSU School of Information Grading Scale is utilized for all iSchool courses:
|97 to 100||A|
|94 to 96||A minus|
|91 to 93||B plus|
|88 to 90||B|
|85 to 87||B minus|
|82 to 84||C plus|
|79 to 81||C|
|76 to 78||C minus|
|73 to 75||D plus|
|70 to 72||D|
|67 to 69||D minus|
In order to provide consistent guidelines for assessment for graduate level work in the School, these terms are applied to letter grades:
- C represents Adequate work; a grade of "C" counts for credit for the course;
- B represents Good work; a grade of "B" clearly meets the standards for graduate level work;
For core courses in the MLIS program (not MARA) — INFO 200, INFO 202, INFO 204 — the iSchool requires that students earn a B in the course. If the grade is less than B (B- or lower) after the first attempt you will be placed on administrative probation. You must repeat the class the following semester. If -on the second attempt- you do not pass the class with a grade of B or better (not B- but B) you will be disqualified.
- A represents Exceptional work; a grade of "A" will be assigned for outstanding work only.
Students are advised that it is their responsibility to maintain a 3.0 Grade Point Average (GPA).
General Expectations, Rights and Responsibilities of the Student
As members of the academic community, students accept both the rights and responsibilities incumbent upon all members of the institution. Students are encouraged to familiarize themselves with SJSU's policies and practices pertaining to the procedures to follow if and when questions or concerns about a class arises. See University Policy S90-5 at http://www.sjsu.edu/senate/docs/S90-5.pdf. More detailed information on a variety of related topics is available in the SJSU catalog at http://info.sjsu.edu/web-dbgen/catalog/departments/LIS.html. In general, it is recommended that students begin by seeking clarification or discussing concerns with their instructor. If such conversation is not possible, or if it does not serve to address the issue, it is recommended that the student contact the Department Chair as a next step.
Dropping and Adding
Students are responsible for understanding the policies and procedures about add/drop, grade forgiveness, etc. Refer to the current semester's Catalog Policies section at http://info.sjsu.edu/static/catalog/policies.html. Add/drop deadlines can be found on the current academic year calendars document on the Academic Calendars webpage at http://www.sjsu.edu/provost/services/academic_calendars/. The Late Drop Policy is available at http://www.sjsu.edu/aars/policies/latedrops/policy/. Students should be aware of the current deadlines and penalties for dropping classes.
Information about the latest changes and news is available at the Advising Hub at http://www.sjsu.edu/advising/.
Consent for Recording of Class and Public Sharing of Instructor Material
University Policy S12-7, http://www.sjsu.edu/senate/docs/S12-7.pdf, requires students to obtain instructor's permission to record the course and the following items to be included in the syllabus:
- "Common courtesy and professional behavior dictate that you notify someone when you are recording him/her. You must obtain the instructor's permission to make audio or video recordings in this class. Such permission allows the recordings to be used for your private, study purposes only. The recordings are the intellectual property of the instructor; you have not been given any rights to reproduce or distribute the material."
- It is suggested that the syllabus include the instructor's process for granting permission, whether in writing or orally and whether for the whole semester or on a class by class basis.
- In classes where active participation of students or guests may be on the recording, permission of those students or guests should be obtained as well.
- "Course material developed by the instructor is the intellectual property of the instructor and cannot be shared publicly without his/her approval. You may not publicly share or upload instructor generated material for this course such as exam questions, lecture notes, or homework solutions without instructor consent."
Your commitment, as a student, to learning is evidenced by your enrollment at San Jose State University. The University Academic Integrity Policy F15-7 at http://www.sjsu.edu/senate/docs/F15-7.pdf requires you to be honest in all your academic course work. Faculty members are required to report all infractions to the office of Student Conduct and Ethical Development. The Student Conduct and Ethical Development website is available at http://www.sjsu.edu/studentconduct/.
Campus Policy in Compliance with the American Disabilities Act
If you need course adaptations or accommodations because of a disability, or if you need to make special arrangements in case the building must be evacuated, please make an appointment with me as soon as possible, or see me during office hours. Presidential Directive 97-03 at http://www.sjsu.edu/president/docs/directives/PD_1997-03.pdf requires that students with disabilities requesting accommodations must register with the Accessible Education Center (AEC) at http://www.sjsu.edu/aec to establish a record of their disability.
Download Adobe Acrobat Reader to access PDF files.
More accessibility resources.