ITLearning Hub

                             : Joins in NoSQL world: Here in NoSQL world, we have $lookup aggregate function for performing joins and it performs left outer equi-join functionality. This aggregate function is only available from MongoDB 3.2 versions only. The Left outer equi-join produces a result set that contains data for all documents from the left table (collection) together with data from the right table (collection) for documents where there is a match with documents from the left table (collection). See the diagram below                      $lookup – Left Outer Equi-Joins Below diagram illustrates the syntax for performing the join: 1)    leftCollection is the collection that the aggregation is being performed on and is the left collection in the join 2)    from identifies the collection that it will be joined with – the ...

Neatly explained why to use and why not use the katalon studio based on this we can take a decision where to go with it or not. https://www.altexsoft.com/blog/engineering/the-good-and-the-bad-of-katalon-studio-automation-testing-tool/

I felt this blog has neatly explained the difference between selenium and puppeteer and which to pick at which instances and so on. https://blog.testproject.io/2020/02/20/selenium-vs-puppeteer-when-to-choose-what/   https://dev.to/endtest/puppeteer-vs-selenium-1938

Hi All, This site was developed by one of my co-worker Krishnakanth Kondoju  and I found this site is very helpful for the one who is interested to learn more about ReactJs, JavaScript and so on as point of developer and sharing it with you all. I would like to thank him for letting me post is his site in my blog and helping other. https://ui-webkit.netlify.app/docs/

 Hi All,  Today I was inspired by few sites where I saw few SQL queries that are been asked in interviews a lot and wanted to share with you all. So, that everyone can benefit of it. https://www.techbeamers.com/sql-query-questions-answers-for-practice/  https://www.complexsql.com/real-time-scenarios-in-sql-queries/   https://www.complexsql.com/complex-sql-queries-examples-with-answers/complex-sql-for-interviews/  https://www.interviewbit.com/sql-interview-questions/ https://www.softwaretestingmaterial.com/sql-interview-questions/

  -           To check the current database list cmd> show dbs; -           To drop database cmd> db.dropdatabase( ); -           To create collection cmd> db.createCollection(“collection name”); or Use <collection name> -           To insert a document into the collection cmd> db.collectionname.insert([{}]); //insert many documents or one document           db.collectionname.insertOne({}); //inserts one document           db.collectionname.insertMany([{},{}]); //insert many documents -           To Print data in Json format cmd> db.collectionname.find( ).forEach(printjson); -        ...