Search icon

Master data management with SQL. Learn from experts to write queries, enhance database handling and boost analytical skills to professional data analyst and developer standards.

2 day course     10am - 5pm     Live Online or Classroom-based

What you will learn

  • Exploring the database design system known as SQL.
  • How to use SQL to improve business workflows and output.
  • Understanding the use of SQL to improve website output and end user satisfaction.
  • How to manipulate customer databases for effective SEO.
  • Exploring tools to build better client relationships, improving customer communication.
  • How to write code for an SEO database using PHP and SQL.
  • Understanding best practice SEO techniques and design skills.

We can tailor this course to you

If you have specific requirements, talk to us about customising this course to meet your exact needs.

  • Thanks so much for the invaluable training I received on Premiere Pro. I really enjoyed the two days and learnt a lot. I'm excited to create my own videos using all the skills and techniques taught!

    MAF UK
    September 2026
  • Just dropping a line to thank you, our trainer and the team for the great Figma course delivered over the past couple of days.

    Marcos A
    September 2026
  • Probably the best course I have been on. Very thorough and entertaining.

    Cancer Research UK
    August 2026
  • Thanks again for the session last week. I've received more glowing feedback about how inspired and engaged the team felt.

    Molson Coors
    September 2026
  • I have been very impressed with the trainer and I thought the course was very good.

    Leaders Roman Group
    September 2026
  • The venue was immaculate and Lee's tutoring was very comfortable and informative! We really enjoyed it and can't wait to start using what we learnt.

    William Bowerman
    October 2026
  • As someone who has attended three courses now with Transmedia, I have always come away feeling more confident and knowledgeable. Lee happily recaps on any content students are unsure of. Thank you!

    Ministry Of Defence
    October 2026
  • I found it so easy to understand and it was so beneficial. The way our trainer went through everything made the course so easy to pick up and absorb all of the handy tricks and information.

    Wren Kitchens
    September 2026
  • Our trainer was incredible at delivering really valuable content that has inspired conversation and ideas about how we can use Figma. Please thank him for sharing so many useful tips and tricks!

    Cancer Research UK
    October 2026
  • We did the intermediate Photoshop course and it was amazing! I learned so much and the teacher even took into account what we needed Photoshop for, to put the lessons into context. Highly recommended.

    Future PLC
    August 2026
  • I wanted to say thank you to you and our trainer for another great Figma training session last Friday! The SEs learned a lot and enjoyed all the tips and tricks that he kindly provided.

    Salesforce
    July 2026
  • We all really enjoyed the two days training. Please thank our trainer as we all had a great time. We spent yesterday trying to get our heads around the Auto-Layout - I think we are getting there!

    LTE Group
    November 2026
  • A huge thank you to the whole team at Transmedia - everyone we dealt with was extremely helpful and highly responsive with any queries we had. We felt like we were in safe hands from start to finish.

    Cambridge University Press
    November 2026
  • The trainer's knowledge of the program was amazing.

    Hastoe Housing
    November 2026
  • A very well conducted 2-day Figma session. Trainer was great at explaining and simplifying the software and gave us time to try things out and ask questions. I had a lot of fun learning something new!

    Norwich University of the Arts
    September 2026
  • Thanks so much for the invaluable training I received on Premiere Pro. I really enjoyed the two days and learnt a lot. I'm excited to create my own videos using all the skills and techniques taught!

    MAF UK
    September 2026
  • Just dropping a line to thank you, our trainer and the team for the great Figma course delivered over the past couple of days.

    Marcos A
    September 2026
  • Probably the best course I have been on. Very thorough and entertaining.

    Cancer Research UK
    August 2026
  • Thanks again for the session last week. I've received more glowing feedback about how inspired and engaged the team felt.

    Molson Coors
    September 2026
  • I have been very impressed with the trainer and I thought the course was very good.

    Leaders Roman Group
    September 2026
  • The venue was immaculate and Lee's tutoring was very comfortable and informative! We really enjoyed it and can't wait to start using what we learnt.

    William Bowerman
    October 2026
  • As someone who has attended three courses now with Transmedia, I have always come away feeling more confident and knowledgeable. Lee happily recaps on any content students are unsure of. Thank you!

    Ministry Of Defence
    October 2026
  • I found it so easy to understand and it was so beneficial. The way our trainer went through everything made the course so easy to pick up and absorb all of the handy tricks and information.

    Wren Kitchens
    September 2026
  • Our trainer was incredible at delivering really valuable content that has inspired conversation and ideas about how we can use Figma. Please thank him for sharing so many useful tips and tricks!

    Cancer Research UK
    October 2026
  • We did the intermediate Photoshop course and it was amazing! I learned so much and the teacher even took into account what we needed Photoshop for, to put the lessons into context. Highly recommended.

    Future PLC
    August 2026
  • I wanted to say thank you to you and our trainer for another great Figma training session last Friday! The SEs learned a lot and enjoyed all the tips and tricks that he kindly provided.

    Salesforce
    July 2026
  • We all really enjoyed the two days training. Please thank our trainer as we all had a great time. We spent yesterday trying to get our heads around the Auto-Layout - I think we are getting there!

    LTE Group
    November 2026
  • A huge thank you to the whole team at Transmedia - everyone we dealt with was extremely helpful and highly responsive with any queries we had. We felt like we were in safe hands from start to finish.

    Cambridge University Press
    November 2026
  • The trainer's knowledge of the program was amazing.

    Hastoe Housing
    November 2026
  • A very well conducted 2-day Figma session. Trainer was great at explaining and simplifying the software and gave us time to try things out and ask questions. I had a lot of fun learning something new!

    Norwich University of the Arts
    September 2026

This SQL Introduction course includes

  • bullet point icon Authorised Certificate
  • bullet point icon Lifetime support after your course
  • bullet point icon Course materials
  • bullet point icon Live Instructor-led training
  • bullet point icon Refreshments all day
  • bullet point icon Latest Mac or PC ready to go
  • bullet point icon Authorised Trainers
  • bullet point icon Hands-on exercises

Book this course

We offer SQL Introduction as a private course.

You can select a date which suits you or your team.

The course content can be fully customised to your exact learning requirements.

Request dates

Video success stories

Adobe Max
Adobe Carlo
NHM Emma
Roze and Erin
Adobe Quintijn
Zahra from The Hoffman Agency
Elena
Adobe Claudia
Amari doing Illustrator
Sage Francesca
Adobe Rishi
James from Digital Catapult
Annetta from The University of Westminster
Sage Filming with a Smartphone
Josie and Vanessa
Adobe Sven and Stephane
Adobe Lemeeka
Ellie from Sportd Industry Group
Exeter University Gloria
Danielle
Julia from Letters by Julia

Course Outline for SQL Introduction

Introducing Fast Track to SQL

  • Understanding course prerequisites
  • Using the course format
  • Browsing the course outline

Introduction to Relational Databases

  • Define relational database/terms used in relational database design/ basic concepts of relational technology
  • Understand why duplicate data is bad and hard to manage
  • Contrast data architectures
  • Logical vs. Physical Data Modelling
  • Understand Entity/Relationship diagrams
  • Describe the basics of normalization

Selecting Data

  • Overview of SQL Viewer
  • Using the basic SELECT statement
  • Using a column wildcard
  • Using owner and table prefixes
  • Specifying textual vs numeric data types
  • Filtering rows with the WHERE clause
  • Using comparison operators: =,<, >, and <>
  • Using Null/Nulls and inequality
  • Using compound WHERE clauses with AND and OR
  • Using IN and NOT IN to shorten SQL queries
  • Using LIKE for partial pattern matching

Creating JOIN statements

  • Describe join types
  • Creating recordsets from multiiple tables using an inner join
  • Using primary and foreign keys in performing joins/filters with joins
  • Joining tables using ANSI-92 syntax
  • Joining 3 or more tables in a single statement

