SQL Important Notes
A- Quick Revision SQL Stands for: Structured Query Language SQL is a type of: Relational Database Management System A type of database in which data is stored in the format…
MySQL Functions
MySQL Functions Functions are used to perorm some specific task. Every functions has a particular pre-defined tasks. functions are categorized into two parts. 1. Single Row Functions These functions operates…
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…
Basic SQL Commands
1. CREATE DATABASE It is used to create a new database. Syntax: CREATE DATABASE database_name; Example: CREATE DATABASE school; 2. USE It is used to select a database before performing…
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…
Types of Database Models
Here are the examples of different types of DBMS. 1. Hierarchical DBMS (Tree Structure) Structure: Data stored in a tree-like structure (Parent → Child relationship). Each child has only one…
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.…