5529 Courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

This course bundle is ideal for anyone looking to launch their Cisco networking career, specifically in Cisco cyber ops and security. It consists of one Cisco Certified Technician (CCT) certification in Routing and Switching, one Cisco Certified Network Associate (CCNA) certification, one Cisco Certified CyberOps Associate certification, and one Cisco Certified Networking Professional (CCNP) certifications, specialising in Cisco security. Although there are no formal prerequisites to enrol on the CCNA, or CCNP certification courses and sit the exams, learners should have a good foundation knowledge in networking. The Cisco Certified Technician Routing and Switching (CCT Routing and Switching) certification focuses on the skills required for onsite support and maintenance of Cisco routers, switches, and operating environments. It’s a great starting point if you’re new to Cisco networking. Technicians in this area must be able to identify Cisco router and switch models, accessories, cabling, and interfaces; understand the Cisco IOS Software operating modes and identify commonly found software; and be able to use the Cisco Command Line Interface (CLI) to connect and service products. Achieving CCT Routing and Switching certification is considered the best foundation for supporting other Cisco devices and systems. Earning the CCNA is usually the first ‘major’ certification step in preparing for a career in Cisco networking technologies. To earn your CCNA certification, you only need to pass one exam – which covers a broad range of fundamentals for IT careers, based on the latest networking technologies. The Cisco Certified CyberOps Associate certification program validates the day-today, tactical knowledge and skills that Security Operations Center (SOC) teams need to detect and respond to cyber security threats. The certification validates the fundamentals needed for associate-level job roles, with one exam and one training course to help you prepare. The exam and training cover knowledge and skills related to security concepts, security monitoring, host-based analysis, network intrusion analysis, and security policies and procedures. From a recognized provider of security solutions and certifications, the CyberOps Associate certification and training program is your pathway to a career in cyber security operations. The CCNP Security certification is designed to help you prove your skills in the ever-changing landscape of security technologies. The program prepares you for today’s professional-level job roles in security technologies. One of the industry’s most respected certifications, CCNP validates the core knowledge you need while providing the flexibility to choose a focus area. To earn your CCNP Security, you must pass two exams: a core exam and a concentration exam of your choice. This course bundle includes the core exam and concentration exam. The core exam’s focus is ‘Securing Networks with Cisco Firepower Technologies‘ – Cisco CCNP Security SNCF (Exam 300-710).

Online Marketing course for individuals, companies, professionals that want to succeed on the job and improve marketing skills.

Face to Face training customised and bespoke. Live online or Face to Face.

1-2-1 face to face training customised and bespoke.

Film and VFX face to face training customised and bespoke. One to One Online or Face to Face

