5961 Productivity courses

Description: This Microsoft Project 2013 Advanced - Complete Video Course is designed to introduce you to the advanced commands and features of Microsoft Projects 2013. You will learn how to manage the project environment and manage task structure, linking projects, how to set a baseline in a project, and how to work with custom fields. You will also learn about generating project views and producing project reports, how to create and run effective project reports, find out about cost management, explore the use of earned value analysis for your project, discover advanced options for customizing your workspace, dive into options for consolidating and splitting projects, and much more. So, if you are interested to take your project management skills to the next level, this course will be very beneficial for you. So, don't be late to join this course today. 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? Microsoft Project 2013 Advanced - Complete Video Course 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 Microsoft Project 2013 Advanced - Complete Video Course 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. Managing the Project Environment Link Projects FREE 00:11:00 Baseline a Project 00:12:00 Work with Custom Fields 00:23:00 Managing Task Structures Change a Task List 00:21:00 Create a Network Diagram 00:13:00 Manage the Critical Path 00:05:00 Use Lag and Lead 00:13:00 Analyze Earned Value 00:24:00 Generating Project Views Use View Commands 00:24:00 Use Existing Views 00:11:00 Create Custom Views 00:15:00 Format and Share the Timeline View 00:12:00 Producing Project Reports Use Existing Reports 00:10:00 Create Custom Reports 00:23:00 Export Visual Reports 00:05:00 Mock Exam Mock Exam- Microsoft Project 2013 Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Project 2013 Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Project 2007 Advanced - Complete Video Course designed to provide you with the necessary skills to plan and schedule a building or construction project. It focuses on setting u a project in MS Project, updating and revising project schedules, assigning resources and dealing with constraints. You will learn to create time-scaled diagrams (bar charts), resolve activity clashes/problems and update and monitor activity completion, consolidating multiple projects, tools for resource types and defining costs, discover how to use and customize reports, how to assign, level, and divert resources to overcome problems, delegation and tracking tasks. You can join this course if you have an understanding of project management concepts, and responsible for creating and modifying project plans, and need a tool to manage these project plans. By taking this course you will have a complete understanding of the higher functions of Project. 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? Microsoft Project 2007 Advanced - Complete Video Course 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 Microsoft Project 2007 Advanced - Complete Video Course 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. Exchanging Information and Updating a Plan Exchanging Project Plan Data with Other Applications FREE 00:22:00 Updating a Project Plan 00:46:00 Costs, Visualization, and Reusing Plan Information Managing Project Costs 00:23:00 Reporting Project Data Visually 00:30:00 Reusing Project Plan Information 00:37:00 Mock Exam Mock Exam- Microsoft Project 2007 Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Project 2007 Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This Minute Taking Online Course is developed for the admin, secretary & PA (personal assistant), who are working in the office and require minute taking now and then. This Minute Taking Online Course covers a range of topics including understanding meeting structures, meeting minutes strategies, minute taking duties and responsibilities technology used in minute taking and how to boost minute taking confidence. Key Features This Minute Taking Online Course Comes with: CPD Certified Free Certificate from Reed CIQ Approved Minute Taking Online Course Developed by Minute Taking Specialist Lifetime Access Minute Taking Course Curriculum Module 01: Overview of Minute Taking Module 02: Ready for Minute Taking Module 03: Understanding Meeting Structures Module 04: Crafting Minute Taking for Meetings, Decisions, and Actions Module 05: Responsibilities and Duties of Minute Taking Module 06: Strategies for Effective Minute Taking Module 07: Integration of Technology in Minute Taking Management Module 08: Cultivating Confidence in Minute Taking Learning Outcomes This Minute Taking Online Course Comes with: Analyse meeting structures adeptly for accurate Minute Taking documentation. Demonstrate confidence in crafting precise minutes for various meeting scenarios. Execute effective strategies for minute taking, ensuring clarity and comprehensiveness. Integrate technology proficiently in minute taking management for streamlined documentation processes. Understand and fulfil responsibilities and duties of a proficient minute taker. Develop a strong foundation in minute taking, cultivating competence and assurance. Certification After completing this Minute Taking Onlinecourse, you will get a free Certificate. Please note: The CPD approved course is owned by E-Learning Solutions Ltd and is distributed under license. CPD 10 CPD hours / points Accredited by The CPD Certification Service Minute Writing Essentials 2:00:00 1: Module 01: Overview of Minute Writing 14:00 2: Module 02: Ready for Minute Taking 17:00 3: Module 03: Understanding Meeting Structures 14:00 4: Module 04: Crafting Minutes for Meetings, Decisions, and Actions 16:00 5: Module 05: Responsibilities and Duties of Minute Takers 20:00 6: Module 06: Strategies for Effective Minute Taking 13:00 7: Module 07: Integration of Technology in Minute Management 13:00 8: Module 08: Cultivating Confidence in Minute Writing 11:00 9: CPD Certificate - Free 01:00 10: Leave A Review 01:00 Who is this course for? Minute Taking Online Course Administrative staff Executive assistants Secretaries Project coordinators Entry-level professionals Career path Minute Taking Online Course Meeting Coordinator - £25K to 30K/year. Minute Writing Specialist - £20K to 30K/year. Administrative Assistant - £20K to 30K/year. Executive Secretary - £25K to 35K/year. Office Manager - £30K to 40K/year. Corporate Communications Coordinator - £25K to 35K/year. Project Coordinator - £25K to 35K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

This Minute Taking Online Course is developed for the admin, secretary & PA (personal assistant), who are working in the office and require minute taking now and then. This Minute Taking Online Course covers a range of topics including understanding meeting structures, meeting minutes strategies, minute taking duties and responsibilities technology used in minute taking and how to boost minute taking confidence. Key Features This Minute Taking Online Course Comes with: CPD Certified Free Certificate from Reed CIQ Approved Minute Taking Online Course Developed by Minute Taking Specialist Lifetime Access Minute Taking Course Curriculum Module 01: Overview of Minute Taking Module 02: Ready for Minute Taking Module 03: Understanding Meeting Structures Module 04: Crafting Minute Taking for Meetings, Decisions, and Actions Module 05: Responsibilities and Duties of Minute Taking Module 06: Strategies for Effective Minute Taking Module 07: Integration of Technology in Minute Taking Management Module 08: Cultivating Confidence in Minute Taking Learning Outcomes This Minute Taking Online Course Comes with: Analyse meeting structures adeptly for accurate Minute Taking documentation. Demonstrate confidence in crafting precise minutes for various meeting scenarios. Execute effective strategies for minute taking, ensuring clarity and comprehensiveness. Integrate technology proficiently in minute taking management for streamlined documentation processes. Understand and fulfil responsibilities and duties of a proficient minute taker. Develop a strong foundation in minute taking, cultivating competence and assurance. Certification After completing this Minute Taking Onlinecourse, you will get a free Certificate. Please note: The CPD approved course is owned by E-Learning Solutions Ltd and is distributed under license. CPD 10 CPD hours / points Accredited by The CPD Certification Service Minute Writing Essentials 2:00:00 1: Module 01: Overview of Minute Writing 14:00 2: Module 02: Ready for Minute Taking 17:00 3: Module 03: Understanding Meeting Structures 14:00 4: Module 04: Crafting Minutes for Meetings, Decisions, and Actions 16:00 5: Module 05: Responsibilities and Duties of Minute Takers 20:00 6: Module 06: Strategies for Effective Minute Taking 13:00 7: Module 07: Integration of Technology in Minute Management 13:00 8: Module 08: Cultivating Confidence in Minute Writing 11:00 9: CPD Certificate - Free 01:00 10: Leave A Review 01:00 Who is this course for? Minute Taking Online Course Administrative staff Executive assistants Secretaries Project coordinators Entry-level professionals Career path Minute Taking Online Course Meeting Coordinator - £25K to 30K/year. Minute Writing Specialist - £20K to 30K/year. Administrative Assistant - £20K to 30K/year. Executive Secretary - £25K to 35K/year. Office Manager - £30K to 40K/year. Corporate Communications Coordinator - £25K to 35K/year. Project Coordinator - £25K to 35K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

