Distance Learning

Distance Learning Center

Orientation Details

Online Orientation for CIS -D064B-63Z
(It is highly recommended that you print out this page for future reference.)
Instructor Contact Information
Instructor Sukhjit Singh
Office Hours Monday and Wednesday - 1 pm to 3 pm.
Office Location F51e
Office Phone 408-864-5566
Email singhsukhjit@fhda.edu
Website http://www.sukhjit.tv
A Message from your Instructor

I am looking forward to working with you in this course over this term. Success in this class can be attained by following some simple steps: Do all of the lab assignments and turn them in on time. View all of the videos during the term. Take all of the examinations. You are expected to spend about 10-15 hours per week for this course.

Be an active learner- which means watch the lecture attend, attend weekly review sessions and try to understand all the concepts. Call me if you need help or if you feel you are lost on getting started with the subject matter.

Course Topics

  • Week 1 Oracle Server Architecture. - Role of Databases. Introduction to the language. Foundation
  • Week 2 Selecting Restricting and Sorting Data - Set Theory, Query Processor and Oracle Optimizer.
  • Week 3 Single Row Functions and Joins.
  • Week 4 Multiple Row Functions, Subqueries, Formatted Output.
  • Week 5 DML Statements Transaction Mgmt. Database Locking and Read Consistency.
  • Week 6 DDL Statements (Create, Alter) – Midterm - Constraints, Partitioned Objects, IOTs, Clusters,
  • Week 8 Views, Sequences, Indexes, Synonyms - Direct Load Insert
  • Week 9 DDL Statements (Rename, Truncate, Drop)
  • Week 10 Users, Roles and Privileges - Oracle Security
  • Week 11 Database Recovery. Distributed Computing and Oracle, Advanced Queuing.
  • Week 12 Final



  • Schedule:
    Online Lectures are pre recorded and available for replay.
    Weekly review session held every Sunday morning from 7am to 8am on Friday's Morning
    Midterm - November 1st 2011 - 8:30pm to 10:30pm in ATC Main Lab
    Final - December 13th 2011 - 8:30pm to 10:30pm in ATC Main Lab
    Hours of Study
    Be prepared to spend a minimum of 12 hours per week using and studying the course materials.
    How to get started in your course
    • Apply for admission to De Anza College and register for this class, if you have not already done so. Completing this orientation DOES NOT enroll you in the course. You must enroll through the college and pay your fees within the first 5 days of the course or you will not receive credit for this course.
    • Complete the Online Orientation and submit the online orientation form.
    • Read the complete course syllabus available at the following URL: http://sql.sukhjit.tv/
    • This course is offered through my website at sql.sukhjit.tv. Go to site at www.sukhjit.tv and review the syllabus. NOTE: You will be able to access the course shell at start of quarter.
    • Consult the Course Calendar in the syllabus and start your Session 1.


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


    Last Updated: 9/5/13