TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| Code | BL217 |
| Name | Database II |
| Term | 2021-2022 Academic Year |
| Semester | 3. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 2.5 National Credit |
| Teaching Language | Türkçe |
| Level | Belirsiz |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | AHMET KIZIL |
| Course Instructor |
AHMET KIZIL
(Güz)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
To gain the ability to manage the database server
Course Content
Advanced SQL Commands and Database Server Management
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Student uses advanced SQL commands |
| LO02 | Student performs Normalization |
| LO03 | Student creates View, Stored Procedure and Function |
| LO04 | The student manages the database |
| LO05 | Student ensures database security |
| LO06 | Student plans and implements backup and restore operations |
| LO07 | Student tracks query performance and improves performance |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Explain the basic scientific concepts related to Computer Technologies. | 0 |
| PLO02 | - | Explains the functions of the electronic circuit elements that make up the computer subcomponents. | 0 |
| PLO03 | - | Explains the basic concepts in the field of computer technologies. He / she installs and uses word processing, spreadsheet and presentation programs. | 0 |
| PLO04 | - | Has the ability to solve problems in the field of computer programming. | 0 |
| PLO05 | - | Explains basic concepts about computer hardware, makes simple installation, solves problems that do not require expertise. | 0 |
| PLO06 | - | Know basic database systems, design and implement client / server software. | 5 |
| PLO07 | - | In Computer Technologies, students use graphical programs used in interface design and 3D modeling in web pages at basic level. | 0 |
| PLO08 | - | Explains, designs and installs network systems. | 0 |
| PLO09 | - | Uses Internet technologies, develops server-side working internet applications. | 0 |
| PLO10 | - | It is able to carry out a basic study related to its field in independent or disciplined teams and has the confidence to take responsibility. | 0 |
| PLO11 | - | By taking into consideration the necessity of lifelong learning, it follows the developments in its field and can do resource research for this purpose, use databases and other information sources. | 0 |
| PLO12 | - | Knows a foreign language which is sufficient for the applications in the field. | 0 |
| PLO13 | - | To be able to communicate effectively in written and oral Turkish. | 0 |
| PLO14 | - | He/she can clearly explain the designs and applications related to computer technologies to his colleagues, superiors, others who are related to the field or not. | 0 |
| PLO15 | - | Has knowledge about Atatürk's Principles and History of Revolution. | 0 |
| PLO16 | - | It is aware of occupational health and safety, environmental and ethical values within the framework of global and social values. | 0 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Basic Database Concepts | Study from textbook | |
| 2 | Data Base and Normalization | Study from textbook | |
| 3 | Installing Database Tools | Study from textbook | |
| 4 | Creating Tables and Determining Their Properties | Study from textbook | |
| 5 | Creating Database and Tables with TSQL, Determining Their Properties | Study from textbook | |
| 6 | Creating a query and using query types - 1 | Study from textbook | |
| 7 | Creating a query and using query types - 2 | Study from textbook | |
| 8 | Mid-Term Exam | Study from textbook | |
| 9 | Creating a query and using query types - 3 | Study from textbook | |
| 10 | Creating a query and using query types - 4 | Study from textbook | |
| 11 | Preparing Queries with Related Tables | Study from textbook | |
| 12 | View, Store Procedures and Functions | Study from textbook | |
| 13 | Managing the Database | Study from textbook | |
| 14 | Database Security | Study from textbook | |
| 15 | Backup and Restore | Study from textbook | |
| 16 | Term Exams | Study from textbook | |
| 17 | Term Exams | Study from textbook |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |