The video tutorial demonstrates how to establish a connection between Node.js and MongoDB, write an asynchronous function to list databases, and iterate over the databases to print their names. The process involves creating a client, using the admin interface to get the list of databases, and logging each database name to the console. The tutorial also explains the significance of internal databases and how to focus on the relevant ones.

Explain the significance of the 'await' keyword in the function that lists databases.

What are the internal databases mentioned in the text, and why are they not a concern for the user?