This database is created using Transact-SQL.
This work presents:
- DDL, DML and TCL operations
- Triggers
- Functions
- Stored procedures
- Views
- WITH keyword
- Aggregate, string functions
- Functions for working with dates
- Window functions
- Basic query commands: select, [left] join, where, group by, order by, having
- Basic comparison operations (like, in, '=', '<', '<=', etc)
- Working with sets (except)
- Nested subqueries
Worked with:
- mostly DBeaver
- sometimes SSMS
Ryzhova Anastasia