8572 Trainers Course courses

Duration 1 Days 6 CPD hours Writing is a key method of communication for most people, and it?s one that many people struggle with. This workshop will give participants a refresher on basic writing concepts (such as spelling, grammar, and punctuation), and an overview of the most common business documents (such as proposals, reports, and agendas), giving you that extra edge in the workplace. 1 - GETTING STARTED * Workshop Objectives * Pre-Assignment Review 2 - WORKING WITH WORDS * Spelling * Grammar * Creating a Cheat Sheet 3 - CONSTRUCTING SENTENCES * Parts of a Sentence * Punctuation * Types of Sentences 4 - CREATING PARAGRAPHS * The Basic Parts * Organization Methods 5 - WRITING MEETING AGENDAS * The Basic Structure * Choosing a Format * Writing the Agenda 6 - WRITING E-MAILS * Addressing Your Message * Grammar and Acronyms 7 - WRITING BUSINESS LETTERS * The Basic Structure * Choosing a Format * Writing the Letter 8 - WRITING PROPOSALS * The Basic Structure * Choosing a Format * Writing the Proposal 9 - WRITING REPORTS * The Basic Structure * Choosing a Format * Writing the Report 10 - OTHER TYPES OF DOCUMENTS * Requests for Proposals * Projections * Executive Summaries * Business Cases 11 - PROOFREADING AND FINISHING * A Proofreading Primer * How Peer Review Can Help * Printing and Publishing 12 - WRAPPING UP * Words from the Wise ADDITIONAL COURSE DETAILS: Nexus Humans Business Writing 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 Business Writing 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 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 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - INTRODUCTION TO TRANSACT-SQL * Work with schemas * Explore the structure of SQL statements * Examine the SELECT statement * Work with data types * Handle NULLs 2 - SORT AND FILTER RESULTS IN T-SQL * Sort your results * Limit the sorted results * Page results * Remove duplicates * Filter data with predicates 3 - COMBINE MULTIPLE TABLES WITH JOINS IN T-SQL * Understand joins concepts and syntax * Use inner joins * Use outer joins * Use cross joins * Use self joins 4 - WRITE SUBQUERIES IN T-SQL * Understand subqueries * Use scalar or multi-valued subqueries * Use self-contained or correlated subqueries 5 - USE BUILT-IN FUNCTIONS AND GROUP BY IN TRANSACT-SQL * Categorize built-in functions * Use scalar functions * Use ranking and rowset functions * Use aggregate functions * Summarize data with GROUP BY * Filter groups with HAVING 6 - MODIFY DATA WITH T-SQL * Insert data * Generate automatic values * Update data * Delete data * Merge data based on multiple tables ADDITIONAL COURSE DETAILS: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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 Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites * SQL Querying Fundamentals - Part 1 1 - USING SUBQUERIES TO PERFORM ADVANCED QUERYING * Search Based on Unknown Values * Compare a Value with Unknown Values * Search Based on the Existence of Records * Generate Output Using Correlated Subqueries * Filter Grouped Data Within Subqueries * Perform Multiple-Level Subqueries 2 - MANIPULATING TABLE DATA * Insert Data * Modify and Delete Data 3 - MANIPULATING THE TABLE STRUCTURE * Create a Simple Table * Create a Table with Constraints * Add or Drop Table Columns * Add or Drop Constraints * Modify the Column Definition * Back Up Tables * Delete Tables 4 - WORKING WITH VIEWS * Create a View * Manipulate Data in Views * Create Aliases * Modify and Drop Views 5 - INDEXING DATA * Create Indices * Drop Indices 6 - MANAGING TRANSACTIONS * Create Transactions * Commit Transactions

