3226 Office Skills courses

Duration 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office 2010, 2013, or 2016 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. You will: Sign in, navigate, and identify components of the Office 365 environment. Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive© for Business, and Delve. Collaborate and work with colleagues using the Yammer and Planner apps. Use email and manage contacts with Outlook on the web. Collaborate using Teams. Configure Teams. This course introduces working with shared documents in the familiar Office 365 online apps?Word, PowerPoint©, and Excel©?as an alternative to installing the Microsoft© Office desktop applications. This course also introduces several productivity apps including Yammer?, Planner, and Delve© that can be used in combination by teams for communication and collaboration. Prerequisites * Outlook - Part 1 * PowerPoint - Part 1 * Word 2016 - Part 1 * Using Microsoft Windows 10 1 - GETTING STARTED WITH OFFICE 365 * Topic A: Sign In to Office 365 * Topic B: Navigate the Office 365 Environment 2 - COLLABORATING WITH SHARED FILES * Topic A: Work with Shared Documents in SharePoint * Topic B: Edit Documents in Office Online * Topic C: Collaborate on the SharePoint Site * Topic D: Work with OneDrive for Business and Delve 3 - USING PRODUCTIVITY APPS * Topic A: Work with Productivity Apps in Combination * Topic B: Broadcast Messages with Yammer * Topic C: Manage Tasks with the Planner App 4 - USING OUTLOOK ON THE WEB * Topic A: Send and Receive Email * Topic B: Manage Contacts * Topic C: Schedule Appointments * Topic D: Personalize Outlook on the Web 5 - COLLABORATING WITH TEAMS * Topic A: Overview of Microsoft Teams * Topic B: Converse and Share in Teams * Topic C: Call and Meet in Teams * Topic D: Collaborate with Office 365 Apps and Teams 6 - CONFIGURING TEAMS * Topic A: Configure Teams * Topic B: Configure Channels * Topic C: Configure Tabs

Duration 1 Days 6 CPD hours Time management training most often begins with setting goals. These goals are recorded and may be broken down into a project, an action plan, or a simple task list. Activities are then rated based on urgency and importance, priorities assigned, and deadlines set. This process results in a plan with a task list or calendar of activities. Routine and recurring tasks are often given less focus to free time to work on tasks that contribute to important goals. This entire process is supported by a skill set that should include personal motivation, delegation skills, organization tools, and crisis management. 1 - GETTING STARTED * Icebreaker * Housekeeping Items * The Parking Lot * Workshop Objectives 2 - SETTING SMART GOALS * The Three P?s * The SMART Way * Prioritizing Your Goals * Visualization 3 - PRIORITIZING YOUR TIME * The 80/20 Rule * The Urgent/Important Matrix * Being Assertive 4 - PLANNING WISELY * Creating Your Productivity Journal * Maximizing the Power of Your Productivity Journal * The Glass Jar: Rocks, Pebbles, Sand, and Water * Chunk, Block, and Tackle * Ready, Fire, Aim! 5 - TACKLING PROCRASTINATION * Why We Procrastinate * Nine Ways to Overcome Procrastination * Eat That Frog! 6 - CRISIS MANAGEMENT * When the Storm Hits * Creating a Plan * Executing the Plan * Lessons Learned 7 - ORGANIZING YOUR WORKSPACE * De-Clutter * Managing Workflow * Dealing with E-mail * Using Calendars * 8 - DELEGATING MADE EASY * When to Delegate * To Whom Should You Delegate? * How Should You Delegate? * Keeping Control * The Importance of Full Acceptance 9 - SETTING A RITUAL * What is a Ritual? * Ritualizing Sleep, Meals, and Exercise * Example Rituals * Using Rituals to Maximize Time 10 - MEETING MANAGEMENT * Deciding if a Meeting is Necessary * Using the PAT Approach * Building the Agenda * Keeping Things on Track * Making Sure the Meeting Was Worthwhile 11 - ALTERNATIVES TO MEETINGS * Instant Messaging and Chat Rooms * Teleconferencing * E-mail Lists and Online Groups * Collaboration Applications 12 - WRAPPING UP * Words from the Wise * Review of Parking Lot * Lessons Learned * Completion of Action Plans and Evaluations ADDITIONAL COURSE DETAILS: Nexus Humans Time Management training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Time Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - EXECUTING A SIMPLE QUERY * Connect to the SQL Database * Query a Database * Save a Query * Modify a Query * Execute a Saved Query 2 - PERFORMING A CONDITIONAL SEARCH * Search Using a Simple Condition * Compare Column Values * Search Using Multiple Conditions * Search for a Range of Values and Null Values * Retrieve Data Based on Patterns 3 - WORKING WITH FUNCTIONS * Perform Date Calculations * Calculate Data Using Aggregate Functions * Manipulate String Values 4 - ORGANIZING DATA * Sort Data * Rank Data * Group Data * Filter Grouped Data * Summarize Grouped Data * Use PIVOT and UNPIVOT Operators 5 - RETRIEVING DATA FROM TABLES * Combine Results of Two Queries * Compare the Results of Two Queries * Retrieve Data by Joining Tables * Check for Unmatched Records * Retrieve Information from a Single Table Using Joins 6 - PRESENTING QUERY RESULTS * Save the Query Result * Generate an XML Report

