Course Objectives: |
With this course, the student will gain competencies in designing, creating, querying, and using database administrative functions. |
Course Content: |
General structure of classical file system, basic concepts of database, basic features of relational database, database design, SQL (Structural Query Language) data types, creating tables, adding, updating, deleting operations, basic queries, functions, establishing relations between tables. |
Week |
Subject |
Related Preparation |
1) |
Introduction to database and basic concepts. |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
2) |
E-R model, entity, entity set, attribute, relation concepts, relation types |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
3) |
Logical Database Design and Model Physical Relational Database Design |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
4) |
Installing Database Tools, Creating Tables and Specifying Properties |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
5) |
Build and Use Query |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
6) |
Build and Use Query |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
7) |
Preparing Query with Related Tables |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
8) |
Midterm |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
9) |
Using DML Queries |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
10) |
Using DML Queries, Writing User Queries |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
11) |
Stored Procedure and Trigger |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
12) |
Project Presentations |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
13) |
Project Presentations |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
14) |
Project Presentations |
İlişkisel Veritabanı Tasarlama ve SQL ile Geliştirme (Nobel akademik yayıncılık,
Selçuk Kıran) |
|
Program Outcomes |
Level of Contribution |
1) |
To have the ability to apply knowledge in the fields of mathematics, science and programming to the development of software systems and the solution of problems related to computer programming. |
4 |
2) |
To have the ability to analyze and model problems specific to the field of software systems development and computer programming, and to identify and define appropriate software requirements for their solutions. |
4 |
3) |
Having the ability to design, develop and evaluate a software system, system part, process or program that will meet specified requirements. |
3 |
4) |
Have the ability to develop software systems and use modern technical and programming tools for computer programming applications. |
3 |
5) |
To have the discipline of software systems development and computer programming and the ability to demonstrate the necessary business skills to work effectively in interdisciplinary teams or individually. |
3 |
6) |
To have the ability to develop software systems and apply approaches in the development of computer programs by applying analysis, design, implementation, verification, validation and maintenance processes. |
1 |
7) |
To have awareness and awareness of professional, legal, ethical and social problems in the field of software and computer programming. |
2 |