Stay home stay safe-- Due to the Covid-19 outbreak all our course will be conducted online. For more inform please contact-9619341713 / 7045481713

  • +91-9619341713-Airoli/ 7045481713-Mahape/ 7045911713-Kalyan

Learn Basic Database Training

Learn Basic & Advanced Database Training start for beginner

Courses
Course Summery

A DBMS is a software that allows creation, definition and manipulation of database, allowing users to store, process and analyse data easily. DBMS provides us with an interface or a tool, to perform various operations like creating database, storing data in it, updating data, creating tables in the database and a lot more. DBMS also provides protection and security to the databases. It also maintains data consistency in case of multiple users.

Requrements

  • Creation of a database
  • Retrieval of information from the database
  • Updating the database
  • Managing a database

Learn Manual PostgreSQL Contents
  • 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
  • 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
  • Sequence Numbers
  • Creating a Sequence
  • Exercises
  • Understanding Indexes
  • PostgreSQL Index Types
  • Creating Indexes
  • Indexes on Expressions
  • Partial Indexes
  • Exercises
  • Using COPY to Load Data
  • Exercises
  • Using COPY to Load Data
  • Exercises
  • Numeric Functions
  • Character Functions
  • Session Information Functions
  • Transactions and Concurrency
  • Transactions
  • Transaction Isolation
  • Working with Array Values
  • Accessing Array Values
  • Array Functions
  • 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
  • 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
  • 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
IBM DB2 Training
  • Data and Databases
  • DBMS(Database Management Systems)
  • Information Model & Data Model
  • Relational Data Model & Relational Databases
  • Normalization
  • 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
  • Database Creation
  • Instance Creation
  • Table Space Creation
  • Working with Buffer Pool
  • Servers , Instances, And databses
  • Managing Instance
  • Creating a DB2 Databse
  • Cataloging
  • Database(Data) Objects
  • Database Transactions
  • Concurrency
  • Concurrency Issues Concurrency Control
  • Isolation Levels
  • Locking
  • Specifying Isolation Levels
  • DB2 Authentication
  • Trusted Context
  • Authorization & Authorities
  • What are the Privilleges?
  • Label-Based Access Control(LBAC)
  • Roles
  • DB2 Backup And Recovery
  • Overview of XML
  • PureXML in DB2
  • XML Data Movement in DB2
  • XQuery and SQL/XML
  • XML Indexes in DB2
  • Application Development
  • Application Development Environment
  • Embedded SQL
  • Static SQL
  • Dynamic SQL
  • Routines
  • Types,Benefits and Usage
  • Explain about tools for developing routines triggers
Load Runner Testing Training
  • Functionality Testing Tools
  • Performance Testing Tools
  • Test Management Tools
  • Performance Testing Types
  • Load Testing
  • Stress Testing
  • LoadRunner Architecture
  • LoadRunner Testing Process
  • Define measureable goals for testing
  • Gather information before testing
  • Document and organize system information
  • Structure the script based on planning
  • Use VuGen to record a Vuser script for Web environment
  • Describe HTML and URL recording levels
  • When to use HTML and/or URL recording levels
  • Identify the appropriate web Run-time settings to set
  • Configure Web Run-time settings to run the script
  • Verify Vuser script functionality in VuGen
  • Create multiple actions in a Vuser script
  • Configure actions to achieve load testing goals
  • Add Transaction to measure response timesn
  • Solve play back problems by Parameterizing the script
  • Identify visual cues to check for during load testing
  • Add Text Checkpo8ints during and after recording
  • Distinguish between available correlation methods
  • Correlate a script manually using correlation functions
  • Correlation during and After recording
  • Correlation after recording
  • Use the scan for correlation tool
  • Correlate data during recording
  • Define rules for correlation in Recording Options
  • Enable correlation during recording
  • Explain elements that make a LoadRunner scenario
  • Identify different types of scenarios
  • How to choose the scenario
  • Present the basic steps for creating a scenario
  • Script and scenario Run – Time settings
  • Configure Run-Time settings in the Controller
  • Prepare for a scenario run
  • Identify techniques to efficiently run a scenario
  • Scheduling group and by scenario
  • Prepare VuGen user (Vuser) Initialization
  • Configure Scenario ramp up and ramp down
  • Value of Performance Monitors
  • Select Performance Monitors
  • Add measurements to Performance Monitors
  • Performance Overlays to track down bottlenecks
  • Value of root cause analysis – resources bottleneck, code loopss
  • Diagnose errors with LoadRunner Application and Architecture
  • Meaningful interpretation of LoadRunner graphs
