5651 Software courses delivered Online

Overview This comprehensive course on Youtube and Instagram Video Production with Editing Bootcamp will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Youtube and Instagram Video Production with Editing Bootcamp comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Youtube and Instagram Video Production with Editing Bootcamp. It is available to all students, of all academic backgrounds. Requirements Our Youtube and Instagram Video Production with Editing Bootcamp is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 20 lectures • 01:55:00 total length •Introduction: 00:16:00 •Preparation. How to Choose Your Topic: 00:06:00 •Creating Outline of Your Video: 00:09:00 •Choosing Shooting Environment: 00:07:00 •Complexity of Your Videos - How Not To Get Overwhelmed: 00:05:00 •Video Equipment - Camera, Tripod, Cards, Computer, Etc: 00:13:00 •Filming. Video Diaries & Shooting Exercises: 00:04:00 •Creating Screencasts: 00:02:00 •Camera Work - Different Setups: 00:06:00 •Your Filming Checklist - What You Shouldn't Forget: 00:03:00 •Filming in Parts: 00:03:00 •Plan B - What to Do If Everything Goes Wrong: 00:03:00 •4K vs 1080p - Pros and Cons: 00:03:00 •Importing, Storage & Backup: 00:10:00 •Editing Software: 00:06:00 •Editing Diary: 00:03:00 •Editing On the Go: 00:02:00 •Content Libraries - Where to Find Music, Images, Graphics: 00:07:00 •Render & Export: 00:07:00 •Assignment -Youtube and Instagram Video Production with Editing Bootcamp: 00:00:00

Sage 50 Payroll for Beginners Course Overview Mastering payroll is essential for any business operation, and Sage 50 Payroll is one of the UK’s most widely used systems for managing employee payments, tax, pensions, and more. This beginner-level course is designed to introduce you to the complete payroll process using Sage 50, from setting up company details to running year-end reports. Whether you’re looking to work in payroll, start a role in HR or finance, or simply want to enhance your accounting knowledge, this course provides step-by-step training to help you build a solid foundation. You’ll start by exploring payroll basics and navigating company and legislation settings. Then, you’ll dive into practical tasks such as adding employees, entering payments, generating reports, and handling submissions. You’ll also gain insights into essential year-end procedures and how to process final payments correctly, giving you confidence in real-world scenarios. No prior payroll experience is required, making this course ideal for aspiring payroll administrators or small business owners looking to manage staff payments in-house. With flexible online learning and practical modules, this course ensures that you can develop your Sage 50 skills at your own pace — ready to take on payroll duties with efficiency and accuracy. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand the fundamentals of Sage 50 Payroll software Learn how to set up company and legislation settings correctly Gain the skills to add new and existing employees to the payroll system Process payrolls and update employee records efficiently Handle statutory payments and employee departures with confidence Master e-submissions and produce accurate reports and year-end summaries Who is this Sage 50 Payroll for Beginners Course for? This Sage 50 Payroll for Beginners course is ideal for aspiring payroll administrators and HR assistants who want to develop practical skills in managing payroll processes. It’s also perfectly suited for small business owners looking to handle their company’s payroll operations in-house. In addition, accountancy or finance students aiming to enhance their career prospects will benefit greatly from this course. Whether you're starting from scratch or looking to refresh your knowledge, this course provides the foundation you need to confidently use Sage 50 Payroll. Entry Requirements There are no formal prerequisites for this course. It is open to anyone interested in learning payroll using Sage 50, regardless of previous experience. A basic understanding of computer use is helpful, but not essential. All you need is a stable internet connection and a desire to learn! Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

Aligned with the AIGP certification program, AI Governance Professional Training is for professionals tasked with implementing AI governance and risk management in their organizations. It provides baseline knowledge and strategies for responding to complex risks associated with the evolving AI landscape. This training meets the rapidly growing need for professionals who can develop, integrate and deploy trustworthy AI systems in line with emerging laws and policies. About This Course This training teaches critical artificial intelligence governance concepts that are also integral to the AIGP certification exam. While not purely a 'test prep' course, this training is appropriate for professionals who plan to certify, as well as for those who want to deepen their AI governance knowledge. Both the training and the exam are based on the same body of knowledge.   Module 1: Foundations of artificial intelligence Defines AI and machine learning, presents an overview of the different types of AI systems and their use cases, and positions AI models in the broader socio-cultural context. Module 2: AI impacts on people and responsible AI principles Outlines the core risks and harms posed by AI systems, the characteristics of trustworthy AI systems, and the principles essential to responsible and ethical AI. Module 3: AI development life cycle Describes the AI development life cycle and the broad context in which AI risks are managed. Module 4: Implementing responsible AI governance and risk management Explains how major AI stakeholders collaborate in a layered approach to manage AI risks while acknowledging AI systems' potential societal benefits. Module 5: Implementing AI projects and systems Outlines mapping, planning and scoping AI projects, testing and validating AI systems during development, and managing and monitoring AI systems after deployment. Module 6: Current laws that apply to AI systems Surveys the existing laws that govern the use of AI, outlines key GDPR intersections, and provides awareness of liability reform. Module 7: Existing and emerging AI laws and standards Describes global AI-specific laws and the major frameworks and standards that exemplify how AI systems can be responsibly governed. Module 8: Ongoing AI issues and concerns Presents current discussions and ideas about AI governance, including awareness of legal issues, user concerns, and AI auditing and accountability issues. Accreditation The associated exam is accredited by the IAPP under its ANSI Accreditation Who Should Attend? Any professionals tasked with developing AI governance and risk management in their operations, and anyone pursuing IAPP Artificial Intelligence Governance Professional certification. Prerequisites A general understanding of AI, Corporate Governance, and Business value would be of benefit to participants. Assessment As with all IAPP exams, the AIGP is a 90 question, multiple choice exam to be completed within 150 minutes. Exams are hosted by Pearsonvue and can be taken either remotely, or via any one of hundreds of exam venues globally. A passing score is achieved at 70% Our Guarantee We are an approved IAPP training provider Exam pass guarantee, or retrain until you do, for free What's Included? Participant Guide Study Guide Practice Exam Exam voucher Breakfast, lunch, coffees and snacks (Classroom courses only) Certification Logo

Duration 2 Days 12 CPD hours This course is intended for This training is ideally suited for data analysts, IT professionals, and software developers who seek to augment their data processing and analytics capabilities. It will also benefit system administrators and data engineers who wish to harness Elastic Stack's functionalities for efficient system logging, monitoring, and robust data visualization. With a focus on practical application, this course is perfect for those aspiring to solve complex data challenges in real-time environments across diverse industry verticals. Overview This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll explore: New features and updates introduced in Elastic Stack 7.0 Fundamentals of Elastic Stack including Elasticsearch, Logstash, and Kibana Useful tips for using Elastic Cloud and deploying Elastic Stack in production environments How to install and configure an Elasticsearch architecture How to solve the full-text search problem with Elasticsearch Powerful analytics capabilities through aggregations using Elasticsearch How to build a data pipeline to transfer data from a variety of sources into Elasticsearch for analysis How to create interactive dashboards for effective storytelling with your data using Kibana How to secure, monitor and use Elastic Stack's alerting and reporting capabilities The Elastic Stack is a powerful combination of tools for techniques such as distributed search, analytics, logging, and visualization of data. Elastic Stack 7.0 encompasses new features and capabilities that will enable you to find unique insights into analytics using these techniques. Geared for experienced data analysts, IT professionals, and software developers who seek to augment their data processing and analytics capabilities, Working with Elasticsearch will explore how to use Elastic Stack and Elasticsearch efficiently to build powerful real-time data processing applications. Throughout the two-day hands-on course, you?ll explore the power of this robust toolset that enables advanced distributed search, analytics, logging, and visualization of data, enabled by new features in Elastic Stack 7.0. You?ll delve into the core functionalities of Elastic Stack, understanding the role of each component in constructing potent real-time data processing applications. You?ll gain proficiency in Elasticsearch for distributed searching and analytics, Logstash for logging, and Kibana for compelling data visualization. You?ll also explore the art of crafting custom plugins using Kibana and Beats, and familiarize yourself with Elastic X-Pack, a vital extension for effective security and monitoring. The course also covers essentials like Elasticsearch architecture, solving full-text search problems, data pipeline building, and creating interactive Kibana dashboards. Learn how to deploy Elastic Stack in production environments and explore the powerful analytics capabilities offered through Elasticsearch aggregations. The course will also touch upon securing, monitoring, and utilizing Elastic Stack's alerting and reporting capabilities. Hands-on labs, captivating demonstrations, and interactive group activities enrich your learning journey throughout the course. Introducing Elastic Stack What is Elasticsearch, and why use it? Exploring the components of the Elastic Stack Use cases of Elastic Stack Downloading and installing Getting Started with Elasticsearch Using the Kibana Console UI Core concepts of Elasticsearch CRUD operations Creating indexes and taking control of mapping REST API overview Searching - What is Relevant The basics of text analysis Searching from structured data Searching from the full text Writing compound queries Modeling relationships Analytics with Elasticsearch The basics of aggregations Preparing data for analysis Metric aggregations Bucket aggregations Pipeline aggregations Substantial Lab and Case Study Analyzing Log Data Log analysis challenges Using Logstash The Logstash architecture Overview of Logstash plugins Ingest node Visualizing Data with Kibana Downloading and installing Kibana Preparing data Kibana UI Timelion Using plugins

