2013 certification text catalogue

IT CertificationIT Certification2013

Comprehensive Courseware For:• LearningProviders• Instructors• Students

Table of Contents

Sybex Courseware Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . 3Cisco . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 - 7CompTIA . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 - 11LPI (LinuxProfessionalInstitute) . . . . . . . . . . . . . . . . . . . . . . . . . 16CWNP (Certified Wireless Network Professional) . . . . . . . . . . . . . . . 17Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19PMI (Project Management Institute) . . . . . . . . . . . . . . . . . . . . . . 21Guidance Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22EC-Council . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22VCP VMware . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22ISACA (Information Systems Audit and Control Association) . . . . . . . 23(ISC)2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23ITIL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23PRINCE2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23Microsoft . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 - 27

Microsoft Official Academic Course - MOAC

Office. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 - 31Microsoft Technology Associate (MTA) Certification . . . . . . . 34 - 35Wiley Faculty Network . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

IT Professional . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 - 42WileyPlus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43

Microsoft IT Certification Academy Roadmap . . . . . . . . . . . . . . . . . . . . . 44 - 45

Microsoft IT Academy Program . . . . 46 - 47

2

For InstructorsInstructorresourcesareprovidedforallSybexStudyGuides 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: • PowerpointPresentations • ClassroomExercises • AnnotatedSyllabus • Testbanks

For StudentsSybexStudyGuidesarecompletetextbooksthatprovidecomprehensivecoverageofofficialexamobjectives. Written by IT professionals, for IT professionals, they develop critical skills alongside real-world insights to provide knowledge and understanding of the technology.

Study Guides include: • In-depthcoverageofallcertificationexam

objectives • OpeningChapterobjectives • Helpful‘Tips’featurethroughouteachchapter • End-of-sectionexercises • End-of-chapteroverviewandchecklist • End-of-chapterquizquestions • Flashcardstoreinforceknowledgeand increase confidence (available from sybex.com) • TestEnginesoftware(availablefrom sybex.com)

Custom EditionsLetusknowifyouwouldlikeyourveryowncourseware with branding and content bespoke for your organisation and programme of learning: • Includeexistingoroutofprintcontentfrom other Wiley books, or other publishers • Addincoursematerialsyouhavewritten yourself • Getyourlogowhereyouwantitfora professional finishThis allows you to focus on learning objectives with instructor and student resources in one place…

OTHERRESOURCESAVAILABLETOHELPYOURSTUDENTSTheReviewGuidesandFastPassSeriesarestreamlined books that can be used in conjunction withtheSybexStudyGuidesasanadditionalstudytool for students. Packed with concise, objective-focusedcoverageandreviewquestionstheseguidesare the perfect supplement to any core certification text.

TheStreetSmartsandRealWorldseriesaredesigned to help students put their certification to work for them. Full of practical, real-world scenarios, the books feature actual tasks from the field and thenofferstep-by-stepexercisesthatteachtheskillsnecessarytocompletethosetasks.Theexercisesarebaseduponexamobjectivesfromleadingtechnologycertifications, each book is ideal as a lab manual for certification prep.

CERTIFICATIONKITSInvestintheSybexCertificationKitsandbeconfidentthat you have all of the tools you need to meet your objectives and get results. Each value priced kit will helptoprepareindepthfortheexams,practicewithrealworldscenariosandexercises,reviewandreinforce learning.

Logo Key: Instructor Supplements

3www.sybex.com/go/certification

www.sybex.com/go/certification

DigitalOptionsAvailable

4

Access our content…... anytime, anywhere

Most of the resources in this catalogue are also available digitally as e-books, in PDF, ePub and Mobi/Kindle formats.

Asthee-bookmarketcontinuesitsexplosivegrowthwewelcometheproliferation of devices and formats available to our customers and the new opportunities for partnership in delivering content.

For more information on how to download e-books, visit Wiley.com

We are taking advantage of technology to bring you the know-how you need, when you need it.

www.sybex.com/go/certification www.sybex.com/go/certification

Raspberry PI®

5

Raspberry Pi®

The best-selling essential guide to getting started with Raspberry Pi computing and programming

Raspberry Pi® User GuideEben Upton (co-creator of the Raspberry Pi) & Gareth Halfacree

ISBN: 978-1-118-46446-5

Raspberry Pi® ProjectsBy Andrew Robinson

ISBN: 978-1-1185-5543-9

A collection of 16 practical projects designed to be both fun and informative.

COMINGSOON!

6 www.sybex.com/go/certification

CISCO

CCENT: Cisco Certified Entry Networking Technician Study Guide: ICND1 (Exam 640‑822)

CCNA Cisco Certified Network Associate Review Guide: Exam 640‑802, includes CD

SERIOUS SKILLS.

TODD LAMMLE

CCNAEXAM 640-802

AA

· Targeted Review for the CCNA Exam

· The Perfect Companion to Any CCNA Learning Tool

Includes a CD with Two Practice Exams, Flashcards, and a Glossary of Key Terms

Cisco Certified Network Associatefi

REVIEW GUIDE

CCNA Cisco Certified Network Associate Study Guide: Exam 640‑802, includes CD‑ROM, 7th Edition

CCNA Cisco Certified Network Associate Certification Kit (640‑802) Set, Includes CDs, 7th EditionCisco Certifi ed

Network AssociateSTUDY GUIDE

Todd Lammle

Covers All Exam Objectives

CCNA®

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

• Custom Test Engine

• Hundreds of Sample Questions

• Video and Audio Instruction from Todd Lammle

• Electronic Flashcards

• Glossary of Terms in PDF

• Bonus CCNA Simulation Practice Guide e-book

Exam 640-802

SERIOUS SKILLS.

Seventh Edition

CCNA Virtual Lab, Titanium Edition 2.0: (Exam 640‑802)

Todd Lammle’s CCNA IOS Commands Survival Guide

Cisco Network Professional’s Advanced Internetworking Guide (CCNP Series)

CCNA Cisco Certified Network Associate Deluxe Study Guide, (Includes 2 CD‑ROMs), 6th Edition

Cisco® Certifi ed Network AssociateSTUDY GUIDE

Todd Lammle

Deluxe Edition

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

• Custom Test Engine with a Total of Eight Practice Exams


• Video and Audio Instruction from Todd Lammle


• Glossary of Terms in PDF

SERIOUS SKILLS.

Includes the CCNA Virtual Lab, Platinum Edition

Revised and Updated for 2011!

CCNA®

Exam 640-802Sixth Edition


7www.sybex.com/go/certification www.sybex.com/go/certification

CISCO

Cisco Networking Essentials

Troy McMillan

SERIOUS SKILLS.

Cisco NetworkingESSENT IALS

CCNA Security Study Guide: Exam 640‑553

CCNA Voice Study Guide: Exam 640‑460

SecuritySTUDY GUIDE

Tim Boyles

Covers All Exam Objectives for IINS 640-553

CCNA





• Entire Book in PDF

SERIOUS SKILLS.

IINS Exam 640-553

®

VoiceSTUDY GUIDE

Andrew Froehlich

Covers All Exam Objectives for IIUC Exam 640-460

CCNA






SERIOUS SKILLS.

IIUC Exam 640-460

AA

CCNA Wireless Study Guide: IUWNE Exam 640‑721

CVOICE 8.0: Implementing Cisco Unified Communications Voice over IP and QoS v8.0 Study Guide (642‑437), with CD

WirelessSTUDY GUIDE

Todd Lammle

Covers All Exam Objectives for IUWNE Exam 640-721

CCNA






SERIOUS SKILLS.

IUWNE Exam 640-721

®

Implementing Cisco Unifi ed Communications Voice over IP and QoS v8.0STUDY GUIDE

Andrew Froehlich


CVOICE 8.0

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




Exam 642-437

SERIOUS SKILLS.


www.sybex.com/go/certification8

An integrated practice test and study guide product, providing the perfect certification preparation

eTestPrep software includes the following features:

• Morethan700Questions with two test-taking modes, twice as many as most of the competing practice test providers. • Customizationoptions includingtheabilitytotestonspecificexamobjectivesand topic areas. • TwoExamModes - PracticeModeisatimedenvironmentsimilartoanactualliveexaminthatthe userdoesnotseecorrectanswersandexplanationuntiltestiscompleted. - LearningModeprovideslinkstocontextualanswersfromtheSybexStudyGuide e-book to create a truly integrated learning environment

The eTestPrep software is available on a CD, or can be purchased and downloaded directly to the user’s desktop from Sybex.com

For more information view our video at www.sybex.com/go/etestprep

CompTIA Security+ eTestPrep (SY0-301)

ISBN 9781118271780Available Jun 2012

CompTIA Network+ eTestPrep (N10-005)

ISBN 9781118271773Available Aug 2012

CompTIA A+ eTestPrep (220-801 and 220-802)

ISBN 9781118388419Available ?

CCNA eTestPrep (640-802)

ISBN 9781118271766Available Jun 2012


CompTIA Basic Series and Professional (+) Series

9

CompTIA Strata Study Guide

Andrew SmithFaithe Wempen


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



• Practice Tests for Each Exam


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

APPRO V E D Q U A L I T Y C O N TEN

T

STUDY GUIDE

CompTIA A+ Complete Deluxe Study Guide 2nd Edition (Exams 220‑801 and 220‑802)

CompTIA A+ Complete Review Guide, 2nd Edition (ExamTBD)

