| Lesson Code | Course Name | Class | Credit | Lesson Time | Weekly Lesson Hours (Theoretical) | Weekly Lesson Hours (Practice) | Weekly Class Hours (Laboratory) |
|---|---|---|---|---|---|---|---|
| OZh 3208 | Database Theory | Үшінші курс | 5 | 150 | 1 | 2 | 2 |
The purpose of this discipline is to teach the theoretical foundations of databases, principles of creating databases and tools for working with them, data models, relational model, design and creation of databases. Training and formation of skills in the basics of the SQL language and methods of designing relational databases.
Data visualization
Algorithms and data structures
Narrative, exchange of views, discussion, problem methods.
| 1 | Explains the use of methods for developing databases and security systems for students. |
| 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 applications. |
| 5 | Implements database creation methods, 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 | Introduction to databases. | |
| 2 | Access to SQL. Working in SQL SERVER Data Warehouse. | |
| 3 | SQL database in the language of queries- selection of information from SELECT operator. | |
| 4 | Using SQL functions in query creation. | |
| 5 | Grouping data. | |
| 6 | Built-in requests. | |
| 7 | Dataservice definition and datasetsmanipulation commands. | |
| 8 | Procedures to be followed. | |
| 9 | SQL database relational language. SQL standards. Categories of SQL commands. | |
| 10 | SQL queries. SQL query format. Simple SQL queries. | |
| 11 | Complex SQL queries. SQL standard functions, data grouping. | |
| 12 | Subordinate queries in SQL. Subordinate requests and requests. | |
| 13 | Design of database systems. | |
| 14 | Principles of designing data resources. | |
| 15 | Logical design. Algorithm for creating logical models. Physicalproject. |
| 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 с |