0% found this document useful (0 votes)
11 views29 pages

Software Testing With SQL

SLA Institute in Chennai offers IT training and placement services with over 20 years of experience and more than 90,000 successful placements. They provide expert career guidance, real-time projects, and both online and offline classes, ensuring 100% placement support through a network of over 1,000 IT recruiting partners. The curriculum includes comprehensive training in software testing, programming, and database management, catering to college students, freshers, and professionals looking to upskill.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
11 views29 pages

Software Testing With SQL

SLA Institute in Chennai offers IT training and placement services with over 20 years of experience and more than 90,000 successful placements. They provide expert career guidance, real-time projects, and both online and offline classes, ensuring 100% placement support through a network of over 1,000 IT recruiting partners. The curriculum includes comprehensive training in software testing, programming, and database management, catering to college students, freshers, and professionals looking to upskill.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

L eading

IT training
In st itu t e in
C henna i

K K Nagar
&
Navalur
About Sla Institute

20 years of
1.5 lakh 90,000+
experience in
happy Successful
training and
learners placements
placements

Authorized Training & Certification Partner for the Top Brands


Who Can Take up our services?

College students

Freshers seeking IT jobs

Candidates who want to shift


their career from non IT to IT

IT professionals who
want to upskill and
upgrade their career

Candidates with career gap


8 Reasons to Choose Us for Your
IT Training & Placements

Expert Career Guidance 1

2 IT Professional Trainers

IBM Certified Partner 3

4 Complete Job Training

Real Time Projects 5

6 Online and offline classes

100% Placement Support 7

8 1000+ IT Recruiting Partners


1 Expert Career
Guidance

You will be guided to take the right


course which will lead you to the right
Job.

We don’t sell courses !! We suggest you the right


course to help you achieve your dream IT job.

Training programs will be suggested based on


your qualification, YOP & current openings in the
market.
Instructor
led programs 2
You will be trained by Expert IT professionals

Learn from Industry Experienced Trainers

Daily tasks will be assigned

Doubts can be clarified then & there

Special Saturday Sessions


3 IBM Certified
Training Partner

Your certificate will be Globally valued!


4 Complete Job
training at one place

soft skills & interview skills

1hr/day
Technical skills
Aptitude skills
1.5 - 2hrs
/day 1hr/day

3 . 5 t o 4 h rs of s olid tra ining /d ay

Investment is less, Return is more


5
Real time
Projects
Codeathon

You will get a chance to work on real time


projects

Implement your learnings real time

Exposure to work in Teams on projects

Extensive Coding practices


6 Online &
Offline classes

You can learn at your convenience

Both modes are Instructor led & not recorded


programs
Genuine
Placement Support
7
Unlimited interviews until you get
placed !
90000+ candidates placed so far

We are the only training company with Google


reviews in which students appreciate about our
Placement services

No backdoor Jobs @ SLA. We do not collect any


money for Placement services

We provide genuine placements based on your


skill. Your Skills alone will help you enter & sustain
in IT Industry

Free lifelong placement support


8 1000+ IT
Recruiting Partners

We have a strong base of IT companies who are


hiring our students on a regular basis.
what are you
still waiting for ?

Join us now !

Take the first step towards your IT career !


Get skilled ! Get placed !

No: 10, PT Rajan Rd, Sector 1, No. E1-A10, RTS Food Street 92,
K. K. Nagar, Chennai, Rajiv Gandhi Salai (OMR), Navalur,
Tamil Nadu 600078 Chennai - 600130.

slainstitute_official slainstitute [Link]


SOFTWARE TESTING QA ARCHITECT
JOB SEEKER PROGRAM
eme
ac

nt
Pl
Genuine
Su
p port

Genuine 0% EMI
Duration Mode 3.5 - 4hrs of
Placement options
4 months Online / offline training /day
Support available

Technical Coverage
This program also includes
(1.5 - 2hrs/day)
Core Java Soft Skills and Communication
Skills(1hr/day)
MYSQL IBM International Certification