Duration 1 Days 6 CPD hours This course is intended for This course is intended for students who want to learn basic Word 2021 skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content. Overview In this course, you will learn fundamental Word skills. You will: Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application. Format text and paragraphs. Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles. Enhance lists by sorting, renumbering, and customizing list styles. Create and format tables. Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art. Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout. Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility. These days, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper, we expect to use a computer to create the majority of our documents. It's impossible to avoid word-processing software in many areas of the business world. Managers, lawyers, clerks, reporters, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer, you'll need to know the ins and outs of electronic word processing. Microsoft© Word 2021 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2021 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Word Associate (Office 365 and Office 2021): Exam MO-100 and Word Expert (Office 365 and Office 2021): Exam MO-101 certifications. Getting Started with Word 2021 Topic A: Navigate in Microsoft Word Topic B: Create and Save Word Documents Topic C: Manage Your Workspace Topic D: Edit Documents Topic E: Preview and Print Documents Topic F: Customize the Word Environment Formatting Text and Paragraphs Topic A: Apply Character Formatting Topic B: Control Paragraph Layout Topic C: Align Text Using Tabs Topic D: Display Text in Bulleted or Numbered Lists Topic E: Apply Borders and Shading Working More Efficiently Topic A: Make Repetitive Edits Topic B: Apply Repetitive Formatting Topic C: Use Styles to Streamline Repetitive Formatting Tasks Managing Lists Topic A: Sort a List Topic B: Format a List Adding Tables Topic A: Insert a Table Topic B: Modify a Table Topic C: Format a Table Topic D: Convert Text to a Table Inserting Graphic Objects Topic A: Insert Symbols and Special Characters Topic B: Add Images to a Document Controlling Page Appearance Topic A: Apply a Page Border and Color Topic B: Add Headers and Footers Topic C: Control Page Layout Topic D: Add a Watermark Preparing to Publish a Document Topic A: Check Spelling, Grammar, and Readability Topic B: Use Research Tools Topic C: Check Accessibility Topic D: Save a Document to Other Formats

The NCSP® 800-53 Practitioner accredited (APMG International), certified (NCSC/GCHQ-UK), and recognized (DHS-CISA-USA) certification course teaches Digital Business, Operational Stakeholders, Auditors, and Risk Practitioners a Fast-Track approach to adopting and adapting the NIST Cybersecurity Framework and its 800-53 controls across an enterprise and its supply chain.The course also teaches candidates how to build a Digital Value Management System (DVMS) CPD overlay model capable of enabling the quick adoption and adaption of new frameworks and models (NIST-CSF, NIST Privacy Framework, CMMC, etc.) that may be required to address internal, external (regulatory), and cyber threat landscape changes. Finally, the course teaches candidates how to ensure the organization's DVMS is designed for use within the organization and auditable by government regulators looking to verify regulatory outcomes. The NCSP Practitioner 800-53 course is designed for both the Implementer and Auditor topics and participants select the exam they want to take (or an additional exam can be ordered to be certified as both an implementer and auditor).

