The tutorial discusses techniques that allow you to perform a number of practical tasks for working with databases in the environment of the popular Microsoft SQL Server DBMS. The manual can be recommended as a methodological guide in seminars and in preparation for passing tests and exams in courses related to databases.