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.
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).
Office Location: F51e
Office Hours: Monday and Wednesday - 1 pm to 3 pm.
Advisory: English Writing 211 and Reading 211 (or Language
Arts 211), or English as a Second Language 272 and 273;
Computer Information Systems 64A.
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
E. Explain and apply data aggregation and sub-queries
to fetch data from database.
F. Demonstrate how formatting output works to produce
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.
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)
SQL in a Nutshell (In a Nutshell (O'Reilly)) by Kevin Kline,
Brand Hunt and Daniel Kline
Recorded lecures playback through www.cccconfer.org.
Lectures held online from 8:00 pm to 9:50pm on Mondays and
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
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.
Tests are open book and notes. Summer 2014 - Exams are taken
Available on Catalyst
Final grades are available through myportal.deanza.edu at the
end of quarter.
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).
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
Final - 40% of the grade
Labs - 30% of the grade
Midterm - 30% of the grade
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.
Basement floor of the Learning Center West building, Room 1, on the De Anza College campus.
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
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:
- 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.