TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF EDUCATION |
| COMPUTER EDUCATION AND INSTRUCTIONAL TECHNOLOGY PR. | |
| Code | BTE314 |
| Name | Database Management Systems |
| Term | 2019-2020 Academic Year |
| Semester | 6. Semester |
| Duration (T+A) | 2-2 (T-A) (17 Week) |
| ECTS | 5 ECTS |
| National Credit | 3 National Credit |
| Teaching Language | Türkçe |
| Level | Üniversite Dersi |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Prof. Dr. OZAN ŞENKAL |
| Course Instructor |
Prof. Dr. OZAN ŞENKAL
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
The aim of this course is to bring in knowledge and skill about teaching general structure of database and database management systems over Sql Server Program
Course Content
Basic database concepts, data and data models, relational database design, SQL structured query language, basic SQL commands, SQL functions, grouping in SQL, assembling in SQL, administrative functions of SQL, using multiple tables with SQL, SQL programming and function, transaction and error states in SQL programming, DBMS setup and administrative operations, SQL query over DBMS.
Course Precondition
Resources
Notes
Veri Tabanı Yönetim Sistemleri-[SQL/PL-SQL/T-SQL]-(2009)-Yrd. Doç. Dr. Zehra Alakoç Burma-Seçkin Yayıncılık
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Describes the concepts about database |
| LO02 | Explains the database functions |
| LO03 | Designs a database to use in a program |
| LO04 | Classifies database to get optimization methods |
| LO05 | Uses SQL Server, MYSQL, Access programs |
| LO06 | Teaches the usage of the programs about managing database |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Explain sub-fields of instructional technologies and integral structure of its process and also its relation to the other fields.Explain the integral structure of instructional technologies and information technologies or computer science applications.Explain concepts that constitutes the basis for scientific thinking in the scope of the field and the related fields. | 4 |
| PLO02 | - | Apply the processes of analysis, design, development, and evaluation on the basis of knowledge of instructional technologies.Utilize information technologies and computer science applications in order to create an effective and productive learning environment.Utilize concepts and applications of scientific research and basic statistics, which are the basis of scientific thinking, for the conditions in the scope of the field and related fields. | 4 |
| PLO03 | - | Apply the processes of analysis, design, development, and evaluation on the basis of knowledge of instructional technologies.Utilize information technologies and computer science applications in order to create an effective and productive learning environment.Utilize concepts and applications of scientific research and basic statistics, which are the basis of scientific thinking, for the conditions in the scope of the field and related fields. | 3 |
| PLO04 | - | Develop a plan, apply the plan and assess the results based on scientific view for the solution of the problems presented in the scope of the field or related fields.Put forward new products or processes on the basis of components of instructional technologies, computer science, for the related situations. | 4 |
| PLO05 | - | Develop a personal proposal, a product or a group of processes for the solution of a problem related to the field as an indicator of the skills of working independently and taking responsibility.Take responsibility of an individual or group projects and accomplishing his/her undertaken missions. | 3 |
| PLO06 | - | Follow current problems and applications and determining information and skills to undertake learning missions for the following stage.Apply the solution for the problem on the basis of scientific and ethical values when she/he confronts a learning problem. | 3 |
| PLO07 | - | Build a healthy communication with students, teachers, school administration, and the individuals in the study group. Comprehend a foreign language in order to follow the international resources that can be utilized for the solution of problems related to the field. Take responsibilities for the distribution and dissemination of the developments in the field on local or national range. | 3 |
| PLO08 | - | Act on the basis of scientific and ethical values in her/his works and also support preservation and learning of these values. Develop and evaluate strategic views on topic related to the future of the field. Transfer related progresses in other related fields to the field of instructional technologies. Create and maintain a cooperative and productive working environment by developing an insight related to the behaviors of the shareholders. | 5 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Database concepts, data and data types | Related subjects in the course text book | |
| 2 | Relational database design - Access application | Related subjects in the course text book | |
| 3 | Sql query language | Related subjects in the course text book | |
| 4 | Functions used in Sql query language | Related subjects in the course text book | |
| 5 | General structure of Sql Server program | Related subjects in the course text book | |
| 6 | Sql server menus | Related subjects in the course text book | |
| 7 | Tables | Related subjects in the course text book | |
| 8 | Mid-Term Exam | Preparing for the exam and rewieving of the topics | |
| 9 | Stored procedures 1 | Related subjects in the course text book | |
| 10 | Stored procedures 2 | Related subjects in the course text book | |
| 11 | Views | Related subjects in the course text book | |
| 12 | Triggers | Related subjects in the course text book | |
| 13 | Creating a sample database | Related subjects in the course text book | |
| 14 | Database optimization | Related subjects in the course text book | |
| 15 | Database optimization methods | Related subjects in the course text book | |
| 16 | Term Exams | Preparing for the exam and rewieving of the topics | |
| 17 | Term Exams | Preparing for the exam and rewieving of the topics |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 20 |
| General Assessment | ||
| Midterm / Year Total | 100 | 20 |
| 1. Final Exam | - | 80 |
| Grand Total | - | 100 |