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

2020 Courses

Ultimate PHP & MySQL Web Development Course & OOP Coding

4.9(27)

By Apex Learning

Overview This comprehensive course on Ultimate PHP & MySQL Web Development Course & OOP Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Ultimate PHP & MySQL Web Development Course & OOP Coding comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Ultimate PHP & MySQL Web Development Course & OOP Coding. It is available to all students, of all academic backgrounds. Requirements Our Ultimate PHP & MySQL Web Development Course & OOP Coding is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 133 lectures • 10:06:00 total length •Introduction: 00:02:00 •Setup On Windows: 00:15:00 •Setup On Mac: 00:11:00 •Setup On Linux: 00:12:00 •Online Code Editor: 00:03:00 •Basic File Syntax: 00:05:00 •Printing (echo): 00:06:00 •Comments: 00:05:00 •Variables: 00:06:00 •Variable Data Types: 00:07:00 •Variable Naming: 00:03:00 •Constants: 00:02:00 •Arrays: 00:05:00 •Associative Arrays: 00:06:00 •Multidimensional Arrays: 00:04:00 •if Statement: 00:06:00 •ifelse Statement: 00:02:00 •ifelseifelse Statement: 00:05:00 •Switch Statement: 00:06:00 •while Loop: 00:06:00 •doWhile Loop: 00:03:00 •for Loop: 00:03:00 •foreach Loop: 00:05:00 •Break Statement: 00:02:00 •Continue Statement: 00:02:00 •Basic Function: 00:03:00 •Passing Function Arguments: 00:03:00 •Passing Function Arguments By Reference: 00:04:00 •Default Argument Value: 00:02:00 •Function Returning Values: 00:05:00 •Dynamic Function Calls: 00:03:00 •Variable Scope: 00:04:00 •Simple HTML Form: 00:07:00 •GET vs POST: 00:05:00 •$_SERVER ['PHP_SELF']: 00:07:00 •Validating Form Data With PHP: 00:07:00 •Required Fields: 00:05:00 •Display Error Messages: 00:05:00 •Validate Name: 00:03:00 •Validate Email: 00:03:00 •Validate URL: 00:07:00 •Keep The Values In The Form: 00:04:00 •Read File (readfile()): 00:02:00 •Open, Read & Close A File (fopen(), fread(), fclose()): 00:04:00 •Read Single Line (fgets()): 00:03:00 •Check End-Of-File (feof()): 00:02:00 •Read Single Character (fgetc()): 00:02:00 •Write To File (fwrite()): 00:03:00 •Configure php.ini File For File Uploading: 00:02:00 •Front End HTML Upload Form: 00:04:00 •PHP Upload Script: 00:15:00 •Check If File Exists: 00:03:00 •Limit File Size: 00:05:00 •Limit File Type: 00:04:00 •MySQL vs MySQLi vs PDO: 00:05:00 •Creating A Database & Table (phpMyAdmin): 00:06:00 •Connecting To A Database: 00:06:00 •Get Data Using SELECT Query: 00:10:00 •WHERE Property For Filtering: 00:03:00 •LIKE Property For Pattern Search: 00:02:00 •Sorting Results Using ORDER BY Property: 00:01:00 •Using JOINS: 00:08:00 •Insert Data Using INSERT Query: 00:04:00 •Get ID Of The Last Inserted Row: 00:02:00 •Insert Multiple Rows: 00:05:00 •Update Data Using UPDATE Query: 00:03:00 •Delete Data Using DELETE Query: 00:02:00 •Delete All Rows In A Table Using TRUNCATE Query: 00:02:00 •Delete Table Using DROP Query: 00:02:00 •Limit Data Selections Using LIMIT, ROWNUM: 00:04:00 •Create Table Using CREATE Query: 00:03:00 •Clone/Duplicate Table: 00:03:00 •Alter Table: 00:05:00 •Create Database: 00:02:00 •Drop Database: 00:02:00 •SQL Injection & Prepared Statements: 00:09:00 •What Is XML?: 00:02:00 •What Is SimpleXML?: 00:02:00 •Parse XML String: 00:08:00 •Parse XML File: 00:02:00 •Get Node Values: 00:02:00 •Get Node Values of Specific Elements: 00:03:00 •Get Node Values - Loop: 00:03:00 •Get Attribute Values: 00:02:00 •What Is The XML Expat Parser?: 00:02:00 •Initializing The XML Expat Parser: 00:10:00 •Load and Output XML Using DOM Parser: 00:02:00 •Looping Through XML Using DOM Parser: 00:03:00 •What Is AJAX?: 00:02:00 •Load Simple Data Using AJAX Front End: 00:08:00 •Load Simple Data Using AJAX Back End: 00:05:00 •Load Data From A Database Using AJAX: 00:08:00 •Send A Plain Text Email: 00:04:00 •Send A HTML Email: 00:06:00 •Email Attachments: 00:17:00 •PHPMailer Setup: 00:03:00 •Send Email Using PHPMailer: 00:04:00 •Send HTML Email Using PHPMailer: 00:04:00 •Email Attachments Using PHPMailer: 00:02:00 •What Is Object Oriented Programming (OOP)?: 00:03:00 •Basic Class With Variables: 00:04:00 •Functions: 00:05:00 •Constructor: 00:04:00 •Destructor: 00:02:00 •Inheritance: 00:06:00 •Multi Class Inheritance: 00:03:00 •Function Overriding: 00:03:00 •Public vs Private vs Protected: 00:05:00 •Interfaces: 00:04:00 •Constants: 00:03:00 •Abstract Class: 00:06:00 •Static Keyword: 00:03:00 •Final Keyword: 00:02:00 •Initiating Parent Constructor: 00:02:00 •die() Function: 00:02:00 •Custom Error Handler: 00:04:00 •Triggering An Exception: 00:03:00 •Exception Handling: 00:05:00 •Create Database & Table: 00:04:00 •User Class & Database Connection: 00:15:00 •Register User Form: 00:09:00 •Inserting User Data Into Database: 00:10:00 •Registration Form Field Validation: 00:12:00 •Securing User Password: 00:03:00 •Check If Username or Email Already Exists: 00:11:00 •Retain Data After Failed Registration: 00:03:00 •Validate an Integer Within a Range: 00:04:00 •Validate IPv6 Address: 00:03:00 •Validate URL - Must Contain QueryString: 00:03:00 •Remove Characters With ASCII Value > 127: 00:04:00 •Including & Requiring External PHP Files: 00:05:00 •Resource: 00:00:00 •Assignment - Ultimate PHP & MySQL Web Development Course & OOP Coding: 00:00:00

