KTU S5 DBMS Lab
- Chitty Management DB
- Laboratory Management DB
- Resort Management DB
- Thesis Management DB
- PL/SQL - Narcissism Checking
- PL/SQL - Palindrome checking of strings
- PL/SQL - Printing Fibonacci numbers
- PL/SQL - Forming tables of Prime and Composite numbers
- PL/SQL - Forming tables of perfect squares and cubes
- PL/SQL - Pension computation using cursors
- PL/SQL - Trigger for printing number of tuples
- PL/SQL - Trigger for salary increment computation
- PL/SQL - Trigger for SGPA and CGPA computation
SQL (Structured Query Language) is a standardized programming language used to manage and manipulate relational databases. It enables users to query, insert, update, and delete data, as well as create and modify database structures (like tables and views). SQL is widely used in data management for tasks such as retrieving data for analysis, managing user permissions, and ensuring data integrity within relational databases like MySQL, PostgreSQL, Oracle, and SQL Server.
PL/SQL (Procedural Language/Structured Query Language) is Oracle's procedural extension for SQL, allowing for structured and complex programming within the database. It is commonly used in Oracle databases for writing stored procedures, functions, and triggers, enabling developers to execute SQL statements in a procedural format. PL/SQL supports variables, loops, conditions, and error handling, which are essential for building robust and efficient database applications.