6153 Computing courses

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.

Certified ScrumMaster® This course is an introduction to Scrum and the principles and tools required to be an effective Scrum Product Owner. You will come away with a good understanding of the Scrum framework and the underlying principles required to make effective decisions regarding the application of the Scrum framework to different situations. Participants successfully completing this course earn a Certified Scrum Product Owner® (CSPO®) designation. The Scrum Alliance certification includes a one-year membership with Scrum Alliance. What You Will Learn You'll learn how to: Use the principles, practices, and tools required to be an effective Scrum Product Owner Make effective decisions regarding the application of the Scrum framework to different situations, including: Setting product vision and goals Chartering the project Writing user stories and structuring your product backlog Scaling the Product Owner Estimating for forward planning Applying prioritization techniques Planning and tracking release progress Getting Started Introduction Course structure Course goals and objectives Agile Principles and Scrum Overview Process control models Incremental and iterative development Shifting the focus on product management Overview of the Scrum process Agile principles Lean principles Scrum Roles and Responsibilities Scrum roles Cross-functional teams Product Owner Responsibilities The Scrum Project Community What happens to my traditional role in Scrum? Chartering the Project Establishing a shared vision Elevator Statement Data sheets Product Vision Box Magazine Review / Press Release Product Backlog and User Stories Product uncertainty and progressive refinement User role modeling User Stories Product backlog characteristics Getting backlog items ready Slicing User Stories Using the product backlog to manage expectations Sprints Done and Scaling Done The Scrum process in detail Sustainable pace The Product Owner's role in each of the Scrum meetings Scaling the Product Owner Scaling Scrum Approaches to scaling the Product Owner Estimation for Forward Planning Why comparative estimation works Planning Poker Affinity Estimation Prioritization Techniques Additional Product Backlog Prioritization Techniques Kano Analysis Theme Screening Release Planning and Tracking Progress Velocity Release Planning Tracking release progress

Certified ScrumMaster®: In-House Training This course is an introduction to Scrum and the principles and tools required to be an effective Scrum Product Owner. You will come away with a good understanding of the Scrum framework and the underlying principles required to make effective decisions regarding the application of the Scrum framework to different situations. Participants successfully completing this course earn a Certified Scrum Product Owner® (CSPO®) designation. The Scrum Alliance certification includes a one-year membership with Scrum Alliance. What You Will Learn You'll learn how to: Use the principles, practices, and tools required to be an effective Scrum Product Owner Make effective decisions regarding the application of the Scrum framework to different situations, including: Setting product vision and goals Chartering the project Writing user stories and structuring your product backlog Scaling the Product Owner Estimating for forward planning Applying prioritization techniques Planning and tracking release progress Getting Started Introduction Course structure Course goals and objectives Agile Principles and Scrum Overview Process control models Incremental and iterative development Shifting the focus on product management Overview of the Scrum process Agile principles Lean principles Scrum Roles and Responsibilities Scrum roles Cross-functional teams Product Owner Responsibilities The Scrum Project Community What happens to my traditional role in Scrum? Chartering the Project Establishing a shared vision Elevator Statement Data sheets Product Vision Box Magazine Review / Press Release Product Backlog and User Stories Product uncertainty and progressive refinement User role modeling User Stories Product backlog characteristics Getting backlog items ready Slicing User Stories Using the product backlog to manage expectations Sprints Done and Scaling Done The Scrum process in detail Sustainable pace The Product Owner's role in each of the Scrum meetings Scaling the Product Owner Scaling Scrum Approaches to scaling the Product Owner Estimation for Forward Planning Why comparative estimation works Planning Poker Affinity Estimation Prioritization Techniques Additional Product Backlog Prioritization Techniques Kano Analysis Theme Screening Release Planning and Tracking Progress Velocity Release Planning Tracking release progress

