18266 Teaching courses in Barton-upon-Humber delivered Online

Level 2 Certificate - in Understanding Common Childhood Illnesses Affecting Children Online Does your work involve infants and young children? Or are you aspiring to work in an early year setting? If so, this Level 2 Certificate in Understanding Common Childhood Illnesses Affecting Children course should hold your attention. The purpose of this Level 2 Certificate - in Understanding Common Childhood Illnesses Affecting Children qualification is to provide you with a thorough understanding of common childhood illnesses, as well as how to provide a safe and healthy environment for infants and young children, recognize when a baby or child is ill, and manage acute and chronic health conditions in early years setting. Level 2 Certificate - in Understanding Common Childhood Illnesses Affecting Children Bundle Courses Course 01: Level 2 Certificate in Understanding Common Childhood Illnesses Affecting Children Course 02: Level 2 Diploma for the Early Years Practitioner Course 03: Level 4 Diploma in Child Counselling Course [ Note: Free PDF certificate as soon as completing the Level 2 Certificate in Understanding Common Childhood Illnesses Affecting Children Course] Level 2 Certificate - in Understanding Common Childhood Illnesses Affecting Children Industry Experts Designed this Level 2 Certificate - in Understanding Common Childhood Illnesses Affecting Children course into 03 detailed modules. Assessment Method of Childhood Illnesses Affecting Children After completing each module of the Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Childhood Illnesses Affecting Children After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Level 2 Certificate - in Understanding Common Childhood Illnesses Affecting Children This Level 2 Certificate in Understanding Common Childhood Illnesses Affecting Children course is designed for those who wish to increase their knowledge and understanding of common childhood illnesses. Anyone who aims to progress to further qualifications and employment within the health and social care sector, particularly within an early years setting, will benefit from this course. Requirements Level 2 Certificate - in Understanding Common Childhood Illnesses Affecting Children Students who intend to enrol in this Level 2 Certificate - in Understanding Common Childhood Illnesses Affecting Children course must meet the following requirements: Good command of the English language Must be vivacious and self-driven. Basic computer knowledge A minimum of 16 years of age is required. Career path Level 2 Certificate - in Understanding Common Childhood Illnesses Affecting Children This Level 2 Certificate in Understanding Common Childhood Illnesses Affecting Children course will improve your CV and employability. After completing this course, you will have a competitive advantage when entering the relevant job field. Certificates Certificate of completion Digital certificate - Included

Purchase Ledger course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in Purchase Ledger. Our course starts with the basics of Purchase Ledger and gradually progresses towards advanced topics. Therefore, each lesson of this Purchase Ledger is intuitive and easy to understand. So, stand out in the job market by completing the Purchase Ledger course. Get an accredited certificate and add it to your resume to impress your employers. Along with the Purchase Ledger course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Module 01: Introduction to Purchase Ledger Module 02: Importance of Purchase Ledger Module 03: Skills for Purchase Ledger Management Module 04: Purchase Ledger Control Account Module 05: Managing Purchase Ledger Successfully Module 06: Reconciliation Module 07: The Key to a Paperless Purchase Ledger World CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Purchase Ledger course. Requirements To enrol in this Purchase Ledger course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Purchase Ledger. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Start on a linguistic journey through the intricate world of medical terminology. Unravel the language of healthcare in our comprehensive course.

