Back
Responsive image

SQL Intro | Training Course

Master the fundamentals of SQL to work with databases, tables, and queries.
Use SQL queries to gain insights into large datasets and make informed business decisions.

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

  Course Dates Venue   Price  
London Bridge £279 + VAT save £120
Online £249 + VAT save £150

SQL Intro | Training Course

Course Takeaways
Course Info

Course Offering

Course Takeaways
Takeaways

What will I learn?

  • SQL basics for database management
  • Creating and managing tables efficiently
  • Inserting, updating, and deleting data
  • Retrieving and sorting data effectively
  • Understanding table joins and aggregations
  • Free digital course assets
  • Free post-course helpdesk support
Course Takeaways
Learner Reviews

How good is the course?

  • Average Score 4.3 out of 5
  • Delicious lunch provided
  • Certificate of Achievement
  • 6 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
  • Python writing clean code
    Using Variables and Types
    String Manipulation
    Functions and Modules
    Handling exceptions

PHP Intro          

from £349 + VAT

2 day course
Learn the essentials of PHP to build dynamic web applications.

Master PHP basics and how it integrates with HTML and databases like MySQL.

  • How HTML and PHP work together
    Understand PHP syntax and variables
    Explore different datatypes in PHP
    Access server variables in PHP
    Connect and interact with databases using PHP

Google Analytics GA4 Intro

from £249 + 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
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1