5585 Computing & IT courses in Hawick delivered Online

This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP). Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job! What Will I Learn? Prepare your environment Introducing Database Program Units Creating and Maintaining Stored Procedures & Functions Creating and Maintaining Packages Advanced Cursor Techniques Using System-Supplied Packages Creating and Maintaining Database Triggers Implementing System Event Triggers Requirements Familiarity with database and programming principles Who is the target audience? Application designers and developers Database administrators Business users and non-technical senior end users Introduction Introduction 00:03:00 Install Oracle XE 00:11:00 SQL Developer Installation 00:00:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Course Certification

Course on all the Essentials of Microsoft Office Looking to learn everything there is about all the Microsoft Office programs? This course will give you exactly what you are looking for. Learn all there is about Microsoft Word, Excel, Outlook, PowerPoint, OneNote, Access, Publisher, Project, InfoPath, SharePoint Designer and Visio. Certified Microsoft Office Essentials introduces a new graphical interface user called the Fluent User Interface, which uses ribbons and an Office menu instead of menu bars and toolbars. Office also introduced Office Open XML file formats as the default file formats in Excel, PowerPoint, and Word. Office also introduces a feature called 'Live Preview', which temporarily applies formatting on the focused text or object, when any formatting button is moused-over. This Course is designed to make you learn everything about all the Microsoft Office tools of and all of its new features. Learning all the office softwares increases your credibility in today's competitive job market. So what are you waiting for? This is the course for you. Course Highlights Certified Microsoft Office Essentials is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft Office Essentials into 77 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 2 days, 19 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft Office Essentials Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft Office Essentials is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Microsoft Office Essentials is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities- Microsoft Word for Beginners Accredited Course 00:00:00 Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Certified Microsoft PowerPoint for Beginners - Activities 00:00:00 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access FREE 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access for Beginners CPD Accredited 00:00:00 Microsoft Outlook Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Outlook FREE 01:00:00 Module Three - Understanding the Interface 01:00:00 Module Four - Working with the Message List and the Reading Pane 01:00:00 Module Five - Using Message List Commands 01:00:00 Module Six - Creating a New Email 01:00:00 Module Seven - Managing Email 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Accredited Microsoft Outlook for Beginners 00:00:00 Microsoft Publisher Module One - Getting Started 00:30:00 Module Two - Opening Publisher 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Publication 01:00:00 Module Five - Working with Pictures 01:00:00 Module Six - Basic Editing Tasks 01:00:00 Module Seven - Formatting Fonts 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Objects 01:00:00 Module Ten - Working with Pages 01:00:00 Module Eleven - Publishing Your Work 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Certified Microsoft Office Essentials 00:30:00 Final Exam Final Exam- Certified Microsoft Office Essentials 00:30:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Javascript for Data Structures: Dive into the world of data structures using JavaScript. Learn to implement arrays, linked lists, stacks, queues, trees, and more. Perfect for aspiring developers.

Excel in IGCSE Mathematics with our CPD Accredited course. Develop problem-solving skills, learn key concepts, and gain exam preparation strategies.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

In a world where every click leaves a trace, digital forensic science has become the modern detective's magnifying glass. From deleted texts to encrypted drives, the truth rarely hides for long when science meets cyber investigation. This course takes you into the fascinating world of digital trails, revealing how data is tracked, analysed and used in investigations across law enforcement, business, and cybersecurity sectors. You'll explore how evidence is gathered from devices, how experts think like digital sleuths, and what methods are used to maintain integrity throughout. Whether you’re interested in solving cybercrimes, working with legal investigations, or simply curious about what really happens behind the scenes of a digital breach, this course gives you the core knowledge needed to understand how today’s digital world can be decoded. It’s sharp, informative, and doesn’t involve lab coats or spy gadgets—just pure digital know-how. The demand for digital forensic analysts has risen by over 21% in the last five years in the UK alone, and with cyber threats only growing, it’s not slowing down anytime soon. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 1: Introduction to Digital Forensics Module 2: Digital Forensic Investigation Module 3: Evidence Management Module 4: Apprehending Offenders Module 5: Maintain Evidence-Based Reporting Module 6: File System Analysis Part-1 Module 7: File System Analysis Part-2 Module 8: Network Forensics Module 9: Memory Forensics Module 10: Digital Evidence in the Courtroom Learning Outcomes: Conduct effective digital investigations using specialised techniques. Manage and preserve digital evidence with meticulous attention to detail. Apprehend offenders by applying advanced investigative strategies. Create evidence-based reports to support legal proceedings. Analyse file systems comprehensively, uncovering hidden information. Utilise network and memory forensics to extract valuable insights. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? IT professionals looking to specialise in digital forensics. Law enforcement personnel aiming to enhance their investigative skills. Cybersecurity enthusiasts interested in digital crime-solving. Legal professionals seeking expertise in digital evidence. Computer science graduates aspiring to work in forensics. Private investigators wanting to expand their skill set. Individuals with a passion for technology and investigation. Anyone intrigued by the intersection of cybercrime and forensic science. Career path Digital Forensic Analyst Cybersecurity Investigator Incident Responder Forensic IT Specialist Cybercrime Investigator Computer Forensic Examiner Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

