17147 Other courses in Westergate delivered Online

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.

Duration 4 Days 24 CPD hours This course is intended for This course is appropriate for anyone who wants to create applications or modules to automate and simplify common tasks with Perl. Overview Working within in an engaging, hands-on learning environment, guided by our expert web development, PHP practitioner, students will learn to: Create a working script that gets input from the command line, the keyboard, or a file Use arrays to store and process data from files Create formatted reports Use regular expressions Use the appropriate types of variables and data structures Refactor duplicate code into subroutines and modules What is available in the standard library Use shortcuts and defaults, and what they replace Introduction to Perl Programming Essentials is an Introductory-level practical, hands-on Perl scripting training course that guides the students from the basics of writing and running Perl scripts to using more advanced features such as file operations, report writing, the use of regular expressions, working with binary data files, and using the extensive functionality of the standard Perl library. Students will immediately be able to use Perl to complete tasks in the real world. Session: An Overview of Perl What is Perl? Perl is compiled and interpreted Perl Advantages and Disadvantages Downloading and Installing Perl Which version of Perl Getting Help Session: Creating and running Perl Programs Structure of a Perl program Running a Perl script Checking syntax and warnings Execution of scripts under Unix and Windows Session: Basic Data and I/O Numeric and Text literals Math operators and expressions Scalar variables Default values Writing to standard output Command line arguments Reading from the standard input Session: Logic and Loops About flow control The if statement and Boolean values Using unless and elsif Statement modifiers warn() and die() The conditional construct Using while loop and its variants Using the for loop Exiting from loops Session: Lists and Arrays The list data type Accessing array elements Creating arrays List interpolation Arrays and memory Counting elements Iterating through an array List evaluation Slices and ranges Session: Reading and writing text files File I/O Overview Opening a file Reading text files Writing to a text file Arrays and file I/O Using the <> operator Session: List functions Growing and shrinking arrays The split() function Splitting on whitespace Assigning to literal lists The join() function The sort() function Alternate sort keys Reversing an array Session: Formatting output Using sprintf() and printf() Report formatting overview Defining report formats The write() function Advanced filehandle magic Session: Hashes Hash overview Creating hashes Hash attributes Traversing a hash Testing for existence of elements Deleting hash elements Session: References What is a reference? The two ways to create references References to existing data References to anonymous data Dereferencing scalar, array, and ash references Dereferencing elements of arrays and hashes Multidimensional arrays and other data structures Session: Text and Regular Expressions String length The substr() function The index() and rindex() functions String replication Pattern matching and substitution Regular expressions Session: Raw file and data access Opening and closing raw (binary) files Reading raw data Using seek() and tell() Writing raw data Raw data manipulation with pack() and unpack() Session: Subroutines and variable scope Understanding packages Package and Lexical variables Localizing builtin variables Declaring and calling subroutines Calling subroutines Passing parameters and returning values Session: Working with the operating system Determining current OS Environment variables Running external programs User identification Trapping signals File test operators Working with files Time of day Session: Shortcuts and defaults Understanding $_ shift() with no array specified Text file processing Using grep() and Using map() Command-line options for file processing Session: Data wrangling Quoting in Perl Evaluating arrays Understanding qw( ) Getting more out of the <> operator Read ranges of lines Using m//g in scalar context The /o modifier Working with embedded newlines Making REs more readable Perl data conversion Session: Using the Perl Library The Perl library Old-style library files Perl modules Modules bundled with Perl A selection of modules Getting modules from ActiveState Getting modules from CPAN Using Getopt::Long Session: Some Useful Tools Sending and receiving files with Net::FTP Using File::Find to search for files and directories Grabbing a Web page Some good places to find scripts Perl man pages for more information Zipping and unzipping files

11-in-1 Premium Bundle | CPD QS Certified | 110 CPD Points | Free Hardcopy + PDF Certificate + Exam | Lifetime Access

