This package is four of our most popular SQL Server 2008/R2-based training courses. It features our Query Writing, T-SQL Programming, Integration Services, and Reporting Services courses with a huge 25% savings off the retail price. These comprehensive instructor-led SQL server 2008/R2 courses cover stored procedures, triggers, views, functions, writing reports, migrating data with SSIS, data flow, JOINS, subqueries, and much more! Visit http://www. learnitfirst.com to watch free sample videos and to learn more! Course 160 - Writing Queries for SQL Server (2005/2008/R2 Edition) - 209 videos over 42+ hoursCourse 161 - Transact-SQL Programming: SQL Server 2008/R2 - 235 videos over 51+ hoursCourse 158 - SQL Server 2008/R2 Integration Services - 210 videos over 42+ hours Course 162 - SQL... Less

228-04026

SQL Server 2008 R2 Standard delivers a complete data management and business intelligence platform for departments and small organizations to run their applications, helping enable effective database management with minimal IT resources. The following capabilities are new to Standard: Backup Compression to reduce data backups by up to 60% and help reduce time spent on backups* Can be managed instance for application and multi-server management capabilities High-scale complex event processing with SQL Server StreamInsight Built on the strong foundation of SQL Server 2008, SQL Server 2008 R2 delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence, improve IT and developer efficiency, and enable highly scalable and... Less

SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration. Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning... Less