慧谷培训 >>> 特色技术课 >>> DB2 9 Database课程介绍   
    搜索课程
搜索:
选项:
 在线咨询    最新课表
    推荐课程
  优惠组合课程
思科官方授权CCNA+CCDA双证班10.
思科官方授权CCNA+CCNP培训只需4.
思科+微软黄金组合3900元
最有价值的网管课程6500元
信息安全技术认证培训
MCSE2012&全球IT认证金牌课程
  Cisco(思科)
思科官方授权CCNA培训
思科官方授权CCNP培训
思科官方授权CCIE培训系统
全国独家Cisco官方售前培训班
思科官方授权CCSP培训
  政府补贴
政府补贴中高级计算机程序设计员Java
Office政府补贴
  微软/Linux
微软MCSE认证/server2012
MCSE2003企业定制
红帽认证工程师(RHCE7)
微软官方MCITP 2008
  Office认证培训
Word课程
Excel 2010基础入门应用
Excel中高级课程
Excel在企业管理上应用(专家级)
PowerPoint课程
Access课程
Outlook课程
  平面广告设计
Adobe平面设计师班
专业美术创意设计班
Adobe Photoshop实战应用班.
高级平面广告创意设计师
  室内设计
AutoCAD 全能
3D MAX 全能班
高级室内创意设计师
  网页设计
CSS+DIV 网页高级布局
动态网页及高级WEB开发班
资深微软认证WEB开发大师班
资深SUN Java WEB开发大师班
Adobe Flash
资深网页设计美工定向班
  影视动画制作课程
3D MAX影视动画全科班
  MAYA动漫游戏
Autodesk Maya认证班
  编程开发系列
Java初级入门SL-110
Jsp Web开发 SL314
Java模式设计OO-226
J2EE企业高级解决方案
  特色技术课
