Yazdır

Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
DATABASE MANAGEMENT SYSTEMS BTE 411 7 3 + 0 3 5
Ön Koşul Dersleri
Önerilen Seçmeli Dersler
Dersin Dili Türkçe
Dersin Seviyesi Lisans
Dersin Türü SECMELI
Dersin Koordinatörü Öğr.Gör. SELÇUK SIRRI TERCAN
Dersi Verenler
Dersin Yardımcıları Emre Çam
Dersin Kategorisi
Dersin Amacı
To bring in knowledge and skill about teaching general structure of database and database management systems over Sql Server Program
Dersin İçeriği
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.
Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 - Describes the concepts about database. 1 - 2 - A -
2 - Explains the database functions. 3 - 4 - C -
3 - Design a database to use in a program. 15 - A -
4 - Classes database to get optimization methods. 4 - B -
5 - Uses SQL Server,MYSQL,Access programs. 15 - A -
6 - Teaches the usage of the programs about managing database 5 - D -
Öğretim Yöntemleri: 1:Lecture 2:Question-Answer 3:Discussion 4:Drilland Practice 5:Demonstration 15:Problem Solving
Ölçme Yöntemleri: A:Testing C:Homework B:Oral Exam D:Project / Design

Ders Akışı

Hafta Konular ÖnHazırlık
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

Kaynaklar

Ders Notu
Ders Kaynakları

Döküman Paylaşımı


Dersin Program Çıktılarına Katkısı

No Program Öğrenme Çıktıları KatkıDüzeyi
1 2 3 4 5
1 Have high level information and skills supported by course books that include the most recent information, application equipment and other scientific sources related to education technologies, teaching profession, general information and basic sciences; use these information and skills in daily life and in jobs. X
2 Examine and evaluate concepts about education technology and teaching profession, ideas and data with scientific methods; diagnose, analyze and discuss complicated problems and subjects; develop suggestions based on scientific discoveries and evidences. X
3 Inform to audiences who are not expert and do not have information about education technology and teaching profession; express related ideas about these problems and solutions with written and oral.
4 Have learning to learn, self control, critical thinking, creative thinking skills and perform independent studies related to study field. X
5 Get responsibilities and try to produce solutions when face with unexpected and complicated cases in applications of education technologies and teaching professions. X
6 Know students’ interests, wishes and needs; know social, cultural and economic properties of families and environment; plan, apply and manage learning and teaching process suitable for these properties; get students active participation in learning process. X
7 Know information about education technologies and teaching professions and comprehend adequately; have information about foreign language in level of communicating with professional colleagues (“European Language Portfolio Global Scale”, Level B1). X
8 Have information about computer software and hardware in level of teaching computer and information and communication technologies courses and supporting other teachers; use informatics and communication technologies (“European Computer Driving License”, Advanced Level). X
9 Consider social, scientific and ethic values in levels of gathering data, analyzing, interpreting, announcing when doing teaching professions or working in private sector, being researcher or source of data. X
10 Continuously try to develop with doing self assessment; be on new information and ideas ; play affective role in developing of themselves and their intuition; know and behave according to the laws about their job, main values and principles, know the rights about job security and social security; have conscious about protecting social values and environment. X
11 Evaluate students’ improvement and learning, get students to evaluate themselves and other students; use the results of evaluation for better instruction; share the results with student, family, managers and teachers.
12
13
14
15

Değerlendirme Sistemi

YARIYIL İÇİ ÇALIŞMALARI SIRA KATKI YÜZDESİ
AraSinav 1 60
KisaSinav 1 10
Odev 1 20
SozluSinav 1 10
Toplam 100
Yıliçinin Başarıya Oranı 50
Finalin Başarıya Oranı 50
Toplam 100

AKTS - İş Yükü

Etkinlik Sayısı Süresi(Saat) Toplam İş yükü(Saat)
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
Toplam İş Yükü 109
Toplam İş Yükü /25(s) 4.36
Dersin AKTS Kredisi 4.36
; ;