This Minute Taking Online Course is developed for the admin, secretary & PA (personal assistant), who are working in the office and require minute taking now and then. This Minute Taking Online Course covers a range of topics including understanding meeting structures, meeting minutes strategies, minute taking duties and responsibilities technology used in minute taking and how to boost minute taking confidence. Key Features This Minute Taking Online Course Comes with: CPD Certified Free Certificate from Reed CIQ Approved Minute Taking Online Course Developed by Minute Taking Specialist Lifetime Access Minute Taking Course Curriculum Module 01: Overview of Minute Taking Module 02: Ready for Minute Taking Module 03: Understanding Meeting Structures Module 04: Crafting Minute Taking for Meetings, Decisions, and Actions Module 05: Responsibilities and Duties of Minute Taking Module 06: Strategies for Effective Minute Taking Module 07: Integration of Technology in Minute Taking Management Module 08: Cultivating Confidence in Minute Taking Learning Outcomes This Minute Taking Online Course Comes with: Analyse meeting structures adeptly for accurate Minute Taking documentation. Demonstrate confidence in crafting precise minutes for various meeting scenarios. Execute effective strategies for minute taking, ensuring clarity and comprehensiveness. Integrate technology proficiently in minute taking management for streamlined documentation processes. Understand and fulfil responsibilities and duties of a proficient minute taker. Develop a strong foundation in minute taking, cultivating competence and assurance. Certification After completing this Minute Taking Onlinecourse, you will get a free Certificate. Please note: The CPD approved course is owned by E-Learning Solutions Ltd and is distributed under license. CPD 10 CPD hours / points Accredited by The CPD Certification Service Minute Writing Essentials 2:00:00 1: Module 01: Overview of Minute Writing 14:00 2: Module 02: Ready for Minute Taking 17:00 3: Module 03: Understanding Meeting Structures 14:00 4: Module 04: Crafting Minutes for Meetings, Decisions, and Actions 16:00 5: Module 05: Responsibilities and Duties of Minute Takers 20:00 6: Module 06: Strategies for Effective Minute Taking 13:00 7: Module 07: Integration of Technology in Minute Management 13:00 8: Module 08: Cultivating Confidence in Minute Writing 11:00 9: CPD Certificate - Free 01:00 10: Leave A Review 01:00 Who is this course for? Minute Taking Online Course Administrative staff Executive assistants Secretaries Project coordinators Entry-level professionals Career path Minute Taking Online Course Meeting Coordinator - £25K to 30K/year. Minute Writing Specialist - £20K to 30K/year. Administrative Assistant - £20K to 30K/year. Executive Secretary - £25K to 35K/year. Office Manager - £30K to 40K/year. Corporate Communications Coordinator - £25K to 35K/year. Project Coordinator - £25K to 35K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

The Desk Support Officer is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Desk Support Officer consists of several modules that take around 3 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: Core Skills Required Core Skills Required 00:12:00 Module 2: Self-Management (I) Self-Management (I) 00:08:00 Module 3: Self-Management (II) Self-Management (II) 00:08:00 Module 4: Time Management (I) Time Management (I) 00:08:00 Module 5: Time Management (II) Time Management (II) 00:09:00 Module 6: Organizing and Planning (I) Organizing and Planning (I) 00:08:00 Module 7: Organizing and Planning (II) Organizing and Planning (II) 00:08:00 Module 8: Communication (I) Communication (I) 00:08:00 Module 9: Communication (II) Communication (II) 00:09:00 Module 10: Additional Challenges Additional Challenges 00:08:00 Module 11: Business Telephone Skills Business Telephone Skills 00:19:00 Module 12: Record Keeping and Filing Systems Record Keeping and Filing Systems 00:28:00 Module 13: Business Writing Skills Business Writing Skills 00:40:00 Module 14: Invoicing/Petty Cash Invoicing/Petty Cash 00:27:00 Mock Exam Mock Exam - Desk Support Officer 00:20:00 Final Exam Final Exam - Desk Support Officer 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

