Courses & Syllabus

Selenium Syllabus - (Daily batches @7:00 am / 10:00 am / 2:00 pm)

Weekend batch - Saturdays @9:00 am &  2:00 pm
Module 1 Java Basics
  • Introduction in Java –
  • Data types –
  • Java variables –
  • Java modifiers –
  • Declarations and Assignments –
Comments in Java
  • Basic Java Syntax –
  • Classes –
  • Class variables –
  • Methods and its reusability –
  • Packages –
  • Objects –
  • Instances – Inheritance .
  • Loops – If, while, do while, for, switch –
  • String Operators –
  • Constructors –
  • Execution of classes.
  • Exception Handling
  • Basic Programming
Module #
  • Introduction to Selenium –
  • Selenium Components –
  • Selenium RC –
  • Selenium Grid –
  • Selenium IDE –
  • Selenium WebDriver.
  • Installation –
  • Basic Components of Selenium IDE –
  • Scripting in Selenium
  • IDE – Record and Play in Selenium IDE –
  • Suite execution –
  • Export the Scripts in different formats.
  • Element Inspection –
  • Installation of Firebug –
  • Inspecting the elements
Module #
  • Introduction of WebDriver –
  • Installation of JDK –
  • Installation of Eclipse –
  • Language Bindings for Selenium
  • Creation of Selenium Project.
  • Selenium WebDriver Commands –
  • Browser Commands –
  • Web elements Commands –
  • Browser
  • Navigation commands –
  • Wait commands –
  • Web Element Command –
  • Switch Command(Alert/Frame) –
  • Drop down command –
  • Mouse hovering –
  • Assert/Verify in Selenium webDriver
  • Execution of scenarios in different browser(IE/Chrome/Firefox) – Screenshot capture in Selenium
Module #
  • Test Automation Framework
  • Components –
  • Advantages –
  • Reporting mechanism.
  • Framework -TestNG
  • Installation of TestNG –
  • Importance of TestNG –
  • First scenario in TestNG –
  • Sequencing and Parameterization –
  • Report generation in framework –
  • annotations in TestNG
  • Data driven Techniques –
  • Excel sheet import and export
  • Introduction for Junit framework –
  • First scenario in Junit – annotations in Junit
  • Maven – Introduction to maven –
  • Setting up of Maven in Windows and workspace –
  • Creation and working with maven
  • projects in 2 ways – Converting the existing Java project framework to Maven framework –
  • Running the maven projects.
  • Introduction to appium
  • Automate your application
  • Web table handling
  • Page Object Model Framework
  • Keyboard handling
  • iFrame handling
  • Appium with Project
  • LIVE PROJECT

Manual Testing - (New Weekend batch)

  • What is Testing?
  • Quality Assurance versus Quality Control
  • The Cost of Quality & How Quality is Defined
  • Re-testing and Regression testing
  • What is a Defect? Scope of Testing
  • When Should Start Testing
  • ‘V Model’ & ‘Agile’ Concept of Testing
  • Testing Techniques
  • Testing Constraints
  • Life Cycle Testing
  • Independent Testing
  • What is a  QA Process?
  • Levels of Testing
  • “V Model” Concept of Testing
Testing Techniques—-
  • Black box and White box testing Technique
  • (Structural versus Functional Technique Categories)
  • Verification versus Validation
  • Static versus Dynamic Testing
  • Examples of Specific Testing Techniques
Test Planning—-
  • Customization of the Test Process
  • Estimation
  • Scheduling
  • Create the Test Plan
  • Prerequisites to test planning
  • Understand the Characteristics of the Software Being Developed
  • Build the Test Plan
  • Write the Test Plan
Test Cases—–
  • Test case Design
  • Building test cases
  • Test data mining
  • Test execution
  • Test Reporting
  • Defect Management
  • Test Coverage – Traceability matrix
Test reporting——
  • Guidelines for writing test reports
  • Test Tools used to Build Test Reports
  • Managing Change
  • Software Configuration Management
  • Risks – Risk Analysis and Management with examples
  • User Acceptance testing – in detail explanation with details
  • Case Study: How to test web, stand alone and database applications – with examples.
  • Basics of automation testing – why, when and how to perform automation testing
  • Test management and bug tracking tools
  • Help with resume and testing interview skills.
  • Interview
Mobile Testing———–
  • Introduction to Mobile Application Testing
  • Market size and figures
  • Players in the Mobile Space
  • Target audiences and customers
  • Business Model in Mobile Space
  • Overview of Mobile Devices Different types of Mobile Applications Mobile Application Architecture Client-side architecture Server-side architecture Connection Types Development Platforms for Mobile Applications Mobile Applications Test Types Challenges of mobile application testing Testing in Mobile Space Emulators & Simulators Differences in Mobile & Conventional Application Testing Mobile Testing Types Testing for the devices Testing for the connectivity Testing applications on different platforms Mobile specific testing Testing different types of mobile applications Common test types applied to mobile testing Field testing Mobile Application Testing Process & Techniques Mobile test Process and Strategy Test Process Test Levels Agile and Mobile Application Development Test Coverage Test Design Techniques Used for Mobile Testing Equivalence Class Partitioning Boundary Value Analysis Decision Table State Transition Testing Experience Based Testing Techniques

