Courses

    Pages & Posts

      • IT Training
        • Amazon Cloud (AWS)
        • Analytics and Big Data
        • Blockchain
        • Cisco
        • Citrix
        • CompTIA Certifications
        • Cybersecurity
        • Development Tools
        • DevOps
        • F5
        • Google Cloud
        • IBM
        • Java
        • Juniper Networks
        • Linux
        • Microsoft
        • Microsoft ON-DEMAND
        • Mobile Computing
        • NetApp
        • Nutanix
        • Oracle
        • Salesforce
        • VMware
        • Web Development, HTML, and JavaScript
      • Business Training
        • Business Analysis
        • Enterprise Architecture
        • HIPAA Certification & Training
        • IT Governance
        • ITIL® Certification
        • Program / Project Management
        • Salesforce
        • Scrum & Agile
        • Seminars
      • Services
        • Cybersecurity Compliance and Risk Management
        • Enterprise Learning Solutions
        • IT Performance Management
        • Media Security Solutions
        • Microsoft Certificate Program
        • Returning Citizens Initiative
        • Rental Request Form
        • State & Local Government
      • Student Resources
        • Navigating Babbage Simmel Academy Courses
        • Student Guide / Daily Schedule
        • College Credit / Tuition Reimbursement
        • Student Policies
        • Testing & Certifications
        • Promotions
        • Area Hotels
        • Area Restaurants
      • DB2 9 for Linux, UNIX, and Windows Advanced Database Administration

      Course Details

      Download PDF
      BSP-1861
      5 Days
      2 (?)
      $3,000.00
      Request a Course Date

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

      Share this course

      Tweet Share
      This comprehensive 5-day course prepares the student for challenging questions on database design; data partitioning and clustering; high availability diagnostics; performance and scalability; security and encryption; connectivity and networking; and much more.
      • Course Outline
      • Audience

      Course Outline

      Database Design  Servers, Instances, and Databases  Creating a Non-partitioned DB2 Database  Creating a Partitioned DB2 Database  Buffer Pools  Table Spaces  Expanding a Database's Boundaries with Federated Systems Data Partitioning and Clustering  Parallelism  Partitioned Databases - A Closer Look  Partition Groups  Partitioning Keys and Partitioning Maps  Range Clustering and Range Partitioning  Multidimensional Clustering  Combining Database and Table Partitioning, with   Multidimensional Clustering  The Design Advisor  The Balanced Configuration Unit High Availability and Diagnostics  Transactions  Transaction Logging  Database Recovery Concepts  Performing a Crash Recovery Operation  Backup and Recovery  Backing Up and Restoring a Partitioned Database  Testing the Integrity of a Backup Image  Backing Up a Database with Split Mirroring  Managing Log Files With a User Exit Program  High Availability Disaster Recovery (HADR)  Problem Determination Tools Performance and Scalability  Basic Performance Tuning  Tuning the DB2 Environment  Configuring Instances and Databases  Self-Tuning Memory Manager  Indexes  Object Statistics and the RUNSTATS Utility  The DB2 Optimizer  Optimizer Techniques  Writing Better Queries  More About Joins  Locking  Analyzing DB2 Query Access Plans  Taking Control of The Server  Deep Compression Security  Controlling Database Access  Authentication  Authorities and Privileges  Granting Authorities and Privileges  Authorities and Privileges Needed to Perform Common Tasks  Securing Data Using Encryption  Securing Data with Label-Based Access Control (LBAC)  DB2's Audit Facility Connectivity and Networking  Configuring Communications  DB2's Directory Files  Cataloging Remote Servers and Databases  DB2 Discovery  Fast Communications Manager (FCM) Communications  Troubleshooting Communications Errors

      Audience

      Database administrators versed in DB2 wanting to learn more about advanced database administration activities and students wishing to gain knowledge to help them pass the DB2 9 UDB Advanced DBA certification exam

      Related Courses

      DB2 Administration, Performance and Procedure...

      This course is custom designed to review the Administration of DB2 version 9.7 f...

      View course details

      Enterprise Linux Network Services...

      The SL-275 is an expansive course that covers a wide range of network services u...

      View course details

      Enterprise Linux System Administration...

      The SL-250 class is an in-depth course that explores installation, configuration...

      View course details

      College Credit, CEUs, PDUs and CDUs
      When you take courses with the Babbage Simmel, be sure you get the credit you deserve. Curriculum offered by Babbage Simmel can earn you college credit, CEUs, PDUs or CDUs.

      College Credit
      Select curriculum offered by Babbage Simmel can be utilized for College Credit. For questions please E-Mail: info@babsim.com or call 614-481-4345.

      Continuing Education Units (CEUs)
      Continuing Education Units (CEUs) are nationally recognized standard units of measurement earned for satisfactory completion of qualified programs of continuing education. If you need more information about CEUs, please E-Mail: info@babsim.com or call 614-481-4345.

      Professional Development Units (PDUs)
      Professional Development Units (PDUs) can be issued by PMI® for formal learning activities related to project management. Project Management Professionals (PMPs®) are required to earn a minimum of 60 PDUs every 3 years to maintain certification. For more information about this program go to the PMI® web site or call 1-855 746 4849.

      Continuing Development Units (CDUs)
      CDUs may be earned by attending professional development (e.g. courses, seminars) offered by organizations endorsed by IIBA® and designated as an EEP vendor. As an IIBA Endorsed Education Provider (EEP) Babbage Simmel's IIBA® endorsed courses qualify for CDU credit. For more information about CDUs go the IIBA® web site or call 1-647-426-3735.

      Our babsimLIVE distance learning brings the classroom learning experience to you by seating you virtually into a real-life instructor-led classroom taught by award winning world-class instructors with other IT professionals like yourself. From the comfort of your home, workplace, or at the Babbage Simmel Columbus Campus, you acquire the training you need, when you want it, in the environment that is most comfortable for you to be successful.

      About Us Contact Us Blog Find A Course

      © Copyright 2019 • Babbage Simmel. All Rights Reserved. Columbus Web Design by Jetpack | Privacy Policy