SRJC Course Outlines

5/26/2022 12:54:30 AMCS 81.61 Course Outline as of Fall 2015

Inactive Course
CATALOG INFORMATION

Discipline and Nbr:  CS 81.61Title:  SQL  
Full Title:  Structured Query Language
Last Reviewed:9/27/2010

UnitsCourse Hours per Week Nbr of WeeksCourse Hours Total
Maximum1.50Lecture Scheduled1.5017.5 max.Lecture Scheduled26.25
Minimum1.50Lab Scheduled04 min.Lab Scheduled0
 Contact DHR0 Contact DHR0
 Contact Total1.50 Contact Total26.25
 
 Non-contact DHR0 Non-contact DHR Total0

 Total Out of Class Hours:  52.50Total Student Learning Hours: 78.75 

Title 5 Category:  AA Degree Applicable
Grading:  Grade or P/NP
Repeatability:  00 - Two Repeats if Grade was D, F, NC, or NP
Also Listed As: 
Formerly:  CIS 69.53

Catalog Description:
Untitled document
This course is designed for the student who has experience with a database management program such as Access or FileMaker Pro and wants to learn Structured Query Language (SQL), the common language of client server database management.

Prerequisites/Corequisites:
Course Completion of CS 63.11 ( or CIS 69.31)


Recommended Preparation:
Eligibility for ENGL 100 or ESL 100

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
This course is designed for the student who has experience with a database management program such as Access or FileMaker Pro and wants to learn Structured Query Language (SQL), the common language of client server database management.
(Grade or P/NP)

Prerequisites:Course Completion of CS 63.11 ( or CIS 69.31)
Recommended:Eligibility for ENGL 100 or ESL 100
Limits on Enrollment:
Transfer Credit:
Repeatability:00 - Two Repeats if Grade was D, F, NC, or NP

ARTICULATION, MAJOR, and CERTIFICATION INFORMATION

Associate Degree:Effective:Inactive:
 Area:
 
CSU GE:Transfer Area Effective:Inactive:
 
IGETC:Transfer Area Effective:Inactive:
 
CSU Transfer:Effective:Inactive:
 
UC Transfer:Effective:Inactive:
 
C-ID:

Certificate/Major Applicable: Certificate Applicable Course



COURSE CONTENT

Outcomes and Objectives:
Upon completion of the course, students will be able to:
Untitled document
Upon completion of the course, students will be able to:
1.  Apply the basic vocabulary and functions of SQL to a variety of database tasks.
2.  Given a Query By Example (QBE) screen, write the corresponding SQL statement.
3.  Select records from an existing database using SQL based on specified selection criteria.
4.  Compare and contrast the join types, INNER, OUTER, LEFT and RIGHT
5.  Use an SQL statement to append records from another source.
6.  Use an SQL statement to update the field contents in a database based on an expression in an SQL statement.
7.  Access SQL data via Microsoft Technologies Open Data Base Connectivity (ODBC).
8.  Solve problems using SQL to demonstrate understanding of the theory and uses of SQL.

Topics and Scope
Untitled document
1.  Review of query by example
   a.  Selecting fields
   b.  Selecting records
       1)  relational operators
           a)  equal
           b)  not equal
           c)  less than
           d)  greater than
           e)  less than or equal to
           f)   greater than or equal to
       2)  logical operators
           a)  and
           b)  or
           c)  not
2.  Categories of SQL keywords
   a.  Commands
   b.  Clauses
   c.  Qualifiers
   d.  Operators
   e.  Group aggregate functions
3.  SQL statements to create queries
   a.  SELECT (ALL, DISTINCT, and DISTINCTROW) FROM
   b.  WHERE
   c.  LIKE (proper use of wild cards)
   d.  ORDER BY (DESC)
   e.  GROUP BY
   f.   AND
   g.  BETWEEN
   h.  SUM
4.  Join types
   a.  INNER
   b.  LEFT
   c.  RIGHT
   d.  OUTER
5.  SQL statements to create joins between tables
   a.  (INNER, LEFT, and RIGHT)   JOIN ON
   b.  Combining result set of two or more SELECT queries into a single result
   c.  Action queries
       1)  INSERT INTO - append from other source
       2)  DELETE FROM - delete from table
       3)  SELECT INTO - create a new table from existing table
       4)  UPDATE  SET   WHERE

Assignments:
Untitled document
1.  Reading approximately 25 pages per week from text book
2.  Weekly  assignments  practicing SQL concepts
3.  2 to 4 exams

Methods of Evaluation/Basis of Grade.
Writing: Assessment tools that demonstrate writing skill and/or require students to select, organize and explain ideas in writing.Writing
0 - 0%
None
This is a degree applicable course but assessment tools based on writing are not included because problem solving assessments are more appropriate for this course.
Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills.Problem Solving
30 - 70%
Weekly assignments
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams.Skill Demonstrations
0 - 0%
None
Exams: All forms of formal testing, other than skill performance exams.Exams
30 - 70%
Multiple choice, true/false, matching items, completion
Other: Includes any assessment tools that do not logically fit into the above categories.Other Category
0 - 10%
Attendance and participation


Representative Textbooks and Materials:
Untitled document
The Practical SQL Handbook, by Judith S. Bowman et al.  4th edition,  Addison Wesley 2001 (classic in field).

Print PDF