11611 Environment courses in Dunfermline delivered Online

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 perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database. In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties. Introduction: Managing the Database Instance The Database Management Tools EM Database Express EM Cloud Control SQL Developer Database Administrator Introduction: Database Architecture Review Database Instance Configurations Memory Structures Process Structures Storage Architecture Introduction: Starting & Stopping Databse Services Start & Stop the Database Listener ABOUT DATABASE STARTUP/SHUTDOWN SYSOPER SYSDBA DATABASE STATE & STAGES STARTUP WITH EM CLOUD CONTROL STARTUP WITH SQL*PLUS SHUTDOWN WITH EM CLOUD CONTROL SHUTDOWN WITH SQL*PLUS USING MS WINDOWS SERVICES Introduction: Oracle Network Environment Oracle Net Services Architecture ORACLE NET CONFIGURATION ASSISTANT ORACLE NET MANAGER USING EM CLOUD CONTROL ADVANCED NETWORK COMPRESSION TROUBLESHOOTING NETWORK PROBLEMS Introduction: Diagnostics & Oracle Support About Database Diagnostics Fault Diagnosability Infrastructure DATABASE INSTANCE HEALTH SNAPSHOT THE SUPPORT WORKBENCH PROACTIVE DATABASE HEALTH CHECKS PACKAGE DIAGNOSTIC DATA WORKING WITH THE KNOWLEDGE BASE Storage: Tablespace Management Starter Tablespaces CREATE TABLESPACE WITH EM CC CREATE TABLESPACE WITH SQL MANAGE TABLESPACES WITH EM CC MANAGE TABLESPACES WITH EM DE MANAGE TABLESPACES WITH SQL DROP TABLESPACE ALTER TABLESPACE Storage: Advanced Tablespace Management Managing Temporary Tablespaces TEMP TABLESPACE GROUPS WITH EM TEMP TABLESPACE GROUPS WITH SQL DEFAULT PERMANENT TABLESPACES BIGFILE TABLESPACES MANAGING THE SYSAUX TABLESPACE Storage: Data Files & Temp Files Management Manage Data Files with EM ACCESS METADATA WITH SQL MANAGE DATA FILES WITH SQL MANAGE TEMP FILES ORACLE-MANAGED FILES (OMF) Storage: UNDO Data & UNDO Tablespaces About UNDO Space Management GUARANTEE UNDO RETENTION MONITOR UNDO SPACE WITH SQL USE THE EM UNDO ADVISOR Security & Schemas: Security Overview & Database Privileges Database Security Principles DATABASE SYSTEM PRIVILEGES DATABASE OBJECT PRIVILEGES SUPER ADMINISTRATOR ROLES PRIVILEGE ANALYSIS Security & Schemas: User Security Create & Manage User Accounts MANAGE USERS WITH EM MANAGE USERS WITH SQL CREATE USER ALTER USER DROP USER GRANT & REVOKE PRIVILEGES RESOURCE LIMITS VIA PROFILES ALTER PROFILE DROP PROFILE PASSWORD MANAGEMENT VIA PROFILES ROLE-BASED SECURITY MANAGEMENT ALTER USER...DEFAULT ROLE SET ROLE DELEGATING PRIVILEGE AUTHORIZATION WITH ADMIN OPTION & System Privileges WITH GRANT OPTION & Object Privileges PRINCIPLE OF LEAST PRIVILEGE CHECKLIST Security & Schemas: Database Auditing Auditing Database Activity Traditional Auditing Unified Auditing Create Audit Policy Security & Schemas: SQL Loader Loader Concepts Loader From the Command Line control File Options Load Methods Loader Express Mode Loader From EM Security & Schemas: Export & Import Manage Directory Objects The Data Pump Architecture Data Pump Export Data Pump Import Data Pump Dictionary Views Using the EM CC Interface Performance & Availability: Managing Performance & SQL Tuning Management Advisory Framework Performance Monitoring & AWR The SQL Tuning Advisor Monitoring Exceptions with Metrics Performance & Availability: Data Concurrency About System & User Locks Monitor & Manage User Locks Moitor Locks with Data Dictionary Manage Locks with EM Performance & Availability: Backup & Recovery Concepts Backup & Recovery Structures Managing REDO Data Configuring for Recoverability Instance Recovery Recoverability Checklist Additional course details: Nexus Humans Oracle 12c Administration II 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 12c Administration II 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.

