BAYBURT University Information Package / Course Catalogue

Home Information on the Institution Information on Degree Programmes General Information for Students
Ders Öğretim Planı
Dersin KoduDersin AdıDersin TürüYılYarıyılAKTS
YÖN203BDatabase Systems and Applications IZorunlu235
Dersin Seviyesi
Lisans
Dersin Amacı
Understanding database design. Knowing data security, backing up and restoring. Learn to use the Sql language. To improve the ability to make database connections and database transactions with programming languages. Manage databases and servers.
Dersi Veren Öğretim Görevlisi/Görevlileri
-
Öğrenme Çıktıları
1Learning the basic concepts of database
2Designing a Database
3Create a database
4Querying Database
5Using Database Administrative Functions
Öğrenim Türü
Normal Education
Dersin Ön Koşulu Olan Dersler
None
Ders İçin Önerilen Diğer Hususlar
None
Dersin İçeriği
1. Database design and management, 2. Data security, backup and restore, 3. SQL-DDL 4. SQL DML 5. SQL-DCL
Haftalık Ayrıntılı Ders İçeriği
HaftaTeorikUygulamaLaboratuvar
1Database basic conceptDatabase basic conceptDatabase basic concept
2NormalizationNormalizationNormalization
3Design database with Entity-Relation modelDesign database with Entity-Relation modelDesign database with Entity-Relation model
4Create database and tables with SQL Data Definition Language (DDL) CommandCreate database and tables with SQL Data Definition Language (DDL) CommandCreate database and tables with SQL Data Definition Language (DDL) Command
5usage of SQL data manipulation language (DML) commandsusage of SQL data manipulation language (DML) commandsusage of SQL data manipulation language (DML) commands
6Arithmetical operators and functionsArithmetical operators and functionsArithmetical operators and functions
7Arithmetical operators and functionsArithmetical operators and functionsArithmetical operators and functions
8Midterm
9Query on one tableQuery on one tableQuery on one table
10Query by groupingQuery by groupingQuery by grouping
11Query on more than one tableQuery on more than one tableQuery on more than one table
12Query on more than one tableQuery on more than one tableQuery on more than one table
13Usage of subqueryUsage of subqueryUsage of subquery
14Usage of subqueryUsage of subqueryUsage of subquery
15Usage of Data Control Language (DCL) commandsUsage of Data Control Language (DCL) commandsUsage of Data Control Language (DCL) commands
Ders Kitabı / Malzemesi / Önerilen Kaynaklar
Veri Tabanı Yönetim Sistemleri- Turgut ÖZSEVEN Veri Tabanı Yönetim Sistemleri PostreSQL- Ahmet FİNCAN, Yasin TATAR
Planlanan Öğrenme Aktiviteleri ve Metodları
Değerlendirme
Yarıyıl (Yıl) İçi EtkinlikleriAdetDeğer
Midterm Examination1100
TOPLAM100
Yarıyıl(Yıl) Sonu EtkinliklerAdetDeğer
Final Examination1100
TOPLAM100
Term (or Year) Learning Activities40
End Of Term (or Year) Learning Activities60
TOPLAM100
Dersin Sunulduğu Dil
Turkish
Staj Durumu
None
İş Yükü Hesaplaması
EtkinliklerSayısıSüresi (saat)Toplam İş Yükü (saat)
Midterm Examination111
Final Examination122
Attending Lectures14456
Practice10220
Self Study10220
Individual Study for Mid term Examination7321
Individual Study for Final Examination7321
TOPLAM İŞ YÜKÜ (saat)141
Program ve Öğrenme Çıktıları İlişkisi
PÇ
1		PÇ
2		PÇ
3		PÇ
4		PÇ
5		PÇ
6
ÖÇ1333333
ÖÇ2333333
ÖÇ3333333
ÖÇ4333333
ÖÇ5333333
* Katkı Düzeyi : 1 Çok düşük 2 Düşük 3 Orta 4 Yüksek 5 Çok yüksek