551 SQL courses in London delivered On Demand

Description Our Microsoft Access course is designed to take your skills from basic to advanced level. Gain knowledge about Microsoft access from scratch to the advanced level. Learn step by step how to use Microsoft Access as professional. Whether new to Microsoft Access or looking forward to enhancing your current skills using this program, then you have selected the right course. Explore the functions various and features of Microsoft Access. In this course you will learn the necessary skills, knowledge and information of Microsoft Access.  Who is this course for? This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Access. Project-based technical analysts and engineers. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Level 3 Diploma in Microsoft Access 2010 will be very beneficial and helpful, especially to the following professionals: Software Engineer. Technical Support. Technical Sales. Business Analyst. Web Developer. Software Tester. Microsoft Access 2010 for Beginners Module One - Getting Started 00:30:00 Module Two - Getting Started With Access 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access 2010 for Beginners 00:00:00 Microsoft Access 2010 for Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with the Access Environment 01:00:00 Module Three - Working with Access Options (I) 01:00:00 Module Four - Working with Access Options (II) 01:00:00 Module Five - Working with Tables 01:00:00 Module Six - Importing Table Data 01:00:00 Module Seven - Working with Queries (I) 01:00:00 Module Eight - Working with Queries (II) 01:00:00 Module Nine - Working with Forms 01:00:00 Module Ten - Using Reports 01:00:00 Module Eleven - Using Macros and Code 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access 2010 for Intermediate Level 00:00:00 Microsoft Access 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - Advanced Table Tasks 01:00:00 Module Three - Advanced Form Tasks 01:00:00 Module Four - Advanced Reporting Tasks 01:00:00 Module Five - Understanding Relationships 01:00:00 Module Six - Advanced Query Tasks 01:00:00 Module Seven - Working with SQL 01:00:00 Module Eight - Linking Data 01:00:00 Module Nine - Importing Data 01:00:00 Module Ten - Exporting Data 01:00:00 Module Eleven - Advanced Database Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Overview Course Overview 00:04:00 Building Your Virtual Lab Environment Video - Downloading ISO and OVA Fles for VirtualBox 00:08:00 Video and lab - Creating a Virtual install of Kali using VirtualBox 00:12:00 Video and Lab - Creating a Virtual Install of CSI Linux 2021.2 00:12:00 Video and lab - Creating an Unattended Virtual Install of XP Using Virtualbox 00:08:00 Video - Installing the VirtualBox Extension pack 00:02:00 Video - Taking a Snapshot of Your Current Configuration 00:04:00 Passive Reconnaissance Video and Lab - Gathering Information Using Maltego 00:09:00 Video and Lab - Gathering Information Using CSI Linux Investigator 00:08:00 Video and Lab - Preparing CSI Linux to Use Shodan 00:05:00 Video and Lab - Using Shodan to Find Vulnerable Devices 00:16:00 Nmap Video and Lab - Introduction to NMap 00:17:00 Video and lab - NMap Scripting Engine (NSE) 00:19:00 Video and lab - Scanning for WannaCry Ransomware 00:14:00 Scanning for Vulnerabilities Using Nessus Video and Lab - Installing NESSUS Using Docker 00:11:00 Video and lab - Scanning for Vulnerabilities Using Nessus 00:10:00 Video - Using Your Nessus Scan Results 00:12:00 Scanning for Vulnerabilities Using OpenVAS Video and Lab - Installing OpenVAS Using Docker 00:09:00 Video and Lab - Scanning for Vulnerabilities Using OpenVAS 00:10:00 Exploiting Microsoft Windows Video and Lab- Using Metasploit to Launch a DOS Attack Against Windows XP 00:09:00 Video and Lab - Establishing A VNC Shell Using Meterpreter 00:18:00 Video and Lab - Using Meterpreter to backdoor Windows XP 00:11:00 Exploiting Linux Video and lab - Installing Metasploitable2 Using VirtualBox 00:10:00 Social Engineering Video and Lab - Using the Social Engineering Toolkit (SET) 00:07:00 BASH Scripting for Pentesters Video and Lab - Introduction to BASH Scripting 00:08:00 Video and Lab - Creating a BASH Script for Scanning Vulnerable Ports 00:16:00 Video and Lab - Password Cracking Using Medusa 00:06:00 Video and Lab - Passwords Cracking Using Mimikatz 00:11:00 Pentesting Wireless Networks Video and Lab - Installing a Wireless Adapter in Kali 00:09:00 Video and Lab - Hacking a Wireless Network Using Kali Linux 00:14:00 Wireless Deauthentication Attack 00:06:00 PMKID Client-less Wireless Attack Using Bettercap 00:10:00 Web Based Application Attacks Video and Lab - Installing w3af in Kali Linux Using Docker 00:13:00 Video and Lab - Conducting A Website Vulnerability Scan Using w3af 00:05:00 Video and Lab - Performing a Browser Based Attack 00:12:00 Video and lab - SQL Injection Attack Using SQLmap 00:12:00 Browser Exploitation Framework (BeEF) Video - Configure Kali for Exploitation the WAN 00:16:00 Video and lab - The Browser Exploitation Framework (BeEF) 00:19:00 Remaining anonymous Video and Lab - Anonymize Kali Using Whonix 00:10:00 Capture The Flag Walkthrough - Mr. Robot Video Walk Through -Key #1 00:13:00 Video Walk through - Key #2 00:19:00 Video Walk Through - Key #3 00:08:00 Capture The Flag Walkthrough - Stapler Video - Capture the Flag - Stapler Part 1 00:18:00 Video - Capture the Flag - Stapler Part 2 00:17:00 Video - Capture the Flag - Stapler Part 3 00:17:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Data doesn’t lie—but interpreting it well takes skill. This Data Science 8-in-1 Premium Courses Bundle offers structured guidance on handling, visualising, and interpreting data using industry-relevant tools like Excel, Power BI, SQL, and Python. Whether you’re a curious beginner or improving your analytics know-how, this course is built to speak your language (and code). It doesn’t stop at software either—you’ll also explore communication, GDPR considerations, and how to share findings clearly. No fluff, no mystery—just data done properly, and explained in plain terms. Ideal for those who like facts with fewer frills. Learning Outcomes: Analyse data using Python, Excel, and Power BI. Write and interpret basic SQL queries and statements. Apply data protection rules in line with GDPR principles. Communicate data insights clearly and without jargon. Build simple dashboards and reports from datasets. Understand basic structures in data science pipelines. Who is this Course For: Beginners exploring data science tools and concepts. Admins handling spreadsheets and databases daily. Analysts wanting to refresh their data software skills. IT staff supporting data-driven teams or processes. Career changers moving into technical data fields. Business professionals working with reports and metrics. Entrepreneurs reviewing sales, traffic, or operations data. Students building a portfolio of software-based data skills. Career Path: Junior Data Analyst – £28,000–£35,000 per year Business Intelligence Assistant – £30,000–£40,000 per year SQL Analyst – £32,000–£42,000 per year Excel Reporting Specialist – £25,000–£34,000 per year Python Developer (Data Focus) – £35,000–£48,000 per year Power BI Technician – £30,000–£45,000 per year

