1797 Dele courses delivered Online

Overview This comprehensive course on Ultimate PHP & MySQL Web Development Course & OOP Coding will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Ultimate PHP & MySQL Web Development Course & OOP Coding comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Ultimate PHP & MySQL Web Development Course & OOP Coding. It is available to all students, of all academic backgrounds. Requirements Our Ultimate PHP & MySQL Web Development Course & OOP Coding 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 15 sections • 133 lectures • 10:06:00 total length •Introduction: 00:02:00 •Setup On Windows: 00:15:00 •Setup On Mac: 00:11:00 •Setup On Linux: 00:12:00 •Online Code Editor: 00:03:00 •Basic File Syntax: 00:05:00 •Printing (echo): 00:06:00 •Comments: 00:05:00 •Variables: 00:06:00 •Variable Data Types: 00:07:00 •Variable Naming: 00:03:00 •Constants: 00:02:00 •Arrays: 00:05:00 •Associative Arrays: 00:06:00 •Multidimensional Arrays: 00:04:00 •if Statement: 00:06:00 •ifelse Statement: 00:02:00 •ifelseifelse Statement: 00:05:00 •Switch Statement: 00:06:00 •while Loop: 00:06:00 •doWhile Loop: 00:03:00 •for Loop: 00:03:00 •foreach Loop: 00:05:00 •Break Statement: 00:02:00 •Continue Statement: 00:02:00 •Basic Function: 00:03:00 •Passing Function Arguments: 00:03:00 •Passing Function Arguments By Reference: 00:04:00 •Default Argument Value: 00:02:00 •Function Returning Values: 00:05:00 •Dynamic Function Calls: 00:03:00 •Variable Scope: 00:04:00 •Simple HTML Form: 00:07:00 •GET vs POST: 00:05:00 •$_SERVER ['PHP_SELF']: 00:07:00 •Validating Form Data With PHP: 00:07:00 •Required Fields: 00:05:00 •Display Error Messages: 00:05:00 •Validate Name: 00:03:00 •Validate Email: 00:03:00 •Validate URL: 00:07:00 •Keep The Values In The Form: 00:04:00 •Read File (readfile()): 00:02:00 •Open, Read & Close A File (fopen(), fread(), fclose()): 00:04:00 •Read Single Line (fgets()): 00:03:00 •Check End-Of-File (feof()): 00:02:00 •Read Single Character (fgetc()): 00:02:00 •Write To File (fwrite()): 00:03:00 •Configure php.ini File For File Uploading: 00:02:00 •Front End HTML Upload Form: 00:04:00 •PHP Upload Script: 00:15:00 •Check If File Exists: 00:03:00 •Limit File Size: 00:05:00 •Limit File Type: 00:04:00 •MySQL vs MySQLi vs PDO: 00:05:00 •Creating A Database & Table (phpMyAdmin): 00:06:00 •Connecting To A Database: 00:06:00 •Get Data Using SELECT Query: 00:10:00 •WHERE Property For Filtering: 00:03:00 •LIKE Property For Pattern Search: 00:02:00 •Sorting Results Using ORDER BY Property: 00:01:00 •Using JOINS: 00:08:00 •Insert Data Using INSERT Query: 00:04:00 •Get ID Of The Last Inserted Row: 00:02:00 •Insert Multiple Rows: 00:05:00 •Update Data Using UPDATE Query: 00:03:00 •Delete Data Using DELETE Query: 00:02:00 •Delete All Rows In A Table Using TRUNCATE Query: 00:02:00 •Delete Table Using DROP Query: 00:02:00 •Limit Data Selections Using LIMIT, ROWNUM: 00:04:00 •Create Table Using CREATE Query: 00:03:00 •Clone/Duplicate Table: 00:03:00 •Alter Table: 00:05:00 •Create Database: 00:02:00 •Drop Database: 00:02:00 •SQL Injection & Prepared Statements: 00:09:00 •What Is XML?: 00:02:00 •What Is SimpleXML?: 00:02:00 •Parse XML String: 00:08:00 •Parse XML File: 00:02:00 •Get Node Values: 00:02:00 •Get Node Values of Specific Elements: 00:03:00 •Get Node Values - Loop: 00:03:00 •Get Attribute Values: 00:02:00 •What Is The XML Expat Parser?: 00:02:00 •Initializing The XML Expat Parser: 00:10:00 •Load and Output XML Using DOM Parser: 00:02:00 •Looping Through XML Using DOM Parser: 00:03:00 •What Is AJAX?: 00:02:00 •Load Simple Data Using AJAX Front End: 00:08:00 •Load Simple Data Using AJAX Back End: 00:05:00 •Load Data From A Database Using AJAX: 00:08:00 •Send A Plain Text Email: 00:04:00 •Send A HTML Email: 00:06:00 •Email Attachments: 00:17:00 •PHPMailer Setup: 00:03:00 •Send Email Using PHPMailer: 00:04:00 •Send HTML Email Using PHPMailer: 00:04:00 •Email Attachments Using PHPMailer: 00:02:00 •What Is Object Oriented Programming (OOP)?: 00:03:00 •Basic Class With Variables: 00:04:00 •Functions: 00:05:00 •Constructor: 00:04:00 •Destructor: 00:02:00 •Inheritance: 00:06:00 •Multi Class Inheritance: 00:03:00 •Function Overriding: 00:03:00 •Public vs Private vs Protected: 00:05:00 •Interfaces: 00:04:00 •Constants: 00:03:00 •Abstract Class: 00:06:00 •Static Keyword: 00:03:00 •Final Keyword: 00:02:00 •Initiating Parent Constructor: 00:02:00 •die() Function: 00:02:00 •Custom Error Handler: 00:04:00 •Triggering An Exception: 00:03:00 •Exception Handling: 00:05:00 •Create Database & Table: 00:04:00 •User Class & Database Connection: 00:15:00 •Register User Form: 00:09:00 •Inserting User Data Into Database: 00:10:00 •Registration Form Field Validation: 00:12:00 •Securing User Password: 00:03:00 •Check If Username or Email Already Exists: 00:11:00 •Retain Data After Failed Registration: 00:03:00 •Validate an Integer Within a Range: 00:04:00 •Validate IPv6 Address: 00:03:00 •Validate URL - Must Contain QueryString: 00:03:00 •Remove Characters With ASCII Value > 127: 00:04:00 •Including & Requiring External PHP Files: 00:05:00 •Resource: 00:00:00 •Assignment - Ultimate PHP & MySQL Web Development Course & OOP Coding: 00:00:00

