FAANG Algorithms.md

• https://www.udemy.com/course/100-leetcode-algorithm-questions-for-technical-interview/
• https://www.udemy.com/course/coding-interview-question-data-structures-algorithm/
• https://www.udemy.com/course/ultimate-javascript-leetcode-interview-bootcamp/
• https://www.udemy.com/course/leetcode-coding-interview-question-solution-explanation/
• https://www.udemy.com/course/50-problems/
• https://www.udemy.com/course/master-the-coding-interview-data-structures-algorithms/
• https://www.udemy.com/course/leetcode-in-python-50-algorithms-coding-interview-questions/
• https://www.udemy.com/course/master-the-coding-interview-big-tech-faang-interviews/
• https://www.udemy.com/course/crack-the-leetcode-interview-high-frequency-questions/

Software Interviews.md

1.) How you keep the code clean and easy to read?

• I use https://en.wikipedia.org/wiki/ABC_Software_Metric to keep the code decloupled and the statements small
• I write documentation comments in every class, method and functions to help developers to understand the software
• I try to use tools to auto generate a UI with the docs of the software like https://ruby-doc.org/

2.) How you know which database use in a particular case?

• I define which distributed system capabilities the case needs using the CAP Theorem
• Then I analize wheter needs structured or non-structured data, qualitative or quantitative data, whether we needs do aggregate calculations using the data or we does not.

3.) How you manage background job tasks?

• I always define the background jobs like nodes in a graph in function of the time.
• I use Directed Acyclic Graphs (DAGs) when I need design the orchestration of several backgroun jobs related to each other
• Most cases I just need to use redis and a Background Job library like Sidekiq for Ruby or Celery for Python but I know there are cases when you should integrate the background jobs with queue messaging solutions like RabbitMQ or Kafka always depends on the problem to solve
• Also I always try to use tools for tracking, monitoring and logging in each job in order to collect all the possibly information about the processes. Datadog, Logstash, Kibana as so on

4.) How would you build a secure login for SPA and Mobile apps?

• Avoiding JWT Auth flow using OAuth 2.0 PKCE spec. There are open source projects like Ory-Hydra or cloud services like AWS Cognito that can help us with this.

5.) How Decouple Complex SQL queries

• Using CTE "WITH" Sub Queries would be a great idea.
• Create Store Procedure SQL Files to reuse repeated logic.
• Left Outer Join is very slow when you have to much records , is better use several queries, and JOIN. Like one query to get the specific IDs to use in the second query with JOIN and WHERE Clause instead get all records using LEFT OUTER JOIN

5.) Software good practices:

KISS, YAGNI, DRY, Law of Demeter, Twelve Factor