(CZ) SQL for testers
On-line, self-study course. Learn SQL basics and gain practical knowledge of the SQL language and Oracle Database. Can be finished within 1 - 2 days.
Training courses
Training courses to help you develop your own professional skills and knowledge.
Back to training list
LanguageCZ LevelBasic PlaceOnline
What will you learn?
- Principle of operation of relational databases, termin primary and foreign key
Inserting, editing and deleting data - INSERT INTO, UPDATE, DELETE- Operators - arithmetic and comperative - AND, OR, NOT, IS NULL, IS NOT NULL, LIKE, IN, BETWEEN
- Joining tables - JOIN, INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, SELF JOIN
- Aggregational and other functions and data grouping - MIN, MAX, COUNT, AVG, SUM, SYSDATE, GROUP BY
- Data selection and filtering - SELECT, SELECT DISTINCT, WHERE
- Data sorting – ORDER BY, DESC, ASC
- Links between tables
- Embedded queries
- Database browsing and data manipulation using SQL Develope
- Working with Oracle Live SQL - a cloud service accessible through a browser that provides access to an instance of an Oracle 19c database
Do you want tailored training?
We will prepare tailored training for you, at the time and place you choose. Fill in the basic information and we will get back to you.