QTP/ UFT Syllabus- (Daily Batch - @ 7:15-8:45 am) and Weekend Batch

  • Automation Testing Introduction
  • Mobile Testing (Android)
  • UFT/QTP
  • Chapter 1: UFT -Introduction
  • Testing Tools
  • CLASSIFICATION OF TOOLSTYPES OF TOOLS:
  • WHERE UFT FITS IN ?
  • UFT HISTORY AND EVOLUTION
  • VERSION HISTORY:
  • ADVANTAGES:
  • DISADVANTAGES:
  • Chapter 2: Test Automation
  • Chapter 3 Environment Setup
  • Installation Procedure
  • Launching UFT and Add-ins Page
  • Chapter 4: Record and Play Back
  • Significance of Record and Playback:
  • Modes of Recording
  • How to Choose Recording Modes
  • Chapter 5: Object Repository
  • Merging Object Repositories Steps to Merge OR’s
  • Index: Location: Creation Time
  • Chapter 6: Actions
  • Types of Actions
  • Working with Actions
  • Chapter 7: Data tables
  • Example Data Table Operations :
  • Chapter 8: Checkpoints
  • Types
  • Inserting Check Point
  • Viewing Checkpoint Properties
  • Viewing Checkpoint Properties
  • Chapter 8: Synchronization
  • Ways to Insert Sync Point
  • METHOD 1: WAITPROPERTY
  • METHOD 2: EXIST
  • METHOD 3: WAIT
  • METHOD 4: SYNC METHOD
  • METHOD 5 : INSERTING UFT INBUILT SYNCHRONIZATION POINTS
  • Default Synchronization:
  • Chapter 9: Smart Identification
  • Enabling Smart identification for an object
  • Chapter 10: Debugging
  • Options in Break Point
  • Debugging Pane
  • Example
  • Chapter 11: Error Handling
  • Error Types
  • SYNTAX ERRORS
  • LOGICAL ERRORS
  • RUNTIME ERRORS:
  • HANDLING RUN-TIME ERRORS:
  • EXAMPLE
  • Chapter 12: Recovery Scenarios
  • Steps to create Recovery Scenario: Verification:
  • Chapter 13: Environment Variables
  • Types of Environment Variables
  • Environment Variables – Supported Methods
  • Chapter 14: Library Files
  • Associating Function Libraries
  • Chapter 15: Test Results
  • Operations performed in Test Results:
  • CONVERTING RESULTS TO HTML
  • FILTERING THE RESULTS
  • RAISING DEFECTS
  • Test Results
  • Chapter 16: Working with GUI Objects
  • WORKING WITH TEXT BOX
  • Working with Check Box EXAMPLE:
  • Working with Radio Button EXAMPLE
  • Working with Combo Box
  • EXAMPLE
  • Working with Buttons
  • EXAMPLE
  • Working with web Tables
  • Chapter 18: Virtual Objects
  • Example
  • Creating a Virtual Object
  • Virtual Object Manager
  • Using Virtual Objects
  • Virtual Object Limitations
  • Chapter 19: Accessing Databases
  • How to connect to Database?
  • RESULT
  • Chapter 20: Working with XML
  • Accessing XML
  • Comparing XML
  • Chapter 21: Descriptive Programming
  • Syntax
  • Description Objects
  • Description Strings
  • Child Objects
  • Ordinal Identifiers
  • Chapter 22: Automation Object Model
  • Generate AOM Script:
  • Example
  • Chapter 23: Frameworks
  • Keyword-Driven Framework
  • ADVANTAGES:
  • DISADVANTAGES:
  • DATA DRIVEN FRAMEWORK
  • FLOW DIAGRAM:
  • ADVANTAGES
  • DISADVANTAGES
  • Hybrid Framework
  • Affecting Factors
  • Designing a Framework
  • MASTER DRIVER SCRIPT
  • LIBRARY FILES
  • OBJECT REPOSITORY:
  • DATA TABLE
  • THE EXECUTION LOG:
  • Newly Covered Areas
  • Basics of VB Scripting
  • Using With…End With Statements in Descriptive programing
  • SCRUM Process and Automation
  • File system objects and Excel Objects

JMeter Syllabus - (contact for Date)

Introduction:
  • Overview of Performance Testing
  • Performance Testing Concepts
  • Performance Testing Types
  • Why to use performance Testing tool?
  • What is JMeter?
  • Running JMeter:
  • JMeter’s Classpath
  • Using a Proxy Server
  • Distributed Mode
  • Introduction to Elements of JMeter
  • Test Plan:
  • Thread Group
  • Controllers
  • Samplers
  • Logic Controllers
  • Listeners
  • Timers
  • Assertions
  • Configuration Elements
  • Pre-Processor Elements
  • Post-Processor Elements
  • Building a Test Plan:
  • Adding and Removing Elements
  • Loading and Saving Elements
  • Configuring Tree Elements
  • Running a Test Plan
  • Adding Users:
  • 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
  • Recording Tests Using JMeter:
  • 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
  • Parameterize the user sessions
  • Parameterize with test data:
  • Identifying the test data on AUT
  • Open a csv file with JMeter
  • Reading the data from CSV files
  • Using the parameters in JMeterTests
  • Adding Assertions to the test script:
  • 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
  • Building a Monitor Test Plan:
  • 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
  • Reporting and Analyzing the Results:
  • 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
  • Best Practices:
  • Limit the Number of Threads
  • Where to Put the Cookie Manager
  • Where to Put the Authorization Manager
  • Reducing resource requirements
  • Distributed Testing
  • Success!

Loadrunner Syllabus- (contact for Date)

  • Performance testing concepts
  • Commonly conducted Performance testing types
  • Goals and benefits of Performance testing
  • Understanding Performance requirements
  • Creating a sample Performance test plan
  • Understanding work load models
  • Understanding symptoms of performance problems
  • Understand and discuss various performance counters
  • Understanding the process of conducting Performance testing
  • Performance testing Vs Performance Engineering
  • Various LR components
  • Overview of Virtual User Generator
  • Understanding VuGen layout
  • Recording types
  • Overview of Protocols supported
  • About Protocol Advisor
  • Single protocol record and replay
  • Multi protocol record and replay
  • Vuser Script language selection
  • Recording a simple scenario an understanding LR script
  • Understanding the replay features
  • Actions in VuGen
  • Commenting and logging
  • Creating Transactions
  • Correlation concept
  • Importance of correlation in performance testing
  • Understanding Correlation Design Studio
  • Setting correlation rules
  • Manual correlation
  • Data parameterization
  • Correlation vs. Parameterization
  • Running actions for iterations
  • Customizing iterations think time and pacing
  • Browser settings and simulation
  • Bandwidth simulation
  • Checkpoints & Content checks
  • Error Handling settings
  • Running as thread and process
  • Think time settings
  • Running the script as Process and threads
  • Rendezvous settings
  • Scripting in C – understanding various LR functions in vugen
  • Introduction Controller
  • Working of Controller
  • Concept of scenarios and groups
  • Working with Manual scenario
  • Working with Goal oriented scenario
  • Concept of Load Balancing and How-to in LR
  • Defining Service Level Agreement
  • Understanding various Monitors graphs
  • LR Analysis
  • About Correlating, overlay and merging graphs
  • Exporting analysis reports
  • Understanding and analyzing performance graphs

DataWarehouse/ETL- (Next Batch- contact for Date)

DWH: Data Ware Housing Concepts
  • What is Data Warehouse? Need of Data Warehouse
  • Introduction to OLTP, ETL and OLAP Systems and its difference.
  • 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 Testing
  • 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)
  • Challenges in DWH ETL Testing compare to other testing
  • Incompatible and duplicate data.
  • Loss of data during ETL process.
  • Testers have no privileges to execute ETL jobs by their own.
  • Volume and complexity of data is very huge.
  • Fault in business process and procedures.
  • Trouble acquiring and building test data.
  • ETL Testing Work flow activities involved
  • Analyze and interpret business requirements/ workflows to Create
