| Lesson Code | Course Name | Class | Credit | Lesson Time | Weekly Lesson Hours (Theoretical) | Weekly Lesson Hours (Practice) | Weekly Class Hours (Laboratory) |
|---|---|---|---|---|---|---|---|
| DJ3207 | Database Systems | Екінші курс | 5 | 150 | 1 | 2 | 2 |
The purpose of the discipline is the formation of students' professional competencies associated with the use of classical and modern approaches to data modeling, data management methods and their implementation in software products. The development of skills based on theoretical knowledge gained, which allows analyzing, modeling and designing databases and developing software applications that use databases. To instill in students the skills of research work, which involves independent study of the specific tools and tools necessary to solve a particular data management problem.The purpose of the discipline is the formation of students' professional competencies associated with the use of classical and modern approaches to data modeling, data management methods and their implementation in software products. The development of skills based on theoretical knowledge gained, which allows analyzing, modeling and designing databases and developing software applications that use databases. To instill in students the skills of research work, which involves independent study of the specific tools and tools necessary to solve a particular data management problem.
Web programming
Algorithms and Programming
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 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 |