وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Complete Guide to Oracle Database 23ai: From Beginner to Advanced

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

As open-source technology becomes more standard, this course highlights the importance of robust, mature, and fully-supported relational database systems. Join instructor Kellyn Gorman as she guides you on your journey toward becoming a proficient database administrator, covering the robust features, innovative enhancements, and powerful capabilities of Oracle 23ai. Kellyn helps equip you with the comprehensive knowledge and skills required to effectively manage Oracle Database systems, the most widely used in enterprise environments, and to manage much of the most critical business data. By delving into Oracle's intricacies, you’ll gain a deep understanding of how to design, implement, and maintain robust and high-performing database systems, making them indispensable assets to organizations that rely on Oracle technology.


01 - Introduction
  • 01 - Oracle 23ai Future-proof your tech journey
  • 02 - An update about Oracle 23ai
  • 03 - What you should know
  • 04 - Getting set up for the Capstone project

  • 02 - 1. Why Oracle
  • 01 - Why Oracle
  • 02 - New in Oracle 23ai
  • 03 - New data types
  • 04 - Miscellaneous new features

  • 03 - 2. Oracle Basics Schema Objects
  • 01 - Schema objects All about tables
  • 02 - Indexing in Oracle 23ai
  • 03 - Views, object views, JSON views, and materialized views
  • 04 - Segment partitioning
  • 05 - The data dictionary and dynamic performance views
  • 06 - Capstone countdown Schema objects recap

  • 04 - 3. Oracle Basics Transactions
  • 01 - What is ACID
  • 02 - Data concurrency
  • 03 - Data consistency
  • 04 - Data integrity
  • 05 - SQL language
  • 06 - PLSQL
  • 07 - Interacting with the database
  • 08 - Capstone countdown Transactions recap

  • 05 - 4. Oracle Architecture
  • 01 - Oracle physical architecture
  • 02 - Oracle logical architecture
  • 03 - Database configuration and logging
  • 04 - Oracle memory and processes
  • 05 - Capstone countdown architecture recap

  • 06 - 5. Instance vs. Container Database (CDB)
  • 01 - What is an Oracle instance
  • 02 - Container database (CDB)
  • 03 - Pluggable databases (PDBs)
  • 04 - Oracle Real Application Clusters (RAC)
  • 05 - Oracle Data Guard
  • 06 - Sharding architecture
  • 07 - Oracle Net Services and application architecture
  • 08 - Capstone countdown Instance vs. container database recap

  • 07 - 6. Database Administration
  • 01 - Role of a database administrator
  • 02 - Overview of maximum availability architecture
  • 03 - Understanding Oracle high availability
  • 04 - Disaster recovery options
  • 05 - Backing up and recovering using RMAN
  • 06 - Capstone countdown Database administration recap

  • 08 - 7. Security
  • 01 - Security basics
  • 02 - Authentication
  • 03 - Authorization
  • 04 - Account management
  • 05 - Auditing
  • 06 - Data governance in Oracle
  • 07 - New security features with 23ai
  • 08 - Capstone countdown Security recap

  • 09 - 8. Advanced Security
  • 01 - Reversible and irreversible data protection
  • 02 - Data obfuscation
  • 03 - Data masking
  • 04 - Transparent Data Encryption (TDE)
  • 05 - Network encryption
  • 06 - Database Firewall
  • 07 - Capstone countdown Advanced security recap

  • 10 - 9. Optimizing Performance
  • 01 - Introduction to performance optimization
  • 02 - Instance tuning
  • 03 - Understanding the AWR report
  • 04 - ASH, ADDM, and the rest of AWR
  • 05 - SQL tuning
  • 06 - SQL tracing
  • 07 - Cost-based optimizer
  • 08 - Performing an optimization exercise
  • 09 - Capstone countdown Optimizing performance recap

  • 11 - 10. Oracle 23ai Capstone Getting Prepared
  • 01 - Capstone introduction and prerequisites
  • 02 - Assignment Navigating the database hierarchy
  • 03 - Walkthrough Navigating the database hierarchy

  • 12 - 11. Oracle 23ai Capstone Admin Tasks
  • 01 - Assignment Starting and stopping databases
  • 02 - Walkthrough Starting and stopping databases
  • 03 - Assignment Configuring and managing space
  • 04 - Walkthrough Configuring and managing space
  • 05 - Assignment User management
  • 06 - Walkthrough User management

  • 13 - 12. Oracle 23ai Capstone Cloning a Database
  • 01 - Assignment Cloning a pluggable database
  • 02 - Walkthrough Cloning a pluggable database

  • 14 - 13. Oracle 23ai Capstone Archiving for Point-in-Time Recovery
  • 01 - Assignment Turning on archiving for point-in-time recovery
  • 02 - Walkthrough Turning on archiving for point-in-time recovery

  • 15 - 14. Oracle 23ai Capstone Working with Data
  • 01 - Assignment Create a sales summary schema owner user
  • 02 - Walkthrough Create a sales summary schema owner user
  • 03 - Assignment Create reporting data
  • 04 - Walkthrough Create reporting data
  • 05 - Assignment Manipulate data
  • 06 - Walkthrough Manipulate data

  • 16 - 15. Oracle 23ai Capstone Managing the Optimizer
  • 01 - Assignment Create an explain plan
  • 02 - Walkthrough Create an explain plan

  • 17 - Conclusion
  • 01 - Further learning with Oracle 23ai
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 39688
    حجم: 661 مگابایت
    مدت زمان: 318 دقیقه
    تاریخ انتشار: ۲۲ مرداد ۱۴۰۳
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید