5816 Computing courses delivered Online

Start on a transformative journey into the world of web design with our masterclass. Unleash your creative prowess and conquer the digital realm.

Mastering English and Maths is pivotal in both daily life and professional endeavors. English facilitates effective communication, enabling clear expression of ideas and successful interactions. Maths equips us with problem-solving skills and numerical literacy vital for budgeting, decision-making, and various tasks. Elevate your career prospects with our comprehensive Functional Skills Maths Level 2 & Functional Skills English course. Sharpen practical mathematical abilities, enhance language proficiency, and gain a competitive edge in the job market. Acquire skills employers highly value, boosting your employability and paving the way for personal growth and success. Invest in yourself today and reap the rewards tomorrow. 4 Exclusive Courses with 4 Free CPD Accredited PDF Certificates! Limited Time Offer!! Hurry Up and Enrol Now!!! Course 01: Functional Skills Maths Course 02: Functional Skills English Course 03: Functional Skills IT Course 04: Functional Skills Fitness This Functional Skills course starts with the basics of Functional Skills and gradually progresses towards advanced topics. Therefore, each lesson of this Functional Skills is intuitive and easy to understand. Why would you choose the Functional Skills course: Lifetime access to the Functional Skills course materials Full tutor support is available from Monday to Friday with the Functional Skills course Learn Functional Skills at your own pace from the comfort of your home Gain a complete understanding of the Functional Skills course Accessible, informative learning Functional Skills course modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Functional Skills course Study Functional Skills in your own time through your computer, tablet or mobile devic A 100% learning satisfaction guarantee with your Functional Skills course Curriculum Breakdown of the Functional Skills (Maths, English, IT & Fitness) Level 2 Bundle Take a look at the training modules of the Functional Skills Maths Level 2 Numbers and Negative Numbers Multiples Factors Fractions and Power Percentages Expressions Decimals Ratio and Proportion Exponents and Radicals Graphs The Profit and Loss Perimeter and Area Averages Probability Take a look at the training modules of the Functional Skills English Level 2 Basics of Grammar The Basics of Sentence Structure of Sentence Punctuation & Capitalisation Spelling Take a look at the training modules of the Functional Skills IT How People Use Computers System Hardware Device Ports and Peripherals Data Storage and Sharing Understanding Operating Systems Setting Up and Configuring a PC Setting Up and Configuring a Mobile Device Managing Files Using and Managing Application Software IT Security Threat Mitigation Computer Maintenance and Management IT Troubleshooting Understanding Databases Take a look at the training modules of the Functional Skills Fitness Introduction Introduction To Functional Fitness Training What Is Functional Fitness Benefits Of Functional Fitness Benefits Of Functional Fitness Functional Fitness & Other Exercises Common Mistakes With Functional Fitness Functional Fitness Training Areas Functional Fitness & Power Functional Fitness & Strength Functional Fitness & Range Of Motion Functional Fitness & Balance & Endurance Conclusion to Functional Fitness Training Conclusion CPD 40 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Functional Skills course. Requirements To enrol in this Functional Skills course, all you need is a basic understanding of the English Language and an internet connection. Career path The Functional Skills (Maths, English, IT & Fitness) Level 2 bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Functional Skills (Maths, English, IT & Fitness) Level 2 are following- Teacher of Mathematics Teacher of English Teacher of IT Mathematics/ English/ IT Lecturer SEND Maths/ English/ IT Teacher Functional Skills Tutor Certificates CDP Accerdited PDF Certificate Digital certificate - Included 4 CPD Accredited PDF Certificates for Free CPD Accredited Hardcopy Certificate Hard copy certificate - £9.99 Delivery Charge Inside the UK: Free Outside the UK: £9.99 for each.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is as follows - IT Staff and Managers - Network and systems personnel and engineers - Small to mid-sized organizations that require fundamental knowledge on networking terms/concepts and configuration guidance for Meraki equipment This also includes organizations looking to implement remote sites, provide a guest wireless solution, and collect user analytics Overview Upon completing this course, the student will be able to meet these objectives: Students will be able to Deploy and Manage a Meraki Network using the Meraki Dashboard - Deploy, Manage, Monitor and Troubleshoot Meraki MS Switches - Deploy, Manage, Monitor and Troubleshoot Meraki MR Wireless Access Points - Deploy, Manage, Monitor and Troubleshoot Meraki MX Firewall Appliances - Deploy, Manage, Monitor and Troubleshoot Meraki MV IP Video Cameras - Deploy, Manage, Monitor and Troubleshoot Meraki MC Phones - Deploy, Manage, Monitor and Troubleshoot Meraki Systems Manager - Deploy, Manage, Monitor and Troubleshoot Meraki SDWAN This course familiarizes individuals with networking concepts and demonstrates how to effectively use Meraki products to build a comprehensive network Cisco/Meraki Product Line Introduction MS - Switching MR - Wireless LAN MX - Security MV ? Camera MC - Voice SD-WAN Cisco/Meraki Cloud Management Introduction to cloud management The dashboard and navigation Organizations & Networks ? what is the difference and how to use them System-wide parameters (organization parameters) Cisco/Meraki Dashboard Administration Creating and implementing maps Summary Report and Auto Generation Reports Adding administrators and tweaking security levels Using Tags and Configuring Alerting (SNMP, email) Adding admins, configuring reports, and alerts Firmware Management Configuring Authentication Lab 1 Lab 2 Configuring external authentication Configuring Group Policies Device Replacement Location Analytics Other advanced analytics Cisco/Meraki Switching Review switching basics Review Meraki L2 Switch Models Configuring Meraki Switches Troubleshooting / Diagnostics Lab 3 Cisco/Meraki Routing Review routing basic (IP Addresses, Networks and Masks, OSPF, etc.) Review Meraki L3 switch Models Configuring Meraki Switches for Routing Lab 4 Cisco/Meraki Wireless Review Wireless Basics Meraki Wireless Product Review Performing a Site Survey Configuring Access Points Lab 5 Cisco/Meraki Firewalls/Security Review firewall basics Meraki Firewall Model Review Configuring a Meraki Firewall Lab 6 IP Cameras MV21 vs MV71 Installing Cameras Adding Cameras to the Dashboard Managing MV Cameras Troubleshooting Cameras Lab 7 Meraki Communications QOS Voice Security Deploying Meraki MC74 Phones Deploying Cisco IP Phones to CUCM Deploying Voice Features End User Lab 8 Meraki Systems Manager Controlling Wireless Device Policies Enrolling Devices Apps Profiles Tags Security Policies Geofencing Policies Lab 9 Meraki SDWAN What is SD-WAN? Concentrator Mode VPN Topology Split Tunnel Full Tunnel Hub and Spoke VPN Mesh Datacenter Redundancy (DC-DC Failover) Warm Spare (High Availability) for VPN concentrators Connection Monitor Dual-Active VPN uplinks Policy-based Routing Dynamic Path Selection SD-WAN Objectives Example Topology High Level Traffic Flow SD-WAN Technologies Deploying a one-armed concentrator Dashboard Configuration Other Datacenter Configuration MX IP Assignment Upstream Considerations Datacenter Redundancy (DC-DC Failover) High-level architecture Failover Times Datacenter Deployment Branch Deployment Lab 10 Meraki Support Getting support for Meraki Finding the Right Documentation Posting in the Community Troubleshooting Meraki Connectivity Issues Resetting Devices. Additional course details: Nexus Humans Implementing and Configuring Meraki Technologies v1.0 (ICMT - CT) 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 Implementing and Configuring Meraki Technologies v1.0 (ICMT - CT) 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 2 Days 12 CPD hours This course is intended for The target audience for the DevOps Engineering Foundation course are individuals involved in engineering and technical practices such as: DevOps Practice owners and process designers Developers, QA engineers and Managers who are interested in understanding how DevOps works. Employees and managers responsible for engineering or improving processes. Consultants guiding their clients through process improvement and DevOps initiatives. Anyone responsible for: Managing process-related requirements Ensuring the efficiency and effectiveness of processes Maximizing the value of processes Overview The learning objectives for DevOps Engineering Foundation include an understanding of: How to engineer DevOps solutions DevOps Technologies Applications Architectures Continuous Integration Continuous Testing Ephemeral Elastic Infrastructures Continuous Delivery and Deployment Metrics, Monitoring, Observability and Governance DevOps Humans Future Trends This course explains the many aspects of DevOps engineering that leaders and practitioners can execute upon. While DevOps Foundation provides an overview of DevOps, this course will provide a closer look at the implementation process from an engineering perspective. It is an in depth view of the major aspects of engineering DevOps. An engineering approach is critical to DevOps journeys. This course provides the foundations of knowledge, principles and practices from a technical perspective needed to engineer a successful DevOps solution. DevOps Engineering Introduction DevOps Foundations Principles and Practices Related Frameworks Performance and Benefits DevOps Technology Source and Artifacts Control CI/CD pipelines Tools and Toolchains Application Release Automation Value Stream Management Applications Architectures and Continuous Integration Application Architectures Containers Continuous integration Continuous Testing CT Tenets Test creation & TDD Test acceleration Test results Test management Test environment management Ephemeral Elastic Infrastructures Virtual and Cloud Configuration management Infra-as-code Containers Orchestration GitOps Continuous Delivery and Deployment Continuous Delivery and Deployment Release Automation Deployment Strategies Metrics, Monitoring, Observability, Governance DevOps Metrics Monitoring Observability Governance DevOps Engineering Humans Culture Team Topologies Continuous Learning Future DevOps Trends Additional course details: Nexus Humans DevOps Engineering Foundation (DevOps Institute) 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 DevOps Engineering Foundation (DevOps Institute) 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 4 Days 24 CPD hours This course is intended for Application Consultant Data Consultant / Manager Developer Consultant Technology Consultant Program / Project Manager Business Analyst Developer User Business Process Owner / Team Lead / Power User Overview This course will prepare you to: Outline SAP Transportation Management business processes Identify and examine the SAP TM building blocks necessary for processing shipments of goods. Engage in Transportation network maintenance, order/requirements integration and management, transportation planning, shipment execution, and freight invoicing and settlement. Use both the SAP ERP and SAP TM systems using the NetWeaver Business Client interface This course will help you to prepare for the blueprinting stage of your SAP Transportation Management implementation or enable you to use the system in your role as a business user. You will gain an overview of the key business transactions and system capabilities to enable you to design the processes you will use within your own organization. You will learn how SAP TM can help you to support Order Management, Transportation Planning, Subcontracting, Execution, Charge Calculation and Settlement. This course is the mandatory foundational prerequisite for all follow-on SAP TM training courses. SAP Transportation Management (SAP TM) Evaluating SAP Transportation Management Evaluating the SAP TM System Landscape SAP TM User Interface Identifying NetWeaver Business Client Components Personalizing Object Worklists Transportation Management Master Data Identifying Master Data Requirements for SAP TM Evaluating the Organizational Structures Used in SAP TM Defining Conditions Determining Freight Incompatibilities Determining Dangerous Goods Shipping Requirements Transportation Order Management Triggering the Transportation Management Process Integrating SAP ERP with SAP TM Managing the Freight Forwarding Process Booking Capacities Transportation Planning Defining the Transportation Planning Process Viewing Freight Units Building Packages Defining Selection Profiles Determining Planning Profiles Accessing the Transportation Cockpit Creating Transportation Proposals Creating Freight Orders Optimizing Loads Transportation Execution Performing Carrier Selection Tendering Freight Orders Triggering Delivery Creation from SAP TM Executing Transportation in SAP ERP Integration between SAP TM and SAP EWM Generating Outputs Monitoring Transportation Events Exporting Freight Orders Analyzing Transportation Management Performance Charge Calculation and Freight Settlement Managing Charge Calculation Master Data Calculating Supplier Charges in Freight Orders Settling Supplier Freight Charges Calculating and Settling Customer Charges in Forwarding Orders Distributing Costs Settling Freight Charges in Group Logistics Companies Managing Freight Contracts

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

