Call us on  08000 199337 From overseas call +44 20 7264 2185

Software Testing Courses

Introduction to SQL for Testers

Course Duration: 1 days

Book online today or if you need any assistance or help chosing the right course for you, please call our team on 08000 199337 and we will help point you in the right direction.

Virtual

Course Duration: 1 days

From +Vat

View dates and book

Private Course: Click Here

Classroom

Course Duration: 1 days

From +Vat

View dates and book

Private Course: Click Here

Course Overview

The Introduction to SQL course provides delegates with an introduction to the important field of relational databases.  By the end of the course delegates will have a good understanding of how relational databases work and some practical experience of using SQL commands to query and update a database.

Read More

The course is structured in six parts:

  • Relational database fundamentals
  • How to connect to a database
  • Simple SQL Queries
  • Complex SQL Queries
  • Editing a table using SQL
  • Database Backup & Restore

This one-day course is designed to be interactive with quizzes and hands-on exercises using MySQL databases that allow attendees to try out the commands in a safe environment.

Who is it for?

The Introduction to SQL course is primarily aimed at testing professionals who need sufficient SQL skills to be able to query databases to locate and check data and to be able to create and update test data. It is also suitable for anyone who wishes to gain a basic understanding of databases and SQL commands, including developers, business analysts and project managers.

Read Less

Entry Requirements

There are no formal entry requirements for this course, although prior experience of working on IT projects is certainly beneficial.

Exam

There is no associated exam

Course Objectives

By the end of the course attendees will:

  • Understand the principles of relational databases.
  • Be able to connect to a SQL database.
  • Be able to create and execute simple SQL queries to return specific records from a database table.
  • Be able to create and execute complex queries that span multiple tables and multiple selection criteria.
  • Be able to edit single and multiple records in a table using SQL commands.
  • Understand how to backup and restore a SQLdatabase.

Syllabus – Key points

  • The course covers:
    • Database fundamentals:
    • The difference between a database and a relational database
    • Tables and relationships
    • Primary and foreign keys
    • Indexes
    • Data types
    • Connecting to a database
    • SQL clients
    • Stored connections
    • Opening a database connection
    • Querying a database
    • Selecting, sorting and filtering data from a table
    • Logical operators
    • Complex database queries
    • Joining tables
    • Using multiple selection criteria
    • Editing tables
    • Insert, update and delete single records
    • Bulk insert, update and delete
    • Backup and restore

Reviews

There are no reviews yet.

Be the first to review “Introduction to SQL for Testers”

Course dates

Start DateExam IncludedPrice (excl VAT)Qty 

Frequently asked questions

A Pearson VUE exam voucher enables you to book and sit your exam at your local Pearson VUE testing centre at a time and date convenient to you.  Pearson VUE centres are worldwide, and you will be able to choose the closest testing centre to you. You then go along to the test centre with your photo ID at the specified date and time and you will then take an electronic exam. Your exam voucher will have an expiration date and your exam must be sat before this date as these vouchers cannot be extended.