19767 Courses delivered Online

Overview Corporate & Strategic Communication Skills for Managers Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Corporate & Strategic Communication Skills for Managers Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Section 01: Basic Communication Skills Definition Of Communication 00:03:00 Elements Of Communication 00:04:00 Communication Styles 00:03:00 Steps In Communication Process 00:01:00 Step 1 Of Communication Process 00:02:00 Step 1 Explained - Goal And Preparation 00:05:00 Step 1 Explained - Practicing Positive Intent 00:02:00 Step 1 Explained - Understanding Assumptions 00:06:00 Step 2 Of Communication Process 00:04:00 Characteristics Of Clear Message 00:04:00 Three Different Communication Styles 00:06:00 Assertive Communication Style 00:02:00 Body Language And Signals 00:03:00 Third Step In Communication - Seeing Feedback 00:04:00 Listening Skills - Listen With Compassion 00:04:00 Listening Skills - Meaning Of Paraphrasing 00:02:00 Ways To Improve Communication And Knowledge Check 00:05:00 Increase Effectiveness Of Communication 00:08:00 8 Guidelines For Giving Praise And Feedback 00:05:00 Additional Tips For Effective Communications 00:09:00 Section 02: Communication In Organisations & Strategic Communications Communication Requirements In Business 00:08:00 Skills Required In Corporate Communication 00:06:00 Interactive Communications 00:08:00 Reason Why Communication Fails 00:03:00 Communication Channels And Their Problems 00:06:00 Indications Of Incompetent Communication 00:06:00 Other Reasons For Communication Failure 00:04:00 Strategic Communication Liner Model 00:05:00 Strategic Communication Adaptive Model 00:04:00 Strategic Communication Interpretive Model 00:04:00 Strategic Communication In Public Communication 00:09:00 Resources And Audience For Strategic Public Communication 00:07:00 Source Of Strategic Communication 00:05:00 Strategic Communication - Summary Of Three Models 00:12:00 Strategic Communication - Guidelines For Interpretative Models 00:05:00 Strategic Communication - Public Communications 00:11:00 Internal Communication - Orientation 00:09:00 Internal Communication - Moral Compansation And Benefits 00:07:00 Internal Communication - Organisation Change 00:07:00 External Communication - Issues Management 00:06:00 External Communication And PR 00:05:00 External Communication - Issue Management - Organisation Response 00:13:00 External Communication - Image Management And Issue Advocacy 00:06:00 External Communication - Risk And Crisis Communication 00:10:00 Case Study On Corporate Strategic Communication 00:09:00 Section 03: How To Make Strategic Communication Plans What Is Strategy? 00:06:00 What Is Communication Strategy? 00:05:00 When Communication Strategy Is Required 00:04:00 Why Communication Strategy Is Required 00:03:00 Information We Need Before Making Strategy 00:08:00 Setting Goals And Identify Audience 00:08:00 Catagorise Your Audience To Help Draft Right Message 00:04:00 Drafting Message To Cater Your Audience 00:04:00 Channels And Timing Of Communication 00:05:00 Resources Risk And Evaluation Of Communication Strategy 00:04:00 Summary Of Communication Strategy 00:03:00 Strategic Communication Plan Template 00:04:00 Strategic Communication Plan 00:04:00 Difference Between Strategic And Tactical Communication 00:03:00 Traditional Planning And Why Refreshed Approached 00:05:00 Change Management - What Are Concerns? 00:03:00 Refreshed Approach To Communication Planning 00:07:00 Possible Problems In Communication Plan, Success Measurement 00:06:00 Measure, Feedback And Manage Cynics 00:03:00 Social Aspects Of Communication Strategy 00:12:00 Additional Planning On Social Aspects Of Communication Strategy 00:04:00 Strategic Communication - American Airlines Case Study 00:33:00 Section 04: Group Discussions Skills How To Succeed In Group Communication 00:10:00 Defining Group Communication 00:08:00 Elements Of Group Communication And Types Of Group 00:08:00 Advantages And Disadvantages Of Group Discussion 00:08:00 How To Prepare For Group Discussion 00:07:00 Practice For Group Discussion And Other Aspects 00:08:00 Dos And Don't Group Discussion 00:08:00 Section 05: Communication Skills For Conflict Resolution Summary Of Previous Class 00:05:00 What Is Conflict - Class Discussion? 00:07:00 Communication In Conflict 00:08:00 Meaning Of Positive Intent In Difficult Situations 00:09:00 Positive Intent - Example 00:05:00 De-Escalating Emotions As A Method To Communicate In Conflicts 00:06:00 Detached Responsibility Method In Resolving Conflicts 00:13:00 Keys To Handle Angry Peoples 00:06:00 Keys To Deal With Denial 00:04:00 Uncovering Hidden Agendas 00:06:00 Giving Negative Feedback 00:09:00 Receiving Negative Feedback And Exercise 00:08:00 Assignment Assignment - Corporate & Strategic Communication For Managers 00:00:00

