TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| Code | BL162 |
| Name | Database II |
| Term | 2017-2018 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 5 ECTS |
| National Credit | 2.5 National Credit |
| Teaching Language | Türkçe |
| Level | Belirsiz |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Öğr. Gör. ERKUT TEKELİ |
| Course Instructor |
Öğr. Gör. ERKUT TEKELİ
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
With this course, students will acquire competencies related to manage database servers and use advanced SQL commads.
Course Content
Advanced SQL Commands and Database Server Management
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Install a database server which have industrial standarts | Study from the textbook | |
| 2 | to Install database management studio, to create database and to dafine users. | Study from the textbook | |
| 3 | to create database and to dafine users, to create tables, to manage diagram | Study from the textbook | |
| 4 | to create tables, to manage diagram, to transfer data | Study from the textbook | |
| 5 | to transfer data, create new database from old one. | Study from the textbook | |
| 6 | to create new database from old one, views, triggers, stored procedures, and arrange indexes | Study from the textbook | |
| 7 | views, triggers, stored procedures, and arrange indexes | Study from the textbook | |
| 8 | Midterm Exam | ||
| 9 | views, triggers, stored procedures, and arrange indexes, user roles, user defined data types | Study from the textbook | |
| 10 | user roles, user defined data types | Study from the textbook | |
| 11 | rules | Study from the textbook | |
| 12 | rules, replication, and to make backup plans | Study from the textbook | |
| 13 | replication, and to make backup plans | Study from the textbook | |
| 14 | Performance Anlysis and restoration | Study from the textbook | |
| 15 | Performance Anlysis and restoration | Study from the textbook | |
| 16 | Final Exam | ||
| 17 | Final Exam |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |