SQL courses in London

IT Cyber Security Engineer – Job Ready Programme Enrol in Our IT Cyber Security Engineer – Job Ready Programme with Career Support! Gain access to 3,000+ online courses and earn Free Certificates to showcase your skills and boost your career potential. Step into the high-demand world of cyber security with a comprehensive programme designed for the UK job market. Master critical areas like penetration testing, secure cloud architecture, AI-powered threat detection, and GDPR compliance—skills that can lead to roles earning up to £95,000 a year. As UK businesses face £27 billion in cybercrime losses annually, the demand for skilled IT Cyber Security Engineers has never been greater. Whether you're changing careers or upskilling, this course equips you with in-demand expertise in threat intelligence, cryptography, and secure coding. Become the digital defence every company needs. Start your journey toward a resilient and rewarding career in cyber security today. Professional Diploma in IT Cyber Security Engineer – 25 Core Courses – Course 01: Cyber Security Online Course: DOSS and DDOS – Course 02: Cyber Security Training: Incident Handling & Response – Course 03: Security Threat Management – Course 04: Certified Information Security Manager (CISM) – Course 05: Certified Information Systems Security Professional (CISSP) – Course 06: CompTIA Advanced Security Practitioner (CASP) – Course 07: Computer Network Security Complete Training – Course 08: CyberSec First Responder: Threat Detection and Response [QLS Level 7] – Course 09: Bash Scripting and Shell Programming for Beginners – Course 10: Ethical Hacking Masterclass – Course 11: CompTIA PenTest+ Ethical Hacking Course – Course 12: BlackArch Linux: Ethical Hacking and Penetration Testing – Course 13: Ultimate Linux Security and Hardening Training – Course 14: The Complete Python Hacking Course: Beginner to Advanced! – Course 15: SQL Database Basics – Course 16: CompTIA Network+ Certification (N10-008) – Course 17: CompTIA A+ Core 1 (220-1101) Course – Course 18: CompTIA A+ Core 2 (220-1102) Course – Course 19: CompTIA Security+ (SY0-601) – Course 20: CompTIA Cloud+ CV0-002 Course – Course 21: Cisco CCENT/CCNA Interconnecting Cisco Networking Devices Part 1 – Course 22: Cisco CCNA Interconnecting Cisco Networking Devices Part 2 (ICND2) Training – Course 23: Cisco ASA Firewall Training with Step-by-Step Lab Workbook – Course 24: FortiGate Firewall Training Step-by-Step Lab Workbook – Course 25: Palo Alto Firewall Training with Step-by-Step Lab Workbook Job Readiness & Career Development Training (Complementary) – Course 01: Career Development Training – Course 02: Effective CV Writing – Course 03: CV Writing and Interview Tricks – Course 04: Ace the Interview – Interview Prep That Makes a Difference – Course 05: Job Search Skills – Course 06: Effective Communication Skills for Professionals – Course 07: Boost Your Confidence, Assertiveness – Course 08: Body Language Secrets – Course 09: Coaching and Mentoring – Course 10: Presentation Skills – Present like a Pro – Course 11: Public Speaking Course – Course 12: Project Management Training – Course 13: Leadership & Management – Course 14: Negotiation and Agreement Training – Course 15: Workplace Equality & Diversity – Course 16: Professional Development and Personal Well-being – Course 17: Emotional Intelligence and Human Behaviour – Course 18: Time Management: Step By Step Training – Course 19: Cross-Cultural Awareness – Course 20: Productivity Boosting – Course 21: Critical Thinking & Problem Solving – Course 22: Perfect LinkedIn Profile Creation – Course 23: Resume Writing Skills & Job Search With LinkedIn – Course 24: Email Writing – Course 25: Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!

Understanding databases and SQL

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.

In this comprehensive course, you will learn everything you need to know about SQL and Microsoft SQL Server, from the basic to advanced topics. With easy-to-follow lessons and hands-on exercises, you will gain the skills and confidence to work with databases like a pro. Perfect for beginners and anyone looking to expand their data management skills.

This course introduces you to SQL and Microsoft SQL Server in a practical way. You'll be able to learn the basics of SQL quickly and understand how to use SQL queries and statements with Microsoft SQL Server to extract data and analyze it for making productive marketing decisions.

Discover the latest advancements and features in SQL 2021, the powerful database management system. Stay ahead with enhanced performance, security, and functionality for your data management needs.

Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.