About Course Master the art of Retail business with this comprehensive online course on Retail Management and Merchandising Retail Management Online course will teach you the basics to start a potential career or business in the promising field of the Retail Industry. Retail is an ever-growing industry. Retail management saves time and ensures that customers easily locate their desired merchandise and return home satisfied. Effective management avoids unnecessary chaos at the store and rather increases the sales of the store. Over the last couple of decades, total retail sales numbers in the United States have grown considerably, from just under 3 trillion U.S. dollars in 2000 to almost 6.6 trillion U.S. dollars in 2021. So it is definitely promising to start a business or career in the Retail industry. This Retail management online course will help individuals who are looking to start their career in the Retail management profession, or thinking about starting a business in this industry, This beginner's level course will be your stepping stone into the industry, and with a high level of professionalism, experience, and skills that it will enable, you have the potential to be en route to becoming a successful professional in the Retail industry. The retail Management online course is strategically divided into 9 modules to cover the key professional elements related to the Retail industry. It is designed in a way that not it will help the job seekers in this field but also the individuals with some experience who want to start a business. The course will help you learn from scratch and reach a higher level of professionalism. As you may know, organisational skills are important because good organisational skills establish trust and professionalism in the workplace. So, if you are looking to join the various Retail Management and organisational skills, then this Retail Management is your most desired course. What Will You Learn? Develop skills required for successful Retail Management and Merchandising Enhance communication skills for relationship selling and networking in retail management. Learn effective strategies for dealing with difficult customers and suppliers. Gain knowledge about stock management, including warehouse activities, aims of warehousing, material handling, and packaging. Course Content Introduction to Retail Management Productivity Techniques for Maximum Selling Communication Skills for Relationship Selling The Selling Process, Theories and Sales Promotions The Importance of Consumer Behavior Dealing with difficult customers Dealing with Suppliers Dealing with the management of stock Retail Merchandising Concluding Remarks A course by Xpert Learning RequirementsLearners with no prior Retail Management knowledge can enroll in this Retail Management course. Audience Retail store owners or managers who want to improve their knowledge of retail management and merchandising strategies to increase their business profitability. Entry-level retail employees who want to develop their skills and knowledge of the retail business and eventually advance to managerial positions. Professionals from other fields who are considering a career change to retail management or who want to acquire knowledge about the retail industry. Audience Retail store owners or managers who want to improve their knowledge of retail management and merchandising strategies to increase their business profitability. Entry-level retail employees who want to develop their skills and knowledge of the retail business and eventually advance to managerial positions. Professionals from other fields who are considering a career change to retail management or who want to acquire knowledge about the retail industry.

About Course Why should you enrol in the course? Xero is a cloud-based accounting software that is used by businesses of all sizes around the world. It is a powerful and easy-to-use tool that can help you to manage your finances more effectively. This online course will teach you everything you need to know about how to use Xero. You will learn how to set up your account, enter transactions, generate reports, and more. Whether you are a business owner, bookkeeper, or accountant, this course is for you. Learning outcomes of the course By the end of this course, you will be able to: Set up and manage a Xero account Enter transactions, including sales, purchases, and expenses Generate financial reports, such as profit and loss statements, balance sheets, and cash flow statements Reconcile bank accounts Process payroll File VAT returns Use advanced features of Xero, such as multi-currency and project tracking Target audience This course is ideal for: Business owners Bookkeepers Accountants Anyone who wants to learn how to use Xero Requirements for the course No prior experience with Xero is required Access to a computer with an internet connection Curriculum The course is divided into three levels: Beginner Intermediate Advanced The beginner level covers the basics of using Xero, such as setting up an account, entering transactions, and generating reports. The intermediate level covers more advanced topics, such as bank reconciliation, payroll, and VAT returns. The advanced level covers even more advanced topics, such as multi-currency and project tracking. Conclusion This online course is a comprehensive and easy-to-follow guide to using Xero. Whether you are a beginner or an experienced user, you will learn something new from this course. If you are interested in learning how to use Xero, I encourage you to enrol in this course today. What Will You Learn? Set up and manage a Xero account Enter transactions, including sales, purchases, and expenses Generate financial reports, such as profit and loss statements, balance sheets, and cash flow statements Reconcile bank accounts Process payroll File VAT returns Use advanced features of Xero, such as multi-currency and project tracking Course Content Getting Started Setting Up Xero How to activate Bank Feed on Xero Setting Up of The System Virtual Tour of Xero Adding a Business Bank Accounts and Cash Accounts on Xero Chart of Accounts and conversion balances Creating/Deleting (Tracking Categories) Customers and Suppliers Setting Up Customer and Supplier Create a Project Entering Purchase (Supplier Invoices), Purchase Credit Notes, Purchase Orders Entering Sales (Customer Invoice), Sales Credit Notes, Quotes Fixed Assets Entering Fixed Assets Inventory Bank Payments and Receipts Bank Feed or Import a Statement Entering Bank Payment and Bank Receipts Internal Bank Transfer Repeating Bill Cash Coding Petty Cash Petty Cash Bank Reconciliation Bank Reconciliation Business Credit Card Business Credit Card Aged Reports Aged Reports Payroll Payroll Vat Return Vat Return CIS Return CIS Return Accrual and Prepayment Accrual and Prepayment Accrued Income and Deferred Income Accrued Income and Deferred Income Depreciation Journal Depreciation Journal Management Reports Management Reports Preparation of Budget Preparation of Budget Cash Flow Cash Flow Payment Services on Xero Payment Services on Xero Bank Rules Bank Rules Multicurrency on Xero Multicurrency on Xero App Marketplace App Marketplace Introduction of Resources During Covid-19 Introduction of Resources during Covid-19 Correction of Errors Correction of Errors A course by Ujjwala D'Souza MAAT, Sage/Xero/Quickbooks Trainer/Advisor Material Includes Course Videos Coursebook RequirementsNo prior experience with Xero is requiredAccess to a computer with an internet connection Audience Business owners Bookkeepers Accountants Anyone who wants to learn how to use Xero Requirements No prior experience with Xero is required Access to a computer with an internet connection

