141 Metadata courses

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. 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 & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A 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 & Branching 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 EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & 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 & 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 Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING 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 Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS 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 AN 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? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES Additional course details: Nexus Humans Oracle 12c PL/SQL Fundamentals 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 PL/SQL Fundamentals 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 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.

Efficient ways to create professional-looking diagrams, images and screenshots Cherryleaf’s popular, and affordable, online Technical Author/technical writing course teaches you the key skills of technical writing for IT and software user documentation. It's ideal if you’re: Looking to start your career as a Technical Author, Technical Writer, or similar role Writing instructions, but you’ve never had any proper training in how to do this well You’ll gain confidence you’re approaching each writing project in the right way, and creating content that follows best practice. This technical communication course is accredited by the Institute of Scientific and Technical Communicators The Technical Author/technical writing training course’s content is accredited by the Institute of Scientific and Technical Communicators, the professional body for Technical Communicators in the United Kingdom. It is an independent assessment of the course’s quality. This course is also recommended by the Society for Technical Communication (USA), the Australian Society for Technical Communication, and the Technical Communicators Association of New Zealand to their members. Learn from the experts As well as teaching technical communication, we also create end-user documentation, Help and UI text for clients. This means every course is based on practical experience of technical writing in today’s environment. The techniques you’ll learn on this course are the same ones used by our projects team. Professional certification as a technical communicator Cherryleaf’s training courses can help you be admitted to the national professional body for technical communicators in the UK (it also has members around the world) - The Institute of Scientific and Technical Communicators (ISTC). Junior Members, Members and Fellows are certified by the ISTC through a vetting process, with Members and Fellows entitled to use the initials MISTC or FISTC after their names. Being a member of the ISTC can help in having your skills and experience recognized by others. Comments from delegates There is something new to learn for most technical authors who are in the early stages of their career. Overall, I would say that the course did benefit me, and I can see myself revisiting parts of it in the future. Emma W., ARM plc I attended a job interview which included a written exercise where I had to jot down how I would go about designing and presenting information for the users of the service unit I was applying to. I could not believe my luck, it was as if the interviewer had designed it with the contents of this course in mind, and, as a result, I got the job! Amber A. I thought it was an excellent course – very thought-provoking and useful. The exercises were enjoyable and really helped, far beyond simply reading from a book about the tasks involved in the job. And I greatly appreciate all your advice and support. Karl D. Thank you very much for all your feed-back – I’ve been reading through this as it has come in this morning. This is really useful and very much appreciated. David H. Who is this course for? This course is ideal for you if you need to: Create end-user documentation and other forms of instructional content with ease Master the fundamentals of technical writing Get a solid understanding of the Technical Author’s role. This course is ideal for more experienced technical writers who’ve never had any formal training. What is a Technical Author? Technical Authors are sometimes known as: Technical Communicators, Technical Writers, Content Developers, Information Developers and Documentarians. Based in the United States or mainland Europe? We've designed the course to work for people living all around the world. On the videos, you'll hear a lovely, clear British accent. What will I learn? In this course, we’ll take you through the process of creating technical documentation. You’ll learn and practise: The purpose and value of technical documentation (aka having an answer if people ask why you should be doing this work). The entire documentation process. We’ll explain what you need to do, from beginning to end. We cover planning, writing, editing, indexing, and production. The skills you need as a technical communicator. How to work more efficiently. This framework will help you avoid wasting time. How to work more effectively. We’ll show you how to write and design your information in a structured, useful, usable and informed way. We don’t like to overhype our courses, so here are some reasons why not to get our technical writing training course. Those are: If you have requirements for your documents to meet specific regulatory documentation standards in these industry sectors: aerospace, military, railway, or automotive. Where documentation must be written to a specific XML standard. (You’ll need to take our DITA module in our advanced course as well). If you need to write technical API documentation for developers. (You’ll need to take our API module in our advanced course as well). Apart from that, this course will help you create the user assistance for your application or product. Duration and delivery format The course comprises 15 modules in total, which you can complete at your own pace. The course modules are delivered over the Web in small, manageable video presentations. You can download the course handouts as Word or PDF files. With the time needed to complete the exercises, you will need to allocate around two days in order to complete the course. You can pause the videos at any time and return to the course at times that suit you. Your Instructor Cherryleaf Cherryleaf is a technical writing services company formed in 2002 by people with a passion for technical communication and learning development. Cherryleaf is recognised as a leader within the technical communication profession. Our staff have written articles for the Society for Technical Communication's (STC) Intercom magazine, the Institute of Scientific and Technical Communicator's Communicator journal and tekom's TCWorld magazine. They've also written books on technical communication. We've presented webinars for Adobe, Madcap Software or the STC, and we've spoken at various conferences around the world. Today, organisations throughout Europe use Cherryleaf’s services so they can provide clear information that enables users and staff to complete tasks productively. Course Curriculum First Section The purpose of technical documentation (7:17) The different models for technical documentation (9:52) What is a technical author? (21:24) Adopting a user-centred design approach (10:38) Overview of the writing process (10:40) Planning your content (10:24) Researching the product and audience (13:20) Software tools (10:40) Writing the topics – Overview (30:31) Writing the topics – How to write and present different types of information (13:33) Writing the topics – Using images and videos (11:43) Writing the topics – Index, Search and Metadata (16:57) Hyperlinking (5:20) Reviewing and editing (9:42) End of course (7:21) Bonus content Frequently Asked Questions When does the course start and finish? It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?You have access for 12 months.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Duration 3 Days 18 CPD hours This course is intended for This class is intended for the following job roles: [Cloud] information security analysts, architects, and engineers Information security/cybersecurity specialists Cloud infrastructure architects Additionally, the course is intended for Google and partner field personnel who work with customers in those job roles. The course should also be useful to developers of cloud applications Overview This course teaches participants the following skills: Understanding the Google approach to security Managing administrative identities using Cloud Identity. Implementing least privilege administrative access using Google Cloud Resource Manager, Cloud IAM. Implementing IP traffic controls using VPC firewalls and Cloud Armor Implementing Identity Aware Proxy Analyzing changes to the configuration or metadata of resources with GCP audit logs Scanning for and redact sensitive data with the Data Loss Prevention API Scanning a GCP deployment with Forseti Remediating important types of vulnerabilities, especially in public access to data and VMs This course gives participants broad study of security controls and techniques on Google Cloud Platform. Through lectures, demonstrations, and hands-on labs, participants explore and deploy the components of a secure Google Cloud solution. Participants also learn mitigation techniques for attacks at many points in a Google Cloud-based infrastructure, including Distributed Denial-of-Service attacks, phishing attacks, and threats involving content classification and use. Foundations of GCP Security Google Cloud's approach to security The shared security responsibility model Threats mitigated by Google and by GCP Access Transparency Cloud Identity Cloud Identity Syncing with Microsoft Active Directory Choosing between Google authentication and SAML-based SSO GCP best practices Identity and Access Management GCP Resource Manager: projects, folders, and organizations GCP IAM roles, including custom roles GCP IAM policies, including organization policies GCP IAM best practices Configuring Google Virtual Private Cloud for Isolation and Security Configuring VPC firewalls (both ingress and egress rules) Load balancing and SSL policies Private Google API access SSL proxy use Best practices for structuring VPC networks Best security practices for VPNs Security considerations for interconnect and peering options Available security products from partners Monitoring, Logging, Auditing, and Scanning Stackdriver monitoring and logging VPC flow logs Cloud audit logging Deploying and Using Forseti Securing Compute Engine: techniques and best practices Compute Engine service accounts, default and customer-defined IAM roles for VMs API scopes for VMs Managing SSH keys for Linux VMs Managing RDP logins for Windows VMs Organization policy controls: trusted images, public IP address, disabling serial port Encrypting VM images with customer-managed encryption keys and with customer-supplied encryption keys Finding and remediating public access to VMs VM best practices Encrypting VM disks with customer-supplied encryption keys Securing cloud data: techniques and best practices Cloud Storage and IAM permissions Cloud Storage and ACLs Auditing cloud data, including finding and remediating publicly accessible data Signed Cloud Storage URLs Signed policy documents Encrypting Cloud Storage objects with customer-managed encryption keys and with customer-supplied encryption keys Best practices, including deleting archived versions of objects after key rotation BigQuery authorized views BigQuery IAM roles Best practices, including preferring IAM permissions over ACLs Protecting against Distributed Denial of Service Attacks: techniques and best practices How DDoS attacks work Mitigations: GCLB, Cloud CDN, autoscaling, VPC ingress and egress firewalls, Cloud Armor Types of complementary partner products Application Security: techniques and best practices Types of application security vulnerabilities DoS protections in App Engine and Cloud Functions Cloud Security Scanner Threat: Identity and Oauth phishing Identity Aware Proxy Content-related vulnerabilities: techniques and best practices Threat: Ransomware Mitigations: Backups, IAM, Data Loss Prevention API Threats: Data misuse, privacy violations, sensitive/restricted/unacceptable content Mitigations: Classifying content using Cloud ML APIs; scanning and redacting data using Data Loss Prevention API Additional course details: Nexus Humans Security in Google Cloud 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 Security in Google Cloud 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 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 There are good reasons Adobe Premiere Pro is such a popular post-production video editing software application. It excels for a wide variety of uses; tapeless and DSLR footage; cross-platforms, open workflows for easy collaboration, powerful metadata features for greater editing and production efficiency, plus real-time 3D editing and Virtual Reality. This four-day course is ideal for beginners, as well as Final Cut Pro and Avid editors - or for anyone who is involved in a content creation environment. Adobe Premiere Interface Performing Nonlinear Editing in Premiere Pro Looking at the Standard Digital Video Workflow Enhancing the Workflow with Premiere Pro Expanding the Workflow Incorporating other Components into the Editing Workflow Adobe Creative Cloud Video Workflow Touring the Premiere Pro Workspace Looking at the Workspace Layout Customizing the Workspace Introducing Preferences Keyboard Shortcuts Moving, Backing up, and Syncing User Settings Setting up a Project Setting up a Sequence Setting up the Timeline Importing Media Importing Assets Working with ingest Options and Proxy Media Working with the Media Browser Importing Images Using Adobe Stock Customizing the Media Cache Recording a Voice-over Organizing Media Project Panel Working with Bins Monitoring Footage Modifying Clips Mastering the Essentials of Video Editing Using the Source Monitor Navigating the Timeline Essential Editing Commands Working with Clips and Markers Using Program Monitor Controls Setting the Playback Resolution Playing back VR Video Using Markers Using Sync Lock and Track Lock Finding Gaps in the Timeline Selecting Clips Moving Clips Extracting and Deleting Segments Adding Transitions Understanding Transitions Edit points and Handles Adding Video Transitions Using A/B mode to Fine-tune a Transition Adding Audio Transitions Performing Advanced Editing Techniques Performing Three or Four-point Editing Changing Playback Speed Replacing Clips and Footage Nesting Sequences Performing Regular Trimming Performing Advanced Trimming Trimming in the Program Monitor Putting Clips in Motion Adjusting the Motion Effect Changing Clip Position, Size, and Rotation Working with Keyframe Interpolation Using other Motion-related Effects Multi-camera Editing Following the Multi-camera Process Creating a Multi-camera Sequence Switching Multiple Cameras Finalizing Multi-camera Editing Editing and Mixing Audio Setting up the Interface to Work with Audio Examining Audio Characteristics Creating a Voice-over Scratch Track Adjusting Audio Volume Normalizing Audio Creating a Split Edit Adjusting Audio Levels for a Clip Sweetening Sound Sweetening Sound with Audio Effects Adjusting EQ Cleaning up Noisy Audio Fading Audio with Essential Sounds Adding Video Effects Working with Effects Master Clip Effects Masking and Tracking Visual Effects Keyframing Effects Effect Presets Frequently Used Effects Improving Clips with Color Correction and Grading Following a Color-oriented Workflow An overview of Color-oriented Effects Fixing Exposure Problems Fixing Color Balance Using Special Color Effects Creating a Look Exploring Compositing Techniques Understanding an Alpha Channel Making Compositing Part of Your Projects Working with the Opacity Effect Working with Alpha-channel Transparencies Color Keying a Green Screen Shot Using Mattes Creating Titles An Overview of Shapes & Type Loading in Graphics Using the Essentials Graphic Panel Browsing Templates Saving Templates Mastering Video Typography Essentials Creating Titles Stylizing Text Making Text Roll and Crawl Introducing Captions Managing Your Projects Using the File menu Using the Project Manager Performing the Final Project Management Steps Importing Projects or Sequences Managing Collaboration Using the Libraries Panel Managing Your Hard Drives Exporting Frames, Clips, and Sequences Overview of Export Options Exporting Single Frames Exporting a Master Copy Working with Adobe Media Encoder Uploading to Social Media Exchanging with Other Editing Applications Additional course details: Nexus Humans Adobe Premiere Pro 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 Adobe Premiere Pro 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.

