The page activity type that allows HTML content to be stored in a course, is this information stored in the database and if so what table would this be located in. Would like to be able to update the page data programmatically via the db.
Yes, it is stored in the database, in the table mdl_page.