VB.NET 开发编程
Visual Studio TFS
微软.net开发实战培训
C#技术基础课程
MOSS 2013(sharepoint.
MOSS 2013(sharepoint.
Lotus Notes企业应用
Oracle OCP 数据库管理开发实战
VMware vSphere实战 VCP
IOS精英直通车班
IOS核心速成班
Windows 8桌面支持专家
互联网前端开发工程师(html5+JS)
安卓Android开发实训营
  小型机系统管理
HP-Unix系统及网络管理I
AIX 6 Basics AU13
大型机操作系统
Solaris 操作系统网络管理
  工业设计
CATIA V5/V6 造型设计实战应用
Pro/E 3/4/5/6 模具设计实战.
Pro/E 3/4/5/6 钣金设计实战
UG NX 5/6/7造型设计实战应用
UG NX 5/6/7模具设计实战
UG NX 8.0 数控加工实战应用
SolidWorks 实战应用
  软件测试专业培训
软件测试提高班
软件测试就业班
  企业管理课程
人力资源管理师二级
企业培训师二级
有效沟通技巧实战培训
  IT英语
IT英语,IT职业英语
暂无小分类
  大数据
   
    广告课程
  >>> DB2 9 Database开班介绍
课程周期: 18小时 培训费用: 7500 元
使用教材: 送培训讲义,教学光盘 教材费用: 包含教材费
学员收益: 熟练应用
咨询电话: 021-64472947、13122257700  64470100   
  >>> DB2 9 Database最近开班
编 号 上课地点 学习时段 开课时间 在线报名


现在报名预约此课程

  >>>  DB2 9 Database详细介绍


DB2 9 Database Administration Workshop for Linux, UNIX, and Windows

课程周期:18小时 
培训费用:7500 元
使用教材:培训讲义
教材费用:送培训讲义,教学光盘
咨询电话:021-64472947

学员收益:This course is designed to teach you how to perform database administration tasks using DB2 9. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pure XML (native XML storage) will be introduced.

一、 培训介绍
    1、18小时、培训费7500元
    2、附送培训讲义,培训光盘

二、 课程简介

Audience
    This intermediate course is for System administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.
This course is appropriate for students using DB2 in a z/Linux environment.

Prerequisites

You should be able to:
    Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
    State the functions of the Structured Query Language (SQL), and be able to construct DDL, DML, and authorization statements
    Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
    These skills can be developed by taking:
    Basic OS functions:
    Windows Operating System Training
    Linux Operating System Training
    AIX Operating System Training
    or have equivalent administration experience
    SQL and relational database basics
    DB2 SQL Workshop (CE12), (3E12)
    or have equivalent knowledge of SQL basics

Skills taught

    Administer a DB2 database system using commands and GUI tools
    Manage System Managed Storage (SMS) and Database Managed Storage (DMS) databases and apply data placement principles
    Implement a given logical database design using DB2 to support integrity and concurrency requirements
    List and describe the components of DB2
    Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
    Use autonomic features of DB2
    Implement DB2 security
   
Course outline

Overview of DB2 9 on Linux, UNIX and Windows
    Contrast the DB2 Family of products
    Identify the DB2 Products
    Describe the functions of DB2 components
    Explore installation and parameters

Command Line Processor (CLP) and GUI usage
    Use the Command Line Processor
    Explore the GUI environment
    Describe the DAS role with GUI tools

The DB2 environment
    Specify the key features of an Instance
    Create and drop an Instance
    Use db2start and db2stop
    Distinguish between types of configuration
    Describe and modify the Database Manager Configuration

Creating databases and data placement
    Review specifics of creating a database
    Explore the System Catalog tables and views
    Compare DMS versus SMS table spaces
    Describe how to setup and manage a DB2 database with Automatic Storage enabled
    Differentiate between table spaces, containers, extents, and pages
    Define table spaces
    Use the get snapshot for tablespaces command to display table space statistics
    Explore Database configuration parameters

Creating database objects
    List DB2 object hierarchy and physical directories and files
    Create the following objects: Schema, Table, View, Alias, Index
    Explore the use of table partitioning
    Review the use of Temporary Tables
    Explore the use and implementation of Check Constraints, Referential Integrity and Triggers
    Exploring the need for and the use of Large Objects
    Recognize XML and its native store as critical infrastructure for emerging technologies

Moving data
    Discuss the INSERT statement and recognize its limitations
    Explain the differences between IMPORT and LOAD
    Explain the EXPORT, IMPORT, and LOAD syntax
    Create and use Exception Tables and Dump-Files
    Distinguish and resolve Table States: Load Pending and Set Integrity Pending
    Use the SET INTEGRITY command
    Discuss the db2move and db2look commands

Backup and recovery
    Describe the major principles and methods for backup and recovery
    State the three types of recovery used by DB2
    Explain the importance of logging for backup and recovery
    Describe how data logging takes place, including circular logging and archival logging
    Use the BACKUP, RESTORE, and ROLLFORWARD commands
    Perform a table space backup and recovery
    Restore a database to the end of logs or to a point-in-time
    Discuss the configuration parameters and the recovery history file and use these to handle various backup and recovery scenarios

Locking and concurrency
    Explain why locking is needed
    List objects that can be locked
    Describe and discuss the various lock modes and their compatibility
    Explain four different levels of data protection
    Set isolation level and lock time out for current activity
    Explain lock conversion and escalation
    Describe the situation that causes deadlocks

Problem determination
    Collect information for problem analysis and resolution
    Use error logs for basic problem analysis
    Describe four types of monitors: Snapshot Monitor, Event Monitor, Activity

Monitor, and Health Monitor
    Describe the function of EXPLAIN and use this facility to assist basic analysis
    Use a series of basic commands to better work with connections and sessions
    Retrieve statistics and other information from a running DB2 instance
    Use RUNSTATS, REORGCHK, and REORG to resolve application performance problems

Security
    Use DB2 access control mechanisms to implement security within the database
    Use group IDs to create a control hierarchy
    Describe Label Based Access Control (LBAC)
    Describe privileges within a database
    Describe privileges required for binding and executing a package
    Describe the difference between explicit privileges and implicit privileges
    Describe the different DB2 authorization levels

三、 企业团体定制介绍
   1、可提供团体定制培训,为企业量身定做。
   2、咨询热线:021-64472947

  >>> 这个课程我有问题向老师咨询
姓 名: 慧谷联络,不对外公布
电 话: 慧谷联络,不对外公布
邮 件: 慧谷回复提问,不对外公布
问 题:
验 证:  
 
 
查看DB2 9 Database最新开班时间    
最新课表 学院优势 学院新闻 授权证书 交通地图 师资力量 教学环境 分校地址 实验申请 证书查询 成绩查询 联系我们 

上海慧谷职业技能培训中心  徐汇区乐山路33号2号楼4楼  
报名热线:021-64076538   64470100   54510150   64482972
Q Q:56823   MSN:xiangyin2005@hotmail.com   Email:train@withub.org
Copyright© 2006—2008 All Right Reserved  IP/ICP备案:沪ICP备09071445号
劳动局认证批准文号:沪劳保技(2003)34号    教育局认证批准文号:徐教社(2005)310号