Create a Gatsby.js Progressive Web App with GraphQL, React, and WordPress and add JAMstack to your skills

Duration 5 Days 30 CPD hours This course is intended for Network and security architects and consultants who design the enterprise and data center networks and VMware NSX environments Overview By the end of the course, you should be able to meet the following objectives: Describe and apply a design framework Apply a design process for gathering requirements, constraints, assumptions, and risks Design a VMware vSphere virtual data center to support NSX-T Data Center requirements Create a VMware NSX Manager™ cluster design Create a VMware NSX Edge™ cluster design to support traffic and service requirements in NSX-T Data Center Design logical switching and routing Recognize NSX-T Data Center security best practices Design logical network services Design a physical network to support network virtualization in a software-defined data center Create a design to support the NSX-T Data Center infrastructure across multiple sites Describe the factors that drive performance in NSX-T Data Center This five-day course provides comprehensive training on considerations and practices to design a VMware NSX-T? Data Center environment as part of a software-defined data center strategy. This course prepares the student with the skills to lead the design of NSX-T Data Center offered in release 3.2, including design principles, processes, and frameworks. The student gains a deeper understanding of the NSX-T Data Center architecture and how it can be used to create solutions to address the customer?s business needs. Course Introduction Introduction and course logistics Course objectives Design Concepts Identify design terms Describe framework and project methodology Describe VMware Validated Design? Identify customers? requirements, assumptions, constraints, and risks Explain the conceptual design Explain the logical design Explain the physical design NSX Architecture and Components Recognize the main elements in the NSX-T Data Center architecture Describe the NSX management cluster and the management plane Identify the functions and components of management, control, and data planes Describe the NSX Manager sizing options Recognize the justification and implication of NSX manager cluster design decisions Identify the NSX management cluster design options NSX Edge Design Explain the leading practices for edge design Describe the NSX Edge VM reference designs Describe the bare-metal NSX Edge reference designs Explain the leading practices for edge cluster design Explain the effect of stateful services placement Explain the growth patterns for edge clusters Identify design considerations when using L2 bridging services NSX Logical Switching Design Describe concepts and terminology in logical switching Identify segment and transport zone design considerations Identify virtual switch design considerations Identify uplink profile, VMware vSphere© Network I/O Control profile, and transport node profile design considerations Identify Geneve tunneling design considerations Identify BUM replication mode design considerations NSX Logical Routing Design Explain the function and features of logical routing Describe NSX-T Data Center single-tier and multitier routing architectures Identify guidelines when selecting a routing topology Describe the BGP and OSPF routing protocol configuration options Explain gateway high availability modes of operation and failure detection mechanisms Identify how multitier architectures provide control over stateful service location Identify VRF Lite requirements and considerations Identify the typical NSX scalable architectures NSX Security Design Identify different security features available in NSX-T Data Center Describe the advantages of an NSX Distributed Firewall Describe the use of NSX Gateway Firewall as a perimeter firewall and as an intertenant firewall Determine a security policy methodology Recognize the NSX-T Data Center security best practices NSX Network Services Identify the stateful services available in different edge cluster high availability modes Describe failover detection mechanisms Explain the design considerations for integrating VMware NSX© Advanced Load Balancer? with NSX-T Data Center Describe stateful and stateless NSX-T Data Center NAT Identify benefits of NSX-T Data Center DHCP Identify benefits of metadata proxy Describe IPSec VPN and L2 VPN Physical Infrastructure Design Identify the components of a switch fabric design Assess Layer 2 and Layer 3 switch fabric design implications Review guidelines when designing top-of-rack switches Review options for connecting transport hosts to the switch fabric Describe typical designs for VMware ESXi? compute hypervisors with two pNICs Describe typical designs for ESXi compute hypervisors with four or more pNICs Describe a typical design for a KVM compute hypervisor with two pNICs Differentiate dedicated and collapsed cluster approaches to SDDC design NSX Multilocation Design Explain scale considerations in an NSX-T Data Center multisite design Describe the main components of the NSX Federation architecture Describe the stretched networking capability in Federation Describe stretched security use cases in Federation Compare Federation disaster recovery designs NSX Optimization Describe Geneve Offload Describe the benefits of Receive Side Scaling and Geneve Rx Filters Explain the benefits of SSL Offload Describe the effect of Multi-TEP, MTU size, and NIC speed on throughput Explain the available N-VDS enhanced datapath modes and use cases List the key performance factors for compute nodes and NSX Edge nodes

