1521 Courses in Cardiff delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for Business Analysts, Technical Managers, and Programmers Overview This intensive training course helps students learn the practical aspects of the R programming language. The course is supplemented by many hands-on labs which allow attendees to immediately apply their theoretical knowledge in practice. Over the past few years, R has been steadily gaining popularity with business analysts, statisticians and data scientists as a tool of choice for conducting statistical analysis of data as well as supervised and unsupervised machine learning. What is R ? What is R? ? Positioning of R in the Data Science Space ? The Legal Aspects ? Microsoft R Open ? R Integrated Development Environments ? Running R ? Running RStudio ? Getting Help ? General Notes on R Commands and Statements ? Assignment Operators ? R Core Data Structures ? Assignment Example ? R Objects and Workspace ? Printing Objects ? Arithmetic Operators ? Logical Operators ? System Date and Time ? Operations ? User-defined Functions ? Control Statements ? Conditional Execution ? Repetitive Execution ? Repetitive execution ? Built-in Functions ? Summary Introduction to Functional Programming with R ? What is Functional Programming (FP)? ? Terminology: Higher-Order Functions ? A Short List of Languages that Support FP ? Functional Programming in R ? Vector and Matrix Arithmetic ? Vector Arithmetic Example ? More Examples of FP in R ? Summary Managing Your Environment ? Getting and Setting the Working Directory ? Getting the List of Files in a Directory ? The R Home Directory ? Executing External R commands ? Loading External Scripts in RStudio ? Listing Objects in Workspace ? Removing Objects in Workspace ? Saving Your Workspace in R ? Saving Your Workspace in RStudio ? Saving Your Workspace in R GUI ? Loading Your Workspace ? Diverting Output to a File ? Batch (Unattended) Processing ? Controlling Global Options ? Summary R Type System and Structures ? The R Data Types ? System Date and Time ? Formatting Date and Time ? Using the mode() Function ? R Data Structures ? What is the Type of My Data Structure? ? Creating Vectors ? Logical Vectors ? Character Vectors ? Factorization ? Multi-Mode Vectors ? The Length of the Vector ? Getting Vector Elements ? Lists ? A List with Element Names ? Extracting List Elements ? Adding to a List ? Matrix Data Structure ? Creating Matrices ? Creating Matrices with cbind() and rbind() ? Working with Data Frames ? Matrices vs Data Frames ? A Data Frame Sample ? Creating a Data Frame ? Accessing Data Cells ? Getting Info About a Data Frame ? Selecting Columns in Data Frames ? Selecting Rows in Data Frames ? Getting a Subset of a Data Frame ? Sorting (ordering) Data in Data Frames by Attribute(s) ? Editing Data Frames ? The str() Function ? Type Conversion (Coercion) ? The summary() Function ? Checking an Object's Type ? Summary Extending R ? The Base R Packages ? Loading Packages ? What is the Difference between Package and Library? ? Extending R ? The CRAN Web Site ? Extending R in R GUI ? Extending R in RStudio ? Installing and Removing Packages from Command-Line ? Summary Read-Write and Import-Export Operations in R ? Reading Data from a File into a Vector ? Example of Reading Data from a File into A Vector ? Writing Data to a File ? Example of Writing Data to a File ? Reading Data into A Data Frame ? Writing CSV Files ? Importing Data into R ? Exporting Data from R ? Summary Statistical Computing Features in R ? Statistical Computing Features ? Descriptive Statistics ? Basic Statistical Functions ? Examples of Using Basic Statistical Functions ? Non-uniformity of a Probability Distribution ? Writing Your Own skew and kurtosis Functions ? Generating Normally Distributed Random Numbers ? Generating Uniformly Distributed Random Numbers ? Using the summary() Function ? Math Functions Used in Data Analysis ? Examples of Using Math Functions ? Correlations ? Correlation Example ? Testing Correlation Coefficient for Significance ? The cor.test() Function ? The cor.test() Example ? Regression Analysis ? Types of Regression ? Simple Linear Regression Model ? Least-Squares Method (LSM) ? LSM Assumptions ? Fitting Linear Regression Models in R ? Example of Using lm() ? Confidence Intervals for Model Parameters ? Example of Using lm() with a Data Frame ? Regression Models in Excel ? Multiple Regression Analysis ? Summary Data Manipulation and Transformation in R ? Applying Functions to Matrices and Data Frames ? The apply() Function ? Using apply() ? Using apply() with a User-Defined Function ? apply() Variants ? Using tapply() ? Adding a Column to a Data Frame ? Dropping A Column in a Data Frame ? The attach() and detach() Functions ? Sampling ? Using sample() for Generating Labels ? Set Operations ? Example of Using Set Operations ? The dplyr Package ? Object Masking (Shadowing) Considerations ? Getting More Information on dplyr in RStudio ? The search() or searchpaths() Functions ? Handling Large Data Sets in R with the data.table Package ? The fread() and fwrite() functions from the data.table Package ? Using the Data Table Structure ? Summary Data Visualization in R ? Data Visualization ? Data Visualization in R ? The ggplot2 Data Visualization Package ? Creating Bar Plots in R ? Creating Horizontal Bar Plots ? Using barplot() with Matrices ? Using barplot() with Matrices Example ? Customizing Plots ? Histograms in R ? Building Histograms with hist() ? Example of using hist() ? Pie Charts in R ? Examples of using pie() ? Generic X-Y Plotting ? Examples of the plot() function ? Dot Plots in R ? Saving Your Work ? Supported Export Options ? Plots in RStudio ? Saving a Plot as an Image ? Summary Using R Efficiently ? Object Memory Allocation Considerations ? Garbage Collection ? Finding Out About Loaded Packages ? Using the conflicts() Function ? Getting Information About the Object Source Package with the pryr Package ? Using the where() Function from the pryr Package ? Timing Your Code ? Timing Your Code with system.time() ? Timing Your Code with System.time() ? Sleeping a Program ? Handling Large Data Sets in R with the data.table Package ? Passing System-Level Parameters to R ? Summary Lab Exercises Lab 1 - Getting Started with R Lab 2 - Learning the R Type System and Structures Lab 3 - Read and Write Operations in R Lab 4 - Data Import and Export in R Lab 5 - k-Nearest Neighbors Algorithm Lab 6 - Creating Your Own Statistical Functions Lab 7 - Simple Linear Regression Lab 8 - Monte-Carlo Simulation (Method) Lab 9 - Data Processing with R Lab 10 - Using R Graphics Package Lab 11 - Using R Efficiently

