Duration 2.75 Days 16.5 CPD hours This course is intended for This course is designed for a person with an understanding of project management concepts, as well as general desktop computer skills, and who will be responsible for creating and maintaining project plans. This course will give you the fundamental understanding as well as acquiring the advanced knowledge and skills needed to update a project plan in Microsoft Project during the execution, monitoring, and controlling phases of a project. Overview Identify project management concepts and navigate Microsoft 2. 2. Project Professional. Create a new project plan. Add tasks to a project. Manage task relationships within a project. Manage project resources. fnalize a project plan. Update a project plan. Generate project views to manage a project. Create project reports to share a project's status. Reuse project plan information. Work with multiple projects. This course will familiarize the user with the basic features and functions of MS Project so that it can be used effectively and efficiently in a real-world environment. MS project will give the ability to project managers to update a project plan in Project during the execution, monitoring, and controlling phases of a project GETTING STARTED WITH MICROSOFT PROJECT Topic A: Identify Project Management Concepts Topic B: Navigate in the Microsoft Project Desktop environment DEFINING A PROJECT Topic A: Create a New Project Plan File Topic B: Set Project Plan Options Topic C: Assign a Project Calendar ADDING PROJECT TASKS Topic A: Add Tasks to a Project Plan Topic B: Enter Task Duration Estimates MANAGING TASKS Topic A: Create a Work Breakdown Structure Topic B: Define Task Relationships Topic C: Schedule Tasks MANAGING PROJECT RESOURCES Topic A: Add Resources to a Project Topic B: Create a Resource Calendar Topic C: Enter Costs for Resources Topic D: Assign Resources to Tasks Topic E: Resolve Resource Conflicts FINALIZING A PROJECT PLAN Topic A: Optimize a Project Plan Topic B: Set a Baseline Topic C: Share a Project Plan UPDATING A PROJECT PLAN Topic A: Enter Task Progress Topic B: Enter Overtime Work Topic C: Edit Tasks Topic D: Update Cost Rate Tables Topic E: Update a Baseline VIEWING PROJECT PROGRESS Topic A: Use View Commands Topic B: Add a Custom Field Topic C: Create Custom Views Topic D: Format and Share the Timeline View REPORTING ON PROJECT PROGRESS Topic A: View Built-in Reports Topic B: Create Custom Reports Topic C: Create a Visual Report REUSING PROJECT PLAN INFORMATION Topic A: Create a Project Plan Template Topic B: Share Project Plan Elements with Other Plans WORKING WITH MULTIPLE PROJECTS Topic A: Share Resources Topic B: Link Project Plans Additional course details: Nexus Humans Microsoft Project 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 Project 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 Deployment engineer Network engineer Sales engineer Overview After taking this course, you should be able to: Describe the Cisco conferencing architecture including cloud, hybrid, and on-premises conferencing Describe the physical deployment options and deployment models for Cisco Meeting Server, including Cisco Meeting Server 1000, 2000, and virtual machine Configure a Cisco Meeting Server single combined deployment for Web-Real Time Communications (WebRTC) endpoints within the enterprise Use APIs and the Cisco Meeting Server API Guide to configure profiles using Postman and the Webadmin API tool Configure a scalable and resilient deployment of Cisco Meeting Server with three servers for WebRTC endpoints within the enterprise Configure a scalable and resilient deployment of Cisco Meeting Server to support standard Session Initiation Protocol (SIP) and WebRTC connectivity outside the enterprise Configure a scalable and resilient deployment of Cisco Meeting Server to support recording and streaming of conferences Configure Cisco Unified Communications Manager and Cisco Meeting Server to support Rendezvous, Scheduled, and Ad-hoc conferencing for Cisco Unified CM registered endpoints Configure Cisco Meeting Server to integrate with a preconfigured on-premise Microsoft Skype for Business installation Install Cisco TelePresence Management Suite (Cisco TMS) and Cisco TelePresence Management Suite for Microsoft Exchange (Cisco TMSXE) on a single Microsoft Windows 2012 server and connect to an existing SQL environment Install and integrate Cisco Meeting Management with Cisco TMS and Cisco Meeting Server Set up and manage a scheduled conference with Cisco TMS and Cisco Meeting Management Capture and analyze logs from Cisco Meeting Server and Cisco Meeting Manager to diagnose faults, including a SIP connection error The Implementing Cisco Collaboration Conferencing (CLCNF) v1.0 course focuses on Cisco© on-premises conferencing architecture and solutions. You will gain knowledge and skills to design and implement common conferencing deployment scenarios of Cisco Meeting Server, its integration with call control features such as Cisco Unified Communications Manager and Cisco Expressway, and other Cisco collaboration conferencing devices.This course offers lessons and hands-on labs to prepare you for the 300-825 Implementing Cisco Collaboration Conferencing (CLCNF) exam. Course outline Describing Cisco Conferencing Architecture Configuring a Single Combined Deployment Installing Cisco Meeting Server Using APIs with Cisco Meeting Server Configuring a Cisco Meeting Server Scalable and Resilient Deployment Configuring Business to Business (B2B) and WebRTC Firewall Traversal Connectivity for Cisco Meeting Server Configuring Recording and Streaming with Cisco Meeting Server Troubleshooting Cisco Meeting Server Integrating Cisco Meeting Server with Cisco Unified CM Integrating Cisco Meeting Server with Microsoft Skype for Business Installing and Operating Cisco TMS and Cisco TMSXE Installing and Integrating Cisco Meeting Management Additional course details: Nexus Humans Cisco Implementing Cisco Collaboration Conferencing v2.0 (CLCNF) 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 Cisco Implementing Cisco Collaboration Conferencing v2.0 (CLCNF) 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 To fully benefit from this course, you should have three to five years of experience designing and implementing applications that are built on top of Cisco platforms. This course is appropriate for: Network engineers expanding their skill-base to include software and automation Developers expanding expertise in automation and DevOps Solution architects moving to the Cisco ecosystem Infrastructure developers designing hardened production environments The job roles best suited to the material in this course are: Senior network automation engineer Senior software developer Senior system integration programmer Additional job roles that could find this course useful are: Senior infrastructure architect Senior network designer Senior test development engineer Students preparing for Cisco Certified DevNet Professional and Cisco Certified DevNet Specialist - Core certification will also find this material useful. Overview After taking this course, you should be able to: Describe the architectural traits and patterns that improve application maintainability Describe the architectural traits and patterns that improve application serviceability Identify steps to design and build a ChatOps application Implement robust Representational State Transfer (REST) API integrations with network error handling, pagination, and error flow control Describe the necessary steps for securing user and system data in applications Describe the necessary steps for securing applications Identify common tasks in automated application release process Describe best practices for application deployment Describe methodologies for designing distributed systems Describe the concepts of infrastructure configuration management and device automation Utilize Yet Another Next Generation (YANG) data models to describe network configurations and telemetry Compare various relational and nonrelational database types and how to select the appropriate type based on requirements In this course, you will learn how to implement network applications using Cisco© platforms as a base, from initial software design to diverse system integration, as well as testing and deployment automation. The course gives you hands-on experience solving real world problems using Cisco Application Programming Interfaces (APIs) and modern development tools. This course helps you prepare for Cisco DevNet Professional certification and for professional-level network automation engineer roles. COURSE OUTLINE DESIGNING FOR MAINTAINABILITY (SELF-STUDY) DESIGNING FOR SERVICEABILITY (SELF-STUDY) IMPLEMENTING CHATOPS APPLICATION DESCRIBING ADVANCED REST API INTEGRATION SECURING APPLICATION DATA (SELF-STUDY) SECURING WEB AND MOBILE APPLICATIONS (SELF-STUDY) AUTOMATING APPLICATION-RELEASE DEPLOYING APPLICATIONS UNDERSTANDING DISTRIBUTED SYSTEMS ORCHESTRATING NETWORK AND INFRASTRUCTURE MODELING DATA WITH YANG USING RELATIONAL AND NON-RELATIONAL DATABASES (SELF-STUDY) PLEASE NOTE:This class includes lecture sections and self-study sections. In instructor-led classes, lectures are delivered in real-time, either in person or via video conferencing. In e-learning courses, the lectures are on recorded videos. In both versions, you will need to review self-study sections on your own before taking the certification exam. Additional course details: Nexus Humans Cisco Developing Applications Using Cisco Core Platforms and APIs v1.0 (DEVCOR) 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 Cisco Developing Applications Using Cisco Core Platforms and APIs v1.0 (DEVCOR) 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 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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 Students in this course are interested in Microsoft 365 development platform or in passing the Microsoft 365 Developer Associate certification exam. Students should also have 1-2 years experience as a developer. This course assumes students know how to code and have a basic understanding of REST APIs, JSON, OAuth2, OData, OpenID Connect, Microsoft identities including Azure AD and Microsoft accounts, Azure AD B2C, and permission/consent concepts. Overview Implementing Microsoft Identity Working with Microsoft Graph Determining workload platform targets Integration Points, including Microsoft Teams, Office Add-ins, and SharePoint Framework This course covers five central elements of Microsoft 365 platform ? implementing Microsoft Identity, working with Microsoft Graph, extending and customizing SharePoint, extending Teams, and extending Office. In this course, students will learn how to implement Microsoft Identity and work with Microsoft Graph. Students will also gain the knowledge on UI elements (including Adaptive Cards and UI Fabric), Integration Points (including Microsoft Teams, Office Add-ins, SharePoint Framework, Actionable Messages), and determining workload platform targets. In implementing Microsoft Identity, students will learn to implement Microsoft identity including registering an application, implanting authentication, configuring permissions to consume an API, and creating a service to access Microsoft Graph. In working with Microsoft Graph, students will learn how to access user data, explore query parameters, manage a group lifecycle, access files, and optimize network traffic using Microsoft Graph. In extending and customizing SharePoint, students will learn about SharePoint Framework web parts, extensions, and how to package and deploy a SPFx solution. In extending Teams, students will look at the components of a Teams App, work with webhooks, tabs, and conversational bots. In extending Office, students work with Office Add-ins, task pane add-ins, JavaScript APIs, Office UI Fabric, and actionable messages with adaptive cards. Implement Microsoft Identity Microsoft Identity platform Register an Application Implement Authentication Configure Permissions to consume an API Implement Authorization to consume an API Implement Authorization in an API Create a Service to access Microsoft Graph Work with Microsoft Graph What is Microsoft Graph Access user data from Microsoft Graph Data usage with query parameters Manage a group lifecycle on Microsoft Graph Access files with Microsoft Graph Optimize network traffic Extend and Customize SharePoint SharePoint Framework web parts SharePoint Framework extensions Package and deploy a SPFx solution Consumption of Microsoft Graph Consumption of 3rd party APIs secured with Azure AD from within SPFx Web Parts as Teams Tabs Branding and theming in SharePoint Extend Teams Microsoft Teams App Webhooks in Microsoft Teams Tabs in Microsoft Teams Messaging extensions in Microsoft Teams Conversational bots in Microsoft Teams Extend Office Office Add-ins Office JS APIs Customization of Add-ins Testing, debugging, and deployment options Actionable message Additional course details: Nexus Humans MS-600T00 Building Applications and Solutions with Microsoft 365 Core 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 MS-600T00 Building Applications and Solutions with Microsoft 365 Core 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.
Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for application programmers who need to write embedded SQL COBOL or PL/I programs in either a DB2 9 or DB2 10 for z/OS environment. Overview Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution. CV720G;CF82G;DB2 Concepts Identify DB2 family products Explain DB2 workstation component functions Identify DB2 objects Identify the key differences between static SQL and other application alternatives for accessing DB2 data Program Structure I Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs Effectively communicate with DB2 when processing NULL values and determining success of statement execution Demonstrate use of DB2 coding aids Code CONNECT statements within an application program Identify connection types and impacts on a unit of work Program for the Call Attach Facility (CAF) Program Preparation Identify the additional steps necessary to prepare a program that contains embedded SQL for execution Describe the functions of the DB2 PRECOMPILE and BIND processes Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements Program Structure II Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs Issue positioned UPDATE and DELETE statements Identify how scrollable cursors can be used Recovery and Locking Concepts Define a unit of recovery Identify the basic locking strategies used by DB2 Dynamic SQL Introduction Describe the difference between static and dynamic SQL List the types of dynamic statements Code dynamic SQL in a program Managing Test Data Identify methods to insert data into a table Use the LOAD or IMPORT utility Identify the purpose of the RUNSTATS utility Identify the purpose of the REORG utility Performance Considerations Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts Identify the access paths available to DB2 List common causes of deadlocks and avoid such causes when possible Use the EXPLAIN tools as aids to develop applications that emphasize performance Additional course details: Nexus Humans CV722 IBM DB2 11 for z/OS Application Programming Workshop 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 CV722 IBM DB2 11 for z/OS Application Programming Workshop 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 designed primarily for professionals in the following job roles: Collaboration engineers Collaboration administrators Overview After taking this course, you should be able to: Configure Cisco Unity Connection integration Configure and troubleshoot Cisco Unity Connection and Cisco Unity Connection call handlers Configure and troubleshoot Cisco Unity Express Describe SSO for Cisco Unified Communications applications Describe how Cisco Jabber and Cisco Unified Communications Manager IM and Presence are integrated with other Cisco or third-party applications Customize the Cisco Unified Communications Manager IM and Presence and Cisco Jabber functionality Configure and troubleshoot chat rooms and message archiving Troubleshoot Cisco Jabber and Cisco Unified Communications Manager IM and Presence Integrate Cisco Unified Attendant Console Advanced with Cisco Unified Communications Manager and Cisco Unified Communications Manager IM and Presence server Configure call recording and monitoring This course provides you with the knowledge and skills to streamline communication procedures, strengthen compliance measures, and enhance your communication systems and devices with knowledge about Single Sign-On (SSO), Cisco© Unified IM and Presence, Cisco Unity© Connection and Cisco Unity Express. This course will prepare you for certification exam 300-810 Implementing Cisco Collaboration Applications (CLICA). Course Outline Configuring and Troubleshooting Cisco Unity Connection Integration Configuring and Troubleshooting Cisco Unity Connection Call Handlers Troubleshooting Cisco Unity Connection Configuring and Troubleshooting Cisco Unity Express Configuring Single Sign-On (SSO) for Cisco Unified Communications Applications Integrating Cisco Unified Communications Manager IM and Presence and Cisco Jabber Customizing Cisco Unified Communications Manager IM and Presence and Cisco Jabber Functionality Configuring Cisco Unified Communications Manager IM and Presence Service Compliance and Message Archiving Troubleshooting Cisco Unified Communications Manager IM and Presence Service Integrating Cisco Unified Attendant Console Advanced Implementing Call Recording and Monitoring Lab outline Integrate and Set Up Cisco Unity Connection Configure Cisco Unity Connection Call Handlers Implement Toll Fraud Prevention Troubleshoot Cisco Unity Connection Call Handlers Troubleshoot Cisco Unity Connection Configure Cisco Unity Express Troubleshoot Cisco Unity Express Configure Cisco Unified Communications Manager IM and Presence High Availability Implement Cisco Jabber Configure Centralized Cisco Unified Communications Manager IM and Presence Configure Cisco Unified Communications Manager IM and Presence Service Functionality Enable Message Archiving and Chat Rooms Troubleshoot the Cisco Unified Communications IM and Presence Database Connection Troubleshoot Cisco Unified Communications Manager IM and Presence High Availability Troubleshoot Cisco Unified Communications Manager IM and Presence Service Integrate Cisco Unified Attendant Console Advanced Implement Call Recording and Monitoring Using a Switched Port Analyzer (SPAN)-based Solution Implement Cisco Unified Communications Manager Call Recording and Monitoring Additional course details: Nexus Humans Cisco Implementing Cisco Collaboration Applications v1.0 (CLICA) 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 Cisco Implementing Cisco Collaboration Applications v1.0 (CLICA) 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 designed for individuals who may need to present information effectively in a professional environment. Overview Define what makes a presentation effective. Plan presentations. Design a presentation framework. Develop the presentation body. Create supporting materials. Prepare for your presentation. Deliver presentations. Conduct a question-and-answer session. Deliver group presentations and virtual presentations. The ability to deliver presentations is vital to achieving advancement for yourself and for your ideas. Few skills in life will contribute to your success as much as presentation skills. Without a dynamic and coherent presentation, even stellar ideas can fail to convince your audience. In this course, you will learn to organize your ideas to create coherent and convincing oral presentations, while also utilizing available visual aids and using public-speaking techniques to strengthen your delivery. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. Prerequisites To ensure your success, you will need to have experience writing in a professional context and creating presentations using Microsoft Office PowerPoint. 1. Defining Presentation Effectiveness Identify Qualities of Effective Presentations Evaluate Yourself as a Presenter 2. Planning Presentations Analyze the Audience Establish Your Presentation\'s Objectives 3. Designing the Presentation Create the Presentation Structure Organize the Presentation Body Write the Conclusion First Write the Introduction 4. Developing the Presentation Body Select Evidence Write the Presentation Body Create Visuals 5. Creating Supporting Materials Create a Slide Deck Create Speaker Aids Create Audience Handouts 6. Preparing for Your Presentation Rehearse the Presentation Plan Event Logistics 7. Delivering Presentations Connect with Your Audience Present Powerfully Utilize a Slide Deck Effectively 8. Conducting a Question-and-Answer Session Answer Questions Handle Challenging Questions 9. Presenting in Common Business Scenarios Plan and Deliver a Virtual Presentation Plan and Deliver Group Presentations 10. Key Course Information This course focuses on the skills necessary to prepare and deliver an effective presentation; that being said, the learner will not be creating, delivering, or designing a specific presentation from start to finish in this course (this course only provides the foundational knowledge for doing this work back at the office). This course consists of instructor lecture along with course activities corresponding with the main course objectives. In terms of the course activities, 50% will be discussion based - 25% will be in a group-work format - and 25% will be hands-on/involve a digital tool, such as a PowerPoint or Word file. The intent is for students leaving this course to take the skills learned and apply them to their efforts of creating more effective presentations upon returning to the workplace. Additional course details: Nexus Humans Effective Presentations (Second Edition) 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 Effective Presentations (Second Edition) 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 beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment. Overview Describe several services provided in a z/OS environmentExplain workloads in the batch environmentExplain workloads in the online environmentDescribe job roles in a z/OS environmentLog On to TSO/ENavigate TSO/E and ISPFUse TSO commandsSetup and utilize JCL (Job Control Language)Utilize SDSFDescribe the different types of data sets in a z/OS environmentAllocate data sets and list data set information and contentCreate and modify data set contentGive an overview of the DB2 9 environmentDescribe and utilize DB2 ObjectsDescribe and utilize several DB2 UtilitiesDescribe the DB2I (DB2 Interactive Facility) environmentUse SPUFI (SQL Processing Using File Input) to compose and execute SQLSetup and execute DB2 CommandsUnderstand DB2 LoggingDescribe DB2 program preparation processUnderstand DB2 startup and shutdownUnderstand and utilize DB2 recovery strategies This course is intended for students looking to develop fundamental skills or recognition through lectures and hands-on exercises of TSO/E and ISPF, data sets, DB2 objects, Structured Query Language, DB2 commands, JCL and SDSF. Day 1 Welcome Unit 1: Introduction Unit 2: TSO/E and ISPF Exercise 1: TSO and ISPF Exercise 1 Review Unit 3: Data Sets (Data Sets and Sequential Data Sets) Exercise 2: Sequential Data Sets Exercise 2 Review Day 2 Unit 3: Data Sets (Partitioned Data Sets) Exercise 3: Partitioned Data Sets Exercise 3 Review Unit 3: Data Sets (VSAM Data Sets) Exercise 4: VSAM Data Sets Exercise 4 Review Unit 4: JCL and SDSF Exercise 5: JCL and SDSF Exercise 5 Review Day 3 Unit 5: DB2 Relational Database Concepts Unit 6: Structured Query Language (SQL) and SPUFI Exercise 6: SQL and SPUFI Exercise 6 Review Unit 7: DB2 Objects (Databases and Table Spaces) Exercise 7: Databases and Table Spaces Exercise 7 Review Unit 7: DB2 Objects (Tables, Indexes, and Views) Exercise 8: Tables, Indexes, and Views Exercise 8 Review Day 4 Unit 7: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements) Exercise 9: Qualified Names, Implicit Object Creation, and SQL Statements Exercise 9 Review Unit 8: The DB2 System Exercise 10: The DB2 System Exercise 10 Review Unit 9: DB2 Commands and Program Preparation Exercise 11: DB2 Commands Exercise 11 Review Day 5 Unit 10: DB2 Utilities Exercise 12: DB2 Utilities Exercise 12 Review Unit 11: DB2 Shutdown, Startup, and Recovery Exercise 13: DB2 Recovery Exercise 13 Review Unit 12: Course Summary Additional course details: Nexus Humans CV041 IBM z/OS and DB2 Basics for DB2 for z/OS DBA Beginners 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 CV041 IBM z/OS and DB2 Basics for DB2 for z/OS DBA Beginners 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 designed for students looking to establish a foundational understanding of Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. Overview In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports. Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft© Access© can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access. Microsoft© Access© for Office 365?: Part 1 (this course): Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. Microsoft© Access© for Office 365?: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports. Microsoft© Access© for Office 365?: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database. This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Working with an Access Database Topic A: Launch Access and Open a Database Topic B: Use Tables to Store Data Topic C: Use Queries to Combine, Find, Filter, and Sort Data Topic D: Use Forms to View, Add, and Update Data Topic E: Use Reports to Present Data Topic F: Get Help and Configure Options in Access Lesson 2: Creating Tables Topic A: Plan an Access Database Topic B: Start a New Access Database Topic C: Create a New Table Topic D: Establish Table Relationships Lesson 3: Creating Queries Topic A: Create Basic Queries Topic B: Add Calculated Columns in a Query Topic C: Sort and Filter Data in a Query Lesson 4: Creating Forms Topic A: Start a New Form Topic B: Enhance a Form Lesson 5: Creating Reports Topic A: Start a New Report Topic B: Enhance Report Layout Additional course details: Nexus Humans Microsoft Access for Office 365: Part 1 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 Access for Office 365: Part 1 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.