42751 Learning courses in Glasgow delivered Online

Digital competence is a crucial competence for employees in many, if not most, of today's organizations. Understanding the basics of the technology that we use both personally and professionally helps employees become better assets and evolve along with their organization. In this video, we explore the definition of the Internet of Things (IoT), how it impacts our workplaces, and the lesser-known ways we interact with it. Length: 3:48 Learning Objectives Evaluate the pervasive influence of the Internet of Things (IoT) on our connected world, discerning its role in connecting diverse devices and enabling the transmission of data for analysis, prediction, and enhanced decision-making across personal and professional domains.;Analyze critical developments in the realm of IoT and the imperative for heightened security measures to counter evolving security threats.;Explore the dynamic landscape of IoT platforms, predicting their exponential growth, and understand the synergy between IoT and blockchain technology for enhanced connectivity and security.

How well do you know your client base? How can upgrading your technology or digitally streamlining serve them? Some companies undergo a digital transformation beginning with reviewing software and then growing frustrated when the impact is hard to find. This microlearning video outlines how to achieve the best results for your customers and organization by starting with exploring intended outcomes. This video is great for anyone involved in strategic planning at your organization. Length: 3:56 Length: 4:21 Learning Objectives Examine the importance of comprehensive audience research, eliminating assumptions and gaining a deep understanding of client behaviors and preferences, to lay the foundation for a data-driven digital transformation strategy.;Articulate clear and strategic objectives, addressing how digital transformation can advance overall business objectives and enhance customer engagement and experiences.;Shift the focus from technology to user impact, emphasizing the significance of reducing costs, saving time, and delivering superior customer experiences in the digital transformation strategy formulation.

Inclusivity is something a lot of organizational leaders say they want, but what about restrooms? Gender-neutral restrooms are a great way to make sure that everyone feels welcome, understood, and respected in your organization. There are multiple approaches to making the change, and while some take more effort than others, it is worth it for the inclusion benefits it provides. This video is great for HR professionals, managers, and decision-makers in a company. Length: 3:39 Learning Objectives Acknowledge the importance of gender-neutral restrooms in promoting inclusivity and understanding the needs of transgender, non-binary, and diverse individuals in the workplace.;Recognize how gender-neutral restrooms are designed to prioritize safety, privacy, and comfort for all users, with an emphasis on individual stalls and appropriate signage.;Develop strategies to address objections and encourage open dialogue, ultimately fostering a more inclusive and accepting workplace that respects the diverse needs and experiences of all individuals.

Having a diverse company culture is good for business! Diversity in the workplace promotes inclusion, innovation, and improved retention rates. A D&I strategy, however, is just one part of a commitment. What happens next? This video explores five ways that management can make sure that their D&I plans are executed and regularly evaluated. Don't let your strategy or commitment just sit on the shelf! Use these tips to make them count. Length: 4:20 Learning Objectives Develop and share equal opportunity policies compliant with the Equal Employment Opportunity Commission guidelines, promoting inclusivity among current and prospective employees.;Implement a selective and effective diversity training approach that fosters real change within the workplace and promotes diversity as a core organizational value.;Recognize the numerous advantages of a diverse company culture, including improved innovation, better decision-making, and increased employee engagement.;Identify untapped talent pools to diversify your workforce and enhance organizational performance.