estimations
  • Approve requirements and prepare the Test plan for the system testing
  • Prepare the test cases with the help of design documents provided by the developer team
  • Execute system testing and integration testing.
  • Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
  • How to detect/report the bugs in the ETL testing
  • How to co-ordinate with developer team for resolving the defects
  • Types of ETL Testing
  • Data completeness./Data transformation./Data quality.
  • Performance and scalability.
  • SQL Queries for ETL Testing (Rogersoft)
  • Incremental load testing and Initial Load / Full load testing
  • Different ETL tools available in the market:- Informatica, Ab Initio, IBM Data stage
  • Power Center Components
  • Designer
  • Repository Manager and Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console
  • Informatica Concepts and Informatica Architecture.
  • Sources Working with relational Sources
  • Working with Flat Files
  • Targets
  • Working with Relational Targets
  • Working with Flat file Targets
  • Transformations – Active and Passive Transformations
  • Expression
  • Lookup –Different types of lookup Caches
  • Sequence Generator
  • Filter/Joiner/Sorter/Rank/Router/Aggregator
  • Source Qualifer
  • Update Strategy
  • Normalizer/ Union
  • Stored Procedure
  • Slowly Changing Dimension
  • SCD Type1, SCD Type2 — Date, Flag and Version, SCD Type3
  • Workflow Manger
  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks/ Session
  • Decision task/ Control Task/ Event wait task/ Timer task
  • Monitoring workflows and debugging errors
  • Indirect Loading
  • Constraint based load ordering
  • Target Load plan
  • Worklet ,Mapplet ,Resuable transformation
  • Migration ?ML migration and Folder Copy.
  • Scheduling Workflow
  • Parameter and variables
  • XML Source, Target and Transformations
  • Performance Tuning
  • Pipeline Partition/ Dynamic Partition/ Pushdown optimization
  • Preparation of Test Cases
  • Executing Test case
  • Preparing Sample data
  • Data validation in Source and target
  • Load and performance testing
  • Unit testing Procedures.
  • Error handling procedures.
  • Testing scenarios, creation of test cases and scripts
  • Test case execution and defect tracking and reporting
  • Preparation of Test data
  • Practice ETL Testing with Real Time Scenarios and FAQ
  • Difference between data warehouse and database
  • Defect management
  • Defect management tools
  • Different stages of ETL testing process
  • Entry and Exit criteria for these stages
  • Agile projects
  • Test data management
  • Defect triage meeting
  • Stake holders in ETL testing
  • Types of ETL validation
  • Types of Report validation
  • A case study with an ETL transformation
  • Reduce the scope of Informatica and add Ansi SQL because most of the the ETL testing projects are black box testing
  • Introduction to big data testing
  • Mock Interview at Rogersoft

Java

Basics of Java
  • Java – What, Where and Why?
  • History and Features of Java
  • Internals of Java Program
  • Difference between JDK,JRE and JVM
  • Internal Details of JVM
  • Variable and Data Type
  • Unicode System
  • Naming Convention
  OOPS Conecpts
  • Advantage of OOPs
  • Object and Class Method Overloading
  • Constructor
  • static variable, method and block
  • this keyword
  • Inheritance (IS-A)
  • Aggregation and Composition(HAS-A)
  • Method Overriding
  • Covariant Return Type
  • super keyword
  • Instance Initializer block
  • final keyword
  • Runtime Polymorphism
  • static and Dynamic binding
  • Abstract class and Interface
  • Downcasting with instanceof operator
  • Package and Access Modifiers
  • Encapsulation
  • Object class
  • Object Cloning
  • Java Array
  • Call By Value and Call By Reference
  • strictfp keyword
  • Creating API Document
String Handling
  • String : What and Why?
  • Immutable String
  • String Comparison
  • String Concatenation
  • Substring
  • Methods of String class
  • StringBuffer class
  • StringBuilder class
  • Creating Immutable class
  • toString method
  • StringTokenizer class
  Exception Handling
  • Exception Handling : What and Why?
  • try and catch block
  • Multiple catch block
  • Nested try
  • finally block
  • throw keyword
  • Exception Propagation
  • throws keyword
  • Exception Handling with Method Overriding
  • Custom Exception
  Nested Classes
  • Nested Class : What and Why?
  • Member Inner class
  • Annonymous Inner class
  • Local Inner class
  • static nested class
  • Nested Interface
  • Multithreading
  Multithreading : What and Why?
  • Life Cycle of a Thread
  • Creating Thread
  • Thread Schedular
  • Sleeping a thread
  • Joining a thread
  • Thread Priority
  • Daemon Thread
  • Thread Pooling
  • Thread Group
  • ShutdownHook
  • Performing multiple task by multiple thread
  • Garbage Collection
  • Runnable class
  Synchronization
  • Synchronization : What and Why?
  • synchronized method
  • synchronized block
  • static synchronization
  • Deadlock
  • Inter-thread Communication
  • Interrupting Thread
  Input and output
  • FileOutputStream & FileInputStream
  • ByteArrayOutputStream
  • SequenceInputStream
  • BufferedOutputStream & BufferedInputStream
  • FileWriter & FileReader
  • CharArrayWriter
  • Input from keyboard by InputStreamReader
  • Input from keyboard by Console
  • Input from keyboard by Scanner
  • PrintStream class
  • PrintWriter class
  • Compressing and Uncompressing File
  • Reading and Writing data simultaneously
  • DataInputStream and DataOutputStream
  • StreamTokenizer class
  Serialization
  • Serialization & Deserialization
  • Serialization with IS-A and Has-A
  • transient keyword
  Networking
  • Socket Programming
  • URL class
  • Displaying data of a web page
  • InetAddress class
  • DatagramSocket and DatagramPacket
  • Two way communication
  AWT and EventHandling
  • AWT Controls
  • Event Handling by 3 ways
  • Event classes and Listener Interfaces
  • Adapter classes
  • Creating Games and Applications
  Swing
  • Basics of Swing
  • JButton class
  • JRadioButton class
  • JTextArea class
  • JComboBox class
  • JTable class
  • JColorChooser class
  • JProgressBar class
  • JSlider class
  • Digital Watch
  • Graphics in swing
  • Displaying Image
  • Edit Menu for Notepad
  • Open Dialog Box
  • Creating Notepad
  • Creating Games and applications
  LayoutManagers
  • BorderLayout
  • GridLayout
  • FlowLayout
  • BoxLayout
  • CardLayout
  Applet
  • Life Cycle of Applet
  • Graphics in Applet
  • Displaying image in Applet
  • Animation in Applet
  • EventHandling in Applet
  • JApplet class
  • Painting in Applet
  • Digital Clock in Applet
  • Analog Clock in Applet
  • Parameter in Applet
  • Applet Communication
  • Creating Games
  Reflection API
  • Reflection API
  • newInstance() & Determining the class object
  • javap tool
  • creating javap tool
  • creating appletviewer
  • Accessing private method from outside the class
  Collection
  • Collection Framework
  • ArrayList class
  • LinkedList class
  • ListIterator interface
  • HashSet class
  • LinkedHashSet class
  • TreeSet class
  • PriorityQueue class
  • ArrayDeque class
  • Map interface
  • HashMap class
  • LinkedHashMap class
  • TreeMap class
  • Hashtable class
  • Comparable and Comparator
  • Properties class
  JDBC
  • JDBC Drivers
  • Steps to connect to the database
  • Connectivity with Oracle
  • Connectivity with MySQL
  • Connectivity with Access without DSN
  • DriverManager
  • Connection interface
  • Statement interface
  • ResultSet interface
  • PreparedStatement
  • ResultSetMetaData
  • DatabaseMetaData
  • Storing image
  • Retrieving image
  • Storing file
  • Retrieving file
  • Stored procedures and functions
  • Transaction Management
  • Batch Processing
  • JDBC New Features
  • Mini Project
  Java New Features
  • Assertion
  • For-each loop
  • Varargs
  • Static Import
  • Autoboxing and Unboxing
  • Enum Type
  • Annotation etc.
  Internationalization
  • Internationalization
  • ResourceBundle class
  • I18N with Date
  • I18N with Time
  • I18N with Number
  • I18N with Currency

Android - contact for date

At the end on this course the students will gain enough knowledge to create and publish their own Apps for Google Android devices as well as ability to learn advanced topics through self-study methods we will teach them. All students will be provided CDs containing software, project source code, as well as certificates for attending the course.    
Full Syllabus:
  1. A) Introduction To Mobile Apps (ROGERSOFT)
Why we Need Mobile Apps Different Kinds of Mobile Apps Briefly about Android
  1. B) Introduction Android
History Behind Android Development What is Android? Pre-requisites to learn Android Brief Discussion on Java Programming
  1. C) Android Architecture
Overview of Android Stack Android Features Introduction to OS layers (ROGERSOFT))
  1. D) Deep Overview in Android Stack
Linux Kernel Libraries Android Runtime Application Framework Dalvik VM
  1. E) Installing Android Machine
Configuring Android Stack Creating Eclipse Environment Integrating Android with Eclipse IDE Exploring Eclipse IDE
  1. F) Creating First Android Application
Creating Android Project Debugging Application through DDMS setting up environment AVD Creation Executing Project on Android Screen
  1. G) Android Components
Activities Services Broadcast Receivers Content Providers
  1. H) Hello World App
Creating your first project The manifest file Layout resource Running your app on Emulator (ROGERSOFT)
  1. I) Building UI with Activities
Activities Views, layouts and Common UI components Creating UI through code and XML Activity lifecycle ((ROGERSOFT)) Intents Communicating data among Activities
  1. J) Advanced UI
Selection components (GridView, ListView, Spinner ) Adapters, Custom Adapters Complex UI components Building UI for performance Menus Creating custom and compound Views
  1. K) Notifications
Toast, Custom Toast Dialogs Status bar Notifications
  1. L) Multithreading
Using Java Mutithreading classes AsyncTask Handler Post Writing an animated game
  1. M) Styles And Themes
Creating and Applying simple Style Inheriting built-in Style and User defined style Using Styles as themes
  1. N) Resources and Assets
Android Resource Using resources in XML and code Localization Handling Runtime configuration changes
  1. O) Intent, Intent Filters and Broadcast Receivers
Role of filters Intent-matching rules Filters in your manifest Filters in dynamic Broadcast Receivers Creating Broadcast receiver
  1. P) Receiving System Broadcast
Understanding Broadcast action, category and data Registering Broadcast receiver through code and through XML Sending Broadcast
  1. Q) Data Storage
Shared Preferences Android File System Internal storage External storage
  1. R) SQLite
IntroducingSQLite SQLiteOpenHelper and creating a database Opening and closing adatabase Working with cursors Inserts, updates, and deletes Network ((ROGERSOFT))
  1. S) Content Providers
Accessing built in content providers Content provider MIME types Searching for content Adding, changing, and removing content Creating content provider Working with content files
  1. T) Services
Overview of services in Android Implementing a Service Service lifecycle Inter Process Communication (AIDL Services)
  1. U) Multimedia in Android
Multimedia Supported audio formats Simple media playback Supported video formats Simple video playback
  1. V) Location Based Services and Google Maps
Using Location Based Services Finding current location and listening for changes in location Proximity alerts
  1. W) Working with Google Maps Showing google map in an Activity ii. Map Overlays iii. Itemized overlays iv. Geocoder v. Displaying route on map
  2. X) Web Services and WebView
Consuming web services Receiving HTTP Response (XML, JSON ) Parsing JSON and XML Using WebView
  1. Y) Sensors
How Sensors work Using Orientation and Accelerometer sensors Best practices for performance
  1. Z) WiFi
Monitoring and managing Internet connectivity Managing active connections Managing WiFi networks A1)  Telephony Services
  • Making calls
  • Monitoring data connectivity and activity
  • Accessing phone properties and status
  • Controlling the phone
  • Sending messages
B1) Camera
  • Taking pictures
  • Media Recorder
  • Rendering previews
C1) Bluetooth
  • Controlling local Bluetooth device
  • Discovering and bonding with Bluetooth devices
  • Managing Bluetooth connections
  • Communicating with Bluetooth
D1) More
  • Fragments
  • Material Design
  • Additional TOPICS (NEW): Since each new version of Android has new features, we keep extra time for adding custom topics in every batch. You can request any Android Topic.
E1) Android Application Deployment
  • Android Application Deployment on device with Linux and Windows
  • Android Application Deployment on Android Market
Benefits of Test Automation
  • Visual Studio Interface Overview
  • Basic on C#
  • Understanding Coded UI Test Structure
  • Test File Types
  • Understanding File Relationships
  • Creating a Coded UI Test
  • Recording Test Steps
  • Using the Recorder Controls
  • Method Generation
Adding Assertions to the Test
  • Assertions using UI Locator
  • Selecting Objects with the UI Locator
  • Using Coded UI Comparators
  • Manually Coding Assertions
  • Understanding the UI Map
  • Accessing the UI Map
  • Understanding Control Names and Parent Windows
  • UI Map Maintenance
Test Executing & Evaluating Results
  • Running Coded UI Tests
  • Evaluating Log Files
  • Understanding Assertion Failures
  • Collection Files
Debugging and Troubleshooting
  • Evaluationg Assertion Statements
  • Storing Expected Results
  • Updating Control Statements
  • Debugging Process
Data-driven Testing
  • Creating DataSources
  • Creating Data-Driven Tests
  • Modifying Assertions with Data Driven Tests