Duration 5 Days 30 CPD hours This course is intended for This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore: The Oracle Database Architecture Query Optimizer Tuning Container Databases and Pluggable Databases Oracle 19c Tuning features Evaluating Execution Plans Oracle Tuning Tools Using Automatic Workload Repository Join Types AWR Using Baselines Additional AWR performance tools Optimizer Statistics Monitoring a Service Bind Variables and database parameters Oracle's Real Application Testing (RAT) SQL Tuning Advisor Automatic Sql Tuning Sql Plan Management Shared Pool Tuning Tuning the database buffer cache Tuning the PGA (Program Global Area) Automatic Memory Management (AMM) Tuning Segment Space Utilization (ASSM) Automatic Storage Management Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more. Overview Oracle Database Architecture Instance Definition Define SGA Define Background Processes Datafile Definition Query Optimizer SQL Parsing Optimizing Terms Optimizing Methods Query Plan Generation Query Plan Control Tuning Container Databases and Pluggable Databases Pluggable tuning parameters Define Container tuning structure Using PDB$SEED Create a new PDB Plug and unplug a PDB Oracle 12c Tuning features Identifying and Using Oracle's Heat Map 12c Compression Levels and Types Evaluating Execution Plans Defining SQL execution plans Automatic Workload Repository Reading execution plans Oracle Tuning Tools Monitoring tools overview Enterprise Manager Dynamic Performance Views Automatic Workload Repository Automatic Database Diagnostic Monitor Sql Tuning Advisor SQL Access Advisor Sql Access Advisor DB operation Tuning DB operation Active Reporting Using Automatic Workload Repository Defining AWR AWR Settings Creating AWR Baselines Metrics, Alerts, and Thresholds Defining Metrics Setting Alerts Setting Corrective Actions User Defined Metrics Metric Dynamic Views Join Types Nested Loops Join Sort Merge join Hash Join and Cartesian Join Equijoins and Nonequijoins Outer Joins Semijoins AWR Using Baselines Creating AWR baselines Creating AWR Repeating baselines Moving Window Baseline Additional AWR performance tools Automatic Maintenance Tasks Segment Advisor Statistics Gathering Automatic Tuning Optimizer Automatic Database Diagnostic Monitor Active Session History (ASH) Optimizer Statistics Optimizer Statistics Overview Table and Index Statistics Statistic Preferences Statistics Gathering e) Locking Statistics, Export/Import Statistics Pending and published statistics Optimizer Hints Optimizer Paths Cost Base Optimization Monitoring a Service Overview of what is an Oracle Service Creating an Oracle Service for Single instance and RAC Monitoring a Service Resource Management and a Service Enterprise Manager and a Service Bind Variables and database parameters Bind variable definition Cursor_sharing parameter Adaptive Cursor Sharing Oracle's Real Application Testing (RAT) Sql Performance Analyzer overview Sql Performance Analyzer Options Database Parameter changes Database version changes Creating SQL Tuning Sets Database Replay Overview Database Replay Configuration Database Replay Options SQL Tuning Advisor SQL Tuning Advisor: Overview SQL Tuning Advisor Limited Mode Sql Tuning Advisor Comprehensive mode Sql Tuning Profiles SQL Access Advisor SQL Access Advisor: Overview Sql Access Advisor options SQL Access Advisor and Sql Tuning Sets Sql Access Advisor and AWR Results and Implementation Automatic Sql Tuning Automatic Sql Tuning Maintenance Task Automatic Tuning Optimization implementation(ATO) Automatic Tuning Optimization Results Enable/Disable Automatic Tuning Optimization Sql Plan Management Sql plan Management and baseline overview Enable sql plan management Loading Sql Plan baselines into the SGA Adaptive plan management Shared Pool Tuning Shared pool architecture Shared pool parameters Library Cache Dictionary cache Large pool considerations and contents Tuning the database buffer cache Database buffer cache overview Database buffer cache parameters Oracle and Dirty reads and writes Automatic Shared Memory Management (ASMM) Buffer Cache goals and responsibility Buffer Cache pools Tuning the PGA (Program Global Area) PGA Overview PGA Database Parameters Temporary Segments Temporary Tablespace Sizing the PGA Automatic Memory Management (AMM) Oracle's Automatic Memory Management Overview Database Auto-tuned Parameters Database Non Auto-tuned Parameters Automatic Memory Management Hints and Sizing suggestions AMM versus ASMM Tuning Segment Space Utilization (ASSM) Overview of Automatic Segment Space Management Defining the DB_BLOCK_SIZE Defining DB_nk_CACHE_SIZE parameter The DB_BLOCK_SIZE Parameter Overview of table compression, block chaining, and block migration Automatic Storage Management Overview of ASM Definition of Grid Infrastructure ASM Instance ASM Diskgroups ASM Diskgroup parameters and templates ASMCMD

