SQL Database Training Videos


Click here to go to the SQL Database Testing Home Page>>

Database testing is very important in a testing cycle of a tester, it is basically used to check the values extracted from the table of a web based or desktop application.The main aim behind drafting this 10 hours of course was to help a beginner level professional to lay a perfect foundation in his/her Testing Career.

All Chapters:

01-Basics of Database Testing Free Videos(2 videos, 48 minutes) ||| 02-Database Testing Basics(1 video, 26 minutes) ||| 03-Mastering SQL Programming(8 videos, 3.2 hours) ||| 04-Testing databases(4 videos, 2 hours) ||| 05-Database Testing using QTP and Selenium(3 videos, 2 hours)

Chapter 1: Basics of Database Testing Free Videos(2 videos, 48 minutes)

In this playlist, you are introduced to 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. 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, The basics of Microsoft Excel, create multiple MS Excel sheets and store data.To apply for membership, please visit our Pricing page.

Chapter 1: Files, Quiz, Assignments, Support below (for members):
Download Files | Tech Help | Report an Issue

Go back to TOP

Chapter 2: Database Testing Basics(1 video, 26 minutes)

In this playlist, we cover about 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 and Create a basic MS Access form to view, navigate and add new data.

[Content protected for ITeLearn Database Premium members only]

Go back to TOP

Chapter 3: Mastering SQL Programming(8 videos, 3.2 hours)

In this playlist, we cover the topics like SQL – Basic tutorials, How to write your 1st SQL Statement?, What is Select and Where Statements ? “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, SQL Insert: To add new records, SQL Update: Update existing records,SQL Delete: Delete existing records, 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, SQL Joins, SQL Inner Joins, SQL LEFT Join, SQL RIGHT Join. SQL FULL Join, SQL Count, SQL Create, SQL Alter, SQL Drop, How to Install MySQL Database?, How to run different SQL queries through command prompt on MySQL Database?, Help Doc to install MySQL and Help Doc to run MySQL Commands.

[Content protected for ITeLearn Database Premium members only]

Go back to TOP

Chapter 4: Testing databases(4 videos, 2 hours)

In this playlist, you get an overview of 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?,Installing XAMPP, Apache Server, MySQL, Installing OrangeHRM, Installing Toad for MySQL, 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?and Running SQL statements pick from previous exercises.

[Content protected for ITeLearn Database Premium members only]

Go back to TOP

Chapter 5: Database Testing using QTP and Selenium(3 videos, 2 hours)

In this playlist, we learn about QTP, QTP Interaction with Databases through script,Add, Modify, Delete MS Access DB records through script, Selenium DB Connections and ResultSets, Running SQL queries and Apply on TestNG and JUnit.

[Content protected for ITeLearn Database Premium members only]

Go back to TOP