ISDA 20A-10 (1-unit)
Query Languages
Summer 2021 Syllabus

Frank Torres
Email
Office:  By Appt
Phone:  480-528-9188
Office Hours: Virtual office hours. Telephone and Zoom by appointment


Syllabus Links
Textbooks
CLOs
Resources
Canvas Login and Tutorials
iSchool eBookstore
 

Canvas Information: This 1-unit course runs from June 7th - July 2nd. It will be available on Canvas on June 7th at approximately 6 am PT.

You will be enrolled in the Canvas site automatically.

Course Description

Introduces students to the features and functionalities of structured query language (SQL) focusing on manipulating data in a database, creating tables and indexes, modifying stored records, creating database objects.

Relevant Information:

Home computing requirements are posted online for prospective students. Students must meet those minimum requirements to participate in the activities for this course. 

You will be required to install the mySQL database (free) on your home computer for this class.  

Library Liaisons 

Gareth Scott (gareth.scott@sjsu.edu) and DeeAnn Tran (deeann.tran@sjsu.edu

Course Requirements and Assignments 

This schedule, and related dates/readings/assignments, is tentative and subject to change with fair notice. Any changes will be announced in due time in class and on the course’s website in the Canvas Learning Management System. The students are obliged to consult the most updated and detailed version of the reading material and syllabus, which will be posted on the course’s website.

Detailed information on assignments and the final exam will be provided on the course Canvas site.

Forum Discussions (supports CLOs 1,2,3,4,5; 9 points) 

There will be one weekly discussion topic that you need to respond to. To obtain full credits, the student should need to write an original post on the assigned topic before the submission deadline. The post should be 2 to 3 paragraphs (50 to100 words) and should use the terms, concepts, and theories covered in the weekly material (or assigned readings). The answers must be substantial and convey understanding of the topic assigned.  

Weekly Assignments (supports CLOs 1,2,3,4,5; 70 points) 

Each student will have to complete 3 assignments throughout the semester, which is worth 70% of the course grade. Each assignment will consist of various steps to complete in order to demonstrate the understanding the material and concepts covered in the chapter material and course material. 

Final Exam (supports CLOs 1,2,3,4,5; 21 points) 

The goal of the final exam is to assess whether the student has successfully met the learning outcomes of this class.  There will be two parts:  short-answer and skills-based responses.  The skills-based portion will require the student to perform a range of SQL statements including queries to demonstrate their understanding of the material.  The final based exam will be assigned on or before the final week of classes and the students will have until the scheduled final exam date and time to submit the responses electronically. 

Grading Information  

Grading information will be available for the finalized course assignments. A tentative plan has been provided in this section. 

Final Evaluation 

The final evaluation of students in this course is through the final exam, as detailed in the Course Assignments section. 

Grading will be based on a total accumulation of possible 100 points, distributed as follows: 

Deliverables 

Points (Total = 100) 

Weekly Assignments 

70

Forum Discussions 

9

Final Exam 

21

Course Schedule 

This schedule and related dates/readings/assignments is tentative and subject to change with fair notice. Any changes will be announced in due time on the course’s website in the Canvas Learning Management System. The students are obliged to consult the most updated and detailed version of the reading material and syllabus, which will be posted on the course’s website. 

Module 

Topics  

Assignments and Activities 

Learning Outcomes 

Introduction 

Setup mySQL environment
and database environment

What is SQL? 

Writing basic SQL queries using the SELECT statement 

Activity: Discussion Forum  

Complete Assignment #1 

Participate in Discussion #1 

CLO 2, 3 

Key objectives this week: 

  • AND, OR, NOT logical operators 

  • IN operator 

  • BETWEEN operator 

  • LIKE operator 

  • ORDER BY 

  • LIMIT 

  • Table aliases 

  • Joining multiple tables together 

Complete Assignment #2 

Participate in Discussion #2 

CLO 1,2,3,5 

Key objectives this week: 

  • Modify data in a database. 

  • Creating tables 

  • INSERT, UPDATE, DELETE 

Complete Assignment #3 

Participate in Discussion #3 

 

CLO 1,2,3,4,5 

Key objectives this week: 

  • Basics of database design 

  • Primary keys and foreign keys 

  • Normalization   

Final Exam 

CLO 1,2,3,4,5 

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

ISDA 20A has no prerequisite requirements.

Course Learning Outcomes

Upon successful completion of the course, students will be able to:

  1. Understand and demonstrate the use of structured query language (SQL) at an introductory level.
  2. Explain the features and structures of SQL.
  3. Demonstrate the use of SQL to interact with database management systems.
  4. Demonstrate the use of SQL to create tables.
  5. Demonstrate the ability to view, create, and modify data in a database using SQL.

    SLOs & PLOs

  1. ISDA 20A has no SLOs or PLOs.

Textbooks

Required Textbooks:

  • Murach, J. (2019). Murach's mySQL (3rd ed.). Mike Murach & Associates, Inc. Available through Amazon: 1943872368arrow gif indicating link outside sjsu domain

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.

icon showing link leads to the PDF file viewer known as Acrobat Reader Download Adobe Acrobat Reader to access PDF files.

More accessibility resources.