422 Courses delivered Online

Do you want to learn basic Linux system administration using real-world applied learning? Do you want to learn how to install and configure a Linux server? Do you prefer learning using hands-on as opposed to just a lecture and quiz? If you have answered yes to these questions, then you have chosen the right course.

Say goodbye to mealtime hassles and turn your dog into a well-behaved pet. Understand the dog and connect with them with lovely greetings. Ensure stress-free dog & puppy training.

Stay safe on the job with our Manual Handling Training course. Gain knowledge and skills to recognize hazards and risks associated with repetitive motions. Enhance your abilities to protect yourself, coworkers, and products with proper techniques and equipment usage. This Manual Handling Training course will equip you with the knowledge and skills to recognise the hazards and risks associated with repetitive motions and tasks that involve lifting, lowering, pushing, or pulling weights. By enrolling in this course, you can implement the necessary measures to protect yourself, your colleagues and your products from any sort of damage. The Manual Handling Training online course is designed to provide individuals with the knowledge and skills to safely and effectively handle materials, equipment and other objects. The course covers a wide range of topics, including ergonomics, risk assessment, and safe lifting techniques. The course also covers the various safe lifting techniques, including the use of proper body mechanics, the use of lifting aids, and how to properly plan and organise manual handling tasks. Additionally, students will learn about the various types of lifting equipment, such as hand trucks, dollies, and forklifts, and how to use them safely. Upon completion of the course, students will have a comprehensive understanding of safe manual handling techniques and will be well-prepared to work safely in any manual handling environment. Learning Outcomes After completing this course, learners will be able to Understand of the risks and hazards associated with manual handling tasks. Gain knowledge of safe lifting techniques and principles of ergonomics Acquire the ability to recognise and assess manual handling risks and implement appropriate measures to mitigate them Gain familiarity with various types of lifting equipment and their safe usage Acquire improved ability to plan and organise manual handling tasks in a safe and efficient manner. What will make you stand out? On completion of this online course, you will gain: CPD QS Accredited After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the course at your own pace. Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. The substantial Manual Handling is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enrolling in this course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Manual Handling and explore the key topics. Therefore, reinforce your knowledge and furnish your skills by enrolling in our course. Take one step closer to achieving your goal. Show off your new skills with a certificate of completion Once you complete the Manual Handling course, you will be eligible to request a digital certificate for free. For Printed Transcript & Hardcopy Certificate- 4.99 GBP (Inside the UK Postal Fee) 8.99 GBP (International Delivery Fee) CPD 10 CPD hours / points Accredited by CPD Quality Standards Module 01: Introduction, Legislation and Guidance 20:06 1: Introduction, Legislation and Guidance Preview 20:06 Module 02: Manual Handling Hazards and Injuries 22:42 2: Manual Handling Hazards and Injuries 22:42 Module 03: Manual Handling Risk Assessments 17:02 3: Manual Handling Risk Assessments 17:02 Module 04: Controlling and Reducing the Risks 25:47 4: Controlling and Reducing the Risks 25:47 Module 05: Safe Lifting Techniques 12:41 5: Safe Lifting Techniques 12:41 Assignment - Manual Handling 03:00 6: Assignment On Manual Handling 03:00 PDF Who is this course for? This course is convenient for - Healthcare workers, such as nurses and orderlies, who regularly lift and move patients. Construction workers, who frequently handle heavy equipment and materials. Warehouse workers and forklift operators, who are responsible for moving and handling heavy items. Retail workers, who may be required to lift and move boxes or stock shelves. Office workers, who may be required to lift and move heavy equipment or files. Requirements Without any formal requirements, you can delightfully enrol in this course. Career path This course will assist the learners in pursuing the following careers Warehouse worker: £18,000 - £24,000 per year. Logistics Coordinator: £20,000 - £30,000 per year. Construction worker: £22,000 - £35,000 per year. Manufacturing worker: £25,000 - £40,000 per year. Forklift Operator: £25,000 - £35,000 per year.