Adobe After Effects Beginners to Advanced Course Tailored for motion graphics designers basic to expert level. Explore advanced topics including motion tracking, green screen compositing, text animation, and techniques like expressions. Learn animations based on geometric proportions in our Advanced Motion Methods module.  Click here for more info: Website Duration: 40 hours Approach: 1-on1 sessions and Customized content. Schedule: Choose your own day and time. Mon to Sat between 9 am and 5 pm. Module 1: Introduction to After Effects Exploring Adobe After Effects Navigating the Interface Configuring Preferences Utilizing Auto-Save Feature Module 2: Projects and Compositions Creating New Projects/Compositions Importing and Organizing Assets Working with Layers Module 3: Animation Techniques Keyframe Essentials Motion Paths and Modifications Graph Editor Insights Motion Control Tools Module 4: Layer Management Organizing and Navigating Layers Layer Visibility and Locking Switches and Modes in Detail Module 5: Shape Manipulation Shape Layers Fundamentals Creating and Animating Shapes Anchor Point Adjustment Module 6: Effects Mastery Applying and Customizing Effects Exploring Various Effects Examples Module 7: Masks and Track Mattes Mask Creation and Animation Track Matte Techniques Module 8: Text and Typography Animation Working with Text Layers Text Animation Presets Layer Styles for Typography Module 9: Exporting Your Creations Export Options Overview Direct Export from After Effects Utilizing Media Encoder After Effects  https://www.adobe.com  By the end of this 40-hour After Effects training, you will: Master Essentials: Understand fundamental and advanced After Effects features for diverse projects. Create Impactful Visuals: Craft compelling motion graphics, animations, and visual effects. Expert Animation Skills: Perfect keyframing, motion paths, and dynamic animations. Streamlined Workflow: Organize projects efficiently, ensuring smooth project execution. Creative Expression: Manipulate shapes, animate text, apply effects, and create masks creatively. Professional Exporting: Master export techniques for various platforms and media. Confidence and Expertise: Solve challenges confidently, applying skills in real-world projects. Industry-Ready: Gain skills applicable in filmmaking, animation, marketing, and creative sectors. Ongoing Support: Access post-training support for continued assistance. Certification: Receive a recognized certification, enhancing your professional profile. Course Title: Adobe After Effects Comprehensive Training Key Details: Duration: 40 hours Learning Approach: Personalized Training: Tailored content with 1-2-1 sessions. Flexible Schedule: Choose hours between 9 am and 7 pm, Monday to Saturday. Method: Hands-on learning with step-by-step demonstrations. Course Highlights: Master Essential Tools: From basics to advanced features for motion graphics and visual effects. Expert Guidance: Certified trainers provide personalized attention. Creative Animation: Learn advanced animation techniques, motion paths, and effects application. Efficient Workflow: Optimize project organization, layer management, and export techniques. Real-World Projects: Apply skills in filmmaking, animation, marketing, and more. Post-Training Support: Lifetime access to email and phone assistance for continued guidance. Certification: Receive a recognized certificate upon course completion. Benefits: Industry-Relevant Skills: Gain expertise for diverse creative sectors. Unleash Creativity: Craft compelling motion graphics, animations, and visual effects. Confidence in Execution: Solve challenges confidently with real-world application. Professional Recognition: Enhance your profile with a certified After Effects proficiency. Course Materials and Certification: Upon enrollment, you will receive a valuable After Effects training guide in PDF format, serving as a useful resource during and after the course. Additionally, upon successful completion, you'll be awarded an e-certificate, validating your achievement in the Adobe After Effects training program. Post-Course Support: Rest assured, you'll have access to lifetime email support from your dedicated After Effects trainer, providing assistance for any inquiries or challenges arising after the course. Prerequisites and Software Version: No prior After Effects knowledge is required for enrollment. The training is tailored for After Effects 2023, with techniques applicable to recent software releases. Whether you're a Windows or Mac user, the training suits your needs. Our Guarantees: We prioritize your satisfaction with our double guarantee - a price assurance ensuring the best value for your investment and a training guarantee ensuring you master essential concepts and skills.

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 Professionals who want to make the best decisions and develop creative and elegant solutions to challenging problems will benefit from this course. Overview Enable you to evaluate, identify, and distinguish between relevant and irrelevant information Engage critical thinking through curiosity and your ability to ask good questions Apply the eight best practices of critical thinking in practice Leverage open-mindedness to become more receptive and highly tuned for new ideas Students will learn to explore challenges, defy incorrect assumptions, and look at things with new and differing perspectives, incorporating these insights into your thought processes, and enabling them to find solutions to even the most difficult tasks. 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 Challenges of Modern Thinking Becoming a Rational Thinker Critical Thinking in Application Applying Reason Developing Open-Mindedness Stepping Out of Your Comfort Zone Avoiding Jumping to Conclusions Expecting and Initiating Change Being Ready to Adapt Thinking Logically 2. Critical Thinking Best Practices Listening Actively Evaluating Information Making Assumptions Watching Out for Bias Asking Clarifying Questions Performing SWOT Analysis Benefitting from Critical Thinking 3. Putting It All Together Changing Your Perspective Considering Other Viewpoints Dealing with New Information Solving Problems Identifying Inconsistencies Asking Why Evaluating the Solution Retaining Your New Skills Reflecting and Learning from Mistakes Asking Questions on an Ongoing Basis Additional course details: Nexus Humans Thinking with Critical Insight 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 Thinking with Critical Insight 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 Professionals who manage teams and desire to understand what leads to conflict, help peacefully navigate team members through potentially antagonistic situations, encourage and empower others to disagree respectfully and productively, and effectively manage disputes between team members will benefit from this course. Overview Identify and manage sources of conflict Define an effective strategy to deal with conflict Implement a process to manage conflict situations Build civility in the workplace In this course, students will learn to recognize the warning signs that precede quarrels and how to mitigate their impact, as well as constructive ways to harness the differences between team members and shift them toward productive, positive outcomes. 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. Understanding conflict Identifying the Causes of Conflict Harnessing the Benefits of Conflict Resolving Conflict Understanding the Key People in Conflict Resolution 2. Civility in the Workplace Recognizing Uncivil Behavior Reaping the Benefits of Civil Behavior Working with Difficult People Identifying and Avoiding Incivility Creating, Implementing, and Enforcing a Civility Policy 3. Conflict Resolution Process Making an Effective Atmosphere Developing Mutual Understanding Focusing on individual and Shared Needs Getting to the Root Cause Generating Options Building a Solution 4. Conflict Resolution Strategies Differentiating Resolution Strategy Versus Process Recognizing the Advantages and Disadvantages to Collaborating, Competing, Compromising, and Avoiding Additional course details: Nexus Humans Constructive Conflict Management training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Constructive Conflict Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.