Lavanya Nandagiri – KTEXPERTS

SQL database (Oracle)

2 weeks ago by Lavanya NandagiriUncategorized

SQL database (Oracle) In the field of Information Technology (IT), databases play a very important role in storing, managing, and retrieving data efficiently. One of the most widely used database systems in the world is the Oracle Database. Oracle is a powerful Relational Database Management… Read More

Data Retrieval language(DRL)

4 weeks ago by Lavanya NandagiriSQL

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

Linux / UNIX PATH, ls Command and File Access Permissions (Security)

2 months ago by Lavanya NandagiriUnix Basics

Linux / UNIX PATH, ls Command and File Access Permissions (Security) Introduction Linux and UNIX are powerful open-source operating systems widely used in servers, cloud platforms, development environments, and academic institutions. To work efficiently in Linux/UNIX, it is very important to understand PATH concepts, the… Read More