4176 Computing courses in Westergate delivered On Demand

Data speaks volumes—if you know how to listen. This course offers a clever route into the world of MySQL, showing you how structured data can turn into smart decisions. Whether you're sifting through figures, building dashboards, or deciphering patterns, understanding SQL isn’t just helpful—it’s essential. You’ll be guided through the foundations of MySQL with clarity and precision, making sense of tables, queries, joins, and more—all without the fluff or confusion. Designed with the analytical mind in focus, this course shines a light on how MySQL powers insights behind the scenes in data science and analytics. It's tailored for learners who prefer clarity over jargon and structure over noise. If you're curious about how databases work and how data fuels smart outcomes, this course is your ideal stepping stone—organised, engaging and purposefully built for those who appreciate logic and clean learning paths. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Section 01: Getting Started Introduction How to get course requirements Getting started on Windows, Linux or Mac How to ask great questions FAQ's What is Source Code? Section 02: SQL Server setting up Section Introduction MySQL Server Installation Connect MySQL Server Instance MySQL Workbench overview Download and Restore Sample Database Section 03: SQL Database basics Section Introduction Overview of Databases Creating Database SQL Data Types Column Data Types on Workbench Creating Table Overview of Primary and Foreign Key Primary Key Foreign Key Creating Temporary tables EER - Enhanced Entity Relationship Diagrams Section 04: SQL DML (Data Manipulation Language) Section Introduction Insert statement Update statement Delete statement Section 05: SQL DDL (Data Definition Language) Section Introduction CREATE table statement DROP statement ALTER statement TRUNCATE statement COMMENT in query RENAME table Section 06: SQL DCL (Data Control Language) Create Database user GRANT permissions REVOKE permissions Section 07: SQL Statement Basic Section Introduction SQL Statement basic SELECT Statement SELECT DISTINCT SELECT with column headings Column AS statement DASHBOARD Analytics Section 08: Filtering Data rows SELECT WHERE Clause - theory SELECT WHERE Clause - practical Section 09: Aggregate functions for Data Analysis Sum() Min()-Max() Section 10: SQL Data Analyticstatements Order By statement SELECT TOP 3 records BETWEEN command IN operator Search Data usingLIKE cards Section 11: SQL Group by statement Section Introduction Group by - theory Data Analytics with Group By HAVING statement Section 12: JOINS Overview of Joins What are Joins Inner join Left outer join Right outer join Union CERTESIAN Product or Cross Join Query Exercise Solution for Query Exercise Section 13: SQL Constraints Section introduction Check constraint NOT NULL constraint UNIQUE constraint Section 14: Views Creating Views Data Analytic Viewsfrom multiple tables Section 15: Advanced SQL Functions Section Introduction Timestamp Extract from timestamp Mathematical scalar functions String functions Advanced functions Sub Queries SELECT with calculations Section 16: SQL Stored procedures Create stored procedure Stored procedure with parameter Drop Procedure Section 17: Import & Export data Section Introduction Import .csv file Export Data to .csv file Section 18: Backup and Restore Database Section Introduction Creating Database backup Restoring Database backup Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Learn MySQL from Scratch for Data Science and Analytics course is open to all, with no formal entry requirements. Career path Upon successful completion of The Learn MySQL from Scratch for Data Science and Analytics Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Step into the world of IT Asset Management (ITAM) and elevate your skills. From establishing ITAM programs to mastering asset security and compliance, this course offers a comprehensive guide to managing IT assets effectively. Enhance your ITAM expertise today!

This course aims to teach you how to build a professional website with HTML, CSS, SaaS and NPM.

You will learn everything you need to know about JavaScript in this course.

Embark on an immersive Web Development journey with our comprehensive Level 5 course, focusing on HTML, CSS, and JavaScript. From setting up your environment to mastering advanced techniques and launching a live website, this course equips you with the skills to become a proficient web developer.

Advance your Java programming skills with our comprehensive course on Object-Oriented Programming. Dive into classes, methods, inheritance, polymorphism, and more, while mastering essential concepts like encapsulation and dependency injection. Perfect for developers looking to elevate their Java expertise.

Dive into JavaScript with a focus on data visualization. Master JavaScript fundamentals, control flow, error handling, and client-side validations. Create engaging visual representations using Google Chart. Perfect for anyone looking to combine coding skills with visual analytics.

Master the essentials of C++ programming with our beginner-friendly course. Learn from local setup to advanced functions, and embark on your journey in software development.

