TECHZONE MULTIMEDIA PRIVATE LIMITED

richnessokahumpkaΔιακομιστές

9 Δεκ 2013 (πριν από 3 χρόνια και 9 μέρες)

63 εμφανίσεις


1



TECHZONE

MULTIMEDIA PRIVATE
LIMITED




(PROPOSED)



TECHZONE


IGNOU COMMUNITY
COLLEGE





PROPOSED
PROGRAMME STRUCTURE FOR

CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)





COURSE DURATION



-

6 Months

STUDENT ELIGIBILITY


-

10 + 2 Pass

WEE
KLY STUDY SCHEDULE

-

5 Days

COURSE FEE




-

Rs:
9
,000/
-














Head Office: 1358, Ambika Tower, Opp.


Vishal Shopping Market,
Wright Town, Jabalpur (M.P)

Tel.: +91


761


4086900 Mobile: +91


9893979911


2

Website: techzonemultimedia.com Email:
sharad_dixit@yahoo.com


TECHZONE


IGNOU COMMUNITY
COLLEGE

(PROPOSED)


CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)



INDEX


S.N.

DESCRIPTION

PAGE
NO.

1

Academic Expert Panel


3

2

Course Objective


4

3

Proposed Programme Structure


5


11

4

Course Credit Structure


12

5

Proposed Examination Marking Scheme


13

6

Faculties Details


14

7

Infrastructure Availability


15

8

Need Analysis Report


16

9

Course Fee Breakup


17



















3

TECHZON
E


IGNOU COMMUNITY
COLLEGE

(PROPOSED)


CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)



PANEL OF ACADEMIC EXPERTS


S.N.

Name of Expert

Designation &
Department

Signature & Seal

1








2








3


























4

TECHZONE


IGNOU
COMMUNITY
COLLEGE

(PROPOSED)


CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)


COURSE OBJECTIVE:




Install, configure and link a Linux system to a corporate network



Administer and manage a Linux network



Install and create an Oracle9i database o
n Linux



Administer and manage an Oracle database on Linux



Perform Backup & Recovery of a database in case of database crash



Tune an Oracle9i database to take advantage of the Linux operating



system



New Features of Database



Perform Database Trouble Sh
ooting
































5


TECHZONE


IGNOU COMMUNITY
COLLEGE

(PROPOSED)


CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)



PROPOSED PROGRAMME STRUCTURE:


DBA MODULE


I



Basics of Linux


Course Overview

Course Duration :

6 Months

Course Fee :

Rs.

9
,000/
-


Student Eligibility
: 10 +2 Pass

Weekly Study Schedule: 5 Days

This course is for a person who have no command
-
line experience in Lin
ux or Unix and want to develop
skills for using and customizing their own Linux workstation


Pre
-
Requisites

User
-
level experience with any computer system, inclu
ding: use of mouse, use of menus and use of any
graphical user interface


Target Audience

IT professionals who want to build user
-
level skills before learning Li
nux System and Network
Administration


Course Outline



Linux Ideas and History

-

Explain the nature of open source software

-

Discuss the origins of Linux

-

List
the Linux operating system
distributions

-

Explain basic Linux principles



Linux Usage Basics

-

Log into a Enterprise Linux System

-

Start X from a console

-

Access the command line from X

-

Change your password

-

Understand the nature of root privileges

-

Elevate your privileges

-

Edit plain text files



Running Commands and Getting Help

-

Execute commands at the prompt

-

Explain the purpose and usage of some
simple commands

-

Use the built
-
in help resources in
Enterprise Linux



Browsing the Filesystem



Investigating and Managing Processes

-

Explain what a process is

-

Describe how to manage processes

-

Use job control too
ls

-

Schedule recurring jobs

-

Employ decision making constructs in
shell scripts



Basic System Configuration Tools

-

Configure the network

-

Configure and send text to a printer

-

Set the system’s date and time

-

Schedule time
-
delayed tasks

-

Schedule recu
rring tasks

-

Know how to handle input with the read
command & positional parameters



