52632 Courses delivered Online

Web development training course description This three-day course helps build a foundation in the development of Web applications. This is not a HTML course but covers the technologies needed to develop web applications. Technologies covered include: ASP.NET, XML, AJAX and HTTP error codes. What will you learn Program Web applications. Work with data and services. Troubleshoot and debug Web applications. Work with client side scripting. Configure and deploy web applications. Web development training course details Who will benefit: Anyone looking for an introduction to web development. Prerequisites: None. Duration 3 days Web development training course contents Programming web applications Customise the layout and appearance of a web page CSS; tables; embedding images; page layout for navigation. Understand ASP.NET intrinsic objects Request; Server; Application; Session; Response; HttpContext. Understand state information in web applications Understand how state is stored based on application design and hardware; understand different types such as session state, view state, control state and application state. Understand events and control page flow Application and page life cycle events; page events; control events; application events; session events; cross-page posting; Response.Redirect; Server.Transfer; IsPostBack; setting AutoEventWireup. Understand controls Understanding various types of controls, including user, server, web and validation controls; know which is the appropriate type of control for a scenario. Understand configuration files Understanding the usage of web.config and machine.config, and the settings that can be made. Working with data and services Read and write XML data Understanding XML, XML validation Does not include: Web services; XPath syntax; XmlDocument; XPathNavigator; XPathNodeIterator; XPathDocument; XmlReader; XmlWriter; XmlDataDocument; XmlNamespaceManager. Distinguish between DataSet & DataReader objects The ability to choose the proper data object to use based on application requirements/design. Call a service from a web page Creating a basic WCF service or web service so that it can be consumed; App_WebReferences; configuration. Understand DataSource controls LinqDataSource: ObjectDataSource; XmlDataSource; SqlDataSource. Bind controls to data by using data binding syntax Ensure that data is updated and displayed in data-aware controls. Manage data connections and databases Database connections; connection objects; connection pools; transaction objects. Troubleshooting and debugging web applications Debug a web application Use in conjunction with custom error pages to display appropriate error information to the appropriate user; implement tracing of a web application, Trace.axd, Trace=True on @Page directive. Handle web application errors HTTP error codes. Working with client-side scripting Understand client-side scripting Purpose of client-side scripting; various client-side scripting languages. LE/370 and Intrinsic Functions. Understand AJAX concepts ASP.NET AJAX implementation; working with client-side libraries, EnablePartialRendering, Triggers, ChildrenAsTriggers, Scripts, Services, UpdateProgress, Timer, ScriptManagerProxy, extender controls. Configuring and deploying web applications Configure authentication and authorisation Forms authentication, Windows authentication; authorisation; file authorisation; impersonation Does not include: Windows Cardspace authentication, Passport (Windows Live ID) authentication, Custom authentication. Configure projects, solutions and reference assemblies Local assemblies; shared assemblies (GAC); web application projects; solutions; configuration files; AppSettings. Publish web applications Choosing the appropriate method to deploy an application based on existing or intended environment; updatable vs. not updateable; MSI deployment; Internet Information Server (IIS) installation and configuration. Understand application pools Purpose of application pools; effect of application pools on web applications.

