4586 Courses

Duration 5 Days 30 CPD hours This course is intended for This course is intended for an IT person wanting to learn about administrating SharePoint 2016. Overview After completing this course, you will be able to: The Installation and configure a SharePoint 2016 Farm How to manage a SharePoint 2016 Farm through the GUI and PowerShell How to create site collections via GUI and PowerShell How to create and configure the all the required service applications for SharePoint 2016 How to backup and restore in SharePoint 2016 This SharePoint 2016 Administrator course is design for Administrators who are new to SharePoint Server Administration or who are upgrading from previous versions of SharePoint.This course covers content that was in retired Microsoft Course 20339-1. Module 1: Hardware, Installation and Patching How to build a Min Role Farm How to View ULS Logs How to document and check IIS Settings for SharePoint 2016 Module 2: Farm Management How to manage the SharePoint Farm Administors group How to configure Outgoing Email How to configure Incoming Email How to Configure Diagnostic and Usage Log Options Module 3: Web Applications How to define a new Managed Account How to add new IP Addresses to a SharePoint Server How to create a claims based web application in SharePoint Central Administration How to create a claims based web application in PowerShell How to create a hosting web application in PowerShell Module 4: Site Collections How to create a managed path How to create a site collection using SharePoint Central Administration How to create a site collection using PowerShell How to create a site collection in its own database using SharePoint Central Administration How to create a site collection in its own database using PowerShell How to create a host named site collection using PowerShell Module 5: Service Applications How to create a State Service Application How to create a Search Service Application How to create the Managed Metadate Service Module 6: Application Management How to add a new IP and Certificate to a SharePoint Web Application How to configure DNS for SharePoint Web Application How to Create a Subscription Settings Service Application How to create the Application Management Application Service How to configure the application URLs How to create the App Catalog Site Colleciton How to Add Apps to the catalog Module 7: Managing the User Profile Service How to create the My Site Web Application How to create the User Profile Service Application How to Configure the User Profile Synchronization Permissions How to create the Active Directory Import Connection How to assign permissions for the AD Group to create a My Site How to create a My Site Module 8: Search How to view the currenty Search Topology How to create an Enterprise Search Centre How to configure a new search schema property How to create a site collection-level result source How to create a new content source Module 9: Office Online Server How to install the pre-requisites for Office Online Server How to install the Office Online Server Binaries How to create the Office Online Server SSL Certifcate How to create the Office Online Server Farm How to connect to the farm from SharePoint How to test the connectivity Module 10: Enterprise Content Management How to create and Apply a site policy How to create discovery sets How to configure In Place records management How to configure the records centre How to configure DLP Module 11: Web Content Management How to configure cross-site publication How to configure content deployment Module 12: Workflow Server How to install Workflow Manger server and Client Binaires How to configure the workflow farm How to patch the workflow farm manager and clients How to register the workflow service in SharePoint How to test Workflow creation Module 13: Business Connectity Services and Secure Store How to configure the secure store service How to create the BCS service Application How to setup the products database How to import the BCS Definition How to use the BDC file in a list web part Module 14: Hybrid SharePoint Shown and Demonstrated the Hybrid features of SharePoint 2016 Module 15: Backup and Restore How to backup SharePoint 2016 Content How to delete SharePoint 2016 Content How to restore SharePoint 2016 Content via PowerShell How to recover a unattached content database Module 16: Upgrade How to restore and attach a SharePoint 2013 Database How to upgrade a SharePoint 2013 MMS Service Application Additional course details: Nexus Humans 55355 SharePoint 2016 Administration 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 55355 SharePoint 2016 Administration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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.

