429 подписчиков
31 видео
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
9. SQL INSERT
29. SQL Functions - Numeric
16. SQL Constraints .. FOREIGN KEY
35. SQL EXISTS, how EXISTS differ from IN
10. SQL Handling NULL
36. SQL DELETE , TRUNCATE and DROP
24. SQL UNION & UNION ALL
37. SQL : COMMIT & ROLLBACK
12. SQL DELETE
15. SQL Constraints .. PRIMARY KEY
14. SQL Constraints ... Not Null & Unique
11. SQL UPDATE
2. Table Creation - Basic
8. SQL ORDER BY
26. SQL SUBQUERY with SELECT
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