4G & 5G Roaming Scenarios & Procedures course description This course is designed to explain the roaming procedures of modern mobile networks, based on the GSMA roaming specification the course explains all scenarios where a mobile subscriber may find themselves whilst visiting a preferred mobile network partner. Interconnection between MNOs and the use of GRX & IPX as an interworking process. The course will work through the registration & authentication procedure, download of the user profile, the APN configuration & DIAMETER process to verify user authenticity. VoLTE roaming and IMS registration procedures for voice support & SMS delivery will be discussed and explained. What will you learn Architecture Models Technical requirements for interfaces - 4G Roaming Scenarios Technical requirements & recommendations for services Other Technical Requirements & Recommendations Technical Requirements for QoS support Technical Requirements & Recommendations for Interfaces - 5G Scenarios Technical Requirements & Recommendations for Interworking & Coexistence with E-UTRAN & EPC Technical Requirements & Recommendations for Services Other Technical Requirements & Recommendations 4G & 5G Roaming Scenarios & Procedures course details Who will benefit: Those working in mobile networks. Prerequisites: None. Duration 3 days 4G & 5G Roaming Scenarios & Procedures course contents Architecture Models 4G Evolved Packet System 5G Core Network SGs Interface for CSFB& SMS over SGs Technical Requirements for Interfaces - 4G Roaming Scenarios General requirements for inter-PLMN interfaces Stream Control Transmission Protocol (SCTP) IAMETER S8 Interface SGW selection PGW selection GTP Transport Layer engineering S9 interface Implementation requirements Guidelines for DIAMETER over S9 S6a & S6d interface Gy interface Guidelines for DIAMETER over Gy Legacy interworking scenarios VPLMN has not implemented LTE HPLMN has not implemented LTE Co-existence scenarios Possible scenarios 2G/3G roaming agreement only 2G/3G LTE roaming agreement LTE roaming registrations Consequences of different APN approaches when roaming Guidance regarding the APN approach when roaming Inter-RAT handover Handover & access restrictions to/from 2G/3G & LTE (Active mode) Access restriction for 2G/3G and/or LTE (Idle mode) Handover of PDN Connections between GERAN/UTRAN & LTE Handover to/from non-3GPP accesses & LTE Bandwidth considerations ARP considerations at handover from LTE to 2G/3G Tech requirements & recommendations for Services SMS SMS over SGs Voice CSFB Roaming retry for CSFB Roaming Forwarding for CSFB Coexistence of Roaming Forwarding & Roaming Retry Recommended procedures IMS Voice Roaming Architecture Other Technical Requirements & Recommendations Access Control Addressing APN for IMS based services IMS Well Known APN APN for Home Operator Services Gateway Selection Inter-PLMN roaming handover Data off related functionality Emergency Services Emergency PDN connectivity Emergency Call indicator Security GTP Security DIAMETER Security DIAMTER Roaming hubbing Default APN E-UTRA NR Dual Connectivity with EPC GW Selection for E-UTRA-NR Dual Connectivity TAC/LAC Restriction Guidelines Technical Requirements for QoS support QoS parameters definition QoS Management in the Home Routed architecture QoS control for IMS APN in the S8HR architecture Support of QoS in GRX/IPX QoS Control in Local Breakout architecture Technical Requirements & Recommendations for Interfaces - 5G Scenarios General requirements for inter-PLMN interfaces Transport protocol - TCP/IP Serialisation protocol - JSON Interface Definition language - OpenAPI Application Protocol - HTTP2 Inter-PLMN (N32) Interface N32c N32f ALS & IPX HTTP Proxy SMF & UPF in HPLMN & VPLMN Requirements related to Service Based Architecture Naming, addressing & routing for 5G SA roaming SEPP load distribution SEPP administration, naming convention & routing SEPP HTTP redirections Technical Requirements & Recommendations for Interworking & Coexistence with E-UTRAN & EPC Interworking scenarios Coexistence scenarios Inter-RAT Handover Handover & Access restriction between 5GC & EPC Technical Requirements & Recommendations for Services Network slicing Voice, Video & Messaging Location support UE Route Selection Policy Other Technical Requirements & Recommendations Access control IP Addressing DNN for IMS based services Emergency PDU Session Emergency Services Fallback Security Steering of Roaming in 5GS Technical Requirements for QoS support 5G QoS model 5G QoS profile QoS Control

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Business Studies bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Business Studies related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Business Studies bundle will help you build a solid foundation to become a proficient worker in the sector. This Business Studies Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Business Studies Course 2: Introduction to Accounting Course 3: Tax Accounting Diploma Course 4: Business Management and Finance Course Course 5: Diploma in Business Analysis Course 6: Operations Management Course 7: Business Law Course 8: AML for Business Owner Course 9: Import/Export Processing Course 10: Port Management Diploma Course 11: Visual Merchandising Diploma Course 12: Business Data Analysis Course 13: Branding Your Business Course 14: Project Management Course 15: Supply Chain Management Course 16: Purchasing and Procurement Course 17: Marketing Fundamentals Course 18: Diploma in Lean Process and Six Sigma Course 19: Cost Control Process and Management Course 20: Business Performance Management Course 21: Stakeholder Management Course 22: Business Plan for Entrepreneours Course 23: Business Strategy Planning Masterclass Course 24: Financial Management Course 25: Financial Analysis 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made Business Studies bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Business Studies Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Business Studies bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Business Studies Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

