Oracle Database technology exchange and knowledge transfer

? What are the characteristics and main contents of the number of days service object? 1. Basic Database and SQL language courses 2. Entry-level courses for junior developers, which describe the basic principles of databases and basic SQL operations, introduction to basic principles, common performance problems, and case studies of SQL application optimization 2 Basic Language Courses 2 Introduction to intermediate and intermediate developers P

? What are the characteristics and main contents of the number of days service object? 1. Basic Database and SQL language courses 2. Entry-level courses for junior developers, which describe the basic principles of databases and basic SQL operations, introduction to basic principles, common performance problems, and case studies of SQL application optimization 2 Basic PL/SQL language courses 2 Introduction to intermediate developers P

?

Serial number	Name	Days	Target customers	Features and main content
? 1	Basic Database and SQL language courses	2	Junior developers	This is an entry-level course for beginners. It describes basic database principles and basic SQL operations, and introduces basic principles, common performance problems, and case analysis of SQL application optimization.
2	Basic PL/SQL language courses	2	Junior and intermediate developers	This section describes PL/SQL overview, PL/SQL variable declaration, common SQL statement writing, condition and loop statement writing, composite data type processing, cursor usage, and exception handling, introduce PL/SQL compiling experience and related cases
3	Advanced PL/SQL language courses	3	Senior developers	This section describes advanced PL/SQL development technologies. Including the compilation of stored procedures, functions, and packages, introduction of main built-in Oracle packages, dynamic SQL statement writing, and large object management. It also introduces the advanced PL/SQL technology application experience and related cases.
4	Database Logic Design and Modeling	2	Database design, developers, and DBAs	This paper introduces the theory of database standardization design, introduces the application of SQL Developer Data Modeler tool, describes the process of Data flowchart design and Entity Relationship Diagram (E-R) Design Based on the case, and improves the level of database design.
Serial number	Name	Days	Target customers	Features and main content
? 5	Physical Database Design	2	Database design, developers, and DBAs	This section comprehensively introduces the physical design process of Oracle databases, including physical design of tablespaces, tables, and indexes. It is suitable for partitioning, ASM, and other technologies and solutions for massive data management, as well as new features related to 10g/11g, some practical cases are introduced.
6	Basic DBA courses	3	Initial and intermediate DBA	This section describes the Oracle database architecture and DBA routine operation and maintenance operations. Such as database object management, backup/recovery, basic security management, network management, performance monitoring and analysis, and the use and analysis of basic tools such as AWR and ADDM
7	DBA advanced courses	3	Senior DBA	Advanced performance optimization technologies are introduced at the system level and SQL application level in combination with a large number of practical cases for senior DBAs, as well as partition technical solutions, fault diagnosis methods, and practical skills, and Oracle's maximum high availability (locally) architecture and technical solutions
8	Advanced SQL application optimization courses	3	Medium and senior DBAs and application developers	Based on the Oracle Performance Optimization Methodology, combined with a large number of practical cases, the system introduces the SQL application optimization technology, such as the index policy and optimizer principle, and the optimization technology application process for different types of OLTP and OLAP systems.

Serial number	Name	Days	Target customers	Features and main content
? 9	Oracle Partitioning technology	2	Medium and senior DBAs and application developers	This article introduces the Oracle Partitioning technology suitable for massive data management. Including Partition Table and partition index technology, partition technology application, new features of 11g partition, partition implementation experience and case analysis, etc.
10	Advanced Fault Diagnosis courses	2	Senior DBA	The system introduces the Oracle database Fault Diagnosis methodology and introduces common database fault diagnosis tools (RDA, AWR, ADDM, ASH, OSW, database dump, Hang analysis, diagcollect, CHM) database Bad Block Processing Process, database Hang processing, ORA-4031 memory error processing, RAC fault diagnosis methods, as well as a large number of practical cases of Fault Diagnosis
11	Oracle 11g advanced database application optimization courses	3	Medium and senior DBAs and application developers	The system introduces the new technology of 11g in application optimization. Including optimizer advanced operation optimization, automatic SQL optimization, SQL Tuning Advisor, SQL Access Advisor, SQL PLAN management, HINT usage skills, and a large number of practical performance optimization Cases
12	Oracle RAC principles and implementation	3	Senior DBA	Introduces the Oracle RAC architecture, RAC installation process, RAC high availability test, RAC Operation and Maintenance Experience, RAC performance analysis and optimization, and introduces the principle and implementation experience of ASM, and 11g new features in RAC and ASM and related implementation cases

Serial number	Name	Days	Target customers	Features and main content
? 13	Oracle OEM	3	Senior DBA	The system introduces the three-tier architecture design of EM Repository, Grid Console, and Agent of Oracle Centralized Monitoring Management Platform OEM, including basic database management functions, online database diagnosis and optimization package usage, and report solution design, introduce OEM implementation cases
14	Oracle Database Security	3	Senior DBA	This section comprehensively introduces the Oracle database security architecture, and introduces typical technologies and implementation cases such as Oracle database security encryption technology, Oracle DB Vault, Oracle DB Mask, and Oracle Audit Vault.
15	Data warehouse design and Modeling	3	Data warehouse design, development and management personnel	This document introduces business and logic model design, multi-dimensional data model, physical model, capacity planning, typical ETL technology, and summary management for the data warehouse system, as well as data warehouse implementation cases.
16	Oracle disaster recovery course	2	Senior DBA	This article introduces the architecture of Data Guard, the implementation process and daily operation and maintenance management of physical Data Guard and Logical Data Guard, the Data Guard optimization technology, and the new features of 11g, and Data Guard implementation cases

Serial number	Name	Days	Target customers	Features and main content
? 17	New Features	3	Database design, developers, and DBAs	The system introduces the new features of 11 GB, including automatic SQL Performance Optimization Technology, SQL plan, Database Replay, SPA, new Partitioning technology, SecureFiles, SQL Result Cache, new RMAN features, and new security technologies, and 11G implementation cases
18	New 12c features	2	Database design, developers, and DBAs	Several new features of 12c are introduced: Concepts and architecture of CDB and PDB, routine management of CDB and PDB, and new information lifecycle management technologies, such as Heat Map and ADO technologies and new data archiving technologies.
19	Advanced Integrated Oracle technology	3	Database design, developers, and DBAs	This article introduces the new features of 11g, 11g upgrade solution, performance optimization, Partitioning technology, Oracle Disaster Tolerance solution, and other advanced technologies, and introduces relevant implementation cases.
20	Exadata	2	Senior DBA	Describes the principle and architecture of Exadata, installation and configuration of Exadata, routine operation and maintenance of Exadata Database Michine and Exadata Storage Server, common fault diagnosis, Exadata backup and recovery, and technical solutions for migrating data to Exadata, introduce relevant implementation cases
21	Oracle TimesTen Memory Database	2	Senior DBA	This article introduces the basic principles of Oracle TimesTen memory database, routine management of TimesTen memory database, concurrency control and performance optimization, TimesTen replication technology, TimesTen high availability solutions, and related implementation cases.
22	Oracle cloud computing and data integration technology	2	Senior DBA	Overall Oracle cloud computing policy, database cloud computing platform (DBaaS), Oracle virtual machine technology, cloud computing Disaster Tolerance and security, main data integration and migration technologies, and related implementation cases

Related posts:

1. How to disable automatic statistics collection in 11g

Original article address: Oracle Database technology exchange and knowledge transfer. Thank you for sharing it with me.