Main Profile

At A Glance

Total Training for Microsoft SQL Server Development P3. Ch1. L4. Examining SQL Server with Code

You can get this entire course at http://www.totaltraining.com Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed! Highlights * Master the fundamentals of SQL Server technology. * Learn how to write better queries to return the exact data required. * Avoid slow iterative code by refactoring cursors into queries using user-defined functions and case expressions. * Develop stored procedures using T-SQL. * Understand how transactions affect performance, how to detect blocking transactions, and how to minimize the impact of locking and blocking. * Create triggers to build custom audit trails and enforce database rules. Chapter 1: T-SQL & STORED PROCEDURES (68 min) 1. Introducing T-SQL 2. Working with Variables 3. Controlling Procedural Flow 4. Examining SQL Server with Code 5. Using Temp Tables 6. Developing Dynamic SQL 7. Introducing Stored Procedures 8. Passing Parameters 9. Returning Parameters 10. Working with a Cursor 11. Handling Errors 12. Explaining the Raise Error 13. Controlling Transactions
Length: 03:18

Contact

Questions about Total Training for Microsoft SQL Server Development P3. Ch1. L4. Examining SQL Server with Code

Want more info about Total Training for Microsoft SQL Server Development P3. Ch1. L4. Examining SQL Server with Code? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question