Overview This comprehensive course on NodeJS made easy for MEAN or MERN Stack Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This NodeJS made easy for MEAN or MERN Stack Level 4 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this NodeJS made easy for MEAN or MERN Stack Level 4. It is available to all students, of all academic backgrounds. Requirements Our NodeJS made easy for MEAN or MERN Stack Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 116 lectures • 06:46:00 total length •Module 01: Course and Instructor Introduction: 00:03:00 •Module 02: GITHub URL: 00:01:00 •Module 01: What is Node?: 00:05:00 •Module 02: Why Node?: 00:04:00 •Module 03: NodeJS package manager NPM: 00:02:00 •Module 04: Install Node and Visual Studio Code: 00:02:00 •Module 01: Create a simple node application: 00:04:00 •Module 02: Adding Dependencies: 00:04:00 •Module 03: OS Module: 00:05:00 •Module 04: Write a file sync and async: 00:07:00 •Module 05: Use Arrow Functions: 00:02:00 •Module 06: Append and Rename: 00:03:00 •Module 07: Read and Delete: 00:04:00 •Module 08: HTTP module in action: 00:03:00 •Module 09: Return JSON Response: 00:04:00 •Module 10: Use nodemon: 00:02:00 •Module 11: Scripts block: 00:04:00 •Module 01: Introduction 04: 00:04:00 •Module 02: What is REST?: 00:06:00 •Module 03: Create an Express App: 00:02:00 •Module 04: Express In Action: 00:05:00 •Module 05: Handle other HTTP Methods: 00:06:00 •Module 06: Use Router: 00:05:00 •Module 07: Create Customer Endpoint: 00:05:00 •Module 01: Introduction 05: 00:02:00 •Module 02: Mongo Command Line: 00:07:00 •Module 03: Steps: 00:03:00 •Module 04: Use Mongo Client: 00:04:00 •Module 05: Implement Find All: 00:04:00 •Module 06: GET single product: 00:04:00 •Module 07: What is body-parser?: 00:03:00 •Module 08: Configure body-parser: 00:02:00 •Module 09: Create Product: 00:04:00 •Module 10: Update Product: 00:06:00 •Module 11: Delete Product: 00:02:00 •Module 01: Introduction 06: 00:04:00 •Module 02: Steps: 00:01:00 •Module 03: Create Project: 00:06:00 •Module 04: Create Server JS: 00:02:00 •Module 05: Create and Configure Product Controller: 00:02:00 •Module 06: Create Mongoose Schema and Model: 00:02:00 •Module 07: Create: 00:04:00 •Module 08: Test and Flow: 00:03:00 •Module 09: Read: 00:03:00 •Module 10: Update: 00:04:00 •Module 11: Delete: 00:02:00 •Module 01: Introduction 07: 00:01:00 •Module 02: Steps 7: 00:01:00 •Module 03: Create the Project 7: 00:02:00 •Module 04: Get All: 00:02:00 •Module 05: Create and Update: 00:04:00 •Module 06: Get and Delete: 00:03:00 •Module 01: Mocha and Chai: 00:03:00 •Module 02: Steps 8: 00:02:00 •Module 03: Install Dependencies: 00:01:00 •Module 04: First Test: 00:06:00 •Module 05: Handle Failures: 00:02:00 •Module 06: Test Create and Get: 00:02:00 •Module 07: Before and after methods: 00:03:00 •Module 01: Introduction 09: 00:03:00 •Module 02: Steps 09: 00:03:00 •Module 03: Create DB Connection: 00:04:00 •Module 04: Mongoose Static Methods: 00:03:00 •Module 05: Create the Model and DAO: 00:07:00 •Module 06: Create the Controller: 00:08:00 •Module 07: Map Routes: 00:05:00 •Module 08: Test: 00:02:00 •Module 09: Use src folder: 00:02:00 •Module 10: Use Babel and ES6 Syntax: 00:06:00 •Module 01: Usecase: 00:01:00 •Module 02: Create the Project: 00:03:00 •Module 03: Setup Configuration: 00:04:00 •Module 04: Create Model: 00:05:00 •Module 05: Implement Patient DAO: 00:03:00 •Module 06: Create Patient Controller: 00:04:00 •Module 07: Create and Configure Routes: 00:03:00 •Module 08: Create Clinical DAO and Controller: 00:07:00 •Module 09: Run and Test: 00:06:00 •Module 10: Fix Bug and Test: 00:02:00 •Module 01: Introduction 11: 00:02:00 •Module 02: Install Docker Desktop: 00:01:00 •Module 03: Steps: 00:03:00 •Module 04: Create Dockerfile: 00:07:00 •Module 05: Create docker-compose.yml: 00:05:00 •Module 06: docker compose up: 00:05:00 •Module 01: Introduction 12: 00:01:00 •Module 02: AWS EC2 Introduction: 00:03:00 •Module 03: Launch an EC2 Instance: 00:05:00 •Module 04: Windows - Use MobaXterm and connect: 00:04:00 •Module 05: Install Mongo: 00:04:00 •Module 06: Install Node and Git: 00:02:00 •Module 07: Push Project to Github: 00:04:00 •Module 08: Run the APP on EC2 and Test: 00:04:00 •Module 01: Introduction 13: 00:01:00 •Module 02: Install React CLI: 00:01:00 •Module 03: Create Project: 00:06:00 •Module 04: Create Components: 00:03:00 •Module 05: Configure Routing: 00:04:00 •Module 06: Home Component: 00:03:00 •Module 07: Use State and React Hook: 00:04:00 •Module 08: Render Rows: 00:03:00 •Module 09: Enable CORS on the Node Project: 00:04:00 •Module 10: Test Home Page: 00:03:00 •Module 11: Add Patient - Create Form: 00:05:00 •Module 12: Handle Submit: 00:04:00 •Module 13: Add Clinical's - Create Form: 00:07:00 •Module 14: Add Clinical's - Handle Submit: 00:04:00 •Module 01: Introduction 14: 00:02:00 •Module 02: Steps 14: 00:01:00 •Module 03: Setup the database: 00:03:00 •Module 04: Setup Project: 00:02:00 •Module 05: Get All: 00:05:00 •Module 06: Get One: 00:03:00 •Module 07: Create: 00:04:00 •Module 08: Return after Insert: 00:02:00 •Module 09: Update: 00:03:00

