Oracle Dataguard, ASM, RAC DBA Training Online Course.

The Ultimate $200K/yr Remote Oracle/AWS Masters Course

Learn how to earn $200K per job working from home

Who is the target audience?

Oracle Database Administrators who want to learn how to create and manage Oracle RAC databases and administer Oracle Data Guard.

Course curriculum

1. Linux Fundamentals I
2. Linux Fundamentals II
3. Linux Fundamentals III
4. Linux Fundamentals IV
5. Linux Fundamentals V
6. Differences Between Windows And Linux
7. What Is A Linux Operating System Prompt
8. Check System Requirements
9. Linux Commands: How To Move Backwards In Linux
10. Linux Commands: How To Move Forward In Linux
11. Linux Commands: What Is A Mount Point
12. Linux Commands: How To Create A Directory In Linux
13. Linux Commands: How To Create A File In Linux
14. Linux Commands: How To Copy A File Or Directory In Linux
15. Linux Commands: How To Move A File Or Directory In Linux
16. Linux Quizes
17. Linux Commands: How To Delete A File Or Directory In Linux
18. Linux Commands: How To List Directories In Linux
19. Linux Commands: How To Switch Users In Linux
20. Linux Commands: How To Change Permissions On A File In Linux
21. Linux Commands: How To Change Ownership In Linux
22. Linux Commands: How To Shutdown Your Server In Linux
23. Notes: Basic Unix Commands
24. Project 1
25. How To Turn In Your Homework Assignment
26. Week 2: Part 1
27. Week 2: Part 2
28. How To Connect To An Oracle Database
29. How To Startup And Shutdown An Oracle Database
30. Select Statement- What Is A Server Parameter File
31. What Is A Controlfile
32. What Is A Datafile And Redolog File
33. What Is A Datafile And Redolog File
34. Select Statements: Explaining Data Manipulation,Data Definition,Data Control Languages
35. Select Statement- Rules Of Select Statements| Select Statement Basics
36. Select Statement- Aliases| Select Statement Basics
37. Select Statement- Arithmetic Functions|Select Statement Basics
38. Select Statement- Arithmetic Functions|Select Statement Basics
39. Select Statement- Case Functions|Select Statement Basics
40. SQL QUIZ PART 1
41. Select Statement- Concatenation|Select Statement Basics
42. Select Statement- Group By Clause|Select Statement Basics
43. Select Statement- Length Clause|Select Statement Basics
44. Select Statement- Replace Clause|Select Statement Basics
45. Select Statement- Left Pad And Right Pad|Select Statement Basics
46. Select Statement- NVL|Select Statement Basics
47. Select Statement- Left Pad And Right Pad|Select Statement Basics
48. Select Statement- Instr|Select Statement Basics
49. Select Statement- Substr|Select Statement Basics
50. Select Statement-To-Char|Select Statement Basics
51. Select Statement-To-Char|Select Statement Basics
52. Select Statement- Where Clause Pt 1|Select Statement Basics
53. Select Statement-Where To + And Clause|Select Statement Basics
54. Select Statement- OR clause|Select Statement Basics
55. Select Statement- And Clause|Select Statement Basics
56. Select Statements- Where Clause contd|Select Statement Basics
57. Select Statement-Between clause|Select Statement Basics
58. Select Statement- Between Clause Contd|Select Statement Basics
59. SQL QUIZ PART 2
60. Select Statement-In clause|Select Statement Basics
61. Select Statement-In clause|Select Statement Basics
62. Select Statement- Like|Select Statement Basics
63. Select Statement-Null Clause|Select Statement Basics
64. Select Statement- Putting It All Together|Select Statement Basics
65. Project 2
66. SQL CLASS NOTES
67. PROJECT 1 SOLUTIONS
68. About this week
69. Week 3: Part 1
70. Week 3: Part 2
71. Select Statement- Group by Clause|Select Statement Basics
72. Select Statement-GroupBY Clause Part2|Select Statement Basics
73. Select Statement-Group BY Clause Part 3|Select Statement Basics
74. Select Statement- How To Perform A Subquery|Select Statement Basics
75. Select Statement- How To Perform A Subquery Part 2|Select Statement Basics
76. Select Statement- How To Perform A Subquery Part 3|Select Statement Basics
77. Select Statement- What Is An Equijoin| Select from Multiple Tables
78. Select Statement- What Is An Equijoin| Select from Multiple Tables
79. Select Statement- What Is An Equijoin Part 2 | Select from Multiple Tables
80. Select Statement- What Is An Equijoin Part 3| Select from Multiple Tables
81. Select Statement- What Is An Equijoin Part 4| Select from Multiple Tables
82. Select Statement- What Is An Equijoin Part 5| Select from Multiple Tables
83. Select Statement- What Is A Leftjoin| Select from Multiple Tables
84. Select Statement- What Is A Rightjoin| Select from Multiple Tables
85. Select Statement- Minus Clause| Select from Multiple Tables
86. Select Statement- Intersect Clause| Select from Multiple Tables
87. Select Statement- Union Clause| Select from Multiple Tables
88. SQL QUIZ PART 3
89. Select Statement- Union Clause| Select from Multiple Tables
90. Select Statement-Putting IT All Together| Selecting From Multiple tables
91. Project 3
92. Copy of SQL CLASS NOTES
93. Copy of PROJECT 2 SOLUTIONS
94. About This Week
95. Week 4: Part 1
96. Week 4: Part 2
97. Data Definition Language- How To Connect To A New Schema
98. Data Definition Language- How to Create A Duplicate Table
99. Data Definition Language- Understanding Oracle Database Tables Datatypes
100. Data Definition Language- Table Column Level Constraints
101. Data Definition Language- Adding A Primary Key Constraint
102. Data Definition Language- Adding A Not Null Constraint
103. Data Definition Language- Adding Unique Constraint
104. Data Definition Language- Adding A Check Constraint
105. Data Definition Language-Adding A Foreign Key Constraint
106. Alter Statement- Adding A Table Constraint After Table Creation| Data Definition Language
107. Alter Statement- Disable Column Level Constraint After Table Creation|Data Definition Language
108. Alter Statement- Enabling A ColumnConstraint After Table Creation|Data Definition Language
109. Alter Statement- Dropping A Column Level Constraint After Table Creation|Data Definition Language
110. Alter Statement-Renaming A Column In A Table|Data Definition Language
111. Alter Statement- Modify A Table Column|Data Definition Language
112. Alter Statement- Renaming A Table|Data Definition Language
113. Alter Statement- Modify A Table Column|Data Definition Language
114. Alter Statement- Drop A Table Column|Data Definition Language
115. Alter Statement- Adding A Column To A Table|Data Definition Language
116. Insert Statement- Inserting Data Into A Table Column|Data Manipulation Language
117. Update Statement- Update Data In A Table Column|Data Manipulation Language
118. Deleting Data In A Table Column|Data Manipulation Language
119. Delete, Drop, Truncate In SQL
120. Data Definition Language-Creating A View
121. SQL QUIZ 4
122. Data Definition Language- Create A Sequence
123. Data Definition Language- Create A Sequence
124. Data Definition Language- Create An Index
125. Data Definition Language- Create A Synonym
126. Project 4
127. SQL CLASS NOTES
128. PROJECT 3 SOLUTIONS
129. About This Week
130. Week 5: Part 1
131. Week 5: Part 2
132. Notes: Database Creation
133. Notes: Managing Oracle Instance
134. Notes: Oracle Database Architecture
135. Notes: User Management
136. How To Create An Oracle Database
137. Oracle Database Administration- Understanding The Oratab File|
138. Oracle Database Administration- Editing The Bash Profile
139. Oracle Database Administration- Understanding Spfile Part 2
140. Oracle Database Administration- Understanding The Export Command
141. Oracle Database Administration- Understanding The Echo Command
142. Oracle Database Administration- Understanding The Physical Structure Of An Oracle Database
143. Oracle Database Administration- Understanding The Logical Structure Of An Oracle Database
144. Oracle Database Administration- Difference The Between SPfile And Pfile
145. Oracle Database Administration-How To Create An Spfile And Pfile
146. Oracle Database Administration- Editing The Pfile
147. Oracle Database Administration- How To Start Oracle Database With The Pfile
148. Oracle Database Administration- How To View Spfile Parameters
149. Oracle Database Administration- Understanding Spfile Scopes
150. Oracle Database Administration- Understanding Spfile Scopes
151. Oracle Database Administration- Understanding The Controlfile
152. Oracle Database Administration- Understanding Datafile
153. Oracle Database Administration- Understanding Redolog files
154. Oracle Database Administration- Understanding Archived Redologfiles
155. Oracle Database Administration- Understanding Dynamic Performance Views
156. Oracle Database Administration- Understanding How To Create A Tablespace And Datafiles
157. Oracle Database Administration- Understanding The 5 Default Tablespaces
158. Oracle Database Administration- Understanding Oracle Managed Files (OMF)
159. Oracle Database Administration- Understanding How To Create Users In A Database
160. Oracle Database Administration- Understanding How To Create Users In A Database
161. Oracle Database Administration- Understanding System Privileges
162. Oracle Database Administration- Understanding How To Create Roles
163. Oracle Database Administration- Understanding How To Create Roles
164. Oracle Database Administration- Understanding How To Create User Profiles
165. Oracle Database Administration- Understanding Enterprise Manager In 11g
166. Project 5
167. Copy of ORACLE ADMIN QUIZ 1
168. Copy of PROJECT 4 SOLUTIONS
169. About This Week
170. Week 6: Part 1
171. Week 6: Part 2
172. Notes: Database Maintenance
173. Notes: Oracle_Network
174. Notes: Auditing
175. Project 6
176. Oracle Database Administration- Understanding Standard Auditing
177. Oracle Database Administration- Understanding Standard Auditing Part 2
178. Oracle Database Administration- Understanding How To Set Up Standard Audits
179. Oracle Database Administration- Understanding Setting Up Fine Grain Auditing
180. Oracle Database Administration- Understanding How To Set Up Finegrain Auditing contd
181. Oracle Database Administration- Understanding How To Disable Finegrain Audit Policies
182. Oracle Database Administration- Understanding How To Configure Oracle Listener
183. Oracle Database Administration- Explaining How To Control The Oracle Database Listener
184. Oracle Database Administration- Undestanding How To Configure The TNS Names.ora File
185. Oracle Database Administration- How to Register The Database A Listener Via Net Manager
186. Oracle Database Administration- Understanding How To Resolve Common Listener Issues
187. Oracle Database Administration- Understanding How Configure The Archivelog
188. Oracle Database Administration- Understanding How To Configure Fast Recovery Area
189. Oracle Database Administration- Understanding The Undo Tablespace
190. Oracle Database Administration- Understanding How To Configure The Undo Tablespace
191. Oracle Database Administration- Listener Definition
192. Oracle Database Administration- Listener Creation
193. Oracle Database Administration- Listener Modification
194. Oracle Database Administration- Understanding TNS Names.ora file
195. Oracle Database Administration-TNS Names Creation
196. Oracle Database Administration- Database Registration
197. Oracle Database Administration- Understanding Automatic Workload Repository (AWR)
198. Oracle Database Administration- Undestanding Automatic Workload Repository(AWR) Contd
199. Oracle Database Administration- Running An AWR Report
200. Oracle Database Administration- Running An ADDM Report
201. Oracle Database Administration- Identifying Blocking Sessions
202. Oracle Database Administration- Understanding The Optimizer
203. Oracle Database Administration- Optimizer Statistic Gathering
204. ORACLE ADMIN QUIZ 2
205. PROJECT 5 SOLUTIONS
206. About This Week
207. Week 7: Part 1
208. Week 7: Part 2
209. Notes: Backup Concepts
210. Notes: Datapump
211. Notes: Flashback
212. Notes: Locks
213. Notes: Restore and Recovery
214. Notes: RMAN Backup
215. Project 7
216. Oracle Database Administration II- Connecting To Recovery Manager
217. Oracle Database Administration II- Setting Up RMAN Parameters
218. Oracle Database Administration II- Setting Up RMAN Contd
219. Oracle Database Administration II- Backing Up The Database Via Recovery Manager
220. Oracle Database Administration II- How To Recover From A SPfile Loss
221. Oracle Database Administration II- How To Recover From A Controlfile Loss
222. Oracle Database Administration II- How To Recover From A Datafile Loss
223. Oracle Database Administration II- How To Recover From A Redo Log File Loss
224. Oracle Database Administration II- How To Recover From A Loss Of All Physical Files
225. Oracle Database Adminsitration II- Backing Up The Controlfile To A Trace File
226. Oracle Database Administration II- Datapump Part 1
227. ORACLE ADMIN QUIZ 3
228. Oracle Database Administration II- Datapump Backup Part 2|
229. Oracle Database Administration II- Flashback Database
230. Oracle Database Administration II- Flashback Drop
231. Oracle Database Administration II- Flashback Table
232. Oracle Database Administration II- Resetting Sys Password File
233. ORACLE ADMIN QUIZ 4
234. Oracle Database Administration II- SQL LOADER Best Practices
235. RMAN Settings
236. PROJECT 6 SOLUTIONS
237. About This Week
238. Week 8: Part 1
239. Week 8: Part 2
240. How To uninstall Oracle 12c Software From A Server
241. Oracle Upgrade Explained
242. Oracle Database Administration II- Upgrade 11.2.0.1 to 11.2.0.2
243. Oracle Database Administration II- Upgrade 11.2.0.1 to 11.2.0.2 Part 2
244. Upgrade From 11.2.0.4 To Oracle 12c Part 3
245. Upgrade From 11.2.0.4 To Oracle 12c
246. Upgrade From 11.2.0.4 To Oracle 12c Part 2
247. Upgrade From 11.2.0.4 To Oracle 12c Part 3
248. Oracle Database Administration II- Datafile Relocation Explained
249. Oracle Database Administration II- Critical Patch Update
250. Oracle Database Administration II- Sqldeveloper Basics
251. ORACLE ADMIN QUIZ 4
252. Oracle Database Administration II- Sqldeveloper New Connection
253. Oracle Database Administration II- Duplicating A Database Via Rman
254. Cloning A Database Via Recovery Manager Script
255. Project 8
256. Oracle Software
257. PROJECT 7 SOLUTIONS
258. FINAL EXAM
1. How To Uninstall The Oracle Software Completely From Your Server
2. How To Create A Container Database
3. How To Create A Pluggable Database From DBCA
4. How To Create A Pluggable Database From Seed
5. Registering The Container And PDB Databases With The TNS Names And Listener.ora Files
6. Registering The Container And PDB Databases With The TNS Names And Listener.ora Files Part 2
7. How To Move From One PDB To Another PDB Database
8. How To Put PDB Database In Archive Redo Log Mode
9. How To Save The State Of A Pluggable Database
10. How To Change Initialization Parameters In A Pluggable Database
11. Creating A Common User
12. Creating A Common User Locally
13. Creating A Common Role
14. Granting A Common Role To A Common User
15. Revoking A Common Role
16. Backing-Up-CDB-Database
17. Backing-Up-PDB-Database
18. Backing-Up-PDB-Database-AS-PDBADmin
19. Backing-Up-PDB-Tablespace-Database
20. Create-Common-User-For-Backups
21. FlashbackCDB-With-Restorepoint
22. PDB-TablespaceLoss-recovery
23. 12C PROJECT
24. Backup and recovery scripts
25. UNINSTALLING ORACLE SOFTWARE
26. Multitenant Oracle Database How To Install Oracle Software From Your Machine
27. Oracle Database How To Create An Empty Container Database
28. Oracle Database How To A NON- Container Database
29. Configuring Your Net Service Names File
30. Connecting To SQL Developer
31. Creating A Pluggable Database From Seed
32. Creating A Pluggable Database Through DBCA
33. Registering Your PDB With Your TNS Names File
34. Deleting A Pluggable Database Through DBCA
35. Creating A Pluggable Database Through SQL Developer
36. Understanding The New Dictionary Tables In Oracle 12C
37. Switching Containers
38. Locating All PDB's In The Container Database
39. Locating All PDB's In The Container Database
40. Creating A CDB and PDB Through DBCA wih Example TBS
41. Viewing Tables Owned By Schemas From The Root Container
42. Common Files Held By Pluggable DB'S
43. Starting And Shutting Down Container Database
44. Starting And Shutting Down PDB Database
45. Starting And Shutting Down PDB Database From Root
46. Changing Parameters In The Root Container And PDB Simultaneously
47. Changing Parameters In Your PDB Database
48. Getting History of Your PDB Database
49. Dropping Your PDB Database Including Datafile
50. Examining The States Of Your PDB Database
51. Examining Which Parameter Is Modifiable
52. Renaming Your Pluggable Database
53. Drop and Clone Your Pluggable Database
54. Understanding PDB$SEED
55. Cloning A PDB From Another PDB
56. Creating A Database Link
57. Creating A Pluggable Database Through A DB Link
58. Using EZ-Connect Configuration To Connect To A Database
59. Unplugging And Replugging A PDB via XML File
60. Creating A PDB via Archive File
61. Creating A PDB From Non-PDB via DBLink
62. Creating A PDB From DBMS PACKAGE
63. Creating A REFRESHABLE Pluggable Database
64. Understanding Common Users and Local Roles
65. Creating Common Users And Granting Them Privileges
66. Creating Common Users And Granting Them Local Privileges
67. Viewing All Local Users In The Container
68. Creating Local Users In The PDB Container
69. Viewing All Common Roles In The PDB and Root Container
70. Creating Common Role In The CDB$Root Container
71. Creating Local Role In The PDB Container
72. Granting Common Role To Common User
73. Viewing Granted Roles
74. Granting Common Role To Common User More Examples
75. Granting Privileges To A Common Role
76. Revoking Privileges From A Common Role
77. Granting Common Role To Local User
78. Backing Up A CDB Database
79. Backing Up A PDB Database
80. Backing Up A PDB Tablespace
81. Restore A SYSTEM PDB Tablespace
82. Restore A NON- SYSTEM PDB Tablespace
83. Backing Up A CDB Database As A Dedicated User
84. Backing Up A CDB Database As A SYSBACKUP
85. Creating A Restore Point
86. Point In Time Recovery For a PDB
87. Flashback To Scn
88. Flashback Pluggable Database To Restore Point
89. Flashback Pluggable Tablespace to PITR
90. Exporting A Schema From One PDB To Another
91. Understanding Application CDB's and PDB's
92. Creating An Application Container
93. Installing An Application In the Application Root
94. Creating An Application Seed
95. Creating An Application Seed From Application Root
96. Creating An Application Seed From Application Root
97. Creating An Application PDB
98. Viewing Application PDB and Application CDB's
99. Registering App PDB and App CDB's With Listener
100. Installing A New Application and Syncing App PDB's
101. Querying Data, Meta and Extended Linked Objects
102. Deleting Rows From Data Linked, MetaLinked and Extended Data-Linked Objects
103. Upgrading An Application
104. Patching An Application
105. ORACLE 12C PROJECTS
1. Oracle Real Application Clusters Classroom Lecture Video 1
2. Oracle Real Application Clusters Classroom Lecture Video 2
3. Oracle Real Application Clusters Classroom Lecture Video 3
4. Oracle Real Application Clusters Classroom Lecture Video 4
5. Oracle Real Application Clusters Classroom Lecture Video 5
6. Oracle Real Application Clusters Classroom Lecture Video 6
7. Oracle Real Application Clusters Classroom Lecture Video 7
8. Oracle Real Application Clusters Classroom Lecture Video 8
9. Oracle Real Application Clusters Classroom Lecture Video 9
10. Oracle Real Application Clusters Classroom Lecture Video 10
11. Oracle Real Application Clusters Classroom Lecture Video 11
12. Oracle Real Application Clusters Classroom Lecture Video 12
13. Oracle Real Application Clusters Classroom Lecture Video 13
14. Oracle Real Application Clusters Classroom Lecture Video 14
15. Oracle Real Application Clusters Classroom Lecture Video 15
16. Oracle Real Application Clusters Classroom Lecture Video 16
17. Oracle Real Application Clusters Classroom Lecture Video 17
18. Oracle Real Application Clusters Classroom Lecture Video 18
19. Oracle Real Application Clusters Classroom Lecture Video 19
20. Oracle Real Application Clusters Classroom Lecture Video 20
21. Oracle Real Application Clusters Classroom Lecture Video 21
22. Oracle Real Application Clusters Classroom Lecture Video 22
23. Oracle Real Application Clusters Classroom Lecture Video 23
24. Oracle Real Application Clusters Classroom Lecture Video 24
25. Oracle Real Application Clusters Classroom Lecture Video 25
26. Oracle Real Application Clusters Classroom Lecture Video 26
27. Oracle Real Application Clusters Classroom Lecture Video 27
28. Oracle Real Application Clusters Installation Video 1
29. Oracle Real Application Clusters Installation Video 2
30. Oracle Real Application Clusters Installation Video 3
31. Oracle Real Application Clusters Installation Video 4
32. Oracle Real Application Clusters Installation Video 5
33. Oracle Real Application Clusters Installation Video 6
34. Oracle Real Application Clusters Installation Video 7
35. Oracle Real Application Clusters Installation Video 8
36. Oracle Real Application Clusters Installation Video 9
37. Oracle Real Application Clusters Installation Video 10
38. Oracle Real Application Clusters Installation Video 11
39. Oracle Real Application Clusters Installation Video 12a
40. Oracle Real Application Cluster Installation Video 12b
41. Oracle Real Application Clusters Installation Video 12
42. Oracle Real Application Clusters Installation Video 13
43. Oracle Real Application Clusters Installation Video 14
44. Oracle Real Application Clusters Installation Video 15
45. Grid Infrastructure Commands
46. RAC RPMS
47. ORACLE REAL APPLICATION CONFIGURATION SCRIPTS
1. Oracle RAC Video 1 - How To Download Linux 6.5 ISO File
2. Oracle RAC Video 2 - Installing Your Virtual Machine
3. Downloading XMING Software
4. Oracle RAC Video 5 - Downloading Putty Software
5. Oracle RAC Video 6 - Creating Primary Node Virtual Machine
6. Oracle RAC Video 7 - Configuring Network Settings For Primary Node
7. Oracle RAC Video 8 - Installing OEL 6.5 To Virtual Machine
8. Oracle Rac Video 9 - Creating Second Node
9. Oracle Rac Video 10 - Configuring Network Settings On Node 2
10. Oracle Rac Video 11 - Establishing Connectivity Between The Two Nodes
11. Oracle Rac Video 12 - Fixing Eth0 and Eth1 Connectivity Issues
12. Oracle Rac Video 13 - Installing Yum Packages
13. Oracle Rac Video 14 - Installing WinSCP
14. Oracle RAC Video 15 - Transferring Database and Grid Infrastructure Software Files Via WinSCP
15. Oracle RAC Video 16 - Configuring Private , VIP And Scan Name Ip's For Connectivity
16. Oracle RAC Video 17 - Configuring Shared Storage
17. Oracle RAC Video 18 - Partitioning Hard Disks For Both Nodes
18. Oracle RAC Video 19 - Creating ASM Disks From Partitions
19. Oracle RAC Video 20 - Configuring Grid Infrastructure Pre-Requisites
20. Oracle RAC Video 21 - Configuring SSH Utility
21. Oracle RAC Video 22 - Running Grid Infrastructure Pre Check
22. Oracle RAC Video 23 - Installing Grid Infrastructure
23. Oracle RAC Video 24 - Creating Diskgroups Via ASMCA
24. Oracle RAC Video 25 - Installing Oracle Software On Both Nodes
25. Oracle RAC Video 26 - Creating Oracle Database On Both Nodes
26. Oracle RAC Video 27 - Setting Up RAC Connection
27. Oracle RAC Video 28 - Different Ways To Connect To Rac DB
28. Oracle RAC Video 29 - How To Use Srvctl Utility
29. Oracle RAC Video 30 - How To Stop A Database On An Instance
30. Oracle RAC Video 31 - How To Stop A Database On All Instances
31. Oracle RAC Video 32 - How To Start A Database On A Local Instances
32. Oracle RAC Video 33 - How To Locate The Spfile On Shared Storage
33. Oracle RAC Video 34 - Creating A Pfile From An Spfile In Rac
34. Oracle Rac Video 35 - Changing Spfile Parameters On All Nodes
35. Oracle RAC Video 36 - Putting Your Database In Archivelog Mode
36. Oracle RAC Video 37 - Backing Up Your RAC Database
37. Oracle RAC Video 38 - Creating Backup Jobs For Your Database
38. Oracle RAC Video 39 - Backing Up Your Database WIth Tags
39. Oracle RAC Video 40 - Using The Global View
40. Oracle RAC Video 41 - Using CRSCTL Utility
41. Oracle RAC Video 42 - Using Olsnodes Utility To Check The Number Of Nodes
42. Oracle RAC Video 43 - Shutting Down The Clusterware Resources
43. Oracle RAC Video 44 - Shutting Down The Clusterware Resources On A Local Node
44. Oracle RAC Video 45 - Enabling High Availability Service
45. Oracle RAC Video 46 - Creating User Friendly OCR Copies
46. Oracle RAC Video 47 - Performing Manual OCR Backups
47. Oracle RAC Video 48 - Understanding The OLR File
48. Oracle RAC Video 49 - Understanding The Voting Disks
49. Oracle Rac Video 50 - Verifying The Status Of Node Applications Via SRVCTL
50. Oracle Rac Video 51 - Understanding ASM Basics
51. Oracle Rac Video 52 - Understanding ASMCMD Basics
52. Oracle Rac Video 53 - Creating Directories VIA ASMCMD
53. Oracle Rac Video 54 - Creating A Service on A Local Node
54. Oracle Rac Video 55 - Modifying A Service
55. Oracle Rac Video 56 - Enabling And Relocating Services
56. Oracle Rac Video 57 - Creating TNS Entry For Dynamic Services
57. Oracle Rac Video 58 - Testing A Dynamic Services
58. Oracle Rac Video 59 - Testing A Dynamic Services From RAC2 Back To RAC1
59. Oracle Rac Video 60 - How To Create A One Node RAC Database
60. Oracle Rac Video 61 - How To Start A Service On A One Node RAC DB On 12c Release 1
61. Oracle Rac Video 62 - How To Relocate A One Node RAC DB On 12c Release 1
62. Oracle Rac Video 63 - How To Convert A One Node DB To A RAC Database
63. Oracle Rac Video 64 - Creating A Multitenant RAC Database
64. Oracle Rac Video 65 - Different Ways Of Connecting To A Single Node A RAC Database
65. Oracle Rac Video 66 - Getting The Status Of A Rac Database
66. Oracle Rac Video 67 - Connecting To A Of A Multitenant RAC Database
67. Oracle Rac Video 68 - Connecting To A Multitenant PDB RAC Database
68. Oracle Rac Video 69 - Closing To A Multitenant PDB RAC Database On A Particular Node
69. Oracle Rac Video 70 - Closing To A Multitenant PDB RAC Database On All Nodes
70. Oracle Rac Video 71 - Cloning A Multitenant PDB RAC Database On All Nodes
71. Oracle Rac Video 72 - Connecting To A Cloned Multinentant PDB
72. Oracle Rac Video 73 - Creating A Service For A Multitenant PDB
73. Oracle Rac Video 74 - Dropping A Multitenant PDB Via SQLPlus
74. Oracle Rac Video 75 - Dropping A Multinentant PDB and CDB Via DBCA
75. Oracle Rac Video 76 - Creating Serverpools
76. Oracle Rac Video 77 - Creating Policy Managed Database
77. Oracle Rac Video 78 - Connecting To Your Policy Managed Database
78. Oracle Rac Video 79 - Creating Dynamic Services For Your Policy Managed PDB Database
79. Oracle Rac Video 80 - Creating Labels For Serverpools
80. Oracle Rac Video 81 - Displaying Serverpool Configuration
81. Oracle Rac Video 82 - Removing Serverpool Labels and Server Categories
82. Oracle Rac Video 83 - Removing A Node From A CLuster - Part 1
83. Oracle Rac Video 84 - Removing A Node From A Cluster - Removing Oracle Home - Part 2
84. Oracle Rac Video 85 - Removing A Node From A Cluster - Removing Clusterware - Part 3
85. Oracle Rac Video 86 - Removing A Node From A Cluster - Deleting Node From Clusterware - Part 4
86. Oracle Rac Video 87 - Adding Node Incomplete
87. Oracle Rac Video 88 - Connecting To ASM Instance
88. Oracle Rac Video 89 - Determining Which DIskgroups are in Use By ASM
89. Oracle RAC Video 90 - Determing Which ASM Disks Are Not Members Of A Diskgroup
90. Oracle RAC Video 91 - Creating A New Diskgroup Via ASM Instance - External Redundancy
91. Oracle RAC Video 92 - Adding A Disk To A Diskgroup Via ASM Instance
92. Oracle RAC Video 93 - Removing A Disk From A Diskgroup
93. Oracle RAC Video 94 - Creating A New Diskgroup Via ASM Instance - Normal Redundancy
94. Oracle RAC Video 95 - Renaming A Diskgroup
95. Oracle RAC Video 96 - Navigating ASMCMD Utility
96. Oracle RAC Video 97 - Getting ASM Version and Patch Information
97. Oracle RAC Video 98 - Using LSDG Command
98. Oracle RAC Video 99 - Using LSDSK Command
99. Oracle RAC 100 - Using The Find And IOStats Command
100. Oracle RAC Video 101 - Creating New Hard Disks From Scratch
101. Oracle RAC Video 102 - Adding Second Node To New Disk
102. Oracle RAC Video 103 - Using Fdisk To Create Partitions
103. Oracle RAC Video 104 - Stamping Disks With Oracle ASM
104. Oracle RAC Video 105 - Adding Disks To A Diskgroup via ASMCA
105. RAC PRACTICE SCRIPTS
1. Data Guard Class Lecture
2. Dataguard Pre-Installation Video 1
3. Dataguard Pre-Installation Part 2
4. Dataguard Pre-Installation Part 3
5. Dataguard Pre-Installation Part 4
6. Changing Modes In Dataguard Configuration part 1
7. Changing Modes In Dataguard Configuration part 2
8. Changing Modes In Dataguard Configuration part 3
9. Verifying Archived Logs Are Applying To Standby Database
10. Inserting Data Into Primary Database In a Datguard Environment
11. Converting From Standby to Snapshot Database
12. Converting From A Snapshot To A Physical Standby Database
13. Performing A Switchover From Primary To Standby
14. How To Resolve "Resolvable Gap Issues"
15. How To Perform A Switchover From Standby To Primary
16. How To Configure Data Broker
17. Changing Protection Modes Via Data Guard Broker
18. Performing A Switch Over Via Databroker
19. DATAGUARD CONFIGURATION SCRIPTS
1. 12c Backup Video 1 - How To Uninstall The Oracle Software and Database
2. 12c Backup Video 2 - How To Install The Oracle Software and Create A Database
3. 12c Backup Video 3 - Understanding The Bash Profile
4. 12c Backup Video 4 - Different Ways To Connect To Recovery Manager
5. 12c Backup Video 5 - Creating A Dedicated User To Connect To Recovery Manager
6. 12c Backup Video 6 - Configuring Basic Rman Settings
7. 12c Backup Video 7 - Configuring Archive Log Mode
8. 12c Backup Video 8 - Performing A Consistent Backup Plus Archivelog
9. 12c Backup Video 9 - Backing Up Multiple Tablespaces
10. 12c Backup Video 10 - Listing Options In RMAN
11. 12c Backup Video 11 - Performing A Hot Backup In RMAN
12. 12c Backup Video 12 - Specifying A Backup Location
13. 12c Backup Video 13 - Determining Space Allocation In The FRA
14. 12c Backup Video 14 - Backing Up The Controlfile
15. 12c Backup Video 15 - Backing Up The Database With Tags
16. 12c Backup Video 16 - Perfoming Image Copy Backups
17. 12c Backup Video 17 - Changing Controlfile Record Keep Time
18. 12c Backup Video 18 - Performing Incremental Level Backups With Tags
19. 12c Backup Video 19 - Enabling Change Tracking
20. 12c Backup Video 19 - Enabling Change Tracking2
21. 12c Backup Video 20 - Scheduling A job With Cron
22. 12c Backup Video 21 - Setting Retention Policy In RMAN
23. 12c Backup Video 22 - Changing Backup Destination With Configure Channel Command
24. 12c Backup Video 23 - Checking RMAN Job Details With Virtual Tables
25. 12c Backup Video 24 - Running OS and SQL Commands In RMAN
26. 12c Backup Video 25 - Running Crosscheck Backup Commands In RMAN
27. 12c Backup Video 26 - Running Report Need Backup In RMAN
28. 12c Backup Video 27 - Monitoring Backup Jobs In RMAN
29. 12c Backup Video 28 - Changing Compression Algorithm For RMAN Backup Jobs
30. 12c Backup Video 29 - Breaking Up Backups Into Multi Sections
31. 12c Backup Video 30 - Creating Recovery Catalog Database
32. 12c Backup Video 31- Catalog Backup Pieces
33. 12c Backup Video 32- Cataloging Multiple Backup Pieces
34. 12c Backup Video 33- Backing Up The Fast Recovery Area
35. 12c Backup Video 34- Creating An E-Wallet For Your Backups
36. 12c Backup Video 35- Creating An Auto-Login Keystore
37. 12c Backup Video 36- Creating A Password Encryption Backup Set
38. 12c Backup Video 37- Creating A Dual Mode Encryption Backup Set
39. 12c Backup Video 38- Restore Database In No Archive Log Mode
40. 12c Backup Video 39- Restore All Datafiles In Archive Log Mode
41. 12c Backup Video 40- Restore Non-System Tablespace In Archive Log Mode
42. 12c Backup Video 41 - Saving Your DBID
43. 12c Backup Video 42 - Restoring Tablespace With Image Copy Backup
44. 12c Backup Video 43- Performing PITR After Data Loss
45. 12c Backup Video 44- Performing PITR After Data Loss IF Time Unknown
46. 12c Backup Video 45- Performing PITR Of A Tablespace
47. 12c Backup Video 46- Performing PITR Of A Table With Users Still Inserting Data
48. 12c Backup Video 47- Create Spfile From Memory
49. 12c Backup Video 48- Create Spfile From Pfile
50. 12c Backup Video 49- Restore Spfile From Autobackup
51. 12c Backup Video 51- Recreating A Lost Inactive RedoLog Member
52. 12c Backup Video 52- Recreating A Lost RedoLog Group
53. 12c Backup Video 53- Recreating A Lost RedoLog Group In Active Database
54. 12c Backup Video 54- Recreating Lost Members In An Active RedoLog Group
55. 12c Backup Video 55- Recreating Lost Members In A CUURENT RedoLog Group
56. 12c Backup Video 56- Recovery From Los Of Your Non - System Datafile
57. 12c Backup Video 57- Recovery From Loss Of Password File
58. 12c Backup Video 59- Recovering A Tablespace From Encrypted Backup
59. 12c Backup Video 60- Restoring A New Database From A Backupset
60. 12c Backup Video 61- Using Data Recovery Advisor
61. 12c Backup Video 62 - Recovery From Corrupted Blocks
62. 12c Backup Video 63 -Duplicating An Active Database
63. 12c Backup Video 64 -Creating An Auxiliary DB From Recovery Catalog Without The Source DB
64. 12c Backup Video 64 -Duplicating An Active Database With A Backupset
65. 12c Backup Video 66 -Creating A Duplicate db Without Recovery Catalog Or Active Database
66. 12c Backup Video 67- Creating A CONTAINER DB And PLUGGABLE DB
67. 12c Backup Video 68- Registering CONTAINER DB And PLUGGABLE DB With Listener and TNSNames
68. 12c Backup Video 69- Backing Up The Container Database
69. 12c Backup Video 70- Backing Up The Pluggable Database
70. 12c Backup Video 71- Backing Up The Tablespace In A Pluggable Database
71. 12c Backup Video 72- Restoring A Container Datafile
72. 12c Backup Video 73- Restoring A Pluggable Datafile
73. 12c Backup Video 58- Recovering From Lost Tempfile
1. Downloading XMING Software
2. Downloading Putty Software
3. Installing Your Virtual Machine Video 1
4. Oracle RAC Video 1 - How To Download Linux 6.5 ISO File
5. Oracle GG Video 5 - Download Oracle Software From Edelivery Platform
6. Oracle Dataguard Video 1 - How To Create A New VM For The Primary Server Part 1
7. Oracle Dataguard Video 2 - How To Create A New VM For The Primary Server Part 2
8. Oracle GG Video 9 - HOw To Create A New VM For The Target Server Part 2a
9. Oracle GG Video 10 - How To Create A New VM For The Source Server Part 3a
10. Oracle GG Video 11 - How To Create A New VM For The Target Server Part 3a
11. Oracle Dataguard Video 6 - Adding Oracle User To Primary VM
12. Oracle Dataguard Video 8 - Adding Oracle User To Standby VM
13. Oracle GG Video 13 - Adding Oracle User To Target VM a
14. Oracle Dataguard Video 14 - Saving Your Machine State
15. Oracle Dataguard Video 15 - Configuring IP Address For Primary VM
16. Oracle GG Video 16 - Configuring IP Address For Target VMa
17. Oracle GG Video 17 - Installing YUM updates and Downloading Oracle Software on Source Server
18. Oracle GG Video 18 - Setting Up Communication Between The Primay and Standby VM'sa
19. Oracle GG Video 19 - Installing YUM updates and Downloading Oracle Software on Target Server
20. Oracle GG Video 20 - Installing Oracle Database on Source Server
21. Oracle GG Video 21 - Installing Oracle Database on Target Server
22. Oracle GG Video 22 - Installing Oracle GoldenGate Software For Edelivery Site
23. Oracle GG Video 23 - Copying Oracle GoldenGate Software Zip Files To VM's
24. Oracle GG Video 25 - Installing Oracle Golden Gate Software on Source and Target Servers
25. Oracle GG Video 26 - Adding Entries In The Bash Profile For Both Servers
26. Oracle GG Video 27 - Configuring Golden Gate Supplemental Logging For Both Servers
27. Oracle GG Video 28 - Configuring The Golden Gate Master User For Replication
28. Oracle GG Video 29 - Granting Admin Privileges To Golden Gate Master User For Replication
29. Oracle GG Video 30 - Adding Parameters In The Manager Process
30. Oracle GG Video 31 - Starting The Manager Process
31. Oracle GG Video 32 - Creating A Basic Table For Replication On Both Servers
32. Oracle GG Video 33 - Connecting To GG Via Master User
33. Oracle GG Video 34 - Adding Table Level Logging and Creating An Extract Process
34. Oracle GG Video 35 - Adding A Trail File Locaton For Extract Process
35. Oracle GG Video 36 - Creating Parameter File For Extra Process
36. Oracle GG Video 37 - Creating A Datapump Process
37. Oracle GG Video 38 - Creating A Remote Trail For The Datapump Process
38. Oracle GG Video 39 - Creating A Parameter File For The Datapump Process
39. Oracle GG Video 40 - Creating The Replicat Process
40. Oracle GG Video 41 - Creating Parameters For The Replicat Process
41. Oracle GG Video 42 - Starting Golden Gate Processes on Source Server
  FREE PREVIEW
