6763 Courses

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and fulfilling profession. This SQL Masterclass: SQL for Data Analytic is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as offer many job opportunities in the competitive job market. In this course, you will learn how to create databases, tables, design databases and tables. You will also learn to create flat file database, confidently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible. Enrol right now and start exploring SQL, the most popular relational database management system. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. 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. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. 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. SQL for Data Analytic - Beginner Level Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 SQL for Data Analytic - Intermediate Level Module: 07 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 08 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 09 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 10 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 11 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 12 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 13 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 14 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 15 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 SQL for Data Analytic - Advanced Level Module: 16 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 17 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 18 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 19 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00

Overview This comprehensive course on XLOOKUP and VLOOKUP will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This XLOOKUP and VLOOKUP 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 XLOOKUP and VLOOKUP. It is available to all students, of all academic backgrounds. Requirements Our XLOOKUP and VLOOKUP 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 20 lectures • 01:52:00 total length •What is XLOOKUP?: 00:01:00 •XLOOKUP Syntax: 00:08:00 •XLOOKUP Rules: 00:05:00 •XLOOKUP NA Error: 00:03:00 •XLOOKUP match_mode: 00:09:00 •XLOOKUP search_mode: 00:06:00 •XLOOKUP Wildcards: 00:11:00 •XLOOKUP Horizontal Lookup: 00:04:00 •XLOOKUP Across Different Spreadsheets: 00:03:00 •XLOOKUP Final Example: 00:07:00 •Introduction: 00:02:00 •What is VLOOKUP?: 00:01:00 •VLOOKUP Syntax: 00:06:00 •VLOOKUP - Range_lookup FALSE: 00:06:00 •VLOOKUP - Range_lookup TRUE: 00:06:00 •VLOOKUP Rules: 00:06:00 •VLOOKUP NA Errors: 00:06:00 •VLOOKUP Wildcards: 00:11:00 •VLOOKUP Insert Function: 00:04:00 •VLOOKUP Across Different Tabs: 00:07:00

Overview This comprehensive course on RCA: Root Cause Analysis will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This RCA: Root Cause Analysis 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 RCA: Root Cause Analysis. It is available to all students, of all academic backgrounds. Requirements Our RCA: Root Cause Analysis 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 7 sections • 19 lectures • 01:17:00 total length •Introduction: 00:04:00 •The fundamentals of RCA: 00:08:00 •The Process: 00:02:00 •Step 1: Define the problem: 00:03:00 •Step 2: Collect data: 00:02:00 •Step 3: Identify possible causes: 00:02:00 •Step 4: Identify root causes: 00:01:00 •Step 5: Identify and implement solutions: 00:02:00 •Step 6: Monitor controls: 00:02:00 •Tools to Conduct an RCA: 00:01:00 •Pareto chart: 00:04:00 •5 whys: 00:06:00 •Fishbone Diagram: 00:04:00 •Drill down: 00:04:00 •FMEA: 00:09:00 •Issue / error Log: 00:05:00 •Other points to consider: 00:14:00 •Close out: 00:04:00 •Assignment - RCA: Root Cause Analysis: 00:00:00

Overview This comprehensive course on Aviation Law Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Aviation Law Training 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 Aviation Law Training. It is available to all students, of all academic backgrounds. Requirements Our Aviation Law Training 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 14 lectures • 08:25:00 total length •Introduction to Aviation Law Training: 00:40:00 •Growth and Benefits: 00:45:00 •Air Policy: 00:50:00 •Public International Law: 00:30:00 •Private International Law: 00:35:00 •Aviation Law: 00:35:00 •Criminal Law in Aviation: 00:35:00 •Commercial Law in Aviation: 00:35:00 •Rules and Regulation Relating to Aviation: 00:45:00 •Climate Change on Aviation: 00:30:00 •Environmental Impact on Aviation: 00:50:00 •Aircraft Management and Insurance: 00:40:00 •Airport Security and Operations: 00:35:00 •Assignment - Aviation Law Training: 00:00:00

Overview This comprehensive course on Amazon Kindle Master Class will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Amazon Kindle Master Class 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 Amazon Kindle Master Class. It is available to all students, of all academic backgrounds. Requirements Our Amazon Kindle Master Class 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 11 lectures • 01:08:00 total length •Kindle Method Explained: 00:09:00 •4 Benefits of the Kindle Method: 00:06:00 •6 Key Places to Look to Find Book-Worthy Topics: 00:11:00 •The 4-Step Process to Complete Your Book Faster: 00:12:00 •Peer Editing (Step 2) & Designing Your Cover (Step 3): 00:10:00 •How to 'Self-Publish' Your Book Fast (Step 4): 00:04:00 •The 7 Most Important Steps to Completing Your Book: 00:07:00 •Affirmation - I Harness My Inner Strength: 00:03:00 •Affirmation - I Harvest My Innate Wisdom: 00:02:00 •Postscript: 00:04:00 •Assignment - Amazon Kindle Master Class: 00:00:00

Overview This comprehensive course on Childminder & Nursery Worker will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Childminder & Nursery Worker 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 Childminder & Nursery Worker. It is available to all students, of all academic backgrounds. Requirements Our Childminder & Nursery Worker 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 11 lectures • 05:01:00 total length •Introduction to Nursery Nurse: 00:17:00 •Understanding the Growth and Development of Children: 00:28:00 •Observation and Assessment of Children in the Early Years Setting: 00:22:00 •Curriculum and Developing Early Learning: 00:29:00 •Promoting Equality, Diversity and Inclusive Practice in Early Years of Learning: 00:29:00 •Safeguarding, Protection and Welfare of Young Children: 00:28:00 •Health and Safety of Children in the Early Years: 00:37:00 •Nutrition and Healthy Food for Children: 00:32:00 •Play and Learning in Children's Education: 00:30:00 •Working with Children Having Special Needs: 00:28:00 •Working in Partnership with Parents and Careers: 00:21:00

Overview This comprehensive course on Excel Pivot Tables will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables 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 Excel Pivot Tables. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 18 lectures • 00:47:00 total length •Excel Pivot Tables: 00:03:00 •Overview about Store Dataset: 00:02:00 •Data Insights: 00:02:00 •Sales Profit Summary: 00:03:00 •Highlight the Data: 00:01:00 •Unprofitable Products: 00:02:00 •Create Crosstabs: 00:02:00 •Select Regions for Unprofitable Products: 00:04:00 •Real Time Analytics and Insights: 00:02:00 •Search Data for States with Slicers: 00:06:00 •Finding Trends: 00:02:00 •Find Data for Specific Date: 00:04:00 •Reporting Made Easy: 00:02:00 •Generate Reports with Pivot Tables: 00:04:00 •Marketing Analytics: 00:02:00 •Target Your Advertisements: 00:05:00 •Become Analyst: 00:01:00 •Assignment - Excel Pivot Tables: 00:00:00

Overview This comprehensive course on Child Playwork will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Child Playwork 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 Child Playwork. It is available to all students, of all academic backgrounds. Requirements Our Child Playwork 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 13 lectures • 09:40:00 total length •Introduction to Child Playwork: 00:40:00 •Playwork Theory, Principles and Practices: 01:10:00 •The Education and Learning Benefits of Playwork: 00:40:00 •Play and Playwork in a Health and Well-Being Context: 01:00:00 •The Economic and Social Benefits of Playwork: 01:00:00 •The Developmental and Behavioural Benefits of Playwork: 00:45:00 •The Negative Results of Play Deprivation: 00:10:00 •Inclusive Play and Challenging Play Environment: 00:35:00 •Designing Play Spaces: 01:10:00 •The Administrative Context of a Playwork Provision: 01:10:00 •Legislation for Safeguarding Children and Child Playwork: 00:40:00 •Reflective Playwork Practice: 00:40:00 •Assignment - Child Playwork: 00:00:00

Overview This comprehensive course on Legal Secretary will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Legal Secretary 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 Legal Secretary. It is available to all students, of all academic backgrounds. Requirements Our Legal Secretary 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 14 sections • 14 lectures • 06:12:00 total length •Module 01: Understanding the Concept of Paralegal: 00:25:00 •Module 02: Key Legal Terminology: 00:16:00 •Module 03: Effective Communication Skills for Paralegals: 00:39:00 •Module 04: The Legal Workplace & Professionals: 00:45:00 •Module 05: Law & Legal Systems: 00:33:00 •Module 06: Contract & Business Law: 00:54:00 •Module 07: Property Law: 00:19:00 •Module 08: Wills, Probate, Estate Law: 00:15:00 •Module 09: Criminal Law: 00:24:00 •Module 10: Common Paralegal Legal Matters: 00:35:00 •Module 11: Human Rights: 00:12:00 •Module 12: Conflict and Conflict Resolution: 00:18:00 •Module 13: Professional Conduct and Ethics of Paralegals: 00:25:00 •Module 14: Mandatory Knowledge Fields and Survival Tips for Paralegals: 00:12:00

Overview This comprehensive course on Large Goods Vehicle (LGV) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Large Goods Vehicle (LGV) 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 Large Goods Vehicle (LGV). It is available to all students, of all academic backgrounds. Requirements Our Large Goods Vehicle (LGV) 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 14 lectures • 02:14:00 total length •Knowing Your LGV: 00:08:00 •Characteristics of Vehicle: 00:10:00 •Vehicle Limit: 00:11:00 •Loads and Load Restraint: 00:12:00 •Drivers' Hours and Records: 00:12:00 •Vehicles and Driving: 00:12:00 •Health and Conduct: 00:11:00 •LGV Safety Inspection: 00:12:00 •Qualified LGV Driver: 00:09:00 •Provisional LGV Licence: 00:07:00 •CPC Test Part 01 and 02: 00:10:00 •CPC Test Part 03 and 04: 00:11:00 •After Getting Qualification: 00:09:00 •Assignment - Large Goods Vehicle (LGV): 00:00:00