Overview This comprehensive course on Bash Scripting, Linux and Shell Programming will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Bash Scripting, Linux and Shell Programming comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Bash Scripting, Linux and Shell Programming. It is available to all students, of all academic backgrounds. Requirements Our Bash Scripting, Linux and Shell Programming is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 61 lectures • 03:03:00 total length •Introduction: 00:02:00 •Bash vs Shell vs Command Line vs Terminal: 00:06:00 •Listing Folder Contents (ls): 00:05:00 •Print Current Folder (pwd): 00:01:00 •Change Folder (cd): 00:03:00 •Using A Stack To Push Folders (pushd/popd): 00:03:00 •Check File Type (file): 00:01:00 •Find File By Name (locate) & Update Locate Database (updatedb): 00:02:00 •Find A Command (which): 00:02:00 •Show Command History (history): 00:02:00 •Show Manual Descriptions (whatis): 00:01:00 •Search Manual (apropos): 00:02:00 •Reference Manuals (man): 00:02:00 •Creating A Folder (mkdir): 00:02:00 •Creating A File (touch): 00:02:00 •Copy Files/Folders (cp): 00:02:00 •Move & Rename Files/Folders (mv): 00:02:00 •Delete Files/Folders (rm): 00:02:00 •Delete Empty Folder (rmdir): 00:02:00 •Change File Permissions (chmod): 00:06:00 •File Concatenation (cat): 00:03:00 •File Perusal Filter (more/less): 00:02:00 •Terminal Based Text Editor (nano): 00:03:00 •Run Commands As A Superuser (sudo): 00:03:00 •Change User (su): 00:03:00 •Show Effecter User and Group IDs (id): 00:02:00 •Kill A Running Command (ctrl + c): 00:02:00 •Kill All Processes By A Name (killall): 00:02:00 •Logging Out Of Bash (exit): 00:01:00 •Tell Bash That There Is No More Input (ctrl + d): 00:02:00 •Clear The Screen (ctr + l): 00:02:00 •Zoom In (ctrl + +): 00:02:00 •Zoom Out (ctrl + -): 00:02:00 •Moving The Cursor: 00:02:00 •Deleting Text: 00:04:00 •Fixing Typos: 00:03:00 •Cutting and Pasting: 00:03:00 •Character Capitalisation: 00:03:00 •Bash File Structure: 00:03:00 •Echo Command: 00:04:00 •Comments: 00:04:00 •Variables: 00:06:00 •Strings: 00:06:00 •While Loop: 00:04:00 •For Loop: 00:04:00 •Until Loop: 00:03:00 •Break & Continue: 00:03:00 •Get User Input: 00:02:00 •If Statement: 00:09:00 •Case Statements: 00:06:00 •Get Arguments From The Command Line: 00:04:00 •Functions: 00:05:00 •Global vs Local Variables: 00:03:00 •Arrays: 00:06:00 •Shell & Environment Variables: 00:06:00 •Scheduled Automation: 00:03:00 •Aliases: 00:03:00 •Wildcards: 00:03:00 •Multiple Commands: 00:02:00 •Resource: 00:00:00 •Assignment - Bash Scripting, Linux and Shell Programming@@: 00:00:00

