Oracle Advanced Database Administration for Experts

Focused View

25:08:05

0 View

1. Oracle Physical Storage Structures

1. Oracle Database Important Files.mp4

19:39

2. Identify Database Files.mp4

04:36

3. Storage Best Practices.mp4

12:13

2. Oracle Logical Storage Structures

1. Different Logical Structures.mp4

06:15

2. Inside Oracle Data Block.mp4

19:52

3. Extents in Oracle.mp4

04:47

4. Segments in Oracle.mp4

12:25

5. Tablespace in Oracle.mp4

04:05

3. Oracle Database Instance

1. What is Oracle Instance.mp4

06:31

2. Oracle Instance Duration.mp4

09:19

3. DB Startup & Shutdown.mp4

12:58

4. Oracle Instance Recovery.mp4

20:57

4. Database Tables and Tables Cluster

1. Database Schema and Objects.mp4

14:30

2. Tables in Database.mp4

10:13

3. Introduction to Table Cluster.mp4

14:22

4. Creating Tables Cluster.mp4

12:47

5. Tables Cluster Inside Database.mp4

02:57

5. Tables and Index Partitioning

1. Partitioning Overview.mp4

11:29

2. Partition Strategy.mp4

09:10

3. Range Partitioning.mp4

06:16

4. Create Table Partitions.mp4

14:55

5. Create Index Partitions.mp4

22:49

6. Advanced Database Management

1. Manual DB Creation.mp4

22:12

2. Tablespace Best Practicies.mp4

05:57

3. Find Tablespace Utilization.mp4

11:15

4. Tablespace Utilization.mp4

17:34

5. Tablespace Administration.mp4

26:10

7. Database Operating Best Practicies

1. Database Alerts.mp4

07:35

2. Special Implementation.mp4

06:51

3. Managing Environment.mp4

06:26

4. DB Troubleshooting Flow.mp4

10:14

8. Advance Database Networking

1. Introduction to Oracle Listener.mp4

16:19

2. Installing Oracle Client.mp4

09:45

3. Oracle Naming Methods.mp4

12:01

4. Troubleshoot DB Networking.mp4

11:34

9. Oracle Recovery Manager

1. Introduction to RMAN.mp4

59:05

2. RMAN Channels and Parallelism.mp4

40:10

10. Performing RMAN Backups

1. RMAN Backup Types.mp4

37:40

2. Taking RMAN Backups.mp4

01:23:39

3. RMAN Backups Best Practicies.mp4

07:26

11. RMAN Recovery Catalog

1. Introduction to Recovery Catalog.mp4

20:43

2. Recovery Catalog Configuration.mp4

34:36

12. Introduction to RMAN Recovery

1. RMAN Recovery Mechanism.mp4

03:37

2. RMAN Recovery Types.mp4

04:43

13. DB Recovery via RMAN DB FULL Backup

1. Recovery Scenarios.mp4

05:43

2. All Data Files Recovery.mp4

22:54

3. Control & Data Files Recovery.mp4

26:07

4. Recover Entire Database.mp4

32:01

5. Database Point-In-Time Recovery.mp4

12:47

14. DB Recovery Via RMAN Incremental Backup

1. Back to Basics.mp4

15:43

2. Incremental Recovery Overview.mp4

03:24

3. Recovery After Loss of All Datafiles.mp4

15:11

4. Database PITR.mp4

13:32

5. Recover Single Datafile.mp4

18:58

6. RMAN Recovery Best Practicies.mp4

06:47

15. RMAN Scripting

1. RMAN Command File Scripting.mp4

50:49

2. RMAN Catalog Scripting.mp4

24:15

3. Scheduling RMAN Backups.mp4

02:26

16. Advanced Database Cloning

1. DB Cloning Via DBCA.mp4

25:59

2. Introduction to DB Cloning.mp4

19:54

3. RMAN Restore Recover Cloning.mp4

35:21

4. Rename DB Post Cloning.mp4

14:02

5. RMAN Active DB Duplicate.mp4

14:10

6. Cloning Best Practicies.mp4

15:50

17. Introduction to Oracle High Availability

1. What is High Availability.mp4

24:47

2. Data Guard components.mp4

10:26

3. Types of standby databases.mp4

27:48

4. Data Guard Important Terms.mp4

11:15

5. Data Guard Recommendations.mp4

07:18

18. Physical Standby Configuration

1. Introduction to Physical Standby.mp4

02:34

2. Why Physical Standby.mp4

02:17

3. Physical Standby Overview.mp4

02:01

4. Primary DB Changes.mp4

39:52

5. Primary & Stb Parameters.mp4

35:02

6. Clone Primary to Standby.mp4

11:51

7. Starting Log Apply Service on Stb.mp4

08:51

19. How to troubleshoot Data Guard

1. Troubleshoot Data Guard.mp4

03:03

