TechPro

   Introduction to SQA - SQA should be utilized to the full extend with traceability of errors, cost efficient . There are the principles behind a highly efficient SQA procedure. Every business should use SQA and use it to the best as they can. They can easily guide the application to be the best procedure. Everything should be “spick and span” when SQA has been executed.   Since it is internationally recognized, the application should not only have a local impact but global acceptance at the same time. Businesses that develop and application and setting it for global standard will have a high reputation and the salability is even better. SQA definitely has benefits that will launch the company towards the global standard it needs.   NEED OF SQA -  There are so many reasons why a company should consider SQA. It is all about business survival and SQA is just one of the many tools the company should effectively use. And just like a tool, it has to be eff...

   Levels of Software Testing There are various testing levels one of which is unit testing in which the smallest testable part of an application is testing for correctness. In integration testing we check the system when we linking  the various modules.  In system testing we check the system as a whole from customers’ viewpoint. Acceptance testing tries to check whether the system is acceptable by most of the users. Alpha testing is carried out at developer’s site and beta is at customer’s site. A Testers workbench is a virtual environment used to verify the correctness or soundness of a design or model. 11 step testing process is a experience based practical approach for solution to a test assignment.     UNIT TESTING -        Unit testing is a software development process in which the smallest testable parts of an application, called units, are individually and independently scrutinized for proper operation. Unit testing is often...

   PHP Language Core  Intended Audience It is anticipated that the typical reader already has some web based experience at least in terms of understanding the concepts of a web server and creating HTML based content. While prior programming and  scripting experience will be beneficial to the reader, this book is designed  such that even the non-programmer can quickly get up to speed with  PHP.  The History of PHP Every once in a while a person faces a particular problem or requirement  to which there appears to be no existing solution. Faced with this problem  the person decides to create a solution to provide the needed functionality. Having developed the solution to their problem it then occurs to them that others may need to solve the same problem, and they decide to make their solution freely available to others who, in turn, can use and improve on it. Within a short period of time many people adopt the technology and work on it, adding n...

   Storage Management Concept • A file system is an organized structure of data-holding files and directories residing on a storage device, such as a physical disk or partition. The process of adding a new file system to the existing directory tree is called mounting.  The  directory where the new file system is mounted is referred to as a mount point. Hard disks and storage devices are normally divided up into smaller chunks called partitions.  Mount point & File System • A file system is an organized structure of data-holding files and directories residing on a storage device, such as a physical disk or partition. The process of adding a new file system to the existing directory tree is called mounting. The directory where the new file system is mounted is referred to as a mount point. Hard disks and storage devices are normally divided up into smaller chunks called partitions. • Partition can be assigning same file system or different file system; it depe...

   Windows Client-Side Hypervisor  l The client-side Hypervisor known as Client Hyper-V was introduced in Windows 8 Operating system. In Windows 10,  t he Client-side Hyper-V has got its features enhanced. Need for client Hyper-V - l Client Hyper-V is used to test or perform demo of operating system features or particular application software.  l Client Hyper-V can also be used to Run a legacy application that are not supported by Windows 10 .  It is used for User support and Troubleshooting. Features of Client Hyper-V are :   l Client Hyper-V supports 32 bit or 64-bit Virtual Machines.  l Used for storage migration or can also be used to create a virtual storage pool.  l Client Hyper-V uses VHD with maximum limit 2TB or VHDX with maximum limit of 64 TB software disk files.  l It can use local software Disk or LAN based storage also known as NAS Network Attached Storage.  l Client Hyper-V supports Import and Export of the VMs to Ser...

  DATA MANIPULATION & CONTROL After reading this chapter you will able to -   state SQL, DDL, DML, DCL Statements   Select, group by & having clause     String & set operations    Aggregate Functions    Nested Sub Queries     Embedded & Dynamic SQL In this chapter we study the query language :  Structured Query Language (SQL) which uses a combination of Relational algebra and Relational calculus. It is a data sub language used to organize, manage and retrieve data from relational database, which is managed by Relational Database Management System (RDBMS). Vendors of DBMS like Oracle, IBM, DB2, Sybase, and Ingress use SQL as programming language for their database.   SQL originated with the system R project in 1974 at IBM's San Jose Research Centre. Original version of SQL was SEQUEL which was an Application Program Interface (API) to the system R project. The predecessor of SEQUEL was named ...

                                          PL / SQL   Pl/SQL    state Loops in PL/SQL   Built in Function     Cursor Management     Exception INTRODUCTION   PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages,  resulting in a structural language that is more powerful than  SQL.PL/SQL is not case sensitive. ‘C’ style comments (/* ……… */)  may be used in PL/SQL programs whenever required.   All PL/SQL programs are made up of blocks, each block performs  a logical action in the program. A PL/SQL block consists of three parts  1. Declaration section   2. Executable section   3. Exception handling section  Only the executable section is required. The other sections are  optional.  A PL/SQL block h...