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

Creating a Database and Table ,executing queries - MySQL Lab Exercise

Create a database school and use it CREATE DATABASE school; USE school; Let's create a simple table schema for a students table in MySQL, followed by a set of queries to interact with the data. id : An integer that uniquely identifies each student (primary key). first_name : The student's first name. last_name : The student's last name. birthdate : The student's birth date. email : The student's email address. gender : The student's gender. enrollment_date : The date when the student was enrolled. CREATE TABLE students (     id INT AUTO_INCREMENT PRIMARY KEY,     first_name VARCHAR(50) NOT NULL,     last_name VARCHAR(50) NOT NULL,     birthdate DATE NOT NULL,     email VARCHAR(100) NOT NULL,     gender ENUM('Male', 'Female', 'Other') NOT NULL,     enrollment_date DATE NOT NULL ); check the schema desc students; Inserting Sample Data INSERT INTO students (first_name, last_name, birthdate, email, gender, enrollment_dat...
Read more

Introduction to RDBMS

An RDBMS (Relational Database Management System) is software that manages a relational database.  Structured Data Storage: An RDBMS organizes data into tables, with rows and columns. Each table represents a specific type of data (e.g., customers, orders). Columns correspond to attributes (e.g., customer name, order date). Rows contain records or tuples (specific data instances). Relationships: RDBMS allows you to establish links between tables using common attributes. For example, a Customer table can be related to an Order table via a shared customer ID. Primary keys (unique identifiers) and foreign keys (references to other tables) create these relationships. Example: Imagine a Customer table with columns like Customer ID, Name, and Address. An Order table might have columns for Order ID, Customer ID, and Order Date. By linking the Customer ID, you can query both tables to create reports or use the data for applications. Key Concepts Tables : Data is organized into tables, which ...
Read more