5883 Software courses

Tired of browsing and searching for a Computer Maintenance Training course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Computer Maintenance Training bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Computer Maintenance Training course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Computer Maintenance Training and help you along your learning journey. Advanced audio-visual learning modules of these Computer Maintenance Training courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Computer Maintenance Training , we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Computer Maintenance Training Bundle Consists of the following Premium courses: Course 01: Building Your Own Computer Course 02: Electronic & Electrical Devices Maintenance Course 03: PAT Level 4 Course 04: Complete Windows 10 Troubleshooting for IT Helpdesk Course 05: Internet of Things Course 06: Network Security Level 2 Course 07: Cyber Security Incident Handling and Incident Response Course 08: CompTIA PenTest+ (Ethical Hacking) Course 09: Functional Skills IT Course 10: Encryption Course 11: Computer Science With Python Course 12: The Complete Microsoft Outlook Masterclass Course 13: Advanced Electrical Safety Course 14: Decision Making and Critical Thinking The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Computer Maintenance Training expertise and essential knowledge, which will assist you in reaching your goal. Course Curriculum : Building Your Own Computer Module 01: Introduction to Computer & Building PC Module 02: Overview of Hardware and Parts Module 03: Building the Computer Module 04: Input and Output Devices Module 05: Software Installation Module 06: Computer Networking Module 07: Building a Gaming PC Module 08: Maintenance of Computers Enrol now in Computer Maintenance Training to advance your career, and use the premium study materials from Apex Learning. Certificate: PDF Certificate: Free (Previously it was £6*14 = £84) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Computer Maintenance Training bundle. Requirements Our Computer Maintenance Training course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Computer Maintenance expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for: Developers System Administrators Solutions Architects Overview This course is designed to teach you how to: Design a microservices-based architecture that uses containers Use Amazon ECS to run and scale a microservices-based application Integrate Amazon ECS with other AWS services Running Container-Enabled Microservices on AWS is designed to teach you how to manage and scale container-enabled applications by using Amazon Elastic Container Service (ECS). This course highlights the challenges of running containerized applications at scale and provides guidance on creating and using Amazon ECS to develop and deploy containerized microservices-based applications. In the hands-on lab exercises you will use Amazon ECS to handle long-running services, build and deploy container images, link services together, and scale capacity to meet demand. You will also learn how to run container workers for asynchronous application processes. Module 1a: Overview of Microservices on AWS Welcome to Simple Mustache Service! The monolith What are microservices? How to implement a microservices infrastructure The six principles of microservices Module 1b: Containers and Docker Introduction to containers Comparing virtual machines with containers Docker Running containers Storing container images Hands-on lab: Building and running your first container Module 2: Continuous delivery for container-based microservices Compare and contrast different software development cycles Use AWS CodePipeline to code, build, and deploy a microservice Use AWS CodeCommit as a source control service Use Jenkins to perform a Docker build Use Postman to run and test microservices Use AWS CloudFormation to provision and deploy microservices Hands-on lab: Using the Amazon ECS Service Scheduler Module 3: High availability and scaling with Amazon Elastic Container Service High availability Cluster management and scheduling Monitoring Scaling a cluster Scaling services Hands-on lab: Continuous delivery pipelines for container-based microservices Module 4: Security for container-based microservices Implement security Apply best practices Automate security Evaluate compliance requirements Embed security into the CI/CD Hands-on lab: Extending Amazon ECS with Service Discovery and Config Management Additional course details: Nexus Humans Running Container Enabled Microservices on AWS 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 Running Container Enabled Microservices on AWS 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.

