2398 Courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL *Plus Setup JDeveloper About BIND and Substitution Variables Using SQL Developer Using SQL *Plus Choosing a Database Programming Language What is Database Programming PL/SQL Programming PL/SQL Performance Advantages Integration with Other Languages PL/SQL Language Essentials PL/SQL Program Structure Language Syntax Rules Embedding SQL Writing Readable Code Generating Readable Code Generating Database Output SQL * Plus Input of Program Block DECLARE Section About the Declare Section Declare Primitive Types Declaration Options Not Null Constant Data Dictionary Integration % Type Declare Simple User-Defined Types Type ? Table Type ? Record Extended User Defined Types BEGIN Section About the Begin Section Manipulating Program Data Logic Control & Braching GOTO LOOP IF-THEN-ELSE CASE EXCEPTION Section About the Exception Section Isolating the Specific Exception Pragma Exception_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT & Select ? Into Beyond the Basics : Explicit Cursors About Explicit Cursors Extend Cursor Techniques For Update of Clause Where Current of Clause Using for ? Loop Cursors Introduction Database Resident Programming Units About Database ? Resident Programs Physical Storage & Execution Types of Stored Program Units Stored Program Unit Advantages Modular Design Principles Creating Stored Procedures and Functions Stored Procedures & Functions Create Procedure / Create Function Creating Procedures & Functions Raise_Salary() Procedure Salary_Valid() function The Parameter Specification Default Clause System & Object Privileges Using the Development Tools Executing Stored Procedures and Functions Calling Procedures & Functions Unit Testing with Execute Anonymous Block Unit Testing Specifying a Parameter Notation SQL Worksheet Unit Testing Calling Functions from SQL Maintaining Stored Programming Units Recompiling Programs Mass Recompilation Using UTL_RECOMP() Dropping Procedures & Functions Drop Procedures & Functions Drop Procedure / Function Data Dictionary Metadata Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies Dependency Internals Tracking Dependencies The Dependency Tracking Utility SQL Developer Dependency Info Dependency Strategy Checklists Creating & Maintaining About Packages Creating Packages Maintaining Packages Performance Considerations Advanced Package Capabilities Definer & Invoker Rights White Lists & Accessible By Persistent Global Objects Defining Initilization Logic Object Orientation Support Advanced Cursor Techniques Using Cursor Variables Using SYS_REFCURSOR Using Cursor Expressions Using System Supplied Packages DBMS_OUTPUT() UTL_FILE() FOPEN() Example Database Trigger Concepts About Database Triggers DML Event Trigger Sub-Types Database Trigger Scenario Trigger Exhaustion Mechanisms Trigger within SQL Worksheet Creating Database Triggers Statement Level Triggers Using Raise Application_Error() Row-Level Triggers Examples of Triggers Employee_Salary_Check Example Employee_Journal Example Budget_Event Example Instead of Triggers Triggers within and Application Maintaining Database Triggers Call Syntax Trigger Maintenance Tasks Show Errors Trigger Drop Trigger Alter Trigger Multiple Triggers for a Table Handling Mutating Table Issues Implementing System Event Triggers What are System Event Triggers Defining the Scope Available System Events System Event Attributes

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Health and Safety in Construction 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 40 course mega bundle that will exceed your expectations within your budget. The Health and Safety in Construction 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 Health and Safety in Construction bundle will help you build a solid foundation to become a proficient worker in the sector. This Health and Safety in Construction Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Construction Management - Level 5 Diploma Course 02 :Construction Site Planning and Managment Course 03 :Construction Cost Estimation Diploma Course 04 :Construction Safety Diploma Course 05 :Construction Industry Scheme (CIS) Course 06 :Quantity Surveyor Training Course 07 :Building Surveyor Course 08 :Land Surveying Course 09 :Property Management Training Course 10 :Property Development Diploma Course 11 :Property Law Course 12 :Property Business Training - Level 5 Course 13 :Residential Property Sales Course 14 :Public Housing Management Course 15 :WELL Building Standard Course 16 :Building Design And Construction With LEED V4.1 Course 17 :AutoCAD VBA Programming for Beginners Course 18 :AutoCAD Programming using C# with Windows Forms Course 19 :Cost Control and Management Training Course 20 :Positive Workplace Environment Course 21 :Effective Communication Skills for Technical People Course 22 :Leadership Styles Course 23 :Workplace First Aid Level 3 Course 24 :Workplace Management Training Course 25: COSHH Training for Assessors Course 26: LOLER Training Level 2 Course 27: RIDDOR Training Course 28: Working at Height Course 29: Lone Worker Safety Diploma Course 30: Ladder Safety Training 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made Health and Safety in Construction 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 Health and Safety in Construction 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 400 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 Health and Safety in Construction bundle! This bundle is also ideal for professionals looking for career advancement. Note: This is not a regulated course. To get a professional qualification, you may like to choose: Health and Safety Management for Construction (UK) Level 3 Certificate in Occupational Health and Safety NEBOSH National Diploma in Occupational Health and Safety NEBOSH National General Certificate in Occupational Health & Safety NEBOSH, International General Certificate in Occupational Health & Safety Level 6 Diploma - Occupational Health and Safety Management Courses from the Institution of Occupational Safety and Health ProQual Level 5 NVQ Diploma in Occupational Health and Safety Practice ProQual Level 6 NVQ Diploma in Occupational Health and Safety Practice ISO 45001 Occupational Health and Safety National Examination Board in Occupational Safety and Health Level 3 NVQ Health and Safety Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Health and Safety in Construction 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.

Why should I learn unit testing? Why spend extra time writing code to test? Is manual testing not sufficient? Well, if you have these questions, then you are on the right course. Unit testing is a very valuable skill in the current development cycle. The purpose is to validate that each unit of the software code performs as expected. So, let's dive into it!

Self-motivation lets you take control of your own life. Live a life full of motivation,stay positive. Learn 'Goals & What is Motivation?', 'The SOURCE of All Motivation'.

Earn up to 90k as a 'Network Engineer' or Your 100% Money Back Network outages cost UK businesses £100 billion annually. With over 50,000 open network engineer jobs paying £54,000 per year on average, skilled professionals are in high demand. Do you have what it takes to design, build, and protect company infrastructure? This Network Engineer Job Guarantee Programme is your all-in-one solution to learn networking skills from scratch and also secure a job in this exciting industry. With our unique blend of comprehensive courses and career support, your dream job is within reach. We understand the challenges of transitioning into a new field, which is why our program is tailored to guide you every step of the way - from mastering core skills to landing your first job as a Network Engineer. By choosing our Network Engineer Job Guarantee Programme, you're not just gaining skills; you're gaining a lifelong career partner. Our mission is simple - to be your trusted partner every step of the way, from training to employment. In addition to teaching you the technical skills you need, we will also provide you with career mentoring and support. We will help you build your resume, prepare for interviews, and land your dream job. We also have partnerships with many companies that are hiring Programmers, so we can help you get your foot in the door. If you are not happy with our service, we also offer a 100% money-back guarantee. So what are you waiting for? Enrol in our Network Engineer Job Guarantee Programme today and start your journey to becoming a successful Network Engineer! Why Choose Us? So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our Certified Network Engineer Programme: Personalised Guidance: We believe in the power of individual attention. Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some Network Engineering experience, we will guide you towards honing your skills and developing a strong foundation in Network Engineering. One-On-One Consultation: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Network Engineering field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking Certified Network Engineers. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. Interview Preparation: No more stress over unexpected interview questions. We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. Courses we will provide once you enrol in the program: Course 01: Network Security Level 2 Course 02: IGCSE ICT: Network Essentials Course 03: Computer Networks Security Course 04: CompTIA Networking Course 05: AWS Certified Cloud Practitioner Course 06: IT Support Technician Course 07: CompTIA A+ (220-1001) Course 08: CompTIA Network (N10-007) Course 09: CompTIA A+ (220-1002) Course 10: CompTIA IT Fundamentals ITF+ (FCO-U61) Course 11: CompTIA PenTest+ (Ethical Hacking) Course 12: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 13: Cisco ASA Firewall Training Course 14: CompTIA Network+ Certification Course 15: Penetration Testing with OWASP ZAP: Mastery course Course 16: GDPR Data Protection Course 17: Data Center Training Essentials: Mechanical & Cooling Course 18: Cyber Security Awareness Training How Can We Offer Job Guarantees? HF Online provides consultancy, professional and educational services to many of the companies in the UK. During our intense exclusive training program, you will not just gain and complete the industry valuable certification but will gain industry experience as well, which is imperative to get your 1st job in the sector. The is completed in 9 easy steps: Step 1: Enrol in the Programme Begin your exciting journey with us by enrolling in the Network Engineer Job Guarantee Programme. Complete your registration and make a secure online payment. Remember, we offer a 14-day money-back guarantee if you're not completely satisfied. After you enrol in the Program, you will get lifetime access to 18 Premium Courses related to Network Engineering. These courses will teach you the knowledge and skills required to become a successful Network Engineer. Our customer service team will help you and keep in contact with you every step of the way. So you won't have to worry about anything! Step 2: Initial One-On-One Counselling Session Once enrolled, you will be paired with a dedicated career mentor. Schedule your first one-on-one session to discuss your career aspirations, skills, experience, and any areas for potential growth. This conversation will shape your learning and development path. Step 3 - Certification upon Course Completion After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 4: CV Revamping Our team of professionals will build you a compelling CV and LinkedIn profile. We'll ensure it presents your skills and qualifications effectively and is tailored to the needs and expectations of the programming/development industry. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Step 5: Building Network and Submitting CV We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. We will also make connections with many high-profile individuals and companies through your LinkedIn profile. Step 6: Interview Preparation With your CV ready, we'll move on to interview preparation. Gain exclusive access to our database of potential interview questions. Through simulated interviews with your mentor, you'll practice your responses and receive valuable feedback to further refine your skills. Step 7: Securing Job Interviews Leveraging our partnerships with leading companies, we'll secure job interviews for you. We'll ensure you get the opportunity to showcase your skills to potential employers and get the dream job you want. Step 8: Post-Interview Support Post-interview, we'll provide a debriefing session to reflect on your performance and identify areas of improvement for future interviews if necessary. Remember, our commitment extends until you land your dream job. Step 9: Celebrate Your New Job! Once you've secured your dream job in Network Engineering, it's time to celebrate! However, our support doesn't end there. We'll provide you with ongoing career advice to ensure you continue to thrive in your new role. We're excited to accompany you on this journey to success. Enrol today, and let's get started! Your path to a successful career in Network Engineering begins with us. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Network Engineering Course is suitable for: Beginners with no prior programming experience who are looking to enter the world of coding. Intermediate programmers who wish to expand their skills and explore Network Engineering's extensive usage. IT professionals seeking to diversify their skill sets and stay relevant in today's tech-driven market. Data analysts and scientists who want to leverage Network Engineering's powerful libraries for their data processing needs. Students and recent graduates looking to enhance their employability in the thriving tech industry. Entrepreneurs who wish to understand and utilise Network Engineering to automate tasks and analyse data for their businesses. Anyone with a keen interest in Network Engineering and a desire to delve into its applications in diverse fields like web development, data science, machine learning, and more. Requirements No experience required. Just enrol & start learning. Career path Network Engineer: £30,000 - £70,000 annually Network Security Analyst: £35,000 - £85,000 annually Cloud Solutions Architect: £40,000 - £100,000 annually IT Support Specialist: £25,000 - £55,000 annually Cyber Security Consultant: £40,000 - £90,000 annually Systems Administrator: £30,000 - £75,000 annually Penetration Tester: £35,000 - £95,000 annually Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Framed (Hardcopy) Certificate Hard copy certificate - Included Enrolment Letter Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included Student ID Card Digital certificate - Included

This course will help you to gain a mastery level understanding of the fundamentals of Android Studio, Android app development, and the Kotlin programming language by building six full-fledged applications as well as many more 'learning' applications throughout the course.

Duration 4.375 Days 26.25 CPD hours This course is intended for The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are: Application designers and database developers Database administrators Web server administrators Overview This eTextbook begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language. The final section goes beyond the basics and begins to explore advanced topics that will be useful later in the Sideris Oracle PL/SQL developer textbook series. One learns techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.

About this training course The smart meter or smart grid represents the next-generation electrical power system. This system uses information, data & communication technology within generation, delivery and consumption of electric energy. This 4-day course will equip you with the innovations that are shaping the power generation and distribution systems and will cover topics ranging from Smart Metering Architecture, Cybersecurity, Smart Grid Systems and Power Line Communications. Training Objectives By participating in this course, you will be able to: Comprehend the Smart Grid and Smart Meters architecture Review latest trends and challenges within the Smart Grid Technology Perform analysis on smart electronic meters Comply with regulatory and metering standards Recognize the importance of cybersecurity in smart grids Maximize efficiency, reliability, and longevity of your smart meters and equipment Gain valuable insights into power quality and harmonics Target Audience This course will greatly benefit the following groups but not limited to: Smart Grid managers and engineers Smart Meters managers and engineers Power plant managers Outage managers Maintenance and operations engineers Power regulatory personnel Transmission managers and engineers Distribution managers and engineers IT managers Renewable energy managers and engineers Course Level Basic or Foundation Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 4 days in total (28 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. This course is also available through our Virtual Instructor Led Training (VILT) format. Trainer Your expert course leader is a professional engineer with extensive experience in power system studies, substation design field-testing, and EHS programs settings for Mining and Electrical Utilities sectors. He was formally the Engineering Manager at GE Canada in Ontario. He received his M.Sc. in electrical engineering from the University of New Brunswick and his MBA from Laurier School of Business in Waterloo. He has managed and executed more than 150 engineering projects on substation design EMF audits and power system studies and analyses, EMF audits and grounding audits, for major electrical utilities, mines, oil and gas, data centers, industrial and commercial facilities in Canada and the U.S. He is a certified professional engineer in the provinces of Ontario and Alberta. He has various IEEE publications, has served as a technical reviewer for many IEEE journals in power systems and control systems, and is the chair of the Industry Application Chapter (IAS) for IEEE Toronto Section. He remains a very active member for the IEEE substation committee of IEEE Std. 81 ground testing (WGE6) and IEEE Std. 80 ground design (WGD7). A certified electrical safety trainer by GE Corporate and a Canadian Standard Association (CSA) committee member at the mining advisory panel for electrical safety, he also taught many technical courses all over Canada to industrial customers, electrical consultants as well as to electrical utilities customers. Highlighted Projects: Various Power System Studies for 345/230 kV Stations - Nova Scotia Power (EMERA) RF audits for Telecom tower and antennas - Cogeco/Rogers Mobile Power System analysis - Powell Canada Structural/Geotechnical Design and upgrades - Oakville Hydro Underground Cables testing and sizing - Plan Group Relay programming and design optimization - Cenovus Canada Different Arc Flash Analysis and BESS Design - SNC Lavalin Environmental site assessment (ESA) Phase I/II for multiple stations - Ontario Electromagnetic compatibility (EMC) assessment for Toronto LRT expansion - MOSAIC Battery energy storage system (BESS) installation at City of London - Siemens Canada EMF audits for 500 kV Transmission Lines - Hydro One EMF audits for 500 kV Transmission Lines - Hydro Quebec AC interference for 138 kV line modeling and mitigations - HBMS Mine 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

Microsoft Word Certification Level 3 Kindly Note: This course utilizes the Windows form of Microsoft Office 2016. Some other forms will have a few contrasts in the capacities. The Microsoft (MS) Word Certificate Level 3 course is intended for those of your representatives who wish to figure out how to function with Microsoft Word programming. Everybody in a business climate should be skillful in word handling programming, and MS Word is the most generally utilized of these product applications. Microsoft Word can be utilized for both business and individual use. The course covers a total outline of the highlights inside MS Word, and the colleague will dominate the abilities important to make, alter and print their own Word archives. Upon effective fulfillment of each of the 53 modules and the death of a different decision assessment, a course authentication is granted. The completely approved declaration can be advantageously downloaded or - for a little expense - it tends to be presented on the colleague. What's Covered in the Course? The accompanying word handling abilities are canvassed in this course: The most effective method to enter and erase text in a record; Parting and joining text; Capacities in Word; Discover and supplant text; Spell check, thesaurus and word tally; Instructions to design your archive; Making and altering boundaries and tables; Making a programmed chapter by chapter list; Embeddings pictures, shapes and Clipart; Printing highlights; Making and altering headers and footers; Configuration highlights in Word; Embeddings recordings; Embeddings commentaries and endnotes; Utilizing mail combine; Sending E-mail in Word; Instructions to add and alter hyperlinks; Fast access toolbar. What are the Benefits of the Course? This capability improves the worker's worth to the association, independent of their part, because of their capacity to plan proficient archives and reports; The course is available online 24 hours every day, 7 days per week, which makes it ideal for the individuals who work all day yet wish to redesign their abilities and capabilities; The accommodation of concentrating anyplace, whenever, on any gadget (PC, PC, tablet or cell phone), gave the student has a web association; Learning at a speed that is agreeable for the student - there is no time limit by which to finish the course; Short, sharp measured construction to the program, which makes learning simple and fun; Available online help all through the course; A thorough schedule, covering immeasurably significant word handling abilities.

Unlock the power of AI with our ChatGPT Tutorial for Beginners. Learn to craft prompts, create content, and enhance your skills with AI text generation.