2357 Courses delivered Online

Start an IT Asset Department Course Overview This course provides a comprehensive introduction to starting and managing an IT Asset Department. Designed to equip learners with the knowledge required to establish and streamline IT asset management (ITAM) processes, it covers the key components and strategies for setting up the department, from understanding the department's purpose to maintaining accurate asset records. Learners will gain a solid understanding of the essential skills required to effectively manage IT assets, ensuring proper tracking, reporting, and operations. By the end of the course, learners will have a clear blueprint for setting up their own IT asset department, ready to implement best practices and improve operational efficiency. Course Description The course delves into the fundamental aspects of starting an IT Asset Department, starting with an overview of the department’s critical role within an organisation. Learners will explore the various functions and responsibilities of the IT Asset Management (ITAM) team, the tools needed to track assets, and how to populate and manage a central database. The course will also cover daily operations, including generating reports and ensuring compliance with industry standards. Learners will leave with the skills necessary to build a structured IT asset management department that can oversee asset tracking, database management, and reporting, ensuring better decision-making and efficiency in the management of IT resources. Start an IT Asset Department Curriculum Module 01: Introduction to the Course Module 02: The Missing Department Module 03: ITAM Team and Activities Module 04: Asset Tracking Tool Module 05: Populating the Database Module 06: Daily Operations and Reports Module 07: Was it a Boring Job? (See full curriculum) Who is this course for? Individuals seeking to develop skills in IT asset management. Professionals aiming to establish or optimise an IT asset management department. Beginners with an interest in IT operations and resource management. Managers looking to improve efficiency in IT asset tracking. Career Path IT Asset Manager IT Operations Specialist IT Procurement Manager Asset Tracking Coordinator IT Project Manager

PAT Testing - Portable Appliance Testing Training Course Overview The "PAT Testing - Portable Appliance Testing Training" course is designed to equip learners with the essential knowledge and skills required to safely conduct portable appliance testing in line with current UK regulations. Participants will gain a clear understanding of the legal requirements, risk assessment techniques, and best practices for maintaining workplace safety. This course is ideal for individuals involved in electrical safety, ensuring they can carry out PAT testing confidently and competently. Upon completion, learners will be prepared to enhance workplace safety through proper appliance inspection and compliance with relevant legislation. Course Description This comprehensive course covers all key areas of portable appliance testing, including the legal provisions that guide PAT testing, risk assessment methodologies, and the appropriate tools for conducting inspections. Learners will explore different types of electrical appliances, their classification, and how to perform initial visual examinations. Additionally, the course delves into the electrical installation testing process and safety precautions necessary to mitigate risks. Participants will also learn the essential practices for recording and reporting test results. By the end of the course, learners will be equipped with the skills needed to perform thorough PAT testing and ensure compliance with industry standards. PAT Testing - Portable Appliance Testing Training Curriculum Module 01: Introduction to PAT Module 02: Relevant Statutory Provisions for PAT Module 03: Risk Assessment Module 04: Reducing and Controlling Risks Module 05: Electrical Units and Appliance Classification Module 06: Initial Visual Examination Module 07: Instruments for Testing and Equipment Inspection Module 08: Electrical Installation Testing Module 09: Safety Precautions in Electrical Testing Module 10: Reporting and Record-keeping (See full curriculum) Who is this course for? Individuals seeking to enhance their knowledge of electrical safety. Professionals aiming to ensure compliance with PAT testing regulations. Beginners with an interest in electrical safety or maintenance. Safety officers or facilities managers responsible for ensuring workplace compliance. Career Path PAT Tester Health and Safety Officer Facilities Manager Electrical Compliance Officer Maintenance Technician Workplace Safety Consultant

Make significant time savings by automating month-end reporting and enable users to self-serve on financial data. Reducing reliance on finance analysts to manually produce reports and analysis each month, leading to more efficient processes and faster decision-making.

The course is intended to help design and implement industry-standard frameworks using Appium with TestNG Maven, Jenkins, GitHub, Apache Log4J2, and Extent Reports.

