141 Metadata courses

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Advanced Basic Audio Editing Training With Audacity Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Advanced Basic Audio Editing Training With Audacity Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced Basic Audio Editing Training With Audacity Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Advanced Basic Audio Editing Training With Audacity Course, like every one of Study Hub's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced Basic Audio Editing Training With Audacity? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Advanced Basic Audio Editing Training With Audacity there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Advanced Basic Audio Editing Training With Audacity course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Advanced Basic Audio Editing Training With Audacity does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Advanced Basic Audio Editing Training With Audacity was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Advanced Basic Audio Editing Training With Audacity is a great way for you to gain multiple skills from the comfort of your home. Advanced Basic Audio Editing Training With Audacity Lesson 01: Overview - Hands On Walkthrough 00:01:00 Lesson 02: Hardware Configuration for Audacity Hands On Project 00:03:00 Lesson 03: Recording On Facebook Live 00:01:00 Lesson 04: Recording An Interview on Skype 00:02:00 Lesson 05: Doing Noise Reduction and Normalization 00:04:00 Lesson 06: Adding In Introductory-Ending Comments 00:04:00 Lesson 07: Adding In Bumper Music 00:03:00 Lesson 08: Creating the Metadata 00:01:00 Lesson 09: Editing Out Unwanted Audio 00:03:00 Lesson 10: Speeding Up The Editing Process 00:01:00 Lesson 11: Speeding Up the Final Recording 00:02:00 Lesson 12: Working with Your Project Files 00:02:00 Lesson 13: Splitting Tracks For Editing 00:02:00 Lesson 14: Labeling Segments 00:02:00 Lesson 15: Exporting the Snippets 00:03:00 Lesson 16: Hosing Your Audio 00:03:00 Lesson 17: Making Your Audio Available To the Public 00:02:00 Lesson 18: Recording Computer Audio - Part 1 00:01:00 Lesson 19: Recording Your Computer Audio - Part 2 00:02:00 Lesson 20: Conclusion 00:02:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Basic Audio Editing Training With Audacity Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Basic Audio Editing Training With Audacity Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Basic Audio Editing Training With Audacity Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Basic Audio Editing Training With Audacity Course, like every one of Study Hub's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Basic Audio Editing Training With Audacity? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD QS-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Basic Audio Editing Training With Audacity there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Basic Audio Editing Training With Audacity course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Basic Audio Editing Training With Audacity does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Basic Audio Editing Training With Audacity was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Basic Audio Editing Training With Audacity is a great way for you to gain multiple skills from the comfort of your home. Basic Audio Editing Training With Audacity Module 01: Overview 00:02:00 Module 02: Download and Install 00:03:00 Module 03: Audacity Toolbar - Part 1 00:02:00 Module 04: Audacity Toolbar - Part 2 00:03:00 Module 05: Hardware Needed 00:01:00 Module 06: Importing Content 00:03:00 Module 07: Audio From Mp4 00:02:00 Module 08: Using Projects and Project Files 00:02:00 Module 09: Creating A Simple Recording 00:02:00 Module 10: Labeling Tracks 00:02:00 Module 11: Adding Metadata 00:02:00 Module 12: Using Track View Features 00:03:00 Module 13: Adding Tracks 00:02:00 Module 14: Noise Reduction and Normalization 00:04:00 Module 15: Doing Simple Edits 00:04:00 Module 16: Splitting Tracks 00:03:00 Module 17: Adjusting Audio Speed 00:01:00 Module 18: Exporting Audio - Part 1 00:01:00 Module 19: Exporting Audio - Part 2 00:02:00 Module 20: Conclusion - Line In Audio 00:01:00

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Data Consultants/Managers, Developers, Program/Project Managers, and System Administrators. Overview This course is designed to give you the comprehensive skills needed to work with the Information Design Tool. The Information Design Tool enables designers to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes.In this course you learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools. This five-day course is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Information Design Tool. Basic SAP BusinessObjects Universe Design Describing Universes Defining the Components of a Universe Data Connections Defining connections Data Foundations Creating Data Foundations Using Joins Business Layers Accessing Data through the Business Layer Integrating the Business Layer Components Validating Objects Creating Measure Objects Creating Shortcut Joins Loops in a Data Foundation Resolving Loops with Joined Tables Resolving Loops Using Aliases Resolving Loops Using Contexts Detecting Contexts Editing Contexts Testing Contexts Resolving Recursive Loops Data Restrictions Defining Data Restrictions Applying Mandatory Data Restrictions Applying Optional Data Restrictions Lists of Values (LOV) Providing a List of Values Parameters Illustrating Runtime Parameters Object @functions Using Object @functions in Queries Applying the Aggregate Awareness Optimization Method Using Other @ Functions Navigation Paths Defining Drill Down Navigation Paths Derived Tables Creating Derived Tables Key Awareness Defining Numeric Keys Universe Management with Data Foundation and Business Layer Views Managing a Universe using the Data Foundation View Managing a Universe using the Business Layer View Universe Optimization Optimizing Universes Using Parameters Universe Deployment and Security Deploying a Universe Securing a Published Universe Creating Data Security Profiles Creating Business Security Profiles Assigning Security Profiles to Users Identifying the Priority of Security Settings Updating a Published Universe SQL Clause Processing Problems Determining How the Order of SQL Clauses Affects Data Returned Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Identifying Fan Traps Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Outer Join Problem Resolution Resolving an Ambiguous Outer Join Using @AggregateAware Universe Creation from Different Data Sources Identifying the Different Data Sources Creating an OLAP Universe Creating a Multi-source Universe Shared Projects Using Shared Projects Manipulating Other Designers' Resources Universe Conversion Converting Existing .unv Universes Translation Deploying Universes in Different Languages

