An Introduction to SQL for Testers

WHEN

-

WHAT

99 Minute Workshop

WHERE

Online

COST

All our 99-minute workshops are included with a Pro membership.

A guide through the fundamentals of understanding and writing SQL

Topics Lee will cover

We'll explore the following topics

Read full session description ->
  • Write a SQL query joining multiple tables together.
  • Refine a SQL query using Where statements
  • Write a SQL query to select data from a table

Meet Your Instructor

Lee Marshall

Lee Marshall

PIRATE TESTER

A self-confessed pirate tester, Lee has been testing since 2012. Specialising in testing databases and reports, Lee also blogs, runs the MidsTest Meetup for the West Midlands. Outside of testing he is a husband, father, enjoys cooking and playing computer games.

Have you ever heard someone mention primary and foreign keys, but have no idea what hey are on about?

-

An introduction to SQL for testers

Lee
99 Minute Workshop
Lee Marshall

Have you ever wanted to view data in a database, but never known how?
Have you ever seen developer SQL code, but not known what it is doing?
Have you ever heard someone mention primary and foreign keys, but have no idea what hey are on about?

Then this workshop is for you.

I will guide you through how the fundamentals of understanding and writing SQL.
By the end of this workshop you will be able to write a basic query against a database, refining your results to show you the data you want, and connecting multiple tables together.

Takeaways

  • Write a SQL query joining multiple tables together.
  • Refine a SQL query using Where statements
  • Write a SQL query to select data from a table

Prerequisites

There are no pre-requisites for this workshop.

99 Minute Workshops

Short Digestable Live Online Workshops

Live and Instructor-led

All our 99-Minute Workshops are hosted live and led by an instructor.

Short and Targeted

These workshops are a max of two hours long which means they can easy be fit into your busy week. The short time also means they are targeted on a few learning outcomes.

Learn with Others

Connect and learn with other community members during these live online testing workshops.

Available with Pro Membership

All our 99-Minute Workshops are available with Pro Membership, you can attend as many as you like. We also do the odd free workshop with our partners.

All our 99-minute workshops are included with a Pro membership.

Frequently Asked Questions

Are the Workshops Recorded?

Our 99-minute workshpos are designed to be attended live. If you can’t make the scheduled time, it will stay available to replay in CrowdCast for 7 days. To get the most out of them, we highly recommend you attend them live.