Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005.
MacMall Part #: 7243408
Manufacturer Part #: 123621292
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!
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.
Presenter: Paul Nielsen
Paul Nielsen believes SQL is the romance language of data. As such he's a hands-on database developer, Microsoft SQL Server MVP, trainer, and author of many books including SQL Server 2005 Bible. As a data architect, he developed the concepts of Optimization Theory and Nordic - an O/R dbms for SQL Server, and writes the data architecture column for SQL Standard magazine. Paul supports the SQL community as the Director of Global Community Development with the PASS (Professional Association for SQL Server). You may have seen Paul speaking at a PASS Summit, SQL Open in Denmark, or SQL Teach in Montreal.
At MacMall, we understand the increasing demand for the best quality consumer products at huge discounted prices. That's why we are proud to offer the lowest prices on our extensive selection of best-selling products, and hard-to-find Mac and iPod products you crave. Get yourself the new iPad or the new Apple TV for your family. Looking to upgrade your MacBook? Or just want to find out the best suited iPod/iPhone accessories for your hot gadget? Keep your iPad up-to-date with function and technology with our line of top-brand iPad accessories. Compare brands. Equip your Apple products.
Plus, with our 24/7 customer service hotline, we're always just a phone call away no matter when you want to reach us. Get the MacMall Advantage. Don’t miss out on the best deals, special prices, rebate savings, exclusive bundles, and dedicated service you won’t find anywhere else!