Changing database contents with INSERT, UPDATE and DELETE

  • Adding data to tables with the INSERT statement
  • Introducing the UPDATE statement
  • Using the DELETE statement/a filter
  • Flagging records deleted as an alternative

Enhancing SELECT statements

  • Ordering data
  • Expressions in SELECT
  • Renaming tables/columns with aliases
  • Selecting computed columns
  • Character strings in queries
  • Aggregating values
  • Getting row counts
  • Minimum and maximum in a column:
  • MIN() and MAX()
  • Average and sum of a column: AVG() and SUM()
  • Grouping query results with GROUP BY clause/Grouping data
  • Other Aggregates such as COUNT()
  • Using positional notation in GROUP BY and the HAVING clause

Connecting to a RDBMS

  • Understand the Client/Server model for databases
  • Basic concept of database users and permissions
  • Discuss how database drivers work
  • Creating an ODBC Data source
  • Comparing performance (Access and MSDE)
  • Query Painters

Introduction to Stored Procedures

  • Description of stored procedures
  • Benefits of stored procedures
  • Incorporating procedural logic into stored procedures
  • Examples of stored procedures for SQL Server and Oracle

Strategies for Web Database Access

  • Understand limitations of the Web environment
  • Discuss strategies for limiting data
  • Next-n interfaces
  • Limiting to n rows returned
  • Performing dynamic searches
  • Increasing selectivity using search criteria
Show more

FAQs about the SQL Introduction course

Will I receive a certificate upon completion of my SQL Introduction course?

Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our SQL Introduction course. Our certificates note our Authorised Training Centre status.

Is this SQL Introduction course suitable for me?

This course is designed for people who are new to SQL or have been using SQL for a while but have never had formal training or who would like to learn best practice in SQL. If you are have any questions about whether the course could meet your needs, please speak to our customer service team, who will be delighted to advise you.

How is the content taught throughout the SQL Introduction course?

Our SQL Introduction course is extremely interactive. You will be using SQL throughout the day, working through examples and live projects under the guidance of our trainer, who will be supporting you through each step.

What is the recommended number of people for the class when I attend the SQL Introduction course?

For private classes in SQL Introduction, we recommend a maximum of 8 to 10 people from the same company in the class. Please ask our customer service team to help you find the right balance of people per class and the number of days training you need.

Should I attend the SQL Introduction course in person or live online?

For in-person courses at our London training centre, you will receive a warm personal welcome, your choice of the latest Mac or PC and morning and afternoon refreshments. If you prefer to attend remotely, rest assured that you will be taught live by the same experts that deliver our in-person courses, covering the same training content, using the same exercises and materials. A second monitor is recommended but not essential.

What support is available after I attend the SQL Introduction course?

We offer ongoing support to our SQL Introduction course attendees through email and by arrangement, phone calls. You are welcome to ask any questions on topics covered during training. Our trainer will always do their best to explain principles and help you with any issues you encounter.

SQL Introduction — Team and Bespoke Training

Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.

  • Sessions can be run online or in person, on your site or at our London training centre.
  • We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
  • Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
  • We offer a free consultation service to work out every detail of your course.

Private One-to-One Training

One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.

Book Now

Team Training for Companies

Group bookings provide you with the most cost-effective way to train your team.


Book Now

Our Clients

dyson logo five cowries logo british library logo s4c logo wcrf logo clarks logo rapha logo banking standards board logo apollo tyres logo natural history museum logo university of oxford logo usaid logo hsbc logo hiscox logo formula 1 logo hmpps logo game of thrones logo university of cambridge logo bbc logo victoria and albert museum logo nhs logo raf logo

Latest Blog Articles

Why Transmedia?

Icon of an activity line

Unlimited Training Support

We offer unlimited training support after your course.

Icon of an activity line

Bespoke Training Solutions

Customised training and software solutions based on your exact requirements.

Icon of an activity line

Worldwide Creative Skills Training

Join our authorised training courses live online from anywhere in the world.

Icon of an activity line

Authorised Training Professionals

Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.