5512 Courses delivered Online

Learn everything there is about Microsoft Office Looking to learn everything there is about all the Microsoft Office programs? This course will give you exactly what you are looking for. Learn all there is about Microsoft Word, Excel, Outlook, PowerPoint, OneNote, Access, Publisher, Project, InfoPath, SharePoint Designer and Visio. Get the complete course in this great deal. Microsoft Office introduces a new graphical interface user called the Fluent User Interface, which uses ribbons and an Office menu instead of menu bars and toolbars. Office also introduced Office Open XML file formats as the default file formats in Excel, PowerPoint, and Word. Office also introduces a feature called 'Live Preview', which temporarily applies formatting on the focused text or object, when any formatting button is moused-over. This Course is designed to make you learn everything about all the Microsoft Office tools of and all of its new features. Learning all the office softwares increases your credibility in today's competitive job market. So what are you waiting for? This is the course for you. Course Highlights Certified Microsoft Office Complete Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft Office Complete Course into several modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft Office Complete Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft Office Complete Course is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Certified Microsoft Office Complete 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening Word FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities- Microsoft Word for Beginners Accredited Course 00:00:00 Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Microsoft PowerPoint Module One - Getting Started FREE 00:30:00 Module Two - Opening PowerPoint FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Access Module One - Getting Started 00:30:00 Module Two - Opening and Closing Access FREE 01:00:00 Module Three - An Introduction to Databases 01:00:00 Module Four - Sharing Data Using Apps 01:00:00 Module Five - Working in Your App 01:00:00 Module Six - An Introduction to Desktop Databases 01:00:00 Module Seven - Performing Basic Table Tasks 01:00:00 Module Eight - Working with Fields 01:00:00 Module Nine - Working with Table Relationships 01:00:00 Module Ten - An Introduction to Queries, Forms, and Reports 01:00:00 Module Eleven - Protecting Your Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access for Beginners CPD Accredited 00:00:00 Microsoft Outlook Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Outlook FREE 01:00:00 Module Three - Understanding the Interface 01:00:00 Module Four - Working with the Message List and the Reading Pane 01:00:00 Module Five - Using Message List Commands 01:00:00 Module Six - Creating a New Email 01:00:00 Module Seven - Managing Email 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Accredited Microsoft Outlook for Beginners 00:00:00 Mock Exam Mock Exam- Certified Microsoft Office Complete Course 00:30:00 Final Exam Final Exam- Certified Microsoft Office Complete Course 00:30:00

Course on all the Essentials of Microsoft Office 2010 Looking to learn everything there is about all the Microsoft Office programs? This course will give you exactly what you are looking for. Learn all there is about Microsoft Word, Excel, Outlook, PowerPoint, OneNote, Access, Publisher, Project, InfoPath, SharePoint Designer and Visio. Certified Microsoft Office Essentials 2010 has carried on with its graphical interface user called the Fluent User Interface, which uses ribbons and an Office menu instead of menu bars and toolbars. Office 2010 also has Office Open XML file formats as the default file formats in Excel, PowerPoint, and Word. Office 2010 has improved Microsoft Outlook and better graphics for pictures and videos in Word and PowerPoint. This Course is designed to make you learn everything about all the Microsoft Office tools of 2010 and all of its new features. Learning all the office softwares increases your credibility in today's competitive job market. So what are you waiting for? This is the course for you. Course Highlights Certified Microsoft Office 2010 Essentials is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft Office 2010 Essentials into 65 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 2 days, 6 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft Office 2010 Essentials Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft Office 2010 Essentials is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Certified Microsoft Office 2010 Essentials 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Word Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Word FREE 01:00:00 Module Three - Working with Documents 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Advanced Formatting Tasks 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Adding the Finishing Touches 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Accredited Microsoft Word 2010 for Beginners Training 00:00:00 Microsoft Excel Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Excel FREE 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Accredited Microsoft Excel 2010 for Beginners 00:00:00 Microsoft PowerPoint Module One - Getting Started 01:00:00 Module Two - Opening and Closing PowerPoint 00:30:00 Module Three - Working with Presentations 00:30:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 00:30:00 Module Six - Formatting Text 00:30:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 00:30:00 Module Nine - Customizing Slide Elements 01:00:00 Module Ten - Setting Up Your Slide Show 00:30:00 Module Eleven - Showtime 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities-Certificate in Microsoft PowerPoint 2010 for Beginners 00:00:00 Microsoft Access Module One - Getting Started FREE 00:30:00 Module Two - Getting Started With Access FREE 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 02:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access 2010 for Beginners 00:00:00 Microsoft Outlook Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Working with E-mail 01:00:00 Module Four - Creating a New E-mail 01:00:00 Module Five - Managing E-mail 01:00:00 Module Six - Managing Junk Mail 01:00:00 Module Seven - Outlook's Organization Tools 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contacts 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities-Certified Microsoft Outlook 2010 for Beginners 00:00:00 Mock Exam Mock Exam - Certified Microsoft Office 2010 Essentials 00:20:00 Final Exam Final Exam - Certified Microsoft Office 2010 Essentials 00:20:00

