8572 Trainers Course courses

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites * Basic understanding of relational databases. * Basic Windows knowledge. MODULE 1: INTRODUCTION TO TRANSACT-SQL * What is Transact-SQL * The SELECT statement * The WHERE clause * Sorting results * Calculations * CASE expressions MODULE 2: JOINING TABLES WITH TRANSACT-SQL * The JOIN clause * Inner joins * Outer joins * Self joins and cross joins MODULE 3: FILTERING AND SORTING RESULTS * Implement the ORDER BY clause * Filter data with the WHERE clause * Limit the number of rows returned by a query * Implement NULL logic MODULE 4: SQL SERVER DATA TYPES * Understand data types * Implement string data types * Implement temporal data types MODULE 5: INSERTING, UPDATING AND DELETING DATA * Insert new records * Update existing records * Delete data MODULE 6: USING SQL SERVER FUNCTIONS WITH TRANSACT-SQL * Understand function types in SQL Server * Convert data using functions * Implement logical functions * Work with NULL data using functions MODULE 7: AGGREGATING DATA WITH TRANSACT-SQL * Implement aggregation in SQL Server * Group records in SQL Server * Filter aggregated data MODULE 8: IMPLEMENT SUBQUERIES WITH TRANSACT-SQL * Implement scalar and multi-valued sub-queries * Implement correlated subqueries * Implement existence checks with subqueries MODULE 9: CREATE QUERIES THAT USE TABLE EXPRESSIONS * Create views * Create table-valued functions * Implement derived tables * Implement common table expressions MODULE 10: USE UNION, INTERSECT, EXCEPT AND APPLY ON MULTIPLE SETS OF DATA * Write queries with the UNION operator * Write queries with the INTERSECT and EXCEPT operators * Write queries with the APPLY operator MODULE 11: IMPLEMENT WINDOW FUNCTIONS IN QUERIES * Understand window functions * Impement window functions MODULE 12: USE PIVOT AND GROUPING SETS IN QUERIES * Implement PIVOT in queries * Implement grouping sets in queries MODULE 13: USE STORED PROCEDURES IN QUERIES * Query data with stored procedures * Interact with stored procedures using input and output parameters * Write simple stored procedures * Pass dynamic SQL to SQL Server MODULE 14: IMPLEMENT PROGRAMMING FEATURES IN TRANSACT-SQL * Understand T-SQL programming elements * Implement loops and conditions in T-SQL queries MODULE 15: ADD ERROR HANDLING TO QUERIES * Understand SQL Server error handling * Implemet structured exception handling MODULE 16: USE TRANSACTIONS IN QUERIES * Understand database transactions * Implement transactions in T-SQL