Money laundering remains a persistent challenge that threatens the integrity of financial systems globally. This Level 3 Anti-Money Laundering (AML) course, endorsed by QLS, offers a detailed exploration of the mechanisms behind money laundering activities and the measures required to identify and address them effectively. Designed for professionals aiming to deepen their understanding of AML principles, the course equips learners with essential knowledge on regulatory frameworks and the critical role of due diligence in preventing illicit financial flows. Included within the course bundle is the Diploma in Anti Money Laundering at QLS Level 5 and a focused Know Your Customer (KYC) module, providing a thorough insight into client verification processes and risk assessment strategies. This carefully structured programme delivers all the key information needed to enhance vigilance against financial crime, ensuring participants remain well-informed about evolving legislation and reporting duties. Whether you work in finance, law, or compliance, this course is an invaluable resource for maintaining ethical standards and safeguarding your organisation’s reputation. Our Anti-Money Laundering (AML) course is endorsed by the Quality Licence Scheme - QLS, ensuring you acquire new skills and enhance your professional development. Anti-Money Laundering (AML) QLS Bundle Includes the following Courses Course 01: Diploma in Anti Money Laundering at QLS Level 5 Course 02: Know Your Customer (KYC) Key Features of Anti-Money Laundering (AML) Eligibility for QLS endorsed certificate upon successful completion of the Anti-Money Laundering (AML) course Free CPD Accredited Course Fully online, interactive Anti-Money Laundering (AML) course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Anti-Money Laundering (AML)training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Anti-Money Laundering (AML) course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Anti-Money Laundering (AML) course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Anti-Money Laundering (AML) course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Anti-Money Laundering (AML) course, learners will be able to order an endorsed certificate, titled: [Diploma in Anti Money Laundering at QLS Level 5], as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 20 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Anti-Money Laundering (AML) basics. Requirements No prior degree or experience is required to enrol in this Anti-Money Laundering (AML) course. Career path This Anti-Money Laundering (AML) Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Level 4 QLS Endorsed Diploma | 120 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Description: The Operation and Security Management Diploma course teaches both Operational Management and Security Management concepts and techniques. Throughout the course, you will learn the basics of operation management, human resource management, assets management, supply chain management, and cost management.  Then the course covers the concepts, skills and techniques of Security Management such as types of security threats, identity theft, piracy, data classification, ways of protecting your digital information, malware and more. 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? Operation and Security Management Diploma 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 Operation and Security Management Diploma 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. Operation and Security Management Diploma - Updated Version Module 01: Introduction To Operations Management Introduction To Operations Management 00:23:00 Module 02: Project Management Project Management 00:22:00 Module 03: Business Development And Succession Planning Business Development And Succession Planning 00:27:00 Module 04: Process Management Process Management 00:26:00 Module 05: Supply Chain Management Supply Chain Management 00:23:00 Module 06: Planning & Forecasting Operations Planning & Forecasting Operations 00:23:00 Module 07: Procurement & Purchasing Management Procurement & Purchasing Management 00:23:00 Module 08: Manufacturing & Delivery Operations Manufacturing & Delivery Operations 00:19:00 Module 09: Quality Management Quality Management 00:23:00 Module 10: Managing Risk And Recovery Managing Risk And Recovery 00:29:00 Module 11: Performance Management Performance Management 00:21:00 Module 12: Talent Management Talent Management 00:20:00 Module 13: Communication Skills Communication Skills 00:26:00 Module 14: Negotiation Techniques Negotiation Techniques 00:19:00 Module 15: Conflict Management Conflict Management 00:17:00 Module 16: Stress Management Stress Management 00:19:00 Module 17: Time Management Time Management 00:40:00 Module 18: Business Environment Business Environment 00:19:00 Module 19: Business Writing Skills Business Writing Skills 00:39:00 Operation and Security Management Diploma - Old Version Module 01 Designing Your Organizational Structure 00:30:00 Introduction to Operations Management 00:15:00 Understanding Financial Terms 00:30:00 Getting the Right People in Place 00:15:00 Getting Your Product Together 00:15:00 Building a Corporate Brand 00:30:00 Marketing Your Product 01:00:00 Selling Your Product 00:15:00 Planning for the Future 00:15:00 Goal Setting and Goal Getting 00:30:00 Succession Planning 101 00:15:00 Managing Your Money 00:15:00 Ethics 101 00:15:00 Building a Strong Customer Care Team 00:15:00 Training Employees for Success 00:15:00 Leadership Essentials 00:15:00 Module 02 The Fundamentals of Business Process Management 00:30:00 Defining Business Process Management 00:30:00 The Business Process Life Cycle 00:15:00 The Vision Phase 00:15:00 The Design Phase 01:00:00 The Modeling Phase 00:30:00 The Execution Phase 01:00:00 The Monitoring Phase 00:30:00 The Optimizing Phase 01:00:00 Module 03 What is Gap Analysis? 00:30:00 The Gap Analysis Process 00:30:00 Supporting Tools 00:30:00 Creating a Gap Analysis Report 00:15:00 Understanding Lean 00:30:00 The Toyota Production System 00:30:00 The Toyota Production System House 00:15:00 The Five Critical Improvement Concepts 00:15:00 Understanding Value with the Kano Model 00:15:00 Types of Waste 00:15:00 Creating a Lean Enterprise 00:15:00 The Plan, Do, Study, Act (PDSA) Cycle 00:15:00 Using the R-DMAIC-S Model 00:15:00 Lean Thinking Tools 00:15:00 Kaizen Events 00:00:00 Data Gathering and Mapping 00:30:00 A Plan to Take Home 00:15:00 Defining Continuous Improvement 00:15:00 Stage One - Identify Areas For Improvement 00:15:00 Stage Two - Create a Plan for Improvement 00:15:00 Stage Three - Implement the Changes 00:15:00 Stage Four - Review the Impact 00:15:00 Test Driving 00:15:00 Module 04 The Evolution of the Supply Chain 00:15:00 The Basic Supply Chain Structure 00:15:00 Supply Chain Drivers 00:15:00 Aligning Your Supply Chain with Business Strategy 00:15:00 Managing Supply Chain Risks 00:15:00 Tracking and Evaluating Supply Chain Data 00:30:00 Troubleshooting Supply Chain Problems 00:15:00 Sharing Supply Chain Activities 00:15:00 Sustainable Supply Chain Strategies 00:15:00 Applying Lean Techniques to the Supply Chain 00:15:00 The Future of Supply Chain Management 00:15:00 Supply Chain Management Basics 00:30:00 The Purchasing Cycle 00:45:00 Purchasing Toolkit 01:00:00 Managing Competitive Bids 00:45:00 Improving Efficiency and Accuracy 00:30:00 Analyzing and Reducing Risk in the Supply Chain 00:30:00 Managing Internal Relationships 00:30:00 Tools of the Trade 00:30:00 Module 05 What is Inventory? 00:30:00 Types of Inventory 00:15:00 Key Players 00:30:00 Setting up the Warehouse 00:15:00 What Makes a Good Inventory Management System? 00:15:00 The Warehouse Inventory Cycle 00:15:00 Identifying Demand 00:15:00 The Receiving Process 00:15:00 Validating Inventory 00:15:00 The Put-Away Process 00:15:00 Maintaining Inventory Accuracy 00:30:00 The Outbound Process 00:30:00 Industry Trends 00:15:00 Module 06 Concept of Quality FREE 00:19:00 Key Terms 00:23:00 Categories 00:21:00 Customer Input 00:11:00 Plan Quality 00:08:00 Design of Experiments 00:07:00 Quality Control 00:11:00 Control Charts 00:11:00 Sampling 00:11:00 Six Sigma 00:08:00 The Steps 00:10:00 The 6 Six Sigma Challenges 00:05:00 Module 07 The Basics Of Security Management 00:15:00 Security Management Planning And Implementing 00:15:00 How to Build a Security Management Team 00:15:00 The Role And Responsibilities of a Security Officer 00:30:00 Security Management Governance 00:15:00 Organizational Security Models 00:30:00 Understanding Risk, Threat, And Vulnerability 00:15:00 Information Risk Management 00:30:00 Different Types of Crimes 00:15:00 Understanding What Burglaries Are 00:15:00 Definition and Dangers of Hijacking 00:15:00 Domestic Violence in the Workplace 00:30:00 Child abuse: Identification, Reporting, and Prevention 00:30:00 Sexual Violence: Prevention Strategies 00:15:00 Module 08 Types of Security Threats 00:29:00 Social Engineering 00:31:00 Identity Theft 00:29:00 Data Classification 00:28:00 Protecting Your Digital Information 00:45:00 Malware 00:17:00 Security from End-to-End 00:27:00 Piracy 00:16:00 Security Policies 00:17:00 Moving Forward 00:12:00 Mock Exam Mock Exam- Operation and Security Management Diploma 00:30:00 Final Exam Final Exam- Operation and Security Management Diploma 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Take steps to become an experienced facilities manager and ensure that buildings and their services meet the needs of people that work in them, with the Facilities Management. In this comprehensive course, you will receive practical training in all areas of facilities management, from exploring the facilities life cycle to inventory management. Our experienced instructor will teach you everything you need to know about maintaining the working environment and providing a quality service.  By the end of this training program, you will be equipped with the practical skills and knowledge to manage facilities of all types, including hospitals, retail stores, hotels and office buildings. Learning Objectives Understand the purpose, nature and scope of facilities management Know the proper use of facilities management terms and definitions Learn about sustainability in facilities management, sustainable developments and trends Demonstrate an in-depth understanding of the facilities life cycle, from design to construction and maintenance Familiarise with the role of a facilities operations manager Develop your understanding of the fundamental steps in inventory management and waste management Understand how to evaluate life-cycle costs in facilities management Learn about quality control, inspections, reporting and record-keeping Develop your project management skills and demonstrate an understanding of a project's life cycle Who is this Course for? This Diploma in Facilities Management is ideal for aspiring facilities managers and existing managers who want to update their skills and knowledge. Our online courses are specially designed for distance learning, offering flexible virtual classroom modules that can be studied on a full-time or part-time basis. Increase your chances of working for a top organisation and gain a Certificate of Achievement to take your career to the next level. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the course. Good understanding of English language, numeracy and ICT are required to attend this course. Certificate of Completion from Course Gate At the successful completion of the course, the learners may order the Certificate of Completion from Course Gate (soft copy) by paying only £2. For the Printed hard copy of the certificate, the learners have to pay £9. There is an additional £10 delivery charge for international students. Career path This advanced diploma in Facilities Management provides a stepping stone to work your way up to becoming a successful facilities manager. Career opportunities and roles in the field include: Facilities Manager Facilities Coordinator Facilities Assistant Course Curriculum Module 1: Facility Management Introduction to Facility Management 00:20:00 Terms and Definitions 00:05:00 Assessment Module 1 Module 01 Final Quiz Exam - Facilities Management 00:10:00 Module 2: Facilities Management in the Workplace Workplace Facilities 00:35:00 Assessment Module 2 Module 02 Final Quiz Exam - Facilities Management 00:10:00 Module 3: Sustainable Development and Facilities Management Sustainable Development and Facilities Management 00:30:00 Facilities Life Cycle 00:15:00 Assessment Module 3 Module 03 Final Quiz Exam - Facilities Management 00:10:00 Module 4: Facility Operations Operations of Facilities 00:25:00 Assessment Module 4 Module 04 Final Quiz Exam - Facilities Management 00:10:00 Module 5: Operations and Maintenance Operations and Maintenance 00:30:00 Assessment Module 5 Module 05 Final Quiz Exam - Facilities Management 00:10:00 Module 6: Facilities Maintenance Planning, Budgeting and Method Facilities Maintenance Planning 00:10:00 Maintenance Costs, Finance and Methods 00:10:00 Factors Affecting Maintenance 00:10:00 Assessment Module 6 Module 06 Final Quiz Exam - Facilities Management 00:10:00 Module 7: Performance and Installations Management Performance Management 00:10:00 Installations Management 00:20:00 Assessment Module 7 Module 07 Final Quiz Exam - Facilities Management 00:10:00 Module 8: Project Management Project Management 00:30:00 Assessment Module 8 Module 08 Final Quiz Exam - Facilities Management 00:10:00 Module 9: HR Management Human Resource Management 00:30:00 Assessment Module 9 Module 09 Final Quiz Exam - Facilities Management 00:10:00 Module 10: Real Estate Management, Client Delivery Models & Outsourcing Real Estate 00:30:00 Client Delivery Models 00:05:00 Outsourcing of Services or In-House Staff 00:15:00 Assessment Module 10 Module 10 Final Quiz Exam - Facilities Management 00:10:00 Order Your Certificate

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special CompTIA Cloud+ (CV0-002) Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The CompTIA Cloud+ (CV0-002) Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This CompTIA Cloud+ (CV0-002) Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This CompTIA Cloud+ (CV0-002) Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this CompTIA Cloud+ (CV0-002)? 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 CompTIA Cloud+ (CV0-002) 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 CompTIA Cloud+ (CV0-002) 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 CompTIA Cloud+ (CV0-002) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This CompTIA Cloud+ (CV0-002) 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 CompTIA Cloud+ (CV0-002) is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: What You Need to Know Introduction to the Cloud 00:04:00 Cloud+ Exam Info 00:08:00 What Can Cloud+ Do For You? 00:03:00 Preparing for the Cloud+ Exam 00:06:00 Section 02: Introducing the Cloud Setting up Your Cloud Accounts 00:06:00 Defining the Cloud 00:08:00 Deployment Models 00:05:00 Public Cloud (Demo) 00:08:00 Private Cloud (Demo) 00:06:00 Community Cloud (Demo) 00:06:00 Hybrid Cloud (Demo) 00:05:00 Additional Models 00:05:00 Cloud Architectures 00:06:00 Capacity, Elasticity, and Support Agreements 00:08:00 Resource Balancing 00:07:00 Change Management 00:07:00 Section 03: System Requirements for Cloud Deployments Deployment Exam Objectives Explained 00:06:00 Cloud Component Interactions, Part 1 00:07:00 Cloud Component Interaction, Part 2 00:08:00 Non-Cloud Component Interactions 00:09:00 Platforms and Applications 00:05:00 Baselines (Lab) 00:07:00 Target Hosts 00:05:00 Existing Systems (Lab) 00:09:00 Architecting for Elements and Targets (Demo) 00:07:00 Selecting Deployment Tools (Demo) 00:07:00 Executing a Deployment Plan (Demo) 00:09:00 Evaluating Testing Plans 00:05:00 Testing Techniques 00:05:00 Analyzing Testing Results 00:04:00 Baseline Confirmation (Lab) 00:08:00 Deployment Problem Resolution (Lab) 00:08:00 Section 04: Cloud Storage Cloud Storage Types 00:06:00 Provisioning Storage 00:06:00 Storage Protection Capabilities 00:09:00 Storage Features 00:06:00 Access Protocols 00:06:00 Storage Management (Demo) 00:06:00 Storage Security (Lab) 00:05:00 Disaster Recovery Capabilities (Demo) 00:07:00 Disaster Recovery Considerations 00:05:00 Business Continuity Plan (Lab) 00:07:00 Section 05: Cloud Compute Compute Introduction 00:06:00 CPU Capabilities 00:08:00 Memory Requirements 00:07:00 Performance Considerations 00:07:00 Cost Considerations (Lab) 00:07:00 Energy Savings 00:05:00 Dedicated vs. Shared Compute 00:04:00 High Availability and Disaster Recovery for Compute 00:05:00 Monitoring (Lab) 00:08:00 Forecasting 00:05:00 Policies 00:03:00 Section 06: Cloud Networking Network Components (Demo) 00:09:00 Network Protocols 00:04:00 Network Ports (Lab) 00:05:00 Virtual Private Networks (VPNs) 00:10:00 IDS/IPS 00:07:00 Segmentation 00:09:00 Network SLAs and Change Management 00:04:00 Networking in Different Models 00:05:00 Section 07: Cloud Security Security Policies 00:06:00 Standards and Compliance (Demo) 00:05:00 Identity, Authentication, and Authorization 00:08:00 Multi-Factor Authentication (Lab) 00:05:00 Authorization (Lab) 00:08:00 Encryption (Demo) 00:08:00 Compute Security (Demo) 00:07:00 Account Management (Lab) 00:07:00 Segmentation (Lab) 00:05:00 Security Tools (Demo) 00:07:00 Security Services 00:05:00 Security Automation and Orchestration 00:06:00 Models and Security 00:06:00 Section 08: Migrating to the Cloud Migration Types 00:07:00 Workload Management 00:05:00 Virtualizing Physical Systems 00:06:00 Migrating Security 00:07:00 Protocols and Services 00:08:00 Environmental Constraints 00:07:00 Section 09: Maintaining Cloud Solutions Planning Patch Management 00:07:00 Manual Patch Management 00:04:00 Automated Patch Management (Lab) 00:03:00 Update Types 00:08:00 Automated Workflows (Lab) 00:07:00 Backup Types (Lab) 00:10:00 Backup Targets and Options 00:07:00 Maintenance Automation Techniques 00:05:00 Maintenance Automation Tasks 00:07:00 Provisioning and Deprovisioning 00:07:00 Application Life Cycle 00:03:00 Monitoring and Reporting (Lab) 00:07:00 Monitoring Metrics 00:06:00 Section 10: Troubleshooting Cloud Solutions Troubleshooting Methodology 00:08:00 Troubleshooting Deployment 00:07:00 Troubleshooting Capacity 00:08:00 Troubleshooting Automation and Orchestration 00:07:00 Troubleshooting Connectivity 00:10:00 Troubleshooting Security 00:09:00 Assignment Assignment - CompTIA Cloud+ (CV0-002) 00:00:00

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? 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 SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00