1694 Computing courses in Chard delivered Live Online

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.

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

SAFe® Product Owner / Product Manager: In-House Training Develop the skillsets needed to guide the delivery of value in a Lean Enterprise by becoming a SAFe® 5.0 Product Owner / Product Manager (POPM). During this course, attendees gain an in-depth understanding of how to effectively perform their role in the Agile Release Train (ART) as it delivers value through Program Increments. Attendees explore how to apply Lean thinking to decompose Epics into Features and Stories, refine Features and Stories, manage Program and Team backlogs, and plan and execute Iterations and Program Increments. Attendees also discover how the Continuous Delivery Pipeline and DevOps culture contribute to the relentless improvement of the ART. What you will Learn To perform the role of a SAFe® Product Owner / Product Manager, attendees should be able to: Articulate the Product Owner and Product Manager roles Connect SAFe® Lean-Agile principles and values to the PO / PM roles Decompose Epics into Features and decompose Features into Stories Manage Program and Team backlogs Collaborate with Agile teams in estimating and forecasting work Represent customer needs in Program Increment Planning Execute the Program Increment and deliver continuous value Becoming a Product Owner / Product Manager in the SAFe® enterprise Preparing for PI Planning Leading PI Planning Executing Iterations Executing the Program Increment Becoming a Certified SAFe® Product Owner / Product Manager

Advanced Certified Scrum Product Owner® (A-CSPO®): In-House Training All Advanced CSPO courses are taught by Educators approved by the Scrum Alliance. Taking an Advanced CSPO course, meeting the learning objectives, and accepting the license agreement designates you as an Advanced Certified Scrum Product Owner. Please review your trainer's course description below to determine which learning objectives this course satisfies. What you will Learn You'll learn to: Manage multiple business initiatives from competing stakeholders Clearly order and express Product Backlog items Define a clear product vision that ensures your product remains focused on the features your customers and end users will actually use Communicate effectively with various stakeholder groups to achieve alignment Identify the crucial opportunities and avoid wasting time Define and validate business value Increase your credibility as a product expert and become recognized as a person who delivers real business results Benefits Build on your foundational knowledge with enhanced implementation skills Distinguish yourself in the global marketplace Stand out in your industry as a member of the Scrum Alliance globally-recognized community Show advanced value to your employer (or potential employer) as a highly trained Agile professional

Disciplined Agile Value Stream Consultant (DAVSC) Training Workshop: Virtual In-House Training The Disciplined Agile Value Stream Consultant workshop teaches you how to use value stream management to create a tailored approach for any organization to accelerate delivery of value to their customers. It provides a combination of Lean, Flow, Theory of Constraints and Organizational Development theories and practices. The workshop integrates with the Disciplined Agile tool kit to provide those practices that will be most effective for where it is applied, whether it be a new Agile transition or continuing a stagnated SAFe® or Spotify one.

SAFe® Agile Software Engineering: In-House Training The introduction of Lean-Agile and DevOps principles and practices into software engineering has sparked new skills and approaches that help organizations deliver higher-quality, software-centric solutions faster and more predictably. This workshop-oriented course explores foundational principles and practices and how continuous flow of value delivery and built-in quality are enabled by XP technical practices, Behavioral-Driven Development (BDD), and Test-Driven Development (TDD). Attendees will learn proven practices to detail, model, design, implement, verify, and validate stories in the SAFe® Continuous Delivery Pipeline, as well as the practices that build quality into code and designs. Attendees will also explore how software engineering fits into the larger solution context and understand their role in collaborating on intentional architecture and DevOps. What you will Learn To perform the role of a SAFe® Agile Software Engineer, you should be able to: Define Agile Software Engineering and the underlying values, principles, and practices Apply the Test-First principle to create alignment between tests and requirements Create shared understanding with Behavior-Driven Development (BDD) Communicate with Agile modeling Design from context for testability Build applications with code and design quality Utilize the test infrastructure for automated testing Collaborate on intentional architecture and emergent design Apply Lean-Agile principles to optimize the flow of value Create an Agile Software Engineering plan Introduction to Agile Software Engineering Connecting Principles and Practices to Built-in Quality Accelerating Flow Applying Intentional Architecture Thinking Test-First Discovering Story Details Creating a Shared Understanding with Behavior-Driven Development (BDD) Communicating with Models Building Systems with Code Quality Building Systems with Design Quality Implementing with Quality

Hi-Tech Training Closed Circuit Television (CCTV) Installation Course is designed to give participants a practical knowledge of the operation and installation of CCTV systems at a foundation level.

The IT System Support Technician (Online Virtual Classroom) Course will equip candidates with the skills and knowledge to competently carry out routine customer support to a range of Computer users, communicate effectively with support managers, supporting colleagues and external clients.

SAFe® Agile Software Engineering: Virtual In-House Training The introduction of Lean-Agile and DevOps principles and practices into software engineering has sparked new skills and approaches that help organizations deliver higher-quality, software-centric solutions faster and more predictably. This workshop-oriented course explores foundational principles and practices and how continuous flow of value delivery and built-in quality are enabled by XP technical practices, Behavioral-Driven Development (BDD), and Test-Driven Development (TDD). Attendees will learn proven practices to detail, model, design, implement, verify, and validate stories in the SAFe® Continuous Delivery Pipeline, as well as the practices that build quality into code and designs. Attendees will also explore how software engineering fits into the larger solution context and understand their role in collaborating on intentional architecture and DevOps. What you will Learn To perform the role of a SAFe® Agile Software Engineer, you should be able to: Define Agile Software Engineering and the underlying values, principles, and practices Apply the Test-First principle to create alignment between tests and requirements Create shared understanding with Behavior-Driven Development (BDD) Communicate with Agile modeling Design from context for testability Build applications with code and design quality Utilize the test infrastructure for automated testing Collaborate on intentional architecture and emergent design Apply Lean-Agile principles to optimize the flow of value Create an Agile Software Engineering plan Introduction to Agile Software Engineering Connecting Principles and Practices to Built-in Quality Accelerating Flow Applying Intentional Architecture Thinking Test-First Discovering Story Details Creating a Shared Understanding with Behavior-Driven Development (BDD) Communicating with Models Building Systems with Code Quality Building Systems with Design Quality Implementing with Quality

SAFe® Product Owner / Product Manager: Virtual In-House Training Develop the skillsets needed to guide the delivery of value in a Lean Enterprise by becoming a SAFe® 5.0 Product Owner / Product Manager (POPM). During this course, attendees gain an in-depth understanding of how to effectively perform their role in the Agile Release Train (ART) as it delivers value through Program Increments. Attendees explore how to apply Lean thinking to decompose Epics into Features and Stories, refine Features and Stories, manage Program and Team backlogs, and plan and execute Iterations and Program Increments. Attendees also discover how the Continuous Delivery Pipeline and DevOps culture contribute to the relentless improvement of the ART. What you will Learn To perform the role of a SAFe® Product Owner / Product Manager, attendees should be able to: Articulate the Product Owner and Product Manager roles Connect SAFe® Lean-Agile principles and values to the PO / PM roles Decompose Epics into Features and decompose Features into Stories Manage Program and Team backlogs Collaborate with Agile teams in estimating and forecasting work Represent customer needs in Program Increment Planning Execute the Program Increment and deliver continuous value Becoming a Product Owner / Product Manager in the SAFe® enterprise Preparing for PI Planning Leading PI Planning Executing Iterations Executing the Program Increment Becoming a Certified SAFe® Product Owner / Product Manager