Discrete Maths Teaching is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Discrete Maths Teaching and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 19 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Sets Introduction to Sets 00:01:00 Definition of Set 00:09:00 Number Sets 00:10:00 Set Equality 00:09:00 Set-Builder Notation 00:10:00 Types of Sets 00:12:00 Subsets 00:10:00 Power Set 00:05:00 Ordered Pairs 00:05:00 Cartesian Products 00:14:00 Cartesian Plane 00:04:00 Venn Diagrams 00:03:00 Set Operations (Union, Intersection) 00:15:00 Properties of Union and Intersection 00:10:00 Set Operations (Difference, Complement) 00:12:00 Properties of Difference and Complement 00:07:00 De Morgan's Law 00:08:00 Partition of Sets 00:16:00 Logic Introduction 00:01:00 Statements 00:07:00 Compound Statements 00:13:00 Truth Tables 00:09:00 Examples 00:13:00 Logical Equivalences 00:07:00 Tautologies and Contradictions 00:06:00 De Morgan's Laws in Logic 00:12:00 Logical Equivalence Laws 00:03:00 Conditional Statements 00:13:00 Negation of Conditional Statements 00:10:00 Converse and Inverse 00:07:00 Biconditional Statements 00:09:00 Examples 00:12:00 Digital Logic Circuits 00:13:00 Black Boxes and Gates 00:15:00 Boolean Expressions 00:06:00 Truth Tables and Circuits 00:09:00 Equivalent Circuits 00:07:00 NAND and NOR Gates 00:07:00 Quantified Statements - ALL 00:08:00 Quantified Statements - THERE EXISTS 00:07:00 Negations of Quantified Statements 00:08:00 Number Theory Introduction 00:01:00 Parity 00:13:00 Divisibility 00:11:00 Prime Numbers 00:08:00 Prime Factorisation 00:09:00 GCD & LCM 00:17:00 Proof Intro 00:06:00 Terminologies 00:08:00 Direct Proofs 00:09:00 Proofs by Contrapositive 00:11:00 Proofs by Contradiction 00:17:00 Exhaustion Proofs 00:14:00 Existence & Uniqueness Proofs 00:16:00 Proofs by Induction 00:12:00 Examples 00:19:00 Functions Intro 00:01:00 Functions 00:15:00 Evaluating a Function 00:13:00 Domains 00:16:00 Range 00:05:00 Graphs 00:16:00 Graphing Calculator 00:06:00 Extracting Info from a Graph 00:12:00 Domain & Range from a Graph 00:08:00 Function Composition 00:10:00 Function Combination 00:09:00 Even and Odd Functions 00:08:00 One to One (Injective) Functions 00:09:00 Onto (Surjective) Functions 00:07:00 Inverse Functions 00:10:00 Long Division 00:16:00 Relations Intro 00:01:00 The Language of Relations 00:10:00 Relations on Sets 00:13:00 The Inverse of a Relation 00:06:00 Reflexivity, Symmetry and Transitivity 00:13:00 Examples 00:08:00 Properties of Equality & Less Than 00:08:00 Equivalence Relation 00:07:00 Equivalence Class 00:07:00 Graph Theory Intro 00:01:00 Graphs 00:11:00 Subgraphs 00:09:00 Degree 00:10:00 Sum of Degrees of Vertices Theorem 00:23:00 Adjacency and Incidence 00:09:00 Adjacency Matrix 00:16:00 Incidence Matrix 00:08:00 Isomorphism 00:08:00 Walks, Trails, Paths, and Circuits 00:13:00 Examples 00:10:00 Eccentricity, Diameter, and Radius 00:07:00 Connectedness 00:20:00 Euler Trails and Circuits 00:18:00 Fleury's Algorithm 00:10:00 Hamiltonian Paths and Circuits 00:06:00 Ore's Theorem 00:14:00 The Shortest Path Problem 00:13:00 Statistics Intro 00:01:00 Terminologies 00:03:00 Mean 00:04:00 Median 00:03:00 Mode 00:03:00 Range 00:08:00 Outlier 00:04:00 Variance 00:09:00 Standard Deviation 00:04:00 Combinatorics Intro 00:03:00 Factorials 00:08:00 The Fundamental Counting Principle 00:13:00 Permutations 00:13:00 Combinations 00:12:00 Pigeonhole Principle 00:06:00 Pascal's Triangle 00:08:00 Sequence and Series Intro 00:01:00 Sequence 00:07:00 Arithmetic Sequences 00:12:00 Geometric Sequences 00:09:00 Partial Sums of Arithmetic Sequences 00:12:00 Partial Sums of Geometric Sequences 00:07:00 Series 00:13:00

