Database lab works🧾

SQL Server

1. Basics of working in SQL Server Management Studio: Solution
2. Database design. Normalization: Solution
3. T-SQL  relational database language: Solution
4. Multi-table SELECT queries: Solution
5. Using subqueries: Solution
6. Grouping data: Solution
7. Analyzing data and combining query results: Solution
8. Using Views: Solution
9. Basics of T-SQL programming: Solution
10. Creating and applying indexes: Solution
11. Processing query results using cursors: Solution
12. Features of using transactions: Solution
13. Development of stored procedures: Solution
14. Development and use of functions: Solution
15. Using DML triggers: Solution
16. Using XML: Solution

Oracle

1. Getting to know SQL DEVELOPER: Tasks | Solution
2. Preparing the database infrastructure: Tasks | Solution
3. Investigation of the architecture of the Oracle12c DBMS instance (Oracle multitenant): Tasks | Solution
4. Architecture Research - Oracle 12c DBMS Files: Tasks | Solution
5. A study of the server architecture. Random access memory. Processes.: Tasks | Solution
6. Basics of working with SQL PLUS.: Tasks | Solution
7. Oracle12c DBMS objects: Tasks | Solution
8. PL/SQL Basics: Tasks | Solution
9. Cursors: Tasks | Solution
10. Built-in functions: Tasks | Solution
11. Development of procedures and functions: Tasks | Solution
12. Development of procedures and functions: Tasks | Solution
13. Partitioning tables: Tasks | Solution
14. Task Planning Packages: Tasks | Solution