SQL for Testers & Developers

SQL for Testers & Developers

Main Speaker:


Sima Sigman

Tracks:

QAGeekWeek

Seminar Categories:

Manual
QAGeekWeek
QAGeekWeek

Course ID:

43807

Date:

08.07.2020

Time:

Daily seminar
9:00-16:30

43807

Overview

One of the most basic software component is the DB. Traditional DBs are relational (RDBMS) and uses SQL language for querying and updating data.

This seminar introduces the RDBMS data structure, basic terms, single & and multiple table data aggregation and more. The seminar also introduces SQL for interacting with DB.

Then, the seminar relates to many DB/Storage testing aspects like SQL injection check, DB availability, verifying data store/load/remove by the application and other tester responsibilities

Course Contents

  • Introduction to SQL
  • The Different Parts of the SQL Language
    • Data Retrieval Commands
    • DML Commands
    • DDL Commands
    • DCL Commands
  • Writing a Basic Query
  • Restricting Data
  • Ordering Data
  • Types of Functions in SQL
    • Single-Row Functions
    • Group Functions
  • Displaying Data from Multiple Tables
  • Subqueries
  • Manipulating Data


DevGeekWeek 2020





By entering your email address, you agree that John Bryce training will use it for marketing purposes, emails and newsletter, as well as promotional offers and announcements, according to John Bryce training & Matrix group privacy policy. Your data will be saved in our computerized database, number 700019285. You can unsubscribe at any time by mailing infomail@johnbryce.co.il or by calling 03-7100777.

Contact

DevGeekWeek 2020





By entering your email address, you agree that John Bryce training will use it for marketing purposes, emails and newsletter, as well as promotional offers and announcements, according to John Bryce training & Matrix group privacy policy. Your data will be saved in our computerized database, number 700019285. You can unsubscribe at any time by mailing infomail@johnbryce.co.il or by calling 03-7100777.

Skip to content