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.
Oracle Database Administration Oracle Dba Fundamentals
