SQLite is a very lightweight database, with no installation required, zero configuration, and no server required. SQLite is widely used as a database of choice in mobile apps, camera, home electronic devices and other embedded systems.

This book is designed for beginners with little or no prior database experience.

Here is what you will learn:

Chapter 1: Introduction

Chapter 2: Create Database

CREATE Database

CREATE Database in a Specific Location

Create database and populate it with tables from a file

Backup & Database

Drop Database

Chapter 3: Create, Alter, Drop Table

Create table

Drop table

Alter table

Add columns- Using ALTER TABLE Command

Insert value into a table

Chapter 4: Primary & Foreign Key

SQLite constraint

Primary Key

Not null constraint

DEFAULT Constraint

UNIQUE constraint

What is a SQLite Foreign KEY?

Chapter 5: Data Types

Storage Classes

Affinity Type

Examples of storing data types in SQLite

Chapter 6: Select, Where, Limit, Count, Group By, Union

Reading data with select

WHERE

Limiting and Ordering

Group BY

Query & Subquery

Set Operations -UNION,Intersect

Conditional results

Advanced queries

Chapter 7: Joins

Introduction to SQLite JOIN Clause

INNER JOIN

JOIN … USING

NATURAL JOIN

LEFT OUTER JOIN

CROSS JOIN

Chapter 8: INSERT, UPDATE, DELETE

INSERT

Update

Delete

Conflict clause

Chapter 9: Index, Trigger & View

View

Index

Trigger

Chapter 10: SQLite Functions

Finding the LENGTH of a string

UPPER Function and LOWER Function

TRIM Function

TYPEOF Function

SQLite LAST_INSERT_ROWID

SQLite library

User-defined functions

SAP MM is one of the core modules of the logistic process in SAP.SAP MM covers a broad area of business functionalities. There is no surprise that SAPMM is a very broad subject, and it requires ample amount of time. In order to save users time and make subject matter easy, this book is designed. The book is small but covers all important aspects of SAP MM.

This book will help you to get end-to-end knowledge of SAP MM module in a short span of time. The book has segmented SAP MM modules into various section like Master data, purchasing, pricing and Inventory management in a concise way. This edition will also guide SAP MM aspirants for their certification course.

It can be used as a user manual by SAP readers. All technical terminology are well explained. By using this book SAP implementation becomes easy, you will learn how SAP MM can be configured step by step. The screenshot and examples clearly explain various t-codes for SAP MM process. For beginners, it will be their first hand on experience with SAP MM. Learning SAP MM becomes easy with this book.

Table Content

Chapter 1: Master Data

1. Introduction to Master Data
2. How to Create Material master data
3. How to Change Material Master
4. How to Copy Material Master
5. Mass Creation of Material Master
6. Material Master Views – Ultimate Guide!

Chapter 2: Purchasing

1. Introduction to Purchasing and purchase requisition
2. How to create a purchase info record
3. How to Change a Purchase Info Record
4. How to create a purchase requisition
5. How to convert Purchase Requisition to Purchase Order

Chapter 3: Quotations

1. Overview of Quotations. How to create RFQ
2. How to Create Quotations
3. How to compare price for different Quotations
4. How to select or reject a Quotation

Chapter 4: Purchase Order

1. How to Create a Source List
2. How to Create a Purchase Order
3. How to create Purchase Order with Reference
4. How to change a Purchase Order

Chapter 5: Invoice

1. How to Post Goods receipt
2. How to perform Invoice Verification
3. How to Release an Invoice
4. Service Purchase Order
5. All About Outline agreement
6. Release procedures for purchasing documents

Chapter 6: Pricing

1. Overview of Pricing Procedure
2. How to Define Access Sequence & Condition Table
3. A How to Define condition types
4. How To Define Calculation Schema
5. How to Define Schema Group
6. Define Schema Determination

Chapter 7: Inventory Management

1. Overview of Inventory Management
2. How to create Goods Receipt
3. How To Cancel Goods Receipt
4. Reservation of Inventory
5. How to issue goods
6. Transfer Posting of Goods
7. All About Physical Inventory
8. Special

Software testing is the verifying your software product against business requirements and the enduring the Application Under Test is defect free. Contrary to popular belief, testing is not an adhoc activity but is