Finding and Processing Files

-

Use locate

-

Use find

-

Use the Gnome Search tool



Network Clients

-

Browse the web


6

-

Descr
ibe important elements of the
filesystem hierarchy

-

Copy, move and remove files

-

Create and view files

-

Manage files with Nautilus



Users, Groups and Permissions

-

Explain the Linux security model

-

Explain the purpose of user and group
accounts

-

Read a
nd set file permissions



Using the bash Shell

-

Use command
-
line shortcuts

-

Use command
-
line expansion

-

Use history and editing tricks

-

Use the gnome
-
terminal

-

Write simple shell scripts

-

Set and reference shell variables



Standard I/O and Pipes

-

Redir
ect I/O channels to files

-

Connect commands using pipes

-

Use the for loops to iterate over sets of
values



Text Processing Tools

-

Use tools for extracting, analyzing and
manipulating text date



vim: An Advanced Text Editor

-

Use the three primary modes of

vi & vim

-

Navigate text and enter Insert mode

-

Change, delete, yank and put text

-

Undo changes

-

Search a document

-

Save and exit

-

Exchange email and instant messages

-

Access a Linux sy
stem remotely

-

Transfer files between systems

-

Use network diagnostic tools



Advanced Topics in Users, Groups and
Permissions

-

Describe where Linux stores user, group
and password information

-

Set default permissions

-

Use special permissions



Investigat
ing and Managing Processes

-

Process States, Viewing Processes and
Nice Values

-

Sending Signals to Processes, Terminating

-

Foreground and Background Process

-

at, crontab Listing and Scheduling Jobs



The Linux Filesystem In
-
Depth

-

Describe how filesystem

information is
organized

-

Describe the function of dentries and
inodes

-

Describe how cp, mv and rm work at the
inode level

-

Create Symbolic links and hard links

-

Access removable media

-

Create archives using tar and gzip

























7


CER
TIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)


DBA MODULE


II



Linux Administration



Course Overview

This course is for users of Linux (or Unix) who
want to start building skills in system administration on
Enterprise Linux, to a level where they can attach and configure a workstation on an existing network.
This 4 day course provides intensive hands
-
on training on Enterprise Linux.


Pre
-
Requisites

Linux Essentials or equivalent experience with Unix/Linux.


Target Aud
ience

Linux or Unix users, who understand the basics of Linux, that desire further technical training to begin the
process of becoming a system administration


C
ourse Outline



Administrative Access

-

Access and administer text and graphical
consoles

-

Remotely access the system for
administration

-

Gain administrative privilege

-

Access virtualized systems



Package Management

-

Add, remove and manage software using

yum

-

Configure yum to connect to a private
repository

-

Connect to and use the Linux Network

-

Create a private yum repository

-

Perform advanced tasks with rpm



System Services and Security

-

Monitor and configure system logs

-

Automate tasks with cron

-

Configure printing

-

Understand the importance of time
synchronization

-

Describe SELinux service security
features



System Initialization

-

Check your current system state

-

Start, stop and check services

-

Change to different runlevels

-

Understand the b
oot sequence



Kernel Monitoring and Configuration

-

Understand the purpose and organization
of the kernel

-

Know how to configure the kernel using


Filesystem Administration

-

Monitor filesys
tems

-

Access removable media

-

Access data from remote systems using
NFS

-

Mount NFS filesystems on demand



Additional Storage

-

Add new partitions/filesystems

-

Troubleshoot filesystems

-

Add virtual memory



User Administration

-

Manage user and group acco
unts

-

Set up filesystem quotas



Filesystems for Group Collaboration

-

Manale security

-

Create collaborative directories using
SetGID

-

Extend filesystem security with ACLs



Centralized User Administration

-

Describe how Enterprise Linux Accesses
user infor
mation

-

Configure system to use centralized
authentication services



Software RAID

-

Configure high
-
availability storage with
RAID

-

Recover a degraded software RAID array



Logical Volume Management

-

Use storage more efficiently with logical
volumes

-

Back