Blockchain revolutionizes industries, offering decentralized, secure digital asset storage and transfer. This course explores fundamental blockchain and Web3 concepts-architecture, consensus, and benefits. Delve into blockchain economics, crucial for understanding network incentives and sustainability.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Duration 4 Days 24 CPD hours This course is intended for This course is designed for data analysts, business intelligence specialists, developers, system architects, and database administrators. Overview Skills gained in this training include:The features that Pig, Hive, and Impala offer for data acquisition, storage, and analysisThe fundamentals of Apache Hadoop and data ETL (extract, transform, load), ingestion, and processing with HadoopHow Pig, Hive, and Impala improve productivity for typical analysis tasksJoining diverse datasets to gain valuable business insightPerforming real-time, complex queries on datasets Cloudera University?s four-day data analyst training course focusing on Apache Pig and Hive and Cloudera Impala will teach you to apply traditional data analytics and business intelligence skills to big data. Hadoop Fundamentals The Motivation for Hadoop Hadoop Overview Data Storage: HDFS Distributed Data Processing: YARN, MapReduce, and Spark Data Processing and Analysis: Pig, Hive, and Impala Data Integration: Sqoop Other Hadoop Data Tools Exercise Scenarios Explanation Introduction to Pig What Is Pig? Pig?s Features Pig Use Cases Interacting with Pig Basic Data Analysis with Pig Pig Latin Syntax Loading Data Simple Data Types Field Definitions Data Output Viewing the Schema Filtering and Sorting Data Commonly-Used Functions Processing Complex Data with Pig Storage Formats Complex/Nested Data Types Grouping Built-In Functions for Complex Data Iterating Grouped Data Multi-Dataset Operations with Pig Techniques for Combining Data Sets Joining Data Sets in Pig Set Operations Splitting Data Sets Pig Troubleshoot & Optimization Troubleshooting Pig Logging Using Hadoop?s Web UI Data Sampling and Debugging Performance Overview Understanding the Execution Plan Tips for Improving the Performance of Your Pig Jobs Introduction to Hive & Impala What Is Hive? What Is Impala? Schema and Data Storage Comparing Hive to Traditional Databases Hive Use Cases Querying with Hive & Impala Databases and Tables Basic Hive and Impala Query Language Syntax Data Types Differences Between Hive and Impala Query Syntax Using Hue to Execute Queries Using the Impala Shell Data Management Data Storage Creating Databases and Tables Loading Data Altering Databases and Tables Simplifying Queries with Views Storing Query Results Data Storage & Performance Partitioning Tables Choosing a File Format Managing Metadata Controlling Access to Data Relational Data Analysis with Hive & Impala Joining Datasets Common Built-In Functions Aggregation and Windowing Working with Impala How Impala Executes Queries Extending Impala with User-Defined Functions Improving Impala Performance Analyzing Text and Complex Data with Hive Complex Values in Hive Using Regular Expressions in Hive Sentiment Analysis and N-Grams Conclusion Hive Optimization Understanding Query Performance Controlling Job Execution Plan Bucketing Indexing Data Extending Hive SerDes Data Transformation with Custom Scripts User-Defined Functions Parameterized Queries Choosing the Best Tool for the Job Comparing MapReduce, Pig, Hive, Impala, and Relational Databases Which to Choose?

