Database Basic SQL Queries Filtering Data Working with Functions Joining Tables Subqueries Modifying Data Advanced Queries Transactions and Locking Indexing and Optimization SQL Best Practices

Hello, Everyone!

I am Prayush Adhikari

Here is what we will learn in this entire journey!

Database

Introduction to Database
Types of Database
Database Management System
SQL vs NoSQL

Basic SQL Queries

SELECT Statement
WHERE Clause
ORDER BY Clause
LIMIT and OFFSET Clauses

Filtering Data

Using Comparison Operators
Using Logical Operators (AND,OR,NOT)
BETWEEN and IN Operators

Working with Functions

Aggregate functions (SUM, AVG, COUNT, etc.)
Scalar functions (UPPER, LOWER, CONCAT, etc.)
Date and time functions

Joining Tables

INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN

Subqueries

Single Row Subquery
Multiple Row Subquery
Correlated Subquery

Modifying Data

INSERT Statement
UPDATE Statement
DELETE Statement

Advanced Queries

CASE Statement
NULL values handling
GROUP BY Clause

Transactions and Locking

Introduction to transactions
ACID properties
Lock types (shared, exclusive, etc.)

Indexing and Optimization

Indexes in SQL
Query Optimization Techniques
Normalization and Denormalization

SQL Best Practices

Qriting efficient queries
Avoiding SQL Injections
Database Security Practices