October | 2021 | Nanang Sadikin Official

Archive for October, 2021

Book Review : Google Cloud

October 31, 2021

Coming soon

Book Review : Sharepoint Hybrid

October 26, 2021

If you are Systems Administrator and Systems Engineer, and want to read about Microsoft Sharepoint, check it out this book:

Title : Deploying SharePoint Server Hybrid: Exam MS-301 Guide
Author : Aaron Guilmete
ISBN-10 ‏ : ‎ 1839218959
ISBN-13 ‏ : ‎ 978-1839218958
Publisher : Packt
Pages : 540
Year : 2020

Here is the details of this book.

Overview of SharePoint Server 2019
Overview of SharePoint Server architecture
Overview of core SharePoint features and services
Summary
Questions
Planning a SharePoint Farm
Selecting and configuring a farm topology
Dedicated roles
Shared roles
Special roles
Role services
Farm topologies
Designing for high availability
Fault forecasting
Fault avoidance
Fault removal
Fault tolerance
Supported SharePoint high-availability designs
Planning for disaster recovery

Outage costs
Disaster recovery options, costs, and considerations
Planning and configuring backup and restore options
Farm
Granular
Configuration only
Central Administration
PowerShell
Planning for IRM
Planning localization and language packs
Multiple language user interface
Variations
Planning and configuring content farms
Planning integration with Office 365 workloads
Planning Group Policy configuration settings
Deploying OneDrive administrative templates
Core requirements
Server infrastructure
Processors
Server roles
Storage
RAID
Multipathing
Disk configurations
Database capacity
Network
Summary
Questions

Manage and Maintain a SharePoint Farm
Configuring and maintaining core infrastructure to support a SharePoint depl
oyment
Server management from Central Administration
Managing servers in this farm
Managing services in this farm
Exploring Manage Farm Features

Configuring Alternate Access Mappings
SQL Server
Distributed Cache
Stopping or starting the Distributed Cache service
Adding or removing a server in a Distributed Cache cluster
Changing the memory allocation for the Distributed Cache service
Viewing cache configuration
Configuring the cache
Changing the service account of the AppFabric caching service
Performance tuning
Repairing a cache host
Deploying and configuring service and web applications
Creating a web application
Creating a root site collection
Creating host-named site collections
Planning and configuring user profiles
Planning for user profiles
Creating a User Profile service application
Extending user profiles
Configuring user profile synchronization
Configuring SharePoint to use Active Directory
Creating a synchronization connection
Mapping user profile properties
Running a manual profile synchronization
Scheduling profile synchronization
Planning and configuring OneDrive/My Site access
Creating a My Sites collection
Updating the User Profile service application
Monitoring
Monitoring farm Health Analyzer reports and resolving issues
Configuring Health Analyzer rules
Configuring the Health Analyzer timer job
Monitoring storage usage for SharePoint
Configuring diagnostic logging
Updating SharePoint Server and validate the installation
Selecting an upgrade path for version to version upgrades in on-premises Sha
rePoint deployments
Managing SharePoint workflows
Planning and configuring Workflow Manager

Configuring prerequisites
Installing Workflow Manager
Installing the Workflow Manager client
Connecting to SharePoint
Troubleshooting
Configuring a content type hub
Configuring prerequisites
Setting up a content type hub
Configuring a Managed Metadata service
Troubleshooting performance issues
Configuring SMTP authentication for a SharePoint farm
Summary
Questions

Implement Authentication
Selecting and implementing an authentication method
Authentication methods
Windows
Forms
SAML
Zones
Configuring web apps with multiple authentication methods
Monitoring and maintaining authentication
Troubleshooting authentication issues
Summary
Questions
Manage Site Collections
Planning and configuring the site collection architecture
Classic SharePoint
Modern SharePoint
Planning the site collection architecture
Determining who will use the site
Determining the content of the site
Planning the navigation structure
Determining access to sites and content
Planning for fast site creation
Planning and configuring modern team and communication sites
Planning and configuring modern lists and libraries
Modern lists
Modern libraries

Planning and configuring self-service site collections
Planning
Configuring self-service site creation
Planning and configuring site policies
Overview of site policies
Configuring site policies
Reorganizing sites based on changes in business needs
Saving a site as a template
Site Content and Structure
Deploying customizations
Activating and deactivating site collection features
Summary
Questions

