Understanding Database Architecture with Oracle

Focused View

Agaba Philip

2:48:41

11 View

01. Course Overview

01. Course Overview.mp4

01:24

02. Building Your Lab

02. Course and Module Introduction.mp4

03:14

03. Configuring the Repos for Centos.mp4

01:27

04. Installing Oracle Database 19c on Linux.mp4

05:15

05. Finishing the Install.mp4

02:57

06. Post-install Steps.mp4

02:12

07. Creating a Database.mp4

02:57

08. The Listener.mp4

00:35

09. Local Database Connection.mp4

01:15

10. Remote Connection - Easy Connect.mp4

03:51

11. Remote Connection - Dedicated Server.mp4

02:12

12. Remote Connection - Shared Server.mp4

02:08

13. Module Summary.mp4

01:48

03. The Architecture

14. Architecture Overview.mp4

01:27

15. Database vs. Instance.mp4

01:54

16. Viewing the Instance Components.mp4

02:31

17. Module Summary.mp4

00:39

04. The Files

18. The Files.mp4

00:45

19. The Server Parameter File.mp4

05:45

20. The Alert Log.mp4

01:59

21. Data Files.mp4

03:46

22. The Control File.mp4

04:28

23. The Redo Logs.mp4

03:53

24. Demo-Redo Logs.mp4

04:06

25. Redo Logs and Instance Recovery.mp4

04:07

26. The Password File.mp4

05:01

27. Demo-Password File.mp4

07:06

28. Password File Key Points.mp4

02:00

29. The Startup Sequence.mp4

03:33

30. Module Summary.mp4

02:26

05. The Memory Structures

31. The Memory Structures.mp4

03:41

32. The PGA and UGA.mp4

02:59

33. The System Global Area.mp4

01:54

34. SGA Redo Log Buffer.mp4

01:53

35. SGA Buffer Cache.mp4

02:59

36. The Need for Redo Data.mp4

04:54

37. Demo-Buffer Cache and Log Buffer.mp4

04:06

38. SGA Shared Pool.mp4

01:21

39. SGA Large Pool.mp4

00:45

40. Automatic Memory Management.mp4

03:47

41. Module Summary.mp4

02:09

06. The Processes

42. The Processes.mp4

00:39

43. Server Processes - Dedicated.mp4

03:07

44. Server Processes - Shared.mp4

08:24

45. Background Processes.mp4

05:25

07. The Logical Structures

46. The Logical Structures.mp4

01:02

47. Tablespaces.mp4

01:57

48. Segments.mp4

01:40

49. Extents.mp4

02:43

50. Data Blocks.mp4

02:47

08. Multitenancy and Sharding

51. Multitenancy and Sharding.mp4

00:25

52. Components of a Multitenant Environment.mp4

02:14

53. Creating a Container Database.mp4

04:10

54. CDB ROOT.mp4

03:34

55. PDB SEED.mp4

01:37

56. Creating a Pluggable Database.mp4

02:11

57. Sharding.mp4

01:57

58. Data Dictionary Primer.mp4

02:11

59. Data Dictionary Static Views.mp4

05:29

Description

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.

What You'll Learn?

Understanding the Oracle database architecture is the first step to becoming an Oracle database professional. In this course, Understanding Database Architecture with Oracle, you’ll come to grips with the Oracle database architecture. First, you'll go over a quick architecture overview, and delve into the physical database structures. Next, you’ll explore the memory structures. Finally, you'll take a look at Oracle’s multitenant and sharding architectures. When you're finished with this course, you'll have the skills and knowledge to start your journey to becoming a Oracle database professional.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle Database

Oracle SQL

Agaba Philip

Instructor's Courses

I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I've come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I'm currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pastime.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.