ISTANBUL OKAN UNIVERSITY INFORMATION PACKAGE / COURSE CATALOGUE
| Information System | |||||
| Master | TR-NQF-HE: Level 7 | QF-EHEA: Second Cycle | EQF-LLL: Level 7 | ||
General course introduction information
| Course Code: | BIS508 | ||||||||
| Course Name: | Database Management | ||||||||
| Course Semester: | Spring | ||||||||
| Course Credits: |
|
||||||||
| Language of instruction: | |||||||||
| 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): |
Öğr.Gör. ENDER ŞAHİNASLAN |
||||||||
| Course Assistants: |
Course Objective and Content
| Course Objectives: | The aim of this course is to teach the students the concepts of database, tables and records; to set up database server and manage database server, to gain the ability to use Transact-SQL commands. |
| Course Content: | Structure of Microsoft SQL Server. The concept of database; relational database; data storage models; database components; database management systems; database products and versions; Microsoft SQL Server installation; SQL Server Management Studio; SQL Server database architecture; the standard SQL server databases; database creation and deletion; DDL; collation; Recovery-Transact Log; compatibility; set the options for the database; data types; data-entry; and delete tables; database backup and restore; queries; the SELECT command; INSERT; DELETE; and UPDATE commands; data transfer operations; join tables; constraints; the concept of index; constraints; stored procedures; triggers; SQL Server Agent. |
Learning Outcomes
The students who have succeeded in this course;
|
||||||||||||||||||||||||||||||||||
Lesson Plan
| Week | Subject | Related Preparation |
| 1) | Database concept, relational database, data storage models | Projection, Computer |
| 2) | Database components (relational database engine, system integration -SQL Server Integration Services, notification services-Notification Services, Reporting Services-Reporting Services, etc.), database management systems (client-server architecture), database products and versions, compatibility with operating systems | Projection, Computer, Resource Books |
| 3) | SQL server database setup (pre-installation preparations, sample naming -Instance Name, service account determination, etc.), SQL server management studio, SQL server database architecture, SQL server standard databases | Projection, Computer, Resource Books |
| 4) | Create database (create database with management studio, create database with Transact SQL), Collation, Recovery Log, Compatibility etc. set database options, delete database | Projection, Computer, Resource Books |
| 5) | Tables (create, add columns, change column properties, delete columns, delete tables, perform objects with T-SQL expression), data types, enter and delete data in tables (with management studio). Back up the database and return (full, transaction log). | Projection, Computer, Source Books |
| 6) | Table operations with Transact SQL: ALTER commands (ALTER TABLE, ALTER COLUMN), SELECT command (WHERE, ORDER BY, GROUP BY) | Projection, Computer, Resource Books |
| 7) | Transact SQL with table operations: INSERT command, DELETE command, UPDATE command | Projection, Computer, Resource Books |
| 8) | QUIZ | |
| 9) | Data transfer operations (data import -Import- and export-export data), Table Transactions with Transact SQL (Connecting Tables) SQLJOIN Rules (INNER, LEFT OUTER, RIGHT OUTER) | Projection, Computer, Source Books |
| 10) | Restrictions (Primary Key), Index concept and index in SQL tables (Clustered Index, Non-clusterd index), Kısıtlamalar (Unique, Foreign Key, Check). | Projection, Computer, Source Books |
| 11) | SQLCMD command prompt, BCP command prompt, Stored Procedure Value Field and Asset Procedures | Projection, Computer, Source Books |
| 12) | Triggers: INSERT Trigger, DELETE Trigger, UPDATE Trigger | Projection, Computer, Source Books |
| 13) | SQL Server Agent, Create and manage scheduled tasks, Create alerts | Projection, Computer, Resource Books |
| 14) | Database Security | Projection, Computer, Source Books |
Sources
| Course Notes / Textbooks: | MSSQL Uygulamalarıyla Veritabanı - Kurtuluş Beylan |
| References: | Microsoft Docs - SQL Web Sayfaları - Microsoft |
Course-Program Learning Outcome Relationship
| Learning Outcomes | 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' strategic position in the firm and its role in the creation of new business strategies. | ||||
| 4) To be able to take responsibilities in the information projects as project manager or participant in accordance with the project objectives. | ||||
| 5) Ability to carry out an independent study on the subjects requiring expertise in the field of Information Systems. | ||||
Course - Learning Outcome Relationship
| 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' strategic position in the firm and its role in the creation of new business strategies. | 4 |
| 4) | To be able to take responsibilities in the information projects as project manager or participant in accordance with the project objectives. | 4 |
| 5) | Ability to carry out an independent study on the subjects requiring expertise in the field of Information Systems. | 5 |
Learning Activity and Teaching Methods
| Individual study and homework | |
| Lab | |
| Homework | |
| Problem Solving | |
| Project preparation | |
| Application (Modelling, Design, Model, Simulation, Experiment etc.) |
Assessment & Grading Methods and Criteria
| Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
| Homework | |
| Application |
Assessment & Grading
| Semester Requirements | Number of Activities | Level of Contribution |
| Attendance | 42 | % 5 |
| Quizzes | 4 | % 15 |
| Midterms | 1 | % 30 |
| Final | 1 | % 50 |
| total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 50 | |
| PERCENTAGE OF FINAL WORK | % 50 | |
| total | % 100 | |
Workload and ECTS Credit Grading
| Activities | Number of Activities | Duration (Hours) | Workload |
| Course Hours | 14 | 3 | 42 |
| Laboratory | 12 | 2 | 24 |
| Application | 12 | 2 | 24 |
| Study Hours Out of Class | 13 | 2 | 26 |
| Homework Assignments | 10 | 2 | 20 |
| Quizzes | 8 | 1 | 8 |
| Midterms | 1 | 2 | 2 |
| Final | 1 | 3 | 3 |
| Total Workload | 149 | ||