Nevşehir Hacı Bektaş Veli University Course Catalogue

Information Of Programmes

VOCATIONAL SCHOOL OF HACI BEKTAŞ VELİ / BİL110 - COMPUTER PROGRAMMING

Code: BİL110 Course Title: DATABASE-II Theoretical+Practice: 2+1 ECTS: 3
Year/Semester of Study 1 / Spring Semester
Level of Course Short Cycle Degree Programme
Type of Course Compulsory
Department COMPUTER PROGRAMMING
Pre-requisities and Co-requisites None
Mode of Delivery Face to Face
Teaching Period 14 Weeks
Name of Lecturer ORÇUN BAĞRA (orcunbagra@nevsehir.edu.tr)
Name of Lecturer(s) ORÇUN BAĞRA,
Language of Instruction Turkish
Work Placement(s) None
Objectives of the Course
With this course, students, aimed to gain qualifications relevant to managing the database and servers.

Learning Outcomes PO MME
The students who succeeded in this course:
LO-1 Establish A Database PO-34 Gains competencies in database and server management.
Examination
LO-2 Do basic table operations PO-25 Perform basic database operations.
PO-34 Gains competencies in database and server management.
Examination
LO-3 Do Advanced Table Operations PO-34 Gains competencies in database and server management.
Examination
LO-4 Manage the database server PO-34 Gains competencies in database and server management.
Examination
PO: Programme Outcomes
MME:Method of measurement & Evaluation

Course Contents
Establish a panel, database management, database users to create and define , Create a database and identify users, identify the tables and diagrams to manage Data transfer to operations, the existing database, create a new database Views, triggers, and indexes to edit subroutines Terms and edit the default values, data replication operations and maintenance plan to make Performance analysis and to make improvements
Weekly Course Content
Week Subject Learning Activities and Teaching Methods
1 Setup industry-standard server software at least two different manufacturers Narration, question and answer,Solving Problem,Practice
2 Setup Admin Panel, Create Database and Define Users Narration, question and answer,Solving Problem,Practice
3 Setup Admin Panel, Create Database and Define Users Narration, question and answer,Solving Problem,Practice
4 Define tables and manage diagram, Narration, question and answer,Solving Problem,Practice
5 Do data transfer operations,Create Database with existing database Narration, question and answer,Solving Problem,Practice
6 Create Database with existing database Narration, question and answer,Solving Problem,Practice
7 Views, triggers, edit indexes and subprograms Narration, question and answer,Solving Problem,Practice
8 mid-term exam
9 Views, triggers, edit indexes and subprograms, edit user roles,edit user-defined data type Narration, question and answer,Solving Problem,Practice
10 edit user roles,edit user-defined data type Narration, question and answer,Solving Problem,Practice
11 Edit terms and the default values Narration, question and answer,Solving Problem,Practice
12 Edit terms and the default values, Narration, question and answer,Solving Problem,Practice
13 Make Data multiplication processes and meintenance plan Narration, question and answer,Solving Problem,Practice
14 Make performance analysis and improvements Narration, question and answer,Solving Problem,Practice
15 Make performance analysis and improvements Narration, question and answer,Solving Problem,Practice
16 final exam
Recommend Course Book / Supplementary Book/Reading
1 Sql Server 2005 Express Edition,Kadir Çamoğlu - Gökhan Gürel , ISBN: 975-6477-62-8, Pusula Yayıncılık
2 Sql Server 2005, Kadir Çamoğlu, ISBN: 978-975-6477-91, Pusula Yayıncılık
Required Course instruments and materials
Lesson Book,Projection,Computer

Assessment Methods
Type of Assessment Week Hours Weight(%)
mid-term exam 8 1 40
Other assessment methods
1.Oral Examination
2.Quiz
3.Laboratory exam
4.Presentation
5.Report
6.Workshop
7.Performance Project
8.Term Paper
9.Project
final exam 16 1 60

Student Work Load
Type of Work Weekly Hours Number of Weeks Work Load
Weekly Course Hours (Theoretical+Practice) 3 14 42
Outside Class
       a) Reading 2 7 14
       b) Search in internet/Library 3 8 24
       c) Performance Project 0
       d) Prepare a workshop/Presentation/Report 0
       e) Term paper/Project 0
Oral Examination 0
Quiz 0
Laboratory exam 0
Own study for mid-term exam 1 4 4
mid-term exam 1 1 1
Own study for final exam 1 4 4
final exam 1 1 1
0
0
Total work load; 90