3573 Windows courses

Administrative management focuses on needs of administrative procedures and using the right tools and techniques in the workplace. [course_titile] is originated for you to carry out administrative tasks to a professional standard. The course begins with by explaining the code of conduct as well as setting the tone in the workplace. Operating an office requires exceptional effort and management skills. Initially, this course is intended to prepare you to handle bullying in the workplace, conflict management and different types of conflict that often occur, necessary steps to avoid and overcome conflict, getting along in the workplace effectively as well. You will be able to create a positive work environment through communication and negotiation. In the course, you will get a clear understanding of closing the generation gap, ergonomics injury prevention, and eliminate workplace violence. Following that, you will learn about workplace harassment and things to do if you become a victim of it. Enroll now and get the most out of this course. Learning Outcomes: Identify what a code of conduct is and why a business should have one Identify what goes into a code of conduct Discuss how to implement a code of conduct in the workplace Create a code of conduct for a business Allot a definition about bullying of what it is and what not Realise the cost of bullying either to organisations nor to people Recognise behaviours associated with bullying as well as the factors behind them Learn some means to shut bullying and realise the roles you can play Acquire the knowledge of some routes to handle yourself from bullying Learn what you should do when encountered with bullying Figure out proper solutions to a bullying event (either within or outside the organisation) Be able to assist in creating an anti-bullying policy Become able to help generate an anti-bullying policy Identify how a positive workplace appears Get information and realise the major components suited to produce and sustain a positive work atmosphere Realise the role of an employee to generate your individual activities to manage a positive work environment Understand as a leader the responsibility you have to create and maintain a positive work environment Figure out Discover what type of team player you are and how that relates to your functioning in the team Know the importance of effective workplace relationships in creating and maintaining a positive work environment Know and understand the importance of working as a team and guidelines to good teamwork Discover your personal strengths and weaknesses in working cooperatively Discover your preference for dealing with workplace conflict Allot a definition to ergonomics and the terms it include Recognise from where you can get ergonomics information for your area Locate the ways ergonomics could be incorporated for your workplace Evaluate the environment for ergonomic risks, learn to open ways so as to solve the issues, as well as planning for their application. Recheck along with assessing your ergonomic endeavor Apply the change management technique proficiently Relate the fundamental principles linked to ergonomics Get to know outlining ergonomic practices to sit, stand, lift, carry, push, as well as to pull Make designs for an ergonomic workstation Recognise the crucial ergonomic features of tools as well as machines Interpret the role of the environmental factors for example, (sound, air quality, as well as light) play in ergonomics 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? Complete Workplace Administration 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 Complete Workplace Administration 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. Module : 1 What is it, and why? 00:15:00 What to leave in, what to leave out 00:15:00 What's it all about? 00:15:00 A Random Sample 00:30:00 What to Do When You Make a Mistake 00:15:00 Auditing 00:30:00 Putting it Together 00:15:00 Module : 2 Defining Bullying 00:15:00 Why Bullies Do What They Do 00:15:00 Building a Shield Against Bullies 00:15:00 What to Do If It Happens to You 00:30:00 What to Do If You Witness Bullying 00:15:00 Creating an Anti-Bullying Workplace 00:15:00 The Law on Bullying 00:15:00 Module : 3 Defining Conflict 00:15:00 Types of Conflict 00:15:00 Open Conflict vs. Hidden Conflict 00:15:00 Spontaneous and Reflective Behavior 00:15:00 The Johari Window 00:15:00 Stages of Conflict 01:00:00 Conflict Resolution Style Questionnaire 00:15:00 The Role of Communication in Conflict Resolution 00:30:00 Active Listening Skills 00:15:00 Paraphrasing Skills 00:15:00 Powerful Questions 00:15:00 Body Language 00:15:00 The Conflict/Opportunity Test 00:15:00 Conflict and Its Resolution 00:30:00 Helping Others Through Conflict 00:45:00 Module : 4 What Does a Positive Environment Look Like? 00:30:00 What Can I Do? 00:30:00 Team Player 00:15:00 Effective Workplace Relationships (I) 00:45:00 Effective Workplace Relationships (II) 00:30:00 Module : 5 The Case for Wellness 00:15:00 Building the Foundation 00:30:00 Gathering Support 00:15:00 Gathering Data 00:30:00 Performing a Needs Analysis 00:15:00 Implementing Your Workplace Wellness Program 00:15:00 Reviewing the Plan 00:15:00 Evaluating and Reporting Results 00:15:00 Module : 6 Getting Started 00:30:00 The Role of Ergonomics in Your Workplace 00:15:00 The Ergonomic Assessment Cycle 00:05:00 Identifying and Assessing Ergonomic Hazards 00:30:00 Developing a Plan to Address Ergonomic Issues 00:15:00 Identifying and Implementing Solutions 00:15:00 Obtaining Employee Buy-In 00:15:00 Tips for Successful Implementation 00:15:00 Reviewing Your Ergonomics Program 00:15:00 Basic Ergonomic Principles 00:15:00 Optimal Sitting and Standing 00:15:00 Safe Lifting and Transporting 00:15:00 Ergonomic Workstations 00:15:00 Safe Tool Selection and Use 00:15:00 Creating an Ergonomic Environment 00:30:00 Module : 7 What is Workplace Violence? 00:15:00 Understanding the Behavior Wheel 00:15:00 The Anger Management Process 00:30:00 Communicating Better 00:15:00 Basic Problem Solving Tools 01:00:00 Other Ways of Managing Anger 00:15:00 A Systems Approach 00:15:00 Developing a Policy and Program 00:15:00 Risk Assessment 00:30:00 Hiring Practices 00:15:00 Workplace Practices and Procedures 00:15:00 Security Systems and Personnel 00:15:00 Training Programs 00:15:00 Developing Emergency Response Plans 00:15:00 Program Review 00:15:00 The Immediate Response 00:15:00 Consulting with the Experts 00:15:00 Gathering Additional Information 00:15:00 Re-Evaluating Information 00:15:00 Communicating Incidents and Threats 00:15:00 Interviewing Employees 00:15:00 Risk Level Analysis 00:15:00 Reviewing the Options 00:15:00 Analyzing the Impact 00:15:00 Process Application 00:15:00 Module : 8 Defining Harassment 00:15:00 Defining Sexual Harassment 00:30:00 The Purpose of Training 00:15:00 Creating a Harassment Policy 00:30:00 Nipping it in the Bud 00:15:00 Protecting Yourself 00:15:00 What If It Happens to Me? 00:30:00 What If It's Happening to Someone Else? 00:15:00 Someone Has Filed a Complaint Against Me! 00:30:00 Addressing a Complaint 00:15:00 Handling False Complaints 00:15:00 Mediation 00:45:00 Investigating a Complaint 00:45:00 Making the Decision 00:15:00 Creating Solutions 00:15:00 After It's Over 00:15:00 Skill Application 00:15:00