The aim of the course Bonds Analysis and Valuation is to provide students with the skills and knowledge necessary to analyze and value fixed-income securities. Through this course, students will learn how to evaluate bond characteristics, assess risks, and determine fair value, which are essential skills for a career in finance or investment management.After the successful completion of the course, you will be able to learn about the following, Understand the nature of Bonds and Bond Yields. Understand the process and techniques of Bond Valuation. Understand What are derivatives and their types. The course Bonds Analysis and Valuation is designed to provide students with an in-depth understanding of fixed-income securities. Through this course, students will learn about different types of bonds, bond pricing, yield curves, and interest rate risk. Additionally, students will develop skills in financial modeling and analysis, which are essential for careers in investment management, banking, and corporate finance. The course Bonds Analysis and Valuation is designed to provide students with an in-depth understanding of fixed income securities. Through this course, students will learn about different types of bonds, bond pricing, yield curves, and interest rate risk. Additionally, students will develop skills in financial modeling and analysis, which are essential for careers in investment management, banking, and corporate finance. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Bonds Analysis and Valuation Self-paced pre-recorded learning content on this topic. Bonds Analysis and Valuation Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Fixed Income Analyst Bond Trader Portfolio Manager Credit Risk Analyst Investment Banker Quantitative Analyst Credit Research Analyst Treasury Analyst Asset Management Associate Financial Consultant Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

24 Hour Flash Deal **25-in-1 Mastering Botany: An Advanced Diploma with Comprehensive Study Mega Bundle** Mastering Botany: An Advanced Diploma with Comprehensive Study Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Mastering Botany: An Advanced Diploma with Comprehensive Study package online with Studyhub through our online learning platform. The Mastering Botany: An Advanced Diploma with Comprehensive Study bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Mastering Botany: An Advanced Diploma with Comprehensive Study course provides complete 360-degree training on Mastering Botany: An Advanced Diploma with Comprehensive Study. You'll get not one, not two, not three, but twenty-five Mastering Botany: An Advanced Diploma with Comprehensive Study courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Mastering Botany: An Advanced Diploma with Comprehensive Study courses are yours for as long as you want them once you enrol in this course This Mastering Botany: An Advanced Diploma with Comprehensive Study Bundle consists the following career oriented courses: Course 01: Botany Course 02: Horticulture Online Course Course 03: Horticulture Diploma & Organic Gardening Certification Online Course 04: Garden Design Certificate Course 05: Kitchen Gardening Course 06: Master Herbalism Studies: Theory and Practice Course 07: Ethnobotany & Ethnomedicine Course Course 08: Biodynamic Farming and Gardening Course Course 09: Delving into Plant Pathology: Understanding Crop Health Course 10: Weeds Identification and Control: Maintaining Green Spaces Course 11: Reproduction in Flowering Plants Course 12: Sustainable Agriculture in the UK: Farming for the Future Course 13: Sustainable Agriculture: From Farm to Fork Course 14: Urban Farming and Gardening Course 15: Urban Gardening and Sustainable Cities Course 16: Floristry & Plant Care Training Course 17: Landscape Horticulture Certificate and Plant Nutrition Training Course 18: Journey into the Fascinating World of Plant Science Course 19: Innovations in Plant Breeding Techniques Course 20: Diploma in Mycology: Fungi Studies Course 21: Biochemistry Course 22: Online Course in Conservation Course 23: Build Your Own Home Hydroponic Farm Course 24: Create Your Own Organic Food Garden Course 25: Environmental Law The Mastering Botany: An Advanced Diploma with Comprehensive Study course has been prepared by focusing largely on Mastering Botany: An Advanced Diploma with Comprehensive Study career readiness. It has been designed by our Mastering Botany: An Advanced Diploma with Comprehensive Study specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Mastering Botany: An Advanced Diploma with Comprehensive Study Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Mastering Botany: An Advanced Diploma with Comprehensive Study bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Mastering Botany: An Advanced Diploma with Comprehensive Study Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Mastering Botany: An Advanced Diploma with Comprehensive Study Elementary modules, allowing our students to grasp each lesson quickly. The Mastering Botany: An Advanced Diploma with Comprehensive Study course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Mastering Botany: An Advanced Diploma with Comprehensive Study bundle, you really hit the jackpot. Here's what you get: Step by step Mastering Botany: An Advanced Diploma with Comprehensive Study lessons One to one assistance from Mastering Botany: An Advanced Diploma with Comprehensive Studyprofessionals if you need it Innovative exams to test your knowledge after the Mastering Botany: An Advanced Diploma with Comprehensive Studycourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Mastering Botany: An Advanced Diploma with Comprehensive Study courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Mastering Botany: An Advanced Diploma with Comprehensive Study certificate and transcript on the next working day Easily learn the Mastering Botany: An Advanced Diploma with Comprehensive Study skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Mastering Botany: An Advanced Diploma with Comprehensive Study training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Mastering Botany: An Advanced Diploma with Comprehensive Study Requirements To participate in this Mastering Botany: An Advanced Diploma with Comprehensive Study course, all you need is - A smart device A secure internet connection And a keen interest in Mastering Botany: An Advanced Diploma with Comprehensive Study Career path You will be able to kickstart your Mastering Botany: An Advanced Diploma with Comprehensive Study career because this course includes various courses as a bonus. This bundle is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Mastering Botany: An Advanced Diploma with Comprehensive Study career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