Duration 3 Days 18 CPD hours Overview Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will explore: New Features Overview Multitenant New Features Security Features Cloud Services Networking Globalization Big Data Support Database Installation and Configuration Database Tuning Backup and Recovery Oracle 19c New Features is a hands-on course that explores the newest features such as Big Data Enhancements, Security, Multitenant features, Oracle Cloud Services, Networking, and much more. Oracle is one of the leading databases in industry today. Learn what their latest flagship product has to offer from industry experts. Oracle 19c New Features Overview Introduction to Oracle 19c New Features Oracle 19c Multitenant New Features Refreshable PDB Switchover PDB Integration with Data Guard PDB Snapshot Carousel CDB Fleet Management Oracle 19c Security Features Profile Lockdown Create a User Defined Master Encryption Key Encrypted Passwords in Database Links and Data Pump Create Keystores for Pluggable Databases Datapump and Unified Auditing Schema Only Accounts Oracle 19c Cloud Services Oracle IaaS Oracle Saas Oracle PaaS Oracle 19c Networking Database Connection Manager Database Proxy Support Tenant Isolation Oracle 19c Globalization New globalization for Bind Variables New Database Local Support Additional Unicode Support Big Data Support New Analytic Support Data Mining Data Warehouse Additional Parallel Processing Support Inline External Tables Database Installation and Configuration Zero Downtime Upgrades Dry Run Command implementation New location for Password File Improved Bulk Operations Database Tuning SQL Tuning Advisor and Exadata New SQL Tuning Set API Concurrent SQL and Sql Performance Analyzer Database In Memory Features In Memory Support for External Tables In Memory Features for Analytics Oracle 19c Backup and Recovery Active Pluggable Cloning Pluggable and non Pluggable Database Migration Additional course details: Nexus Humans Oracle 19c New Features (TTOR20019) 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 19c New Features (TTOR20019) 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

