Aykhan Adigozalov

Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.

• Declaring PLSQL Variables
• Writing executable statements
• Writing Control structure : If, Case statement
• Basic loop, While loop, For loop
• Working with Composite Data Types
• PL/SQL records, %Rowtype,%Type
• Index by tables(associative arrays), Nested table, Varray
• Using explicit cursors
• Handling Exceptions
• Creating Functions
• Using oracle-supplied Packages in Application Development
• UTL_FILE package, DBMS_OUTPUT
• Using Dynamic SQL
• Execute immediate
• Creating triggers
• Creating Compound, DDL, and Event Database Triggers
• Using the PLSQL Compiler
• Managing PLSQL Code
• Managing Dependencies
• Creating Procedures
• Creating Packages
• Working with Procedures, Functions and Packages
• Satandart Oracle Data Dictionary libraries
• Analyzing All dependencies between Table, Package View, Procedure, Function, indexes etc. Schemas and User interface Applications|(like Fexcube)
• Creating Jobs

• Arrays 1 (one dimentional arrays)
• Retrieving information from the Database (The SELECT statement)
• Filtering and Sorting Results
• Operators
• Group Operations Aggregate Functions
• Subqueries : (Inline Views) ; Subquery Factoring (The WITH Clause) ; Top-N Queries etc..
• Functions : numeric, text, date, conversion, Decode and other types of functions.
• Analytic Functions
• Transposing Rows into Columns and Columns into Rows : Pivot, Unpivot
• Set Operators
• JOINS: Selecting Data from More than one Table: Inner join, Equijoins, Non Equijoins, Self, Cross and Outer Joins
• Hierarchical Queries
• DML : Changing the Contents of Database Tables
• Data Definition Language (DDL)
• The union, union all, intersect, minus
• MAIN GOALS
• To read, filter and sort information from database tables.
• To use comparison, logical, set and other type of operators in Oracle SQL.
• To use numeric, text, date, conversion, aggregate, analytic and other types of Oracle SQL functions.
• To add, modify and delete information from Oracle databases using SQL.
• To use SQL to create and use tables, constraints, sequences, indexes and views.
• Much more.

• BRİTİSH EDUCATİON - English to advance level, 2019
• ItCity Acamdedy - Foundataion , Data structures, 2013, 2014

• Udemy - Oracle SQL Ultimate course
• PL/SQL is my game

• Managing Oracle database.
• Moving data between databases Transactional and Analytical system. (Data pump, Dblink)
• Helping to Senior DBA
• Checking daily backups
• Space management.

Becoming Master and Improving Data Migration strategy that working with Hard coded Packages , DB-links, DBMS_Jobs, Paralelism, Partitions...

Solving and Debugging the real time issues regarding the Bank Operating system errors that bussiness side employees calling for it or creating Tasks. Working together bussines developers and Solve weekly , daily Tasks that created in Jira. Optimizing and creating compound SQL query reports in Oracle BI publisher. Management and Development of Projects and tasks assigned Directly Department director. Creating , optimizing editing and tuning Package, Function, Procedure, Trigger table, view and etc. schemas. Supporting to other dept. employees with Flex (Bank Op system) errors. Proud of becoming mainly part of a team that Highly motivated and profenciencied.