Overview The eight 1/2 day Support Manager course is uniquely created to provide training on the fundamentals of management relative to the support environment, and to enhance the inherent skills and knowledge of the support manager. This course focuses specifically on the most common management elements that occur in the technical support centre including, managing customer satisfaction, operations and team performance management and facilitating a team while managing a dynamic service product. This course offers support managers the opportunity to develop and refine their technology support leadership skills enabling them to effectively manage the challenges of the most complex support centres. Who Should Attend The Support Manager course is for managers who have at least six months management experience and have received some basic management training. Requirements The course begins with a review and quiz on a set of pre-class reading materials. These materials are sent to each participant two weeks prior to the class start date. Participants are strongly encouraged to register at least two weeks in advance to allow time to complete these pre-class assignments. Each participant is required to bring the pre-class reading materials as well as a notebook computer with a USB port and with Microsoft Excel, Word and PowerPoint installed. These will be used as tools during the course. All other materials and tools will be provided. Homework is assigned for most evenings of the course. Please plan for study time outside of class. Some of the training objectives… Manage dynamics of change within the support centre Enhance leadership skills Effective staff utilisation Increase support centre morale and retention

ITIL® 4 Specialist: High-Velocity IT: On-Demand This course is based on the ITIL® 4 Specialist: High-Velocity IT exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. What You Will Learn At the end of this course, participants will be able to: Understand concepts regarding the high-velocity nature of the digital enterprise, including the demand it places on IT. Understand the digital product lifecycle in terms of the ITIL operating model. Understand the importance of the ITIL guiding principles and other fundamental concepts for delivering high-velocity IT. Know how to contribute to achieving value with digital products. Course Introduction Introduction to High-Velocity IT High-Velocity IT Approaches High-Velocity IT Operating Models Introduction ITIL Building Blocks for High-Velocity IT Supporting Models and Concepts for Purpose Supporting Models and Concepts for People Supporting Models and Concepts for Progress High-Velocity IT Objectives and Techniques Techniques for Valuable Investments Techniques for Fast Developments Techniques for Resilient Operations Techniques for Co-created Value Techniques for Assured Conformance

ITIL® 4 Specialist: Drive Stakeholder Value: On-Demand The ITIL® 4 Specialist: Drive Stakeholder Value module is part of the Managing Professional stream for ITIL 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation. This course is based on the ITIL® 4 Specialist: Drive Stakeholder Value exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. What You Will Learn The learning objectives of the course are based on the following learning outcomes of the ITIL® 4 Specialist: Drive Stakeholder Value exam specification: Understand how customer journeys are designed Know how to target markets and stakeholders Know how to foster stakeholder relationships Know how to shape demand and define service offerings Know how to align expectations and agree on details of services Know how to onboard and offboard customers and users Know how to act together to ensure continual value co-creation (service consumption / provisioning) Know how to realize and validate service value Customer Journey Purpose of the Module Purpose of Mastering the Customer Journey Touchpoints and Service Interactions Module Topics Mapping the Customer Journey Designing the Customer Journey Measuring and Improving the Customer Journey Customer Journey Step 1: Explore Purpose of the Module Purpose of the Explore Step Module Topics Understanding Service Consumers Understanding Service Providers Understanding and Targeting Markets Customer Journey Step 2: Engage Purpose of the Module Purpose of the Engage Step Aspects of Service Value Module Topics Service Relationship Types Building Service Relationships Building and Sustaining Trust and Relationships Analyzing Customer Needs Managing Suppliers and Partners Customer Journey Step 3: Offer Purpose of the Module Purpose of Shaping Demand and Service Offerings Module Topics Managing Demand and Opportunities Specifying and Managing Customer Requirements Designing Service Offerings and User Experience Selling and Obtaining Service Offerings Customer Journey Step 4: Agree Purpose of the Module Purpose of Aligning Expectations and Agreeing on Services Module Topics Agreeing on and Planning Value Co-Creation Negotiating and Agreeing on a Service Customer Journey Step 5: Onboard Purpose of the Module Purpose of Onboarding and Offboarding ITIL® Management Practices Module Topics Planning Onboarding Fostering Relationships with Users Providing User Engagement and Delivery Channels Enabling Users for Service Elevating Mutual Capabilities Offboarding Customer Journey Step 6: Co-create Purpose of the Module Purpose of Service Provision and Consumption Module Topics Service Mindset Ongoing Service Interactions Nurturing User Communities Customer Journey Step 7: Realize Purpose of the Module Measuring Service Value Purpose of Value Capturing and Customer Journey Improvement Realizing Service Value in Different Settings Module Topics Tracking Value Realization Assessing and Reporting Value Realization Evaluating Value Realization and Improving Customer Journeys Realizing Value for the Service Provider