Capturing Dynamic Data from Objects
  • Creating Multiple UI Maps
  • Regular Expressions
  • Regular Expression Operators
  • Using Regular Expressions for Data Capture
  • Dynamic Object Handling
  • Modify Mapped Objects
  • File Input / Output
  • Reading & Writing data from files
  • Team Foundation Server API
  • Logging Options
  • Database Connectivity
  • Connecting to Databases using ODBC and SQL Connection
  • Executing Queries
  • Managing Playback Settings
  • Synchronizing Coded UI Tests
  • Wait for Condition Controls
  • Test Lab set up Guide.
  • Mapping Automated TC’s to TFS Work item
  • Continues integration build configurations
  • Framework Concepts

Why Cucumber

  • Automated Acceptance Tests
  • Behaviour-Driven Development
  • Living Documentation
  • How Cucumber Works
  • Gherkin Basics
  • What’s Gherkin For?
  • Format and Syntax
  • Feature
  • Scenario
  • Comments
  • Spoken languages
  • Step Definitions- Given,When,Then
  • Steps and Step Definitions
  • Capturing Arguments
  • Multiple Captures
  • Flexibility
  • Returning Results
  • Expressive Scenarios
  • Background
  • Data Tables
  • Scenario Outline
  • Nesting Steps
  • Doc Strings
  • Staying Organized with Tags and Subfolders
  • Support Code
  • Fixing the Bug
  • Bootstrapping the User Interface
  • Making the Switch
  • Using Hooks
  • Building the User Interface
  • Feature file
  • Configuring the java code behind the feature file
  • Multiple scenarios in a feature file
  • Regular Expressions
  • Datatables
  • Running with Hudson – Continuous Integration
  • Configuring Maven for Cucumber project
(Contact for more information) - Updates soon…
(Weekend Class on every month) - Updates soon...
(Contact for Training) - Update soon...
SEO Syllabus
What is Domain
Basic Knowledge of World Wide Web
Difference between Portal and Search Engines
What is SEO
Types of SEO Techniques
Black hat techniques
White Hat techniques
How Search Engine works

SEO Research & Analysis
Market Research
Keyword Research and Analysis
Keyword opportunity
Competitors Website Analysis
SWOT Analysis of Website
How to Choose Best Keywords
Tools available for Keyword Research

Website Design SEO Guidelines
Content Research
Content Guidelines
Content Optimization
Design & Layout
XML Sitemap / URL List Sitemap

On-page Optimization
The Page Title
Meta Descriptions & Meta Keywords
Headings
Bold Text
Domain Names & Suggestions
Canonical Tag
Meta Tags
Images and Alt Text
Internal Link Building
The Sitemap
Invisible Text
Server and Hosting Check
Robots Meta Tag
Doorway Pages
301 Redirects
404 Error
Duplicate content

Off-page Optimization
Page Rank
Link Popularity
Link Building in Detail
Directory Submission
Social Bookmark Submission
Blog Submission
Articles
Links Exchange
Reciprocal Linking
Posting to Forums
Submission to Search Engine
RSS Feeds Submissions
Press Release Submissions
Forum Link Building
Competitor Link Analysis
Practical training on live application

Analytics
Google Analytics
Installing Google Analytics
How to Study Google Analytics
Interpreting Bars & Figures
How Google Analytics can Help SEO
Advanced Reporting
Webmaster Central & Bing/Yahoo
Open Site Explorer
Website Analysis using various SEO Tools available
Practical training on live application

SEO Tools
Keyword Density Analyzer Tools
Google Tools
Yahoo / Bing Tools
Rich Snippet Text Tools
Comparison Tools
Link Popularity Tools
Search Engines Tools
Site Tools
Miscellaneous Tools
Practical training on live application

SEO Reporting
Google analysis
Tracking and Reporting
Reports Submission
Securing Ranks
Working on LIVE applications
C#.NET Training Course Overview
  • Learn the fundamentals of C# programming in Visual Studio.
  • Using .Net Framework
  • Working with variables, data types
  • Work with standard programming skills
  • Exception Handling in C#
  • Object oriented programming in C#
  • Object oriented techniques
  • Working with Arrays
  • Create Generic classes and methods.
  • Collections in C#
  • Generate and test your own classes using the Class Designer and Object Test Bench tools.
  • Use delegate types to provide flexibility and type safety.
  • Use anonymous types, lambda expressions, extension methods, object initializers, and implicit type declarations
Introduction/Overview of .Net
  • Introduction  to  .Net
  • Platform for the  .Net
  • Drawbacks  of  Current  Trend
  • Net Framework – BCL & CLR l Key design goals
  • CLR, CTS, MSIL & other tools.
  • Multiple Language Interaction & support l Moving from Project to Assemblies…
  • Security in .NET – CAS
.Net Framework [Advanced]
  • Advantages/Disadvantages
  • Features of .Net
  • Assemblies in Detail
  • GAC,  Strong  Names
  • Language  Interop
  • Reflection
Visual C#.Net Language
  • Advantages/Disadvantages
  • Why C#/ Why Not C#
  • Where does C# Fit in
  • C, C++ to Visual C#
  • Features  of  C#
  • .NET  Namespaces
.Net Installations/C#.Net
  • .NET Versions – 1.1/2.0/3.0/3.5 Beta
  • Visual  Studio.NET  2003/2005/Orcas/2008
  • Windows Vista – New Look
  • Gadgets/SideBars/UAC  –  relation  with  .NET
  • Hardware/Software  Requirements
  • FAQ’s with detailed answers
Programming Using Visual C#.Net
  • The start of the application
  • C#.Net  Program  Design
  • Variables  and  types
  • Value types and reference types (CTS)
  • Strings and arrays
  • The Console class
  • String  formatting
  • Statements  and  flows
  • Programming  Structures
  • Command-line  arguments
  • VS.NET to Create C#.NET Apps
  • C# 3.0/3.5 features – Implicit types , Extention Methods and more
Introduction To Windows  Forms  – I
  • Windows forms library – WinForms
  • Layout Enhancements
  • Forms and controls – Hierarchy
  • Creating simple GUI by hand
  • Event handling
  • Basic controls
  • Windows forms – buttons, check boxes, radio buttons, panels, group boxes, list boxes, picture boxes…
Windows Forms – II
  • Menus
  • Built-in  dialog  boxes  and  printing
  • Extender  Controls
  • ToolStrips, StatusStrips and progress bars
  • A new MDI forms strategy
  • Inheritance  with  forms
  • New Controls – Web Browser, Property Grid etc
Object Oriented Concepts (Basic)
  • Classes & objects
  • Abstract & override methods
  • Creating and using your own classes l Data members and member methods l Instantiate an object
  • This  keyword
  • Properties –  Read Only Write Only…
  • Build process using windows class library l Generate classes for other clients
  • How to use classes as part of project
