ProSchool

1. SQL - Basic Introduction

27. SQL SUBQUERY in FROM clause, with INSERT , UPDATE and DELETE

17. SQL Constraints .. CHECK

32. SQL Functions - Conversion,TO_CHAR,TO_DATE,NVL & DECODE

25. SQL ALTER TABLE - ADD, DROP, MODIFY and RENAME

19. SQL GROUP BY with HAVING

30. SQL Functions - Character / String / Text

3. SQL SELECT

7. SQL SELECT with WHERE ... contd3

34. SQL MINUS and MINUS vs LEFT JOIN

28. SQL DATE datatype

18. SQL Constraints .. DEFAULT

33. SQL INTERSECT , INTERSECT VS INNER JOIN

9. SQL INSERT

10. SQL Handling NULL

16. SQL Constraints .. FOREIGN KEY

35. SQL EXISTS, how EXISTS differ from IN

29. SQL Functions - Numeric

36. SQL DELETE , TRUNCATE and DROP

24. SQL UNION & UNION ALL

37. SQL : COMMIT & ROLLBACK

2. Table Creation - Basic

14. SQL Constraints ... Not Null & Unique