This book is designed for beginners with little or no prior Software Testing experience.

Here is what you will learn:

Table Of Content

Section 1- Introduction

1. What is Software Testing? Why is it Important?
2. 7 Software Testing Principles
3. What is V Model
4. Software Testing Life Cycle - STLC explained
5. Test Plan
6. What is Manual testing?
7. What is Automation Testing?

Section 2- Creating Test

1. What is Test Scenario?
2. How to Write Test Case
3. Software Testing Techniques
4. How to Create Requirements Traceability Matrix
5. Testing Review
6. Test Environment
7. Test Data
8. What is Defect?
9. Defect Life Cycle

Section 3- Testing Types

1. 100+ Types of Software Testing
2. White Box Testing
3. Black Box Testing
4. Unit Testing
5. INTEGRATION Testing
6. System Testing
7. Regression Testing
8. Sanity Testing & Smoke Testing
9. Performance Testing
10. Load Testing
11. Accessibility Testing
12. STRESS Testing
13. User Acceptance Testing
14. Backend Testing
15. Protocol Testing
16. Web Service Testing
17. API Testing

Section 4- Agile Testing

1. Agile Testing
2. Scrum Testing Beginners

Section 5- Testing Different Domains

1. Banking Domain Application Testing
2. Ecommerce Applications
3. Insurance Application Testing
4. Payment Gateway Testing
5. Retail POS Testing
6. Telecom Domain Testing
7. Data Warehouse Testing
8. Database Testing
   

You do not require much effort to be proficient in SAP ABAP language if you have access to right learning resource. With this book, you can begin with your first SAP ABAP program in minutes. The book makes ABAP program as simple as reading the specification doc, analyze the requirements and start coding. This book will give you a quick tour on basic concepts like an internal table, structures & field symbols, data dictionary, and so on.

Whether you're writing programs for HR, SD, FI, or one of the many other modules within SAP the guidelines in this book will help across all your SAP modules. To save users efforts, the abstract of SAP ABAP is put together in an understandable format. Images, examples, and code will teach you how to create database tables and lists, work with fields and calculations, and debug your code for errors in no time.

For Beginners this book can be a gateway to learn SAP ABAP. They can use this edition as a personal guide. They can learn various control command and practice them in real ABAP environment. All high level and fundamental topics of SAP ABAP required for development of SAP application are covered.

Table Content

Chapter 1: Introduction

1. Data Types
2. Control Statements
3. Logical Operator

Chapter 2: Data Dictionary

1. Domains
2. Data Elements
3. Tables
4. Structures
   
5. Aggregated Objects of ABAP Dictionary

Chapter 3: Macro,Include,Subroutines,Function Modules & Groups

1. SAP- ABAP Macro
2. Include Programs
3. Subroutines
4. Function Modules
5. Function Groups

Chapter 4: Native and Open SQL

1. Basic Open SQL Commands
2. Open SQL Return Codes
3. Open SQL - Performance Rules

Chapter 5: SAP Internal Tables

1. Types of Internal Tables
2. Creating Internal Tables
3. Populating Internal Tables
4. Reading Internal Tables
5. Deleting Internal Tables

Chapter 6: ABAP Table Controls

Chapter 7: ABAP Report Programming

1. Selection Screen
2. Events in an ABAP Report Program
3. Formatting the report
4. Interactive Programming
5. Logical Databases

Chapter 8: ABAP Dialog Programming

1. Difference between Report and Dialog Programs
2. Components of Dialog Program

Chapter 9: Subscreens

Chapter 10: Process on Value & Process on Help

1. Process on Help-Request (POH) : F1 Help
2. Process on Value (POV): F4

Chapter 11: ALV – ABAP List Viewer Programming

1. Simple Report
2. Block Report
3. Hierarchical Reports

Chapter 12: All About SAP Scripts

Selenium is a the most popular open-source test automation tool. Its widely used in Industry to automate web and mobile projects. Selenium can be used to test across different browsers and platforms.

Its flexible enough to allow you to code your automation scripts in languages like Java, C#, Python etc.

Selenium primarily has 3 components