Duration 1 Days 6 CPD hours This course is intended for This course is intended for new managers, especially those with direct reports, who are responsible for increasing employee motivation and job performance. This course will assist students in understanding and implementing strategies that will help to motivate their work force. 1 - GETTING STARTED * Workshop Objectives * Pre-Assignment Review 2 - A PSYCHOLOGICAL APPROACH * Herzberg?s Theory of Motivation * Maslow?s Hierarchy of Needs * The Two Models and Motivation * Case Study * Module Two: Review Questions 3 - OBJECT-ORIENTED THEORY * The Carrot * The Whip * The Plant * Case Study * Module Three: Review Questions 4 - USING REINFORCEMENT THEORY * A History of Reinforcement Theory * Behavior Modification in Four Steps * Appropriate Uses in the Workplace * Case Study * Module Four: Review Questions 5 - USING EXPECTANCY THEORY * A History of Expectancy Theory * Understanding the Three Factors * Using the Three Factors to Motivate in the Workplace * Case Study * Module Five: Review Questions 6 - PERSONALITY'S ROLE IN MOTIVATION * Identifying Your Personality Type * Identifying Others? Personality Type * Motivators by Personality Type * Case Study * Module Six: Review Questions 7 - SETTING GOALS * Goals and Motivation * Setting SMART Goal * Evaluating and Adapting * Case Study * Module Seven: Review Questions 8 - A PERSONAL TOOLBOX * Building Your Own Motivational Plan * Encouraging Growth and Development * Getting Others to See the Glass Half-Full * Case Study * Module Eight: Review Questions 9 - MOTIVATION ON THE JOB * The Key Factors * Creating a Motivational Organization * Creating a Motivational Job * Case Study * Module Nine: Review Questions 10 - ADDRESSING SPECIFIC MORALE ISSUES * Dealing with Individual Morale Problems * Addressing Team Morale * What to Do When the Whole Company is De-Motivated * Case Study * Module Ten: Review Questions 11 - KEEPING YOURSELF MOTIVATED * Identifying Personal Motivators * Maximizing Your Motivators * Evaluating and Adapting * Case Study * Module Eleven: Review Questions 12 - WRAPPING UP * Words from the Wise ADDITIONAL COURSE DETAILS: Nexus Humans Employee Motivation 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 Employee Motivation 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 Managers, directors, executives, and others responsible for leading teams, overseeing projects, and developing new leaders will benefit from this course. Overview Bring about valuable and positive change in those you lead Increase engagement, motivation and morale in your team Enhance performance of individuals and the team Provide an authentic role model that inspires followership Develop others into leaders This course will help students develop authentic leadership qualities that motivate and drive others to reach their full potential, and become the transformational leaders of the future. 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. 1. DEFINING TRANSFORMATIONAL LEADERSHIP * Comparing Leadership Styles * Developing the Attitudes and Beliefs of a Transformational Leader 2. BEING AN AUTHENTIC LEADER * Knowing Who You Are * Fostering Authenticity and Credibility 3. DEMONSTRATING LEADERSHIP PRACTICE * Following the Five Practices of Exemplary Leadership 4. BUILDING ENGAGEMENT AND MOTIVATION * Understanding the Drivers of Employee Engagement * Motivating Like a Transformational Leader 5. OPTIMIZING PERFORMANCE * Coaching for Performance * Supporting Performance through Partnership * Unlocking Potential * Developing and Transforming Careers 6. MENTORING LEADERS * Growing Leaders * Putting Relationships First * Focusing on Character * Capitalizing on Strengths * Showing Optimism and Not Skepticism * Seeking Passion and Success 7. COMMITTING TO TRANSFORMATIONAL LEADERSHIP