24 Hour Flash Deal **25-in-1 Wild Minds: Exploring Animal Behaviour Online Mega Bundle** Wild Minds: Exploring Animal Behaviour Online Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Wild Minds: Exploring Animal Behaviour Online package online with Studyhub through our online learning platform. The Wild Minds: Exploring Animal Behaviour Online bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Wild Minds: Exploring Animal Behaviour Online course provides complete 360-degree training on Wild Minds: Exploring Animal Behaviour Online. You'll get not one, not two, not three, but twenty-five Wild Minds: Exploring Animal Behaviour Online courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Wild Minds: Exploring Animal Behaviour Online courses are yours for as long as you want them once you enrol in this course This Wild Minds: Exploring Animal Behaviour Online Bundle consists the following career oriented courses: Course 01: Animal Carer & Behaviourist Certificate Course 02: Animal Care and Psychology Course 03: Animal Science Course 04: Equine Psychology Diploma Course 05: Animal Care: Dog Whispering & Pet Nutrition Course 06: Exotic Animal Care Course 07: Veterinary Physiotherapy and Rehabilitation Programs Course 08: Animal Welfare and Ethics: Promoting Compassionate Care Course Course 09: Dog Behaviour Course 10: Dog Nutrition Course 11: Basics of Dog Grooming Course 12: Canine Emergency Care Diploma Course 13: Wildlife Rescue and Rehabilitation Course 14: Canine Communication Dog Training Course 15: Public Health Course 16: Livestock Management Essentials: Caring for Your Animals Course 17: Pet Training Masterclass Course 18: Dog First Aid Course 19: Introduction to Dog Breeds and Basic Anatomy Course 20: Dog Cleaning Course 21: Dog Health Care Course 22: Dog Parasite Care Course 23: Feline Behaviour and Psychology Diploma Course 24: Dog Feeding and Raw Diet Management Course 25: Animal Care, Psychology and First Aid The Wild Minds: Exploring Animal Behaviour Online course has been prepared by focusing largely on Wild Minds: Exploring Animal Behaviour Online career readiness. It has been designed by our Wild Minds: Exploring Animal Behaviour Online specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Wild Minds: Exploring Animal Behaviour Online Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Wild Minds: Exploring Animal Behaviour Online bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Wild Minds: Exploring Animal Behaviour Online Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Wild Minds: Exploring Animal Behaviour Online Elementary modules, allowing our students to grasp each lesson quickly. The Wild Minds: Exploring Animal Behaviour Online course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Wild Minds: Exploring Animal Behaviour Online bundle, you really hit the jackpot. Here's what you get: Step by step Wild Minds: Exploring Animal Behaviour Online lessons One to one assistance from Wild Minds: Exploring Animal Behaviour Onlineprofessionals if you need it Innovative exams to test your knowledge after the Wild Minds: Exploring Animal Behaviour Onlinecourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Wild Minds: Exploring Animal Behaviour Online courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Wild Minds: Exploring Animal Behaviour Online certificate and transcript on the next working day Easily learn the Wild Minds: Exploring Animal Behaviour Online skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Wild Minds: Exploring Animal Behaviour Online training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Wild Minds: Exploring Animal Behaviour Online Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Wild Minds: Exploring Animal Behaviour Online course, all you need is - A smart device A secure internet connection And a keen interest in Wild Minds: Exploring Animal Behaviour Online Career path You will be able to kickstart your Wild Minds: Exploring Animal Behaviour Online career because this course includes various courses as a bonus. This Wild Minds: Exploring Animal Behaviour Online is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Wild Minds: Exploring Animal Behaviour Online career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

