SQL Server: Triggers, Stored Procedures, and Functions
- Type product
SQL Server: Triggers, Stored Procedures, and Functions
Beschrijving
Investigates several key database-programming concepts and how to combine them to create a high-quality database with Microsoft SQL Server.This course investigates several key database-programming concepts: triggers, stored procedures, functions, and .NET CLR (Common Language Runtime) assemblies. Author Martin Guidry shows how to combine these techniques and create a high-quality database using Microsoft SQL Server 2012. The course also covers real-world uses of the INSERT, UPDATE, and DELETE procedures, and how to build a basic web form to connect to your database. Topics include: Comparing triggers, functions, and stored procedures Installing and configuring SQL Server Creating a stored pr…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Investigates several key database-programming concepts and how to combine them to create a high-quality database with Microsoft SQL Server.This course investigates several key database-programming concepts: triggers, stored procedures, functions, and .NET CLR (Common Language Runtime) assemblies. Author Martin Guidry shows how to combine these techniques and create a high-quality database using Microsoft SQL Server 2012. The course also covers real-world uses of the INSERT, UPDATE, and DELETE procedures, and how to build a basic web form to connect to your database. Topics include: Comparing triggers, functions, and stored procedures Installing and configuring SQL Server Creating a stored procedure Returning data using data sets Creating user-defined functions Using "after," "instead," and nested triggers Modifying existing stored procedures Implementing logging on DELETE Choosing between T-SQL and CLR Executing a stored procedure Passing parameters
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.