Information Systems and Technologies | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
Course Code: | BST360 | ||||||||
Course Name: | Advanced Database | ||||||||
Course Semester: | Fall | ||||||||
Course Credits: |
|
||||||||
Language of instruction: | TR | ||||||||
Course Requisites: | |||||||||
Does the Course Require Work Experience?: | No | ||||||||
Type of course: | Department Elective | ||||||||
Course Level: |
|
||||||||
Mode of Delivery: | Face to face | ||||||||
Course Coordinator : | Dr.Öğr.Üyesi FERİDUN CEMAL ÖZÇAKIR | ||||||||
Course Lecturer(s): |
Dr. BİLİNMİYOR BEKLER |
||||||||
Course Assistants: |
Course Objectives: | Creating relational database modeling, learning database advanced query techniques and procedural database programming. |
Course Content: | Designing relational databases, configuring the security mechanism of database servers, stored procedures, functions, triggers, procedural programming, using comparison and control statements on database, using loop statements, efficient database procedural programming with cursor structures. |
The students who have succeeded in this course;
|
Week | Subject | Related Preparation |
1) | Overview of Database and SQL Server Structure | |
2) | SQL Server and SQL Server Security Mechanism, Relational Database Model | |
3) | Data Definition Language Commands (DDL) (CREATE, DROP, ALTER ..) and Data Manipulation Language Commands (DML) (SELECT, INSERT, DELETE, UPDATE) | |
4) | Joins (INNER, LEFT OUTER, RIGHT OUTER), Relations - Restrictions (CONSTRAINTS) | |
5) | Triggers (INSERT, DELETE, UPDATE) | |
6) | Data Control Language statements (Expression and Object permissions, GRANT, DENY and REVOKE) | |
7) | Variables, Comparison and Control Statements (IF / ELSE, BEGIN / END, WHILE, GOTO and CASE commands) | |
8) | Midterm Exam | |
9) | Stored Procedures - Input and Output Parameters | |
10) | User Defined Functions (Table-valued, Scalar-valued) | |
11) | Advanced Query Design (Subqueries - add, delete and update data with queries) | |
12) | Cursors (Navigational, Static, Dynamic, Keyed, Salt-Forward cursors) | |
13) | Transactions and Locks | |
14) | Creating Scheduled Tasks | |
15) | Final Exam |
Course Notes / Textbooks: | Microsoft SQL Docs - Programming |
References: | - Inside Microsoft SQL Server 2008: T-SQL Programming (Itzik Ben-Gan, Dejan Sarka, Ed Katibah, Greg Low, Roger Wolter, Isaac Kunen) - Microsoft Press - Programming Microsoft SQL Server 2012 (Leonard Lobel, Andrew Brust) - Microsoft Press |
Learning Outcomes | 1 |
2 |
3 |
|
---|---|---|---|---|
Program Outcomes | ||||
1) Having knowledge and skills in software development for different environments, systems management, network security, data and database management systems. | ||||
2) Keeping up-to-date with current issues about new information systems that are the result of rapid change of information technologies. | ||||
3) Be aware of the importance of Information Systems' stratagic position in the firm and its role in the creation of new business strategies. | ||||
4) To be able to explain the ideas and suggestions that is related to the field of Information Systems as in writing and orally. | ||||
5) ability to carry out an independent study on the subjects requiring expertise in the field of Information Systems. |
No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
Program Outcomes | Level of Contribution | |
1) | Having knowledge and skills in software development for different environments, systems management, network security, data and database management systems. | 5 |
2) | Keeping up-to-date with current issues about new information systems that are the result of rapid change of information technologies. | 4 |
3) | Be aware of the importance of Information Systems' stratagic position in the firm and its role in the creation of new business strategies. | 4 |
4) | To be able to explain the ideas and suggestions that is related to the field of Information Systems as in writing and orally. | 4 |
5) | ability to carry out an independent study on the subjects requiring expertise in the field of Information Systems. | 5 |
Individual study and homework | |
Lesson | |
Group study and homework | |
Homework | |
Problem Solving |
Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
Homework | |
Application | |
Individual Project | |
Group project | |
Case study presentation |
Semester Requirements | Number of Activities | Level of Contribution |
Attendance | 42 | % 5 |
Quizzes | 2 | % 10 |
Presentation | 1 | % 10 |
Midterms | 1 | % 25 |
Final | 1 | % 50 |
total | % 100 | |
PERCENTAGE OF SEMESTER WORK | % 50 | |
PERCENTAGE OF FINAL WORK | % 50 | |
total | % 100 |
Activities | Number of Activities | Duration (Hours) | Workload |
Course Hours | 14 | 3 | 42 |
Laboratory | 12 | 2 | 24 |
Application | 14 | 3 | 42 |
Study Hours Out of Class | 5 | 2 | 10 |
Presentations / Seminar | 2 | 5 | 10 |
Homework Assignments | 5 | 2 | 10 |
Quizzes | 6 | 1 | 6 |
Midterms | 1 | 3 | 3 |
Final | 1 | 3 | 3 |
Total Workload | 150 |