Historical Association webinar series: Draft Ofsted toolkits; implications for primary history Presenter: Dan Hartley This session will look at ways teachers can be supported to build their confidence, expertise and subject knowledge in primary history. It will also explore how subject leaders can develop their own expertise in leading history, including ideas for extending their professional development beyond their own school.   To use your corporate webinar offer for this webinar please complete this form: https://forms.office.com/e/qG8gK0CU8X

Duration 2 Days 12 CPD hours This course is intended for This course is intended for anyone who is responsible for day-to-day management of many FortiGate devices via the FortiManager platform. Overview Describe capabilities of FortiManager Add FortiGate devices to Device Manager and import their running configuration Use provisioning templates and scripts for device-level changes across many devices Identify the synchronization states Manage the revision history of managed devices Offer a local FortiGuard Distribution Server to your Fortinet devices Deploy administrative domains (ADOMs) to support multiple customers on a single FortiManager Manage firewall policies across multiple FortiGate devices using policy packages with shared and dynamic objects Deploy policies and objects from the global ADOM to multiple ADOMs Explain high availability, backup, and recovery options for FortiManager Compare methods for centrally managing IPsec VPNs Explain the restricted ''admin'' profile and API high-level usage Use workspaces and workflow mode Identify steps to replace a managed FortiGate device Manage FortiGate devices' firmware centrally In this 2-day class, you will learn the fundamentals of using FortiManager for centralized network administration of many FortiGate devices. Example use cases include large enterprise and carrier networks. Course Outline Module1 - Introduction and Initial Configuration Module2 - Administration and Management Module3 - Device Registration Module4 - Device Level Configuration and Installation Module5 - Policy and Objects Module6 - Manager Panes Module7 - Diagnostics and Troubleshooting Module8 - Advanced Configuration Additional course details: Nexus Humans FortiManager 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 FortiManager 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 1 Days 6 CPD hours This course is intended for Multi-role (consumers, business authors, professional authors, developers, administrators, modelers, project managers) This course provides students with an overview of the IBM Cognos Analytics suite of products and their underlying architecture. Students will examine each component as it relates to an Analytics solution & will be shown a range of resources. IBM Cognos Analytics Describe IBM Cognos Analytics Describe IBM Cognos Analytics components Describe IBM Cognos architecture at a high level Describe IBM Cognos security at a high level Consume Content in IBM Cognos Analytics Where do consumers access BI content? Use published reports Drill through to related data Specify run report options Specify properties of an entry Alerts and Watch Items Create Reports in IBM Cognos Analytics Overview of reporting and report authoring Identify package types, uploaded files, and data modules available for reporting Examine IBM Cognos Analytics - Reporting Examine the interface Explore different report types Create a simple, sorted, and formatted report Create a report view Create a subscription Create an Active Report Import and report on personal data Create Dashboards in IBM Cognos Analytics Describe IBM Cognos Dashboarding Identify the IBM Cognos Dashboarding user interface Add report content and tools to create dashboards Widget-to-widget communication Filter data in the dashboard Sort, group and ungroup, and calculate data Create Metadata Models in IBM Cognos Analytics Define IBM Cognos Framework Manager and its purpose Describe the IBM Cognos Framework Manager environment Describe IBM Cognos Cube Designer Get high-level content from Dynamic Cubes course and/or FM course Web-based Modeling Create Data Modules Extend IBM Cognos Analytics Introduction to IBM Cognos Mobile Key features Examine Cognos Mobile architecture Identify supported products Introduction to IBM Cognos BI for Microsoft Office Describe Cognos Analysis for Excel (CAF) Compare IBM Cognos Analytics & IBM Cognos BI New features in IBM Cognos Analytics Changes from IBM Cognos BI to IBM Cognos Analytics Legacy option Examine Event Studio Examine the role of Event Studio in Performance Management List the benefits of Event Studio Examine Metric Studio Identify scorecards, metrics, and metric types Organize metrics with strategies Track initiatives with projects

