59939 Courses

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.

Discover how to effectively reduce gas flaring and monetize resources with EnergyEdge's specialized course. Enroll now!

Unlock the potential of cross-border electricity trading in Southeast Asia with EnergyEdge. Explore our comprehensive training program for industry professionals.

Learn how to get more done and become a master of time management Do you want to be a good communicator? Become a master of time management Learn the latest time organization techniques, how to plan your calendar, manage your team and delegate tasks. Learn from the best The course is taught by a time management expert that will reveal effective methods and techniques based on his years of experience. Test your knowledge In the course, you will find tests and practical tasks to consolidate your knowledge and skills. Do you try to manage your time, but still struggle to get anything done? If yes, then it’s time to take matters into your own hands and learn how to manage your time. Being able to manage your time wisely is crucial for anyone who wants to keep their life under control, no matter whether you run your own business or work for a company. We carefully designed this course in time management to answer all your needs. During the course, you will learn not only the most important theoretical issues of time planning methods, but above all, you will gain new practical skills on how to plan, organize your work time, rest time, and manage your calendar. We have prepared for you a series of repetition materials, practical tasks, tests, and necessary tools needed for skillful planning and increasing efficiency. If you are interested in increasing personal effectiveness, managing yourself and others, you are in the right place. We’ll introduce you to the best time management techniques and teach you planning and organizational skills for your career and life. Note: the training is designed for those with previous experience in time management, but also for those with no experience in the field. On the top of everything, at the end of the course, you will receive a certificate, which you can proudly display in your office or room, as well as boast about your experience in your CV. Join the communication course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Robert Sotelo Time Management Expert The time management course will be delivered by a time management expert, the best one in the field, with many years of experience. The trainer will share all the knowledge and experience with you and will teach you the most important theoretical issues of time planning methods. They will also teach you how to plan and organize your work time and your free time. At the end of the course, you’ll be a master of effectively managing your time; you’ll be the one who controls time. You’ll learn how to manage your schedule and how to arrange your weekly, monthly and yearly calendar. Your expert trainer will assist you and guide you through several knowledge repetitions, practical tasks and tests to make sure you remember all the important information and to consolidate your knowledge even better. Overview of the course: I. Video presentations Effective time managementOutline the most important aspects of controlling your time and calendar. Theoretical introduction and beyond. Personal effectiveness, managing yourself and others over timeSome tips on how to get the most efficiency. Tips related to human resource management. Time organization apps – essential toolsA presentation of the best apps to keep your calendar well organized. Time management methodsDiscuss the most important methods of managing time, your own and others. Use of specific techniques in theory and practice. Organizing your own workWork organizational systems in a professional context. How to handle pair duties well? II. Training videos Tools to support effective time managementA set of tools, apps and traditional forms of time organization. Guide how to use them properly. Making a task list and setting prioritiesExercises to consolidate the acquired theoretical knowledge. The 4-step method and its application in practiceDiscuss the 4-step method and the tasks involved in using it. Goal setting and implementationHow to set your goals and, with the help of a calendar, make them happen? Practical tasks and exercises to help manage time and combine it with goal setting Expert CalendarHow to arrange your calendar wisely? Expectations vs. reality. The most common time planning mistakes. III. Tests Tests and repetitions of acquired knowledgeAt the end of each section, you will receive a summary and a short test to make sure you remember all the important information. Final testAt the end of the course, you will have a final test, after which you will get your certificate. IV. Tasks Tasks and practical exercisesPractical tasks will allow you to consolidate your knowledge even better, e.g. adjusting time management techniques depending on the situation or developing a plan and calendar based on a case study. V. Bonus materials for the course Additional materials for daily work You will receive a collection of time management applications, a set of techniques for increasing efficiency or an example of time management training games, and more. A letter from your expert instructor: Are you overwhelmed by the amount of responsibilities? Are you still short on time? Do you feel time is slipping through your fingers? Are you constantly on the run? Do you have a lot of time, but you don’t know how to use it? Would you like to use every moment of the day effectively?Good news for you: We offer you an effective solution to all your time management problems. We are pleased to invite you to our time management course, carefully designed to teach you how to manage your time. You will gain new practical skills on how to plan and organize your work time, get more free time and manage your calendar.Through the course, you will go through tests and repetitions to make sure you remember all the important information. You will also complete tasks and practical exercises that will allow you to better consolidate your gained knowledge.After successfully completing the course, you will receive a certificate that will serve as a proof of your newly developed skills.Learn how to manage and control your time and become a master of time management!Join us today!Faustine ParsonsCommunication expert

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.

