Learn Oracle Database Administration From Scratch

سرفصل های دوره

Master Oracle Database Administration: From Installation to Advanced Backup and Recovery Techniques

1 - Introduction to Database

1 - What is Data

2 - What is a Database

3 - How a Database Function

2 - Oracle 11g Architecture

4 - User Connectivity in Oracle

5 - Phases of SQL Execution

6 - Select Statement Processing

7 - DML DDL Statement Processing

8 - Oracle Architecture Components

9 - Oracle Background Processes

10 - Oracle Files

3 - Oracle 11g Software Installation

11 - Download Oracle 11g

12 - Installation Prerequisites

13 - Pre Install Tasks

14 - Install Oracle 11g

15 - Post Install Tasks

4 - Oracle 11g Database Creation

16 - Set Environment Variables

17 - DBCA Create Database

18 - Connect Database

19 - Manual DB Creation

20 - DBCA Delete Database

5 - Navigating Oracle Database

21 - Database Metadata

22 - Basic Views You Must Know

23 - Key Database Files

24 - Database Storage Structures

25 - Datafiles Metadata

26 - Tablespace Metadata

6 - Basic Database Administration

27 - Database Operating Modes

28 - DB Startup Shutdown

29 - Multiplexing of Database Files

30 - Multiplexing Control Files

31 - Multiplexing Redolog Files

32 - Database Archivelog Mode

7 - Tablespace Administration

33 - Tablespace Utilization

34 - Create New Tablespace

35 - Capacity Planning

8 - User Administration

36 - Users in Oracle

37 - User Management

38 - User Role Management

39 - User Permission Management

40 - Profile Management

41 - Create User Profile

9 - Oracle Networking

42 - Install Oracle 11g Client

43 - Configuring Listener

44 - Configuring TNS Entries

45 - Oracle DB Links

10 - Oracle Utilities

46 - SQL Loader

47 - Import csv into Table

48 - Oracle Export Import

49 - Performing Export

50 - Performing Import

51 - Oracle Data Pump

52 - Data Pump Directory

53 - Data Pump Export

54 - Data Pump Import

11 - Database Backup Recovery

55 - Why Backup Recovery

56 - Backup Recovery Solutions

12 - Oracle User Managed Backups

57 - Cold DB Backup and Recovery

58 - Hot Database Backups

59 - Find DB Files Location

60 - Taking Hot DB Backup

61 - Hot Backup Queries

62 - RESTORE vs RECOVER

13 - Oracle User Managed Recovery

63 - Parameter File Recovery

64 - Control File Recovery

65 - Entire Database Recovery

14 - Introduction to RMAN

66 - What is RMAN Recovery manager

67 - How to Connect RMAN Utility

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy