1706 Courses

Compass for Agility - Leveraging Agility for Business Problem-Solving Join Leila Rao as she introduces the Compass for Agility. This 90-day iterative approach is a pragmatic and personalized method, enabling organizations to build the capacity and culture for responding to challenges and opportunities. This provides a structure for organizations to explore what'ss working and what isnTt in their ecosystem to successfully and sustainably build the capability for continuous learning and improvement. The Compass helps with addressing "wicked" business problems set apart by one key variation: agile is the how, not the "why". Enhancing business agility is a fortunate by-product of directly resolving pain points because agile serves as the means, not the end. Empower your organization to orient itself by its unique needs and values so that you can continually create customized maps as you chart your own journey in volatile and uncertain terrains.

Unlock the power of SQL with the Mastering SQL Programming course. This comprehensive program takes you from the fundamentals to advanced techniques in SQL programming. Starting with setting up your tools, you'll delve into browsing, filtering, and sorting data. Explore complex operations, including mathematical calculations and string concatenation, while learning to manage NULL values and use CASE statements effectively. Dive into SQL functions, nested queries, and join operations, gaining mastery over data manipulation and database definition. Whether you're a beginner or seeking to enhance your SQL skills, this course equips you with the knowledge to become a proficient SQL programmer. Learning Outcomes: Establish a solid foundation in SQL programming principles. Efficiently browse, filter, and sort data for data retrieval. Utilize AND, OR, and NOT operators for precise data filtering. Perform mathematical operations and string concatenation in SQL. Apply sorting, alias names, and record limiting to enhance result readability. Handle NULL values and implement DISTINCT and CASE statements. Master multiple-row and single-row functions for complex data processing. Create nested queries and perform data manipulation using SQL. Why buy this Mastering SQL Programming?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Mastering SQL Programming you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Mastering SQL Programming course is ideal for Aspiring database administrators and SQL developers. Individuals looking to enhance their data management skills. Business analysts seeking SQL proficiency for data analysis. Anyone interested in learning SQL programming from basics to advanced concepts. Prerequisites This Mastering SQL Programming 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. Career path SQL Developer: £30,000 - £60,000 per year. Database Administrator (DBA): £35,000 - £70,000 per year. Data Analyst: £25,000 - £55,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. SQL Instructor/Trainer: Earnings vary based on experience and location.

Acceptance and Commitment CBT

Overview In a world where diversity is our strength, understanding the nuances of equality, diversity, and discrimination is paramount. The course 'Equality, Diversity and Discrimination' offers a comprehensive insight into the legislation relating to equality diversity and discrimination, ensuring that individuals and organisations are well-versed in the codes of practice for diversity equality inclusion and discrimination. From the foundational principles of human rights to the intricate details of unconscious bias and affirmative action, this course provides a holistic view, ensuring that learners are equipped to promote inclusivity and challenge discrimination in all its forms. The curriculum delves deep into the integration of equality and diversity into policies, highlighting the significance of promoting social inclusion. By exploring the links between values, attitudes, and beliefs, learners will gain a profound understanding of the root causes of stereotypes, prejudice, and bias.  In today's globalised society, fostering an environment of equality diversity inclusion and discrimination awareness is not just a moral imperative but also a strategic necessity. This course is a beacon for those who wish to be at the forefront of creating inclusive spaces, ensuring that every individual, irrespective of their background, feels valued and respected. Learning Outcomes: Understand the foundational principles of equality, diversity, and the various forms of discrimination. Gain knowledge of the legislation and codes of practice related to equality, diversity, and discrimination. Develop strategies to integrate equality and diversity into organisational policies and practices. Recognise and challenge stereotypes, prejudices, and biases, both conscious and unconscious. Explore the mechanisms of institutional discrimination and learn the importance of affirmative action and monitoring. Why buy this Equality, Diversity and Discrimination course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Equality, Diversity and Discrimination there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Equality, Diversity and Discrimination course for? Individuals keen on understanding the intricacies of equality and diversity in the modern world. Organisations aiming to foster an inclusive work environment. Policy makers and strategists focused on integrating equality and diversity principles. Educators and trainers looking to incorporate equality and diversity teachings. Advocates and activists championing for human rights and social inclusion. Prerequisites This Equality, Diversity and Discrimination does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Equality, Diversity and Discrimination 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. Career path Equality and Diversity Officer: £25,000 - £35,000 Annually Human Rights Advocate: £30,000 - £45,000 Annually Policy Advisor on Equality and Diversity: £40,000 - £55,000 Annually Diversity and Inclusion Consultant: £45,000 - £60,000 Annually Social Inclusion Manager: £35,000 - £50,000 Annually Unconscious Bias Trainer: £30,000 - £45,000 Annually Course Curriculum Module 01: Introduction to Equality, Diversity and Discrimination Introduction to Equality, Diversity and Discrimination 00:41:00 Module 02: Equality and Diversity Legislation Equality and Diversity Legislation 00:47:00 Module 03: Integrating Equality and Diversity into Policy Integrating Equality and Diversity into Policy 00:41:00 Module 04: Human Rights Human Rights 00:41:00 Module 05: Promoting Diversity and Social Inclusion Promoting Diversity and Social Inclusion 00:36:00 Module 06: Equality Analysis Equality Analysis 00:34:00 Module 07: Links between Values, Attitudes and Beliefs Links between Values, Attitudes and Beliefs 00:40:00 Module 08: Basics of Discrimination Basics of Discrimination 00:46:00 Module 09: Stereotypes, Prejudice, Discrimination and Bias Stereotypes, Prejudice, Discrimination and Bias 00:35:00 Module 10: Institutional Discrimination Institutional Discrimination 00:27:00 Module 11: Unconscious Bias Unconscious Bias 00:29:00 Module 12: Affirmative Action Affirmative Action 00:28:00 Module 13: Monitoring Equality and Diversity Monitoring Equality and Diversity 00:35:00 Assignment Assignment - Equality & Diversity and Discrimination 00:00:00