Overview This comprehensive course on Angular 8 with Project will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Angular 8 with Project comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Angular 8 with Project. It is available to all students, of all academic backgrounds. Requirements Our Angular 8 with Project 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 10 sections • 21 lectures • 02:16:00 total length •Creating Demo Application: 00:07:00 •Components for Header: 00:10:00 •Creating Footer: 00:06:00 •Syntax for Footer: 00:05:00 •Header Component: 00:05:00 •Security related Feature: 00:06:00 •Defining the Router: 00:06:00 •Defining the Constructor: 00:06:00 •Create & Delete using Post: 00:06:00 •Get and Delete Methods: 00:07:00 •Creating Login Component: 00:08:00 •Components in Routing File: 00:08:00 •Creating Employee Files: 00:07:00 •Progress Info: 00:07:00 •Fields and Textboxes: 00:07:00 •Labels and Buttons: 00:06:00 •New Component to Add Employee: 00:06:00 •Properties related to New Employee: 00:06:00 •Backend & Frontend Application: 00:07:00 •Working of our Application: 00:06:00 •Logout Component: 00:04:00

Overview This comprehensive course on Node JS: API Development with Swagger Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Node JS: API Development with Swagger Masterclass comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Node JS: API Development with Swagger Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Node JS: API Development with Swagger Masterclass 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 6 sections • 22 lectures • 02:44:00 total length •Module 01: Introduction: 00:01:00 •Module 02: Goals & Prerequisites: 00:03:00 •Module 03: About the Instructor: 00:01:00 •Module 04: Open API Specification (OAS), Swagger & Node.js: 00:09:00 •Module 01: Http and Swagger: 00:09:00 •Module 02: Swagger Tools: 00:06:00 •Module 03: Setup: 00:06:00 •Module 01: Project Configuration: 00:08:00 •Module 02: Intro to Swagger Editor: 00:06:00 •Module 03: Project Explanation + GET Endpoint: 00:13:00 •Module 04: POST Endpoint: 00:06:00 •Module 05: PUT + DELETE Endpoint: 00:08:00 •Module 06: Challenge: Comments Endpoints: 00:17:00 •Module 01: Get: 00:11:00 •Module 02: Post: 00:08:00 •Module 03: Put: 00:07:00 •Module 04: Delete: 00:06:00 •Module 05: Challenge: Add comment logic: 00:18:00 •Module 06: Deploy API in Heroku: 00:06:00 •Module 01: Introduction to Json Web Tokens: 00:07:00 •Module 02: Authentication with Swagger and JWT: 00:07:00 •Module 01: Thank you!: 00:01:00

