ОПИСАНИЕ
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год
Курс буде читатись українською.
Реєстрація на сайті http://qagroup.com.ua обовязкова.
UAevent