Saturday, January 31, 2009

CCENT Exam Prep or Mastering VBA

CCENT Exam Prep (Exam 640-822)

Author: Jeremy Cioara

Your Complete Certification Solution

In this book you'll learn how to:

  • Understand the foundations of network communication as described in the OSI and TCP/IP models
  • Accurately design and troubleshoot networks using IP subnetting skills
  • Understand the operational components and models of Cisco® routers and switches
  • Perform basic navigation and configurations using Cisco IOS® Software and Cisco Secure Device Manager
  • Apply techniques to secure networks
  • Implement and troubleshoot Distance Vector (RIPv2) routing protocols
  • Implement and troubleshoot NAT, DHCP, and DNS operation on a router
  • Implement and secure wireless LANs (WLANs)
  • Implement and verify basic WAN links

CD Features New Simulation Questions!
The CD features innovative testing software powered by MeasureUp, an electronic copy of the book, and 75 minutes of video instruction that highlight five scenarios to help prepare for simlet questions on the new exams. The MeasureUp testing software gives you an effective tool to assess your readiness for the ICND1 exam:

  • Detailed explanations of correct and incorrect answers
  • Multiple test modes
  • Random questions and order of answers
  • Coverage of all CCENT™ ICND1 exam objectives



    Table of Contents:
    Cisco ICND1 Exam Objectives
    xxv
    Exam Descriptionxxv
    Exam Topicsxxv
      Describe the operation of data networksxxv
      Implement a small switched networkxxv
      Implement an IP addressing scheme and IP services to meet network requirements for a small branch officexxvi
      Implement a small routed networkxxvi
      Explain and select the appropriate administrative tasks required for a WLANxxvii
      Identify security threats to a network and describe general methods to mitigate those threatsxxvii
      Implement and verify WAN linksxxvii
    Introduction1
    How This Book Helps You1
    Network Hardware and Software Requirements3
    Advice on Taking the Exam4
    Chapter 1: Standard Internetworking Models7
    Introduction10
    What Is an Internetwork?10
    Types of Internetworks11
      Local Area Network (LAN)11
      Metropolitan Area Network (MAN)12
      Wide Area Network (WAN)12
      Storage Area Network (SAN)13
      Virtual Private Network (VPN)14
    Open Systems Interconnection (OSI) Model14
      Upper Layers15
      Application Layer15
      Presentation Layer17
      Session Layer18
      Lower Layers18
      Transport Layer18
      Network Layer20
    Data Link Layer21
      Physical Layer23
      OSI Layered Communications23
    TCP/IP Model25
      Application Layer26
      Transport Layer27
      Internet Layer31
      Network Interface Layer33
    Cisco 3-Layer Hierarchical Model33
      Access Layer34
      Distribution Layer35
      Core Layer35
    Chapter Summary37
      Key Terms37
    Apply Your Knowledge40
      Exercises40
      Review Questions41
      Exam Questions41
      Answers to Review Questions45
      Answers to Exam Questions47
      Suggested Readings and Resources49
    Chapter 2: Physical Layer Networking Concepts51
    Introduction54
    Network Topologies54
      The Bus Topology54
      The Ring Topology55
      The Star Topology56
      The Mesh Topology57
    Cabling58
      Coaxial Cable59
      Twisted-Pair Cable60
      Fiber-Optic Cable63
    Wireless64
      Wireless Fidelity (Wi-Fi)65
      Infrared65
      Bluetooth66
    Physical Layer Devices66
      Repeaters66
      Hubs67
      Network Interfaces67
    Chapter Summary68
      Key Terms68
    Apply Your Knowledge69
      Exercises69
      Review Questions70
      Exam Questions70
      Answers to Review Questions77
         Answers to Exam Questions77
      Suggested Readings and Resources79
    Chapter 3: Data Link Networking Concepts81
    Introduction84
    Data Link Protocols84
      Token Ring84
      FDDI86
      Ethernet at the Data Link Layer87
    Physical Ethernet Standards93
      Ethernet93
      Fast Ethernet96
      Gigabit Ethernet97
      10-Gigabit Ethernet (10GbE)99
      Long Reach Ethernet100
    Data Link Layer Devices100
      Bridges101
      Switches104
    Duplex105
    Microsegmentation106
    Chapter Summary107
      Key Terms107
    Apply Your Knowledge109
      Exercises109
      Review Questions110
      Exam Questions110
      Answers to Review Questions114
      Answers to Exam Questions115
      Suggested Readings and Resources117
    Chapter 4: General Network Security119
    Introduction122
    Classes of Attack122
      Access Attacks123
      Reconnaissance Attacks125
      Denial of Service (DoS) Attacks127
    Mitigating Network Threats130
      AAA130
      Cisco ACLs130
      Cisco IOS Secure Management Features131
      Encryption Protocols132
    Security Appliances and Applications132
    Chapter Summary134
      Key Terms134
    Apply Your Knowledge135
      Exercise135
      Review Questions136
      Exam Questions136
      Answers to Review Questions138
      Answers to Exam Questions138
      Suggested Readings and Resources139
    Chapter 5: IP at the Network Layer141
    Introduction144
    Network Layer Functions144
    IP Addressing and Formats145
      Binary145
      Hexadecimal150
      IP Address Classes151
      Subnet Masks154
      Private (RFC 1918) Addressing156
    Subnetting IP156
      Calculating Hosts in a Subnet159
      Calculating Networks in a Subnet161
      The Increment162
      Determining the Range of Valid IPs165
    Network Layer Devices167
      Routers167
      Layer 3 Switches170
    Chapter Summary171
      Key Terms171
    Apply Your Knowledge172
      Exercises172
      Review Questions175
      Exam Questions175
      Answers to Review Questions179
      Answers to Exam Questions181
      Suggested Readings and Resources183
    Chapter 6: Introduction to Cisco Routers and Switches185
    Introduction188
    Interfaces and Modules188
      LAN Interfaces188
      WAN Interfaces189
    Cisco Memory Components192
      ROM193
      Flash193
      RAM193
      NVRAM193
    Cisco Internetworking Operating System193
      Feature Sets194
      IOS Image File Naming195
    Cisco Router Models and Features196
    Cisco Switch Models and Features197
    Chapter Summary199
      Key Terms199
    Apply Your Knowledge200
      Exercises200
      Review Questions200
      Exam Questions201
      Answers to Review Questions203
      Answers to Exam Questions204
      Suggested Readings and Resources205
    Chapter 7: Foundation Cisco IOS Operations207
    Introduction210
    Terminal Options210
      Console Port210
      Auxiliary Port212
      Telnet212
      HTTP and HTTPS212
      SSH213
    Router/Switch Startup Procedures214
      POST214
      Bootstrap215
      IOS Loading215
      Configuration Loading217
    Navigating the IOS220
      User EXEC220
      Privileged EXEC221
      Global Configuration222
      Context-Sensitive Help224
      Abbreviations226
      Shortcut Keys226
      Common Syntax Errors227
    Chapter Summary230
      Key Terms231
    Apply Your Knowledge231
      Exercises231
      Review Questions233
      Exam Questions233
      Answers to Review Questions235
      Answers to Exam Questions236
      Suggested Readings and Resources237
    Chapter 8: Foundation Cisco Configurations239
    Introduction242
    Global Configuration242
      Altering the Boot Sequence242
      Changing the Hostname244
      Creating a Login Banner244
      Assigning a Password for Privileged EXEC Mode245
      Domain Name—Specific Commands246
      Enabling SSH247
    Line Configurations248
      Securing Console Access to User EXEC248
      Securing Auxiliary Access to User EXEC250
      Securing Telnet and SSH Access to User EXEC250
    Router Interface Configurations253
      Assigning an IP Address254
      Enabling the Interface255
      LAN-Specific Commands255
      WAN-Specific Commands256
    Saving Configurations256
    Using the show Command to Get Information258
      Verifying Your Configurations259
      Viewing Interface Statuses and Statistics260
      IOS File Version show Commands264
    Troubleshooting Commands266
    Backing Up and Restoring Configurations and IOS Using TFTP269
    Neighbor Discovery with CDP272
    Using Telnet for Virtual Terminal Access276
      Terminal Monitor277
    IOS DHCP278
    Chapter Summary281
      Key Terms282
    Apply Your Knowledge284
      Exercises284
     Review Questions285
      Exam Questions286
      Answers to Review Questions289
      Answers to Exam Questions290
      Suggested Readings and Resources291
    Chapter 9: Understanding the Cisco SDM293
    Introduction296
    Getting Started296
    Global Configurations298
      Changing the Hostname, Banner, Domain Name, and Secret Password299
      Router Access303
      DNS304
      DHCP305
    Router Interface Configurations308
      Assigning an IP Address308
      Enabling the Interface309
      Saving and Verifying Your Configurations310
    Monitoring310
    Chapter Summary312
      Key Terms312
    Apply Your Knowledge312
      Exercise312
      Review Questions312
      Exam Questions313
     Answers to Review Questions315
      Answers to Exam Questions316
      Suggested Readings and Resources316
    Chapter 10: Introduction to Routing and Routing Protocols317
    Introduction320
    The Default Gateway320
      Verifying and Troubleshooting the Default Gateway322
    Routing Sources323
      Administrative Distance324
    Static Routes325
      Configuring Static Routes326
      Floating Static Routes327
    Default Routes328
    Configuring Static and Default Routes with SDM329
    Verifying Static and Default Routes330
      Dynamic Routing Protocols331
      Routing Metrics332
      Classful and Classless Routing Updates333
    VLSM336
      Interior and Exterior Gateway Routing Protocols340
      Distance Vector Routing Protocols340
      Link-State Routing Protocols341
      Advanced Distance Vector/Hybrid Routing Protocols341
    The Routing Table Revisited342
    Routing Redistribution343
    Chapter Summary345
      Key Terms346
    Apply Your Knowledge347
      Exercises347
      Review Questions348
      Exam Questions348
      Answers to Review Questions351
      Answers to Exam Questions351
      Suggested Readings and Resources353
    Chapter 11: Distance Vector Routing Protocols355
    Introduction358
      Distance Vector Operations358
      Routing Loops360
    Routing Loop Mitigation362
      Counting to Infinity363
      Split Horizon363
      Route Poison, Poison Reverse, and Hold-Down Timers364
      Triggered Updates366
      Invalid/Dead Timers367
    RIP367
      RIP Characteristics367
      RIP Configuration368
      Passive Interfaces371
      RIPv2 Characteristics371
      RIPv2 Configuration372
      Configuring RIP with SDM373
      RIP Verification374
      Troubleshooting RIP375
    Chapter Summary379
      Key Terms380
    Apply Your Knowledge380
      Exercises380
      Review Questions382
      Exam Questions382
      Answers to Review Questions384
      Answers to Exam Questions385
      Suggested Readings and Resources386
    Chapter 12: Enabling Internet Connectivity with NAT387
    Introduction390
    NAT Concepts391
      Static NAT392
      Dynamic NAT393
      NAT Overload and Port Address Translation394
    NAT Terminology395
    Configuring NAT Using Cisco SDM397
      Configuring NAT Overload397
    Verifying NAT Configuration410
    Troubleshooting NAT413
    Chapter Summary415
      Key Terms415
      Review Questions416
    Apply Your Knowledge416
      Exam Questions416
      Answers to Review Questions419
      Answers to Exam Questions419
      Suggested Reading and Resources421
    Chapter 13: Foundation Switching Operations423
    Introduction426
      Switching Functionality426
    Frame Transmission Methods427
      Store-and-Forward428
      Cut-Through428
      Fragment-Free428
    Half- and Full-Duplex Connections429
    Switching Design430
    Spanning Tree Protocol430
      Root Bridge431
      Root Ports432
      Designated Ports434
      Blocked Ports435
    Port State Transitions437
    Initial Switch Configurations438
      Assigning a Management IP Address to a Switch439
      Defining a Default Gateway439
      IP Assignment Using DHCP440
      Configuring Multiple Switch Interfaces441
      Verifying Spanning Tree Protocol442
    Troubleshooting Basic Switch Connectivity442
    Chapter Summary445
      Key Terms445
    Apply Your Knowledge446
      Exercises446
      Review Questions448
      Exam Questions449
      Answers to Review Questions452
      Answers to Exam Questions452
    Suggested Readings and Resources454
    Chapter 14: Implementing Switch Security455
    Introduction458
    Securing Physical Access to the Catalyst Switch458
    Securing Terminal Access to the Catalyst Switch458
      To Telnet or Not to Telnet460
      Additional IOS Security Practices461
    Layer 2 Security461
      Port Security462
      “See”DP464
    Chapter Summary466
      Key Terms466
    Apply Your Knowledge467
      Exercises467
      Review Questions469
      Exam Questions469
      Answers to Review Questions471
      Answers to Exam Questions472
      Suggested Readings and Resources472
    Chapter 15: Understanding Wireless Networking473
    Introduction476
    The Business Case476
    The Players in the 802.11 Market477
    Entering the Radio Frequency World478
      Understanding Wireless Transmission478
      Unlicensed RF Bands479
      The Key to Successful Wireless: Channel Surfing480
    The 802.11 Standards Family483
      Party Like It’s 1999: 802.11a and 802.11b483
       2003 Delivers: 802.11g483
      The Next Generation: 802.11n484
    Chapter Summary485
      Key Terms485
    Apply Your Knowledge486
      Exercise486
      Review Questions486
      Exam Questions487
      Answers to Review Questions489
      Answers to Exam Questions489
      Suggested Readings and Resources490
    Chapter 16: Wireless Security and Implementation Considerations491
    Introduction494
    Understanding the Threats494
      War Driving494
      Direct Hacking495
      Employee Ignorance495
    Deploying a Secure Wireless Network496
      Wireless Encryption496
      Wireless Authentication (802.1x)499
      Wireless Intrusion Prevention System (IPS)500
    Wireless Implementation Guidelines501
      Understanding Wireless Topologies501
      Understanding Wireless Data Rates503
      General Wireless Implementation Steps506
      Wireless Troubleshooting506
    Chapter Summary508
      Key Terms508
    Apply Your Knowledge509
      Review Questions509
      Exam Questions509
      Answers to Review Questions512
      Answers to Exam Questions512
      Suggested Readings and Resources513
    Chapter 17: Wide Area Network Connections515
    See also: Design to Sell Using Microsoft Publisher to Inform Motivate and Persuade or Visio 2007 Bible

    Mastering VBA

    Author: Guy Hart Davis

    Curious to learn how to write macros, automate Office applications, or create custom applications in Word, Excel, PowerPoint, Outlook or Access? With this comprehensive guide to Visual Basic for Applications (VBA), you can master the language that underlines the Microsoft Office products. Revised for the new versions of the language and the Office suite, this book is completely up-to-date. Aimed at everyone from power users to system administrators and professional developers, it covers all Office products in depth. You'll discover that VBA is easily accessible by novice programmers, yet powerful enough for IT professionals who need to create specialized business applications.



No comments:

Post a Comment