Get Expertise in Database Testing(SQL) + Linux for Testers

Udemy

Comprehend the methods and concepts associated with Linux and SQL for database testing including DML operations, Joins, and grouping.

Online

₹ 3499

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Course introduction & Setup Instructions

Course Architecture : Must for Everyone | What we will learn in this course
Database Setup Introduction
Approach-1: Mysql Server Installation on Windows Machine (Database Server Setup)
MySQL Client Installation : Workbench on Windows Machine (Database Client Setup)
Setup Sample Tables and Test Data for practice
Sample Database, Tables with Data
Approach-2: Execute SQL query online (Incase you do not have Installed DB)
What is Database Testing ? What all testing activities we will do on Database

Fetch Data from Table using Basic Select Queries - With Data Filtration

Select Query Basics : Fetch Data from Table- Select all data or Few columns
Reference Document : Last Session Queries
Select data from table : Data filtration using WHERE Clause
Select Query : Data Filtration : Where Clause with Logical AND and OR
Select Query : Data Filtration using List and Range (IN and BETWEEN)
Fetch unique data from column and Table structure
Display data with Column Alias
Reference Document : Last Session Queries
Display data in Sorting order (Ascending & Descending )
Reference Document : Last Session Queries
Test your learning by solving these Practice Questions
Its Time for QUIZ : Check Your Knowledge

Advance Select Queries : Pattern Matching(Like with Characters) and Sub Queries

Select data with Pattern Matching(Like with Wild Card Character) - Part 1
Document : Select data with Pattern Matching - Part 1
Select data with Pattern Matching(Like with Wild Card Character) - Part 2
Document : Select data with Pattern Matching - Part 2
SQL - SubQuery : Write Query inside a Query
Reference Document : SQL - SubQuery
Test your learning by solving these Practice Questions

Other Common Select Query Operations

Select Query : Fetch Null data
Arithmetic operations on Column data
Queries of this complete section
Its Time for QUIZ : Check Your Knowledge

Delete Table Structure & Table Data (Delete, Drop, Truncate)

SQL - Delete data from tables( Delete | Drop | Truncate)
Document : Delete data from tables( Delete | Drop | Truncate)

Data Fetch and Display after Grouping (Group By and Having)

Group Functions - Mix, Max, Avg, Count, Sum
Display data with Grouping - Use Group by Clause
Filter data before and after Grouping - Where and Having in a Single Query
Queries of this complete section
Test your learning by solving these Practice Questions

Joins : Fetch Data from multiple Tables (Inner, Outer , Simple & Cross Join)

What is Join | Why and How we write join in SQL queries
Cross or Cartesian Join : Fetch data by Complete merging of 2 or more tables)
Inner Join | Equi Join | Simple Join : Fetch data by merging 2 tables(condition)
Queries to run before next video
Left Join | Left Outer Join :Fetch data by merging 2 tables(condition)+Left data
Right Join | Right Outer Join: Fetch data by merging 2 table(condition)+Right
Full Join | Full Outer Join
Self Join : Join table by Itself
Test your learning by solving these Practice Questions
Queries of this complete section

Working with Tables : Create table, Insert, Update and Delete data from table

Create Tables by Coping content from another Table
Create Table with Structure
Insert data into table : One row at a time
Update data of a table : By giving some conditions
Update Table Structure (Conditionally update data)
All Queries of this section

Advance SQL Queries : Views, Index and Union

SQL - Views : Create dummy table structure to allow limited access on data
SQL - Indexes : Increase Search statement performance
SQL- Union & Union All : Simply adding data of 2 or more tables
Queries of this complete section

Data Constraint : Apply rules to columns for Data insertion and update

SQL - Not Null constraint (Not allow to insert Null data into column)
Check Constraint : Apply condition for data to insert of update
Default Constraint : Apply default value to column in case not value given
SQL - Unique Key constraint : Apply rule to insert only unique data

Advance Constraints : Must for Realtime DB Testing and Interviews

