| Lesson Code | Course Name | Class | Credit | Lesson Time | Weekly Lesson Hours (Theoretical) | Weekly Lesson Hours (Practice) | Weekly Class Hours (Laboratory) |
|---|---|---|---|---|---|---|---|
| DKA 3205 | Database Administration | Үшінші курс | 5 | 150 | 1 | 2 | 2 |
The purpose of the discipline is the formation of knowledge and skills in the formation of databases, the study and use of various forms of data presentation, the use of language tools for presenting and processing data in databases, as well as the formation of Information Systems (IS) and Information applications based on databases in various DBMS environments.
---
Database systems
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 с |