@ayuxsh

Ayush Rajput

@ayuxshJoined February 2024

</ hello world >

About

Nothing here yet.

Available for

Nothing here yet.

Ayush Rajput's blogs

JAVASCRIPT - Basic to Advancerajputayush.hashnode.dev17 posts

Next JS - Fullnextjs4u.hashnode.dev10 posts

Node.JS - Basic to Advanceayynode.hashnode.dev10 posts

React JS - Basic to advancerajputayushreact.hashnode.dev7 posts

SQLsqlwithayush.hashnode.dev6 posts

Articles Comments

Recently published

ARAyush Rajputsqlwithayush.hashnode.dev5d ago · 6 min read

6. Subqueries | View | Indexes | Performence tips

A subquery (also called a nested query or inner query) is a query written inside another SQL query.The subquery runs first it gives value then outer query use that value Subquery in WHERE - (add some

ARAyush Rajputsqlwithayush.hashnode.devJul 6 · 8 min read

5. Aggregation functions | Group By | Having

Aggregation FunctionsFunctions that perform calculations on a set of rows and return a single value. Function Description Example COUNT() Counts rows SELECT COUNT(*) FROM employees; SUM() Calc

ARAyush Rajputsqlwithayush.hashnode.devJun 29 · 6 min read

4. Joins and Complex Relationships

In SQL, a JOIN is used to combine rows from two or more tables based on a related column.Example in Image: -- CREATE TABLE classes ( -- id INT PRIMARY KEY, -- class_name VARCHAR(50), -- teacher VARC

ARAyush Rajputsqlwithayush.hashnode.devJun 19 · 6 min read

3. Data Types in SQL | DDL | DML

Boolean -> BOOLEAN/BOOL -> True/False valuesBinary -> BINARY(n) , VARBINARY(n) , BLOB (for files )Speacil -> ENUM-> fixed length of list DDL ( DATA define language)A category of SQL commands used to d

ARAyush Rajputsqlwithayush.hashnode.devJun 14 · 6 min read

2.BASIC SQL COMMANDS

SELECT & FROMSELECT : Tells which col you want.FROM: Tell from which Table you want to fetch. //In Postgres default schema is public //In We have databse inside it we have schema inside it we have ta

Ayush Rajput

About

Available for

Ayush Rajput's blogs

Recently published

6. Subqueries | View | Indexes | Performence tips

5. Aggregation functions | Group By | Having

4. Joins and Complex Relationships

3. Data Types in SQL | DDL | DML

2.BASIC SQL COMMANDS

Search Hashnode

Ayush Rajput

About

Available for

Ayush Rajput's blogs

Recently published

6. Subqueries | View | Indexes | Performence tips

5. Aggregation functions | Group By | Having

4. Joins and Complex Relationships

3. Data Types in SQL | DDL | DML

2.BASIC SQL COMMANDS