• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

37564 Courses delivered Online

Cisco Implementing Cisco Quality of Service v2.5 (QOS)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Channel Partner / Reseller Customer Employee Overview At course completion students will be able to: - Explain the need for QoS, describe the fundamentals of QoS policy, and identify and describe the different models that are used for ensuring QoS in a network - Explain the use of MQC and AutoQoS to implement QoS on the network and describe some of the mechanisms used to monitor QoS implementations - Given a converged network and a policy defining QoS requirements, classify and mark network traffic to implement the policy - Use Cisco QoS queuing mechanisms to manage network congestion - Use Cisco QoS congestion avoidance mechanisms to reduce the effects of congestion on the network - Use Cisco QoS traffic policing and traffic shaping mechanisms to effectively limit the rate of network traffic - Given a low speed WAN link, use Cisco link efficiency mechanisms to improve the badwidth efficiency of the link - Describe the recommended best practices and methods used for end-to-end QoS deployment in the enterprise This course provides students with knowledge of IP QoS requirements, conceptual models such as best effort, IntServ, and DiffServ, and the implementation of QoS on Cisco platforms. Introduction to QoS Review Converged Networks Understand QoS Describe Best-Effort and Integrated Services Models Describe the Differentiated Services Model Module Summary Module Self-Check Implement and Monitor QoS MQC Introduction Monitor QoS Define Campus AutoQoS Define WAN AutoQoS Module Summary Module Self-Check Lab 2-1: IP SLA Setup and QoS Baseline Measurement Lab 2-2: Configuring QoS with Cisco AutoQoS Classification and Marking Classification and Marking Overview Case Study 3-1: Classification and Marking MQC for Classification and Marking NBAR for Classification Use of QoS Preclassify Campus Classification and Marking Module Summary Module Self-Check Lab 3-1: Classification and Marking Using MQC Lab 3-2: Using NBAR for Classification Lab 3-3: Configuring QoS Preclassify Lab 3-4: Campus Classification and Marking Using MQC Congestion Management Queuing Introduction Configure WFQ Configure CBWFQ and LLQ Configure Campus Congestion Management Module Summary Module Self-Check Lab 4-1: Configuring Fair Queuing Lab 4-2: Configuring LLQ-CBWFQ Lab 4-3: Configuring Campus-Based Queuing Mechanisms Congestion Avoidance Congestion Avoidance Introduction Configure Class-Based WRED Case Study 5-1: WRED Traffic Profiles Configure ECN Describe Campus-Based Congestion Avoidance Module Summary Module Self-Check Lab 5-1: Configuring DSCP-Based WRED Lab 5-2: Configuring WTD Thresholds Traffic Policing and Shaping Traffic Policing and Shaping Overview Configure Class-Based Policing Campus Policing Configure Class-Based Shaping Configure Class-Based Shaping on Frame Relay Interfaces Configure Frame Relay Voice-Adaptive Traffic Shaping and Fragmentation Module Summary Module Self-Check Lab 6-1: Configuring Class-Based Policing Lab 6-2: Configuring Class-Based Shaping Link Efficiency Mechanisms Link Efficiency Mechanisms Overview Configure Class-Based Header Compression Configure LFI Module Summary Module Self-Check Lab 7-1: Configuring Class-Based Header Compression Lab 7-2: Configuring LFI Deploying End-to-End QoS Apply Best Practices for QoS Policy Design End-to-End QoS Deployments Module Summary Module Self-Check Lab 8-1: Mapping Enterprise QoS Policy to the Service Provider Policy Additional course details: Nexus Humans Cisco Implementing Cisco Quality of Service v2.5 (QOS) 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 Cisco Implementing Cisco Quality of Service v2.5 (QOS) 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.

Cisco Implementing Cisco Quality of Service v2.5 (QOS)
Delivered OnlineFlexible Dates
Price on Enquiry

iOS App Development Essentials

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Developers and architects who will be developing applications for iOS devices. In this course you'll be shown a complete introduction to iPhone and iPad development, emphasizing the newest technologies and best practices for iOS. Introduction & Setup Start Here Joining the Apple iOS Developer Program Installing Xcode and the iOS SDK A Guided Tour of Xcode An Introduction to Xcode Playgrounds Swift Programming Language Swift Data Types, Constants, and Variables Swift Operators and Expressions Swift Flow Control The Swift Switch Statement An Overview of Swift Functions The Basics of Object Oriented Programming in Swift An Introduction to Swift Subclassing and Extensions Working with Array and Dictionary Collections in Swift Understanding Error Handling in Swift Views, Layouts, & Storyboards iOS Application and Development Architecture Creating an Interactive iOS App Understanding Views, Windows and the View Hierarchy An Introduction to Auto Layout in iOS Working with iOS Auto Layout Constraints in Interface Builder Implementing iOS Auto Layout Constraints in Code Implementing Cross-Hierarchy Auto Layout Constraints in iOS Understanding the iOS Auto Layout Visual Format Language Using Trait Variations to Design Adaptive User Interfaces Using Storyboards in Xcode An Overview of iOS Table Views Using Xcode Storyboards to Build Dynamic TableViews Implementing TableView Navigation Working with the iOS Stack View Class A Guide to Multitasking in iOS Implementing a Page based iOS Application using UIPageViewController Data Storage with Files, iCloud, & Databases Working with Directories in Swift on iOS Working with Files in Swift on iOS Preparing an iOS App to use iCloud Storage Managing Files using the iOS UIDocument Class Using iCloud Storage in an iOS Application Synchronizing iOS Key-Value Data using iCloud iOS Database Implementation using SQLite Working with iOS Databases using Core Data CloudKit Data Storage on iOS Touch, Taps, & Gestures An Overview of iOS Multitouch, Taps and Gestures An Example iOS Touch, Multitouch and Tap Application Detecting iOS Touch Screen Gesture Motions Identifying Gestures using iOS Gesture Recognizers iOS 3D Touch Implementing TouchID Authentication in iOS Apps Advanced View Options Drawing iOS 2D Graphics with Core Graphics Interface Builder Live Views and iOS Embedded Frameworks Using Core Graphics and Core Image iOS Animation using UIViewPropertyAnimator iOS UIKit Dynamics iOS Sprite Kit Programming iOS Multitasking, Background Transfer Service and Fetching iOS Application State Preservation and Restoration Integrating Maps into iOS Applications Getting Location Information using the iOS Core Location Framework Extensions An Introduction to Extensions in iOS An iOS Today Extension Widget Tutorial Creating an iOS Photo Editing Extension Creating an iOS Action Extension Receiving Data from an iOS Action Extension Building iOS Message Apps Using Event Kit to Create Date and Location Based Reminders Multimedia and Social Media Accessing the iOS Camera and Photo Library iOS Video Playback using AVPlayer and AVPlayerViewController An iOS Multitasking Picture in Picture Tutorial Playing Audio on iOS using AVAudioPlayer Recording Audio on iOS with AVAudioRecorder iOS Speech Recognition Introduction to SiriKit Integrating Twitter and Facebook into iOS Applications The App Store Making Store Purchases with SKStoreProductViewController Class Building In-App Purchasing into iOS Applications Configuring and Creating App Store Hosted Content for iOS In-App Purchases Preparing and Submitting an iOS Application to the App Store Additional course details: Nexus Humans iOS App Development Essentials 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 iOS App Development Essentials 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.

iOS App Development Essentials
Delivered OnlineFlexible Dates
Price on Enquiry

