Below are the list of all the important topics that are important for a manual tester in SQL. And also they are very important for any level Manual Testing Job interviews

1. Types of statements

2. Data Definition statements(DDL)

  • Alter Table
  • Create Database
  • Create Index
  • Create Table
  • Drop Database
  • Drop Index
  • Drop Table
  • Rename Table
  • Truncate Table

3. Data Manipulation Statements(DML)

  • Delete Table
  • Insert
  • Select
  • Update

4. Transaction control statements(TCL)

  • Commit
  • Save point
  • Rollback

5. Functions

  • Aggregate functions
  • Scalar Functions

6. Joins

  • Inner join
  • Left Join
  • Right Join

7. Union

8. ‘And’ and ‘Or’ operators

9. Order By

10. LIMIT

11. Group By

12. Wild Cards

13. Distinct

14. Like

15. In

16. Between

17. Aliases

18. Insert into select(for copy)

19. Constraints

  • NOT NULL
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • DEFAULT

20. Index

21. Auto Increment

22. Views

23. Dates

24. Null values

25. Null Functions

26. Data Types

27. Having

These are some of the important topics regarding MySQL…

Let us see each topic in-detail in next posts…