Duration 3 Days 18 CPD hours This course is intended for This is an introductory-level XML training course, designed for those needing an introduction to concepts and technologies associated with XML and its related recommendations. Previous experience or knowledge of HTML is helpful but not essential. Overview This course is an intensive, hands-on introduction to XML, XPath, and XSLT. The course is a balanced mixture of theory and practical labs designed to take students from the basic fundamentals of XML through to the related advanced technologies. The students walk through the different standards in a structured manner to enable them to master the concepts and ideas, which are reinforced in the lab exercises. The course starts with the fundamentals of XML, including coverage of DTDs and XML Schema. It then moves on to the XPath and XSLT standards, and how to use them to transform XML documents into other documents such as HTML documents or other XML documents. This course provides indoctrination in the practical use of W3C standards (including XSL and XML Schema) and of implementing tools and technologies. This course is programming language independent, making it useful for Java, .NET, C++, and any other programming orientation. Graduates will hit the ground running, applying XML to projects at both an architectural as well as a line by line coding level. We can easily adapt this course to industry and client specific needs.In addition to valuable knowledge and working examples, students receive a copy of the 'Xtensil' product. This unique software was developed to assist in implementing, testing, and fielding XML applications. Xtensil is used as both a teaching aid and a straightforward, basic, fully functional XML toolkit that students can use on Windows and Linux platforms. Working in a hands-on learning environment student will learn to: Write well-formed XML documents Model business requirements using XML Handle XML reserved characters Validate an XML document with a DTD and with a Schema Centralize data and markup definition with entities Create DTDs and Schemas using XML tools Generate XML documents from databases Write XSL templates to transform XML documents into HTML Integrate XML, XSL and the DOM to implement a complete solution The Extensible Markup Language (XML) is a standard that is enabling a revolution in web applications and business to business interactions. XML is the basis for Wireless Markup Language (WML), Voice Markup Language (VoiceML), Simple Object Access Protocol (SOAP), Web Services, and numerous industry initiatives such as ACORD (insurance), PXML (proposal/RFP) and OTA (travel). Introduction to XML is a three-day, hands-on course geared for software developers who need to understand what XML is and how to use in with today's systems and architectures. This course covers the topics from tags to architectures. The course is a balanced mixture of theory and practical labs designed to take students from a quick review of the basic fundamentals of XML through to the related advanced technologies. The students walk through the different standards in a structured manner to enable them to master the concepts and ideas, which are reinforced in the lab exercises. The course starts with a quick review of the fundamentals of XML before covering XML Schema in detail. It then moves on to the XPath and XSLT covering advanced topics in both. Finally, XML and Web Services security mechanisms and issues are addressed. XML Content Introduction to XML XML Mechanics XML Structure Namespaces Structure Using Schemas XML Formatting CSS and Rendering XML XSL Transformations XSLT and XPath XPath 2.0 and XSLT 2.0 Overview XSL FO (Formatting Objects) Applying XML XML Interoperability XML Performance Improvements Web Services Overview XML Applications Additional course details: Nexus Humans Introduction to XML (TT4300) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to XML (TT4300) 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.