Ultimate PHP & MySQL Web Development Course & OOP Coding
Delivered Online On Demand10 hours 6 minutes
£12

BOYS’ EMOTIONAL NEEDS

By Inclusive Solutions

This workshop gives an opportunity to focus on the emotional needs of boys and how to meet these. We lift the lid on an emerging urgent inclusion issue,namely meeting the emotional needs of boys. Everyone knows a boy. They may be pupil, son, brother, parent or partner. Boys when they become adults are over represented in the prison, and mental health system. Course Category Meeting emotional needs Description This workshop gives an opportunity to focus on the emotional needs of boys and how to meet these. We lift the lid on an emerging urgent inclusion issue,namely meeting the emotional needs of boys. Everyone knows a boy. They may be pupil, son, brother, parent or partner. Boys when they become adults are over represented in the prison, and mental health system. In one recent year 1300 young men committed suicide in the UK. In the UK the commonest cause of death among those aged 16-35 is suicide. Three men for every one woman kill themselves every year (Guardian, June 2006). 1 in 4 women experience domestic violence and 2 women a week are killed by a current or ex partner. Boys and men are a major concern. We need to find ways to allow them to unclench their hearts and learn to experience, process, communicate and manage their own emotional lives for their own and for the good of the wider community. Testimonials ‘Thanks for a super day, lots of good ideas for our citizens of the future. We need to offer them the best and what we would offer our own children’?? ‘Enjoyed the day very much. Brilliant ideas and lots of food for thought. Will use the solution circle. A great tool!’ ‘went well and the ethos/participation was commendably facilititated. well done’. ‘Wonderful day!’ ‘Still getting lots of positive messages this end.’ Learning Objectives Increased understanding of boys’ emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of core values surrounding inclusion of boys Opportunity to reflect on professional attitudes and behaviour towards boys and their emotional challenges New skills and processes to make boys’ inclusion and achievement more successful Who Is It For ? Early years and school based practitioners Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content The course explores the questions : Is there a problem with boys? What can we do to meet the emotional needs of boys? What helps? What should our priority be with boys? This workshop will explore: Cultural and historical expectations of boys in our society Shared experiences of teaching and parenting boys Circle of Courage as away of understanding emotional needs Fathers, mothers and sons Drinking and drugs: filling the emotional void Depression and suicide Anger and violence Solution Circle Problem Solving around boys needs What boys really need