Overview HTML and CSS Coding: Beginner to Advanced Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this HTML and CSS Coding: Beginner to Advanced Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Getting Started Introduction 00:03:00 Course Curriculum 00:07:00 How To Get Course Requirements 00:02:00 Getting Started On Windows, Linux Or Mac 00:02:00 How To Ask A Great Questions 00:01:00 Setting Up Development Environment Introduction 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview Of A Webpage 00:05:00 Full HTML Code Page 00:07:00 First Hello World! Webpage 00:09:00 HTML Fundamentals Introduction 00:03:00 Heading 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 ID's In CSS 00:06:00 Comments In HTML 00:04:00 Summary 00:04:00 HTML Intermediate Introduction 00:02:00 Images 00:12:00 Forms 00:05:00 Form Actions 00:04:00 Br Tag 00:03:00 Marquee 00:06:00 Text Area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div Tag 00:06:00 Google Maps 00:07:00 Summary 00:02:00 HTML Advanced Introduction 00:02:00 HTML5 Audio 00:07:00 HTML5 Video 00:05:00 Progress Bar 00:04:00 Drag And Drop 00:18:00 Canvas 00:06:00 I Frames 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 YouTube Video Linking 00:04:00 Creating Responsive Page 00:05:00 Summary 00:02:00 HTML Expert Introduction 00:02:00 Registration Form 00:04:00 Login Form 00:04:00 About Us Form 00:02:00 Contact Us Form 00:10:00 Footer Form 00:03:00 Integrate All Together 00:07:00 Coding Exercise 00:01:00 Solution For Coding Exercise 00:02:00 Summary 00:02:00 HTML Website Project Introduction 00:02:00 Challenge - HTML 5 Clock Face With Numbers 00:05:00 Project Overview 00:03:00 Conclusion On Project 00:01:00 Summary 00:02:00 CSS Fundamentals Introduction 00:03:00 CSS Syntax 00:05:00 Creating A First Page With CSS Style 00:13:00 Inline CSS 00:06:00 Internal CSS 00:05:00 CSS External 00:10:00 CSS Classes 00:09:00 CSS IDs 00:06:00 Colors 00:08:00 Backgrounds 00:04:00 Floating 00:09:00 Positioning 00:06:00 Margins 00:07:00 Padding 00:04:00 Borders 00:03:00 Summary 00:02:00 CSS Intermediate Introduction 00:02:00 Styling Text 00:07:00 Aligning Text 00:04:00 Styling Links 00:10:00 Font Family 00:07:00 Font Styles 00:03:00 Applying Google Fonts 00:07:00 Box Model 00:09:00 Icons 00:09:00 Tables 00:16:00 Navigation-Menu 00:11:00 Dropdowns 00:15:00 Summary 00:02:00 CSS Advanced Introduction 00:02:00 Advanced Selectors 00:05:00 Forms 00:17:00 Website Layout 00:21:00 Rounded Corners 00:08:00 Color Keywords 00:06:00 Animations 00:08:00 Pseudo Classes 00:03:00 Gradients 00:03:00 Shadows 00:03:00 Calculations 00:05:00 Creating Responsive Page 00:06:00 Summary 00:02:00 CSS Expert Introduction 00:01:00 Button Styles 00:06:00 Flexbox 00:14:00 CSS Grid 00:15:00 Pagination 00:07:00 Multiple Columns 00:06:00 Image Reflection 00:02:00 UI - UX Design 00:09:00 Social Media Icons 00:08:00 Coding Exercise 00:01:00 Solution For Coding Exercise 00:03:00 Summary 00:02:00 CSS Website Project Introduction 00:01:00 CSS Project Getting 00:05:00 CSS Project Overview 00:08:00 Summary 00:01:00 Publish Your Website For Live Introduction 00:02:00 Installing Free FTP Solution (FileZilla) 00:04:00 Setting Up FTP (File Transfer Protocol) 00:03:00 Publish Website To Hosting Server 00:04:00 Summary 00:01:00