Duration 1 Days 6 CPD hours This course is intended for This course is designed for Microsoft© Windows© and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint. Overview Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site. Use SharePoint workflow automation tools. In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft© SharePoint© is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents. Prerequisites To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. LESSON 1: NAVIGATING SHAREPOINT SITES * Topic A: Launch SharePoint * Topic B: Gain Access to a Site You Didn't Create * Topic C: Navigate Within a SharePoint Site * Topic D: Access SharePoint from Your Mobile Device LESSON 2: USING LISTS TO TRACK INFORMATION * Topic A: Add and Populate Lists * Topic B: Change View Options * Topic C: Create a Custom View LESSON 3: USING DOCUMENT LIBRARIES TO SHARE AND ORGANIZE DOCUMENTS * Topic A: Store Files in a Document Library * Topic B: Create and Use Document Templates LESSON 4: FINDING, SHARING, AND ARCHIVING CONTENT * Topic A: Search for Items in Lists or Libraries * Topic B: Share Through Links * Topic C: Move Files Offline LESSON 5: AUTHORING DOCUMENTS AS A TEAM * Topic A: Work Together on Documents * Topic B: Manage File Versions and Document Recovery LESSON 6: AUTOMATING BUSINESS PROCESSES * Topic A: Use Rule-Based Automation * Topic B: Use Power Automate to Automate a Workflow

Duration 1 Days 6 CPD hours This course is intended for This course is suitable for IT personnel who are just beginning to work with Azure. This audience wants to learn about our offerings and get hands-on experience with the product. This course primarily uses the Azure portal and command line interface to create resources and does not require scripting skills. Students in this course will gain confidence to take other role-based courses and certifications, such as Azure Administrator. This course combines lecture, demonstrations, and hands-on labs. This course will also help prepare someone for the AZ-900 exam. This course will provide foundational level knowledge on cloud concepts; core Azure services; and Azure management and governance features and tools. Prerequisites There are no prerequisites for taking this course. Familiarity with cloud computing is helpful, but isn't necessary. 1 - DESCRIBE CLOUD COMPUTING * What is cloud computing * Describe the shared responsibility model * Define cloud models * Describe the consumption-based model 2 - DESCRIBE THE BENEFITS OF USING CLOUD SERVICES * Describe the benefits of high availability and scalability in the cloud * Describe the benefits of reliability and predictability in the cloud * Describe the benefits of security and governance in the cloud * Describe the benefits of manageability in the cloud 3 - DESCRIBE CLOUD SERVICE TYPES * Describe Infrastructure as a Service * Describe Platform as a Service * Describe Software as a Service 4 - DESCRIBE THE CORE ARCHITECTURAL COMPONENTS OF AZURE * What is Microsoft Azure * Get started with Azure accounts * Describe Azure physical infrastructure * Describe Azure management infrastructure 5 - DESCRIBE AZURE COMPUTE AND NETWORKING SERVICES * Describe Azure Virtual Machines * Describe Azure Virtual Desktop * Describe Azure Containers * Describe Azure Functions * Describe application hosting options * Describe Azure Virtual Networking * Describe Azure Virtual Private Networks * Describe Azure ExpressRoute * Describe Azure DNS 6 - DESCRIBE AZURE STORAGE SERVICES * Describe Azure storage accounts * Describe Azure storage redundancy * Describe Azure storage services * Identify Azure data migration options * Identify Azure file movement options 7 - DESCRIBE AZURE IDENTITY, ACCESS, AND SECURITY * Describe Azure directory services * Describe Azure authentication methods * Describe Azure external identities * Describe Azure conditional access * Describe Azure role-based access control * Describe zero trust model * Describe defense-in-depth * Describe Microsoft Defender for Cloud 8 - DESCRIBE COST MANAGEMENT IN AZURE * Describe factors that can affect costs in Azure * Compare the Pricing and Total Cost of Ownership calculators * Describe the Microsoft Cost Management tool * Describe the purpose of tags 9 - DESCRIBE FEATURES AND TOOLS IN AZURE FOR GOVERNANCE AND COMPLIANCE * Describe the purpose of Microsoft Purview * Describe the purpose of Azure Policy * Describe the purpose of resource locks * Describe the purpose of the Service Trust portal 10 - DESCRIBE FEATURES AND TOOLS FOR MANAGING AND DEPLOYING AZURE RESOURCES * Describe tools for interacting with Azure * Describe the purpose of Azure Arc * Describe Azure Resource Manager and Azure ARM templates 11 - DESCRIBE MONITORING TOOLS IN AZURE * Describe the purpose of Azure Advisor * Describe Azure Service Health * Describe Azure Monitor ADDITIONAL COURSE DETAILS: Nexus Humans AZ-900T00 Microsoft Azure Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AZ-900T00 Microsoft Azure Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint. Overview Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365 This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans. 1 - PLANNING AND PROVISIONING OFFICE 365 * Overview of Office 365 * Core Services of Office 365 * Requirements for an Office 365 Tenant * Planning a Pilot and Deployment * Creating an Office 365 Tenant * Adding Custom Domains and Managing DNS Settings * Lab: Provisioning Office 365 2 - MANAGING USERS AND GROUPS IN OFFICE 365 * Managing User Accounts and Licences * Managing Passwords and Authentication * Create and Managing the Different Types of Groups in Office 365 * Managing Users and Groups with PowerShell * Managing Users and Groups in the Azure AD Admin Center * Role Based Access and Administrative Roles * Planning and Configuring Directory Synchronization * Lab: Managing Users and Groups in Office 365 * Lab: Planning and Configuring Directory Synchronisation 3 - DEPLOYING AND CONFIGURING TOOLS AND APPLICATIONS FOR OFFICE 365 * Planning Network Configuration for Office 365 Tools and Applications * Using the Office Configuration Tool * Click to Run Installation Use and Control * Managing Centralized Deployment of Tools, Applications and Add-ins * Reporting * Lab: Deploying and Configuring Tools and Applications for Office 365 4 - PLANNING AND MANAGING EXCHANGE ONLINE * What is Exchange Online * Managing Exchange Online Mailboxes * Managing Office 365 Groups in Exchange Online * Configuring Exchange Online Permissions * Managing Exchange Online using PowerShell * Plan and Configure Mail Flow * Plan and Configure Email Protection * Lab: Planning and Managing Exchange Online 5 - PLANNING AND MANAGING SHAREPOINT ONLINE * What is SharePoint Online * Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups * SharePoint Online Architecture * Configure SharePoint Online * Configure and Control External Sharing * Managing SharePoint Online Site Collections * Managing SharePoint Online using PowerShell * Lab: Planning and Managing SharePoint Online 6 - PLANNING AND MANAGING MICROSOFT TEAMS * What is Microsoft Teams * How Microsoft Teams integrates with other Office 365 Services * Create and Manage Organization Wide Settings * Create, Manage and Assign Microsoft Teams Policies * Plan and Configure External and Guest Access * Managing Microsoft Teams using PowerShell * Lab: Planning and Managing Microsoft Teams 7 - PLANNING AND MANAGING OTHER OFFICE 365 SERVICES * Yammer * Planner * Visio * Bookings * Delve * Forms * Power Platform * Stream * Sway * Viva * Scheduler * Add-ins, including Find Time and Junk Reporter * Lab: Planning and Managing Office 365 Services 8 - SECURITY AND COMPLIANCE IN OFFICE 365 * Overview of Security and Compliance Features in Office 365 * Extending Security and compliance Features with Additional Licences * Using the Microsoft Defender Portal and Secure Score * Using the Office 365 Compliance Portal and Compliance Score * Plan and Configure Retention Labels and Policies * Plan and Configure Data Loss Prevention Policies * Create and Assign Sensitivity Labels * Configure Safe Attachments and Safe Links Policies * Plan and Configure Multi Factor Authentication * Lab: Configure Security and Compliance in Office 365 9 - REPORTING, MONITORING AND TROUBLESHOOTING OFFICE 365 * Monitoring Office 365 Service Health * Troubleshooting Administrative Access in Office 365 * Troubleshoot Directory Synchronization * Troubleshooting Exchange Online * Troubleshooting SharePoint Online * Troubleshooting Microsoft Teams * Troubleshooting Office 365 Security and Compliance * Lab: Reporting, Monitoring and Troubleshooting in Office 365