This course will help you become familiar with the implementation of creational design patterns. Featuring real-world examples written in modern C++, each pattern is explained in detail to help you to understand how the pattern can be implemented efficiently using language features.

If data had a fan club, analysts would be the VIP members. This 8-in-1 online bundle offers a structured dive into the data world—from input to insight. With modules in SQL, Python, Microsoft Access, Tableau, Google Analytics, and more, it covers the tools that analysts actually use when trying to make sense of endless spreadsheets. You’ll start with data entry foundations and move through analysis techniques, database management, and visualisation. The goal? To help you read, question, and communicate data without turning it into a maths lesson. Whether you’re new to analytics or brushing up on tools, this bundle is here to turn data into something slightly more interesting than... well, a spreadsheet. 🎯 Learning Outcomes: Understand core data analysis methods across common tools. Learn SQL for querying and managing structured data sets. Apply Python for basic data organisation and automation. Use Tableau and Google tools for visual data presentation. Gain data entry and database management understanding. Analyse online performance through Google Analytics platforms. 👤 Who is this Course For: Aspiring data analysts building core tool knowledge. Marketing professionals interested in online performance stats. Admins needing database and data entry foundations. Junior developers exploring data-related workstreams. Business analysts reviewing structured analysis methods. Freelancers handling data-heavy client tasks. Entrepreneurs reviewing user behaviour via Google tools. Graduates seeking online data training for job roles. 💼 Career Path (UK Average Salaries): Data Analyst – £38,000 per year Business Intelligence Analyst – £42,000 per year Data Entry Administrator – £24,000 per year SQL Analyst – £40,000 per year Marketing Data Analyst – £36,000 per year Analytics Coordinator – £34,000 per year

