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:

Purpose: ● To view data ● To… Read More

Data Definition Language (DDL)

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

Introduction to SQL

Introduction to SQL What is SQL? SQL (Structured Query Language) is a database computer language used to communicate with and retrieve data from relational databases. It allows users to store, manipulate, update, and retrieve data efficiently. SQL is widely used with popular database systems such… Read More

SQL Joins

Dear Readers, In this article, we will see the SQL Joins. Joins A join is a query that combines rows from two or more tables Join Conditions Most join queries contain WHERE clause conditions that compare two columns, each from a different table. Such a… Read More

ORACLE ANALYTICAL FUNCTIONS – 1

ORACLE ANALYTICAL FUNCTIONS – 1 In this article, we will see how Analytical functions works in Oracle. Analytical Function  : Analytical function is used to compute the aggregate values and perform aggregate operations it returns more than value in each group In sql we have… Read More

BASIC SQL CLASS (Vimeo Links).

BASIC SQL CLASS (Vimeo Links). S.no Video Vimeo Link Password Topic Description 1 Class-1 https://vimeo.com/285140850 sql Introduction to DBMS. What is SQL? History of SQL? Features of SQL? What are Codd Rules? 2 Class-2 https://vimeo.com/285330531 sql Oracle installation on windows platform. Explanation about codd rules.… Read More