Knowledge

This deals with an fully amortized loan with monthly prepay, default rate, constant severity and recovery lag. Please check the below excel, Cashflow

SQL Alchemy Other Notes Schema Database: This is the top-level container that holds the schemas. A database can contain multiple schemas. Schema: Within a database, a schema is a collection of objects.

SQL Alchemy Performance Considerations Query The example table is around 7 million observations, 50+ columns, including 160+ account names, and suppose we want to get the distinct account names. The data model we have defined is the ConsumerLoanStatic with table name consumer_loan_static.

Postgres SQL Setup Install Go to the PostgreSQL download page and choose the version compatible with your operating system. Follow the installation instructions specific to your OS. During installation, you will set up a password for the postgres user, which is the default superuser.

Working with existing database

Some features that are not so obvious