Overview Quickbooks and Xero Accounting Course Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Quickbooks and Xero Accounting Course Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Quickbook Getting prepared - access the software and course materials The structure of the course - first things first! 00:00:00 Set up free trial 00:03:00 Getting started Starting A New Company File 00:11:00 Setting up the system Enter opening balances 00:02:00 Reverse opening balances - accruals and prepayments 00:06:00 Report Journal 00:05:00 Nominal ledger Amend The Nominal Ledger 00:07:00 Report listing the nominal ledgers 00:02:00 Customers Enter customers 00:09:00 Report on customer contact information 00:01:00 Suppliers Enter Suppliers 00:05:00 Supplier Contact List 00:02:00 Sales ledger Enter Invoices 00:09:00 Invoice Entering 00:03:00 Invoice batch 00:06:00 Post Sales Credit Notes 00:08:00 Report showing Customer Activity 00:03:00 Aged Debtors 00:02:00 Purchases ledger Post Supplier Invoices 00:03:00 Entering a Batch of Supplier Bills 00:09:00 Credit Notes Suppliers 00:05:00 Reclassify Supplier Bills - Flash Bulbs Purchased 00:04:00 Supplier Account Activity Report 00:04:00 Sundry payments Post Cheques 00:07:00 Report showing supplier payments 00:01:00 Sundry receipts Receipts from customers 00:07:00 Report showing customer receipts 00:02:00 Petty cash Post Petty Cash Transactions and Report 00:04:00 Post cash payments to ledgers 00:02:00 Enter petty cash items 00:14:00 Report on Petty Cash Payments Proper 00:05:00 Post Sundry Payments 00:05:00 Report Bank Payments 00:03:00 VAT - Value Added Tax VAT Return 00:03:00 Bank reconciliation Reconcile The Bank 00:10:00 Provide A Report Showing Any Unreconnciled Transaction 00:02:00 Payroll / Wages Post the Wages Journal 00:08:00 Posting Journal Adjustments 00:02:00 Reports Month end adjustments 00:03:00 Month end reports 00:06:00 Tasks Task- Crearing the accounts 00:06:00 Task - Customer report 00:01:00 Additional Resources Course Paper 00:00:00 Further Reading - QuickBooks Online 2014 The Handbook 00:00:00 Xero Accounting Getting Prepared - Access the software and course materials Introduction To The Course And Your Tutor 00:04:00 Activating Your Free Trial With Xero 00:02:00 Getting started Signing Up For The Free Trial 00:04:00 Instruction of updated Xero accounting software 00:00:00 Create The Organisation 00:08:00 The Ficticious Scenario 00:02:00 Setting up the system Add Bank Accounts To The System 00:14:00 Enter Opening Balances 00:07:00 Opening Trial Balance 00:01:00 Nominal ledger Amend The Nominal Ledger 00:06:00 Chart Of Accounts Report 00:01:00 Customers & Suppliers Enter customers 00:07:00 Reporting Customer And Supplier Information 00:02:00 Sales ledger Enter Invoices 00:07:00 Invoicing tips - adding logo, repeat billing 00:09:00 Entering Invoices 6574 to 6610 00:16:00 Post Credit Notes 00:03:00 Report Showing Customer Activity 00:08:00 Aged Debtors 00:02:00 Suppliers Post supplier invoices 00:09:00 Enter suppliers invoices 6028 onwards 00:14:00 Enter More Supplier Invoices No 4308 Onwards 00:06:00 Credit Notes Suppliers 00:02:00 Supplier Activity Report 00:04:00 Aged Creditors Info 00:01:00 Reciepts from Customers 00:10:00 Apply Customer Credit Notes 00:05:00 Purchases ledger Post Supplier Cheques 00:08:00 Apply Supplier Credit Notes 00:03:00 Print List Of Bank Receipts And Payments 00:01:00 Sundry payments Post Sundry Payments 00:07:00 Make a credit card payment 00:08:00 Petty Cash Add Petty Cash Transactions - Week 1 00:16:00 Add Petty Cash Transactions - Week 2 00:12:00 Add Petty Cash Transactions - Week 3 00:07:00 Add Petty Cash Transactions - Week 4 00:09:00 Imprest System on Petty Cash 00:04:00 Print a Copy of Petty Cash Receipts and Payments 00:01:00 Bad Debt Writing Off A Bad Debt - Print Customer Statement 00:02:00 Write Off A Bad Debt 00:09:00 Credit Card Reconcile The Credit Card Statement 00:09:00 Bank Reconciliation Bank Statement As A CSV File 00:27:00 Bank Statement Closing Balances 00:11:00 Reconcile The Petty Cash 00:05:00 Payroll / Wages Wages And Salaries 00:09:00 Post the Wages Journal 00:07:00 Report Wages Journal 00:02:00 Payday 00:11:00 Pay The Two Staff 00:05:00 VAT - Value Added Tax Depreciation 00:04:00 VAT Return 00:03:00 Reports Month End Reports PnL, BS, TB 00:05:00 Payroll unit Using Payroll 00:12:00 Setting Up Employees 00:10:00 Running Payroll - An Example 00:14:00 Conclude Recap And Next Steps 00:06:00 What happens next 00:02:00 Resources Resources - Xero Accounting 00:00:00 Assignment Assignment - Quickbooks and Xero Accounting Course 00:00:00

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.

