Database Management Systems DBMS Lab PCCSL408 Semester 4 KTU CS 2024 Scheme- Dr Binu V P

 About Me Scheme and Syllabus Experiments Introduction to RDBMS Working with MySQL Design a Database schema for an application ER Diagrams - MySQL Workbench Introduction to SQL Data Types in MySQL Built-in Functions-MySQL Aggregate Functions Enforcing Rules using Constraints MySQL Lab Exercise Importing Data from a csv file into MySQL Order by, group by and having clause MySQL Lab Exercise Set Operations Nested Queries Subqueries in FROM and SELECT clause Join Queries Example Join Queries Temporary and Intermediate Tables in SQL MySQL Lab Exercise - Handling Multiple Tables SQL TCL commands - COMMIT, ROLLBACK , SAVEPOINT SQL DCL Commands - GRANT, REVOKE Views Assertions Stored Procedures in MySQL Triggers in MySQL Functions in MySQL Cursors in MySQL Build a web application based on sample database - use Php-MySQL SQL Vs NoSQL Cassandra official site Apache Cassandra- Introduction and Basic CQL commands Cassandra- advanced CURD operations Work with MongoDB atlas for free MongoDB and...

  DBMS LAB (Commonto CS/CD/CR/CA/AD/AI/CB/CN/CC/CU/CI/CG)   Course Code PCCSL408 CIE Marks 50 Teaching Hours/Week (L: T:P: R) 0:0:3:0 ESE Marks 50 Credits 2 Exam Hours 2Hrs.30 Min. Prerequisites(if any) None Course  Type Lab Course  Objectives: 1.        To equip students with comprehensive skills in SQL,PL/SQL, and NoSQL databases.   2.        To enable the learner to proficiently design,implement,and manage relational and non- relational databases to meet diverse data management needs   Expt. No. Experiments 1 Design a database schema for an application with ERdiagram from ap roblem  description.   2 Creation of database schema-DDL(createtables...