• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

13777 Ear courses delivered Online

CCNA training course description The Implementing and Administering Cisco Solutions (CCNA) course gives you a broad range of fundamental knowledge for all IT careers. Through a combination of lecture, hands-on labs, and self-study, you will learn how to install, operate, configure, and verify basic IPv4 and IPv6 networks. The course covers configuring network components such as switches, routers, and wireless LAN controllers; managing network devices; and identifying basic security threats. It also gives a foundation in network programmability, and software-defined networking What will you learn Install, configure, and operate a small to medium sized network Gain a foundation in the essentials of networking, security, and automation Prepare for the 200-301 CCNA exam, which earns CCNA certification CCNA training course details Who will benefit: Network support help desk technicians involved in the basic installation, operation, and verification of Cisco networks. Anyone seeking CCNA certification. Prerequisites: Introduction to Data communications & networking Duration 5 days CCNA training course content After taking this course, you should be able to: Identify the components of a computer network and describe their basic characteristics. Understand the model of host-to-host communication. Describe the Cisco IOS software. Describe LANs and the role of switches within LANs. Describe Ethernet and describe the operation of switches. Install a switch and perform the initial configuration. Describe the TCP/IP Internet layer, IPv4, its addressing scheme, and subnetting. Describe the TCP/IP Transport and Application layers Explore functions of routing. Implement basic configuration on a Cisco router. Explain host-to-host comms across switches and routers. Identify and resolve common switched network issues and common problems associated with IPv4 addressing. Describe IPv6 main features and addresses, and configure and verify basic IPv6 connectivity. Describe static routing. Describe, implement, and verify VLANs and trunks. Describe inter VLAN routing. Explain the basics of dynamic routing protocols and describe components and terms of OSPF. Explain how STP and RSTP work. Configure link aggregation using EtherChannel. Describe the purpose of Layer 3 redundancy protocols. Describe basic WAN and VPN concepts. Describe the operation of access control lists (ACLs) and their applications in the network. Configure Internet access using DHCP clients and explain and configure NAT on Cisco routers. Describe basic QoS concepts. Describe the concepts of wireless networks, which types of wireless networks can be built, and how to use Wireless LAN Controllers (WLCs). Describe network and device architectures, introduce virtualization, network programmability and SDN and describe smart network management solutions such as Cisco DNA Center™, SD-Access, and SD-WAN. Configure basic IOS system monitoring tools. Describe the management of Cisco devices. Describe the current security threat landscape. Describe threat defence technologies. Implement a basic security configuration of the device management plane. Implement basic steps to harden network devices. Detailed course outline Exploring the Functions of Networking. The Host-to-Host Communications Model. Operating Cisco IOS Software. Introducing LANs. Exploring the TCP/IP Link Layer. Starting a Switch. The TCP/IP IP layer, IPv4 Addressing, and Subnets. The TCP/IP Transport Layer and Application Layer. Exploring the Functions of Routing. Configuring a Cisco Router. Exploring the Packet Delivery Process. Troubleshooting a Simple Network. Introducing Basic IPv6. Configuring Static Routing. Implementing VLANs and Trunks. Routing Between VLANs. Introducing OSPF. Redundant Switched Topologies with EtherChannel. Explaining Basics of ACL. Enabling Internet Connectivity. Explaining the Evolution of Intelligent Networks. Introducing System Monitoring. Managing Cisco Devices. Securing Administrative Access. Implementing Device Hardening. Self-Study: Building Redundant Switched Topologies. Exploring Layer 3 Redundancy. Introducing WAN Technologies. Introducing QoS. Explaining Wireless Fundamentals. Introducing Architectures and Virtualization. Examining the Security Threat Landscape. Threat Defense Technologies.

CCNA
Delivered in Internationally or OnlineFlexible Dates
£2,797

28th January Imogen Pelham #Agent121. Looking for: ADULT FICTION, NON-FICTION

5.0(1)

By I Am In Print

LOOKING FOR: ADULT FICTION, NON-FICTION Imogen Pelham has been at Marjacq since 2015, and has worked as a literary agent for more than a decade. She represents literary fiction and some upmarket commercial fiction, as well as a wide range of non-fiction. Imogen's looking for fiction with a strong premise, a surprise twist, or sharp humour. Recent favourites include Leave The World Behind by Rumaan Alam, Early Morning Riser by Katherine Heiny, and Sorrow & Bliss by Meg Mason. Her non-fiction list includes history, memoir, medicine and psychology. She is particularly interested in identity, the arts and investigative journalism. Imogen would like you to submit a covering letter, 1 - 2 page synopsis and the first 10,000 words of your manuscript in a single word document. (In addition to the paid sessions, Imogen is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 20th January 2025

28th January Imogen Pelham #Agent121. Looking for: ADULT FICTION, NON-FICTION
Delivered Online + more
£72

28th January Kate Walsh #Agent121. Looking for: ADULT FICTION, NON-FICTION

5.0(1)

By I Am In Print

LOOKING FOR: ADULT FICTION, NON-FICTION Kate Walsh has built up many years of agenting experience across her own list, and another senior agent's list at United Agents for 9 years before parting ways and going it alone for a while. Fiction-wise, she works on a hugely broad list for expansive commercial genre fiction and is on the lookout for historical fiction, upmarket women’s fiction, clever commercial thrillers, romance and some SFF, particularly those with a dystopian slant, or earth-bound science fiction, however that comes. Kate will also look at YA, though is not the right fit for high fantasy. On the non-fiction side, Kate has worked with an impressive list of clients across the commercial spectrum. She's on the lookout mainly (although not exclusively) for music titles, history and broad-spectrum popular science, but is open to anything that feels like a fresh and original way of looking at the world. She is especially drawn to 20th and 21st century affairs, and welcomes anything from anyone willing to speculate on what comes next.  Kate would like you to submit a covering letter, 1 page synopsis and the opening three chapters (max 5,000 words). (In addition to the paid sessions, Kate is offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Thursday 16th January 2025

28th January Kate Walsh #Agent121. Looking for: ADULT FICTION, NON-FICTION
Delivered Online + more
£72

Process Hazard Assessment using the HAZOP Technique and HAZOP Team Leader Training

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course Process Hazard Assessment using the HAZOP Technique is an intensely participative course that will both explain the key facets of the HAZOP technique as well as provide ample opportunities for participants to practice and become familiar with the technique using generic and real-life examples. HAZOP Team Leader Training is an intensely participative course that will develop participants already familiar with the HAZOP technique, the skills, knowledge and attributes of a HAZOP Team Leader. An in-depth syndicate exercise will provide the opportunity to lead a HAZOP team (consisting of other participants) and to be observed performing the role for constructive feedback. This 5 full-day course has been reviewed and approved by the Institution of Chemical Engineers (IChemE). IChemE is the global professional membership organisation for chemical, biochemical and process engineers and other professionals involved in the chemical, process and bioprocess industries. Their knowledge of professional standards, close involvement with industry, education and regulators, and their expertise as a leading global training provider, means they are uniquely positioned to independently assess and approve training courses and professional development programmes across the world. Training Objectives Process Hazard Assessment using the HAZOP Technique By the end of this course, participants will be able to: Understand the basic HAZOP Technique Fulfill roles as competent HAZOP Team Members Understand the role of HAZOP in risk management Understand how Hazard Identification can predict accidents and incidents Understand how HAZOP complements other hazard identification tool HAZOP Team Leader Training By the end of this course, participants will be able to: Understand the role of the HAZOP Team Leader Practise the role in a classroom environment Provide feedback to participants on their performance as HAZOP Team Leaders Appreciate the leadership skills required as HAZOP Team Leader Plan, organise, manage and successfully undertake a Hazard and Operability study Target Audience This course will benefit: All key persons in the organisation, who by their discipline and/or position, are likely to be called on to initiate, participate or review a HAZOP study. All who have responsibility for the management and supervision of process & safety including but not limited to Senior Management, Plant Managers, Process and Maintenance Engineers (all disciplines), Line Supervisors, Team Leaders, Safety Specialists, and Process Training Instructors. Course Level Basic or Foundation Trainer Your expert course leader has 50 years' experience in chemical and process safety engineering. His early career included 20 years in design and project engineering with various fine chemical and pharmaceutical companies where he designed chemical processes, specified plant equipment and selected materials for highly corrosive and toxic processes, often where textbook data was not available. This was followed by 10 years in offshore oil and gas design projects where he was responsible for setting up a Technical Safety group to change design safety practices in the aftermath of the 1988 Piper Alpha disaster. In recent years, he has been called upon to conduct various offshore and onshore incident investigations. His career has given him experience in project engineering, project management, process design and operations, safety engineering and risk management. He is a Fellow of the UK Institution of Chemical Engineers. He served on the Scottish Branch committee, and was elected chairman for a two-year term in 1991. He has also been chairman of the Safety and Reliability Society - North of Scotland Branch. He has delivered training courses in Process Hazard Analysis (HAZOP and HAZID), Process Safety Management, Hazard Awareness, Risk Assessment, Root Cause Analysis, Failure Modes & Effect Analysis and has lectured on Reliability Analysis to the M.Sc. course in Process Safety and Loss Prevention at Sheffield University. In addition to delivering training courses, he currently facilitates HAZOP / HAZID / LOPA studies and undertakes expert witness roles advising lawyers engaged in contractual disputes, usually involving the design or construction of chemical plants or Oil & Gas production facilities, or criminal prosecutions. 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 post training support and fees applicable Accreditions And Affliations

Process Hazard Assessment using the HAZOP Technique and HAZOP Team Leader Training
Delivered in Internationally or OnlineFlexible Dates
£3,095 to £3,599

Process Safety Management & Engineering Applications

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course This 5 full-day course covers all the main elements of IChemE's Process Safety Competency framework: culture, knowledge and competence, engineering and design, human factors, systems and procedures, and assurance. Participants will achieve at least the second level of competence 'Basic Application', which is defined as 'Performs fundamental and routine tasks. Requires occasional supervision. Increased functional expertise and ability. Works with others.' This course examines the interrelation of the various techniques of process safety for analysing and managing process hazards in the hydrocarbon and chemical processing industries. There is a particular emphasis on engineering design aspects with extensive participation in individual and group exercises, tutored exercises and video case studies throughout the course to underpin key learning points. The learning is consolidated in a comprehensive case study and requires collaboration between members of each syndicate. This course has been reviewed and approved by the Institution of Chemical Engineers. IChemE is the global professional membership organisation for chemical, biochemical and process engineers and other professionals involved in the chemical, process and bioprocess industries. Their knowledge of professional standards, close involvement with industry, education and regulators, and their expertise as a leading global training provider, means they are uniquely positioned to independently assess and approve training courses and professional development programmes across the world. Training Objectives By the end of this course, participants will be able to: Acquire the underpinning knowledge required to achieve process safety competency Gain a comprehensive understanding of process safety management Understand the concept of the safety life cycle of a process plant from conceptual design onwards including operation, maintenance and modification Understand the hazard scenarios associated with a process plant Understand how risks can be controlled by hardware and procedural measures Identify and analyse hazard causes and consequences Recognise when specialist analytical expertise is required Generate effective and appropriate measures to reduce risks Justify and communicate practical solutions to non-technical personnel Explain the rationale for process safety measures to decision makers Target Audience This course is suitable for process industry professionals who need to acquire a comprehensive understanding of process safety management, those moving into process safety positions or those who wish to broaden their process safety knowledge within their existing discipline. It is particularly suited for anyone involved in the design, operation, modification or maintenance of a major hazard installation. This includes: Supervisors, operators and maintainers in Oil & Gas, Petrochemical and Chemical industries, process, mechanical and chemical engineers and technicians Design engineers, project engineers and HSE managers Control, automation and instrumentation engineers It will also demonstrate a substantial understanding of process safety for those engaged in Continuous Professional Development or aiming for the Chartered Engineer status. Course Level Basic or Foundation Trainer Your expert course leader has 50 years' experience in chemical and process safety engineering. His early career included 20 years in design and project engineering with various fine chemical and pharmaceutical companies where he designed chemical processes, specified plant equipment and selected materials for highly corrosive and toxic processes, often where textbook data was not available. This was followed by 10 years in offshore oil and gas design projects where he was responsible for setting up a Technical Safety group to change design safety practices in the aftermath of the 1988 Piper Alpha disaster. In recent years, he has been called upon to conduct various offshore and onshore incident investigations. His career has given him experience in project engineering, project management, process design and operations, safety engineering and risk management. He is a Fellow of the UK Institution of Chemical Engineers. He served on the Scottish Branch committee, and was elected chairman for a two-year term in 1991. He has also been chairman of the Safety and Reliability Society - North of Scotland Branch. He has delivered training courses in Process Hazard Analysis (HAZOP and HAZID), Process Safety Management, Hazard Awareness, Risk Assessment, Root Cause Analysis, Failure Modes & Effect Analysis and has lectured on Reliability Analysis to the M.Sc. course in Process Safety and Loss Prevention at Sheffield University. In addition to delivering training courses, he currently facilitates HAZOP / HAZID / LOPA studies and undertakes expert witness roles advising lawyers engaged in contractual disputes, usually involving the design or construction of chemical plants or Oil & Gas production facilities, or criminal prosecutions. 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 post training support and fees applicable Accreditions And Affliations

Process Safety Management & Engineering Applications
Delivered in Internationally or OnlineFlexible Dates
£3,095 to £3,599

Seismic Interpretation in Carbonates

By EnergyEdge - Training for a Sustainable Energy Future

Explore the complexities of seismic interpretation in carbonates through our dynamic classroom training course. Energyedge delivers cutting-edge instruction and valuable insights.

Seismic Interpretation in Carbonates
Delivered in Internationally or OnlineFlexible Dates
£3,499 to £3,599

Integrated Field Development Planning for Offshore Fields

By EnergyEdge - Training for a Sustainable Energy Future

About this Virtual Instructor Led Training (VILT) This Virtual Instructor Led Training (VILT) course is designed with the aim of showing the degree of integration necessary in developing an offshore petroleum discovery, from field appraisal to development. The 5 half-day VILT course gives a comprehensive account of the methodology, processes and techniques utilised in developing an offshore oil or gas discovery. Technically, integration of expected reservoir behavior, well planning and design, and facilities concepts and selection are exemplified through detailed case histories, group discussions and exercises. Commercial aspects related to overall project evaluation are also covered. Training Objectives Course participants will obtain a comprehensive understanding of key aspects of offshore field development, from appraisal through to development planning and leading up to sanction. The VILT course covers the three key elements: reservoirs, wells and facilities, and covers the integration of these with commercial aspects, and the required management aspects, including uncertainty and risk. Target Audience This VILT course is designed for project managers, field development and planning engineers, asset managers, petroleum engineers, reservoir engineers as well as field geoscientists and managers who have an interest in or are involved in field development feasibility and planning. In particular, this VILT course would be of interest to managers leading multidisciplinary and diverse functional teams. Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Trainer 1: Your first expert course leader is a specialist in reservoir engineering, field development planning and petroleum management. Having worked for over 40 years in the petroleum industry, his most recent full-time position was Chief Operating Officer and Project Director for AED Oil and East Puffin (2007-09) for the Puffin offshore development, Timor Sea. Prior to his academic career (2001-2006), commencing in 2001 as head of the new School of Petroleum Engineering and Management at the UA, he worked for 16 years for BHP Petroleum (now BHP Billiton), most recently as Chief Reservoir Engineer for their worldwide operations. Other positions with BHP Billiton involved mainly technical and project management, and general management positions, including member of the BHP Board. He was project manager (feasibility) for two FPSO projects, the Skua and Griffin area fields, offshore Australia. He was also the Technical Manager for the Dai Hung project, offshore Vietnam where first oil was achieved in just 18 months from sanction. Before that time, he worked for Shell International (8 years) in the Netherlands, including two years as Senior Lecturer Reservoir Engineering at Shell's training centre and in Australia, seconded to Woodside Energy, with a key role in Australia's largest capital project (at the time), the Northwest Shelf Gas development. He started his career in Calgary, Canada, first with Hudson's Bay Oil and Gas and subsequently with the US consulting company, Scientific Software Corporation. He holds a BSc degree in Physics from the University of British Columbia and a MS degree in Nuclear Engineering from Stanford University. He has been an active member of the Society of Petroleum Engineers, including Director for the Asia-Pacific region (1996-98) and as a member of the Board. He was an SPE Distinguished Lecturer during 2001-02 and a PESA Distinguished Lecturer during 2002. He has lectured at many institutions and was a visiting professor at Stanford University in 2000. He has published over 50 papers on both technical and managerial topics. His professional interests are in optimal planning and project management of offshore petroleum discoveries. His primary research interests are in the area of special core analysis and the development of predictive models for reservoir characterisation. Trainer 2: Your other course leader is currently an independent consultant and trainer after 37 years in the upstream petroleum industry. His previous roles included Chief Geologist for GALP Energy, Consultant/ Head of Exploration for Qatar Petroleum, Technical/ Asset Manager for SASOL, and various technical and technical management roles in BHP Billiton Petroleum and Chevron. He managed/ executed many projects in diverse locations: West Grimes gas field development - California; Port Arguello heavy oil development - offshore California; exploration & development projects - Nigeria; Tengiz field early development, Korolev appraisal - Kazakhstan; Nkossa field development, Moho/ Bilondo exploration - offshore Congo; PNG divestment, Bayu-Undan LNG development - Australia; Ohanet acquisition, appraisal & development - Algeria; Pande development, Pande/ Temane gas plant expansion & near field exploration - Mozambique; Pre-Khuff (HP/HT) exploration, multiple blocks & operators - Qatar; Coral/ Mamba appraisal - Mozambique; Blocks 14/32 exploration & development - Angola; exploration & appraisal - onshore & offshore Brazil. He has an MSc in Geophysics from Stanford, an MBA from St. Mary's College of California, and a BSc in Geology (Honors) from Western Illinois University. He is a member of SEG, AAPG, SPE, PESGB, and PESA and is a Fellow of the Energy Institute (UK). His professional interests centre around deploying this extensive and international experience base to add value to future projects via training and consultancy, and to provide the leadership needed to execute, deliver, and ensure profitability of new projects. 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

Integrated Field Development Planning for Offshore Fields
Delivered in Internationally or OnlineFlexible Dates
£1,854 to £3,499

Battery Energy Storage Systems (BESS) in Electricity Markets and Trading

By EnergyEdge - Training for a Sustainable Energy Future

About this Course Batteries are going to play an increasingly important role in the energy grid. An increasing number of developers are looking to add battery storage systems (BESS) into their existing projects. However future cash flows are highly uncertain and they are often unsure exactly how battery technology can be monetised. A strong revenue model requires stacking of different revenue sources. As the share of variable renewable sources in electricity systems further increase, battery systems are expected to play a growing role by providing frequency control and operational reserves as well as for wholesale arbitrage, while helping reduce grid integration costs. The more volatile electricity prices are, the greater the earning potential of batteries trading electricity on various electricity markets. BESS can generate revenue streams in several different ways; through a frequency response contract with the TSO, by providing grid services in other ways or by arbitrage through buying cheap power and selling power for a higher price in a liquid wholesale market. Because batteries are efficient, the round trip efficiency is also high. They can spread arbitrage trading much better than other storage types and in many cases, other asset classes. For companies that combine a battery with other tasks, for example to store power from their own panels, or to avoid a costly heavy power connection, the investment is less risky than for those that purely focus on arbitrage trading. It is uncertain whether electricity prices will fluctuate more violently in the coming years, or whether the peaks will actually level off. During this highly interactive training, the trainer will provide you with the latest insights and best practices on how to obtain the maximum economic benefits when participating with BESS in the electricity market. Training Objectives By the end of this course, the participants will be able to: Discover the different BESS battery technologies and their impact on the grid Understand the role of storage in providing flexibility to the power system Examine the potential revenue streams from BESS models Learn how profit can generated with BESS trading strategies Determine how to optimize the value from BESS projects Find out how to combine BESS with renewable PPAs Target Audience Professionals and executives from Power Utilities, Energy Companies, Financial & Investment Banks, Renewable Power Project Developers, Transmission System Operators and Energy Industry Regulators will find this training course useful. Electricity Marketing and Traders New Venture or Business Development Executives Corporate Finance and Treasury Executives Audit and Risk Management Executives Power or Utility Market Research Analysts Investment Managers for Renewable Power Projects Origination Professionals Regulation, Compliance and Documentation Officers Lawyers and Accountants Power Transmission and Distributions Engineers Trainer Our key expert is a skilled and accomplished professional with over 25 years' of extensive senior management / board level experience in the energy markets worldwide. Next to advising energy companies, banks, consultants and regulators regarding PPAs, our key expert has also conducted several highly successful training courses about Power Purchase Agreements, Power Project Finance, IPPs, and Project Risk Management to over 1,000 high level participants from Asia, Africa, Europe and Middle East. He was a member of the expert commission of the Dutch Government for 2 offshore wind parks, Hollandse Kust (zuid) Wind Farm Zone Sites 3 and 4 that advised on which of the 5 applicants did provide the best security and solutions associated with the electricity and green certificate prices, the construction and operational risks of the project. 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 post training support and fees applicable Accreditions And Affliations

Battery Energy Storage Systems (BESS) in Electricity Markets and Trading
Delivered in Internationally or OnlineFlexible Dates
£2,837 to £3,299

Property Sourcing Business Blueprint

By Property SQ2

Build a property sourcing business, negotiation property deals as a sourcing agent or buyer's agent. Be legal and compliant, learning industry best practice as a deal packager.

Property Sourcing Business Blueprint
Delivered OnlineFlexible Dates
£1,100 to £3,000

Complete ADO.NET for developers

5.0(3)

By Systems & Network Training

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.

Complete ADO.NET for developers
Delivered in Internationally or OnlineFlexible Dates
£2,477