Duration 4 Days 24 CPD hours This course is intended for Collaboration Communications Systems Engineers are responsible for planning, deploying, configuring, maintaining, and troubleshooting Microsoft Teams Phone, meetings, and personal and shared space devices, including Microsoft Teams Rooms and Surface Hub. Collaboration Communications Systems Engineers have a fundamental understanding ofÿnetworking, telecommunications, audio/visual and meeting room technologies, identity and access management. They are proficient in managing and monitoring Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard. They deploy and configure Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing. Collaboration Communications Systems Engineers work with Teams Administrators, Microsoft Identity and Access Administrators, and Microsoft 365ÿAdministrators. In addition, they may work with owners of other workloads, including facilitiesÿmanagers, network engineers, security engineers, device manufacturers, telephony providers, and Microsoft Certified solutions providers. This training course is designed to give participants the knowledge and skills to become a Collaboration Communications Systems Engineer. Participants should understand the fundamentals of networking, telecommunications, audio/visual and meeting room technologies, identity and access management, and Microsoft Teams. They will gain hands-on experience configuring and deploying Microsoft Teams Phone, meetings and certified devices including Microsoft Teams Rooms and Surface Hub. The course will also cover how to manage and monitor Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard. In addition, the course will cover configuring and deploying Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing. Prerequisites * Microsoft 365 and Microsoft Teams * Networking, telecommunications, and audio/visual basics * Identity and access management basics 1 - INTRODUCTION TO TEAMS MEETINGS AND CALLING * Overview of Teams meetings and events * Overview of Teams Phone * Overview of auto attendants and call queues * Overview of Teams devices 2 - PLAN FOR TEAMS PHONE * Plan to deploy Teams Phone * Plan for Teams Phone PSTN connectivity * Determine license requirements * Plan for Teams Phone devices * Plan and design Teams Phone features * Plan for voicemail 3 - PLAN FOR MICROSOFT TEAMS ROOMS AND SURFACE HUB * Determine license requirements for Microsoft Teams Rooms and shared devices * Understand differences between Microsoft Teams Rooms on Android and Windows * Understand Microsoft Teams Rooms on Surface Hub 2S * Understand and plan Teams Room accessories, components, and peripherals * Understand Teams Rooms management options 4 - PLAN AND OPTIMIZE NETWORK PERFORMANCE FOR TEAMS MEDIA * Understand Teams network requirements * Design network for media optimization * Design and implement QoS 5 - CONFIGURE AND DEPLOY TEAMS PHONE * Configure emergency calling for Teams Calling Plans * Manage and configure Microsoft PSTN numbers * Configure Operator Connect and Teams Phone Mobile * Configure Teams Phone policies * Create and manage Teams policies * Configure Audio Conferencing 6 - CONFIGURE AND DEPLOY TEAMS PHONE WITH DIRECT ROUTING * Design Direct Routing call flows * Implement SIP trunking with Direct Routing * Configure Emergency Calling for Direct Routing * Extend Teams Direct Routing infrastructure * Deploy and maintain a survivable branch appliance 7 - EXTEND TEAMS PHONE WITH ADDITIONAL SERVICES * Understand how Teams interacts with additional services * Configure compliance recording in Teams * Configure and integrate a certified contact center in Teams * Design and deploy voice bots in Teams 8 - MANAGE MEETINGS AND EVENTS EXPERIENCES * Explore meetings and events in Microsoft Teams * Configure meeting settings * Create and manage meeting policies * Configure audio conferencing * Create and manage meeting templates and template policies * Create and manage meetings customization policies * Configure live events settings * Create and manage live events policies * Examine live events across Microsoft 365 9 - GUIDED PROJECT - CREATE AND ASSIGN TEAMS POLICIES TO MEET BUSINESS REQUIREMENTS IN MICROSOFT TEAMS * Prepare 10 - CONFIGURE AND MANAGE VOICE USERS * Enable users for Teams Phone * Enable users for Direct Routing with Teams Phone * Enable additional calling features for Teams Phone * Enable users for Teams Phone Mobile 11 - CONFIGURE AUTO ATTENDANTS AND CALL QUEUES * Design call flows for auto attendants and call queues * Configure auto attendants and call queues * Deploy a channel-based call queue * Configure resource accounts * Configure Microsoft 365 groups for voicemail * Interpret call queue conference modes * Interpret call queue routing methods * Configure holidays for auto attendants and call queues * Configure custom music on hold 12 - CONFIGURE, DEPLOY, AND MANAGE TEAMS DEVICES * Manage Microsoft Teams Phones * Manage Microsoft Teams Room Systems * Microsoft Teams Rooms management options * Manage Surface Hub 2S devices * Configure Microsoft Teams SIP gateway * Manage Microsoft Teams displays * Remote provisioning and sign in for Teams Phones * Update Microsoft Teams devices remotely * Manage Microsoft Teams device tags 13 - GUIDED PROJECT - PREPARE MEETING ROOM EXPERIENCES * Prepare 14 - MONITOR AND TROUBLESHOOT TEAMS COLLABORATION COMMUNICATIONS SYSTEMS * Diagnose and troubleshoot phone number assignment * Diagnose and troubleshoot Teams client issues * Diagnose and troubleshoot call failure and call quality issues * Report on and troubleshoot Teams calls with Call Quality Dashboard * Diagnose and troubleshoot Direct Routing issues * Troubleshoot and monitor Teams devices * Troubleshoot Teams meetings and calling * Troubleshoot Teams Rooms devices

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Information Technology (IT) Professionals who have some experience working with Windows Server and are looking for a single five-day course that covers core administration components and technologies in Windows Server. This course also helps server administrators from previous Windows Server versions to update their knowledge and skills related to Windows Server. The course is also for individuals from a service desk role who wish to transition into server maintenance. This five-day instructor-led course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing identity, networking, storage and compute by using Windows Server, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server. The course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server in most organizations. MODULE 1: WINDOWS SERVER ADMINISTRATION OVERVIEW  * Introducing Windows Server * Windows Server Core Overview * Windows Server administration principles and tools overview MODULE 2: IDENTITY SERVICES IN WINDOWS SERVER  * AD DS Overview * Deploying Windows Server domain controllers * Azure AD overview * Implementing Group Policy * Active Directory Certificate Services overview MODULE 3: NETWORK INFRASTRUCTURE SERVICES IN WINDOWS SERVER  * Deploying and managing DHCP * Deploying and managing DNS service * Deploying and managing IPAM * Remote Access Services in Windows Server MODULE 4: FILE SERVERS AND STORAGE MANAGEMENT IN WINDOWS SERVER  * Volumes and File Systems in Windows Server * Implementing sharing in Windows Server * Implementing Storage Spaces in Windows Server * Implementing Data Deduplication * Implementing iSCSI * Deploying Distributed File System MODULE 5: HYPER-V VIRTUALIZATION AND CONTAINERS IN WINDOWS SERVER  * Hyper-V in Windows Server * Configuring VMs * Securing virtualization in Windows Server * Containers in Windows Server * Overview of Kubernetes MODULE 6: HIGH AVAILABILITY IN WINDOWS SERVER * Planning for failover clustering implementation * Creating and configuring failover cluster * Overview of stretch clusters * High availability and disaster recovery solutions with Hyper-V VMs MODULE 7: DISASTER RECOVERY IN WINDOWS SERVER * Hyper-V Replica * Backup and restore infrastructure in Windows Server MODULE 8: WINDOWS SERVER SECURITY * Credentials and privileged access protection * Hardening Windows Server * JEA in Windows Server * Securing and analyzing SMB traffic * Windows Server update management MODULE 9: RDS IN WINDOWS SERVER * Overview of RDS * Configuring a session-based desktop deployment * Overview of personal and pooled virtual desktops MODULE 10: REMOTE ACCESS AND WEB SERVICES IN WINDOWS SERVER * Implementing VPNs * Implementing Always On VPN * Implementing NPS * Implementing Web Server in Windows Server MODULE 11: SERVER AND PERFORMANCE MONITORING IN WINDOWS SERVER  * Overview of Windows Server monitoring tools * Using Performance Monitor * Monitoring event logs for troubleshooting MODULE 12: UPGRADE AND MIGRATION IN WINDOWS SERVER * AD DS migration * Storage Migration Service * Windows Server migration tools ADDITIONAL COURSE DETAILS: Nexus Humans 55371 Windows Server Administration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55371 Windows Server Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies. In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data. Prerequisites The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices. 1 - EXPLORE THE ENTERPRISE DESKTOP * Examine benefits of modern management * Examine the enterprise desktop life-cycle model * Examine planning and purchasing * Examine desktop deployment * Plan an application deployment * Plan for upgrades and retirement 2 - EXPLORE WINDOWS EDITIONS * Examine Windows client editions and capabilities * Select client edition * Examine hardware requirements 3 - UNDERSTAND MICROSOFT ENTRA ID * Examine Microsoft Entra ID * Compare Microsoft Entra ID and Active Directory Domain Services * Examine Microsoft Entra ID as a directory service for cloud apps * Compare Microsoft Entra ID P1 and P2 plans * Examine Microsoft Entra Domain Services 4 - MANAGE MICROSOFT ENTRA IDENTITIES * Examine RBAC and user roles in Microsoft Entra ID * Create and manage users in Microsoft Entra ID * Create and manage groups in Microsoft Entra ID * Manage Microsoft Entra objects with PowerShell * Synchronize objects from AD DS to Microsoft Entra ID 5 - MANAGE DEVICE AUTHENTICATION * Describe Microsoft Entra join * Examine Microsoft Entra join prerequisites limitations and benefits * Join devices to Microsoft Entra ID * Manage devices joined to Microsoft Entra ID 6 - ENROLL DEVICES USING MICROSOFT CONFIGURATION MANAGER * Deploy the Microsoft Configuration Manager client * Monitor the Microsoft Configuration Manager client * Manage the Microsoft Configuration Manager client 7 - ENROLL DEVICES USING MICROSOFT INTUNE * Manage mobile devices with Intune * Enable mobile device management * Explain considerations for device enrollment * Manage corporate enrollment policy * Enroll Windows devices in Intune * Enroll Android devices in Intune * Enroll iOS devices in Intune * Explore device enrollment manager * Monitor device enrollment * Manage devices remotely 8 - EXECUTE DEVICE PROFILES * Explore Intune device profiles * Create device profiles * Create a custom device profile 9 - OVERSEE DEVICE PROFILES * Monitor device profiles in Intune * Manage device sync in Intune * Manage devices in Intune using scripts 10 - MAINTAIN USER PROFILES * Examine user profile * Explore user profile types * Examine options for minimizing user profile size * Deploy and configure folder redirection * Sync user state with Enterprise State Roaming * Configure Enterprise State Roaming in Azure 11 - EXECUTE MOBILE APPLICATION MANAGEMENT * Examine mobile application management * Examine considerations for mobile application management * Prepare line-of-business apps for app protection policies * Implement mobile application management policies in Intune * Manage mobile application management policies in Intune 12 - DEPLOY AND UPDATE APPLICATIONS * Deploy applications with Intune * Add apps to Intune * Manage Win32 apps with Intune * Deploy applications with Configuration Manager * Deploying applications with Group Policy * Assign and publish software * Explore Microsoft Store for Business * Implement Microsoft Store Apps * Update Microsoft Store Apps with Intune * Assign apps to company employees 13 - ADMINISTER ENDPOINT APPLICATIONS * Manage apps with Intune * Manage Apps on non-enrolled devices * Deploy Microsoft 365 Apps with Intune * Additional Microsoft 365 Apps Deployment Tools * Configure Microsoft Edge Internet Explorer mode * App Inventory Review 14 - PROTECT IDENTITIES IN MICROSOFT ENTRA ID * Explore Windows Hello for Business * Deploy Windows Hello * Manage Windows Hello for Business * Explore Microsoft Entra ID Protection * Manage self-service password reset in Microsoft Entra ID * Implement multi-factor authentication 15 - ENABLE ORGANIZATIONAL ACCESS * Enable access to organization resources * Explore VPN types and configuration * Explore Always On VPN * Deploy Always On VPN 16 - IMPLEMENT DEVICE COMPLIANCE * Protect access to resources using Intune * Explore device compliance policy * Deploy a device compliance policy * Explore conditional access * Create conditional access policies 17 - GENERATE INVENTORY AND COMPLIANCE REPORTS * Report enrolled devices inventory in Intune * Monitor and report device compliance * Build custom Intune inventory reports * Access Intune using Microsoft Graph API 18 - DEPLOY DEVICE DATA PROTECTION * Explore Windows Information Protection * Plan Windows Information Protection * Implement and use Windows Information Protection * Explore Encrypting File System in Windows client * Explore BitLocker 19 - MANAGE MICROSOFT DEFENDER FOR ENDPOINT * Explore Microsoft Defender for Endpoint * Examine key capabilities of Microsoft Defender for Endpoint * Explore Windows Defender Application Control and Device Guard * Explore Microsoft Defender Application Guard * Examine Windows Defender Exploit Guard * Explore Windows Defender System Guard 20 - MANAGE MICROSOFT DEFENDER IN WINDOWS CLIENT * Explore Windows Security Center * Explore Windows Defender Credential Guard * Manage Microsoft Defender Antivirus * Manage Windows Defender Firewall * Explore Windows Defender Firewall with Advanced Security 21 - MANAGE MICROSOFT DEFENDER FOR CLOUD APPS * Explore Microsoft Defender for Cloud Apps * Planning Microsoft Defender for Cloud Apps * Implement Microsoft Defender for Cloud Apps 22 - ASSESS DEPLOYMENT READINESS * Examine deployment guidelines * Explore readiness tools * Assess application compatibility * Explore tools for application compatibility mitigation * Prepare network and directory for deployment * Plan a pilot 23 - DEPLOY USING THE MICROSOFT DEPLOYMENT TOOLKIT * Evaluate traditional deployment methods * Set up the Microsoft Deployment Toolkit for client deployment * Manage and deploy images using the Microsoft Deployment Toolkit 24 - DEPLOY USING MICROSOFT CONFIGURATION MANAGER * Explore client deployment using Configuration Manager * Examine deployment components of Configuration Manager * Manage client deployment using Configuration Manager * Plan in-place upgrades using Configuration Manager 25 - DEPLOY DEVICES USING WINDOWS AUTOPILOT * Use Autopilot for modern deployment * Examine requirements for Windows Autopilot * Prepare device IDs for Autopilot * Implement device registration and out-of-the-box customization * Examine Autopilot scenarios * Troubleshoot Windows Autopilot 26 - IMPLEMENT DYNAMIC DEPLOYMENT METHODS * Examine subscription activation * Deploy using provisioning packages * Use Windows Configuration Designer * Use Microsoft Entra join with automatic MDM enrollment 27 - PLAN A TRANSITION TO MODERN ENDPOINT MANAGEMENT * Explore using co-management to transition to modern endpoint management * Examine prerequisites for co-management * Evaluate modern management considerations * Evaluate upgrades and migrations in modern transitioning * Migrate data when modern transitioning * Migrate workloads when modern transitioning 28 - MANAGE WINDOWS 365 * Explore Windows 365 * Configure Windows 365 * Administer Windows 365 29 - MANAGE AZURE VIRTUAL DESKTOP * Examine Azure Virtual Desktop * Explore Azure Virtual Desktop * Configure Azure Virtual Desktop * Administer Azure Virtual Desktop ADDITIONAL COURSE DETAILS: Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the MD-102T00 : Microsoft 365 Endpoint Administrator course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Overview Create sophisticated SSIS packages for extracting, transforming, and loading data Use containers to efficiently control repetitive tasks and transactions Configure packages to dynamically adapt to environment changes Use Data Quality Services to cleanse data Successfully troubleshoot packages Create and Manage the SSIS Catalog Deploy, configure, and schedule packages Secure the SSIS Catalog SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. Prerequisites Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required. Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design. 1 - SSIS OVERVIEW * Import/Export Wizard * Exporting Data with the Wizard * Common Import Concerns * Quality Checking Imported/Exported Data 2 - WORKING WITH SOLUTIONS AND PROJECTS * Working with SQL Server Data Tools * Understanding Solutions and Projects * Working with the Visual Studio Interface 3 - BASIC CONTROL FLOW * Working with Tasks * Understanding Precedence Constraints * Annotating Packages * Grouping Tasks * Package and Task Properties * Connection Managers * Favorite Tasks 4 - COMMON TASKS * Analysis Services Processing * Data Profiling Task * Execute Package Task * Execute Process Task * Expression Task * File System Task * FTP Task * Hadoop Task * Script Task Introduction * Send Mail Task * Web Service Task * XML Task 5 - DATA FLOW SOURCES AND DESTINATIONS * The Data Flow Task * The Data Flow SSIS Toolbox * Working with Data Sources * SSIS Data Sources * Working with Data Destinations * SSIS Data Destinations 6 - DATA FLOW TRANSFORMATIONS * Transformations * Configuring Transformations 7 - MAKING PACKAGES DYNAMIC * Features for Making Packages Dynamic * Package Parameters * Project Parameters * Variables * SQL Parameters * Expressions in Tasks * Expressions in Connection Managers * After Deployment * How It All Fits Together 8 - CONTAINERS * Sequence Containers * For Loop Containers * Foreach Loop Containers 9 - TROUBLESHOOTING AND PACKAGE RELIABILITY * Understanding MaximumErrorCount * Breakpoints * Redirecting Error Rows * Logging * Event Handlers * Using Checkpoints * Transactions 10 - DEPLOYING TO THE SSIS CATALOG * The SSIS Catalog * Deploying Projects * Working with Environments * Executing Packages in SSMS * Executing Packages from the Command Line * Deployment Model Differences 11 - INSTALLING AND ADMINISTERING SSIS * Installing SSIS * Upgrading SSIS * Managing the SSIS Catalog * Viewing Built-in SSIS Reports * Managing SSIS Logging and Operation Histories * Automating Package Execution 12 - SECURING THE SSIS CATALOG * Principals * Securables * Grantable Permissions * Granting Permissions * Configuring Proxy Accounts ADDITIONAL COURSE DETAILS: Nexus Humans 55321 SQL Server Integration Services training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55321 SQL Server Integration Services course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.