I am 61, with an academic background in computer science, and many years in industry, mostly startups. I taught many years ago, and have resumed teaching, a database course: data modeling, relational algebra, SQL, application programming and architecture (e.g. 2-tier vs. 3-tier, web & mobile), database internals.
Student evaluations were pretty good for the most part, but quite a few students found the presentation a bit dry: I prepared every lecture as HTML ahead of time, made it available online, and presented it in class. A couple of times, I would do interactive things, e.g. tuning queries using EXPLAIN and playing with indexes. That proved pretty popular, but of course, it's difficult to capture this material, (I recorded a log of the session, but extemperaneous discussion was not captured).
Looking for advice on how to balance prepared material and more spontaneous things. Also, any other advice on how to make material of this sort (theory + practice) easier to absorb.
Observation 2: If you can prepare something detailed in writing in advance, it’s more efficient to just give it to the students in advance and let them read or view it on their own time.
Observation 3: Interactive discussions are the one thing that classrooms are optimized for.
Don’t stop the prep work. But if you can lead classroom discussions with safe cold calling, the students with get more out of it. Don’t worry about capturing the results. You could record it, but it’s the process of struggling and discussing that creates learning. Written artifacts are supplementary.
I commend you for both teaching, and for caring enough about your craft to ask for help. The Lifetime value your students can get is enormous.