Information Systems and Technologies | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
Course Code: | BST210 | ||||||||
Course Name: | Database Management | ||||||||
Course Semester: | Spring | ||||||||
Course Credits: |
|
||||||||
Language of instruction: | TR | ||||||||
Course Requisites: | |||||||||
Does the Course Require Work Experience?: | No | ||||||||
Type of course: | Compulsory | ||||||||
Course Level: |
|
||||||||
Mode of Delivery: | Face to face | ||||||||
Course Coordinator : | Öğr.Gör. ENDER ŞAHİNASLAN | ||||||||
Course Lecturer(s): |
Öğr.Gör. ENDER ŞAHİNASLAN Öğr.Gör. B.Öğretim Elemanı Dr.Öğr.Üyesi NURŞEN TOPÇUBAŞI |
||||||||
Course Assistants: |
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. |
The students who have succeeded in this course;
|
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 |
Course Notes / Textbooks: | MSSQL Uygulamalarıyla Veritabanı - Kurtuluş Beylan |
References: | Microsoft Docs - SQL Web Sayfaları - Microsoft |
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' 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. | 3 |
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. | 1 |
5) | ability to carry out an independent study on the subjects requiring expertise in the field of Information Systems. | 3 |
Individual study and homework | |
Lab | |
Homework | |
Problem Solving | |
Project preparation | |
Application (Modelling, Design, Model, Simulation, Experiment etc.) |
Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
Homework | |
Application |
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 |
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 |