The 'Unix Administration: Unix Operating System' course offers a comprehensive introduction to Unix, focusing on key concepts, file and directory management, essential commands, and the basics of the VI text editor. Participants will gain practical knowledge and skills in Unix administration, enabling them to navigate and manage the Unix operating system effectively. Learning Outcomes: Understand the fundamentals of Unix and its significance in modern computing. Explore directory and file management techniques, including creation, manipulation, and organization. Master essential Unix commands for tasks such as navigation, file operations, and system management. Learn the basics of the VI text editor for efficient file editing and manipulation. Acquire proficiency in using Unix shell commands to enhance system administration. Develop skills in managing user accounts, permissions, and security settings. Gain knowledge of process management and system monitoring in Unix. Understand basic networking concepts and how they apply to Unix systems. Why buy this Unix Administration: Unix Operating System? 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 Unix Administration: Unix Operating System 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 Unix Administration: Unix Operating System does not require you to have any prior qualifications or experience. You can just enrol and start learning.  IT professionals seeking to enhance their Unix administration skills. System administrators and network administrators working with Unix-based systems. Software developers and programmers interested in Unix environments. Students and enthusiasts looking to gain hands-on experience with Unix. Individuals pursuing a career in IT infrastructure and system management. Prerequisites This Unix Administration: Unix Operating System 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 Unix System Administrator - Median salary of £40,000 - £50,000 per year. Network Administrator - Median salary of £30,000 - £40,000 per year. IT Operations Manager - Median salary of £50,000 - £70,000 per year. Software Developer - Median salary of £35,000 - £45,000 per year. IT Consultant - Median salary of £40,000 - £60,000 per year. Course Curriculum Unix Administration: Unix Operating System Introduction to Unix 01:00:00 Directory and File Management (Part- I) 00:58:00 Directory and File Management (Part- II) 00:59:00 Commands in Unix 00:59:00 Basics of VI Editor 00:59:00 Assignment Assignment - Unix Administration: Unix Operating System 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This course is designed for project leaders, scrum masters, coaches, product owners, and team members who intend on taking the PMI-ACP© exam. This course provides participants with a foundation of the PMI-ACP© exam. Participants will be introduced to PMI Agile concepts and practices with banks of sample questions. PMI-ACP© Exam Preperation PMI-ACP© Exam Particulars Overview PMI-ACP© Exam Particulars PMI-ACP© Candidate Requirements PMI-ACP© Candidate Fees PMI-ACP© Exam Application Process Core Agile Concepts Core Agile Concepts Overview Traditional Project Management Methodologies Drawbacks of Waterfall Methodologies Agile Approach Empirical Process Control Agile and Traditional Project Management Choice of Methodologies/Frameworks The Agile Manifesto The Agile Manifesto Overview Manifesto Contributors Manifesto Values Manifesto Principles Common Agile Methodology Elements Common Agile Methodology Elements Overview Project (Product; Release) Initiation Agile Planning Iteration Planning and Executing Project Initiation Project Initiation Overview Determine Project Justifications and Metrics Provide Value-Driven Delivery Write Project Vision Statement Create Project Charter Identify Stakeholders and Leader/Coach Form Project Team Agile Teams and Team Space Agile Teams and Team Space Overview Scrum Master/Coach Product Owner/Customer Team Members/Developers (XP) Trackers and Testers Other Roles Team Space Physical Space Recommendations Agile Planning Agile Planning Overview Develop Epics and Stories Create Stories Non-Customer Facing Stories Personas and Extreme Personas Story Maps Estimating Stories Prioritizing Stories Create Product Backlog Create Product Roadmap Conduct Release Planning Create Parking Lot Iterations/Sprints Iterations/Sprints Overview Velocity Determination Iteration Planning Meeting Iteration Planning Guidelines Development Testing Daily Standup Meetings Progress Tracking Velocity Tracking Interpersonal Aspects of Agile Interpersonal Aspects of Agile Overview Methodologies and Uncertainty Coach/Scrum Master Team Motivation Soft Skills Emotional Intelligence Collaboration Negotiations Active listening Conflict Resolution Speed Leas? Model of Group Conflict Conducting Retrospectives Mindsets of Agile Coaches Leadership Stages Key Coaching Responsibilities Agile Methodologies Agile Methodologies Overview XP and Scrum Terms XP Terms and Concepts XP Primary Practices XP Corollary Practices Scrum Lean Software Development Seven Principles of Lean Seven Types of Muda Responsibilities Core Beliefs of Lean-Agile Software Development Other Principles of Lean-Agile Software Development Value Stream Mapping Lean-Agile Software Development Portfolio Management Additional course details: Nexus Humans PMI Agile Certified Practitioner (PMI-ACP) Exam Preparation 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 PMI Agile Certified Practitioner (PMI-ACP) Exam Preparation 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 Built for experienced IT Professionals who want to be familiar with Citrix ADC. Potential students include administrators, engineers, and architects interested in learning how to deploy or manage Citrix ADC. Overview Understand the functionality and capabilities of the Citrix ADC Complete the initial setup and configuration of the Citrix ADC appliance Understand Citrix ADC Load Balancing and High Availability configuration options and management Employ recommended tools and techniques to troubleshoot common ADC network and connectivity issues Learn the skills required to implement Citrix ADC Essential components includingsecure Load Balancing, High Availability, and Citrix ADC Management. At the endof the course, students will be able to configure their Citrix ADC environments toaddress traffic delivery and management requirements including Load Balancing,Availability, and ADC Operation Management. Getting Started Introduction to Citrix ADC Feature and Platform Overview Deployment Options Architectural Overview Setup and Management Basic Networking Networking Topology Citrix ADC Components Routing Access Control Lists ADC Platforms Citrix ADC MPX Citrix ADC VPX Citrix ADC CPX Citrix ADC SDX Citrix ADC BLX High Availability Citrix ADC High Availability High Availability Configuration Managing High Availability In Service Software Upgrade Troubleshooting High Availability Load balancing Load Balancing Overview Load Balancing Methods and Monitors Load Balancing Traffic Types Load Balancing Protection Priority Load Balancing Load Balancing Troubleshooting SSL Offloading SSL Overview SSL Configuration SSL Offload Troubleshooting SSL Offload SSL Vulnerabilities and Protections Security Authentication, Authorization, and Auditing Configuring External Authentication Admin Partitions Security Citrix ADC Logging Monitoring with SNMP Reporting and Diagnostics AppFlow Functions Citrix Application Delivery Management Troubleshooting

