24479 Courses delivered Online

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse Administrator Database Administrators Database Designers Support Engineer Technical Administrator Overview Back up, restore, and patch DBCS database deployments Describe the DBaaS and on-premises Oracle Database architectures Manage database instances Manage UNDO data Move data between databases Implement basic backup and recovery procedures Monitor and tune database performance Tune SQL to improve performance Manage resources with Oracle Database Resource Manager Create pluggable databases (PDBs) Configure the Oracle network environment Administer user security and implement auditing Create and manage tablespaces Manage storage space Create and manage Database as a Cloud Service (DBCS) database deployments Register databases and manage performance with Enterprise Manager Cloud Control The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide students with a firm foundation in administration of an Oracle Database. In this course students will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. Exploring Oracle Database Architecture Introducing Oracle Database Relation Database Models Oracle SQL and PL/SQL Oracle Database Server Architecture Connecting to Oracle Databases Oracle Database Tools Oracle-Supplied User Accounts Querying the Oracle Data Dictionary Managing Database Instances Initialization Parameter Files Starting Up Oracle Databases Shutting Down Oracle Databases Opening and Closing PDBs Working with the Automatic Diagnostic Repository (ADR) Querying Dynamic Performance Views Creating PDBs Methods and Tools to Create PDBs Creating PDBs from Seed with SQL*Plus Cloning PDBs with SQL*Plus Unplugging and Pluggin In PDBs with SQL*Plus Dropping PDBs with SQL*Plus Configuring the Oracle Network Environment Oracle Net Services How Listeners Work Configuring Listeners for Dynamic Service Registration Configuring Listeners for Static Service Registration Configuring Local Naming for Connections Testing Oracle Net Connectivity with tnsping Configuring Communication Between Databases Dedicated Versus Shared Server Configurations Administering User Security Creating Users Granting Privileges Creating and Granting Roles Revoking Privileges and Roles Creating and Assigning Profiles Authenticating Users Assigning Quotas to Users Applying the Principal of Least Privilege Creating and Managing Tablespaces How Table Data is Stored Creating Tablespaces in SQL*Plus Altering and Dropping Tablespaces in SQL*Plus Viewing Tablespace Information in SQL*Plus Implementing Oracle Managed Files Moving and Renaming Online Data Files in SQL*Plus Managing Storage Space Oracle Database Space Management Features Block Space Management Row Chaining and Migration Free Space Management Within Segments Types of Segments Allocating Extents Understanding Deferred Segment Creation Space-Saving Features Managing UNDO Data Undo Data: Overview Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data Managing Undo Local Undo Mode Versus Shared Undo Mode Configuring Undo Retention Categories of Undo Moving Data Moving Data: General Architecture Oracle Data Pump: Overview Oracle Data Pump: Benefits Data Pump Export and Import Clients Data Pump Utility: Interfaces and Modes Data Pump Import: Transformations SQL*Loader Overview Loading Methods Backup and Recovery Concepts DBA Responsibilities Categories of Failure Understanding Instance Recovery Understanding Types of Backups Comparing Complete and Incomplete Recovery Oracle Data Protection Solutions Flashback Technology Monitoring and Tuning Database Performance Managing Performance Activities Performance Planning Considerations Database Maintenance Automatic Workload Repository (AWR) Automatic Database Diagnostic Monitor Performance Monitoring Performance Tuning Methodology Database Server Statistics and Metrics SQL Tuning SQL Tuning Process Oracle Optimizer Optimizer Statistics SQL Plan Directives Adaptive Execution Plans SQL Tuning Advisor SQL Access Advisor SQL Performance Analyzer Oracle Database Resource Manager Oracle Database Resource Manager: Overview Resource Manager Elements Using Resource Manager to Allocate Resources Creating a Simple Resource Plan Creating a Complex Resource Plan Using the Active Session Pool Feature Limiting CPU Utilization at the Database Level Limiting CPU Utilization at the Server Level Enterprise Manager Cloud Control Controlling the Enterprise Manager Cloud Control Framework Starting the Enterprise Manager Cloud Control Framework Stopping the Enterprise Manager Cloud Control Framework Introduction to Oracle Database Cloud Service Oracle Cloud: Overview Database Cloud Service Offerings DBCS Architecture Features and Tooling Additional Database Configuration Options Creating DBCS Database Deployments Automated Database Provisioning Creating a Database Deployment How SSH Key Pairs are Used Creating an SSH Key Pair Storage Used for Database Files Managing DBCS Database Deployments Cloud Tooling Accessing Tools and Features from the DBCS Console Managing the Compute Node Associated With a Database Deployment Managing Network Access to DBCS Enabling Access to a Compute Node Port Scaling a Database Deployment Backing Up and Restoring DBCS Database Deployments Backing Up and Recovering Databases on DBCS Backup Destination Choices Backup Configuration Creating an On-Demand Backup Customizing the Backup Configuration Performing Recovery by Using the Console Performing Recovery by Using the dbaascli Utility Patching DBCS Database Deployments Patching DBCS Using the DBCS Console to Manage Patches Using the dbaascli Utility to Manage Patches Creating Master Encryption Keys for PDBs CDB and PDB Master Encryption Keys Determining Whether You Need to Create and Activate and Encryption Key for a PDB Creating and Activating an Encryption Key Tablespace Encryption by Default Tablespace Encryption by Default in DBCS Transparent Data Encryption (TDE) Overview Components of TDE Using TDE Defining the Keystore Location Controlling Tablespace Encryption by Default Managing the Software Keystore and Master Encryption Key Managing the Keystore in CDBs and PDBs Additional course details: Nexus Humans Oracle Database 12c R2 - Administration Workshop Ed 3 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle Database 12c R2 - Administration Workshop Ed 3 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Become your own car expert! Learn vital maintenance skills to save on repairs and keep your vehicle in top shape. #CarMaintenance

