19983 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.

Duration 1 Days 6 CPD hours This course is intended for People in different roles and at various stages in their careers can benefit from this fundamentals course. This includes IT professionals, business stakeholders and others who want to be exposed to the customer engagement capabilities of Dynamics 365, students, recent graduates, and people changing careers who want to leverage Dynamics 365 to move to the next level. Overview Describe the customer engagement apps and what they have in common Describe the standard marketing processes and how Dynamics 365 Marketing addresses them Describe Dynamics 365 Marketing features and capabilities Describe additional marketing apps Describe the standard sales processes and how Dynamics 365 Sales addresses them Describe Dynamics 365 Sales capabilities Describe additional sales apps such as Sales Insights and Sales Navigator Describe the standard customer service processes and how Dynamics 365 Customer Serviceaddresses them Describe Dynamics Customer Service capabilities Describe additional sales apps such as Sales Insights and Sales Navigator Describe the standard field service business processes and how Dynamics 365 Field Service addresses Describe how to generate Work Orders Describe the scheduling capabilities of Dynamics 365 Field Service Describe the inventory management capabilities of Dynamics 365 Field Service Describe the asset management capabilities of Dynamics 365 Field Service Describe project-based customer engagement processes addressed by Dynamics 365 Project Operations Describe the sales capabilities of Dynamics 365 Project Operations Describe the project management capabilities of Dynamics 365 Project Operations Describe the resource utilization capabilities of Dynamics 365 Project Operations This course will provide you with a broad introduction to the customer engagement capabilities of Dynamics 365. You will become familiar with the concept of customer engagement, as well as each of the customer engagement apps, including Dynamics 365 Marketing, Dynamics 365 Sales, Dynamics 365 Customer Service, Dynamics 365 Field Service, and the customer relationship management (CRM) capabilities of Dynamics 365 Project Operations. This course will include lecture as well as hands-on labs. Learn the Fundamentals of Dynamics 365 Marketing Get introduced to the Dynamics 365 customer engagement apps Examine Dynamics 365 Marketing Describe Dynamics 365 Marketing capabilities Review Additional Marketing Apps Learn the Fundamentals of Dynamics 365 Sales Explore Dynamics 365 Sales Manage the sales lifecycle with Dynamics 365 Sales Review additional sales apps Learn the Fundamentals of Dynamics 365 Customer Service Examine Dynamics 365 Customer Service Describe Dynamics Customer Service capabilities Review additional customer service apps Learn the Fundamentals of Dynamics 365 Field Service Examine Dynamics Field Service Generate Work Orders in Dynamics 365 Field Service Describe the scheduling capabilities of Dynamics 365 Field Service Examine the inventory management capabilities of Dynamics 365 Field Service Review the asset management capabilities of Dynamics 365 Field Service Learn the Fundamentals of Dynamics 365 Project Operations (CRM) Examine Dynamics 365 Project Operations Describe the sales capabilities of Dynamics 365 Project Operations Plan projects with Dynamics 365 Project Operations Review the resource utilization capabilities of Dynamics 365 Project Operations Additional course details: Nexus Humans MB-910T00 Microsoft Dynamics 365 Fundamentals (CRM) 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-910T00 Microsoft Dynamics 365 Fundamentals (CRM) 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 IS DESIGNED FOR THOSE WISHING TO TEST THE WATERS AND SEE HOW THEY FEEL ABOUT JOINING THE BARBER LIFE.

Nasogastric tube training ensures healthcare professionals have the correct clinical knowledge and skills to provide excellent care and support for individuals who may require treatment via NG tube for nutrition, hydration or medication.

The Revit Structure Training is for 15 hours, £525, and it will cover from Introduction to Intermediate in small classes with only 1 people per class.

This HTML course will provide you with an easy to follow, hands-on introduction to HTML and CSS, the basic coding languages which drive the internet. Participants will learn how to create an attractive and well-structured web page using basic HTML and CSS. This workshop is highly recommended for anyone wishing to learn how to create websites and also for people who already use applications such as Dreamweaver or WordPress and need more control over their web output.