up logical volumes with minimal
risk and downtime


8

/proc and sysctl

-

Explore hardware devices available on the
system

-

Understand how to load and configure
ker
nel modules



Network Configuration

-

Configure TCP/IP network interfaces and
routing

-

Configure DNS name resolution

-

Do basic monitoring and filtering of
network traffic

-

Describe how interfaces could be bonded



Virtualization and Automated Installation

-

Define virtualization

-

Interactively install virtual machine

-

Create and utilize Kickstart files

-

Set up an anaconda server



Troubleshooting with Rescue Mode

-

Develop a strategy for troubleshooting















































9


CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)


DBA MODULE


III



Database Management




Course Overview

Linux has gained considerable momentum as the operating system of choice for deploying Database
Servers for Intranets and Internet Portals. This course offers sufficient knowledge to build and host a
database ser
ver on Linux using MySQL as RDBMS. This course is offered on compatible versions of
Linux OS.


Pre
-
Requisites

The participants should have a conceptual understan
ding of RDBMS and fair knowledge of SQL
commands.


Target Audience

The audience for this course include Database Administrators, Web Developers and programmers.


Course Outline


Database Terminology

-

DBMS and RDBMS

-

Tables and Databases

-

Primary Key and Foreign Key

-

Unique Keys

-

Structured Query Language

-

SQL as

DDL, DML and DCL


-

Features of MySQL

-

MySQL Data Directory

-

Logging and Log Files

-

Installation of MySQL Server


-

Data Definition Language

-

Columns and Datatypes

-

Primary and Foreign Keys

-

Unique Key
s and NOT NULL

-

Auto Increment Values

-

Table, View & Database Creation


-

Data Manipulation Language

-

INSERT Records to Table

-

UPDATE Records of Table

-

DELETE Records from Table

-

Relationships Between Tables

-

Inner Joins and Natural
Joins

-

Left Joins and Right Joins

-

Locking the Tables


-

Indexes in MySQL

-

Setting Indexes to Existing Tables



MySQL User Management

-

MySQL Users and Privileges

-

Loc
al and Remote users

-

user() Function

-

Access Rights with MySQL

-

SQL GRANT Statement

-

Granting Multiple Privileges

-

Setting Password for Users

-

Revoking Privileges

-

Display Privileges for Tables & Users



MySQL Storage Engines

-

MyISAM, InnoDB , HEAP T
ables

-

Features of InnoDB and MyISAM

-

Repairing Tables by isamchk

-

myisamchk



MySQL Server Backup & Replication

-

Backup Principles

-

mysqldump and mysqlhotcopy

-

Transfers to Database or Server

-

Backup by Direct Copying

-

Recovering Databases and Table
s

-

Setting Multiple MySQL Servers

-

MySQL Server Replication

-

MySQL Triggers



API based MySQL Server

-

Basics of Standard APIs

-

Overview of Using PHP API

-

PHPMyAdmin


10

-

Non Unique Indexes

-

MySQL Functions

-

MySQL Cursors





















































11


CERTIFICATE COURSE IN LINUX DATAB
ASE
ADMINISTRATOR (CCLDA)

COURSE
-

PERSONALITY DEVELOPMENT

Course Code: PD
-
001 (Common Syllabus for all
TECHZONE



IGNOU Community College Identified courses)



Chapter 1 Personality profile

1.1 Personality defined

1.2 Elements of personality

1.3 Determi
nants of personality

1.4 Personal SWOT analyses


Chapter 2 Personality enrichment

2.1 Self Esteem

2.1.1 Self concept

2.1.2 Advantages of high self esteem

2.1.3 Characteristics of people with high and low self esteem

2.1.4 Steps to building positive self e
steem

2.2 Attitude

2.2.1 Factors that determine our attitude

2.2.2 Benefits of a positive attitude and consequences of a negative attitude

2.2.3 Steps to building a positive attitude

2.3 Motivation

2.3.1 The difference between inspiration and motivation

2.
3.2 Motivation redefined

2.3.3 External motivation v/s internal motivation