When information flows freely across emails, servers and shared drives, who’s keeping an eye on what goes where? The Information Governance Training Course gives you a solid grasp of how information should be handled, stored, and shared responsibly—without overloading you with jargon or abstract concepts. It covers the rules and good habits that help prevent data breaches, mishandling of documents, and those accidental “reply-alls” that could land you in trouble. Whether you're working in healthcare, education, finance, or the local bakery with a very organised spreadsheet, understanding information governance is no longer optional. This course walks you through data protection, record management, information security and your legal duties, all with a touch of clarity (and a pinch of dry humour where appropriate). If you've ever wondered what happens when data goes wandering, this is the place to get your answers—before it’s your inbox in the headlines. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Lesson 1: Introduction to Information Governance Lesson 2: Data Protection and Privacy Lesson 3: Records Management Lesson 4: Information Security Lesson 5: Cybersecurity Lesson 6: Privacy, Confidentiality and Freedom of Information Lesson 7: Data Governance Lesson 8: Information Risk Management Lesson 9: Information Ethics Lesson 10: Compliance and Auditing Lesson 11: Information Governance in Practice Learning Outcomes: Gain an in-depth understanding of Information Governance. Master data protection and privacy regulations. Learn effective records management practices. Enhance information security and cybersecurity knowledge. Understand the principles of data governance. Apply ethical standards to information management. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Data protection officers and compliance professionals. Records managers and archivists. IT and security professionals seeking to expand their knowledge. Legal professionals involved in data compliance. Managers responsible for data handling and security. Compliance auditors and risk managers. Anyone looking to ensure data integrity and compliance. Individuals interested in a career in Information Governance. Career path Data Protection Officer Records Manager Information Security Analyst Compliance Officer Risk Management Specialist Privacy Officer Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

From local businesses to international consulting opportunities, security management has become one of the fastest growing fields. Safety and security managers are responsible for establishing and enforcing security policies and procedures as well as managing and coordinating the activities to create a safe and secure environment for clients and employees. The Security Management Diploma course provides you with the necessary knowledge on the various aspects of security, implementing security policies, regulations, rules, and norms to counter crime. A variety of topics are covered in this course, including executive protection and recovery, trade secret protection, background investigations and analysis, incident recording, surveillance, IT security and cyber-security. By the time you complete this course, you will be able to analyse and implement effective security countermeasures and procedures to safeguard proprietary information, trade secrets, organisational human resources and leaders. Who is this Course for? Security Management Diploma is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Security Management Diploma Module 01: Introduction to Security Management 00:30:00 Module 02: Organisational Security Management 00:26:00 Module 03: Security Risk Analysis and Risk Reduction 00:23:00 Module 04: Physical and Information Security Protection 00:32:00 Module 05: Business Resilience and Crisis Management 00:17:00 Module 06: Cyber Security and Fraud Prevention 00:25:00 Module 07: Security Investigations and Threat Awareness 00:24:00 Module 08: Laws and Regulations 00:25:00 Mock Exam Mock Exam - Security Management Diploma 00:20:00 Final Exam Final Exam - Security Management Diploma 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00