Information Package / Course Catalogue
Database - II
Course Code: BPR203
Course Type: Required
Couse Group: Short Cycle (Associate's Degree)
Education Language: Turkish
Work Placement: N/A
Theory: 3
Prt.: 1
Credit: 4
Lab: 0
ECTS: 4
Objectives of the Course

This course aims to acquire the competencies related to managing the student, the database and the servers

Course Content

To install the server software, the database administration panel. To create database, users can define tables and manage diagrams. Organize view, trigger, subprograms and indexes. User roles, user-defined types of data to edit. Make data replication operations and maintenance plan. Performing performance analysis and improvements.

Name of Lecturer(s)
Ins. Erkan GÜLER
Learning Outcomes
1.Setting up the database
2.Making basic table operations
3.Making advanced table operations
4.Managing the database server
5.Perform database design of a system
6.Knows the data types used in QL (structural query language), can create database tables using SQL commands
Recommended or Required Reading
1.Visual basic and Database M. Şakir Unutur Arter yayıncılık
Weekly Detailed Course Contents
Week 1 - Theoretical
Establish server software of at least two different industry standard industry vendors
Week 2 - Theoretical
Setting up the database administration panel, creating the database and defining the users
Week 3 - Theoretical
Creating databases and defining users, Defining tables and managing diagrams
Week 4 - Theoretical
Defining tables and managing diagrams, Performing data transfer operations
Week 5 - Theoretical
Perform data transfer operations, Create new database from existing database
Week 6 - Theoretical
Create new database from existing database, edit views, triggers, subprograms and indexes
Week 7 - Theoretical
Organizing views, triggers, subprograms and indexes
Week 8 - Theoretical
Organizing views, triggers, subprograms and indexes, Organizing user roles, user-defined data types (midterm)
Week 9 - Theoretical
Editing user roles, user-defined data types
Week 10 - Theoretical
To edit rules and default values
Week 11 - Theoretical
Regulate rules and default values, Perform data replication operations and maintenance plan
Week 12 - Theoretical
Perform data replication operations and maintenance plan
Week 13 - Theoretical
Perform performance analysis and improvements
Week 14 - Theoretical
Perform performance analysis and improvements
Assessment Methods and Criteria
Type of AssessmentCountPercent
Midterm Examination1%40
Final Examination1%60
Workload Calculation
ActivitiesCountPreparationTimeTotal Work Load (hours)
Lecture - Theory140342
Assignment80432
Reading140114
Midterm Examination1516
Final Examination1516
TOTAL WORKLOAD (hours)100
Contribution of Learning Outcomes to Programme Outcomes
PÇ-1
PÇ-2
PÇ-3
PÇ-4
PÇ-5
PÇ-6
PÇ-7
PÇ-8
PÇ-9
PÇ-10
PÇ-11
OÇ-1
5
5
5
1
2
2
2
1
1
1
2
OÇ-2
5
5
5
1
2
1
1
1
1
1
1
OÇ-3
4
4
4
1
2
2
1
1
1
1
1
OÇ-4
4
4
4
1
2
2
1
1
1
1
1
OÇ-5
4
4
4
4
2
2
1
1
1
1
1
OÇ-6
4
4
4
4
2
2
2
1
1
1
1
Adnan Menderes University - Information Package / Course Catalogue
2026