AutoCAD-Mac Introduction to Advanced Training Course This project-based course is tailored for AutoCAD Mac users, architecture and interior design students and professionals. Click here for more info: Website When Can I Book This Training Course? Personalized experience with 1-on-1 sessions designed to fit your unique needs. Available from Monday to Saturday, 9 am to 7 am Or Call to Book 02077202581. Duration of Training: 16 hours. Training Method:  1-on-1, providing the option for in-person sessions or live online training. Course Content Section 1: Introduction Course Overview Section 2: Basic Concepts Status Bar and The Units Drawing Commands Control Points - Vertex or Verteces Modifying Commands Snap Settings Drawing An Outline Section 3: Dimensions and Customization Adding Dimensions and Dimension Style Manager Importing Dimension Styles Customizing Shortcuts Section 4: Advanced Techniques Adding Walls Thickness with Offset Command Adding interior layout Cleaning Layout lines with Trim Section 5: Text and Styling Text Editing and Importing Text Styles Main File Formats in AutoCAD Section 6: Design Elements Creating Openings in the Floor Plan Adding Openings - Part 2 Adding Openings - Part 3 Drawing Doors & Windows Using Line Types & Linetype Scale Group and Ungroup Commands Using Blocks Using Blocks Library & Dynamic Blocks Section 7: Layers and Furnishing Layers - Part 2 Layers - Part 3 Furnishing Bedrooms & Bathrooms - Part 1 Adding Furniture, Fixtures, and Equipments | part 2 Adding Furniture, Fixtures, and Equipments | part 3 Drawing the Kitchen Drawing the Living Room Drawing Dining Room & Adding Casework Adding Steps and Railings Using Stretch Command Finishing Steps and patio areas Hatch command Hatch Customization Adding Plants & Finishing Floor Plan Section 8: Layout and Printing Paper Space & Page Setup Manager Working with Viewport & Using Print Command Scale & Using Multiple Viewports Locking Viewport Scale Drawing A Titleblock - Part 1 Drawing A Titleblock - Part 2 Copying the Titleblock Using Titleblock with Attributes Section 9: Roof Plan and Organization Drawing The Roof Plan Placing Roof Plan on Sheet Organizing Project Drawings & Using Layer Freeze AutoCAD Crashing And What To Do Section 10: Elevations Exterior elevations - Drawing the Outline Exterior elevations - Drawing the Openings Elevations - Detailing - Part 1 Elevations - Detailing - Part 2 Elevations - Repeating the workflow Elevations - Finishing 3rd Elevation Elevations - Drawing the final elevation Section 11: Sections Sections: Drawing Cut Lines & the Outline Sections: Placing 1st Section on Sheet Sections: Drawing Section #2 - Different Technique Sections: Adding Final Detail Section 12: Interior Elevations Interior Elevations: Drawing the Outline Interior Elevations: Placing on Sheet Interior Elevations: Using Block Clip Interior Elevations: Final Drawing Section 13: Conclusion Putting the Final Set Together Proficient AutoCAD Skills: Master essential tools for efficient drawing creation and manipulation. Accurate 2D Designs: Create precise and high-quality layouts with attention to detail. Effective Object Handling: Excel in selecting, moving, copying, and scaling objects. File Management: Organize drawings efficiently and understand different file formats. Precise Measurements: Utilize inquiry commands for accurate design analysis. Annotations and Hatching: Apply text, dimensions, and hatching to enhance drawings. Object Organization: Manage layers and object properties for organized designs. Reusable Content: Efficiently use blocks, tool palettes, and groups for productivity. Layout Optimization: Create layouts with viewports for optimal design presentation. Professional Output: Generate professional plots and PDF output for polished results. Enhanced Productivity: Explore AutoCAD toolsets and web/mobile apps for streamlined workflow. Course Overview: Learn versatile AutoCAD for Mac drawing techniques, applicable across all industries, enabling you to excel in the application. Our trainers incorporate exercises from various disciplines. Who Should Attend: Ideal for newcomers to AutoCAD for Mac, self-taught users seeking correct techniques, and those transitioning from other CAD tools. Requirements: A solid Mac OS understanding is essential, while prior CAD knowledge is not required. Pre-course preparation guidance is provided for new AutoCAD users. Highlights: Perfect for AutoCAD for Mac beginners. Gain skills for precise 2D layouts and designs. Versatile drawing techniques for all industries. Choose between in-class or live online training. Autodesk Certified Tutors: AutoCAD 1-2-1 courses. Hands-on learning with expert trainers. Lifetime post-course email support. Tailored on-request training available. Certificate: Digital certificate included. Tailored Mac Training: Excel in AutoCAD with specialized Mac training, leveraging its distinct features and interface for heightened efficiency. Comprehensive Skill Enhancement: Advance from fundamental to intermediate AutoCAD Mac proficiency, creating precise and professional 2D drawings. Industry-Relevant Expertise: Attain in-demand skills valued by employers in architecture, engineering, and design sectors. Hands-On Project Exposure: Immerse yourself in practical exercises mirroring real-world design scenarios, fostering practical competence. Lesson Recordings for Review: Access recorded lessons for reinforcement and deeper AutoCAD Mac comprehension. Ongoing Email Support: Benefit from lifetime email support, ensuring assistance beyond course completion."

Bunnyfoot were the pioneers and are now one of the leading providers of the Certified Professional for Usability and User Experience – Foundation Level (CPUX-F) in the United Kingdom. Created in association with the international UXQB, this professional 3-day UX certification programme covers user experience methods and theories – and is independently assessed/certified.

