Oracle PL/SQL Programming in Hindi Course
5.0
(0)
5 learners
What you'll learn
This course includes
- 10 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 89 lessons • 10 hours of video
Oracle PL/SQL Programming in Hindi Course
89 lessons
• 10 hours
Oracle PL/SQL Programming in Hindi Course
89 lessons
• 10 hours
- 1. What is Database 02:43
- 2. What is Database Table? 01:38
- 3. What is Database Fields and Records? 01:27
- 4. What is Oracle? 01:12
- 5. What is RDBMS and how it is different from flat files? 02:15
- 6. What is SQL? Is SQL common for all RDBMS packages, prove it? 04:31
- 7. Installing Oracle 05:58
- 8. CREATE, INSERT and SELECT commands 15:42
- 9. DELETE and UPDATE commands 06:35
- 10. SELECT command with WHERE condition 10:15
- 11. LIKE 'pattern' Operator 05:28
- 12. IN Operator 03:41
- 13. BETWEEN Operator 05:41
- 14. Pseudo Columns 14:02
- 15. Data Types in Oracle 04:50
- 16. ORDER BY Clause in PL/SQL Oracle 03:55
- 17. RENAME Table and DROP Table in Oracle 03:06
- 18. Savepoint, Rollback and Commit in Oracle 06:39
- 19. Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in Oracle 13:58
- 20. Tablespace and Datafile in Oracle 04:34
- 21. Alter Tablespace in Oracle 06:33
- 22. Insert multiple records in one or more tables at once in PL/SQL Oracle 03:22
- 23. Grant, Revoke and Grant Table View to other user in Oracle 09:44
- 24. Referential Integrity in Oracle 09:42
- 25. Column Alias in Oracle 03:01
- 26. Table Alias in Oracle 04:00
- 27. Equi Join and Non Equi Join in PL/SQL Oracle 05:05
- 28. Self Join in Oracle 02:18
- 29. Natural Join in Oracle 02:02
- 30. Cross Join in PL/SQL Oracle 02:14
- 31. Outer Join - (Left Outer Join, Right Outer Join and Full Outer Join) in Oracle 04:46
- 32. Anti Join in Oracle 02:04
- 33. Column Format in Oracle 03:41
- 34. Aggregate Functions in PL/SQL Oracle 06:50
- 35. Character Functions in Oracle 04:55
- 36. Number Functions in Oracle 06:55
- 37. Conversion Functions To Char, To Date, NVL, Decode in PL/SQL Oracle 10:19
- 38. Date Functions - Add_Months, Last_Day, Months_Between, Next_Day, To_Date, New_Time in Oracle 07:52
- 39. SQL Commands Type in PL/SQL Oracle 01:27
- 40. SQL Buffer Commands in Oracle 04:47
- 41. Ed or Edit Buffer Command in Oracle 02:12
- 42. IN and NOT IN Operators in Oracle 04:09
- 43. Not Null Constraint in PL/SQL Oracle 03:45
- 44. Unique Constraint in Oracle 02:44
- 45. Primary Key and Foreign Key Constraints in PL/SQL Oracle 12:37
- 46. Check Constraint in Oracle 09:49
- 47. Order By Clause in Oracle 03:20
- 48. Group By Clause in PL/SQL Oracle 05:35
- 49. Having Clause in Oracle 04:52
- 50. Subquery or Inner Query or Nested Query in PL/SQL Oracle 03:40
- 51. Union, Union All, Intersect and Minus Operators in PL/SQL Oracle 06:32
- 52. Data Dictionaries TAB, ALL TABLES, ALL SEQUENCES, ALL VIEWS etc in PL/SQL Oracle 06:33
- 53. What are SQL, PL/SQL, TSQL and SQL Plus 03:16
- 54. ALTER TABLE ADD new column and DROP existing column in PL/SQL Oracle 05:31
- 55. ALTER TABLE to Modify existing column in PL/SQL Oracle 08:00
- 56. ALTER TABLE to ADD and DROP integrity constraints in PL/SQL Oracle 10:39
- 57. Create, Alter and Drop Sequence in Oracle 04:38
- 58. Create, Alter and Drop named constraints in PL/SQL Oracle 05:41
- 59. Subquery in PL/SQL Oracle 19:12
- 60. Set Union, Union All, Intersect, Minus Operators in PL/SQL Oracle 10:25
- 61. Execute commands written in physical file in PL/SQL Oracle 05:34
- 62. Getting started with SQL Plus Reports in PL/SQL Oracle - Part 1 12:32
- 63. Getting started with SQL Plus Reports in PL/SQL Oracle - Part 2 10:17
- 64. Getting started with SQL Plus Reports in PL/SQL Oracle - Part 3 05:18
- 65. Views in PL/SQL Oracle 18:52
- 66. Input Variables in Oracle SQL Plus 06:52
- 67. Define Variables in PL/SQL Oracle 06:04
- 68. Bind Variables in PL/SQL Oracle 02:01
- 69. Introduction to PL/SQL in Oracle 10:42
- 70. IF ELSE construct in PL/SQL Oracle 05:18
- 71. FOR LOOP Looping Command in PL/SQL Oracle 09:54
- 72. LOOP Looping Command in PL/SQL Oracle 02:20
- 73. WHILE Looping Command in PL/SQL Oracle 02:10
- 74. PL/SQL Table in Oracle 10:54
- 75. Exception in PL/SQL Oracle 11:34
- 76. Tax Calculator and Exception Handling in PL/SQL Oracle 06:21
- 77. Introduction to Cursor in PL/SQL Oracle 11:21
- 78. Cursor Examples in PL/SQL Oracle 07:05
- 79. UPDATE and DELETE using Cursor in PL/SQL Oracle 08:18
- 80 Introduction to TRIGGER in PL/SQL Oracle 11:05
- 81. AFTER INSERT fire UPDATE Command in Trigger in PL/SQL Oracle 05:03
- 82. AFTER INSERT or UPDATE or DELETE Commands in Trigger in PL/SQL Oracle 05:59
- 83. Statement Level Trigger in PL/SQL Oracle 05:31
- 84. Introduction to Procedure and Function in PL/SQL Oracle 18:16
- 85. Function in PL/SQL Oracle 06:45
- 86. Package in PL/SQL Oracle 06:01
- 87. Create and Execute Package in PL/SQL Oracle 08:11
- 88. Using RMAN Recovery MANager in PL/SQL Oracle 15:45
- 89. Oracle Database in the Browser APEX 14:41
