Posts

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 ***********************
Post a Comment
Read more

KTU DBMS LAB CSL 333 Syllabus and Experiments

 Syllabus 1. Design a database schema for an application with ER diagram from a problem description **. 2. Creation, modification, configuration, and deletion of databases using UI and SQL Commands **. 3. Creation of database schema - DDL (create tables, set constraints, enforce relationships, create indices, delete and modify tables). Export ER diagram from the database and verify relationships** (with the ER diagram designed in step 1). 4. Database initialization - Data insert, Data import to a database (bulk import using UI and SQL Commands)**. 5. Practice SQL commands for DML (insertion, updating, altering, deletion of data, and viewing/querying records based on condition in databases)**. 6. Implementation of built-in functions in RDBMS**. 7. Implementation of various aggregate functions in SQL**. 8. Implementation of Order By, Group By & Having clause **. 9. Implementation of set operators nested queries, and join queries **. 10. Implementation of queries using temp tables. 11
Post a Comment
Read more

About the course DBMS LAB

Preamble: The Database Management Systems course is intended to impart the elementary concepts of a database management system to students and equip them to design and implement a database application based on those concepts. This course helps the learners to get practical exposure on database creation, SQL queries creation, transaction processing and NoSQL & MongoDB based operations. The course enables the students to create, manage and administer the databases, develop necessary tools for the design and development of the databases, and to understand emerging technologies to handle Big Data. Prerequisite: A sound knowledge of the basics of relational DBMS. Course Outcomes: After the completion of the course the student will be able to CO1 Design database schema for a given real world problem-domain using standard design and modeling approaches. (Cognitive Knowledge Level: Apply) CO2 Construct queries using SQL for database creation, interaction, modification, and updation. (Cog
Post a Comment
Read more

Working with MySQL

MySQL is an open-source relational database management system (RDBMS) that uses Structured Query Language (SQL) to manage and manipulate databases. It is widely used for web applications and is a central component of the LAMP stack (Linux, Apache, MySQL, PHP/Python/Perl). Key Features of MySQLOpen Source:  MySQL is free to use under the GNU General Public License (GPL). Cross-Platform: It can be installed on various operating systems including Linux, Windows, and macOS. High Performance: MySQL is designed for high-speed transactions and supports a large number of concurrent users. Scalability: Suitable for both small applications and large-scale enterprise solutions. Security: Provides robust security features to protect data. Replication: Supports database replication to increase availability and performance. Installing MySQL On Linux sudo apt-get update  sudo apt-get install mysql-server On Windows Download the MySQL installer from the official website and follow the installation wi
Post a Comment
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 cons
Post a Comment
Read more

Built in Functions -MySQL

MySQL built-in functions are pre-defined functions provided by MySQL to perform various operations on data. These functions are categorized into different types based on their functionality: String Functions CONCAT() : Concatenates two or more strings. SUBSTRING() : Extracts a substring from a string. LENGTH() : Returns the length of a string. UPPER() : Converts a string to uppercase. LOWER() : Converts a string to lowercase. TRIM() : Removes leading and trailing spaces from a string. REPLACE() : Replaces occurrences of a specified string with another string. Numeric Functions ABS() : Returns the absolute value of a number. CEIL()  or  CEILING() : Rounds a number up to the nearest integer. FLOOR() : Rounds a number down to the nearest integer. ROUND() : Rounds a number to a specified number of decimal places. MOD() : Returns the remainder of a division operation. POWER() : Raises a number to the power of another number. Date and Time Functions CURDATE() : Returns the current date. CURT
Post a Comment
Read more

Introduction to SQL

SQL (Structured Query Language) is a standard programming language specifically designed for managing and manipulating relational databases. It is used to perform tasks such as querying data, updating records, inserting data, and deleting records. Here are some key points about SQL: Data Querying : SQL allows users to query data from a database using the SELECT statement, which can retrieve specific data based on given criteria. Data Manipulation : SQL provides commands for inserting ( INSERT ) , updating ( UPDATE ) , and deleting ( DELETE ) data within database tables. Data Definition : SQL includes commands for defining the structure of databases and tables, such as CREATE TABLE , ALTER TABLE , and DROP TABLE . Data Control : SQL has features for controlling access to data within a database, including granting and revoking permissions using GRANT and REVOKE . SQL is widely used in various database systems, including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, and Oracle Databa
Post a Comment
Read more