Category: SQL
34 posts
What is PL/SQL ?
PL SQL stands for Procedural language constructs for Structured Query Language. PL SQL was introduced by Oracle to overcome the limitations of plain sql. So, pl sql adds in procedural language approac... Read Mores
Prathmesh Yelne
14-Dec-2021 17:09:39
How do I view tables in SQL ?
To view tables in SQL, all you need to do is give this command:
Show tables;
... Read Mores
Prathmesh Yelne
14-Dec-2021 17:07:50
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
What is Primary Key in SQL ?
Introduction :
In the world of databases, a primary key is a fundamental concept that plays a crucial role in maintaining data integrity and ensuring efficient data retrieval. It is a concept th... Read Mores
Prathmesh Yelne
24-Jul-2023 17:44:20
How to insert date in SQL ?
If the RDBMS is MYSQL, this is how we can insert date:
INSERT INTO tablename (col_name, col_date) VALUES (‘DATE: Manual Date’, ‘2020-9-10’);
... Read Mores
Prathmesh Yelne
14-Dec-2021 17:00:30
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
What is SQL server ?
To understand what exactly is SQL Server, we need to understand what is DBMS and RDBMS. DBMS stands for Database Management System. When we have a huge database with us, we would need a proper manage... Read Mores
Prathmesh Yelne
14-Dec-2021 16:57:09
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
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
What is Normalization in SQL ?
Normalization is used to decompose a larger, complex table into simple and smaller ones. This helps us in removing all the redundant data.
Generally, in a table, we will have a lot of redundant inf... Read Mores
Prathmesh Yelne
14-Dec-2021 16:47:00
How to create a database in SQL?
A database is a repository in sql, which can comprise of multiple tables.
This will be the command to create a database in sql:
CREATE DATABASE database_name.
... Read Mores
Prathmesh Yelne
14-Dec-2021 16:43:51
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago
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
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
September 11, 2020
2.2 K Views
GCP Cloud Engineer
21 hours ago