SQL Database Testing Tutorials


Chapter 1. Basics of Databases
Day 01 (24 mins)
What is covered in this video?
What are Databases?
Importance of Database in todays software world?
Project 1: A sample job portal for creating a database
Creating basic data structure and data content in a notepad.
The basics of Microsoft Excel, create multiple MS Excel sheets and store data.

Free Content: This video is free for everyone.
Apply for new membership? | Already a member? Sign-in.

Day 02 (24 mins)
What is covered in this video?
Intro to MS Access Database.
Creating a MS Access DB
Creating tables in a MS Access DB
Understanding Primary Keys in Database
Understanding Data types
Importing from MS Excel into MS Access
Adding records to MS Access DB

Free Content: This video is free for everyone.
Apply for new membership? | Already a member? Sign-in.

Day 03 (26 mins)
What is covered in this video?
Database Table relationships
Creating new relationships between table fields
Adding look-ups from one table to the other
Understanding the MS Access forms and how they work
Create a basic MS Access form to view, navigate and add new data.

Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

Chapter 2: Mastering SQL programming
Day 04 (22 mins)
What is covered in this video?
SQL – Basic tutorials
How to write your 1st SQL Statement?
What is SELECT?
What is FROM?
What is WHERE?

Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

Day 05 (33 mins)
What is covered in this video?
SQL Conditions
Using “OR” and “AND”
ORDER BY: Sorting records Ascending/ Descending
BETWEEN : Display records in a range between 2 values
DISTINCT : How to get unique records only

Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

Day 06 (34 mins)
What is covered in this video?
SQL Insert: To add new records
SQL Update: Update existing records
SQL Delete: Delete existing records

Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

Day 07 (14 mins)
What is covered in this video?
SQL Top: How many rows to return
SQL In: Provide multiple values in your where clause
SQL Alias: Giving short names to a table inside a query

Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

Day 08 (20:41 mins)
What is covered in this video?
SQL Joins
SQL Inner Joins

Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

Day 09 (12:47 mins)
What is covered in this video?
SQL LEFT Join
SQL RIGHT Join
SQL FULL Join
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.
Day 10 (14:03 mins)
What is covered in this video?
SQL Count
SQL Create
SQL Alter
SQL Drop
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.
Day 11 – MySQL Installation and Commands (29 mins)
What is covered in this video?
How to Install MySQL Database?
How to run different SQL queries through command prompt on MySQL Database?
Help Doc to install MySQL.
Help Doc to run MySQL Commands.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.
Chapter 3. Testing Databases
Day 12 (14:48 mins)
What is covered in this video?
Why is Testing Databases important?
How do we Test Databases? Basic level intro.
What is Black Box Database Testing?
What is White Box Database Testing?
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.
Day 13 (17:28 mins)
What is covered in this video?
Installing XAMPP, Apache Server, MySQL
Installing OrangeHRM
Installing Toad for MySQL.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.
Day 14 (20:00 min)
What is covered in this video?
Starting the work -Launch Xampp-Launch Toad-Launch App
Testing the application Front end changes
Testing the db backend changes
What should be tested
Preparation of Test cases for Database Testing
How to use toad to its potential?
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.
Day 15 (25:00 min)
What is covered in this video?
Running SQL stmts
pick from previous exercises
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.
Chapter 4. Database Automation Testing for QTP and Selenium
Automation DB Test 1 (44:32 mins)
What is covered in this video?
QTP
QTP Interaction with Databases through script
Add, Modify, Delete MS Access DB records through script

Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

Automation DB Test 2(29:41 mins)
What is covered in this video?
Selenium Part 1
1) DB Connections and ResultSets
2) Running SQL queries
3) Apply on TestNG and JUnit

Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

Automation DB Test 3 (43:09 mins)
What is covered in this video?
Selenium Part 2
1) DB Connections and ResultSets
2) Running SQL queries
3) Apply on TestNG and JUnit

Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

Video – 01 .

Back to top

Video – 02 .


Back to top


Video – 03
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 04
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 05
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 06
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 07
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 08
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 09
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 10
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


MySQL – Installation and Basic Commands
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 12
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 13
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 14
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 15
.
Premium Content: This video is for Database Premium Members only.
Apply for new membership? | Already a member? Sign-in.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 16:

This video is only for QTP Premium members. Please click here to apply.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 17:

This video is only for Selenium Premium members. Please click here to apply.

[Content protected for ITeLearn Database Premium members only]
Back to top


Video – 18:

This video is only for Selenium Premium members. Please click here to apply.

[Content protected for ITeLearn Database Premium members only]
Back to top