Oracle Database Administration Oracle Dba Fundamentals

[martinstronis654]

Oracle Database Administration: Oracle Dba Fundamentals
Published 11/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.97 GB | Duration: 10h 26m​

Become an expert Oracle DBA with hands-on training in Oracle Database, from setup to advanced management techniques.

What you'll learn
Master the architecture and components of Oracle Database 21c.
Understand Oracle memory structures, background processes, and storage management.
Configure, start up, and shut down Oracle databases.
Manage tablespaces, data files, and control files for optimal performance.
Implement user security, profiles, and resource management.
Perform hands-on exercises to create and manage databases, indexes, and tables.
Use Oracle tools like SQLPlus and Oracle Enterprise Manager for database administration.
Explore new features in Oracle 21c for improved database management.

Requirements
Basic understanding of databases and SQL.
Familiarity with operating systems (Windows/Linux).
No prior experience with Oracle Database is required, but it is beneficial.
An active Oracle Database 21c installation (free version available) for hands-on practice.

Description
Welcome to the Oracle Database Administration course, where you will master the essential skills needed to become a proficient Oracle Database Administrator (DBA). This comprehensive course covers everything from foundational concepts like the architecture of Oracle databases to advanced topics such as managing tablespaces, user security, and database optimization. Whether you're an aspiring DBA or looking to upgrade your skills to the latest version of Oracle, this course will provide you with practical, hands-on experience to confidently manage Oracle Database environments.Section 1: Introduction to Oracle DBA 21cIn this section, you'll get acquainted with the fundamentals of Oracle Database 21c. We'll start by understanding what a database server is and delve into the architecture of Oracle's memory structures and background processes, such as PGA, SMON, and LREG. You'll also learn about Oracle 21c's new features, giving you insight into what's new in this latest release.Key Lectures Include:Understanding Database Servers and Their ImportancePGA and Key Background Processes (SMON, LREG)Oracle 21c New Features OverviewDatabase Buffer Cache and System FilesApplication Containers and Advanced Checkpoint ProcessesSection 2: Oracle Database Admin DBA 1 CourseThis in-depth section is designed to equip you with essential Oracle DBA skills. Starting with the Oracle Server setup, you'll dive deep into various Oracle memory structures like the SGA, shared pool, and redo log buffers. Learn how to manage Oracle instances, configure databases, and use powerful tools like SQLPlus and Oracle Enterprise Manager. You'll explore advanced topics such as creating databases, managing control files, and maintaining tablespaces, ensuring you have a solid foundation in Oracle Database Administration.Key Lectures Include:Oracle Server, Instance, and Database ArchitectureManaging Oracle Instances, SPFILE, and Initialization ParametersCreating and Managing Databases Using DCA and Manual MethodsUnderstanding Data Dictionary and Dynamic Performance TablesAdvanced Management of Redo Logs, Tablespaces, and SegmentsPractical Examples and Hands-On Sessions for Real-World ScenariosCourse Conclusion:By the end of this course, you will have gained a thorough understanding of Oracle Database 21c's architecture, essential DBA tasks, and best practices for managing databases efficiently. This course is designed to build your confidence in handling database environments, optimizing performance, and securing data. Whether you're looking to start a career as an Oracle DBA or upskill to Oracle 21c, this course provides the knowledge and hands-on experience you need.

Overview
Section 1: Introduction to Oracle DBA 21c

Lecture 1 What is Database Server

Lecture 2 PGA and Background Process

Lecture 3 Database Buffer Cache

Lecture 4 Database System Files

Lecture 5 Application Container

Lecture 6 LREG and SMON

Lecture 7 Checkpoint Process

Lecture 8 RVWR

Lecture 9 Oracle 21c New Features

Section 2: Oracle Database Admin DBA 1 Course

Lecture 10 Introduction

Lecture 11 Oracle Server, Instance and Database

Lecture 12 SGA, Shared Pool, Library Cache

Lecture 13 Redo Log Buffer, Large Pool and Java Pool

Lecture 14 Program Global Area

