Books, Computers & Internet, Certification Central, MS SQL Server

Page 1 of 13 | next

J.C. Mackin, Mike Hotek
MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server(TM) 2005 (Pro Certification)
by Microsoft Press (Hardcover)
Platform: No Operating System

Announcing an all-new Microsoft Certified IT Professional (MCITP) Training Kit designed to help maximize your performance on Exam 70-443, an exam for the new MCITP: Database Administrator certification. This kit packs the tools and features exam candidates want most—including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Focusing on SQL Server 2005, this official study guide covers topics such as designing a database server infrastructure, designing security for a database server solution, designing a physical database, designing a database solution for high availability, specifying data recovery technologies based on business requirements, and designing a strategy for data archiving. Ace your exam ...

Solid Quality Learning
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
by Microsoft Press (Hardcover)
Platform: No Operating System

Announcing an all-new MCTS Training Kit designed to help maximize your performance on Exam 70-431, a core exam for the new Microsoft IT Professional certifications. This kit packs the tools and features that exam candidates want most—including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Focusing on SQL Server 2005, this official study guide covers topics such as installing and configuring SQL Server, implementing database mirroring, managing database snapshots, working with XML and flat files, managing replication, backing up and restoring a database, monitoring and troubleshooting, and creating and implementing database objects. Ace your exam preparation and ramp up quickly on SQL Server 2005 database ...

Brian Larson
Delivering Business Intelligence with Microsoft SQL Server(TM) 2/E 2008
by McGraw-Hill Osborne Media (Paperback)

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.Understand the goals and benefits of business intelligenceDesign and create relational data marts and OLAP cubesManage Analysis Services databases using BI Development StudioCleanse data and populate data marts with SQL Server Integration ServicesTake advantage of the flexibility of the Unified Dimensional ModelManipulate and analyze data using MDX scripts and queries Use data mining to identify data patterns, correlations, and clusteringDevelop ...

Mike Hotek
MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance (PRO-Certification)
by Microsoft Press (Paperback)

Long Description Announcing an all-new SELF-PACED TRAINING KIT designed to help maximize your performance on 70-432, the required exam for the new Microsoft Certified Technology Specialist (MCTS) certification for SQL Server 2008 Implementation and Maintenance. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for the skills and expertise you can apply to the job. Focusing on implementing and maintaining a SQL Server 2008 database, this official study guide covers installing and configuring SQL Server 2008; managing SQL Server Agent jobs, alerts, and operators; ...

Erik Veerman, Teo Lachev, Dejan Sarka, Javier Loria, ...
MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005
by Microsoft Press (Paperback)

Announcing an all-new Self-Paced Training Kit designed to help maximize your performance on 70-445, the required exam for the new Microsoft Certified Technology Specialist (MCTS): SQL Server 2005 Business Intelligence certification. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most--including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Work at your own pace through the lessons and lab exercises. Focusing on the technology skills required to build business intelligence applications using SQL Server 2005, this official study guide covers topics ...

Dejan Sarka, Andy Leonard, Javier Loria, Adolfo Wiernik
MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
by Microsoft Press (Paperback)

Announcing an all-new Self-Paced Training Kit designed to help maximize your performance on 70-441, one of the required exams for the Microsoft Certified IT Professional (MCITP): Database Developer certification. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most--including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Work at your own pace through the lessons and lab exercises. Focusing on the job role of designing database solutions, this official study guide covers topics such as designing a logical and physical database, implementing ...

Darril Gibson
MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442)
by McGraw-Hill Osborne Media (Hardcover)

All-in-One is All You NeedGet complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.Get full details on all exam topics including how to:Install and configure SQL Server 2005Manage database designUse Transact-SQL and XMLWork with functions, triggers, and CLR integrationOptimize, monitor, and secure databasesCreate stored proceduresHandle disaster recoveryWork with Service Broker, Web Services, and MARSUse SQL Server Reporting Services and Notification ServicesManage locks, deadlocks, and cursorsTransfer data using Replication and SQL Server Integration ServicesThe CD-ROM ...

Sara Morgan, Tobias Thernstrom
MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
by Microsoft Press (Paperback)

Announcing an all-new Self-Paced Training Kit designed to help maximize your performance on 70-442, one of the required exams for the Microsoft Certified IT Professional (MCITP) Database Developer certification. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most--including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Work at your own pace through the lessons and lab exercises. Focusing on designing and implementing database solutions in a professional job role, this official study guide covers topics such as designing data access technologies, ...

Ashwani Nanda
Hands-On Microsoft SQL Server 2005 Integration Services
by McGraw-Hill Osborne Media (Paperback)

In-depth coverage of Microsoft�s powerful. new data integration tool. Learn to maximize the features of. SQL Server 2005 Integration Services from this essential. guide. Hands-On Microsoft SQL Server 2005 Integration. Services makes learning SSIS easy through the. use of extensive real-world exercises structured. around every component within the tool. You will. learn to collect corporate data from various sources. and transform that data for analysis, mining, and. reporting..

Dejan Sunderic
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
by McGraw-Hill Osborne Media (Paperback)

Create and Use Stored Procedures for Optimal Database PerformanceDevelop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages. You'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers. Essential Skills for Database ProfessionalsGroup and execute T-SQL statements using batches, scripts, and transactionsCreate user-defined, system, extended, temporary, global temporary, and remote stored procedures Develop and manage stored procedures using C# and Visual Basic .NETImplement database access using ...

Page 1 of 13 | next