Level 5 QLS Endorsed Diploma | 150 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Level 5 QLS Endorsed Diploma | 150 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Estate Agent Diploma Course Overview The Estate Agent Diploma is designed for individuals looking to develop a comprehensive understanding of the property industry. This course covers key areas such as property law, valuation techniques, and the process of buying and selling properties. Learners will gain insight into the daily responsibilities of estate agents, including client relations, property marketing, and market analysis. The course offers a valuable foundation for those looking to enter the real estate sector, providing the knowledge required to pursue a career as an estate agent. By the end of the course, learners will be equipped with the essential skills needed to navigate the property market with confidence. Course Description This diploma course offers in-depth coverage of various aspects of estate agency work, including property laws, valuation practices, and the sale and purchase process. Learners will explore topics such as client communication, marketing strategies, and legal obligations, ensuring they have a well-rounded knowledge of the industry. The course materials are structured to provide a clear understanding of market trends, the role of estate agents, and customer service in real estate. Throughout the course, learners will gain the skills necessary to work effectively in the property sector, including key insights into the regulatory environment and professional ethics. Estate Agent Diploma Curriculum Module 01: Introduction to Estate Agency Module 02: Property Law and Regulations Module 03: Understanding Property Valuation Module 04: The Buying and Selling Process Module 05: Marketing and Advertising Properties Module 06: Client Communication and Negotiation Module 07: Managing Property Listings and Viewings Module 08: Professional Ethics and Industry Standards (See full curriculum) Who is this course for? Individuals seeking to pursue a career in estate agency. Professionals aiming to enhance their skills in property sales and management. Beginners with an interest in the property industry. Those looking to understand the legal and regulatory aspects of property transactions. Career Path Estate Agent Property Manager Lettings Agent Real Estate Consultant Property Sales Negotiator

