Database coding

Software engineering principles should be applied to database coding. This is important to keep the code clean and to speed up development cycles. This section will address several issues, such as naming conventions, documentation, and version control.

If you're familiar with these concepts, feel free to skip this section.

Database naming conventions

A naming convention describes how names are to be formulated. Naming conventions allow some information to be derived based on patterns, which helps developers to easily search for and predict the database's object names. Database naming conventions should be standardized across the organization. There's a lot of debate on how to name database objects...