Fundamentals of database application using Microsoft SQL Server DBMS

Authors

Andrii Kopp
National Technical University "Kharkiv Polytechnic Institute", Ukraine
https://orcid.org/0000-0002-3189-5623
Dmytro Orlovskyi
National Technical University "Kharkiv Polytechnic Institute", Ukraine
https://orcid.org/0000-0002-8261-2988

Keywords:

database, database application, database design, DBMS, Microsoft SQL Server, OLTP system

Synopsis

The training manual considers a set of topics related to the methodological foundations and tools for creating and using databases using the Microsoft SQL Server database management system. The basics of the query language, data types, creating a database and its main objects, tools for displaying database objects and all their characteristics are considered. Methods of designing, creating and changing the structure of a database are shown; data manipulation tools, using of views, stored procedures, triggers, transactions are considered. Examples of creating tools for working with databases at the end-user level are considered.

Intended for students studying in the specialties F2 "Software Engineering" and F3 "Computer Science".

Author Biographies

Andrii Kopp, National Technical University "Kharkiv Polytechnic Institute"

Doctor of Philosophy (PhD), Docent, Head of Software Engineering and Management Intelligent Technologies Department

Dmytro Orlovskyi, National Technical University "Kharkiv Polytechnic Institute"

Candidate of Technical Sciences (PhD), Docent, Professor at the Department of Software Engineering and Management Intelligent Technologies Department

Обкладинка

Downloads

PDF (Ukrainian)

Published

February 26, 2026
Copyright (c) 2026 Kopp A., Orlovskyi D., National Technical University "Kharkiv Polytechnic Institute"

License

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Details about this monograph

ISBN-13 (15)

978-617-05-0596-5