Plan and Configure Business Connectivity Services
Overview of Business Connectivity Services
Overview of Secure Store
Planning for external content types
Planning and configuring connections to external data sources
Configuring Secure Store target applications
Importing the BCS model
Configuring external lists
Planning and configuring search for BCS applications
Summary
Questions
Planning and Configuring Managed Metadata
Planning and configuring Managed Metadata Service applications
Overview and terminology
Planning the Managed Metadata Service application
Planning for taxonomy and folksonomy
Configure the Managed Metadata Service application
Creating and configuring a service account
Configuring a Managed Metadata Service application
Configuring the Managed Metadata Service connection
Planning and configuring the Term Store security
Adding a Term Store administrator
Adding a group manager
Adding a contributor
Planning and configuring the Term Store structure
Creating and managing term sets
Creating a term set
Managing a term set and maintaining the Term Store
Creating a term
Copying a term
Reusing a term
Pinning a term
Merging a term
Deprecating a term
Moving a term or term set
Deleting a term or a term set
Importing term sets
Planning and configuring the Term Store languages
Downloading and installing language packs
Configuring multilingual support
Summary
Questions
Manage Search
Overview of Search
Managing the search schema
Creating and updating search dictionaries
Managing company names
Managing query spelling
Managing Query Suggestions
Managing result sources
Creating a result source
Managing query rules
Configuring search and result output
Content Search web part
Search Results web part
Search Results query
Search Result type display template
Search Results settings
Search Results Refinement
Configuring search farms
Configuring a Trust for Search
Configuring a Remote SharePoint results source
Managing the search topology
Prerequisites
Configuring an enterprise search service instance
Performing other search topology updates
Viewing the current active topology
Cloning
Adding a component
Removing a component
Activating a search topology
Troubleshooting search
Performance
Crawl completeness
Summary
Questions
Overview of SharePoint Hybrid
Evaluating hybrid scenarios
Sites
Site following
OneDrive for Business
Self-service site creation
App Launcher
Search
Taxonomy
B2B extranet sites
Planning for hybrid service integration
Summary
Questions
Plan a Hybrid Configuration and Topology
Planning for Hybrid best practices
Configuring the prerequisites for a SharePoint Hybrid farm
Running the SharePoint Hybrid Configuration Wizard
Summary
Questions
Implement Hybrid Teamwork Artifacts
Configuring hybrid taxonomy and content types
Prerequisites
Updating term store permissions
Copying on-premises taxonomy to SharePoint Online
Running the Hybrid Configuration Wizard
Configuring hybrid OneDrive for Business
Prerequisites
Creating a pilot group
Configuring permissions
Running the Hybrid Configuration Wizard
Configuring hybrid sites
Configuring Hybrid B2B sites
Configuring the hybrid app launcher
Configuring document rendering for web apps
Configuring the prerequisites for Office Online Server
Installing the Office Online Server
Configuring Office Online Server
Troubleshooting hybrid configuration issues
Hybrid taxonomy language not found
Invalid content type name
Site following
Document rendering
Summary
Questions
Implement a Hybrid Search Service Application
Overview of cloud hybrid search
Configuring cloud hybrid search
Prerequisites
Preparing Azure AD for SharePoint Hybrid
Creating a cloud SSA
The Hybrid Configuration Wizard
PowerShell
Connecting the cloud SSA to SharePoint Online
Creating a content source for the cloud hybrid search
Configuring the SharePoint Server search to display results from SharePoi
nt Online
Troubleshooting the cloud hybrid search
The cloud hybrid search setup fails to complete due to networking
The Hybrid Configuration Wizard fails
The cloud hybrid search fails to return expected results
Summary
Questions
Implement a Data Gateway
Planning the implementation of an on-premises data gateway
Server and software requirements
Networking requirements
Endpoints
Proxy servers
Security and credentials
High-availability requirements
Recovery key
Installing and configuring an on-premises data gateway
Configuring networking
Configuring a proxy server
Configuring proxy server authentication
Downloading and installing the software
Creating a cluster
Managing an on-premises data gateway
Adding a data source
Adding a gateway admin
Changing the gateway service account
Updating the data gateway service to use a group MSA
Creating a group MSA
Configuring the service
Updating the data gateway service to use a domain account
Changing the recovery key
Monitoring a gateway
Enabling gateway performance monitoring
Enabling query logging
Troubleshooting common issues
Communication errors
Installation errors
Log sources
Summary
Questions
Overview of the Migration Process
Determining and inventorying data sources
Evaluating the migration process and tools
Self-service
Service engagements
Gathering data permissions and accessing the requirements
Planning the destination site architecture and security
Evaluating network requirements
Planning the migration requirements
Planning the operational requirements
Preparing data sources
Change management
Summary
Questions
Migrate Data and Content
Prerequisites
Network
SharePoint Online
SharePoint Migration Assessment Tool
SPMT
Generating an identity mapping file for existing sites
Scanning content for potential issues
Identifying and resolving blocking issues that prevent migration
Determining the course of action for content that cannot be migrated
Planning and configuring an automated SharePoint migration
Recommended tools and strategies to migrate data
Summary
Questions

Aaron Guilmette, a Teams technical specialist at Microsoft, provides guidance and assistance to customers adopting the Microsoft 365 platform. He primarily focuses on collaborative technologies, including Microsoft SharePoint Online, Microsoft Exchange, and Microsoft Teams. He also works with identity and scripting solutions. He has been involved with technology since 1998 and has provided consulting services for customers in the commercial, educational, and government sectors internationally. Aaron has also worked with technical certification exams and instructional design for Microsoft and other organizations.

You can buy this book from online bookstores in the Internet such as Amazon, Barnes and Nobles, and others.

For any other IT Tutorial, you can check it here :

For IT Tutorial visit here:

https://bukutrainingns.blogspot.com/

For IT Tutorial video watch here:

https://www.youtube.com/c/NanangSadikinOfficial

See you again.

Regards

Nanang

Posted in Karir | Leave a Comment »

Book Review : Microsoft 365 Fundamentals

October 21, 2021

If you are Systems Administrator and Systems Engineer, and want to read about Microsoft Cloud, check it out this book:

Title : Microsoft 365 Fundamentals Exam Ref MS-900
Author : Craig Zacker
ISBN-13 : 978-0-13-648487-5
ISBN-10 : 0-13-648487-5
Library of Congress Control Number: 2019956209
Publisher : Pearson Inc
Pages : 240
Year : 2020

Here is the details of this book.

Chapter 1
Skill 1.1: Detail and understand the benefits
and considerations of using cloud
services
Understanding cloud services
Advantages of cloud computing
Skill 1.2: Understand the different types of
cloud services available
Cloud architectures
Cloud service models
Summary
Thought experiment
Thought experiment answer

