DBMS-MySQL

   DBMS (Database Management System)      1. Introduction DBMS stands for Database Management System. It is used to store, manage, and retrieve data efficiently. Example: MySQL, Oracle, SQL Server, MS Access, PostgreSQL.      2. Database A database is a collection of related data. It stores data in an organized form (tables). Example: A…

Read More

Components of DBMS

1.Primary Key Uniquely identifies each record in a table. Cannot contain NULL values. Each table can have only one primary key. Example: Roll no., Aadhar no. etc. 2.Candidate Key All attributes that can uniquely identify a record. From these, one key is chosen as the Primary Key. Example: Roll_No, Aadhar_No, and Email can all uniquely…

Read More

Tuple in Python

1. What is a Tuple? A tuple is a collection of items. It stores multiple values in a single variable. Tuples are ordered and immutable (cannot be changed). Example Output: 2. Features of Tuple Ordered Immutable (cannot modify items) Allows duplicate values Can store different data types Faster than lists 3. Creating a Tuple Multiple…

Read More

SQL Joins

 JOIN Joins are used to extract data from one or more tables. There are different types of Joins in MySql. Let’s learn about them. 1. CROSS JOIN CROSS JOIN returns the Cartesian product of two tables. Every row of table1 is combined with every row of table2.              Example-  …

Read More