Duration 1 Days 6 CPD hours Overview Students will come away with knowledge and skills to become a top-notch team performer. This workshop will encourage you to explore the different aspects of a team, as well as ways that they can become a top-notch team performer. 1 - GETTING STARTED * Icebreaker * Housekeeping Items * The Parking Lot * Workshop Objectives 2 - DEFINING SUCCESS * What is a Team? * An Overview of Tuckman and Jensen's Four-Phase Model 3 - TYPES OF TEAMS * The Traditional Team * Self-Directed Teams * E-Teams 4 - THE FIRST STAGE OF TEAM DEVELOPMENT-FORMING * Hallmarks of This Stage * What To Do As A Leader * What To Do As A Follower 5 - THE SECOND STAGE OF TEAM DEVELOPMENT-STORMING * The Hallmarks of This Stage * What To Do As A Leader * What To Do As A Follower 6 - THE THIRD STAGE OF TEAM DEVELOPMENT-NORMING * The Hallmarks of This Stage * What To Do As A Leader * What To Do As A Follower 7 - THE FOURTH STAGE OF TEAM DEVELOPMENT-PERFORMING * Hallmarks of This Stage * What To Do As A Leader * What To Do As A Follower 8 - TEAM BUILDING ACTIVITIES * The Benefits and Disadvantages * Team-Building Activities That Won't Make People Cringe * Choosing a Location for Team-Building 9 - MAKING THE MOST OF TEAM MEETINGS * Setting the Time and Place * Trying the 50-Minute Meeting * Using Celebrations of All Sizes 10 - SOLVING PROBLEMS AS A TEAM * The Six Thinking Hats * Encouraging Brainstorming * Building Consensus 11 - ENCOURAGING TEAMWORK * Some Things to Do * Some Things to Avoid * Some Things to Consider 12 - WRAPPING UP * Words from the Wise * Review of Parking Lot * Lessons Learned * Completion of Action Plans ADDITIONAL COURSE DETAILS: Nexus Humans Teamwork and Team Building 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 Teamwork and Team Building 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 New managers wanting to become skilled in their management roles will benefit from this course Overview Describe the roles that a manager has in an organization Identify and nurture talent in your team Build a management vision for success Create strategies to motivate and empower your team Combine leadership qualities and influence skills to motivate your team Plan and manage effective meetings In this course, students will learn how to confidently acquire and build these skills through relevant discussions, team and individual activities. 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. 1. THE MANAGER\'S ROLE * Distinguishing a Manager\'s Role from Function Understanding Interpersonal, Informational, and Decision Roles 2. BUILDING A SHARED VISION * Defining a Shared Vision Building a Strong Vision Creating and Communicating a Vision Statement Identifying Benefits of Your Vision 3. LEADERSHIP AND INFLUENCE * Identifying the Characteristics and Qualities of a Leader Modeling the Way and Enabling Others to Act Encouraging Your Inner Innovator and Mastering the Art of Persuasion Creating Mutual Respect Effectively Communicating and Reasoning with Others 4. NURTURING TALENT * Calibrating Talent Finding and Nurturing the Attributes that Meet Your Requirements Articulating Culture and Hiring for a Cultural Fit Looking to the Future - Developing and Executing a Plan Succession Planning Creating and Fostering Employee Engagement Coaching, Training, and Development 5. DELEGATION AND EMPOWERMENT * Working with Workgroups and Teams Delegating Progress Tracking and Reviewing Results 6. BUILDING A BETTER MEETING * Planning and Preparing a Meeting Identifying Proper Participants Creating an Agenda Evaluating the Use of Technology ADDITIONAL COURSE DETAILS: Nexus Humans Evolving into the Manager Role 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 Evolving into the Manager Role 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 The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. MODULE 1: INTRODUCTION TO DATABASES * Introduction to Relational Databases * Other Databases and Storage * Data Analysis * SQL Server Database Languages MODULE 2: DATA MODELING * Data Modelling * Designing a Database * Relationship Modeling MODULE 3: NORMALIZATION * Fundamentals of Normalization * Normal Form * Denormalization MODULE 4: RELATIONSHIPS * Introduction to Relationships * Planning Referential Integrity MODULE 5: PERFORMANCE * Indexing * Query Performance * Concurrency MODULE 6: DATABASE OBJECTS * Tables * Views * Stored Procedures, Triggers and Functions

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. USING VBA TO SOLVE BUSINESS PROBLEMS * Use Macros to Automate Tasks in Excel * Identify Components of Macro-Enabled Workbooks * Configure the Excel VBA Environment 2. RECORDING A MACRO * Use the Macro Recorder to Create a VBA Macro * Record a Macro with Relative Addressing * Delete Macros and Modules * Identify Strategies for Using the Macro Recorder 3. WRITING VBA CODE DIRECTLY * Write VBA Code * Discover Objects You Can Use * Create a Custom Function 4. SOLVING PROBLEMS THROUGH CODE * Make Decisions in Code * Work with Variables * Perform Repetitive Tasks 5. IMPROVING YOUR VBA CODE * Debug VBA Errors * Deal with Errors * Improve Macro Performance 6. CONTROLLING HOW AND WHEN MACROS RUN * Prompt the User for Information * Configure Macros to Run Automatically ADDITIONAL COURSE DETAILS: Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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.