Skip to content

README.md

Latest commit

 

History

History
48 lines (40 loc) · 6.08 KB

README.md

File metadata and controls

48 lines (40 loc) · 6.08 KB

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