Lecture 15 Database Writer (DBWn), Log Writer (LGWR)System Monitor (SMON)

Lecture 16 Checkpoint, Archiver

Lecture 17 Processing SQL Statements

Lecture 18 Checkpoint, Archiver and Logical Structure Summary

Lecture 19 Getting Started with the Oracle Server

Lecture 20 Database Administrator Users, SQLPlus

Lecture 21 Oracle Enterprise Manager and Console

Lecture 22 Managing an Oracle Instance

Lecture 23 SPFILE spfileSID.ora

Lecture 24 Starting up database, Alter database

Lecture 25 Shutting Down Database

Lecture 26 Managing and Organizing a Database

Lecture 27 Using Password File Authentication & Creating a Database

Lecture 28 Create Database Using DCA And Manually

Lecture 29 Creating a Database using OMF, Troubleshooting and After Database Creation

Lecture 30 Creating a Database 1

Lecture 31 Creating a Database 2

Lecture 32 Data Dictionary

Lecture 33 Dynamic Performance Tables

Lecture 34 Practical Examples session 5

Lecture 35 Maintaining the Control File

Lecture 36 Maintaining the Control File Count

Lecture 37 Practical Examples Session 6

Lecture 38 Maintaining Redo Log Files

Lecture 39 Dropping Online Redo Log Files

Lecture 40 Managing Online Redo Log Files

Lecture 41 Practical Examples Session 7

Lecture 42 Types of Tablespaces

Lecture 43 Locally Managed Tablespaces

Lecture 44 Undo, Temporary and Read Only Tablespace

Lecture 45 Default Temporary Tablespace

Lecture 46 Tablespace offline, Storage Settings and Resizing Tablespace

Lecture 47 Resizing, Dropping and Obtaining Tablespace information

Lecture 48 Managing Tablespaces and Datafiles-Practical 1

Lecture 49 Managing Tablespaces and Datafiles-Practical 2

Lecture 50 Types of Segments

Lecture 51 Storage Clause Precedence

Lecture 52 Non Standard Block Size, Database Block Contents

Lecture 53 Manual Data block Management and Practical Examples

Lecture 54 Managing Undo Data

Lecture 55 Types of Undo Segments

Lecture 56 Automatic Undo Management Altering an UNDO Tablespace

Lecture 57 Automatic Undo Management Sizing an UNDO Tablespace

Lecture 58 Practical Example Session 10

Lecture 59 Storing User Data

Lecture 60 Oracle Built-in Data Types

Lecture 61 ROWID Format, Structure of a Row

Lecture 62 Creating a Table

Lecture 63 Truncating, Dropping Table

Lecture 64 Dropping a Table

Lecture 65 Practical Example Session 11

Lecture 66 Btree Index

Lecture 67 Bitmap Indexes

Lecture 68 Creating Btree and Bitmap Index

Lecture 69 Changing Storage Parameters for Indexes

Lecture 70 Changing Storage Parameters for Indexes Count

Lecture 71 Practical Examples Session 12

Lecture 72 Types of Constraints, Constraints States

Lecture 73 Types of Constraints, Constraints States Count

Lecture 74 Defining Constraints

Lecture 75 Enabling Constraints

Lecture 76 Practical Examples Session 13

Lecture 77 Profiles and Password Management

Lecture 78 Profiles and Password Management Count

Lecture 79 Alter, Drop Profile

Lecture 80 Resource Plan Directives

Lecture 81 Practical Examples Session 14

Lecture 82 Users and Security

Lecture 83 Creating a New User Operating System Authentication

Lecture 84 Practical Examples Session 15

Lecture 85 Granting and Revoking System Privileges

Aspiring Database Administrators looking to gain practical skills in Oracle Database 21c.,IT Professionals and System Administrators interested in expanding their database management expertise.,Developers who want to deepen their knowledge of Oracle database architecture and administration.,Students and Tech Enthusiasts eager to start a career in database management.,Experienced DBAs who want to upgrade their skills to the latest Oracle 21c version.

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!