ANTALYA BİLİM
UNIVERSITY
Course Information Package
| Code | Description |
|---|---|
| LO1 | Students know the working logic of Database and Database Management Systems. |
| LO2 | Students can create new databases. |
| LO3 | Students can create, update and delete tables in the database. |
| LO4 | Students will be able to write queries using SQL language, edit data and prepare reports. |
| LO5 | Students will be able to add data to the database, update data, delete data using SQL language. |
| Week | Content |
|---|---|
| 1 | Introduction, What is a Database? |
| 2 | The place of database in systems, database types, database management systems |
| 3 | Use of DBMS (Database Management System), database creation, tables |
| 4 | Table creating, updating, data query, insertion, deletion with DBMS |
| 5 | Introduction to SQL language, running queries on DBMS, basic SELECT queries |
| 6 | DDL Commands - CREATE DATABASE, CREATE TABLE |
| 7 | DDL Commands - ALTER TABLE (ADD, ALTER, DROP COLUMN) |
| 8 | Midterm |
| 9 | DDL Commands - DROP TABLE, DROP DATABASE |
| 10 | DDL Commands - PRIMARY KEY: Meaning, Usage, and Creation Queries |
| 11 | DDL Commands - FOREIGN KEY: Meaning, Usage, and Creation Queries |
| 12 | DML Commands - INSERT, UPDATE, DELETE |
| 13 | Complex Queries - SELECT, WHERE, COUNT, MAX, MIN, GROUP BY, ORDER BY |
| 14 | Complex Queries - INNER JOIN , LEFT JOIN, RIGHT JOIN |
| Activity | Count | Duration (Hours) | Total |
|---|---|---|---|
| Attendance | 14 | 2.00 | 28.00 |
| Practice | 14 | 1.00 | 14.00 |
| Pre-Class Individual Study | 1 | 21.00 | 21.00 |
| Post-Class Individual Study | 1 | 22.00 | 22.00 |
| Midterm Exam/Preparation | 1 | 10.00 | 10.00 |
| Final Exam/Preparation | 1 | 25.00 | 25.00 |
| Total Workload (Hours) | 120 | ||
| ECTS Credit (Workload / 25) | 4 | ||
| # | Assessment Type | Contribution (%) |
|---|---|---|
| 1 | Midterm Exam | %40 |
| 2 | Final Exam | %60 |
| TOTAL | %100 | |
| PO \ LO |
LO1
|
LO2
|
LO3
|
LO4
|
LO5
|
|---|---|---|---|---|---|
| PO-1 | |||||
| PO-2 | |||||
| PO-3 | |||||
| PO-4 | |||||
| PO-5 | |||||
| PO-6 | |||||
| PO-7 | |||||
| PO-8 | |||||
| PO-9 | |||||
| PO-10 | |||||
| PO-11 | |||||
| PO-12 | |||||
| PO-13 | |||||
| PO-14 | |||||
| PO-15 | |||||
| PO-16 |
| # | Method Name | Description | Tools |
|---|---|---|---|
| 1 | Lecture (expository teaching), interactive discussion | Listening and taking notes. | Standard classroom technologies, multimedia tools (projector, computer, digital presentations) |
| 2 | Brainstorming | The purpose of forming pairs is to ensure that they are open to innovation during the idea generation phase | Standard classroom technologies, multimedia tools, projector, computer, overhead projector |
| 3 | Laboratory | Listening, note-taking, conceptual analysis, critical thinking, questioning, and participation in discussions. | Special equipment |
