| Dersin Kodu | Dersin Adı | Dersin Türü | Yıl | Yarıyıl | AKTS | | BLG2092010783 | DATABASE II | Zorunlu | 2 | 3 | 4 |
|
| Dersin Seviyesi |
| Ön Lisans |
| Dersin Amacı |
| The aim of the course is
• to gain sufficiencies of managing database and database servers
|
| Dersi Veren Öğretim Görevlisi/Görevlileri |
| Öğr. Gör. Murat ÇETİNKAYA |
| Öğrenme Çıktıları |
| 1 | The client / server database software to comprehend the logic of programming. | | 2 | The client / server search a database of hundreds of special (form) can be prepared. | | 3 | Client / server-featured database gains the ability to prepare reports. |
|
| Öğrenim Türü |
| Evening Education |
| Dersin Ön Koşulu Olan Dersler |
| Yok |
| Ders İçin Önerilen Diğer Hususlar |
| Week 1 Installing two servers created by different producers compatible with industrial standard
Week2 Installing database management panel, creating database and defining users
Week 3 Creating database and defining users, Defining tables and managing diagrams
Week 4 Defining tables and managing diagrams, Making data transfer operations
Week 5 Making data transfer operations,
Week 6 Creating a database from existing database,
Week 7 Editing views, triggers, stored procedures and indexes
Week 8 Editing views, triggers, stored procedures and indexes
Week 9 Editing user roles and user-defined data types
Week 10 Editing rules and default values
Week 11 Making replication and maintenance plan
Week 12 Making replication and maintenance plan
Week 13 Making performance analysis and optimizations
Week 14 Making performance analysis and optimizations
|
| Dersin İçeriği |
| • Installing two servers created by different producers compatible with industrial standard
• Installing database management panel, creating database and defining users
• Creating database and defining users, Defining tables and managing diagrams
• Defining tables and managing diagrams, Making data transfer operations
• Making data transfer operations,
• Creating a database from existing database,
• Editing views, triggers, stored procedures and indexes
• Editing user roles and user-defined data types
• Editing rules and default values
• Making replication and maintenance plan
• Making performance analysis and optimizations
|
| Haftalık Ayrıntılı Ders İçeriği |
|
| 1 | Installing two servers created by different producers compatible with industrial standard | | | | 2 | Installing database management panel, creating database and defining users | | | | 3 | Creating database and defining users, Defining tables and managing diagrams | | | | 4 | Defining tables and managing diagrams, Making data transfer operations | | | | 5 | Making data transfer operations, | | | | 6 | Creating a database from existing database, | | | | 7 | Editing views, triggers, stored procedures and indexes | | | | 8 | Editing views, triggers, stored procedures and indexes | | | | 9 | Editing user roles and user-defined data types | | | | 10 | Editing rules and default values | | | | 11 | Making replication and maintenance plan | | | | 12 | Making replication and maintenance plan | | | | 13 | Making performance analysis and optimizations
| | | | 14 | Making performance analysis and optimizations | | |
|
| 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.
Öğretim Görevlisi Ders Notları ve Uygulama Ödevleri. |
| 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 | 1 | 1 |
| Final Examination | 1 | 2 | 2 |
| Attending Lectures | 14 | 4 | 56 |
| Self Study | 13 | 3 | 39 |
| Individual Study for Homework Problems | 5 | 2 | 10 |
| Individual Study for Mid term Examination | 2 | 2 | 4 |
| Individual Study for Final Examination | 4 | 2 | 8 |
|
| Program ve Öğrenme Çıktıları İlişkisi |
| ÖÇ1 | | | | | 5 | | | | | | | | | | | | 5 | 5 | | | | | | | | | | | | ÖÇ2 | | | | | 5 | | | | | | | | | | | | 4 | 5 | | | | | | | | | | | | ÖÇ3 | | | | | 4 | | | | | | | | | | | | 5 | 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
|