I will do oracle sql queries and plsql scripts

Kenya

I speak English, French

Database Design, Project Management, User Experience, Software Dev

Over 5 years of experience in Design Research, Project Management, Software Engineering, Database Management and Administration, IT Tutoring, SDLC, IT Tutoring and Software Security.
About this Gig

I am proficient in Oracle Apex application and oracle PLSQL scripts.

I write:

  1. PLSQL Sequences
  2. Triggers
  3. Procedures
  4. Functions
  5. Tables
  6. Views
  7. DBMS Scheduler for Automation
  8. Oracle SQL Queries


I write SQL queries that perform actions such as:

  1. Select
  2. Insert
  3. Update
  4. Delete
  5. Merge
  6. Joins


I use SQL Developer as my IDE for Data Analysis/Analytics.


Other services I offer comfortably include:

  1. Writing SQL Queries and PL-SQL Code
  2. Optimizing SQL Queries and PL-SQL Code
  3. Testing of SQL Queries and PL-SQL Code
  4. Exception Handling in PL-SQL Code
  5. Altering the Functionality of Applications using PL-SQL Code
  6. Triggers on System and Schema-Related Events
  7. Firing Trigger(s) on Events
  8. Updatable Views
  9. Dynamic Update/Delete Statements and Dynamic Queries
  10. PL/SQL Collections and Records
  11. Cursors, Loops in PL-SQL Code
  12. Automating Tasks



Database type:

Centralized database

Hierarchical database

Platform:

MySQL

Oracle

PL/SQL

Expertise:

SQL

DDL

DML

Normalization