Is learning to paint on your bucket list? This FREE beginner's class to experiment with watercolour paints, and have fun making a floral abstract greeting card. Learn to paint and draw a lovely floral greeting card in a more abstract, non-representational style!

Accredited by CPD QS | Interactive Lessons | Tutor Support included | Special Price

Remember the thrill of watching Netflix's Squid Game, understanding every gasp and plot twist thanks to precise captions? That's the power of transcription and captioning, a thriving industry that unlocks content for millions. Now, you can delve into this impactful field with our Transcription and Captioning Course. Master the art of creating accurate, accessible text for videos, opening doors to diverse career paths and the satisfaction of making content inclusive for all. You Will Learn The Following Things: Grasp the fundamentals of subtitles and closed captions. Craft clear and engaging captions that adhere to industry guidelines. Confidently transcribe videos using both offline and online tools. Integrate captions seamlessly into video files. Expand your reach by translating captions for international audiences. Apply your skills effectively in various transcription and captioning projects. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Transcription and Captioning Course. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Transcription and Captioning Course course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? Content Creators: Enhance your videos' reach and engagement with high-quality captions. Educators: Make your online courses more accessible for learners with varying needs. Businesses: Expand your audience and ensure compliance with accessibility regulations. Freelancers: Build a rewarding career in transcription and captioning, offering your services to clients worldwide. Individuals Passionate About Accessibility: Contribute to a more inclusive media landscape. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Transcription and Captioning Course course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path Transcriptionist - £20K to £35K/year Captioner - £22K to £38K/year Subtitler - £24K to £40K/year Translation Specialist - £25K to £45K/year Accessibility Consultant - £30K to £50K/year Course Curriculum Module 01: Introduction - What It's All About Definition: Captions 00:02:00 Subtitling in Practice 00:05:00 Workflow for Captioning Videos 00:04:00 Module 02: Theory - About Subtitles and Closed Captions Theory: Overview 00:02:00 Motivation: Benefits of Subtitles and Captions 00:05:00 Differences Between Subtitles and Captions 00:04:00 The Most Important Subtitle Formats 00:06:00 Module 03: Guidelines - Nice and Clean Captions Language: Pay Attention to Spelling, Grammar and Punctuation 00:03:00 Style Guidelines: How to Create Great Captions 00:06:00 Example and Discussion: Good and Bad Captions 00:04:00 Module 04: Preparation - Transcribe Your Video Preparation: Overview 00:02:00 Definition: Transcription 00:01:00 Reasons for Transcription 00:04:00 The Other Way Around: Convert Captions to Plain Text 00:02:00 Tools for Transcribing Videos 00:04:00 Module 05: The Offline Way - Manually Prepare Captions With Desktop Tools The Offline Way: Overview 00:03:00 Benefits of Captioning Software 00:04:00 Subtitle Edit 00:07:00 Tip: Adjust Timings 00:02:00 Tip: Convert Subtitles 00:01:00 Aegisub Advanced Subtitle Editor 00:06:00 Other Programs to Create Subtitles 00:04:00 Module 06: The Subtitle Track - Integrate Captions into Your Video File The Subtitle Track: Overview 00:02:00 How to Add Captions to MKV Videos 00:04:00 How to Add Captions to MP4 Videos 00:03:00 How to Use Captions With the VLC media player 00:05:00 Open Captions Vs. Closed Captions 00:06:00 Tip: The Other Way Round: Extract Captions From Videos 00:02:00 Module 07: The Online Way - Caption Videos Manually and Automatically Online The Online Way: Overview 00:02:00 YouTube: Create, Edit and Add Captions to Your Videos 00:04:00 Subtitling Platforms 00:04:00 Download Subtitles for Any YouTube Video 00:02:00 Module 08: Translation - Appeal to Your International Audience Translation: Overview 00:02:00 Motivation: Translate Videos into Many Different Languages Using Captions 00:03:00 The Translation Procedure: Translate Transcriptions, Not Captions! 00:03:00 Online Translation Tools 00:04:00 Module 09: The End - What Did You Learn? Summary of the Course 00:05:00