Introducing the 'Python Programming Bible | Networking, GUI, Email, XML, CGI' - your comprehensive, all-in-one resource for mastering Python! Are you an aspiring developer looking to dive into the ocean of Python programming or a seasoned coder seeking to level up your Python game? Look no further! Our course is expertly designed to take you from the basics to the complexities of Python, including Networking, GUI, Email, XML, and CGI. If you've ever dreamt of not just learning Python but truly mastering it, this is the course for you. This program is designed to provide a solid foundation and sharpen your skills in one of the most in-demand programming languages, while also introducing you to its many applications. This course starts with the basics of Python, providing a gentle yet thorough introduction and setup that caters to beginners as well as those looking to refresh their Python knowledge. As we study deeper into the heart of Python, we dive into objects, classes, and the power of regular expressions. But it doesn't stop there! You'll also become comfortable with concepts like CGI programming, which is an important building block for creating dynamic web pages. Navigating from core programming, we transition into the intricacies of managing databases and executing multithreading in Python. You'll gain the confidence to handle complex data management tasks, understand how Python interacts with databases, and efficiently manages multiple tasks simultaneously. The XML section allows you to get hands-on with parsing, data extraction, and manipulation, while the GUI section unveils the art of creating beautiful, user-friendly interfaces using Python. The course is enriched with a diverse set of resources, including real-world projects, quizzes, and interactive coding exercises. This is more than just a course, it's your passport to a new realm of opportunities, unlocking a world where Python programming is your strength, not just a skill.  So whether you're a student aiming to get a head start on your peers, a professional looking to diversify your skills, or an enthusiast wanting to dive deeper into the Python universe, the Python Programming Bible is the starting point for your journey to becoming a Python expert. Enrol today and step into a future of endless opportunities with Python! Learning Outcomes: Upon completion of the Python Programming Bible course, you should be able to: Understand and implement Python basics and advanced concepts. Build object-oriented programs with Python. Utilise regular expressions for pattern-matching tasks. Develop dynamic web pages using CGI programming. Interact with databases efficiently using Python. Apply multithreading for better utilisation of resources. Process and manipulate data using XML in Python. Design and create user-friendly GUIs with Python. Who is this course for? This Python Programming Bible course is ideal for the following: Beginners aiming to learn Python from scratch. Professionals looking to broaden their programming skills. Students pursuing a degree in Computer Science. Web developers looking to integrate Python into their toolkit. Data enthusiasts aiming to handle data with Python. Career Path: This Python Programming Bible course will help you to develop your knowledge and skills to pursue different careers, such as: Python Developer: (£35,000 - £70,000). Data Analyst: (£27,000 - £55,000). Web Developer: (£24,000 - £60,000). Data Scientist: (£45,000 - £90,000). Machine Learning Engineer: (£50,000 - £90,000). Software Developer: (£30,000 - £70,000). Certification After studying the course materials of the Python Programming Bible | Networking, GUI, Email, XML, CGI 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Prerequisites This Python Programming Bible | Networking, GUI, Email, XML, CGI does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming Bible | Networking, GUI, Email, XML, CGI 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. Course Curriculum Section 01: Introduction & Setup Introduction 00:02:00 Setup on Mac OS X 00:03:00 Setup On Linux/Ubuntu 00:03:00 Setup On Windows 00:03:00 Run Code Online 00:03:00 Section 02: Basics Comments 00:02:00 Variables & Variable Types 00:05:00 Lists 00:04:00 Tuples 00:03:00 Dictionary 00:06:00 Data Type Conversion 00:02:00 Arithmetic Operators 00:05:00 Comparison Operators 00:03:00 Assignment Operators 00:03:00 Bitwise Operators 00:10:00 Logical Operators 00:07:00 Membership Operators 00:02:00 Identity Operators 00:02:00 Operator Precedence 00:03:00 Decision Making 00:09:00 Loops 00:06:00 Loop Control Statements 00:05:00 Numbers 00:05:00 Strings 00:12:00 Lists In Depth 00:05:00 Tuples In Depth 00:06:00 Dictionary In Depth 00:08:00 Date & Time 00:07:00 Functions 00:11:00 Modules 00:05:00 File Inputs & Outputs 00:13:00 Handling Exceptions 00:07:00 Section 03: Classes/Objects Simple Example 00:04:00 Creating Instance Objects 00:01:00 Accessing Attributes 00:04:00 Constructor New & Init Method 00:06:00 Destroying Objects 00:02:00 Class Inheritance 00:04:00 Overriding Methods 00:03:00 Overloading Methods 00:01:00 Overloading Operators 00:04:00 Data Hiding 00:03:00 Section 04: Regular Expressions Match Function 00:05:00 Search Function 00:02:00 Advanced Expressions 00:05:00 Search & Replace 00:03:00 Section 05: CGI Programming Basic CGI Programming 00:08:00 Get Method 00:06:00 Post Method 00:05:00 Cookies 00:05:00 Section 06: Database Setup Database 00:02:00 Connect To Database 00:05:00 Create Table 00:03:00 INSERT Operation 00:04:00 READ Operation 00:06:00 UPDATE Operation 00:02:00 DELETE Operation 00:02:00 Simple Network Example 00:04:00 Simple Client 00:04:00 Section 07: Multithreading Initiate a New Thread 00:07:00 Create Thread 00:06:00 Synchronise Threads 00:03:00 Multithreaded Priority Queue 00:09:00 Section 08: XML Parse an XML File 00:10:00 Section 09: GUI Introduction 00:02:00 Button Preview 00:03:00 Canvas 00:04:00 Checkbutton 00:02:00 Entry 00:02:00 Frame 00:04:00 Label 00:02:00 List Box 00:02:00 Menu button 00:03:00 Menu 00:08:00 Message 00:02:00 Radio button 00:05:00 Scale 00:03:00 Scrollbar 00:04:00 Text 00:03:00 Top-level 00:02:00 Spinbox 00:02:00 Paned Window 00:03:00 Message Box 00:02:00 Label Frame 00:02:00 Section 10: Resource Resource 00:00:00 Assignment Assignment - Python Programming Bible | Networking, GUI, Email, XML, CGI 00:00:00

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

