Video2Brain SQL Server 2008 R2 Programmierung

Tutorial & e-learning. March 5, 2011 by AllApps.

Video2Brain SQL Server 2008 R2 Programmierung
Video: .MP4 | 1024x576 | Audio: mp3/44100Hz
Genre: eLearning

Microsoft SQL Server 2008 R2 is a powerful database management system. Use this video tutorial you will learn quickly and accurately all the essential techniques for the successful programming of SQL Server. The experienced database developers and known author Klemens Konopasek brings you the benefits of server-side programming in more detail. Here his focus is on the one hand, the use of Transact SQL and the other on the Programming.. NET But programming related topics from a wide range of SQL Server features, it saves not enough. Finally, you also learn to integrate the generated code into your front-end programming.

From the contents:

The first, short chapter introduces the aim of the training video - before and the tools and elements you need to - the server-side database programming with SQL Server.

The Transact-SQL programming
The introduction is in Transact-SQL provides an overview of the components of such procedural language extension of the "Structured Query Language".

Stored Procedures
the program logic and data traffic to pass through the server to maintain the performance and high security, you will come to "Stored Procedures" indispensable.

Stored procedures in practice
This chapter goes deeper into the use of stored procedures. Among other things, provides information on topics such as security and user management, cursors and transactions, as well as debug tells the coach here.

Triggers are programs that start automatically when the triggering event occurs. Typically they are used to carry out further actions or implement complex data validation.

Custom Functions
User-defined functions are similar to some stored procedures are, however, directly in SQL statements can be integrated and able, to extend the useful functions in SQL.

Programming with. NET
The SQL Server can be programmed in Visual Studio with. NET language. In this chapter you will learn how to create. NET User-Defined Function. NET stored procedures. NET and triggers.

Mail from the application to a Friend
They learn how to set up database mail and see how the distribution of e-mail starts out from stored procedures.





Download File

Here you can download files online. Unlimited access to all sources file with one click direct download link!
  • Featured link
  • [5-03-2011]