Back
Responsive image

SQL Intro | Training Course

Use SQL queries to delve into large datasets.
Gain insights and make informed business decisions.

SQL EXPERTS | PROFESSIONAL TRAINING | SMALL COURSE SIZES | LONDON & ONLINE COURSES

  Course Dates Venue   Price  
Online £229 + VAT save £150
London Bridge £279 + VAT save £100

SQL Intro | Training Course

Course Takeaways
Course Info

Course Offering

Course Takeaways
Takeaways

What will I learn?

  • The basic concepts of SQL
  • Create and manage databases
  • Insert, update, and delete data
  • Retrieve data from MySQL tables
  • Join data from multiple tables
  • Free digital course assets
  • Free post-course helpdesk support
Course Takeaways
Learner Reviews

How good is the course?

  • New Course
  • No reviews yet
  • Delicious lunch provided
  • Certificate of Achievement
  • 0 reviews

Introduction to SQL and relational databases

• What is SQL?

• Overview of relational databases

• Using MySQL to create a database


Creating and Managing Databases and Tables

• Creating a database

• Creating a table

• Adding columns to a table

• Deleting a column

• Dropping a table


Inserting, Updating, and Deleting Data

• Inserting data into a table

• Updating data in a table

• Deleting data from a table

Retrieving Data from Tables

• Selecting data from a table

• Using wildcards in SELECT statements

• Using ORDER BY and LIMIT in SELECT statements

• Using GROUP BY and HAVING in SELECT statements


Joining Tables

• Inner joins

• Outer joins

• Self joins


Aggregation

• COUNT()

• SUM()

• AVG()

• MAX()

• MIN()


Questions & Answers

You Might Like These Too

Python Intro          

from £379 + VAT

2 day course
Learn the basics of programming with Python.

Take the first step towards becoming a developer in one of the most versatile and in-demand languages
  • Programming Basics
    Write Python Scripts
    Numerical Operations
    Create Functions
    Handle Errors

PHP Intro          

from £379 + VAT

2 day course
Learn the most popular web scripting language compatible with HTML and databases.

Perfect for anyone wanting to build dynamic web applications.

  • Understand the language
    Build dynamic websites
    Extract data from databases
    Embed directly into HTML
    Build applications

Google Analytics GA4 Intro

from £229 + VAT

1 day course
Master the new GA4 features to gain valuable marketing insights.

Make data-informed decisions to improve your digital marketing strategies.

  • The GA4 data model
    Tracking holistic digital space
    Primary metrics in GA4
    GA4 vs Universal Analytics
    Event tracking in GA4


"Excellent, relaxing learning environment. Trainer was very friendly and nice."
Genomics England
6th June - Minute Taking

Latest Reviews



"A really tailored training session with a trainer who listened and answered questions really well - superb"
Eastern Fostering Services
  • 5th June


"Rosie was superb ! Excellent facilitator with a personable touch. She explained everything clearly and so much learning was gained. Thank you."
Federated Hermes Ltd
  • 2nd June


"It was great - good content and trainer was flexible with our class. Good class size so the training was bespoke and we could ask role/ industry specific questions. Would definitely recommend."
Asante Capital Group
  • 30th May