5661 Courses

This workshop is a creative problem solving session that is based on the principles of design thinking. It consists of engaging, collaberative activities to stimulate innovation.

MySQL server admins training course description This MySQL Server administration course is designed for MySQL Server administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands. The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performance. This MySQL Server administration course also covers MySQL replication and its role in high availability and scalability. What will you learn Use MySQL Workbench. Install and configure a MySQL Server . Administer and tune a MySQL server. Configure log files and interpret error messages.. Secure the Server. Administer a replication topology. MySQL server admin training course details Who will benefit: Database administrators, Database developers and Technical consultants. Prerequisites: Introduction to MySQL Duration 5 days MySQL server admin training course contents Introduction to Oracle Application Express APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application SWL Workshop Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries Build a database application Application components Create an application Create an application from a spreadsheet Create reports Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats Using files Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file Pages and regions Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms Creating lists of values Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values Items and buttons Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons Page Processing Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches Shared components Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults Display dynamic content Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees State and debugging Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development Themes and templates Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files Dynamic actions and plug-in components Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action Building website applications Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application Implementing security Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection Deploy an appliction Define supporting objects Package an application Export an application Import an application Install supporting objects Administer Apex workspaces Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace Utility programs Import and export data Generate DDL statements View objects reports

The Agile Project Manager (On-Demand) Change isn't coming, it's already here. The project environment is becoming more volatile, uncertain, complex, and ambiguous. Project management and project managers must transform and evolve in order to keep up with these changes. Agile has been a disruptor in the field of project management, having over 20 years of successes and benefits to organizations that have adopted their frameworks. The Agile frameworks have proven themselves to be more adept in dealing with this uncertainty. But Agile isn't just about following a different way of working. What do you need to learn, do, and become in order to continue in the current and future environment? It is a powerful combination of knowledge, competencies, and mindset. In an increasingly complicated project environment, this course provides participants with the knowledge needed to not only survive but thrive. What you will Learn At the end of this program, you will be able to: Evaluate the changing project environment and the needed knowledge, skills, and behaviors Demonstrate innovative project manager competencies of leading change, servant leadership, and focus on value Utilize Lean and Agile principles to maximize value and improve project performance Construct a hybrid Agile model that is unique to your project Assess your role in Business Agility as an Agile Project Manager Getting Started Introductions Workshop orientation Expectations Foundations Recap: What is Agile? A changed project environment The future project manager Agile Project Management Competencies Focusing on value Championing change Servant leadership Coaching / mentorship Facilitation Lean and Agile Principles Optimizing flow Making things small Continuous planning Just-In-Time requirements Visualizing work Hybrid Agile Considerations Considering a Hybrid Approach Examining Strengths and Weaknesses of Each Approach Selecting Waterfall / Agile Roles, Practices, and Techniques Reviewing Three Hybrid Scenarios Constructing the Hybrid Project Implementing Agile Pitfalls and Concerns Agile in the Organization Business Agility Summary and Next Steps

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.

The Beginners Woodworking Workshop is a one day course where you will learn to make a bread board in just a few hours!

Effective Delegation; Ipswich; Suffolk; Switch Direction; Dan Cocksedge

What you'll do Have you ever wanted to create your own unique furniture? During this one day experience you’ll transform a pallet into a one-off piece of furniture for your home. First you'll find out how to source materials and discover the tools and techniques you’ll need to prepare your pallets for upcycling. Once Scott has introduced you to the workshop space, you’ll use a mix of hand and power tools to create your own piece, from a shoe or wine rack to a bird feeder, storage box or even a small bookcase. With your experience host's guidance, you'll leave with your own finished upcycled item. All materials, tools and safety equipment will be provided for you on the day. Dates for 2022: Feb 5,6 March 5,6 April 23,24 June 25,26 Sep 10,11 Oct 29,30 Dec 10,11 Facilities Toilets WiFi Refreshments available Parking COVID-19 guidelines Everyone will need to confirm fitness each day. Everyone will have their temperature taken at the beginning of each day. Hand washing will be compulsory at set times during the courses. Face masks will be compulsory during the specific parts of the course where you will be breathing heavily due to exertion. The remainder of the course we will have face shields available as an option to facemasks. Face shields will be provided. But please bring your own face mask. On the day You don't need any previous woodwork experience, just some enthusiasm! Please wear old clothes (or something that you don’t mind getting damaged or torn) and sensible, closed toe footwear. Work boots are recommended. Tea and coffee will be available throughout the day, but please bring along your own packed lunch. Course Location courses can be either in Glastonbury or at Scott's own workshop near the Bath and West show grounds (BA46QN) and will be confirmed.

Hypnotherapy offers a therapeutic approach to address emotional processing, trauma, and acceptance, aiding individuals in navigating their grief journey. While grief is universal, seeking support and exploring therapeutic options like hypnotherapy can help individuals find healing and solace amidst their pain.

Are you an assessor or a trainer looking to enhance your effectiveness and communication skills? Do you find it challenging to confidently express your thoughts, to get what you want from situations and to maintain control during training sessions or assessments?  If so, our “Assertiveness for Assessors and Trainers” live online workshop is made for you. Effective Communication: Assertiveness empowers you to communicate your ideas clearly, ensuring your message is understood by learners. You’ll learn techniques to express your thoughts confidently, leading to improved engagement and comprehension. Confidence Building: Learn techniques for appearing more confident when communicating with others.  Taking control: Take control of situations through your body language and the verbal / written language you use. Invest in Your Success This 2.5 hour session will help you gain the skills to lead with confidence, communicate effectively, and prioritise yourself in your life.  Further Information This 2.5 hour session held live online via Teams will give you the tools and techniques you need to be more assertive. Workshop Benefits Interactive Workshops: Engage in hands-on activities, role plays, and real-world scenarios to practice assertive communication techniques in a safe and supportive environment.Expert Facilitators: Our experienced trainers will guide you through proven strategies, drawing on their expertise in communication, psychology, and training methodologies.Tailored Content: The course content is specifically designed for assessors and trainers, addressing challenges and situations unique to your profession.Practical Tools: Walk away with a toolkit of practical techniques, scripts, and strategies that you can immediately apply in your assessments and training sessions.Networking Opportunities: Connect with fellow assessors and trainers, sharing insights, experiences, and best practices to further enhance your professional journey.

Duration 4 Days 24 CPD hours This course is intended for This course is intended for the person who has responsibility for daily system operations. Overview Send, display, and respond to messages Use the online help and reference materials Monitor and control job queues, active jobs, and output queues Create and change user profiles Use authorization lists and group profiles Start and stop Power Systems with IBM i Manage system devices, user display stations, and printers Save and restore objects and libraries Monitor job and history logs Diagnose a system problem Order, receive, and install PTFs This course enables a new system operator to develop basic to intermediate level skills needed for day-to-day operations of the Power System with IBM i Power Systems and IBM i concepts and overview . Reference material and support . Overview of 5250 emulation and help . Overview of System i Navigator . Overview of IBM Navigator for i . Messaging concepts . Messaging with 5250 emulation . Messaging with System i Navigator . Messaging with IBM Navigator for i . CL command concepts . CL commands with 5250 emulation . Concepts: Object, library, and the IFS . Object management with 5250 emulation . Object management with System i Navigator . Object management with IBM Navigator for i . Introduction to work management . Work management with 5250 emulation . Job control with 5250 emulation . Job control with System i Navigator . Job control with IBM Navigator for i . Print concepts . Print control with 5250 emulation . Print control with System i Navigator . Print control with IBM Navigator for i . Starting and stopping the system . System security concepts . System security with 5250 emulation . System security with System i Navigator . System security with IBM Navigator for i . System configuration overview . Configuration with 5250 emulation . Configuration with System i Navigator . Configuration with IBM Navigator for i . Save concepts . Save with 5250 emulation . Save with System i Navigator . Save with IBM Navigator for i . Restore concepts and overview . Problem determination with 5250 emulation . Problem determination with System i Navigator . Overview of the PTF process . PTFs with 5250 Emulation . Class summary . Additional course details: Nexus Humans AS24 IBM System Operator Workshop for IBM i 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 AS24 IBM System Operator Workshop for IBM i 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.