Course Contents

&#10004What is Data Warehouse?
✔Need of Data Warehouse
✔Introduction to OLTP, ETL and OLAP Systems
✔Difference between OLTP and OLAP
✔Data Warehouse Architecture
✔Data Marts
✔ODS [Operational Data Store]
✔Dimensional Modelling
✔Difference between relation and dimensional modelling
✔Star Schema and Snowflake Schema
✔What is fact table?
✔What is Dimension Table?
✔Normalization and De-Normalization
✔ETL architecture.
✔What is ETL and importance of ETL testing ?
✔How DWH ETL Testing is different from the Application Testing
✔SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)
✔Installation of Python and Selenium Webdriver Package for Python
✔Selecting Python Editor
✔Prepare Your First Selenium Webdriver Automation Script Using Python
✔Write a Script for Firefox Browser
✔Decoding the Automation Script
✔Creating Selenium Webdriver and Python Scripts for
✔Internet Explorer
✔Google Chrome
✔Different Navigation Methods in Python
✔How to Switch between Windows
✔How to Switch between IFrames
✔Learn to Handle Alert & Popup Boxes
✔How to Locate Elements Using Selenium Python
✔How to Use Selenium WebDriver Waits in Python
✔Using Python UnitTest for Automation
✔Web Services introduction – Concepts & Jargons made simple
✔Introduction to Groovy Scripting and contextual coverage of Groovy.
✔Introduction and in-depth coverage of SOAP UI tool(SOAP UI 5.2.1 & Ready API 1.5.0)
✔Reading of various files using Groovy Scripting in SOAP UI(Properties File & Excel file)
✔In depth coverage of Assertions concept
✔Introduction to “log” object in SOAP UI & the log4j package
✔Introduction to “Context” object in SOAP UI & its usage
✔Introduction to “Test Runner” object  in SOAP UI & its usage
✔“Properties” demystified & deep dive into Properties
✔In depth REST web service testing using Ready API 1.5.0
✔Database Access using MySql
✔Framework – Core Framework using SOAP UI 5.2.1(free version)
✔Framework – Data Driven Framework using Ready API 1.5.0(Licensed)
✔What is WebServices?,WSDL, SOAP, SOAPUI Pro Tool, XML
✔Discuss couple of projects developed with WebServices
✔Why WebServices are Being Used
✔SoapUI Pro – Download, Installation
✔How to create project and add multiple WSDL to one project
✔XML, WSDL, SOAP and REST protocols
✔Testing Web Services with SoapUI Pro
✔Adding properties to Project and how to use the values from project level and Test Suite level properties indifferent scenarios
✔Creating Mock Services using SoapUI pro
✔Parameterization of Data / Data Driven Testing using SOAPUI tool – using data from local Excel file.
✔Create Automation Test Suite, Test case and adding steps to each test case
✔How to add and implement
✔SOAP Test Request
✔Groovy Script
✔Properties
✔Property Transfer
✔DataGen
✔How to add Assertions and validate different scenarios in Request / Response XML and compare with pre-defined data from Properties.
✔XPath& XQuery with SoapUI
✔How to write Groovy Script – Programming standards, concepts of Variables, writing logic to validate response xml
✔Defining variables to get the data from properties
✔If condition, for loop, etc.
✔How to debug the script, log.info etc.
✔JDBC Connection. Write script to connect to Database and retrieve the data and compare the data with the response xml
✔How to add Assertions and validate different scenarios using Groovy script.
✔Overview of The Product and Platform Architectures
✔Creating and Managing Templates and Associated Page-Rendering Components
✔Installing and Utilizing CRXDE And CRXDE Lite
✔Creating A Custom Widget and CQ Package
✔Creating, Adding, And Managing Components
✔Taking Input from Authors Using Component and Design Dialogs
✔Defining and Assigning A Design to A Web Site
✔Overview of Workflow Definition
✔Overview of Mobile Content Concepts, Emulators, Components
✔Creating Custom Workflow Process Steps
✔OSGi Bundles and Consuming Classed Defined In Them
✔About XML Training
✔XML Training Course Content
✔What is XML?
✔XML Syntax
✔What is a well-formed XML document
✔What is an XML Element
✔What are the XML Naming Rules
✔What are the Best Naming Practices
✔XML Attributes
✔How to view XML files
✔How to develop an XML document
✔How to check the well-formedness of XML document
✔How to validate XML document
✔What is an XML parser? What are its functions
✔What is DTD
✔What are the constituents of DTD file? (Contains)
✔DTD – Elements
✔What is cardinality operator in DTD
✔DTD – Attributes
✔DTD – Entities
✔How to associate a DTD with XML
✔Data Types
✔XSD Restrictions/Facets
✔Non atomic Types
✔Complex Types
✔Empty Elements
✔Indicators
✔Order Indicators
✔Occurrence Indicators
✔Group Indicators
✔Annotating XML Schemas
✔XML Namespaces
✔Refer a Schema in an XML Document
✔Import/Include Schemas
✔Raster vs Vector Graphics
✔File formats for Web and Print
✔Resolution Fundamentals
✔Documents Standards for Web, Print, Mobile and Video
✔Getting to Know Work space Elements
✔Working With Selections Basic , Advanced and Auto
✔Power of Layers
✔Power of Retouching Tools
✔Creating Vector Graphics
✔Basic to Advanced Making Techniques
✔Typography tools in Photoshop
✔Color Corrections
✔Masking Beyond the limits
✔Working with Video
✔Editing and adding transitions to video
✔working with 3d Objects
✔Animation
✔Automation Tasks
✔Actions
✔Paths
✔Channels
✔Filters
✔Memory Management
✔use full menu commands in real world Scenarios
✔import and Export
✔Integration with other adobe Products
✔image optimization for web and print
✔power of Adobe Bridge
✔Web Scraping; Spiders and Crawling
✔How does Web Scraping work?
✔Robots.txt and Web Scraping Rules
✔Installation with Pycharm
✔Installation with Terminal / Sublime
✔Project Structure in Scrapy
✔Creating our first spider ( web crawler )
✔Extracting data w/ CSS Selectors
✔Running our first spider ( web crawler )
✔Extracting data w/ XPATH
✔Web Scraping Quotes and Authors
✔Item containers ( Storing scraped data )
✔Storing in JSON; XML and CSV
✔Pipelines in Web Scraping
✔Basics of Sqlite3 database
✔Storing data in Sqlite3 Database
✔