Chapter 2 Understand core Microsoft 365
services and concepts
Skill 2.1: Describe the core Microsoft 365
components
Windows 10 Enterprise
Exchange Online
SharePoint Online
Microsoft Teams
Enterprise Mobility + Security
Skill 2.2: Compare core services in Microsoft
365 with corresponding on-premises
services
Deployment
Updates
Cost
Administration
Security
Service comparisons
Skill 2.3: Understand the concept of modern management
Transitioning to modern management
Windows as a Service
Using the Microsoft 365 portals
Understanding the Microsoft
deployment and release model
Skill 2.4: Understand Office 365 ProPlus
Comparing Office 365 ProPlus with
on-premises Office
Deploying Office
Skill 2.5: Understand collaboration and
mobility with Microsoft 365
Microsoft 365 collaboration tools
Collaborating in Microsoft 365
Enterprise mobility
Skill 2.6: Describe analytics capabilities in
Microsoft 365
Microsoft Advanced Threat Analytics
Microsoft 365 Usage Analytics
MyAnalytics
Workplace Analytics
Summary
Thought experiment
Thought experiment answer

Chapter 3 Understand security, compliance,
privacy, and trust in Microsoft 365
Skill 3.1: Understand security and
compliance concepts with Microsoft 365
Risk management
Key security pillars
Skill 3.2: Understand identity protection and
management
Identities
Authentication
Protecting documents
Skill 3.3: Understand the need for unified
endpoint management, security usage
scenarios and services
Microsoft 365 and Directory Services
SCCM and Intune co-management
Security usage scenarios
Addressing common threats
Skill 3.4: Understand the Service Trust Portal
and Compliance Manager
Service Trust Portal
Compliance Manager
Cloud adoption showstoppers
Summary
Thought experiment
Thought experiment answer

Chapter 4 Understand Microsoft 365 pricing and
support
Skill 4.1: Understand licensing options
available in Microsoft 365
Microsoft 365 subscriptions
Selling Microsoft 365
Licensing Microsoft 365
Implementing best practices
Skill 4.2: Plan, predict, and compare pricing
Cost-benefit analysis for cloud vs. onpremises
networks
Volume licensing
Billing and bill management
Skill 4.3: Describe support offerings for
Microsoft 365 services
Service level agreements
Creating support requests
Determining service health
Skill 4.4: Understand the service lifecycle in
Microsoft 365
Summary
Thought experiment
Thought experiment answer
Index

Craig Zacker is the author or coauthor of dozens of books, manuals, articles, and websites on computer and networking topics. He has also been an English professor, a technical and copy editor, a network administrator, a webmaster, a corporate trainer, a technical support engineer, a minicomputer operator, a literature and philosophy student, a library clerk, a photographic darkroom technician, a shipping clerk, and a newspaper boy. He lives in a little house with his beautiful wife and a neurotic cat.

You can buy this book from online bookstores in the Internet such as Amazon, Barnes and Nobles, and others.

For any other IT Tutorial, you can check it here :

For IT Tutorial visit here:

https://bukutrainingns.blogspot.com/

For IT Tutorial video watch here:

https://www.youtube.com/c/NanangSadikinOfficial

See you again.

Regards

Nanang

Posted in Karir | Leave a Comment »

Book Review : CCNP Enterprise Design

October 15, 2021

If you are Network Engineer, and want to read about Cisco Certification CCNP, check it out this book:

Title : CCNP Enterprise Design ENSLD 300-420 Official Cert Guide: Designing Cisco Enterprise Networks
Author : Anthony Bruno and Steve Jordan
ISBN-13 : 978-0-13-657519-1
ISBN-10 : 0-13-657519-6
Publisher : Cisco Press
Pages : 528
Year : 2020

Here is the details of this book.

Chapter 1. Internet Protocol Version 4 (IPv4) Design
“Do I Know This Already?” Quiz
Foundation Topics
IPv4 Header
IPv4 Addressing
IPv4 Address Subnets
IPv4 Addressing Design
Address Assignment and Name Resolution
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 2. Internet Protocol Version 6 (IPv6)
Design
“Do I Know This Already?” Quiz
Foundation Topics
Introduction to IPv6
IPv6 Header
IPv6 Address Representation
IPv6 Address Scope Types and Address
Allocations
IPv6 Mechanisms
IPv6 Routing Protocols
IPv4-to-IPv6 Migration Strategies and
Deployment Models
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 3. Routing Protocol Characteristics,
EIGRP, and IS-IS
“Do I Know This Already?” Quiz
Foundation Topics
Routing Protocol Characteristics
Routing Protocol Metrics and Loop
Prevention
EIGRP
IS-IS
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 4. OSPF, BGP, and Route
Manipulation
“Do I Know This Already?” Quiz
Foundation Topics
OSPFv2
OSPFv3
BGP
Route Manipulation
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 5. IP Multicast and Network
Management
“Do I Know This Already?” Quiz
Foundation Topics
IP Multicast Review
Network Management Design
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 6. Enterprise LAN Design and
Technologies
“Do I Know This Already?” Quiz
Foundation Topics
Hierarchical Network Models
LAN Media
Spanning Tree Protocol Design
Considerations
References and Recommended Reading
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 7. Advanced Enterprise Campus
Design
“Do I Know This Already?” Quiz
Foundation Topics
Campus LAN Design and Best Practices
High Availability Network Services
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 8. WAN for the Enterprise
“Do I Know This Already?” Quiz
Foundation Topics
WAN Overview
WAN Transport Technologies
Site-to-Site VPN Design
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 9. WAN Availability and QoS
“Do I Know This Already?” Quiz
Foundation Topics
WAN Design Methodologies
Design for High Availability
Internet Connectivity
Backup Connectivity
QoS Strategies
Designing End-to-End QoS Policies
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 10. SD-Access Design
“Do I Know This Already?” Quiz
Foundation Topics
SD-Access Architecture
SD-Access Fabric Design Considerations
for Wired and Wireless Access
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 11. SD-WAN Design
“Do I Know This Already?” Quiz
Foundation Topics
SD-WAN Architecture
SD-WAN Design Considerations
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 12. Automation
“Do I Know This Already?” Quiz
Foundation Topics
Introduction to Network APIs and Protocols
YANG, NETCONF, and RESTCONF Explored
IETF, OpenConfig, and Cisco YANG Models
Model-Driven Telemetry
References and Recommended Readings
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A

Chapter 13. Final Preparation
Getting Ready
Tools for Final Preparation
Suggested Plan for Final Review/Study
Summary

Appendix A. OSI Model, TCP/IP Architecture, and Numeric Conversion
Appendix B. Answers to the “Do I Know This Already?” Quiz Questions Q&A Questions “Do I Know This Already?” Answers Quiz Answers
Appendix C. CCNP Enterprise Design ENSLD 300-420 Official Cert Guide Exam Updates
Appendix D. Memory Tables
Appendix E. Memory Tables Answer Key
Appendix F. Study Planner
Glossary

Anthony Bruno, CCIE No. 2738, is an architect and technical resource manager with British Telecom (BT) with more than 27 years of experience in the internetworking field. Previously, he worked for International Network Services (INS) and Lucent Technologies, and he was a captain in the U.S. Air Force. He has consulted for many enterprise and service provider customers in the design, implementation, and optimization of large-scale networks. Anthony leads architecture and design teams in building nextgeneration networks for customers. Anthony completed a master of science degree in electrical engineering at the University of Missouri–Rolla in 1994 and a bachelor of science in electrical engineering at the University of Puerto Rico–Mayaguez in 1990. For the past 20 years, he has coauthored five editions of the CCDA Official Cert Guide for Cisco Press. Outside work, Anthony enjoys running marathons and Spartan obstacle races, and he has finished seven Ironman distance triathlons. He is also an avid genealogist and ancestry tree researcher. Anthony also enjoys piloting his Mavic Pro drone during trips.

Steve Jordan, CCIE No. 11293, is a principal architect with J. Network Architects and has 23 years of experience in the field of internetworking. For the past 10 years, Steve has specialized in data center and network security architectures involving compute, network, security, storage, and virtualization. Over the years, Steve has worked with many enterprise and service provider customers in both presales and postsales engineering and architecture roles, and he has worked at several Cisco Gold Partners. He has extensive experience in data center and security architecture design and has implemented solutions in many financial, energy, retail, healthcare, education, and telecommunications industries. Steve is a 15-year triple CCIE in the tracks of Routing & Switching, Storage Networking, and Data Center. His other certifications include CCNA, CCNP Enterprise, VMware VCIX6-NV, and VCP6-NV. Steve lives in Houston, Texas, and when he is not working on technology, he can be found traveling to new places, homebrewing, and trading stocks. Over the past 14 years, Steve has coauthored three editions of the CCDA Official Cert Guide.

You can buy this book from online bookstores in the Internet such as Amazon, Barnes and Nobles, and others.

For any other IT Tutorial, you can check it here :

For IT Tutorial visit here:

https://bukutrainingns.blogspot.com/

For IT Tutorial video watch here:

https://www.youtube.com/c/NanangSadikinOfficial

See you again.

Regards

Nanang

Posted in Karir | Leave a Comment »

Book Review : Cisco CCNP Collaboration

October 12, 2021

If you are Network Engineer, and want to read about Cisco Certification CCNP, check it out this book:

Title : CCNP Collaboration Cloud and Edge Solutions CLCEI 300-820 Official Cert Guide 1st Edition
Author : Jason Ball
ISBN-10 ‏ : ‎ 0136733727
ISBN-13 ‏ : ‎ 978-0136733720
Publisher : Cisco Press
Pages : 592
Year : 2021

Here is the details of this book.