Overview This comprehensive course on Complete Web Application Penetration Testing & Security will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Web Application Penetration Testing & Security 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 Web Application Penetration Testing & Security. It is available to all students, of all academic backgrounds. Requirements Our Complete Web Application Penetration Testing & Security 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 12 sections • 60 lectures • 14:18:00 total length •About The Course: 00:03:00 •Web Attack Simulation Lab: 00:12:00 •Web application technologies 101 - PDF: 00:47:00 •HTTP Protocol Basics: 00:11:00 •Encoding Schemes: 00:13:00 •Same Origin Policy - SOP: 00:06:00 •HTTP Cookies: 00:11:00 •Cross-origin resource sharing: 00:05:00 •Web application proxy - Burp suite: 00:09:00 •Fingerprinting web server: 00:05:00 •DNS Analysis - Enumerating subdomains: 00:04:00 •Metasploit for web application attacks: 00:12:00 •Web technologies analysis in real time: 00:03:00 •Outdated web application to server takeover: 00:08:00 •BruteForcing Web applications: 00:06:00 •Shodan HQ: 00:07:00 •Harvesting the data: 00:05:00 •Finding link of target with Maltego CE: 00:09:00 •Cross Site Scripting- XSS - PDF: 00:34:00 •Cross site scripting: 00:07:00 •Reflected XSS: 00:14:00 •Persistent XSS: 00:11:00 •DOM-based XSS: 00:10:00 •Website defacement through XSS: 00:09:00 •XML Documents & database: 00:14:00 •Generating XSS attack payloads: 00:13:00 •XSS in PHP, ASP & JS Code review: 00:13:00 •Cookie stealing through XSS: 00:12:00 •Advanced XSS phishing attacks: 00:08:00 •Advanced XSS with BeEF attacks: 00:10:00 •Advanced XSS attacks with Burp suite: 00:08:00 •Code Review Guide: 03:11:00 •SQL Injection attacks - PDF: 00:45:00 •Introduction to SQL Injection: 00:16:00 •Dangers of SQL Injection: 00:05:00 •Hunting for SQL Injection vulnerabilities: 00:20:00 •In-band SQL Injection attacks: 00:27:00 •Blind SQL Injection attack in-action: 00:10:00 •Exploiting SQL injection - SQLMap: 00:09:00 •Fuzzing for SQL Injection - Burp Intruder: 00:14:00 •CSRF or XSRF attack methods: 00:12:00 •Anti-CSRF Token methods: 00:15:00 •Anti-CSRF token stealing-NOT easy: 00:11:00 •Authentication bypass-hydra: 00:11:00 •HTTP Verb Tampering: 00:09:00 •HTTP parameter pollution - HPP: 00:06:00 •Authentication: 00:10:00 •Client side control bypass: 00:10:00 •LFI & RFI attacks: 00:13:00 •Unrestricted file upload - content type: 00:06:00 •Unrestricted File Upload - Extension Type: 00:06:00 •Remote code execution using Shell Uploads: 00:09:00 •XXE attacks in action: 00:14:00 •Advanced Intruder attack types: 00:23:00 •Cross window messaging: 00:02:00 •Defense in depth applied to web app: 00:02:00 •Drupagedden: 00:02:00 •Finding details with open source: 00:17:00 •Out of band XXE: 00:02:00 •Website auditing: 00:02:00

Overview This comprehensive course on ASP.Net MVC and Entity Framework will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This ASP.Net MVC and Entity Framework 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 ASP.Net MVC and Entity Framework. It is available to all students, of all academic backgrounds. Requirements Our ASP.Net MVC and Entity Framework 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 5 sections • 22 lectures • 06:17:00 total length •Module 01: Install Visual Studio Community Edition: 00:02:00 •Module 02: Create ASP.Net MVC Project: 00:04:00 •Module 03: Setup Database: 00:06:00 •Module 04: Add Entity Framework Data Model: 00:06:00 •Module 05: Tour of Folder Structure and How to Add Views: 00:23:00 •Module 06: Scaffolding: Adding Controller and Views: 00:35:00 •Module 07: Managing Database Changes: 00:14:00 •Module 08: Customizing a View - Bootstrap: 00:20:00 •Module 09: Customizing a View - Additional Data: 00:09:00 •Module 10: Add Data Validations to Forms: 00:31:00 •Module 01: Understanding Authentication Functionality: 00:05:00 •Module 02: Adding User Data Points: 00:30:00 •Module 03: Control User Access: 00:07:00 •Module 04: Adding Roles and Authorizations: 00:37:00 •Module 01: Add Project to GitHub: 00:12:00 •Module 02: Understanding Package Management: 00:08:00 •Module 01: Add Lecturer and Enrollment Management Modules: 00:14:00 •Module 02: Install JQueryUI Javascript Libraries: 00:12:00 •Module 03: Implement JQueryUI Autocomplete: 00:35:00 •Module 04: Create an JQuery/Ajax Form: 00:34:00 •Module 05: Partial View and Data Refresh: 00:33:00 •Resources - ASP.Net MVC and Entity Framework: 00:00:00