Genpact Cora Knowledge Center


SQL Scripts Best Practices

When working on a Cora SeQuence project implementation, you may need to write a lot of SQL queries. How can you be sure that you're writing effective and easy to read SQL scripts?

Watch this recorded session on SQL best practices to improve the quality and performance of your SQL code. 

Among others, the session covers the following topics:

  • Improving readability
  • Using operators
  • Common Table Expression (CTE)
  • Temporal tables
  • Transactions
  • JSON for stored procedures
  • SQL functions

Check out the deck used during the session.

Additional tip: Using the NOLOCK hint.