2. How to verify your Data Guard Setup.mp4

04:44

3. Data Guard Startup Sequence.mp4

05:10

4. Active Data Guard from Physical Standby.mp4

03:57

5. Convert Physical Stb to Active Data Guard.mp4

02:49

20. Oracle Flashback

1. Why Oracle Flashback.mp4

18:58

2. Oracle Flashback Types.mp4

09:58

3. Flashback Table to SCN.mp4

14:18

4. Flashback Table Drop.mp4

09:24

5. Flashback Database.mp4

13:25

21. Introduction to Oracle Upgrades

1. Oracle upgrade overview.mp4

11:24

2. Oracle real time upgrade process.mp4

17:42

22. Oracle 11201 to 11204 Upgrade

1. 11201 to 11204 upgrade steps.mp4

11:44

2. 11201 to 11204 prepare for upgrade.mp4

11:56

3. 11201 to 11204 Pre-Upgrade.mp4

25:53

4. 11201 to 11204 Database Upgrade.mp4

11:32

5. 11201 to 11204 Post-Upgrade.mp4

17:27

23. Oracle 11204 to 12101 Upgrade

1. 11204 to 12101 prepare for upgrade.mp4

06:12

2. 11204 to 12101 Pre-Upgrade.mp4

20:57

3. 11204 to 12101 Database Upgrade.mp4

07:58

4. 11204 to 12101 Post-Upgrade.mp4

11:02

Description

Mastering High Availability, Performance Tuning, and Advanced Recovery Techniques

What You'll Learn?

Understand and manage physical and logical storage structures in Oracle, including data blocks, extents, segments, and tablespaces
Learn about Oracle database instances, their startup and shutdown processes, and instance recovery techniques
Gain knowledge on partitioning strategies for tables and indexes to improve database performance and manageability
Explore advanced topics such as manual database creation, tablespace administration, and best practices for database storage and utilization
Get introduced to Oracle networking components like the Oracle Listener and learn to troubleshoot networking issues effectively
Master the use of RMAN for database backup and recovery, including full and incremental backups, recovery catalogs, and RMAN scripting
Understand high availability concepts, Data Guard components, and how to configure and manage physical standby databases for disaster recovery
Utilize Oracle Flashback technology for data recovery, including flashback queries, flashback table, and flashback database
Gain practical knowledge on upgrading Oracle databases from version 11.2.0.1 to 11.2.0.4 and from 11.2.0.4 to 12.1.0.1, including upgrade preparation

Who is this for?

Database administrators who are already familiar with basic Oracle DBA tasks and want to advance their skills

IT professionals who manage database infrastructure and want to gain deeper knowledge in Oracle 11g database administration

System administrators who work with Oracle databases and need to understand advanced DBA tasks

Developers who work closely with Oracle databases and want to understand advanced database management

IT managers who oversee database administration teams and want to understand advanced Oracle DBA concepts

What You Need to Know?

Familiarity with database concepts, terminology, and basic operations

Experience with Oracle Database, including installation, configuration, and basic administration tasks

Ability to write and execute SQL queries, and understanding of SQL syntax and functions

Basic Unix/Linux Commands

Familiarity with Oracle Tools

More details

Description
Welcome to the Oracle 11g Advanced DBA course, your comprehensive guide to mastering advanced database administration techniques for Oracle 11g. This course is designed for experienced DBAs and IT professionals looking to elevate their skills and manage complex Oracle 11g environments effectively.

By the end of this course, you will possess the expertise required to optimize, secure, and ensure high availability of Oracle databases, preparing you for real-world challenges and advanced certification exams.

The course begins with a deep dive into Oracle's physical and logical storage structures. You'll explore the intricacies of data blocks, extents, segments, and tablespaces, learning best practices for efficient data organization and retrieval. Understanding these foundational elements is crucial for managing storage and ensuring optimal performance and scalability of your Oracle databases.

The course also delves into advanced database management topics, including manual database creation, tablespace administration, and storage optimization. You'll learn how to monitor and manage tablespace utilization, implement best practices, and troubleshoot common issues. Additionally, we cover table and index partitioning strategies, which are essential for managing large datasets and improving database performance.

Whether you're aiming to enhance your current DBA skills, prepare for advanced Oracle certifications, or ensure your organization's databases are robust and efficient, this course provides the comprehensive knowledge and practical skills you need. Join us in mastering Oracle 11g and take your database administration capabilities to the next level.
Who this course is for:
Database administrators who are already familiar with basic Oracle DBA tasks and want to advance their skills
IT professionals who manage database infrastructure and want to gain deeper knowledge in Oracle 11g database administration
System administrators who work with Oracle databases and need to understand advanced DBA tasks
Developers who work closely with Oracle databases and want to understand advanced database management
IT managers who oversee database administration teams and want to understand advanced Oracle DBA concepts

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle Database

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.