KTU DBMS LAB CSL 333 BTech S5 - Dr Binu V P

 About Me

About the course

Syllabus and Experiments

****************************************

Introduction to RDBMS

Working with MySQL

ER Diagrams-MySQL Workbench

Introduction to SQL

Data types in MySQL

Built-in Functions MySQL

Aggregate Functions

Enforcing rules using constraints

MySQL -Lab Exercise

******************************************

Joining tables

Order by, group by and having clause

Nested Queries

MySQL -Lab Exercise

*******************************************

Insert Data from a CSV file

Set Operations

Queries using temporary tables

TCL commands in MySQL

DCL commands in MySQL

Views and Assertions

Library Database- Lab Exercise

*********************************************

PL/SQL and Stored Procedures

IF statement in PL/SQL

CASE statement in PL/SQL

Loops in PL/SQL

Procedures in PL/SQL

Functions in PL/SQL

Triggers in PL/SQL

Cursors in PL/SQL

Packages in PL/SQL

Exception Handling in PL/SQL

Backing up and Restoring Databases

Query Analysis using Query Plan

********************************************

Introduction to NoSQL Databases

Introduction to MongoDB and CURD operations

Comments

Post a Comment

Popular posts from this blog

PL/SQL and Stored Procedures

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is not used in MySQL; instead, MySQL uses its own procedural language called MySQL stored procedures. PL/SQL (Oracle): PL/SQL is a procedural language that has SQL statements with procedural constructs like loops, conditions, and exceptions. It allows you to write code to interact with Oracle databases more effectively. Features of PL/SQL: Tight Integration with SQL: PL/SQL supports SQL data types and allows SQL statements to be embedded within procedural code. Error Handling: PL/SQL has a robust exception handling mechanism to catch and handle runtime errors. Blocks Structure: PL/SQL code is divided into blocks (anonymous blocks, procedures, functions, packages, triggers). Control Structures: Supports traditional programming constructs like loops (FOR, WHILE), conditionals (IF, CASE), and others. Stored Procedures and Functions: You...
Read more

ER Diagrams

Learn about ER diagrams Design a normalized database schema for the following requirement. The requirement: A library wants to maintain the record of books, members, book issue, book return, and fines collected for late returns, in a database. The database can be loaded with book information. Students can register with the library to be a member. Books can be issued to students with a valid library membership. A student can keep an issued book with him/her for a maximum period of two weeks from the date of issue, beyond which a fine will be charged. Fine is calculated based on the delay in days of return. For 0-7 days: Rs 10, For 7 – 30 days: Rs 100, and for days above 30 days: Rs 10 will be charged per day. Sample Database Design BOOK (Book_Id, Title, Language_Id, MRP, Publisher_Id, Published_Date, Volume, Status) //Language_Id, Publisher_Id are FK (Foreign Key) AUTHOR(Author_Id, Name, Email, Phone_Number, Status) BOOK_AUTHOR(Book_Id, Author_Id) // many-to-many relationship, both col...
Read more