Duration 3 Days 18 CPD hours This course is intended for This course is appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands-on learning environment led by our expert pracitioner you'll learn how to: Add Data, Retrieve, Sort and Organize a SQL Database Combine Data, Set Operators and Subqueries Manipulate Data and Data Definition Languages in SQL Work with Data Dictionary Views and Create Sequences, Indexes and Views Use Database Objects and Subqueries Perform Data and access control Perform other Advanced Level Database operations. Oracle 19C SQL Programming Fundamentals Is a three-day, hands-on course designed to equip you with the fundamental skills needed to set up, run and manage SQL databases using Oracle Database Technology. You will also be discovering all the tools and concepts required to organize data efficiently. Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course, you will learn the key elements of a database, and the way Oracle systems facilitate their induction in the system. You?ll also learn the tools and strategies you can implement to store, retrieve, compare and organize data according to your requirements. You?ll also explore the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs. Adding Data, Retrieving, Sorting and Organizing a SQL Database The building blocks of a database. How to add data to the database. The process of retrieving data using SQL functions. Multiple methods of sorting and organizing data. Using SQL functions to get the required simple to complex output. Various strategies for using functions and conditions to organize data. Combining Data, Set Operators And Subqueries Consolidating data using multiple functions and group operators. Fetching intelligent data reports using simple functions. Fetching data from multiple sources in the tables. Using Subqueries to compile data as required. Using Set operators to create smart data reports. Data Manipulation and Data Definition Languages in SQL Describing and managing data transaction using Data Definition Language. Categorize and review data tables using Data Definition Language. Data Dictionary Views and Creating Sequences, Indexes and Views How to manage and query Data Dictionary Views. The process of creating and using Sequences. How to create various types of Synonyms and Indexes. Creating simple and complex views and retrieving data. Understanding and using Database Objects and Subqueries Core concept and application of Schema Objects. Fetching required data with Subqueries. Using Subqueries to organize Data in SQL. Data and access control Assigning and revoking data access. Managing data access control according to user levels. Performing Advanced Level Database operations. Using advanced functions and performing data queries. Creating and managing time zone-based databases.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for IT Professionals who deploy and manage Microsoft SharePoint and OneDrive in their organizations. Students in this course are interested in Microsoft SharePoint and OneDrive. Overview Configure SharePoint Sites. Manage sites storage limits. Deploy OneDrive sync client. Use Group Policy to control OneDrive sync client settings. Manage external sharing for data in Microsoft SharePoint and OneDrive. Configure user profile properties. Manage audiences. Use the App Catalog to manage custom apps. Create and manage term groups, term sets, and terms. Describe the difference between modern and classic search experiences. Content is the most critical digital asset for every organization. In this course, you will learn how to plan, configure, and manage SharePoint Sites and OneDrive to enable modern content services that transform the content lifecycle. Specifically, this course discusses the modern SharePoint site structure, such as SharePoint hub sites. It provides best practices for the adoption and deployment of OneDrive within your organization. It also covers sharing, security, and monitoring in SharePoint and OneDrive in Microsoft 365. Additionally, you will learn how to manage user profiles and apps with proper permission settings. We will also discuss how to plan and configure Managed Metadata, Business Connectivity Services, and search allowing content to be found, consumed, and governed across Microsoft 365. Plan and Configure SharePoint Sites Overview of SharePoint in Microsoft 365 Configure SharePoint sites Manage SharePoint site Configure and Manage OneDrive Overview of OneDrive in Microsoft 365 Deploy OneDrive Manage OneDrive Sharing and Security in SharePoint and OneDrive Manage SharePoint site permissions Manage sharing in SharePoint and OneDrive Manage security in SharePoint and OneDrive Manage User Profiles and Apps Manage User Profiles Manage apps Plan and Configure Managed Metadata and Business Connectivity Services Plan and configure Managed Metadata Plan and configure Business Connectivity Services Plan and Configure Search Plan search Configure search Additional course details: Nexus Humans MS-040T00-A Manage SharePoint and OneDrive in Microsoft 365 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 MS-040T00-A Manage SharePoint and OneDrive in Microsoft 365 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.