25,000+ Courses Nationwide
0345 4506120

Introduction to SQL for Testers

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.

Select specific date to see price, venue and full details.

Learning 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.

Pre-Requisites

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

Course Content

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

Exams & Certification

There is no associated exam

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best