Object Oriented  Concepts  (Advanced)
  • Accessibility levels, specifiers
  • Constructors
  • Method  overloading
  • Class (static) variables & methods
  • Object  destruction
  • ‘ref’ and ‘out’ parameters
  • Constant  values
  • Enumerations
  • Inheritance  and  Polymorphism
  • The root of all classes
  • Creating  derived  classes
  • Method  overriding  and  hiding
  • Polymorphism  and  virtual  functions
  • Casting  objects
  • Abstract classes
  • Sealed  classes
  • Static classes
Object Oriented Concepts (Implementation Oriented)
  • Case  Studies
  • Class Diagram in VS.Net
  • Refactoring  &  others
  • FAQ’s
Error Handling
  • Unstructured  error  handling  support
  • Structured  error  handling
  • Error  categories
  • Debugging  the  application
  • Debug and Trace  classes
  • Code  Optimization
  • Testing  and  strategies
Ado.Net 1.1/2.0/Linq
  • History  and  background
  • From DAO to ADO.NET
  • ADO.NET  LINQ
  • ADO.NET  design  goals
  • The ADO.NET architecture and its components
  • ADO.NET in relation to the other .NET tools
  • DataSet  in  RealTime  Scenarious
Ado.Net Components
  • Connected  and  disconnected  environment
  • ADO.NET  object  model
  • Data  sources,  providers  and  connections
  • Commands  and  data  readers
  • Data  sets  and  data  adaptors
  • Data  tables,  rows  and columns
  • Constraints  and  relations
  • Data-centric  applications  –  New  ADO.Net  Hierarchy
Data Sources And .Net Data Providers
  • Connecting  to  a  data  source
  • SQL Server .NET data provider
  • OLE-DB  .NET  data  provider
  • Connections  and  connection  strings
  • SQL-Server  integrated  security
  • Connection  pooling
  • ADO.NET  exceptions
Accessing Data In The Connected Environment
  • Commands
  • Creating  and  executing  commands
  • Reading  data  using  a  data  reader
  • Batch queries & single result queries
  • Parameterised  queries  (input  &  output  parameters)
  • Adding,  editing  and  deleting  data
  • Stored  procedures
Accessing Data In  Disconnected  Environment
  • Why using a disconnected environment?
  • DataSet  and  DataAdapter features
  • Filling data  sets using  data adapters
  • Read data using data tables, rows and columns
  • Batch queries and data sets
  • Visual Studio Data Menu & tools
  • DataSet  Navigation
  • DataSet  Functionality
  • DataSet  Optimistic  Concurrency
Sorting, Searching And  Filtering
  • Searching in data sets
  • Find on primary keys
  • Searching on any column
  • Searching on row state
  • Wildcard  searches
  • Sorting  and  filtering  using  data  views
  • Searching in a data view
Live Case Study and Implementation Of ADO.NET   in N-Tier
  • Client Server Basics
  • N-Tier – Classical and New
  • N-Tier importance w.r.t other .Net technologies
  • Build User Interface Layer – importance
  • Business Layer in N-Tier – advantages & disadvantages
  • Data Access Layer – Generic/Specific Advantages
  • N-Tier  DataBase  Application
  • SQLHelper,  CodeSmith  etc  tools  awareness
XML
  • XML Basics – Importance in Todays world
  • XML designers/support in VS.NET
  • XML Derived Technologies – XSD ,XSL , SOAP ,WSDL
XML IN .NET
  • System.Xml  Namespace
  • Stream  Model  XML
  • XML DOM
  • XmlTextReader,TextWriter
  • XmlTextReader, TextWriter XMLDocument/ XmlDataDocumentClasses
  • Dom  Objects  –  XMLNode/XMLNodeList
  • XPATH- Query Language for XML
  • DOM – Navigation & Access Case Studies
Creating Custom Windows Controls
  • About  user  –  defined  controls
  • Understanding  the  control  class  with  Container
  • Add  Properties/Methods/Events  to  Control
  • Pack & use control in other windows applications
  • Create  &  implement  a  windows  control
Windows Services*
  • Understanding  services
  • Creating  windows  services
  • Setting  properties
  • Compile, run & install services
  • Event log services
.Net Remoting
  • About  Distributed  Applications
  • COM/DCOM  in  Distributed  Environment
  • Drawbacks of DCOM
  • .NET  Remoting  –  New  distributed  environment
  • Advantages  &  Disadvantages
  • Remoting  –  Web  Services  comparisons
  • MBR, MBV
  • Channels
  • Formatters
  • Programming Model – Object Styles & Lifestyles
  • Activation
  • Case  Study  –  Implementation  using  Remoting
Crystal Reports*
  • Reporting  Need  in  the  application
  • Crystal  Reports  –  Reporting  Tool
  • Different Versions of Crystal Reports
  • Developing  a  Crystal  Report
  • Different ways to Invoke/Deploy Crystal Reports
Application Deployment
    • Packaging  Code
    • ClickOnce  Deployment
    • Configuring  the  .Net  framework
    • Deploying  the  application  in  Web  Server
  • Deployment  –  other  methods
ntroduction To Web Applications [Prerequisites]
  • Types of Applications – Web, Desktop & Mobile  Applications
  • Web  applications  with  Web  Server
  • Web Server role, about IIS, APACHE, and CASSINI
  • Web  Browsers,  Web  Support  Languages
  • Understanding http, TCP/IP, LAN, WAN & O/S role in web development
  • Why Scripting & its importance
  • Client-Side  &  Server-Side  Scripting
OVERVIEW OF .NET (ASP.NET)
  • Intro to .NET
  • Drawbacks  of  Current  Trend
  • .NET  Framework
  • Key Design Goals
  • CLR, CTS, MSIL, & Other Tools
  • Multiple  Language  Interaction  &  Support
  • Moving from Project to Assemblies…
  • Security Services   and   environment
  • Vista & IIS 6.0/7.0 & their requirements
  • Installing  &  Configuring  VS.NET/.NET  2.0/3.0/3.5
  • AJAX(ATLAS)  importance  in  Web  applications
  • The need for AJAX & the Solution
ACTIVE SERVER  PAGES .NET ROLE
  • Shifting from ASP to ASP.Net, Asp.net to web 2.0 (new)
  • ASP.Net as Framework, Namespaces
  • ASP.Net – New Scenario in development process with IDE – VS.NET
  • Web Pages to Web Forms, HTML – ASP.NET, State management- an Important Objective
  • Understanding the ASP.NET Execution Scenario
  • C#.Net role in ASP.NET Development
  • ASP.NET/C#.Net – the Industry approach
  • HTML, HTML Controls, ASP.NET Controls
  • Client-side & Server-side Controls
  • Consuming HTML Client/Server Controls in WebForms
  • Consuming ASP.Net Controls in WebForms
  • Understanding the Rendering Nature of Controls Developing a Simple Startup Application
