IT Certification 2014 by Wiley India

CERTIFICATION

2014

Catalog

C ATA L O G I C O N S CourseSmart Wiley Custom Select Wiley E-Text Instructor Supplements

TA B L E O F C O N T E N T S MICROSOFT OFFICIAL ACADEMIC COURSEWARE (MOAC) MTA............................................................ 8 Network+ ................................................. 10

WileyPlus Wiley Binder Version

IT Professional.......................................... 14 Windows Server 2008 ..................................14

O R D E R Y O U R E X A M I N AT I O N COPIES ONLINE Go to: www.wiley.com If you prefer, you can contact your local Wiley representative directly. Go to: www.wiley.com/college/rep Or write to: John Wiley & Sons, Inc. Attn: Michele Protocollo MS 5-02 111 River Street, Hoboken, NJ 07030-5774 Be sure to include the book title/author/ISBN, the course you teach, and your course enrollment. Or visit: www.coursesmart.com for e-textbook options. For all other inquiries please email us at: • In U.S.: custserv@wiley.com • In Canada: canada@wiley.com • In U.K., Europe, Middle East, and Africa: highereducation@wiley.co.uk • In Germany, Switzerland and Austria: college@wiley-vch.de • In Asia: enquiry@wiley.com.sg • In Australia: highered@johnwiley.com.au For High Schools please contact: Wiley High School Solutions Wileyhsap@wiley.com 1-855-827-4630 Get the latest news on new titles in your discipline: www.wiley.com/college/mailbag

www.wiley.com/go/certcatalog

Windows Server 2012 ...................................15 Other Servers ...............................................17 Windows Client ........................................... 20 Developer .................................................... 22 Microsoft Office Specialist....................... 23 SYBEX Cisco® ........................................................... 29 CompTIA® .................................................... 32 CWNP........................................................... 40 EC-Council ....................................................42 Guidance Software ......................................42 ISACA® ......................................................... 43 (ISC)2®........................................................... 43 LPI ................................................................. 44 Microsoft® .................................................... 45 Oracle® ..........................................................47 Java............................................................... 48 VMware, Inc. .................................................49 PMI® .............................................................. 50

WileyPLUS is a research-based online environment for effective teaching and learning. WileyPLUS builds students’ confidence because it takes the guesswork out of studying by providing students with a clear roadmap: • • •

what to do how to do it if they did it right

It offers interactive resources along with a complete digital textbook that help students learn more. With WileyPLUS, students take more initiative so you’ll have greater impact on their achievement in the classroom and beyond.

Now available for

For more information, visit www.wileyplus.com

FREE!

All of the Microsoft® developer tools, operating systems, and servers FREE!

It’s really FREE! Microsoft DreamSpark™ Premium provides a complete, inexpensive set of software titles for teaching and research purposes for students, faculty, and academic labs. Eligible Science, Technology, Engineering, and Math departments can receive download access for three years to the complete suite of Microsoft developer tools, servers, and platforms when they adopt a Wiley text. One powerful, complete suite of technology resources Software, resources, and support in the Microsoft DreamSpark™ Premium program include: • Microsoft® Windows • Microsoft® Windows Server • Microsoft® Visual Studio® Professional • Microsoft® Visio® Professional • Microsoft® Project Professional • Access to Microsoft DreamSpark™ Subscriber Downloads Web site for program administrators • Software distribution to students through the e-Academy License Management System (ELMS) Webstore • Development tools for Microsoft® Windows® • Server test platforms • I ncludes Microsoft® Windows ServerTM, SQL ServerTM, Exchange Server, Commerce Server, BizTalk® Server, Host Integration Server, Application Center, Systems Center, Management, ISA Server, and SharePoint® Server • Four professional technical support calls for program administrators • Monitored Microsoft DreamSpark™ newsgroups and access to Microsoft DreamSpark™ online resources

Three full years of invaluable benefits • Trust with a capital T. Microsoft DreamSpark™ Premium provides software for non-commercial use from a trusted source: Microsoft. • Simplified deployment and distribution. Translation: You won’t spend hours showing students how to download the software onto their PCs. • We do the heavy lifting. Microsoft DreamSpark™ Premium constantly provides the latest software updates and ensures that students have the versions they need—so you don’t have to. • Software you can keep. Once you download software, you can keep it forever—as long as it is used only for noncommercial purposes. • It’s a budget’s best friend. For the first three years, it is complimentary upon adoption of a Wiley textbook, then US $320 to renew in each following year. Your department gets all the latest developer tools, servers, and platforms from Microsoft.

Qualifications and requirements: • Program software may be used for instruction and research purposes only (supplied software is not licensed to support department or school infrastructure). • Membership is limited to science, technology, engineering or math departments within accredited educational institutions and is subject to eligibility check. • Free downloads are available only to those students taking credit courses within the department that is a member of the program.

Contact your Wiley rep for more details: MOAC@wiley.com

MOAC Labs Online Today’s Cutting-Edge Teaching Technology MOAC Labs Online addresses the most pervasive challenges facing today’s schools, instructors, and students. Rapid changes in software and hardware, authentic job training and experience, and anytime, anywhere access are the new reality of satisfying today’s student. MOAC Labs Online provides real solutions for these demands.

The Wiley/MOAC Labs Online Advantage 

MOAC Labs Online provides students with the ability to work on the actual software, rather than a simulation, simply by connecting through their Internet Explorer web browser.



MOAC Labs Online alleviates the need for local setup, configuration and most troubleshooting tasks.



MOAC Labs Online represents an opportunity to lower costs, eliminate the hassle of lab setup and support and improve student access and portability.



MOAC Labs Online can be purchased with both our print and digital MOAC IT Professional Textbook Series, or may be purchased separately.

Want to know more? Call your MOAC Sales Consultant at 888-764-7001 or visit www.wiley.com/college/microsoft

Microsoft Technology Associates (MTA) Technology Fundamentals Students beginning studies in technology need a strong foundation in the basics before moving on to advanced technology courses and certification programs. The Microsoft Technology Associate (MTA) is an innovative certification track that provides a pathway for future success in technology courses and careers. The MTA program curriculum helps instructors teach and validate fundamental technology concepts, thus providing students with a foundation for their careers as well as the confidence they need to succeed in advanced studies. MOAC supports the MTA certification as well as any course where foundational technology concepts areÂ taught.

DEVELOPER EX AMS Software Development Fundamentals (98-361) Windows Development Fundamentals (98-362) Web Development Fundamentals (98-363) Microsoft .NET Development Fundamentals (98-372) Mobile Development Fundamentals (98-373) Gaming Development Fundamentals (98-374) HTML5 Development Fundamentals (98-375)

D ATA B A S E E X A M S Database Administration Fundamentals (98-364)

IT PRO EX AMS Networking Fundamentals (98-366) Security Fundamentals (98-367) Windows Server Administration Fundamentals (98-365) Windows Operating System Fundamentals (98-349)

M TA : M I C R O S O F T T E C H N O L O G Y A S S O C I AT E

Exam 98-349

MTA Windows Operating System Fundamentals

Exam 98-361

Windows Operating System Fundamentals

TABLE OF CONTENTS Lesson 1: Introducing, Installing, and Upgrading Windows Lesson 2: Understanding Operating System Configurations Lesson 3: Understanding Native Applications, Tools, Mobility, and Remote Management and Assistance Lesson 4: Managing Applications, Services, Folders, and Libraries Lesson 5: Managing Devices Lesson 6: Understanding File and Print Sharing Lesson 7: Maintaining, Updating, and Protecting Windows 7 Lesson 8: Understanding Backup and Recovery Methods Appendix Credits Index

TABLE OF CONTENTS Lesson 1: Introduction to Programming Lesson 2: Introduction to Object Oriented Programming Lesson 3: Understanding General Software Development Lesson 4: Understanding Web Applications Lesson 5: Understanding Desktop Applications Lesson 6: Understanding Databases

Exam 98-362

Exam 98-363

MTA Windows Development Fundamentals

Web Development Fundamentals

2IÀFLDO $FDGHPLF &RXUVH

MTA Exam 98-349

TABLE OF CONTENTS Lesson 1: Introducing Windows Applications Lesson 2: Creating a Windows Application Project in Visual Studio Lesson 3: Creating a Windows Forms User Interface Lesson 4: Controlling Application Execution Lesson 5: Validating User Input Lesson 6: Integrating Data Lesson 7: Packaging and Deploying Windows Applications

www.wiley.com/go/certcatalog

TABLE OF CONTENTS Lesson 1: Creating a Web Page Lesson 2: Creating an Interactive Web Page Lesson 3: Understanding XML, The DataSet, The DataReader and WCF Lesson 4: Understanding Database Controls and Objects Lesson 5: Understanding Client-Side Scripting and Ajax Concepts Lesson 6: Debugging and Error Handling Lesson 7: Configuring Web Applications Lesson 8: Deploying Web Applications

M TA : M I C R O S O F T T E C H N O L O G Y A S S O C I AT E

Exam 98-364

TABLE OF CONTENTS Lesson 1: Understanding Core Database Objects Lesson 2: Creating Database Objects Lesson 3: Manipulating Data Lesson 4: Understanding Data Storage Lesson 5: Administrating a Database

Exam 98-365

Exam 98-366

MTA Windows Server Administration Fundamentals

TABLE OF CONTENTS Chapter 1: Server Overview Chapter 2: Managing Windows Servers (including virtualization) Chapter 3: Managing Storage Chapter 4: Monitoring and Troubleshooting Servers Chapter 5: Essential Naming and Directory Services Chapter 6: File and Print Services Chapter 7: Popular Windows Network Services and Application

TABLE OF CONTENTS Lesson 1: Understanding Local Area Networking Lesson 2: Defining Networks with the OSI Model Lesson 3: Understanding Wired and Wireless Networks Lesson 4: Understanding Internet Protocol Lesson 5: Implementing TCP/IP in the Command-Line Lesson 6: Working with Networking Services Lesson 7: Understanding Wide Area Networks Lesson 8: Defining Network Infrastructures and Network Security

Exam 98-367

Exam 98-372

6HFXULW\ )XQGDPHQWDOV

Microsoft .NET Fundamentals

TABLE OF CONTENTS Lesson 1: Understanding Security Layers Lesson 2: Authentication, Authorization, and Accounting Lesson 3: Understanding Security Policies Lesson 4: Understanding Network Security Lesson 5: Protecting the Server and Client

www.wiley.com/go/certcatalog

2IÀFLDO $FDGHPLF &RXUVH

TABLE OF CONTENTS Lesson 1: Understanding Object Oriented Programming Lesson 2: Understanding Data Types and Collections Lesson 3: Understanding Events and Exceptions Lesson 4: Understanding Code Compilation and Deployment Lesson 5: Understanding Input/Output (I/O) Classes Lesson 6: Understanding Security 2IÀFLDO $FDGHPLF &RXUVH IÀ

MTA Exam 98-372

M TA : M I C R O S O F T T E C H N O L O G Y A S S O C I AT E

Exam 98-373

Exam 98-374

Mobile Development Fundamentals

TABLE OF CONTENTS Lesson 1: Understanding Mobile Devices, Interactions, and Tools Lesson 2: Exploring Networked Data and Data Stores Lesson 3: Working in a Mobile App Development Environment Lesson 4: Exploring Mobile Device Networking Lesson 5: Understanding Silverlight and Mobile Code Lesson 6: Understanding Mobile App Development Concepts and Working with APIs Lesson 7: Using Mobile Device Controls and Creating User Interfaces Lesson 8: Testing, Debugging, and Deploying a Mobile App

2IÀFLDO $FDGHPLF &RXUVH

MTA Exam 98-373

Gaming Development Fundamentals

TABLE OF CONTENTS Chapter 1: Ideating and Conceptualizing a Game Chapter 2: Identifying and Managing Game Requirements Chapter 3: Creating the Game Output Design Chapter 4: Designing Specific Game Components Chapter 5: Developing the Game

2IÀFLDO $FDGHPLF &RXUVH

MTA Exam 98-374

Exam 98-375

TABLE OF CONTENTS Lesson 1: Managing the Application Life Cycle Lesson 2: Building the User Interface by Using HTML5: Text, Graphics, and Media Lesson 3: Building the User Interface by Using HTML5: Organization, Input, and Validation Lesson 4: Understanding CSS Essentials: Content Flow, Positioning, Styling Lesson 5: Understanding CSS Essentials: Layouts Lesson 6: Managing Text Flow by Using CSS Lesson 7: Managing the Graphical Interface by Using CSS Lesson 8: Understanding JavaScript and Coding Essentials Lesson 9: Creating Animations, Working with Graphics, and Accessing Data Lesson 10: JavaScript Coding for the Touch Interface, Device and Operating System Resources, and More

www.wiley.com/go/certcatalog

N E T W O R K+

Introduction to Networking with Network+

Introduction to Networking with Network +

TABLE OF CONTENTS Lesson 1: Introduction to Networking Lesson 2: The OSI and TCP/IP Models Lesson 3: Media Lesson 4: Network Addressing Lesson 5: Network Protocols Lesson 6: Networking Devices Lesson 7: LAN Technologies Lesson 8: WAN Technologies Lesson 9: Network Operating Systems Lesson 10: Network Security Lesson 11: Network Management Lesson 12: Network Troubleshooting

Timothy Pintello

M TA : M I C R O S O F T T E C H N O L O G Y A S S O C I AT E

Microsoft IT Professionalâ&#x20AC;&#x201D; Developer and Database For candidates who develop software or work in higher level IT

TECHNOLOGY PROFESSIONAL A range of MOAC IT Professional Courseware options are available for students at all skill levels, from the entry-level Microsoft Technology Associate (MTA) Certification to Technology Specialists and Solution Architects. If your students are new to technology and IT training, start by examining the MTA certification titles. If you teach primarily seasoned IT professionals, explore the Specialist and Professional Series titles. Both the Specialist and Professional Series are found in this section under the general category of IT Professional. For more information on MTA, see the separate section for Microsoft Technology Associate (MTA) titles.

SPECIALIST SERIES MOAC Technology Specialist Courseware supports certification programs designed to teach an in-depth knowledge of a key Microsoft product or technology and validate the studentâ&#x20AC;&#x2122;s ability to implement, build, troubleshoot, and debug a particular Microsoft technology, such as Windows Server, Microsoft .NET Framework, or Microsoft SQL Server. Earning an MCTS certification typically requires that students successfully pass one or two exams and possess at least one year of relevant experience and IT training.

PROFESSIONAL SERIES MOAC Professional Courseware supports the Microsoft Professional and Developer Certifications and are designed to help students learn a comprehensive set of job-related skills, such as project management, system design, operations management, planning developer skills.

IT PROFESSIONAL WINDOWS SERVER Exam 70-640

TABLE OF CONTENTS Overview of Active Directory Domain Services. Implementing Active Directory. Working with Active Directory Sites. Global Catalog and Flexible Single Master Operations (FSMO) Roles. Active Directory Administration. Security Planning and Administrative Delegation. Introduction to Group Policy. Configuring the User and Computer Environment Using Group Policy. Performing Software Installation with Group Policy. Planning a Group Policy Management and Implementation Strategy. Active Directory Maintenance, Troubleshooting, and Disaster Recovery. Configuring Name Resolution and Additional Services. Configuring Active Directory Certificate Services.

Exam 70-642

TABLE OF CONTENTS Lesson 1: Introduction to Networking Concepts Lesson 2: Installing Microsoft Windows Server 2008 Lesson 3: Configuring and Managing the DHCP Server Role Lesson 4: Configuring and Managing the DNS Server Role Lesson 5: Configuring Routing and Remote Access (RRAS) and Wireless Networking Lesson 6: Configuring File Services Lesson 7: Configuring Print Services Lesson 8: Maintaining and Updating Windows Server 2008 Lesson 9: Securing Data Transmission and Authentication Lesson 10: Maintaining Network Health Lesson 11: Maintaining Windows Server 2008 File Services

Exam 70-643