Overview Become an expert in online marketing and learn how to turn brands and businesses into huge successes overnight. This popular Digital Marketing and Advertising Level 3 course is designed to teach anyone the fundamental knowledge needed to perform dynamic online advertising that works. The many online learning modules provide expert tuition for every aspect of Digital Marketing; from using SEO to target an audience, to utilising the power of social media to make a product go viral. You will also be taught how to use video and email marketing in order to maximise the recognition for your work and make everyone aware of your product. 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 Digital Marketing and Advertising Level 3. It is available to all students, of all academic backgrounds. Requirements Our Digital Marketing and Advertising Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 13 sections • 123 lectures • 11:23:00 total length •Welcome: 00:01:00 •How to register your company: 00:04:00 •How to see Email Sender's Company and Logo in Your Gmail: 00:02:00 •How to Generate sitemap of a website: 00:03:00 •How to protect a website from Spam on WordPress: 00:02:00 •Quick way to identify whether the website is Mobile optimized: 00:03:00 •How to identify registration data of website: 00:01:00 •How to identify duplicate content from the web: 00:03:00 •How to create google alerts: 00:03:00 •How to find the age of the domin: 00:02:00 •How to check if the website server is down: 00:01:00 •How to create text notes thatwill self destruct after being read: 00:02:00 •How to send google search information to your friends: 00:03:00 •How to find webhost of any website: 00:02:00 •Discover new sites that are similar to what you like alredy: 00:03:00 •How to easily highlight the important parts of a web page: 00:01:00 •How to share you email online without worrying about spam: 00:02:00 •How to get compute level answers without searching: 00:03:00 •The easiest way to setup email reminders: 00:03:00 •How to find the original URL tht's hiding behind a short URL: 00:02:00 •How to corrupt a file you shared online: 00:01:00 •How to create a throwaway email: 00:02:00 •How to check if your email account has been compromised: 00:01:00 •How to register website on Google search console: 00:06:00 •How to Optimize your website homepage: 00:06:00 •How to add a sitemap on google search: 00:07:00 •How to shortlist targeted keyword list in google keyword planner: 00:08:00 •How to set international targeting on google search: 00:02:00 •How to remove a URL from google search engine: 00:03:00 •How to identify competitors keyword: 00:08:00 •How to leverage top sites to get on google search results: 00:04:00 •Discover powerful data analytics to mesure SEO performance: 00:06:00 •How to do keyword research: 00:11:00 •How to write perfect title tags for search engines: 00:05:00 •How to optimise heading tags, external and internal links: 00:08:00 •What are backlinks & how to get them: 00:06:00 •How to write a perfect Meta description: 00:06:00 •How to enhance speed & performance of your website: 00:04:00 •Youtube account setup: 00:04:00 •Account optimization: 00:09:00 •How to create & setup Youtube channel banner: 00:05:00 •Youtube channel tags, thumbnails & custom thumbnails: 00:08:00 •Analyse Youtube keyword research: 00:05:00 •Youtube SEO techniques: 00:07:00 •What are Youtube cards & how does it work: 00:06:00 •How to optimise comments & reply them in bulk: 00:03:00 •How to grow your channel with competitor Analysis: 00:07:00 •How to manage multiple YouTube accounts: 00:02:00 •A simple yet powerful trick to increase your subscribers list: 00:03:00 •Youtube Paid Advertising: 00:13:00 •How to monetise your YouTube channel: 00:02:00 •What are Google Ads & how does it work: 00:16:00 •Account setup: 00:04:00 •Competitors analysis: 00:08:00 •Campaign types & how to select the right campaign: 00:07:00 •Bids & Budgets: 00:08:00 •How to target the right audience: 00:07:00 •Google Ads advance campaign settings: 00:07:00 •Choosing the right keywords: 00:05:00 •How to write ads that gets more clicks: 00:06:00 •How to install tracking code on your website: 00:04:00 •How to add filters & remove internal traffic: 00:04:00 •How to track paid campaigns: 00:04:00 •How to look and analyse different segment data: 00:06:00 •How to configure goals in google analysics: 00:05:00 •How to link google Adwords account: 00:03:00 •How to manage multiple analytics accounts: 00:02:00 •How to remove spam traffic: 00:04:00 •Email marketing tools set up ( Mailchimp and Gestresponse): 00:10:00 •How to install signup or popup forms on the website: 00:17:00 •How to collect email address without a wbsite: 00:05:00 •How to create a 'Hook' to your signup forms: 00:08:00 •Discover the psychology behind acquiring more leads: 00:09:00 •Email marketing automation process: 00:08:00 •Email analytics: 00:07:00 •How to increase your connections in no time: 00:08:00 •Secret of LinkedIn InMails: 00:05:00 •Discover the best ways to use Linkedin Groups: 00:09:00 •How to setup a company page on Linkedin: 00:04:00 •How to increase traffic to your website using Linkedin blog: 00:07:00 •Twitter Account setup: 00:03:00 •Knowing Twitter features: 00:06:00 •Following twitter accounts: 00:03:00 •Twitter profile optimisation: 00:06:00 •How to get Twitter followers: 00:10:00 •Posting first 5 tweets for engagement: 00:05:00 •Leveraging Hashtags to increase your tweets visibility: 00:04:00 •What are twitter polls & how do you use them: 00:05:00 •A powerful trick to acquire customers on twitter: 00:03:00 •How to get followers retweet your post: 00:03:00 •How to embed a twitter button to your website or post: 00:02:00 •Twitter analytics: 00:04:00 •Set your Facebook page: 00:05:00 •Facebook Icon, cover image & description: 00:06:00 •How to get your first page likes: 00:08:00 •Discover how to increase your page likes: 00:02:00 •How to manage multiple Facebook page: 00:03:00 •Facebook comments: 00:05:00 •Leveraging Facebook groups: 00:05:00 •Facebook Autoposting: 00:04:00 •Run a competition: 00:06:00 •Facebook Ads: 00:04:00 •How to get best out of Facebook: 00:15:00 •Facebook pixel & Re-marketing: 00:04:00 •How to setup a Instagram business profile: 00:07:00 •Set up Instagram bio & profile image: 00:03:00 •Leveraging Instagram accounts: 00:06:00 •A simple way to create free content on Instagram: 00:05:00 •Secret of hashtags on Instagram: 00:04:00 •Reposting Instagram App: 00:04:00 •How to get genuine Instagram followers: 00:05:00 •Discover how to grow your business through Instagram stories: 00:05:00 •How to get your posts reposted on Instgram by influncers: 00:05:00 •A quick way to do App store marketing research: 00:16:00 •How to discover the estimate size of your market: 00:08:00 •Discover the best ways to promote your app: 00:15:00 •App installs via Facebook Ads: 00:16:00 •App installs via Google Ads: 00:14:00 •How to make money from your app: 00:08:00 •How to optimise your App store listing ?: 00:14:00 •Discover growth hacking techniques for App downloads: 00:09:00 •Techniques to get to the top of App store ranking: 00:07:00 •Assignment - Digital Marketing and Advertising Level 3: 00:00:00

