|
Location: Building 3 , Lab 5
Time: Monday, 9:30-11:20
Introduction
The laboratory introduces the database management system (DBMS), and the use of a special-purpose programming language designed for managing data held in a relational DBMS. Students will be able to administrate the DB, using DB Objects, and write in high-level query language.
The software that will be used in the lab are:
DBMS: Oracle Database Express Edition 10g
Programming Language: SQL
Lab Instructions and Syllabus click here
Lab Contents
Lab1&2 .. for slides, click here. For exercise click here
Lab 3.. Slides, Exercise, Assignment Paper, Assignment Example.
Lab 4..Slides.
Lab 5..Slides, Assignment.
Lab 6..Slides.
Lab 7..Slides, Assignment.
Lab 8..Slides.
Lab 9..Slides.
Lab 10..Slides.
Lab Project
Students will be introduced to MySQL Workbench. This will give the students idea about different Oracle products and deal with the new SQL version.
Download MySQL - Installation Tutorial
Download MySQL - Get Started
Download Project Outlines.
|