Course Overview Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no further; you've come to the right place! Our easy-to-follow Workplace Productivity Hacks will provide you with all the deep knowledge and insight you need to know about this topic. This comprehensive course has been broken down into several manageable modules, which we believe will assist you to easily grasp each concept - from the fundamental to the more advanced aspects of the course.  Learn the most in-demand skills from the safety & comfort of your home. Enjoy the freedom to learn at your own comfortable pace and prepare yourself for the market of the future. Learning Outcomes Whether you are an aspiring professional or a complete beginner, this course will improve your expertise and boost your CV with key skills and an accredited certification attesting to your knowledge. Entry Requirement This course is available to all learners of all academic backgrounds.Learners should be aged 16 or over to undertake the qualification.Some basic understanding of the English language and numeracy. Why choose us? Affordable, engaging & high-quality e-learning study materials;Tutorial videos/materials from the industry-leading experts;Study in a user-friendly, advanced online learning platform;Efficient exam systems for the assessment and instant result;The UK & internationally recognized accredited qualification;Access to course content on mobile, tablet, or desktop from anywhere, anytime;The benefit of career advancement opportunities;24/7 student support via email. Will I receive a certificate of completion? After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can, however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £29 or in PDF format at the cost of £19. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Career path Workplace Productivity Hacks is a useful qualification to possess and would be beneficial for any related profession or industry. Course Curriculum Module 01: Ways to Improve Workplace Productivity Ways to Improve Workplace Productivity 00:41:00 Module 02: Organisational Skills to Improve Productivity Organisational Skills to Improve Productivity 00:21:00 Module 03: Productive Communication Skills in the Workplace Productive Communication Skills in the Workplace 00:29:00 Module 04: Time Management Time Management 00:41:00 Module 05: Conflict Management Conflict Management 00:16:00 Module 06: Health, Safety and Wellness in the Workplace Health, Safety and Wellness in the Workplace 00:29:00 Module 07: Managing Stress and Coping Anxiety in the Workplace Managing Stress and Coping Anxiety in the Workplace 00:28:00

Master essential and advanced video editing techniques with our comprehensive Video Editing Tips & Tricks course. Learn to cut, sequence, and polish raw footage, apply creative effects, and enhance your editing skills. Ideal for beginners and experienced editors alike, this course prepares you for diverse career paths in video editing and multimedia production. Enroll today to start creating professional-quality videos!

Transform your career with our Makeup and Skincare for Beauty Professionals course. Become proficient in essential and advanced makeup techniques, skincare routines, and professional practices. Enroll today to enhance your skills and excel in the beauty industry!

Turn your love for makeup into a successful career with our extensive Makeup Artist Training course. This program covers everything from beauty and film makeup to airbrush techniques and advanced artistry. Gain the skills needed to master various makeup styles and settings. Enroll now to begin your path to a fulfilling makeup artistry career!

Learn essential grant writing skills to secure funding for your non-profit. Master proposal writing, budgeting, and funder alignment in our flexible online course.