6.5 Query (কোয়েরি)
Download as pptx, pdf0 likes159 views
The document discusses different types of queries in database management systems including select, parameter, crosstab, and action queries. It also discusses various query languages like QUEL, QBE, and SQL. SQL stands for Structured Query Language and has four main components - DQL for data queries, DDL for data definition, DML for data manipulation, and DCL for data control. Examples of queries in each of the SQL components are provided.
6.5 Query (কোয়েরি)
- 1. অধ্যায় ৬ ডেটাবেজ ম্যাবেজবম্ন্ট সিবেম্
- 2. ৬.৫ ড াবয়সি অধ্যায় ৬ ডেটাবেজ ম্যাবেজবম্ন্ট সিবেম্
- 3. Select query Parameter query Crosstab query Action query Query
- 4. Query Language QUEL – QUEry Language QBE – Query By Example SQL – Structured Query Language
- 5. SQL query Union query Pas-through query Data definition query Sub query
- 6. SQL – Structured Query Language DQL – Data Query Language DDL – Data Definition Language DML – Data Manipulation Language DCL – Data Control Language
- 7. DQL SELECT Name, Address FROM Student WHERE Id=1; DDL CREATE TABLE Student( Id NUMBER(10) NOT NULL, Name VARCHAR(255) NOT NULL, Address VARCHAR (255) );
- 8. DML INSERT INTO Customer (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 ); DELETE FROM Customer WHERE ID = 6; UPDATE Customer SET ADDRESS = ‘Jamalpur' WHERE ID = 6;
- 9. DCL
- 10. THANK YOU
- 11. Mohammad Ali Khan Email: xvirus.bd@gmail.com Facebook: facebook.com/robotbalok Youtube: youtube.com/c/RobotBalok Twitter: twitter.com/Blue_fellings Web: makgr.com