New Functions of SQL 2008/2008R2 from a Programmer’s Perspective
Creating database applications working in Microsoft SQL Server 2008 environment should not be limited to writing T-SQL scripts with SSMS console. Just the opposite, a database application project may and should be executed along similar standards and using similar tools as projects of other types. This means, for instance, that the source code should be versioned and stored in the repository, all the changes should be tested prior to implementation, and given tasks be executed with technologies best suiting them. The course trains database programmers to use SQL Server 2008 to its full capacities, starting with choosing most suitable tools, writing and optimizing T-SQL code, programming the access to non-relational types of data and writing SQLCLR code, and finishing with using tried and tested design patterns. We have designed this course building on our many years’ experience, best programming practices and tried and tested methods of their application in database projects. All this has resulted in a course which will enable you to use fully the extended capabilities of SQL 2008 for database applications.
- Course level: 400
- Start date: as required
- Duration time: 2 days
Price: 2800 zł
- Open training
- On-site (costumer's premises)
- Customer’s computer
The course is aimed at database programmers, as well as all those who have experience in working with previous SQL Server versions, yet want to find out the new functions of SQL Server 2008. The participants will acquire the practical skills necessary to be able to independently create database applications using various editions of SQL Server 2008 and SQL Server 2008 R2.
The basic training is comprised of 7 modules. Just like all the other courses on our offer, it has been designed by our experts, therefore we can freely customize it to suit the individual needs of the participants. We would like to encourage you not only to choose modules which you find relevant for your needs, but also to feel free to contact us with your suggestions and questions you would like to hear answered throughout the course.
Our trainings are unique also because we limit the time set aside for laboratory type classes customarily conducted after the completion of each module, to the benefit of exercises done with the assistance of the trainer and demonstrations. We believe in this manner we can equip you with substantially more practical information and tips, and focus on dealing with the issues directly within your scope of interest. However, each day of the training is finished with a laboratory class of approximately 1hr, so that you can do self-practice and do exercises of your choice.