Overview This comprehensive course on Microsoft SQL Server Development for Everyone will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Microsoft SQL Server Development for Everyone comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft SQL Server Development for Everyone . It is available to all students, of all academic backgrounds. Requirements Our Microsoft SQL Server Development for Everyone 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 6 sections • 31 lectures • 05:48:00 total length •Introduction to SQL Server and Databases: 00:04:00 •Download and Install SQL Server Express: 00:05:00 •Connect to Database Instance and Create a Database: 00:06:00 •Drop or Remove Database: 00:04:00 •What is a Database Table?: 00:02:00 •Create an SQL Database Table: 00:32:00 •Insert Data into the Table with SQL Script: 00:15:00 •Insert Data into the Table with Management Studio: 00:05:00 •Select Data from the Table with SQL Script: 00:09:00 •More Advanced Select Queries Part 1: 00:18:00 •Update Data in the Table: 00:10:00 •Update Data in the Table with Management Studio GUI: 00:02:00 •Delete Data from the Table with SQL Script: 00:06:00 •Delete Data from the Table with Management Studio GUI: 00:01:00 •What are Relationships, Foreign Keys and Normalization: 00:11:00 •Create a Relationship in SQL Server: 00:19:00 •Insert Records in Related Tables: 00:13:00 •Run Queries on Related Tables: 00:19:00 •Left, Right and Full Joins: 00:11:00 •Grouping Data using SQL GROUP BY Clause: 00:12:00 •SQL AVG Aggregate Function: 00:11:00 •SQL COUNT Aggregate Function: 00:04:00 •SQL MAX and MIN Aggregate Functions: 00:04:00 •SQL SUM Aggregate Function: 00:04:00 •Create and Manage Views: 00:23:00 •Scalar Valued Functions: 00:27:00 •Inline Table Valued Functions: 00:09:00 •Stored Procedures: 00:28:00 •Table Triggers: 00:19:00 •Database Scripting, Backup and Restore: 00:15:00 •Assignment - Microsoft SQL Server Development for Everyone: 00:00:00

