TÜRKÇE
ENGLISH
Information
| Unit | KOZAN VOCATIONAL SCHOOL |
| Code | BL162 |
| Name | Database II |
| Term | 2018-2019 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 2-1 (T-A) (17 Week) |
| ECTS | 5 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 | Öğr. Gör. ERKUT TEKELİ |
| Course Instructor |
Öğr. Gör. ERKUT TEKELİ
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
With this course, students will acquire competencies related to manage database servers and use advanced SQL commads.
Course Content
Advanced SQL Commands and Database Server Management
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Install databeses |
| LO02 | use basic table operations |
| LO03 | use advenced table operations |
| LO04 | manage database servers |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Explain the basic scientific concepts related to Computer Technologies. | |
| PLO02 | - | Explains the functions of the electronic circuit elements that make up the computer subcomponents. | |
| PLO03 | - | Explains the basic concepts in the field of computer technologies. He / she installs and uses word processing, spreadsheet and presentation programs. | |
| PLO04 | - | Has the ability to solve problems in the field of computer programming. | |
| PLO05 | - | Explains basic concepts about computer hardware, makes simple installation, solves problems that do not require expertise. | |
| PLO06 | - | Know basic database systems, design and implement client / server software. | |
| PLO07 | - | In Computer Technologies, students use graphical programs used in interface design and 3D modeling in web pages at basic level. | |
| PLO08 | - | Explains, designs and installs network systems. | |
| PLO09 | - | Uses Internet technologies, develops server-side working internet applications. | |
| 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. | |
| 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. | |
| PLO12 | - | Knows a foreign language which is sufficient for the applications in the field. | |
| PLO13 | - | To be able to communicate effectively in written and oral Turkish. | |
| 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. | |
| PLO15 | - | Has knowledge about Atatürk's Principles and History of Revolution. | |
| PLO16 | - | It is aware of occupational health and safety, environmental and ethical values within the framework of global and social values. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Install a database server which have industrial standarts | Study from the textbook | |
| 2 | to Install database management studio, to create database and to dafine users. | Study from the textbook | |
| 3 | to create database and to dafine users, to create tables, to manage diagram | Study from the textbook | |
| 4 | to create tables, to manage diagram, to transfer data | Study from the textbook | |
| 5 | to transfer data, create new database from old one. | Study from the textbook | |
| 6 | to create new database from old one, views, triggers, stored procedures, and arrange indexes | Study from the textbook | |
| 7 | views, triggers, stored procedures, and arrange indexes | Study from the textbook | |
| 8 | Mid-Term Exam | Study from the textbook | |
| 9 | views, triggers, stored procedures, and arrange indexes, user roles, user defined data types | Study from the textbook | |
| 10 | user roles, user defined data types | Study from the textbook | |
| 11 | rules | Study from the textbook | |
| 12 | rules, replication, and to make backup plans | Study from the textbook | |
| 13 | replication, and to make backup plans | Study from the textbook | |
| 14 | Performance Anlysis and restoration | Study from the textbook | |
| 15 | Performance Anlysis and restoration | Study from the textbook | |
| 16 | Term Exams | Study from the textbook | |
| 17 | Term Exams | Study from the 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 |