Wednesday night I had the opportunity to give my SQL 101, the basics presentation. I hadn’t given this one since just before leaving IntegrationPoint earlier this year. I spent a little time updating the presentation based on past evaluations and some changes in SQL. My new version includes some newer data types that have been released with versions of MS SQL 2008 and newer. While I do talk about the differences in multiple SQL Server vendors and versions, I’ve decided to move my discussions to the last full version released.
I of course explain that there will always be differences in the versions, but with the basics I’m trying to lay down, they should be able to lead themselves to learn the nuances of their environment. I’d prefer to teach the basics, and let the student master the topics him or herself.
I’ve embedded my presentation, in case you’re interested in catching up.
I’m also considering recording the presentation next time, and putting it out on youtube. I don’t know if there’s a desire for that sort of thing, but if there is, I’m always happy to help where I can. I’ve also been asked to provide more examples, to help illustrate some points. As I work through the next few presentations, I’ll add examples I use. If you want more, or need help understanding something in particular, please drop me a line.
Also, if you want to join in on our current sessions, either in person, or remotely, let me know and I’ll send you an invite. Currently we’re planning on covering