'Y'

Introduction to SQL for Testers

This 16 hour course aims to teach participants how to use the SQL programming language to query a database for testing purposes.
Code: SQA-037
Duration: 16 hours

Description

This 16 hour course aims to teach participants how to use SQL to query a database for testing purposes. The SQL (Structured Query Language) principles taught in this training are independent of any database management system and can be used on most database management systems.

After completing the course, participants will have a good understanding of basic database concepts and will gain the necessary knowledge to interact with the database to verify data. We will learn and practice techniques pertaining to SQL, that allow us to design additional tests and gain a deeper understanding of the application we are testing.

Roadmap

  • The concept of a relational database
  • How to create a query, streamline query results, remove redundant results
  • Queries with a condition. Using Relational and Boolean Operators
  • Use of special operators
  • Aggregate Functions
  • Generating query output
  • Combining tables, using different conditions
  • Subqueries, related subqueries
  • EXISTS, ALL, ANY / SOME statements
  • Using Union
  • Using Join
  • Modifying tables: insert, change, delete rows. Using Conditions
  • Creating, modifying views
  • Creating, deleting tables

Objectives

  • Know the different database management systems in the market place
  • Get an understanding of different types of databases
  • Understand the basic structure of a database specifically for relational databases
  • Understand and differentiate between common database objects
  • Be able to create and understand a simple to complex select statement
  • Understand how to modify data using common statements
  • Know how to create aliases in a select statement and work with special operators
  • Be able to expand the select statement to find specific data on the tables using the where, group by and having clauses
  • Understand how to select data from different tables in a single select statement
  • Be able to manipulate data across table and views

Target Audience

  • Entry level software testers


Trainer in Online
Horia Calin Programming Consultant
Horia is currently working as a Team Lead, managing a group of 10 people. He is responsible, among others, for planning and coordinating daily and release-cycle activities for the PV team as well as planning and coordinating PV activities for each testing cycle.

In his previous role he tested Spirent L4L7 traffic generator products (Cyberflood and Avalanche Commander) together with a large variety of hardware and virtual platforms (40 platforms as of September 2018). Some of the technologies he used include: Selenium, PyCharm, Rest API, Jenkins, Jira, Git, TestLink, Origin, ESXi, CouchDB, VMware, VirtualBox.

Horia has developed and facilitated trainings on software testing, Java, CISCO, automated Testing with Python and Selenium, just to name a few. He also worked as a teaching assistant at the Bucharest Polytechnic University on subject related to Computer Networks and Microcontrollers.

His certifications include:
  • CCNP ROUTE 300-101
  • CCNP SWITCH 300-115
  • Oracle Certified Associate, Java SE8 Programmer
  • CCAI - Cisco Certified Academy Instructor
  • Cisco Certified Network Associate Routing and Switching
Course is scheduled in: Online
16.11.2020 - 19.11.2020
Time: 09:30-13:30
City: Online
Duration: 16 hours
Language: Romanian
Trainer
Horia Calin
Programming Consultant
-10% €280
€252
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
16.11.2020 - 19.11.2020
Time: 09:30-13:30
City: Online
Duration: 16 hours
Language: Romanian
Trainer
Horia Calin
Programming Consultant
-10% €280
€252
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Bucharest €280
Krakow €280
Wroclaw €280

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. Price does not include VAT.

Courses you may be interested in:

Sign up

Choose dates
First Name*
Last Name*
Company
Email*
Phone
Your Comment
Luxoft Warsaw - Warsaw Spire, plac Europejski 1, 00-844 Warszawa
Dimitrie Pompeiu nr 5-7 , building C, Et. 5, sect 2, Bucharest, 014459

Contact phone:

021 371 4858
Luxoft Poland Wroclaw - Silver Tower pl. Konstytucji 3-go Maja 3 50-048 Wroclaw
Aleja Generała Tadeusza Bora-Komorowskiego 25, Quattro Business Park Five, 31-476 Kraków, Poland

Contact phone:

+48 122110650
Success
Thank you.
Your request has been received.