Please note that this round of training is available only to workforce based within, or supporting individuals living in Conwy County Sparc is a North Wales based. project. We work with adults with learning disabilities, their parents and the people who work with them. Sparc provide training sessions on friendships, relationships and sex so that adults with learning disabilities become more confident with dating and relationships. This training day for North Wales workforce is based on our experience so far in delivering this work, and what we have been told by the learning disability and/or autistic communities about how they would prefer to be supported Become a workplace champion in supporting the rights and opportunities for adults with learning disabilities and or autism to have happy and healthy friendships, romantic relationships and sex. This workshop is free of charge for practitioners within or supporting individuals living in CONWY COUNTY, funded by the North Wales Transformation Project for Seamless Services and UK Government Levelling Up Fund We invite enthusiastic representatives from workplaces across the region to join take part in this one day event focused on exploring and removing barriers faced by adults with learning disabilities and autism in forming and maintaining positive friendships and romantic relationships. During the course of the day participants will Explore the benefits of healthy and fulfilling friendships, relationships and sex Identify barriers to the above, presented both by wider societal structure and within their workplace settings Consider law and legislation outlining individuals rights to relationships and private life Explored best practice in facilitating and supporting relationships and friendships Have the opportunity to create a bespoke action plan to share information and support colleagues within their workplace setting Terms & conditions: Due to limited capacity we are offering this free training to a maximum of two representatives from each workplace or setting. If more than two staff from a workplace wish to book on please email corrina@sexeducationcompany.org to be added to the reserve list. We will contact you if a place becomes available. As part of the conditions of attendance you will be asked to share the learning gained on this course with your workplace and colleagues. Although this course is free of charge we will charge late cancellation administration fees as follows: No notification of non-attendance - £50, less than 48 hours notice of non-attendance £30, Less than 1 weeks notice of non-attendance £25. By registering on the course you agree to these charges on late cancellation or failure to attend. Prosiect yng Ngogledd Cymru yw Sparc. Mae'n gweithio gydag oedolion ag anableddau dysgu, eu rhieni a'r bobl sy'n gweithio gyda nhw. Mae Sparc yn ddarparu sesiynau hyfforddi ar gyfeillgarwch, perthnasoedd a rhyw fel bod oedolion ag anableddau dysgu yn dod yn fwy hyderus gyda pherthnasoedd ac wrth ddêtio. Beth am ddod yn hyrwyddwr yn y gweithle er mwyn cefnogi hawliau a chyfleoedd i oedolion ag anableddau dysgu a/neu awtistiaeth i gael cyfeillgarwch hapus ac iach, perthnasoedd rhamantus a rhyw. Mae’r gweithdy hwn yn rhad ac am ddim i ymarferwyr yn SIR GONWY, ac wedi ei ariannu gan Brosiect Gwasanaethau Di-dor Gogledd Cymru. Rydym yn estyn gwahoddiad i gynrychiolwyr brwdfrydig o weithleoedd drwy’r ardal i gymryd rhan yn ystod y diwrnod hwn sy’n canolbwyntio ar archwilio a chael gwared o’r rhwystrau sy’n wynebu oedolion ag anableddau dysgu ac awtistiaeth wrth iddynt lunio a chynnal cyfeillgarwch positif a pherthnasoedd rhamantus. Yn ystod y diwrnod bydd y rhai sy’n cymryd rhan yn cael cyfle i Archwilio manteision cyfeillgarwch, perthnasoedd a rhyw iach a bodlon Canfod yr elfennau sy’n rhwystro’r uchod, ac sy’n codi o ganlyniad i strwythur cymdeithasol ehangach a sefyllfaoedd o fewn y gweithle Ystyried y gyfraith a’r ddeddfwriaeth sy’n amlinellu hawliau’r unigolyn i berthnasoedd a bywyd preifat Archwilio ymarfer gorau wrth hwyluso a chefnogi perthnasoedd a chyfeillgarwch Cael y cyfle i greu cynllun gweithredu pwrpasol i rannu gwybodaeth a chefnogi cydweithwyr o fewn eu gweithle Telerau ac amodau: Gan fod lleoedd yn gyfyngedig rydym yn cynnig yr hyfforddiant rhad ac am ddim hwn, i ddau gynrychiolydd yn unig o bob gweithle neu leoliad gwaith. Fel rhan o’r amodau mynychu gofynnir ichi rannu’r hyn a ddysgwyd gennych ar y cwrs â’ch gweithle a’ch cydweithwyr. Er bod y cwrs hwn yn rhad ac am ddim byddwn yn codi ffi weinyddol os bydd lleoedd yn cael eu canslo’n hwyr, fel a ganlyn: Peidio â rhoi gwybod na fyddwch yn mynychu- £50, Llai na 48 awr o rybudd na fyddwch yn mynychu £30, Llai na 1 wythnos o rybudd na fyddwch yn mynychu £25. Drwy gofrestru ar y cwrs byddwch yn cytuno â’r costau hyn am ganslo hwyr neu beidio â mynychu.

