• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

8288 Courses in Liverpool delivered On Demand

ARM Assembly Language From Ground Up™ 1

By Packt

Covering ARM systems design and architecture and practical assembly programming, this is a comprehensive ARM assembly video course to get you up and running. You'll develop the skills necessary for starting your career as an ARM embedded developer, such as developing algorithms and creating state machines in assembly.

ARM Assembly Language From Ground Up™ 1
Delivered Online On Demand14 hours 37 minutes
£56.99

React Bootcamp with .NET API (Router, Redux Toolkit, Hooks)

By Packt

This comprehensive course is designed to take you on a journey of mastering React, the popular JavaScript library for building dynamic user interfaces, and combining it with the power of .NET API for seamless back-end integration. This course will provide you with a solid foundation and hands-on experience in building full-stack applications.

React Bootcamp with .NET API (Router, Redux Toolkit, Hooks)
Delivered Online On Demand22 hours 20 minutes
£82.99

Tax at QLS Level 5 Diploma - 12 Courses Bundle

By NextGen Learning

Are you looking to elevate your professional skills to new heights? Introducing our Tax at QLS Level 5 Diploma, a QLS-endorsed course bundle that sets a new standard in online education. This prestigious endorsement by the Quality Licence Scheme (QLS) is a testament to the exceptional quality and rigour of our course content. The bundle comprises 11 CPD-accredited courses, each meticulously designed to meet the highest standards of learning. This endorsement not only highlights the excellence of our courses but also assures that your learning journey is recognised and valued in the professional world. The purpose of Tax at QLS Level 5 Diploma is to provide learners with a comprehensive, skill-enriching experience that caters to a variety of professional needs. Each course within the bundle is crafted to not only impart essential knowledge but also to enhance practical skills, ensuring that learners are well-equipped to excel in their respective fields. From gaining cutting-edge industry insights to mastering critical thinking and problem-solving techniques, this bundle is an amalgamation of learning experiences that are both enriching and empowering. Moreover, Tax at QLS Level 5 Diploma goes beyond just online learning. Upon completion of the bundle, learners will receive a free QLS Endorsed Hardcopy Certificate & 11 CPD Accredited PDF Certificate, a tangible acknowledgement of their dedication and hard work. This certificate serves as a powerful tool in showcasing your newly acquired skills and knowledge to potential employers. So, why wait? Embark on this transformative learning journey today and unlock your potential with Tax at QLS Level 5 Diploma! This premium bundle comprises the following courses, QLS Endorsed Course: Course 01: Tax at QLS Level 5 Diploma CPD QS Accredited Courses: Course 02: Self Assessment Tax Return Filing UK Course 03: UK Tax Reforms and HMRC Legislation Course 04: Introduction to VAT Course 05: Investment Banking Course 06: Financial Advisor Course 07: Charity Accounting Course 08: Applied Accounting Course 09: Theory of Constraints, Throughput Accounting and Lean Accounting Course 10: GDPR Course 11: Anti-Money Laundering (AML) Training Course 12: Xero Accounting and Bookkeeping Learning Outcomes Upon completion of the bundle, you will be able to: Acquire industry-relevant skills and up-to-date knowledge. Enhance critical thinking and problem-solving abilities. Gain a competitive edge in the job market with QLS-endorsed certification. Develop a comprehensive understanding of Tax. Master practical application of theoretical concepts. Improve career prospects with CPD-accredited courses. The Tax at QLS Level 5 Diploma offers an unparalleled learning experience endorsed by the Quality Licence Scheme (QLS). This endorsement underlines the quality and depth of the courses, ensuring that your learning is recognised globally. The bundle includes 11 CPD-accredited courses, each meticulously designed to cater to your professional development needs. Whether you're looking to gain new skills, enhance existing ones, or pursue a complete career change, this bundle provides the tools and knowledge necessary to achieve your goals. The Quality Licence Scheme (QLS) endorsement further elevates your professional credibility, signalling to potential employers your commitment to excellence and continuous learning. The benefits of this course are manifold - from enhancing your resume with a QLS-endorsed certification to developing skills directly applicable to your job, positioning you for promotions, higher salary brackets, and a broader range of career opportunities. Embark on a journey of professional transformation with Tax at QLS Level 5 Diploma today and seize the opportunity to stand out in your career. Enrol in Tax now and take the first step towards unlocking a world of potential and possibilities. Don't miss out on this chance to redefine your professional trajectory! Certificate of Achievement: QLS-endorsed courses are designed to provide learners with the skills and knowledge they need to succeed in their chosen field. The Quality Licence Scheme is a distinguished and respected accreditation in the UK, denoting exceptional quality and excellence. It carries significant weight among industry professionals and recruiters. Upon completion, learners will receive a Free Premium QLS Endorsed Hard Copy Certificate titled 'Tax at QLS Level 5 Diploma' & 11 Free CPD Accredited PDF Certificates. These certificates serve to validate the completion of the course, the level achieved, and the QLS endorsement. Please Note: NextGen Learning is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Tax at QLS Level 5 Diploma bundle is ideal for: Professionals seeking to enhance their skills and knowledge. Individuals aiming for career advancement or transition. Those seeking CPD-accredited certification for professional growth. Learners desiring a QLS-endorsed comprehensive learning experience. Requirements You are cordially invited to enroll in this bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Upon completing the Tax at QLS Level 5 Diploma course bundle, each offering promising prospects and competitive salary ranges. Whether you aspire to climb the corporate ladder in a managerial role, delve into the dynamic world of marketing, explore the intricacies of finance, or excel in the ever-evolving field of technolog Certificates CPD Quality Standard Certificate Digital certificate - Included Free 11 CPD Accredited PDF Certificates. QLS Endorsed Certificate Hard copy certificate - Included

