INFO 246-11
Information Technology Tools and Applications Advanced
Topic: MySQL in Depth
Summer 2021 Syllabus
| Syllabus Links Textbooks CLOs Competencies Prerequisites |
Course Links Instructor Information |
Resources iSchool eBookstore |
Canvas Information: Courses will be available beginning June 1st, 6 am PT unless you are taking an intensive or a one-unit or two-unit class that starts on a different day. In that case, the class will open on the first day that the class meets.
You will be enrolled in the Canvas system automatically.
Course Description
This course covers the various features of SQL using MySQL in depth.
Students will learn to manipulate data in a database, create tables and indexes, handle security,
control transaction processing, and learn the basics of how to design a database.
Course Requirements
Important Dates
Info 246 - MySQL- Syllabus
Semester: Summer 2021 (2021-06-01 through 2021-08-06)
Class No: 30027
The FINAL DATE for this class is 2021-08-06
No assignments or exams will be accepted after that date!
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 4-day grace period on all assignments. This means you can turn in an assignment up to 4 days past the due date with no penalty. (As long as it is not past the last day of the semester.)
If you contact me before the grace period has passed, I may extend an assignment due date for you, if need be. The important thing is to contact 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.
Assignments and Due Dates
| Lesson | Assignment | Due Date | Points Possible |
| Introduction to SQL | Assignment-1 | 2021-06-06 | 6 |
| Basic SQL Statements | Assignment-2 | 2021-06-10 | 6 |
| Restricting Data - Part 1 | Assignment-3 | 2021-06-14 | 6 |
| Joining Tables | Assignment-4 | 2021-06-20 | 4 |
| Summarizing Data | Assignment-5 | 2021-06-24 | 4 |
| Joining Multiple Tables | Assignment-6 | 2021-06-28 | 4 |
| Data Subsets | Assignment-7 | 2021-07-02 | 4 |
| Restricting Data - Part 2 | Assignment-8 | 2021-07-06 | 6 |
| Subqueries | Assignment-9 | 2021-07-10 | 4 |
| Data Modeling | Assignment-10 | 2021-07-14 | 4 |
| Manipulating Tables and Data | Assignment-11 | 2021-07-18 | 12 |
| Single-Row Functions | Assignment-12 | 2021-07-22 | 6 |
| Creating and Using Views | Assignment-13 | 2021-07-26 | 6 |
| Management and Security | Assignment-14 | 2021-07-30 | 6 |
| Legacy SQL Techniques | Assignment-15 | 2021-08-03 | 4 |
| Participation | 2021-08-06 | 8 | |
| Final Exam | 2021-08-06 | 10 | |
| Total: | 100 |
| Lesson | Assignment | Assignment Supports... |
| Introduction to SQL | Assignment-1 | CLO #1 |
| Basic SQL Statements | Assignment-2 | CLO #2 |
| Restricting Data - Part 1 | Assignment-3 | CLO #2 |
| Joining Tables | Assignment-4 | CLO #2 |
| Summarizing Data | Assignment-5 | CLO #2 |
| Joining Multiple Tables | Assignment-6 | CLO #2 |
| Data Subsets | Assignment-7 | CLO #2 |
| Restricting Data - Part 2 | Assignment-8 | CLO #2 |
| Subqueries | Assignment-9 | CLO #3 |
| Data Modeling | Assignment-10 | CLO #1 |
| Manipulating Tables and Data | Assignment-11 | CLO #4 |
| Single-Row Functions | Assignment-12 | CLO #2 |
| Creating and Using Views | Assignment-13 | CLO #2 |
| Management and Security | Assignment-14 | CLO #1 |
| Legacy SQL Techniques | Assignment-15 | CLO #2 |
Required Reading
It is necessary to read all of the Web pages that I have posted in each Lesson and Assignment 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.
Course Prerequisites
INFO 246 has no prequisite requirements.
Course 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)
INFO 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.
Textbooks
No Textbooks For This Course.
Grading Scale
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 |
| Below 67 | F |
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 or undergraduate (for BS-ISDA);
For core courses in the MLIS program (not MARA, Informatics, BS-ISDA) — 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 if you wish to stay in the program. 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.
Graduate Students are advised that it is their responsibility to maintain a 3.0 Grade Point Average (GPA). Undergraduates must maintain a 2.0 Grade Point Average (GPA).
University Policies
Per University Policy S16-9, university-wide policy information relevant to all courses, such as academic integrity, accommodations, etc. will be available on Office of Graduate and Undergraduate Programs' Syllabus Information web page at: https://www.sjsu.edu/curriculum/courses/syllabus-info.php. Make sure to visit this page, review and be familiar with these university policies and resources.
In order to request an accommodation in a class please contact the Accessible Education Center and register via the MyAEC portal.
Download Adobe Acrobat Reader to access PDF files.
More accessibility resources.