Overview This comprehensive course on Compliance Administrator will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Compliance Administrator 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 Compliance Administrator. It is available to all students, of all academic backgrounds. Requirements Our Compliance Administrator 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 8 sections • 8 lectures • 03:20:00 total length •Introduction To Compliance: 00:17:00 •Five Basic Elements Of Compliance: 00:25:00 •Compliance Management System (CMS): 00:26:00 •Compliance Audit: 00:38:00 •Compliance And Ethics: 00:26:00 •Risk And Types Of Risk: 00:25:00 •Introduction To Risk Management: 00:25:00 •Risk Management Process: 00:18:00

Overview This comprehensive course on Introduction to Cryptocurrency will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Introduction to Cryptocurrency comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enroll 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 Introduction to Cryptocurrency. It is available to all students, of all academic backgrounds. Requirements Our Introduction to Cryptocurrency 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. 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 10 sections • 10 lectures • 06:15:00 total length •The Fundamentals of Cryptocurrencies: 00:30:00 •The Blockchain: 00:35:00 •Types of Cryptocurrencies: 00:45:00 •NFTs: 00:50:00 •Cryptocurrency Wallets: 00:40:00 •Cryptocurrency Security: 00:20:00 •Decentralized Finance: 00:30:00 •Investing in Cryptos: 01:00:00 •Opportunities and Future of Cryptocurrencies: 00:35:00 •Cryptocurrency Laws in the UK: 00:30:00