VoIP training course description Convergence of voice and data is now a common place mainstream technology. Our Voice Over IP course investigates the characteristics of voice transmission and then studies the impact on IP networks. Practical sessions with soft phones, hard phones and gateways allow the students to see all aspects of VoIP. Network analysers are used to study packets on the wire. What will you learn Describe the issues of voice and data convergence. Describe techniques, which can be used in IP to provide low uniform delay. Evaluate VoIP technologies. Design data networks, which will support voice. VoIP training course details Who will benefit: Anyone working in the field of networking or telecommunications. Prerequisites: TCP/IP foundation for engineers Intro to data communications & networking Duration 3 days VoIP training course contents What is VoIP Voice over IP, brief review of IP, brief review of telephones and voice. Configuring IP softphones What are softphones? Downloading, installing. Hands on Building the base IP network, a simple VoIP call with softphones, Internet telephony. Addressing E164, FQDN, IP addresses, URIs, DNS, SIP addressing, H.323 addressing. VoIP issues Bandwidth, Delay, Jitter, digitising voice, digitisation steps, coding, quality issues, MOS, voice compression, silence suppression, packetising voice, prioritising voice, jitter buffers. Hands on Simple packet analysis. Architectures Desktop, backbone, gateway, hard phones, PoE, integrating phones and PCs, carriers, Softswitches. Hands on Integrating Softphones, hard phones and analog phones. IP performance and QoS ITU delay recommendations, IP DSCP field, DiffServ, IP precedence, queuing strategies; FIFO, WFQ, custom, priority, RED, LLQ. VoIP protocol stack RTP, RTCP, mixers and translators, RSVP. Bandwidth, Erlang models, link layer overhead. Hands on Calculating VoIP bandwidth, analysing RTP packets. ITU Recommendation H.323 Architecture, protocols, terminals, Call setup, Gatekeepers, gateway discovery, H.323 registration with a gatekeeper. Hands on PC to PC using H.323. IETF - Session Initiation Protocol What is SIP? SIP protocol stack, SDP, Sip architecture, SIP messages, Initial SIP phone startup, SIP servers, proxy server, redirect server. Hands on PC to PC using SIP. Carrier networks Signalling systems, SS7, media gateways, Media gateway controllers, signalling gateways, MGCP, Megaco, SIGTRAN. Hands on PSTN interworking. Video over IP Video components, digital video, pictures and audio, video codecs, issues and solutions, video conferencing, multipoint video conferencing, video protocol stack. Appendix 1: Multicasting. Appendix 2: Voice/data integration without IP.