BOYS’ EMOTIONAL NEEDS
Delivered in UK Wide Travel Costs or OnlineFlexible Dates
£1,800 to £2,500

Master C# and SQL by Building Applications

By Packt

This video course will help you build applications using the power of C# and SQL. You will not only learn to write flawless console applications in C# but also learn how to build SQL tables and views, work with stored procedures and SQL user-defined data types, and a lot more. You will also become comfortable in handling communication between the C# code and SQL database.

Master C# and SQL by Building Applications
Delivered Online On Demand6 hours 4 minutes
£82.99

Job-Ready SQL in an Afternoon

By Packt

Welcome to a hands-on SQL course. In this course, you will learn the fundamentals of SQL databases and the relational model. We will cover core concepts such as inserting data into SQL databases, extracting data from SQL databases, aggregations, subqueries, joins, unions, and window functions. This course will help you write complex queries to perform tasks as required in technical interviews or on the job.

Job-Ready SQL in an Afternoon
Delivered Online On Demand6 hours 14 minutes
£82.99

Stress can affect your ability to think clearly and rationally and to perform well. This session aims to help you better deal with stress by sharing key insights and strategies to reduce stress and optimize your work-life balance, particularly as we face uncertainties in the economy, the workplace and the environment.

Stress Management
Delivered in Loughborough or UK Wide or OnlineFlexible Dates
£180

Microsoft Office 2010 Access Intermediate - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2010 Access Intermediate - Complete Video Course builds on the skills and concepts taught in Access 2010: Basic. In this series, you will learn about relational databases, related tables, complex queries, advanced form design, reports and printing, charts, and PivotTables and PivotCharts. From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will discover the fundamentals of database design and construction, which will allow you to construct a strong relational database that makes future modifications and data analysis easier. Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for this powerful database program and build an entire data project from scratch. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Access Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Access Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Relational Databases Database Normalization 00:14:00 Table Relationships 00:13:00 Referential Integrity 00:12:00 Related Tables Creating Lookup Fields 00:11:00 Modifying Lookup Fields 00:06:00 Using Subdatasheets 00:04:00 Complex Queries Joining Tables in Queries 00:26:00 Using Calculated Fields 00:09:00 Summarizing and Grouping Values 00:08:00 Advanced Form Design Adding Unbound Controls 00:08:00 Adding Graphics 00:04:00 Adding Calculated Values 00:06:00 Adding Combo Boxes 00:04:00 Advanced Form Types 00:10:00 Reports and Printing Customized Headers and Footers 00:17:00 Calculated Values 00:08:00 Printing 00:03:00 Labels 00:05:00 Charts Charts in Forms 00:08:00 Charts in Reports 00:06:00 PivotTables and PivotCharts PivotTables 00:05:00 Modifying PivotTables 00:07:00 PivotCharts 00:04:00 PivotTable Forms 00:01:00 Mock Exam Mock Exam- Microsoft Office 2010 Access Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Access Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2010 Access Intermediate - Complete Video Course
Delivered Online On Demand3 hours 59 minutes
£22

Innovation and Design - Thinking Beyond the Obvious: On-Demand

By IIL Europe Ltd