Overview From cyberbullying to online grooming, the internet can be a deadly place for underage users. So, whether you are a parent or someone working with children, you must take steps to ensure internet safety for children. If you don't know where to start, our Internet Safety for Children Course is your solution. Here, you will be able to learn about the concepts of internet safety for children. The course will help you get a better understanding of cyberbullying and internet grooming. In addition, you will learn about the steps you can take for internet safety for children. Also, the course will introduce you to the tools and strategies for monitoring children's internet use. You will be able to ensure the safe use of social media and mobile devices for children.  This course can help you protect the little ones from the dark side of the internet. So join today and get a step closer to ensuring internet safety for children. Course Preview Learning Outcomes Understand the concepts of internet safety for children Learn about cyberbullying and Internet grooming Know what are the appropriate measures for safeguarding children Get introduced to the tools and techniques for monitoring children's internet use Grasp the strategies to identify and prevent children's internet addiction Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Ensuring Internet safety for children Establishing safety on mobile devices Who Should Take This Internet Safety for Children Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Internet Safety for Children Course Certification After completing and passing the Internet Safety for Children Course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Internet Safety for Children Course will equip you with effective skills and abilities and help you explore career paths such as  Teachers Child Care Workers School Counsellor Module 1: The Concept Of Internet Safety For The Children The Concept of Internet Safety for the Children 00:46:00 Module 2: The Concept Of Privacy And Appropriate Online Content The Concept of Privacy and Appropriate Online Content 00:33:00 Module 3: Cyberbullying Cyberbullying 00:39:00 Module 4: Internet Grooming Internet Grooming 00:41:00 Module 5: Appropriate Measures For Safeguarding Your Child Appropriate Measures for Safeguarding Your Child 00:26:00 Module 6: Safe Use Of Social Media Safe Use of Social Media 00:16:00 Module 7: Mobile Device Safety Mobile Device Safety 00:19:00 Module 8: Tools And Tips For Monitoring Child's Internet Use Tools and Tips for Monitoring Child_s Internet Use 00:18:00 Module 9: Identifying, Preventing And Overcoming Internet Addiction Identifying, Preventing and Overcoming Internet 00:19:00 Assignment Assignment - Safeguarding Children: Internet Safety Course 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course certifies the student for their renewal for their Maryland Handgun Permit. This course also certifies for Florida out of state (good in 37 states) and Delaware for Delaware residents. You can bring your own firearm or use one of our Glock 9mm firearms. You may also provide your own ammunition in any caliber if you are bringing your own firearm or if you are using our firearm you may pre-pay for the ammunition at $25.00 per box (you will need four boxes of 200 rounds). Choose the ammunition add on if you are not providing the ammunition.