In an era where digital proficiency dominates the business realm, mastering the nuances of top-notch software like Xero can make a world of difference in the accounting sector. Dive deep into the intricacies of Xero Accounting & Bookkeeping and unravel the secrets of managing financial tasks seamlessly. Whether understanding how to add an accountant to Xero or effortlessly manoeuvring through invoices and sales, this course is tailored to give you a comprehensive grasp of the Xero software. The curriculum does more than just touch the surface. Our handpicked course modules ensure a holistic approach to Xero. From 'Getting Started'-a gentle introduction for beginners-to in-depth explorations of 'Bills and Purchases', 'Bank Accounts', and 'Fixed Assets', every topic is curated to provide a 360-degree understanding. And for those who've been searching for an efficient guide on adding an accountant to Xero, your search ends here. Our course isn't just about breadth; it's about depth, ensuring learners are equipped with the nuances and subtleties that can make all the difference in real-world scenarios. Learning Outcomes Acquire expertise in setting up and navigating the Xero accounting platform. Gain insights into the efficient management of invoices, sales, bills, and purchases. Understand the dynamics of managing bank accounts, products, and services on Xero. Develop skills in overseeing fixed assets, payroll, and processing VAT returns. Enhance competency in using Xero software for optimal financial management. Why choose this Certificate in Xero Accounting & Bookkeeping at QLS Level 3 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Certificate in Xero Accounting & Bookkeeping at QLS Level 3 course for? Business owners eager to streamline their financial management processes. Aspiring accountants aiming to diversify their skillset with Xero proficiency. Bookkeepers looking to integrate Xero into their daily operations. Financial consultants seeking a digital edge in their advisory roles. Students of accounting and finance aiming to stay ahead in the digital accounting curve. Career path Xero Software Specialist: £28,000 - £35,000 Per Year Accountant (Xero Proficient): £30,000 - £45,000 Per Year Bookkeeper with Xero Expertise: £23,000 - £31,000 Per Year Financial Consultant (Xero Integrated): £35,000 - £52,000 Per Year Payroll Manager (Xero Familiarity): £27,000 - £40,000 Per Year VAT Returns Specialist: £29,000 - £37,000 Per Year Prerequisites This Certificate in Xero Accounting & Bookkeeping at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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. Method of Assessment To assess your learning of this Certificate in Xero Accounting & Bookkeeping at QLS Level 3 course, you have to participate in an automated multiple-choice question exam. You have to score at least 60% to pass the exam and to qualify for CPD accredited certificates. After passing the exam, you will be able to apply for a certificate. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £85 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Introduction Introduction 00:02:00 Getting Started Introduction - Getting Started 00:01:00 Signing up to Xero 00:04:00 Quick Tour of Xero 00:12:00 Initial Xero Settings 00:13:00 Chart of Accounts 00:14:00 Adding a Bank Account 00:08:00 Demo Company 00:04:00 Tracking Categories 00:07:00 Contacts 00:12:00 Invoices and Sales Introduction - Invoices and Sales 00:01:00 Sales Screens 00:04:00 Invoice Settings 00:13:00 Creating an Invoice 00:17:00 Repeating Invoices 00:07:00 Credit Notes 00:10:00 Quotes Settings 00:03:00 Creating Quotes 00:07:00 Other Invoicing Tasks 00:03:00 Sending Statements 00:03:00 Sales Reporting 00:05:00 Bills and Purchases Introduction - Bills and Purchases 00:01:00 Purchases Screens 00:04:00 Bill Settings 00:02:00 Creating a Bill 00:13:00 Repeating Bills 00:05:00 Credit Notes 00:06:00 Purchase Order Settings 00:02:00 Purchase Orders 00:08:00 Batch Payments 00:12:00 Other Billing Tasks 00:02:00 Sending Remittances 00:03:00 Purchases Reporting 00:05:00 Bank Accounts Introduction - Bank Accounts 00:01:00 Bank Accounts Screens 00:07:00 Automatic Matching 00:04:00 Reconciling Invoices 00:06:00 Reconciling Bills 00:03:00 Reconciling Spend Money 00:05:00 Reconciling Receive Money 00:04:00 Find and Match 00:04:00 Bank Rules 00:09:00 Cash Coding 00:04:00 Remove and Redo vs Unreconcile 00:04:00 Uploading Bank Transactions 00:07:00 Automatic Bank Feeds 00:06:00 Products and Services Introduction - Products and Services 00:01:00 Products and Services Screen 00:02:00 Adding Services 00:03:00 Adding Untracked Products 00:03:00 Adding Tracked Products 00:07:00 Fixed Assets Introduction - Fixed Assets 00:01:00 Fixed Assets Settings 00:05:00 Adding Assets from Bank Transactions 00:06:00 Adding Assets from Spend Money 00:05:00 Adding Assets from Bills 00:02:00 Depreciation 00:04:00 Payroll Introduction - Payroll 00:01:00 Payroll Settings 00:15:00 Adding Employees 00:18:00 Paying Employees 00:10:00 Payroll Filing 00:04:00 VAT Returns Introduction - VAT Returns 00:01:00 VAT Settings 00:02:00 VAT Returns - Manual Filing 00:06:00 VAT Returns - Digital Filing 00:02:00 Mock Exam Mock Exam - Certificate in Xero Accounting & Bookkeeping at QLS Level 3 00:20:00 Final Exam Final Exam - Certificate in Xero Accounting & Bookkeeping at QLS Level 3 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Are you interested in pursuing a rewarding career as a web developer? Alternatively, perhaps you'd want to brush up on your skills and take things to a whole new level? Then this course is for you. A carefully structured course for both beginners and intermediate-level learners.

