Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases. Overview After completing this course, you will be able to: Authenticate and authorize users Assign server and database roles Authorize users to access resources Use encryption and auditing features to protect data Describe recovery models and backup strategies Backup and Restore SQL Server databases Automate database management Configure security for the SQL Server agent Manage alerts and notifications Managing SQL Server using PowerShell Trace access to SQL Server Monitor a SQL Server infrastructure Troubleshoot a SQL Server infrastructure Import and export data This course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks. This course covers content that was in retired Microsoft Course 20764: Administering a SQL Database Infrastructure. 1 - Creating advanced functions Lesson 1: Converting a command into an advanced function Lesson 2: Creating a script module Lesson 3: Defining parameter attributes and input validation Lesson 4: Writing functions that accept pipeline input Lesson 5: Producing complex pipeline output Lesson 6: Using comment-based Help Lesson 7: Using Whatif and Confirm parameters 2 - Using Microsoft .NET Framework and REST API in Windows PowerShell Lesson 1: Using .NET Framework in PowerShell Lesson 2: Using REST API in PowerShell 3 - Writing controller scripts Lesson 1: Understanding controller scripts Lesson 2: Writing controller scripts with a user interface Lesson 3: Writing controller scripts that create reports 4 - Handling script errors Lesson 1: Understanding error handling Lesson 2: Handling errors in a script 5 - Using XML, JSON, and custom-formatted data Lesson 1: Working with XML formatted data Lesson 2: Working with JSON formatted data Lesson 3: Working with custom-formatted data 6 - Enhancing server management with Desired State Configuration and Just Enough Administration Lesson 1: Implementing Desired State Configuration Lesson 2: Implementing Just Enough Administration 7 - Analyzing and debugging scripts Lesson 1: Debugging in Windows PowerShell Lesson 2: Analyzing and debugging an existing script 8 - Understanding Windows PowerShell Workflow Lesson 1: Understanding Windows PowerShell Workflows Lesson 2: Running Windows PowerShell Workflows
Duration 3 Days 18 CPD hours This course is intended for Project team members & Consultants In this course, students become familiar with logistics invoice verification as the final stage in the external procurement process. Students also learn how to enter invoices relating to purchase orders, block them, and release them for payment. Course Outline Introduction to invoice verification Invoice entry and parking Taxes, cash discounts, and foreign currency Invoices for purchase orders with account assignment Variances with and without reference to an item, invoice blocking reasons Invoice reduction, releasing blocked invoices Delivery costs Subsequent debits and credits Credit memos and cancellations Invoice verification in the background Automated processing GR/IR clearing account maintenance Customizing for invoice verification
Duration 1 Days 6 CPD hours This course is intended for This workshop is intended for Cloud Architects and IT professionals who have architectural expertise of infrastructure and solutions design in cloud technologies and want to learn more about Azure and Azure services Overview At the end of this whiteboard design session, you will leave with the information needed to develop a solid migration plan to keep mission-critical apps and data protected as they are transitioned and modernized. Topics covered will include how to get an inventory of a 2008 server environment, how to categorize 2008 workloads and evaluate the best option for each category, migration and upgrade tools available, TCO analysis tools, offers available from Microsoft to leverage existing licenses and innovations of recent product updates, licensing and technologies. This course will look at the process of migrating workloads to Azure. You will leave with the information needed to develop a solid migration plan to keep mission-critical apps and data protected as your customers transition and modernize their application, data, and infrastructure environment. Whiteboard Design Session - Windows Server 2008 and SQL Server 2008 end of support planning Review the customer case study Design a proof of concept solution Present the solution
Duration 3 Days 18 CPD hours This course is intended for Security administrators, developers, developer consultants, system administrators, and technology consultants. Overview This training course will focus on the authorization, security, and integrated scenario. In this course, students will focus on the authorization, security, and integrated scenarios for SAP HANA. Module 1 Creation of authorizations and authorization roles Module 2 User management Module 3 Access control for HANA native models Module 4 Authorization trace Module 5 Auditing Module 6 Authentication and single sign-on options Module 7 Encryption options Module 8 Security considerations for Multitenant Database Containers Module 9 SAP GRC Integration for Governance Risk and Compliance Module 10 HANA use case scenarios and security requirements Module 11 SAP Netweaver Identity Management integration Module 12 Reusing of BW authorizations for SAP HANA applications Module 13 HANA Cloud Platform (HCP) security Module 14 HANA Enterprise Cloud security
Duration 2 Days 12 CPD hours This course is intended for This course is recommended for technical professionals who need to install, configure, and manage multiple security domains within their network security environment. Overview Discuss challenges associated with securing large-scale business organizations with distributed network environments. Describe the Check Point Multi-Domain Security Management solution and its benefits. Understand the components of MDSM and how they work together to help administrators manage multiple network security environments within a single management framework. Understand how to install and configure the Multi-Domain Security Management environment. Describe how to implement Management High Availability within the MDSM environment. Discuss the two types of log server options used to store logs in the Multi-Domain Security Management environment, and how they differ. Understand how to manage and view Multi-Domain activity logs in SmartConsole. Understand how to configure and implement Global Policy to manage rules for multiple domains. Identify various MDSM command line tools commonly used to retrieve information and perform configuration changes on a MDSM Server. Describe troubleshooting tools to use for addressing MDSM Server issues. Understand how VSX works and how to integrate the technology within the MDSM environment. This course provides a comprehensive understanding of the Check Point Multi-Domain Security Management solution and describes how to deploy it within the corporate network environment. Course Outline Multi-Domain Security Management MDSM Installation and Configuration MDSM Log Management Global Policy Management MDSM Troubleshooting Incorporating VSX
Duration 1 Days 6 CPD hours This course is intended for This course is intended for students who want to use more advanced functionalities in Microsoft Word, including image manipulation, collaboration and revision tracking, cross- referencing and linking, document security, forms, and process automation through macros. Overview In this course, you will explore advanced functionalities in Word. You will: Use images in a document. Create custom graphic elements. Collaborate on documents. Add reference marks and notes. Secure a document. Create and manipulate forms. Create macros to automate tasks. Word for Microsoft 365 enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.Being able to manipulate graphics and efficiently create, manage, revise, and distribute long documents and forms can help your organization create important and interesting documents. Implementing time-saving features that enable you to work well in a collaborative mode will benefit both you and your organization. Constructing document elements that ensure your readers have access to pertinent information at the click of a button, while at the same time protecting sensitive information, is another important skill. Mastering these skills and techniques will make you a valued employee in your organization.Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will alsoenable you to access and effectively utilize many web-based resources provided with your Microsoft 365? subscription. Helpful notes throughout the material alert you to caseswhere the online version of the application may function differently from the primary, desktop version.This course may be a useful component in your preparation for theMicrosoft Word (Microsoft 365 Apps and Office 2019): Exam MO-100 and Microsoft Word Expert (Microsoft 365 Apps and Office 2019): Exam MO-101 certification exams. Lesson 1: Manipulating Images Topic A: Integrate Pictures and Text Topic B: Adjust Image Appearance Lesson 2: Using Custom Graphic Elements Topic A: Create Text Boxes and Pull Quotes Topic B: Add WordArt and Other Text Effects Topic C: Draw Shapes Topic D: Create Complex Illustrations with SmartArt Lesson 3: Collaborating on Documents Topic A: Share and Co-Author a Document Topic B: Mark Up a Document Topic C: Review Markups Topic D: Merge Changes from Other Documents Lesson 4: Adding Document References and Links Topic A: Add Captions Topic B: Add Cross-References Topic C: Add Bookmarks Topic D: Add Links Topic E: Insert Footnotes and Endnotes Topic F: Add Citations and a Bibliography Lesson 5: Securing a Document Topic A: Suppress Information Topic B: Set Formatting and Editing Restrictions Topic C: Restrict Document Access Topic D: Add a Digital Signature to a Document Lesson 6: Using Forms to Manage Content Topic A: Create Forms Topic B: Modify Forms Lesson 7: Automating Repetitive Tasks with Macros Topic A: Automate Tasks by Using Macros Topic B: Create a Macro Additional course details: Nexus Humans Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 3 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 Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 3 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 3 Days 18 CPD hours This course is intended for Application Consultant Business Analyst Business Process Architect Business Process Owner/Team Lead/Power User Developer Development Consultant Program/Project Manager Solution Architect Technology Consultant Overview This course will prepare you to: Understand the SAP Cloud Solution Understand the SAP Cloud Strategy Understand Java Development Understand development in SAP Cloud Classify and use the various Cloud Platform services Understand the various CP Services Explore the Internet of things Get an overview of SAP Cloud Platform, integration Service Understand Extensions of SAP Cloud Solutions This course will introduce and inform you about the vast potential of SAP Cloud Platform with hands-on exercises to dive into this open platform. SAP Cloud Platform, Introduction Introduce SAP Cloud Platform (SAP CP) Explain Landscape Architecture-Relevant Terms Learn about typical Use cases Explore What is in it: Product Capabilities and Services Platform Concepts Understand Basic Platform Concepts Explore Datacenters Understand Security Digital Transformation - Java Development Introduce Digital Transformation, Java Development Explore 12 Factor Microservices Use the Supported Java Development Environment Explain Supported Java Programming Models by CF Operate Java Applications on SAP Cloud Platform NEO Digital Transformation ? SAP HANA Development Understand SAP HANA Development Understand the SAP HANA XSA Development on CF Digital Transformation ? HTML5/SAPUI5/Fiori Development Introduce HTML5, SAPUI5, and Fiori Development Use SAP UI5 Use SAP Fiori Agile Business ? Extend Application Introduce Agile Business Understand the Application Frontend x-tend the Application: Backend Explore SAP Cloud Platform Data and Storage Services Enterprise Optimization ? Integration Services Introduce Enterprise Optimization, Integration Services Explore Available Integration Services Enterprise Optimization ? Process Integration Introduce SAP Cloud Platform, Integration Service Implement iFlows Enterprise Optimization ? API Explain API Management Build and Publish APIs Internet of Things Services (IoT) Explore the Internet of Things (IoT) Other Interesting Services and Features Explain SAP Cloud Platform SaaS Extensions Explore SAP Cloud Platform Business Services Explain Cloud Platform Data and Storage Understand SAP Cloud Platform Security
Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants/Modelers and Project team members. Overview Get an overview of SAP HANA SPS09 and in-memory computing.Build an analytic data model with native HANA modeling tools.Understand the different approaches to provision data into SAP HANA.Learn how to connect to SAP HANA and consume HANA models. In this course, students get an overview of SAP HANA SPS09 and in-memory computing. Students will also gain an understanding of the different approaches to provision data into SAP HANA. Key concepts of SAP HANAWorking with SAP HANA StudioArchitecture of SAP in-memory computingModeling with SAP HANA Attribute Views Analytic Views Calculation Views Overview of data provisioning in SAP HANA with the tools Flat file upload SAP BusinessObjects Data Services SAP Landscape Transformation Replication Server SAP Replication Server SAP Direct Extractor Connection Smart Data Access Smart Data Integration / Smart Data Quality Smart Data Streaming SAP HANA Interfaces to BI client tools SAP BusinessObjects Analysis for Office SAP Design Studio SAP Lumira Additional course details: Nexus Humans HA100 SAP HANA - Introduction 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 HA100 SAP HANA - Introduction 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 This course is intended for individuals who want to improve their phone skills. Overview Upon successful completion of this course, students will be more confident in handling the phone, resulting in new customers while retaining current clientele. In this course, students will learn about different types of calls and the etiquette associated with them. Getting Started Housekeeping Items Pre-Assignment Review Workshop Objectives The Parking Lot Action Plan Aspects of Phone Etiquette Phrasing Tone of Voice Speaking Clearly Listen to the Caller Case Study Using Proper Phone Language Please and Thank You Do Not Use Slang Avoid Using the Term ?You? Emphasize What You Can Do, Not What You Can?t Case Study Eliminate Phone Distractions Avoid Eating or Drinking Minimize Multi-Tasking Remove Office Distractions Do Not Let Others Interrupt Case Study Inbound Calls Avoid Long Greeting Messages Introduce Yourself Focus on Their Needs Be Patient Case Study Outbound Calls Be Prepared Identify Yourself and Your Company Give Them the Reason for the Call Keep Caller Information Private Case Study Handling Rude or Angry Callers Stay Calm Listen to the Needs Never Interrupt Identify What You Can Do For Them Handling Interoffice Calls Transferring Calls Placing Callers on Hold Taking Messages End the Conversation Case Study Handling Voicemail Messages Ensure the Voice Mail Has a Proper Greeting Answer Important Messages Right Away Ensure Messages are Delivered to the Right Person When Leaving A Message for Others... Case Study Methods of Training Employees Group Training One-on-One Training Peer Training Job Shadowing Case Study Correcting Poor Telephone Etiquette Screening Calls Employee Evaluations Peer Monitoring Customer Surveys Case Study Wrapping Up Words From The Wise Review Of The Parking Lot Lessons Learned Recommended Reading Completion Of Action Plans And Evaluations