|
Oracle 11g: Administration I培訓 |
|
班級規模及環境--熱線:4008699035 手機:15921673576( 微信同號) |
每期人數限3到5人。 |
上課時間和地點 |
開課地址:【上?!客瑵髮W(滬西)/新城金郡商務樓(11號線白銀路站)【深圳分部】:電影大廈(地鐵一號線大劇院站) 【武漢分部】:佳源大廈【成都分部】:領館區1號【沈陽分部】:沈陽理工大學【鄭州分部】:錦華大廈【石家莊分部】:瑞景大廈【北京分部】:北京中山學院 【南京分部】:金港大廈
最新開班 (連續班 、周末班、晚班):2020年3月16日 |
實驗設備 |
☆資深工程師授課
☆注重質量
☆邊講邊練
☆合格學員免費推薦工作
★實驗設備請點擊這兒查看★ |
質量保障 |
1、培訓過程中,如有部分內容理解不透或消化不好,可免費在以后培訓班中重聽;
2、培訓結束后,授課老師留給學員聯系方式,保障培訓效果,免費提供課后技術支持。
3、培訓合格學員可享受免費推薦就業機會。 |
課程大綱 |
|
-
- 1. Oracle Database 11g: Database Architecture and Installation
Main structural components of Oracle Database 11g
Components of the Oracle Database 11g memory structures
Functions of the Oracle Database 11 server and background processes
How information is stored and structured within the Oracle Database 11g storage architecture
Necessary tasks and essential tools required to administer an Oracle Database 11g database
Planning and carrying out an installation of Oracle Database 11g software using the Oracle Universal Installer (OUI)
Install Oracle Database 11g software in a given scenario
2. Oracle Database 11g: Database Creation, Instance Management, and Connectivity
Creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA) and managing a database instance using various Oracle tools
Scope and capabilities of Oracle Database 11g initialization parameters and the steps for maintaining them
Configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance
Using the Data Dictionary to find information about users, objects, constraints, and storage
Create a database using the DBCA and manage instances using Enterprise Manager
Ways of configuring and managing the Oracle network and the steps for creating a new Oracle Net Listener via Enterprise Manager
Connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options and when to employ connection pooling
Using and configuring Oracle Net Services in a given scenario
3. Oracle Database 11g: Storage Structures and User Security
Purposes of table spaces and datafiles
Creating a new tablespace
How to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic
Storage Management (ASM)
View tablespace information and create a new tablespace
Creating and authenticating database user accounts
Granting and revoking privileges and creating and managing roles
Creating and managing profiles, implementing password security, and assigning quotas
4. Oracle Database 11g: Managing the Schema, Data, and Concurrency
Features and functions of schemas and data types
|
|
|
|
|
|