Overview Embarking on the High School Math course opens doors to a world where numbers and equations form the backbone of countless real-world applications. In an era where data-driven decisions rule, this course stands as a cornerstone for those aspiring to thrive in numerous professional fields.  A recent study by the Educational Research Center highlighted that proficiency in high school mathematics is strongly correlated with success in higher education and various career paths. This course not only equips students with fundamental mathematical knowledge but also sharpens analytical and problem-solving skills, making them indispensable in today's competitive landscape. Venture on a journey of mathematical mastery. Enrol in the High School Math course today and unlock the door to a world of opportunities and intellectual growth! 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 High School Math. It is available to all students, of all academic backgrounds. Requirements Our High School Math 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 12 sections • 136 lectures • 23:03:00 total length •Introduction: 00:03:00 •What is Function?: 00:07:00 •Vertical Line Test: 00:04:00 •Value of a Function Graphically: 00:08:00 •Domain Range of a function Algebraically: 00:13:00 •Domain Range of a function Graphically: 00:06:00 •Even & Odd Functions: 00:07:00 •One to one Function: 00:05:00 •Composite Functions: 00:09:00 •How to draw Rational Functions- 1: 00:04:00 •How to draw Rational Functions- 2: 00:10:00 •Inverse of a function Algebraically: 00:05:00 •Inverse of a function Graphically: 00:09:00 •Practice Problems 1: 00:15:00 •Practice Problems 2: 00:11:00 •Resources Downloads: 00:40:00 •Introduction to Quadratic Equations: 00:04:00 •Solving Quadratic Equations by Factorization method: 00:10:00 •Writing in completed square form: 00:08:00 •Solving by completed square method: 00:08:00 •Sketching of Quadratic Graphs: 00:11:00 •Quadratic graphs using Transformations: 00:06:00 •Quadratic inequalities: 00:11:00 •Deriving Quadratic formula: 00:05:00 •Solving problems using Quadratic Formula: 00:06:00 •Equations reducible to Quadratic: 00:07:00 •Nature of Roots of Quadratic Equations: 00:04:00 •Nature of roots continues: 00:12:00 •Quadratic Equations (Resources): 00:50:00 •Distance formula: 00:15:00 •Mid point formula: 00:05:00 •Gradient of a line: 00:10:00 •Graphing using gradient and y intercept: 00:02:00 •Some standard lines: 00:04:00 •Slope intercept form y = m x +c: 00:05:00 •Intersection of line and parabola: 00:09:00 •Practice Problems from past papers (part 3): 00:12:00 •Sequence and series ( video): 00:08:00 •Arithmetic Sequence: 00:10:00 •General term of an A.P.: 00:07:00 •Finding given term is which term?: 00:05:00 •Writing sequence when two terms are known: 00:08:00 •Condition for three terms to be in A.P.: 00:05:00 •Sum to n terms of A.P.: 00:06:00 •Practice Problems 1 (A.P.): 00:08:00 •Practice problems 3 (A.P.): 00:07:00 •Practice problems 4 (A.P.): 00:10:00 •Geometric Progressions: 00:11:00 •Sum to n terms in G.P.: 00:14:00 •Sum to infinite Terms in G.P.: 00:13:00 •Practice Problems 1 (GP): 00:13:00 •Practice Problems 2 (GP): 00:06:00 •Practice Problems based on AP and GP both: 00:15:00 •Sequence and series Text 1: 00:40:00 •Sequence and series Text 2: 00:55:00 •What is Factorial?: 00:06:00 •n-choose -r problems: 00:06:00 •Properties of n - choose -r: 00:05:00 •Expanding using Binomial Theorem: 00:11:00 •Finding the indicated term in the Binomial expansion: 00:10:00 •Finding the indicated term from end: 00:09:00 •Finding the coefficient for given exponent (index) of the variable: 00:08:00 •Finding the term independent of variable: 00:05:00 •Expanding in increasing and decreasing powers of x: 00:09:00 •Practice problems 1: 00:12:00 •Practice Problems 2: 00:09:00 •Practice problems 3: 00:10:00 •Past papers problems 1: 00:15:00 •Past Paper problems 2: 00:13:00 •Past Paper problems 3: 00:09:00 •Resources in this section: 00:48:00 •What is Derivative?: 00:07:00 •Derivation of formula for Derivative: 00:06:00 •Differentiation by definition or First Principle: 00:06:00 •Power Rule: 00:20:00 •Practice Problems on Power Rule 1: 00:07:00 •Practice Problems on Power Rule 2: 00:07:00 •Practice Problems on Power Rule 3: 00:05:00 •Practice Problems on Power Rule 4: 00:11:00 •Practice Problems on Power Rule 5: 00:07:00 •Tangents and Normals- Basics: 00:12:00 •Practice- Tangents and Normals Part 1: 00:16:00 •Practice- Tangents and Normals Part 2: 00:13:00 •Practice- Tangents and Normals Part 3: 00:11:00 •Practice- Tangents and Normals Part 4: 00:14:00 •Stationary Points - Basics: 00:13:00 •Practice- Increasing Decreasing & Maxima Minima part 1: 00:11:00 •Practice- Increasing Decreasing & Maxima Minima part 2: 00:12:00 •Practice- Increasing Decreasing & Maxima Minima part 3: 00:10:00 •Concavity-Basics: 00:02:00 •Concavity & Second Derivative: 00:08:00 •Second Derivative Test: 00:09:00 •Practice Problems on second derivative: 00:04:00 •Practice Problem of Maxima Minima using second derivative test Part 1: 00:17:00 •Practice Problem of Maxima Minima using second derivative test Part 2: 00:10:00 •Practice Problem of Maxima Minima using second derivative test Part 3: 00:07:00 •Practice Problem of Maxima Minima using second derivative test Part 4: 00:07:00 •Applications of Maxima and Minima Part 1: 00:09:00 •Applications of Maxima and Minima Part 2: 00:07:00 •Applications of Maxima and Minima Part 3: 00:10:00 •Applications of Maxima and Minima Part 4: 00:09:00 •Applications of Maxima and Minima Part 5: 00:10:00 •Applications of Maxima and Minima Part 6: 00:08:00 •Past Paper Problems on applications of maxima and minima Part 1: 00:09:00 •Past Paper Problems on applications of maxima and minima Part 2: 00:09:00 •Past Paper Problems on applications of maxima and minima Part 3: 00:08:00 •Past Paper Problems on applications of maxima and minima Part 4: 00:07:00 •Chain Rule: 00:12:00 •Rate of change part 1: 00:05:00 •Rate of change part 2: 00:10:00 •Rate of change part 3: 00:07:00 •Past Paper Problems using chain rule -1: 00:06:00 •Past Paper Problems using chain rule - 2: 00:07:00 •Past Paper Problems using chain rule 3: 00:07:00 •Past Paper Problems using chain rule -4: 00:04:00 •Graphical Method of solving pair of linear equations: 00:10:00 •Video lecture on Graphical method: 00:05:00 •Method of elimination by substitution: 00:10:00 •Video lecture on substitution method: 00:06:00 •Method of elimination by equating the coefficients: 00:10:00 •Video lecture on equating coefficients method: 00:09:00 •Practice Problems on Linear equation: 00:20:00 •How to take up this course?: 00:10:00 •Background of Algebra: 00:10:00 •Language of Alg ebra: 00:10:00 •Finding Values of algebraic expressions: 00:14:00 •Fractional Indices: 00:10:00 •Higher Indices: 00:07:00 •Rules of Brackets: 00:04:00 •Simplification by removing brackets (BODMAS): 00:11:00 •Simplifications of Algebraic Fractions: 00:07:00 •Solving complex Linear Equations in one variable: 00:10:00 •Factorization by taking out common factor: 00:10:00 •Factorization by grouping the terms: 00:09:00 •Factorize using identity a ² - b ²: 00:07:00 •Factorization by middle term split: 00:12:00

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