Imagine a world where your creativity knows no bounds. Where you can bring your ideas to life with the power of Adobe's creative suite. With this bundle, you'll learn the mastery of Adobe Lightroom, InDesign, After Effects, Illustrator, Premiere Pro, Audition, and Animate. Learning outcomes: Adobe Lightroom: Learn to edit and organise your photos like a pro. DaVinci Resolve: Master the art of video editing and colour grading. Adobe InDesign: Create professional-looking layouts for magazines, brochures, and more. Adobe After Effects: Create stunning motion graphics and visual effects. User Experience UI/UX Design: Learn the principles of user-centred design and create user interfaces that are both visually appealing and easy to use. Professional Photography: Learn the fundamentals of photography and take stunning photos in any situation. Adobe Illustrator: Create vector graphics and illustrations for print, web, and video. Adobe Premiere Pro: Edit and produce professional videos. Adobe Audition: Record, edit, and mix audio for your videos and podcasts. Adobe Animate: Create 2D animations for cartoons, banners, games, and the web. Freelancing on Upwork: Learn how to find and land freelance jobs on Upwork, the world's largest freelancing platform. This Adobe - Lightroom, InDesign, After Effects, Illustrator, Premiere Pro, Audition, & Animate Bundle Consists of the following Premium courses: => Course 01: Adobe Lightroom => Course 02: Video Editing- DaVinci Resolve => Course 03: Adobe InDesign Training => Course 04: Complete Adobe After Effects CC Diploma => Course 05: Advanced Diploma in User Experience UI/UX Design => Course 06: Professional Photography Diploma => Course 07: Adobe Illustrator Certificate Course => Course 08: Adobe Premiere Pro => Course 09: Adobe Audition => Course 10: 2D Animation: Adobe Animate => Course 11: Freelancing on Upwork Enrol today and start your journey to becoming a creative master! The Adobe - Lightroom, InDesign, After Effects, Illustrator, Premiere Pro, Audition, & Animate Bundle is a comprehensive course that will teach you everything you need to know to master the Adobe Creative Cloud suite. This Adobe - Lightroom, InDesign, After Effects, Illustrator, Premiere Pro, Audition, & Animate Bundle course is divided into 11 modules, each of which covers a different aspect of the Adobe Creative Cloud. You will learn how to use Lightroom to edit and organise your photos, InDesign to create professional-looking documents, After Effects to create motion graphics and visual effects, Illustrator to create vector graphics, Premiere Pro to edit videos, Audition to edit and mix audio, and Animate to create 2D animations. This Adobe - Lightroom, InDesign, After Effects, Illustrator, Premiere Pro, Audition, & Animate Bundle course is taught by experienced professionals who are experts in their field. You will learn the latest techniques and trends in creative design, and you will have the opportunity to build a portfolio of your work to showcase your skills to potential employers or clients. The Curriculum of Adobe - Lightroom, InDesign, After Effects, Illustrator, Premiere Pro, Audition, & Animate Bundle: => Course 01: Adobe Lightroom Module 01: Overview Module 02: The Essentials Module 03: Views Module 04: Techniques Module 05: Flags Ratings Module 06: Collections Module 07: Keywords and Metadata Module 08: Workflow Module 09: Exporting Module 10: Basics Module 11: Editing Module 12: Tools Module 13: HSL Module 14: Slideshows Module 15: Projects and Assignments Module 16: Conclusion Module 17: Final Lesson Module 18: Practice Materials =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you can order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) P.S: The delivery charge inside the UK is £3.99, and international students must pay £9.99. Enrol today and start your journey to becoming a creative professional! CPD 125 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Adobe - Lightroom, InDesign, After Effects, Illustrator, Premiere Pro, Audition, & Animate Bundle course is for anyone who wants to learn how to use the Adobe Creative Cloud suite to create professional-quality photos, videos, graphics, and animations. Whether you are a beginner or a more experienced user, this course has something to offer you. Beginners: Learn the basics of the Adobe Creative Cloud suite and how to use it to create professional-looking work. Intermediate users: Expand your skills and learn new techniques and trends in creative design. Experienced users: Master the Adobe Creative Cloud suite and take your skills to the next level. Requirements Our Adobe is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this Adobe bundle will increase the value of your CV and open you up to multiple job sectors: Animators: £25,000-£60,000 Video editor: £28,000 to £60,000 Graphic designer: £25,000 to £50,000 Motion graphics designer: £27,000 to £55,000 User experience designer: £30,000 to £70,000 Freelancer: £25,000-£35,000 (depending on experience and skills) Certificates Certificate of Completion (Hard Copy) Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Adobe Lightroom) absolutely Free! Other hard-copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of Completion (PDF) Digital certificate - Included