Scrum Product Owner Workshop: In-House Training The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. The Product Owner must be knowledgeable, available, and empowered to make decisions quickly in order for an Agile project to be successful. The Product Owner's key accountability is the Product Backlog. Managing, maintaining, and evolving the Product Backlog involves: Establishing a clear Vision that engages the Development Team and stakeholders Clearly expressing Product Backlog items Ordering the items in the Product Backlog to best achieve the Vision and goals Ensuring that the Product Backlog is visible, transparent, and clear to all Working with the Development Team throughout the project to create a product that fits the customer's needs The overall course goal is to support you in becoming an effective Product Owner. What you will Learn You'll learn how to: Differentiate between poor, good, and great Product Owner attributes, and their impact on the team, product, stakeholders, and the organization Engage your stakeholders by knowing your customers and market Develop an effective and value-driven Product Backlog Evaluate the Product Owner's role in Scrum's 5 events and team engagement Foundation Concepts Agile foundation Product owner role Product Ownership Product ownership Project vision Understanding your customers and market Personas Stakeholder management and engagement The Product Backlog Epics and user stories Preparing user stories for a sprint The product backlog Visualizing the product backlog Product backlog prioritization Technical debt Sprint Planning and Delivery Sprint planning The sprint Sprint Reviews, Retrospectives, and Closing Sprint reviews Key agile patterns Retrospectives Closing the project

Scrum Product Owner Workshop The Product Owner is responsible for maximizing the value of the product and the work of the Development Team. The Product Owner must be knowledgeable, available, and empowered to make decisions quickly in order for an Agile project to be successful. The Product Owner's key accountability is the Product Backlog. Managing, maintaining, and evolving the Product Backlog involves: Establishing a clear Vision that engages the Development Team and stakeholders Clearly expressing Product Backlog items Ordering the items in the Product Backlog to best achieve the Vision and goals Ensuring that the Product Backlog is visible, transparent, and clear to all Working with the Development Team throughout the project to create a product that fits the customer's needs The overall course goal is to support you in becoming an effective Product Owner. What you will Learn You'll learn how to: Differentiate between poor, good, and great Product Owner attributes, and their impact on the team, product, stakeholders, and the organization Engage your stakeholders by knowing your customers and market Develop an effective and value-driven Product Backlog Evaluate the Product Owner's role in Scrum's 5 events and team engagement Foundation Concepts Agile foundation Product owner role Product Ownership Product ownership Project vision Understanding your customers and market Personas Stakeholder management and engagement The Product Backlog Epics and user stories Preparing user stories for a sprint The product backlog Visualizing the product backlog Product backlog prioritization Technical debt Sprint Planning and Delivery Sprint planning The sprint Sprint Reviews, Retrospectives, and Closing Sprint reviews Key agile patterns Retrospectives Closing the project

Enhance your understanding of petroleum geology for non geologists with EnergyEdge's classroom training. Join our course to gain valuable insights. Enroll now!

ISTQB® FOUNDATION TRAINING COURSE (2 persons minimum) The aim of this course is to provide you with the knowledge and skills to pass an exam certifying you as an ISTQB® Certified Tester - Foundation Level. Most organisations require this certification as a minimum skill requirement for software testers. In this course you will learn a standardized approach to software testing that will be immediately applicable to your projects. In order to get the certification you will be required to pass a 60-minute exam. Our trainers will fully prepare you by employing scenarios that mirror the exam questions, and by focusing course delivery with a balance of theory and practice. Target group: Functional Tester, Agile Tester, User Acceptance Tester, Test Automation Specialist, Performance Testing Specialist, Testing Team Lead, Test Manager, Business analyst Prerequisites: There are no specific prerequisites for this course. This course is suitable for anyone involved in software testing. Duration: 3 days. Training objectives: Learn aspects of test planning, estimation, monitoring and control. Understand and use international standards and terminology. Understand and implement effective testing techniques. Be well prepared for the exam. Identify the missing testing skills for the career development purposes. This course covers the following areas: Fundamentals of software testing Testing throughout the life cycle (software development models, test levels, test types) Test design techniques (e.g. specification-based or black-box techniques, structure-based or white-box techniques) Static testing (static testing techniques, review process, tool-assisted static analysis) Test management (test organisation, test planning and estimation, test progress monitoring and control, risks) Tools to support testing (types, benefits and risks) Language: English