Chapter 1. Introduction to the Expressway Solution
Solution “Do I Know This Already?” Quiz
Foundation Topics
VCS to Expressway Migration
SIP on the Expressways
H.323 on the Expressways
Describe Expressway Licensing
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 2. Configure Key Expressway Settings
“Do I Know This Already?” Quiz
Foundation Topics
Cisco Expressway Deployment on VM
Setup Wizard through Web Interface
Expressway System Configuration
Expressway Backup and Restore Procedure
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 3. Initial Configuration Settings on the Cisco Expressway
“Do I Know This Already?” Quiz
Foundation Topics
H.323 Settings
SIP and Domain Settings
Describe Protocol Interworking on the Cisco Expressway
Verifying Registration on the Cisco Expressway
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 4. Regular Expressions on the Cisco Expressway
“Do I Know This Already?” Quiz
Foundation Topics
Overview and Use Cases for Regular Expressions
Verifying Regular Expression using the Check Pattern Tool
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 5. Security Overview on the Cisco Expressway
“Do I Know This Already?” Quiz
Foundation Topics
Describe SIP Media Encryption Mode
Certificates
Administrator Authentication
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Part II: Expressway Configurations
Chapter 6. Registration on Cisco Expressway
“Do I Know This Already?” Quiz
Foundation Topics
Registration Conflict Policy
Registration Restriction Policy
Registration Authentication
Subzones and Membership Rules
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 7. Cisco Expressway Call Processing Order
“Do I Know This Already?” Quiz
Foundation Topics
Transforms
Call Policy
User Policy
Search History and the Locate Tool
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 8. Bandwidth Management
“Do I Know This Already?” Quiz
Foundation Topics
Subzone Bandwidth Management
Links and Pipes Bandwidth Management
Call Control Using Pipes
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 9. Multisite Collaboration Solutions
“Do I Know This Already?” Quiz
Foundation Topics
Dial Plan Elements
Simple Video Network with a Flat Dial Plan
Complex Video Network with a Flat Dial Plan
Complex Video Network with a Structured Dial Plan
Hierarchical Video Network with a Structured Dial Plan
Configuring Neighbor Zones
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 10. Multisite and Business-to-Business (B2B) Collaboration
Solutions
“Do I Know This Already?” Quiz
Foundation Topics
Firewall Issues in a Collaboration Environment
NAT Issues in a Collaboration Environment
Purpose of STUN, TURN and ICE
TURN
ICE
Expressway Media Traversal
DNS Zones
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 11. Clustering Expressways
“Do I Know This Already?” Quiz
Foundation Topics
Clustering Requirements
DNS and Clustering
Zones and Clustering
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 12. Troubleshooting a Business-to-Business (B2B)
Collaboration Solution
“Do I Know This Already?” Quiz
Foundation Topics
Troubleshooting Registration Issues
Troubleshooting Calling Issues
Troubleshooting DNS Issues
Troubleshooting Certificate Issues
Other Troubleshooting Tools
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Part III: Mobile and Remote Access
Chapter 13. Introduction to Mobile and Remote Access (MRA)
“Do I Know This Already?” Quiz
Foundation Topics
Purpose of MRA
Components of MRA
Considerations for MRA Deployment
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 14. Configure an MRA Solution
“Do I Know This Already?” Quiz
Foundation Topics
DNS Records
Certificates
CUCM Settings for MRA
Unified Communications Configuration on Expressways
HTTP Allow List
Unified Communications Traversal Zones
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 15. Troubleshooting an MRA Solution
“Do I Know This Already?” Quiz
Foundation Topics
MRA Troubleshooting General Techniques
Registration and Certificate Issues
Cisco Jabber Sign-In Issues
Other Specific Issues
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Part IV: Cisco Webex Technologies
Chapter 16. Introduction to Cisco Cloud Collaboration
“Do I Know This Already?” Quiz
Foundation Topics
Cloud Collaboration Solutions
Cisco Webex Components
Cisco Webex Hybrid Services
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 17. Configure Webex Hybrid Directory Service
“Do I Know This Already?” Quiz
Foundation Topics
Deployment Model
Deployment Requirements
Infrastructure Requirements
Active Directory Configuration and Synchronization
Webex User Service Assignment
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 18. Configure Webex Hybrid Calendar Service
“Do I Know This Already?” Quiz
Foundation Topics
Calendar Service Operation
Expressway-Based Calendar Connector
Google Calendar Deployment in the Cloud
Office 365
One Button to Push (OBTP)
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 19. Configure Webex Hybrid Message Service
“Do I Know This Already?” Quiz
Foundation Topics
Deployment Models
Deployment Requirements
Expressway Requirements
Certificates
Register Expressway Connector to the Cisco Webex Cloud
IM and Presence Configuration
Manage Hybrid Message Service
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 20. Webex Edge Solutions
“Do I Know This Already?” Quiz
Foundation Topics
Webex Edge for Devices
Webex Edge for Calling
Webex Edge Audio
Webex Edge Connect
Webex Video Mesh
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 21. Describe Cisco Jabber for Cloud and Hybrid
Deployments with Cisco Webex Messenger
“Do I Know This Already?” Quiz
Foundation Topics
Deployment Requirements
CUCM Requirements
Exam Preparation Tasks
Review All Key Topics
Complete Tables and Lists from Memory
Define Key Terms
Q&A
Answers

Chapter 22. Final Preparation
Getting Ready
Tools for Final Preparation
Suggested Plan for Final Review/Study
Summary
Appendix A. Answers to the “Do I Know This Already?” Quizzes
and Review Questions
Appendix B. CCNP Implementing Cisco Collaboration Cloud and

Anyone who has worked with Jason Ball or has sat in one of his classes knows that his enthusiasm for collaboration is matched only by his engaging zeal for teaching. Jason’s current position as a solution readiness engineer in Collaboration for Cisco awards him with the opportunity to create and provide training to Cisco partners on new, innovative collaboration solutions as Cisco releases them. He has been operating as a collaboration engineer for more than 11 years and holds 19 different certifications, including a CCNP Collaboration certification and a Cisco Certified Systems Instructor (CCSI) certification. He has been teaching Cisco Voice, Video, and Collaboration certification courses for as many years as he has been involved with Cisco. Some of the accomplishments that Jason has achieved include serving as a subject matter expert (SME) for two certification courses Cisco has developed: the TVS Advanced Services Course and the CIVND2 certification course for the former CCNA Collaboration certification. He also wrote the Video Infrastructure Implementation (VII) Advanced Services course for Cisco, coauthored CCNA Collaboration CIVND 210-065 Official Cert Guide (Cisco Press, 2015), and was the sole author of CCNP and CCIE Collaboration Core CLCOR 350-801 Official Cert Guide (Cisco Press). Jason currently resides in Raleigh, North Carolina, with his wife and two children.

TJ Arneson is a Cisco Certified Systems Instructor (CCSI) who has had a history with Cisco products since his enlistment days in the U.S. Army. He has obtained both the CCNP Routing & Switching and Collaboration certifications. TJ’s current position is a Customer Success Specialist for Cisco Systems, where he is enabling and empowering customers through the Customer Experience (CX) team under the Service Provider theater. TJ currently resides in sunny Tampa, Florida. When he is not working, he is either fishing in Tampa Bay or grinding levels in video games with his wife.

You can buy this book from online bookstores in the Internet such as Amazon, Barnes and Nobles, and others.

For any other IT Tutorial, you can check it here :

For IT Tutorial visit here:

https://bukutrainingns.blogspot.com/

For IT Tutorial video watch here:

https://www.youtube.com/c/NanangSadikinOfficial

See you again.

Regards

Nanang

Posted in Karir | Leave a Comment »

Book Review : SQL Server 2019 Beginner Guide

October 5, 2021