Primary Key : Set one or more columns as Primary key(Unique + Not Null)
Foreign Key : Create Reference of Primary Key
Difference between Primary Key and Unique Key

-------QUIZ for SQL Queries ------- 25 Questions in 25 mins

Test your SQL skills

SQL Interview Questions : Must for all Interview Aspirants

Copy a Table without Structure
Find 2nd(Any number) Highest | Lowest Salary of Employee
Find Duplicate Records

Introduction to Unix (Linux)| Why as Tester we should Learn ? :Environment Setup

Documentation
Why as Tester/QA to learn Unix/Linux Commands ? Practical areas to use it as QA
Use online environment for practice(In case you don't have practice environment)
Setup Environment
Setup Practice Environment on Windows Machine (Suggestive for better practicing)

Let's Start Practical Session with very basic Unix /Linux Commands

Start working with Basic Commands : Current Directory, Clear Terminal & Help
Working with Directories - Create Directory, Move in & Move out to Directories
Working with Directories - Create Multiple Directories, Delete Directory
Different option to create files : Blank File, File with Content, Insert Data
Listing files and Folders : Hidden Files, List Format and Sorted Order
All uses of CAT command : Must for Practical Implementation & Interviews

Check content of File(Log Files) : Must Learning Concepts/practical for Tester

Documentation : Sample Data to be used for Practicing with me
Setup Sample Data to be used for Practicing with me
Check complete file content : CAT Command
Check file content : Top few lines - Head Command
Check file content : bottom few lines - Tail Command
Check file content : with Paging - More Command
Check file content : with Paging - Less Command
Check file content : with VIM editor
Commonly Asked Question : Get few lines from middle of the File

Search Data in a File : This Section is also MUST for Realtime Work + Interviews

What is Grep Command | Search data in 1 file by giving Search String
Search data in more than 1 file : Giving Search String, Practical Implementation
Search data in all files of current directory : Practical Implementation
Search data by ignoring case : Must to be use which checking Log files
Search Data : Display Line number in front of each display line
Search Data : Display File Name (When we are searching content in multiple file)

Cut & Copy Files and Folder |Taking Files and Folders from one location to Other

Copy file/folder from one location to another location - Part 1
Copy file/folder from one location to another location - Part 2
Cut file/ folder from one location to another location
Rename File and Folder

Miscellaneous commands : Some rarely use but effective commands

Check File Detail
Sort File Data
History Command
Fetch Uniq data
Basic System Commands

Introduction to Shell Scripting, Lets start Writing Shell Scripting

Shell Scripting Introduction : How to create Shell file
Write First Shell Script, Basic rules and Steps to Execute
How to pass user inputs to Shell Script file
Shell script with simple shell commands
Shell Scripting - Use Case 1 : Must to Try for Every Learner
Shell Scripting - Use Case 2 : Must to Try for Every Learner
Update Shell Script - Printf & RANDOM

Database Testing using JMeter :- Functional and Performance Testing of SQL Query

JMeter Setup Step 1: Setup Java
JMeter Setup Step 2: Install JMeter
Introduction to JMeter
Test Plan, Thread Group, Thread
Jmeter: Different type of steps in Jmeter- Part 1
Jmeter: Different type of steps in Jmeter- Part 2
Execution order of Elements-Part1
Execution order of Elements-Part2
Environment Walkthrough
First Test case in Jmeter
Declare Variables & Use It

Database Testing using JMeter :- Execute Query & Validate Result

Setup JDBC Driver for Database Connection
Setup Connection with MySQL Database
Execute SELECT query on database
Functional Validation of SELECT query Response
Pass parameters to Select Queries
Perform DML Operations ( INSERT and UPDATE queries)
Convert Functional Testcase to Performance TestCase

Popular Courses

Popular Platforms

Popular Searches

Get Expertise in Database Testing(SQL) + Linux for Testers

Online

₹ 3499

Quick Facts

Course overview

The highlights

Program offerings

Course and certificate fees

Fees information

certificate availability

certificate providing authority

Who it is for

What you will learn

The syllabus