Legal Secretary and Office Skills Diploma Course Overview The Legal Secretary and Office Skills Diploma is a comprehensive course designed for those aiming to pursue a career as a legal secretary or administrative professional. This course covers a wide range of essential office skills and legal secretarial duties, offering a strong foundation in the tools and techniques needed to succeed in the office environment. Learners will gain proficiency in Microsoft Office tools, including Word, PowerPoint, Outlook, and Excel, as well as essential knowledge of legal office practices. Upon completion, learners will be well-equipped to manage office operations, handle legal documentation, and assist with legal professionals' administrative tasks, enhancing their career prospects in both the legal and administrative fields. Course Description This diploma provides a structured learning experience, covering essential topics such as legal secretary duties, and Microsoft Office tools, including Word, PowerPoint, Outlook, and Excel. Learners will explore essential office management techniques, including document preparation, managing correspondence, organising meetings, and understanding legal terminology. The course also introduces top Excel keyboard shortcuts to boost efficiency in document management and office tasks. As learners progress through the modules, they will gain key skills required to assist legal teams in their day-to-day operations. The course is designed for those looking to enter the legal, administrative, or office management fields and offers in-depth exposure to both the technical and professional skills that employers seek. Legal Secretary and Office Skills Diploma Curriculum Module 01: Legal Secretary Module 02: Microsoft Word Essentials Module 03: Microsoft PowerPoint Essentials Module 04: Microsoft Outlook Essentials Module 05: Microsoft Excel - Top 50 Keyboard Shortcuts (See full curriculum) Who is this course for? Individuals seeking to become proficient in legal secretary and office management roles. Professionals aiming to advance in administrative careers within the legal sector. Beginners with an interest in learning essential office skills and legal office practices. Those who wish to work in law firms or corporate legal departments. Career Path Legal Secretary Office Administrator Executive Assistant Paralegal Administrative Assistant in Law Firms Office Manager in Corporate Settings

Flappy Bird Clone: Cocos2d-x C++ Game Course Overview: This course provides a comprehensive introduction to game development using Cocos2d-x and C++. Learners will create a fully functional Flappy Bird clone, mastering the fundamentals of game mechanics, user interface design, and game physics. The course covers essential topics in object-oriented programming, handling user input, collision detection, and scene management. By the end, learners will have the knowledge to design and develop their own 2D games, making this course an excellent starting point for anyone interested in game development. The practical value lies in learning how to implement complex game features, which can be used in future projects or professional roles. Course Description: In this course, learners will dive into the process of developing a 2D game using C++ and Cocos2d-x. Starting with the basics of game creation, the course introduces essential programming concepts including classes, object handling, and event-driven programming. Key topics include building the game environment, implementing gravity and jump mechanics, handling user inputs, and managing game scenes. Learners will also focus on game physics such as collision detection and the continuous movement of the game elements. The course encourages learners to break down complex game features into manageable components while using a leading game engine. By the end of the course, participants will be equipped with a strong foundation in game programming and the skills needed to create their own games. Flappy Bird Clone: Cocos2d-x C++ Game Curriculum: Module 01: Introduction to Cocos2d-x and C++ (See full curriculum) Who is this course for? Individuals seeking to start a career in game development Professionals aiming to enhance their programming and game design skills Beginners with an interest in learning game development Aspiring developers looking to create their own 2D games Career Path Junior Game Developer Game Programmer Game Designer Mobile Game Developer Software Developer in the gaming industry

Parenting Skills Training Course Course Overview The Parenting Skills Training Course provides essential knowledge and strategies for parents, caregivers, and professionals working with families. This comprehensive course covers key aspects of parenting, including child development, communication techniques, managing challenging behaviours, and supporting emotional and social growth. Learners will gain valuable insights into building positive relationships with children and fostering a nurturing environment at home. The course aims to equip participants with effective strategies to handle a variety of parenting challenges and enhance their understanding of children's needs. By the end of the course, learners will be prepared to apply their newfound skills in real-world situations, improving family dynamics and child well-being. Course Description This course covers a wide range of topics aimed at enhancing parenting skills and improving the relationship between parents and children. Participants will explore child development stages, effective communication techniques, positive discipline strategies, and methods to support children's emotional health. The course also focuses on understanding children's behaviour, managing conflicts, and fostering resilience. Throughout the course, learners will engage in detailed discussions and scenarios, providing a deeper understanding of the complexities of parenting. By the end of the course, learners will have developed skills to confidently manage challenging situations and promote the well-being of children in their care. Parenting Skills Training Course Curriculum Module 01: Introduction to Parenting Styles and Child Development Module 02: Building Positive Parent-Child Relationships Module 03: Effective Communication Techniques Module 04: Managing Challenging Behaviours Module 05: Supporting Emotional and Social Development Module 06: Discipline Strategies and Behaviour Management Module 07: Managing Stress and Self-Care for Parents Module 08: Promoting Resilience and Positive Mental Health Module 09: Parenting in Diverse Family Dynamics (See full curriculum) Who is this course for? Individuals seeking to improve their parenting skills Professionals aiming to work in family support and child welfare Beginners with an interest in child development Caregivers looking to enhance their child-rearing practices Career Path Family Support Worker Childcare Specialist Parent Educator Social Worker Educational Support Assistant

