Семінари та Практикуми "SQL для Тест Інженерів"

Спікер(-и) події
Додати у Google Calendar
Опис події

Seminars and Practices "SQL for Test Engineers"

Program

Day 1: Database Introduction
- Database Models
- Types of Keys in Database
- Types of Table Relationships
- SQL Command Types

Fully theoretical part of seminar.

Day 2: MySQL Database
- MySQL Database
- Database DDL commands
- Data types
- Database parameters
- Indexes

This is a mix of theory and practice.

Day 3: Database scheme designing
Designing database scheme by analyzing each type of the information that is supposed to be stored and relations between the data.

That is totally practical lesson for improving skills in creating database scheme for the early start and up to complicated structure.

Day 4: Data defining and managing
- DML Insert, Update and Delete data
- Variable cases of select data
- Embedded functions
- Search
- Group By functionality
- Transactions

This is a mix of theory and practice.

Day 5: Data Control, Administration, Database testing and optimization
- Grand and Revoke user permissions
- Basis of MySQL administration
- Database testing
- SQL Optimization
- SQL Injections

This is a mix of theory and practice.

Day 6: SQL Tasks
Tasks for resolving predefined issues using SQL.

That is a fully practical lesson for improving skills in creating SQL SELECT scripts including the basic scripts and up to applied tasks.

___________________________________________________

6 занять по 3 години (18 годин)

Дні та час проведення занять:
Четвер (21, 28 Лютого та 7 Березня): 19:00 - 22:00год
Субота (23 Лютого та 2, 9 Березня) : 11:00 - 14:00год

Курс буде читатись українською.