Duration 3 Days 18 CPD hours This course is intended for This course is intended for network administrators, operators, and engineers responsible for managing the normal day-to-day operation and administration of BIG-IP Access Policy Manager Overview This course provides the skills to create and manage BIG-IP APM system. This course covers three typical deployment scenarios for BIG-IP Access Policy Manager (APM) and is broken into three individual lessons. In lesson one, you learn how to configure BIG-IP APM to provide Active Directory-based authentication for a load-balanced pool of web servers. In lesson two, you learn how to create a policy that provides an SSL VPN (Network Access) resource to users, but only when they log into BIG-IP APM using a corporate-issued PC. Finally, lesson three builds on the first two lessons to create a policy that provides a dynamic landing page with both SSL VPN as well as an OWA (Portal Access) resource, but only to users with special authorization. Setting Up the BIG-IP System Introducing the BIG-IP System Initially Setting Up the BIG-IP System Archiving the BIG-IP Configuration Leveraging F5 Support Resources and Tools Configuring Web Application Access Review of BIG-IP LTM Introduction to the Access Policy Web Access Application Configuration Overview Web Application Access Configuration in Detail Exploring the Access Policy Navigating the Access Policy Managing BIG-IP APM BIG-IP APM Sessions and Access Licenses Session Variables and sessiondump Session Cookies Access Policy General Purpose Agents List Using Authentication Introduction to Access Policy Authentication Active Directory AAA Server RADIUS One-Time Password Local User Database Understanding Assignment Agents List of Assignment Agents Configuring Portal Access Introduction to Portal Access Portal Access Configuration Overview Portal Access Configuration Portal Access in Action Configuring Network Access Concurrent User Licensing VPN Concepts Network Access Configuration Overview Network Access Configuration Network Access in Action Deploying Macros Access Policy Macros Configuring Macros An Access Policy is a Flowchart Access Policy Logon Agents Configuring Logon Agents Exploring Client-Side Checks Client-Side Endpoint Security Exploring Server-Side Checks Server-Side Endpoint Security Agents List Server-Side and Client-Side Checks Differences Using Authorization Active Directory Query Active Directory Nested Groups Configuration in Detail Configuring AppTunnels Application Access Remote Desktop Network Access Optimized Tunnels Landing Page Bookmarks Deploying Access Control Lists Introduction to Access Control Lists Configuration Overview Dynamic ACLs Portal Access ACLs Signing On with SSO Remote Desktop Single Sign-On Portal Access Single Sign-On Using iRules iRules Introduction Basic TCL Syntax iRules and Advanced Access Policy Rules Customizing BIG-IP APM Customization Overview BIG-IP Edge Client Advanced Edit Mode Customization Landing Page Sections Deploying SAML SAML Conceptual Overview SAML Configuration Overview Exploring Webtops and Wizards Webtops Wizards Using BIG-IP Edge Client BIG-IP Edge Client for Windows Installation BIG-IP Edge Client in Action Lesson Configuration Project Additional Training and Certification Getting Started Series Web-Based Training F5 Instructor Led Training Curriculum F5 Professional Certification Program F5 Instructor Led Training Curriculum F5 Professional Certification Program Additional course details: Nexus Humans F5 Configuring BIG-IP APM - Access Policy Manager v13.x 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 F5 Configuring BIG-IP APM - Access Policy Manager v13.x 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.