COMPLETE DELUXE STUDY GUIDE

Quentin Docter, Emmett Dulaney, and Toby Skandier

SERIOUS SKILLS.

Includes Real World Scenarios, Hands-On Exercises, and

a Deluxe CD Featuring:

+ Custom Test Engine with Eight Practice Exams

+ Hundreds of Sample Questions

+ Over an Hour of Instructor-led Videos on Key Topics

+ Electronic Flashcards

+ Entire Book in ePDF, Mobi, and ePub formats

Second Edition EXAM 220-801EXAM 220-802

SERIOUS SKILLS.

Emmett Dulaney

COMPLETE REVIEW GUIDESecond Edition

+ Targeted Review for the CompTIA A+ Exam

+ Includes Access to a Full Set of Online Review Tools

+ The Perfect Companion to Any CompTIA A+ Learning Tool

EXAM 220-801EXAM 220-802

CompTIA A+ Complete Study Guide (Exams 220‑801 and 220‑802)COMPLETE STUDY GUIDE


T

Quentin Docter, Emmett Dulaney, and Toby Skandier

SERIOUS SKILLS.

Includes Real-World Scenarios, Hands-On Exercises,

and Access to Exam Prep Software Featuring:

+ Custom Test Engine with Four Practice Exams

+ Over 300 Sample Questions


EXAM 220-801EXAM 220-802

Second Edition

CompTIA A+ Complete Lab Manual

COMPLETE LAB MANUAL

EXAM 220-801EXAM 220-802

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

Real-world scenarios put those skills in perspective

James Pyles

SERIOUS SKILLS.

CompTIACloud Essentials: (CompTIA

Authorized Courseware for Exam CLO-001)



CompTIA Professional (+) Series

10

CompTIA Network+ Study Guide: Exam N10‑005STUDY GUIDE


T

Todd Lammle

SERIOUS SKILLS.



+ Custom Test Engine

+ Hundreds of Practice Questions


EXAM N10-005Second Edition

CompTIA Network+ Deluxe Study Guide: Exam: N10‑005, 2nd EditionDELUXE STUDY GUIDE

Todd Lammle

SERIOUS SKILLS.

Includes Real-World Scenarios, Hands-On Exercises, and

a Deluxe CD Featuring:

+ Custom Test Engine with Six Practice Exams

+ Hundreds of Sample Questions

+ Exclusive Network+ Virtual Lab Network Simulator


+ Entire Book in ePDF, Mobi, and ePub formats

EXAM N10-005Second Edition

CompTIA Network+ Review Guide: Exam: N10‑005, 2nd Edition

SERIOUS SKILLS.

Bill Ferguson

REVIEW GUIDE

EXAM N10-005

Second Edition

+ Targeted Review Tool for the CompTIA Network+ Exam

+ The Perfect Companion to Any Network+ Learning Tool

CompTIA

Netw

ork +Com

pTIA Security +

CompTIA Network+ Lab Manual (Exam N10‑005)

LAB MANUAL

EXAM N10-005


Real-world scenarios put those skills in perspective

Toby Skandier

SERIOUS SKILLS.

CompTIA Network+ Certification Kit: Exam N10‑005, 3rd Edition

CompTIA Security+ Study Guide: Exam SY0‑301, 5th Edition

CompTIA Security+ Review Guide: Exam SY0‑301, Includes CD, 2nd Edition

STUDY GUIDE

Emmett Dulaney

Covers All Objectives for the SY0-301 Exam!

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


• Over 300 Sample Questions • Electronic Flashcards

Exam SY0-301Fifth Edition


T

SERIOUS SKILLS.

JAMES MICHAEL STEWART

Security+REVIEW GUIDE

EXAM SY0-301

SECOND EDITION

CompTIA®AA

· 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



CompTIA Professional (+) Series and Mastery Series

11

CompTIA

Security +

CompTIA Security+ Deluxe Study Guide: Exam SY0‑301, 2nd Edition

CompTIA Security+ Certification Kit: Exam SY0‑301, Includes CD Set, 3rd Edition

DeluxeSTUDY GUIDE

Emmett Dulaney

Deluxe Editionwith exclusive Security+ training software!




• Five Complete Practice Exams


• Bonus Videos, Study Tools, and More

Exam SY0-301 Second Edition

Study and prepare in depth for the exam

Practice with real-world scenarios and exercises

Review and reinforce with targeted review tool

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

Certifi cation Kit

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

The Complete Study Tool for CompTIA Security+™ Certifi cation Candidates

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

purchased individually!

STUDY GUIDE

Emmett Dulaney

Covers All Objectives for the SY0-301 Exam!


and Leading-Edge Exam Prep Software Featuring:

Exam SY0-301Fifth Edition

APPR O V E D Q U A L I T Y C O NTEN

T

SERIOUS SKILLS.

JAMES MICHAEL STEWART

Security+REVIEW GUIDE

EXAM SY0-301

SECOND EDITION

CompTIA®

™

· 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

+ STREET SMARTS A Real World Guide to CompTIA Security+™ Skills

David R. MillerMichael Gregg

fro

m b

oo

k s

mar

ts t

o s

t ree

t sm

arts


Real world scenarios put those skills in perspective

SERIOUS 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 01 )

Exam SY0-301

Third Edition

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

A Real World Guide to CompTIA®

Security+™ Skills

David RR. MillerMichael Gregg

fro

m b

oo

k sm

arts

to

str

eet

smar

ts

Steepp-bbyy-stepp exerciises teach yyou hands-on skills

Real world scenarios put those skills in ppersppective

SERIOUS 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 01 )

CompTIA Linux+ Study Guide, 2nd Edition (LX0-101 and LX0-102)

CompTIA Project+ Study Guide: Exam PK0‑003

STUDY GUIDE

Kim HeldmanWilliam Heldman

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






T

Exam PK0-003

Covers All Exam Objectives for Exam PK0-003

CASP CompTIA Advanced Security Practitioner Study Guide: Exam CAS‑001STUDY GUIDE

Michael Gregg and Billy Haines

SERIOUS SKILLS.






CASPCompTIA AdvancedSecurity Practitioner

EXAM CAS-001

CompTIA

Mastery

CompTIA

Linux+

CompTIA

Project +



TheSybexEssentialsSeries

12

The Sybex Essentials Series We’ve done the hard work for you

Microsoft Windows Networking EssentialsExam98-3669781118016855 May-11

Microsoft Windows Security EssentialsExam98-3679781118016848 Jun-11

Microsoft Windows Server Administration EssentialsExam98-3659781118016862 Aug-11

Microsoft Windows Operating System EssentialsExam98-3499781118195529 Feb-12

Microsoft Essentials...

For more information on any of the Essentials guides and to download our free instructor resources contact, [email protected]

The Essentials series from Sybex gives you the tools you need to help aspiring technology professionals gain the fundamental skills they need to begin their career as an IT administrator.

Each Essentialsguideexplainsthecoreconcepts of key technologies, then uses a task-based approach and step-by-step exercisestohelpyourstudentsacquirethe skills that they need in preparing for the corresponding MTA certification exams.

Key Features:• Introduction to the core Windows networking, security and administration topics with an emphasis on fundamental understanding.

• 300-400 pages of content focused on the most important concepts

• Four- colour graphics that richly illustrate every topic

• FullCoverageofallMTAexamobjectives

• The Essentials and Beyond - a wrap-up sidebar with a chapter summary and additionalexercises

• Lay-flatbindingthatisconvenientfor classroom lab activities


TheSybexEssentialsSeries

13

The Sybex Essentials Series We’ve done the hard work for you

Cisco Networking Essentials9781118097595 Dec-11

Linux EssentialsExam98-3679781118106792 Mar-12

VirtualizationEssentials9781118176719 Apr-12

Cloud Essentials: (CompTIAAuthorizedCourseware for Exam CLO-001)ExamCLO-0019781118408735 Apr-13

OtherEssentialsfromSybex...

For more information on any of the Essentials guides and to download our free instructor resources contact, [email protected]

How these Essentials help you, the Instructor:Complete instructor resources are provided for all Essentials titles, enabling you, the instructor, to be readytoteach,quicklyandeasily.Theseelectronicresources help you deliver learning objectives to your students without the need to invest a lot of time, money and energy into course development.

Instructor resources consist of:1. Annotated syllabus2. PowerPoint presentations organised by chapter3. Bonusquestionbanks4. Classroomexercisesandactivities

1. 2.

3.4.


We have the keys to your new Office

Peter Weverka

8 IN 1BOOKSBOOKS

®

®

®

®

Office 2013Microsoft®

A L L - I N - O N E

Making Everything Easier!™

f

Wallace Wang

Learn to: Use the newest versions of Word, Excel, PowerPoint, and Access

Work with spreadsheets, data, and databases

Organize your calendar and e-mail

Add flair to your documents and create powerful presentations



Elaine Marmel


Microsoft®

Office 2013

W R I T T E N B Y

LISA A. BUCKI MICHAEL R. GROH

JOHN WALKENBACHFAITHE WEMPEN

EXPLORE THE LATEST TOOLS AND FEATURES

MASTER INSIDE TRICKS AND BEST PRACTICES

DISCOVER WHAT YOU NEED, WHEN YOU NEED IT

Peter WeverkaAuthor of Office 2013 All-in-One For Dummies

6 IN 1BOOKSBOOKS

®

®

®

Office Home and Student 2013

Microsoft®

A L L - I N - O N E



A Complete Training Package!

Microsoft®

Word 2013

W R I T T E N B Y

LISA A. BUCKI




Elaine Marmel

Word 2013Microsoft®

James H. Russell

Learn to:Take advantage of this powerful Microsoft Office application

Create notes from scratch and add electronic files

Index your notes for easy searching

Use OneNote on your Windows 8-powered tablet

OneNote 2013


Bill Dyszel

Learn to:Set up your e-mail, create distribution lists, and manage contacts

Secure your information and eliminate junk mail and spam

Keep track of your calendar and stay organized with Notes

Assign tasks and collaborate with other users

Outlook 2013Microsoft®


Microsoft®

PowerPoint 2013

W R I T T E N B Y

FAITHE WEMPEN




Doug Lowe

Learn to:Create a slide presentation with charts, clip art, sound, and video

Work with master slides and templates

Use all the newest enhancements and features

IN FULL COLOR!

PowerPoint® 2013Microsoft®


William Wood

PowerPoint 2013Microsoft®

9781118516362March 2013

9781118497159March 2013

9781118517680April 2013

9781118516379April 2013

9781118497111May 2013

9781118517178April 2013

9781118488096June 2013

9781118568477June 2013

9781118488126April 2013

9781118517697April 2013

9781118491232March 2013

9781118550564May 2013

9781118490464March 2013

9781118517697April 2013

9781118491232March 2013

9781118550564May 2013

www.sybex.com/go/certification www.sybex.com/go/certification 15

Let us show you around all the new features and functions with our huge range of expert guides

Joseph Schmuller, PhD

Learn to:Understand common statistical terms

Interpret sales figures, gambling odds, sports stats, and more

Use Excel formulas, functions, charts, and PivotTables

Develop a grading curve or medical correlations

Statistical Analysis with Excel

3rd EditionMaking Everything Easier!™

Ken BluttmanAuthor of Excel Charts For Dummies®

Learn to:Use functions and understand how they work within a formula

Take advantage of 150 built-in Excel functions

Evaluate investment performance or forecast college expenses

Compare 15- vs. 30-year mortgage rates

Excel® Formulas and Functions

3rd EditionMaking Everything Easier!™

Dashboards & Reports

Second Edition

Excel Microsoft® ®

John Walkenbach

Excel® 2013 Formulas

Microsoft® Microsoft

Step-by-step instructions for easy learning

e L E A R N I N G K I T

Includes: Book, CD, or both — pick the way you learn best

Four hours of Excel 2013 instruction

Easy-to-follow format that lets you learn at your own pace

Faithe Wempen4-hour training course4-hour training course

Excel® 2013Microsoft®

John Walkenbach

Excel® 2013Power Programming with VBA

Microsoft®

Faithe Wempen

Access 2013Microsoft®

Microsoft®

Access 2013

W R I T T E N B Y

MICHAEL ALEXANDER

DICK KUSLEIKA

CREATE TABLES AND DESIGN DATABASES

INTEGRATE ACCESS WITH OTHER APPLICATIONS

BUILD FORMS AND REPORTS TO VIEW AND SHARE DATA

Laurie Ulrich Fuller

Learn to:Navigate the Access interface and understand database architecture

Build tables to organize data and forms for easy data entry

Share data and create forms and reports

Use the power of queries to find and maintain your data

Access® 2013Microsoft®


Alison BarrowsJoseph StockmanAllen Taylor

9 IN 1BOOKSBOOKS

Access® 2013Microsoft®

A L L - I N - O N E


9781118490365March 2013

9781118510100March 2013

9781118510124Feb 2013

9781118460849March 2013

9781118464311April 2013

9781118505397March 2013

9781118490372March 2013

9781118490396April 2013

9781118490426May 2013

9781118490440April 2013

9781118505427April 2013

9781118493045July 2013

9781118517703May 2013

9781118490358May 2013

9781118516386April 2013

9781118510551April 2013


LPI

16

LPI

LPIC‑2 Linux Professional Institute Certification Study Guide: Exams 201 and 202

Linux Professional Institute Certifi cation STUDY GUIDE

Roderick W. Smith

Covers Both the 201 and 202 Exams!

LPIC-2


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

Exams 201 and 202

SERIOUS SKILLS.

Linux Essentials

Roderick W. Smith

SERIOUS SKILLS.

LinuxESSENT IALS

Red Hat Enterprise Linux 6 Administration: Real World Skills for Red Hat Administrators

LPIC-1: Linux Professional Institute Certification Study Guide: (Exams 101 and 102), 3rd Edition

Linux Administrator Street Smarts: A Real World Guide to Linux Certification Skills



CWNP

17

CWSP Certified Wireless Security Professional Official Study Guide: Exam PW0‑204David D. Coleman

David A. WestcottBryan E. HarkinsShawn M. Jackman

Certifi ed Wireless Security Professional Offi cial Study Guide

CWSP®




• Case Studies and Demo Software

SERIOUS SKILLS.

Exam PW0-204

Offi cial Study Guide

CWDP Certified Wireless Design Professional Official Study Guide: Exam PW0‑250

Shawn M. Jackman, CWNE #54

Marcus Burton, CWNE #78

Matt Swartz, CWNE #57

Thomas W. Head

Certifi ed Wireless Design ProfessionalOffi cial Study Guide

CWDP™

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

• Two full-length practice exams

• Over 100 electronic fl ashcards

SERIOUS SKILLS.

Exam PW0-250


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

CWNA: Certified Wireless Network Administrator Official Study Guide: Exam PW0-105, 3rd EditionDavid D. Coleman, CWNE #4

David A. Westcott, CWNE #7

Certified Wireless Network AdministratorOfficial Study GuideThird Edition

CWNA®


SERIOUS SKILLS.

Exam PW0-105

Official Study Guide

CWAP Certified Wireless Analysis Professional Official Study Guide: Exam PW0‑270David A. Westcott, CWNE #7

David D. Coleman, CWNE #4

Peter Mackenzie, CWNE #33

Ben Miller, CWNE #12

Certifi ed Wireless Analysis ProfessionalOffi cial Study Guide

CWAP®


• Two full-length practice exams

• Over 150 electronic fl ashcards

SERIOUS SKILLS.

Exam PW0-270


CBAP / CCBA Certified Business Analysis Study Guide

Certifi ed Business AnalysisSTUDY GUIDE

Susan WeeseTerri Wagner


CBAP®/CCBA

™



• Four Practice Exams


• Over 100 Electronic Flashcards

SERIOUS SKILLS.

CWN

P



Adobe Creative Suite 6 Books from WileyGet the big picture on Adobe’s entire Creative Suite! From full coverage of CS6 Design Premium and the new Adobe Muse to the latest on Photoshop, Illustrator, Dreamweaver, InDesign, and Flash, Wiley has Adobe CS5 and 6 guides for every level of designer.

Adobe Photoshop CS6 EssentialsAug-12 9781118094952

Adobe Flash Professional CS6 EssentialsJul-12 9781118129654

Adobe Photoshop CS6 Digital ClassroomJun-12 9781118123898

To see our full range of Adobe titles, scan the QR code with your phone or tablet, or visit, http://lp.wileypub.com/adobecs6/index.html

Adobe Creative Suite 6 Design and Web Premium Digital ClassroomJun-12 9781118124055

Premiere Pro CS6 Digital ClassroomDec-12 9781118494547

Adobe After Effects CS6 Digital ClassroomJun-12 9781118142790


Oracle

19

OCP: Oracle Database 11g Administrator Certified Professional Certification Kit: (1Z0‑051, 1Z0‑052, and 1Z0‑053)

OCP: Oracle Database 11g Administrator Certified Professional Study Guide: (Exam 1Z0‑053)

SCJP: Sun Certified Programmer for Java Platform Study Guide: SE6 (Exam CX‑310‑065)

OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0‑051 and 1Z0‑052)

Complete Java™ 2 Certification Study Guide, 5th Edition

Oracle



IT Career Jumpstart is an ideal starting point for anyone looking for a career in IT but doesn’t know where to start.

• Includes a discussion of the key computer components, such as the processor and memory.

• Covers the basics of data storage as well as the input/output process.

• Zeroes in on basic hardware and configuration including how to install hardware and software drivers.

• Introduces various computer operating systems, including the Windows OS family, Linux, and Mac.

• Looks at basic networking concepts and design.

LaunchYourITCareer-Quickly and Effectively

In-Depth Coverage for Anyone Considering a Career in IT!AValuableReferenceandResourceforThoseAlreadyintheIndustry!

ISBN 978-1-118-20615-7January 2012


PMI

21

PMP Project Management Professional Exam Study Guide, 6th Edition

Project ManagementProfessional ExamSTUDY GUIDE

Kim Heldman

Includes Over Two Hours of Bonus Audio on the CD

PMP




• Chapter Review in Audio Format


SERIOUS SKILLS.

Sixth Edition

®

Updated forthe 2011

PMP Exam

PMP Project Management Professional Exam Certification Kit, 2nd Edition

Project Management

Professional Exam

STUDY GUIDEKim Heldman

Includes Over Two Hours of Bonus

Audio on the CD

PMP

Includes Real-World Scenarios

and Leading-Edge Exam Prep

Software Featuring:

SERIOUS SKILLS.

Sixth Edition

®

Updated forthe 2011 PMP exam

STREET SMARTSA Real World Guide to PMP

®

Skills

Linda Kretz Zaval, PMP®

Terri Wagner, PMP®

from

boo

k sm

arts

to

stre

et s

mar

ts



SERIOUS SKILLS.

project manager

2 N D E D I T I O N - R E V I S E D F O R T H E 2 011 P M P ® E X A M

from

boo

k sm

arts

to

stre

et s

mar

ts

SERIOUS SKILLS.

KIM HELDMAN, PMP®

VANINA MANGANO, PMP®

· Targeted Review for the New 2011 PMP® Exam· The Perfect Companion to Any PMP® Learning Tool Includes a CD with Two Practice Exams, Flashcards, and a Glossary of Key Terms

PMP

®

Project Management Professional ExamREVIEW GUIDESECOND EDITION

SERIOUS SKILLS.

PMPProject Management Professional Exam Certifi cation Kit

A trio of books to help you prepare for the PMP Certifi cation Exam

Kim Heldman, Vanina Mangano,

Linda Kretz Zaval, and Terri Wagner

Second Edition

®

$10 U.S. off suggested retail price of books

purchased individually!

The Complete Study Tool for PMP® Certifi cation Candidates

Project Manager Street Smarts: A Real World Guide to PMP Skills, 2nd Edition

PgMPSM: Program Management Professional Exam Study Guide

STREET SMARTSA Real World Guide to PMP

®

Skills

Linda Kretz Zaval, PMP®

Terri Wagner, PMP®

from

boo

k sm

arts

to

stre

et s

mar

ts



SERIOUS SKILLS.

project manager

2 N D E D I T I O N - R E V I S E D F O R T H E 2 011 P M P ® E X A M

PMI

NEW 7th EDITION

OUTSEPTEMBER

2013

PMP Practice Makes Perfect: Over 1000 PMP Practice Questions and Answers

PMP: Project Management Professional Exam Review Guide, 2nd Edition

SERIOUS SKILLS.

KIM HELDMAN, PMP®

VANINA MANGANO, PMP®

· Targeted Review for the New 2011 PMP® Exam

· The Perfect Companion to Any PMP® Learning Tool

Includes a CD with Two Practice Exams, Flashcards, and a Glossary of Key Terms

PMP

®

Project Management Professional Exam

REVIEW GUIDESECOND EDITION



GuidanceSoftware/ECCouncil/VCP

22

Guidance Softw

areVCP

EC Council

EnCase Computer Forensics - The Official EnCE: EnCase Certified Examiner Study Guide, 3rd Edition

STUDY GUIDE

Steve Bunting

SERIOUS SKILLS.

+ In-deptch Preparation for the EnCase®

Certified Examiner (EnCE) Exam

+ The Only Official EnCE Certification

Study Guide on the Market

+ Technically Reviewed and Approved by

Guidance Software™

+ Access to Practice Tests, Flashcards,

Evidence Files, EnCase® Legal Journal,

and more

THIRD EDITION

EnCE®

EnCase Computer Forensics:The Official EnCase Certified Examiner

CEH™: Official Certified Ethical Hacker Review Guide: Exam 312‑50

CEH Certified Ethical Hacker Study Guide

Certifi edEthical HackerSTUDY GUIDE

Kimberly Graves

Covers all Exam Objectives for CEHv6

CEH™






SERIOUS SKILLS.

Exam 312-50Exam EC0-350

VCP VMware Certified Professional on vSphere 4 Study Guide: Exam VCP‑410

VCP VMware Certified Professional on vSphere 4 Review Guide: (Exam VCP‑410)

VMware® Certifi edProfessional on vSphere™ 4STUDY GUIDE

Brian PerryChris HussJeantet Fields

Covers All Exam Objectives for Exam VCP-410

VCP






Exam VCP-410

SERIOUS SKILLS. SeriouS SkillS.

BRIAN PERRY, CHRIS HUSS,JEANTET FIELDS, TROY MCMILLAN

VCPExAM VCP-410

VCP: VMware Certified Professional on vSphere 5 Study Guide (Exam TBD)STUDY GUIDE

Brian Atkinson

SERIOUS SKILLS.






VCPVMware Certified Professional on vSphere 5

EXAM VCP-510



ISACA/ISC/ITIL/PRINCE2

23

ISCPRIN

CE2ITIL

ITIL Foundation Exam Study GuideStudy Guide

SeriouS SkillS.



+ Custom test engine


+ electronic Flashcards

itiL®

v3 Foundation exam

FOundatiOn

Liz Gallacher and Helen Morris

PRINCE2 Study Guide

STUDY GUIDE

David Hinde


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

Prince2 Foundation Certification Prince2 Practitioner Certification

SERIOUS SKILLS.

PRINCE2®

CISA Certified Information Systems Auditor Study Guide, 3rd Edition

Certifi ed InformationSystems Auditor® STUDY GUIDE

David L. Cannon

Over 500 Review Questions

CISA®

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





SERIOUS SKILLS.

Third Edition

ISACA

CISSP: Certified Information Systems Security Professional Study Guide, 6th Edition

CISSP Practice: 2,250 Questions, Answers, and Explanations for Passing the Test

CISSP Practice

®

S. Rao Vallabhaneni

2,250 Questions, Answers, and Explanations for Passing the Test

TIMELY. PRACTICAL. RELIABLE.



Microsoft

24

Microsoft

Microsoft Windows Server Administration Essentials

Microsoft Windows Operating System Essentials

Microsoft Windows Networking Essentials

Microsoft Windows Security Essentials

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

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

Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

MCTS Microsoft Windows 7 Configuration Study Guide: Exam 70‑680, Study Guide, 2nd Edition

Microsoft® Windows® 7ConfigurationSTUDY GUIDE

William Panek

MCTS





• Video Demonstrations

Exam 70-680

SERIOUS SKILLS.

Covers All Exam Objectives for Exam 70-680

Second Edition



Microsoft

25

Microsoft

Windows 7 Desktop Support and Administration: Real World Skills for MCITP Certification and Beyond (Exams 70‑685 and 70‑686)

Darril Gibson

SERIOUS SKILLS.

Real World Skills for MCITP Certification and Beyond

Windows® 7Desktop Supportand Administration

Microsoft®

Exams 70-685 and 70-686

MCTS Microsoft SharePoint 2010 Configuration Study Guide: Exam 70‑667

Microsoft® SharePoint®

2010 Confi gurationSTUDY GUIDE

James Pyles


MCTS






Exam 70-667

SERIOUS SKILLS.

MCTS

Microsoft

® SharePoint®

2010 Confi guration

STUDY GUIDE

Pyles

Exam 70-667

SYBEX TEST ENGINETest your knowledge with advanced testing software. Includes chapter review questions and practice exams.

ELECTRONIC FLASHCARDSReinforce your understanding with electronic fl ashcards.

Also on CD, you’ll fi nd the entire book in searchable and printable PDF. Study any-where, any time, and approach the exam with confi dence.

FEATURED ON THE CD

C A T E G O R YCOMPUTERS/Certifi cation Guides

ISBN: 978-0-470-62701-3

Validate your skills in SharePoint, achieve your MCTS certifi cation, and enhance your IT career when you pass Microsoft’s newest SharePoint exam, Microsoft SharePoint 2010, Confi guring (Exam 70-667). This in-depth study guide prepares you with thorough coverage of all exam objectives, including installing, deploying, confi guring, and upgrading SharePoint Server 2010—and much more. Inside, you’ll fi nd:

Full coverage of all exam objectives in a systematic approach, so you can be confi dent you’re getting the instruction you need for the exam

Practical hands-on exercises to reinforce critical skills

Real-world scenarios that put what you’ve learned in the context of actual job roles

Challenging review questions in each chapter to prepare you for exam day

Exam Essentials, a key feature in each chapter that identifi es critical areas you must become profi cient in before taking the exam

A handy tear card that maps every offi cial exam objective to thecorresponding chapter in the book, so you can track your examprep objective by objective

James Pyles is an experienced author, instructor, and consultant, and currently worksas a technical writer for Keynetics, Inc. He has been involved in numerous Ethernet rolloutprojects, software and hardware installations and upgrades, and Windows and UNIXoperating system upgrades. Previously he was a developmental editor for Global Support Content Operations at HP. He has authored or coauthored several books, including MCTS: Microsoft SharePoint Server 2007 Confi guration Study Guide and PC Technician Street Smarts: A Real World Guide to CompTIA A+ Skills, Second Edition.

The preparation you need for Exam 70-667

$59.99 US$71.99 CN

A B O U T T H E A U T H O R

Look inside for complete coverage of all exam objectives.

www.sybex.com/go/mctssharepoint2010

spine=1.344”

Microsoft SharePoint 2010 Administration: Real World Skills for MCITP Certification and Beyond (Exam 70‑668)

Tom CarpenterJames Pyles

SERIOUS SKILLS.


SharePoint® 2010Administration

Microsoft®

Exam 70-668

Project 2010 Project Management: Real World Skills for Certification and Beyond (Exam 70‑178)

Robert Happy, PMP, MCT

SERIOUS SKILLS.

Real World Skills for Certification and Beyond

Project 2010Project Management

Microsoft®

Exam 77-178

Exchange Server 2010 Administration: Real World Skills for MCITP Certification and Beyond (Exams 70‑662 and 70‑663)

Joel StidleyErik Gustafson

SERIOUS SKILLS.


Exchange Server 2010Administration

Microsoft®

Exam 70-662Exam 70-663

Covers Exchange Server

2010 SP1

SQL Server 2008 Administration: Real‑World Skills for MCITP Certification and Beyond (Exams 70‑432 and 70‑450)

Tom Carpenter

SERIOUS SKILLS.

Real-World Skills for MCITP Certification and Beyond

SQL Server® 2008Administration

Microsoft®

Exams 70-432 and 70-450

MCTS Windows Server 2008 Active Directory Configuration Study Guide: Exam 70‑640

MCTS: Windows Server 2008 Network Infrastructure Configuration Study Guide: Exam 70‑642



MicrosoftM

icrosoft

MCTS: Microsoft Office SharePoint Server 2007 Configuration Study Guide: Exam 70‑630

MCTS: Microsoft Exchange Server 2007 Configuration Study Guide: Exam 70‑236

MCTS: Microsoft Exchange Server 2007 Configuration Study Guide: Exam 70‑236, 2nd Edition

MCITP: Windows Server 2008 Server Administrator Certification Kit

MCTS: Windows Server 2008 Applications Infrastructure Configuration Study Guide: Exam 70‑643

MCTS: Windows Server 2008 R2 Complete Study Guide (Exams 70‑640, 70‑642 and 70‑643)

Windows Server® 2008 R2CompleteSTUDY GUIDE

William Panek

Covers Three Exams in One Book

MCTS


• Custom Test Engine• Hundreds of Sample Questions • Six Practice Exams• Electronic Flashcards • Glossary of Terms in PDF Format

Exam 70-640 Exam 70-642Exam 70-643

SERIOUS SKILLS.

MCITP: Windows Server 2008 Server Administrator Study Guide: (Exam 70‑646)

MCITP: Windows Server 2008 Enterprise Administrator Study Guide: (Exam 70‑647)


www.sybex.com/go/certification www.sybex.com/go/certification 27

Microsoft MicrosoftM

icrosoft

MCTS Windows SharePoint Services 3.0 Configuration Study Guide: Exam 70‑631

MCTS: Windows Server Virtualization Configuration Study Guide: (Exam 70‑652)

Windows® SharePoint® Services 3.0 Confi gurationSTUDY GUIDE

Marilyn Miller-WhitePaul StorkKris Wagner


MCTS






Exam 70-631

SERIOUS SKILLS.



CompTIA Professional (+) Series and Mastery Series

2 www.sybex.com/go/certification

ForDUMMIES

28

eLearning Kits make learning easier!

A unique book-and-CD package lets your customers learn from a full-colour

book, and interactive CD, or both!

Seeking certification? Look no further than these books to give you the information you need to succeed!

Making Everything Easier

www.wiley.com/go/MOAC


CompTIA Professional (+) Series and Mastery Series CompTIA Professional (+) Series and Mastery Series

3www.sybex.com/go/certification 29

MOACTableofContents

Office. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 - 31

Microsoft Technology Associate (MTA) Certification . . . . 34 - 35

Wiley Faculty Network . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

IT Professional . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 - 42

WileyPlus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43

Microsoft IT Certification Academy Roadmap . . . . . . . . 44 - 45

Microsoft IT Academy Program . . . . . . . . . . . . . . . . . . 46 - 47



Office

30

Office

Logo Key: Available as Textbook Available as Lab Manual

MOAC WORD (10)77-881 Wrd10

Microsoft®

MOAC POWERPOINT (13)PowerPoint 2013

MOAC POWERPOINT (10)77-883 Ppt10

Microsoft® PowerPoint®

MOAC EXCEL (10)77-882 Exc10

Microsoft® Excel® 2010MOS Exam 77-882

MOAC EXCEL (13)Excel 2013

MOAC WORD (13)Word 2013

MOAC OUTLOOK (13)Outlook 2013

MOAC OUTLOOK (10)77-884 Otlk10

Microsoft® Outlook® 2010MOS Exam 77-884

Coming Soon!

Coming Soon!

Coming Soon!

Coming Soon!

www.wiley.com/go/MOAC www.wiley.com/go/MOAC

Office Office

31

MOAC OFFICE (10)Offc10

Microsoft®

MOAC PROJECT (13)Project 2010

Microsoft® Project 2010

MOAC PROJECT (10)Project 2010

Office


MOAC OFFICE (13)Offc13

MOAC ACCESS (10)77-885 Acc10

Microsoft® Access® 2010MOS Exam 77-885

MOAC ACCESS (13)Access 2013Coming Soon!

Coming Soon!

Coming Soon!

www.wiley.com/go/MOAC32

MOAC Labs Online, Today’s Cutting Edge Teaching Technology

MOAC Labs Online address the most pervasive challenges facing schools, instructors, and students today. 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 provide real solutions for these demands.

Don’t miss this opportunity to lower your costs, eliminate the hassle of lab setup and support, and improve student access and portability with the latest technology from Microsoft by adopting MOAC Labs Online for your networking program!

Want to know more?Call your MOAC Sales Consultant today

or visit www.wiley.com/college/microsoft

Exam Title Print Textbook MOAC Labs Online purchased separately

70-640: Windows® Server 2008 Active 9780470225097 978-0-470-46859-3 Directory Configuration

70-642: Windows® Server 2008 9780470225158 978-0-470-46864-7 Network Infrastructure Configuration

70-643: Windows® Server 2008 9780470225134 978-0-470-46861-6 Applications Infrastructure Configuration

70-646: Windows® Server 2008 Administrator 9780470225110 978-0-470-46856-2

70-647: Windows Server 2008 Enterprise 9780470225165 978-1-118-15757-2 Administrator

70-443 & 70-450: Microsoft SQL Server 9780470183656 978-1-118-14021-5 Database Design and Optimization

70-667 Microsoft Office SharePoint 2010 9780470538678 978-1-118-28133-8 Configuration

70-680: Windows 7 Configuration 9780470875094 978-0-470-87977-1

70-685: Windows 7 Enterprise Desktop 9781118134504 978-1-118-14022-2 Support Technician, Revised and Expanded

www.wiley.com/go/MOAC www.wiley.com/go/MOAC 33


Microsoft Technology Associate (MTA) Certification

34

Microsoft Technology A

ssociate (MTA

) Certification


MOAC MTA HTML5 APP DEV (1)98-375 HTML5 App Dev Fund

MOAC MTA DATABASE ADMINISTRATION FUNDAME (1)98-364 DB Adm Fund

MOAC MTA NET FUNDAMENTALS (1)98-372 MS .NET Fund

MTA Exam 98-372

Microsoft .NETFundamentals

MOAC MTA GAMING DEVELOPMENT FUNDAMENTALS (1)98-374 Gaming Dev Fund

MOAC MTA MOBILE DEVELOPMENT FUNDAMENTALS (1)98-373 Mobile Dev Fund

MTA Exam 98-374

Gaming Development Fundamentals

MTA Exam 98-373

Mobile Development Fundamentals

MOAC MTA NETWORKING FUNDAMENTALS (1)98-366 Netwk Fund

MOAC MTA SERVER ADMINISTRATION FUNDAMENT (1)98-365 Win Svr Adm Fund

MOAC MTA SECURITY FUNDAMENTALS (1)98-367 Sec Fund


Microsoft Technology Associate (MTA) Certification Microsoft Technology Associate (MTA) Certification / Adobe

35

MOAC MTA WINDOWS DEVELOPER FUNDAMENTALS (1)98-362 Win Dev Fund

MOAC MTA WINDOWS OS FUNDAMENTALS (1)98-349 Win OS Fund

MTA Exam 98-349

Windows Operating System

Fundamentals

MOAC MTA WEB DEVELOPER FUNDAMENTALS (1)98-363 Web Dev Fund

MOAC MTA SOFTWARE DEVELOPMENT FUNDAMENTA (1)98-361 Sftw Dev Fund

Microsoft Technology A

ssociate (MTA

) Certification / Adobe


ACA PHOTOSHOP (1)Intro Phtshp CS6 ACA

Complete Coverage of the Adobe®

® ® CS6

Introduction to Adobe® Photoshop® CS6

ACA FLASH PROFESSIONAL (1)Intro Flash CS6 ACA


® ®

Introduction to Adobe® Flash® Professional CS6

ACA DREAMWEAVER (1)Intro Drmwvr CS6 ACA


® Dreamweaver® CS6

Introduction to Adobe® Dreamweaver® CS6


Wiley Faculty Network

Discover innovative ideas and gain knowledge you can use.

Learn from instructors around the world, as well as recognized leaders across disciplines. Join thousands of faculty just like you who participate in Online Events each semester. You’ll connect with fresh ideas, best practices, and practical tools for a wide range of timely topics. • Guest Lectures• Author Keynotes• Product Info & Training Sessions

Connect with colleagues – your greatest resource.

Tap into your greatest resource: your peers. Exchange ideas and teaching tools, while broadening your perspective. Whether you choose to blog, join interest groups, or connect with a Mentor, you’ve come to the right place.• Connect with Colleagues• Find a Mentor• Interest Groups• Blog

The Wiley Faculty Network (WFN) is a global community of faculty connected by a passion for teaching and a drive to learn, share, and collaborate.

Whether you’re seeking guidance, training, and resources or simply looking to re-energize your course, you’ll find what you need with the WFN. The WFN also partners with institutions to provide customized professional development opportunities. Connect with the Wiley Faculty Network to collaborate with your colleagues, find a Mentor, attend Online Events, and view a wealth of resources all designed to help you grow as an educator.

The Wiley Faculty Network… you belong here!Get connected at www.WhereFacultyConnect.com

Explore your resources and development opportunities.

See all that is available to you when you connect with the Wiley Faculty Network. From Learning Modules and Archived Online Events to faculty development and peer-reviewed resources, there is a wealth of materials at your fingertips.• Teaching Resources• Archived Online Events • Learning Modules

Embrace the art of teaching - great things happen where faculty connect!


Microsoft IT Professional

37

Wiley Faculty Network


IT Professional

38

IT Professional


MOAC WINDOWS SERVER 2012 70-410 (1)70-410 Install & Confg Win Svr12 LM

PINTELLO NETWORK+ (1)Intro Netwk Net+

Timothy Pintello

Introduction to Networking with Network +

MOAC WINDOWS SERVER 2012 70-411 (1)70-411 Admin Win Svr12 LM

MOAC WINDOWS SERVER 2012 70-410 (1)70-410 Install & Confg Win Svr12

MOAC WINDOWS SERVER 2012 70-411 (1)70-411 Admin Win Svr12

Craig Zacker

MOAC WINDOWS SERVER 2012-70-412 (1)70-412 Confg Adv Win Svr12 Svcs

MOAC QUERYING SQL SERVER 2012 70-461 (1)70-461 Query SQL Svr12

MOAC WINDOWS SERVER 2012-70-412 (1)70-412 Confg Adv Win Svr12 Svcs LM

Coming Soon!

Coming Soon!

Coming Soon!

Coming Soon!

Coming Soon!


IT Professional IT Professional

39

MOAC WINDOWS 7 70-680 (1)70-680 Win7 Confg LM

MOAC ADMINISTER SQL SERVER 2012 70-462 (1)70-462 Admin SQL Svr12 DB LM

MOAC WINDOWS 7 70-680 (1)70-680 Win7 Confg

MOAC ADMINISTER SQL SERVER 2012 70-462 (1)70-462 Admin SQL Svr12 DB

MOAC QUERYING SQL SERVER 2012 70-461 (1)70-461 Query SQL Svr12 LM

IT Professional


MOAC WINDOWS 7 70-685 (2)70-685 Win7 Supp Tech Rev & Exp

MOAC WINDOWS 8 70-687 (1)70-687 Confg Win8

MOAC WINDOWS 7 70-685 (2)70-685 Win7 Supp Tech Rev & Exp LM

Lab Manual

Evalu

ation Software Inside W

indows Server 2008 Enterprise

®

EEEEEEEEEEEEEEEEEEEvvvvvvvvvvaaaaaaaalllllluuuuuuu

aaaaatttttttiiiiiiiiooooonnnn SSSSSooooooooffffffffttttttwwwwwwwwwaaaaaaarrreee IIIInnnnsssssssiiiiiddddddddeeeeeeeeeeeeeeeeeeeWWWWWWWWWWWWWWWWWWWWWWW

iiiiiiiiiiinnnndddddddddooooooowwwwwssss SSSSSSeeerrrrrrvvvvvveeeeeeeeerrrrrrr 22222222222200000000000000088888888888888888 EEEEEEEEEEEEEEnnnnnnnnnnnnnnnnttttttttttttttteeeeeeeeeerrrrrrppppppprriisssssseeeeeee

®®®®®®Charles DeSassureConsulting Editor

Coming Soon!

Coming Soon!Coming Soon!

Coming Soon!


IT Professional

40

IT Professional


MOAC WINDOWS 8 70-688 (1)70-688 Mang & Maint Win8 LM

MOAC WINDOWS 8 70-687 (1)70-687 Confg Win8 LM

MOAC WINDOWS SERVER 2008 70-640 (1)70-640 Win Svr08 Act Dir LM

MOAC WINDOWS 8 70-688 (1)70-688 Mang & Maint Win8

MOAC WINDOWS SERVER 2008 70-640 (1)70-640 Win Svr08 Act Dir

MOAC WINDOWS SERVER 2008 70-642 (1)70-642 Win Svr08 Netwk Confg

MOAC WINDOWS SERVER 2008 70-643 (1)70-643 Win Svr08 App Confg

MOAC WINDOWS SERVER 2008 70-642 (1)70-642 Win Svr08 Netwk Confg LM

Coming Soon!

Coming Soon!

Coming Soon!


IT Professional IT Professional

41

MOAC WINDOWS SERVER 2008 70-647 (1)70-647 Win Svr08 Entrprs Adm LM

Of cial Academic Course

Lab Manual

MOAC WINDOWS SERVER 2008 70-646 (1)70-646 Win Svr08 Adm LM

Lab Manual

MOAC WINDOWS SERVER 2008 70-647 (1)70-647 Win Svr08 Entrprs Adm


Evalu

ation Software Inside

Windows Server 2008®

MOAC WINDOWS SERVER 2008 70-646 (1)70-646 Win Svr08 Adm

Evalu

ation Software Inside W

indows Server 2008 Enterprise®

MOAC WINDOWS SERVER 2008 70-643 (1)70-643 Win Svr08 App Confg LM

IT Professional


MOAC .NET 3.5 70-536 (1)70-536 .NET Fndtn

MOAC .NET 3.5 70-564 (1)70-564 .NET Dsgn & Dev


Lab Manual

MOAC .NET 3.5 70-562 (1)70-562 .NET App Dev


IT Professional

42

IT Professional


MOAC SHAREPOINT 2010 70-667 (1)70-667 Shrpt10 Confg

MOAC EXCHANGE 2007 70-236 (1)70-236 Exchg Svr07 Confg

MOAC SQL 2005 70-431 (1)70-431 SQL Svr05 Imp & Mnt

MOAC EXCHANGE 2007 70-236 (1)70-236 Exchg Svr07 Confg LM

MOAC SHAREPOINT 2010 70-667 (1)70-667 Shrpt10 Confg LM

Lab Manual

MOAC SQL 2005 70-431 (1)70-431 SQL Svr05 Imp & Mnt LM

MOAC SQL 2008 70-450 (1)70-443/450 SQL Svr Dsgn & Opt LM

MOAC SQL 2008 70-450 (1)70-443/450 SQL Svr Dsgn & Opt


IT Professional WileyPLUS

43

2 www.wiley.com/college/microsoft

Table of ConTenTs

Microsoft official acadeMic courseWare (Moac)

MTa . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

network+ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

IT Professional . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

Windows Server 2008. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .14

Windows Server 2003. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15

Other Servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15

Windows Client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17

Developer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .19

Microsoft office specialist . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20

sybex

Cisco® . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .23

CompTIA®. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .28

CWNP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .35

EC-Council . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38

Guidance Software. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .39

HRCI®. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .40

IIBA . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41

ISACA® . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .42

(ISC)2® . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43

LPI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44

Microsoft® . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .45

Oracle® . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .52

Java . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53

PMI®. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .54

VMware, Inc. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .57

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.

for more information, visit www .wileyplus .com

catalog icons

Coursesmart

Vitalsource

Wiley Custom select

Instructor supplements

WileyPlUs


MCSEDesktop Infrastructure

MOS MasterMicrosoft Office 2010

415 Implementing a Desktop Infrastructure

416 Implementing Desktop Application Environments

MCSEServer Infrastructure

MCSEPrivate Cloud

246 Monitoring and Operating a Private Cloud with System Center 2012

247 Configuring and Deploying a Private Cloud with System Center 2012

MCSEData Platform

MCSEBusiness Intelligence

467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012

MCSDWindows Store Apps–C#

485 Advanced Windows Store App Development using C#

484 Essentials of Developing Windows Store Apps using C#

MCSDWindows Store Apps–HTML5

483 Programming in C#

MCSDWeb Apps

461 Querying Microsoft SQL Server 2012

462 Administering Microsoft SQL Server 2012 Databases

463 Implementing a Data Warehouse with Microsoft SQL Server 2012

464 Developing Microsoft SQL Server 2012 Databases

466 Implementing Data Models and Reports with Microsoft SQL Server 2012

481 Essentials of Developing Windows Store Apps using HTML5 and JavaScript

482 Advanced Windows StoreApp Development using HTML5 and JavaScript

486 Developing ASP.NET 4.5 MVC Web Applications

487 Developing Windows Azure and Web Services

480 Programming in HTML5 with JavaScript and CSS3

465 Designing Database Solutions for Microsoft SQL Server 2012

410 Installing and Configuring Windows Server 2012

MTA 349: Windows OS Fundamentals 365: Windows Server Administration Fundamentals 366: Networking Fundamentals367: Security Fundamentals


MTA 364: Database Fundamentals

411 Administering Windows Server 2012

412 Configuring Advanced Windows Server 2012 Services


413 Designing and Implementing a Server Infrastructure

414 Implementing an Advanced Server Infrastructure

Business

Client

Server

Database

Development

Certification Destinations:

MCSASQL Server 2012

MCSAWindows Server 2012

MCSAWindows 8

687 Configuring Windows 8

688 Managing and Maintaining Windows 8

