What do you with you knew when you started in SQL?
I have a request. I’ve been given the opportunity to teach a course at our local community college on Database Design and Development and they’ve given me room to come up with my own curriculum. I want to create a balance of theory, practice, quizzes, and projects, but one of the things I feel like I have a great opportunity to do is to pass on some really great knowledge that I’ve picked up over the years.
Please comment below and give me examples of things you wish you knew sooner. I’d like to put as many tools in my students toolboxes before they get moving. Feel free to leave advice on teaching in a formal setting, keeping people’s attention and the most important thing….
How do I keep people’s attention if the class if FOUR HOURS LONG?!?!? Two hour lecture, two hour lab, once a week.
as an example – someone mentioned on twitter that one of the most important things they’ve taught their students is the practice of always writing out a select statement to get the right number of records, THEN changing the select to update/delete, etc so as to not inadvertently have an Oh $#!& moment. (
my apologies, I went back through my feed and couldn’t find the post posted by Brian Hogan)