ASP.NET WEB FORMS – THE NEW TECHNOLOGY(BEGINNING)
  • Introducing Web Forms, Worker process
  • Working  with  Server  Controls
  • Applying Styles to Controls, Themes, Skins etc
FORM
  • Page Directives  and its use
  • Separating  Code  &  Design
  • New  Code  behind  Techniques
  • Implementing  ASP.NET  Server  Controls
  • Types of ASP.NET & their need/render
  • Intrinsic – Validation – Bound – DataSource
  • Navigation – Login – Web Parts & AJAX.-as building blocks Asp.net.
    WEB FORMS – INTRODUCTION TO AJAX INPUT VALIDATION
  • Validating Form with Validation Controls of Asp.net
  • Using RequiredFieldvalidator control
  • Using CompareValidator Control Using RangeValidator Control
  • Using  CustomValidator  control
  • Create Server-side / Client-side functions for – CustomValidator Control
  • Group Validations & avoiding Validations.
  • Finally – Client Targets & ValidationSummary control
ADO.NET I – DATABASE SERVICES  (V1.1/2.0/3.5)
  • XML, XML to HTML, XML & Databases
  • XML Schema Definition Tool
  • Overview of ADO.NET/ XML Support in .NET
  • Connect/Insert/Update/Delete,Query data -using ADO.NET
  • Retrieve data with datasets
  • Data Adapters, Understanding Data tables
  • Build Data table programmatically
  • Filter and sort Data table, Data Relations
  • ADO.NET  LINQ
ADO.NET – II
  • Parameters  with  Command  Object
  • Stored  Procedures  with  ADO.NET  using  –output  parameters
  • Develop  a  Registration  form  using  ADO
PRESENTING DATA USING ASP.NET BOUND CONTROLS (USING VB.NET/C#)
  • ASP.Net  bound  controls
  • DataSource  Controls
  • Repeater & its uses.
  • DataBound  and  DataAware  Controls
  • Bind  data  to  Dropdownlist  Control
  • Datalist  control
  • DataGrid(1.1/2.0)  Control
  • GridView  &  its  importance  in  Development
  • GridView(Basic)  –  simple  uses
  • GridView  (Advanced)  –Runtime  Fields,  Empty  DataRows,  NTier  …
  • FormView  &  DetailsView
  • ListView
AJAX ( ATLAS )
  • Introduction to Microsoft  AJAX.(Code  name  ATLAS)
  • XML Http object
  • Programming  with  XML  HTTP  Object
  • Advantages and Disadvantages of AJAX.
  • Features of AJAX.
  • MS Implementation of AJAX
ASP.NET ERROR HANDLING &  DEBUG.
  • Error Handling & .NET Runtime
  • Avoid Errors before they occur
  • Structured Error Handling
  • Catching  General  Exceptions
  • Catching Specific Exceptions
  • Throwing  Exceptions
  • Custom  Exceptions
  • Page  Level  Error  Handling
  • Application  Level  Error  Handling
USER CONTROLS
  • Creating  User  Controls
  • Adding member to user controls.
  • Registering User Controls
  • Properties  &  Methods
  • Dynamically  loading  user  controls
  • Master Pages
CONFIGURING ASP.NET APPLICATION
  • Web Application configuration-Advantages.
  • New Configuration Model, ASP.NET Confn Tool
  • Web Application Machine Configuration
  • Global Assembly Cache, Strong Names VS2005.
  • Working with Assembly Info
  • Web.Config,  Machine.Config
  • Process Model –System Configuration.
ASP.NET WEB APPLICATIONS
  • About Session & Application object
  • Comparison between Session & Application
  • Using the Global.asax file
  • Managing  Application  State
  • Http  Handlers
  • Application & Session Variables
  • Application & Session Events
CACHE SERVICES
  • Caching  Overview
  • Advantages  of  Caching
  • Comparing with Application & Session var’s
  • Page Output Caching
  • Page  Data  Caching
  • Fragment Caching
SECURITY
  • Security  Overview
  • Authentication  &  Authorization
  • Windows-based  Authentication
  • Passport  Authentication.(WebServices)
  • Forms-based  Authentication
  • Memberships
  • Authorizing  Users  and  Roles
  • User  Account  Impersonation
DEPLOYMENT
  • Deploying  ASP.NET  Application
ASP.NET XML WEB SERVICES
  • Introducing   XML Web Services
  • Differences Between DCOM / Remoting / Web Services
  • Asp.net Webservices.
  • Writing a Simple Web Service
  • Xml web services stack, SOAP,WSDL,UDDI,Sync an
  • Async calls
  • Web Service Type Marshalling
  • Using Data in Web Services
  • Using Objects and Intrinsic
  • HTML  Pattern  Matching
  • WCF
WEBPARTS
  • New concept in Web Apps.
  • Advantages and Disadvantages.
  • Predefined/ user defined controls with webparts.
WINDOWS VISTA-NEW FEATURES
  • Gadgets/side bars.
  • Office  2007
  • VS to VS.net tools for office.
MOBILE APPLICATIONS
  • Mobile  forms
  • Mobile Environment – Today’s Need.
  • Needed  Infrastructure
  • WAP, WML overview.
  • MS Mobile Explorer.
  • Open ware Simulators.
  • Line smart phones   and Pocket PC Applications.
SMARTPHONE AND POCKET PC
  • What is Smartphone / Pocket Pc?
  • Application for   smartphone / pocket pc
  • Deploying / Run application in devices / Live
VSTO – VS.NET
  • What is VSTO?
  • Programming developing   managed addings for outlook.
  • Advantages VSTO
  • VSTO 2005 SE
  • Runtime component.
[ Additional Needed  Services  in Web  Apps(Optional)]
  • MSMQ in ASP.Net
  • Its need in data transferring
  • MSMQ – Its role in heterogeneous networks and systems
  • Crystal  Reports  in  ASP.Net
  • Designing Reports for Web Browsers
[ OVERVIEW ]
  • SharePoint
  • BizTalk
    01 - Database Basics and Structured Query Language  
  • Introduction to SQL
    • In our first , we'll explore the basic structure and history of relational databases. You'll learn the history of SQL, then we'll review some key terms. Then, you'll discover what SQL is and how it's used with a relational database.
  02 - Filtering and Retrieving Data  
  • Retrieving Data, Updating Data, Inserting Data, Deleting Data
    • In this , you'll learn how to use SQL to filter and retrieve data from tables. We'll talk about important query terms that allow you to communicate with your database, as well as syntax rules that will help you to create clear and understandable queries while avoiding system generated errors.
    03 - Sorting and Filtering Data  
  • Sorting and Filtering Data, Advanced Filtering,
    • In this , you'll learn how to use SQL to filter retrieved data. You'll practice sorting retrieved data using the ORDER BY clause. You'll be able to sort single and multiple columns, and you'll know how to specify sort directions such as ascending and descending order. You'll also learn additional query terms that will help you customize your SQL queries.
    04 - Calculated Fields and Functions  
  • Today, you'll learn how to reformat retrieved data with calculated fields and functions. You'll also learn how to create alternate names for columns, and you'll discover the secret behind merging columns with the concatenation symbol.
      05 - Summarizing and Grouping Data  
  • Summarizing Data, Grouping Data
    • In this , we'll discuss gathering significant statistics from data using aggregate functions. You'll also learn how to use the GROUP BY clause in conjunction with an aggregate function to gather important statistics from a table. Then you'll find out how to use the HAVING clause in conjunction with an aggregate function to filter groups of data from a table.
    06 - Working with Sub queries  
  • Using Subqueries
    • Its all about sub queries. You'll learn how to extract data from multiple tables simultaneously, how to use calculated fields in sub queries, how to use the DATEPART () function in sub queries, and how to use aggregate functions in sub queries. Then we'll talk about qualification—a technique used to combine a table name with a column name so there's no question about which table the column name refers to.
    07 - Creating and Using Table Joins  
  • Joining Tables, Managing Tables, Using Views
    • In this , you'll learn how to use joins to gather information from two or more tables simultaneously. You'll learn how to use the inner join, self-join, natural join, and the outer join. Then you'll become familiar with the term Cartesian product.
    08 - Inserting, Updating, and Deleting Data  
  • Stored Procedures, Using Cursors
    • In today's , you'll discover how to manipulate data using the INSERT, UPDATE, and DELETE statements. You'll learn how to insert partial and complete rows into a table, and how to update information already stored in a table. You find out how to transfer data to a new table, how to transfer data to an existing table, and how to delete rows from a table.
      09 - Table Creation and Maintenance  
  • Using Cursors, Using Transactions
    • Today you'll find out how you can use SQL to create and maintain tables. You'll learn how to use the CREATE TABLE keywords to create a table, then we'll discuss how to use the ALTER TABLE, DROP TABLE, ADD COLUMN, and DROP COLUMN keywords to manipulate the tables themselves. You'll also find out how to define a primary key, data type, and field size.
    10 - Creating and Understanding Views  
  • In this , you'll learn how and why views are used in SQL. You'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. I'll also teach you how to update and delete a view.
      11 - Understanding Transaction Processing, Constraints, and Indexes  
  • Today, you'll learn how transaction processing, constraints, and indexes are implemented in SQL. You'll work through an example that demonstrates how a transaction is created, how constraints are used in the creation of a table, and how indexes are used to improve the performance of a database by optimizing the speed at which queries are processed.
    12 - Understanding Stored Procedures, Triggers, and Cursors  
  • In our final , you'll find out how stored procedures, triggers, and cursors are implemented in SQL. You'll see how stored procedures are created and executed, as well as how triggers work. You'll also see how cursors are declared in SQL.
    13 – How to do database testing.
  • Data Mapping
  • ACID properties validation
  • Data integrity:
  • Business rule conformity
  • 1) Transactions:
  • 2) Database schema:
  • 3) Trigger:
  • 4) Stored Procedures:
  • Field constraints – Default value, unique value and foreign key:
  • How To Test Database:
  1. Create your own Queries
  2. Observe data table by table
  3. Get query from developer
 

