Home
Docs
Resources
Tools
Contact Us
Typing Test
বাংলা
Toggle Sidebar
Start Here
Computer Basics
20
Office Skills
37
Intro to Programming
20
Artificial Intelligence
24
Cybersecurity
18
Git & GitHub
25
Design
Graphic Design
18
UI/UX Design Principles
32
Photoshop
12
Figma
17
Build the web
HTML
43
CSS
49
JavaScript
34
React
28
Backend & data
PHP
41
SQL
22
Introduction to SQL
Databases & Tables
Data Types & Memory Sizing
DDL — Data Definition Language
DML — Data Manipulation Language
DCL — Data Control Language
TCL — Transaction Control Language
Filtering — WHERE & Operators
Sorting — ORDER BY
Grouping — GROUP BY & HAVING
Joins
Functions — Aggregate, String, Date, Numeric
Window Functions
Subqueries
Common Table Expressions (CTEs)
Beyond the Basics
Data Constraints — FOREIGN KEY, UNIQUE, NOT NULL, CHECK
Self Join and Cross Join
Conditional Expressions — CASE, COALESCE, NULLIF
Transactions — ACID Properties and Isolation Levels
Relational Databases — Concepts and SQL vs. NoSQL
Query Optimization Techniques
WordPress
31
Python
38
Node.js
34
MongoDB
26
Launch & grow
Freelancing & Client Work
29
Hosting & Deployment
40
Digital Marketing
32
SEO
26
Career Skills
34
SQL
22 lessons
1
Introduction to SQL
2
Databases & Tables
3
Data Types & Memory Sizing
4
DDL — Data Definition Language
5
DML — Data Manipulation Language
6
DCL — Data Control Language
7
TCL — Transaction Control Language
8
Filtering — WHERE & Operators
9
Sorting — ORDER BY
10
Grouping — GROUP BY & HAVING
11
Joins
12
Functions — Aggregate, String, Date, Numeric
13
Window Functions
14
Subqueries
15
Common Table Expressions (CTEs)
16
Beyond the Basics
17
Data Constraints — FOREIGN KEY, UNIQUE, NOT NULL, CHECK
18
Self Join and Cross Join
19
Conditional Expressions — CASE, COALESCE, NULLIF
20
Transactions — ACID Properties and Isolation Levels
21
Relational Databases — Concepts and SQL vs. NoSQL
22
Query Optimization Techniques