Overview The Ultimate Microsoft Office 4 Courses Bundle Course will provide you with everything you need to master the skills for confidently using Microsoft Office in the workplace. You will develop the essential knowledge and abilities employers expect in Word, Excel, PowerPoint and Access. This is a unique bundle course that will teach you the essential shortcuts and time-saving tools, including how to modify the programs according to your needs. You will also be tutored in a wide range of topics in an extremely expert manner that will make your life easier, no matter what your work requires. After the completion of this online Microsoft Office training program, you will receive a valid acknowledgement in Microsoft Office, and be able to accomplish office tasks quickly, with greater efficiency. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Requirements There is no specific requirements for our Ultimate Microsoft Office 4 Courses Bundle course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. The course requires a moderate Internet connection so it is possible to start learning with any type of Internet from anywhere at anytime without any limitations.  Course Content Microsoft Excel 2019 Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Microsoft Word 2019 Microsoft Word 2019 New Features Introduction to Microsoft Word 2019 New Features 00:14:00 Inking Tools 00:03:00 Inking Tools 1 00:07:00 Learning Tools 00:07:00 Microsoft Translate 00:03:00 LaTeX 00:05:00 Smart Lookup 00:04:00 Side to Side Scrolling 00:02:00 Scalable Vector Graphics 00:03:00 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2019 00:00:00 Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features Introduction to Microsoft PowerPoint 2019 New Features 00:06:00 Highlighting 00:02:00 Morph Transition 00:03:00 Zoom 00:03:00 Vector Graphics 00:03:00 SVG Icons to Shapes 00:04:00 3D Modeling 00:04:00 Background Removal 00:03:00 4K 00:03:00 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Microsoft Access 2019 New Features 00:05:00 Window Resize 00:01:00 Charts 00:02:00 dbf 00:01:00 Large Number 00:01:00 Property Sorting 00:01:00 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Assignment Assignment - Ultimate Microsoft Office 4 Courses Bundle 3 weeks, 3 days Order Your Certificate Order your Certificate QLS 00:00:00

