Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
Now that we've installed SQL Server let's go ahead and set up a test database to run some demos on. I've already staged some code for you in your Exercise Files folder. The one says create_database, just copy and paste all of that into Management Studio. You notice near the top it's going to try to create some files in C:\program files\Microsoft SQL Server, et cetera, et cetera. This is the default path for database and log files.
You're welcome to use a different path if you want to. What I have on the screen here just represents the default. So we'll go ahead and run that. Command completed successfully. And that gives us a new database called myDatabase. We do need to add one table to that database and populate it with just a little bit of data. We have script for that also. So again I'll copy and paste that over, and execute, and we see now we have an Authors table and we should have of a few records in that Authors table. It looks good.
I think we're ready to go.
There are currently no FAQs about SQL Server: Triggers, Stored Procedures, and Functions.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.