Database management System

Introduction Database Management System

• Installing & Configuring PostgreSQL
• Pre-installation Tasks
• Downloading and Installing PostgreSQL
• Using Configure Arguments
• Configuring PostgreSQL to Start on Boot
• Configuring PostgreSQL for Network Access
• Exercises
• Using the psql Client
• Connecting to PostgreSQL
• Psql Meta-Commands
• Psql Internal Variables
• Understanding PostgreSQL Data Types

Understanding PostgreSQL Data Types

• What are Data Types?
• Numeric Data Types
• Integer Types
• Arbitrary Precision Numbers
• Floating Point Types
• Serial Types
• Character Types
• Binary Data Types
• Date & Time Types
• Boolean Values
• Array Types
• Other Data Types
• Exercises

Understanding Sequences

• Sequence Numbers
• Creating a Sequence
• Exercises

Creating & Managing Indexes

• Understanding Indexes
• PostgreSQL Index Types
• Creating Indexes
• Indexes on Expressions
• Partial Indexes
• Using COPY to Load Data
• Exercises
• Using COPY to Load Data
• Exercises

PostgreSQL Functions

• Numeric Functions
• Character Functions
• Session Information Functions
• Transactions and Concurrency
• Transactions
• Transaction Isolation
• Working with Array Values
• Accessing Array Values
• Array Functions

Writing Triggers &Stored Procedures with PL/pgSQL

• What is PL/pgSQL?
• Creating a PL/pgSQL Procedure
• Session Information Functions
• Function Volatility
• Function Security
• Variables in Procedures
• Special Data Types
• Decision Making
• Performing Loop Operations
• Returning Values from Functions
• Returning Table Data Sets

Parameter Notes

• The PERFORM and EXECUTE Statements
• Error Handling
• Handling Exceptions
• Working with Cursors
• Unbound Cursors
• Scrollable Cursors
• Repositioning Scrollable Cursors
• Updating Rows using Cursors
• The FOUND Variable
• Triggers in PostgreSQL
• Using the PostgreSQL Query Optimizer
• Analyzing and Optimizing Queries
• Using EXPLAIN to View Execution Plans

Understanding PostgreSQL's Query Operators

• The “Seq Scan” operator
• The Index Scan Operator
• The Sort Operator
• The Unique Operator
• The Limit Operator
• The Aggregate Operator
• The Append Operator
• The Result Operator
• The Join Operators
• The Group and HashAggregate Operators
• The Subquery Scan and Subplan Operators
• The TID Scan Operator
• The Materialize Operator
• Setop Operators
• Improving Query Performance

Introduction to IBM DB2 Training

• Data and Databases
• DBMS(Database Management Systems)
• Information Model & Data Model
• Relational Data Model & Relational Databases
• Normalization

DB2 Fundamentals & IBM Data Studio Tool

• Product Overview
• Editions & Features
• Licensing
• DB2 Fundamentals
• DB2 Architecture
• Users
• Instances
• DB2 Clients
• Storage
• Table Spaces
• Buffer Pools
• Security
• SQL and XQuery
• IBM Data Studio
• DSAC

Installation And Configuration(Working with Windows OS)

• Installation And Configuration
• Database Creation
• Instance Creation
• Table Space Creation
• Working with Buffer Pool

Working With Databases & Object In DB2

• Servers , Instances, And databses
• Managing Instance
• Creating a DB2 Databse
• Cataloging
• Database(Data) Objects

Data Concurrency

• Database Transactions
• Concurrency
• Concurrency Issues Concurrency Control
• Isolation Levels
• Locking
• Specifying Isolation Levels

DB2 Security

• DB2 Authentication
• Trusted Context
• Authorization & Authorities
• What are the Privilleges?
• Label-Based Access Control(LBAC)
• Roles
• DB2 Backup And 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 and Usage
• Explain about tools for developing routines triggers

Using the Psql client

• Basic Knowledge about DATABASE
• DDL, DML, DCL and TCL commands
• Joins
• Operators
• Understanding PostgreSQL data types
• Numeric data types
  1] Integer data types
  2] Floating point types
  3] Serial types:-
  a] Character Types
  b] Binary data Types
  c] Date & time Values
  d] Boolean Values
  e] Array Types
  f] Other data types
• Understanding sequences
• Creating & managing indexes
• Understanding PostgreSQL indexes
  1] Partial indexes
  2] Indexes on expressions
• Using COPY to load data
• Working with Array Values
• Advanced SQL Functions
  1] Using Common Table Expressions (CTE)
  2] Views
• Writing triggers & stored procedures with PL/Psql
  1] Variables in procedures
  2] Performing loop operations
  3] The PERFORM and EXECUTE statements
  4] Triggers in PostgreSQL
• Using the PostgreSQL query optimizer
  1] Analyzing & optimizing queries
  2] Viewing execution plans with EXPLAIN
  3] Understanding PostgreSQL query operators
• Improving query performance
• User Defined Functions