3234 Microsoft courses

Overview This The Complete SQL : Bootcamp course will unlock your full potential and will show you how to excel in a career in The Complete SQL : Bootcamp. So upskill now and reach your full potential. Everything you need to get started in The Complete SQL : Bootcamp is available in this course. Learning and progressing are the hallmarks of personal development. This The Complete SQL : Bootcamp will quickly teach you the must-have skills needed to start in the relevant industry. In This The Complete SQL : Bootcamp Course, You Will: Learn strategies to boost your workplace efficiency. Hone your The Complete SQL : Bootcamp skills to help you advance your career. Acquire a comprehensive understanding of various The Complete SQL : Bootcamp topics and tips from industry experts. Learn in-demand The Complete SQL : Bootcamp skills that are in high demand among UK employers, which will help you to kickstart your career. This The Complete SQL : Bootcamp course covers everything you must know to stand against the tough competition in the The Complete SQL : Bootcamp field.  The future is truly yours to seize with this The Complete SQL : Bootcamp. Enrol today and complete the course to achieve a The Complete SQL : Bootcamp certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the The Complete SQL : Bootcamp course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the The Complete SQL : Bootcamp course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the The Complete SQL : Bootcamp course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This The Complete SQL : Bootcamp is suitable for anyone aspiring to start a career in The Complete SQL : Bootcamp; even if you are new to this and have no prior knowledge on The Complete SQL : Bootcamp, this course is going to be very easy for you to understand.  And if you are already working in the The Complete SQL : Bootcamp field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this The Complete SQL : Bootcamp course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This The Complete SQL : Bootcamp course has no prerequisite.  You don't need any educational qualification or experience to enrol in the The Complete SQL : Bootcamp course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online The Complete SQL : Bootcamp course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum overview 00:04:00 Overview of Databases 00:08:00 SQL Environment Setup PostgreSQL Installation 00:13:00 Connecting to PostgreSQL using psql 00:04:00 Connecting to PostgreSQL using PgAdmin 00:07:00 Creating Database and Tables Basic of Database and Tables 00:06:00 Data Types 00:07:00 Primary Keys and Foreign Keys 00:04:00 Create Table in SQL Script 00:17:00 Insert 00:05:00 Update 00:05:00 Delete 00:03:00 Alter Table 00:05:00 Drop Table 00:02:00 Check Constraint 00:12:00 NOT NULL Constraint 00:04:00 UNIQUE Constraint 00:06:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:07:00 SELECT Statement 00:12:00 SELECT DISTINCT 00:10:00 Column AS Statement 00:07:00 COUNT 00:07:00 SELECT WHERE Clause - One 00:06:00 SELECT WHERE Clause - Two 00:11:00 ORDER 00:05:00 LIMIT 00:04:00 BETWEEN keyword usage on real time 00:08:00 IN Operator 00:06:00 LIKE and ILIKE 00:10:00 GROUP BY Statements Overview of GROUP BY 00:03:00 Aggregation Function 00:12:00 GROUP BY - One 00:05:00 GROUP BY - Two 00:06:00 HAVING on SQL Statement 00:04:00 JOINS Overview of JOINS 00:07:00 Introduction to JOINS 00:06:00 AS Statement table 00:05:00 INNER Joins 00:14:00 Full Outer Joins 00:04:00 Left Outer join 00:03:00 Right Outer Join 00:05:00 Union 00:05:00 Advanced SQL Commands Basic of Advanced SQL Commands 00:04:00 Timestamps 00:17:00 Extract from Timestamp 00:05:00 Mathematical Functions 00:06:00 String Functions 00:16:00 SubQuery 00:08:00 Databases and Tables Overview of Databases and Tables 00:02:00 Creating a Database backup 00:03:00 Restoring a Database from backup 00:04:00 Mock Exam Mock Exam - The Complete SQL from Scratch: Bootcamp 00:20:00 Final Exam Final Exam - The Complete SQL from Scratch: Bootcamp 00:20:00

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before. Boost Your Career By Enrolling In This Virtual Assistant Bundle To Overcome Your Challenges! 6 in 1 Virtual Assistant Bundle Are you interested in a career as a virtual assistant? Are you considering setting up a virtual assistant business? If so, then this Course will equip you with the practical knowledge and skills you need to kickstart your career. Improve your knowledge and enhance your skills to succeed with this Virtual Assistant bundle. This bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our Virtual Assistant bundle is ideal for those who aim to be the best in their fields and are always looking to grow. Why Prefer Virtual Assistant Bundle from Us? All-in-one package Virtual Assistant bundle Earn a certificate accredited by CPD. Get a free student ID card with this Virtual Assistant Bundle Get instant access to this Virtual Assistant course. Learn Virtual Assistant from anywhere in the world Virtual Assistant Training is affordable and simple to understand Virtual Assistant Course is entirely online, interactive lesson with voiceover audio Lifetime access to the Virtual Assistant course materials Virtual Assistant comes with 24/7 tutor support Enrol now in this Virtual Assistant Level 3 Diploma - CPD Certified to advance your career! Start your learning journey straightaway with our Virtual Assistant Diploma Course 01: Virtual Assistant Introduction Different Types of Virtual Assistants Be a Virtual Assistant Must-Have Skills for VA Essential Tools Finding Your Niche Get Hired for VA Jobs How to Set VA Business Admin Support- a Vital Part of VA How to Manage Clients Working with a Virtual Team Data Security Measures Assessment Process of Virtual Assistant Once you have completed all the courses in the Virtual Assistant bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. Enrol now in this Virtual Assistant Level 3 Diploma - CPD Certified to advance your career! CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Virtual Assistant Level 3 Diploma - CPD Certified. Requirements Virtual Assistant Level 3 Diploma - CPD Certified. Career path Virtual Assistant Level 3 Diploma - CPD Certified. Certificates Certificate Accredited by CPD Digital certificate - £10 Upon passing the Virtual Assistant Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD. Certificate Accredited by CPD Hard copy certificate - £29 Upon passing the Virtual Assistant Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

