looking for "lesson plan" type tutorials for stored procedures 1

[bebblebrox]

Hi,

I need to teach some folks how to write stored procedures. They already have a concept of stored procedures and can write very simple procedures to select data.

I'm trying to find some examples that I can give them of more complex procedures, or some sort of tutorial/lesson plans that are structured and have increasing complexity.

Ideally I'd get a book such as SAMS or DUMMIES but there doesn't seem to be anything that is what I need. They all have copies of the Guru's Guide (Henderson) but it's too much informatino to begin on.

Any help would be much appreciated.

Thanks,

B

 

[SQLSister]

It doesn;t have lesson plans, but it is very comprehensive on how to write sps.

SQL Server 2000 Stored Procedure Programming by Sunderic and Woodhead published by Osborne

You could get it and create your own lesson plans from it.

My suggestion for possible lessons:
Basic SP using simple selects with input and output variables
Basic inserts, Updates, Deletes
Transaction processing (include doing an insert to a table with an identity field and using scope_identity() to get the identity and use it to insert into a related table)
Advanced selects including theory of joins and use of user-defined functions
Advanced inserts (those using selects and joins and case statements)
Advanced updates
Advanced deletes
Temp tables and table variables
Conditional processing and looping (no cursors! but short loops are sometimes necessary, do not teach until they can do an insert and update joining to another table and including a case statement.)
Debugging











Questions about posting. See faq183-874

 

[Mike555]

How about this:

Buy a copy of Camtasia Studio and record your own training videos directly from your PC. Then supplement those videos with assignments.

http://www.techsmith.com/products/studio/default.asp?lid=CamtasiaStudioHome

--
Mike

 

[bebblebrox]

bump

 

[TRACEYMARYLAND]

you can go to

http://www.stretchunlimited.com

examples there