database.mp4
- Created a SQL script that generates a full logicaldatabase structure
- Added sequences and triggers with sample test data
- Created SELECT query to select data from tablesusing different operators in WHERE (UPDATE & NVLtest)
- Added:
- group by & having select
- subqueries and perspectives
- Indexes and TCS (Transaction Control System) - Transactions
- INSERT INTO loop
- Implicit cursors
- Explicit cursors
For the purposes of the project, names of tables, data, descriptions, etc. are in Polish
MIT