2.4 Success

2.4.1 Defining success

2.4.2 Real or imagined obstacles to success

2.4.3 Qualities that make a person successful

2.4.4 Reasons for failure

2.5 Interpersonal skills

2.5.1

Dealing with seniors, colleagues, juniors, customers, suppliers at the workplace

2.5.2 Factors that prevent building and maintaining positive relationships

2.5.3 The difference between ego and pride

2.5.4 The difference between selfishness and self intere
st

2.5.5 Steps for building a positive personality

2.6 Body language

2.6.1 Understanding body language

2.6.2 Projecting positive body language


Chapter 3 What are recruiters looking for?

3.1 Recruiter expectations

3.2 Career counseling ( based on student
SWOT analysis )

3.3 Creating a career path















12


CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)

Course Duration

6 Months

Eligibility

10 + 2 Pass

Study Pattern

5 Days a week



(Proposed)

TECHZONE


IGNOU COMMUNITY COLLEGE



PROPOSED

CERTIFICATE

PROGRAMME

Certificate Course in Linux Database Administrator (CCLDA)


PROPOSED
CREDIT STRUCTURE



S.N.

COURSE CODE

COURSE TITLE

THEORY

CREDITS

PRACTICAL

CREDITS

1

CCLDA
-
101

Basics of Linux

2

2

2

CCLDA
-
102

Linux Administration

2.5

2

3

CCLDA
-
103

Database Management

2.5

2

4

PD
-
001

Personality Development

1

-

5

CCLDA
-
P
-
201

Practical / On Job Informal Training

-

2

TOTAL CREDITS

8

8




32

Credits

x 30
Hours
=
960

Hours





















13


CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (C
CLDA)

Course Duration

6 Months

Eligibility

10 + 2 Pass

Study Pattern

5 Days a week


(Proposed)

TECHZONE


IGNOU COMMUNITY COLLEGE



PROPOSED
CERTIFICATE
PROGRAMME

Certificate Course in Linux Database Administrator (CCLDA)


Proposed
Examination
Marking

Scheme


S.N.

Paper
Code

Course Title

Theory
Marks

Practical
Marks

Internal
Assessment
Marks

Total Marks
per paper


Max

Min

Max

Min

Max

Min

Max

Min

1

CCLDA
-
101

Basics of Linux

60

24

60

24

60

24

180

72

2

CCLDA
-
102

Linux Administration

60

24

60

24

60

24

180

72

3

CCLDA
-
103

Database Management

60

24

60

24

60

24

180

72

4

PD
-
001

Personality Development

30

1
2

-

-

30

1
2

60

2
4

5


Project

-

-

-

-

-

-

1
2
0

48


Total Marks

720

288


TECHZONE



IGNOU Community College proposed following Evaluation gradation sc
heme for
TECHZONE
identified
courses.


Grade

% from

% to

A+

91 %

100 %

A

76 %

90 %

B

61 %

75%

C

50 %

60 %

D

40 %

50 %

Less than
40 % Fail















14


CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)

Course Duration

6 Months

Eligibility

10 + 2 Pass

Study Pattern

5 Days a week


(Proposed)

TECHZONE


IGNOU COMMUNITY COLLEGE


Faculty Details for
(Proposed) TECHZONE



IGNOU Community
College identified course
Certificate Course in Linux Database Administrator
(CCLDA)


S.N.

NAME OF PROGRAM
ME

PROGRAMME
CODE

FACULTY NAME

FACULTY
QUALIFICATION

MEDIUM OF
INSTRUCTION









1

2

3

4

5

6

1

Certificate
Course in Linux
Database
Administrator

CCLDA

VIKAS NAIDU

Red hat certified engineer
(RHCE).

*
RHCE Certification

Red hat Certified Security
Spec
ialist (RHCSS)

* IBM AS 400 Certified
Professional


English

PARAG SHUKLA


*
RHCE


RedHat
Certified Engineer
(2010)

*
CCNA
-

CCNA
certified by CISCO in year
2007 from guided by
Router point, NAGPUR.

