Course Contents |
Establish a panel, database management, database users to create and define , Create a database and identify users, identify the tables and diagrams to manage Data transfer to operations, the existing database, create a new database Views, triggers, and indexes to edit subroutines Terms and edit the default values, data replication operations and maintenance plan to make Performance analysis and to make improvements |
Weekly Course Content |
Week |
Subject |
Learning Activities and Teaching Methods |
1 |
Setup industry-standard server software at least two different manufacturers |
Narration, question and answer,Solving Problem,Practice |
2 |
Setup Admin Panel, Create Database and Define Users |
Narration, question and answer,Solving Problem,Practice |
3 |
Setup Admin Panel, Create Database and Define Users |
Narration, question and answer,Solving Problem,Practice |
4 |
Define tables and manage diagram, |
Narration, question and answer,Solving Problem,Practice |
5 |
Do data transfer operations,Create Database with existing database |
Narration, question and answer,Solving Problem,Practice |
6 |
Create Database with existing database |
Narration, question and answer,Solving Problem,Practice |
7 |
Views, triggers, edit indexes and subprograms |
Narration, question and answer,Solving Problem,Practice |
8 |
mid-term exam |
|
9 |
Views, triggers, edit indexes and subprograms, edit user roles,edit user-defined data type |
Narration, question and answer,Solving Problem,Practice |
10 |
edit user roles,edit user-defined data type |
Narration, question and answer,Solving Problem,Practice |
11 |
Edit terms and the default values |
Narration, question and answer,Solving Problem,Practice |
12 |
Edit terms and the default values, |
Narration, question and answer,Solving Problem,Practice |
13 |
Make Data multiplication processes and meintenance plan |
Narration, question and answer,Solving Problem,Practice |
14 |
Make performance analysis and improvements |
Narration, question and answer,Solving Problem,Practice |
15 |
Make performance analysis and improvements |
Narration, question and answer,Solving Problem,Practice |
16 |
final exam |
|
Recommend Course Book / Supplementary Book/Reading |
1 |
Sql Server 2005 Express Edition,Kadir Çamoğlu - Gökhan Gürel , ISBN: 975-6477-62-8, Pusula Yayıncılık |
2 |
Sql Server 2005, Kadir Çamoğlu, ISBN: 978-975-6477-91, Pusula Yayıncılık |
Required Course instruments and materials |
Lesson Book,Projection,Computer |