Duration 2 Days 12 CPD hours This course is intended for Executives, directors, managers, and others tasked with making important decisions for their organizations will benefit from this course. Overview Make intelligent decisions with limited time and information Reframe issues to ensure greater problem-solving accuracy Convert conflicting opinions into useful insights In this course, students will learn to evaluate options, generate possible solutions, and decide on logical strategies. 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 While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training. 1. THE COMPLEXITY OF DECISION MAKING * Establishing the Needs of the Organization * Defining Organizational Objectives and Goals * Measuring Your Goals * Calculating Probabilities of Success 2. DEALING WITH OPINION IN THE FACE OF UNCERTAINTY * Understanding Theories of Decision-Making * Avoiding Irrationality * Being Aware of Risks * Reframing the Options * Asking the Right Questions * Knowing What You Want * Making Proper Comparisons * Working with Stereotypes and Expectations 3. ADAPTING DECISION STRATEGIES FOR A COMPLEX WORLD * Reviewing Your Plans * Engaging Stakeholders * Enlisting Your Network * Managing Risks * Planning for Risks - Avoidance, Mitigation, Transference, and Acceptance * Applying Complexity Theory and the Butterfly Effect * Adjusting Decisions * Building in Metrics & Measurements * Monitoring Progress and Managing Risks * Looking for Emerging Trends ADDITIONAL COURSE DETAILS: Nexus Humans Making the Right Decisions Under Pressure 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 Making the Right Decisions Under Pressure 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 The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. Overview Navigate the Report Builder Environment. - Create table reports. - Format reports. - Create basic and complex expressions. - Group report data. - Create matrix reports. - Sort and filter data. - Summarize data with charts. - Print and export reports. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. Prerequisites ?Familiarity with Windows. ?Creating and navigating folders. ?Opening programs. ?Manipulating windows. ?Copying and pasting objects. ?Formatting text. ?Saving files. 1 - EXPLORING THE REPORT BUILDER ENVIRONMENT * Introducing the Report Builder Environment * Working with Existing Reports * Lab 1: Exploring the Report Builder Application 2 - ADDING DATA TO TABLE REPORTS * Create Report Data Sources * Create Report Datasets * Work with the Tablix Data Region * Create a Table Report * Lab 1: Creating Table Reports 3 - FORMATTING DATA AND CREATING EXPRESSIONS IN REPORTS * Formatting Reports * Sorting and Filtering Report Data * Adding Data to a Dataset * Creating Simple Expressions * Creating Complex Expressions * Lab 1: Formatting Reports 4 - GROUPING REPORT DATA * Group Data in Reports * Group Data Using an Expression * Creating Subgroups and Group Aggregates * Lab 1: Creating Reports with Groups and Aggregates 5 - MATRIX REPORTS * Creating and Modifying Matrix Data Regions * Creating and Modifying Column Groups * Lab 1: Creating Matrix Reports 6 - CHARTS * Create and Modify Chart Wizard Reports * Add Charts to Existing Reports * Modify Charts in Reports * Lab 1: Creating Charts and Chart Reports 7 - PRINTING AND EXPORTING REPORTS * Print Features and Print Options * Export Reports * Lab 1: Printing and Exporting Reports

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - PARAMETER REPORTS * Parameterized Reporting * Create Report Parameters * Modify Report Parameters * Provide Default Parameter Values * Provide Available Values for Parameters * Lab: Creating Parameterized Reports 2 - LIST DATA REGIONS * Introducing the List Data Region * Create Reports Using List Data Regions * Modify Reports Which Use List Data Regions * Lab: Creating List Reports 3 - ENHANCING REPORTS WITH COMPLEX EXPRESSIONS * Formatting Reports * Top N Reports * Running Values * Lab: Enhancing Reports with Complex Expressions 4 - ENHANCE REPORTS WITH IMAGES AND SUBREPORTS * Add Images to Reports * Retrieve Images from a Database * Introducing SSRS (SQL Server Reporting Services) Report Server * Add Subreports to Reports * Lab: Working With Images and Subreports 5 - DRILLDOWN AND DRILLTHROUGH REPORTS * Add and Configure Drilldown Reporting * Add and Configure Drillthrough Reporting * Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - SPARKLINES, DATA BARS, AND INDICATORS * Sparklines * Data Bars * Indicators * Lab: Adding Sparklines, Data Bars, and Indicators to Reports ADDITIONAL COURSE DETAILS: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 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 55128 Writing Reports with Report Builder and SSRS Level 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.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using Tableau to perform numerical or general data analysis, visualization, and reporting. They need to provide data visualizations from multiple data sources, or combine data to show comparisons, manipulate data through calculations, create interactive visualizations, or create visualizations that showcase insights from statistical analysis. This course is also designed for students who plan to obtain Tableau Desktop Certified Associate certification, which requires candidates to pass the Tableau Desktop Certified Associate exam. Overview Blend data multiple sources. Join data. Access data in PDFs. Refine visualizations with sets and parameters. Analyze data with calculations. Visualize data with advanced calculations. Perform statistical analysis and forecasting. Create geographic visualizations. Get answers with Ask and Explain The advent of cloud computing and storage has ushered in the era of "big data." With the abundance of computational power and storage, organizations and employees with many different roles and responsibilities can benefit from analyzing data to find timely insights and gain competitive advantage. Data-backed visualizations allow anyone to explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Beyond the fundamental capabilities of creating data driven visualizations, Tableau allows users to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. This gives users the ability to create and share data driven insights with peers, executives, and clients. Prerequisites Tableau Desktop: Part 1 LESSON 1: BLENDING DATA FROM MULTIPLE SOURCES * Topic A: Blend Data * Topic B: Refine Blends to Visualize Key Information LESSON 2: JOINING DATA * Topic A: Create Joins * Topic B: Troubleshoot Joins * Topic C: Merge Data with Unions LESSON 3: ACCESSING DATA IN PDFS * Topic A: Connect to PDFs * Topic B: Clean Up and Organize PDF Data LESSON 4: REFINING VISUALIZATIONS WITH SETS AND PARAMETERS * Topic A: Create Sets * Topic B: Analyze Data with Sets * Topic C: Apply Parameters to Refine Visualizations * Topic D: Create Advanced Visualizations LESSON 5: ANALYZING DATA WITH CALCULATIONS * Topic A: Create Calculated Fields to Analyze Data * Topic B: Manipulate Data with Functions * Topic C: Analyze Data with Table Calculations LESSON 6: VISUALIZING DATA WITH ADVANCED CALCULATIONS * Topic A: Create Groups and Bins with Calculations * Topic B: Analyze Data with LOD Expressions LESSON 7: PERFORMING STATISTICAL ANALYSIS AND FORECASTING * Topic A: Perform Statistical Analysis * Topic B: Forecast Data Trends LESSON 8: CREATING GEOGRAPHIC VISUALIZATIONS * Topic A: Create Maps * Topic B: Customize Mapped Data LESSON 9: GETTING ANSWERS WITH ASK AND EXPLAIN * Topic A: Ask Data * Topic B: Explain Data ADDITIONAL COURSE DETAILS: Nexus Humans Tableau Desktop - Part 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 Tableau Desktop - Part 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.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for individuals who need to present information effectively in a professional environment. Overview This program can benefit anyone who presents; a trainer, a meeting facilitator, speaker, or seminar discussion leader. No matter which role you are assuming, this workshop will help you become more efficient and proficient with the skills of providing information to others. In this course, students will learn active listening skills to facilitate the exchange of ideas in meetings and presentations. They will also organize your ideas to create coherent and convincing oral presentations. GETTING STARTED * Icebreaker * Housekeeping Items * The Parking Lot * Workshop Objectives CREATING THE PROGRAM * Performing a Needs Analysis * Writing the Basic Outline * Researching, Writing, and Editing CHOOSING YOUR DELIVERY METHODS * Basic Methods * Advanced Methods * Basic Criteria to Consider VERBAL COMMUNICATION SKILLS * Listening and Hearing: They Aren?t the Same Thing * Asking Questions * Communicating with Power NON-VERBAL COMMUNICATION SKILLS * Body Language * It?s Not What You Say, it?s How You Say It OVERCOMING NERVOUSNESS * Preparing Mentally * Physical Relaxation Techniques * Appearing Confident in Front of the Crowd CREATING FANTASTIC FLIP CHARTS * Required Tools * The Advantages of Pre-Writing * Using Colors Appropriately * Creating a Plan B CREATING COMPELLING POWERPOINT PRESENTATIONS * Required Tools * Tips and Tricks * Creating a Plan B WOW 'EM WITH THE WHITEBOARD * Traditional and Electronic Whiteboards * Using Colors Appropriately * Creating a Plan B VIBRANT VIDEOS AND AMAZING AUDIO * Required Tools * Tips and Tricks * Creating a Plan B PUMPING IT UP A NOTCH * Make Them Laugh a Little * Encourage Discussion * Dealing with Questions WRAPPING UP * Words from the Wise * Review of Parking Lot * Lessons Learned * Completion of Action Plans and Evaluations ADDITIONAL COURSE DETAILS: Nexus Humans Presentation Skills 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 Presentation Skills 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.