This course will walk you through a whole real-world scenario for developing and deploying an ecommerce website with Blazor, and we will tackle numerous obstacles along the way. You will learn how to create a .NET 6 API from scratch and deploy .NET API, Blazor WASM, and Server to Azure in this course.

Spreadsheet chaos? Sorted. This Microsoft Excel: 8 in 1 Premium Courses Bundle goes far beyond basic number crunching. You’ll explore not just Excel, but also the full Microsoft Office suite—Word, PowerPoint, Outlook, Access, Project—plus Power BI and SQL for those ready to flirt with data like it’s the office gossip. Whether you're spreadsheet shy or pivot table proud, this bundle keeps things tidy, stylish and fully functional. The content takes you through formulas, formatting, business reporting, data visualisation, and database management with clear, structured learning. No fluff, no filler—just focused skills that help you navigate office software with the confidence of someone who actually knows what they're doing. Upgrade your workflow one formula at a time. Learning Outcomes: Build and manage Excel spreadsheets with confidence and clarity. Create professional documents and reports using MS Word. Deliver sharp, engaging slides with MS PowerPoint tools. Handle email, tasks and calendars using MS Outlook efficiently. Analyse data using Power BI and basic SQL queries. Organise databases using Access and manage projects in MS Project. Who is this Course For: Professionals handling spreadsheets and reports on a regular basis. Office staff looking to improve Microsoft Office fluency. Admins managing communication, scheduling and document creation. Individuals working in finance, HR or operations roles. Data beginners who want to explore Power BI and SQL basics. Project coordinators managing deadlines and resource tracking. Job seekers looking to polish their office software knowledge. Anyone who thinks “VLOOKUP” sounds like tech wizardry. Career Path: Data Entry Clerk – £21,000 average salary Office Administrator – £24,500 average salary Business Analyst Assistant – £28,000 average salary Project Coordinator – £32,000 average salary Junior Data Analyst – £30,500 average salary Executive Assistant – £33,000 average salary

