Oracle DBA 11g/12c - Database Administration for Junior DBA
- Descrição
- Currículo
- FAQ
- Revisões
Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.
‘Oracle 11g/12c DBA’ course follows a step by step methodology in introducing concepts and Demo’s to the students so that they can learn with ease.
If you want to become an Oracle Database Administrator(Oracle DBA), this course is right for you!!!!
Almost in every organization, you will find Database Administrator’s (DBA’s) to maintain the organization’s database. Becoming a good DBA depends on the knowledge you have in the overall architecture of Oracle Database.
In this course, I have covered both Oracle Database 11g and Oracle Database 12c so that you get to know the differences and can work in organizations, who are still in 11g.
Step by Step methodology followed is…
- Learn the fundamentals of database to set the stage for Oracle Architecture
- Understand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues).
- Install Oracle Database 11g & 12c (Manual method and using DBCA)
- Tablespace management to manage space to store the data.
- UNDO Tablespace management to manage undo space.
- REDO Log file management to manage redo space.
- Manage users and security
- Networking (Configuring Listeners and TNS entries)
- Understand various Data dictionary tables/views
- Diagnose issues using Diagnose data and generate packages for Oracle Support.
- Backup and Recovery (User Managed)
- Backup and Recovery (RMAN)
- Materialized Views
- Table Partitioning
- Project Work
Let’s start and I will take you step by step to lead your journey into the DBA world!!!
-
19Memory ArchitectureVídeo Aula
-
20Database Buffer CacheVídeo Aula
-
21Shared PoolVídeo Aula
-
22REDO log bufferVídeo Aula
-
23Large PoolVídeo Aula
-
24Java Pool and Streams PoolVídeo Aula
-
25Keep Buffer PoolVídeo Aula
-
26Recycle Buffer PoolVídeo Aula
-
27nK Buffer CacheVídeo Aula
-
28Program Global Area (PGA)Vídeo Aula
-
29Dedicated vs Shared DatabasesVídeo Aula
-
30PGA in a Shared EnvrionmentVídeo Aula
-
31Quiz Time!!!Questionário
-
34Software Download...Texto
-
35Virtual Machine InstallationVídeo Aula
-
36Linux InstallationVídeo Aula
-
37Oracle Software InstallationVídeo Aula
-
38Oracle Parameter FilesVídeo Aula
-
39Database creation - Manual Method DemoVídeo Aula
-
40Verify Database creationVídeo Aula
-
41Database creation using DBCA (Preferred option)Vídeo Aula
-
42Oracle Startup Steps...Vídeo Aula
-
43Oracle Shutdown methodsVídeo Aula
-
44Oracle 12c UpgradeVídeo Aula
-
45How data is stored in a Database?Vídeo Aula
-
46Tablespace ConceptsVídeo Aula
-
47Online and Offline TablespacesVídeo Aula
-
48Let's create a Tablespace...Vídeo Aula
-
49Let's add more space to the Database...Vídeo Aula
-
50Tablespace Demo 1Vídeo Aula
-
51Tablespace Demo 2Vídeo Aula
-
52Tablespaces with different block sizesVídeo Aula
-
53Temporary Tablespace ManagementVídeo Aula
-
54Temporary Tablespace GroupsVídeo Aula
-
55Extent Management (Local vs Dictionary managed)Vídeo Aula
-
68User Management ConceptsVídeo Aula
-
69User Management Demo 1Vídeo Aula
-
70User Management Demo 2Vídeo Aula
-
71User Creation ExerciseTexto
-
72PrivilegesVídeo Aula
-
73System Privileges DemoVídeo Aula
-
74Object Privileges DemoVídeo Aula
-
75Revoking User PrivilegesVídeo Aula
-
76Revoking System PrivilegesVídeo Aula
-
77Revoking Object PrivilegesVídeo Aula
-
78Let's practice what we learnt so far...Vídeo Aula
-
79Role Management ConceptsVídeo Aula
-
80Role Management DemoVídeo Aula
-
81User ProfilesVídeo Aula
-
82User Profile DemoVídeo Aula
-
83Managing Passwords using ProfilesVídeo Aula
