A11Y

  A11Y - Usable by everyone with or without disabilities. Recently I did MOB learning on accessibility testing with Rahul, Apoorva, and Pallavi. We have recorded our learnings and my study notes.

Accessibility Testing: A11Y 

12 Mindless Habits That Are Secretly Exhausting You

 I recently read '12 Mindless Habits Thar Are Secretly Exhausting You.' by 'Krissy Brady', summarized my reading in mindmaps. The three habits start with 'W.' more apt in today's times...if you are interested in deep dive, follow below bit.ly 

 

12MindlessHabits

Querying Microsoft SQL Server 2012

   Study notes for Querying Microsoft SQL Server 2012 in a mind map.

API-Webservices

          I have done the CP-WSR since then I want to capture the learnings in the mind map for reference. Recently I was able to review and come with my notes as a mind map.

Life Is Beautiful

  

    I am not sure when/how I downloaded this book, recently read this 'Life Is Beautiful' book, it's small book but interesting. Author nicely organized how she got inspired from different personalities and more importantly provided references to the books on those personalities, that would be the reason I would have downloaded the this book. Prepared notes in mind map so that I can plan to read the books. 

Conversations - SkyGrid

 Few weeks back I got an opportunity to had conversation with skygrid leadership, I was really excited about the products and the work they do in airspace system built on AI and blockchain. To make engaged conversations I spent some time exploring the product as a consumer. With that excitement prepared below feature map...

ETL - 200

        Since my original ETL 101 post, I have been spending quality time to retrospect myself to evaluate my ETL knowledge. This evaluation helped me to close the gaps that I have. I came up with the below ETL concepts/skillset mind map that may help to evaluate ETL concept/skillset.

ETL 201

ETL 202

StoryShots - KOBE BRYANT The MAMBA MENTALITY

 

                                 Last week I listened to the story 'KOBE BRYANT The MAMBA MENTALITY in StoryShots, people familiar with US basketball or NBA defiantly know who is KOBE. I have listened to the entire one-hour podcast in StoryShots a couple of times felt like it's good to put it in a mindmap.

RWD-Testing: Responsive Web Design Testing

 

        Responsive Web Design? Any unique test strategy to be followed for Responsive Web Design Testing? I got these questions when I heard about RWD, result of my homework is below the mindmap.

API Testing - HTTP Status Codes

          HTTP Status Codes? If we ever worked on an application which implemented on APIs or Webservices or Microservices not only knows HTTP Status Codes, might aware of few status codes like 200 or 401 or 500 likewise I am also familiar with these codes. A recent conversation with one of my colleague on these HTTP statuses Codes triggered me to explore various types of status codes and got curious why we are validating few status codes as part of testing. Before deep-diving into the rest of the HTTP status codes implementation, I thought of knowing available status codes that resulted below the mindmap.

What next? Explore how other status codes being implemented.

SQL - Datefunctions

        The Other day I was testing a story wherein I need to count the number of days with the current date to validate the end results.

        x/y/z columns date is greater than 60 days but less than 210 days.

        x/y/z columns date is greater than 60 days between 210 and 330.

     During test design, have prepared an excel sheet with the 'DAYS' function to auto calculate the days. However, I need to run SQL SELECT query against few tables copy the data into excel to cross-check, and then use the test data in API endpoints for further validation. Instead of using excel, I got a question why can't I check in SQL itself. Without putting much effort found inbuilt datefunctions, though they were many datefunctions I happened to use the below for testing.

 

        DATEDIFF(datepart, startdate, enddate) - three arguments

                        datepart - units in which differences to be reported.

            

         SELECT 

                    E.EMPID,

                    E.DEPT,

                    E.JOINDATE,

         FROM   EMPLOYEE E

         WHERE DATEDIFF(DAY,E.JOINDATE,GETDATE()) > 60

        DATEADD(datepart, number, date) - three arguments

                    this function adds a specified number value to a specified datepart.

        Ex: Notification to be given between 210 and 330 days based on 'y' column date.

         SELECT 

                    E.EMPID,

                    E.DEPT,

                    E.JOINDATE,

         FROM   EMPLOYEE E

         WHERE E.JOINDATE <= DATEADD(DAY,-210,GETDATE())

             AND E.JOINDATE >= DATEADD(DAY,-310,GETDATE()) 

        CONVERT(DATE, CREATEDON) - Though it's not datefunction, I have used it widely to format the DateTime columns to a specific format.

        

    

ETL Testing - 101

                                        ETL Testing...we all know its full form is Extract Transform Load. Unlike traditional testing or backend/database testing ETL testing to be done with a different test approach. Though I have done combination backend, database and ETL testing in past I did not deep dive into ETL testing until I was asked to explain how I would do ETL testing. Since then I am spending time unlearn-learn...came across the site Datagaps...though there are many sources to learn have started going through this site and taking notes. Made an attempt to represent the notes in mind-map for easy reference.

Typical Testing Day

 

            Recently I came across a situation where I need to find whether a particular column has an integer value or varchar...there could be many ways to find the outcome however found the below query which is very simple.

Let us say we have a table called EMPLOYEE and ID is a varchar column, I need to find records which as integer or char.

SELECT * FROM EMPLOYEE

                    WHERE ID LIKE '%[^0-9]%' -- Looks for 0-9

                     OR ID LIKE '_%-%' -- Looks for the '-' other than 1st position.

 

If you ever come across a situation wherein you have to quickly modify the list of things in the SQL query...probably either you would have copied that text into excel added some formula to get the desired format. Instead, we can use this little trick in the SQL Query window itself...

   Hold ALT and mouse left click...you will notice vertical line '|' each string like below after that we can add the same character before or after the vertical line.

Hope it helps