SQL 101 — the 11/24 presentation

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 SELECT on December 15th at 5pm. If you’re interested in learning SQL, I’d love to have you in the class!

By Shannon Lowder

Shannon Lowder is the Database Engineer you've been looking for! Look no further for expertise in: Business Analysis to gather the business requirements for the database; Database Architecting to design the logical design of the database; Database Development to actually build the objects needed by the business logic; finally, Database Administration to keep the database running in top form, and making sure there is a disaster recovery plan.

Leave a comment

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