Tax at QLS Level 5 Diploma - 12 Courses Bundle
Delivered Online On Demand5 days
£79

AAT Level 4 Diploma in Professional Accounting

3.8(10)

By Eagle Education And Training Ltd

Do you want a fulfilling career in accountancy? Have you passed AAT Level 3 or an equivalent accounting qualification? We can help you reach your goal by studying AAT Level 4. This level builds on the knowledge you gained in the Level 3 Diploma. You will cover higher accounting tasks including drafting financial statements, managing budgets, and evaluating financial performance. There are also optional specialist units including business tax, personal tax, auditing, credit management, and cash and financial management. After qualifying you can work in accounting roles or progress onto studying chartered accountancy. About AAT Level 4 Diploma in Professional Accounting Entry Requirements To progress comfortably on this course, you’ll need to have good accounting knowledge and be able to perform all the financial and management accounting tasks which are tested on the AAT Level 3 course. Plus you’ll need a good standard of English literacy and basic Maths skills. We recommend you register with AAT before starting this course. This will give you your AAT student number, which enables you to enter for assessments. AAT Level 4 Diploma in Professional Accounting syllabus By the end of this course, you’ll be able to apply complex accounting principles, concepts, and rules to prepare the financial statements of a limited company. You’ll also learn management accounting techniques to aid decision making and control, prepare and monitor budgets, and measure performance. This level consists of compulsory and optional units: Compulsory unitsDrafting and Interpreting of Financial Statements (DAIF) The reporting frameworks that underpin financial reporting How to draft statutory financial statements for limited companies How to draft consolidated financial statements How to interpret financial statements using ratio analysis Applied Management Accounting (AMAC) The organisational planning process How to use internal processes to enhance operational control How to use techniques to aid short-term and long-term decision making How to analyse and report on business performance Internal Accounting Systems and Controls (INAC) The role and responsibilities of the accounting function within an organisation How to evaluate internal control systems How to evaluate an organisation’s accounting system and underpinning procedures The impact of technology on accounting systems How to recommend improvements to an organisation’s accounting system Optional units (choose two)Business Tax (BNTA) How to prepare tax computations for sole traders and partnerships How to prepare tax computations for limited companies How to prepare tax computations for the sale of capital assets by limited companies The administrative requirements of the UK’s tax regime The tax implications of business disposals Tax reliefs, tax planning opportunities and agent’s responsibilities in reporting taxation to HM Revenue and Customs Personal Tax (PNTA) The principles and rules that underpin taxation systems How to calculate UK taxpayers’ total income How to calculate income tax and National Insurance Contributions (NICs) payable by UK taxpayers How to calculate capital gains tax payable by UK taxpayers The principles of inheritance tax Audit and Assurance (AUDT) The audit and assurance framework The importance of professional ethics How to evaluate the planning process for audit and assurance How to evaluate procedures for obtaining sufficient and appropriate evidence How to review and report findings Cash and Financial Management (CSFT) How to prepare forecasts for cash receipts and payments How to prepare cash budgets and monitor cash flows The importance of managing finance and liquidity Ways of raising finance and investing funds Regulations and organisational policies that influence decisions in managing cash and finance Credit and Debt Management (CRDM) The relevant legislation and contract law that impacts the credit control environment How information is used to assess credit risk and grant credit in compliance with organisational policies and procedures The organisation’s credit control processes for managing and collecting debts Different techniques available to collect debts How is this course assessed? The Level 4 course is assessed by unit assessments. Unit assessment The Level 4 course is assessed by unit assessments. A unit assessment only tests knowledge and skills taught in that unit. At Level 4 they are: Available on demand Scheduled by and sat at AAT approved assessment venues Marked by the AAT and the results are released after six weeks Getting your results Assessment results will be available in your MyAAT account when they are released. Grading To be awarded the AAT Level 4 Diploma in Accounting qualification you must achieve at least a 70% competency level in each unit assessment. Resits You can resit an assessment to improve your grade. Results from the assessment with the highest marks will be used to calculate your final grade. There are no resit restrictions or employer engagement requirements for any fee paying student on any of our AAT courses. What’s included, and what support will I get? Partnering with the best, you’ll always have access to market leading tutor led online learning modules and content developed by Kaplan and Osborne books. All day, every day for as long as you subscribe. Unlimited access to the AAT Level 4 content with the use of all other levels, allowing you to recap previous levels at no extra cost Instant access to our unique comprehensive Study Buddy learning guide Access to Consolidation and Progress Tests and computer and self marked Mock Exams. You’re fully supported with access to expert tutors, seven days a week, responding via email within four working hours You’ll be assigned a mentor to help and guide you through the order of subjects to study in, and check that the level you’re starting at is right for you. Your subscription includes all the online content you need to succeed, but if you want to supplement your learning with books, Eagle students get 50% off hard copy study materials. What could I do next? After you’ve passed this level, you can work in a variety of jobs including forensic accountant, tax manager, accountancy consultant, or finance analyst, earning salaries of up to £37,000 as you advance and gain experience. AAT full members (MAAT) and fellow members (FMAAT) are eligible for exemptions that allow you to take the fast track route to chartered accountant status. You can stay with the same training provider. Eagle offers affordable courses approved by the ACCA (Association of Chartered Certified Accountants) to which you can subscribe. Additional costs You are required to become a member of the Association of Accounting Technicians (AAT) launch to fulfil your qualification. Fees associated with admission, and exam fees, are in addition to the cost of the course. Admission and membership fees are payable direct to AAT. Exam fees are paid to the exam centre. AAT One off Level 4 Registration Fee: £240 AAT Assessment Fees: £70 to £80 per unit but this can vary depending on where you sit your assessment. Please be aware that these are subject to change.