Who is this course for? Advanced 3ds Max and After Effects Masterclass. This course is designed for 3D artists, animators, and visual effects artists seeking comprehensive training in 3ds Max and After Effects. Whether you're a beginner or an intermediate learner, this course provides skills and techniques for creating stunning 3D models and captivating visual effects. Check our Website Duration: 10 hours Training Approach: 1-on-1 Sessions and Tailored Content. When: Book anyday Mon to Sat between 9 am and 7 pm. Course Title: Motion Graphics Mastery: 3ds Max and After Effects Duration: 10 hours Course Highlights: Introduction to 3ds Max: Get acquainted with the 3ds Max interface Create captivating 3D objects and scenes Explore cameras, lighting, materials, and textures Basic Animation Principles in 3ds Max: Grasp keyframes and interpolation techniques Craft seamless animation cycles for 3D objects Apply animation principles with precision using the graph editor Advanced Animation Techniques in 3ds Max: Master custom controllers and expressions for intricate animations Utilize inverse kinematics for lifelike motion Create dynamic particle systems and simulations for realistic effects Exporting 3D Scenes to After Effects: Prepare 3D scenes for seamless export Effortlessly import 3D scenes into After Effects Explore 3D layer properties for depth and realism Basic Compositing in After Effects: Navigate the After Effects interface with confidence Utilize keyframes and animation curves for smooth transitions Blend 2D and 3D elements seamlessly Apply a variety of effects and filters for added visual impact Advanced Compositing Techniques in After Effects: Employ masks and mattes for precision and creative effects Harness the power of 3D camera tracking for realistic integration Work with green screen footage for professional compositions Create breathtaking special effects that captivate the audience Integrating 3D and Live-Action Footage in After Effects: Match camera angles and movements seamlessly Incorporate 3D camera data for dynamic compositions Add shadows and reflections to enhance realism Rendering and Outputting Animations: Efficiently render 3D scenes from 3ds Max Utilize the After Effects render queue for optimized output Export animations in various formats tailored to specific needs Motion Graphics Projects: Craft a fundamental motion graphics sequence Design a captivating animated logo Create an engaging animated title sequence that captures attention Course Requirements: Computer with 3ds Max and After Effects software installed Basic understanding of computer operations Enthusiasm for exploring the world of motion graphics and animation Upon completing the Motion Graphics Mastery: 3ds Max and After Effects course, participants will: Master 3D Animation: Gain expertise in creating intricate 3D objects, scenes, and animations in 3ds Max, applying advanced animation principles and techniques. Seamless Integration: Learn to seamlessly export 3D scenes from 3ds Max to After Effects, effectively blending 2D and 3D elements for dynamic compositions. Advanced Compositing: Acquire advanced compositing skills, including the use of masks, mattes, 3D camera tracking, and green screen techniques to create professional-grade visual effects. Professional Rendering: Understand the process of rendering 3D scenes and animations, ensuring optimal quality for various output formats. Motion Graphics Projects: Develop practical motion graphics projects, including motion sequences, animated logos, and title sequences, showcasing creativity and technical proficiency. Creative Problem-Solving: Enhance problem-solving skills through hands-on projects, allowing participants to tackle real-world motion graphics challenges effectively. Industry-Standard Tools: Gain proficiency in using industry-standard software tools - 3ds Max and After Effects - essential for careers in animation, visual effects, and motion graphics. Professional Portfolio: Create a compelling portfolio of motion graphics work, showcasing diverse skills and creativity, essential for professional opportunities in the field. Effective Collaboration: Develop teamwork and communication skills by collaborating on motion graphics projects, fostering a collaborative and creative working environment. Confidence and Expertise: Build confidence in applying animation principles, compositing techniques, and visual effects skills, enabling participants to approach complex projects with confidence and creativity. Download Adobe After Effects. Download Autodesk 3ds max. Skills Acquired: Advanced 3D Modeling: Master the intricacies of 3D object creation and manipulation in 3ds Max. Visual Effects Creation: Learn the art of crafting compelling visual effects using After Effects. Texturing and Lighting: Understand texturing techniques and lighting principles for realistic 3D scenes. Animation Techniques: Develop skills in animating 3D models and adding dynamic motion to visual effects. Job Opportunities: 3D Modeler: Create detailed and realistic 3D models for various industries. Visual Effects Artist: Work in film, TV, or advertising, creating stunning visual effects sequences. Motion Graphics Designer: Design animated graphics and visual elements for videos and multimedia projects. Game Designer: Contribute to game development by creating 3D assets and visual effects. Video Editor: Enhance videos with professional visual effects and animations. Step into Personalized Learning! Why Us? Discover the Advantages: Tailored One-on-One Training: Experience individualized coaching from skilled architects and designers, either in-person at (SW96DE) or through live online sessions, available Monday to Saturday, 9 am to 7 pm. Customized Tutorials: Take home exclusive video tutorials crafted to elevate your learning experience. Comprehensive Learning Resources: Access a digital reference book for thorough revision, ensuring a deep understanding of every concept. Free Ongoing Support: Enjoy continuous post-course assistance via phone or email, ensuring your success even after class completion. Flexible Syllabus: We tailor the syllabus and projects to your specific needs, ensuring focused learning on what matters most to you. Official Certificate: Certificate upon course completion. Why Us? Individualized Learning Support: Our courses, ranging from 10 to 120 hours, offer unwavering assistance at every stage. With personalized homework assignments and free post-course support, we guide you toward mastering software with unmatched expertise. Personal Attention, No Crowded Classrooms: Bid farewell to overcrowded classrooms. Experience the intimacy of one-on-one learning, ensuring you receive the undivided attention you deserve in a confident and comfortable environment. Financial Flexibility: Embarking on your educational journey shouldn't strain your finances. We offer diverse payment plans tailored to your needs. Explore available options and begin your learning adventure today. Expert Instructors, Real-world Experience: Our instructors, chosen for their industry expertise and passion for teaching, are dedicated to imparting invaluable skills to eager learners.