Overview This comprehensive course on 50 Tips to Upgrade your Excel Skill will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This 50 Tips to Upgrade your Excel Skill comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this 50 Tips to Upgrade your Excel Skill. It is available to all students, of all academic backgrounds. Requirements Our 50 Tips to Upgrade your Excel Skill 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 7 sections • 52 lectures • 02:57:00 total length •Welcome: 00:02:00 •Camera Tool: 00:05:00 •Add Line Break in Formula Bar: 00:03:00 •Advanced Copy-Paste using Office Clipboard: 00:03:00 •Navigation between Worksheets using Shortcut Keys: 00:01:00 •Flash Fill: 00:02:00 •Add Multiple Rows and Columns Quickly: 00:02:00 •Delete Blank Rows: 00:03:00 •Multi Level Row and Column Sorting: 00:04:00 •Add Sparklines: 00:03:00 •Paste Special - Transpose: 00:03:00 •Snap to Grid: 00:03:00 •Create Custom Auto fill List: 00:06:00 •Absolute Cell Reference: 00:03:00 •Import Data from Web page: 00:04:00 •Move Cell Direction: 00:03:00 •Delete Data using Mouse: 00:02:00 •Status Bar Quick Calculations: 00:03:00 •Link Text Boxes to Cell: 00:04:00 •Phone Number and ZIP Code Format: 00:04:00 •Speaking Cell: 00:05:00 •Invisible Text: 00:03:00 •Worksheet Grouping: 00:04:00 •Advanced Transpose: 00:04:00 •XLStart Folder: 00:03:00 •Use Slicers: 00:05:00 •Convert Text to Numbers: 00:03:00 •Hiding Workbook Elements: 00:02:00 •Useful Shortcut Keys: 00:03:00 •Sort data from Left to Right: 00:03:00 •Advanced Filter (Complex): 00:11:00 •Email as PDF: 00:02:00 •Synchronous Scrolling: 00:03:00 •Quick Analysis of data within Excel: 00:02:00 •Fill blank cells with Value: 00:03:00 •Hidden Chart Source Data: 00:03:00 •Two more Shortcuts: 00:03:00 •Add Blank Rows: 00:03:00 •Custom views in Excel: 00:06:00 •EMBED Feature: 00:04:00 •Adding Country code in Mobile Numbers: 00:04:00 •Plot an Average Line to a Chart: 00:04:00 •3D Referencing: 00:04:00 •Extract Unique Values: 00:03:00 •Excel Array Formula: 00:04:00 •Forecast Sheet: 00:04:00 •Add Spin Controls in Excel: 00:05:00 •Move Data using Mouse: 00:01:00 •Add new entry in Auto Correct to use across Office Applications: 00:05:00 •Find Differences between Two Lists: 00:02:00 •Find formulas Quickly: 00:02:00 •Thank You: 00:01:00