Get to know how the Business works Do you think with your skills you should be having a career in a company as a Business Administrator? Can you be the corporate man that every company want? Well, you can! This course will teach all you need to know about Business Administration. Business administration is a wide field that incorporates many types of management positions. From major corporations to independent businesses, every operation needs skilled administrators in order to succeed. A career in business touches on information technology, leadership dynamics and increasingly on ethics and international relationships. As a career path You'll have the option to work across industries as a business analyst, human resources generalist, operations manager or marketing specialist. Kickstart your career in Business Administration with this course which will provide everything you need to know in details. Upon completion of this course inExtended Diploma in Business Administration you will find yourself to be easily suited for the corporate job. Business Administration Course Highlights Extended Diploma in Business Administration is an award winning and the best selling course that has been given the CPD Certification & CiQ accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Extended Diploma in Business Administration into 102 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 3 days, 14 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Extended Diploma in Business Administration Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Extended Diploma in Business Administration is CPD certified and CiQ accredited. 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 backgrounds. Requirements Our Extended Diploma in Business Administration 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and CiQ accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Extended Diploma in Business Administration - Updated Version Representing Your Boss and Company 00:36:00 Skills of an Effective Administrator 00:17:00 Business Writing Skills 00:41:00 Communication Skills 00:27:00 Business Telephone Skills 00:20:00 Mail Services and Shipping 00:28:00 Travel Arrangements 00:25:00 Organising Meeting and Conferences 00:28:00 Time Management 00:35:00 Record Keeping and Filing Systems 00:28:00 Effective Planning and Scheduling 00:52:00 Extended Diploma in Business Administration - Old Version Business Administration What is Business Administration? FREE 01:00:00 Business and Organisations FREE 00:30:00 Management of Business 01:00:00 Business Organization Perspectives 01:00:00 Decision Making 01:00:00 Approaches to Leadership 01:00:00 Business Communication Communication Basics FREE 00:30:00 Know Thyself and The Message FREE 00:30:00 Learn To Use Terms of Business Communication That Invoke Emotions 00:30:00 Pay Attention To Body Language 00:30:00 Learn To Use Terms That Spark Interest 00:30:00 The Benefits Of Presenting Your Message In 1 Minute 00:30:00 Wrapping Up 00:15:00 Finance Management Financing Basics 01:00:00 Record Your Income 01:00:00 Make a List of Expenses First and Put Them in Categories 01:00:00 Countdown & Adjust 01:00:00 Review Regularly 01:00:00 Human Resource Management Module One - Getting Started FREE 00:30:00 Module Two - Human Resources Today FREE 01:00:00 Module Three - Recruiting and Interviewing 01:00:00 Module Four - Retention and Orientation 01:00:00 Module Five - Following Up With New Employees 01:00:00 Module Six - Workplace Health & Safety 01:00:00 Module Seven - Workplace Bullying, Harassment, and Violence 01:00:00 Module Eight - Workplace Wellness 01:00:00 Module Nine - Providing Feedback to Employees 01:00:00 Module Ten - Disciplining Employees 01:00:00 Module Eleven - Terminating Employees 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activites-Professional Diploma in Human Resource Management 00:00:00 Business Writing Module One - Getting Started FREE 00:30:00 Module Two - Working with Words FREE 01:00:00 Module Three - Constructing Sentences 01:00:00 Module Four - Creating Paragraphs 01:00:00 Module Five - Writing Meeting Agendas 01:00:00 Module Six - Writing E-mails 01:00:00 Module Seven - Writing Business Letters 01:00:00 Module Eight - Writing Proposals 01:00:00 Module Nine - Writing Reports 01:00:00 Module Ten - Other Types of Documents 01:00:00 Module Eleven - Proofreading and Finishing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access FREE 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Extended Diploma in Business Administration 00:30:00 Final Exam Final Exam- Extended Diploma in Business Administration 00:30:00

