Vocatıonal School
Informatıon Securıty Technology
Course Information
| DATABASES AND SQL LANGUAGES | |||||
|---|---|---|---|---|---|
| Code | Semester | Theoretical | Practice | National Credit | ECTS Credit |
| Hour / Week | |||||
| BGT105 | Fall | 3 | 2 | 3 | |
| Prerequisites and co-requisites | |
|---|---|
| Language of instruction | Turkish |
| Type | Required |
| Level of Course | Associate |
| Lecturer | |
| Mode of Delivery | Face to Face |
| Suggested Subject | |
| Professional practise ( internship ) | None |
| Objectives of the Course | The aim of this course is to teach database normalization, design, table arrangement, basic inquiry processes, gaining the ability to create a stored procedure and trigger. |
| Contents of the Course | Interconnections, Normalization rules, Database design by normalizing the data stack, Database and table design, Basic and complex inquiry, Stored procedure and trigger design, Managing database using stored procedures and triggers |
Learning Outcomes of Course
| # | Learning Outcomes |
|---|---|
| 1 | Learns connections between assets |
| 2 | Learn the rules of normalization |
| 3 | Gains the ability to design database by normalizing data stack |
| 4 | Learns database and table design |
| 5 | Gain basic and complex inquiry process skills |
| 6 | Learns stored procedure and trigger design |
| 7 | Gains the ability to manage database by using stored procedure and triggers |
Course Syllabus
| # | Subjects | Teaching Methods and Technics |
|---|---|---|
| 1 | Database needs analysis | Verbal lecture |
| 2 | Asset diagrams | Verbal lecture |
| 3 | Normalization | Verbal lecture |
| 4 | Normalization | Verbal lecture |
| 5 | Database software installation, database design | Verbal lecture |
| 6 | Table design, basic inquiry operations | Verbal lecture |
| 7 | Midterm | Written |
| 8 | Complex inquiry operations | Verbal lecture |
| 9 | Complex inquiry operations | Verbal lecture |
| 10 | Server and user management functions | Verbal lecture |
| 11 | Server and user management functions | Verbal lecture |
| 12 | Creating a stored procedure | Verbal lecture |
| 13 | Creating a stored procedure | Verbal lecture |
| 14 | Create a trigger | Verbal lecture |
| 15 | Create a trigger | Verbal lecture |
| 16 | Final Exam | Written |
Course Syllabus
| # | Material / Resources | Information About Resources | Reference / Recommended Resources |
|---|
Method of Assessment
| # | Weight | Work Type | Work Title |
|---|---|---|---|
| 1 | 40% | Mid-Term Exam | Mid-Term Exam |
| 2 | 60% | Final Exam | Final Exam |
Relationship between Learning Outcomes of Course and Program Outcomes
| # | Learning Outcomes | Program Outcomes | Method of Assessment |
|---|---|---|---|
| 1 | Learns connections between assets | 3 | 1 |
| 2 | Learn the rules of normalization | 2͵4͵6 | 1 |
| 3 | Gains the ability to design database by normalizing data stack | 2͵4͵5͵6 | 1 |
| 4 | Learns database and table design | 2͵4͵5͵7 | 2 |
| 5 | Gain basic and complex inquiry process skills | 1͵5͵6͵7 | 2 |
| 6 | Learns stored procedure and trigger design | 2͵4 | 2 |
| 7 | Gains the ability to manage database by using stored procedure and triggers | 2͵4 | 2 |
Work Load Details
| # | Type of Work | Quantity | Time (Hour) | Work Load |
|---|---|---|---|---|
| 1 | Course Duration | 14 | 3 | 42 |
| 2 | Course Duration Except Class (Preliminary Study, Enhancement) | 0 | 0 | 0 |
| 3 | Presentation and Seminar Preparation | 4 | 2 | 8 |
| 4 | Web Research, Library and Archival Work | 1 | 5 | 5 |
| 5 | Document/Information Listing | 1 | 5 | 5 |
| 6 | Workshop | 0 | 0 | 0 |
| 7 | Preparation for Midterm Exam | 1 | 5 | 5 |
| 8 | Midterm Exam | 1 | 5 | 5 |
| 9 | Quiz | 0 | 0 | 0 |
| 10 | Homework | 1 | 10 | 10 |
| 11 | Midterm Project | 0 | 0 | 0 |
| 12 | Midterm Exercise | 0 | 0 | 0 |
| 13 | Final Project | 0 | 0 | 0 |
| 14 | Final Exercise | 0 | 0 | 0 |
| 15 | Preparation for Final Exam | 1 | 5 | 5 |
| 16 | Final Exam | 1 | 5 | 5 |
| 90 | ||||