• Selenium Integrated Development Environment (IDE)
• Selenium WebDriver
• Selenium Grid

This book covers tutorials and training to teach you Selenium 2 as well Selenium 3. The book uses Java as the scripting language.

This book covers tutorials and training to teach you Selenium 2 as well Selenium 3. The book uses Java as the scripting language.

Table Of Contents

Chapter 1: Introduction to Selenium

Chapter 2: Introduction to WebDriver & Comparison with Selenium RC

Chapter 3: Guide to install Selenium WebDriver

Chapter 4: Creating your First Script in Webdriver

Chapter 5: Find Element

Chapter 6: Accessing Forms in Webdriver

Chapter 7: Accessing Links & Tables using Selenium Webdriver

Chapter 8: Keyboard Mouse Events , Uploading Files - Webdriver

Chapter 9: Upload & Download a File

Chapter 10: XPath

Chapter 11: TestNG with Selenium

Chapter 12: Handling Date Time Picker

Chapter 13: Handling Alert & Popup

Chapter 14: Handling Dynamic Web Tables

Chapter 15: Using Contains, Sibling, Ancestor to Find Element

Chapter 16: Implicit & Explicit Waits

Chapter 17: Parameterization using XML and DataProviders

Chapter 18: Excel in Selenium

Chapter 19: Page Object Model (POM) & Page Factory

Chapter 20: Selenium Grid

Chapter 21: Keyword & Hybrid Frameworks with Selenium

Chapter 22: Database Testing using Selenium

Chapter 23: Handling Iframes in Selenium

Chapter 24: Cross Browser Testing

Chapter 25: PDF , Emails and Screenshot of Test Reports

Chapter 26: How to Take Screenshot in Selenium

Chapter 27: HTMLUnit Driver & PhantomJS

Chapter 28: Robot API

Chapter 29: AutoIT

Chapter 30: Ajax

Chapter 31: Drag and Drop action

Chapter 32: Handling Cookie

Unlike popular belief, Data Warehouse is not a single tool but a collection of software tools. A data warehouse will collect data from diverse sources into a single database. Using Business Intelligence tools, meaningful insights are drawn from this data.

The best thing about “Learn Data Warehousing in 1 Day" is that it is small and can be completed in a day. With this e-book, you will be enough knowledge to contribute and participate in a Data warehouse implementation project.

The book covers upcoming and promising technologies like Data Lakes, Data Mart, ELT (Extract Load Transform) amongst others. Following are detailed topics included in the book

Table content

Chapter 1: What Is Data Warehouse?

1. What is Data Warehouse?
   
2. Types of Data Warehouse
3. Who needs Data warehouse?
4. Why We Need Data Warehouse?
5. Data Warehouse Tools

Chapter 2: Data Warehouse Architecture

1. Characteristics of Data warehouse
2. Data Warehouse Architectures
3. Datawarehouse Components
4. Query Tools

Chapter 3: ETL Process

1. What is ETL?
2. Why do you need ETL?
3. ETL Process
4. ETL tools

Chapter 4: ETL Vs ELT

1. What is ETL?
2. Difference between ETL vs. ELT

Chapter 5: Data Modeling

1. What is Data Modelling?
2. Types of Data Models
3. Characteristics of a physical data model

Chapter 6: OLAP

1. What is Online Analytical Processing?
2. Types of OLAP systems
3. Advantages and Disadvantages of OLAP

Chapter 7: Multidimensional Olap (MOLAP)

1. What is MOLAP?
2. MOLAP Architecture
3. MOLAP Tools

Chapter 8: OLAP Vs OLTP

1. What is the meaning of OLAP?
2. What is the meaning of OLTP?
3. Difference between OLTP and OLAP

Chapter 9: Dimensional Modeling

1. What is Dimensional Model?
2. Elements of Dimensional Data Model
3. Attributes
   
4. Difference between Dimension table vs. Fact table
5. Steps of Dimensional Modelling
6. Rules for Dimensional Modelling

Chapter 10: Star and SnowFlake Schema

1. What is Multidimensional schemas?
2. What is a Star Schema?
3. What is a Snowflake Schema?
4. Difference between Start Schema and Snowflake

Chapter 11: Data Mart

1. What is Data Mart?
2. Type of Data Mart
3. Steps in Implementing a Datamart

Chapter 12: Data Mart Vs Data Warehouse

1. What is Data Warehouse?
2. What is Data Mart?
3. Differences between a Data Warehou

Practical Step by Step Hands-on book for developers, quality assurance engineers, testers, and test managers to learn Jmeter

Each chapter introduces a unique feature of Jmeter with sample code with TROUBLESHOOTING guide.

The book starts with an introduction to Jmeter and performance testing. Gives details steps to install Jmeter on various platforms. It proceeds to familiarize the reader with the Jmeter GUI. Then the book teaches to create performance test and enhance the test using Timer, Assertion, Controllers, and Processor.

The cookbook also gives detailed steps to perform distributed testing using Jmeter software.

Best Practices to successfully conduct your Jmeter test are include.

Here is what you will learn in detail-

Chapter 1: Introduction

Chapter 2: Installation Guide

Chapter 3: Complete Element Reference

Thread Group

Samplers

Listeners

Configuration

Chapter 4: Hands on with JMeter GUI

Chapter 5: Performance Testing using Jmeter

Chapter 6: Timers

Chapter 7: Assertions

Response Assertion

Duration Assertion

Size Assertion

XML Assertion

HTML Assertion

Chapter 8: Controllers

Chapter 9: Processor

Chapter 10: Distributed Testing in JMeter

Chapter 11: HTTP Proxy Server Testing

Chapter 12: Best Practices for your Jmeter Tests

If you are one of them who easily get scared of Python’s long, complicated code, then this e-book is for you. Python is a powerful programming language used on various platforms like video streaming and file hosting services. Getting proficient in Python language means you are capable of creating scientific applications, data sciences or machine learning algorithm. The biggest advantage of Python is that it is a free language, and anyone can change, correct or improve the algorithm.

If you want to learn Python real fast, this course can be helpful to you.  It extracted some complex concepts of Python and explained them into simple steps. The e-book made Python so simple that you can easily master the Python language even if you have never coded before.

The e-book has covered various Python coding concepts like classes, objects, tuples, strings, and so on. The examples are chosen carefully to illustrate all the Python concepts in easy to understand for beginners. The book also links to the additional course, guidance and tutorials for further reference. Even kids can use this e-book as a Python dictionary, where they can quickly learn Python programming concepts.

Table Of Content

Chapter 1: Install Python

Chapter 2: Creating Your First Python Program

Chapter 3: Python Main Function

Chapter 4: Variables

Chapter 5: Strings

Chapter 6: TUPLE

Chapter 7: Python Dictionary

Chapter 8: Operators

Chapter 9: Functions

Chapter 10: IF Statement

Chapter 11: Loops

Chapter 12: Class & Objects

Chapter 13: Regular Expressions

Chapter 14: Date, time and datetime classes in Python

Chapter 15: Calendar

Chapter 16: Reading and Writing Files in Python

Chapter 17: If File or Directory Exists

Chapter 18: Python COPY File

Chapter 19: Python Rename File

Chapter 20: Python ZIP file

Chapter 21: Accessing Internet Data with Python

Chapter 22: Manipulating XML with Python

The e-book has used screenshot and graphics explicitly for explaining code examples. With this Python crash course, you will discover that Python is not what that lengthy books, expensive online courses or complicated Python tutorial books have projected. After reading this Python book, you will not only gain knowledge but able to retain the knowledge for longer.

SAP HR/ HCM is a very popular in the SAP ERP landscape.

Learn SAP HR/ HCM in 1 Day serves as beginner guide for a crash course in SAP HR/ HCM module.

SAP Human Resource aka Human Capital Management deals with HR related activites.

Who This Book Is For?

If you have a background is with SAP ERP product and want to learn about HR and leverage your configuration skills then this book is for you.

Here is what you will learn

Table Of Content

Chapter 1 Infotypes

1. What is an Infotype?
2. How to create an Infotype
3. How to Display an Infotype
4. How to Change an Infotype
5. How to Copy an Infotype
6. How to Delete an Infotype
7. How to Display Overview of an Infotype
8. SAP Fast Entry Tutorial

Chapter 2 Actions