PHP syllabus - (contact for Date)

PHP Course Syllabus Introduction to web technology  Web application  Web server  Client and Server  Scripting languages Arrays  Array syntax  Array Index Get length without using pre-defined functions  Array push and pull  Associative arrays Loop through arrays  Multidimensional Arrays  Array functions  Array Sorting without using pre-defined functions OOPS  Classes and objects  Constructor & Destructor Inheritance  Static methods and properties  Methods overloading  Abstracts class & Interface HTML 5 Introduction & History  Basic tags and attributes  HTML5 New Elements  HTML5 Input Types  HTML5 Form Elements  HTML5 Form Attributes  HTML5 Canvas  HTML5 SVG  HTML5 Video  HTML5 Audio CSS 3  CSS Properties, Selectors, Style Declaration Types  Colors, Backgrounds, Text and Fonts  Images, Links, Tables and List  Borders, Padding, Margin  Cursor, Dimension, Scrollbars, Visibility and Positioning JavaScript Introduction to JavaScript  Variables  Operators  Data type conversion  Functions  Conditional statements and Loops  Form manipulation  Validation PHP – Understanding the Preliminaries  Introduction to web & internet  Introduction to server  Understanding localhost server  Starting PHP  PHP syntax and variables  Operators and Expressions  Conditional Branching and Looping Statements  Learning Arrays in PHP PHP - The Core Logics and Techniques  String and Math functions in PHP  Introduction HTML Form Elements and Fields  Accessing PHP, HTTP Data  Query Strings and Hyperlinks  Describing Pre-Defined Variables - Super Global Arrays  Understanding Functions, Important PHP Functions  What are the Scope of variables  Usage of Include and require statements PHP and MySQL - The Structured Repository  PHP MySQL Connectivity  Integrating Web Forms and Database  Using PHP’s MySQL Extension Learn More Advanced Techniques in PHP  Introduction to Object Oriented Programming  Classes and Objects  Abstraction, Encapsulation, Inheritance and Polymorphism  Constructors and Destructors  Overloading, Overriding of functions  Exception Handling  Regular Expressions  Session Handling  Using Cookies MySQL  MySQL datatypes  DML and DDL  Aggregate functions  Sub query and join Database Programming  PHP and MYSQL  Mysql functions  One tier architecture  Two tier Architecture  Three tier Architecture  File uploading and downloading. AJAX  Introduction  PHP AJAX example  AJAX Database programming jQuery jQuery Syntax jQuery Selectors jQuery Events  jQuery Hide/Show JSON Bootstrap Introduction to Bootstrap Bootstrap Grid System Creating Layouts with Bootstrap  Bootstrap CSS - Understanding the CSS  Responsive Web design with Bootstrap  Single Page Responsive site with Bootstrap  Bootstrap Layout Components  Bootstrap Plug-ins Dropdown Tab  Building Websites with Bootstrap CodeIgniter Framework  Introduction to PHP Frameworks  Working with CodeIgniter Framework  MVC architecture in CodeIgniter  Routing  Controllers,Views and Models  Helpers and Libraries  FormValidation  FetchingData using Input Class Webservice  Introduction  How to use API’s