IBM DB2 Course Overview
IBM DB2 Training Course Content
Relational Data Model :
Data and Databases, Database Management Systems (DBMS), Information Model & Data Model, Relational Data Model & Relational Databases, Normalization
DB2 Fundamentals And Ibm Data Studio Tool
Product Overview, Editions & Features, Licensing, Fundamentals, Architecture, Users, Instances, DB2 Client
Storage, Table spaces, Buffer pools, Security, SQL and XQuery, IBM Data Studio, DSAC
Installation and Configuration (Working With Windows Os)
Installation, Configuration, Database creation, Instance creation, Table space Creation, Working with Buffer pool
Working with Databases and Database Object in Db2
Servers, Instances, and Databases, Managing Instances, Creating a DB2 Database Cataloging, Database (Data) Objects
Introduction to Sql
SQL, Data Definition Language, Data Manipulation Language, JOINs, Data Control Language, Transaction Control Statements
Data Concurrency
Database Transactions, Concurrency, Concurrency Issues, Concurrency Control, Isolation Levels, Locking, Specifying Isolation Levels
DB2 Security
Authentication, Trusted Context, Authorization, Authorities Privileges, Label-Based Access Control (LBAC), ROLES
DB2 Bbackup and Recovery
Backup, Recovery
DB2 Pure XML
Overview of XML, PureXML in DB2, XML Data Movement in DB2, XQuery and SQL/XML, XML Indexes in DB2, Application Development
DB2 Programming Fundamentals
Application Development Environment, Embedded SQL, Static SQL, Dynamic SQL, Routines, Types, Benefits, Usage, Tools for Developing Routines, Triggers
|
| Course Duration |
30 hrs |
| Live Projects |
2 |
| Next Batch |
12 Jul, 2020 |