1. How to view all Infotypes Saved for an Employee
2. All About Infotype 0003 – Payroll Status
3. What are Time Constraints ?
4. SAP Personnel Actions Tutorial
5. How to delete a Personnel Number in SAP

Chapter 3 Organizational Management

1. What is structures in SAP? Different types of structures
2. Learn Organizational Management (OM) in SAP HR
3. How SAP HR organization works as a single unit
4. How to maintain organizational management infotypes in SAP
5. Intoduction to Organization and Staffing Transaction

Chapter 4 Organizational Unit

1. How to create an Organizational Unit
2. How to create an Org Unit within Existing Structure

Chapter 5 Position

1. How to Create a New Position?
2. How to Copy a New Position
3. How to Delimit a Position
4. Identify a Position as Head of Org Unit
5. How to assign a Job & Cost Center to a Position

Chapter 6: Time

1. Learn Time Management using SAP HR
2. How to Run Time Evaluation in SAP HR
3. How to Check Time Evaluation Results in SAP HR

Chapter 7: Payroll

1. Overview of Payroll Process in SAP
2. What is Payroll Area and Payroll Period?
3. All About Payroll Control Record
4. How to Execute Payroll in SAP
5. How to Check Payroll Results using PC_PAYRESULT
6. How to Delete Payroll Results
7. How to Execute Payroll in Background
8. What is Off Cycle Payroll ?
9. How to Audit Payroll
10. What is Matchcode W ?
11. Different categories of WageTypes in SAP

Chapter 8: Post Payroll Run Activities

1. All About Bank Transfer using DME in SAP
2. How to Create a Bank Key
3. Posting to General Ledger
4. All About Ad-Hoc Query
   

Databases can be found in almost all software applications. Infact it's hard to find a software that doesn’t use a database. SQL is the standard language to query a database. SQL stand for: Structured Query Language. SQL provides basic to advance commands to retrieve, update, delete, insert data into database.

This book is designed for beginners with little or no prior database experience.

Here is what you will learn:

Chapter 1: Introduction to Database and MySQL

What is Data?

What is a database?

What is a Database Management System?

Types of DBMS

What is SQL?

What is NoSQL?

Chapter 2: Install MySQL workbench

What is MySQL?

Why use MySQL?

Introducing MySQL Workbench

MySQL workbench- Modeling and Design tool

MySQL workbench - SQL development tool

Install MySQL workbench Guide

Chapter 3: Introduction To Database Design

Why Database Design is Important?

Database development life cycle

Requirements analysis

Database designing

Implementation

Types of Database Techniques

Chapter 4: Database Normalization

What is Normalization?

1NF Rules

What is Composite Key

2NF Rules

3NF Rules

Boyce-Codd Normal Form (BCNF)

Chapter 5: ER Modeling

What is ER Modeling?

Enhanced Entity Relationship (EER) Model

Why use ER Model?

Entities in the "MyFlix" library

Defining the relationships among entities

Chapter 6: How To Create A Database

Create Database

Creating Tables MySQL

Data types

MySQL workbench ER diagram forward Engineering

Chapter 7: How to use SELECT in MySQL

Chapter 8: Where clause in MySQL

Chapter 9: How to use INSERT Into in MySQL

Chapter 10: How to Delete & Update data in MySQL

Chapter 11: ORDER BY, DESC and ASC

Chapter 12: Group By

Chapter 13: Wildcards

Chapter 14: Regular Expressions

Chapter 15: MySQL PHP

Chapter 16: Aggregate Function in MySQL

Chapter 17: Null value & Keyword in MySQL

Chapter 18: Auto Increment

Chapter 19: Alter, Drop & Rename

Chapter 20: Limit keyword

Chapter 21: Sub-Queries

Chapter 22: Joins

Chapter 23: Unions

Chapter 24: Views

Chapter 25: Index in MySQL

Apache Hive is the new member in database family that works within the Hadoop ecosystem. It provides all great features like data summarization, ad-hoc query, and analysis of large datasets. If you are not a good programmer, then this edition will teach you how to use hive queries without writing complex codes.