The 'Virtual Team Building & Management' course is designed to equip participants with the skills and strategies needed to effectively lead and collaborate with virtual teams. In this dynamic online learning experience, participants will explore the challenges and opportunities presented by virtual work environments, and they will learn how to foster teamwork, communication, and trust among team members spread across different locations. Learning Outcomes: Set up and organize a virtual team for optimal performance and productivity. Conduct effective virtual team meetings that facilitate communication and collaboration. Develop clear and efficient communication strategies to bridge geographical gaps. Build trust and strong relationships among virtual team members. Address cultural differences and diversity to create a cohesive virtual team. Implement techniques for successfully managing a virtual team and achieving goals. Handle challenges posed by poor team players and maintain team dynamics. Choose the right tools and technologies for seamless virtual collaboration. Why buy this Virtual Team Building & Management? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Virtual Team Building & Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Virtual Team Building & Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Team leaders and managers working with remote or virtual teams. Professionals transitioning to virtual work environments. Project managers overseeing dispersed teams. Human resources professionals interested in enhancing virtual team dynamics. Prerequisites This Virtual Team Building & Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Virtual Team Manager - Median salary of $65,000 - $90,000 per year. Remote Project Manager - Median salary of $70,000 - $100,000 per year. Virtual Collaboration Specialist - Median salary of $60,000 - $85,000 per year. Remote Team Coordinator - Median salary of $55,000 - $75,000 per year. Virtual Team Facilitator - Median salary of $50,000 - $70,000 per year. Course Curriculum Module 01: Setting Up Your Virtual Team (I) Setting Up Your Virtual Team (I) 00:07:00 Module 02: Setting Up Your Virtual Team (II) Setting Up Your Virtual Team (II) 00:05:00 Module 03: Virtual Team Meetings Virtual Team Meetings 00:06:00 Module 04: Communication (I) Communication (I) 00:06:00 Module 05: Communication (II) Communication (II) 00:08:00 Module 06: Building Trust Building Trust 00:05:00 Module 07: Cultural Issues Cultural Issues 00:05:00 Module 08: To Succeed With a Virtual Team To Succeed With a Virtual Team 00:06:00 Module 09: Dealing With Poor Team Players Dealing With Poor Team Players 00:05:00 Module 10: Choosing the Right Tools Choosing the Right Tools 00:06:00 Assignment Assignment - Virtual Team Building & Management 00:00:00

Solidworks: CSWP Exam Preparation is a comprehensive course designed to equip participants with the necessary skills and knowledge to pass the Certified SolidWorks Professional (CSWP) exam. The course covers advanced modeling techniques, assembly creation, and drawing practices. Learning Outcomes: Master advanced 3D modeling techniques in SolidWorks. Learn to create complex assemblies and effectively manage mates. Develop proficiency in generating detailed engineering drawings with proper dimensioning and annotations. Prepare effectively to pass the CSWP exam and earn a recognized industry certification. Why buy this Solidworks: CSWP Exam Preparation? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Solidworks: CSWP Exam Preparation there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Solidworks: CSWP Exam Preparation course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Solidworks: CSWP Exam Preparation does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Solidworks: CSWP Exam Preparation was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Solidworks: CSWP Exam Preparation is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum INTRODUCTION About the course 00:03:00 Tips for CSWP 00:01:00 EXAM - SEGMENT 1 PART 1 00:18:00 PART 2 00:15:00 EXAM - SEGMENT 2 PART 1 00:09:00 PART 2 00:08:00 EXAM - SEGMENT 3 PART 1 00:20:00 PART 2 00:08:00 OFFICIAL EXAM SAMPLE Exam 02:30:00 Resources Resources- Solidworks: CSWP Exam Preparation 00:00:00 Assignment Assignment - Solidworks: CSWP Exam Preparation 00:00:00