Duration 2 Days 12 CPD hours This course is intended for Server administrators Network engineers Systems engineers Consulting systems engineers Technical solutions architects Network administrators Storage administrators Network managers Sales engineers Cisco integrators and partners Overview After taking this course, you should be able to: Describe Cisco UCS server hardware Describe Cisco UCS connectivity Describe the Cisco HyperFlex Data Platform, its data writing and reading processes, and data optimization Describe and configure Cisco UCS service profiles Describe and configure Cisco UCS service profile templates Describe and implement iSCSI on Cisco UCS Describe and implement Cisco UCS firmware updates Describe and implement Cisco UCS backups This introductory course shows you how to deploy, secure, operate and maintain the Cisco Unified Computing system (Cisco UCS) B-Series blade server, Cisco UCS C-Series and S-Series rack servers, and Cisco HyperFlex product family, for use in data centers. Describing Cisco UCS Server Hardware Cisco UCS B-Series Blade Servers Cisco UCS C-Series Rack Servers Cisco UCS S-Series Rack Servers Cisco Virtual Interface Cards Hyperconvergence Overview Cisco HyperFlex HX-Series Servers Describing Cisco UCS Connectivity Cisco UCS Fabric Interconnect Cisco UCS B-Series Connectivity Cisco UCS C-Series Connectivity Cisco UCS S-Series Connectivity Cisco HyperFlex Connectivity Architecture Cisco HyperFlex Edge Connectivity Ethernet End-Host Mode Compared to Switching Mode Cisco UCS Fabric Interconnect Uplink Pinning Cisco UCS C-Series Integration Describing the Cisco HyperFlex HX Data Platform Cisco HyperFlex HX Data Platform Software Writing Data to Cisco HyperFlex HX Data Platform Reading Data from Cisco HyperFlex HX Data Platform Data Optimization in Cisco HyperFlex HX Data Platform Configuring Cisco UCS Service Profiles Portability Issue with Nonabstracted Identities Cisco UCS Service Profile Identity Pools Server Pools IP Pools Configuring Cisco UCS Service Profile Templates Service Profile Templates Implementing iSCSI on Cisco UCS iSCSI Addressing Evolution of SCSI from DAS to SAN iSCSI Multipathing Implementing Cisco UCS Firmware Updates Update Cisco UCS C-Series Server Firmware Download Tasks for the Infrastructure Image Download Tasks for Cisco UCS B-Series Firmware Packages Best Practices for Updating Firmware in Cisco UCS Manager Firmware Upgrades Using Auto Install Capability Catalog Updates Host Firmware Packages Driver Updates for Operating Systems and Hypervisors Implementing Cisco UCS Backups Compare Backup Options in Cisco UCS Manager Compare Two Import Types Policy Backup