TABLE OF CONTENTS Chapter 1: Deploying an Application Server Chapter 2: Deploying a File Server Chapter 3: Using the File Services Role Chapter 4: Deploying Print and Fax Servers Chapter 5: Deploying IIS Services Chapter 6: Securing IIS Services Chapter 7: Deploying Web Applications Chapter 8: Using Terminal Services Chapter 9: Configuring Terminal Services Clients Chapter 10: Using the Terminal Services Gateway Chapter 11: Using Network Application Services Chapter 12: Using High Availability Technologies

www.wiley.com/go/certcatalog

IT PROFESSIONAL WINDOWS SERVER Exam 70-646 2IÀFLDO $FDGHPLF &RXUVH

Ser ver 2008 E ws n Softwa nter re I pr do io ns in luat id va

ise

TABLE OF CONTENTS Preface 1: Planning Server Deployments. Chapter 2: Planning Infrastructure Services. Chapter 3: Planning an Active Directory Deployment. Chapter 4: Planning Application Services. Chapter 5: Planning File and Print Services. Chapter 6: Planning Storage Solutions. Chapter 7: Planning for High Availability. Chapter 8: Planning Server and Network Security. Chapter 9: Securing Infrastructure Services. Chapter 10: Managing Servers. Chapter 11: Monitoring Servers. Chapter 12: Backing Up. Appendix A. Appendix B.

Exam 70-647

TABLE OF CONTENTS Lesson 1: Naming and Addressing Lesson 2: Designing an Active Directory Hierarchy Lesson 3: Building an Active Directory Topology Lesson 4: Planning for Migration and Interoperability Lesson 5: Planning a Branch Office Deployment Lesson 6: Designing a Public Key Infrastructure Lesson 7: Planning for Network Access Lesson 8: Selecting Data Management Solutions Lesson 9: Deploying Applications Lesson 10: Virtualizing Applications and Servers Lesson 11: Deploying Software Updates Lesson 12: Ensuring Business Continuity

Exam 70-410

TABLE OF CONTENTS Chapter 1: Installing Servers Chapter 2: Configuring Servers Chapter 3: Configuring Local Storage Chapter 4: Configuring File and Share Access Chapter 5: Configuring Print and Document Services Chapter 6: Configuring Servers for Remote Management Chapter 7: Create and Configure Virtual Machine Settings Chapter 8: Creating and Configuring Virtual Machine Storage Chapter 9: Creating Craig Zacker and Configuring Virtual Networks Chapter 10: Configuring IPv4 and IPv6 Addressing Chapter 11: Deploying and Configuring the DHCP Service Chapter 12: Deploying and Configuring the DNS Service Chapter 13: Installing Domain Controllers Chapter 14: Creating and Managing Active Directory Users and Computers Chapter 15: Creating and Managing Active Directory Groups and Organizational Units (OUs) Chapter 16: Creating Group Policy Objects Chapter 17: Configuring Security Policies Chapter 18: Configuring Application Restriction Policies Chapter 19: Configuring Windows Firewall

www.wiley.com/go/certcatalog

IT PROFESSIONAL WINDOWS SERVER Exam 70-411

TABLE OF CONTENTS Lesson 1: Deploying and Managing Server Images Lesson 2: Implementing Patch Management Lesson 3: Monitoring Servers Lesson 4: Configuring Distributed File System (DFS) Lesson 5: Configuring File Server Resource Manager Lesson 6: Configuring File Services and Disk Encryption Lesson 7: Configure Advanced Audit Policies Lesson 8: Configuring DNS Zones Lesson 9: Configuring DNS Records Lesson 10: Configuring VPN and Routing Lesson 11: Configuring Direct Access Lesson 12: Configuring a Network Policy Server Lesson 13: Configuring NPS Policies Lesson 14: Configuring Network Access Protection (NAP) Lesson 15: Configuring Server Authentication Lesson 16: Configuring Domain Controllers Lesson 17: Maintaining Active Directory Lesson 18: Configuring Account Polices Lesson 19: Configuring Group Policy Processing Lesson 20: Configuring Group Policy Settings Lesson 21: Managing Group Policy Objects Lesson 22: Configuring Group Policy Preferences

Exam 70-412

TABLE OF CONTENTS UNIT 1: Configuring and Manage High Availability Lesson 1: Configuring Network Load Balancing Lesson 2: Configuring Failover Clustering Lesson 3: Managing Failover Clustering Lesson 4: Managing VM Movement UNIT 2: CONFIGURING FILE AND STORAGE SOLUTIONS Lesson 5: Configuring Advanced File Services Lesson 6: Implementing Dynamic Access Control Lesson 7: Configuring and Optimizing Storage UNIT 3: IMPLEMENT BUSINESS CONTINUITY AND DISASTER RECOVERY Lesson 8: Configuring and Managing Backups Lesson 9: Recovering Servers Lesson 10: Configuring Site-Level Fault Tolerance UNIT 4: CONFIGURE NETWORK SERVICES Lesson 11: Implementing Advanced DHCP Solution Lesson 12: Implementing Advanced DNS Solution Lesson 13: Deploying and Managing IPAM UNIT 5: CONFIGURE THE ACTIVE DIRECTORY INFRASTRUCTURE Lesson 14: Configuring a Domain and Forest Lesson 15: Configuring Trusts Lesson 16: Configuring Sites Lesson 17: Managing Active Directory and SYSVOL Replication UNIT 6: CONFIGURE IDENTITY AND ACCESS SOLUTIONS Lesson 18: Implementing Active Directory Federation Services Lesson 19: Installing and Configuring Active Directory Certificate Services Lesson 20: Managing Certificates Lesson 21: Installing and Configuring Active Directory Rights Management Services

www.wiley.com/go/certcatalog

IT PROFESSIONAL OTHER SERVERS Exam 70-236

Exam 70-431

Microsoft Exchange Server 2007 Configuration with Lab Manual Set

Microsoft SQL Server 2005 Implementation and Maintenance Lab Manual

TABLE OF CONTENTS Chapter 1: Exchange Server 2007 Basics. Chapter 2: Working with Active Directory. Chapter 3: Deploying Exchange Server 2007. Chapter 4: Configuring a New Exchange Server. Chapter 5: Working with Recipient Objects. Chapter 6: Address Lists, Policies, and Bulk Management. Chapter 7: Working with Public Folders. Chapter 8: Configuring Email Protocols and Transport Rules. Chapter 9: Configuring Security. Chapter 10: Backing Up, Restoring, and Repairing Exchange. Chapter 11: Monitoring Exchange. Chapter 12: Providing for Mobile Access and Unified Messaging. Chapter 13: Providing for High Availability. Appendix A. Appendix B.

TABLE OF CONTENTS Lesson 1: Introduction. Lesson 2: Installing Microsoft SQL Server 2005. Lesson 3: Navigating SQL Server 2005. Lesson 4: Datatypes. Lesson 5: Databases. Lesson 6: Tables. Lesson 7: Performing Indexing and Full-Text Searching. Lesson 8: Views. Lesson 9: Constraints. Lesson 10: Stored Procedures. Lesson 11: Triggers. Lesson 12: Functions. Lesson 13: Transactions and Locks. Lesson 14: Moving Data. Lesson 15: XML Data. Lesson 16: Permissions. Lesson 17: Backing Up and Restoring. Lesson 18: Maintaining and Automating SQL Server. Lesson 19: Monitoring and Optimizing SQL Server. Lesson 20: High-Availability Methods. Lesson 21: Service Broker. Lesson 22: Endpoints. Lesson 23: Replication.

Exam 70-432 OfÀcial Academic Course

TABLE OF CONTENTS Chapter 1: Introduction. Chapter 2: Installing Microsoft SQL Server. Chapter 3: Navigating SQL Server. Chapter 4: Data Types. Chapter 5: Databases. Chapter 6: Tables. Chapter 7: Views. Chapter 8: Constraints. Chapter 9: Stored Procedures. Chapter 10: Functions. Chapter 11: Service Broker. Chapter 12: Data Integrity. Chapter 13: Permissions. Chapter 14: Logins, Roles, and Credentials. Chapter 15: Additional Security Tools. Chapter 16: Backing Up and Restoring Databases. Chapter 17: Endpoints. Chapter 18: Linking Servers. Chapter 19: Triggers. Chapter 20: Replication. Chapter 21: Performing Indexing and Full-Text Searching. Chapter 22: Transactions and Locks. Chapter 23: Moving Data. Chapter 24: Handling Specialty Data. Chapter 25: High-Availability Methods. Chapter 26: Maintaining and Automating SQL Server. Chapter 27: Monitoring and Optimizing SQL Server. Chapter 28: SQL Server Management Tools. Chapter 29: Troubleshooting Techniques. Appendix A. Appendix B Appendix C. Ser ver 2008 En te ws do ion Software In rpr in luat sid va

www.wiley.com/go/certcatalog

ise

IT PROFESSIONAL OTHER SERVERS Exam 70-443 & 70-450 2IĂ&#x20AC; FLDO $FDGHPLF &RXUVH

Microsoft SQL Server Database Design and Optimization with Lab Manual Set 978-0-470-18374-8, ÂŠ2010

TABLE OF CONTENTS Lesson 1: Designing the Hardware and Software Infrastructure Lesson 2: Designing Physical Storage Lesson 3: Designing a Consolidation Strategy Lesson 4: Analyzing and Designing Security Lesson 5: Designing Windows Server-Level Security Lesson 6: Designing SQL Server Service-Level and Database-Level Security Lesson 7: Designing SQL Server Object-Level SecurityÂ Lesson 8: Designing a Physical Database Lesson 9: Creating Database Conventions and Standards Lesson 10: Designing a SQL Server Solution for High Availability Lesson 11: Designing a Data Recovery Solution for a Database Lesson 12: Designing a Data-Archiving Solution