BA28 - Requirements Analysis and Use Cases

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course has been expressly designed for the Business Analyst, Business System Analyst, System Analyst, and/or Requirements Engineer. The Designer, Developer and Tester who are actively involved in utilizing use cases may also benefit from this workshop. Overview Employ use cases to elicit requirements, at a business, system or subsystem levelEmploy use cases to document the scope of a projectWrite use cases in a clear and unambiguous way.Model use cases with workflow diagramsPlan and divide up the project work based on your use casesManage a use case as it evolves over time and goes through many changes This course provides a strong foundation in the mechanics of use case diagramming and writing textual descriptions of use cases. In this highly interactive workshop, you will learn how to enhance and refine your use case skills, how to involve your stakeholders in the use case process, and how to develop use cases that provide valuable information to the designers and testers. Use cases that meet the needs of designers can be too technical and too detailed for other stakeholders. Use cases that satisfy business users are usually not very helpful to designers and testers. How do you satisfy these two disparate interests? And how do you handle the details like business rules, data validations and user interface specifications? Introduction Course objectives Understanding of business analysis Knowledge areas of BABOK© Guide Overview of Use Cases Describe the purpose and value of a use case approach Use case terminology Introducing a use case approach Needs Assessment Purpose of Needs Assessment Needs Assessment and use cases Defining and understanding the strategic goals and objectives Understanding the business process Identifying actors Identifying business information Analyzing locations and operations Drawing the business use case diagram Building the business architecture Defining solution options Defining System Scope Product scope/project scope System actors versus business actors Analyzing the business process model Analyzing business use cases Identifying candidate use cases Identifying scenarios Diagramming use cases Draw a use case diagram Create a use case catalog Evaluating, Prioritizing, and Packaging Use Cases Iterative nature of this work Evaluating use cases Use case priority Use case risk Use case complexity Use case dependencies Evaluate and Prioritize use cases Dividing work up between releases Packaging A process for how to perform packaging Writing the Main Success Scenario Use case descriptions Primary and secondary goals Assumptions Pre-conditions Triggers Post-conditions Scenario example Main success scenario Conditional execution Use cases and requirements Best practices for writing a use case description Writing the Other Scenarios Scenarios and flows Alternate scenarios and flows Alternate vs. basic flow Guidelines for alternate flows Exception flows Failed post conditions Write alternate and exception flows Process Modeling to Describe Use Case Flows UML© Activity Diagram Notation Sequencing activities Developing an activity diagram Facilitated sessions Draw a UML© Activity Diagram Using Advanced Diagramming Techniques Commonality Dependency Relationships Identify relationships Comparing the different relationships Developing a Requirements Specification Requirements and use cases Detailed requirements Common approaches to specifications Non-functional requirements Write non-functional requirements User interface requirements UI data descriptions Business rules Decision tables and inference rules How to document simple calculations Reporting requirements Data requirements Data accessibility requirements Traceability Course Summary Wrap-up Finding more information Additional course details: Nexus Humans BA28 - Requirements Analysis and Use Cases 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 BA28 - Requirements Analysis and Use Cases 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.

BA28 - Requirements Analysis and Use Cases
Delivered OnlineFlexible Dates
Price on Enquiry

ICT: Information and Communication Technology

4.5(3)

By Studyhub UK

