Oracle PL/SQL Programming in Hindi Course

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