Category: Database
10 posts
Difference Between DDL and DML in DBMS
In the realm of Database Management Systems (DBMS), SQL (Structured Query Language) is divided into various types of commands, each serving a specific purpose. Two primary types of SQL commands are Da... Read Mores
Prathmesh Yelne
02-Jul-2024 9:13:20
SQL Commands | DDL, DQL, DML, DCL and TCL Commands
SQL (Structured Query Language) is a standard language for managing and manipulating databases. It includes a variety of commands grouped into different categories based on their functionality. In thi... Read Mores
Prathmesh Yelne
01-Jul-2024 10:48:00
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
How to delete a column in SQL ?
To delete a column in SQL we will be using DROP COLUMN method:
ALTER TABLE employees
DROP COLUMN age;
We will start off by giving the keywords ALTER TABLE, then we will give the name of the tab... Read Mores
Prathmesh Yelne
16-Dec-2021 16:39:14
What is a schema in SQL ?
Our database comprises of a lot of different entities such as tables, stored procedures, functions, database owners and so on. To make sense of how all these different entities interact, we would need... Read Mores
Prathmesh Yelne
16-Dec-2021 16:35:48
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
What are the types of SQL Queries ?
We have four types of SQL Queries:
DDL (Data Definition Language): the creation of objects
DML (Data Manipulation Language): manipulation of data
DCL (Data Control Language): assignment ... Read Mores
Prathmesh Yelne
19-Dec-2021 16:56:21
How can I see all tables in SQL?
Different database management systems have different queries to see all the tables.
To see all the tables in MYSQL, we would have to use this query:
show tables;
This is how we can see all t... Read Mores
Prathmesh Yelne
14-Dec-2021 17:13:39
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
What is a Join in SQL ?
In SQL (Structured Query Language), a join in sql is a powerful operation that combines rows from two or more tables based on a related column between them. Joins are essential for querying data from ... Read Mores
Prathmesh Yelne
04-Jul-2024 21:24:28
How to delete a row in SQL ?
We will be using the DELETE query to delete existing rows from the table:
DELETE FROM table_name
WHERE [condition];
We will start off by giving the keywords DELETE FROM, then we will give the n... Read Mores
Prathmesh Yelne
12-Dec-2021 20:59:46
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
How to change a table name in SQL ?
This is the command to change a table name in SQL:
ALTER TABLE table_name
RENAME TO new_table_name;
We will start off by giving the keywords ALTER TABLE, then we will follow it up by giving the... Read Mores
Prathmesh Yelne
12-Dec-2021 20:55:05
How to delete a table in SQL ?
There are two ways to delete a table from sql: DROP and TRUNCATE. The DROP TABLE command is used to completely delete the table from the database. This is the command:
DROP TABLE table_name;
The... Read Mores
Prathmesh Yelne
12-Dec-2021 20:41:30
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago