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
Help for GCSE Product Design Students who are struggling with the exam element of the qualification.
Come and join us to learn this beautiful meditative technique and let your mind and body relax with your hands engaged in this amazing creative and mindful activity. Weaving is a technique that has existed for thousands of years, present in every culture across the globe. You can weave with various materials and we will be using only upcycled wool and other textile pieces. You are also more than welcome to bring your own fabric scraps or wool and incorporate them it into your project. During the 3 hours workshop, you will learn how to set up a basic weaving loom, see some examples, and discuss various possibilities how they could be incorporated into clothing and fashion projects. This workshop will familiarise you with basic weaving techniques. We will cover how to prepare a loom, the plain weave and the soumak stitch. You should be able to complete a small wall hanging about size A6 (4,1x5,8 inches) or a bookmark if you are a complete beginner. This workshop is led by Anna Baran, a trauma informed designer, artist, and maker based in the north of Edinburgh. She has always drawn inspiration from the sea, with her walks to local beaches, particularly Wardie Bay during the lockdown, becoming not only a source of new ideas for her artistic practice but also a way to gather materials such as driftwood, pieces of plastic ropes, and seashells. Anna has consistently sought to incorporate upcycled materials into her art, using her work to raise environmental awareness and promote art as an accessible medium for self-expression, regardless of financial circumstances. In addition to participating in various art exhibitions and fashion-related events, she has delivered a wide range of art and craft workshops to diverse communities across Edinburgh. This FREE workshop is for Adults women only and is sponsored by CORRA and HENRY DUNCAN GRANTS By attending this class you release Anna Baran, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending. Pictures will be taken during the workshop, if you prefer not to be in them, please inform the teacher.
Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!
This course will introduce you to the beautiful world of colour analogue photography. Taking as a starting point the work of contemporary photographic artists working with colour, we will discuss and explore theory as well as developing core skills essential for the capture and printing of your own colour images. You will learn how to correctly expose colour negative film and learn more about the characteristics of different types of film and the effects that they can have on an image. Within Stills’ darkrooms you will learn how to process your colour film by hand and print high quality analogue C-Type prints. Day 1 Morning: Colour Theory, Inspiration and Refresher for SLR Camera Controls During the morning we will be looking at contemporary photographers and artists that have used colour to inform their practice in specific ways. We will look at the ways in which colour revolutionized the artworld and vernacular photography. We will also look at basic colour theory, exploring which colours compliment each other and why. We will also refresh basic camera controls, load cameras and head out to the streets to shoot a roll of film. Afternoon: Colour Film Processing During this session, you will learn how to hand process your colour film. We will discuss the loading of the tank and the preparation of the machine to ensure correct processing temperature. We will look at different film types, why you may want to use them and the range of effects that can be produced. Day 2 Morning: Introducing the Colour Darkroom and Contact Sheets You will be introduced to Stills colour darkooms and become familiarised with the range of equipment you will be using. You will be taught how to set up your darkroom for printing, how the colour print processor works and how to print a contact sheet for viewing your negatives. Afternoon: Printing In the afternoon you will be expected to make a series of final C-Type prints. You will be shown techniques to improve your printing skills and produce the images you desire. This last session will allow you time to print with some one-to-one attention. We will discuss some printing techniques to help you get the most from your negatives. We will also have time at the end of the day to look back on all the work produced over the course and discuss it in relation to theory we learnt at the beginning. By the end of the course you will have: Learned more about colour theory and have a knowledge of contemporary artists working with colour photography Learned to process your own colour film Experimented with a variety of specialised darkroom printing techniques Printed contact sheets and a collection of colour photographs Feel confident in a colour darkroom using specialist equipment Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.
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)
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.