Embark on a journey into the world of technology with Spark Generation! Learn the fundamentals of computer science, coding languages, and algorithmic thinking. Discover the logic behind programs and explore the creative potential of digital innovation.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Recruitment: IT Basics for IT Recruiters Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Recruitment: IT Basics for IT Recruiters Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Recruitment: IT Basics for IT Recruiters Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Recruitment: IT Basics for IT Recruiters Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Recruitment: IT Basics for IT Recruiters? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Recruitment: IT Basics for IT Recruiters there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Recruitment: IT Basics for IT Recruiters course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Recruitment: IT Basics for IT Recruiters does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Recruitment: IT Basics for IT Recruiters was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Recruitment: IT Basics for IT Recruiters is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:02:00 Section 02: IT Fundamentals Server 00:08:00 What is hardware and software? 00:04:00 Project Life Cycle 00:06:00 Software Development Life Cycle 00:08:00 Section 03: IT Terms / basics Methodologies: Scrum, Agile, Kanban, Waterfall, Lean 00:09:00 CMS 00:04:00 API 00:04:00 Stacks 00:03:00 Native & Hybrid Native Apps 00:02:00 CI / CD / Deployment tools 00:04:00 Section 04: IT Positions CTO 00:13:00 IT Architects 00:08:00 Product Owner 00:12:00 Product Manager 00:06:00 PO vs Product Manager 00:04:00 Project Manager 00:13:00 Product Owner vs Project Manager vs Product Manager 00:07:00 Business Analysts 00:09:00 Business Intelligence Analyst 00:06:00 Data Engineer 00:05:00 Data Scientist 00:07:00 Data Engineer vs Data Scientist 00:07:00 Agile Coach 00:14:00 Scrum Master 00:08:00 Agile Coach vs Scrum Master 00:01:00 Frontend Developer 00:06:00 Backend Developer 00:06:00 Fullstack Developer 00:04:00 Developers: Frontend, Backend and Fullstack 00:02:00 iOS Developer 00:03:00 Android Developer 00:04:00 UX Designers 00:09:00 UI Design 00:08:00 UX vs UI Design: what is the difference? 00:04:00 QA Engineers and Testers 00:09:00 System Administrators+ 00:07:00 DevOps 00:05:00 SEO Specialists: who are they? 00:10:00 Section 05: IT Technologies Programming languages and frameworks Programming Languages and Frameworks. Introduction 00:01:00 Programming languages and frameworks 00:08:00 JavaScript 00:02:00 Java 00:03:00 Python 00:01:00 C 00:02:00 C# 00:02:00 C++ 00:03:00 SWIFT 00:02:00 Objective C 00:01:00 HTML 00:02:00 PHP 00:02:00 Ruby 00:02:00 SQL 00:02:00 Go 00:01:00 R 00:01:00 Section 06: IT Technologies: Databases Database 00:05:00 Types of Databases 00:07:00 Section 07: From Recruiter to Recruiter The day of an IT Recruiter 00:05:00 Key principles 00:03:00 Sourcing Tipps 00:03:00 Section 08: Bye-bye Thank you for taking part in this course! 00:01:00 Assignment Assignment - Recruitment: IT Basics for IT Recruiters 00:00:00