Most users face the problem of not getting a dedicated course on Hive. The goal of this e-book is to cater everything about Hive and only Hive with minimum jargons. The notes, lessons and hands-on examples in this small e-book are simplified and tactfully presented to solve all your Hive queries. Instead of writing long code for MapReduce or Java, the e-book shows tips on writing the same program with a minimum code snippet.

Beginners as well as peers will thoroughly enjoy this book. They will discover and learn more hive patterns for data processing and data integrations. Unlike other e-book, where they skip basic detail thinking users having prior subject knowledge. This edition has given complete attention to each and every small aspect of the hive like “how to set up and configure Hive in your environment”.

This e-book is also helpful for those who just want to explore Hive and don’t want to spend big bucks for short courses. You will quickly learn, apply and share your Hive knowledge with this e-book.

Table of content

Chapter 1: Introduction

What is Hive?

Hive Architecture

Different modes of Hive

What is Hive Server2 (HS2)?

Hive vs Map Reduce

Chapter 2: Installation and Configuration

Installation of Hive

Hive shell commands

Install and configure MYSQL database

Chapter 3: Data operations

Data types in Hive

Creation and dropping of Database in Hive

Create, Drop and altering of tables in Hive

Table types and its Usage

Partitions

Buckets

Chapter 4: Queries and Implementation

Order by query

Group by query

Sort by

Cluster By

Distribute By

Join queries

Different type of joins

Sub queries

Embedding custom scripts

UDFs (User Define Functions)

Chapter 5: Query Language, Built-in Operators and Functions

Hive Query Language (HQL)

Built-in operators

Built-in functions

Chapter 6: Data Extraction

Working with Structured Data using Hive

Working with Semi structured data using Hive (XML, JSON)

Hive in Real time projects – When and Where to Use

Real-time financial information helps the organization to take important decisions. SAP FICO is a complete financial management ERP solution that integrates the accounting side of business. Most SAP consultants find difficult how and what part of the business process they should bring under SAP FICO. This e-book can actually act as a demo for them, where they will learn to integrate the important business module into SAP FICO.

This e-book is intentionally prepared small to keep it simple and straight to the point. The book did not miss on any of the SAP FICO topics like Accounts Payable, Accounts Receivables, Bank Accounting, General Ledger, Asset Accounting, and so on. The book has given a practical example and explained them step by step. The example teaches you each SAP FICO module in detail including how their transaction code works.

Not only SAP consultant but any beginners will be benefited with this book. Where company demands experienced SAP consultant to handle their finance, this book could be a first handon experience for SAP aspirant. This e-book has also given a referral to some basic accounting concept and terminologies to help beginners.

Where online training or courses charges you the hefty amount for teaching you the same, and no guaranteed returns. This book can help you to reduce that cost. This e-book is an ultimate guide to learn SAP FICO.

Table Content

Chapter 1: Organizational Structure

1. Create Financial Statement Version
2. How to perform a Journal Entry Posting

Chapter 2: General Ledger

1. Fiscal Year Variant
2. Assign Company Code To Fiscal Year Variant
3. Define Posting Period Variant
4. Opening And Closing Posting Periods
5. Define Field Status Variant And Field Status Group
6. Assign Field Status Variant To Company Code
7. Document Type And Number Ranges
8. Post With Reference
9. Hold Document
10. Park Document

Chapter 3: Accounts Receivable

1. Create a Customer Master Data
2. Change Customer Documents
3. How to Display Changes in Customer Master
4. How to Block or Delete a Customer
5. Create Customer Account Group
6. One Time Customer
7. How to post a Sales Invoice
8. Document Reversal
9. Sales Returns – Credit Memo
10. How to Post Incoming Payment
11. How to post a Foreign Currency Invoice
12. Incoming Partial Payments By Residual Method
13. Incoming Partial Payments By Partial Payment Method
14. How to Reset AR Cleared Items
15. Credit Control for the Customer

Chapter 4: Accounts Payable

1. How to Create a Vendor
2. How to Create a Vendor Account Group
3. How to Display Changes in Vendor Master
4. How to Block or Delete a Vendor
5. Create Vendor Master Data
6. One Time Vendor
7. Purchase Invoice Posting
8. Purchases Returns – Credit Memo
9. Outgoing Payments
10. Foreign Currency Vendor Invoice