*
LSCSNA

-

Training of
linux network an
d system
administration in 2008
from Linux solution,
Bhopal (M.P.).

*
LSCHNP
-

Training of
Computer Hardware and
Network engineering in
2008 from Linux solution,
Bhopal (M.P.)


English

VIVEK SONI

* BCA

* RHCE
-

Certificate
No.
-

804006552422158

English









15


CERTIFICATE COURSE IN LINUX DATABASE
ADMINISTRATOR (CCLDA)

Course Duration

6 Months

Eligibility

10 + 2 Pass

Study Pattern

5 Days a week

(Proposed)

TECHZONE


IGNOU COMMUNITY COLLEGE

INFRASTRUCTURE AVAILABILITY


Furniture:


PARTICULA
RS

QUANTITY

INSTRUCTOR CHAIR

01 No.

INSTRUCTOR TABLE

01 No.

STUDENT CHAIR WITH WRITING PAD HOLDER

CLASS ROOM No


1


30 Chairs


Teaching Aids:


PARTICULARS

QUANTITY

LCD PROJECTOR (Movable)

01 Nos.

COMPUTER SYSTEM

30

Nos.

WHITE MARKER BOARD

01 No.

WHITE BOARD MARKER (Consumable)

12 Nos. (For Complete
Session
)

WHITE BOARD DUSTER

02 Nos. (For Complete
Session
)


Electrical Accessories:


PARTICULARS

QUANTITY

TUBE LIGHTS

04 Nos.

SEALING FAN

02 Nos.

ELECTRICAL OUTLETS

02 Nos.


Drinking Water:


PARTI
CULARS

QUANTITY

/ CAPACITY

OVER HEAD WATER TANK

5000 Ltr.

DRINKING WATER STORAGE TANK

1000 Ltr.

WATER GLASSES

24 Nos.


T
oilets
:


PARTICULARS

QUANTITY


MAIN FLOOR

02 Nos. (Map Attached)

TOP FLOOR

6 Nos.


Library:


PARTICULARS

QUANTITY


Linux & Comp
uter Hardware

50 Nos.

Multimedia Subject Books

20 Nos.

Books on Software Applications

50 Nos.

Books on Gaming Subject

50 Nos.

Web Design & Development Books.

50 Nos.

Fashion Technology

24 Nos.

Books on Financial Accounting

30 Nos.

Books on Graphic
Designing

20 Nos.

Fashion Technology

27 Nos.

Books on Personality Development

20 Nos.

Animation Related Books & Manuals

18 Nos.

Mass Communication & Textile Technology Related Books

14 Nos.


16

TOTAL

373 Books & Manuals



CERTIFICATE COURSE IN LINUX DA
TABASE
ADMINISTRATOR (CCLDA)

Course Duration

6 Months

Eligibility

10 + 2 Pass

Study Pattern

5 Days a week


(Proposed)

TECHZONE


IGNOU COMMUNITY COLLEGE



NEED ANALYSIS REPORT



We had performed Need Analysis for
Certificate Course in Linux Database A
dministrator (CCLDA)

in local
community of Jabalpur and we had found following results:


Note:

The Need Analysis is performed at the local community
of Boys & Girls,
in between students who had passed 10
+ 2 Examination.

(Need Analysis is performed with in 25 Students)



PROPOSED TIMING FOR
THE COURSE


% of community who said that
they will prefer

Morning timings for the course

% of community who said that
they will prefer Afternoon timings
for the course

% of community w
ho said that
they will prefer Evening timings
for the course

3
2
%


32
%

36
%





PROPOSED MEDIUM OF INSTRUCTION


% of community who said that they will prefer
English Language

% of community who said that they will prefer
Hindi Language

84
%


16
%




PRO
POSED PROGRAMME FEE
(Excluding IGNOU Registration & Exam
Fee) for the Course Rs: 12,000/
-

(Rs: 1000/
-

Per Month)

% of community who said that they can afford
the fee

% of community who said that they cannot
afford the fee

84
%


16
%