🚀 Unlock Your Problem-Solving Potential with 'Tackling Problems in 12 Simple Steps' Online Course! 🌟 Are you tired of feeling overwhelmed by problems, unsure where to start or how to find solutions? Say goodbye to frustration and hello to effective problem-solving skills with our revolutionary online course! Introducing 'Tackling Problems in 12 Simple Steps' - your ultimate guide to conquering challenges effortlessly. Whether it's personal hurdles, professional roadblocks, or academic puzzles, this course equips you with a proven framework to tackle any problem head-on. 🎯 What You'll Gain:     A Strategic Blueprint: Master a systematic approach to dissecting and solving problems with ease. 12 Proven Steps: Learn practical, actionable steps designed to simplify even the most complex issues. Adaptability Skills: Gain the confidence to address diverse problems across various aspects of life. Problem-solving Mindset: Develop a resilient mindset to embrace challenges as opportunities for growth. Real-Life Applications: Apply these techniques immediately for instant results in your personal and professional life. 💡 Course Highlights: Engaging video modules led by industry experts. Interactive exercises to reinforce learning. Case studies illustrating the steps in action. Access to a supportive community for discussions and networking. Downloadable resources and tools for practical implementation.   🌟 Join thousands of satisfied learners who have transformed their problem-solving abilities with our course! Don't let obstacles hold you back - empower yourself to face challenges confidently. 🔥 Limited Time Offer: Enroll now and gain exclusive access to bonus materials and a special discount! Don't miss this opportunity to supercharge your problem-solving skills! 👉 Ready to take charge of your problem-solving journey? Enroll now in 'Tackling Problems in 12 Simple Steps' and start overcoming challenges like a pro! 💪 Course Curriculum

Explore Microsoft Power Automate in this course to master basic automation, template flows, and more.

iscover the fascinating world of Python programming as you take your first steps into the realm of coding. This course is designed to ignite your passion for programming, providing a solid foundation for beginners. Get ready to unleash your creative potential in the world of technology.

Leverage psychological and physical content to help you develop broader perspectives and strengthen your coaching expertise herein this

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Highlights of the Course Course Type: Online Learning Duration: 3 hours 56 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about functional skills ICT Understand the core competencies and principles of functional skills ICT Explore the various areas of functional skills ICT Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert functional skills ICT teacher IT Troubleshooting Training Advanced for Desktop Support Professional Course Master the skills you need to propel your career forward in functional skills ICT. This course will equip you with the essential knowledge and skillset that will make you a confident functional skills ICT teacher and take your career to the next level. This comprehensive IT troubleshooting training course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this IT troubleshooting training course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective functional skills ICT practice and equip you with the essential skills, confidence and competence to assist you in the functional skills ICT industry. You'll gain a solid understanding of the core competencies required to drive a successful career in functional skills ICT. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for functional skills ICT teacher or for people who are aspiring to specialise in functional skills ICT. Enrol in this IT troubleshooting training course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive IT troubleshooting training course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this functional skills ICT can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This IT troubleshooting training course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This IT troubleshooting training course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This IT troubleshooting training course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Course Introduction Course Introduction 00:00:00 Prepare Virtual Test Lab Install Hyper-V on Local System 00:02:00 Create Virtual Machine (VM) 00:02:00 Download Free Evaluation Windows 10 Image 00:02:00 Installing Windows OS With Multiple Media Installing Windows 10 00:06:00 Make USB Bootable with GUI Tool 00:07:00 Make USB Bootable with Command (CLI Tool) 00:05:00 Access Boot Menu 00:03:00 Hyper-V Interface Overview 00:05:00 Increase Disk and Memory of Virtual Machine 00:07:00 Use of Snapshot (Time Saving) 00:03:00 System Troubleshooting without Reboot Fix Stuck Windows Service 00:11:00 Fix 'Not Responding' Application or Desktop Error 00:03:00 Logoff Another User from Local System 00:03:00 Logoff user Remotely through PowerShell 00:02:00 Delay in Replication of Assigned Permission on Client 00:03:00 Fix Domain Trust issue without Re-joining & Reboot 00:05:00 Find & Kill High Utilization Process 00:02:00 Optimize System Performance (Fix Slowness Issue) Monitor CPU, Memory & HDD Utilization (Task Manager & Resource Monitor) 00:06:00 Find & Kill High Utilization Process 00:02:00 Check Recently System Uptime and Reboot 00:03:00 Uninstall Unwanted Applications 00:03:00 Run Disk Cleanup (Remove Not Required System Files) 00:06:00 Deep Cleaning Through TreeSize Free Tool 00:06:00 Disable Startup Applications (Speed Up Booting Time) 00:02:00 Disable Unwanted Startup Services (MSCONFIG) 00:03:00 Active Directory Server Setup (Optional) Module Introduction 00:02:00 Create Virtual Machine for Server 2019 00:02:00 Install Windows Server 2019 00:03:00 Rename System Name 00:02:00 Server Manager Introduction 00:02:00 Install Active Directory Role 00:03:00 Promote Active Directory Domain Controller 00:06:00 Set Static IP Address 00:02:00 Active Directory Introduction Active Directory Users and Computers (ADUC) 00:04:00 Active Directory Administrative Center (ADAC) 00:03:00 Create Active Directory User 00:06:00 Join System in Active Directory Domain 00:04:00 Computer Account Introduction & Solution 00:05:00 Info about Default Quota for Rejoining System 00:02:00 Check Password Expiration and Account Status 00:02:00 File System Related Troubleshooting Recycle Bin Settings 00:02:00 Cleanup Recycle Bin Data of Multiple Users Profile (Advance) 00:08:00 Close Locked Open Files on File Server 00:06:00 How To Fix Filename Is Too Long Issue 00:04:00 Supplementary Resources Supplementary Resources - Advance IT Troubleshooting for Desktop Support Professional 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

