How to store passwords in a database

Question

I'm developing an application that requires storing user passwords, and I want to ensure they are stored securely. What are the best practices for hashing and salting passwords before storing them in the database, and which hashing algorithms are most secure for this purpose?

If anyone could explain practical steps for securely handling passwords, especially in relational databases, it would be beneficial.