Learn the basic principles of good programme management using the MSP® approach and prepare for the Foundation and Practitioner examinations on this accredited programme. Duration: 5 days (32.5 hours) Our MSP® Foundation and Practitioner course is designed to teach the basic principles of good programme management in line with the Principles, Themes and Processes described in the MSP® approach. It also prepares delegates for the Foundation and Practitioner examinations. This course is designed for anyone who needs to understand programme management and the practical application of MSP® and to gain the MSP® Foundation and Practitioner qualifications. Delegates should have an understanding of and preferably experience in the issues surrounding business change The MSP® Foundation and Practitioner Course is based upon the “Managing Successful Programmes – 5th Edition” which describes “best practice” guidance for handling all types of transformational change programmes. These are intensive modules and require delegates to undertake some evening work in their own time. Objectives  By the end of the course you will be able to: Describe the differences between programmes and projects Describe the Principles, Themes and Processes as described in the MSP® - 5th Edition Practice the application of MSP® Prepare for both the MSP® Foundation and Practitioner Exam Please note that examinations are the responsibility of the examination board, PEOPLECERT and must be organised separately by each person attending. Content Introduction Introduction – what is, and why use, Programme Management The Three Lenses of the MSP® FrameworkMSP PrinciplesMSP ThemesMSP Processes The Themes Overview – introduction to the seven Themes Organization – roles, accountabilities, responsibilities Design – Vision, Benefits, Risk, Target Operating Model Justification – Business case and financial planning Structure – Delivery approaches, Planning and control Knowledge – Knowledge and Information management Assurance – Assurance at multiple levels approach and planning Decisions – Decision-making, Issue and Risk resolution approaches, Data-gathering and options analysis The Processes Overview – the seven processes Identify the Programme – initial justification Design the Outcomes - establishing solid foundations Plan Progressive Delivery – build on the programme design Deliver the Capabilities– oversee programme delivery Embed the Outcomes – adopting new ways of working and realize the benefits Evaluate new information – collecting, evaluating, analysing and presenting new information Close the Programme – final assessment and release resources Practitioner Workshop and Examination MSP® Practitioner Examination Objectives and Guidance MSP® Review MSP® Practitioner Examination Workshops MSP® Practitioner Examination MSP® Foundation and Practitioner Examinations The MSP® Foundation Exam is of 1 hour duration and consists of 60 multiple choice questions. A Pass is 36 correct answers, 60%.   The MSP® Practitioner Exam is a written paper of 2.5 hours duration. There are 70 Objective Test style questions to be answered in the 2.5 hours and the candidate may use an annotated manual. The candidate must score 42/70, 60%, to be successful. Presented in association with aims4change, a PEOPLECERT Accredited Training Organisation. MPS® is a Registered Trade Mark of AXELOS Limited.

Regulation 10 of the Control of Asbestos Regulations 2012 sets down requirements for asbestos awareness training. Basically, any employer involved in work where there might be a risk of disturbing asbestos, such as general building, maintenance, demolition, or refurbishment, is required by law to ensure that all affected employees are educated and trained appropriately. More recently the importance of adherence to the awareness measures has been emphasised in the Health & Safety Executive’s ‘Duty to Manage Asbestos Enforcement Initiative’ and it is now clear that non-compliance will not be tolerated. In fact, several perpetrators have already been served with improvement notices, or in the worst-case scenario a probation notice, which results in an immediate and costly halt to work. Employee training is believed to be the best way to target the estimated 1.8 million workers who are potentially at risk of life-threatening illnesses following exposure to asbestos in their day-to-day work. These people include plasterers, roofers, plumbers, electricians, demolition, maintenance men and joiners but also the less obvious workers such as computer installers, ground workers, landscapers, and fire & burglar alarm installers. Aims To raise personnel awareness of asbestos and the risks associated with it. To comply with the legal requirement of The Control of Asbestos Regulations 2012. Course Content • Introduction to asbestos - nature and origin • Types of asbestos • Properties and benefits (use of asbestos) • Health hazards • Possible locations of asbestos in buildings • Current legislation and guidance • Legal limitations on work liable to disturb asbestos • Working safely/duty holders’ responsibilities • Safe working in areas where asbestos is present • Decontamination • Emergency procedures/accidental damage/general procedures. Prerequisites None – The course is intended either as an introduction or as an update. Assessment Delegates will be required to complete a short multiple-choice test at the end of the training. Certificate This course is covered by certification to provide to your Clients, CHAS (and other SSIP) as confirmation of training undertaken and is valid for 2 years. Instructions Cost includes: course notes, certification & refreshments. Directions Location Map