Innovation and Design - Thinking Beyond the Obvious: On-Demand Thinking and doing the same has got to change. The world we live in is becoming more volatile, uncertain, complex, and ambiguous. Expanding our innovation and design thinking capabilities is a key to unlock solutions for some of our biggest global and local challenges. What do you need to learn, do, and become in order to continue in the current and future environment? It is a powerful combination of knowledge, competencies, and mindset. In an increasingly complicated context, this course provides participants with the knowledge needed to not only learn about innovation and what is needed to make it sustainable in your organization but also to inspire others to innovate and think beyond the obvious, What You Will Learn At the end of this program, you will be able to: Explain the link between innovation and strategy Describe the value of expanding your innovation practice and creating an innovative culture would be Apply a basic set of Design Thinking techniques to your innovation projects Promote innovative practices within your teams and processes in your work environment Foundation Concepts The context for innovation What is innovation Comparing innovation to invention Innovation and Strategy Run and changing the business The power of disruptors Three horizons of growth Strategy and innovation portfolio links Innovation strategy and delivery Measuring value from innovation Design Thinking What is design thinking Why design thinking Design thinking frameworks Stanford university d.School model Design thinking general practices Innovative Decision Making Leaders focus on value creation Effective decision making Characteristics of great leaders and sponsors Measuring innovation leadership effectiveness Situational leadership and overcoming bias Building an Innovative Team Forming innovative teams Values and behaviors that support innovation Building an energized team culture Mindset is key Embracing collaboration and multimodal working Innovative Culture Introduction to organizational culture Benefits and barrier to enterprise agility Enabling innovation across the organization Leaders are critical Success factors for an innovative culture

Innovation and Design - Thinking Beyond the Obvious: On-Demand
Delivered Online On Demand30 minutes
£350

Safeguarding Children-CPD Approved

By BAB Business Group

Our Safeguarding courses have been created because, first and foremost, each and every one of us has basic human rights. Chief among these is the right to be healthy, happy and treated well, regardless of race, age, gender or location. When these rights are abused in some way it’s wrong, and it is therefore vital that guidelines, policies and procedures are followed to enable everyone, without exception to live a life in which these basic values and rights are maintained and upheld. Everyone, regardless of their age, gender, religion, ethnicity or background has the right to a healthy, happy life. Safeguarding is about minimising and managing the risks to vulnerable individuals. This course, ‘Safeguarding Children’, is aimed at anyone who has a duty of care for, or comes into contact with children in their chosen profession. Although most children are brought up in loving, nurturing environments and grow up to lead happy lives, the subject has to be discussed in order to better protect those children that need it most. During this course you will hear many facts, figures and details surrounding the risk to children, the types of abuse suffered, how to recognise the signs of abuse and key safeguarding legislations put in place to minimise the abuse of children. Once you are able to recognise the signs of possible abuse, and know the steps you should take if you suspect it you will be better able to protect the children in your care.

Safeguarding Children-CPD Approved
Delivered Online On Demand
£30