Are you interested in learning more about UI/UX but don't know where to begin? This course will enable you to add UX designer to your resume and begin earning money for your new abilities. This course is for those who want to learn about UI/UX design. It begins from the very beginning and progresses in a step-by-step manner.  In this course, you will get clear instruction on all steps of the UI/UX development process, from user research to establishing a project's strategy, scope, and information architecture, to building sitemaps and wireframes, in this course. You will study current UX design best practices and standards and use them to create effective and appealing screen-based experiences for websites or applications. By the end of the course, you'll have a diverse set of abilities that will allow you to work in the UI/UX design sector. The valuable certificate that comes with the course will enhance your value and make you stand out in the job market. This is the perfect course to kick start your career in the UI/UX design industry. So, enrol now and fast track your career ladder. Course Highlights Advanced Diploma in UI/UX Design is an award winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Advanced Diploma in UI/UX Design into 110 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 12 hours, 52 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Advanced Diploma in UI/UX Design Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Advanced Diploma in UI/UX Design is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our Advanced Diploma in UI/UX Design 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. UX/UI Course Introduction Learn UX/UI Course Overview 00:05:00 Section Overview 00:04:00 UX vs UI 00:04:00 UX/UI Designer Marketplace 00:05:00 Overview of UX Roles 00:06:00 Introduction To The Web Industry Web Industry Section Overview 00:03:00 The Phases of Web Development 00:13:00 Designer Responsibilities (working in a team) 00:09:00 Roles & Descriptions (working in a team) 00:05:00 Agile Approach To Project Management 00:12:00 Scrum - Flexible Framework 00:06:00 Project Management Apps 00:13:00 XD Lesson - Introduction 00:13:00 Foundations of Graphic Design Graphic Design Section Overview 00:02:00 The Psychology of Color 00:13:00 Color Wheel & Color Schemes 00:06:00 Working with Fonts 00:10:00 Working With Icons 00:04:00 XD Lesson - Tools, Object Manipulation and Components 00:13:00 XD Lesson - Font Styles and Artboard Settings 00:07:00 Graphic Design Software Tools 00:03:00 Adobe XD lesson 4 - Icons & Vector Graphics 00:14:00 UX Design (User Experience Design) UX Design Section Overview 00:04:00 What is User Experience Design? (UX) 00:09:00 UX Design Process 00:03:00 The UX Analysis Process 00:08:00 Working with User Profiles 00:03:00 Understanding User Pain Points 00:03:00 XD Lesson 5 Class Project: Сompetitive Analysis 00:10:00 Developing a Persona Part 1 00:05:00 Developing a Persona Part 2 00:05:00 Customer Journey 00:04:00 Customer Journey vs Sales Funnel 00:04:00 3 Phases of a Sales Funnel 00:07:00 4 Stages of a Sales Funnel 00:06:00 Macro/Micro Conversions 00:05:00 Stages of Market Sophistication 00:06:00 Lead Generation Funnel 00:06:00 Digital Product Sales Funnel 00:05:00 7 Principles of Influence 00:12:00 Age Based Influence Triggers 00:06:00 Gender Influence Triggers 00:06:00 Interest Based Marketing 00:04:00 Understanding User Flow 00:08:00 XD Lesson 6 Class Project: Userflow - Your first UX deliverable 00:07:00 Working with Story Boards 00:05:00 XD Lesson 7 Class Project: Crafting a Story board 00:09:00 Working with Moodboards 00:04:00 XD Lesson 8 Class Project: Creating Moodboard 00:11:00 Sitemap & Information Architecture 00:07:00 XD Lesson - Class Project: App Architecture 00:09:00 Low and Hi Fidelity Wireframes 00:03:00 XD Lesson - Class Project: Login Screen Wireframe Using Material Design 00:08:00 Working with Prototypes 00:04:00 XD Lesson - Class Project: Home Screen Wireframe and Linking 00:07:00 XD Lesson - Class Project: Adding Interaction to Wireframes 00:10:00 Testing and Evaluating 00:11:00 UX Deliverables 00:03:00 UX Design Conclusion 00:01:00 UI Design (User Interface Design) UI Design Section Overview 00:03:00 UI Design Overview 00:03:00 Types of Interfaces 00:10:00 Landing Pages Overview 00:10:00 XD Lesson - Using Grids in XD 00:08:00 XD Lesson - Single Card design 00:13:00 UI Controls 00:07:00 UI Components 00:12:00 Navigational Components 00:12:00 Header Design Overview 00:07:00 XD Lesson - Mobile & Desktop: Header Design 00:10:00 XD Lesson - Mobile & Desktop: Dropdown Design 00:06:00 Common Layouts Overview 00:08:00 XD Lesson - Common Layouts 00:07:00 Mobile & Desktop Footer Design Overview 00:07:00 XD Lesson - Mobile & Desktop: Footer Design 00:06:00 Mobile & Desktop Button Design Overview 00:05:00 XD Lesson - Mobile & Desktop: Button Design 00:10:00 XD Lesson - Mobile & Desktop: Input Design 00:07:00 Mobile & Desktop Filter Search Bar Design Overview 00:06:00 Adobe XD Lesson - Mobile & Desktop: Filter Design 00:07:00 Adobe XD Lesson - Mobile & Desktop: Search Design 00:03:00 UI Kit Overview 00:05:00 Adobe XD Lesson - Desktop and Mobile: UI Kit 00:06:00 Microinteractions Overview 00:05:00 Adobe XD lesson - Microinteractions 00:07:00 Optimization Optimization Section Overview 00:02:00 Feedback Review & Getting Referrals 00:04:00 'Above the Fold' Rule 00:04:00 Adobe XD lesson - Designing a Powerful Above the Fold 00:08:00 Using Analytics For Optimization 00:05:00 Heat Maps & Element Placements 00:04:00 Crafting A Usability Report Overview 00:08:00 Adobe XD lesson - Crafting Reports in XD 00:20:00 Starting a Career in UX/UI Design Careers in UX/UI Section Overview 00:06:00 Your Daily Productivity Hub 00:14:00 How To Start Freelancing 00:08:00 Client Consulting 00:04:00 Building a Brand 00:10:00 Personal Branding 00:06:00 The Importance of Having a Website 00:08:00 Creating a Logo 00:05:00 Step by Step Website Setup 00:17:00 UI Templates 00:06:00 Logo Templates 00:04:00 Creating a Business Email 00:06:00 Networking Do's and Don'ts 00:04:00 Top Freelance Websites 00:10:00 UX/UI Project Scope Questions 00:10:00 Laser Focus & Productivity Tools 00:06:00 The Places to Find UX Jobs 00:05:00

