Are there templates for creating a page that retrieves data from a MySQL database?
My wish is that a calendar should be displayed with the option to select "Year, Month and date" and then subsequently view the data in the MySQL database that matches the search criteria
I don't know of any Templates for this. However this might help you get started.
You will need:
concerning Template it self, you should find your aim, going there
and so on...
but as said @Nancy OShea I'm afraid that none of those template comes with the core engine to interact in between database and queries... you will have to handle it by your own code
Generally Template handles structure, display, component... but not the core engine