Overview of Business Administration Join our Business Administration course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Business Administration course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Business Administration course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a Quick Look at The Course Content: This Business Administration Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Business Administration. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Business Administration course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Business Administration is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Business Administration course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Business Administration Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Business Administration Introduction to Business Management 00:25:00 Operations Management 00:24:00 Introduction to Business Analysis 00:14:00 Strategic Analysis and Product Scope 00:28:00 Project Management 00:19:00 Business Development and Succession Planning 00:24:00 Business Process Management (BPM) 00:28:00 Planning Forecasting Operations 00:21:00 Performance Management 00:18:00 Management of Cash and Credit 00:19:00 Managing Risk and Recovery 00:26:00 Quality Management 00:19:00 Communication Skills 00:25:00 Business Environment 00:16:00 Organisational Skills 01:16:00 Negotiation Techniques 00:16:00 Introduction to Human Resources 00:17:00 Motivation and Counselling 00:19:00 Customer Service 00:16:00 Time Management 00:40:00 Conflict Management 00:14:00

Begin your career as an HR manager by enrolling in Course Cave's HR Management course. This course will help you pursue your goals and develop your knowledge, competence, and skill, whether you are a novice or a seasoned professional. It covers a wide range of topics to assist you in developing your HR management knowledge and skills. It provides step-by-step directions for hiring and selecting employees, improving employee relationships at work, and motivating and rewarding staff for better productivity. This HR manager course also provides in-depth knowledge of the various HR processes and functions. After completing this course, learners will be able to build the necessary HR skills and knowledge and manage an organization's HR functions. Upon registration, you will receive full course access and will be able to access the course materials from anywhere in the world, at any time, and on any internet-enabled device. Learning Outcomes You will be able to do the following at the end of the course: Examine the importance of human resources and their management in businesses. Describe HRM Models. Implement new employee recruitment and selection procedures in your business. Recognise the significance of a positive employee partnership. Create and execute a successful workplace training program. Inspire and empower your staff. Promote equality and manage diversity in your organisation Examine current health and safety legislation and regulations and workplace health and safety management and risk assessment. Talk about common employee complaints, disciplinary issues, and professional dismissal procedures. Improve your communication abilities. Prevent abuse and discrimination in the workplace. Taking easy anti-Covid-19 precautions that will help protect your employees and your business. ***Courses are included in this Bundle Course Course 01: HR Management Course Course 02: Level 7 Diploma in Leadership & Management Course 03: Level 5 Diploma in Risk Management Course [ Note: Free PDF certificate as soon as completing the HR course ] Course Curriculum *** HR : HR *** Module 1: Introduction Module 2: Recruitment and Selection Module 3: Employee Relationship Module 4: Performance Management Module 5: The Necessity of Training & Development in the Workplace Module 6: Motivating and Rewarding Employees Module 7: Equality and Diversity Module 8: Health and Safety of Employees Module 9: Talent Management Module 10: Succession Planning Module 11: Absence Management and Attendance Module 12: Handling Grievance, Discipline, Termination and Dismissal Module 13: Communication Techniques for the Workplace Module 14: Preventing Workplace Violence and Harassment Module 15: Conflict Resolution Module 16: Occupational Health Safety, Hygiene and Workplace Wellbeing of Employees Module17: COVID-19 and the Workplace Assessment Method After completing each module of the HR Management 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 After completing the MCQ/Assignment assessment for this HR Management 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? HR course is highly recommended for anyone considering a career in human resources. This is something that existing HR workers who are desperate for promotion should think about. Thiscourse is open to business management students and anybody looking to improve their resume and career opportunities. Requirements There are no specific requirements for this course because it does not require any advanced knowledge or skills. Students who intend to enrol in this 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 After completing this HR course, you will be capable of applying for a variety of positions. After completing this course, you can continue your education with our updated version of Human Resources Management if you want to keep up with your colleagues and peers or advance in your profession. Certificates Certificate of completion Digital certificate - Included