Data Analysis In Excel is suitable for anyone aspiring to or already working in this field or simply want to learn deeper into data analysis. You will be able to add this qualification to your CV by downloading your certificate instantly without any cost. To make this course more accessible for you, we have designed it for both part-time and full-time students. This course is packed into the bite-size module for your convenience. You can study at your own pace or become accredited within hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. This Data Analysis In Excel aims to introduce Data Analysis in Excel 2016. You'll learn the best way to enter and organize data, sort and map data, perform calculations with simple functions, format the appearance of your data and cells, and build charts and PivotTables for data analysis. You will know how to validate data, search and remove invalid data. The course covers Lookup information using VLOOKUP, and INDEX-MATCH, data forecasting and cleansing, providing external and 3D references and inserting sparklings, so that you have a great foundation in the world's most popular spreadsheet programme. Finally, you will learn different features to visualise or analyse your data in the most convenient way, which allows you to take the right business decisions for your company Who is this Course for? Data Analysis In Excel is 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 Data Analysis In Excel 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

With this GraphQL Training with NodeJs you will learn how to start GraphQL and NodeJs, do CURD Operations with NodeJs, MongoDB, and GraphQL, and fragment, union, and interfaces with GraphQL. The course will teach you to learn how to set page number, make caching and batching, filtering, sorting and to know about the subscription and data loaders in GraphQL. You will master fundamental concepts behind structuring graphql servers. Learn to build apis with graphql. You will explore to integrating graphql with nodejs and mongodb and, graphql with nodejs and sequelize. You will also learn to test the data authentication and authorization with Jest in MngoDB, NodeJs, and GraphQL. Who is this course for? GraphQL Training with NodeJs is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our GraphQL Training with NodeJs is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started Create Express Server in NodeJs 00:04:00 Create GraphQL Server using express 00:08:00 Understand GraphQL Resolver Arguments 00:00:00 Connect GraphQL App with MongoDB using Mongoose 00:04:00 CURD(Create, Read,Update,Delete) Operations with Nodejs, GraphQL, and MongoDB Create Record in MongoDB Using GraphQL Mutation 00:06:00 Get Records From MongoDB Using GraphQL Query 00:02:00 Update Records From MongoDB Using GraphQL Mutation 00:02:00 Delete Record From MongoDB Using GraphQL Mutation 00:02:00 Authentication and Authorization in GraphQL, Nodejs and MongoDB Create GraphQL Server with GraphQL Yoga 00:03:00 Split up your schema definition, resolvers, and Query type into multiple files 00:07:00 Create a Mongoose User model for Authentication in GraphQL 00:03:00 Register and Encrypt User Data and Return JWT Payload with Graph 00:07:00 Operations and Variables in GraphQL 00:02:00 Validate Input in GraphQL with Joi 00:04:00 Authenticate a User using a JSON Web Token in GraphQL 00:03:00 Merge GraphQL Resolvers into a Single Object using lodash.merge 00:02:00 Create a Middleware for Authentication in GraphQL 00:07:00 Apply Authentication Middleware on GraphQL Resolvers 00:03:00 Create Nested Resolvers to remove duplicate code from individual 00:07:00 Pagination, Filtering, And Sorting in GraphQL Paginate List of Data in GraphQL 00:08:00 Filter Nodes with Matching Rule GraphQL Queries 00:03:00 Sort GraphQL Query Results by Field 00:02:00 Cursor Based Pagination 00:09:00 Fragments, Interfaces, and Unions in GraphQL Send Multiple Queries in a Single Request using Aliases in GraphQL 00:00:00 Enhancing Fields Reusability with Fragments in GraphQL 00:02:00 Create Enum to represents a collection of related values 00:03:00 Create an Interface to represent the reusable fields in GraphQL 00:06:00 Interface Demo with - ResolveType 00:05:00 Create Union to return more than object type from GraphQL field 00:11:00 Subscriptions and DataLoaders in GraphQL Introduction to Subscriptions 00:01:00 Adding real-time functionality with GraphQL Subscriptions 00:06:00 Create DataLoader in GraphQL 00:05:00 Batching in GraphQL 00:05:00 Caching in GraphQL 00:03:00 Testing with Jest in GraphQL and NodeJs Write Unit test for Resolvers in GraphQL 00:04:00 Write Integration Test for Queries And Mutations in GraphQL 00:04:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00