IBM DB2

IBM DB2

0 STUDENTS ENROLLED

    \Introduction

    IBM DB2 belongs to the relational database family and its one of the IBM products to serve database service to an organization. It delivers strong industry leading performance, high availability and mission critical assistance, reliability of the platform, handling high value workloads, robust, optimize performance, reduce both total cost of ownership and operational cost. It can be easily used on the premises, in private or public environments. It includes a range of management and application development tools. It can advance from a single user application to a multiuser system. And it also delivers simultaneous user access from DB2 and other databases using SQL.

    COURSE SUMMARY

    Course Name IBM DB2 Online Training
    Contents Fundamentals and Concepts of IBM DB2
    Duration 30 Hours with Flexible timings
    Delivery Instructor Led-Live Online Training
    Eligibility Any Graduate
    Ideal For Fresher, Aspiring job seekers in the field of Database
    Next Batch Please visit the schedule section

    Course Objectives

    • Learn about relational database concepts.
    • Understand the DB2 environment.
    • Learn the concepts of information and data models.
    • Learn about DB2 servers, clients and drivers.
    • Learn about Data Studio and its installation.
    • Learn how to advance data using the UPDATE statement.
    • Learn how to navigate the Data Studio workbench.
    • Learn how to work with operating system scripts.
    • Learn how to work with the different DB2 database objects.
    • Learn to how to work with ER diagrams.

    PRE-REQUISITES:  Basic Concepts of Unix and Shell Scripting

    Course Curriculum

    MODULE 1: OVERVIEW OF DB2

    TOPICS: Db2 Family Product Overview, Db2 Product Features And Functions, Db2 Luw Product Editions, Db2 Client Connectivity Options

    MODULE 2: COMMAND LINE PROCESSOR AND GUI USAGE

    TOPICS: Introduction To Db2 Clp Environment, Interactive Mode, Non-Interactive Mode, Client Connectivity From Data Studio, Db2 Command Line Options

    MODULE 3: THE DB2 DATABASE MANAGER INSTANCE

    TOPICS: Database Manager Instance Overview, Create And Drop An Instance, Db2 Instance Generation Prerequisites, Starting And Stopping An Instance, Db2 History Command, List And Modify The Dbm Configuration, Db2 Registry And Environment Variables, Db2set Command

    MODULE 4: CREATING DATABASES AND DATA PLACEMENT

    TOPICS: Table Spaces Overview, Storage Management Overview, Default Table Spaces, Database Generation Prerequisites, List Db Setup Parameters, Database Directories And Files Introduction, Database Storage Requirements, Modify Db Configuration Parameters, Containers And Pages Overview, Create Database Command, System Catalog Tables And Views, Storage Groups Overview, Assigning A Table Space To A Storage Group Activate And Deactivate A Database, , Introduction To Db2pd Command

    MODULE 5: CREATING DATABASE OBJECTS

    TOPICS: Db2 Object Hierarchy, Create Alias, Index, Trigger, Create Table, View, Referential Integrity, Creation Of Temporary Tables, Table Partitioning, Create Schema, Keys, Constraints, Db2look Cli Command, Creation OF TEMPORAL TABLES, AUTHORIZATION & AUTHENTICATION

    MODULE 6: MOVING DATA

    TOPICS: Import Versus Load, Load Query Table, Offline Versus Online Load, Export Command, Admin_Mov_Table Procedure, Db2 List Utilities, Pending States

    MODULE 7: BACKUP AND RECOVERY

    TOPICS: Recovery Utility Options, Transactional Logging, Backup Utility Options, Rollforward, Configure Database Logs, Online Versus Offline Backup, Db2 Recover Database

    MODULE 8: LOCKING AND CONCURRENCY

    TOPICS: Importance Of Locking, Row Lock Modes, Table Lock Modes, Isolation Levels, Lock Table Statement, Lock Mode Compatibility, Deadlocks And Detection, Lock Escalation, Timeout And Wait

    MODULE 9: SECURITY

    TOPICS: Sysmon, Sysctrl, Sysadm, Sysmaint, Authentication Versus Authorization, Accessctrl, Secadm, Dbadm, Grant And Revoke Privileges, Db2 Security Privilege Hierarchies

    MODULE 10: LOG MANAGEMENT AND PERFORMANCE TUNING

    TOPICS: Log Sequence Numbers, Database Seeds, Logsecond And Logprimary, Db2pd To Check Logging Activity, Log Retrieval Processing, Log Archive Processing, Create An Access Plan Graph, Analyze Sql Statements, Using Indexes For Performance, Clustering Indexes, Index Usage Statistics Using Db2pd

    MODULE 11: ADVANCED MONITORING

    TOPICS: Get Snapshot Command, Monitoring Table Functions, Monitoring Performance With Sql, Monitoring Performance With Sql, In Memory Metrics, Administrative Functions And Views, Monitor With Sql

    Write a Review

    Your email address will not be published. Required fields are marked *

    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. keen Technologies also verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.

    You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.

    Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, India and other parts of the world.

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 1 month
    Contact Us

    +1 475-212-0075

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies

    Disclaimer

    This web site or keentechnologies.com team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. Keen Technologies does not provide official SAP training courses or certifications and does not provide any access to SAP software. SAP and its product names, including HANA, S/4HANA, HYBRIS, and LEONARDO are trademarks or registered trademarks of SAP in Germany and other countries.

    Keen Technologies does not provide official SAP training courses or certifications and does not provide any access to SAP software. SAP and its product names, including HANA, S/4HANA, HYBRIS, and LEONARDO are trademarks or registered trademarks of SAP in Germany and other countries.

    IBM® is a registered trademark of IBM in the United States.

    Popular Courses

    Countries

    Keen Technologies offering training in cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Texas, Chicago, San Francisco, Dallas, Washington, New York, Houstan, Atlanta, Orlando, Boston, Toronto, Ottawa, Windsor, Australia, Dubai, Leeds.


    ONLINE MEETING PARTNERS

    top
    COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED
    WhatsApp us whatsapp