Setup Menus in Admin Panel

ITeLearn.com

SQL Database Testing Tutorials

SQL Database Testing Tutorials

Karthik’s SQL Database Testing Tutorials program has been designed and perfected for a beginner level professional who is seeking to lay a perfect foundation for an Automation Testing Career. This course offers you over 15-20 hours of video content, interview questions and answers, live project work and assignments.
Awesome course content
Amazing teaching
Job and real-time project focused.

Database Testing Chapter 1: Basics of Databases

In this Chapter we cover up topics like What are Databases?,Importance of Database in today’s 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.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,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.


#01 – 24min

Basics of Databases-1


#02 – 24min

Basics of Databases-2


#03 – 26min

Basics of Databases-3

Members Access: Files, Quiz, Support.
[Content protected for ITeLearn Database Premium members only]

Database Testing Chapter 2: Mastering SQL programming

In this Chapter we cover the topics like SQL – Basic tutorials,How to write your 1st SQL Statement?,What is SELECT?,What is FROM?,What is WHERE?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.


#01 – 22min

SQL Basics-1


#02 – 33min

SQL Conditions-2


#03 – 34min

SQL Insert,Update & Delete-3


#04 – 14min

SQL Top,In,Alias-4


#05 – 21min

SQL Joins,Inner Joins-5


#06 – 13min

SQL Join-6


#07 – 14min

SQL Basics-7


#08 – 29min

My SQL Installation and Commands-8

Members Access: Files, Quiz, Support.
[Content protected for ITeLearn Database Premium members only]

https://s3.amazonaws.com/itelearn-videos/database-testing/Files/new+folder/SQL-Chapter-2.zip

Database Testing Chapter 3: Testing Databases

This Chapter gives you 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


#01 – 15min

Testing Databases-1


#02 – 17min

Installation-2


#03 – 20min

Testing Applications-3


#04 – 25min

Running SQL Statements-4

Members Access: Files, Quiz, Support.
[Content protected for ITeLearn Database Premium members only]

Database Testing Chapter 4: Database Automation Testing for QTP and Selenium

This Chapter gives us an overview QTP,QTP Interaction with Databases through script,Add, Modify, Delete MS Access DB records through script,Selenium Part 1 1) DB Connections and ResultSets 2) Running SQL queries
3) Apply on TestNG and JUnit Selenium Part 2 1) DB Connections and ResultSets 2) Running SQL queries
3) Apply on TestNG and JUnit


#01 – 44min

Automation DB Test-1


#02 – 30min

Automation DB Test-2


#03 – 43min

Automation DB Test-3

Members Access: Files, Quiz, Support.
[Content protected for ITeLearn Database Premium members only]

Database Testing Chapter 5: Interview Questions and Assignments

This Chapter gives us an overview about the Interview Questions and Answers,Note-Videos for this Chapter are will be uploaded very soon.



Main Menu