Definitive Ethernet switching course description A hands on comprehensive look at Ethernet switches with extensive coverage of VLANs. The course focuses on the technology and not any one manufacturers product enabling delegates to configure switches from any manufacturer. What will you learn Configure and troubleshoot switches using: Console port telnet HTTP TFTP Configure and troubleshoot switch features such as: Duplex/speed Port based MAC security Spanning Tree Link aggregation Tagged ports Configure and troubleshoot VLANs. Definitive Ethernet switching course details Who will benefit: Technical staff. Prerequisites: Intro to data communications & networking. Duration 3 days Definitive Ethernet switching course contents What is Ethernet? LANs, network cards and cables, CSMA/CD, Ethernet frames, Ethernet evolution, 802.3. Hands on: ping, Ethernet speeds, CSMA/CD. Ethernet layer 2 Layer 2 functions, NICs, MAC addresses, unicasts, multicasts and broadcasts, frame formats. Hands on: Configuring NICs, Analysing MAC addresses with Wireshark IP and Ethernet Relationship Hands on: ARP. What is a switch? Switches connect multiple devices, switches versus hubs, simultaneous conversations, switches work at layer 2, the forwarding database, how the forwarding database is built, broadcast and collision domains Hands on: Difference between hubs and switches. Switch configuration Switch configuration Managed/unmanaged switches, configuration methods, reasons to configure switches. Console ports, HyperTerminal (and alternatives). Hands on: Using the console port to troubleshoot and configure switches. Switches in more detail Latency, forwarding mechanisms, switch fabrics. Hands on: Using telnet and HTTP to switches. Ethernet extensions Auto negotiation, Power over Ethernet. Hands on:Configuring and troubleshooting switch ports: Speed, duplex and security. Redundant links Loops, broadcast storms, STP, BPDU format, STP convergence. Hands on: Tracking blocked ports. STP convergence. Backbone links Architectures, link aggregation, LACP, load sharing, resilience. Hands on: fail over times. VLANs Virtual versus physical LANs, Why have VLANs? Broadcast domains, Creating VLANs, Assigning ports to VLANs. Hands on: Analysing the effect of VLANs on traffic. Enterprise VLANs VLANS are internal, multiple VLANs, Load balancing, Default VLAN, VLAN registration protocols: VTP, GVRP, MVRP. Hands on: VLANs on multiple switches. Tagging/Trunking Reason for tagging, terminology, tagging process, 802.1Q, Tag format, VLAN stacking. Hands on: Configuring and troubleshooting tags. STP variants RSTP, Common STP, Multiple STP, PVST, ring alternatives. Hands on: RSTP. Inter VLANs Layer 3 switching, IP addressing rules, Interconnecting VLANs. Hands on: Routing between VLANs. Troubleshooting Ethernet Methods, tools, locating faults, layer 1 issues, layer 2 issues Hands on: Fixing the network.

About this Training Course Materials Management is an essential link in the Supply Chain process. It takes an even bigger significance in the Upstream industry when the cost of a rupture in equipment or stock can be tremendous, without even considering the cost of the equipment itself. The downside may result in the accumulation of out-of-commission materials which leads to business inefficiency. What does it take to maintain efficient Materials Management? This 3 full-day course will explain more in detail. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives At the end of this course, participants will be able to: Understand the importance of an efficient Materials Management in the Supply Chain process Examine the control and validation of Stock processes Understand the role of the Duet and work within the Stock Duet in materials management Learn about the key factors in Stock optimisation Target Audience This course will benefit all personnel involved in Supply Chain including Stock Controllers, Cost Controllers, Buyers, Logisticians and those from the technical department such as Technical Administrators and members of the duet. Course Level Basic or Foundation Trainer Your expert course leader has 25 years of experience in management positions in Contracting, Procurement and Logistics, mainly in the Oil & Gas Industry. He was a Lecturer for IFP Training for 5 years. During his Oil & Gas industry experience, he has worked on major Oil and Gas development projects like the Yadana project in Myanmar, Akpo project in Nigeria and YLNG in Yemen. His international experience allows him to adapt very easily and integrate the multicultural specificities of the Oil & Gas industry in his teaching. 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