Sunday, May 17, 2020

How to record or save any online music audio on your PC or laptop

https://youtu.be/pUrcthfoRlM

Steps to follow:

1. Before recording, go to SOUND SETTINGS - SOUND CONTROL PANEL - Under Recording tab, ensure that STEREO MIX is selected as default.

2. Keep volume levels near 50% at max, as high-volume levels will create distortion in audio recordings.h

3. Play any online audio or video and open VOICE RECORDER on your pc/laptop and start recording.

4. . Audio recordings will be in M4A format which are playable on mobiles as well.

Video instructions link for above steps:
https://youtu.be/pUrcthfoRlM

This method is useful for recording from online music platforms like Hungama, Gaana, Saavan , wynk etc. and also office meetings on ZOOM, Skype etc.

Disclaimer:
This video is created only for educational purposes and you are not supposed to distribute the downloaded contents, as doing so is against Indian Copyright Act 1957 with fines ranging upto Rs 3 lacs and punishment upto 3 years imprisonment.

Sunday, April 12, 2020

How to view Google 3D AR Animals | watch AR Tiger and other animals


Steps to view Google 3D AR Animals
- Go to Google and search “Tiger”
- Click on View in 3D
- View in your Space
- Move your phone around to get the Tiger 

Above is the quick video on how to view and play with AR based 3D animals on google search, from your android phone.

Prerequisites:

Check whether the Google Play Services for AR app can be installed on your phone.
https://play.google.com/store/apps/details?id=com.google.ar.core

Link to see the complete list of devices:
https://developers.google.com/ar/discover/supported-devices

Note: I am using Redmi note 7 pro and it supports Google’s ARCore.


Saturday, February 29, 2020

Basics of data warehouse and ETL testing


I have created this video for software testing professionals, who are beginners with ETL testing. 
In this video, we will go through the basic concepts of database, date warehouse and SQL queries required to perform ETL testing.

Agenda includes introduction of database, data warehouse and basic difference between them.
We will go through ETL based data warehouse architecture, which talk about ETL process.
We will have a look at the concept of dimensions and fact tables, which are part of data warehouse.
ETL testing approach along with basics of SQL queries will be seen. At the end, we will have look at simple automation method for ETL testing as well.
https://youtu.be/jor49_utDlU

Note that only theoretical points will be explained in this video, as it is not feasible to show you test execution of actual live project due to multiple constraints.

Overall, this video will help students as well as those who are seeking ETL testing interviews.

If any question/clarification, please let me know in the comments section below.