50 likes | 178 Views
COSC 3480 Projects & Homeworks Fall 2003. Conceptual Schema Design. Relational Database Design. Learn how to define tables. Data Mining. Decision Trees Clustering. ODL/OQL basics. Learn how to load and create an Oracle database. MS SQL 2000 Analysis Server. PL/SQL Triggers.
E N D
Conceptual Schema Design Relational Database Design Learn how to define tables Data Mining Decision Trees Clustering ODL/OQL basics Learn how to load and create an Oracle database MS SQL 2000 Analysis Server PL/SQL Triggers PL/SQL Cursors PL/SQL Functions Procedures and Packages OLAP Oracle8/9i Data Warehousing Learn how to define user views Learn how to write complex SQL Queries Developer 2000 Datablock Forms Generate SQL Plus reports Learn PL/SQL basics Developer 2000 reports Object-Relational features Java/C++ Interfaces Support for XML Lab 2003 Activities
COSC 3480 Lab Projects I • There will be 6 lab projects; 5 will be programming projects, one will be a design project. • The TU/TH Lab (Sessions 5:30-7:00p) in 200 PGH • Instructor Aditya Toomula • The lab sessions will be help in 200 PGH; that host 45 stand-alone computers that are connected to the internet (no floppy, no CD). • Vision: Usually, there will be a short lecture and then students will be given a task that is similar to the tasks in the 6 lab projects and each student tries his best to solve the task on his lab computer. • Moreover, sometimes the will be just QA-sessions; other activities include discussions of homework / exams, student presentations, makeup classes during the lab time; occasionally, there will be no lab at all. A lab schedule will be available on the web soon.
COSC 3480 Lab Projects II • Lab projects can be performed by accessing the departmental Oracle server; accounts are currently created. It is also okay, if you install Oracle 8i, 9i, 8.17 on your own computer and perform the projects on your own computer. • As I know the “short lecture-do_tasks_on_lab_computer” approach will be used the first time when teaching COSC 3480; therefore: • There likely will be problems at the beginning; it is not 100% certain if what I /we have in mind will work. • Your feedback is appreciated. • We might adapt our teaching approach based on experiences in the first lab sessions. • The lab sessions will hopefully start on Tu., September 9.