article – KTEXPERTS

Data Retrieval language(DRL)

Data Retrieval language(DRL) Data Retrieval Language (DRL) is a part of SQL used to retrieve (fetch) data from a database without modifying it. Main Command: SELECT – used to get data from one or more tables. Examples:

SELECT * FROM students;
→ Retrieves all records from the students table.

SELECT name, marks FROM students WHERE marks > 60;
→ Retrieves names and marks of students who scored more than 60.

SELECT * FROM students;

→ Retrieves all records from the students table.

SELECT name, marks FROM students WHERE marks > 60;

→ Retrieves names and marks of students who scored more than 60.

Purpose: ● To view data ● To… Read More

Data Definition Language (DDL)

7 hours ago by Kishor KumarSQL

Data Definition Language (DDL) Introduction Structured Query Language (SQL) is the standard language used for interacting with relational databases. SQL is divided into different categories based on the type of operations performed on the database. Among these categories, Data Definition Language (DDL) plays a foundational… Read More

Basic MongoDB Commands Operations

3 years ago by TejaMongoDB

Basic MongoDB Commands Operations 👉👉👉Please check the below video 1 – To shows all the databases Atlas atlas-dsrabt-shard-0 [primary] myFirstDatabase> show dbs 2 – To use the database called sample_airbnb Atlas atlas-dsrabt-shard-0 [primary] myFirstDatabase> use sample_airbnb 3 – To show all the collections in… Read More

Introduction to MongoDB

3 years ago by TejaMongoDB

Introduction to MongoDB MongoDB is an open and free NoSQL database management system. It is a document oriented database, i.e. it will store all the data in semi-structured Binary JSON like documents. Features of MongoDB Document Object Data Model: MongoDB stores the data as Binary… Read More

Pluggable database save state

3 years ago by Vinod SiramOracle DB Admin

Pluggable database save state Automate Pluggable DB opening during Container instance startup PDB Saved State is a feature in 12.1.0.2 for saving the OPEN state of all PDBS when CDB is restarted. This is for preserving the state of a Pluggable database proir to CDB… Read More