|
Lab Objective:L
The student will learn the SQL language and how to develop simple business applications using popular DBMS: MS-Access and OracleDB ExpressEdition10g ,Oracle SQL Plus and Oracle developer.L
Learn how to create and edit tables to store data about one specific topic, L
Use queries to ask questions and find information quickly,L
Design forms for viewing the information.L
And design reports for printing results.L
Understand the use of Structured Query Language (SQL) and learn SQL syntax. L
Lab Policy:L
lab depends on Quizzes, assignments, and lab work.L
Any student who cheats in a quiz will receive a zero .copying other student's work letting other students copy your work.L
Check your email for information from the instructor. L
Read your assignments very well ( Requirements and due dates ) .L
Late assignment is not accepted.LL
Grading Policy:L
10 Marks, includes (Lab Work + Quizzes + Assignments)L
Software Requirements:L
Microsoft ACCESS-2003, Oracle 10g, Oracle Developer, L
Useful Tutorials:L
Access:L
http://cisnet.baruch.cuny.edu/holowczak/classes/2200/access/accessall.html
http://www.fgcu.edu/support/office2000/access/
Oracle - Complete Student Guide for SQL/PLSQL:L
http://www.saddleback.cc.ca.us/faculty/mbhimaraju/D11782GC11Pvol1.pdf
http://www.cs.odu.edu/~dba_web/Stu%20Guide
Download:L
CPCS241syllabus
CPCS Ass1
Oracle Labs Presentation
Oracle_Lab4
|