If you are Database Administrator (DBA), and want to read about SQL Server, check it out this book:

Title : Microsoft SQL Server 2019 a Beginner Guide Seventh Edition
Author : Dusan Petkovic
ISBN-10 ‏ : ‎ 1260458873
ISBN-13 ‏ : ‎ 978-1260458879
Publisher : McGraw Hill
Pages : 864
Year : 2020

Here is the details of this book.

Chapter 1 Overview
Variety of User Interfaces
Physical Data Independence
Logical Data Independence
Query Optimization
Data Integrity
Concurrency Control
Backup and Recovery
Database Security
Relational Database Systems
Working with the Book’s sample
Database
SQL: A Relational Database Language
Database Design
Normal Forms
Entity-Relationship Model
Syntax Conventions
Summary
Exercises

Chapter 2 Planning the Installation and
Installing SQL Server
SQL Server Editions and Management
Tools
SQL Server Editions
Management Tools
Planning Phase: General
Recommendations
Which Operating System Will Be
Used?
Which SQL Server Components
Should Be Installed?
Where Will the Root Directory Be
Stored?
Should Multiple Instances of the
Database Engine Be Used?
Which Authentication Mode for the
Database Engine Should Be Used?
Installation of SQL Server on Windows or
Ubuntu
Planning the Installation on Windows
Installing SQL Server on Windows
Installing SQL Server Directly on
Ubuntu
Summary

Chapter 3 Front-End Tools for the Database
Engine
SQL Server Management Studio
Connecting to a Server
Registered Servers
Object Explorer
Organizing and Navigating SQL
Server Management Studio’s Panes
Using SQL Server Management Studio
with the Database Engine
Administering Database Servers
Managing Databases Using Object
Explorer
Authoring Activities Using SQL Server
Management Studio
Query Editor
Solution Explorer
Data Discovery and Classification
Azure Data Studio
Installation of Azure Data Studio
Configuration
Object Explorer
Code Editor
Database Dashboards and
Customization
SQL Server Management Studio vs. Azure
Data Studio
Summary
Exercises

Part II Transact-SQL Language

Chapter 4 SQL Components
SQL’s Basic Objects
Literal Values
Identifiers
Delimiters
Comments
Reserved Keywords
Data Types
Numeric Data Types
Character Data Types
Temporal Data Types
Miscellaneous Data Types
Storage Options
Transact-SQL Functions
Aggregate Functions
Scalar Functions
Scalar Operators
Global Variables
NULL Values
Summary
Exercises

Chapter 5 Data Definition Language
Creating Database Objects
Creation of a Database
CREATE TABLE: A Basic Form
CREATE TABLE and Declarative
Integrity Constraints
Referential Integrity
Creating Other Database Objects
Integrity Constraints and Domains
Modifying Database Objects
Altering a Database
Altering a Table
Removing Database Objects
Summary
Exercises

Chapter 6 Queries
SELECT Statement: Its Clauses and
Functions
WHERE Clause
GROUP BY Clause
Aggregate Functions
HAVING Clause
ORDER BY Clause
SELECT Statement and IDENTITY
Property
CREATE SEQUENCE Statement
Set Operators
CASE Expressions
Subqueries
Subqueries and Comparison
Operators
Subqueries and the IN Operator
Subqueries and ANY and ALL
Operators
Temporary Tables
Join Operator
Two Syntax Forms to Implement
Joins
Natural Join
Cartesian Product
Outer Join
Further Forms of Join Operations
Correlated Subqueries
Subqueries and the EXISTS Function
Should You Use Joins or Subqueries?
Table Expressions
Derived Tables
Common Table Expressions
Summary
Exercises

Chapter 7 Modification of a Table’s Contents
INSERT Statement
Inserting a Single Row
Inserting Multiple Rows
Table Value Constructors and
INSERT
UPDATE Statement
DELETE Statement
Other T-SQL Modification Statements and
Clauses
TRUNCATE TABLE Statement
MERGE Statement
The OUTPUT Clause
Summary
Exercises

Chapter 8 Stored Procedures and User-
Defined Functions
Procedural Extensions
Block of Statements
IF Statement
WHILE Statement
Local Variables
Miscellaneous Procedural Statements
Exception Handling with TRY,
CATCH, and THROW
Stored Procedures
Creation and Execution of Stored
Procedures
User-Defined Functions
Types of User-Defined Functions
Creation and Execution of User-
Defined Functions
Changing the Structure of UDFs
Summary
Exercises

Chapter 9 System Catalog
Introduction to the System Catalog
General Interfaces
Catalog Views
Dynamic Management Views and
Functions
Information Schema
Proprietary Interfaces
System Stored Procedures
System Functions
Property Functions
Summary
Exercises

Chapter 10 Indices
Introduction to Indices
Clustered Indices
Nonclustered Indices
Transact-SQL and Indices
Creating Indices
Editing Information Concerning
Indices
Altering Indices
Creation of Resumable Online Indices
Removing and Renaming Indices
Guidelines for Creating and Using Indices
Indices and Conditions in the
WHERE Clause
Indices and the Join Operator
Covering Index
Missing Indices
Special Types of Indices
Summary
Exercises

Chapter 11 Views
DDL Statements and Views
Creating a View
Altering and Removing Views
DML Statements and Views
View Retrieval
INSERT Statement and a View
UPDATE Statement and a View
DELETE Statement and a View
Editing Information Concerning
Views
Summary
Exercises

