Oracle Database: SQL configuration and optimization - course RUB 39,990. from Specialist, training, Date: April 30, 2023.
Miscellaneous / / November 28, 2023
Practical teacher, experienced Oracle DBMS specialist. He knows how to convey his wealth of experience to every listener and do it in simple and accessible language, using many practical examples. Grateful listeners note his ability to show a wide variety of nuances of working with the Oracle DBMS.
Mikhail Fokin has ten years of experience working with Oracle DBMS (versions 8, 8i, 9i, 10g, 11g), including administration experience and performance settings of the Oracle DBMS on Unix and Windows platforms, including in the Real Application configuration Clusters. Professionally fluent in SQL, PL/SQL languages. Fluent in database backup and recovery technologies - both using RMAN and manually (user managed backup and recovery). Provides reliable data storage and fault tolerance using Data Guard‚ RAC technologies. Resolves database performance issues and also performs tuning of SQL commands and PL/SQL code. In addition, he has seven years of experience teaching courses on Oracle DBMS administration, performance tuning, security, application development and reporting using Oracle Forms Developer and Oracle Reports.
Currently, he is an Oracle DBMS administrator at a large Russian bank.
The course provides students with basic knowledge of SQL, allowing the developer to write queries against one or more tables, modify table data, and create database objects. The main development tool used in the course is Oracle SQL Developer; SQL Plus is used as an additional one.
4,2
We consider additional features of SQL and relational databases: variables, transactions, stored procedures, triggers and locks. We study window functions and analytics in SQL in detail.
4