Take The SIA Door Supervisor Course + First Aid, This Will Take You 6 Days To Complete. Enrol Now On To The Course! What Is SIA Door Supervisor Course? The SIA (Security Industry Authority) Door Supervisor Training is a comprehensive training program designed to prepare individuals for roles as door supervisors within the security industry in the United Kingdom. Door supervisors play a critical role in ensuring safety and security at licensed premises, including bars, clubs, and events. This SIA Door Supervisor Course + First Aid is 6 days, this is a compulsory course in order to attain the Door Supervisor Licence. Furthermore, this will allow you to work as a doorman, nightclub security, retail security, corporate security, construction security and many other security sectors. Enrol now or contact us for any further details.  Course Overview: 6 Days Course | 09:00 – 18:30 | Mon – Sat Every Week SIA Door Supervisor Course Road Map 1. Book Course Book your SIA Door Supervisor Training and First Aid Course in London (6 Days) 2. Attend Course Attend a 6-day course, and successfully pass all your SIA Door Supervisor exams.  3. Apply SIA Register for an account with SIA, and apply for your SIA Door Supervisor Licence. Course Information Why Choose SIA Door Supervisor Course? Expert Instructors Learn from seasoned professionals who bring real-world insights to the classroom. Our instructors are dedicated to your success, offering guidance and support throughout the training. Practical Training Gain hands-on experience in simulated security scenarios, preparing you for the challenges you’ll face in the field. Our practical sessions enhance your problem-solving skills and decision-making abilities SIA Compliance Stay ahead in the security industry by understanding and complying with SIA regulations. Our course covers the latest guidelines, ensuring you are well-versed in the legal and ethical aspects of security operations Job Placement Assistance We go beyond training by offering job placement assistance. Our network of industry connections helps you kickstart your security career with confidence. Ready To Begi Your SIA Journey? Your journey toward a rewarding and responsible career as a Door Supervisor starts here. Contact us today to enrol in our Door Supervisor Training at London Construction College, and take the first step towards an exciting and impactful career in security. Your future awaits! SIA Door Supervisor Course Content Unit 1 : Working In The Private Security Industry Legal Considerations in the Private Security Industry. Ensuring Health and Safety for Private Security Operatives . Awareness of Fire Safety. Procedures for Emergency Situations. Effective Communication Skills and Customer Care. Unit 2: Working As A Door Supervisor Adherence to Behavioral Standards. Understanding Civil and Criminal Law. Procedures for Search Operations. Protocols for Arrest Situations. Awareness of Drugs and Their Impact. Documentation of Incidents and Preservation of Crime Scenes. Compliance with Licensing Laws. Emergency Procedures. Unit 3: Conflict Management For The Private Security Industry Conflict Avoidance and Personal Risk Mitigation. De-escalation of Conflicts. Resolution and Lessons from Conflicts . Application of Communication and Conflict Management Skills for Door Supervisors. Unit 4: Physical Intervention Skills For The Private Security Industry Overview of Physical Intervention Skills. Essential Legislation Awareness . Fun Fact: The persuasive Communication and Conflict Management skills acquired in this course are applicable both professionally and personally in conflict situations. This standalone component alone holds a value exceeding the course price. SIA Door Supervisor Exam On the last day of the course, you’ll encounter four multiple-choice exams along with a practical assessment. We acknowledge that exams can be intimidating, but rest assured, there’s no cause for concern. The Door Supervisor course comprehensively covers all exam topics, and your skilled instructor will thoroughly equip you for success in these assessments. Embarking on an exciting career in the security industry as a Door Supervisor or Security Guard starts with the initial step of acquiring the right training. Throughout your Door Supervisor training, we guide you through the entire process, offering essential training and providing the necessary materials to assist you in obtaining your SIA Door Supervisor license. Document Checks Proof Of Identity You will need to provide documents that prove you are who you say you are. Address history You need to provide two proofs of address. Bank or building society statement issued within the last three months. Utility bill issued within the last three months. A credit card statement was sent to your current address within the last three months. Council Tax statement issued in the last 12 months. Mortgage statement issued in the last 12 months. Age You must be 18 or over to hold an SIA licence. Criminal record Please be aware, that even if you pass the SIA door supervisor, you will still need to pass SIA criminal record checks. If you live outside the UK, or you have spent 6 continuous months or more outside the UK in the last 5 years, you need to provide evidence of overseas criminal record checks to the SIA. SIA will only issue a licence after completing background checks.  Right to work in the UK You must have the right to work in the UK to get a front-line or non-front-line licence.  Important Things You Should Know FAQ SIA Door Supervisor Training What is the SIA Door Supervisor course, and why do I need it? The SIA Door Supervisor course is a training program designed for individuals seeking employment in the security industry, specifically in roles such as door supervision. The Security Industry Authority (SIA) requires this qualification for those working in designated roles to ensure a standard level of competence and professionalism. What does the SIA Door Supervisor Course cover? The SIA course covers a range of topics essential for door supervisors, including conflict management, physical intervention, emergency procedures, legal responsibilities, and customer service. It provides a comprehensive skill set needed to excel in the role. Can I take the course in London? Yes, the SIA Door Supervisor course is available in London.  How long does the course take to complete? The SIA Door Supervisor and First Aid is completed over 6 days of training. Is there an age requirement for taking the SIA Door Supervisor course? Yes, you must be at least 18 years old to take the SIA Door Supervisor course as it is a legal requirement for working in the security industry. What are the job prospects after completing the course? Successfully completing the SIA Door Supervisor course enhances your employability in the security industry. Door supervisors are in demand in various establishments, including nightclubs, bars, and events, and having the SIA qualification opens up job opportunities in these sectors. Do I need any prior experience in security to enrol in the course? No, prior experience in security is not a prerequisite for enrolling in the SIA Door Supervisor course. The course is designed to provide comprehensive training for individuals at various levels, including those new to the security industry. Can I take the SIA Door Supervisor course if I’m not a UK citizen? Yes, the SIA Door Supervisor course is open to individuals regardless of nationality. However, it’s essential to ensure that you meet the legal requirements for working in the UK, including visa regulations.