Chapter 12 Security System of the Database
Engine
Encrypting Data
Symmetric Keys
Asymmetric Keys
Certificates
Editing Metadata Concerning User
Keys
Extensible Key Management
Methods of Data Encryption
Authentication
Setting Up the Database System
Security
Schemas
User–Schema Separation
DDL Schema-Related Statements
Default Database Schemas
Database Security
Managing Database Security Using
SQL Server Management Studio
Managing Database Security Using
Transact-SQL Statements
Roles
Fixed Server Roles
Fixed Database Roles
Application Roles
User-Defined Server Roles
User-Defined Database Roles
Authorization
GRANT Statement
DENY Statement
REVOKE Statement
Managing Permissions Using SQL
Server Management Studio
Managing Authorization and
Authentication of Contained
Databases
Change Tracking
Data Security and Views
Summary
Exercises

Chapter 13 Concurrency Control
Concurrency Models
Transactions
Properties of Transactions
Transact-SQL Statements and
Transactions
Transaction Log
Editing Information Concerning
Transactions and Logs
Locking
Lock Modes
Lock Granularity
Lock Escalation
Affecting Locks
Displaying Lock Information
Deadlock
Isolation Levels
Concurrency Problems
The Database Engine and Isolation
Levels
Row Versioning
Read Committed Snapshot Isolation
Snapshot Isolation
Summary
Exercises

Chapter 14 Triggers
Introduction to Triggers
Creating a DML Trigger
Modifying a Trigger’s Structure
Using deleted and inserted Virtual
Tables
Application Areas for DML Triggers
AFTER Triggers
INSTEAD OF Triggers
First and Last Triggers
DDL Triggers and Their Application Areas
Database-Level Triggers
Server-Level Triggers
Summary
Exercises
Part III SQL Server: System
Administration

15 System Environment of the
Database Engine
System Databases
master Database
model Database
tempdb Database
msdb Database
Disk Storage
Properties of Data Pages
Types of Data Pages
Editing Information Concerning Disk
Storage
Parallel Processing of Tasks
Utilities
bcp Utility
sqlcmd Utility
mssql-cli Utility
sqlservr Utility
DBCC Commands
Validation Commands
Performance Command
Policy-Based Management
Key Terms and Concepts
Using Policy-Based Management
Summary
Exercises

Chapter 16 Backup, Recovery, and System
Availability
Reasons for Data Loss
Introduction to Backup Methods
Full Database Backup
Differential Backup
Transaction Log Backup
File or Filegroup Backup
Performing Database Backup
Backing Up Using Transact-SQL
Statements
Backing Up Using SQL Server
Management Studio
Determining Which Databases to
Back Up
Performing Database Recovery
Automatic Recovery
Manual Recovery
Recovery Models
System Availability
Using a Standby Server
Using RAID Technology
Database Mirroring
Failover Clustering
Log Shipping
AlwaysOn
Comparison of High-Availability
Components
Maintenance Plan Wizard
Summary
Exercises

Chapter 17 Automating System Administration
Tasks
Starting SQL Server Agent
Creating Jobs and Operators
Creating a Job and Its Steps
Creating a Job Schedule
Notifying Operators About the Job
Status
Viewing the Job History Log
Alerts
Error Messages
SQL Server Agent Error Log
Windows Application Log
Defining Alerts to Handle Errors
Summary
Exercises

Chapter 18 Data Replication
Distributed Data and Methods for
Distributing
SQL Server Replication: An Overview
Publishers, Distributors, and
Subscribers
Publications and Articles
Agents
The distribution Database
Replication Types
Replication Models
Managing Replication
Configuring the Distribution and
Publication Servers
Setting Up Publications
Configuring Subscription Servers
Summary
Exercises

Chapter 19 Query Optimizer
Phases of Query Processing
How Query Optimization Works
Query Analysis
Index Selection
Join Order Selection
Join Processing Techniques
Plan Caching
Tools for Editing the Optimizer Strategy
SET Statement
SQL Server Management Studio and
Graphical Execution Plans
Examples of Execution Plans
Dynamic Management Views and
Query Optimizer
Optimizer Hints
Why Use Optimizer Hints
Types of Optimizer Hints
Summary
Exercises

Chapter 20 Performance Tuning
Factors That Affect Performance
Database Applications and
Performance
The Database Engine and
Performance
System Resources and Performance
Monitoring Performance
Performance Monitor: An Overview
Monitoring the CPU
Monitoring Memory
Monitoring the Disk System
Monitoring the Network Interface
Choosing the Right Tool for Monitoring
SQL Server Profiler
Database Engine Tuning Advisor
Extended Events
Other Performance Tools of the Database
Engine
Query Store
Automatic Tuning
Performance Data Collector
Resource Governor
Live Query Statistics
Summary
Exercises

Chapter 21 In-Memory OLTP
Memory-Optimized Tables
Pinned Tables as Predecessor of
Memory-Optimized Tables
Creating a Memory-Optimized
Filegroup
Creating Memory-Optimized Tables
Row and Index Storage
Row Storage
Index Storage

In-Memory OLTP and Concurrency
Control
Logging Memory-Optimized Objects
Optimistic Multiversion Concurrency
Control
Accessing the Content of Memory-
Optimized Tables
Interpreted Transact-SQL
Compiled Stored Procedures
Editing Information Concerning In-
Memory Objects
Property Functions
Catalog Views and System Stored
Procedures
Dynamic Management Views
Tools for In-Memory OLTP
Memory Management for In-Memory
OLTP: Overview
Memory Management Tools
Migration Tools for In-Memory OLTP
Summary
Part IV SQL Server and Business
Intelligence

Chapter 22 Business Intelligence: An
Introduction
Online Transaction Processing vs.
Business Intelligence
Online Transaction Processing
Business Intelligence Systems
Data Warehouses and Data Marts
Data Warehouse Design
Cubes and Their Architectures
Aggregation
Physical Storage of a Cube
Data Access
Summary
Exercises

