58 Designer courses in Camberley

ADO.NET training course description This ADO.net training course is designed to enable developers to use the toolset provided with.NET for data access including ADO.net objects, data controls, designers and interoperability with earlier ADO objects. The course is applicable for those using C# or VB.NET with ADO.NET What will you learn Retrieve and manipulate data using Microsoft's ADO.NET library. Work with the ADO.NET object model. Update data, including handling stored procedures, parameters, and return value. Search, sort and filter data. Leverage the power of XML. ADO.NET training course details Who will benefit: Programmers working with ADO.Net. Prerequisites: Effective programming with VB.NET or Concise introduction to C# Duration 2 days ADO.NET training course contents Introducing ADO.Net Traditional Data Access Architecture. ADO.Net Disconnected Data Access Architecture. Different components of ADO.Net. A review of basic SQL queries SQL SELECT Statement. SQL INSERT Statement. SQL UPDATE Statement. SQL DELETE Statement. Common data access tasks with ADO.Net Accessing Data using ADO.Net. Defining the connection string. Defining a Connection. Defining the command or command string. Defining the Data Adapter. Creating and filling the DataSet. A Demonstration Application The Interface. Loading the table. Filling the controls on the Form. Navigating through the records. Updating Data Steps for updating the table. Building the Application. Loading the table and displaying data in the form's controls. Initialising Commands. Adding Parameters to the commands. The ToggleControls() method of our application. Editing (or Updating) Records. Event Handler for the Save Button. Event Handler for the Cancel Button. Inserting Records. Deleting a Record. Using Stored Procedures Sample Stored Procedures. UPDATE Stored Procedure. INSERT Stored Procedure. DELETE Stored Procedure. SELECT Stored Procedure. Using Stored Procedures with ADO.Net.

About this Virtual Instructor Led Training (VILT)  Electrification of the transportation sector will impact the power system in several ways. Besides the additional load, local impact on the grid needs to be managed by the grid operators. Simultaneously charging of many electric vehicles (EVs) might exceed the limits in specific locations. On the other hand, EVs can provide flexibility and other ancillary services that will help grid operators. This 3 half-day VILT course will provide a complete overview of integrating electric vehicles (EVs) into the power grid. It will cover the whole value chain from grid operations to the car battery. This includes the control room, possible grid reinforcement, demand side management and power electronics. This course will demonstrate the impact on the grid and solutions for a safe & cost-effective grid plan and operation, with examples of successful integration of EVs. The course will also provide vital knowledge about technology used for EVs such as power electronics, demand side management, communication and batteries. In this context, the focus will be on power electronics as it has the highest impact on the grid. The grid planning tool, pandapower, is introduced as an open source tool for power system modelling. The set-up of the training course allows for discussion and questions. Questions can be formulated by the participants upfront or during the training. This course is delivered in partnership with Fraunhofer IEE. Training Objectives At the end of this course, the participants will: Understand the charging options for EVs and its impact on the grid and batteries Identify system services for EVs with regards to voltage quality at the point of common coupling Discover what are the 'grid friendly' and grid supporting functions in EVs Uncover the different applications, standards and data researched on EVs Examine the application of a grid planning tool (pandapower) for power system modelling Be able to develop code snippets with pandapower Apply and execute a code example for power system modelling with pandapower Target Audience EV and grid project developers and administrators Power grid operators and planners EPC organisations involved in grid development EV/ battery manufacturers and designers EV transport planners and designers Government regulators and policy makers Training Methods The VILT will be delivered online in 3 half-day sessions comprising 4 hours per day, with 2 x 10 minutes breaks per day, including time for lectures, discussion, quizzes and short interactive exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end of every session/day. Trainer Our first course expert is Head of Department Converters and Electrical Drive Systems at Fraunhofer IEE and Professor for Electromobility and Electrical Infrastructure at Bonn-Rhein-Sieg University of Applied Sciences. He received his engineering degree in automation in 2008 by the THM Technische Hochschule Mittelhessen (FH Giessen-Friedberg). Afterwards he studied power engineering at University of Kassel and received his diploma certificate in 2010. In 2016 he received the Ph.D. (Dr.-Ing.) from the University of Hannover. The title of his dissertation is Optimized multifunctional bi-directional charger for electric vehicles. He has been a researcher at the Fraunhofer IEE in Kassel since 2010 and deals with power converters for electric vehicles, photovoltaics and wind energy. His current research interests include the bidirectional inductive power transfer, battery charger and inverter as well as new power electronic components such as SiC MOSFETs and chokes. Additionally, our key expert is Chairman of the IEEE Joint IAS/PELS/IES German Chapter and a member of the International Scientific Committee of the EPE Association. Our second course expert is deputy head of energy storage department at Fraunhofer IEE. Prior to this he was the Director of Grid Integration department at SMA Solar Technology AG, one of the world's largest manufacturers of PV power converters. Before joining SMA, our course expert was manager of the Front Office System Planning at Amprion GmbH (formerly RWE TSO), one of the four German transmission system operators. He holds a degree of electrical engineering of the University of Kassel, Germany. In 2003 he finished his Ph.D. (Dr.-Ing.) on the topic of wind power forecasting at the 'Institute of Solar Energy Supply Technology' (now Fraunhofer IEE) in Kassel. In 2004 he started his career at RWE TSO with main focus on wind power integration and congestion management. Our course expert is chairman of the IEC SC 8A 'Grid Integration of Large-capacity Renewable Energy (RE) Generation' and has published several papers about grid integration of renewable energy source and forecasting systems on books, magazines, international conferences and workshops. Our third course expert is Research Associate at Fraunhofer IEE. He is actively working on different projects related to the integration of electric vehicle charging into the electric distribution grid. The focus of this work concerns time series based simulations for grid planning and operation in order to investigate the effect of a future rollout of electric vehicles and charging infrastructure on economics e.g. costs for grid reinforcement. He completed his master degree (MSc.) in Business Administration and Engineering: Electrical Power Engineering at RWTH Aachen University, Germany. Our trainers are experts from Fraunhofer Institute for Energy Economics and Energy System Technology (Fraunhofer, IEE), Germany. The Fraunhofer IEE researches for the national and international transformation of energy supply systems POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

The legendary Peter Keep from Jewellery Training Solutions is heading to Woking from Australia to teach his vast knowledge. Our focus within both courses on offer this weekend is to offer our students intricate technical knowledge which is quickly lost to new technology. Well skilled technical jewellers able to create multiple designs by hand are rare and in demand, Peter is dedicated to sharing his endless knowledge and tips, and while he can usually be found online, we are lucky enough to offer classes with Peter in person – a golden opportunity not to be missed. WHEN: FRIDAY 6th September 10-4 WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Peter Keep –About WHAT DOES THE DAY INVOLVE? The legendary Peter Keep from Jewellery Training Solutions is heading to Woking from Australia to teach his vast knowledge. Our focus within both courses on offer this weekend is to offer our students intricate technical knowledge which is quickly lost to new technology. Well skilled technical jewellers able to create multiple designs by hand are rare and in demand, Peter is dedicated to sharing his endless knowledge and tips, and while he can usually be found online, we are lucky enough to offer classes with Peter in person – a golden opportunity not to be missed. In this class Peter will teach you how to make a catch with a hinged locking mechanism.This project is easier than it first looks, but you do need to have experience piercing out shapes and drilling. During the one-day workshop Peter will show you some other options and explain how they work. You will also be provided with information handouts and materials. These specialist skills can be applied across other aspects of jewellery making. You NEVER stop learning as far as the jewellery industry is concerned and it is Peter’s passion to maintain traditional skill. EXPERIENCE REQUIRED: Students should have some workshop experience and be confident using normal jewellery tools and equipment. If you are unsure, please email us at hello@workshop925.com to discuss any queries, we are always here to help. CLASS SIZE: 7 WHAT IS INCLUDED? All tools and consumables are supplied. WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. Please bring any lunch, snacks and drinks which you may want to your session. We have tea and coffee for you to help yourselves to. We supply all materials and tools. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.

Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!

The legendary Peter Keep from Jewellery Training Solutions is heading to Woking from Australia to teach his vast knowledge. Our focus within both courses on offer this weekend is to offer our students intricate technical knowledge which is quickly lost to new technology. Well skilled technical jewellers able to create multiple designs by hand are rare and in demand, Peter is dedicated to sharing his endless knowledge and tips, and while he can usually be found online, we are lucky enough to offer classes with Peter in person – a golden opportunity not to be missed. If you’re ready to boost your skills and make jewellery findings with a locking mechanism, this course with Peter are a must. Clasp making demands precision, calculation and attention to detail. You will learn how to fabricate the elements required to create the working parts of a clasp and learn how to combine these elements. Peter will guide you through each step to create your clasp, sharing his wonderful hints and tips he has developed through years of training and experience in the industry across the world. WHEN: Saturday 7th September 10-4/5 WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Peter Keep –About WHAT DOES THE DAY INVOLVE? The legendary Peter Keep from Jewellery Training Solutions is heading to Woking from Australia to teach his vast knowledge. Our focus within both courses on offer this weekend is to offer our students intricate technical knowledge which is quickly lost to new technology. Well skilled technical jewellers able to create multiple designs by hand are rare and in demand, Peter is dedicated to sharing his endless knowledge and tips, and while he can usually be found online, we are lucky enough to offer classes with Peter in person – a golden opportunity not to be missed. If you’re ready to boost your skills and make jewellery findings with a locking mechanism, this course with Peter are a must. Clasp making demands precision, calculation and attention to detail. You will learn how to fabricate the elements required to create the working parts of a clasp and learn how to combine these elements. Peter will guide you through each step to create your clasp, sharing his wonderful hints and tips he has developed through years of training and experience in the industry across the world. You will learn advanced soldering skills to create a tubular barrel and learn how to form a hardened snap catch.This technique will open your mind to other types of catches & clips. Peter will show you some other options and explain how they work.These specialist skills can be applied across other aspects of jewellery making. You NEVER stop learning as far as the jewellery industry is concerned and it is Peter’s passion to maintain traditional skill. EXPERIENCE REQUIRED: Students should have some workshop experience and be confident using normal jewellery tools and equipment. If you are unsure, please email us at hello@workshop925.com to discuss any queries, we are always here to help. CLASS SIZE: 7 WHAT IS INCLUDED? All tools and consumables are supplied. WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. Please bring any lunch, snacks and drinks which you may want to your session. We have tea and coffee for you to help yourselves to. We supply all materials and tools. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.

Help for GCSE Product Design Students who are struggling with the exam element of the qualification.

This Level 4 City and Guilds 2396-01 Design and Verification of Electrical Installations course has been designed to help develop the skills and up date the knowledge of the requirements to enable you to professionally design, erect and then verify an electrical installation. This course is aimed at those who will have responsibility for designing, supervising, installing and testing electrical installations. Further information can be found here: C&G 2396 Electrical Design Course — Optima Electrical Training (optima-ect.com)

See how plastic bottle tops are remelted into beautiful objects!

Data Ethics for Business Professionals is designed for individuals who are seeking to demonstrate an understanding of the ethical uses of data in business settings.

In this one-day introduction to grain setting techniques, you will learn how to set small stones in a selection of styles. We will begin with a simple single stone grain setting before moving onto a traditional star setting and finally a row of five stones in a thread and grain style setting. During the day we will also look at considerations for grain setting as well as the preparation of tools and possible applications. WHEN: Saturday 14th September 10-5pm WHERE:  Workshop 925 based at The Mayford Centre, just outside of Woking and very close to Guildford. Unit F9 The Mayford Centre, Mayford Green Woking, Surrey  GU22 0PP TUTOR: Stephen Barnett WHAT DOES THE DAY INVOLVE? In this one-day introduction to grain setting techniques, you will learn how to set small stones in a selection of styles. We will begin with a simple single stone grain setting before moving on to a traditional star setting and finally a row of five stones in a thread and gain style setting. During the day, we will also look at considerations for grain setting as well as the preparation of tools and possible applications. As always with advance stone setting, we strongly recommend you set aside some time after your course to practice the skills you learn to develop your technique. We will be in touch the week of your course with full details and directions and any other helpful information we think will be of use for the day. EXPERIENCE REQUIRED: Students should have some stone setting experience and be confident using normal jewellery tools and equipment. If you are unsure, please email us at hello@workshop925.com to discuss any queries, we are always here to help. CLASS SIZE: 7 WHAT IS INCLUDED? All tools and consumables are supplied including your stones and silver. WHAT TO BRING: For safety reasons, during each class, you are required to wear appropriate footwear, we request that no open toed shoes are worn within Workshop 925. Long hair should also be tied back when working with the equipment. You may also wish to bring a notebook. We have handouts for many demonstrations, but there are always many tips and tricks given verbally by the tutor, which some might like to keep note of. Please bring any lunch, snacks and drinks which you may want to your session. We have tea and coffee for you to help yourselves to. For stone setting courses, it is also recommended to bring Optivisors if you have any or glasses which allow you to see smaller stones. PAYMENT OPTIONS: You can pay via our website or in our workshop in person using our card machine. If you prefer to pay directly, you can email us on hello@workshop925.com and we can invoice you manually to arrange a bank transfer. For classes over £80, instalment options are also available. Please email us on hello@workshop925.com to arrange. Gift Voucher – if you have a voucher to redeem, please email us before booking on hello@workshop925.com Please check your dates carefully before booking a class as we are unable to offer refunds. See our Terms & Conditions for full details.