rssHome » Networking and Server » Microsoft SQL Server » Microsoft SQL Server 2008 Microsoft Press

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 ...

eBook Details:

  • Paperback: 640 pages
  • Publisher: Microsoft Press; 1 Pap/Cdr edition (April 15, 2009)
  • Language: English
  • ISBN-10: 0735626367
  • ISBN-13: 978-0735626362

eBook Description:

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 Business Intelligence Development and Maintenance

Ace your preparation for the skills measured by MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 Business Intelligence Development and Maintenance and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

  • Create SSIS packages; troubleshoot data flow and control flow
  • Configure, debug, and deploy SSIS solutions
  • Develop SSAS cubes for OLAP and data mining services
  • Implement custom logic with MDX
  • Optimize storage design and query performance
  • Create SSRS reports; enable interactivity; write custom code
  • Manage the report environment
  • Configure security features for SSIS, SSAS, and SSRS

Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers including a customized learning path that describes how and where to focus your studies. Download eBook Free »

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 ...

eBook Details:

  • Hardcover: 652 pages
  • Publisher: Microsoft Press; Har/Cdr edition (May 20, 2009)
  • Language: English
  • ISBN-10: 0735626391
  • ISBN-13: 978-0735626393

eBook Description:

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 Database Development

  • Create and manage database objects
  • Query and modify data; implement subqueries and CTEs * Optimize table structures and data integrity
  • Create stored procedures, functions, and triggers
  • Manage transactions, error handling, and change tracking
  • Tune query performance
  • Implement database mail, full-text search, Service Broker, scripts
  • Work with XML and SQLCLR Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers including a customized learning path that describes how and where to focus your studies.

Ace your preparation for the skills measured by MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 Database Development and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Download eBook Free »

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 ...

eBook Details:

  • Hardcover: 900 pages
  • Publisher: Microsoft Press; 1 Har/Cdr edition (February 18, 2009)
  • Language: English
  • ISBN-10: 0735626057
  • ISBN-13: 978-0735626058

eBook Description:

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance

Ace your preparation for the skills measured by MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

  • Configure, manage, back up, and restore databases
  • Create a partitioned table, index, or indexed view
  • Configure services and components to manage your environment
  • Help prevent unauthorized access at each security infrastructure layer
  • Design and deploy high-availability solutions
  • Manage SQL Server Agent jobs, alerts, and operators
  • Identify service, concurrency, and job execution problems

Ace your preparation for the skills measured by MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Download eBook Free »