MYSQL Testing Aptitude Skills(1hr/day)

Softskills & Interview skills


Manual Testing
Mock Interview
JIRA Tool
Linked in Profile Creation
Agile Methodology GIT Hub Project Portfolio
Testing Framework Codeathon-Real time Projects

Selenium Life long free Placement support

Who can take up this program ?


Candidates must hold minimum a degree in any domain

Candidates having nil standing arrears ( if you have standing arrears


you should clear them before the course completion to access our
placement support)

College going graduates , passed out job seekers , candidates who are
working in Non IT , candidates with career gap are eligible to apply for
this program
SYLLABUS
CORE JAVA
INTRODUCTION ABOUT JAVA AND COLLECTION

What is java, features of java


JDK and Eclipse installation
What is mean by Collection framework
List and its classes
Set and its classes
Map and its classes

ARRAY

Explain about Array concept


Disadvantages of array
Find duplicates in array

CONTROL STATEMENT

Conditional statement
(if, if else, ladder if, nested if)
Looping statement
(While,do while,for for each)
Jumping statement
(Break and continue)
OOPS

Introduction about OOPS


Explain Class ,method and object
Create a simple oops program using class,
method and object
Create a program in same package different class
Different package and different class

OOPS PRINCIPLES

Inheritance and its types with real time examples


(Single,multiple,multi level,hybrid,hierarchal)
Abstraction and its types with real time examples
(Partial and fully abstraction)
Polymorphism and its types with real time
examples
(Method overloading and method riding)

POJO

Explain what is meant by POJO class


Access using getter and setter methods
STRING

Explain what is mean by string


And its methods like
Length(),toUppercase(),to LowerCase
String types like literal and non literal

EXCEPTION HANDLING

What is mean by exception


Types of exception
Try, catch ,finally explanation
Throw and throws

MYSQL / SQL
SQL BASICS & SETUP
What is SQL?
Why do we use SQL?
MySQL Installation (with GUI tool like MySQL
Workbench or phpMyAdmin)
Introduction to SQL coding structure (DDL, DML,
DCL, TCL)
SQL Datatypes (INT, VARCHAR, DATE, etc.)
ALTERING TABLES & DML BASICS

Modifying tables:

Rename table
Rename column
Modify datatype
Add/remove constraints

Data Manipulation Language (DML) Intro

INSERT INTO – creating records


UPDATE – changing records
DELETE – deleting records

FETCHING DATA & FILTERS

SELECT statement – fetching rows and columns


WHERE clause

Filtering:
BETWEEN
IN
AND
OR
NOT
Logical Operators:
=, <>, >, <, >=, <=

Aggregation & Sorting


GROUP BY – aggregating data
Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
HAVING – filtering after grouping
ORDER BY – sorting data
LIMIT and OFFSET – pagination and limiting results

Date & String Functions


Date Functions

YEAR(date) – Extract year


MONTH(date) – Extract month
NOW() – Current timestamp
DATEDIFF(date1, date2) – Difference in days
TIMESTAMPDIFF(unit, datetime1, datetime2) –
Difference in specified unit (YEAR, MONTH, etc.)

String Functions
REPLACE()
LPAD() / RPAD() – Padding
SUBSTRING()
UPPER() / LOWER()
CONCAT()
TRIM()

Joins + Normalization
Normalization

What is normalization?
1NF, 2NF, 3NF (basics with simple examples)
Purpose of normalization vs denormalization

Joins Practical
Types of Joins:
INNER JOIN – common records
LEFT JOIN – all from left + matched right
RIGHT JOIN – all from right + matched left
FULL OUTER JOIN – all records (if supported, else
simulate)
SELF JOIN – join table with itself

Subqueries

Types of Subqueries
Single Row Subquery – Returns one value
Multi Row Subquery – Returns multiple value
Correlated Subquery – Uses outer query data
inside subquery

Window Functions & CTEs


Window Functions
RANK() OVER(PARTITION BY ...)
DENSE_RANK()
LEAD(), LAG()
NTILE() – N-th bucket

