Sql Topics & Practice Problems

CRUD Operations

Create Table
Insert Rows
SELECT Statement
UPDATE Rows
DELETE Rows

Table Operations

ALTER TABLE
PRAGMA TABLE_INFO
DROP TABLE

Operators

Comparision Operators
String Operators
Logical Operators
IN and BETWEEN Operators

SQL Query Operations

DISTINCT
ORDER BY
Pagination

Aggregations and Group By

Aggregation Functions
Group BY & Having

SQL Expressions

Arithmetic Operations
String Expressions
CASE Clause

SQL Functions

String Functions
Date Functions
CAST Function