Tiêu chuẩn hãng

Oracle Database 12c: Administration Workshop

The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.

Learn To: 

  • Create and manage an Oracle Database Instance.
  • Create and manage Storage Structures.
  • Configure the Oracle Network Environment.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Learn basic information on backup and recovery techniques.
  • Use the Oracle Support Workbench and My Oracle Support to update your Oracle Database software.

 B enefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Objectives

  • Back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Manage database instances
  • Manage UNDO data
  • Move data between databases
  • Implement basic backup and recovery procedures
  • Monitor and tune database performance
  • Tune SQL to improve performance
  • Manage resources with Oracle Database Resource Manager
  • Create pluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer user security and implement auditing
  • Create and manage tablespaces
  • Manage storage space
  • Create and manage Database as a Cloud Service (DBCS) database deployments
  • Register databases and manage performance with Enterprise Manager Cloud Control

Topics

  • Getting Started
  • Exploring Oracle Database Architecture
  • Managing Database Instances
  • Creating PDBs
  • Configuring the Oracle Network Environment
  • Administering User Security
  • Creating and Managing Tablespaces
  • Managing Storage Space
  • Managing UNDO Data
  • Moving Data
  • Backup and Recovery Concepts
  • Monitoring and Tuning Database Performance
  • SQL Tuning
  • Oracle Database Resource Manager
  • Enterprise Manager Cloud Control
  • Introduction to Oracle Database Cloud Service
  • Creating DBCS Database Deployments
  • Managing DBCS Database Deployments
  • Backing Up and Restoring DBCS Database Deployments
  • Patching DBCS Database Deployments
  • Creating Master Encryption Keys for PDBs
  • Tablespace Encryption by Default

Nguồn: Oracle Learning

KHÓA HỌC LIÊN QUAN
  • VMware Virtual SAN: Deploy and Manage [V5.5]

    Lịch Khai Giảng

    Tháng 05 11
  • VMware Virtual SAN: Deploy and Manage [V5.5]

    Khóa học này nhằm cung cấp cho học viên những kiến thức và kỹ năng trong việc xây dựng và quản lý giải pháp hệ thống lưu trữ định nghĩa bằng phần mềm (software defined storage), trên nền tảng là sản phẩm VMware® Virtual SAN 5.5.

    XEM CHI TIẾT

  • KHÓA HỌC LINUX ADMINISTRATION I - LPI 1

    Lịch Khai Giảng

    Tháng 03 26
  • KHÓA HỌC LINUX ADMINISTRATION I - LPI 1

    Chương trình được xây dựng bởi Linux Professional Institute (LPI) nhằm cung cấp cho học viên những kiến thức và kỹ năng quản trị chung trên hầu hết các phiên bản khác nhau của Linux. Chương trình này đáp ứng cho các chuyên viên CNTT muốn lấy chứng chỉ quản trị viên hệ thống Linux cấp 1 (LPI Level 1), cung cấp kiến thức căn bản, nhưng quan trọng, trong các lĩnh vực sau: Phần cứng & Kiến trúc hệ thống, Cài đặt & Quản lý Linux, các Lệnh của GNU & UNIX, Hệ thống Tập tin & các Chuẩn theo cấp, Khởi động và Quản lý tiến trình, Quyền truy cập, TCP/IP, DFS, Cấu hình thiết bị, Quản lý dịch vụ Mạng (NTP, Apache, DNS, Samba, OpenSSH, Sendmail), xử lý sự cố, sao lưu-phục hồi dữ liệu. Học viên có đủ kiến thức và kỹ năng để thi lấy chứng chỉ chuyên viên quản trị hệ thống Linux – LPI Level 1 (môn thi LPI 101 & 102)

    XEM CHI TIẾT

  • Oracle Database 11g: Administration Workshop II

    Lịch Khai Giảng

    Tháng 03 26
  • Oracle Database 11g: Administration Workshop II

    In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.

    XEM CHI TIẾT

  • 20465B: Designing Database Solutions for Microsoft SQL Server 2012

    Lịch Khai Giảng

    Tháng 01 01
  • 20465B: Designing Database Solutions for Microsoft SQL Server 2012

    This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability

    XEM CHI TIẾT

  • Oracle Database 11g: Administration Workshop I

    Lịch Khai Giảng

    Tháng 03 26
  • Oracle Database 11g: Administration Workshop I

    This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

    XEM CHI TIẾT

    zalo