Database Management System

About This Course

This course is dedicated to introducing students to database systems in Information Systems comprehensively and expand their knowledge on working with PGAdmin developers.

Course objectives include:

To explain database management software to develop data-intensive applications;

To introduce PGAdmin;

To explain PGAdmin development environments;

To demonstrate hands-on practice in order to reinforce the fundamental concept;

To provide practice on querying on PGADmin database;

To describe Built-in SQL functions.

Skills and competences:

Describe how database management systems can be used during software maintenance as well as describing major issues involved.

Analyze the runtime performance of various approaches and commands in terms of the size of their requests, averages, best, and worst cases.

By the end of this course the students will be able:

To list data structures and operators in SQL.

To create diagrams and data models for projects.

To design and develop normalization for tables.

To solve practical tasks on SQL.

To compare and contrast the different ways of solving problems.

To modify and rewrite the created program using the analysis.

To explain the constituted program documentation.

Course Staff

Assel Smaiyl

Assel Smaiyl is a deputy Director of the Department of Computer Engineering at Astana IT University, Nur-Sultan, Kazakhstan. She defended her PhD dissertation in Computer Science on the topic “Models and methods of intellectual information and training system”. She has teaching experience of 8 years. She has presented several research papers in international journals. Her scientific interest is in the field of data science and smart technologies in education.

Frequently Asked Questions

What web browser should I use?

The Open edX platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.

See our list of supported browsers for the most up-to-date information.

Question #2

Your answer would be displayed here.

AITU: DB001 Database Management System