Get Xero Advisor certified and boost your knowledge of the nation's leading Cloud accounting software, with our Xero Bookkeeping and Budgeting course! The Xero Bookkeeping and Budgeting For Everyone is ideal for small business owners, aspiring bookkeepers and accountants, covering the fundamental principles of Cloud accounting, with instruction on how to set up and run Xero. We've taken this comprehensive professional diploma and broken it down into several manageable modules which will assist you to easily grasp each concept - from the fundamentals to the most advanced aspects of the course. It really is a sure pathway to success! Learning Outcomes Navigate Xero's interface and features for optimal bookkeeping efficiency. Process financial transactions, including sales and purchases, with proficiency. Conduct bank reconciliations and manage cash flows with precision. Administer payroll duties and handle asset registries meticulously. Prepare and submit VAT returns, adhering to UK tax legislation. Why choose this Xero Bookkeeping and Budgeting course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Xero Bookkeeping and Budgeting For Everyone Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Xero Bookkeeping and Budgeting course for? Aspiring bookkeepers seeking to specialise in Xero software. Business owners aiming to manage their finances independently. Accountancy students enhancing their proficiency in cloud-based systems. Finance professionals diversifying their skill set. Small to medium-sized enterprise (SME) managers overseeing financial operations. Career path Xero Certified Bookkeeper: £18,000 - £28,000 Accounts Assistant: £17,000 - £25,000 Financial Controller: £25,000 - £50,000 Payroll Administrator: £19,000 - £27,000 VAT Specialist: £22,000 - £35,000 Management Accountant: £24,000 - £40,000 Prerequisites This Xero Bookkeeping and Budgeting For Everyone does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Xero Bookkeeping and Budgeting For Everyone was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Introduction 00:02:00 Getting Started Introduction - Getting Started 00:01:00 Signing up to Xero 00:04:00 Quick Tour of Xero 00:12:00 Initial Xero Settings 00:13:00 Chart of Accounts 00:14:00 Adding a Bank Account 00:08:00 Demo Company 00:04:00 Tracking Categories 00:07:00 Contacts 00:12:00 Invoices and Sales Introduction - Invoices and Sales 00:01:00 Sales Screens 00:04:00 Invoice Settings 00:13:00 Creating an Invoice 00:17:00 Repeating Invoices 00:07:00 Credit Notes 00:10:00 Quotes Settings 00:03:00 Creating Quotes 00:07:00 Other Invoicing Tasks 00:03:00 Sending Statements 00:03:00 Sales Reporting 00:05:00 Bills and Purchases Introduction - Bills and Purchases 00:01:00 Purchases Screens 00:04:00 Bill Settings 00:02:00 Creating a Bill 00:13:00 Repeating Bills 00:05:00 Credit Notes 00:06:00 Purchase Order Settings 00:02:00 Purchase Orders 00:08:00 Batch Payments 00:12:00 Other Billing Tasks 00:02:00 Sending Remittances 00:03:00 Purchases Reporting 00:05:00 Bank Accounts Introduction - Bank Accounts 00:01:00 Bank Accounts Screens 00:07:00 Automatic Matching 00:04:00 Reconciling Invoices 00:06:00 Reconciling Bills 00:03:00 Reconciling Spend Money 00:05:00 Reconciling Receive Money 00:04:00 Find and Match 00:04:00 Bank Rules 00:09:00 Cash Coding 00:04:00 Remove and Redo vs Unreconcile 00:04:00 Uploading Bank Transactions 00:07:00 Automatic Bank Feeds 00:06:00 Products and Services Introduction - Products and Services 00:01:00 Products and Services Screen 00:02:00 Adding Services 00:03:00 Adding Untracked Products 00:03:00 Adding Tracked Products 00:07:00 Fixed Assets Introduction - Fixed Assets 00:01:00 Fixed Assets Settings 00:05:00 Adding Assets from Bank Transactions 00:06:00 Adding Assets from Spend Money 00:05:00 Adding Assets from Bills 00:02:00 Depreciation 00:04:00 Payroll Introduction - Payroll 00:01:00 Payroll Settings 00:15:00 Adding Employees 00:18:00 Paying Employees 00:10:00 Payroll Filing 00:04:00 VAT Returns Introduction - VAT Returns 00:01:00 VAT Settings 00:02:00 VAT Returns - Manual Filing 00:06:00 VAT Returns - Digital Filing 00:02:00 Mock Exam Mock Exam - Xero Bookkeeping and Budgeting For Everyone 00:20:00 Final Exam Final Exam - Xero Bookkeeping and Budgeting For Everyone 00:20:00

Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to understand configuration for installation, configuration of a host system, using Oracle Restart framework, troubleshooting tips, how the database fits with other systems, internals of the database, database failures and other topics. In this course, students will focus on configuration on supported systems. Also how the database fits in with other systems. Oracle Database Architercture Overview The Database Instance Database Memory Structures Database Process Structures Database Storage Architecture Oracle Clusterware Configuring the Host for Standalone Installlation Host Configuration Overview Choosing a Database Host Choosing an Operating System Proprietary Unix vs Open-Source Linux Making the OS Selection Prepare an Oracle LINUX Installation Perform Oracle LINUX Installation Configure the LINUX Host Step 1 - Confirm General System Requirements Step 2 - Confirm The Operating System Platform Step 3 - Confirm LINUX Package Requirements Step 4 - Confirm Network Configuration Configure Host for Virtualization VM Technologies Configure Oracle Linux for Virtualization Step 1 - Download Linux Updates Step 2 - Check Linux Kernel Step 3 - Download Latest yum Configuration File Step 4 - Enable Oracle Linux Add-ons Step 5 - Install VirtualBox Oracle Optimal Flexible Architecture OFA Goals ORACLE_BASE ORACLE_HOME Database Files Multiple ORACLE_HOMEs Databse Software Upgrades Mutliple Oracle Software Installations GRID Infrastructure Configuration Configure the Linux Installation About ASM Devices Configure Linux Devices for ASM Partioning a Device Oracle ASMLib Configue MS Windows Devices GRID Infrastructure Installation Perform the Installation Download Unpack the Installation Package Launch the Installation Session The Installation Dialog Verify the Installation Operating System Confirmation Oracle Utilities Setup SQL*Plus Confirmation Using EM Cloud Control Troubleshooting Problems DATABASE Installation Configuraion Configure a Linux Installation System Groups & Users Configure Kernel Parameters Create the Physical Directories Configure MS Windows Installation Prerequisite Checks & Fixup Utility DATABASE Installation ABOUT THE INSTALLATION The Installation Tools About The Installation Dialog The Installation Session Log PERFORM INSTALLATION ON LINUX Download Unpack The Installation Files Set Environment Variables Launch The Installation SERVER CLASS INSTALLATION DIALOG More About The Global Database Name About Enterprise Manager Cloud Control Secure The New Database PERFORM INSTALLATION ON WINDOWS Launch The Installation POST---INSTALLATION CONFIGURATION Required Environment Variables Defining The Environment Variables About SSH VERIFY THE INSTALLATION SQL*PlusConfirmation Operating System Confirmation Firewall Configuration Accessing EM Database Express Creating Databses Using DBCA About DBCA DBCA Templates Are You Sure? DEFAULT CONFIGURATION DATABASE ADVANCED MODE DATABASE File Location Variables Database Vault and Label Security CONFIGURE AN EXISTING DATABASE DELETE A DATABASE MANAGE TEMPLATES MANUALLY CREATE A DATABASE The CREATE DATABASE Command Using Oracle Restart WHAT IS ORACLE RESTART? What Oracle Restart Does Is Oracle Restart Deprecated? Registering With Oracle Restart More About srvctl Terminal Session Configuration COMPONENT STATUS USING SRVCTL Database Status Grid Infrastructure Status Oracle Home Status CONFIGURATION USING SRVCTL Examining A Database Configuration Examining The Listener Configuration Examining The ASM Configuration Manual Registration ListenerConfiguration Modification Database ConfigurationModification STARTUP/SHUTDOWN USING SRVCTL Why Use srvctl? MANAGING ORACLE RESTART Obtaining Oracle Restart Status Start/Stop Oracle Restart Preparing for a Database Upgrade What is a Database Upgrade? Database Upgrade Methods Real World Database Upgrade Develop A Database Upgrade Plan ABOUT THE DATABASE VERSION Direct Upgrade The COMPATIBLE Database Parameter PRE-UPGRADE PREPARATIONS Oracle Warehouse Builder Oracle Label Security (OLS) Oracle Database Vault Locating The Older Database Installations THE PRE-UPGRADE INFORMATION TOOL Pre-Upgrade Information Tool Files Run The Pre---Upgrade Information Tool Examining The Pre---Upgrade Information Tool Results Upgrade to Oracle Databse 12c Launch DBUA Database Upgrade Dialog Post-Upgrade Tasks Post-Upgrade Checklist Enable Unified Auditing Migrate to Unified Auditing Database Parameter Changes Enable New Features Source Destination Specific Post-Upgrade Tasks Oracle Architecture: The Systems Infrastructure About Enterprise Architectures The Relational Database Legacy Computing Models The Multi-Tiered Computing Model Scaling Up Cloud-Based Deployment ORACLE INFRASTRUCTURE ECOSYSTEM USING ORACLE ENTERPRISE MANAGER More About EM Using EM Database Express Using EM Cloud Control Oracle Architecture: The Database Host The Database Server Stack PROCESSOR LAYER CPU Resources Memory Resources I/O & STORAGE PROCESSING OS LAYER PROCESSING MODES DATABASE SERVER VIRTUALIZATION STORAGE VIRTUALIZATION ORACLE DATABASE SERVER STACK ORACLE ENGINEERED SYSTEMS Oracle Exadata Database Platform Exalogic Cloud Machine Exalytics BI Machine Oracle Architecture: Princilples & Technology Concepts Grid Computing Principles Why Grid Computing? What Is Grid Computing? PARALLELIZATION PRINCIPLES Hardware Parallelization Grid Computing Devices Clustered Database Servers CLOUD COMPUTING PRINCIPLES Multi-Tenancy Oracle Architecture: The RDBMS Installation & the Database Instance The Database Server Software Database Versions & Releases Database Editions Using PRODUCT_COMPONENT_VERSION View The Core Database Components Using V$VERSION View Understanding The Database Version Number The COMPATIBLE Database Parameter DATABASE INSTANCE ELEMENTS Individual Elements Of A Database Instance Physical Database Elements An Operational Database installation DATABASE INSTANCE CONFIGURATIONS Single Instance Parameter Files & Instance Configuration MAX_STRING_SIZE Parameter Example Independent Instances Clustered Instances The Database Instance In A Multi-tenant Configuration RECONFIGURING A DATABASE INSTANCE Static Vs. Dynamic Parameters Dynamic Parameter Setting Parameter Setting Scope Parameter Setting Level Setting Upgrade Related Parameters DATABASE COMPONENTS Advanced Data Functionality Components Security Components High-Performance Components Administration Components Database F