Lab

Task

HOURS

1

–          Introduction to Database Management System

2

2

–          Entity Relationship diagram concepts (ERD)

2

3

–          Mapping ER Diagram

2

4

–          Retrieving data using the SQL SELECT statement.

–          Restricting and sorting data

2

5

–          Using Single-Row Functions to customize output.

2

6

–          Reporting aggregated data using the Group Functions.

7

–          Displaying data from multiple tables.

2

8

–          Using sub queries to solve queries.

–          Data Manipulation Language    DML.

2

9

–          Using Data Definition Language DDL statements to create and manage tables.

2

10

–          Creating other schema objects: Views, Sequences, Synonyms …etc.

2

11

–         Managing objects with data dictionary views.

2

12

–          Normalization

2

–          Total Hours

24