Step into the dynamic and ever-evolving world of ICT with our ICT: Information and Communication Technology course. This isn't just a course; it's a gateway to understanding the vast and intricate universe of information management. The journey begins with an Introduction to Information Management, where you'll be greeted not just with concepts and theories, but with the real-life applications and significance of efficiently managing information. This module sets the tone for a deeper understanding of the critical role information plays in today's digital world. As you progress, delve into the strategic aspects of information management with Module 02, where crafting a robust Information Management Strategy is more than learning-it's about envisioning and shaping the future of information flow in organizations. The course takes you through the technicalities and intricacies of Databases and Information Management, followed by an exploration of Management Information Systems (MIS), where you learn to merge technology with business acumen. Your learning journey also encompasses Auditing Information Systems, ensuring not just the efficiency but also the security and integrity of information. The course culminates with an important discussion on Ethical and Social Issues and Data Protection, equipping you with the knowledge to navigate the complex moral landscape of the digital age. By the end of this course, you'll be more than just knowledgeable; you'll be a responsible and forward-thinking custodian of information in the digital era. Learning Outcomes Gain a foundational understanding of information management in the ICT sector. Develop strategies for effective information management within organizations. Learn about the design and implementation of databases and information systems. Understand the principles of auditing information systems for efficiency and security. Acquire knowledge about the ethical, social, and legal aspects of information technology. Why choose this ICT: Information and Communication Technology course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this ICT: Information and Communication Technology course for? Aspiring ICT professionals seeking foundational knowledge in information management. Business managers and administrators aiming to implement effective ICT strategies. Data management officers and system auditors. Students and academics interested in the field of information technology. Professionals in any field looking to enhance their ICT skills for workplace efficiency. Career path Information Technology Manager: £30,000 - £55,000 Database Administrator: £25,000 - £50,000 Systems Analyst: £28,000 - £45,000 Data Protection Officer: £30,000 - £55,000 ICT Consultant: £35,000 - £60,000 Information Systems Auditor: £32,000 - £50,000 Prerequisites This ICT: Information and Communication Technology does not require you to have any prior qualifications or experience. You can just enrol and start learning.This ICT: Information and Communication Technology was made by professionals and it is compatible with all PC's, Mac's, 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Information Management Introduction to Information Management 00:32:00 Module 02: Information Management Strategy Information Management Strategy 00:17:00 Module 03: Databases and Information Management Databases and Information Management 00:29:00 Module 04: Management Information Systems (MIS) Management Information Systems 00:16:00 Module 05: Auditing Information Systems Auditing Information Systems 00:16:00 Module 06: Ethical and Social Issues and Data Protection Ethical and Social Issues and Data Protection 00:27:00 Assignment Assignment - ICT: Information and Communication Technology 00:00:00

ICT: Information and Communication Technology
Delivered Online On Demand2 hours 17 minutes
£10.99

Speech and Language Therapy

4.7(26)

By Academy for Health and Fitness

Ask yourself if you enjoy Working with people of all ages and from all backgrounds Bringing together science, education, social sciences, languages, linguistics and medicine Working as part of a team Listening and communicating with people Solving problems Always learning new things and being creative Leading a team If you answered yes to any of the above, speech and language therapy could be an excellent fit for you. Speech and language therapists (SLTs) are allied health professionals. They work with parents, carers and other professionals, such as teachers, nurses, occupational therapists, and doctors, to provide treatment, support and care for children and adults with communication difficulties or eating, drinking and swallowing disorders. Enrol in this QLS-endorsed and CPD certified Speech and Language Therapy course to learn the core theoretical knowledge and skills required by a Speech and Language Therapist. The Speech and Language Therapy course covers the foundations of speech and language therapy, including both the social and clinical context of human communication. Throughout the course, you will understand speech anatomy and its characteristics. In addition, the course will strengthen your knowledge of literacy and language development and aspects of child Speech and Language disorders. Please note that this course does not entitle you to join the HCPC register or be a recognised Speech and Language Therapist. But you will come across all the basic guidelines of Speech and Language Therapy to boost and shine your knowledge in the field of Speech and language therapy and prepare yourself to start a career as an Speech and Language Therapist. Learning Outcome of Speech and Language Therapy course Understand the fundamentals of Speech & Language Therapy Explore the science of Speech Better communication ability with people who have Speech & Language disorders. Understand eating, drinking and swallowing disorders Know about child and adult Speech and Language disorders Learn the role of a Speech and Language Therapist Capability to help a child with SL difficulties Tips for starting a career as a Speech & Language Therapist Take a step toward a brighter future! Why Prefer this Speech and Language Therapy Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPDQS after completing the Speech and Language Therapy course. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. *** Course Curriculum *** Here is the curriculum breakdown of the Speech and Language Therapy course: Module 1: An Overview Module 2: The Science of Speech Module 3: The Anatomy of Speech Module 4: Characteristics of Speech: Linguistic Disciplines Module 5: Literacy & Language Development Module 6: Child Speech & Language Disorders Module 7: Adult Speech & Language Disorders Module 8: How to Help a Child with SL Difficulties Assessment Process After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analyzed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Speech and Language Therapy at QLS Level 5 exam, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme. CPD 150 CPD hours / points Accredited by CPD Quality Standards Requirements Disclaimer: Please note that this course does not entitle you to join the HCPC register or be a recognised Speech and Language Therapist. But you will come across all the basic guidelines of Speech and Language Therapy to boost and shine your knowledge in the field of speech and language therapy and prepare yourself to start a career as a Speech and Language Therapist. Career path Complete the course to enhance your CV and also prepare yourself for many career opportunities, including; SEN Teaching Assistant SEN Teacher Language Tutor Occupational Therapist Paediatric Occupational Therapist Counselling Rehabilitation Manager Healthcare Administrator Working with school-aged children And many more! Certificates CPDQS Accredited Certificate Digital certificate - £10 Diploma in Speech & Language Therapy at QLS Level 5 Hard copy certificate - £119 Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Speech & Language Therapy at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS Upon finishing the Speech & Language Therapy course, you need to order to receive a Certificate Accredited by CPDQS that is accepted all over the UK and also internationally. The pricing schemes are: 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

