Technologies / Data & Analytics

Advanced SQL II

The training delves into advanced aspects of SQL, focusing on query optimization and database performance. The program combines theory with intensive hands-on workshops where participants work on real database examples. Classes are conducted in a workshop format with an emphasis on solving complex database problems.

Issues

Optimization of complex SQL queries
Analysis of query execution plans
Design and use of indexes
Database-side programming
Transaction management
Data partitioning and segmentation
Database security
Performance monitoring
Replication and high availability
Backup and recovery
Stored procedures and functions
Handling concurrency

Benefits

The participant will develop the ability to design and optimize complex SQL queries for maximum performance
Will gain the ability to analyze and improve the performance of existing database solutions
Will master techniques for efficient design of data structures and indexes
Will acquire the knowledge to implement advanced security mechanisms in databases
Will be able to create efficient stored procedures and functions
Will develop the ability to identify and solve performance problems in database systems

Who is this training for?

Database application developers

Database administrators

Data analysts working with large collections

Backend developers

Database solution architects

Performance optimization specialists

ETL engineers

Database systems consultants

Prerequisites

Practical knowledge of the basics of SQL language
Experience in creating SELECT queries
Knowledge of basic DML operations
Understand the basics of database design

Training program

Indexes and their impact on performance
Joint optimization
Sub-query processing
Base side programming

Functions and triggers
Transaction handling

Advanced data structures
Partitioning of tables
Materialized views

Composite types
Security and administration
Privilege management
Auditing and monitoring
Backup and recovery
Data replication

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Frequently asked questions

What are the prerequisites for this training?

For Advanced SQL II we recommend: Practical knowledge of the basics of SQL language; Experience in creating SELECT queries; Knowledge of basic DML operations.

What is the format and duration of this training?

The training lasts 3 days and is available in online and on-site format. Sessions run from 9:00 AM to 4:00 PM. We can also customize the schedule to fit your team's needs.

Who is this training designed for?

This training is designed for: Database application developers; Database administrators; Data analysts working with large collections.