- Description
- Curriculum
- Reviews
Introduction to Oracle DBA Training
Laraonlinetraining Oracle DBA Training is designed for professionals who aspire to grow their careers in Oracle database administration. Our industry experts covered all the concepts that satisfy the real-time requirements for beginner and advanced levels.
The DBA concepts like multi-tenant architecture, Containers Naming, Pluggable database, PDB Structures, Cloning PDB, and Changing a PDB Mode.
Trainees will work on two real-time projects to acquire hands-on knowledge of local temporary tablespaces, local schemas, revoking roles, creating non-shared objects, Partial PDB backup, Flashback CDB, heat map, and archiving solutions.
Database administration has become a very important job role in organizations since data has become an integral asset of any company. Enterprises have started to invest heavily in database administration and its related fields, such as information security and assurance management.
Database administrators are responsible for the proper organization and storage of the company’s data, which is why they prefer hiring certified working professionals to meet their demands.
Why Should I choose Lara Online Training?
- Laraonlinetraining provide very in-depth course material with real time scenarios for each topic with its Solutions for Oracle DBA Training.
- We also provide production case studies during the training.
- Schedule the sessions based upon your comfort by our Highly Qualified Trainers and Real-time Experts.
- Get the Class recordings, immediately after the session for further Reference.
- Avail flexibility with Normal Track, Fast Track, and Weekend Batches also for Oracle DBA Training.
- Cost Effective and Flexible Payment Schemes.
- 100% Placement assistance
- We provide Assessment and Mock Interviews
-
6New Multitenant Architecture: BenefitsText lesson
-
7Other Benefits of Multitenant ArchitectureText lesson
-
8Multitenant Container DatabaseText lesson
-
9Separating SYSTEM and User DataText lesson
-
10Naming the ContainersText lesson
-
11Provisioning a Pluggable DatabaseText lesson
-
12Basics of Multitenant Container Database and Pluggable DatabasesText lesson
-
13Interacting Within Multitenant Container DatabaseText lesson
-
14Exploring CDB Architecture and StructuresText lesson
-
15Steps to Create a Multitenant Container DatabaseText lesson
-
16Creating a Multitenant Container Database Using SQL*PlusText lesson
-
17Exploring CDB and PDB StructuresText lesson
-
18Create New PDB from PDB$SEEDText lesson
-
19With FILE_NAME_CONVERTText lesson
-
20Without FILE_NAME_CONVERTText lesson
-
21Cloning PDB within the Same CDBText lesson
-
22Plugging a Non-CDB into a CDBText lesson
-
23Dropping a PDB (optional)Text lesson
-
24Plug Unplugged PDB in to CDBText lesson
-
25Starting Up a CDB InstanceText lesson
-
26Mounting a CDBText lesson
-
27Opening a CDBText lesson
-
28Opening a PDBText lesson
-
29Closing a PDBText lesson
-
30Shutting Down a CDB InstanceText lesson
-
31Creating after Startup Trigger to Open All PDBsText lesson
-
32Changing PDB ModeText lesson
-
33Changing PDB Mode with SQL DeveloperText lesson
-
34Instance Parameter Changes and its Impact on PDBsText lesson
-
35Creating Permanent Tablespaces in a CDBText lesson
-
36Assigning Default TablespacesText lesson
-
37Creating Local Temporary TablespacesText lesson
-
38Assigning Default Temporary TablespacesText lesson
-
39Users, Roles, and PrivilegesText lesson
-
40Local Users, Roles, and PrivilegesText lesson
-
41Creating a Local UserText lesson
-
42Common UsersText lesson
-
43Creating a Common UserText lesson
-
44Common and Local Schemas / UsersText lesson
-
45Common and Local PrivilegesText lesson
-
46Granting and Revoking PrivilegesText lesson
-
47Creating Common and Local RolesText lesson
-
48Granting Common or Local Privileges / Roles to RolesText lesson
-
49Granting Common and Local Roles to UsersText lesson
-
50Granting and Revoking RolesText lesson
-
51Creating Shared and Non-Shared ObjectsText lesson
-
59Media Failure: CDB or PDB Temp File RecoveryText lesson
-
60Media Failure: PDB Temp File RecoveryText lesson
-
61Media Failure: Control File LossText lesson
-
62Media Failure: Redo Log File LossText lesson
-
63Media Failure: Root SYSTEM or UNDO Data FileText lesson
-
64Media Failure: Root SYSAUX Data FileText lesson
-
65Media Failure: PDB SYSTEM Data FileText lesson
-
66Media Failure: PDB Non-SYSTEM Data FileText lesson
-
67Media Failure: PITRText lesson
-
68Flashback CDBText lesson
-
69Special SituationsText lesson
-
70Creating a control file backup scriptText lesson
-
71Enabling Heat Map.Text lesson
-
72Automatic Data Optimization – Creating a TIER PolicyText lesson
-
73Automatic Data Optimization – Creating a COMPRESS PolicyText lesson
-
74Cleanup ADO Policies and Heat Map StatisticsText lesson
-
75Moving Data File OnlineText lesson
-
76In-Database Archiving and Temporal ValidityText lesson
-
77Archiving ChallengesText lesson
-
78Archiving SolutionsText lesson
-
79In-Database Archiving: HCCText lesson
-
80Archiving Challenges and SolutionsText lesson
-
81In-Database ArchivingText lesson
-
82ORA_ARCHIVE_STATE columnText lesson
-
83Session Visibility ControlText lesson
-
84Disable Row-ArchivalText lesson
-
85PERIOD FOR Clause ConceptText lesson
-
86Filtering on Valid-Time ColumnsText lesson
-
87Types of AuditingText lesson
-
88Audit Trail ImplementationText lesson
-
89Oracle Database 12c AuditingText lesson
-
90Enabling Unified AuditingText lesson
-
91Auditing Data Pump ExportText lesson
-
92Auditing RMAN BackupsText lesson
-
93Unified Audit ImplementationText lesson
-
94Security RolesText lesson
-
95Security SYS Auditing 9-21Text lesson
-
96Simplicity Audit Policy 9-22Text lesson
-
97Creating the Audit PolicyText lesson
-
98Creating the Audit Policy with Object-Specific ActionsText lesson
-
99DBMS_FLASHBACK_ARCHIVEText lesson
-
100New Administrative PrivilegesText lesson
-
101New Administrative Privilege SYSBACKUPText lesson
-
102New Administrative Privilege SYSDGText lesson
-
103New Administrative Privilege SYSKMText lesson
-
104OS Authentication and OS GroupsText lesson
-
105Password Authentication for SYSBACKUPText lesson
-
106Password Authentication for SYSDGText lesson
-
107New System Privilege PURGE DBA_RECYCLEBIN 10-19Text lesson
-
108Creating Policies Database and Role AnalysisText lesson
-
109Creating Policies Context AnalysisText lesson
-
110Analyzing and ReportingText lesson
-
111SYSTEM and OBJECT Used PrivilegesText lesson
-
112Used Privileges ResultsText lesson
-
113Compare Used and Unused PrivilegesText lesson
-
114Full Transportable Export/Import OverviewText lesson
-
115Full Transportable Export/Import UsageText lesson
-
116Full Transportable Export/Import ExampleText lesson
-
117Plugging a Non-CDB into CDB Using Data PumpText lesson
-
118Plugging a Non-CDB into CDB Using ReplicationText lesson
-
119Transporting a Database over the Network ExampleText lesson
-
120Disabling Logging for Oracle Data Pump Import OverviewText lesson
-
121Disabling Logging for Oracle Data Pump Import UsageText lesson
-
122Disabling Logging for Oracle Data Pump Import Command-Line ExamplesText lesson
-
123Exporting Views as Tables OverviewText lesson
-
124Exporting Views as Tables UsageText lesson
-
125Exporting Views as Tables Command-Line ExamplesText lesson
-
126Specifying the Encryption PasswordText lesson
-
127Compressing Tables during ImportText lesson
-
128SQL*Loader and External Table EnhancementsText lesson
-
129Backing Up and Restoring Very Large FilesText lesson
-
130RMAN Duplication EnhancementsText lesson
-
131Duplicating an Active DatabaseText lesson
-
132What Is New?Text lesson
-
133The NOOPEN OptionText lesson
-
134Duplicating Pluggable DatabasesText lesson
-
135Recovering Databases with Third-Party SnapshotsText lesson
-
136Transporting Data across PlatformsText lesson
-
137Data TransportText lesson
-
138Transporting Database Process StepsText lesson
-
139Transporting Tablespace Process StepsText lesson
-
140Table RecoveryText lesson
-
141Recovering Tables from BackupsText lesson
-
142Specifying the Recovery Point-in-TimeText lesson
-
143Process Steps of Table RecoveryText lesson
-
160Start and stop the Oracle database and componentsText lesson
-
161Use Oracle Enterprise ManagerText lesson
-
162Access a database with SQLPlusText lesson
-
163Modify database installation parametersText lesson
-
164Describe the stages of database startupText lesson
-
165Describe database shutdown optionsText lesson
-
166View the alert logText lesson
-
167Access dynamic performance viewsText lesson
-
171Storage StructuresText lesson
-
172How Table Data Is StoredText lesson
-
173Anatomy of a Database BlockText lesson
-
174Space Management in TablespacesText lesson
-
175Tablespaces in the Preconfigured DatabaseText lesson
-
176Actions with TablespacesText lesson
-
177Oracle Managed Files (OMF)Text lesson
-
195Describe DBA responsibilities for securityText lesson
-
196Enable standard database auditingText lesson
-
197Specify audit optionsText lesson
-
198Review audit informationText lesson
-
199Maintain the audit trailText lesson
-
200Manage optimizer statisticsText lesson
-
201Manage the Automatic Workload Repository (AWR)Text lesson
-
202Use the Automatic Database Diagnostic Monitor (ADDM)Text lesson
-
203Describe and use the advisory frameworkText lesson
-
204Set alert thresholdsText lesson
-
205Use server-generated alertsText lesson
-
206Use automated tasksText lesson
-
207Performance MonitoringText lesson
-
208Managing Memory ComponentsText lesson
-
209Enabling Automatic Memory Management (AMM)Text lesson
-
210Automatic Shared Memory AdvisorText lesson
-
211Using Memory AdvisorsText lesson
-
212Dynamic Performance StatisticsText lesson
-
213Troubleshooting and Tuning ViewsText lesson
-
214Invalid and Unusable ObjectsText lesson
-
215Backup Solutions: OverviewText lesson
-
216Oracle Secure BackupText lesson
-
217User-Managed BackupText lesson
-
218TerminologyText lesson
-
219Recovery Manager (RMAN)Text lesson
-
220Configuring Backup SettingsText lesson
-
221Backing Up the Control File to a Trace FileText lesson
-
222Monitoring the Flash Recovery AreaText lesson
-
223Opening a DatabaseText lesson
-
224Data Recovery AdvisorText lesson
-
225Loss of a Control FileText lesson
-
226Loss of a Redo Log FileText lesson
-
227Data Recovery AdvisorText lesson
-
228Data FailuresText lesson
-
229Listing Data FailuresText lesson
-
230Data Recovery Advisor ViewsText lesson
-
235Identify situations that require RMAN recovery catalogText lesson
-
236Create and configure a recovery catalogText lesson
-
237Synchronize the recovery catalogText lesson
-
238Create and Use RMAN stored scriptsText lesson
-
239Back up the recovery catalogText lesson
-
240Create and use a virtual private catalogText lesson
-
244Create image file backupsText lesson
-
245Create a whole database backupText lesson
-
246Enable fast incremental backupText lesson
-
247Create duplex backup and back up backup setsText lesson
-
248Create an archival backup for long-term retentionText lesson
-
249Create a multisection, compressed and encrypted backupText lesson
-
250Report on and maintain backupsText lesson
-
251Recover from a lost TEMP file and redo log groupText lesson
-
252Recover from the loss of password fileText lesson
-
253Perform user-managed complete and incomplete database recoveryText lesson
-
254Perform user-managed and server managed backupsText lesson
-
255Identify the need for backup modeText lesson
-
256Back up and recover a control fileText lesson
-
257Perform complete recovery from a critical or noncritical data file loss using RMANText lesson
-
258Perform the incomplete recovery using RMANText lesson
-
259Recover using incrementally updated backupsText lesson
-
260Switch to image copies for fast recoveryText lesson
-
261Restore a database onto a new hostText lesson
-
262Recover using a backup control fileText lesson
-
263Using RMAN to Duplicate a DatabaseText lesson
-
264Creating a duplicate databaseText lesson
-
265Using a duplicate databaseText lesson
-
269Database Architecture and ASMText lesson
-
270Describe Automatic Storage Management (ASM)Text lesson
-
271Set up initialization parameter files for ASM and database instancesText lesson
-
272Start up and shut down ASM instancesText lesson
-
273Administer ASM disk groupsText lesson
-
274Storage FundamentalsText lesson
-
275ASM ConceptsText lesson
-
276Preparing ASM StorageText lesson
-
277ASM Instance setupText lesson
-
278ASM disk group failure groups (Redundancy)Text lesson
-
279Managing DiskgroupsText lesson
-
280Backing up DiskgroupsText lesson
-
281Monitoring DiskgroupsText lesson
-
282Creating a Database on ASMText lesson
-
283Managing Database on ASMText lesson
-
284Basic architectureText lesson
-
285Storage conceptsText lesson
-
286Backup StrategiesText lesson
-
287FLASH recovery areaText lesson
-
288RMAN ArchitectureText lesson
-
289RMAN backup componentsText lesson
-
290RMAN catalog and configurationText lesson
-
291RMAN CommandsText lesson
-
292Monitoring RMAN backupsText lesson
-
293Tuning RMAN jobsText lesson
-
294Restoring and recovering using RMANText lesson
-
295Database cloning using RMANText lesson
-
296Troubleshooting RMAN issuesText lesson
-
297Best practicesText lesson
Excellent rating
Based on 16 reviewsTrustindex verifies that the original source of the review is Google. It was great working and learning experience with krish on scripting issue. Communication with Management is very responsive and helpful and special thanks to krish for his patience. sujith BTrustindex verifies that the original source of the review is Google. Trainer explained well.completed all topics and helped in technical issues Laxmi MTrustindex verifies that the original source of the review is Google. Gulshan who is the trainer is very good at giving insights of the RPA and he is good on clearing all my doubts. The institute also helped me find the right trainer Srivalli Anand MakkapatiTrustindex verifies that the original source of the review is Google. Thank you so much, Mr. Kishore, for the online IT training. That was a great experience with you. I have learned a lot from you. You are a very knowledgeable person and helpful in answering questions. I appreciate your replies to me promptly through text messages or email. I understand you overall. Asif JafriTrustindex verifies that the original source of the review is Google. The explanation is excellent. Trainer explained with live examples and secenarios Eswar vakadaTrustindex verifies that the original source of the review is Google. Excellent experience. Kishore is a valuable resource, Lara online training should be proud of him. Nasir JavedTrustindex verifies that the original source of the review is Google. that was a best practice and I have learned alot new things. thank you kishore Muscle PassionTrustindex verifies that the original source of the review is Google. Thank you so much for give us such a great training I learn a lot and it adds value to my knowledge If got a job I should be able to do it without any trouble thanks. Mohammad Zahid_Qureshi