Description: The 70-246 - Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) course teaches you how to monitor and operate a private cloud with System Center 2012 R2. Throughout the course, you will learn the basics of the cloud, the ways of working with the business cloud, cloud services, monitoring and automating responses. The course will teach you how to handle problems in the Private Cloud, and the procedures of Service Management in the Private Cloud. You will also be introduced to cloud protection, recovery, compliance, the use of SLAs, Dashboards and Widgets. The course shows you the real-time state using Visio, system centre analytics, service level tracking, viewing SSRS and Excel to view data, PerformancePoint and configuring and deploying widgets and dashboards. Finally, you will learn cleaning up system centre databases systems. After completing the course, you will understand how Operations Manager handles monitoring, Service Manager and App Controller facilitate self-service, and Orchestrator glues everything together. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? 70-246 - Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-246 - Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. System Center 2012 What is System Center 2012 FREE 00:30:00 Introducing the Cloud Discussion of Cloud Computing 00:19:00 Important Requirements 00:07:00 Working with System Center and the Infrastructure 00:05:00 Maintaining the Cloud Health 00:05:00 How Components are Integrated 00:06:00 Are You in Compliance 00:05:00 Working with the Business Cloud Examining SC 2012 VMM 00:17:00 Working with VMs with the VMM 00:11:00 Creating Clouds for Business 00:16:00 Cloud Services Looking at Service Templates and VMM Profiles 00:22:00 Web Deploy Packages 00:08:00 Server App V Introduction 00:05:00 The Data of the N Tier Application 00:05:00 What's New with VMM R2 00:07:00 Importing and Deploying the Stock trader Application 00:10:00 Installing SQL Server 00:10:00 Monitoring Overview of Operations Manager 00:20:00 Customize the Monitoring Operations 00:09:00 Monitoring Application Performance 00:14:00 Advanced Monitoring 00:04:00 Using Operations Manager for Applications 00:04:00 Using Operations Manager for the Network 00:11:00 Using Operations Manager for Distributed Applications 00:07:00 What's New in Operations Manager 2012 R2 00:09:00 Deploying an Agent 00:09:00 Configuration for Custom Monitoring 00:11:00 Configuring Basic Monitoring and Application Perfomance 00:12:00 Installing Operations Manager 00:05:00 Automating Responses Looking at Orchestrator 2012 00:08:00 Putting Orchestrator, Operations Manager, and Service Manager Together 00:15:00 What's New with Orchestrator 2012 R2 00:04:00 Managing Problems in the Private Cloud What is Problem Management 00:07:00 Using Custom Rules 00:08:00 Service Management in the Private Cloud Service Manager Introduction 00:10:00 Security Settings 00:09:00 Work Items 00:08:00 Incident Queues and Service Offerings 00:03:00 What's New with Service Manager 2012 R2 00:01:00 Configuring the Incident Template 00:10:00 Cloud Protection, Recovery, and Compliance Protecting and Recovering Data for the Private Cloud 00:29:00 Data Recovery 00:15:00 Overview of the Process Pack for IT GRC 00:14:00 Installing the Process Pack for IT GRC 00:06:00 Implementing an IT GRC Control Management Program 00:06:00 How to Maintain Compliance Through VMM Security Baselines with System Center 00:06:00 What's New with DPM 2012 R2 Advisor 00:03:00 Configuring Manual Protection 00:06:00 SLAs, Dashboards and Widgets Configuring and Deploying Widgets and Dashboards 00:12:00 Real-Time State Using Visio 00:10:00 System Center Analytics 00:12:00 Service Level Tracking 00:05:00 Viewing SSRS and Excel to View Data 00:04:00 PerformancePoint 00:04:00 Cleaning Up System Center Databases Service Manager Groom Settings 00:08:00 View and Purge Orchestrator Runbook Logs 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Are you interested in learning and deploying applications at scale using Google Cloud platform? Do you lack hands-on exposure when it comes to deploying applications and seeing them in action? Then this course is for you. You will also learn microservices and event-driven architectures with real-world use case implementations.

The Data Science (Business and Management) Mini Bundle offers a clever mix of technical and soft skills. You’ll explore core data topics like analysis, Python programming, and SQL—paired with public speaking and communication skills that actually help you talk to people about all that data. This isn’t just about numbers—it’s about knowing what to say when someone asks, “What do these numbers mean?” Whether you’re presenting to a team or querying a database, this course helps you communicate with confidence and clarity while building your technical toolkit for business roles. Learning Outcomes: Analyse datasets using structured, goal-based methods. Write Python code to organise, clean and process information. Understand SQL queries to access and filter relevant data. Present findings clearly using confident verbal communication. Improve workplace discussions through stronger communication habits. Combine data insights with thoughtful business reasoning. Who Is This Course For: Data beginners looking to speak clearly in business meetings. Business analysts needing stronger coding and tech fluency. Professionals handling large datasets and regular reports. Team members presenting technical updates or data reviews. Career changers entering data-focused business environments. Admins juggling between spreadsheets and project discussions. Managers wanting a sharper grasp on data and delivery. Curious learners improving both tech skills and communication. Career Path: Business Analyst – £42,000/year Data Communications Officer – £36,000/year Business Intelligence Assistant – £38,000/year SQL Analyst – £40,000/year Python Data Assistant – £39,000/year Public Speaking Coach (Business Focus) – £34,000/year