Dersin Kodu | Dersin Adı | Dersin Türü | Yıl | Yarıyıl | AKTS | BLG1062010783 | DATABASE I | Zorunlu | 1 | 2 | 4 |
|
Dersin Seviyesi |
Ön Lisans |
Dersin Amacı |
The aim of the course is
• to gain sufficiencies of designing and creating databases, making queries and using database management functions
|
Dersi Veren Öğretim Görevlisi/Görevlileri |
Öğr. Gör. Murat ÇETİNKAYA |
Öğrenme Çıktıları |
1 | Database Designing | 2 | Create Database | 3 | Querying the database | 4 | Database Using Administrative Functions |
|
Öğrenim Türü |
Evening Education |
Dersin Ön Koşulu Olan Dersler |
Yok |
Ders İçin Önerilen Diğer Hususlar |
Week 1 Database requirement analysis, Normalization
Week2 Normalization
Week 3 Normalization
Week 4 Installation of database tools, Creating tables and determining fields
Week 5 Creating tables and determining fields
Week 6 Creating tables and determining fields
Week 7 Creating various queries
Week 8 Creating various queries, Creating queries with related tables
Week 9 Creating queries with related tables
Week 10 Using DML queries
Week 11 Using DML queries, Writing user queries
Week 12 Writing views, Writing triggers
Week 13 Writing triggers, Writing stored procedures
Week 14 Making transaction operations, Writing index queries
|
Dersin İçeriği |
Database requirement analysis, Normalization
• Installation of database tools, Creating tables and determining fields
• Creating tables and determining fields
• Creating various queries
• Creating queries with related tables
• Using DML queries
• Writing user queries
• Writing views
• Writing triggers
• Writing stored procedures
• Writing stored procedures
• Making transaction operations
• Writing index queries
|
Haftalık Ayrıntılı Ders İçeriği |
|
1 | Needs Analysis Database Normalization | | | 2 | Normalization | | | 3 | Normalization | | | 4 | From the Setup Database Tools. Creating tables and to determine the characteristics | | | 5 | Creating Tables and select Properties | | | 6 | Create the table and determine the properties | | | 7 | Create and use the query type | | | 8 | Midterm Exam | | | 9 | Create a query and use it to type. Queries related to Prepared Statements | | | 10 | Prepare the query with related tables | | | 11 | Using DML queries | | | 12 | Using DML queries. Writing Queries | | | 13 | Views Writing Queries. Trigger Query Writing | | | 14 | Transaction Processing to do. Writing Queries Index | | |
|
Ders Kitabı / Malzemesi / Önerilen Kaynaklar |
Yaşar Gözüdeli, Yazılımcılar İçin SQL server 2005 Veritabanı programlama, Seçkin Yayıncılık
Kadir Çamoğlu , SQL Server 2005 , Seçkin yayıncılık |
Planlanan Öğrenme Aktiviteleri ve Metodları |
|
Değerlendirme | |
TOPLAM | 0 | |
TOPLAM | 0 | Yarıyıl (Yıl) İçi Etkinlikleri | 40 | Yarıyıl (Yıl) Sonu Etkinlikleri | 60 | TOPLAM | 100 |
| Dersin Sunulduğu Dil | Turkish | Staj Durumu | Yok |
|
İş Yükü Hesaplaması |
|
Midterm Examination | 1 | 2 | 2 |
Final Examination | 1 | 2 | 2 |
Attending Lectures | 14 | 4 | 56 |
Self Study | 11 | 3 | 33 |
Individual Study for Homework Problems | 6 | 2 | 12 |
Individual Study for Mid term Examination | 2 | 4 | 8 |
Individual Study for Final Examination | 2 | 4 | 8 |
|
Program ve Öğrenme Çıktıları İlişkisi |
ÖÇ1 | | | | | | | | | | | | 5 | | | | | | | | | | 5 | | | 5 | | | | ÖÇ2 | | | | | | | | | | | | 5 | | | | | | | | | | 5 | | | 5 | | | | ÖÇ3 | | | | | | | | | | | | 5 | | | | | | | | | | 4 | | | 5 | | | | ÖÇ4 | | | | | | | | | | | | 5 | | | | | | | | | | 4 | | | 5 | | | |
|
* Katkı Düzeyi : 1 Çok düşük 2 Düşük 3 Orta 4 Yüksek 5 Çok yüksek |
|
|
Ordu University Rectorate Building ,Cumhuriyet Campus , Center / ORDU / TURKEY • Tel: +90 452 226 52 00
|