42. Oracle GG Video 43 - Starting Golden Gate Replicat Processes on Target Server
43. Oracle GG Video 44 - Basic Replication Unifnished
44. Oracle GG Video 45 - Performance Tuning - Fixing Replication Issues
45. Oracle GG Video 46 - Fixing Performance Issues - Handle Collission Clause
46. Oracle GG Video 47 - Issuing Delete In Golden Gate
47. Oracle GG Video 48 - Issuing Insert In Golden Gate
48. Oracle GG Video 49 - Issuing Updates In Golden Gate
49. Oracle GG Video 50 - Golden Gate Basic Command - Info All and Help Command
50. Oracle GG Video 51 - Golden Gate Command - Detail Flag
51. Oracle GG Video 52 - Golden Gate Basic Command - View Parameters
52. Oracle GG Video 53 - Golden Gate Basic Commands - Stats
53. Oracle GG Video 54 - Single Table Initial Load Part 1
54. Oracle GG Video 55 - Single Table Initial Load Part 2
55. Oracle GG Video 56 - Single Table Initial Load - Adding Initial Load Extract - Part 3
56. Oracle GG Video 57 - Single Table Load Part 4 - Performing Change Synch and Initial Load Extract
57. Oracle GG Video 58 - Performing Replication With Different Schema Definitions Part 1
58. Oracle GG Video 59 - Performing Replication With Different Schema Definitions Part 2
59. Oracle GG Video 60 - Performing Replication With Different Schema Definitions Part 3
60. Oracle GG Video 61 - Performing Replication With Different Schema Definitions Part 4
61. Oracle GG Video 62 - Performing Replication With Different Schema Definitions Part 5
62. Oracle GG Video 63 - Performing Delete Operation On Schemas With Columns
63. Performing Update Operation On Tables With Data Mapped To Diff Columns
64. Oracle GG Video 65 - Data Mapping To Columns With Different Names Part 1
65. Oracle GG Video 66 - Data Mapping To Columns With Different Names Part 2
66. Oracle GG Video 65 - Data Mapping To Columns With Different Names Part 1
67. Oracle GG Video 66 - Data Mapping To Columns With Different Names Part 2
68. Oracle GG Video 67 - Updating Data Mapped To Columns With Different Names Part 3
69. Oracle GG Video 68 - Golden Gate Filter Functions - Understanding Case Filter
70. Oracle GG Video 69 - Golden Gate Filter Functions - Understanding Eval Filter
71. Oracle GG Video 70 - Golden Gate Filter Functions - Understanding IF Filter
72. Oracle GG Video 71 - Golden Gate Filter Functions - Understanding DATENOW Filter
73. Oracle GG Video 72 - Golden Gate Filter Functions - Understanding DATEDIFF Filter
74. Oracle GG Video 73 - Golden Gate Filter Functions - Understanding COLSTAT Filter
75. Oracle GG Video 74 - Golden Gate Filter Functions - Understanding COLTEST Filter
76. Oracle GG Video 75 - Golden Gate Filter Functions - Understanding NUMSTR Filter
77. Oracle GG Video 76 - Golden Gate Filter Functions - Understanding STRNUM Filter
78. Oracle GG Video 77 - Golden Gate Filter Functions - Understanding STRUP Filter
79. Oracle GG Video 78 - Golden Gate Filter Functions - Understanding COMPUTE Filter
80. Oracle GG Video 79 - Golden Gate - Setting Up DDL Replication
81. Oracle GG Video 80 - Golden Gate - Performing DDL Transactions
82. Oracle GG Video 81 - Golden Gate - SCHEMA Replication
83. Oracle GG Video 82 - Golden Gate - DDL AND DML SCHEMA REPLICATION
84. Oracle GG Video 83 - Golden Gate - Bidirectional Replication
85. Oracle GG Video 84 - Golden Gate - Trouble Shooting Abended Processes
86. Oracle GG Video 85 - Golden Gate - Confirming Bi-Directional Replication
87. Oracle GG Video 86 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 1
88. Oracle GG Video 87 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 2
89. Oracle GG Video 88 - Golden Gate - Upgrade Golden Gate Software From 12.1.0.2 to 12.2.0.2 Part 3
90. GOLDEN GATE BI-DIRECTIONAL PART 1
91. GOLDEN GATE BI-DIRECTIONAL PART 2
92. GOLDEN GATE EXPRESSIONS
1. Oracle SQL Tuning Video 1 - Setting Up PLUSTRACE ROLE For Users
2. Oracle SQL Tuning Video 2 - Understanding Autotrace Features
3. Oracle SQL Tuning Video 3 - Displaying Exaplain Plan Only
4. Oracle SQL Tuning Video 4 - Displaying Auto trace Stats Only
5. Oracle SQL Tuning Video 5 - Displaying Autot Trace Only
6. Oracle SQL Tuning Video 6 - Reading Directly From The DBMS_XPLAN.DISPLAY Table
7. Oracle SQL Tuning Video 7 - How to Display Execution Plan From Cursor Cache
8. Oracle SQL Tuning Video 8 - How to Display Execution PlanUsing SQL ID
9. Oracle SQL Tuning Video 9 - How to Display Execution From SQLDEVELOPER
10. Oracle SQL Tuning Video 10 - Understanding The Optimizer
11. Oracle SQL Tuning Video 11 - Understanding Full Table Scans
12. Oracle SQL Tuning Video 12 - Access Path - Understanding Table Access By RowID
13. Oracle SQL Tuning Video 13 - Access Path - Understanding Sample Table Scan
14. Oracle SQL Tuning Video 14 - Access Path - Understanding Index Unique Scan
15. Oracle SQL Tuning Video 15 - Access Path - Understanding Index Full Scan
16. Oracle SQL Tuning Video 16 - Access Path - Understanding Index Fast Full Scan
17. Oracle SQL Tuning Video 17 - Access Path - Understanding Index Skip Scan
18. Oracle SQL Tuning Video 18 - Access Path - Understanding Index Join Scan
19. Oracle SQL Tuning Video 19 - Access Path - Understanding Bitmap Index Single Value
20. Oracle SQL Tuning Video 20 - Access Path - Understanding Bitmap Index Range Scan
21. Oracle SQL Tuning Video 21 - Access Path - Understanding Cluster Scan
22. Oracle SQL Tuning Video 22 - Access Path - Understanding Hash Scan
23. Oracle SQL Tuning Video 23 - Join Methods - Understanding Nested Loops
24. Oracle SQL Tuning Video 24 - Join Methods - Understanding Sort Merge Joins
25. Oracle SQL Tuning Video 25 - Join Methods - Understanding Cartesian Joins
26. Oracle SQL Tuning Video 26 - Join Methods - Understanding Hash Joins
27. Oracle SQL Tuning Video 27 - Join Types - Understanding Inner (Simple) Joins
28. Oracle SQL Tuning Video 28 - Join Types - Understanding Non-Equity Inner Joins
29. Oracle SQL Tuning Video 29 - Join Types - Understanding Left Outer Joins
30. Oracle SQL Tuning Video 30 - Join Types - Understanding Right Outer Joins
31. Oracle SQL Tuning Video 31 - Join Types - Understanding Full Outer Joins
32. Oracle SQL Tuning Video 32 - Join Types - Understanding SORT MERGE Joing part 2
33. Oracle SQL Tuning Video 33 - Understanding How To Influence The Optimizer
34. Oracle SQL Tuning Video 34 - Understanding Optimizer Goals
35. Oracle SQL Tuning Video 35 - Influencing The Optimizer - Access Path
36. Oracle SQL Tuning Video 36 - Influencing The Optimizer - Access Path (INDEX)
37. Oracle SQL Tuning Video 37 - Influencing The Optimizer - Access Path (INDEX FFS)
38. Oracle SQL Tuning Video 38 - Influencing The Optimizer - Access Path (JOIN ORDER)
39. Oracle SQL Tuning Video 39 - Influencing The Optimizer - Access Path (LEADING)
40. Oracle SQL Tuning Video 40 - Influencing The Optimizer - Access Path (NESTED LOOP)
41. Oracle SQL Tuning Video 41 - Influencing The Optimizer - Access Path (HASH JOIN)
42. Oracle SQL Tuning Video 42 - Influencing The Optimizer - Access Path (MERGE JOIN)
43. Oracle SQL Tuning Video 43 - Optimizer Statistics - Analyzing A Table
44. Oracle SQL Tuning Video 44 - Optimizer Statistics - Importance Of Gathering Table Statistics
45. Oracle SQL Tuning Video 45 - Optimizer Statistics - Querying Index Statistics
46. Oracle SQL Tuning Video 46 - Optimizer Statistics - Understanding Clustering Factor
47. Oracle SQL Tuning Video 47 - Optimizer Statistics - Understanding Clustering Factor part 2
48. Oracle SQL Tuning Video 48 - Column Statistics - Understanding Histograms
49. Oracle SQL Tuning Video 49 - Column Statistics - Purpose of Histograms
50. Oracle SQL Tuning Video 50 - Column Statistics - Understanding The Types of Histograms
51. Oracle SQL Tuning Video 51 - Column Statistics - Creating A Frequency Histogram
52. Oracle SQL Tuning Video 52 - Column Statistics - Creating A TOP Frequency Histogram
53. Oracle SQL Tuning Video 53 - Column Statistics - Creating A Height Balanced Histogram
54. Oracle SQL Tuning Video 54 - Column Statistics - Creating A Hybrid Histogram
55. Oracle SQL Tuning Video 55 - Optimizer Statistics - Refreshing Table Statistics
56. Oracle SQL Tuning Video 56 - Optimizer Statistics - Refreshing Schema Statistics
57. Oracle SQL Tuning Video 57 - Optimizer Statistics - Refreshing Table and Index Statistics
58. Oracle SQL Tuning Video 58 - Optimizer Statistics - Refreshing Database Statistics
59. Oracle SQL Tuning Video 59 - Undestanding The Difference Between Autotrace and Explain Plan
60. Oracle SQL Tuning Video 60 - Verifying That An Execution Plan Was Used
61. Oracle SQL Tuning Video 61 - Reading An Execution Plan
62. Oracle SQL Tuning Video 62 - Reading An Execution Plan pt 2
63. Oracle SQL Tuning Video 63 - Reading An Execution Plan pt 3
64. Optimizer Access Paths Script
65. Optimizer Join Methods
1. Classroom Lecture 1 - Introduction to PL/SQL
2. Classroom Lecture 2 - Difference btwn SQL AND PL/SQL
3. Classroom Lecture 3 - Anonymous Blocks
4. Classroom Lecture 4 Anonymous block
5. Classroom Lecture 4 Rules of anonymous Block
6. Classroom Lecture 5 - DBMS OUTPUT PUT LINE
7. Classroom Lecture 6 - Understanding Variables
8. Classroom Lecture 7 -- Making Comments
9. Classroom Lecture 8
10. Classroom Lecture 8 - Global and Local Variable
11. Classroom Lecture 9- IF THEN ELSIF
12. Classroom Lecture 10- IF THEN ELSE
13. Classroom Lecture 11- IF THEN ELSE
14. Classroom Lecture 12- What is WHILE Loop
15. Classroom Lecture 13 - What is FOR Loop
16. Classroom Lecture 14 - Fetching Data From the Database
17. Classroom Lecture 15- What is %TYPE
18. Classroom Lecture 16 - CASE
19. Classroom Lecture 17- Datatypes
20. Classroom Lecture 18 - Handling Literals
21. Classroom Lecture 19 - Bind Variable
22. Classroom Lecture 20 - Nested Blocks
23. Classroom Lecture 21 - Nested Blocks p2
24. Classroom Lecture 22 - Petting It Together
25. Classroom Lecture 23 - Cursors
26. Classroom Lecture 24 - Cursor Attributes
27. Classroom Lecture 25 - Composite Datatype
28. Classroom Lecture 26 - UPDATE SET ROW
29. Classroom Lecture 27 - Index by Table
30. Classroom Lecture 28 - Nested Tables
31. Classroom Lecture 29 - Nested Tables Extended
32. Classroom Lecture 30 - Index by Table of Record
33. Classroom Lecture 31 - Associative Array
34. Classroom Lecture 32 - Stored Procedure Syntax
35. Classroom Lecture 33 - Creating a Stored Procedure
36. Classroom Lecture 34 - IN parameters
37. Classroom Lecture 35 - Out Parameters
38. Classroom Lecture 36 - Calling a Stored Procedure
39. Classroom Lecture 37- IN OUT PARAMETERS
40. Classroom Lecture 38 - Adding Exceptions to functions
41. Classroom Lecture 39 - What is a package
42. Classroom Lecture 40 - Creating a package specification
43. Classroom Lecture 41 - How to create a package body
44. Oracle PLSQL Video 1- Installing 12c Oracle Database
45. Oracle PLSQL Video 2- Launching SQL Developer For 12c Oracle Database
46. Oracle PLSQL Video 3 - Numbering Your SQL Worksheet
47. Oracle PLSQL Video 4 - Highlighting Comments In Your SQL Worksheet
48. Oracle PLSQL Video 5 - Block Structure Fundamentals
49. Oracle PLSQL Lesson 6 - Turning On Server Output
50. Oracle PLSQL Lesson 7 - Variable Basics
51. Oracle PLSQL Lesson 8 - Variable Basics Pt 2
52. Oracle PLSQL Lesson 9 - Variable Naming Rules
53. Oracle PLSQL Lesson 10 - Datatypes
54. Oracle PLSQL Lesson 11 - Constants
55. Oracle PLSQL Lesson 12 - Dataypes contd
56. Oracle PLSQL Lesson 13 - Constants and Variables Combined
57. Oracle PLSQL Lesson 14 - TYPE attribute
58. Oracle PLSQL Lesson 15 - ROWTYPE attribute
59. Oracle PLSQL Lesson 16 - ROWTYPE attribute contd
60. Oracle PLSQL Lesson 17 -TYPE.. Table
61. Oracle PLSQL Lesson 18 - Understanding Records
62. Oracle PLSQL Lesson 19 - Creating Table Based Records
63. Oracle PLSQL Lesson 20 - Creating Table Based Records Part 2
64. Oracle PLSQL Lesson 21 - Creating A Cursor Based Record
65. Oracle PLSQL Lesson 22 - Creating User Defined Records
66. Oracle PLSQL Lesson 23 - User Defined TYPE.. Record
67. Oracle PLSQL Lesson 20 - Concatenating Variables
68. Oracle PLSQL Lesson 21 - Handling String Literals (')
69. Oracle PLSQL Lesson 22 - Handling String Literals (') CONTD
70. Oracle PLSQL Lesson 26 - IF THEN ELSIF
71. Oracle PLSQL Lesson 26 - IF THEN ELSIF
72. Oracle PLSQL Lesson 18 -TYPE.. Record
73. Oracle PLSQL Lesson 24 - IF THEN ELSE basics
74. Oracle PLSQL Lesson 23 - IF THEN basics
75. Oracle PLSQL Lesson 25 - IF THEN ELSE Basics part 2
76. Oracle PLSQL Lesson 27 - Calculating With Numberic Variables
77. Oracle PLSQL Lesson 29 - Bolean Datatype
78. Oracle PLSQL Lesson 28 - Date Variables
79. Oracle PLSQL Lesson 30 - Using Comparison Operators
80. Oracle PLSQL Lesson 26 - IF THEN ELSIF
81. Oracle PLSQL Lesson 36 - Using Comparison Operators with Records
82. Oracle PLSQL Lesson 37 - Using DML's With PLSQL
83. Oracle PLSQL Lesson 38 - Using DML's in PLSQL Script
84. Oracle PLSQL Lesson 39 - Creating Sequences
85. Oracle PLSQL Lesson 40 - GOTO and Labels
86. Oracle PLSQL Lesson 41 - For Loops Basics
87. Oracle PLSQL Lesson 42 - Reverse Loops Basics
88. Oracle PLSQL Lesson 43 - For Loops Basics part 2
89. Oracle PLSQL Lesson 44 - EXIT WHEN .. LOOP
90. Oracle PLSQL Lesson 45 - WHILE LOOP
91. Oracle PLSQL Lesson 46 - CASE Statement
92. Oracle PLSQL Lesson 46 - CASE STATEMENTS
93. Oracle PLSQL Lesson 47 - Basic CASE STATEMENT part 2
94. Oracle PLSQL Lesson 48 - Creating A Basic Stored Procedure
95. Oracle PLSQL Lesson 49 - INPUT Parameters In Stored Procedures
96. Oracle PLSQL Lesson 50 - Creating A Basic Stored Procedure part 2
97. Oracle PLSQL Lesson 51 - Creating Static Stored Procedures
98. Oracle PLSQL Lesson 52 - Undestanding When To Use Variables in Stored Procedures
99. Oracle PLSQL Lesson 53 - Creating Stored Procedures with OUTPUT Parameters
100. Oracle PLSQL Lesson 54 - FUNCTIONS Basics
101. Oracle PLSQL Lesson 55 - Creating Stored Procedures Via SQL Developer Pane
102. Oracle PLSQL Lesson 56 - Understanding Triggers
103. Oracle PLSQL Lesson 57 - Creating A Basic Trigger
104. Oracle PLSQL Lesson 58 - Statement Level Triggers
105. Oracle PLSQL Lesson 59 - BEFORE EVENT Triggers
106. Oracle PLSQL Lesson 60 - Passing New OLD parameters
1. Installing Postgresql
2. Getting the status of your postgres session
3. How to clear your screen
4. How to describe your table
5. How to get a list of all the schemas in the database
6. How to get a list of tables in your database
7. How to log into the database
8. How to quit a session
9. How to switch databases
10. Understanding difference btwn users and schemas
11. How to re-execute your last command
12. Adding data into a table from an outside source
13. Set autocommit off
14. Create a database
15. Dropping a database
16. Another way to create a database from the OS
17. Another way to drop a database from the OS
18. How to create a user from the OS
19. Granting super user privileges to a new user
20. How to create a new user with super user privileges
21. How to revoke public access to a database from the public
22. Creating and dropping a schema
23. How to create a user from the OS Interactively
24. Grant a user the ability to connect to a database
25. Understanding the Postgresql Home vs Oracle DB Home
26. Understanding the Postgresql Auto Conf
27. Understanding Postgres Configuration Files
28. Understanding the pg identity conf file
29. Understanding the pg hba conf file
30. UNDERSTANDING PG CATALOGS
31. How to reset parameter settings back to default
32. How to view your parameter settings in the Postgresql.conf file
33. Creating tables
34. Creating tables with constraints
35. Performing DML's on tables
36. Understanding Table Inheritance
37. Creating a copy of a table
38. Creating Tablesapces
39. Moving tables from one tablesapce to another
40. Performing a Logical Backup
41. Performing a Logical Backup of the cluster
42. Compressing a Logical backup
43. Restoring a DB
44. Restoring a table from a Logical Backup
45. Performing an offline backup
46. Enabling Archive log mode
47. Performing an online backup
48. Performing an online backup of cluster with pg basebackup
49. Updating optimizer statistics via analyze command
50. Understandin bloating and data fragmentation
51. Difference btwn VACCUM and VACCUM FULL
52. Understanding MVCC and AUTO Vaccum
53. Difference btwn DML, Vaccum and Vaccum full
54. How to re-index a bloated index
55. How to adjust the analyze setting in the pg_setting table
56. Creating a clustered table based on an index
57. How to connect to PGAdmin4 user interface
58. How to Uninstall the Postgresql
59. Understanding the Postgresql CONF file vs SPFILE
1. Logging Into AWS Console
2. Signing Up For A New AWS Console
3. Getting Familiar With AWS Console
4. Identify Access Management Initial Setup
5. Creating Billing Alarms
6. Creating AWS Organizations
7. Grant Access To Users In A Different Account
8. Cross Region Replication
9. Creating An S3 Bucket
10. Steps To Deleting An S3 Bucket
11. Steps To Uploading Files Into An S3 Bucket
12. Granting Permission on S3 Bucket Objects
13. Granting Permission on S3 Bucket Objects Part 2
14. Granting Permission on S3 Bucket Objects Part 3
15. Creating Lifecycle Rules
16. Understanding Bucket Versioning
17. Enabling Bucket Versioning
18. Enabling Bucket Versioning
19. Understanding the Unique ID for Bucket Versioning
20. Bucket Versioning- Delete A File and Updating Storage Class
21. Encrypting Your Bucket and Files
22. Creating Users In The AWS Console
23. How To Log In As A New IAM User
24. Delete An IAM User Via AWS Console
25. How To Download The csv file After Creating Users
26. Setting Up Environmental Variables
27. How to Email A New User Account Credentials
28. Installing AWS Command Line Interface
29. Configuring and Completing AWI CLI
30. Setting Up Environmental Variables
31. AWS CLI Man Page Basics
32. AWS CLI Command Basics - Using Different Text Outputs
33. AWS CLI Command Basics - Using the Help Command
34. Creating and Using a Key Pair
35. Creating and Launching a New Instance
36. Creating a New Key Pair Using AWS CLI
37. Deleting an EC2 Instance Using AWS CLI
38. Creating an S3 Bucket Using AWS CLI
39. Creating an S3 Bucket In A Different Region Using AWS CLI
40. Copying a File Into an S3 Bucket
41. Moving a File Into an S3 Bucket
42. Moving a File From an S3 Bucket To Local Storage
43. Synchronizing a File From a Local Storage To S3 Bucket
44. Synchronizing a File From a Local Storage To A Subfolder In an S3 Bucket
45. S3 Transfer Acceleration
46. Creating Cloud Front Distribution
47. Creating A Static Website
48. Removing a File From an S3 Bucket Using AWS CLI
49. Creating A Lifecycle Policy For Objects In a Bucket
50. Creating A Lifecycle Policy to Permanently Delete Objects in A Bucket
51. Creating Pre-Signed URLs
52. Creating Pre-signed URLs With 60 Sec Expiration
53. Creating A Group
54. Creating A User And Assigning User To A Group
55. Logging In Via CLI With an IAM User Credentials
56. How To Replicate A Bucket From One Region To Another
57. How To Create A Bucket Policy
58. How To Create A Bucket Policy
59. How To Test A Bucket Policy
60. How To Delete A Bucket Policy
61. Configuring MFA Delete For S3 Buckets
62. Configuring MFA Delete For S3 Buckets part 2
63. Understanding IAM User Roles
64. Creating Restrictive Policies
65. Creating A Role
66. Attaching A Role To An Instance
67. Connecting To An Instance Via SSH
68. Creating A Custom VPC
69. Creating Custom Subnets
70. Creating Custom Route Tables
71. Creating Custom Internet Gateways
72. Connecting Internet Gateways To Subnet Automatically
73. Creating Instances Inside Subnets
74. Connecting To Public EC2s
75. Attempting To Connect To Private EC2s
76. Connecting To Private EC2s Via Public Ec2
77. Connecting To An EC2 Instance Remotely Part 2
78. Creating A NAT Gateway
79. Creating An EC2 Instance And Apache Web Page
80. Navigating Your EC2 Instance
81. Terminating Your EC2 Instance
82. Creating EBS Volumes
83. Creating New Snapshots and AMI's From An EBS Block Storage
84. Encrypting An EC2 Instance After Creation
85. Configuring EC2 Hybernation
86. Configuring CloudWatch For More Frequent Updates
87. AWS CLI - Launching An EC2 Instance From Scratch
88. AWS CLI - Creating New Tags For An EC2 Instance
89. AWS CLI - Searching For Instances By Instance Type
90. AWS CLI - Searching For Instances By AMI Type
91. AWS CLI - Stopping An EC2 Instance
92. AWS CLI - Terminating An EC2 Instance
93. Creating IAM Roles To Connect To An EC2 Instance
94. Using The Curl Command To Get Meta-Data Of An EC2 Instance
95. Creating Boot Strap Scripts For Your EC2 Instance
96. Creating An EFS File System For A Cluster of EC2 Instances
97. Creating An EFS File System For A Cluster of EC2 Instances p2
98. Creating And Installing An Oracle Database Instance
99. Fixing Connection Issues In An Oracle Database Instance
100. Modifying and Deleting A Oracle Database Instance
101. Creating And Installing A MYSQL Database Instance
102. Launching An EC2 Instance For MYSQL Database
103. Connecting To RDS MYSQL Instance From EC2 Instance
104. Launching An EC2 Instance For MYSQL Database
105. Connecting To RDS MYSQL Instance From EC2 Instance
106. Creating Databases and Tables Inside a MYSQL Instance
107. Creating a Dynamo Database
108. Creating an Amazon Redshift Database
109. Amazon Redshift- Uploading Data into an S3 Bucket
110. C Amazon Redshift- Creating Tables in Query Editor
111. Creating An Aurora Cluster DB
112. Amazon Redshift- Copying Files From S3 Bucket Into Redshift DB
113. Registering a New Domain On AWS
114. Configuring A Simple Routing Policy In Route 53
115. Configuring A Weighted Routing Policy In Route 53
116. Configuring A Latency Routing Policy In Route 53
117. Configuring Health Checks For EC2 Instances
118. Configuring A Geolocation Routing Policy In Route 53
119. Configuring A Multi-Value Routing Policy In Route 53
120. Configuring An Application Load Balancer For A Static Web Page
121. Configuring An Application Load Balancer For Ans Target Groups

About this course

$4,999.00
1050 lessons
164 hours of video content

Course Cost

$4,999.00

Get started now
2 x $2,500.00

Two Month Split Payment

Get started now
3 x $2,500.00

Three Month Split Payment

Get started now

Oracle DBATraining | QA Tester TrainingClouduversity

The Ultimate $200K/yr Remote Oracle/AWS Masters Course

Who is the target audience?

Course curriculum

Oracle 11g Database Administration

ORACLE 12C ADMINISTRATION

Oracle12c Real Application Clusters Classroom Lecture

Oracle 12C RAC Advanced

Oracle 12c Dataguard Classroom Lecture And Installation

Oracle 12c Advanced Backup and Recovery Strategies

ORACLE 12C GOLDEN GATE

Oracle 12c SQL Tuning Administration

Oracle 12c PLSQL Introductory Course

POSTGRES Administration

AWS Solutions Architect Advanced

About this course

Course Cost

$4,999.00

2 x $2,500.00

3 x $2,500.00