Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
DATABASE AND APPICATIONS UEBP206 4. Semester 3 + 0 3.0 5.0

Prerequisites None

Language of Instruction Turkish
Course Level Associate's Degree
Course Type Compulsory
Mode of delivery
Course Coordinator
Instructors
Assistants
Goals This course details Microsoft SQL Server. Topics include: learning how to create and manipulate database objects. Students will be introduced to the basics of using SQL Server, indexs, functions, triggers, cursors, security, connected ve disconnected layers, transaction.
Course Content Advanced Database
Learning Outcomes 1) SQL Server Basics, indexs, functions, triggers, cursors, security, connected ve disconnected layers, transaction.
2) Understanding Tables and Databases.
3) Indexes and Views.

Weekly Topics (Content)
Week Topics Teaching and Learning Methods and Techniques Study Materials
1. Week SQL Server Basics. Lecture; Question Answer; Problem Solving
Brainstorming; Six Hats Thinking; Opinion Pool
Project Based Learning; Problem Based Learning; Storyline 		Homework Presentation (Including Preparation Time) Project (Including Preparation and presentation Time)

Sources Used in This Course
Recommended Sources
Ramakrishnan, R. and Gehrke J., Database Management Systems (Third Edition), WCB/McGraw Hill, ISBN: 0-07-232206-3

Relations with Education Attainment Program Course Competencies
Program RequirementsContribution LevelDK1DK2DK3
PY15000
PY25000
PY35000
PY45000

*DK = Course's Contrubution.
0 1 2 3 4 5
Level of contribution None Very Low Low Fair High Very High
.

ECTS credits and course workload
Event Quantity Duration (Hour) Total Workload (Hour)
Course Duration (Total weeks*Hours per week) 14 3
Work Hour outside Classroom (Preparation, strengthening) 14 3
Homework 4 5
Project (Including Preparation and presentation Time) 1 10
Midterm Exam 1 1
Time to prepare for Midterm Exam 1 15
Final Exam 1 1
Time to prepare for Final Exam 1 15
Total Workload
Total Workload / 30 (s)
ECTS Credit of the Course
Quick Access Hızlı Erişim Genişlet
Course Information
  • Course Information
  • Weekly Topics (Content)
  • Sources Used in This Course
  • Relations with Education Attainment Program Course Competencies
  • ECTS credits and course workload