COURSE INFORMATON
Course Title Code Semester L+P Hour Credits ECTS
Database II * BL   162 2 2 2 5

Prerequisites and co-requisites
Recommended Optional Programme Components None

Language of Instruction Turkish
Course Level Short Cycle Programmes (Associate's Degree)
Course Type
Course Coordinator Lec. Erkut TEKELİ
Instructors
Öğr. Gör.ERKUT TEKELİ1. Öğretim Grup:A
 
Assistants
Goals
With this course, students will acquire competencies related to manage database servers and use advanced SQL commads.
Content
Advanced SQL Commands and Database Server Management

Learning Outcomes
-


Course's Contribution To Program
NoProgram Learning OutcomesContribution
12345

Course Content
WeekTopicsStudy Materials _ocw_rs_drs_yontem
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-17 Final Exam

Recommended or Required Reading
Textbook
Additional Resources