sql-notes-and-practice/Roadmap at main · Thogaruchesti-hemanth/sql-notes-and-practice · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
1. Basic foundation
    i. what is MySQL?
   ii. What is database and DBMS?

2. Need to learn the basics to write queries
    i. Datatypes
   ii. Constraints

3. learn 'CREATE TABLE'.

4. Learn 'ALTER' and 'MODIFY'.
    1. Change the DataType of a particular column.
    2. Change the Column Size (example: - length of the characters allowed).
    3. Add and Remove NOT NULL constraint.
    4. Add, Remove and Change the DEFAULT value.
    5. Change column position. ( like roll_no, name --> name, roll_no)
    6. Rename Column name.

5. Learn 'INSERT'.

6. Learn 'SELECT' 'WHERE'.

7. Learn 'AND', 'OR', 'NOT'.

8. Learn 'IN', 'BETWEEN', 'LIKE', 'IS NULL'.

9. Learn  `ORDER BY`, `LIMIT`, `OFFSET`.

10. Learn 'UPDATE', `DELETE`.

11. Learn Aggregate Functions DISTINCT, COUNT, MIN, MAX, AVG, SUM.

12. Learn GROUP BY, HAVING.

13.