Microsoft IT Academy (ITA) Program provides students with the technology skills they need to be successful in college and a career. With Microsoft Certification, students can validate those skills and pursue a career path in business or technology. ITA Program members receive attractive price reductions on Microsoft Certification exams so they can enable skills development and certification for their students globally.

Secondary Students:Microsoft Office Specialist (MOS)Students pursuing a career using client-side productivity applications for business or IT should pursue MOS certification. MOS certification validates mastery of Microsoft Office skills that all businesses require, setting students apart as they go on to higher education or enter the workforce.

Microsoft Technology Associate (MTA)For a technology career, students should start with MTA certification, which validates core technology concepts in infrastructure, database and development. MTA helps students explore technology for today's popular IT careers. MTA is recommended, but not required, prior to pursuing a deeper technical certification path. MTA certification may be earned in one semester and can be used to demonstrate capability and commitment for entry-level IT positions.

2-year Post-Secondary Students:Microsoft Certified Solutions Associate (MCSA)The MCSA certification is recommended for 2-year program students and those who already have some knowledge of IT. MCSA validates deeper skills on Microsoft technology and cloud computing, and allows students to gain experience in a classroom setting versus on the job. MCSA is required for becoming an MCSE.

4-Year Post-Secondary Students:Microsoft Certified Solutions Expert (MCSE) / Microsoft Certified Solutions Developer (MCSD)The MCSE and MCSD certifications are recommended for students in a 4-year program. The MCSE builds off of the experience gained while achieving the MCSA certification, and further develops an individual’s expertise in cloud technologies. The MCSD builds off of MTA development fundamentals. MCSE and MCSD certifications allow students to acquire additional experience developing, deploying and maintaining full technology solutions in a classroom setting versus on the job. Upon graduation and certification, a student will be in a competitive position for a mid-level IT job.

Microsoft Official Course and Exam NumberOfficial training courses and exams are available through Microsoft Learning Partners worldwide.

Microsoft Technology AssociateNon-compulsory training courses and exams that help prepare individuals for professional certification.MTA exams and classroom content are included as benefits within the Microsoft IT Academy Program subscription.

Microsoft Certified Solutions AssociateMCSA certification validates core platform skills and is required to achieve MCSE certification.

Microsoft Office SpecialistMOS certification enables individuals to tap the full functionality of the Microsoft Office programs.

For more information visit www.microsoft.com/itacademy

Start by choosing your certification and career path

Microsoft IT Academy Certification Roadmap

MTA361: Software Development Fundamentals362: Windows Development Fundamentals 363: Web Development Fundamentals372: .Net Fundamentals 375: HTML5 Application Development Fundamentals

Core Exam choose one:881: Word882: Excel 883: PowerPoint 884: Outlook

Expert Exam choose one:887: Microsoft Word (Expert)888: Microsoft Excel (Expert)

883Microsoft PowerPoint

Elective Examchoose one:884: Outlook885: Access 886: SharePoint

MOS SpecialistSelected program

MOS ExpertWord or Excel885: Access

886: SharePoint 853: OneNote 891: Office 365

853: OneNote 891: Office 365


MCSEDesktop Infrastructure

MOS MasterMicrosoft Office 2010

415 Implementing a Desktop Infrastructure

416 Implementing Desktop Application Environments

MCSEServer Infrastructure

MCSEPrivate Cloud

246 Monitoring and Operating a Private Cloud with System Center 2012

247 Configuring and Deploying a Private Cloud with System Center 2012

MCSEData Platform

MCSEBusiness Intelligence

467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012

MCSDWindows Store Apps–C#

485 Advanced Windows Store App Development using C#

484 Essentials of Developing Windows Store Apps using C#

MCSDWindows Store Apps–HTML5

483 Programming in C#

MCSDWeb Apps

461 Querying Microsoft SQL Server 2012

462 Administering Microsoft SQL Server 2012 Databases

463 Implementing a Data Warehouse with Microsoft SQL Server 2012

464 Developing Microsoft SQL Server 2012 Databases

466 Implementing Data Models and Reports with Microsoft SQL Server 2012

481 Essentials of Developing Windows Store Apps using HTML5 and JavaScript

482 Advanced Windows StoreApp Development using HTML5 and JavaScript

486 Developing ASP.NET 4.5 MVC Web Applications

487 Developing Windows Azure and Web Services

480 Programming in HTML5 with JavaScript and CSS3

465 Designing Database Solutions for Microsoft SQL Server 2012

410 Installing and Configuring Windows Server 2012



MTA 364: Database Fundamentals

411 Administering Windows Server 2012



413 Designing and Implementing a Server Infrastructure

414 Implementing an Advanced Server Infrastructure

Business

Client

Server

Database

Development

Certification Destinations:

MCSASQL Server 2012

MCSAWindows Server 2012

MCSAWindows 8

687 Configuring Windows 8

688 Managing and Maintaining Windows 8

Microsoft IT Academy (ITA) Program provides students with the technology skills they need to be successful in college and a career. With Microsoft Certification, students can validate those skills and pursue a career path in business or technology. ITA Program members receive attractive price reductions on Microsoft Certification exams so they can enable skills development and certification for their students globally.

Secondary Students:Microsoft Office Specialist (MOS)Students pursuing a career using client-side productivity applications for business or IT should pursue MOS certification. MOS certification validates mastery of Microsoft Office skills that all businesses require, setting students apart as they go on to higher education or enter the workforce.

Microsoft Technology Associate (MTA)For a technology career, students should start with MTA certification, which validates core technology concepts in infrastructure, database and development. MTA helps students explore technology for today's popular IT careers. MTA is recommended, but not required, prior to pursuing a deeper technical certification path. MTA certification may be earned in one semester and can be used to demonstrate capability and commitment for entry-level IT positions.

2-year Post-Secondary Students:Microsoft Certified Solutions Associate (MCSA)The MCSA certification is recommended for 2-year program students and those who already have some knowledge of IT. MCSA validates deeper skills on Microsoft technology and cloud computing, and allows students to gain experience in a classroom setting versus on the job. MCSA is required for becoming an MCSE.

4-Year Post-Secondary Students:Microsoft Certified Solutions Expert (MCSE) / Microsoft Certified Solutions Developer (MCSD)The MCSE and MCSD certifications are recommended for students in a 4-year program. The MCSE builds off of the experience gained while achieving the MCSA certification, and further develops an individual’s expertise in cloud technologies. The MCSD builds off of MTA development fundamentals. MCSE and MCSD certifications allow students to acquire additional experience developing, deploying and maintaining full technology solutions in a classroom setting versus on the job. Upon graduation and certification, a student will be in a competitive position for a mid-level IT job.

Microsoft Official Course and Exam NumberOfficial training courses and exams are available through Microsoft Learning Partners worldwide.

Microsoft Technology AssociateNon-compulsory training courses and exams that help prepare individuals for professional certification.MTA exams and classroom content are included as benefits within the Microsoft IT Academy Program subscription.

Microsoft Certified Solutions AssociateMCSA certification validates core platform skills and is required to achieve MCSE certification.

Microsoft Office SpecialistMOS certification enables individuals to tap the full functionality of the Microsoft Office programs.

For more information visit www.microsoft.com/itacademy

Start by choosing your certification and career path

Microsoft IT Academy Certification Roadmap

MTA361: Software Development Fundamentals362: Windows Development Fundamentals 363: Web Development Fundamentals372: .Net Fundamentals 375: HTML5 Application Development Fundamentals

Core Exam choose one:881: Word882: Excel 883: PowerPoint 884: Outlook

Expert Exam choose one:887: Microsoft Word (Expert)888: Microsoft Excel (Expert)

883Microsoft PowerPoint

Elective Examchoose one:884: Outlook885: Access 886: SharePoint

MOS SpecialistSelected program

MOS ExpertWord or Excel885: Access

886: SharePoint 853: OneNote 891: Office 365

853: OneNote 891: Office 365


How a Microsoft it acadeMy MeMbersHip Helps your students.

Whatever career path your students take, a strong base of technology skills can help them be in greater demand with a wide variety of employers.

• Helps students succeed in the 21st century workforce by teaching them the technology skills that employers seek.

• Gives access to training that helps prepare students for certification on Microsoft applications.

• Offers hands-on experience with the latest Microsoft software and hundreds of web-based E-Learning courses from productivity applications to high-level programming.

80% of IT managers report their team requires a significant amount of task-specific skills to

perform assigned duties.

Over 10,000 Microsoft IT Academies are located in 160 countries.

Hear real life success stories at:

http://www.microsoft.com/ itacademy/success-stories.aspx

How a Microsoft it acadeMy MeMbersHip Helps your educators.

The Microsoft IT Academy Program provides educators and institutions with a comprehensive and cost-effective solution for teaching and learning about Microsoft technologies.

• Saves time with “ready-to-teach” solutions for industry leading Microsoft technologies.

• Easily integrate courses into new or existing curricula. Classes can be tailored to meet the needs of students of all ages and skill levels.

• World-class curriculum helps educators offer the hands-on skills and experience that today’s graduates need to succeed in any career.

• Access to professional development resources helps educators stay up to date with the latest technology.

wHy sHould My institution becoMe a Microsoft it acadeMy MeMber?• To keep pace with changing technology and curriculum demands through rich online resources available for learning anytime, anywhere.

• To assist educators with professional development opportunities to bridge their technology skills gap.

• To link academic learning to real-world job skills that enable students to graduate with technology skills required by today’s job market.