Description: The 70-680 - Configuring Microsoft Windows 7 Training course is for the users who use Microsoft Windows 7 as a desktop operating system in an enterprise environment. However, you should have at least one year of experience in the IT field, as well as experience implementing and administering any Windows client operating system in a networked environment. Another pre-requisite of the course is to able to install, deploy, and upgrade to Windows 7, including ensuring hardware and software compatibility. Apart from these, you should also be able to configure pre-installation and post-installation system settings, Windows security features, network connectivity applications included with Windows, and mobile computing. You should also require maintaining systems, including monitoring for and resolving performance and reliability issues. Finally, you should know the basic concept of Windows PowerShell syntax. The course will teach you about Windows PowerShell 2.0, the ways of remoting with Windows PowerShell 2.0, and configuring group policy with PowerShell 2.0. 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? 70-680 - Configuring Microsoft Windows 7 Training 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 70-680 - Configuring Microsoft Windows 7 Training 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. Basic Windows 7 Installation Installation Options FREE 00:17:00 Choosing To Do the Clean Install 00:13:00 Advanced Windows 7 Installation Performing an Image Installation 00:15:00 Doing an Upgrade or Migration to Windows 7 00:10:00 Planning for Application Compatibility 00:08:00 Understanding Disk Types and File Systems Windows 7 Disk Types and Formats 00:14:00 Managing Hard Drives with Volumes 00:25:00 Hard Drive Maintenance 00:14:00 Network Configuration IP Addressing 00:45:00 Auto IP Configuration 00:09:00 Troubleshooting Networking 00:17:00 Introducing Wireless Networks 00:09:00 Connecting Windows 7 to the Wireless Network 00:09:00 Sharing Files, Folders, and Printers Planning for Authentication and Authorization 00:14:00 Securing File Access 00:25:00 Compressing Files 00:12:00 Sharing Folders and Printers 00:20:00 Working with Windows 7 Client Performance Installing and Configuring Device Drivers 00:19:00 Windows 7 Performance Monitoring Tools 00:18:00 Monitoring Reliability of Windows 7 00:08:00 Basic Desktop Security Discussion of Security Management in Windows 7 00:11:00 Using Windows Defender 00:15:00 How does UAC Work 00:20:00 Using Windows Firewall 00:28:00 Advanced Desktop Security Using Local Policies to Secure Windows 7 00:18:00 How EFS and BitLocker Secure Your Data 00:15:00 Security With Application Restrictions 00:22:00 IE Version 8 Privacy Features 00:16:00 Disaster Recovery & Prevention Backing Up and Restore Options with Windows 7 00:10:00 How System Restore Works 00:09:00 Using the Windows Update 00:08:00 Remote Access Options Configuring Windows 7 for Mobility 00:10:00 Remote Access Solutions 00:04:00 Understanding VPN Connections 00:12:00 What is BranchCache 00:09:00 Introducing Windows PowerShell 2.0 What is Windows PowerShell 2.0 00:11:00 Remoting With Windows PowerShell 2.0 00:04:00 Configuring Group Policy with PowerShell 2.0 00:03:00 Mock Exam Mock Exam- 70-680 - Configuring Microsoft Windows 7 Training 00:20:00 Final Exam Final Exam- 70-680 - Configuring Microsoft Windows 7 Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on Personal and Networking Skills will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Personal and Networking Skills comes with accredited certification from CPD, 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 Personal and Networking Skills. It is available to all students, of all academic backgrounds. Requirements Our Personal and Networking 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 1 sections • 7 lectures • 00:45:00 total length •Why Is Networking Powerful?: 00:05:00 •Networking Paradigm Shifts: 00:03:00 •You've Got To GIVE To GET: 00:08:00 •The Power Of 'Likeability': 00:09:00 •Making The Connection: 00:06:00 •Great Places To Network: 00:08:00 •The Power Of Mentors: 00:06: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

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

Master the role of a Hotel Receptionist with our top Hotel Receptionist Diploma. Learn procedures, communication, and brand standards in hospitality.

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

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.