Marketing Strategies for Business Course Overview This course offers a comprehensive exploration of marketing strategies essential for business growth and competitive advantage. Learners will gain insight into analysing current market positions, defining strategic goals, and developing effective go-to-market plans. Emphasising the integration of theory and strategic planning, the course equips participants with the ability to design and implement marketing initiatives that drive success. Through structured learning, individuals will develop critical thinking skills to evaluate market opportunities, understand customer needs, and align marketing efforts with broader business objectives. This course is designed to empower learners with the knowledge and confidence to contribute meaningfully to marketing strategy development in various business contexts. Course Description Delving deeper into core marketing concepts, this course covers strategic analysis of the current market environment, goal setting for future positioning, and detailed approaches to launching marketing campaigns. Learners will engage with topics such as market segmentation, competitive analysis, brand positioning, and the execution of marketing plans that ensure measurable outcomes. The learning experience emphasises strategic decision-making, fostering skills in assessing market trends and consumer behaviour. Participants will be equipped to formulate coherent marketing strategies that align with organisational aims, enhancing business growth and sustainability. Throughout, the course maintains a professional and informative tone, suitable for those seeking to develop expertise in marketing within diverse industries. Marketing Strategies for Business Curriculum Module 01: Welcome Module 02: Strategic Outline: Where Are We Now? Module 03: Strategic Outline: Where Do We Want to Be? Module 04: It’s Time to Go to Market Module 05: Ensure Success (See full curriculum) Who Is This Course For? Individuals seeking to understand core marketing strategy principles Professionals aiming to enhance strategic marketing skills for career progression Beginners with an interest in marketing and business development Entrepreneurs looking to improve market positioning and customer engagement Career Path Marketing Coordinator Business Development Executive Brand Strategist Market Research Analyst Marketing Consultant

Learn to Level Up Your Leadership Course Overview "Learn to Level Up Your Leadership" is designed for individuals who want to enhance their leadership capabilities and navigate the challenges of leading teams. This course delves into essential leadership concepts such as decision-making, communication, and team management. Learners will gain a solid understanding of leadership styles, conflict resolution, and how to motivate and inspire their teams. By the end of the course, learners will be equipped to lead more effectively, build trust, and foster a positive team environment, which are essential skills in today's dynamic business world. Course Description This course covers a comprehensive range of leadership topics, offering insights into modern leadership techniques and strategies. Learners will explore various leadership styles, learn the importance of emotional intelligence in leadership, and understand the core principles of team dynamics. They will also be introduced to conflict management strategies, decision-making processes, and the significance of leading with integrity. The course is designed to provide a robust foundation for individuals who wish to improve their leadership skills and grow in their professional careers. Learners will develop the skills to manage diverse teams, handle challenges, and drive organisational success. Learn to Level Up Your Leadership Curriculum Module 01: Introduction to Leadership Module 02: Leadership Styles and Approaches Module 03: Emotional Intelligence in Leadership Module 04: Effective Communication for Leaders Module 05: Decision-Making and Problem Solving Module 06: Managing and Motivating Teams Module 07: Conflict Resolution and Negotiation Module 08: Leading with Integrity and Vision (See full curriculum) Who is this course for? Individuals seeking to develop their leadership skills. Professionals aiming to advance their careers through enhanced leadership capabilities. Beginners with an interest in management or leadership roles. Aspiring managers looking to transition into leadership positions. Career Path Team Leader Project Manager Department Manager Operations Manager Leadership Consultant HR Manager Executive Role in various industries