Common Table Expressions (CTEs)


Stored Procedures + Triggers
Stored Procedures

What is a Stored Procedure?


Creating a procedure
Input/Output parameters
Calling a procedure

Triggers
What is a trigger?
BEFORE vs AFTER
Trigger on INSERT, UPDATE, DELETE
Use cases (e.g., logging, data validation)

Functions + Use Cases


User-Defined Functions (UDFs)
What is a SQL function?
Scalar functions (return single value)
Deterministic vs non-deterministic
Using functions in queries

Views
What is a View?
Creating and using views
Updating data through views (updatable views)
Use cases: security, abstraction, code
simplification

MYSQL DATABASE TESTING

DDL
DML
DCL
TCL
Joins
MANUAL TESTING

PRINCIPLES OF MANUAL TESTING

What is manual Testing


Benefits of manual Testing
Functional and non-functional testing
Principles

CREATE TEST CASE

Explain what is test case and test scenario


Give more practice to write a test case and test
scenario

SDLC and STLC


Explain the phases of SDLC with real time examples
like

Requirement gathering and analysis


Design
Development
Testing
Deployment
Operation and maintenance
Explain the phases of STLC with real time examples
like

Requirement analysis
Test plan
Test design
Test execution
Signoff

TYPES OF TESTING

Whitebox and BlackBox Testing


Positive and negative Testing
Formal and informal Testing
Alpha and beta testing
Smoke, regression and sanity testing

LEVELS OF TESTING

Unit Testing
Integration Testing
Top Down approach
Bottom Up approach
Big Bang approach

System Testing
UAT
TESTING TECHNIQUES

Boundary value analysis


State transition Techniques
Equivalence case partitioning techniques
Decision table techniques
Error guessing techniques with real time examples

DEFECT LIFE CYCLE

Explain what is defect ,bugs and errors


Stages of invalid bugs
Cycles of defect like from New to Closing the bugs

PRIORITY AND SEVERITY

Priority
Severity
High priority and High severity
Low priority and low severity
High priority and low severity
Low priority and high severity
SDLC METHODOLOGIES

Waterfall
Spiral
VV model
Prototype
Agile

AGILE METHODOLOGY

Agile advantages
Agile Roles
Agile Artifacts
Agile Meetings

JIRA TOOL

Explain how to write user story


And acceptance criteria
Set user story points
Set priority
Raise the bugs and complete the sprints

PROJECT PHASE 1 - MANUAL TESTING IMPLEMENTATION


AUTOMATION TESTING

TESTNG FRAMEWORK

Introduction about framework like testng, cu-


cumber,pom
Add testng plugin in eclipse
Write first testcase in testing framework using
priority,enabled,invocation count
Parallel execution,grouping,parameter
Create XML file and execute all the test case
Generate reports

SELENIUM

Introduction about Selenium Web driver


Selenium components
Download jars and drivers
Configure the jars
Set folder structure in eclipse
And launch url and get title of the webpage
LOCATORS

Explain locators and its uses


Id
Name
Classname
Xpath
Tagname
Linktext
Partial link text
CSS selector

MOUSE AND KEYBOARD ACTIONS

MoveToElement
Dragand Drop
Context click
Double click
Keypress
Keyrelease

JAVASCRIPT EXECUTOR AND SCREENSHOT

How to take a screen shot


Value passing through executor
WINDOWSHANDLING AND WEB TABLE

Get Window Handle


Get Window Handles
Rows
Columns

SELECT CLASS AND FRAMES

Dropdown
Select by value, visible text, index, deselect All
Frames like string id, name, index

WAITS AND RADIO BUTTON

Conditional and unconditional waits


Implicit wait
Explicit wait
Fluent wait
Is Selected

ALERTS AND NAVIGATION

Simple alert
Confirm alert
Prompt alert
Back
Forward and refresh

PROJECT PHASE 2 - SELINIUM TESTING IMPLEMENTATION

API TESTING

Introduction of API testing


POSTMAN TOOL

You might also like