Chapter 23 SQL Server Analysis Services
Multidimensional Model
Multidimensional Model Terminology
Creating a New Project Using Visual
Studio 2019
Creating and Processing of a
Multidimensional Cube
Delivering Data from the
Multidimensional Model
Tabular Model
Workspace Database
Creating a Tabular Model Solution
A Tabular Model Example
Delivering Data from the Tabular
Project
Multidimensional Model vs. Tabular
Model
Analysis Services: Data Security
Summary
Exercises

Chapter 24 Business Intelligence and
Transact-SQL
Window Construct
Partitioning
Ordering and Framing
Extensions of GROUP BY
CUBE Operator
ROLLUP Operator
Grouping Functions
Grouping Sets
OLAP Query Functions
Ranking Functions
Statistical Aggregate Functions
Standard and Nonstandard Analytic
Functions
TOP Clause
OFFSET/FETCH
NTILE Function
Pivoting Data
STRING_AGG Function
APPROX_COUNT_DISTINCT
Function
Summary
Exercises

Chapter 25 SQL Server Reporting Services
Reports: An Introduction
SQL Server Reporting Services
Architecture
Reporting Services Windows Service
Report Catalog
Installation and Configuration of
Reporting Services
Creating Reports
Installation of SQL Server Data Tools
Creating Your First Report
Creating a Parameterized Report
Creating a Report Using a Chart
Managing and Tuning Reports
Reporting Services Web Portal
Performance Issues
Reporting Services Security
Authentication
Authorization
Summary
Exercises

Chapter 26 Optimizing Techniques for Data
Warehousing
Data Partitioning
How the Database Engine Partitions
Data
Steps for Creating Partitioned Tables
Partitioning Techniques for
Increasing System Performance
Editing Information Concerning
Partitioning
Guidelines for Partitioning Tables and
Indices
Star Join Optimization
Indexed Views
Creating an Indexed View
Modifying the Structure of an
Indexed View
Editing Information Concerning
Indexed Views
Benefits of Indexed Views
Summary

Chapter 27 Columnstore Indices
Benefits of Columnstore Indices
Internal Storage of Columnstore Indices
Index Storage
Compression
Types of Columnstore Indices
Clustered Columnstore Index
Nonclustered Columnstore Index
Editing Information Concerning
Columnstore Indices
Columnstore Indices: Performance
Columnstore Indices vs. Rowstore
Indices
Batch Mode on Columnstore
Summary
Exercises

Chapter 28 Intelligent Query Processing
Adaptive Query Processing
Memory Grant Feedback
Adaptive Join
Interleaved Execution
Batch Mode on Rowstore
Approximate Query Processing
Scalar UDF Inlining
Enabling and Disabling Scalar UDF
Inlining
Table Variable Deferred Compilation
Summary
Part V Beyond Relational Data

Chapter 29 JSON Integration in the Database
Engine
An Introduction to JSON
Why Support JSON in SQL Server?
Storing JSON Documents in the Database
Engine
Presenting and Querying JSON
Documents
Presenting JSON Documents as
Relational Data
Presenting Relational Data as JSON
Documents
Querying JSON Documents
Updating JSON Documents
Summary

Chapter 30 Spatial and Temporal Data
Spatial Data
Models for Representing Spatial Data
GEOMETRY Data Type
GEOGRAPHY Data Type
GEOMETRY vs. GEOGRAPHY
External Data Formats
Working with Spatial Data Types
Working with the GEOMETRY Data
Type
Working with the GEOGRAPHY Data
Type
Spatial Indices
Editing Information Concerning
Spatial Data
Temporal Tables
Creation of Temporal Tables
Temporal Tables and DML
Statements
Querying Temporal Data
Converting Nontemporal Tables into
Temporal Tables
Summary

Chapter 31 SQL Server Graph Databases
Graph Databases: A General Introduction
Graph Databases: Models
SQL Server Graph Databases: An
Introduction
Creating Node Tables and Edge Tables
Creating Node Tables
Creating Edge Tables
Inserting Data into Edge Tables
Querying Graph Data
The MATCH Function
Recursive Relationships
Modifying and Editing Data in Graph
Databases
Deleting Graph Data
Updating Graph Data
Editing Information Concerning SQL
Server Graph Databases
Querying Graph Data Using Relational
Queries
Summary
Exercises
Part VI Machine Learning

Chapter 32 SQL Server Machine Learning
Services: R Support
SQL Server R Services
R Language: An Introduction
Getting Started with R in SQL Server
R Data Frames
Data Visualization
Data Visualization in R
Integrate R in Power BI Desktop
Predictive Modeling with R
Solving Linear Regression Problems
with R
Summary

Chapter 33 SQL Server Machine Learning
Services: Python Support
Python: An Introduction
Getting Started with Python
Python Data Frames
Data Visualization with Python
Predictive Modeling with Python in SQL
Server
Solving Linear Regression Problems
Using Python
Summary
Appendix Exercise Solutions
Index

Dusan Petrovic (Germany) is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He frequently contributes to SQL Server Magazine and has published 8 other computer books in Germany for Addison Wesley and McGraw-Hill.

You can buy this book from online bookstores in the Internet such as Amazon, Barnes and Nobles, and others.

For any other IT Tutorial, you can check it here :

For IT Tutorial visit here:

https://bukutrainingns.blogspot.com/

For IT Tutorial video watch here:

https://www.youtube.com/c/NanangSadikinOfficial

See you again.

Regards

Nanang

Posted in Karir | Leave a Comment »

Nanang Sadikin Official

Archive for October, 2021

Book Review : Google Cloud

Book Review : Sharepoint Hybrid

Book Review : Microsoft 365 Fundamentals

Book Review : CCNP Enterprise Design

Book Review : Cisco CCNP Collaboration

Book Review : SQL Server 2019 Beginner Guide

Pages

Archives

Categories