The 'MS Office 2016 Word for Beginners' course is designed to provide essential skills and knowledge to beginners for effectively using Microsoft Word. It covers basic functionalities like formatting text, working efficiently, managing lists, adding tables, inserting graphic objects, controlling page appearance, and preparing documents for publication. Learning Outcomes: Navigate and utilize Microsoft Word efficiently for various tasks. Format text and paragraphs with different styles and layouts. Work more efficiently using shortcuts, auto-correct, and other time-saving features. Manage and format lists to create well-structured documents. Insert and format tables to organize data effectively. Add and manipulate graphic objects such as images, shapes, and icons. Control page appearance through margins, page breaks, and headers/footers. Prepare documents for publication by checking spelling, grammar, and using review tools. Why buy this MS Office 2016 Word for Beginners? 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 MS Office 2016 Word for Beginners you will be able to take the MCQ test that will assess your knowledge. 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 MS Office 2016 Word for Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This MS Office 2016 Word for Beginners 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 MS Office 2016 Word for Beginners is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Inserting a Table 00:06:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:05:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Proofing and Research Tools 00:07:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00

Course Overview Take your Microsoft Office skills to a new level and gain full proficiency in Word, Excel, PowerPoint, Access and Outlook. This complete Diploma in Microsoft Office will teach you how to automate tasks with macros, create powerful work presentations, write professional business documents, and much more. Through step-by-step audiovisual training, you will familiarise with the advanced tools and features of each program, taking you from beginner to expert in no time. In just a few days, you will be able to perform advanced tasks such as creating queries in Access, and will be able to work faster and much more efficiently when taking on day-to-day office tasks. By the end of this Advanced Microsoft Office Training course, you will have the skills and confidence to utilise key Microsoft Office features and tools to customise your work and enhance your documents and slides to your liking. Not only that, but you will be able to add this qualification to your resume to instantly stand out to prospective employers! Develop full proficiency in Microsoft Office and stand out to prospective employers! What You Will Learn In this Microsoft Office Diploma, you will develop full proficiency in Word, Excel, PowerPoint, Outlook and Access, guaranteeing your career prospects in any office-based role. Performing Advanced Editing & Formatting Tasks in Word Formatting Pictures and Adding SmartArt in Word Working With Illustrations in Word Adding Tables & Inserting Special Objects in Word Working With Document References in Word How to Automate Tasks With Macros In Excel Managing, Grouping & Outlining Data In Excel Inserting Text, Audio & Visual in PowerPoint Tips for Preparing Your PowerPoint Presentation Creating Queries, Reports & Reforms in Access Managing Junk Mail & Performing Advanced Calendar Tasks Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.

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

Overview This comprehensive course on Medical Receptionist: Responsibilities and Skills will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Medical Receptionist: Responsibilities and Skills comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? •There is no experience or previous qualifications required for enrolment on this Medical Receptionist: Responsibilities and Skills. It is available to all students, of all academic backgrounds. Requirements Our Medical Receptionist: Responsibilities and Skills is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 15 lectures • 04:55:00 total length •Module 01: Introduction to Medical and Clinical Administration: 00:15:00 •Module 02: Introduction to Healthcare and Receptionists: 00:31:00 •Module 03: Organise Schedules: 00:21:00 •Module 04: Maintaining Medical Records: 00:19:00 •Module 05: Effective Filing Systems in Medical Offices: 00:16:00 •Module 06: Confidentiality in a Medical Environment: 00:14:00 •Module 07: Medical Jargon and Terminology: 00:25:00 •Module 08: Controlling Stocks and Supplies: 00:09:00 •Module 09: Medical (Clinical) Coding and Billing: 00:18:00 •Module 10: Information Technology in Health Care: 00:13:00 •Module 11: Legal aspects and Ethics: 00:19:00 •Module 12: Maintaining Workplace Safety: 00:20:00 •Module 13: Time Management: 00:35:00 •Mock Exam - Medical Receptionist: Responsibilities and Skills: 00:20:00 •Final Exam - Medical Receptionist: Responsibilities and Skills: 00:20:00