LTE Architecture and Protocols course description This course provides a comprehensive tour of the LTE architecture along with services provided and the protocols used. What will you learn Describe the overall architecture of LTE. Explain the information flows through LTE. Describe the LTE security. Describe LTE mobility management. Recognise the next steps for LTE. LTE Architecture and Protocols course details Who will benefit: Anyone working with LTE. Prerequisites: Mobile communications demystified Duration 3 days LTE Architecture and Protocols course contents Introduction History, LTE key features. The 4G ITU process. The LTE 3GPP specifications. Specifications. System Architecture LTE hardware architecture. UE architecture and capabilities. E-UTRAN and eNB. EPC, MME functions, SGW, PGW and PCRF. System interfaces and protocol stacks. Example information flows. Dedicated and default bearers. EMM, ECM, RRC state diagrams. Radio transmission and reception OFDMA, SC-FDMA, MIMO antennas. Air interface protocol stack. Logical, transport and physical channels. Frame and slot structure, the resource grid. Resource element mapping of the physical channels and signals. Cell acquisition, data transmission and random access. MAC, RLC, PDCP protocols. LTE spectrum allocation. Power-on procedures Network and cell selection. RRC connection establishment. Attach procedure, including IP address allocation and default bearer activation. LTE detach procedure. Security in LTE networks LTE security features, identity confidentiality, ciphering and integrity protection. Architecture of network access security in LTE. Secure key hierarchy. Authentication and key agreement procedure. Security mode command procedure. Network domain security architecture. Security associations using IKE and IPSec. Mobility management RRC_IDLE, RRC_CONNECTED. Cell reselection, tracking area updates. Measurement reporting. X2 and S1 based handovers. Interoperation with UMTS, GSM and non-3GPP technologies such as cdma2000. QoS, policy control and charging QoS in LTE, EPS bearers, service data flows and packet flows. The architecture and signalling procedures for policy and charging control. Data transport using GPRS, differentiated services and MPLS. Offline and online charging in LTE. Delivery of voice and text messages over LTE Difficulties and solutions for Voice over LTE. Architecture and call setup procedures for circuit switched fallback. Architecture, protocols and call setup procedures in IP multimedia subsystem. Enhancements in release 9 LTE location services. Multimedia broadcast / multicast service and MBSFN. Cell selection, commercial mobile alert service. LTE Advanced and release 10 Impact of carrier aggregation on LTE air interface. Enhanced MIMO processing on uplink and downlink. Relaying. Release 11 and beyond. OAM and self organising networks Operation, administration, maintenance and provisioning for LTE. Self-configuration of base station parameters. Fractional frequency re-use, inter-cell interference co-ordination. Self-optimisation of base station procedures. Self-healing to detect and recover from faults.