Dr. Mohammad Ali H. Eljinini

Course Name: : Software Lab II

Course Number: 605162

Course Description:

( Prerequisites: Computer Skills (1) – 605111 )

At the end of the course, the student will be able familiar with the concepts of the UNIX Operating System, it's commands, and the vi editor. Also, to understand the SQL^*Plus commands, and to be familiar with 4^th Generation Language.

Course Contents: 

 PART 1 - UNIX

1.        Shell Types

2.        Shell commands syntax, File system concepts

3.        Directories handling

4.        communication between users

5.        vi editor

    a.     Character Positioning

    b.     Word Positioning

    c.     Sentence Positioning

    d.     Line Positioning

PART 2 - ORACLE

1.        Data types

2.        Table creation, Alteration, Insertion

3.        Table updating, Query Syntax

4.        String functions

5.        Number functions

6.        Aggregate functions

7.        Date Functions

8.        Simple Join 

  Textbook:

Provided material  

 References: 

1. Teach yourself UNIX, RUTH ASHLEY-90

2. Mastering ORACLE 7 & Client Server Computing,BOBROWSKI-94

 Exams & Grades:

First Exam: 25%                                   

Second Exam: 25%

Final Exam: 40%

Class Activities: 10%