|
Object - Oriented
File Management Skill Using SQL Server
Course Objective
Effective
file management system is impossible in today's world of electronic
commerce without the appropriate knowledge of event-driven database
management tools. This introductory course is designed to
teach participants how to use SQL to create a small utility for
themselves or their work group without having to be a programmer.
All
participants will receive real-life work examples on diskettes
for use in their offices
Course
Outline
Introduction
to Object Oriented Database
.
Overview of Database Design Structure
.
Introduction to Microsoft SQL Server 7 (Getting Started)
.
Overview of SQL Server Architecture, Fundamental of SQL Server
Architecture
.
Database Architecture; Logical Database Components - Data Type
and Table Structure, SQL View,
SQL Stored Procedures, Constraints, Rules, Defaults and Triggers,
Systems Database and Data
.
Physical Database Architecture
.
Systems Database and Data
Creating
and Maintaining Databases
.
Databases
* Parts of a Database
* Database Design Considerations
* Creating a Database
* Modifying a Database
* Viewing a Database
.
Tables
* Designing Tables
* Creating and Modifying Table
.
Database Diagrams
.
Indexes ( Designing an Index, Creating an Index, etc)
.
Views (Scenarios for using views, creating a view, getting information
about a view, etc.)
.
Stored Procedures (Creating a stored procedure, executing a stored
procedure, etc)
.
Enforcing Business Rules and Triggers (Creating a Trigger, Deleting
a Trigger, etc.)
Real
Life Application of Personnel Details
. Billing, Assets Records, Maintenance & Corporate/ Individual
Relations/ Correspondences
.
Setting Up a Custom-made Personnel Detail Databases as real life
examples
Administrative
File Management Areas of Application
. Employees File Management, Job Evaluation & Salary Administration
.
Manpower Planning, Performance Appraisal, etc. (From manual to
computer)
Note:
For the last two items, all participants are expected to come
with necessary manual
documents
which they may need to translate to computer operations using
Microsoft Access
Who
Should Attend?
The
above workshop is designed for any professional who may want to
use computer to achieve result.
Participants
of this workshop will also be able to understand computer operations
from the scratch
Dates
Duration
Venue
Cost (N)
Apr. 02-06
5 Days Ultimate
Systems Solutions Training Center
45, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
May 07-11 5
Days
"
45,
500
Jun. 11- 15
5 Days Ultimate
Systems Solutions Training Center 45,
500
110b Awolowo Way, Ikeja, Lagos, Nigeria
Provision
Executive
Leather Bag, Lunch, Tea Break, Various Accounting Modules as stated
above on diskette, One Computer Per Participant, Group Photograph,
Workshop Materials
Note
Depending
on your choice, we can also run the above course for you in either
your office or your training center. But the number of participants
would not be less than 5.
| 