Duration 2 Days 12 CPD hours Whether you are already an instructional designer or just looking to get into the world of developing eLearning courses, this two-day course covers the full feature set of Articulate Storyline 360 and uses real world exercises to create projects from scratch. The course will include how to add interactivity to your slides via buttons, triggers, text entry areas, and hotspots. You'll also learn how to create quizzes, and how to publish your eLearning projects for the widest possible audience. The class will also explore Articulate Storyline's advance techniques and methods on Themes & Templates, Custom Navigation, Gamification, Advanced Quizzing, Accessibility and Reporting, and more. Exploring Articulate Storyline Explore a Finished Storyline Project Explore Slides and Panels Zoom and Magnify Explore Panels Preview the Entire Project Creating Projects Create a New Project Apply a Theme Apply a Content Master Slide Insert New Slides Create a New Content Master Slide Apply a Different Master Slide Layout to a Slide Import Content From PowerPoint Adding Content Create and Format a Text Box Work with a List Add an Image to a Slide Add a Shape to a Slide Customize a Shape Insert a Character Insert a Caption Interactivity Add Buttons to Slides Change Button States Create Layers Insert a Text Entry Field Triggers and Hotspots Delete Default Triggers Add a Trigger to a Button Hide Player Buttons Add Triggers to Layers Add a Hide Layer Trigger Add a Slide Trigger Add a Conditional Trigger Edit a Trigger Add a Hotspot and Lightbox Trigger Variables Manage a Variable Reference a Variable Create a Variable Manipulate a Variable with a Trigger Create a True/False Variable Create a Trigger to Change a True/False Variable Add a Condition to an Existing Trigger Play Audio with a Conditional Trigger Add a Condition to a Button Audio, Animation and Video Add Voiceover Audio to a Slide Change Slide Audio Edit Slide Audio Add Silence Record Voiceover Audio Control Object Timing Animate an Object Control Animation Options Insert Video Delay Object Start Times Trim Video Animate a Video Add a Slide Transition Quizzes Insert a Multiple Choice Slide Insert a Matching Drag-and-Drop Slide Insert a Freeform Drag and Drop Quiz Slide Insert a Quiz Result Slide

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.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who want to learn the Python programming language in preparation for using Python to develop software for a wide range of applications, such as data science, machine learning, artificial intelligence, and web development. Overview In this course, you will develop simple command-line programs in Python. You will: Set up Python and develop a simple application. Declare and perform operations on simple data types, including strings, numbers, and dates. Declare and perform operations on data structures, including lists, ranges, tuples, dictionaries, and sets. Write conditional statements and loops. Define and use functions, classes, and modules. Manage files and directories through code. Deal with exceptions. Though Python has been in use for nearly thirty years, it has become one of the most popular languages for software development, particularly within the fields of data science, machine learning, artificial intelligence, and web development?all areas in which Python is widely used. Whether you're relatively new to programming, or have experience in other programming languages, this course will provide you with a comprehensive first exposure to the Python programming language that can provide you with a quick start in Python, or as the foundation for further learning. You will learn elements of the Python 3 language and development strategies by creating a complete program that performs a wide range of operations on a variety of data types, structures, and objects, implements program logic through conditional statements and loops, structures code for reusability through functions, classes, and modules, reads and writes files, and handles error conditions. Lesson 1: Setting Up Python and Developing a Simple Application Topic A: Set Up the Development Environment Topic B: Write Python Statements Topic C: Create a Python Application Topic D: Prevent Errors Lesson 2: Processing Simple Data Types Topic A: Process Strings and Integers Topic B: Process Decimals, Floats, and Mixed Number Types Lesson 3: Processing Data Structures Topic A: Process Ordered Data Structures Topic B: Process Unordered Data Structures Lesson 4: Writing Conditional Statements and Loops in Python Topic A: Write a Conditional Statement Topic B: Write a Loop Lesson 5: Structuring Code for Reuse Topic A: Define and Call a Function Topic B: Define and Instantiate a Class Topic C: Import and Use a Module Lesson 6: Writing Code to Process Files and Directories Topic A: Write to a Text File Topic B: Read from a Text File Topic C: Get the Contents of a Directory Topic D: Manage Files and Directories Lesson 7: Dealing with Exceptions Topic A: Handle Exceptions Topic B: Raise Exceptions

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases. Overview After completing this course, you will be able to: Authenticate and authorize users Assign server and database roles Authorize users to access resources Use encryption and auditing features to protect data Describe recovery models and backup strategies Backup and Restore SQL Server databases Automate database management Configure security for the SQL Server agent Manage alerts and notifications Managing SQL Server using PowerShell Trace access to SQL Server Monitor a SQL Server infrastructure Troubleshoot a SQL Server infrastructure Import and export data This course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks. This course covers content that was in retired Microsoft Course 20764: Administering a SQL Database Infrastructure. 1 - Creating advanced functions Lesson 1: Converting a command into an advanced function Lesson 2: Creating a script module Lesson 3: Defining parameter attributes and input validation Lesson 4: Writing functions that accept pipeline input Lesson 5: Producing complex pipeline output Lesson 6: Using comment-based Help Lesson 7: Using Whatif and Confirm parameters 2 - Using Microsoft .NET Framework and REST API in Windows PowerShell Lesson 1: Using .NET Framework in PowerShell Lesson 2: Using REST API in PowerShell 3 - Writing controller scripts Lesson 1: Understanding controller scripts Lesson 2: Writing controller scripts with a user interface Lesson 3: Writing controller scripts that create reports 4 - Handling script errors Lesson 1: Understanding error handling Lesson 2: Handling errors in a script 5 - Using XML, JSON, and custom-formatted data Lesson 1: Working with XML formatted data Lesson 2: Working with JSON formatted data Lesson 3: Working with custom-formatted data 6 - Enhancing server management with Desired State Configuration and Just Enough Administration Lesson 1: Implementing Desired State Configuration Lesson 2: Implementing Just Enough Administration 7 - Analyzing and debugging scripts Lesson 1: Debugging in Windows PowerShell Lesson 2: Analyzing and debugging an existing script 8 - Understanding Windows PowerShell Workflow Lesson 1: Understanding Windows PowerShell Workflows Lesson 2: Running Windows PowerShell Workflows