Master the advanced techniques of using the world's most powerful photo editing and management software Adobe Lightroom and edit like a pro with the help of the Photo Magic - Edit Like a Pro Super Bundle course. Adobe Lightroom helps you to make amazing photos, from anywhere. Using the application, you can import, organize, manage, and find your images. You can use any browser to access your photos uploaded from Lightroom CC on your computer, mobile phone, or tablet, and edit them in full-resolution. You can also use Lightroom CC with Photoshop CC. The bundle course covers various editing styles and shows you how to make complex sky selections using the adjustment brush, or edit a landscape photo using a wide range of techniques. You will also learn to use PhotoShop to combine multiple light trails images into a stunning composite. The use of radial filters to brighten up areas, crop, strategies of using new Lightroom transformation tools, Clone tools to erase unwanted details, process a color image into black and white, etc. will be covered in the course. Upon completion, you will be able to edit photos and make them professional by using Adobe Lightroom. What Will I Learn? Edit photos out of their camera and turn them into professional quality images! Use PhotoShop to blend multiple light trails images into a stunning composite! Maintain top quality whilst bringing the very best out of the shots out of your camera Use the Clone tool to erase unwanted details Adjust specific areas of your shots to bring out the details in shadow areas Crop your shots to bring out the best compositions Requirements How to take a sunset or night photo, and then ideally have it open in Lightroom or your own editing application to follow along as Joe shows you how to edit and apply the different techniques How to load up your photos into Lightroom or any other editing application Edit Like a Pro! - 1 - Navvy on the river Liffey, Dublin, Ireland Opening Titles 00:01:00 Introduction to our image 00:03:00 Let's start with some global adjustments Fix verticals using transform 00:02:00 Crop out distracting elements 00:01:00 Tonal range, black and white points 00:03:00 Decisions about clarity 00:01:00 Now we focus in and make localised adjustments to different parts of the image Localised adjustments using the radial filter 00:03:00 Localised adjustments using the clone tool 00:06:00 Localised brightening using the adjustment brush 00:01:00 Localised adjustments - white balance 00:03:00 Finishing off... Final edits - subject, background, corners 00:02:00 Thanks for watching! 00:01:00 Edit Like a Pro! - 2 - Beckett Bridge Sunset - Let's get started Titles and promo 00:01:00 Edit Like a Pro promo 00:01:00 Introduction to our image 00:03:00 Initial Processing - Assessing the image Reading the Histogram 00:03:00 Creating the HDR merge 00:05:00 Sorting your images in Grid view 00:02:00 Using Survey mode (N) to compare images 00:01:00 Keywording our new image 00:03:00 Main Edits Editing - the Basic tab 00:06:00 Editing - the Transform tab 00:04:00 Editing - Sharpening 00:03:00 Edit - Radial filters 00:08:00 Editing - Adjustment brush 00:07:00 Thanks for Watching! Editing - Final Tweaks 00:04:00 Thanks for watching 00:01:00 Edit Like a Pro! - 3 - Light Trails on O'Connell Street Bridge, Dublin, Ireland Opening titles 00:01:00 Introduction to our image 00:03:00 Using Lightroom and Photoshop Selecting the images to export into Photoshop 00:02:00 Combining our images in Photoshop 00:04:00 Finding the new composite file back in Lightroom 00:01:00 Editing our composite image back in Lightroom Editing our merged image 00:02:00 Edit - fixing verticals with the transform tab 00:02:00 Edit - changing the crop 00:02:00 Edit - Basic panel adjustments 00:05:00 Edit - tone curve and sharpening 00:02:00 Finishing off... Final touches 00:02:00 Thanks for watching 00:01:00 Edit Like a Pro! - 4 - Castletown Stately Home - Let's set our image up for editing... Opening titles 00:01:00 Promo for Edit Like a Pro! - 4 - Castletown Stately Home 00:01:00 Introduction to our image 00:01:00 Keywording our image 00:02:00 Editing metadata pre-sets 00:02:00 The Basic Tab - initial editing Setting the Crop 00:05:00 Adjusting tonal range using the Histogram 00:04:00 Highlights, Shadows, Whites & Blacks 00:03:00 Clarity, Vibrance & Saturation 00:02:00 Adjusting Contrast using the Tone Curve 00:02:00 The HSL tab Adjusting Hue, Saturation and Luminance 00:04:00 Sharpening and Orientation Sharpening & the Detail tab 00:04:00 Lens Corrections 00:02:00 Tweaking verticals with the Transform tab 00:04:00 Subtle finishing touches Applying a vignette in the Effects tab 00:01:00 Using Camera Calibration for different 'looks' 00:03:00 Bring out shadow detail with Radial Filters & Adjustment Brushes 00:06:00 Cloning out distracting elements 00:10:00 B&W using Nik Silver Efex Pro 2 00:10:00 Thanks for watching! 00:01:00 Edit Like a Pro! - 5 - Houses of Parliament Evening - Introduction Opening titles 00:01:00 Basic edits Setting up the develop tab 00:02:00 Correcting perspective 00:04:00 Applying a panoramic crop 00:03:00 Complex selections in Lightroom Selecting the sky 00:16:00 Adjusting the building 00:08:00 Cleaning the clock faces 00:04:00 Finishing off The Basic tab 00:04:00 Seeing the before and after 00:01:00 Thanks for watching 00:01:00 Course Certification

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Editing 360º Photos with Photoshop and After Effects will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Editing 360º Photos with Photoshop and After Effects will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Editing 360º Photos with Photoshop and After Effects and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Editing 360º Photos with Photoshop and After Effects is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Editing 360º Photos with Photoshop and After Effects. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Editing 360º Photos with Photoshop and After Effects will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: Introduction Introduction 00:01:00 Software you'll need 00:01:00 A brief intro to After Effects 00:02:00 About the exercise files 00:01:00 Section 02: Editing and Retouching a Spherical Panorama Isolating the tripod area 00:07:00 Seamless tripod removal 00:02:00 Replacing tripod from bottom of sphere 00:04:00 Retouch and reset the panorama center point 00:04:00 Replacing the sky 00:04:00 Adding some sunshine 00:07:00 Making color adjustments 00:02:00 Adding a logo 00:05:00 Preparing Final JPEG file (with metadata) 00:04:00 Upload spherical panoramic to Facebook 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00