| Lesson Code | Course Name | Class | Credit | Lesson Time | Weekly Lesson Hours (Theoretical) | Weekly Lesson Hours (Practice) | Weekly Class Hours (Laboratory) |
|---|---|---|---|---|---|---|---|
| BSV 3207 | Database and Information Systems | Екінші курс | 5 | 150 | 1 | 2 | 2 |
The main goal of the discipline includes teaching the basics of relational algebra, SQL language, general DBMS devices, database scheme design in solving applied problems, teaching the principles of demand optimization, fault tolerance mechanisms and correct competitive availability.
Business Analytics and Management of IT Projects
Algorithms, Data Structures and Programming
Design method, group work, cloud technology, IT method, developing learning technology.
| 1 | Learns the principles of creating database systems in information systems. |
| 2 | Can learn the basics of database design in information systems. |
| 3 | Learns how to use a modern database management system in information systems. |
| 4 | Learns to design an information model in a specific subject area for information systems. |
| 5 | Master the basic operations applied to data in information systems. |
| 6 | Can design hardware and software complexes for setting up databases. |
| Haftalık Konu | Evaluation Method | |
|---|---|---|
| 1 | Concept of database (DB). Concept of database systems. | |
| 2 | Database management system (DBMS) and its main components. Current DBMS. | |
| 3 | Data types and models. Hierarchical, network, relational, post-relational, multidimensional, object-oriented information models. | |
| 4 | Basic concepts of relational database. Relationships. Relational algebra. | |
| 5 | Linking tables and their main types. Define key fields. | |
| 6 | Relational database design. Design stages. | |
| 7 | Method of normal forms. | |
| 8 | Introduction to SQL. Features, achievements and functions of language. History, standard and use of SQL language | |
| 9 | Defining a data structure | |
| 10 | SQL instructions. Types of data. Constants. Expressions. Variables. SQL language functions | |
| 11 | Create queries to extract data. SELECT, FROM, WHERE, ORDER BY instructions. Consolidation of requests. | |
| 12 | Automation of data management and editing | |
| 13 | Creating a form and using it. | |
| 14 | Preparation of simple (simple) calculations. | |
| 15 | Creating the most complex problems with the help of a master |
| 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 | Ху Вен Цен, Турметов Б.Х., Қоңырбаев Н.Б., Деректер қорын басқару жүйесі: Оқу құралы. - Алматы, 2023. -232 | |
| 2 | А. Ж. Сейкетов, Рахимова Д.Р., Г. А. Мирзахмедов, Алгоритмдер және деректер құрылымдары. -Алматы. 2017. -162б. | |
| 3 | Д. Ж. Ахмед -Заки , З. Х. Юлдашев, Ғ. Ә. Сералин\ Алгоритмдер және деректер құрылымы. - Алматы. 2014. | |
| 4 | Деректер қоры жүйелері. Оқу-әдістемелік құрал. - Алматы: 2012ж. | |
| 5 | Нурпеисова, Ж.С. АЖ-дегі мәліметтер базасы : Оқу құралы. . - Қостанай: А. Байтурсынов атындағы ҚМУ, 2019. - 130 |