Overview This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this SQL NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds. Requirements Our SQL NoSQL Big Data and Hadoop 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 • 130 lectures • 22:34:00 total length •Introduction: 00:07:00 •Building a Data-driven Organization - Introduction: 00:04:00 •Data Engineering: 00:06:00 •Learning Environment & Course Material: 00:04:00 •Movielens Dataset: 00:03:00 •Introduction to Relational Databases: 00:09:00 •SQL: 00:05:00 •Movielens Relational Model: 00:15:00 •Movielens Relational Model: Normalization vs Denormalization: 00:16:00 •MySQL: 00:05:00 •Movielens in MySQL: Database import: 00:06:00 •OLTP in RDBMS: CRUD Applications: 00:17:00 •Indexes: 00:16:00 •Data Warehousing: 00:15:00 •Analytical Processing: 00:17:00 •Transaction Logs: 00:06:00 •Relational Databases - Wrap Up: 00:03:00 •Distributed Databases: 00:07:00 •CAP Theorem: 00:10:00 •BASE: 00:07:00 •Other Classifications: 00:07:00 •Introduction to KV Stores: 00:02:00 •Redis: 00:04:00 •Install Redis: 00:07:00 •Time Complexity of Algorithm: 00:05:00 •Data Structures in Redis : Key & String: 00:20:00 •Data Structures in Redis II : Hash & List: 00:18:00 •Data structures in Redis III : Set & Sorted Set: 00:21:00 •Data structures in Redis IV : Geo & HyperLogLog: 00:11:00 •Data structures in Redis V : Pubsub & Transaction: 00:08:00 •Modelling Movielens in Redis: 00:11:00 •Redis Example in Application: 00:29:00 •KV Stores: Wrap Up: 00:02:00 •Introduction to Document-Oriented Databases: 00:05:00 •MongoDB: 00:04:00 •MongoDB Installation: 00:02:00 •Movielens in MongoDB: 00:13:00 •Movielens in MongoDB: Normalization vs Denormalization: 00:11:00 •Movielens in MongoDB: Implementation: 00:10:00 •CRUD Operations in MongoDB: 00:13:00 •Indexes: 00:16:00 •MongoDB Aggregation Query - MapReduce function: 00:09:00 •MongoDB Aggregation Query - Aggregation Framework: 00:16:00 •Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00 •Document Stores: Wrap Up: 00:03:00 •Introduction to Search Engine Stores: 00:05:00 •Elasticsearch: 00:09:00 •Basic Terms Concepts and Description: 00:13:00 •Movielens in Elastisearch: 00:12:00 •CRUD in Elasticsearch: 00:15:00 •Search Queries in Elasticsearch: 00:23:00 •Aggregation Queries in Elasticsearch: 00:23:00 •The Elastic Stack (ELK): 00:12:00 •Use case: UFO Sighting in ElasticSearch: 00:29:00 •Search Engines: Wrap Up: 00:04:00 •Introduction to Columnar databases: 00:06:00 •HBase: 00:07:00 •HBase Architecture: 00:09:00 •HBase Installation: 00:09:00 •Apache Zookeeper: 00:06:00 •Movielens Data in HBase: 00:17:00 •Performing CRUD in HBase: 00:24:00 •SQL on HBase - Apache Phoenix: 00:14:00 •SQL on HBase - Apache Phoenix - Movielens: 00:10:00 •Demo : GeoLife GPS Trajectories: 00:02:00 •Wide Column Store: Wrap Up: 00:05:00 •Introduction to Time Series: 00:09:00 •InfluxDB: 00:03:00 •InfluxDB Installation: 00:07:00 •InfluxDB Data Model: 00:07:00 •Data manipulation in InfluxDB: 00:17:00 •TICK Stack I: 00:12:00 •TICK Stack II: 00:23:00 •Time Series Databases: Wrap Up: 00:04:00 •Introduction to Graph Databases: 00:05:00 •Modelling in Graph: 00:14:00 •Modelling Movielens as a Graph: 00:10:00 •Neo4J: 00:04:00 •Neo4J installation: 00:08:00 •Cypher: 00:12:00 •Cypher II: 00:19:00 •Movielens in Neo4J: Data Import: 00:17:00 •Movielens in Neo4J: Spring Application: 00:12:00 •Data Analysis in Graph Databases: 00:05:00 •Examples of Graph Algorithms in Neo4J: 00:18:00 •Graph Databases: Wrap Up: 00:07:00 •Introduction to Big Data With Apache Hadoop: 00:06:00 •Big Data Storage in Hadoop (HDFS): 00:16:00 •Big Data Processing : YARN: 00:11:00 •Installation: 00:13:00 •Data Processing in Hadoop (MapReduce): 00:14:00 •Examples in MapReduce: 00:25:00 •Data Processing in Hadoop (Pig): 00:12:00 •Examples in Pig: 00:21:00 •Data Processing in Hadoop (Spark): 00:23:00 •Examples in Spark: 00:23:00 •Data Analytics with Apache Spark: 00:09:00 •Data Compression: 00:06:00 •Data serialization and storage formats: 00:20:00 •Hadoop: Wrap Up: 00:07:00 •Introduction Big Data SQL Engines: 00:03:00 •Apache Hive: 00:10:00 •Apache Hive : Demonstration: 00:20:00 •MPP SQL-on-Hadoop: Introduction: 00:03:00 •Impala: 00:06:00 •Impala : Demonstration: 00:18:00 •PrestoDB: 00:13:00 •PrestoDB : Demonstration: 00:14:00 •SQL-on-Hadoop: Wrap Up: 00:02:00 •Data Architectures: 00:05:00 •Introduction to Distributed Commit Logs: 00:07:00 •Apache Kafka: 00:03:00 •Confluent Platform Installation: 00:10:00 •Data Modeling in Kafka I: 00:13:00 •Data Modeling in Kafka II: 00:15:00 •Data Generation for Testing: 00:09:00 •Use case: Toll fee Collection: 00:04:00 •Stream processing: 00:11:00 •Stream Processing II with Stream + Connect APIs: 00:19:00 •Example: Kafka Streams: 00:15:00 •KSQL : Streaming Processing in SQL: 00:04:00 •KSQL: Example: 00:14:00 •Demonstration: NYC Taxi and Fares: 00:01:00 •Streaming: Wrap Up: 00:02:00 •Database Polyglot: 00:04:00 •Extending your knowledge: 00:08:00 •Data Visualization: 00:11:00 •Building a Data-driven Organization - Conclusion: 00:07:00 •Conclusion: 00:03:00 •Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

CPD Accredited | Free PDF Certificate | 20 CPD Points | Lifetime Access | Tutor Support