Are you looking to enhance your Virtual Assistant skills? If yes, then you have come to the right place. Our comprehensive course on Virtual Assistant will assist you in producing the best possible outcome by mastering the Virtual Assistant skills. The Virtual Assistant course is for those who want to be successful. In the Virtual Assistant course, you will learn the essential knowledge needed to become well versed in Virtual Assistant. Our Virtual Assistant course starts with the basics of Virtual Assistant and gradually progresses towards advanced topics. Therefore, each lesson of this Virtual Assistant course is intuitive and easy to understand. Why would you choose the Virtual Assistant course from Compliance Central: Lifetime access to Virtual Assistant course materials Full tutor support is available from Monday to Friday with the Virtual Assistant course Learn Virtual Assistant skills at your own pace from the comfort of your home Gain a complete understanding of Virtual Assistant course Accessible, informative Virtual Assistant learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Virtual Assistant bundle Study Virtual Assistant in your own time through your computer, tablet or mobile device. Improve your chance of gaining in demand skills and better earning potential by completing the Virtual Assistant Free: Online Meeting Management Course Curriculum Breakdown of the Virtual Assistant Course Module 01: Introduction to Virtual Assistant Module 02: Different Types of Virtual Assistants Module 03: Be a Virtual Assistant Module 04: Must-Have Skills for Virtual Assistants Module 05: Essential Tools for a Virtual Assistant Module 06: Finding Your Niche Module 07: Get Hired for VA Jobs Module 08: How to Set VA Business Module 09: Admin Support- a Vital Part of VA Module 10: How to Manage Clients Module 11: Working with a Virtual Team Module 12: Data Security Measures CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Virtual Assistant course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Virtual Assistant. Requirements To enrol in this Virtual Assistant course, all you need is a basic understanding of the English Language and an internet connection. Career path The Virtual Assistant course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Virtual Assistant. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

AI in Project Management: The Next Generation of Project Decision Making Project managers need to make critical project decisions on a daily basis. They are confronted with increasing complexities, high ambiguity and the need to process an exponentially growing amount of data and information in order to make informed and good decisions. This leads to an increasing risk of project failure - meanwhile, the project management industry is already challenged with ongoing low project success rates, caused by often massive failures of projects. Project Data Analytics and Artificial Intelligence (AI) are expected to fill the gap by providing analytical and unbiased capabilities that go beyond human possibilities, towards a data-driven and fact-based decision-making approach. While there is little doubt that AI as a trending technology will disrupt the project management practice and augment today's project management capabilities, AI cannot be seen as just another new tool to make project management more effective. Rather, AI will act as a complement to human intelligence, requiring a collaborative approach and, accordingly, a significant change in project culture and peoples' mindset. Today's project decisions are usually driven by human intuition, experience, leadership, and often do not follow any rational logic. Project decision-makers will be required to abandon such an approach and shift to a data-driven, decision-making approach. This session will provide an overview of the expected changes from AI-driven project management, the resulting impact on project decision making and changes in project culture, and what actions can be taken by project professionals to match their beliefs and behaviours with the new project culture. Learning goals: Gain insights into how AI for project management will significantly change decision-making in projects Gain an understanding of how to transition to a new AI-powered project culture

Step into the world of effective Team Management through our Level 1 Diploma in Team Management. With modules covering everything from Understanding Teams to advanced Leadership Skills, this course is your key to Team Management excellence.

Duration 2 Days 12 CPD hours This course is intended for This SQL training course is designed for students new to writing SQL queries. Overview Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables. Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases. Relational Database Basics Brief History of SQL Relational Databases Popular Databases SQL Statements Simple SELECTs Introduction to the Northwind Database Some Basics SELECTing All Columns in All Rows Exploring the Tables SELECTing Specific Columns Sorting Records The WHERE Clause and Operator Symbols Using the WHERE clause to check for equality or inequality Using the WHERE clause to check for greater or less than Checking for NULL Using WHERE and ORDER BY Together The WHERE Clause and Operator Words More SELECTs with WHERE Checking Multiple Conditions Writing SELECTs with Multiple Conditions Advanced SELECTs Calculated Fields Calculating Fields Aggregate Functions and Grouping Working with Aggregate Functions Built-in Data Manipulation Functions Data Manipulation Functions Subqueries, Joins and Unions Subqueries Joins Using Joins Outer Joins Unions Working with Unions If time allows, one or more of the following may be covered: Conditional Processing with CASE INSERT, UPDATE, DELETE Student Challenges - Design your own reports

