Comprehensive Oracle Database Tutorial Series (Download, Installation, SQL Basics, PL/SQL, and Advanced Topics)

Part 1: Oracle Download and Installation

1. Database type introduction (mp4)

2. Oracle official website overview and download procedure (mp4)

3. Oracle database installation tutorial (mp4)

4. Oracle related services explanation (mp4)

5. Oracle database instance creation (mp4)

6. Oracle client tool "SQL Developer" overview (mp4)

7. Detailed Oracle database uninstallation steps (mp4)

8. Oracle user and permission management (mp4)

Part 2: Oracle Basic SQL Operations

9. SQL introduction and data type overview (mp4)

10. Table creation statements and comments (mp4)

11. Deleting and modifying table structures (mp4)

12. Table constraints explanation (mp4)

13. DML INSERT statement tutorial (mp4)

14. DML SEQUENCE (auto‑increment) tutorial (mp4)

15. DML UPDATE statement tutorial (mp4)

16. DML DELETE statement tutorial (mp4)

17. DML multi‑row operation tutorial (mp4)

18. DQL simple full‑table query tutorial (mp4)

19. DQL simple conditional query tutorial (mp4)

20. DQL single‑table query case study (part 1) (mp4)

21. DQL single‑table query case study (part 2) (mp4)

22. DQL aggregate functions tutorial (mp4)

23. DQL common functions – grouping functions tutorial (mp4)

24. DQL multi‑table query – cross join and equi‑join tutorial (mp4)

25. DQL multi‑table query – other join types tutorial (mp4)

26. DQL comprehensive case study (part 1) (mp4)

27. DQL comprehensive case study (part 2) (mp4)

Part 3: Oracle Advanced PL/SQL Programming

28. PL/SQL syntax overview (mp4)

29. PL/SQL DBMS_OUTPUT tutorial (mp4)

30. PL/SQL assignment statements (part 1) (mp4)

31. PL/SQL assignment statements (part 2) (mp4)

32. PL/SQL assignment statements (part 3) (mp4)

33. PL/SQL control statements – branch statements tutorial (mp4)

34. PL/SQL control statements – loop statements tutorial (mp4)

35. PL/SQL control statements – GOTO keyword tutorial (mp4)

36. PL/SQL dynamic SQL statements tutorial (mp4)

37. PL/SQL exception handling tutorial (mp4)

38. PL/SQL case study (part 1) (mp4)

39. PL/SQL case study (part 2) (mp4)

40. PL/SQL cursors – implicit cursor tutorial (mp4)

41. PL/SQL cursors – explicit cursor tutorial (mp4)

42. PL/SQL cursors – REF cursor tutorial (mp4)

43. Subprograms – stored procedure without parameters tutorial (mp4)

44. Subprograms – stored procedure with parameters tutorial (mp4)

45. Subprograms – comprehensive small case study (mp4)

46. Subprograms – stored function tutorial (mp4)

47. Subprograms – package tutorial (mp4)

48. Triggers – syntax introduction and statement‑level trigger tutorial (mp4)

49. Triggers – row‑level and conditional row‑level trigger tutorial (mp4)

50. Views – introduction and creation tutorial (mp4)

51. Views – view‑related case study tutorial (mp4)

52. Indexes – introduction tutorial (mp4)

--- End of tutorial list ---