are your students prepared for a 21st century workforce?The Microsoft IT Academy is a subscription-based program designed for accredited academic institutions worldwide. It empowers educators to help students realize their skills and career potential through relevant, high-quality and the latest technology training resources.

* Impact of Training on Network Administration: Certification Leads to Operational Productivity

2009 IDC #220563

www.microsoftitacademy.com


Microsoft certification Helps validate tecHnology knowledge and skills.Internationally recognized Microsoft Certification is one of the most demanding and respected endorsements in the industry, stressing both technical knowledge and real-world experience.

Earning a Microsoft Certification can help your students and educators:• Gain a competitive edge in the job market.• Demonstrate their commitment to the IT profession.• Enable a career development path for ongoing advancement of Microsoft technology skills.

©2011 Microsoft Corporation. All Rights Reserved. This content is provided for informational purposes only and is provided “as-is”. Microsoft makes no warranties, express or implied. Microsoft is a trademark of the Microsoft group of companies

Microsoft® it academy program

is My institution eligible?

Microsoft IT Academy is available to accredited academic

primary, secondary, post-secondary, higher education institutions, universities, and preparatory

schools. Other eligible institutions include vocational, trade,

military academy, and technical education, as well as accredited sources of continuing education.

How do i get started?

Microsoft IT Academy can be acquired through the

following Microsoft Academic Volume Licensing programs:

Enrollment for Education Solutions (EES)

Open Value Subscriptionfor Education Solutions

(OVS-ES)

School Agreement

Academic Select Plus Agreement

For more information, please visit: http://www.microsoft.com/licensing/licensing-options/for-industries.aspx#tab=2

CurriCulumAccess to E-learning courses - E-Learning provides students with hands-on practice via a multimedia learning experience. Educators can use E-Learning to expand their own professional skills and to explore ways to improve classroom learning.

Access to E-reference library and Discounts on microsoft Press Products - Advanced IT Academy members receive 5 accounts to a special E-Reference Library with over 120 titles from Microsoft Press. All members receive discounts on E-Reference Library subscriptions, print books and E-Books from Microsoft Press.

Access to microsoft Digital literacy Curriculum - Essential computing skills curriculum for those new to computing as well as people interested in improving their current skills.

Academic pricing on Microsoft Official Academic Courses (MOAC) - A best-selling textbook series that provides a rich foundation for educators and students to expand their knowledge of Microsoft technologies and acquire the real-world skills they need to succeed in today’s technology careers.

Academic pricing on Microsoft Official Courseware (MOC) - Advanced IT Academy members get academic pricing on courseware intended for IT professionals and developers who build, support, and implement solutions by using Microsoft products and technologies.

miCrOSOFT CErTiFiCATiON

Academic pricing on Microsoft (MCP) Certification exams - Educators can stay current with the IT industry and students gain credentials to showcase proven skills on Microsoft technologies.

Microsoft Office Specialist Exam Vouchers (MOS) - Helps validate proficiency in using Microsoft Office 2010 and meets the demand for the most up-to-date skills on some of the latest Microsoft technologies. Ten MOS exam vouchers can be requested annually for professional development.

microsoft Technology Associate Exam Vouchers (MTA) - Entry-level exam and certification that validates essential building block knowledge for aspiring IT professionals and developers. Twenty MTA exam vouchers can be requested annually for professional development.

Become a Test Center - Microsoft IT Academy members are eligible to become a test center and offer Microsoft Certification exams to students and educators on campus.

EDuCATOr TOOlS

Access to the learning management System - Administer content and manage students’ progress with E-Learning online.

One free enrollment in Microsoft Certified Trainer program for an educator - Also includes a 25 percent discount on enrollments for any additional educators.

Access to lesson Plans - Downloadable and customizable lesson plans ad projects can help save class preparation time, personalized course completion certificates.

mArkETiNG rESOurCES

Access to marketing resources - Members receive access to the Microsoft IT Academy Program member logo and the ability to promote their institution in the Microsoft IT Academy locator tool. Additional marketing and promotional materials are available.

prograM benefits:

Note: Additional Microsoft IT Academy program benefits are available through Academic Volume Licensing programs.

The percentage of relevant certifications a team holds is a reliable measure of an IT team’s functional capability. Each new certification increases team performance*.

“The Microsoft IT Academy is a perfect example of how our state is leading the way in preparing high school students for college and career” Bill Harrison, Chairman, North Carolina State Board of Education.

*Impact of Training on Network Administration: Certification Leads to Operational Productivity 2009 IDC #220563

Email [email protected] for access to the free and customisable instructor resources, sample copiesfor evaluation purposes and to order your courseware. Natalie RichardsICT Certification Sales & Business Development Manager (EMEA)Tel: +44 (0) 7827 953158Email: [email protected]

Please send orders to: John Wiley & Sons Singapore Pte. Ltd.

CWT Commodity Hub, 24 Penjuru Road, #08-01, Singapore 609128Customer Service Hotline: (65) 6302 9800, Fax: (65) 6265 1782 or Email: [email protected]

For sales & marketing enquiries: Fax: (65) 6643 8008 or Email: [email protected] Homepage: http://www.wiley.com

ChinaBeijing

Shanghai Unit 1402-1404, 14/F Cross Tower No.318 Fuzhou Road, Huangpu District, Shanghai 20001, P.R. ChinaTel: (86 21) 51163377 Fax: (86 21) 63912077 [email protected]

Hong Kong Unit 2203, APEC Plaza, 49 Hoi Yuen Road Kwun Tong, Kowloon, Hong Kong Tel: (852) 2793 4652 Fax: (852) 2793 4663 [email protected]

India New Delhi 4435-36/7, Ansari Road, Daryaganj, New Delhi 110 002, India Tel: (91 11) 4 363 0000/01 Fax: (91 11) 2 327 5895 [email protected]

East India Tel: (91) 9973156158 [email protected]

Bangalore Tel: (91 80) 23132383 Fax: (91 80) 23124319 [email protected]

Mumbai Tel/Fax: (91 22) 27889272 (91 22) 27889263 [email protected]

Chennai Tel: (91) 98410 22399 [email protected]

Hyderabad Tel: (91) 98661 43949 [email protected]

Indonesia Ruko Golden Boulevard II, Block R/41 Jl. Pahlawan Seribu, Bumi Serpong Damai, Sector IV Com, Tangerang, Indonesia Tel: (62 21) 5316 3245 Fax: (62 21) 537 0309 [email protected]

Japan Frontier Koishikawa Bldg. 4F 1-28-1 Koishikawa, Bunkyo-kuTokyo 112-0002 JapanTel: (81 3) 3830 1232Fax: (81 3) 5689 [email protected] www.wiley.co.jp

MalaysiaUnit B-3A-3A, Menara BATA, PJ Trade CentreNo 8, Jalan PJU 8/8A, Bandar Damansara Perdana47800 Petaling Jaya, SelangorTel: (03) 7712 2000Fax: (03) 7722 [email protected] Philippines Unit C Ground Floor Belvedere Tower San Miguel Avenue, Ortigas Center Pasig City 1605, Philippines Tel: (63 2) 687 3186 Fax: (63 2) 687 3187 [email protected]

South Korea Suite 405, BR Elitel Building, #141-1 Sangsoo-Dong, Mapo-Gu, Seoul,121-828, Rep of Korea Tel: (82 2) 338 9700 Fax: (82 2) 337 1929 [email protected]

Taiwan 4F, 218 Sec 2 JinShan S Road Taipei 10643, Taiwan Tel: (886 2) 2357 3900 Fax: (886 2) 2391 1068 [email protected]

Thailand 41 Lertpanya Building 8th Floor, Suit No. 801 Soi Lertpanya, Sri-Ayudhaya Rd Tamboon Tanonphyathai, Rajathevee Bangkok 10400, Thailand Tel: (662) 642 7548 Fax: (662) 642 7549 [email protected]

Singapore1 Fusionopolis Walk #07-01Solaris South TowerSingapore 138628Tel: (65) 6643 8000Fax: (65) 6643 [email protected]

Australia & New Zealand For marketing, please contact155 Cremorne Street,Richmond Vic, 3121 AustraliaTel: (61) 3 9274 3100Fax: (61) 3 9274 3101

For orders in ANZ region, please contact: PO Box 3065Stafford BCQueensland, 4053AustraliaToll-free telephone: 1800 777 474Toll-free fax: 1800 802 [email protected]

Asian Publishing & Distribution Centre for ▲ Australia ▲ Bangladesh ▲ Brunei ▲ Cambodia ▲ Hong Kong ▲ India ▲ Indonesia ▲ Japan ▲ Laos ▲ Maldives ▲ Malaysia ▲ Mauritius ▲ Myanmar

▲ Nepal ▲ People’s Republic of China ▲ Philippines ▲ Singapore ▲ South Korea ▲ Sri Lanka ▲ Taiwan ▲ Thailand ▲ Vietnam

Wiley O c Region

Room 805-808, Floor 8, Sun Palace,No. 12A, Taiyanggong Middle RoadChaoyang District, Beijing, P.R. ChinaPostal code 100028Tel: (86) 10 8418 7800Fax: (86) 10 8418 [email protected]

12

-47

49

4

2013 certification text catalogue

Documents

learning objectives

certification prep

certification academy

wiley books

programme of learning

core certification text

sectionexercises end

student resources