ANTALYA BİLİM
UNIVERSITY
Course Information Package
| Code | Description |
|---|---|
| LO1 | Students can use the MS SQL SERVER program. |
| LO2 | Students can write queries with SQL and T-SQL language. |
| LO3 | Students can use SQL Server Basic Functions. |
| LO4 | Students can generate and use Stored Procedure. |
| LO5 | Students can generate and use functions and triggers. |
| Week | Content |
|---|---|
| 1 | Introduction, general review. |
| 2 | SSMS setup, connection, database creation |
| 3 | SQL SELECT, UPDATE, DELETE, MIN, MAX, COUNT, AVG, SUM |
| 4 | What is T-SQL, what is FUNCTION, what is PROCEDURE, what is TRIGGER |
| 5 | SQL Server String Functions - SQL Server Math/Numeric Functions |
| 6 | SQL Server Date Functions, SQL Server Advanced Functions |
| 7 | Views |
| 8 | Midterm |
| 9 | T-SQL - Create and drop functions |
| 10 | T-SQL - Declare Variables |
| 11 | T-SQL - Conditional Statements |
| 12 | T-SQL - Loops |
| 13 | T-SQL - Stored Procedures |
| 14 | T-SQL - Triggers |
| 15 | T-SQL Applications |
| 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 |
