Scribd
Upload
87 views2 pages

ADBA Course Outline 2019

This document provides information about an advanced database administration course offered at the Federal TVET Institute. The course is a 3-credit course offered in the first semester of the master's program in information and communication technology management. The course aims to provide students with the necessary skills and knowledge to establish an advanced database administration using SQL Server. Over the course of 4 chapters, students will learn about database administration roles, installing and manipulating databases in SQL Server, maintaining databases in SQL Server, and creating simple applications using SQL Server. Students will be evaluated based on midterm and final exams, lab exams, and a mini project.

Uploaded by

ኮኾብ ጽባሕ
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
87 views2 pages

ADBA Course Outline 2019

This document provides information about an advanced database administration course offered at the Federal TVET Institute. The course is a 3-credit course offered in the first semester of the master's program in information and communication technology management. The course aims to provide students with the necessary skills and knowledge to establish an advanced database administration using SQL Server. Over the course of 4 chapters, students will learn about database administration roles, installing and manipulating databases in SQL Server, maintaining databases in SQL Server, and creating simple applications using SQL Server. Students will be evaluated based on midterm and final exams, lab exams, and a mini project.

Uploaded by

ኮኾብ ጽባሕ
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

FEDERAL TVET INSTITUTE (FTVETI)

Addis Ababa
Department of Information and Communication Technology management

Program: M. Sc. in Information and Communication Technology Management.

Course Name and Code: Advance Database Administration (ICT 544)

Course Credits: 3

Year and Semester: I Year II Semester 2018/19 A.Y

Instructor Name: Dr. VASU PINNTI E-Mail: vasupinnti@yahoo.com

COURSE DESCRIPTION:
This course an advanced database infrastructure design, optimization, maintenance,
troubleshooting and security. To get the most out of this course, trainees should have a basic
knowledge and experience working with some DBMS and have a strong grasp of database
administration fundamentals.
COURSE OBJECTIVES:
The course aims to provide trainees with the necessary knowledge and skills that will help them in
establishing an Advance Database Administration.
After completing this course student should be able to:
 Identify the roles and functions of Database Administrator.
 Manipulate database using SQL Server
 Attain the advance skills and knowledge needed to maintain database using SQL Server.
 Understand all the programmability objects in SQL Server and how the use it?

SCHEDULE AND COURSE CONTENT:


The following is an outline of the order in which syllabus contents will be covered.

Chapters and Topics


The Database Administrator
Chapter -1
- Roles and functions of Database Administrator
- Skills, interests and qualities of Database Administrator
Manipulate database using SQL Server
Chapter – 2
- Installing SQL Server
- About SQL Server Management Studio (SSMS)

1
- Connecting to SQL Server
- Creating, Altering and Dropping a Database
- Creating and Working with tables
- SQL Commands and PL/SQL
- Views and Procedures
Chapter - 3 Maintaining Database using SQL Server
- SQL Server Security (User Authentication)
- Backing-up Database
- Restoring Database
- Recovering Database
Creating simple application using SQL Server as Backend database
Chapter – 4
 Connecting VB.Net/C#.Net to SQL Server
 Displaying Records
 Add, Edit, Delete Records
 Creating Reports

REQUIRED TEXTS:
Text books:
- Professional SQL Server Administration by Peter A. Carter, 2014
Reference:
 Microsoft SQL Server 2008 R2 Administration
 https://www.pluralsight.com/courses/sql-server-2008-advanced-dba-pt1

ASSESSMENT AND EVALUATION:


Evaluation will be carried out based on continuous assessment which comprises relevant mid-exam, lab
exam, mini project and final examination.

Parameter Weight Remark


Mid exam 20
CHAPTER 1,2
lab exam 20
Mini project 20
CHAPTER 3,4
Final exam 40
Total 100 %
Attendance: You are obliged to attend at least 80% of the lecture classes and 100% attendance during
practical work sessions to sit for final exam

Instructor signature Department Head

You might also like