| 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. |
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. |
| 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. |
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. |
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. |
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. |
| 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. |
| 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. |
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. |
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. |
| Chapter 5. Interview Questions and Assignments | |
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 – 20:
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 – 21:
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 – 22:
This video is only for Selenium Premium members. Please click here to apply.
[Content protected for ITeLearn Database Premium members only]
Back to top