With this course, you will kick start your journey of creating awesome GUI applications in Python using the Tkinter library. During the process, you will become familiar with the GUI widgets, application layout, and executable files.

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

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Health and Safety in Construction bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Health and Safety in Construction related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Health and Safety in Construction bundle will help you build a solid foundation to become a proficient worker in the sector. This Health and Safety in Construction Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Construction Management - Level 5 Diploma Course 02 :Construction Site Planning and Managment Course 03 :Construction Cost Estimation Diploma Course 04 :Construction Safety Diploma Course 05 :Construction Industry Scheme (CIS) Course 06 :Quantity Surveyor Training Course 07 :Building Surveyor Course 08 :Land Surveying Course 09 :Property Management Training Course 10 :Property Development Diploma Course 11 :Property Law Course 12 :Property Business Training - Level 5 Course 13 :Residential Property Sales Course 14 :Public Housing Management Course 15 :WELL Building Standard Course 16 :Building Design And Construction With LEED V4.1 Course 17 :AutoCAD VBA Programming for Beginners Course 18 :AutoCAD Programming using C# with Windows Forms Course 19 :Cost Control and Management Training Course 20 :Positive Workplace Environment Course 21 :Effective Communication Skills for Technical People Course 22 :Leadership Styles Course 23 :Workplace First Aid Level 3 Course 24 :Workplace Management Training Course 25: COSHH Training for Assessors Course 26: LOLER Training Level 2 Course 27: RIDDOR Training Course 28: Working at Height Course 29: Lone Worker Safety Diploma Course 30: Ladder Safety Training 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made Health and Safety in Construction bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Health and Safety in Construction Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Health and Safety in Construction bundle! This bundle is also ideal for professionals looking for career advancement. Note: This is not a regulated course. To get a professional qualification, you may like to choose: Health and Safety Management for Construction (UK) Level 3 Certificate in Occupational Health and Safety NEBOSH National Diploma in Occupational Health and Safety NEBOSH National General Certificate in Occupational Health & Safety NEBOSH, International General Certificate in Occupational Health & Safety Level 6 Diploma - Occupational Health and Safety Management Courses from the Institution of Occupational Safety and Health ProQual Level 5 NVQ Diploma in Occupational Health and Safety Practice ProQual Level 6 NVQ Diploma in Occupational Health and Safety Practice ISO 45001 Occupational Health and Safety National Examination Board in Occupational Safety and Health Level 3 NVQ Health and Safety Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Health and Safety in Construction Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.