Türkçe | English
FACULTY of LAW /

Course Catalog
http://hukuk.ktu.edu.tr/
Phone: +90 0462 3778652

FACULTY of LAW / /
Katalog Ana Sayfa
  Katalog Ana Sayfa  KTÜ Ana Sayfa   Katalog Ana Sayfa
 
 

TBIL2017Database II3+1+0ECTS:4
Year / SemesterFall Semester
Level of CourseShort Cycle
Status Compulsory
DepartmentDEPARTMENT of COMPUTER TECHNOLOGIES
Prerequisites and co-requisitesNone
Mode of DeliveryFace to face, Lab work , Practical
Contact Hours14 weeks - 3 hours of lectures and 1 hour of practicals per week
LecturerDr. Öğr. Üyesi Beste ÜSTÜBİOĞLU
Co-Lecturer
Language of instructionTurkish
Professional practise ( internship ) None
 
The aim of the course:
Be able to gain competencies about managing the database and servers. Prepare interface/report on the client / server database.
 
Learning OutcomesCTPOTOA
Upon successful completion of the course, the students will be able to :
LO - 1 : Design the database. 1,2,81,3,6
LO - 2 : Use the SQL Server management software effectively. 1,2,81,3,6
LO - 3 : Take the necessary steps on Relational Databases. 1,2,81,3,6
LO - 4 : Make database performance analysis and optimization.1,2,81,3,6
CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome

 
Contents of the Course
1. Design criteria for databases, 2. Setup at least two server software from two different industry standard manufacturers. 3. Create the database and define users, identify tables and manage diagrams. 4. Create a new database from an existing database, edit the view, the trigger, the indexes and the subroutines. 5. Edit the user roles and user-defined data types. 6. Make performance analysis and improvements.
 
Course Syllabus
 WeekSubjectRelated Notes / Files
 Week 1Setup at least two server software from two different industry standard manufacturers.
 Week 2Setup database management panel, create the database and define users.
 Week 3Create the database and define users, identify tables and manage diagrams.
 Week 4Identify tables and manage diagrams, make the data transfer operations.
 Week 5Data transfer operations, create a new database from an existing database.
 Week 6Create a new database from an existing database, edit the view, the trigger, the indexes and the subroutines.
 Week 7Edit the view, the trigger, the indexes and the subroutines.
 Week 8Edit the view, the trigger, the indexes and the subroutines, edit the user roles and user-defined data types.
 Week 9Midterm Exam
 Week 10Edit the user roles and user-defined data types.
 Week 11Edit the rules and the default values.
 Week 12Edit the rules and the default values, and make data replication operations and maintenance plan.
 Week 13Make data replication operations and maintenance plan.
 Week 14Make performance analysis and improvements.
 Week 15Learn the database management rules. Ensure the security of the database.
 Week 16Final Exam
 
Textbook / Material
1Gözüdeli, Y. 2013. Yazılımcılar için SQL Server 2012 Veri Tabanı Programlama, Seçkin Yayıncılık, Ankara
 
Recommended Reading
1Inan, Y. ve Demirli, N. 2005. Visual C(Sharp) . NET ile veri tabani, Palme Yay
2Özkan, Y. 2009. Veri Tabani Sistemleri, Alfa Yayinevi, Istanbul.
 
Method of Assessment
Type of assessmentWeek NoDate

Duration (hours)Weight (%)
Mid-term exam 9 1 30
End-of-term exam 16 1 70
 
Student Work Load and its Distribution
Type of workDuration (hours pw)

No of weeks / Number of activity

Hours in total per term
Yüz yüze eğitim 3 14 42
Sınıf dışı çalışma 1 14 14
Laboratuar çalışması 1 14 14
Arasınav için hazırlık 6 1 6
Arasınav 1 1 1
Uygulama 1 14 14
Klinik Uygulama 0 0 0
Ödev 0 0 0
Proje 0 0 0
Kısa sınav 0 0 0
Dönem sonu sınavı için hazırlık 8 1 8
Dönem sonu sınavı 1 1 1
Diğer 1 0 0 0
Diğer 2 0 0 0
Total work load100