Elevate your sales skills with our Sales Assistant Training course. Master customer understanding, negotiation, and advanced sales strategies to excel in the dynamic world of sales. Ideal for those aiming to thrive in the UK sales sector.

Duration 2 Days 12 CPD hours This course is intended for This class assumes some prior experience with Git, plus basic coding or programming knowledge. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert team, students will explore: Getting Started with Collaboration Understanding the GitHub Flow Branching with Git Local Git Configuration Working Locally with Git Collaborating on Your Code Merging Pull Requests Viewing Local Project History Streaming Your Workflow with Aliases Workflow Review Project: GitHub Games Resolving Merge Conflicts Working with Multiple Conflicts Searching for Events in Your Code Reverting Commits Helpful Git Commands Viewing Local Changes Creating a New Local Repository Fixing Commit Mistakes Rewriting History with Git Reset Merge Strategies: Rebase This is a fast-paced hands-on course that provides you with a solid overview of Git and GitHub, the web-based version control repository hosting service. While the examples in this class are related to computer code, GitHub can be used for other content. It offers the complete distributed version control and source code management (SCM) functionality of Git as well as adding its own features. It provides access control and several collaboration features such as bug tracking, feature requests, task management, and wikis for every project. Getting Started with The GitHub Ecosystem What is Git? Exploring a GitHub Repository Using GitHub Issues Activity: Creating A GitHub Issue Using Markdown Understanding the GitHub Flow The Essential GitHub Workflow Branching with Git Branching Defined Activity: Creating a Branch with GitHub Introduction Class Diagram Interaction Diagrams Sequence Diagrams Communication Diagrams State Machine Diagrams Activity Diagram Implementation Diagrams Local Git Configuration Checking your Git version Git Configuration Levels Viewing your configurations Configuring your username and email Configuring autocrif Working Locally with Git Creating a Local copy of the repo Our favorite Git command: git status Using Branches locally Switching branches Activity: Creating a New File The Two Stage Commit Collaborating on Your Code Collaboration Pushing your changes to GitHub Activity: Creating a Pull Request Exploring a Pull Request Activity: Code Review Merging Pull Requests Merge Explained Merging Your Pull Request Updating Your Local Repository Cleaning Up the Unneeded Branches Viewing Local Project History Using Git Log Streaming Your Workflow with Aliases Creating Custom Aliases Workflow Review Project: GitHub Games User Accounts vs. Organization Accounts Introduction to GitHub Pages What is a Fork? Creating a Fork Workflow Review: Updating the README.md Resolving Merge Conflicts Local Merge Conflicts Working with Multiple Conflicts Remote Merge Conflicts Exploring Searching for Events in Your Code What is GitHub? What is Git bisect? Finding the bug in your project Reverting Commits How Commits are made Safe operations Reverting Commits Helpful Git Commands Moving and Renaming Files with Git Staging Hunks of Changes Viewing Local Changes Comparing changes with the Repository Creating a New Local Repository Initializing a new local repository Fixing Commit Mistakes Revising your last commit Rewriting History with Git Reset Understanding reset Reset Modes Reset Soft Reset Mixed Reset Hard Does gone really mean gone? Getting it Back You just want that one commit Oops, I didn?t mean to reset Merge Strategies: Rebase About Git rebase Understanding Git Merge Strategies Creating a Linear History Additional course details: Nexus Humans Introduction to GITHub for Developers (TTDV7551) 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 Introduction to GITHub for Developers (TTDV7551) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This program is designed for students who have attended successfully the IJOS and JRE courses (prior to April 1, 2017) or the IJOS course (since April 3, 2017) and are working toward JNCIA-JUNOS certification. Overview The objectives for this course follow the requirements for the current JNCIA-JUNOS. At the end of this course, the successful student will be able to: Identify the concepts and functionality of various fundamental elements of networking Identify the concepts, benefits and functionality of the core elements of the Junos OS Identify the concepts, operation and functionality of the Junos user interfaces Identify the main elements for configuring Junos devices Describe how to configure basic components of a Junos device Identify methods of monitoring and maintaining Junos devices Describe monitoring and maintenance procedures for a Junos device Identify basic routing concepts and functionality for Junos devices Describe how to configure and monitor basic routing elements for a Junos device Identify the concepts and functionality of routing policy and firewall filters on Junos devices Describe how to configure and monitor routing policies and firewall filters on a Junos device Apply knowledge of Junos operating system configuration, operations, and functionality to real-world scenarios This intense, two-day program is designed to prepare attendees who have previously taken the Introduction to the Junos Operating System (IJOS) course for taking the certification exam while simultaneously gaining insight into real-world applications Session 1: Practice Labs Guided practice labs to reintroduce the lab environment Session 2: Real-World Scenario Labs Labs that emulate real-world application of JNCIA-level knowledge, configurations, operations, and functionality. These labs will challenge students to complete scenario-based problems to accomplish specific network goals. Session 3: Networking Fundamentals Collision domains and broadcast domains Function of routers and switches Optical network fundamentals ? SONET/SDH, OTN Ethernet networks Layer 2 addressing, including address resolution IPv4 and IPv6 fundamentals Layer 3 / IP addressing, including subnet masks Subnetting and supernetting Decimal to binary conversion Longest match routing Connection-oriented vs. connectionless protocols Session 4: Junos OS Fundamentals Junos device portfolio ? product families, general functionality Software architecture Control and forwarding planes Routing Engine and Packet Forwarding Engine Protocol daemons Transit traffic processing Exception traffic Session 5: User Interfaces CLI functionality CLI modes CLI navigation CLI Help Filtering output Active vs. candidate configuration Reverting to previous configurations Modifying, managing, and saving configuration files Viewing, comparing, and loading configuration files J-Web ? core/common functionality Session 6: Junos Configuration Basics Initial configuration User accounts Login classes User authentication methods Interface types and properties Configuration groups Additional initial configuration elements ? NTP, SNMP, syslog, etc. Configuration archival Logging and tracing Rescue configuration Session 7: Operational Monitoring and Maintenance Show commands Monitor commands Interface statistics and errors Network tools ? ping, traceroute, telnet, SSH, etc. Real-time performance monitoring (RPM) Junos OS installation Software upgrades Powering on and shutting down Junos devices Root password recovery Session 8: Routing Fundamentals Packet forwarding concepts Routing tables Routing vs. forwarding tables Route preference Routing instances Static routing Advantages of / use cases for dynamic routing protocols Session 9: Routing Policy and Firewall Filters Default routing policies Import and export policies Routing policy flow Effect of policies on routes and routing tables Policy structure and terms Policy match criteria, match types, and actions Firewall filter concepts Firewall filter concepts Filter match criteria and actions Effect of filters on packets Unicast reverse-path-forwarding (RPF) Session 10: JNCIA-JUNOS Certification Exam The exam voucher is included in the price of the course DWWTC is a certified PearsonVUE Testing Center' Additional course details: Nexus Humans JNCIA Practicum and Exam Preparation 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 JNCIA Practicum and Exam Preparation 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.