| Lesson Code | Course Name | Class | Credit | Lesson Time | Weekly Lesson Hours (Theoretical) | Weekly Lesson Hours (Practice) | Weekly Class Hours (Laboratory) |
|---|---|---|---|---|---|---|---|
| SQLT 3334 | SQL Basics | Үшінші курс | 5 | 150 | 1 | 2 | 2 |
The subject explores the benefits of centralized data management; database management systems. Particular attention is paid to building queries in SQL; types of data connections, stored procedures and functions, as well as data management administration tools.
Business Analytics and Management of IT Projects
Data baseand Information Systems
Group work, pair work, learning and working, lightning questions, brainstorming, creative teaching methods, group project work method, problem composition method.
| 1 | Masters the principles of working with tables in the online database. |
| 2 | Ability to work with database tools and applications. |
| 3 | Can provide technical support and updating of the database. |
| 4 | Can design hardware and software complexes for database installation. |
| 5 | Coordinates studies on database management. |
| Haftalık Konu | Evaluation Method | |
|---|---|---|
| 1 | Relational model. Advantages of SQL | |
| 2 | Using the SQL environment to execute commands on the database server. Introduction to SQL and SQL Developer. | |
| 3 | Creating, modifying and deleting tables in the database | |
| 4 | Add, update and delete rows | |
| 5 | SQL identity declaration. Identifier types in SQL. | |
| 6 | Overview of SQL block types. Output generation from SQL blocks. | |
| 7 | SQL Expressions and Operators Writing executable expressions | |
| 8 | Basic syntax of blocks. commenting the code | |
| 9 | Environment to run PL/SQL code on the database server | |
| 10 | SQL functions. Add and group data | |
| 11 | Select data from multiple table | |
| 12 | Internal requests | |
| 13 | Directories | |
| 14 | Presentation | |
| 15 | Transactions |
| 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 | A'dan Z'ye PHP. SEÇKİN YAYINCILIK, Ankara 2015, Rıza Çelik | |
| 2 | РНР және My SQL-де WEB қосымшаларды құру негіздері. Оқу - әдістемелік құрал. Ә.Баялы. Р.Садыбеков. Алматы 2020 | |
| 3 | РНР және My SQL-де WEB қосымшаларды құру негіздері. Оқу - әдістемелік құрал. Ә.Баялы. Р.Садыбеков. Алматы 2020 | |
| 4 | UNIX желілік бағдарламалау. API желілік сокеттері: 2017. оқулық / Алматы: Дәуір. Р. В. Стивенс, Б. Феннер, Э. М. Рудофф. | |
| 5 | Internet Tehnologies. Оқу құралы. N. P. Saparkhojayev. - Almaty: KazNRTU 2017, - 214 p. - 978-601-228-998-5 |