Creating Efficient Database Applications

Description

To create an efficient database application one needs the knowledge of T-SQL language, must build an appropriate logical and physical database model, be aware of mechanisms specific to SQL Server, be able to use given server functions properly, and comply with both general, as well as SQL Server-specific, design patterns. Testing, including performance and load tests, is a crucial stage of a database project. Not only should such tests simulate the expected load of a database, but, most importantly, their results should be the basis for introducing changes in the application project. The course prepares programmers to create efficient and scalable database applications working in Microsoft SQL Server environment. At the heart of this training there are verified standards and best programming practices, as well as methods of their application which we have successfully put to practical use in database projects ourselves. In effect, we have designed a training which will prevent you from making common mistakes which often result in coming up with applications whose proper performance is limited to the programmer’s computer, or ones whose performance decreases substantially as the number of users and/or the amount of data stored in the database grows.

Options

Course level:400

Start date:as required

Duration time:4 days

Price: 4100 zł

Open training

On-site (costumer's premises)

Customer’s computer

Class

The course has been designed for database programmers, testers and all those who would like to learn to diagnose and troubleshoot performance issues. Its participants will acquire the practical skills crucial for designing scalable databases, writing efficient queries and identifying and optimizing ineffective code modules. The training is available in 3 versions, for SQL Server 2005, 2008 and 2008 R2, 2012 and 2014 respectively.

Plan

The basic training is comprised of 12 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 during 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.