Speech and Language Therapy
Delivered Online On Demand3 weeks
£12

Belbin Team Roles : personality profiling

By Beyond Theory: business training & coaching

leadership management training course belbin team roles

Belbin Team Roles : personality profiling
Delivered in Northampton or UK Wide or OnlineFlexible Dates
Price on Enquiry

Oracle 12c SQL Fundamentals

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS 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 Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c 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 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.

Oracle 12c SQL Fundamentals
Delivered OnlineFlexible Dates
Price on Enquiry

Get Help Embedding Cademy

4.8(6)

By Cademy

To streamline your website integration with Cademy, we invite you to schedule a Zoom consultation with one of our friendly developers. Prior to your appointment, please ensure your courses are published on Cademy. Additionally, confirm that you have the necessary permissions to modify your website. This includes accessing the admin panel of your content management system or website builder (such as Wordpress, Wix, Squarespace, etc.), or possessing the relevant credentials or instructions for site editing. If you are unsure about how to proceed, our developer will provide guidance during the call. During your consultation, a Cademy developer will assist you in embedding the free Cademy booking system into your website. You will be asked to share your screen, and our developer will guide you through the setup process step by step. Should you have any questions throughout the process, we are here to provide support and assistance.

Get Help Embedding Cademy
Delivered OnlineFlexible Dates
FREE

Dog Cleaning

4.5(3)

By Studyhub UK

Welcome to the fascinating world of 'Dog Cleaning,' where you'll embark on a journey of care, cleanliness, and canine well-being. This course is your key to becoming a proficient dog groomer, providing you with the knowledge and skills needed to ensure your furry friends are happy, healthy, and well-groomed. In this comprehensive program, you'll learn the art of bathing, drying, and grooming dogs effectively. From getting your canine companion to love bath time to caring for their eyes, ears, teeth, and nails, you'll delve deep into the essential aspects of dog cleaning. Upon completion, you'll be well-prepared to keep dogs of all breeds looking and feeling their best. Learning Outcomes Understand the general considerations of bathing and drying dogs. Learn techniques to make bath time an enjoyable experience for dogs. Master the bathing process for dogs of all sizes. Become skilled at drying dogs safely and efficiently. Gain knowledge in caring for a dog's eyes, ears, teeth, and nails. Why choose this Dog Cleaning course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Dog Cleaning course for? Dog enthusiasts and pet owners. Individuals aspiring to become professional dog groomers. Animal lovers interested in canine well-being. Pet caregivers seeking to enhance their skills. Anyone passionate about keeping dogs clean and healthy. Career path Dog Groomer: £16,000 - £30,000 Pet Care Assistant: £15,000 - £20,000 Animal Shelter Worker: £15,000 - £25,000 Veterinary Assistant: £16,000 - £25,000 Pet Store Sales Associate: £15,000 - £22,000 Dog Trainer: £18,000 - £35,000 Prerequisites This Dog Cleaning does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: General Considerations of Bathing and Dying General Considerations of Bathing and Dying 00:11:00 Module 02: Getting Your Dog to Love Bath Time Getting Your Dog to Love Bath Time 00:05:00 Module 03: Bathing Process Bathing Process 00:12:00 Module 04: Drying Your Dog Drying Your Dog 00:05:00 Module 05: Eyes, Ears, Teeth and Nail Care Eyes, Ears, Teeth and Nail Care 00:16:00 Module 06: Cleaning and Disinfecting the Grooming Area and Equipment Cleaning and Disinfecting the Grooming Area and Equipment 00:12:00

