Database Design and Administration in the MS SQL Server Environment
About the module
In this module, we focus on the SQL Server database. It is currently one of the most popular and technologically advanced platforms for data management. You will get acquainted with advanced issues related to the design of professional databases, with particular emphasis on their performance and security. You will also be able to write advanced and, above all, efficient queries on large collections. You will also immerse yourself in programming (T-SQL), which will allow you to write advanced procedures and functions. Finally, you’ll get a solid dose of knowledge about database administration.
The module is recommended for future professionals who want to deal with database design, operation or administration professionally.
If you are a beginner, you should consider the Database Design module first.
Your education path
In order to obtain the engineer degree you need at least 210 ECTS.
In your first year you take obligatory courses and later, starting with the third semester (that is your second year), you choose what you want to study. How? It is easy. Choose at least one module (formerly called a specialty) which is most interesting for you and then continue along the chosen path till the end of your studies. If you wish, you can take next modules or individual subjects- including those from other fields of study. All modules you complete will be visible on your diploma.
141 ECTSObligatory courses
Datbase Design and Administration in the MS SQL Server Environment
49 ECTSOther modules or elective courses
Courses included in the module:
You will learn to write complex queries in T-SQL. You will master the instructions for data manipulation (INSERT, UPDATE, DELETE). You will learn to create views, manage errors and NULL values.
You will learn the principles of effective database design and operation. You will learn to create a database model tailored to your business needs, program data flow support, handle exceptions and errors, and manage performance.
You will learn how to manage data stored in databases and their users. You will learn how to backup and restore a database after a failure. You will get to know administrator tools for monitoring the database system and affecting its performance. Practical classes will be held using MS SQL Server.
You will learn how to use Azure cloud databases. You will learn how to create servers, their instances and implement databases on Azure virtual machines. You will learn to manage database security in the cloud, optimize your database system and manage SQL Server instances.
Your education pathWhat options do you have next?
You can choose the recommended module.
You can choose a module from the list those that, in our opinion, will suit you best.
You can choose other modules, including those from the other study programs.
You can choose particular additional subjects, one module is enough to get a degree.
Prof. Dariusz Put
A teacher and practitioner specializing in databases, with many years of experience in using MS Access in teaching and for implementing databases. Author of several textbooks on databases, including one in English, plenty of teaching materials as well as several complete projects in which MS Access was used as a database system.
Module coordinator recommendation
The module is dedicated to people who want to specialize in Microsoft database technologies. You will learn the T-SQL language in detail, learn how to implement a database, manage data and administer the SQL Server system. You will learn how to use Azure technology to collect and store data in the cloud. Knowledge and skills acquired in class will be an excellent complement to the engineer’s diploma and a pass to an interesting and well-paid job.