This is an in depth course about using and programming with SQL Server. It assumes that the student has at least a rudimentary understanding of database concepts and architecture and gets right into the meat of the subject.
This course will get you up to speed on proper table design, creation, scripting and management as well as executing simple TSQL statements. The course will also provide real world examples of using Stored Procedures to effectively streamline such functions as INSERT, UPDATE and DELETE. The Stored Procedures are completely downloadable!!
Dave Merton is a software developer, troubleshooter, problem solver, software trainer, author and entrepreneur. He has been designing high end custom software for the last 20 years in direct mail, the pharmaceutical industry, oil companies and more.
Over the last eight years Dave has been developing and modifying custom high end software for dozens of testing laboratories throughout the U.S. This specific software discipline is referred to as "LIMS" (Laboratory Information Management System) and can be very intensive during development and deployment. For LIMS development Dave has been using VB.Net & C Sharp for the front end; web, VB.Net and MS Access for custom reporting; and SQL Server for the back end. During this time Dave has personally built over nine separate LIMS and LIMS (LAB) related apps.
Send Dave an email, he would love to hear from you.