Duration 3 Days 18 CPD hours This course is intended for Developers Administrators Overview Understand why Blockchain is needed and where Explore the major components of Blockchain Learn about Hyperledger Fabric v1.1 and the structure of the Hyperledger Architecture Lean the features of the Fabric model including chaincode, SDKs, Ledger, Security and Membership Services Perform comprehensive labs on writing chaincode Explore the architecture of Hyperledger Fabric v1.1 Understand and perform in depth labs on Bootstrapping the Network Gain a detailed understanding of the benefits, components and architecture of Hyperledger Composer Learn Hyperledger Explorer and Hyperledger Composer Playground Perform comprehensive labs to integrate/develop an application with Hyperledger Fabric running a smart contract Build applications on Hyperledger Fabric v1.1 This instructor-led Hyperledger training course is designed for developers and administrators who want to take a comprehensive deep dive on Hyperledger Fabric and Hyperledger Composer. This Hyperledger training course has several comprehensive labs, giving you real world experience.In 3 days, you will learn the need for blockchain applications, where blockchain is used, and about Hyperledger Fabric, the open source framework for developing blockchain applications and solutions with a modular architecture. Introduction to Blockchain Introduction to Blockchain What is Blockchain Types of network Public network Permissioned network Private network Need for Blockchain Components of Blockchain Consensus Provenance Immutability Finality Where can Blockchain be used Example on Blockchain How Blockchain Works How Blockchain Works Structure of Blockchain Block Hash Blockchain Distributed Lifecycle of Blockchain Smart Contract Consensus Algorithm Proof of Work Proof of Stake Practical Byzantine Fault Tolerance Actors of Blockchain Blockchain developer Blockchain operator Blockchain regulator Blockchain user Membership service provider Building A Small Blockchain Application Introduction to Hyperledger Fabric v1.1 Introduction to Hyperledger What is Hyperledger Why Hyperledger Where can Hyperledger be used Hyperledger Architecture Membership Blockchain Transaction Chaincode Hyperledger Fabric Features of Hyperledger Fabric Installation of prerequisite Getting Started With Fabric Model The Fabric Model Features of Fabric Model Chaincode SDKs Ledger Privacy through channels Security and Membership services Assets Consensus Components of Fabric Model Peer Orderer Certificate Authority Building your network Chaincode Chaincode Chaincode API How to write a Chaincode Lab Work Architecture of Hyperledger Fabric v1.1 Architecture of Hyperledger Fabric Transaction Ledger Nodes Peer Endorser Ordering Nodes Channels Certificate Authority Transaction Flow Lab Work Bootstrapping Bootstrapping the Network Introduction Lab Work Task 1 - Generate the crypto material for the various participants. Task 2 - Generate the genesis block for the Orderer node and start ordering service (solo node). Task 3 - Generated the configuration transaction block to create a new channel. Task 4 - Sign the configuration block and create the new channel. Task 5 - Make peers of all the organizations join the channel that we created in Task 4 Introdcution to Hyperledger Explorer Introduction To Hyperledger Explorer Block Details Peer List Chaincode List Transaction Details Installation of Hyperledger Explorer Starting the Explorer App Introduction to Hyperledger Composer Introduction Components of Hyperledger Composer Benefits of Hyperledger Composer Key Concepts Hyperledger Composer Solution Installation Hyperledger Composer Playground Hyperledger Composer Playground Introduction Playground Overview Lab Work Additional course details: Nexus Humans Hyperledger Training - Developing on Hyperledger Fabric training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Hyperledger Training - Developing on Hyperledger Fabric course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Take this tremendous opportunity to transform yourself into highly skilled and recognised python experts by enrolling on our

