Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
DATABASE APPLICATIONS AND SECURITY SGM104 2. Semester 3 + 2 4.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 The aim of this course is to provide students with the concept of database and its purposes, data models, three-level database structure, layered database architectures, understanding physical and conceptual database modeling, using relational algebra and structured query language, gaining competencies in database security, database attack and defense methods.
Course Content Database Fundamentals, Union and Join Statements, Data Definition Language, Database Attack and Defense Methods, Databese Security
Learning Outcomes 1) Grasp database management systems, their installation and usage advantages.
2) Ability to understand basic concepts such as entity-relationship diagram and data definition language (DDL) expressions, table creation, table properties, data types, integrity, and arithmetic operators, and solve problems related to these topics.
3) Understanding basic concepts about database design, normalization, subquery, creating queries in the database, union and join statements, NoSQL databases, and being able to solve related problems and apply this knowledge.
4) Ability to understand basic concepts related to database security, database attack and defense methods, SQL injection attacks and defense, database backup, user security management and application security, and be able to solve related problems and apply this knowledge.

Weekly Topics (Content)
Week Topics Teaching and Learning Methods and Techniques Study Materials
1. Week Introduction to Database Lecture; Question Answer; Problem Solving; Discussion

Problem Based Learning 		Seminar
2. Week Database Fundamentals, Database Types Lecture; Question Answer; Problem Solving; Discussion

Problem Based Learning 		Seminar
3. Week Entity-Relationship Diagram and Data Definition Language (DDL) Expressions Lecture; Question Answer; Problem Solving; Discussion

Project Based Learning; Problem Based Learning 		Homework Seminar
4. Week Creating a Table, Table Properties Lecture; Question Answer; Problem Solving; Discussion

Problem Based Learning 		Seminar
5. Week Data Types, Integrity and Arithmetic Operators Lecture; Question Answer; Problem Solving; Discussion

Problem Based Learning 		Seminar
6. Week Designing a Database, Normalization, Subquery, Creating a Query in the Database Lecture; Question Answer; Problem Solving; Discussion

Project Based Learning; Problem Based Learning 		Homework Seminar
7. Week Union and Join Statements, Creating NoSQL Databases Lecture; Question Answer; Problem Solving; Discussion

Problem Based Learning 		Seminar
8. Week Midterm Exam, Database Setup and Management Lecture; Question Answer; Problem Solving

Problem Based Learning 		Activity (Web Search, Library Work, Trip, Observation, Interview etc.) Seminar
9. Week Introduction to Database Security Lecture; Question Answer; Problem Solving; Discussion

Project Based Learning; Problem Based Learning 		Homework Seminar
10. Week Database Attack and Defense Methods Lecture; Question Answer; Problem Solving; Discussion

Problem Based Learning 		Seminar
11. Week SQL Injection Attacks and Defense Lecture; Question Answer; Problem Solving; Discussion

Problem Based Learning 		Seminar
12. Week Database Backup Lecture; Question Answer; Problem Solving; Discussion

Project Based Learning; Problem Based Learning 		Homework Seminar
13. Week User Security Management Lecture; Question Answer; Problem Solving; Discussion

Problem Based Learning 		Seminar
14. Week Application Security: Regulations and Compliances, General Audit, Architectural Audit Lecture; Question Answer; Problem Solving; Discussion

Problem Based Learning 		Seminar

Sources Used in This Course
Recommended Sources
Database Security: Problems and Solutions, Christopher Diaz, Mercury Learning and Information, (22 Aug. 2022).
Veri Tabanı Sistemleri, Dr.Yalçın Özkan, Alfa yayınevi DERS ARAÇLARI: Bilgisayar, Projeksiyon cihazı, Veri Tabanı Yönetim Sistemi yazılımı, SQL Editörü yazılımı.

Relations with Education Attainment Program Course Competencies
Program RequirementsContribution LevelDK1DK2DK3DK4
PY150000
PY255555
PY350000
PY455555
PY550000

*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 2
Practice (Teaching Practice, Music/Musical Instrument Practice , Statistics, Laboratory, Field Work, Clinic and Polyclinic Practice) 14 2
Midterm Exam 1 2
Time to prepare for Midterm Exam 1 8
Final Exam 1 2
Time to prepare for Final Exam 1 14
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