Understanding Database Architecture with Oracle

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

The Oracle database system is quite complex, and understanding its architecture is the non-negotiable first step. This course will give you a solid foundation of the Oracle database architecture.

01. Course Overview

01. Course Overview

02. Building Your Lab

02. Course and Module Introduction

03. Configuring the Repos for Centos

04. Installing Oracle Database 19c on Linux

05. Finishing the Install

06. Post-install Steps

07. Creating a Database

08. The Listener

09. Local Database Connection

10. Remote Connection - Easy Connect

11. Remote Connection - Dedicated Server

12. Remote Connection - Shared Server

13. Module Summary

03. The Architecture

14. Architecture Overview

15. Database vs. Instance

16. Viewing the Instance Components

17. Module Summary

04. The Files

18. The Files

19. The Server Parameter File

20. The Alert Log

21. Data Files

22. The Control File

23. The Redo Logs

24. Demo-Redo Logs

25. Redo Logs and Instance Recovery

26. The Password File

27. Demo-Password File

28. Password File Key Points

29. The Startup Sequence

30. Module Summary

05. The Memory Structures

31. The Memory Structures

32. The PGA and UGA

33. The System Global Area

34. SGA Redo Log Buffer

35. SGA Buffer Cache

36. The Need for Redo Data

37. Demo-Buffer Cache and Log Buffer

38. SGA Shared Pool

39. SGA Large Pool

40. Automatic Memory Management

41. Module Summary

06. The Processes

42. The Processes

43. Server Processes - Dedicated

44. Server Processes - Shared

45. Background Processes

07. The Logical Structures

46. The Logical Structures

47. Tablespaces

48. Segments

49. Extents

50. Data Blocks

08. Multitenancy and Sharding

51. Multitenancy and Sharding

52. Components of a Multitenant Environment

53. Creating a Container Database

54. CDB ROOT

55. PDB SEED

56. Creating a Pluggable Database

57. Sharding

58. Data Dictionary Primer

59. Data Dictionary Static Views

139,000 تومان

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

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

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

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