Overview This comprehensive course on Complete SAP UI5 Development will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete SAP UI5 Development comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Complete SAP UI5 Development. It is available to all students, of all academic backgrounds. Requirements Our Complete SAP UI5 Development is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 39 lectures • 08:22:00 total length •Module 01: Introduction: 00:01:00 •Module 02: Tools for this Course: 00:03:00 •Module 01: HTML Introduction: 00:16:00 •Module 02: CSS and CSS Selectors: 00:17:00 •Module 03: CSS Box Model: 00:11:00 •Module 04: CSS Layout Flexbox and Grid: 00:18:00 •Module 05: CSS Responsive Design Concept: 00:06:00 •Module 01: Data Types and Operations: 00:34:00 •Module 02: Functions: 00:13:00 •Module 03: Conditions and Loops: 00:19:00 •Module 04: Promise and Async await: 00:16:00 •Module 05: Events: 00:08:00 •Module 01: Load UI5 Libraries: 00:17:00 •Module 02: Views and Controllers: 00:27:00 •Module 03: Component and Descriptor: 00:12:00 •Module 04: JSON Model and Data Binding: 00:14:00 •Module 05: Layout: 00:14:00 •Module 06: Data Format and Icons: 00:14:00 •Module 07: MVC in UI5: 00:05:00 •Module 01: SAP Web IDE and SAP Fiori Launchpad Introduction: 00:11:00 •Module 02: Migrate Project to SAP Web IDE: 00:17:00 •Module 03: Resource Model and Multi-language Support: 00:11:00 •Module 04: Fragments and Dialog: 00:20:00 •Module 05: Routing and Navigation: 00:23:00 •Module 06: Device API: 00:12:00 •Module 01: Use Rest API: 00:07:00 •Module 02: OData Service Introduction: 00:12:00 •Module 03: Use OData Service V2: 00:14:00 •Module 04: Sort and Filter Data: 00:14:00 •Module 05: Create Update Delete Read with OData Service V2: 00:14:00 •Module 06: Use OData Service V4: 00:06:00 •Module 07: Create Update Delete and Auto Data Type Detection with OData Service V4: 00:13:00 •Module 08: Action and Function Binding in OData Service V4: 00:08:00 •Module 09: Troubleshooting: 00:11:00 •Module 01: SAP Fiori Launchpad Core Concept: 00:06:00 •Module 02: Deploy to SAP Cloud Platform: 00:12:00 •Module 03: Deploy to SAP Gateway System: 00:22:00 •Module 04: Deploy to non-SAP Environment: 00:04:00 •Assignment - Complete SAP UI5 Development: 00:00:00

Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00

Overview Learn to use the full power and functionality of Microsoft's Excel and deliver impressive charts and analysis work. This Advanced Diploma in MS Excel course allows you to exploit the full abilities of Microsoft's best-selling tool and become capable of providing higher-quality results from it. You may use Excel every day in your work or business, but are you really using it to its full potential? With the advanced training from this course, you will quickly produce stunning spreadsheets and visually perfect graphs that will showcase business data to a much more professional degree. Use Excel to make your customer service excellent. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Advanced Diploma in MS Excel. It is available to all students, of all academic backgrounds. Requirements Our Advanced Diploma in MS Excel 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 21 sections • 90 lectures • 22:14:00 total length •Introduction to Microsoft Excel 2019 New Features: 00:07:00 •CONCAT: 00:02:00 •IFS: 00:01:00 •MAXIFS: 00:01:00 •MINIFS: 00:01:00 •SWITCH: 00:02:00 •TEXTJOIN: 00:01:00 •Map Chart: 00:02:00 •Funnel Chart: 00:01:00 •Better Visuals: 00:06:00 •Pivot Table Enhancements: 00:02:00 •Power Pivot Updates: 00:01:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Work with Ranges: 00:18:00 •Use Specialized Functions: 00:11:00 •Work with Logical Functions: 00:23:00 •Work with Date & Time Functions: 00:08:00 •Work with Text Functions: 00:11:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Collaborate on a Workbook: 00:19:00 •Protect Worksheets and Workbooks: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00 •Create a Macro Using the Macro Recorder: 01:00:00 •Edit a Macro: 01:00:00 •Debug a Macro: 00:30:00 •Customize the Quick Access Toolbar and Hotkeys: 00:30:00 •Set Macro Security: 01:00:00 •Insert Text: 00:30:00 •Format Text: 00:30:00 •Sort Data: 00:30:00 •Duplicate Data: 01:00:00 •Generate a Report: 01:00:00 •Determine the Dialog Box Type: 00:15:00 •Capture User Input: 01:00:00 •Insert, Copy, and Delete Worksheets: 00:30:00 •Rename Worksheets: 00:30:00 •Modify the Order of Worksheets: 00:15:00 •Print Worksheets: 00:30:00 •Create User-Defined Functions: 00:30:00 •Automate SUM Functions: 00:30:00 •Resources - Microsoft Excel - Beginner Course - Cpd Accredited: 00:00:00 •Assignment - Advanced Diploma in MS Excel: 00:05:00