Welcome to the forums Benny
Yes, you want all viewable content in the public_html folder.
If you tell us what you are trying to install maybe we could help.
You create databases in cPanel using the MySQL Databases function. You create a database by giving it a name. You also need to create a user in the same section and add that user to the database. You then access the database by modifying the config file for the software you are installing.
For DBHost you use 'localhost'
For DBName you use 'your-cpanel-name_database-name-you-create'
For DBUser you use 'your-cpanel-name_user-you-create'
For DBPassword you use 'the-password-you-created'
If you need help just ask and someone will be willing to offer you some guidance.