Fire Safety: Level 2 Award in Fire Safety Course Online This online Fire Safety: Level 2 Award in Fire Safety Course was designed to teach employees about the hazards of workplace fires. It goes into the causes of fire in great detail and what fire safety precautions and evacuation processes your company should have in place. The Fire Safety: Level 2 Award in Fire Safety Course is structured into modules and submodules to make it easier for learners to grasp the concept, beginning with essential information and progressing to the most advanced level. The course covers both theoretical and practical aspects of all aspects of fire safety. It is critical to be aware of fire safety in the workplace, not only to comply with the law but also to keep people safe. It is everyone's responsibility to help prevent fires from starting and properly evacuate if required. This Fire Safety: Level 2 Award in Fire Safety Course will provide you with the knowledge you need to achieve these requirements. So, enrol on this Fire Safety: Level 2 Award in Fire Safety Course now and start learning instantly! Other courses are included with Fire Safety: Level 2 Award in Fire Safety Course Course 01: Level 2 Fire Safety Course 02: Workplace First Aid Training Course 03: Level 5 Health and Safety at Work [ Note: Free PDF certificate as soon as completing the Fire Safety: Level 2 Award in Fire Safety Course] Fire Safety: Level 2 Award in Fire Safety Course Online Industry Experts Designed this Fire Safety: Level 2 Award in Fire Safety Course into 12 detailed modules. Course Curriculum of Level 2 Award in Fire Safety Module 01: Introduction to Fire Safety Module 02: Fires in the Workplace Module 03: Fire Hazards Module 04: Fire Spread Module 05: Fire Safety Standards Module 06: Protecting People and Property Module 07: Methods of Extinguishing Fires Module 08: Fixed Fire Fighting Instructions Module 09: Fire Risk Assessments Module 10: Fire Procedures Module 11: Action in the Event of Fire Module 12: Role of the Fire Warden Assessment Method of Level 2 Award in Fire Safety After completing each module of the Fire Safety: Level 2 Award in Fire Safety 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 Level 2 Award in Fire Safety After completing the MCQ/Assignment assessment for this Fire Safety: Level 2 Award in Fire Safety 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? Fire Safety: Level 2 Award in Fire Safety Course Online Fire Safety: Level 2 Award in Fire Safety Course is suitable for: Students, Graduates, Trainees, Professionals, Students, Tutors, Executives, Home scholars, Beginners, Experts, Job Seekers, People with a passion for personal development! Special Note: Our Course is not a regulated course. If You want to get qualified, you can consider following options: Level 2 Award in Fire Safety (RQF) Level 2 Award in Fire Safety Principles (RQF) Level 2 Award in the Principles of Fire Safety (RQF) Level 1 in Principles of Fire Safety Awareness (RQF) Requirements Fire Safety: Level 2 Award in Fire Safety Course Online Students who intend to enrol in this Fire Safety: Level 2 Award in Fire Safety Course must meet the following requirements: Fire Safety: Good command of the English language Fire Safety: Must be vivacious and self-driven. Fire Safety: Basic computer knowledge. Fire Safety: A minimum of 16 years of age is required. Career path Fire Safety: Level 2 Award in Fire Safety Course Online Whether you want to enhance or start, the Fire Safety: Level 2 Award in Fire Safety Course will make pursuing a career in fire safety easier. So, express your expertise, distinguish yourself from the competition, and succeed! Certificates Certificate of completion Digital certificate - Included