how did you use sql in your current project

Solutions on MaxInterview for how did you use sql in your current project by the best coders in the world

showing results for - "how did you use sql in your current project"
Luciano
04 Sep 2019
1Our web application uses Oracle database and 
2I normally write queries to do Data validation. 
3For example: 
4I create data from UI or I send POST request
5from API then I write query to verify that
6data was successfully and correctly inserted
7into database. Our database consists of
8many tables, so most of the time,
9I need to write queries that involve joins.
10
11CAN MENTION: Since our application has
12large sets of data, data is stored into
13Oracle and to another CACHE database. 
14I write queries to test data that both are in SYNC(same).