ITIL© 4 Strategist - Direct Plan and Improve (DPI)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Delegates attending this course must have successfully achieved the ITIL 4 Foundation Qualification; your certificate must be presented as documentary evidence to gain admission to this course. Although there is no mandatory requirement, ideally candidates should have at least two years professional experience working in IT Service Management. The ITIL 4 DPI Qualification would most likely suit the following delegates: Individuals continuing of their journey in service management ITSM managers and aspiring ITSM managers Managers of all levels involved in shaping direction and strategy or developing a continually improving team Existing ITIL qualification holders wishing to develop their knowledge The above list is a suggestion only; individuals may wish to attend based on their own career aspirations, personal goals or objectives. Delegates may take as few or as many Intermediate qualifications as they require, and to suit their needs. Overview The purpose of the ITIL 4 Direct Plan and Improve Qualification is: To provide the candidate with the practical skills necessary to create a ?learning and improving? IT organization, with a strong and effective strategic direction To provide practitioners with a practical and strategic method for planning and delivering continual improvement with the necessary agility The objectives of this course are to: Understand the Key Concepts of Direct, Plan & Improve Understand the scope of what is to be directed and/or planned, and know how to use key principles and methods of direction and planning in that context Understand the role of GRC (Governance, Risk & Compliance) and know how to integrate the principles and methods into the service value system Understand and know how to use the key principles and methods of continual improvement for all types of improvements Understand and know how to use the key principles and methods of Organizational Change Management to direction, planning and improvement Understand and know how to use the key principles and methods of measurement and reporting in directing, planning and improvement Understand and know how to direct, plan and improve value streams and practices This unique and central course covers requirements in both the ITIL Managing Professional and ITIL Strategic Leader designations. As such, this course is a must-have in any ITIL 4 professional development plan. You will gain the practical skills needed to establish a ?learning and improving? IT organization that possess a strong and targeted strategic direction. This class includes an exam voucher. Prerequisites ITIL© 4 Foundation 1 - KEY CONCEPTS OF DIRECT, PLAN AND IMPROVE Knowing key terms Differentiating between principle concepts Defining the relationship of Values, Outcomes, Costs and Risks 2 - SCOPING WHAT IS TO BE DIRECTED Cascading goals and requirements Deciphering effective policies, controls and guidelines Placing decision-making authority at the correct level 3 - THE ROLE OF GRC IN THE SERVICE VALUE SYSTEM The role of risk management How governance impacts DPI Ensuring that controls are sufficient but not excessive 4 - PRINCIPLES AND METHODS FOR CONTINUAL IMPROVEMENT Leverage the ITIL CI model Identify assessment objectives and outputs Select the appropriate assessment method Prioritize desired outcomes Build, justify and advocate your business case Conduct improvement reviews and lessons learned sessions Embed CI at all levels of the service value stream 5 - APPLYING COMMUNICATION AND ORGANIZATIONAL CHANGE MANAGEMENT The nature and benefits of OCM Manage, communicate effectively, and influence stakeholders Establish valuable interfaces across the value chain 6 - EFFECTIVE MEASURING AND REPORTING Defining indicators and metrics to support objectives 7 - DIRECT, PLAN AND IMPROVE VALUE STREAMS Recognizing the differences between value streams and practices Choosing the right methods and techniques to direct, plan and improve value streams Additional course details:Notes New Horizons is an Authorised Training Organisation (ATO) for Peoplecert for ITIL4 Nexus Humans ITIL 4 Strategist Direct Plan and Improve (DPI) with Exam 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 ITIL 4 Strategist Direct Plan and Improve (DPI) with Exam 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.

ITIL© 4 Strategist - Direct Plan and Improve (DPI)
Delivered OnlineFlexible Dates
£2,385

How Servant Leadership Drives Success Habitat for Humanity International´s Approach to Culture, Engagement, and Results

By IIL Europe Ltd

How Servant Leadership Drives Success Habitat for Humanity International´s Approach to Culture, Engagement, and Results A servant leadership culture engages employees and other stakeholders to create success and investment in the future. At Habitat for Humanity International, many of our employees are exceptionally committed to the mission and purpose of the organization driving high employee engagement, strong growth and resulting impact in providing decent, affordable housing around the world. A key element of our culture is our approach to servant leadership. Servant leadership includes a focus on: Integrity and moral reasoning; Serving followers not just for the good of the organization but for their personal development as well; Concern with the success of all stakeholders; Self-reflection and humility. A servant leadership culture is not without challenges, but ideally results in treating people in the way they like to be treated. It also ensures that leadership is continuously seeking feedback and challenging itself to learn and improve. Habitat is currently refining our cultural values and leadership behaviors to drive and support an aggressive strategy of drawing nearer to a world where everyone has a decent place to live. We are inspired by this important mission, and we're engaging our employees globally in defining how each of them will personally execute on the mission. We'll share the process we've gone through to engage everyone in the refinement of our cultural values and how we've integrated our servant leadership capability model in all aspects of our talent management processes.

How Servant Leadership Drives Success Habitat for Humanity International´s Approach to Culture, Engagement, and Results
Delivered Online On Demand15 minutes
£10