If you want to start your import-export business but don't know where to start, this Import/Export Business course will guide you through the process. Through this course, you'll learn the process of purchasing products, packing, shipping, and selling them for maximum profits. This Import/Export Business course will teach you the essential steps to start your import-export business. It will introduce you to the import-export operations. You will learn how to choose the right products for your business. You'll also learn how to target the market and find your ideal customers. Our exclusive lectures will also educate you on supply chain management and familiarise you with the necessary tools for trading.  Learning Objectives Learn how to organise for import and export operations Be able to choose the right products for your business Know how to target the market and find the ideal customers Understand the process of searching, marketing, and distribution Learn about documentation and supply chain management Know about the pricing, payment, and shipping procedureDetermine the necessary tools for trading Who is this Course for? This Import/Export Business course is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of import-export business or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement Anyone interested in learning more about this subject should take this Import/Export Business course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Import/Export Business course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Import Operator Import Clerk Import Manager Import Administrator Import & Export Controller Supply Chain Coordinator Import & Export Coordinator Sales & Shipping Administrator Management Consultant Lead Course Curriculum Module 01: Introduction to Import Export Introduction to Import Export 00:20:00 Module 02: Organising the Import Export Operation Organising the Import Export Operation 00:26:00 Module 03: Products for Your Import Export Business Products for Your Import Export Business 00:23:00 Module 04: Target the Marketing and Find Your Customers Target the Marketing and Find Your Customers 00:23:00 Module 05: Searching, Marketing, and Distribution Searching, Marketing, and Distribution 00:24:00 Module 06: Documentation and Supply Chain Management Documentation and Supply Chain Management 00:14:00 Module 07: Pricing, Payment and Shipping Procedure Pricing, Payment and Shipping Procedure 00:22:00 Module 08: Necessary Tools for Trading Necessary Tools for Trading 00:12:00 Assignment Assignment - Import/Export Business 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Register on the SQL Server : Basic Microsoft SQL Server today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The SQL Server : Basic Microsoft SQL Server is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The SQL Server : Basic Microsoft SQL Server Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the SQL Server : Basic Microsoft SQL Server, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Unit 01: Course and Instructor Introduction Course and Instructor Introduction 00:05:00 Unit 02: Laying out the foundation - Overview & Installation Pre-requisites & Different Editions of SQL Server 00:06:00 Downloading Express Edition & sample database 00:03:00 Installing the downloads & Configuration 00:19:00 The sa Login 00:04:00 Wrap up - what we went over! 00:01:00 Unit 03: Core concepts - Taming the RDBMS beast! What is RDBMS? 00:12:00 Where does SQL Server fit in? 00:02:00 Basic database objects 00:16:00 Different Files that got installed - MDF & LDF 00:03:00 Wrap up - what we went over! 00:01:00 Unit 04: Tool of the trade - SQL Server Management Studio Getting started with SSMS 00:07:00 Getting around Object Explorer 00:05:00 Query Window 00:06:00 Pre-built DB - system database 00:04:00 Wrap up - what we went over! 00:01:00 Unit 05: Simple SELECT Bare Minimum: SELECTING a literal 00:05:00 Retrieving / querying data from a table - using FROM clause 00:06:00 Playing with Column Names 00:03:00 Rearranging columns to your liking 00:01:00 Wrap up - what we went over! 00:01:00 Unit 06: Filtering out unwanted data Narrowing down and ordering result set - WHERE and ORDER clause 00:17:00 Narrowing down result set - BETWEEN / NOT BETWEEN 00:09:00 Narrowing down result set - IN and NOT IN operator 00:05:00 Narrowing down result set - Pattern Matching: LIKE and Wildcards 00:11:00 Wrap up - what we went over! 00:01:00 Unit 07: Expressions and Functions Dealing with nothing: NULL 00:06:00 Working with strings: Concatenation and other string functions 00:15:00 Working with dates: Date Functions 00:07:00 Some System Functions 00:05:00 Wrap up - what we went over! 00:02:00 Unit 08: Getting data out of multiple tables Joining multiple tables - INNER JOIN 00:09:00 Join types - OUTER JOIN - LEFT / RIGHT / FULL 00:08:00 Join types - CROSS JOIN 00:02:00 Holy UNION! 00:03:00 Subqueries 00:04:00 Wrap up - what we went over! 00:02:00 Unit 09: Summarizing and Grouping data DISTINCT and ALL Predicates 00:02:00 Aggregate Functions 00:03:00 GROUP BY clause / HAVING clause 00:04:00 WHERE and ORDER BY in aggregate queries 00:04:00 Wrap up - what we went over! 00:01:00 Unit 10: Bonus Bonus_Section 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Course Overview Peek into the world of data science and machine learning with the comprehensive Data Science & Machine Learning With R in 2021 course. This course will provide you with a detailed understanding of both machine learning and data science. In addition, you will acquire essential skills to pursue a career in this growing industry. The Data Science & Machine Learning With R in 2021 course will teach you the core concept of data science. You will be able to recognize different data types and structures. From the modules, you will receive an introduction to the intermediate R Section. The course will show you the techniques of data manipulation in R. You will know the process of data visualization with R and learn to create reports with R markdown. The Data Science & Machine Learning With R in 2021 course will provide you with an insight into the fundamentals of machine learning. You will understand the principles of data processing, linear regression, logistic regression and more.  This highly informative Data Science & Machine Learning With R in 2021 course will equip you with the essential skills of data science. If you desire to become a professional data scientist, this course can be your stepping stone. So, enroll in the course and fast track your career. Learning Outcomes Learn the definition of data science Understand the basics of machine learning Enrich your knowledge of data types and structures Know the process of data manipulation in R Gain the ability to create reports with R markdown Become skilled in building web apps with R shiny Who is this course for? Aspiring data scientists or individuals interested in learning data science and machine learning  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. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. 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  The Data Science & Machine Learning With R in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Data Scientist Data Science and Machine Learning Course Intro Data Science and Machine Learning Introduction 00:03:00 What is Data Science 00:10:00 Machine Learning Overview 00:05:00 Who is This Course for 00:03:00 Data Science and Machine Learning Marketplace 00:05:00 Data Science and Machine Learning Job Opportunities 00:03:00 Data Types and Structures in R Getting Started 00:16:00 Basics 00:06:00 Files 00:11:00 RStudio 00:07:00 Tidyverse 00:05:00 Resources 00:04:00 Data Types and Structures in R Unit Introduction 00:30:00 Basic Type 00:09:00 Vector Part One 00:20:00 Vectors Part Two 00:25:00 Vectors - Missing Values 00:16:00 Vectors - Coercion 00:14:00 Vectors - Naming 00:10:00 Vectors - Misc 00:06:00 Creating Matrics 00:31:00 List 00:32:00 Introduction to Data Frames 00:19:00 Creating Data Frames 00:20:00 Data Frames: Helper Functions 00:31:00 Data Frames Tibbles 00:39:00 Intermediate R Intermediate Introduction 00:47:00 Relational Operations 00:11:00 Conditional Statements 00:11:00 Loops 00:08:00 Functions 00:14:00 Packages 00:11:00 Factors 00:28:00 Dates and Times 00:30:00 Functional Programming 00:37:00 Data Import or Export 00:22:00 Database1 00:27:00 Data Manipulation in R Data Manipulation in R Introduction 00:36:00 Tidy Data 00:11:00 The Pipe Operator 00:15:00 The Filter Verb 00:22:00 The Select Verb 00:46:00 The Mutate Verb 00:32:00 The Arrange Verb 00:10:00 The Summarize Verb 00:23:00 Data Pivoting 00:43:00 JSON Parsing 00:11:00 String Manipulation 00:33:00 Web Scraping 00:59:00 Data Visualization in R Data Visualization in R Section Intro 00:17:00 Getting Started 00:16:00 Aesthetics Mappings 00:25:00 Single Variable Plots 00:37:00 Two Variable Plots 00:21:00 Facets, Layering, and Coordinate Systems 00:18:00 Styling and Saving 00:12:00 Creating Reports with R Markdown Creating with R Markdown 00:29:00 Building Webapps with R Shiny Introduction to R Shiny 00:26:00 A Basic R Shiny App 00:31:00 Other Examples with R Shiny 00:34:00 Introduction to Machine Learning Machine Learning Part 1 00:22:00 Machine Learning Part 2 00:47:00 Starting A Career in Data Science Starting a Data Science Career Section Overview 00:03:00 Data Science Resume 00:04:00 Getting Started with Freelancing 00:05:00 Top Freelance Websites 00:05:00 Personal Branding 00:05:00 Importance of Website and Blo 00:04:00 Networking Do's and Don'ts 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Gain essential skills for the funeral service industry with our Funeral Service Management Diploma. Learn funeral arrangement, etiquette, marketing, and more. Start your journey today!

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