Course Name Code Semester T+U Hours Credit ECTS
Database Management Systems BTE 411 7 3 + 0 3 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Optional
Course Coordinator Öğr.Gör. SELÇUK SIRRI TERCAN
Course Lecturers Öğr.Gör. SELÇUK SIRRI TERCAN,
Course Assistants Emre Çam
Course Category
Course Objective To bring in knowledge and skill about teaching general structure of database and database management systems over Sql Server Program
Course Content Basic database concepts, data and data models, relational database design, SQL structured query language, basic SQL commands, SQL functions, grouping in SQL, assembling in SQL, administrative functions of SQL, using multiple tables with SQL, SQL programming and function, transaction and error states in SQL programming, VTYS setup and administrative operations, Sql query over VTYS.
# Course Learning Outcomes Teaching Methods Assessment Methods
1 Describes the concepts about database. Lecture, Question-Answer, Testing,
2 Explains the database functions. Discussion, Drilland Practice, Homework,
3 Design a database to use in a program. Problem Solving, Testing,
4 Classes database to get optimization methods. Drilland Practice, Oral Exam,
5 Uses SQL Server,MYSQL,Access programs. Problem Solving, Testing,
6 Teaches the usage of the programs about managing database Demonstration, Project / Design,
Week Course Topics Preliminary Preparation
1 Database concepts, data and data types
2 Relational database design – Access application
3 Sql query language
4 Functions used in Sql query language
5 General structure of Sql Server program
6 Sql Server Menus
7 Tables
8 Stored procedures
9 Relation
10 Views
11 Triggers
12 Creating a sample database
13 Database optimization
14 Database optimization methods
Resources
Course Notes
Course Resources
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 60
1. Ödev 20
2. Ödev 10
3. Ödev 10
Total 100
1. Yıl İçinin Başarıya 50
1. Final 50
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 2 32
Hours for off-the-classroom study (Pre-study, practice) 16 2 32
Mid-terms 1 1 1
Quiz 1 1 1
Assignment 1 10 10
Performance Task (Laboratory) 1 30 30
Final examination 1 3 3
Total Workload 109
Total Workload / 25 (Hours) 4.36
dersAKTSKredisi 5