AAT Level 4 Diploma in Professional Accounting
Delivered Online On Demand
£45 to £430

Pattern Drafting: Making and fitting toiles - SKIRT BLOCK

5.0(3)

By Textiles Skills Centre

Sampling and fitting a skirt.

Pattern Drafting: Making and fitting toiles  - SKIRT BLOCK
Delivered Online On Demand
£35

Hyaluronic Acid Essential Settings & Injection Techniques

By Medical Aesthetics Academy

Hyaluronic Acid Essential Settings & Injection Techniques - CPD Accredited Course Everything you need to know on consumables, products and injection techniques for peri-oral, naso-labial and glabellaWhat will you learn Learn the essential clinical settings for the practice of Hyaluronic Acid (HA) fillers in aesthetic medicine treatments Become familiar with treatment room requirements, products, medications and consumables needed for the safe administration of the treatment Guidance on local anaesthesia options HA syringe and needle assembly and handling Differences between the use of needles and cannulas Learn injection techniques for glabella, peri-oral and naso-labial areas RequirementsYou must be health professional (doctor, dentist, nurse, etc.) that is legally entitled to offer aesthetic injectable treatments in your country/state No experience in aesthetic medicine needed Course Description This CPD accredited course covers the essential clinical settings for the practice of Hyaluronic Acid (HA) dermal filler aesthetic treatments, together with treatment demonstrations for the most popular areas, peri-oral, naso-labials and glabella . You will become familiar with the treatment room requirements, products, medications and consumables needed for the safe administration of the treatment. Guidance on local anaesthesia options, differences between the use of needles and cannulas, HA syringe and needle assembly and handling is included, to help inexperienced practitioners choose the safest and most cost-effective products and techniques. This course is a perfect introduction to the use of Hyaluronic Acid (HA) in medical aesthetics. It is ideal for beginners, but it is also useful for professionals who have attended courses elsewhere and wish to re-establish a solid knowledge foundation. Great emphasis is placed on the safest and more effective techniques, which are used as a point of reference internationally. Our specialised training is aimed at doctors, dentists and other health professionals interested in starting their career in aesthetic medicine, improve their existing skills with the most established techniques, or simply expand their knowledge. We have used our experience of more than 20 years in the non-surgical aesthetic medicine industry as a base to develop specific training courses. 

