ExamAdda LogoExamAdda
SYSTEM DESIGN (LLD)SYSTEM DESIGN (HLD)DSADBMSMYSQLINTERVIEWOSARTIFICIAL INTELLIGENCEMACHINE LEARNINGDEEP LEARNINGGENAIROADMAPSJAVASCRIPTPYTHON
Roadmap Section to Article Path

MYSQL Tutorial Roadmap

13
Sections
3
Sub Section
115
Articles
0
Premium
01SectionMySQL Basic 3 subsections 16 articles
16/16 articles
1Introduction
2Installation Subsection 3/3 articles
Subsection articles
3/3 articles
1Installing Mysql
2MySQL Tools
3MySQL Connection
3MySQL Constraints Subsection 7/7 articles
Subsection articles
7/7 articles
1Constraints Introductions
2NOT NULL
3UNIQUE
4PRIMARY KEY
5FOREIGN KEY
6CHECK
7DEFAULT
4Operators and Clauses
5Type of SQL Commands Subsection 4/4 articles
Subsection articles
4/4 articles
1DDL
2DML
3DCL
4TCL
02SectionMySQL Database 0 subsections 5 articles
5/5 articles
1Create Database
2Drop Database
3Select Database
4Show Database
5Copy Database
03SectionMySQL Table 0 subsections 15 articles
15/15 articles
1Create Tables
2Show Tables
3Alter Tables
4Rename Tables
5Clone Tables
6Truncate Tables
7Temporary Tables
8Repair Tables
9Describe Tables
10Add/Delete Columns
11Show Columns
12Rename Columns
13Table Locking
14Drop Tables
15Derived Tables
04SectionCRUD Queries 0 subsections 8 articles
8/8 articles
1Insert Query
2Select Query
3Update Query
4Delete Query
5Replace Query
6Insert Ignore
7Insert on Duplicate Key Update
8Insert Into Select
05SectionSQL Clauses 0 subsections 8 articles
8/8 articles
1Where Clause
2Limit Clause
3Distinct Clause
4Order By Clause
5Group By Clause
6Having Clause
7Alias
8ROLLUP
06SectionSQL Operators 0 subsections 17 articles
17/17 articles
1AND Operator
2OR Operator
3Like Operator
4IN Operator
5ANY Operator
6EXISTS Operator
7NOT Operator
8NOT EQUAL Operator
9IS NULL Operator
10IS NOT NULL Operator
11Between Operator
12UNION Operator
13UNION vs UNION ALL
14MINUS Operator
15INTERSECT Operator
16INTERVAL Operator
17Wildcards
07SectionSQL Joins 0 subsections 7 articles
7/7 articles
1Inner Join
2Left Join
3Right Join
4Cross Join
5Full Join
6Self Join
7Union vs Join
08SectionAggregate Functions 0 subsections 7 articles
7/7 articles
1COUNT()
2SUM()
3AVG()
4MIN()
5MAX()
6GROUP BY
7HAVING
09SectionViews 0 subsections 4 articles
4/4 articles
1Create Views
2Update Views
3Drop Views
4Rename Views
10SectionTriggers 0 subsections 10 articles
10/10 articles
1Triggers
2Create Trigger
3Show Trigger
4Drop Trigger
5Before Insert Trigger
6After Insert Trigger
7Before Update Trigger
8After Update Trigger
9Before Delete Trigger
10After Delete Trigger
11SectionIndexes 0 subsections 8 articles
8/8 articles
1Single-Level Index
2Multi-Level Index
3B-Tree
4B+ Tree
5Bitmap Index
6Inverted Index
7Clustered vs Non-Clustered Index
8Hash Indexing
12SectionReplication & Scaling 0 subsections 8 articles
8/8 articles
1Master-Slave Replication
2Master-Master
3Read Replicas
4Sharding
5Partitioning
6High Availability
7Horizontal Partitioning
8Vertical Partitioning
13SectionAdvanced SQL 0 subsections 2 articles
2/2 articles
1SubQuery
2Cursor
Next Tutorial
Introduction