Yazdır

Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
DATABASE APPLICATIONS WITH ORACLE EBT 553 0 3 + 0 3 6
Ön Koşul Dersleri
Önerilen Seçmeli Dersler
Dersin Dili Türkçe
Dersin Seviyesi Yüksek Lisans
Dersin Türü SECMELI
Dersin Koordinatörü Prof.Dr. AHMET ÖZMEN
Dersi Verenler
Dersin Yardımcıları
Dersin Kategorisi
Dersin Amacı
To teach basic understanding of database system management, and develop various database systems using Oracle. To teach oracle SQL labguage. Advanced topics in Oracle database systems.
Dersin İçeriği
Basic database structures. Data definition language and manipulation language. Queries. Code blocks, procedures, functions and triggers.
Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
2 - Knows Oracle database management system 1 - 4 - A - C -
3 - Uses Oracle database management system 1 - 4 - 16 - A - C - D -
Öğretim Yöntemleri: 1:Lecture 4:Drilland Practice 16:Project Based Learning
Ölçme Yöntemleri: A:Testing C:Homework D:Project / Design

Ders Akışı

Hafta Konular ÖnHazırlık
1 Genearal structure of database systems.
2 History of Oracle database system and architecture.
3 Introduction to SQL. Queries using SQL commands.
4 SQL plus. Execises with SQL commands using SQL plus interface.
5 SQL operators: Aritmetic, logical and comparator operators.
6 Grouping in queries.
7 Querying multiple tables.
8 DML: manupilation of database objects.
9 DDL: data definition of database objects.
10 PL/SQL: Oracle code blocks. Definition of variables, execution of code blocks.
11 PL/SQL: Oracle function and procedures.
12 PL/SQL: Oracle triggers.
13 Example applications with PL/SQL.
14 Application development using Oracle Apex.

Kaynaklar

Ders Notu 1. Oracle Veritabanı ve Uygulamaları Ders Notu, Doç Dr. Ahmet Özmen, 2012.
2. Oracle/SQL Tutorial, Michael Gertz.
Ders Kaynakları 1. Oracle Essentials, Oracle Database 11g,Rick Greenwald, Robert Stackowiak ve Jonathan Stern, O´Reilly, 2008.

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 ability to access wide and deep information with scientific researches in the field of Engineering, evaluate, interpret and implement the knowledge gained in his/her field of study X
2 ability to complete and implement limited or incomplete data by using the scientific methods. X
3 ability to consolidate engineering problems, develop proper method(s) to solve and apply the innovative solutions to them X
4 ability to develop new and original ideas and method(s), to develop new innovative solutions at design of system, component or process X
5 gain comprehensive information on modern techniques, methods and their borders which are being applied to engineering X
6 ability to design and apply analytical, modelling and experimental based research, analyze and interpret the faced complex issues during the design and apply process X
7 gain high level ability to define the required information and data X
8 ability to work in multi-disciplinary teams and to take responsibility to define approaches for complex situations X
9 systematic and clear verbal or written transfer of the process and results of studies at national and international environments X
10 aware of social, scientific and ethical values guarding adequacy at all professional activities and at the stage of data collection, interpretation and announcement X
11 aware of new and developing application of profession and ability to analyze and study on those applications X
12 ability to interpret engineering applications social and environmental dimensions and its compliance with the social environment X

Değerlendirme Sistemi

YARIYIL İÇİ ÇALIŞMALARI SIRA KATKI YÜZDESİ
AraSinav 1 30
Odev 1 35
Odev 2 35
Toplam 100
Yıliçinin Başarıya Oranı 40
Finalin Başarıya Oranı 60
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 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 2 32
Mid-terms 1 10 10
Assignment 2 20 40
Final examination 1 15 15
Toplam İş Yükü 145
Toplam İş Yükü /25(s) 5.8
Dersin AKTS Kredisi 5.8
; ;