DG Awareness and Trailer Checks Course Details: Time: 8:00 AM - 4:30 PM Location: Birmingham Price: £69.95 Course overview: This comprehensive course combines essential Dangerous Goods (DG) Awareness training with practical instruction on Trailer Checks. Gain the knowledge and skills needed to handle, transport, and secure hazardous materials safely and comply with the latest December 2022 regulations. DG Awareness: * Understand the different hazard classes and types of dangerous goods. * Learn about the legal requirements for transporting and storing DG. * Discover the essential safety protocols for handling hazardous materials. * Identify and assess potential risks associated with DG. * Apply best practices for documentation and labeling. Trailer Checks: * Master the proper procedures for conducting thorough pre-journey and mid-journey trailer inspections. * Understand the essential components of a trailer and their potential faults. * Learn how to identify and report any damage or safety concerns. * Gain confidence in securing loads effectively and preventing trailer issues. Benefits: * Stay compliant with updated DG regulations. * Minimize workplace risks and ensure employee safety. * Improve efficiency and professionalism in handling DG. * Gain valuable skills for careers in transport, logistics, and related industries. Who should attend? This course is ideal for: * Drivers and transport operators * Warehouse personnel and logistics staff * Safety managers and supervisors * Anyone who handles, transports, or stores hazardous materials Don't miss this opportunity to enhance your knowledge and skills in DG awareness and trailer checks. Register now for £69.95 and secure your spot!

