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)

4 thoughts on “What do you with you knew when you started in SQL?

  1. For Developers, the importance of truly understanding JOIN types and when to use them cannot be overstated. Indexes as well. I faked my way through both of those as a self-taught developer with Access, then SQL Server. That’s the T-SQL. For schema, proper design of tables (normalization, data types) is a must.

  2. Write queries for human readability first.

    If you can show the query to someone else who’s never seen your database before, and in a matter of seconds they can explain what your query is doing, then odds are the query optimizer will do a pretty good job of building an efficient query plan. Plus, when you come back to the query months or years later to fix it, you’ll be able to pick right up where you left off.

    If the other person takes a deep breath and asks for a pen and some scratch paper to figure out what you’re doing, odds are it’s not going to perform or be easily maintainable.

Leave a Reply

Your email address will not be published. Required fields are marked *