上海OCP认证培训,Oracle数据库原厂专家认证课程,本课程包含OCA和OCP两个等级的课程,学员完成本课程的学习可系统掌握Oracle数据库知识,具备管理大型数据库的能力,通过考试后,可获得OCA和OCP两张证书。
01Oracle 12c 及SQL介绍
02理解 SQL 语句,以及关系型数据库概念
03使用 SQL Developer 工具
04使用SQL编写报表程序
05操作和保存表数据
▶ Introduction(SQL 简介)
▶ Retrieving Data using the SQL SELECT Statement(SELECT 查询语句)
▶ Restricting and Sorting Data(限制和排序数据)
▶ Using Single-Row Functions to Customize Output(单行函数及自定义输出格式)
▶ Using Conversion Functions and Conditional Expressions(转换函数与条件表达式)
▶ Reporting Aggregated Data Using the Group Functions(分组函数以及聚合操作)
▶ Displaying Data From Multiple Tables Using Joins(多表查询操作)
▶ Using Subqueries to Solve Queries(使用子查询)
▶ Using the SET Operators(Set集合操作)
▶ Managing Tables using DML statements(DML与事务处理操作
▶ Introduction to Data Definition Language(DDL语句)
Oracle Database 12c Administrator workshop(Oracle 数据库12c 管理)
对应考试代码:IZO-062
本课程中你将学习到:
01.Oracle 12C数据库特点介绍
02.Oracle 12C数据库安装与配置
03.创建管理Oracle数据库实例
04.创建管理储存结构
05.创建管理用户
06.监考管理数据库性能
07.备份与恢复等内容
▶ Introduction(课程介绍)
▶ Exploring Oracle Database Architecture(ORACLE数据库体系架构)
▶ Oracle Database Management Tools(ORACLE数据库管理工具)
▶ Managing the Database Instance(管理数据库服务器实例)
▶ Configuring the Oracle Network Environment (配置ORACLE数据库网络环境)
▶ Administering User Security(管理用户与安全)
▶ Managing Database Storage Structures(管理数据库存储结构)
▶ Managing Space (管理空间)
▶ Managing Undo Data(管理回滚数据)
▶ Managing Data Concurrency(管理并发)
▶ Implementing Oracle Database Auditing(实现ORACLE数据库审计)
▶ Backup and Recovery: Concepts(备份与恢复的概念)
▶ Backup and Recovery: Configuration(配置数据可恢复性)
▶ Performing Database Backups(实施数据库备份)
▶ Performing Database Recovery(实施数据恢复)
▶ Moving Data(移动数据)
▶ Database Maintenance(数据库维护)
▶ Managing Performance(管理数据库性能)
▶ Managing Performance: SQL Tuning(执行数据的SQL优化)
▶ Using Database Resource Manager(使用数据资源管理器)
▶ Using Oracle Scheduler to Automate Tasks(使用数据库调试器)
▶ Oracle Database Cloud Service: Overview (ORACLE云服务介绍)
Oracle Database 12c: Backup and Recovery Workshop (Oracle 数据库12c 备份与恢复)
对应考试代码:IZO-063
本课程中你将学习到:
01Oracle 12c 多租用户的云管理05诊断修复数据错误
06闪回数据库▶ Introduction(课程简介)
▶ Getting Started(备份与恢复基本概念)
▶ Configuring for Recoverablility(配置系统可恢复性)
▶ Using the RMAN Recovery Catalog(使用RMAN资料档案库)
▶ Backup Strategies and Terminology(备份策略与术语)
▶ Performing Backups(实施备份)
▶ Improving Your Backups(提升备份性能)
▶ Using RMAN-Encrypted Backups(采用RMAN加密的备份)
▶ Diagnosing Database Failures(诊断数据库故障)
▶ Restore and Recovery Concepts(备份恢复概念)
▶ Performing Recovery(实施各种场景恢复)
▶ RMAN and Oracle Secure Backup(Rman与 Oracle Secure Backup集成)
▶ Performing Tape Backups and Restores(实施磁带的备份与恢复)
▶ Using Flashback Technologies(使用闪回技术)
▶ Using Flashback Database(闪回数据库)
▶ Managing Backup Space or Transporting Data(跨平台传送表空间和数据库)
▶ Duplicating a Database(复制数据库)
▶ RMAN Performance and Tuning(备份性能调优)
Oracle Database 12c: Managing Multitenant Architecture(Oracle 12c 云数据库多租用户管理体系)
对应考试代码:IZO-063
本课程中你将学习到:
01Oracle 12c 多租用户的云管理
02CDB(容器数据库)管理
03PDB(可插拔数据库)管理
▶ Container and Pluggable Database Architecture(容器与可插拔数据库体系结构)
▶ Managing a CDB and PDBs(管理CDB PDB)
▶ Managing Storage in a CDB and PDBs(管理PDB CDB存储)
▶ Managing Security in a CDB and PDBs(管理CDB PDB安全)
▶ Managing Availability(管理可用性)
▶ Managing Performance(管理性能)
▶ Introduction(课程介绍)
▶ Exploring Oracle Database Architecture(ORACLE数据库体系架构)
▶ Oracle Database Management Tools(ORACLE数据库管理工具)
▶ Managing the Database Instance(管理数据库服务器实例)
▶ Configuring the Oracle Network Environment (配置ORACLE数据库网络环境)
▶ Administering User Security(管理用户与安全)
▶ Managing Database Storage Structures(管理数据库存储结构)
▶ Managing Space (管理空间)
▶ Managing Undo Data(管理回滚数据)
▶ Managing Data Concurrency(管理并发)
▶ Implementing Oracle Database Auditing(实现ORACLE数据库审计)
▶ Backup and Recovery: Concepts(备份与恢复的概念)
▶ Backup and Recovery: Configuration(配置数据可恢复性)
▶ Performing Database Backups(实施数据库备份)
▶ Performing Database Recovery(实施数据恢复)
▶ Moving Data(移动数据)
▶ Database Maintenance(数据库维护)
▶ Managing Performance(管理数据库性能)
▶ Managing Performance: SQL Tuning(执行数据的SQL优化)
▶ Using Database Resource Manager(使用数据资源管理器)
▶ Using Oracle Scheduler to Automate Tasks(使用数据库调试器)
▶ Oracle Database Cloud Service: Overview (ORACLE云服务介绍)
免费重修、证书版本升级、在线答疑、免费重考等优惠。