HU (QW 6HU Y - 6WHYHQ -RQHV Â&#x2021; 'DYLG : 7VFKDQ] Â&#x2021; 'DYH 2ZHQ Â&#x2021; :D\QH 5 %R\HU ZV H 6RIWZ Â&#x160;

(

Microsoft Office SharePoint 2010 Configuration with Lab Manual Set 978-0-470-48736-5, ÂŠ2011

TABLE OF CONTENTS Chapter 1: Introducing SharePoint 2010 Chapter 2: Installing SharePoint 2010 Chapter 3: Configuring SharePoint 2010 Chapter 4: Managing Web Applications Chapter 5: Deploying and Managing SharePoint Features and Solution Packages Chapter 6: Managing Accounts and User Roles Chapter 7: Configuring Service Applications Chapter 8: Configuring Indexes and Searches Chapter 9: Monitoring SharePoint Chapter 10: Managing Authentication Providers Chapter 11: Backing Up and Restoring the SharePoint Environment Chapter 12: Optimizing SharePoint Performance

www.wiley.com/go/certcatalog

Exam 70-667

DUH US ,QV U LG

LVH

GR LRQ LQ OXDW YD

IT PROFESSIONAL OTHER SERVERS Exam 70-461

TABLE OF CONTENTS Part 1: Preparing for the Course Lesson 1: Working with SQL Server 2012 Tools Lesson 2: Understanding Processing Sequences Lesson 3: Introducing T-SQL Query Syntax Lesson 4: Understanding the Role of the Query Optimizer Lesson 5: Creating Scripts Lesson 6: Understanding Data Types Part 2: Programming Database Object Queries Lesson 7: Writing Simple SELECT Statements Lesson 8: Querying Multiple Tables Lesson 9: Sorting and Filtering Data Lesson 10: Using Functions Lesson 11: Grouping and Aggregating Data Lesson 12: Using Subqueries Lesson 13: Using Derived Data Structures Lesson 14: Using Set Operators Lesson 15: Controlling with Windows Lesson 16: Pivoting and Grouping SETS Lesson 17: Creating and Working with Full-Text Data Lesson 18: Querying XML Data Part 3: Creating Database Objects Lesson 19: Generating Databases Lesson 20: Generating Tables Lesson 21: Creating Views Lesson 22: Generating Stored Procedures Lesson 23: Generating Functions Lesson 24: Generating Triggers Lesson 25: Programming Access to Database Objects Part 4: Managing System Efficiencies Lesson 26: Using Management Functions Lesson 27: Controlling Transactions and Locks

Exam 70-462

TABLE OF CONTENTS Part 1: Install and Configure Lesson 1: Plan Installation Lesson 2: Install SQL Server and Related Services Lesson 3: Implement a Migration Strategy Lesson 4: Configure Additional SQL Server Components Lesson 5: Manage SQL Server Agent Part 2: Maintain Instances and Databases Lesson 6: Manage and Configure Databases Lesson 7: Configure SQL Server Instances Lesson 8: Implement a SQL Server Clustered Instance Lesson 9: Manage SQL Server Instances Part 3: Optimize and Troubleshoot Lesson 10: Identify and Resolve Concurrency Problems Lesson 11: Collect and Analyze Troubleshooting Data Lesson 12: Audit SQL Server Instances Part 4: Manage Data Lesson 13: Configure and Maintain a Backup Strategy Lesson 14: Restore Databases Lesson 15: Implement and Maintain Indexes Lesson 16: Import and Export Data Part 5: Implement Security Lesson 17: Manage Logins and Server Roles Lesson 18: Manage Database Permissions Lesson 19: Manage Users and Database Roles Lesson 20: Troubleshoot Security Part 6: Implement High Availability Lesson 21: Implement AlwaysOn Lesson 22: Implement Database Mirroring Lesson 23: Implement Replication

www.wiley.com/go/certcatalog

IT PROFESSIONAL WINDOWS CLIENT Exam 70-620

Windows Vista Configuration with Lab Manual Set 978-0-470-87492-9, ÂŠ2008

TABLE OF CONTENTS Chapter 1: Introducing Windows Vista. Chapter 2: Installing Windows Vista. Chapter 3: Configuring System Settings. Chapter 4: Working with Disks. Chapter 5: Working with Users and Groups. Chapter 6: Working with Drivers and Printers. Chapter 7: Configuring Network Connectivity. Chapter 8: Configuring Windows Vista Security. Chapter 9: Configuring Windows Vista Applications. Chapter 10: Optimizing Windows Vista Performance. Chapter 11: Troubleshooting Windows Vista. Chapter 12: Working with Mobile Computers.

Exam 70-680 2IĂ&#x20AC; FLDO $FDGHPLF &RXUVH

Windows 7 Configuration with Lab Manual Set 978-0-470-89122-3, ÂŠ2011

&UDLJ =DFNHU

HU ( 6HU Y ZV Q 6RIWZD QWHU UH , SU GR LR QV LQ OXDW LG YD Â&#x160;

(

LVH

TABLE OF CONTENTS Lesson 1: Introducing Windows 7 Lesson 2: Installing Windows 7 Lesson 3: Deploying WindowsÂ 7 Lesson 4: Working with Disks and Devices Lesson 5: Connecting to a Network Lesson 6: Sharing Resources Lesson 7: Working with Applications Lesson 8: Managing and Monitoring Windows 7 Performance Lesson 9: Working with Workgroups Lesson 10: Securing Windows 7 Lesson 11: Administering Windows 7 Lesson 12: Using Mobile Computers

Exam 70-622

Supporting and Troubleshooting Applications on a Windows Vista Client for Enterprise Support Technicians with Lab Manual Set 978-0-470-87495-0, ÂŠ2008

TABLE OF CONTENTS Unit 1: Deploying Windows Vista. Lesson 1: Preparing for deployment. Lesson 2: Deploy using an image. Lesson 3: Perform post installation tasks. Lesson 4: Troubleshooting Deployment Issues. Unit 2: Managing Windows Vista Security. Lesson 5: Internet Explorer 7 Security. Lesson 6: Troubleshoot security policy issues. Lesson 7: Windows Vista Firewall, Defender, and Security Updates. Lesson 8: Troubleshoot Access, Authentication, and User Account Control Issues. Unit 3: Managing and Maintaining Systems that Run Windows Vista. Lesson 9: Troubleshoot Policy Settings. Lesson 10: Configuring the Task Scheduler and Event Forwarding. Lesson 11: Applying and Troubleshooting Updates and performance issues. Unit 4: Configuring and Troubleshooting Networking. Lesson 12: Network Protocols, DNS, and DHCP. Lesson 13: Troubleshoot Access Issues. Lesson 14: Troubleshooting Connectivity. Lesson 15: Network Security. 20

www.wiley.com/go/certcatalog

IT PROFESSIONAL WINDOWS CLIENT Exam 70-685 2IÀFLDO $FDGHPLF &RXUVH

Charles DeSassure

Ser ver 2008 En te ws do ion Software In rpr in luat sid va ®

Consulting Editor

ise

TABLE OF CONTENTS Lesson 1: Introduction to Windows Lesson 2: Resolving IP Connectivity Issues Lesson 3: Understanding Workgroups and Active Directory Lesson 4: TroubleshootingMobile Connectivity Problems Lesson 5: Troubleshooting Hardware Issues Lesson 6: Troubleshooting Startup Problems Lesson 7: Understanding and Troubleshooting File Access Lesson 8: Troubleshooting Printer Problems Lesson 9: Dealing with Software Issues Lesson 10: Dealing with Performance Issues Lesson 11: Troubleshooting Internet Explorer Lesson 12: Resolving Security Issues

Exam 70-687

TABLE OF CONTENTS Unit 1: Install and Upgrade to Windows 8. Chapter 1: Evaluate Hardware Readiness and Compatibility. Chapter 2: Install Windows 8. Chapter 3: Migrate and Configure User Data Unit 2: Configure Hardware and Applications. Chapter 4: Configure Devices and Device Drivers. Chapter 5: Install and Configure Desktop Applications. Chapter 6: Install and Configure Windows Store &UDLJ =DFNHU Applications. Chapter 7: Control Access to Local Hardware And Applications. Chapter 8: Configure Internet Explorer. Chapter 9: Configure Hyper-V. Unit 3: Configure Network Connectivity. Chapter 10: Configure IP Settings. Chapter 11: Configure Networking Settings. Chapter 12: Configure and Maintain Network Security. Chapter 13: Configure Remote Management. Unit 4: Configure Access to Resources. Chapter 14: Configure Shared Resources. Chapter 15: Configure File and Folder Access. Chapter 16: Configure Local Security Settings. Chapter 17: Configure Authentication and Authorization. Unit 5: Configure Remote Access and Mobility. Chapter 18: Configure Remote Connections. Chapter 19: Configure Mobility Options. Chapter 20: Configure Security for Mobile Devices. Unit 6: Monitor and Maintain Windows Clients. Chapter 21: Configure and Manage Updates. Chapter 22: Manage Local Storage. Chapter 23: Monitor System Performance. Unit 7: Configure Backup and Recovery Options. Chapter 24: Configure Backup. Chapter 25: Configure System Recovery Options. Chapter 26: Configure File Recovery Options.

Exam 70-688

TABLE OF CONTENTS 1 Designing an Operating System Installation Strategy 2 Designing an Application Strategy for Desktop Applications 3 Designing an Application Strategy for Cloud Applications 4 Designing a Solution for User Settings 5 Designing for Network Connectivity 6 Designing for Remote Access 7 Designing for Authentication and Authorization 8 Managing Data Storage 9 Managing Data Security 10 Managing Hardware and Printers 11 Managing Mobile Devices 12 Designing a Recovery Solution 13 Managing Endpoint Security 14 Managing Clients by Using Windows Intune 15 Managing Public Cloud Services 16 Managing and Maintaining Clients by Using MDOP www.wiley.com/go/certcatalog

IT PROFESSIONAL DEVELOPER Exam 70-536

Microsoft .NET Framework Application Development Foundation, Package

2IÀ FLDO $FDGHPLF &RXUVH

TABLE OF CONTENTS Chapter 1: Exploring .NET Fundamentals Chapter 2: Working with Collections, Dictionaries, and Generics Chapter 3: Working with File System I/O Chapter 4: Creating Graphic Applications Chapter 5: Serializing .NET Applications Chapter 6: Creating Application Domains and Windows Services Chapter 7: Using Threading and Reflection Chapter 8: Monitoring Application Performance Chapter 9: Securing Applications, Users, and Data in .NET Chapter 10: Extending Capabilities of .NET Applications Chapter 11: Programming .NET Interoperability Chapter 12: Setting Up .NET Applications

Exam 70-564

Designing and Developing ASP.NET Applications Using the Microsoft .NET Framework 3.5, Package

Exam 70-562 OfÀcial Academic Course

Microsoft .NET Framework 3.5, ASP. NET Application Development, Package

2IÀ FLDO $FDGHPLF &RXUVH

TABLE OF CONTENTS Chapter 1: Designing Web Applications with Suitable Controls Chapter 2: Designing Web Sites Chapter 3: Creating Web Applications and Web Sites Chapter 4: Designing State Management for Web Applications Chapter 5: Designing Reusable Controls Chapter 6: Leveraging Scripting with ASP.NET AJAX Chapter 7: Troubleshooting Web Applications Chapter 8: Accessing and Displaying Data Chapter 9: Sourcing Data from Different Sources Chapter 10: Enhancing Web Applications Chapter 11: Designing Security Measures Chapter 12: Protecting Web Applications Chapter 13: Configuring and Deploying Web Applications Appendix Getting Started with Visual Studio 2008

www.wiley.com/go/certcatalog

TABLE OF CONTENTS Chapter 1: Introducing ASP. NET 3.5 Chapter 2: Creating and Configuring Server Controls Chapter 3: Working with User Controls and Web Parts Chapter 4: Manipulating Data Using ADO.NET Chapter 5: Using XML and LINQ Chapter 6: Working with ASP.NET AJAX Chapter 7: Programming the Web Application Chapter 8: Implementing Globalization, Personalization, and Accessibility Chapter 9: Enhancing Security and Performance of the Web Application Chapter 10: Working with Services, Windows Communication Foundation, and ASP.NET Extensions Chapter 11: Working with Mobile Applications Chapter 12: Troubleshooting and Debugging Web Applications Chapter 13: Deploying and Publishing Web Applications Appendix A: Introducing Object-oriented Programming

MICROSOFT OFFICE SPECIALIST

Exam 77-881

Microsoft Word 2010

2IĂ&#x20AC; FLDO $FDGHPLF &RXUVH

978-0-470-90766-5, ÂŠ2012

Exam 77-883

2IĂ&#x20AC;FLDO $FDGHPLF &RXUVH

Microsoft PowerPoint 2010, with Microsoft Office 2010 Evaluation Software

TABLE OF CONTENTS Lesson 1: Getting Started with Word Lesson 2: Manipulating a Microsoft :RUG Document Lesson 3: Character Formatting Lesson 4: Paragraph Formatting Lesson 5: Managing Text Flow Lesson 6: Creating Table Lesson 7: Working with Themes, Quick Parts, Page Backgrounds, and Headers and Footers Lesson 8: Illustrations and Graphics Lesson 9: Proofreading Lesson 10: Applying Hyperlinks and References Lesson 11: Performing Mail Merges Lesson 12: Working with Outlines, Master and Subdocuments Lesson 13: Managing, Protecting and Sharing Documents Lesson 14: Advanced Options

TABLE OF CONTENTS Lesson 1: PowerPoint Essentials Lesson 2: Presentation Basics Lesson 3: Working with Text Lesson 4: Designing a Presentation Lesson 5: Adding Tables to Slides Lesson 6: Using Charts in a Presentation Lesson 7: Creating SmartArt Graphics Lesson 8: Adding Graphics to a Presentation Lesson 9: Using Animation and Multimedia Lesson 10: Securing and Sharing a Presentation Lesson 11: Delivering a Presentation

Exam 77-882

Exam 77-884

978-0-470-90852-5, ÂŠ2012 Microsoft PowerPoint ÂŽ

ÂŽ

026 ([DP

Microsoft Excel 2010 with Microsoft Office 2010 Evaluation Software

2IĂ&#x20AC; FLDO $FDGHPLF &RXUVH

978-0-470-90767-2, ÂŠ2012

Microsoft Outlook 2010 with Microsoft Office 2010 Evaluation Software

2IĂ&#x20AC; FLDO $FDGHPLF &RXUVH

978-0-470-90851-8, ÂŠ2012

Microsoft Excel 2010 ÂŽ

ÂŽ

MOS Exam 77-882

TABLE OF CONTENTS Lesson 1: Overview Lesson 2: Using Backstage Lesson 3:Â Working with Microsoft Excel 2010 Lesson 4: Creating and Formatting Cells and Ranges Lesson 5: Formatting Worksheets and Workbooks Lesson 6: Managing Worksheets Lesson 7: Working with Data Lesson 8: Using Basic Formulas and Functions Lesson 9: Creating Charts from Your Data Lesson 10: Adding Pictures and Shapes to a Worksheet Lesson 11: Excel Security and Advanced Features

www.wiley.com/go/certcatalog

ÂŽ

026 ([DP

Microsoft Outlook 2010 ÂŽ

ÂŽ

MOS Exam 77-884

TABLE OF CONTENTS Lesson 1: Getting to Know Outlook Lesson 2: Email Basics Lesson 3 Advanced Email Tools Lesson 4: Managing Mail with Folders & Clean up Tools Lesson 5: Processing Messages with Rules Lesson 6: Contact Basics Lesson 7: Advanced Contact Management Lesson 8: Calendar Basics Lesson 9: Managing Meetings Lesson 10: Advanced Calendar Management Lesson 11: Managing Tasks Lesson 12: Categories and Outlook Data Files Lesson 13: Managing Notes & Journal Entries

MICROSOFT OFFICE SPECIALIST

Exam 77-885

Microsoft Access 2010 with Microsoft Office 2010 Evaluation Software

2IÀ FLDO $FDGHPLF &RXUVH

Microsoft Office 2010 with Microsoft Office 2010 Evaluation Software

2IÀFLDO $FDGHPLF &RXUVH

Microsoft Access 2010 ®

TABLE OF CONTENTS Lesson 1: Database Essentials Lesson 2: Create Database Tables Lesson 3: Work with Tables/ Database Records Lesson 4: Modify Tables and Fields Lesson 5: Create Forms Lesson 6: Create Reports Lesson 7: Use Controls in Reports and Forms Lesson 8: Create and Modify Queries Lesson 9: Advanced Tables Lesson 10: Creating and Formatting Advanced Forms Lesson 11: Creating and Formatting Advanced Reports Lesson 12: Advanced Queries Lesson 13: Display and Share Data Lesson 14: Import and Export Data Lesson 15: Database Tools

MOS Exam 77-885

Microsoft 2IÀFH TABLE OF CONTENTS Part 1: Microsoft Windows 7. Part 2: Microsoft Word 2010. Part 3: Microsoft Excel 2010. Part 4: Microsoft PowerPoint 2010. Part 5: Microsoft Outlook 2010. Part 6: Microsoft Access 2010

Microsoft Project 2010

2IÀFLDO $FDGHPLF &RXUVH

TABLE OF CONTENTS Lesson 1: Project Basics Lesson 2: Establishing Resources Lesson 3: Resource and Task Assignments Lesson 4: Refining Your Project Schedule Lesson 5: Fine-Tuning Tasks Lesson 6: Fine-Tuning Resources Lesson 7: Sorting and Grouping and Filtering Project Information Lesson 8: Project Schedule Formatting Fundamentals Lesson 9: Customizing and Printing Project Information Lesson 10: Project Schedule Tracking - Fundamentals Lesson 11: Advanced Project Schedule Tracking Lesson 12: Integrating Microsoft Project with Other Programs Lesson 13: Project Schedule Optimization Lesson 14: Advanced Project Schedule Formatting Lesson 15: Managing Multiple Projects Lesson 16: Working With Resource Pools Lesson 17: Customizing Microsoft Project

www.wiley.com/go/certcatalog

Microsoft Project 2010 ®

MICROSOFT OFFICE SPECIALIST

Exam 77-418

Microsoft Word 2013 978-0-470-13307-1, ÂŠ2014

Exam 77-420

Microsoft 2IĂ&#x20AC;FLDO $FDGHPLF &RXUVH MOS

Microsoft Excel 2013 978-0-470-13308-8, ÂŠ2014

Microsoft 2IĂ&#x20AC;FLDO $FDGHPLF &RXUVH MOS

EXAM TABLE OF CONTENTS Chapter 1: Working with Microsoft Word 2013 Chapter 2: Basic Microsoft Editing Chapter 3: Character :RUG Formatting Chapter 4: Paragraph Formatting Chapter 5: Managing Text Flow Chapter 6: Creating Table Chapter 7: Working with Themes, Style Sets, Page Backgrounds, Quick Parts Chapter 8: Illustrations and Graphics Chapter 9: Proofreading Documents Chapter 10: Formatting a Research Paper with References Chapter 11: Performing Mail Merges Chapter 12: Maintaining Documents Chapter 13: Protecting and Sharing Documents Chapter 14: Advanced Options

(;$0 TABLE OF CONTENTS Lesson 1: Overview Lesson 2: Working with Microsoft Excel Microsoft Lesson 3: Using Office Backstage ([FHO Lesson 4: Using Basic Formulas Lesson 5: Using Functions Lesson 6: Formatting Cells and Ranges Lesson 7: Formatting Worksheets Lesson 8: Managing Worksheets Lesson 9: Working with Data and Macros Lesson 10: Using Advanced Formulas Lesson 11: Securing and Sharing Workbooks Lesson 12: Creating Charts Lesson 13: Adding Pictures and Shapes to a Worksheet

Exam 77-422

Exam 77-423

Microsoft PowerPoint 2013 978-0-470-13309-5, ÂŠ2014

Microsoft 2IĂ&#x20AC;FLDO $FDGHPLF &RXUVH MOS EXAM

TABLE OF CONTENTS Chapter 1: PowerPoint Essentials. Microsoft Chapter 2: Presentation Basics. 3RZHU3RLQW Chapter 3: Working with Text. Chapter 4: Designing a Presentation. Chapter 5: Adding Tables to Slides. Chapter 6: Using Charts in a Presentation. Chapter 7: Creating SmartArt Graphics. Chapter 8: Adding Graphics to a Presentation. Chapter 9: Using Animation and Multimedia. Chapter 10: Securing and Sharing a Presentation. Chapter 11: Delivering a Presentation.

www.wiley.com/go/certcatalog

Microsoft Outlook 2013 978-0-470-13311-8, ÂŠ2014

Microsoft 2IĂ&#x20AC;FLDO $FDGHPLF &RXUVH MOS

EXAM TABLE OF CONTENTS Lesson 1: Getting to Know Outlook Lesson 2: E-mail Microsoft Basics Lesson 3: Advanced 2XWORRN E-mail Tools Lesson 4: Managing E-mail Messages Lesson 5: Automating Message Processing Lesson 6: Working with Contacts Lesson 7: Advanced Contact Management Lesson 8: Calendar Basics Lesson 9: Managing Meetings Lesson 10: Advanced Calendar Management Lesson 11: Managing Tasks Lesson 12: Categories and Outlook Data Files Lesson 13: Managing Notes & Journal Entries

MICROSOFT OFFICE SPECIALIST

Exam 77-424

Microsoft 2IÀFLDO $FDGHPLF &RXUVH MOS EXAM

TABLE OF CONTENTS Lesson 1: Database Essentials Lesson 2: Create Database Tables Microsoft Lesson 3: Work with Tables and $FFHVV Database Records Lesson 4: Modify Tables and Fields Lesson 5: Create Forms Lesson 6: Create Reports Lesson 7: Create and Modify Queries Lesson 8: Use Controls in Reports and Forms Lesson 9: Advanced Tables Lesson 10: Advanced Forms Lesson 11: Advanced Reports Lesson 12: Advanced Queries Lesson 13: Display and Share Data Lesson 14: Import and Export Data Lesson 15: Database Tools

Microsoft 2IÀFLDO $FDGHPLF &RXUVH

TABLE OF CONTENTS Lesson 1: Project Basics. Lesson 2: Establishing Resources. Lesson 3: Resource and Task Microsoft Assignments. Lesson 4: Refining 3URMHFW Your Project Schedule. Lesson 5: Fine-Tuning Tasks. Lesson 6: Fine-Tuning Resources. Lesson 7: Project Information: Sorting, Grouping, and Filtering. Lesson 8: Project Schedule Formatting—Fundamentals. Lesson 9: Project Reporting. Lesson 10: Project Schedule Tracking – Fundamentals. Lesson 11: Advanced Project Schedule Tracking. Lesson 12: Integrating Microsoft Project with Other Programs. Lesson 13: Project Schedule Optimization. Lesson 14: Advanced Project Schedule Formatting. Lesson 15: Managing Multiple Projects. Lesson 16: Working with Resource Pools. Lesson 17: Customizing Microsoft Project.

Microsoft 2IÀFLDO $FDGHPLF &RXUVH

TABLE OF CONTENTS Unit 1: Microsoft Windows 8. Lesson 1: Getting Started with Windows 8. Lesson 2: Navigating and Customizing the Start Screen. Lesson 3: Working with Desktop Apps. Lesson 4: Using Files and Folders. Lesson 5: Customizing and Maintaining Windows 8. Unit 2: Internet Explorer and the 0LFURVRIW 2IÀFH Web. Lesson 1: Surfing the Web. Lesson 2: Sharing Device Settings and Content. Unit 3: Microsoft (GLWLRQ Word 2013. Lesson 1: Microsoft Word 2013 Jumpstart. Lesson 2: Getting Started with Word 2013. Lesson 3: Beginning Text and Layout Operations. Lesson 4: Structuring Complex Documents. Lesson 5: Working with Tables. Lesson 6: Beyond Word: Linking and Collaborating. Lesson 7: Creating Mail Merges. Lesson 8: Blogging in Word. Unit 4: Microsoft Excel 2013. Lesson 1: Getting Started with Excel 2013. Lesson 2: Creating a Worksheet in Excel 2013. Lesson 3: Formatting a Worksheet. Lesson 4: Using Formulas in Excel 2013. Lesson 5: Working with Charts. Lesson 6: Working with Data. Lesson 7: Working with Excel 2013 Templates. Lesson 8: Advanced Data Analysis. Unit 5: Microsoft PowerPoint 2013. Lesson 1: Microsoft PowerPoint 2013 Jumpstart. Lesson 2: Getting Started with PowerPoint 2013. Lesson 3: Designing a Presentation. Lesson 4: Using Tables, Charts, and SmartArt. Lesson 5: Adding Graphics and Multimedia to Your Presentation. Lesson 6: Delivering Your Presentation. Unit 6: Microsoft Outlook 2013. Lesson 1: Introduction to Microsoft Outlook 2013. Lesson 2: Getting Started with Outlook 2013. Unit 7: Microsoft OneNote 2013. Lesson 1: Microsoft OneNote 2013 Jumpstart. Lesson 2: Getting Started with OneNote 2013. Unit 8: Microsoft Access 2013. Lesson 1: Introduction to Microsoft Access. Lesson 2: Getting Started with Microsoft Access 2013. Unit 9: Microsoft Publisher 2013. Lesson 1: Microsoft Publisher 2013. Lesson 2: Microsoft Publisher 2013 Jumpstart.

www.wiley.com/go/certcatalog

LOWER PRICE, BETTER EXPERIENCE.

E-Textbooks are complete digital versions of the text that help students study more efﬁciently as they: • • • •

Access content online and ofﬂine on practically any device Search across the entire book content Take notes and highlight Copy and paste or print key sections

Wiley E-Text: Powered by VitalSource as well as CourseSmart (available for all titles) Ask your sales representative about other available formats.

A three-hole punched, loose-leaf format allows students to: • • •

Carry only the content they need Insert class notes and hand-outs Keep all your materials in one place

This group’s services allow you to: • • • OR… •

Adapt existing Wiley content and combine texts Incorporate and publish your own materials Collaborate with our team to ensure your satisfaction Start building your own materials today at customselect.wiley.com

Talk to your Wiley representative about substantial student savings and the right solution for you and your students.

www.wiley.com/college/wileyﬂex

MICROSOFT OFFICE SPECIALIST

Sybex Study Guides FOR INSTRUCTORS Instructor resources are provided for all Sybex Study Guides to enable you to be “ready to train” with ease and simplicity. The electronic instructor resources enable you to focus on delivering the learning objectives to your students without investing time, money, and energy in course development. Instructor resources consist of: • Annotated sullabus using the Sybex Study Guides • PowerPoint presentations organized by chapter • Question banks • Class exercises and activities

FOR STUDENTS Sybex Study Guides are complete textbooks that provide coverage of official exam objectives. Written by IT professionals, these books help develop critical skills alongside real world insights to provide knowledge and understanding of the technology. Sybex Study Guides include: • Assessment test to gauge level of knowledge • In-depth coverage of all certification exam objectives • Opening chapter objectives • Helpful “Notes, Tips, and Warnings” throughout each chapter • End-of-chapter overview and checklist • End-of-chapter quizzes • Electronic flashcards to reinforce knowledge and increase confidence • Hundreds of Practice Questions

ADDITIONAL SYBEX SERIES A N D M AT E R I A L S ESSENTIALS—These striking, full-color books cover technology fundamentals and prepare your students for certification exams. With full coverage of Exam topics, chapter review questions, chapter-opening learning objectives, and full-color screenshots and illustrations, they help aspiring IT professionals maximize skill acquisition and knowledge retention. REVIEW GUIDES—These streamlined books can be used in conjunction with Sybex Study Guides to provide additional review for students. Packed with focused coverage of exam objectives, these books are the perfect supplement to any certification study tool. LAB MANUALS—The Lab Manual books are designed to help students put their certification to work. The books feature actual tasks from the field, with step-by-step exercises that teach the skills necessary to complete those tasks. Based on the exam objectives from leading technology certifications, these books are also ideal as lab manuals for certification preparation. CERTIFICATION KITS—These practical kits offer several Sybex books in value-priced collections, designed to help your students prepare in depth for the leading certifications.

CISCO® C C E N T: C I S C O C E R T I F I E D E N T R Y N E T W O R K I N G T E C H N I C I A N

CCENT Study Guide (ICND1 Exam 100-101)

CCENT Virtual Lab 2.0 (ICND1 Exam 100-101)

William Tedder TABLE OF CONTENTS Chapter 1: Internetworking Chapter 2: Ethernet Networking and Data Encapsulation Chapter 3: Introduction to TCP/IP Chapter 4: Easy Subnetting Chapter 5: VLSMs, Summarization, and Troubleshooting TCP/IP Chapter 6: Cisco’s Internetworking Operating System (IOS) Chapter 7: Managing a Cisco Internetwork Chapter 8: IP Routing Chapter 9: Open Shortest Path First Chapter 10: Layer 2 Switching Chapter 11: VLANs and Inter-VLAN Routing Chapter 12: Security Chapter 13: Network Address Translation (NAT) Chapter 14: Internet Protocol Version 6 (IPv6)

TABLE OF CONTENTS Network Environment. Cisco IOS. IP Routing. Managing a Cisco Internetwork. Configuring the Catalyst Switch. NAT. Switch Security. Individual Labs.

C C N A : C I S C O C E R T I F I E D N E T W O R K A S S O C I AT E

CCNA Routing and Switching Study Guide (Exams 100-101, 200-101, and 200-120)

Todd Lammle

CCNA ®

ICND2

STUDY GUIDE EXAM 200-101

Includes Real-World Scenarios, Hands-On Exercises, and Access to Exam Prep Software Featuring:

TABLE OF CONTENTS Chapter 1: Internetworking. Chapter 2: Review of Ethernet Networking and Data Not available in print Encapsulation. Chapter 3: Introduction to TCP/IP. Chapter 4: Easy Subnetting. Chapter 5: Variable Length Subnet Masks (VLSMs), Summarization, and Troubleshooting TCP/IP. Chapter 6: Ciscos Internetworking Operating System (IOS). Chapter 7: Managing a Cisco Internetwork. Chapter 8: IP Routing. Chapter 9: Enhanced IGRP (EIGRP) and Open Shortest Path First (OSPF). Chapter 10: Layer 2 Switching and Spanning Tree Protocol (STP). Chapter 11: Virtual LANs (VLANs). Chapter 12: Security. Chapter 13: Network Address Translation (NAT). Chapter 14: Ciscos Wireless Technologies. Chapter 15: Internet Protocol Version 6 (IPv6). Chapter 16: Wide Area Networks.

Todd Lammle

CCNA ®

Routing and Switching

STUDY GUIDE EXAM 100-101 EXAM 200-101 EXAM 200-120

+ Free Network Simulator

+ Practice Test Environment

+ Hundreds of Sample Questions + Author Videos

www.wiley.com/go/certcatalog

TABLE OF CONTENTS Chapter 1: Describe How a Network Works. Chapter 2: Configure, Verify, and Troubleshoot a Switch with VLANs and Interswitch Communications. Chapter 3: Implement an IP Addressing Scheme and IP Services to Meet Network Requirements in a Medium-Sized Enterprise Branch Office Network. Chapter 4: Configure, Verify, and Troubleshoot Basic Router Operation and Routing on Cisco Devices. Chapter 5: Explain and Select the Appropriate Administrative Tasks Required for a WLAN. Chapter 6: Identify Security Threats to a Network and Describe General Methods to Mitigate Those Threats. Chapter 7: Implement, Verify, and Troubleshoot NAT and ACLs in a Medium-Sized Enterprise Branch Office Network. Chapter 8: Implement and Verify WAN Links. Review Questions.

CISCO® C C N A ® : C I S C O C E R T I F I E D N E T W O R K A S S O C I AT E

Todd Lammle and William Tedder

CCNA ®

DELUXE STUDY GUIDE EXAM 100-101 EXAM 200-101 EXAM 200-120 Includes Real-World Scenarios, Hands-On Exercises, and bonus materials including: + Access to an online testing environment with hundreds of sample questions and flashcards

TODD LAMMLE TROY MC MI LLAN · Concise, targeted review of all exam objectives · The perfect companion to any CCNA Routing and Switching exam study tool · Access to online study tools including hundreds of practice questions, flashcards, and a glossary of key terms.

CCNA ®

Routing and Switching REVIEW GUIDE

+ Exclusive virtual lab network simulator + Author videos + Complete eBook in multiple file formats

EXAM 100-101 EXAM 200-101 EXAM 200-120

TABLE OF CONTENTS Chapter 1: Internetworking. Chapter 2: Review of Ethernet Networking and Data Encapsulation. Chapter 3: Introduction to TCP/IP. Chapter 4: Easy Subnetting. Chapter 5: Variable Length Subnet Masks (VLSMs), Summarization, and Troubleshooting TCP/IP. Chapter 6: Cisco’s Internetworking Operating System (IOS). Chapter 7: Managing a Cisco Internetwork. Chapter 8: IP Routing. Chapter 9: Enhanced IGRP (EIGRP) and Open Shortest Path First (OSPF). Chapter 10: Layer 2 Switching and Spanning Tree Protocol (STP). Chapter 11: Virtual LANs (VLANs). Chapter 12: Security. Chapter 13: Network Address Translation (NAT). Chapter 14: Cisco’s Wireless Technologies. Chapter 15: Internet Protocol Version 6 (IPv6). Chapter 16: Wide Area Networks. Appendix A: About the Companion CD.

TABLE OF CONTENTS Lab 1: Network Environment. Lab 4: Cisco IOS. Lab 5: IP Routing. Lab 6: Managing a Cisco Internetwork. Lab 7: EIGRP and OSPF. Lab 8: Configuring the Catalyst Switch. Lab 9: Virtual LANs (VLANs). Lab 10: Managing Traffic with Access Lists. Lab 11: Network Address Translation/ Port Address Translation (NAT/PAT). Lab 14: Cisco Wide Area Networks (WAN). Lab 15: VLSM with Summarization. Lab 16: Net Assessment. Lab 17: Create Your Own Custom Lab. Practice Scenarios.

Three expert Sybex CCNA study titles in one value-priced kit • CCNA Routing and Switching Study Guide, 7th Edition, 978-1-118-74961-6 • CCNA Routing and Switching Review Guide, 978-1-118-78981-0 • CCNA Virtual Lab, Titanium Edition, 4.0, 978-1-118-78967-4

www.wiley.com/go/certcatalog

CISCO® C C N A ® : C I S C O C E R T I F I E D N E T W O R K A S S O C I AT E

CCNA Data Center Introducing Cisco Data Center Networking Study Guide (Exam 640-911)

CCNA Data Center: Introducing Cisco Data Center Technologies Study Guide (Exam 640-916)

Todd Lammle and John Swartz

Todd Lammie and John Swartz

978-1-118-66109-3, ®2006

Todd Lammle and John Swartz

CCNA ®

Introducing Cisco Data Center Technologies

STUDY GUIDE

EXAM 640-916

Includes Real-World Scenarios, Hands-On Labs, and Access to Exam Prep Software Featuring: + Free Nexus Simulator + Practice Test Environment + Hundreds of Sample Questions + Electronic Flashcards

TABLE OF CONTENTS Chapter 1: Understanding Basic Networking Chapter 2: Internetworking Chapter 3: Ethernet Technologies Chapter 4: TCP/IP DoD model Chapter 5: IP Addressing Chapter 6: Easy Subnetting Chapter 7: Introduction to Nexus Chapter 8: Configuring Nexus Chapter 9: IP Routing Chapter 10: Routing Protocols Chapter 11: Layer 2 Switching Technologies Chapter 12: Redundant Switched Technologies Chapter 13: Security Appendix A Appendix B Appendix C

C VO ICE

Covers All Exam Objectives Includes Real-World Scenarios, Written and Hands-On Labs, and Leading-Edge Exam Prep Software Featuring:

• Custom Test Engine • Hundreds of Sample Questions • Electronic Flashcards

CVOICE 8.0 Implementing Cisco Uniﬁed Communications Voice over IP and QoS v8.0

TABLE OF CONTENTS STUDY GUIDE Andrew Froehlich Chapter 1: An Introduction to Traditional Telephony and Cisco Unified Communications. Chapter 2: Understanding Analog and Digital Voice. Chapter 3: VoIP Operation and Protocols. Chapter 4: The VoIP Path-Selection Process. Chapter 5: VoIP Design Options. Chapter 6: Configuring Voice Gateway Ports and DSPs. Chapter 7: Configuring Voice Gateway Signaling Protocols. Chapter 8: Configuring and Managing CUCM Express. Chapter 9: Advanced Voice Gateway Features. Chapter 10: Configuring and Managing CUBE and H.323 Gateways. Chapter 11: Introduction to Quality of Service. Chapter 12: Configuring Quality of Service. Exam 642-437

SERIOUS SKILLS.

www.wiley.com/go/certcatalog

COMP TIA® S T R ATA

CompTIA Strata Study Guide Authorized Courseware (Exams FC0-U41, FC0-U11, and FC0-U21)

Covers All Exam Objectives Includes Hands-on Exercises, plus Leading-Edge Exam Prep Software Featuring:

• Custom Test Engine • Hundreds of Sample Questions

Andrew Smith and Faithe Wempen

• Practice Tests for Each Exam

TABLE OF CONTENTS Chapter 1: Processing and Memory Chapter 2: Input and Storage Devices Chapter 3: Peripherals and Networking Chapter 4: Setting Up a Computer Chapter 5: Maintaining a Computer Chapter 6: Installing and Configuring Software Chapter 7: Updating and Upgrading Hardware Chapter 8: Troubleshooting Operational Problems Chapter 9: Security and Access Control Chapter 20: Safe, Legal, and Green Computer Usage

APPROVE

TENT

• Electronic Flashcards

QUALITY C

STUDY GUIDE Exam FC0-U41 (US/Global) Exam FC0-U11 (UK only) Exam FC0-U21 (UK only)

Andrew Smith Faithe Wempen

A+

TABLE OF CONTENTS Part I: 220-801. Chapter 1: Personal Computer System Components. Chapter 2: Storage Devices, Power Supplies, and Adapters. Chapter 3: Understanding Display Devices. Chapter 4: Understanding Laptops and Portable Devices. Chapter 5: Installing and Configuring Printers. Chapter 6 :Operating System Features and Interfaces. Chapter 7: Installing and Configuring Operating Systems. Chapter 8: Troubleshooting Theory and Preventive Maintenance. Chapter 9: Troubleshooting Operating Systems, Hardware, Printers, and Laptops. Chapter 10: Understanding Networking. Chapter 11: Understanding Network Security Fundamentals. Part II 220-802. Chapter 12: Understanding Operational Procedures. Chapter 13: Installing, Maintaining, and Troubleshooting Hardware. Chapter 14: Installing, Configuring, and Troubleshooting Laptops. Chapter 15: Resolving Printer Problems. Chapter 16: Operating System Structures and Commands. Chapter 17: Operating System Utilities and Troubleshooting Issues. Chapter 18: Installing and Troubleshooting Networks. Chapter 19: System Security. Appendix A: Answers to Review Questions. Appendix B: Answer to Performance-Based Questions.

www.wiley.com/go/certcatalog

TABLE OF CONTENTS Part I: 220-801. Chapter 1: Personal Computer System Components. Chapter 2: Storage Devices, Power Supplies, and Adapters. Chapter 3: Understanding Display Devices. Chapter 4: Understanding Laptops and Portable Devices. Chapter 5: Installing and Configuring Printers. Chapter 6: Operating System Features and Interfaces. Chapter 7: Installing and Configuring Operating Systems. Chapter 8: Troubleshooting Theory and Preventive Maintenance. Chapter 9: Troubleshooting Operating Systems, Hardware, Printers, and Laptops. Chapter 10: Understanding Networking. Chapter 11: Understanding Network Security Fundamentals. Part II: 220-802. Chapter 12: Understanding Operational Procedures. Chapter 13: Installing, Maintaining, and Troubleshooting Hardware. Chapter 14: Installing, Configuring, and Troubleshooting Laptops. Chapter 15: Resolving Printer Problems. Chapter 16: Operating System Structures and Commands. Chapter 17: Operating System Utilities and Troubleshooting Issues. Chapter 18: Installing and Troubleshooting Networks. Chapter 19: System Security. Appendix A: Answers to Review Questions. Appendix B: Answer to Performance-Based Questions. Appendix C: About the Companion CD.

COMP TIA® A+

TABLE OF CONTENTS Part I: 220-801. Chapter 1: Hardware. Chapter 2: Troubleshooting, Repair, and Maintenance. Chapter 3: Operating Systems and Software. Chapter 4: Networking. Chapter 5: Security. Chapter 6:Operational Procedure. Part II: 220-802. Chapter 7: Hardware. Chapter 8: Operating Systems. Chapter 9: Networking. Chapter 10: Security.

CompTIA A+ Complete Lab Manual James Pyles

Save 10% on Exam Vouchers Coupon Inside!

James Pyles

TABLE OF CONTENTS Phase 1: Installing Hardware and Software. Phase 2: Maintaining and Documenting Computer Systems. Phase 3: Networking Computer Systems. Phase 4: Troubleshooting and Restoring.

COMPLETE LAB MANUAL

Step-by-step exercises teach you hands-on skills Real-world scenarios put those skills in perspective

EXAM 220-801 EXAM 220-802

SERIOUS SKILLS.

Two expert Sybex study titles in one value-priced kit • CompTIA A+ Study Complete Study Guide for exams 220-801 and 220-802, 978-1-118-32405-9 • CompTIA A+ eTestPrep, 978-1-118-38841-9

www.wiley.com/go/certcatalog

COMP TIA® A+

CompTIA A+ Complete Certification Kit Recommended Courseware, 2nd Edition (Exams 220-801 and 220-802)

Save $10 U.S. off suggested retail price of books purchased individually!

Three expert Sybex Comp TIA A+ study titles in one value-priced kit

CERTIFICATION KIT SECOND EDITION

EXAMS 220-801 AND 220-802

• CompTIA A+ Complete Study Guide, 2nd Edition, 978-1-118-32405-9 • CompTIA A+ Lab Manual, 978-1-118-32407-3 • CompTIA A+ Complete Review Guide, 2nd Edition, 978-1-118-32408-0

L I N U X+

TABLE OF CONTENTS Part I: The CompTIA Linux+ LX0-101 Exam. Chapter 1: Exploring Linux Command Line Tools. Chapter 2: Managing Software. Chapter 3: Configuring Hardware. Chapter 4: Managing Files. Chapter 5: Booting Linux and Editing Files. Part II: The CompTIA Linux+ LX0-102 Exam. Chapter 6: Configuring the X Window System, Localization, and Printing. Chapter 7: Administering the System. Chapter 8: Configuring Basic Networking. Chapter 9: Writing Scripts, Configuring E-mail, and Using Databases. Chapter 10: Securing Your System.

www.wiley.com/go/certcatalog

COMP TIA® N E T W O R K+

Todd Lammle

Save 10%

TENT

on Exam Vouchers Coupon Inside!

Todd Lammle

APPROVE

CompTIA Network+ Study Guide Authorized Courseware (Exam N10-005)

QUALITY C

STUDY GUIDE Second Edition

EXAM N10-005

Includes Real-World Scenarios, Hands-On Exercises, and Access to Exam Prep Software Featuring:

CompTIA Network+ Deluxe Study Guide Recommended Courseware, 2nd Edition (Exam N10-005)

Save 10%

DELUXE STUDY GUIDE Second Edition

Todd Lammle

Includes Real-World Scenarios, Hands-On Exercises, and + Custom Test Engine with Six Practice Exams + Hundreds of Sample Questions

+ Hundreds of Practice Questions + Electronic Flashcards

TABLE OF CONTENTS Chapter 1: Introduction to Networks. Chapter 2: The Open Systems Interconnection Specifications. Chapter 3: Networking Topologies, Connectors and Wiring Standards. Chapter 4: The Current Ethernet Specifications. Chapter 5: Networking Devices. Chapter 6: Introducing the Internet Protocol. Chapter 7: IP Addressing. Chapter 8: IP Subnetting and Troubleshooting IP. Chapter 9: Introduction to Routing. Chapter 10: Routing Protocols. Chapter 11: Switching and Virtual Lans. Chapter 12: Wireless Networking. Chapter 13: Authentication and Access Control. Chapter 14: Network Threats and Mitigation. Chapter 15: Physical and Hardware Security. Chapter 16: Wide Area Networking. Chapter 17: Operating Systems and Command Line Tools. Chapter 18: Software and Hardware Tools. Chapter 19: Network Troubleshooting. Chapter 20: Management and Optimization.

Save 10% on Exam Vouchers Coupon Inside!

Bill Ferguson

+ Electronic Flashcards + Entire Book in ePDF, Mobi, and ePub formats

SERIOUS SKILLS.

CompTIA Network+ Lab Manual, 3rd Edition Toby Skandier

Save 10% on Exam Vouchers Coupon Inside!

Toby Skandier

LAB MANUAL

Second Edition

+ Targeted Review for the CompTIA Network+ Exam + Includes Access to a Full Set of Online Review Tools + The Perfect Companion to Any Network+ Learning Tool

EXAM N10-005

TABLE OF CONTENTS Chapter 1: Networking Concepts. Chapter 2: Network Installation and Configuration. Chapter 3: Network Media and Topologies. Chapter 4: Network Management. Chapter 5: Network Security. SERIOUS SKILLS.

www.wiley.com/go/certcatalog

+ Exclusive Network+ Virtual Lab Network Simulator

SERIOUS SKILLS.

Bill Ferguson

EXAM N10-005

a Deluxe CD Featuring:

+ Custom Test Engine

CompTIA Network+ Review Guide, 2nd Edition (Exam: N10-005)

on Exam Vouchers Coupon Inside!

Todd Lammle

TABLE OF CONTENTS Phase 1: Designing an Internetwork. Phase 2: Implementing and Configuring the Design. Phase 3: Maintaining and Securing the Network. Phase 4: Troubleshooting the Network.

Step-by-step exercises teach you hands-on skills Real-world scenarios put those skills in perspective

EXAM N10-005

SERIOUS SKILLS.

COMP TIA® N E T W O R K+

Two expert Sybex study titles in one value-priced kit • CompTIA Network+ Study Guide, Second Edition, 978-1-118-13755-0 • CompTIA Network+ eTestPrep Authorized Courseware, Exam N10-005, 978-1-1118927177-3

CompTIA Network+ Certification Kit Recommended Courseware: Exam N10-005, 3rd Edition

The Complete Study Tool for CompTIA Network+ Certiﬁcation

Save $10 U.S. off suggested retail price of books purchased individually!

CERTIFICATION KIT THIRD EDITION

Three expert Sybex CompTIA Network+ study titles in one value-priced kit

EXAM N10-005

A trio of books to help you prepare for the CompTIA Network+ Exam

Todd Lammle, Bill Ferguson, and Toby Skandier

• CompTIA Network+ Study Guide, Second Edition, 978-1-118-13755-0 • CompTIA Network+ Review Guide, Second Edition, 978-1-118-14862-4 • CompTIA Network+ Lab Manual, 3rd Edition, 978-1-118-14863-1

www.wiley.com/go/certcatalog

COMP TIA® P R O J E C T+

CompTIA Project+ Study Guide Authorized Courseware (Exam PK0-003)

Save 10% on Exam Vouchers Coupon Inside!

Covers All Exam Objectives for Exam PK0-003

Includes Real-World Scenarios, Review Questions, and Leading-Edge Exam Prep Software Featuring:

s #USTOM 4EST %NGINE s (UNDREDS OF 3AMPLE 1UESTIONS

Kim Heldman and William Heldman

s %LECTRONIC &LASHCARDS

TABLE OF CONTENTS Chapter 1: Initiating the Project. Chapter 2: Project Process Groups and the Project Charter. Chapter 3: Planning a Project. Chapter 4: Schedule Planning. Chapter 5: Communicating the Plan. Chapter 6: Defining the Cost, Quality, and Risk Plans. Chapter 7: Executing the Project. Chapter 8: Processing Change Requests. Chapter 9: Controlling the Project. Chapter 10: Closing the Project.

APPROVE

TENT

s %NTIRE "OOK IN 0$&

QUALITY C

STUDY GUIDE Kim Heldman William Heldman

Exam PK0-003

S E C U R I T Y+

CompTIA Security+ Study Guide Authorized Courseware, 5th Edition (Exam SY0-301)

Save 10% on Exam Vouchers Coupon Inside!

Covers All Objectives for the SY0-301 Exam!

Includes Real-World Scenarios, Hands-On Exercises, and Leading-Edge Exam Prep Software Featuring:

s #USTOM 4EST %NGINE

APPROVE

TENT

s /VER 3AMPLE 1UESTIONS s %LECTRONIC &LASHCARDS

QUALITY C

Emmett Dulaney

STUDY GUIDE Fifth Edition

Exam SY0-301

Emmett Dulaney

Deluxe Edition

with exclusive Security+ training software!

Includes Real-World Scenarios, Hands-On Exercises, and Leading-Edge Exam Prep Software Featuring: s #USTOM 4EST %NGINE s (UNDREDS OF 3AMPLE 1UESTIONS s &IVE #OMPLETE 0RACTICE %XAMS s %LECTRONIC &LASHCARDS s "ONUS 6IDEOS 3TUDY 4OOLS AND -ORE

Deluxe STUDY GUIDE Exam SY0-301

TABLE OF CONTENTS Chapter 1: Measuring and Weighing Risk. Chapter 2: Infrastructure and Connectivity. Chapter 3: Protecting Networks. Chapter 4: Threats and Vulnerabilities. Chapter 5: Access Control and Identity Management. Chapter 6: Educating and Protecting the User. Chapter 7: Operating System and Application Security. Chapter 8: Cryptography Basics. Chapter 9: Cryptography Implementation. Chapter 10: Physical and Hardware-based Security. Chapter 11: Securing the Network Environment. Chapter 12: Wireless Networking Security. Chapter 13: Disaster Recovery and Incident Response. Chapter 14: Security Policies and Procedures. Chapter 15: Security Administration. Appendix A: About the Companion CD.

www.wiley.com/go/certcatalog

Save 10% on Exam Vouchers Coupon Inside!

Second Edition

Emmett Dulaney

COMP TIA®

Save 10% on Exam Vouchers Coupon Inside!

JAM E S M IC HAE L S T E WART

· Targeted Review Tool for the CompTIA Security+ Exam · The Perfect Companion to Any Security+ Learning Tool Features an Interactive CD with Two Practice Exams, Flashcards, and a Glossary of Key Terms

Security+ CompTIA

Security Administrator Street Smarts: A Real World Guide to CompTIA Security+ Skills, 3rd Edition

™

REVIEW GUIDE SECOND EDITION

TABLE OF CONTENTS Chapter 1: Network Security. Chapter 2: Compliance and Operational Security. Chapter 3: Threats and Vulnerabilities. Chapter 4: Application, Data, and Host Security. Chapter 5: Access Control and Identity Management. Chapter 6: Cryptography. Exam Essentials. Review Questions. Answers to Review Questions. Appendix About the Companion CD.

David R. Miller and Michael Gregg

Save 10% on Exam Vouchers Coupon Inside!

David R. Miller Michael Gregg

STREET SMARTS

A Real World Guide to CompTIA Security+ Skills ®

™

3 R D E D I T I O N - R E V I S E D F O R T H E U P D AT E D S E C U R I T Y + E X A M ( S Y 0 - 3 0 1 )

Step-by-step exercises teach you hands-on skills Real world scenarios put those skills in perspective

E X A M S Y0 - 3 0 1

SERIOUS SKILLS.

f rom book sm ar ts to stre e t sm a r ts

S E C U R I T Y+

TABLE OF CONTENTS Phase 1: The Grunt Work of Security. Phase 2: Hardening Systems. Phase 3: Malicious Software. Phase 4: Secure Storage. Phase 5: Managing User Accounts. Phase 6: Network Security. Phase 7: Securing Internet Activity. Phase 8: Security Testing. Phase 9: Investigating Incidents. Phase 10: Security Troubleshooting. SERIOUS SKILLS.

Two expert Sybex study titles in one value-priced kit • CompTIA Security+ Study Guide, Exam SY0-301, 5th Edition, 978-1-118-01473-8 • CompTIA Security+ eTestPrep Authorized Courseware, Exam SY0-301, 978-1-118-01473-8

www.wiley.com/go/certcatalog

COMP TIA® S E C U R I T Y+

CompTIA Security+ Certification Kit Recommended Courseware, 3rd Edition Exam SY0-301

The Complete Study Tool for CompTIA Security+™ Certiﬁcation Candidates Save $10 U.S. off suggested retail price of books purchased individually!

Study and prepare in depth for the exam Practice with real-world scenarios and exercises Review and reinforce with targeted review tool

Certiﬁcation Kit Third Edition

for the SY0-301

Exam!

JAMES MICHAEL STEWART

Exercises, Scenarios, Hands-On Includes Real-World Featuring: Exam Prep Software and Leading-Edge

David R. Miller Michael Gregg

· Targeted Review Tool for the CompTIA Security+ Exam · The Perfect Companion to Any Security+ Learning Tool

s #USTOM 4EST %NGINE s /VER 3AMPLE 1UESTIONS s %LECTRONIC &LASHCARDS

Features an Interactive CD with Two Practice Exams, Flashcards, and a Glossary of Key Terms

CompTIA

NTENT

APPROVE

DQ UALITY

Three expert Sybex CompTIA Security+ study titles in one value-priced kit

Covers All Objectives

from book smarts to street smarts

Exam SY0-301 • Leading-edge exam prep software • Custom test engine • Real-world scenarios • Hands-on exercises • Hundreds of sample questions • Challenging practice exams • Electronic ﬂashcards • Additional study tools

Security+ + STREET SMARTS ™

A Real World Guide to CompTIA Security+

REVIEW GUIDE

Fifth Edition

Exam SY0-301

™

Skills

3 RD E D ITI O N - R EV ISED FOR THE UP D AT E D S E C U R I T Y + E X A M ( S Y 0 - 3 01 )

SECOND EDITION

STUDY GUIDE

Step-by-step exercises teach you hands-on skills

EXAM SY0-301

Emmett Dulaney

Real world scenarios put those skills in perspective

SERIOUS SKILLS.

Emmett Dulaney, James Michael Stewart, David R. Miller, and Michael Gregg

• CompTIA Security+ Study Guide, Exam SY0-301, 5th Edition, 978-1-118-01473-8 • Security Administrator Street Smarts: A Real World Guide to CompTIA Security+ Skills, Third Edition, 978-1-118-06116-9 • CompTIA Security+ Review Guide, Second Edition, 978-1-118-06117-6

CASP

CASP CompTIA Advanced Security Practitioner

TENT

APPROVE

Michael Gregg and Billy Haines

Save 10% on Exam Vouchers Coupon Inside!

Michael Gregg and Billy Haines

CASP: CompTIA Advanced Security Practitioner Study Guide Authorized Courseware (Exam CAS-001)

QUALITY C

STUDY GUIDE

EXAM CAS-001

Includes Real-World Scenarios, Lab Exercises, and Access to Exam Prep Software Featuring: + Custom Test Engine + Hundreds of Practice Questions + Electronic Flashcards

TABLE OF CONTENTS Chapter 1: Cryptographic Tools and Techniques Chapter 2: Comprehensive Security Solutions Chapter 3: Securing Virtualized, Distributed, and Shared Computing Chapter 4: Host Security Chapter 5: Application Security and Penetration Testing Chapter 6: Risk Management Chapter 7: Policies, Procedures, and Incident Response Chapter 8: Security Research and Analysis Chapter 9: Enterprise Security Integration Chapter 10: Security Controls for Communication and Collaboration SERIOUS SKILLS.

www.wiley.com/go/certcatalog

COMP TIA® S TO R AG E+

Data Storage Networking: Real World Skills for the CompTIA Storage+ Certification and Beyond

Data Storage 0GVYQTMKPI 4GCN 9QTNF 5MKNNU HQT VJG %QOR6+# 5VQTCIG %GTVKƒECVKQP CPF $G[QPF

Cloud Essentials: CompTIA Authorized Courseware (Exam CLO-001)

Nigel Poulton

Kirk Hausman, Susan L. Cook, and Telmo Sampaio

Save 10%

Kirk Hausman Susan L. Cook Telmo Sampaio

on Exam Vouchers Coupon Inside!

Cloud

ESSENTIALS CompTIA Authorized Courseware for Exam CLO-001 ®

Nigel Poulton

TABLE OF CONTENTS Chapter 1: What is Cloud Computing Chapter 2: Cloud Models Chapter 3: Service Models Chapter 4: Current Cloud Technologies Chapter 5: Cloud Business Value Chapter 6: Cloud Infrastructure Planning Chapter 7: Strategies for Cloud Adoption Chapter 8: Applications in the Cloud Chapter 9: Cloud Service Rollout Chapter 10: Cloud Service-Level Management Chapter 11: Security in the Cloud Chapter 12: Privacy and Compliance

CWNP® Sybex is the official publisher of the Official Study Guides for the Certified Wireless Network Professional (CWNP) certifications.

CWTS Official Study Guide Exam PW0-071

Specialis

i rtified W

CWTS

CWTS Ce

CWTS: Certified Wireless Technology Specialist Official Study Guide, 2nd Edition (Exam PW0-071)

CWNA

s Te chno

Certified Wireless Technology Specialist

Official Study Guide Second Edition Robert J. Bartz

Richard J. Bartz

Includes Real-World Scenarios, Hands-On Exercises, and Access to Leading-Edge Exam Prep Software Featuring: t $VTUPN 5FTU &OHJOF t 1SBDUJDF &YBNT t &MFDUSPOJD 'MBTIDBSET t (MPTTBSZ PG 5FSNT BOE 8IJUF 1BQFST

CWNA: Certified Wireless Network Administrator Official Study Guide, 3rd Edition (Exam PW0-105) David D. Coleman and David A. Westcott

Official Study Guide Exam PW0-105

CWNA ®

Certified Wireless Network Administrator Official Study Guide Third Edition

David D. Coleman, CWNE #4 David A. Westcott, CWNE #7

Includes Real-World Scenarios, Hands-On Exercises, and Access to Leading-Edge Exam Prep Software Featuring: • Custom Test Engine • Practice Exams • Over 350 Electronic Flashcards • Glossary of Terms • White Papers, Videos, and Demo Software, and More

TABLE OF CONTENTS Chapter 1: Introduction to Computer Networking Chapter 2: Introduction to Wireless Local Area Networking Chapter 3: Wireless LAN Infrastructure Devices Chapter 4: Wireless LAN Client Devices Chapter 5: Physical Layer Access Methods and Spread-Spectrum Technology Chapter 6: Radio Frequency Fundamentals for Wireless LAN Technology Chapter 7: Wireless LAN Antennas and Accessories Chapter 8: Wireless LAN Terminology and Technology Chapter 9: Wireless LAN Security Basics Chapter 10: Wireless LAN Site Survey Basics Chapter 11: Performing an RF Wireless LAN Site Survey Chapter 12: Troubleshooting and Maintaining IEEE 802.11 Wireless Local Area Networks

www.wiley.com/go/certcatalog

SERIOUS SKILLS.

CWNP® CWSP

CWDP Ofﬁcial Study Guide Exam PW0-204

CWSP

Certiﬁed Wireless Security Professional Ofﬁcial Study Guide David D. Coleman David A. Westcott Bryan E. Harkins Shawn M. Jackman

Includes Real-World Scenarios, Hands-On Exercises, and Leading-Edge Exam Prep Software Featuring: • Hundreds of Sample Questions • Electronic Flashcards • Case Studies and Demo Software

SERIOUS SKILLS.

TABLE OF CONTENTS Chapter 1: WLAN Security Overview. Chapter 2: Legacy 802.11 Security. Chapter 3: Encryption Ciphers and Methods. Chapter 4: Enterprise 802.11 Layer 2 Authentication Methods. Chapter 5: 802.11 Layer 2 Dynamic Encryption Key Generation. Chapter 6: SOHO 802.11 Security. Chapter 7: 802.11 Fast Secure Roaming. Chapter 8: Wireless Security Risks. Chapter 9: Wireless LAN Security Auditing. Chapter 10: Wireless Security Monitoring. Chapter 11: VPNs, Remote Access, and Guest Access Services. Chapter 12: WLAN Security Infrastructure. Chapter 13: Wireless Security Policies. Appendix A: Abbreviations, Acronyms, and Regulations. Appendix B: WLAN Vendors. Appendix C: About the Companion CD.

Ofﬁcial Study Guide Exam PW0-250

CWDP

™

Certiﬁed Wireless Design Professional Ofﬁcial Study Guide Shawn M. Jackman, CWNE #54 Marcus Burton, CWNE #78 Matt Swartz, CWNE #57 Thomas W. Head

Includes Real-World Scenarios and Leading-Edge Exam Prep Software Featuring: • Two full-length practice exams • Over 100 electronic ﬂashcards

SERIOUS SKILLS.

TABLE OF CONTENTS Chapter 1: Gathering and Analyzing Requirements. Chapter 2: Designing for Client Devices and Applications. Chapter 3: Designing for Applications. Chapter 4: Industry-Specific Design Considerations. Chapter 5 :Vendor and WLAN Architecture Selection. Chapter 6: RF Communication Principles. Chapter 7: RF Hardware and 802.11n. Chapter 8: Site Survey Preparation. Chapter 9: Site Survey RF Design. Chapter 10: MAC Layer Design. Chapter 11: Basic WLAN Security Design. Chapter 12: Advanced Enterprise WLAN Security Design. Chapter 13: Documentation and Finalizing the Design Solution. Chapter 14: Post-Installation Validation. Chapter 15: Design Troubleshooting. Appendix A: About the Companion CD.

C WA P

TABLE OF CONTENTS Chapter 1: 802.11 Overview. Chapter 2: 802.11 Physical (PHY) Layer Frame Format. Chapter 3: 802.11 MAC Sub-layer Frame Format. Chapter 4: 802.11 Management Frames. Chapter 5: 802.11 Control Frames. Chapter 6: 802.11 Data Frames. Chapter 7: 802.11 Medium Contention. Chapter 8: 802.11 Power Management. Chapter 9: 802.11 Security. Chapter 10: 802.11n – HT analysis. Chapter 11: Spectrum Analysis - Layer 1. Chapter 12: Protocol Analyzer Operation & Troubleshooting.

www.wiley.com/go/certcatalog

Ofﬁcial Study Guide Exam PW0-270

CWAP

Certiﬁed Wireless Analysis Professional Ofﬁcial Study Guide David A. Westcott, CWNE #7 David D. Coleman, CWNE #4 Peter Mackenzie, CWNE #33 Ben Miller, CWNE #12

Includes Real-World Scenarios, Hands-On Exercises, and Leading-Edge Exam Prep Software Featuring: • Two full-length practice exams • Over 150 electronic ﬂashcards

SERIOUS SKILLS.

EC- COUNCIL CEH: CER TIFIED ETHIC AL HACK ER

Sean-Philip Oriyano

CEHV8 Certiﬁed Ethical Hacker Version 8

STUDY GUIDE

TABLE OF CONTENTS Chapter 1: Introduction to Ethical Hacking, Ethics, and Legality. Chapter 2: Gathering Target Information: Reconnaissance, Footprinting, and Social Engineering. Chapter 3: Gathering Network and Host Information: Scanning and Enumeration. Chapter 4: System Hacking: Password Cracking, Escalating Privileges, and Hiding Files. Chapter 5: Installing Software on Target Systems: Spyware, Trojans, Backdoors, Viruses, and Worms. Chapter 6: Gathering Data from Networks: Sniffers. Chapter 7: Denial of Service and Session Hijacking. Chapter 8: Web Hacking: Google, Web Servers, Web Application Vulnerabilities, and Web-Based Password Cracking Techniques. Chapter 9: Attacking Applications: SQL Injection and Buffer Overflows. Chapter 10: Wireless Network Hacking. Chapter 11: Physical Site Security. Chapter Chapter 12: Hacking Linux Systems. Chapter 13: Bypassing Network Security: Evading IDS, Honeypots, and Firewalls. Chapter 14: Understanding Cryptography. Chapter 15: Performing a Penetration Test.

G U I DA N C E S O F T WA R E

ENCE: ENCASE CERTIFIED EX AMINER

TABLE OF CONTENTS Chapter 1: Computer Hardware. Chapter 2: File Systems. Chapter 3: First Response. Chapter 4: Acquiring Digital Evidence. Chapter 5: EnCase Concepts. Chapter 6: EnCase Environment. Chapter 7: Understanding, Searching For, and Bookmarking Data. Chapter 8: File Signature Analysis and Hash Analysis. Chapter 9: Windows Operating System Artifacts. Chapter 10: Advanced EnCase. Appendix A: Creating Paperless Reports.

www.wiley.com/go/certcatalog

ISAC A (Information Systems Audit and Control Association)

C I S A : C E R T I F I E D I N F O R M AT I O N S Y S T E M S A U D I T O R

CISA Certified Information Systems Auditor Study Guide, 3rd Edition

Over 500 Review Questions

David L. Cannon

Includes Real-World Scenarios for Insight into Professional Audit Systems and Controls, and Leading-Edge Exam Prep Software Featuring:

• Custom Test Engine

• Hundreds of Sample Questions • Electronic Flashcards • Entire Book in PDF

TABLE OF CONTENTS Chapter 1: Secrets of a Successful IS Auditor. Chapter 2: IT Governance. Chapter 3: Audit Program. Chapter 4: Networking Technology. Chapter 5: Life Cycle Management. Chapter 6: IT Service Delivery. Chapter 7: Information Asset Protection. Chapter 8: Disaster Recovery and Business Continuity. Appendix A: About the Companion CD. Glossary.

CISA ®

Certiﬁed Information Systems Auditor STUDY GUIDE ®

Third Edition

David L. Cannon SERIOUS SKILLS.

(ISC)2® (The International Information Systems Security Certification Consortium, Inc.)

C E R T I F I E D I N F O R M AT I O N S Y S T E M S S E C U R I T Y P R O F E S S I O N A L ( C I S S P )

James M. Stewart, Mike Chapple, and Darril Gibson

CISSP

Certiﬁed Information Systems Security Professional

STUDY GUIDE Sixth Edition

TABLE OF CONTENTS Chapter 1: Access Control 1. Chapter 2: Access Control Attacks and Monitoring. Chapter 3: Secure Network Architecture and Securing Network Components. Chapter 4: Secure Communications and Network Attacks. Chapter 5: Security Governance Concepts, Principles, and Policies. Chapter 6: Risk and Personnel Management. Chapter 7: Software Development Security. Chapter 8: Malicious Code and Application Attacks. Chapter 9: Cryptography and Symmetric Key Algorithms. Chapter 10: PKI and Cryptographic Applications. Chapter 11: Principles of Security Models, Design, and Capabilities. Chapter 12: Security Architecture Vulnerabilities, Threats, and Countermeasures. Chapter 13: Security Operations. Chapter 14: Incident Management. Chapter 15: Business Continuity Planning. Chapter 16: Disaster Recovery Planning. Chapter 17: Laws, Regulations, and Compliance. Chapter 18: Incidents and Ethics. Chapter 19: Physical Security Requirements. Includes Real-World Scenarios, Written Exercises, and Access to Exam Prep Software Featuring: + Three Full-Length Practice Exams + Over 1,000 Practice Questions + Electronic Flashcards

SERIOUS SKILLS.

www.wiley.com/go/certcatalog

LPI (Linux Professional Institute)

L P I C -1 A N D L P I C - 2

Linux Essentials

Roderick W. Smith

TABLE OF CONTENTS Chapter 1: Selecting an Operating System. Chapter 2: Investigating Linux’s Principles and Philosophy. ESSENTIALS Chapter 3: Understanding Software Licensing. Chapter 4: Using Common Linux Programs. Chapter 5: Managing Hardware. Chapter 6: Getting to Know the Command Line. Chapter 7: Managing Files. Chapter 8: Getting Help. Chapter 9: Using Programs and Processes. Chapter 10: Searching, Extracting, and Archiving Data. Chapter 11: Editing Files. Chapter 12: Creating Scripts. Chapter 13: Understanding Users and Groups. Chapter 14: Creating Users and Groups. Chapter 15: Setting Ownership and Permissions. Chapter 16: Navigating the Linux Filesystem. Chapter 17: Managing Network Connections.

Linux

SERIOUS SKILLS.

TABLE OF CONTENTS Chapter 1: Exploring Linux Command-Line Tools. Chapter 2: Managing Software. Chapter 3: Configuring Hardware Chapter 4: Managing Files. Chapter 5: Booting Linux and Editing Files. Chapter 6: Configuring the X Window System. Chapter 7: Administering the System. Chapter 8: Configuring the Basic Network. Chapter 9: Writing Scripts, Configuring Email, and Using Databases. Chapter 10: Securing Your System. Appendix A: Answers to Review Questions. Appendix B: About the Additional Study Tools.

LPIC-2: Linux Professional Institute Certification Study Guide (Exams 201 and 202)

Covers Both the 201 and 202 Exams! Includes Real-World Scenarios, Hands-On Exercises, and Leading-Edge Exam Prep Software Featuring:

• Linux-Compatible Custom Test Engine • Hundreds of Sample Questions • Electronic Flashcards • Glossary of Terms in PDF

LPIC-2 Linux Professional

Institute Certiﬁcation TABLE OF CONTENTS STUDY GUIDE Part I. The LPI 201 Exam (60 Weights). Chapter 1: System Startup and Advanced System Management. Roderick W. Smith Chapter 2: Linux Kernel Configuration. Chapter 3: Basic Filesystem Management. Chapter 4: Advanced Filesystem Management. Chapter 5: Networking Configuration. Chapter 6: DNS Server Configuration. Part II The LPI 202 Exam (60 Weights). Chapter 7: Advanced Network Configuration. Chapter 8: Configuring File Servers. Chapter 9: Configuring Web & Email Servers. Chapter 10: Security. Chapter 11: System Troubleshooting-I. Chapter 12: System Troubleshooting-II. Exams 201 and 202

SERIOUS SKILLS.

www.wiley.com/go/certcatalog

MICROSOFT M TA I T I N F R A S T R U C T U R E

Microsoft Windows Operating System Essentials

Tom Carpenter

Microsoft Windows Server Administration Essentials

Tom Carpenter

Exam 98-365

Exam 98-349

Microsoft Windows TABLE OF CONTENTS Operating System Chapter 1: Windows Operating ESSENTIALS Systems Overview. Chapter 2: Installing Windows. Chapter 3: Managing the Desktop. Chapter 4: Using Native Applications. Chapter 5: Managing with the Control Panel. Chapter 6: Mobility and Remote Management. Chapter 7: Managing Applications. Chapter 8: Controlling Malware Chapter 9: File Management. Chapter 10: Network Shares. Chapter 11: Device Management. Chapter 12: Storage Management. Chapter 13: Windows Troubleshooting. Chapter 14: Backup and Recovery. Chapter 15: Windows Update.

TABLE OF CONTENTS Windows Server Administration ESSENTIALS Chapter 1: Windows Server Overview. Chapter 2: Installing Windows Servers. Chapter 3: Managing Windows Server Storage Chapter 4: Administering Services. Chapter 5: Active Directory Infrastructure. Chapter 6: Configuring Active Directory. Chapter 7: Managing Active Directory. Chapter 8: Group Policy Management. Chapter 9: Application Servers. Chapter 10: Internet Information Services (I IS). Chapter 11: File and Print Servers. Chapter 12: Remote Access Technologies. Chapter 13: Server Troubleshooting. Chapter 14: Performance Tuning. Chapter 15: Server Maintenance. Appendix A: Answers to Review Questions Appendix B: Microsoft’s Certification Program. Certification Objectives Map.

Microsoft Windows Networking Essentials

Microsoft Windows Security Essentials

SERIOUS SKILLS.

Darril Gibson

Microsoft®

SERIOUS SKILLS.

Darril Gibson

Exam 98-366 TABLE OF CONTENTS Microsoft Chapter 1: Introduction to Windows Networking Networking. Chapter 2: Overview ESSENTIALS of Networking Components. Chapter 3: Understanding the OSI Model. Chapter 4: Core TCP/IP Protocols. Chapter 5: Exploring IPv4. Chapter 6: Exploring IPv6. Chapter 7: Connecting Computers to a Network. Chapter 8: Networking Computer with Switches. Chapter 9: Connecting Networks with Routers. Chapter 10: Resolving Names to IP Addresses. Chapter 11: Understanding Network Security Zones. Chapter 12: Understanding Wireless Networking. Chapter 13: Understanding Wide Area Networks. Chapter 14: Troubleshooting TCP/IP Problems. Appendix A: Answers to Review Questions. Appendix B: Microsoft’s Certification Program. Certification Objectives Map. ®

SERIOUS SKILLS.

www.wiley.com/go/certcatalog

Darril Gibson

Exam 98-367 TABLE OF CONTENTS Chapter 1: Understanding Core Windows Security Security Principles. Chapter ESSENTIALS 2: Understanding Malware and Social Engineering. Chapter 3: Understanding User Authentication. Chapter 4: Securing Access with Permissions. Chapter 5: Using Audit Policies and Network Auditing. Chapter 6: Protecting Clients and Servers. Chapter 7: Protecting a Network. Chapter 8: Understanding Wireless Security. Chapter 9: Understanding Physical Security. Chapter 10: Enforcing Confidentiality with Encryption. Chapter 11: Understanding Certificates and a PKI. Chapter 12: Understanding Internet Explorer Security. Appendix A: Answers to Review Questions. Appendix B: Microsoft’s Certification Program. Microsoft®

SERIOUS SKILLS.

MICROSOFT SERVER

DESKTOP

MCSA Windows Server 2012 Complete Study Guide (Exams 70-410, 70-411, 70-412, and 70-417)

MCSA: Microsoft Windows 8 Complete Study Guide (Exams 70-687 and 70-688)

William Panek

Rob Tidrow, William Panek, and Darril Gibson

Darril Gibson

MCSA Microsoft Windows 8 ®

COMPLETE STUDY GUIDE EXAM 70-687 EXAM 70-688

Includes Real-World Scenarios, Hands-On Exercises, and Access to Exam Prep Software Featuring: + Custom Test Engine + Over 300 Sample Questions + Electronic Flashcards + Over an Hour of Video Instruction

TABLE OF CONTENTS Chapter 1: Installing and Configuring Windows Server 2012. Chapter 2: Domain Name System. Chapter 3: Active Directory Planning and Installation. Chapter 4: Administering Active Directory. Chapter 5: Managing Group Policy Objects. Chapter 6: Configuring Active Directory Infrastructure. Chapter 7: Configuring Active Directory Server Roles. Chapter 8: Using Virtualization in Windows Server 2012. Chapter 9: Configuring TCP/IP. Chapter 10: Managing DHCP. Chapter 11: Managing and Maintaining Servers. Chapter 12: Configuring Network Access. Chapter 13: Understanding Security. Chapter 14: Managing File and Print Services. Chapter 15: Managing Remote Access Services. Chapter 16: Configuring High Availability in Windows Server 2012. Chapter 17: Configuring File and Storage Services. Chapter 18: Implementing Disaster Recovery. Appendix A: Answers to Review Questions. Appendix B: About the Additional Study Tools.

D ATA B A S E

TABLE OF CONTENTS Chapter 1: Understanding SQL Server’s Role. Chapter 2: Installing SQL Server. Chapter 3: Working with the Administration Tools. Chapter 4: SQL Server Command-Line Administration. Chapter 5: Querying SQL Server. Chapter 6: Database Concepts and Terminology. Chapter 7: ERD and Capacity Planning. Chapter 8: Normalization and Other Design Issues. Chapter 9: Creating SQL Server Databases. Chapter 10: Creating Tables. Chapter 11: Indexes and Views. Chapter 12: Triggers and Stored Procedures. Chapter 13: Implementing Advanced Features. Chapter 14: Creating Jobs, Operators, and Alerts. Chapter 15: Performance Monitoring and Tuning. Chapter 16: Policy-Based Management. Chapter 17: Backup and Restoration. Chapter 18: Security Threats and Principles. Chapter 19: Authentication and Encryption. Chapter 20: Security Best Practices. Chapter 21: AlwaysOn and High Availability. Chapter 22: SQL Server Failover Clustering. Chapter 23: Database Mirroring and Snapshots. Chapter 24: Implementing Replication. Chapter 25: Data Warehousing. Chapter 26: SQL Server Integration Services. Chapter 27: Data Quality Solutions. Appendix A: Microsoft’s Certification Program. Appendix B: About the Additional Study Tools. 46

www.wiley.com/go/certcatalog

OR ACLE ORACLE CERTIFIED ASSOCIATE (OCA) AND ORACLE CERTIFIED PROFESSIONAL (OCP)

Biju Thomas

OCA

Oracle Database 12c Administrator Certiﬁed Associate

STUDY GUIDE EXAM 1Z0-061 EXAM 1Z0-062

Includes Real-World Scenarios, Hands-On Exercises, and Access to Exam Prep Software Featuring: + Custom Test Engine + Over 300 Sample Questions + Electronic Flashcards

TABLE OF CONTENTS Part I: Oracle Database 11g: SQL Fundamentals I. Chapter 1: Basic SQL SELECT Statements. Chapter 2: Single-Row Functions. Chapter 3: Group Functions. Chapter 4: Joins and Sub-queries. Chapter 5: Modifying Data. Chapter 6: Creating Tables. Chapter 7: Creating Schema Objects. Part II: Oracle Database 11g: Administration I. Chapter 8: Oracle Database 11g Components and Architecture. Chapter 9: Create an Oracle11g Database. Chapter 10: Database Storage and Schema Objects. Chapter 11: Oracle Network Architecture. Chapter 12: Security and Auditing. Chapter 13: Managing Data and Undo. Chapter 14: Proactive Maintenance and Performance Monitoring. Chapter 15: Implementing Database Backups. Chapter 16: Recovering Database. Chapter 17: EM Tools and Data Utilities.

Robert G. Freeman and Charles A. Pack

OCP

Oracle Database 12c Administrator Certiﬁed Professional

STUDY GUIDE EXAM 1Z0-063

Includes Real-World Scenarios, Hands-On Exercises, and Access to Exam Prep Software Featuring: + Custom Test Engine + Over 300 Sample Questions + Electronic Flashcards

TABLE OF CONTENTS Assessment Test. Chapter 1: Using Oracle ASM. Chapter 2: Performing Oracle User-Managed Backups. Chapter 3: Performing Oracle User-Managed Database Recoveries. Chapter 4: Configuring and Backing Up Using RMAN. Chapter 5: Using the RMAN Recovery Catalog. Chapter 6: Recovering Databases with RMAN. Chapter 7: Reporting, Monitoring, and Tuning with RMAN. Chapter 8: Performing Oracle Advanced Recovery. Chapter 9: Understanding Flashback Technology. Chapter 10: Diagnosing the Database and Managing Performance. Chapter 11: Managing Database Resources. Chapter 12: Using the Scheduler to Automate Tasks. Chapter 13: Implementing Globalization Support. Appendix A: Lab Exercises.

www.wiley.com/go/certcatalog

J AVA J AVA P R O G R A M M E R

TABLE OF CONTENTS Chapter 1: Introducing the Basics of Java. Chapter 2: Applying Data Types in Java Programming. Chapter 3: Using Java Operators and Conditional Logic. Chapter 4: Using Java Arrays. Chapter 5: Using Loops in Java Code. Chapter 6: Encapsulating Data and Exposing Methods in Java. Chapter 7: Using Java Methods to Communicate. Chapter 8: Using Java Constructors. Chapter 9: Inheriting Code and Data in Java. Chapter 10: Understanding Java Interfaces and Abstract Classes. Chapter 11: Throwing and Catching Exceptions in Java

TABLE OF CONTENTS Chapter 1: Fundamentals. Chapter 2: Declarations, Initialization, and Scoping. Chapter 3: Flow Control. Chapter 4: API Contents. Chapter 5: Concurrency. Chapter 6: Object-Oriented Concepts. Chapter 7: Collections and Generics.

www.wiley.com/go/certcatalog

V M WA R E , I N C . VC P5 : V M WA R E C E R T I F I E D P R O F E S S I O N A L O N V S P H E R E

VCP5 VMware Certified Professional on vSphere 5 Study Guide (Exam VCP-510) Brian Atkinson

Brian Atkinson

VCP5

VMware Certiﬁed Professional on vSphere 5 ®

STUDY GUIDE EXAM VCP-510

Includes Real-World Scenarios, Hands-On Exercises, and Access to Exam Prep Software Featuring:

TABLE OF CONTENTS Chapter 1: What’s New in vSphere 5. Chapter 2: Plan, Install, Configure, and Upgrade vCenter Server and VMware ESXi. Chapter 3: Secure vCenter Server and ESXi and Identify vSphere Architecture and Solutions. Chapter 4: Plan and Configure vSphere Networking. Chapter 5: Plan and Configure vSphere Storage. Chapter 6: Create and Deploy Virtual Machines and vApps. Chapter 7: Manage and Administer Virtual Machines and vApps. Chapter 8: Establish Service Levels with Cluster, Fault Tolerance, and Resource Pools. Chapter 9: Maintain Service Levels. Chapter 10: Perform Basic Troubleshooting. Chapter 11: Monitor a vSphere Implementation and Manage vCenter Server Alarms. + Custom Test Engine

+ Over 300 Sample Questions + Electronic Flashcards

SERIOUS SKILLS.

Brian Atkinson

VCP-DCV VMware Certified Professional-Datacenter Virtualization on vSphere

STUDY GUIDE

Includes Real-World Scenarios, Hands-On Labs, and Access to Exam Prep Software Featuring: + Practice Test Environment with hundreds of questions + Electronic Flashcards + Glossary of Key Terms + Author Videos

www.wiley.com/go/certcatalog

PMI (Project Management Institute)

PMP

PMP: Project Management Professional Exam Study Guide, 7th Edition

PMP: Project Management Professional eTestPrep

Kim Heldman

TABLE OF CONTENTS Chapter 1: What Is a Project? Chapter 2: Creating the Project Charter. Chapter 3: Developing the Project Scope Statement. Chapter 4: Creating the Project Schedule. Chapter 5: Developing the Project Budget. Chapter 6: Risk Planning. Chapter 7: Planning Project Resources. Chapter 8: Developing the Project Team. Chapter 9: Conducting Procurements and Sharing Information. Chapter 10: Measuring and Controlling Project Performance. Chapter 11: Controlling Work Results. Chapter 12: Closing the Project and Applying Professional Responsibility.

Bonnie Biafore Teresa Stover

Your Project Management

Coach

TABLE OF CONTENTS Best Practtice es for Managing Projectss in the Real World Part I Understanding Projects and Project Management. Chapter 1 Getting to Know Projects. Chapter 2 Getting to Know Project Management. Part II Planning a Project. Chapter 3 Getting a Project Off the Ground. Chapter 4 Getting to Know a Project Plan. Chapter 5 Identifying the Work to Be Completed. Chapter 6 Estimating Work and Cost. Chapter 7 Planning Project Resources. Chapter 8 Building a Schedule. Chapter 9 Planning for Quality. Chapter 10 Setting Up a Communication Plan. Chapter 11 Setting Up a Change Management Plan. Chapter 12 Managing Risk. Part III Executing a Project. Chapter 13 Kicking Off a Project. Chapter 14 Taming Processes, Problems, and Conflicts. Chapter 15 The Keys to Successful Meetings. Chapter 16 Transforming People into a Team. Part IV Monitoring and Controlling. Chapter 17 Gathering Progress Information. Chapter 18 Evaluating Progress and Performance. Chapter 19 Getting a Plan Back on Track. Part V Closing the Project. Chapter 20 Obtaining Acceptance and Other Wrap-Up Tasks. Chapter 21 Documenting a Project for Posterity. Chapter 22 Don’t Forget Lessons Learned. Part VI Taking the Next Steps in Project Management. Chapter 23 Running a Project Management Office. Chapter 24 Managing a Portfolio of Projects. Part VII Reference.

www.wiley.com/go/certcatalog

PMI (Project Management Institute)

PMP

TABLE OF CONTENTS Chapter 1: Overview. Chapter 2: Project Management Growth: Concepts and Definitions. Chapter 3: Organizational Structures. Chapter 4: Organizing and Staffing the Project Office and Team. Chapter 5: Management Functions. Chapter 6: Management of ‘Your’ Time and Stress. Chapter 7: Conflicts. Chapter 8: Special Topics. Chapter 9: The Variables for Success. Chapter 10: Working with Executives. Chapter 11: Planning. Chapter 12: Network Scheduling Techniques. Chapter 13: Project Graphics. Chapter 14: Pricing and Estimating. Chapter 15: Cost Control. Chapter 16: Trade-off Analysis in a Project Environment. Chapter 17: Risk Management. Chapter 18: Learning Curves. Chapter 19: Contract Management. Chapter 20: Quality Management. Chapter 21: Modern Developments Project Management. Chapter 22: The Business of Scope Changes. Chapter 23: The ‘Project’ Office. Chapter 24: Managing Crisis Projects. Chapter 25: The Rise, Fall, and Resurrection of Iridium: A Project Management Perspective. Appendix A: Solutions to the Project Management Conflict Exercise. Appendix B: Solution to Leadership Exercise. Appendix C: Dorale Products Case Studies. Appendix D: Solution to the Dorale Products Case Studies. Appendix E: Crosslisting of PMBOK to the Text.

Project Management Workbook and PMP / CAPM Exam Study Guide, 11th Edition

Project Management: Case Studies, 4th Edition

Harold R. Kerzner and Frank P. Saladis

Harold R. Kerzner

TABLE OF CONTENTS Chapter 1. Project Management Overview. Chapter 2. Project Management Growth: Concepts and Definitions. Chapter 3. Organizational Structures. Chapter 4. Organizing and Staffing the Project Office and Team. Chapter 5. Management Functions. Chapter 6. Management of Your Time and Stress. Chapter 7. Conflicts. Chapter 8. Special Topics. Chapter 9. The Variables for Success. Chapter 10. Working with Executive. Chapter 11. Planning. Chapter 12. Network Scheduling Techniques. Chapter 13. Project Graphic. Chapter 14. Pricing and Estimating. Chapter 15. Cost Control. Chapter 16. Tradeoff Analysis. Chapter 17. Risk Management. Chapter 18. Learning Curves. Chapter 19. Contract Management. Chapter 20. Quality Management. Chapter 21. Modern Developments in Project Management. Chapter 22. Situational Exercises. Chapter 23. Project Management Crossword Puzzles. Chapter 24. PMP and CAPM Exam Review. Chapter 25. Project Management Logic Problems. www.wiley.com/go/certcatalog

TABLE OF CONTENTS 1 Project Management Methodologies 2 Implementation of Project Management 3 Project Management Cultures 4 Project Management Organizational Structures 5 Negotiating for Resources 6 Project Estimating 7 Project Planning 8 Project Scheduling 9 Project Execution 10 Controlling Projects 11 Project Risk Management 12 Conflict Management 13 Morality And Ethics 14 Managing Scope Changes 15 Wage and Salary Administration 16 Time Management 17 Industry Specific: Construction

INDEX

A Administering Microsoft SQL Server 2012 Databases: Exam 70-462 / MOAC ....................................................................................19 Administering Windows Server 2012: Exam 70-411 / MOAC ................................................................................................................16

C CASP: CompTIA Advanced Security Practitioner Study Guide Authorized Courseware: Exam CAS-001 / Gregg ...........................39 CCENT Study Guide: Exam 100-101 (ICND1) / Lammle .........................................................................................................................29 CCENT Virtual Lab 2.0: Exam 100-101 (ICND1) / Tedder ......................................................................................................................29 CCNA Data Center - Introducing Cisco Data Center Networking Study Guide: Exam 640-911 / Lammle ........................................31 CCNA Data Center: Introducing Cisco Data Center Technologies Study Guide: Exam 640-916 / Lammle .......................................31 CCNA ICND2 Study Guide: Exam 200-101 / Lammle ............................................................................................................................29 CCNA Routing and Switching Certification Kit: Exams 100-101, 200-201, 200-120 / Lammle ........................................................... 30 CCNA Routing and Switching Deluxe Study Guide: Exams 100-101, 200-101, and 200-120 / Lammle.............................................. 30 CCNA Routing and Switching Review Guide: Exams 100-101, 200-101, and 200-120 / Lammle ........................................................ 30 CCNA Routing and Switching Study Guide: Exams 100-101, 200-101, and 200-120 / Lammle ...........................................................29 CCNA Routing and Switching Virtual Lab, Titanium Edition 4.0 / Tedder ........................................................................................... 30 CEHv8: Certified Ethical Hacker Version 8 Study Guide / Oriyano .......................................................................................................42 CISA Certified Information Systems Auditor Study Guide, 3rd Edition / Cannon............................................................................... 43 CISSP: Certified Information Systems Security Professional Study Guide, 6th Edition / Stewart ...................................................... 43 Cloud Essentials: CompTIA Authorized Courseware for Exam CLO-001 / Hausman ......................................................................... 40 CompTIA A+ Complete Certification Kit Recommended Courseware: Exams 220-801 and 220-802, 2nd Edition / Docter ...........34 CompTIA A+ Complete Deluxe Study Guide Recommended Courseware: Exams 220-801 and 220-802, 2nd Edition / Docter.....32 CompTIA A+ Complete Lab Manual / Pyles ...........................................................................................................................................33 CompTIA A+ Complete Review Guide: Exams 220-801 and 220-802, 2nd Edition / Dulaney ............................................................33 CompTIA A+ Complete Study Guide Authorized Courseware: Exams 220-801 and 220-802, 2nd Edition / Docter ........................32 CompTIA A+ eTestPrep Authorized Courseware: Exams 220-801 and 220-802 / Docter...................................................................33 CompTIA A+ Total Test Prep: A Comprehensive Approach to the CompTIA A+ Certification / Docter ............................................33 CompTIA Linux+ Study Guide: Exams LX0-101 and LX0-102, 2nd Edition / Smith ..............................................................................34 CompTIA Network+ Certification Kit Recommended Courseware: Exam N10-005, 3rd Edition / Lammle .......................................36 CompTIA Network+ Deluxe Study Guide Recommended Courseware: Exam N10-005, 2nd Edition / Lammle ...............................35 CompTIA Network+ eTestPrep Authorized Courseware: Exam N10-005 / Lammle ............................................................................36 CompTIA Network+ Lab Manual, 3rd Edition / Skandier ......................................................................................................................35 CompTIA Network+ Review Guide: Exam N10-005, 2nd Edition / Ferguson ......................................................................................35 CompTIA Network+ Study Guide Authorized Courseware: Exam N10-005 / Lammle ........................................................................35 CompTIA Network+ Total Test Prep: A Comprehensive Approach to the CompTIA Network+ Certification Exam / Lammle ........36 CompTIA Project+ Study Guide Authorized Courseware: Exam PK0-003 / Heldman .........................................................................37 CompTIA Security+ Certification Kit Recommended Courseware: Exam SY0-301, 3rd Edition / Dulaney ........................................39 CompTIA Security+ Deluxe Study Guide Recommended Courseware: Exam SY0-301 / Dulaney......................................................37 CompTIA Security+ eTestPrep Authorized Courseware: Exam SY0-301 / Dulaney ............................................................................ 38 CompTIA Security+ Review Guide: Exam SY0-301, Includes CD, 2nd Edition / Stewart .................................................................... 38 CompTIA Security+ Study Guide Authorized Courseware: Exam SY0-301, 5th Edition / Dulaney .....................................................37

MOAC = MICROSOFT OFFICIAL ACADEMIC COURSE 52

www.wiley.com/go/certcatalog

INDEX

CompTIA Security+ Total Test Prep: A Comprehensive Approach to the CompTIA Security+ Certification / Dulaney ................... 38 CompTIA Strata Study Guide Authorized Courseware: Exams FC0-U41, FC0-U11, and FC0-U21 / Smith .........................................32 Configuring Advanced Windows Server 2012 Services: Exam 70-412 / MOAC ...................................................................................16 Configuring Windows 8: Exam 70-687 / MOAC .....................................................................................................................................21 CVOICE 8.0: Implementing Cisco Unified Communications Voice over IP and QoS v8.0 (Exam 642-437), with CD / Froehlich .......31 CWAP Certified Wireless Analysis Professional Official Study Guide: Exam PW0-270 / Westcott.....................................................41 CWDP Certified Wireless Design Professional Official Study Guide: Exam PW0-250 / Jackman .......................................................41 CWNA: Certified Wireless Network Administrator Official Study Guide: Exam PW0-105, 3rd Edition / Coleman .......................... 40 CWSP Certified Wireless Security Professional Official Study Guide: Exam PW0-204 / Coleman .....................................................41 CWTS: Certified Wireless Technology Specialist Official Study Guide: (PW0-071), 2nd Edition / Bartz ........................................... 40

D Data Storage Networking: Real World Skills for the CompTIA Storage+ Certification and Beyond / Poulton ................................. 40 Designing and Developing ASP.NET Applications Using the Microsoft .NET Framework 3.5, Package: Exam 70-564 / MOAC .....22

E EnCase Computer Forensics -- The Official EnCE: EnCase Certified Examiner Study Guide, 3rd Edition / Bunting ........................42

I Installing and Configuring Windows Server 2012: Exam 70-410 / MOAC ............................................................................................15 Introduction to Networking with Network+ / Pintello ..........................................................................................................................10

J Java SE 7 Programming Essentials / Ernest .......................................................................................................................................... 48

L Linux Essentials / Smith .......................................................................................................................................................................... 44 LPIC-1: Linux Professional Institute Certification Study Guide: (Exams 101 and 102), 3rd Edition / Smith........................................ 44 LPIC-2 Linux Professional Institute Certification Study Guide: Exams 201 and 202 / Smith .............................................................. 44

M Managing and Maintaining Windows 8: Exam 70-688 / MOAC ............................................................................................................21 MCSA Windows Server 2012 Complete Study Guide: Exams 70-410, 70-411, 70-412, and 70-417 / Panek ...................................... 46 MCSA: Microsoft Windows 8 Complete Study Guide: Exams 70-687 and 70-688 / Tidrow .............................................................. 46 Microsoft .NET Framework 3.5, ASP.NET Application Development, Package: Exam 70-562 / MOAC ............................................22 Microsoft .NET Framework Application Development Foundation, Package: Exam 70-536 / MOAC ...............................................22 Microsoft Access 2010 with Microsoft Office 2010 Evaluation Software: Exam 77-885 / MOAC .......................................................24 Microsoft Access 2013: Exam 77-424 / MOAC .......................................................................................................................................26 Microsoft Excel 2010 with Microsoft Office 2010 Evaluation Software: Exam 77-882 / MOAC..........................................................23 Microsoft Excel 2013: Exam 77-420 / MOAC .........................................................................................................................................25 Microsoft Exchange Server 2007 Configuration with Lab Manual Set: Exam 70-236 / MOAC ...........................................................17 Microsoft Office 2010 with Microsoft Office 2010 Evaluation Software / MOAC................................................................................24

www.wiley.com/go/certcatalog

INDEX

Microsoft Office 2013 / MOAC ...............................................................................................................................................................26 Microsoft Office SharePoint 2010 Configuration with Lab Manual Set: Exam 70-667 / MOAC ..........................................................18 Microsoft Outlook 2010 with Microsoft Office 2010 Evaluation Software: Exam 77-884 / MOAC .....................................................23 Microsoft Outlook 2013: Exam 77-423 / MOAC.....................................................................................................................................25 Microsoft PowerPoint 2010, with Microsoft Office 2010 Evaluation Software: Exam 77-883 / MOAC ..............................................23 Microsoft PowerPoint 2013: Exam 77-422 / MOAC ...............................................................................................................................25 Microsoft Project 2010 / MOAC..............................................................................................................................................................24 Microsoft Project 2013 / MOAC ..............................................................................................................................................................26 Microsoft SQL Server 2005 Implementation and Maintenance Lab Manual: Exam 70-431 / MOAC .................................................17 Microsoft SQL Server 2008 Implementation and Maintenance with Lab Manual Set: Exam 70-432 / MOAC ...................................17 Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463) / Carpenter ............................................................................................................................................................................ 46 Microsoft SQL Server Database Design and Optimization with Lab Manual Set: Exams 70-443 & 70-450 / MOAC ........................18 Microsoft Windows Networking Essentials / Gibson ........................................................................................................................... 45 Microsoft Windows Operating System Essentials / Carpenter ............................................................................................................ 45 Microsoft Windows Security Essentials / Gibson .................................................................................................................................. 45 Microsoft Windows Server Administration Essentials / Carpenter...................................................................................................... 45 Microsoft Word 2010: Exam 77-881 / MOAC .........................................................................................................................................23 Microsoft Word 2013: Exam 77-418 / MOAC .........................................................................................................................................25 MTA Database Administration Fundamentals: Exam 98-364 / MOAC ...................................................................................................9 MTA Gaming Development Fundamentals: Exam 98-374 / MOAC ......................................................................................................10 MTA HTML5 Application Development Fundamentals: Exam 98-375 / MOAC ...................................................................................10 MTA Microsoft .NET Fundamentals: Exam 98-372 / MOAC....................................................................................................................9 MTA Mobile Development Fundamentals: Exam 98-373 / MOAC ........................................................................................................10 MTA Networking Fundamentals: Exam 98-366 / MOAC .........................................................................................................................9 MTA Software Development Fundamentals: Exam 98-361 / MOAC ......................................................................................................8 MTA Windows Development Fundamentals: Exam 98-362 / MOAC .....................................................................................................8 MTA Windows Operating System Fundamentals: Exam 98-349 / MOAC ..............................................................................................8 MTA Windows Server Administration Fundamentals: Exam 98-365 / MOAC ........................................................................................9

O OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062 / Thomas ......................47 OCP: Oracle Database 12c Administrator Certified Professional Study Guide: Exam 1Z0-063 / Freeman ........................................47

P PMP: Project Management Professional eTestPrep / Heldman ............................................................................................................50 PMP: Project Management Professional Exam Study Guide, 7th Edition / Heldman ..........................................................................50 Project Management Workbook and PMP / CAPM Exam Study Guide, 11th Edition / Kerzner .........................................................51 Project Management: A Systems Approach to Planning, Scheduling, and Controlling, 11th Edition / Kerzner ................................51 Project Management: Case Studies, 4th Edition / Kerzner ...................................................................................................................51

MOAC = MICROSOFT OFFICIAL ACADEMIC COURSE 54

www.wiley.com/go/certcatalog

INDEX

Q Querying Microsoft SQL Server 2012: Exam 70-461 / MOAC...............................................................................................................19

S SCJP: Sun Certified Programmer for Java Platform Study Guide: SE6 (Exam CX-310-065) / Raposa .............................................. 48 Security Administrator Street Smarts: A Real World Guide to CompTIA Security+ Skills, 3rd Edition / Miller................................. 38 Security Fundamentals: Exam 98-367 / MOAC ........................................................................................................................................9 Supporting and Troubleshooting Applications on a Windows Vista Client for Enterprise Support Technicians with Lab Manual Set: Exam 70-622 / MOAC ..........................................................................................................................................................................20

V VCP-DCV: VMware Certified Professional-Datacenter Virtualization on vSphere Study Guide / Atkinson........................................49 VCP5 VMware Certified Professional on vSphere 5 Study Guide: Exam VCP-510 / Atkinson .............................................................49

W Web Development Fundamentals: Exam 98-363 / MOAC ......................................................................................................................8 Windows 7 Configuration with Lab Manual Set: Exam 70-680 / MOAC...............................................................................................20 Windows 7 Enterprise Desktop Support Technician Revised and Expanded Version with Lab Manual Set: Exam 70-685 / MOAC 21 Windows Server 2008 Active Directory Configuration, with Lab Manual Set: Exam 70-640 / MOAC ...............................................14 Windows Server 2008 Administrator with Lab Manual Set: Exam 70-646 / MOAC ............................................................................15 Windows Server 2008 Applications Infrastructure Configuration, Lab Manual Set: Exam 70-643 / MOAC ......................................14 Windows Server 2008 Enterprise Administrator with Lab Manual Set: Exam 70-647 / MOAC ..........................................................15 Windows Server 2008 Network Infrastructure Configuration with Lab Manual Set: Exam 70-642 / MOAC .....................................14 Windows Vista Configuration with Lab Manual Set: Exam 70-620 / MOAC ........................................................................................20

Y Your Project Management Coach: Best Practices for Managing Projects in the Real World / Biafore ...............................................50

www.wiley.com/go/certcatalog

111 River Street, Hoboken, NJ 07030-5774

One size does not fit all. That’s why Wiley Custom Select gives you the freedom to create your course materials exactly the way you want them.

You have the option to create a text online in just 3 easy steps: 1. Search & Select Browse from our extensive collection of Wiley content and select just what you need.

2. Customize Make the book your own by selecting your output method, creating a cover, arranging the sequence of content, and you can even upload your own materials.

3. Preview & Submit At any time you can preview a full version of what your book will look like and when you’re ready, submit your book and we’ll take care of the rest.

Want help getting started? Watch a short, step-by-step demo of how to build customized course materials at: www.wiley.com/college/wcsdemo.

customselect.wiley.com