Duration 3 Days 18 CPD hours Participants in this course will learn how to update, upgrade, and reinstall the macOS then set up and configure the new macOS. They will also be introduced to the command-line interface and macOS Recovery. Other course topics include: managing user accounts, system resources, Time Machine, user home folders managing file systems, storage, encryption, permissions, using hidden items, shortcuts, file archiving file sharing, metadata, Spotlight, network services, host sharing, and creating a personal firewall and much more. The students will also learn all about macOS security and password changes Installation and Configuration Update, Upgrade, or Reinstall macOS Set Up and Configure macOS Use the Command-Line Interface Use macOS Recovery Update macOS User Accounts Manage User Accounts Manage User Home Folders Manage Security and Privacy Manage Password Changes File Systems Manage File Systems and Storage Manage FileVault Manage Permissions and Sharing Use Hidden Items, Shortcuts, and File Archives Data Management Manage System Resources Use Metadata, Spotlight, and Siri Manage Time Machine Apps and Processes Install Apps Manage Files Manage and Troubleshoot Apps Network Configuration Manage Basic Network Settings Manage Advanced Network Settings Troubleshoot Network Issues Network Services Manage Network Services Manage Host Sharing and Personal Firewall System Management Troubleshoot Peripherals Manage Printers and Scanners Troubleshoot Startup and System Issues Additional course details: Nexus Humans macOS Support Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the macOS Support Essentials course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This course is suitable for anyone responsible for configuring, managing or supporting a Veeam Availability Suite v11 environment. Overview After completing this course, attendees should be able to: Describe Veeam Availability Suite components usage scenarios and relevance to your environment. Effectively manage data availability in on-site, off-site, cloud and hybrid environments. Ensure both Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs) are met. Configure Veeam Availability Suite to ensure data is protected effectively. Adapt with an organization's evolving technical and business data protection needs. Ensure recovery is possible, effective, efficient, secure and compliant with business requirements. Provide visibility of the business data assets, reports and dashboards to monitor performance and risks The Veeam© Availability Suite? v11: Configuration and Management training course is a three-day, technical deep dive focused on teaching IT professionals the skills to configure, manage and support a Veeam Availability Suite v11 solution. With extensive hands-on-labs, the class enables administrators and engineers to effectively manage data in an ever-changing technical and business environment, bringing tangible benefit to businesses in the digital world. This course is based on Veeam Availability Suite v11. Introduction Describe RTOs and RPOs, what they mean for your business, how to manage and monitor performance against them The 3-2-1 Rule and its importance in formulating a successful backup strategy Identify key Veeam Availability Suite components and describe their usage scenarios and deployment types Building backup capabilities Backup methods, the appropriate use cases and impact on underlying file systems Create, modify, optimize and delete backup jobs, including Agents and NAS Backup jobs. Explore different tools and methods to maximize environment performance Ensure efficiency by being able to select appropriate transport modes while being aware of the impact of various backup functions on the infrastructure Building replication capabilities Identify and describe the options available for replication and impacts of using them Create and modify replication jobs, outline considerations to ensure success Introduce the new Continuous Data Protection (CDP) policy Secondary backups Simple vs. advanced backup copy jobs, how to create and modify them using best practices to ensure efficient recovery Discuss using tapes for backups Advanced repository capabilities Ensure repository scalability using a capability such as SOBR on-premises and off-site including integration with cloud storage Ensure compatibility with existing deduplication appliances Introduce the new hardened repository Protecting data in the cloud Review how Veeam can protect the data of a cloud native application Review how Veeam Cloud Connect enables you to take advantage of cloud services built on Veeam Review how Veeam can be used to protect your Office 365 data Restoring from backup Ensure you have the confidence to use the correct restore tool at the right time for restoring VMs, bare metal and individual content such as files and folders Utilize Secure Restore to prevent the restoration of malware Describe how to use Staged Restore to comply with things like General Data Protection Regulation (GDPR) before releasing restores to production Identify, describe and utilize the different explores and instant recovery tools and features Recovery from replica Identify and describe in detail, failover features and the appropriate usage Develop, prepare and test failover plans to ensure recovery Disaster recovery from replica to meet a variety of real-world recovery needs Testing backup and replication Testing backups and replicas to ensure you can recover, what you need, when you need to Configure and setup virtual sandbox environments based on backup, replicas and storage snapshots Veeam Backup Enterprise Manager and Veeam ONE Introduce the concept of monitoring your virtual, physical and cloud environments with Veeam Backup Enterprise Manager and Veeam ONE Configuration backup Locate, migrate or restore backup configuration Additional course details: Nexus Humans VASCM-11 Veeam Availability Suite v11: Configuration and Management 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 VASCM-11 Veeam Availability Suite v11: Configuration and Management 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.