Dog Cleaning
Delivered Online On Demand1 hour 1 minutes
£10.99

Dog Nutrition

4.5(3)

By Studyhub UK

Embark on a delightful journey into the heart of canine well-being with our Dog Nutrition course. From the first wag of a tail to the last playful bark, understanding your furry friend's nutritional needs is paramount. In this course, we don't just explore the basics; we delve deep into the intricate world of dog nutrition, unveiling the key nutrients essential for a happy and healthy pet. From decoding the principles of feeding dogs to navigating the nuanced choices of dog food, this course is your companion in ensuring your furry friend thrives. Discover the art of creating a balanced diet tailored to your dog's unique needs, and learn about home-prepared diets that add an extra layer of care. As you progress through each module, you'll gain insights into feeding practices for different circumstances, helping you become your dog's nutrition maestro. Learning Outcomes Understand the fundamental principles of dog nutrition. Identify key nutrients crucial for a dog's well-being. Navigate the types of dog food available in the market. Learn the art of creating a balanced and nutritious diet for your dog. Gain insights into feeding practices for various life stages and health conditions. Why choose this Dog Nutrition course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Dog Nutrition course for? Pet owners seeking to enhance their dog's well-being. Aspiring dog nutritionists and pet care professionals. Individuals interested in pursuing a career in veterinary support. Animal welfare advocates looking to deepen their knowledge. Anyone passionate about ensuring dogs lead healthy and happy lives. Career path Pet Nutrition Consultant: £25,000 - £35,000 Veterinary Nutritionist: £30,000 - £45,000 Animal Welfare Officer: £22,000 - £30,000 Pet Care Specialist: £20,000 - £28,000 Dog Trainer and Behaviourist: £18,000 - £25,000 Pet Food Product Developer: £35,000 - £50,000 Prerequisites This Dog Nutrition does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Dog Nutrition was made by professionals and it is compatible with all PC's, Mac's, 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Dog Nutrition Introduction to Dog Nutrition 00:15:00 Module 02: Nutrients in a Dog's Diet Nutrients in a Dog's Diet 00:22:00 Module 03: Types of Dog Food Types of Dog Food 00:17:00 Module 04: Principles of Feeding Dogs Principles of Feeding Dogs 00:19:00 Module 05: Food Portion for Dogs Food Portion for Dogs 00:17:00 Module 06: Foods to Avoid and Approach with Caution Foods to Avoid and Approach with Caution 00:16:00 Module 07: Feeding Growing Puppies Feeding Growing Puppies 00:18:00 Module 08: Feeding Unwell Dogs Feeding Unwell Dogs 00:21:00 Module 09: Natural Diet for Dogs Natural Diet for Dogs 00:16:00 Module 10: Creating a Balanced Diet Creating a Balanced Diet 00:19:00 Module 11: Choosing the Right Diet for Your Dog Choosing the Right Diet for Your Dog 00:20:00 Module 12: Different Diets for Different Circumstances Different Diets for Different Circumstances 00:18:00 Module 13: Home-Prepared Diets Home-Prepared Diets 00:16:00 Module 14: Poor Nutrition in Dogs Poor Nutrition in Dogs 00:16:00

Dog Nutrition
Delivered Online On Demand4 hours 10 minutes
£10.99