Register on the Custom Face Mask Store today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Custom Face Mask Store is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Custom Face Mask Store Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Custom Face Mask Store, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Custom Face Mask Store Module 01: Introduction 00:03:00 Module 02: Creating the Home Page 00:09:00 Module 03: Create Your Own Designs 00:10:00 Module 04: Where to Find Designs 00:16:00 Module 05: Linking Site with Spread shirt 00:14:00 Module 06: Create the Store, Contact & About Us Page 00:27:00 Module 07: Metadata & Search Engine Optimization 00:11:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Duration 3 Days 18 CPD hours This course is intended for This class is intended for the following customer job roles: Cloud architects, administrators, and SysOps personnel Cloud developers and DevOps personnel Overview This course teaches participants the following skills: Plan and implement a well-architected logging and monitoring infrastructure Define Service Level Indicators (SLIs) and Service Level Objectives (SLOs) Create effective monitoring dashboards and alerts Monitor, troubleshoot, and improve Google Cloud infrastructure Analyze and export Google Cloud audit logs Find production code defects, identify bottlenecks, and improve performance Optimize monitoring costs This course teaches you techniques for monitoring, troubleshooting, and improving infrastructure and application performance in Google Cloud. Guided by the principles of Site Reliability Engineering (SRE), and using a combination of presentations, demos, hands-on labs, and real-world case studies, attendees gain experience with full-stack monitoring, real-time log management and analysis, debugging code in production, tracing application performance bottlenecks, and profiling CPU and memory usage. Introduction to Google Cloud Monitoring Tools Understand the purpose and capabilities of Google Cloud operations-focused components: Logging, Monitoring, Error Reporting, and Service Monitoring Understand the purpose and capabilities of Google Cloud application performance management focused components: Debugger, Trace, and Profiler Avoiding Customer Pain Construct a monitoring base on the four golden signals: latency, traffic, errors, and saturation Measure customer pain with SLIs Define critical performance measures Create and use SLOs and SLAs Achieve developer and operation harmony with error budgets Alerting Policies Develop alerting strategies Define alerting policies Add notification channels Identify types of alerts and common uses for each Construct and alert on resource groups Manage alerting policies programmatically Monitoring Critical Systems Choose best practice monitoring project architectures Differentiate Cloud IAM roles for monitoring Use the default dashboards appropriately Build custom dashboards to show resource consumption and application load Define uptime checks to track aliveness and latency Configuring Google Cloud Services for Observability Integrate logging and monitoring agents into Compute Engine VMs and images Enable and utilize Kubernetes Monitoring Extend and clarify Kubernetes monitoring with Prometheus Expose custom metrics through code, and with the help of OpenCensus Advanced Logging and Analysis Identify and choose among resource tagging approaches Define log sinks (inclusion filters) and exclusion filters Create metrics based on logs Define custom metrics Link application errors to Logging using Error Reporting Export logs to BigQuery Monitoring Network Security and Audit Logs Collect and analyze VPC Flow logs and Firewall Rules logs Enable and monitor Packet Mirroring Explain the capabilities of Network Intelligence Center Use Admin Activity audit logs to track changes to the configuration or metadata of resources Use Data Access audit logs to track accesses or changes to user-provided resource data Use System Event audit logs to track GCP administrative actions Managing Incidents Define incident management roles and communication channels Mitigate incident impact Troubleshoot root causes Resolve incidents Document incidents in a post-mortem process Investigating Application Performance Issues Debug production code to correct code defects Trace latency through layers of service interaction to eliminate performance bottlenecks Profile and identify resource-intensive functions in an application Optimizing the Costs of Monitoring Analyze resource utilization cust for monitoring related components within Google Cloud Implement best practices for controlling the cost of monitoring within Google Cloud

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