Level 2 Certificate in Understanding Climate Change and Environmental Awareness Climate change is the most critical issue facing the globe right now. Climate change may be categorised into two categories: those caused by natural forces and those caused by man. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course will educate you about all the fundamentals of climate change so you may create positive changes. You will learn about the effects of pollution as well as the challenges to a sustainable future, and how to overcome these barriers. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course also will address the benefits of renewable energy and how to minimise energy usage and carbon footprints for a better future. The environment is today undergoing its most significant crisis. Everyone has the ability to make a difference and contribute to a more sustainable future for future generations. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course will also include the core skills and knowledge to effectively support climate change programs and connect students to the world's most extensive network of professionals, organisations, and authorities. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course is perfect for students who are interested in environmental and sustainability concerns and wish to pursue a long-term career in the field. We leave no stone unturned, and whether you are ready to take This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course in your career as an environmental specialist or simply want to improve your current skills, we will assist you in every step of the way. Simply log on to our online portal, where you will find all of the necessary learning materials of this Level 2 Certificate in Understanding Climate Change and Environmental Awareness course. When you study for a qualification online, You are completely in charge of your study schedule. There are no time-consuming classes to attend or long commutes to endure. You will be able to work on your own time and at your own pace once enrolled. So, enrol today in this powerful Level 2 Certificate in Understanding Climate Change and Environmental Awareness course and start preparing to succeed! Why choose this from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course is ideal for those who want to work as an environmental specialist. The course will place a strong emphasis on project methods. So, are you looking for the most professional course in Understanding Climate Change and Environmental Awareness? Do you already work in this field but want to improve your knowledge? If so then don't be concerned. We are here to meet your needs. Our professionals created this Level 2 Certificate in Understanding Climate Change and Environmental Awareness course to provide you with advanced skills, knowledge, and confidence to help you build a long-term career in this field. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course helps students to understand about climate changes as well as investigates how the weather changes over time. They accomplish this by observing the wind, temperature, lightning, sunlight, and rainfall. This information assists them in making sense of climate patterns and variations, as well as allowing professionals to observe how human activity influences the weather. This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course helps students to understand about how society can adapt and reduce the effects of climate change as well as how an environmental specialist can positively protect the environment. Learning Outcomes After completing this Level 2 Certificate in Understanding Climate Change and Environmental Awareness course, learner will be able to: Gain a thorough understanding of the environment, the benefits and the challenges. Understand in-depth knowledge about global warming and climate change. Understand sustainability and sustainable development Gain a solid understanding of the role of industry in protecting the environment Understand resource efficiency and waste management Course Curriculum Module 1: Understand climate change, sustainability and environmental protection Understand the environment, the benefits and the challenges Understand global warming and climate change Understand sustainability and sustainable development Module 2: Understand industry and the environment Understand the role of industry in protecting the environment Module 3: Understand resource efficiency and waste management Understand how to reduce the environmental impact of organisations and individuals Understand how to reduce energy consumption and carbon emissions Understand water efficiency Assessment Method After completing Level 2 Certificate in Understanding Climate Change and Environmental Awareness Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Our fully-loaded Level 2 Certificate in Understanding Climate Change and Environmental Awareness course offers vital teachings and career insights to both beginners in the sector and current specialists. Whether you want to make your career as an environmental specialist or advance to a higher level of the environment awareness related sector, this course will help you. You may become more aware of the challenges surrounding climate change and the environment by completing the Level 2 Certificate in Understanding Climate Change and Environmental Awareness course. This course is perfect for students interested in a profession such as; Environmental Specialist. Agricultural Inspector. Hydrologist. Requirements There are no particular requirements for this course because it doesn't call for any specialized training. To enroll in this Level 2 Certificate in Understanding Climate Change and Environmental Awareness course, students must fulfill the following requirements: Good Command over English language Be energetic and self-motivated Basic computer Skill You must be at least 15 years old Career path This Level 2 Certificate in Understanding Climate Change and Environmental Awareness course is for anybody who wishes to work in a capacity that can promote positive change and assist their organisation in being more environmentally friendly by understanding climate change.

Visual Studio Code is currently the number #1 IDE among the programmer's community. All the big companies are moving towards using VS Code for active development. Get ahead of the curve and learn to use Visual Studio Code with ease.

This course is suitable for anyone aspiring to or already working in Data Protection/Law and looks at the skills needed to improve Data Protection/Law. By taking this course you will gain the necessary skills to perform effectively in this field. All businesses use personal data gathered from customers, suppliers, and colleagues in some way or another. It is in our collective interest to protect this data and keep it confidential in line with existing regulations and common sense. The Guide to the GDPR explains the provisions of the GDPR to help organisations comply with its requirements. It is for those who have day-to-day responsibility for data protection. The GDPR covers the critical area of obtaining, using, storing, managing and deleting personal data, and represents a substantial regulatory expansion of personal data protection rules and requirements This GDPR Data Protection Training Course is designed to provide an understanding of new and wide-reaching requirements from the General Data Protection Regulation and those rules relevant for businesses, as well as employees' responsibilities are for protecting personal information. The GDPR Data Protection Training Course is organised into 2 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 3hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Mock exams Multiple-choice assessment 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? GDPR Data Protection Training Course Course is suitable for anyone who wants to gain extensive knowledge, potential experience, and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more about this subject.

Sharpen your HTML, CSS, and JavaScript by working on a large variety of projects. In this course, we'll be working through a project a day using vanilla JavaScript. Over the next 50 days, you'll have 50 small, unique, DOM-oriented projects under your belt.

Fundamental Skills for First-Time Managers Certification Assuming in liability for a group can be an enormous test for first-time administrators, and it requires certain abilities and capacities that weren't recently needed. As it's a particularly troublesome change from a person to a pioneer, it's significant that all new directors get the essential abilities and preparing from the start. This course will be taking a gander at the different abilities that first-time directors need to turn out to be better pioneers, make drew in, gainful groups and produce extraordinary outcomes. You will Learn: Step by step instructions to adjust your attitude from a person to an administrator Instructions to effectively appoint undertakings Instructions to propel your group and energize proficient turn of events Instructions to assemble trust and associations with your group Instructions to lead by setting a model Advantages of Taking this Course: You'll acquire a superior comprehension of what's in store and what to do as a first-time director You'll figure out how to accomplish your objectives by controlling others through undertakings You'll have the option to oversee all the more effectively and make gainful groups

Neuro-Linguistic Programming Finding out about Neuro-Linguistic Programming (NLP) is significant to anyone who needs to defeat obstacles, associate with others better and assume responsibility for their lives, regardless of what their age, foundation or individual circumstance. This course covers all you require to think about NLP, including an itemized portrayal of precisely how it functions, the different degrees of individual change it influences and reasonable instances of amazing NLP procedures. From the advantages and reactions to powerful industry applications and open positions for professionals, this course covers all you'll at any point require to think about Neuro-Linguistic Programming. You Will Learn The inward functions of NLP and the six degrees of progress included The different segments and pragmatic instances of NLP strategies The advantages NLP has to bring to the table and experiences into basic reactions Pragmatic industry applications and a rundown of fascinating positions for NLP experts Advantages of Taking This Course You will accomplish more by defeating frailties and passionate blockages You will interface better with friends and family and mend broken connections You will set out your own business open doors utilizing NLP You will pull in progress and love into your life by changing your standpoint