1 / 5

COSC 3480 Projects & Homeworks Fall 2003

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.

marius
Download Presentation

COSC 3480 Projects & Homeworks Fall 2003

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. COSC 3480 Projects & HomeworksFall 2003

  2. 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

  3. 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.

  4. 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.

  5. Announcements

More Related