/SQL-for-testers

from LinkedIn course for my own use

SQL-for-testers

from LinkedIn course for my own use

User workflow validation

Screen Shot 2023-04-04 at 13 02 23

Compare it with Address 1 field.

Using alias (a1).

Screen Shot 2023-04-04 at 13 02 04

Data integrity validation

Inner Join:

Screen Shot 2023-04-05 at 12 05 10

Creating new entries in a table.

Using https://www.mockaroo.com/ to generate mock data.

Screen Shot 2023-04-13 at 13 07 53

Updating existing entries in a table.

Screen Shot 2023-04-13 at 13 16 17

Screen Shot 2023-04-13 at 13 21 37

Screen Shot 2023-04-13 at 13 21 16

Updating password.

Screen Shot 2023-04-13 at 13 30 24

All the passwords were updated to 827ccb0eea8a706c4c34a16891f84e7b:

Screen Shot 2023-04-13 at 13 38 36