This Microsoft Office Skills course is designed for people with a career in Accounting, Finance, Marketing, Sales, Executive, Administration, Business Management, Manager, Human Resources, Customer Service, Assistant, and Reception. In this Microsoft Office course, we will go in-depth into four Microsoft Office applications: Excel, Word, PowerPoint, and Access. Microsoft Office Excel 2019 Microsoft Office Word 2019 Microsoft Office PowerPoint 2019 Microsoft Office Access 2019 Microsoft Office Microsoft Excel 2019 Key Features Instant e-certificate and hard copy Fully online, interactive Microsoft Office course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum of Microsoft Office 2019 Microsoft Office Excel Microsoft Office Excel 2019 Microsoft Office Excel 2019 New Features Getting Started with Microsoft Office Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Office Word Microsoft Office Word 2019 Microsoft Office Word 2019 New Features Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Microsoft Office PowerPoint Microsoft Office PowerPoint 2019 Microsoft Office PowerPoint 2019 New Features Microsoft Office PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentation Microsoft Office Access Microsoft Office Access 2019 Microsoft Office Access 2019 New Features Introduction to Access Modify Data Working with Queries Access Forms Working with Reports Accreditation All of our courses, including these Microsoft Office courses, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Microsoft Office course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Microsoft Office Requirements Microsoft Office Career path Microsoft Office Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Looking to enhance your job search abilities? Our Job Search Skills Workshop Course is designed to help you develop the key strategies to successfully navigate today’s competitive job market. Through clear and straightforward guidance, you'll learn the vital tools to boost your CV, craft compelling cover letters, and ace interviews with confidence. This course will equip you with the knowledge needed to find and apply for the right jobs, giving you the edge in your job search journey. With the Job Search Skills Workshop Course, you’ll gain practical insights into how recruitment processes work, how to network effectively, and how to tailor your approach to different employers. Learn how to position yourself as a strong candidate, whether you’re entering the workforce or exploring new opportunities. The skills you’ll gain are directly applicable to any job search scenario, helping you save time and maximise your chances of landing the right role. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Job Search in the UK Module 02: Crafting an Effective CV (Curriculum Vitae) Module 03: Job Search Strategies in the UK Module 04: Leveraging LinkedIn for Job Search Module 05: Job Application and Cover Letters Module 06: Interview Preparation in the UK Module 07: Post-Interview Follow-up and Negotiation Learning Outcomes: Construct a compelling CV that stands out to UK employers. Apply effective job search strategies tailored to the UK market. Optimise your LinkedIn profile for increased professional visibility. Craft persuasive job applications and cover letters for impact. Prepare confidently for interviews in the UK context. Execute post-interview follow-up and negotiation with finesse. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Recent graduates seeking employment. Job seekers aiming to enhance their UK job market knowledge. Professionals transitioning within the UK job market. Individuals returning to the workforce. International job seekers navigating the UK job scene. Career changers exploring opportunities in the UK. Students preparing for the transition to the professional world. Anyone keen on mastering the art of successful job hunting in the UK. Career path Administrative Assistant Sales Representative Marketing Coordinator Human Resources Assistant Customer Service Representative Project Coordinator Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.