Distance Learning

Distance Learning Center

Syllabus

Winter 2015 Syllabus for CIS -D064B-61Z
CIS -D064B-61Z - Sukhjit Singh
Introduction to SQL
Call Number: 11241
Term: Summer 2014
4 units
De Anza College Distance Learning Center • LC 107 • Phone: 408-864-8969 • FAX: 408-864-8245 • http://www.deanza.edu/distance/
Description
Introduction to Oracle, SQL, DML, processing techniques, DDL techniques, selecting and sorting data, Joins, SQL functions, Oracle object, Oracle data processing concepts to maintain large database systems.
Prerequisites
Computer Information Systems 64A.
Instructor Information: Sukhjit Singh
I have over 15 years of experience in software engineering and executive consulting and have developed business-critical, scalable and reliable infrastructures for companies like @Road, Infospace and Oracle. Education: MS Software Engineering with focus on Program Management (Carnegie Mellon University), MS Education - focus on Online Learning Technologies (CSUH), BS Computer Science (CSUH).

Phone: 408-864-5566
Email: singhsukhjit@fhda.edu
Office Location: F51e
Office Hours: Monday and Wednesday - 1 pm to 3 pm.
Requirements
Advisory: English Writing 211 and Reading 211 (or Language
Arts 211), or English as a Second Language 272 and 273;
Computer Information Systems 64A.
Objectives
A. Review the basic features of databases.
B. Demonstrate usage of basic SQL statements to
restrict and sort data.
C. Demonstrate usage of single-row functions for
retrieving from database.
D. Illustrate usage of joins to get data from multiple
tables.
E. Explain and apply data aggregation and sub-queries
to fetch data from database.
F. Demonstrate how formatting output works to produce
readable reports.
G. Create Database Objects using a database schema.
H. Define database security policy and create different
levels of user access and variables in database schema.
I. Use Control Structures to implement decision making
constructs in RDBMS.
J. Describe how cursors are implemented in databases.
K. Demonstrate usage of database utilities used for
importing and exporting data from databases.
Textbook
Required Text
-------------
#1
ISBN-10: 0321444434
ISBN-13: 978-0321444431
SQL Queries for Mere MortalsĀ®: A Hands-On Guide to Data
Manipulation in SQL (2nd Edition) [Paperback]
John L. Viescas (Author), Michael J. Hernandez (Author)

#2
ISBN-10: 0596518846
ISBN-13: 978-0596518844
SQL in a Nutshell (In a Nutshell (O'Reilly)) by Kevin Kline,
Brand Hunt and Daniel Kline
Media Availability
Recorded lecures playback through www.cccconfer.org.
Lectures held online from 8:00 pm to 9:50pm on Mondays and
Wednesdays
Written Assignments
Assignment Due dates
Programming Assignment 1 7/4/2014
Programming Assignment 2 7/9/2014
Programming Assignment 3 7/14/2014
Programming Assignment 4 7/18/2014
Programming Assignment 5 7/23/2014
Midterm 7/21/2014 8:00 pm -
9:45 pm online
Programming Assignment 6 7/28/2014
Programming Assignment 7 8/1/2014
Programming Assignment 8 8/6/2014
Final 8/6/2014 8:00 pm-9:45 pm
online
Extra Credit
There is NO EXTRA CREDIT in this course. In fairness to all,
under no circumstance will the instructor offer a special
extra credit assignment to an individual student to
accommodate their desire for a higher grade.
Exam Notes
Tests are open book and notes. Summer 2014 - Exams are taken
online.
Handouts
Available on Catalyst
Final Grade
Final grades are available through myportal.deanza.edu at the
end of quarter.
Additional Information
Note to Students with Disabilities: If you have a
disability-related need for reasonable academic
accommodations or services in this course, provide (name of
Instructor) with a Test Accommodation Verification Form
(also known as a TAV form) from Disability Support Services
(DSS) or the Educational Diagnostic Center (EDC). Students
are expected to give five days notice of the need for
accommodations. Students with disabilities can obtain a TAV
form from their DSS counselor (864-8753 DSS main number) or
EDC advisor (864-8839 EDC main number).
Grading
For Letter Grade:
Grade: A+ assigned with 97% or higher
Grade: A assigned with 93% or higher Grade: A- assigned
with 90% or higher
Grade: B+ assigned with 87% or higher
Grade: B assigned with 83% or higher
Grade: B- assigned with 80% or higher
Grade: C+ assigned with 77% or higher
Grade: C assigned with 73% or higher
Grade: D+ assigned with 70% or higher
Grade: D assigned with 63% or higher
Grade: D- assigned with 60% or higher
Grade: F assigned with 0% or higher
For Pass/No Pass:
Grade: Credit assigned with 70% or higher
Grade: No Credit assigned with 0% or higher
Incomplete
Audit
Withdrawal
Grades
Final - 40% of the grade
Labs - 30% of the grade
Midterm - 30% of the grade
Cheating
Policy on Copying and Cheating:Students who submit the work of others as their own or cheat on exams or other assignments will receive a failing grade in the course and will be reported to college authorities.
Library West Computer Lab(LWCL)

The Library West Computer Lab offers support services for Distance Learning students including: open computer lab with Internet access, stations for viewing videotapes and videotape checkout.

A photo I.D. card is required to check out materials or use computers in the Library West Computer Lab, use computers in other campus computer labs.

To check out videotapes from the OML a Distance Learning Center I.D. Card is also required

The Distance Learning I.D. cards are available from the Distance Learning Center.

LWCL Location
Basement floor of the Learning Center West building, Room 1, on the De Anza College campus.

http://www.deanza.edu/library/librarywestcomputer.html
(408) 864-8850

Catalyst Information
This course utilizes Catalyst, De Anza's Online Learning Community. Please view the Catalyst website at https://catalyst.deanza.edu/ to login. Please note that you will be unable to login until the first day of class. Be sure you are using your correct username and password - do not use your social security number or international "99" number. If you need help logging in or finding your student ID, please view the short instructional video at: https://catalyst.deanza.edu/?pg=mod1. Additional instructions and assistance can be found on the Catalyst website.
De Anza College Bookstore Contact Information
Phone: 408-864-8455
http://books.deanza.edu/
LIBRARY SERVICES
De Anza College Library Services are available for all students and faculty, both on and off campus. Please consult the library website for a complete description of the library services and hours:

De Anza College Library: http://www.deanza.edu/library/

Services of particular interest to off campus students include:
  • Access to the Library Catalog which includes books, DVDs, and course reserves. Here is a link to the library catalog:
    Library Catalog: http://library.deanza.edu/uhtbin/webcat
  • Article Databases and Research Databases The library subscribes to several electronic databases which provide access to thousands of full-text journals, newspapers, and magazine articles. Research databases include: LEXIS NEXIS Academic, Encyclopedia Britannica Online and a Practice Test Database which contains Nursing Exams, TOEFL Preparation, College Entrance Exams, and many more.
To use the article or research databases from an off campus computer, log in with your 14 digit library number or eight digit student id number. These instructions are repeated on the first page of the library website along with descriptions of all the online resources provided.


Distance Learning
Building: MLC 250
Email: distance@deanza.edu
Phone: 408.864.8969
sizeplaceholder


Last Updated: 9/5/13