This beginner's course exclusively delivers Python programming from basic to advanced. You will learn Python concepts in real-life programming examples by building real-world applications. Learn the syntax of Python language and understand the logic behind the programming process to create your Python programs successfully and master Python coding.

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

ESG and impact investing are two of the most rapidly growing areas of finance, as more investors seek to align their values with their financial goals. ESG stands for environmental, social, and governance, which are the criteria used to evaluate the sustainability and ethical practices of companies and projects. Impact investing is a subset of ESG investing that aims to generate positive social and environmental impact, as well as financial returns. This course will teach you the fundamentals of ESG and impact investing, from their origins and motivations to their applications and benefits. You will gain a solid understanding of the ESG factors that influence the performance and risk of investments, and how to assess them using various methods and tools. By the end of this course, you will be able to apply ESG and impact investing principles and practices to make informed and responsible investment decisions.

Duration 3 Days 18 CPD hours Overview VMware vSphere: What's New [V8] https://lms.nhcms.neYou will learn essential Terraform concepts including: Writing Terraform HCL code Deploying into common clouds such as AWS, Azure, Docker, Kubernetes, and VMWare Where Terraform fits in the Enterprise CI/CD model Differences between Terraform and Ansible As enterprises seek to deploy and maintain increasingly complex cloud infrastructure, there is a necessity to use ?Infrastructure as Code? (IaC) tools, like Terraform. An open-source, state management tool developed by HashiCorp, Terraform allows developers to use a common coding interface to work through their various clouds safely and efficiently. Attendees will leave being able to write and understand Terraform code (HCL), have a clear understanding of Terraform?s various components and supporting tools, as well as when to reach for Terraform over another IaC tool, such as Ansible. This class prepares you for Terraform Certifcation. Up and Running with Terraform Terraform Overview Defining ?declarative? How to think about Terraform (versus Ansible) Reviewing the Terraform Configuration Running the Terraform Configuration Provisioners Syntax Low Level? HCL syntax Style Conventions Comments Blocks Arguments JSON Configuration Syntax Resources Meta-Arguments depends_on count for_each provider lifecycle Data Sources Variables and Output Input Variables Output Values Local Values Functions String Collection Numeric Encoding Filesystem Date and Time Hash and Crypto IP Network Type Conversion Modules Module Blocks Module Sources Meta Arguments Terraform Templates templatefile Function Template Demonstration Introducing Data Sources Creating an External Data Source Building tftpl template files Expressions Types and Values Strings and Templates Reference to Values Operators Function Calls Conditionals For Expressions Splat Expressions Dynamic Blocks Type Constraints Version Constraints State Understanding the importants of states state storage and locking importing existing resources Remote State What to do when local state is lost CICD Piplines with Terraform Terraform and GitLab pipelines Terraform and Jenkins pipelines Enterprise Case Studies Terraform and Docker Terraform and Kubernetes Terraform and Amazon AWS Terraform and Azure Terraform and VMWare Understanding how to apply Terraform to your unique infrastructure Beyond Basics Intro to Go Programming Terraform Cloud Additional HashiCorp Offerings Backends Secrets Additional course details: Nexus Humans Terraform 101 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 Terraform 101 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.

Gain proficiency in the mastery of Geographic Information Systems (GIS) via ArcGIS Desktop

The Real Estate Development School is a five day course that focuses on both the theoretical and practical elements of Commercial Real Estate Development.