| Lesson Code | Course Name | Class | Credit | Lesson Time | Weekly Lesson Hours (Theoretical) | Weekly Lesson Hours (Practice) | Weekly Class Hours (Laboratory) |
|---|---|---|---|---|---|---|---|
| DKB 3210 | Database Management | Үшінші курс | 5 | 150 | 1 | 2 | 2 |
The purpose of this course is to train students on SQL Server Administration issues: from the main tasks of the administrator to aspects of database reservation and recovery. This course is devoted to the consideration of various aspects of SQL Server Administration. It provides detailed information about all the key issues necessary for the successful implementation of SQL Server administration tasks. All the main tasks of the administrator were considered and instructions were given for their implementation.
---
Algorithms and data structures, database theory
Narrative, exchange of views, discussion, problem methods.
| 1 | Explains to students the use of methods for developing databases and protection systems. |
| 2 | Designs and develops databases, information management systems. |
| 3 | Summarizes knowledge about the features of teaching technologies and ways when planning and conducting classes. |
| 4 | Knows the features of the development of database application areas. |
| 5 | Implements methods for creating databases , forms concepts and skills. |
| 6 | Uses methods and means that can determine the methods of processing, transmitting, storing databases in an information system. |
| Haftalık Konu | Evaluation Method | |
|---|---|---|
| 1 | DB development and management. | |
| 2 | Modern circuit design tools. | |
| 3 | Database Administration database. | |
| 4 | Technologies for data transmission and sharing in computer networks. | |
| 5 | SQL and its toolkit. | |
| 6 | Preparing systems for SQL Server installation. | |
| 7 | Installing and configuring SQL Server. | |
| 8 | Import and export data. | |
| 9 | Automation of SQL Management. | |
| 10 | Performing SQL Server monitoring using notes and alerts. | |
| 11 | Setting up maintenance for the current database. | |
| 12 | Finding and solving typical administrative errors. | |
| 13 | Approaches to data access control and privilege management. | |
| 14 | SQL Server recovery models. | |
| 15 | Setting up SQL Agent security. |
| PÇ1 | PÇ2 | PÇ3 | PÇ4 | PÇ5 | PÇ6 | PÇ7 | PÇ8 | PÇ9 | PÇ10 | PÇ11 | PÇ12 |
|---|
| Textbook / Material / Recommended Resources | ||
|---|---|---|
| 1 | Заманауи МББЖ. Оқу құралы. Алматы 2020. Л. Б. Диярова, С. К. Байгубенова | |
| 2 | Клиент-серверлік қосымша.Информатика мамандығы студенттеріне арналған оқу құралы [Текст] / Т. А. Шмыгалева, Л. Ш. Черикбаева. - Алматы : [б. и.], 2019 | |
| 3 | Big data analytics.Textbook. Алматы 2021. A. K. Mukasheva, T. F. Umarov, I. A. Zimin | |
| 4 | Database in IS. Алматы 2016. K.S. and etc. Duisebekova | |
| 5 | Медешова А. Б., Аймичева Г.И., Акимова С.М..Работа с базами данных: Учебное методическое пособие. . Уральск:ЗКГУ им. М.Утемисова 2015.-190 с. |