Duration 5 Days 30 CPD hours This course is intended for Microsoft Dynamics 365 Finance and Operations Apps Developers Overview By the end of this course, you will learn to develop fully realized solutions by using standardized application coding patterns. In this course, you will learn the tasks needed to fulfill the role of developer in Dynamics 365 Finance and Operations Apps. The Dynamics 365 for Finance and Operations (FO) developer is a key technical resource that implements and extends the application to meet the requirements of the business. MODULE 1: OVERVIEW & ARCHITECTUREN * Explore the ecosystem and main components * Explore the technical architecture * Explore design and deployment considerations MODULE 2: DEVELOPER TOOLS * Manage implementations by using Lifecycle Services * Manage source code by using version control * Customize by using Visual Studio MODULE 3: SOLUTION DESIGN * Implement application lifecycle management MODULE 4: AOT ELEMENTS * Build extended data types and enumerations * Build tables * Build forms and optimize form performance * Create classes * Create other user interface elements MODULE 5: CODE DEVELOPMENT & TESTING * Explore the test framework and use tools * Get started with development using X++ * Develop object-oriented code * Use RSAT tool MODULE 6: DATA MIGRATION * Prepare data for migration MODULE 7: FRAMEWORKS * Introduction * Explore extensions and the extension framework * Extend elements * SysOperationSandbox framework * Summary MODULE 8: INTEGRATION * Identify data integration patterns and scenarios * Implement data integration concepts and solutions * Implement the data management package API * Data integrations * Integrate with Microsoft Azure * Connecting to Power Platform services * Consume business events * Integrate Finance and Operations apps with Microsoft Dataverse MODULE 9: REPORTING * Explore the reporting tools * Build reports * Build workspaces * Manage data sources with external data stores MODULE 10: SECURITY & PERFORMANCE * Work with performance and monitoring tools * Implement role-based security * Apply basic performance optimization techniques ADDITIONAL COURSE DETAILS: Nexus Humans MB-500T00 Dynamics 365 - Finance and Operations Apps Developer 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 MB-500T00 Dynamics 365 - Finance and Operations Apps Developer 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.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Duration 2 Days 12 CPD hours This course is intended for * Professionals desiring to develop meaning engagement strategies to better connect with leadership, peers, and clients. * JOB ROLES: Personal Development Leader of Teams/Projects Leader of Managers/Departments Leader of Organizational Strategy Overview Develop better strategies in preparation and execution with audiences of all kinds Engage audience members more deeply and intently Optimize ability to prepare delivery, style, and transparency in sharing information Deliver your message with more clarity, purpose, and passion Create deeper meaning in who you are as a leader for others What?s the difference between good engagement and incredible engagement? How do you know when your audience, employees, or teammates are committed to everything you say and do? The answer is Authentic Engagement. When you notice amazing leaders, you will notice they possess all seven of these traits, regardless of whether they have been in the profession twenty years or twenty weeks. This course is the map toward shaping the next wave of leaders, regardless of style, audience, or modality! The question is: Are you ready to embark on your voyage? In this course, you will learn how to authentically engage others, build a more purposeful message that resonates, and learn the strategies to gain stronger engagement and input back from the people you work with. 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 CYA MODEL OF PREPARATION * Preparing Your Content * Learning the 4-Square to Holistic Content Delivery * Getting Ready for the Seven C?s for Engagement * Preparing for Yourself and Audience 2. PREPARING YOURSELF AND THE POWER OF YOUR DELIVERY * Understanding the Power of Delivery and Style * Learning when to be Transparent in your Approach * Understanding How You Shine Remotely vs. Face-to-Face * Understanding Your Command * Knowing What and When to Change Your Approach * Building Better Efficacy and Confidence 3. CAPTURING, BUILDING, AND CONNECTING WITH THE PEOPLE YOU ENGAGE * Learning the Differences between Surface-Level Engagement and Deeper Connection * Understanding the Four Levels of Audience to Build Relationships * Developing Captivation Techniques with Engagement * Establishing Clarity through Depth and Alignment * Connecting Deeper and Establishing Trust 4. GOING BEYOND FOR COMPLETENESS * Looking to the Future of Engagement, Technology, and Leadership * Plotting Your Next Course for Delivery * Using the Anchor Guide to Renew Your Approach * Mapping the Next Steps ADDITIONAL COURSE DETAILS: Nexus Humans Mastering Meaningful Engagement 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 Mastering Meaningful Engagement 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.