empower your people,
empower your organization
Call:  08000 199337 From overseas call +44 20 7264 2185
face-to-face training
Training Since 2002
Online Learning
Certified Trainers with 20+ Year's Experience
Virtual classroom training
Above Industry Average Pass Rates
7-key IT disciplines
No Fee Course Resits

Enjoy live training & exams NOW from your own home Learn more Now offering Remotely Proctored ExamsLearn More

Introduction to SQL for Testers

About the Course

Course Duration: 1 day

Price From: £400


Private Course: Click Here

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.

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.

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”

Your email address will not be published. Required fields are marked *

View dates and book

Select the Introduction to SQL for Testers Classroom & Virtual Course

Now offering VIRTUAL courses. Enjoy live training NOW from your home Learn more
Start Date Exam Included Price
(Excl VAT)
Qty  
Clear

Types of Exams

Pearson Vue Voucher Exams

Online Exam

Classroom Exam

OUR CUSTOMERS INCLUDE

OUR LOCATIONS

We operate from ten training centres across the country, giving you more choice for where to attend

SIGN UP ALL THE LATEST NEWS AND OFFERS