Selenium Training
  • Introduction to Automation and Selenium WebDriver
  • Why selenium?
  • Setup:
  • Downloading Jars of WebDriver
  • Configuring in eclipse
  • Configuring Java
  • First selenium program for login
  • How to login or perform click by code other than clicking
  • Locators:
  • Identifying WebElements using different locators: xapth, css, id, name, class etc.
  • Absolute and complete Xpaths
  • Creating customized Xpaths (different types of xpaths creations and its types)
  • Different Webdriver functions (All methods and actions that can be achieved with selenium )
  • Introduction to Selenium IDE
  • How to record and play with IDE
  • How IDE helps in identifying elements
  • Various helpful plugins like firebug and firepath
  • Waits:
  • Hard wait
  • Implicit wait
  • Explicit wait
  • Browser support: Working with Firefox, chrome and IE browser
  • FindElement vs FindELements
  • isDisplayed, isEnabled, isSelected methods
  • Retrieving multiple elements from a page
  • Managing Ajax based components
  • Handling applications having frames with selenium
  • Handling frame inside frame
  • Handling new windows
  • Handling java script alerts/popups
  • Handling Dropdowns with selenium
  • Handling multiple windows
  • Password encoding with selenium
  • Managing front and back button click on Browser using selenium
  • Finding number of links on a webpage without clicking
  • Uploading different files on web using browser button
  • Downloading files from web
  • How to handle desktop based dialogues
  • Handling/Managing cookies
  • Simulating all keyboard buttons with selenium
  • Actions class in Webdriver
  • Moving curser to element by hovering
  • Dragging and dropping by coordinates
  • Dragging and dropping by element
  • Sliding
  • Taking screen shots with selenium
  • Exception handling in Selenium (concept showed in framework)
  • Concept of firefox profile
  • Using Javascript in Selenium -- JavaScriptExecutor example
  • Connecting to SQL database with selenium
  • Concept of Robot and AutoIT in selenium
  • Managing Certification errors
  • Some Good Exercise questions
  • Complete discussion on interview questions and how to crack any interview
  • How to implement automation in organization in any project
  • Help is provided for any problems faced in official project
  • Introduction to framework
  • Different types of frameworks
  • Structure / Architecture of framework
  • Building framework from scratch on a live application
  • Ensuring framework can be reused, maintained and stable.
  • Reading test data from different files like excel, propertiesfile, json, yml etc.
  • Implementing POM (Page object design technique in framework
  • Implementing Page factory in framework
  • Implementing screenshot on test failure
  • Extended HTML reporting
  • Running Test cases from terminal
  • Running test cases from batch file
  • Introduction to BDD Cucumber framework
  • Advantage of BDD Cucumber framework
  • Introduction to TestNG
  • TestNG vs Junit
  • Installing TestNg in Eclipse
  • TestNg annotations and Usage
  • Creating test suite with testng
  • Running single Test in TestNg
  • Running multiple tests in Testng
  • Parameterizing Tests with TestNG– DataProvider
  • Assertions/Reporting Errors
  • Batch Running of tests in TestNg
  • Running test in parallel with testng
  • Concepts of OOPS, classes , variables and methods
  • Inheritance
  • Constructors
  • Static/non static
  • Exception handling
  • Loops. If loop, for loop etc.
  • Data types
  • Conversation of one data type to another ,like int to string
  • Exception handling , try catch
  • All what is needed for Selenium
  • Introduction to Grid
  • Use of grid
  • ConstructorsHub and Nodes in Grid
  • How to setup grid
  • How to run tests in parallel using grid
  • Introduction to ANT (build tool)
  • Implementing ANT in framework
  • ANT vs MAVEN
  • Introduction to Jenkins (CI tool)and its use in organization to run automation suites
  • Introduction to Agile and its methodology
  • How selenium fits in Agile based projects
  • SVN vs GITLAB
  • How to commit code in Git repositories and how it is used in orgainzations
JMeter Training
  • Overview of Performance Testing
  • Performance Testing Concepts
  • Performance Testing Types
  • Why to use performance Testing tool?
  • What is JMeter?
  • JMeter’sClasspath
  • Using a Proxy Server
  • Non-GUI Mode
  • Distributed Mode
  • Thread Group
  • Controllers
  • Samplers
  • Logic Controllers
  • >Listeners
  • Timers
  • Assertions
  • Configuration Elements
  • Pre-Processor Elements
  • Post-Processor Elements
  • Adding and Removing Elements
  • Loading and Saving Elements
  • Configuring Tree Elements
  • Running a Test Plan
  • Adding Default HTTP Request Properties
  • Adding Cookie Support
  • Adding HTTP Requests
  • Adding Post-Processor for Correlation
  • Adding a Listener to View/Store the Test Results
  • Saving the Test Plan
  • Running the Test Plan
  • Creation of Thread Group
  • Adding HTTP Proxy Server
  • Configuring HTTP proxy server
  • Configuring the browser for recording the test script
  • Capturing the test steps using JMeter
  • Handling User Sessions with URL Rewriting
  • Using a Header Manager
  • Handling the dynamic server values
  • Parameterize the user sessions
  • Identifying the test data on AUT
  • Open a csv file with JMeter
  • Reading the data from CSV files
  • Using the parameters in JMeterTests
  • Validating the response data related issues
  • Validating the response size related issues
  • Validating the threshold for the server response times
  • Running the tests and analyzing the Assertion results
  • Adding Server
  • Adding HTTP Requests
  • Adding Constant Timer
  • Adding a Listener to View/Store the Test Results
  • Adding Monitor Results
  • Saving the Test Plan
  • Running the Test Plan
  • Creating multiple test thread groups
  • Calling the multiple thread groups from a test plan
  • Configuring the threads groups with respetive users numbers and ratios
  • Running the load test for multiple thread groups from a Single Test
  • Analyze the user group specific issues
  • Analyze the Test plan specific issues for all user groups
  • Adding the Assertion Results and monitoring
  • Configuring and Generating the Distribution Graph
  • Configuring and Generating the Graph Full Results
  • Generating the Monitor Results
  • Saving the data through Simple Data Writer
  • Configuring and Generating the Spline Visualizer
  • Generating the Aggregate Graph for multi group test
  • Generating the Aggregate Report for multi thread group test
  • Generating the Summary Report
  • Limit the Number of Threads
  • Where to Put the Cookie Manager
  • Where to Put the Authorization Manager
  • Reducing resource requirements
  • BeanShell server
  • Distributed Testing
Tosca
  • Introduction to Automation
  • What is automation?
  • When and Why automation
  • Advantages and Disadvantages
  • Different Types Of Automation Tools
  • What is TOSCA Test Suite
  • Installation / Setup
  • System Requirements
  • Process to Download Tosca
  • Process to Install Tosca
  • Introduction to TOSCA
  • Create project in TOSCA Test Suite
  • Components of Tosca
  • Test Process Flow in TOSCA
  • Tosca Commander
  • Requirement Section
  • Test case Design Section
  • Modules section
  • Test Case Section
  • Execution List Section
  • Issues Section
  • Record / Playback
  • Recording Manual Test cases
  • Recording Automated Test cases
  • Recording Automated data driven Test Cases.
  • Modules Section
  • Introduction of Modules
  • Types of Modules
  • what is object Identification
  • How to scan Application
  • Create user define Modules
  • Various methods for Object Identification
  • Identify By Properties
  • Identify By Anchor
  • Identify By Image
  • Identify By Index
  • what is standard Modules
  • Re-Scan Modules in Tosca
  • Merge Modules in Tosca
  • Action Modes
  • Working with various action modes
  • Input
  • Verify
  • WaitOn
  • Buffer
  • Select
  • Constraint
  • Synchronization
  • TBox Wait
  • Synchronization Time Out
  • Synchronization Time Out During Wait on
  • If Else Condition
  • while statement
  • Do-while
Test Cases Creation
Create Test Cases in Tosca test suite
  • Internet Explore
  • FireFox
  • Chrome
  • create TCP
  • Types of TCP
  • Project root element
  • Test case folder
  • Test case
  • Execution List Folder
  • Execution List
  • Execution entry folder
  • Execution entry
  • Buffer in TOSCA Test Suite (Storing Value to variable)
  • Create Requirements
  • Link test Cases to Requirements
  • Test Case Design Section
  • Data Driven Testing
  • Create Reusable Test step Blocks(RTB)
  • use reusable test step blocks in test cases
  • business parameters in Tosca test suite
  • create test sheet in TCD
  • create Attributes & Instances
  • Generate Instance
  • create test case template
  • link test sheet to template
  • Execution Lists
  • what is execution lists
  • create Execution lists
  • Execute Test cases
  • Execute Manual Test cases
  • Issue Section/Defect Management
  • how to create defect
  • create defect from execution list
PostgreSQL (SQL) Training
  • Basic Knowledge about DATABASE
  • DDL, DML, DCL and TCL commands
  • Joins
  • Operators
  • Understanding PostgreSQL data types
  • Numeric data types
    • Integer data types
    • Floating point types
    • Serial types
      • Character Types
      • Binary data Types
      • Date & time Values
      • Boolean Values
      • Array Types
      • Other data types
  • Understanding sequences
  • Creating & managing indexes
  • Understanding PostgreSQL indexes
    • Partial indexes
    • Indexes on expressions
  • Using COPY to load data
  • Working with Array Values
  • Advanced SQL Functions
    • Using Common Table Expressions (CTE)
    • Views
  • Writing triggers & stored procedures with PL/Psql
    • Variables in procedures
    • Performing loop operations
    • The PERFORM and EXECUTE statements
    • Triggers in PostgreSQL
  • Using the PostgreSQL query optimizer
    • Analyzing & optimizing queries
    • Viewing execution plans with EXPLAIN
    • Understanding PostgreSQL query operators
  • Improving query performance
  • User Defined Functions