Introduction to SQL for Testers [TSG_SQL]

Total time
Location
At location
Starting date and place
Logo Global Knowledge Network Training Ltd.

Need more information? Get more details on the site of the provider.

Starting dates and places

placeVirtual Learning
30 Sep 2021
placeVirtual Learning
22 Oct 2021
placeVirtual Learning
19 Nov 2021
placeVirtual Learning
8 Dec 2021

Description

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.

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.

OBJECTIVES

By the …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, PL/SQL, Programming (general), IT Security, and Web Accessibility.

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.

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.

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.

AUDIENCE

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.

CERTIFICATION

There is no associated exam

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
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.