The target audience
- Business Analysts, Product Owners, and Product Managers
- Project Managers
- QA Engineers
- Beginner Developers
- All technical and non-technical experts, who need to understand the principles of working with relational databases
Reasons to take the training
The training will allow to:
- Work with relational databases using the SQL language;
- Understand the developers better;
- Receive and analyze information stored in your (new or old) information systems;
- And, as a result, make decisions based on data, not on assumptions.
Results after the training
Upon completion of the training, students will be able to:
- Execute simple SELECT queries with WHERE constraints;
- Understand the difference in sorting in different databases;
- Compose queries using JOIN;
- Understand the main tasks of various types of JOIN;
- Use aggregate functions;
- Understand the ACID concept
- Understand the execution plan.
Cost of the Training:
Until February 28 - 90 $
Until March 14 - 100 $
From March 15 - 110 $
What the training will be like:
- The course takes place online at a convenient time on weekends from 11:00 a.m. to 2:00 p.m.;
- The course consists of 3 classes, 3 hours each;
- Classes include the theory and practice of creating SQL queries;
- After each class, students receive homework, which the instructor checks and comments on during the next lecture.
In just 9 hours of online classes, you will learn the language of communication with databases, learn how easy it is to get the information you need and understand why developers need so much detail from you.
Necessary technical support
The training will be conducted with the use of Oracle 11g XE DBMS and PL / SQL Developer IDE. To complete your homework you can use:
- An installed version of any relational DBMS (Oracle, MS SQL, Postgres, MySQL)
- The online system https://livesql.oracle.com/apex/livesql/file/index.html
Prior Knowledge Required
A basic understanding of simple SQL SELECT in any database management system.
- Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition. Neil Matthew, Richard Stones. (Chapters 3, 6, 8 and 9)
- Mastering Oracle SQL. Sanjay Mishra, Alan Beaulieu. (Chapter 5, 6, 7 and 9)
- Beginning SQL Server 2005 for Developers: From Novice to Professional. Robin Dawson. (Chapter 4, 5, 8 and 9)
Module 1: Simple SELECT
- Dealing with datatypes
- Sorting query results
- Using WHERE
Module 2: Joins
- CROSS JOIN, formal and informal notation
- INNER JOIN, formal and informal notation
- LEFT / RIGHT JOIN
- FULL JOIN
Module 3: Aggregate functions
- Aggregate functions
- GROUP BY
Module 4: ACID
- ACID in examples
- Isolation in Oracle and MS SQL
Module 5: Execution Plan
- Table access
- Joining tables
Natalia Bogushevskaya has been working in the IT industry for more than 15 years as a business analyst and project manager, possessing the experience in creating automated systems from scratch, maintaining existing systems, and integrating systems at the database level.
Over the last 5 years, she has been working with the training center in EPAM Systems, preparing young specialists in programming, testing, and database work.
Having a Doctoral Degree in Technical Sciences in Modeling Discrete Systems, for over 10 years Natalia worked at NTUU ‘KPI’ at the IOT Faculty, teaching subjects such as ‘Technology for Creating Software Products’ and ‘Database Fundamentals.’ The scope of her interests lies in business diagrams (UML, BPMN, DFD, and ERD) and the design and optimization of databases (Oracle).