Hyaluronic Acid Essential Settings & Injection Techniques
Delivered Online On Demand
£79.99

Large Scale Flower Drawing

5.0(8)

By Discovery Art Class

Large scale tulip flower charcoal drawing course

Large Scale Flower Drawing
Delivered Online On Demand1 hour
£25

Salesforce Experience (Community) Cloud Consultant Training

By Packt

Immerse into the intricacies of Salesforce Experience Cloud with our training course and explore building sites, Salesforce CMS, content moderation, gamification, and partner portal setups. Learn about sharing rules, dashboards, and Salesforce CMS integration with a focus on user management, social login, and Lightning Bolts.

Salesforce Experience (Community) Cloud Consultant Training
Delivered Online On Demand10 hours 26 minutes
£52.99

Python Programming Bible | Networking, GUI, Email, XML, CGI

4.5(3)

By Studyhub UK

Introducing the 'Python Programming Bible | Networking, GUI, Email, XML, CGI' - your comprehensive, all-in-one resource for mastering Python! Are you an aspiring developer looking to dive into the ocean of Python programming or a seasoned coder seeking to level up your Python game? Look no further! Our course is expertly designed to take you from the basics to the complexities of Python, including Networking, GUI, Email, XML, and CGI. If you've ever dreamt of not just learning Python but truly mastering it, this is the course for you. This program is designed to provide a solid foundation and sharpen your skills in one of the most in-demand programming languages, while also introducing you to its many applications. This course starts with the basics of Python, providing a gentle yet thorough introduction and setup that caters to beginners as well as those looking to refresh their Python knowledge. As we study deeper into the heart of Python, we dive into objects, classes, and the power of regular expressions. But it doesn't stop there! You'll also become comfortable with concepts like CGI programming, which is an important building block for creating dynamic web pages. Navigating from core programming, we transition into the intricacies of managing databases and executing multithreading in Python. You'll gain the confidence to handle complex data management tasks, understand how Python interacts with databases, and efficiently manages multiple tasks simultaneously. The XML section allows you to get hands-on with parsing, data extraction, and manipulation, while the GUI section unveils the art of creating beautiful, user-friendly interfaces using Python. The course is enriched with a diverse set of resources, including real-world projects, quizzes, and interactive coding exercises. This is more than just a course, it's your passport to a new realm of opportunities, unlocking a world where Python programming is your strength, not just a skill.  So whether you're a student aiming to get a head start on your peers, a professional looking to diversify your skills, or an enthusiast wanting to dive deeper into the Python universe, the Python Programming Bible is the starting point for your journey to becoming a Python expert. Enrol today and step into a future of endless opportunities with Python! Learning Outcomes: Upon completion of the Python Programming Bible course, you should be able to: Understand and implement Python basics and advanced concepts. Build object-oriented programs with Python. Utilise regular expressions for pattern-matching tasks. Develop dynamic web pages using CGI programming. Interact with databases efficiently using Python. Apply multithreading for better utilisation of resources. Process and manipulate data using XML in Python. Design and create user-friendly GUIs with Python. Who is this course for? This Python Programming Bible course is ideal for the following: Beginners aiming to learn Python from scratch. Professionals looking to broaden their programming skills. Students pursuing a degree in Computer Science. Web developers looking to integrate Python into their toolkit. Data enthusiasts aiming to handle data with Python. Career Path: This Python Programming Bible course will help you to develop your knowledge and skills to pursue different careers, such as: Python Developer: (£35,000 - £70,000). Data Analyst: (£27,000 - £55,000). Web Developer: (£24,000 - £60,000). Data Scientist: (£45,000 - £90,000). Machine Learning Engineer: (£50,000 - £90,000). Software Developer: (£30,000 - £70,000). Certification After studying the course materials of the Python Programming Bible | Networking, GUI, Email, XML, CGI there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Prerequisites This Python Programming Bible | Networking, GUI, Email, XML, CGI does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming Bible | Networking, GUI, Email, XML, CGI 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. Course Curriculum Section 01: Introduction & Setup Introduction 00:02:00 Setup on Mac OS X 00:03:00 Setup On Linux/Ubuntu 00:03:00 Setup On Windows 00:03:00 Run Code Online 00:03:00 Section 02: Basics Comments 00:02:00 Variables & Variable Types 00:05:00 Lists 00:04:00 Tuples 00:03:00 Dictionary 00:06:00 Data Type Conversion 00:02:00 Arithmetic Operators 00:05:00 Comparison Operators 00:03:00 Assignment Operators 00:03:00 Bitwise Operators 00:10:00 Logical Operators 00:07:00 Membership Operators 00:02:00 Identity Operators 00:02:00 Operator Precedence 00:03:00 Decision Making 00:09:00 Loops 00:06:00 Loop Control Statements 00:05:00 Numbers 00:05:00 Strings 00:12:00 Lists In Depth 00:05:00 Tuples In Depth 00:06:00 Dictionary In Depth 00:08:00 Date & Time 00:07:00 Functions 00:11:00 Modules 00:05:00 File Inputs & Outputs 00:13:00 Handling Exceptions 00:07:00 Section 03: Classes/Objects Simple Example 00:04:00 Creating Instance Objects 00:01:00 Accessing Attributes 00:04:00 Constructor New & Init Method 00:06:00 Destroying Objects 00:02:00 Class Inheritance 00:04:00 Overriding Methods 00:03:00 Overloading Methods 00:01:00 Overloading Operators 00:04:00 Data Hiding 00:03:00 Section 04: Regular Expressions Match Function 00:05:00 Search Function 00:02:00 Advanced Expressions 00:05:00 Search & Replace 00:03:00 Section 05: CGI Programming Basic CGI Programming 00:08:00 Get Method 00:06:00 Post Method 00:05:00 Cookies 00:05:00 Section 06: Database Setup Database 00:02:00 Connect To Database 00:05:00 Create Table 00:03:00 INSERT Operation 00:04:00 READ Operation 00:06:00 UPDATE Operation 00:02:00 DELETE Operation 00:02:00 Simple Network Example 00:04:00 Simple Client 00:04:00 Section 07: Multithreading Initiate a New Thread 00:07:00 Create Thread 00:06:00 Synchronise Threads 00:03:00 Multithreaded Priority Queue 00:09:00 Section 08: XML Parse an XML File 00:10:00 Section 09: GUI Introduction 00:02:00 Button Preview 00:03:00 Canvas 00:04:00 Checkbutton 00:02:00 Entry 00:02:00 Frame 00:04:00 Label 00:02:00 List Box 00:02:00 Menu button 00:03:00 Menu 00:08:00 Message 00:02:00 Radio button 00:05:00 Scale 00:03:00 Scrollbar 00:04:00 Text 00:03:00 Top-level 00:02:00 Spinbox 00:02:00 Paned Window 00:03:00 Message Box 00:02:00 Label Frame 00:02:00 Section 10: Resource Resource 00:00:00 Assignment Assignment - Python Programming Bible | Networking, GUI, Email, XML, CGI 00:00:00

Python Programming Bible | Networking, GUI, Email, XML, CGI
Delivered Online On Demand6 hours 8 minutes
£10.99

SQL for Data Science, Data Analytics and Data Visualization

4.5(3)

By Studyhub UK

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

SQL for Data Science, Data Analytics and Data Visualization
Delivered Online On Demand7 hours 15 minutes
£10.99