18457 Other courses

MASTERCLASS: LEARN PROFESSIONAL LEATHER CRAFT, SEWING AND LEATHERGOODS CONSTRUCTION SKILLS One teacher, five students KEY FEATURES OF THIS COURSE:– Understanding and working with leather– Learning leather hand sewing– Learning leather machine sewing– Realising samples of bag features– Realising two finished leather items Experience a comprehensive two-week Leather Craft and Sewing Masterclass, merging theory with hands-on learning Explore essential techniques for working with leather, vegan alternatives, and fabric. Proficiently handle hand tools, master hand-sewing, and operate industrial machines. Cover material selection, finishing and construction methods.Gain insights into the technical aspects of leatherworking, including preparation, marking, cutting, gluing, reinforcing, skiving, debossing, and more.Participants receive thorough instruction in professional sewing techniques on diverse industrial machines, along with specialised saddle stitching training. Create personalised samples to enhance practical skills.Conclude the masterclass with the ability to craft entirely handmade simple leather items, showcasing acquired skills in both machine-stitched and saddle-stitched styles.Facilitated by a prototype maker and manufacturer, the course offers a professional journey into common leatherworking practices.Participants also receive valuable handouts and curated lists of leather and tool suppliers for ongoing reference.   Here is a concise summary of the topics covered during the classes: LEATHER, VEGAN LEATHER, AND HAND TOOLS:Understanding leather types, tanning, finishings and best useExploring different types of vegan leathers and their featuresComparing leather and vegan leather: pros and cons from a manufacturer’s perspectiveImportance of choosing the right materials and tools for projectsLeather preparation, pattern placement and markingCutting complex shapes with various toolsUsing leather punches, skiving, beveling and creasingFinishing leather edges: painting vs. burnishingUtilising leather glues, tapes and reinforcementsExploration of prototyping and manufacturing leather goods, encompassing varied working methods, machines, and tools.   MACHINE AND HAND SEWING:Understanding industrial sewing machines and their differencesSelecting the right sewing machine for specific materials and constructionsOperating a lock stitch walking foot machineThreading industrial sewing machinesAchieving correct tension in sewingUnderstanding thread types and needle sizesLearning to sew leather, distinguishing it from other materialsCorrectly sewing various leather types, ranging from thin to very thickSewing straight lines, curves and creating parallel seamsProducing various seams and seam finishesBasics of saddle stitching leather and understanding related tools and materials   CONSTRUCTION TECHNIQUES:Sewing and finishing a simple zip on leatherCutting, assembling and sewing simple straps/handlesIncorporating basic lining types in projectsConstructing and sewing common gussetsComprehending the use of reinforcements and stabilisers and their application in the craft of accessory making   LEATHER GOODS MAKING:Creating two finalised leather items from chosen designs such as card holders, purses, clutches, glass covers and similar accessories.# By the end of the tuition, you will have:– Developed confidence in utilising specific tools for leather preparation, marking, finishing, cutting and fastening fittings.– Acquired an understanding of working with diverse leather types and thicknesses, with the ability to source and select appropriate tools and materials for your projects.– Mastered essential leather sewing techniques, troubleshooting common sewing issues and handling challenges such as curves, multiple layers of leather and various surface textures.– Learned to sew fundamental bag components like simple zips, straps, and gussets, along with reinforcing specific areas of a bag.– Built confidence in sewing with both industrial machines and by hand, gaining the skills to independently create simple leather items. Included in the course:You will be provided with useful paper handouts which contain:– A list of tools and materials used during the lesson(s), including a description of what they are and how they are used– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing essential key words related to the topic of the lesson– A glossary containing information about leather types and characteristics– A glossary containing information about needle and thread types   What are the entry requirements? This course is suitable for total beginners, beginners with some experience and intermediate.You should be able to use measurements and understand verbal and written English instructions.   Are there any other costs? Materials are included.   Is there anything I need to bring? Feel free to bring a notepad, if you would like to take some notes, we will provide the rest.   How long is this tuition? This tuition will require two consecutive weeks / 50 hours to be completed.We aim to provide customised and high quality tuition services and by only allowing up to 5 students at a time, we are able to focus on each person needs and interests.   IMPORTANT TO KNOW: We aim to cover as much of the syllabus as possible. Depending on your ability and prior experience, we may not complete the entire program or we might delve into additional techniques related to the listed topics, including:Advanced finishing techniques (piping, binding, folding)More complex styles of zipsUtilising different machine feet, tools, and equipment in your sewingExploring various fittings, closure types, fastening techniques, and tools (sam browns, magnets, pop buttons, eyelets, etc.)Understanding the importance and application of construction sequences and reference notes during item construction

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

We deliver CSCS approved courses from the Base Business Space in Hull every Monday and Friday. Other days available on request! We also have access to a onsite CITB Test Centre! We have been supporting clients gain a CSCS Labourers and Skilled cards for over 10 years!

This one day masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook and is aimed at anyone tasked with launching and implementing diversity and inclusion within their organisation.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITIL© 4 Foundation certification and who want to prepare for ITIL© 4 Foundation exam. Overview By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITIL© Practices, and the new Service Value Chain that incorporate the core of ITIL© version 4. ITIL© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITIL© 4. This course will earn you 21 PDUs. This class includes an exam voucher. 1 - ITIL 4 OVERVIEW Introduction to ITIL Key Concepts of ITIL 2 - The ITIL Framework The Four Dimensions of Service Management The ITIL Service Value System 3 - The ITIL Guiding Principles Focus on Value Start Where You Are Progress Iteratively with Feedback Collaborate and Promote Visibility Think and Work Holistically Keep It Simple and Practical Optimize and Automate 4 - THE ITIL SERVICE VALUE SYSTEM (SVS) Governance The Service Value Chain Continual Improvement 5 - Key ITIL Practices Continual Improvement Service Level Management Change Control Incident Management Service Request Management Service Desk Problem Management 6 - Other ITIL Practices General Management Practices Service Management Practices Technical Management Practices

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY

𝐃𝐢𝐝 𝐘𝐨𝐮 𝐤𝐧𝐨𝐰? 😍Vision Boards improves your chance of success! Here's just a few benefits from the process of vision boarding ⤵️ 🔸 Helps you to connect with what you truly want from life; 🔸 Shift your mindset; 🔸 Provides a tool to align and focus your goals And are a great opportunity to meet new and like minded people! I'm looking forward to hosting this vision board workshop with you. 🙏🏻Give me a shout if you have any questions.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended. Overview Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks. This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects. Prerequisites Basic Windows and Active Directory knowledge. Conceptual knowledge of Configuration Manager objects and how they interact. Basic experience performing configuration tasks in ECM using the graphical console. Experience working from a command prompt. Basic knowledge of the fundamentals of Windows PowerShell. 1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS Architecture of an System Center 2012 Configuration Manager Installation Managing Assets Content Delivery and Management Security, Monitoring, and Remote Management 2 - MANAGING RESOURCES Implementing Discovery Organizing Resources with Collections Working with Boundaries 3 - WORKING WITH CLIENTS Installing the Configuration Manager Client Managing Client Settings Managing Client Operations Monitoring Client Status 4 - DISTRIBUTING SOFTWARE Configure the Software Distribution Components Working with Distribution Points Creating Content for Distribution Deploying Software Applications 5 - UPDATING SYSTEMS WITH WSUS AND SCCM Integrating Configuration Manager and WSUS Managing Updates through Software Update Groups Creating and Deploying Update Packages Working with Automatic Deployment Rules 6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS Creating Compliance Settings Objects Deploying and Monitor the Baseline 7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS Preparing the OSD Environment Working with Task Sequences 8 - WORKING AT THE SITE LEVEL Modify the Site Adding Site System Roles Adding a Secondary Site 9 - SECURITY AND MONITORING Configuring Role Based Administration Implementing Endpoint Protection Configuring Monitoring Options 10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS Review of Scripting Constructs Introduction to the Configuration Manager WMI Classes

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.