Banner Image

All Services

Other

Swappit websolutions

$5/hr Starting at $25

We are providing all the database solutions oracle forms, an Oracle SQL/PLSQL expert to OA Framework page. Before Hello World!: The basics of tables, columns, rows The Hello World! Level: SQL Select Just after Hello World!: Writing Data Commands to create, modify and drop tables, or Data Definition Language (DDL) Knowing how to use a Query Analyzer or optimization tool Understanding Normalization Understanding Denormalization Understanding Primary Keys, Foreign Keys and Constraints Understanding Transactions Understanding ACID Understanding Indexes as optimization tool Views Database Security Upgrades and Installs Efficient access of database from application Bulk operations: loading or exporting large amounts of data Understanding of Contexts and how they lead to different sets of Best Practices Preventing performance degradation through various maintenance tasks Deployment strategies: partitioning, tablespaces Deployment strategies, failure protection, from simple backup to hot standbys Server-side coding: stored procedures and functions Server-side coding: triggers Temporary tables

About

$5/hr Ongoing

Download Resume

We are providing all the database solutions oracle forms, an Oracle SQL/PLSQL expert to OA Framework page. Before Hello World!: The basics of tables, columns, rows The Hello World! Level: SQL Select Just after Hello World!: Writing Data Commands to create, modify and drop tables, or Data Definition Language (DDL) Knowing how to use a Query Analyzer or optimization tool Understanding Normalization Understanding Denormalization Understanding Primary Keys, Foreign Keys and Constraints Understanding Transactions Understanding ACID Understanding Indexes as optimization tool Views Database Security Upgrades and Installs Efficient access of database from application Bulk operations: loading or exporting large amounts of data Understanding of Contexts and how they lead to different sets of Best Practices Preventing performance degradation through various maintenance tasks Deployment strategies: partitioning, tablespaces Deployment strategies, failure protection, from simple backup to hot standbys Server-side coding: stored procedures and functions Server-side coding: triggers Temporary tables

Skills & Expertise

BackupData ManagementDatabase DevelopmentFramework DesignLead GenerationMicrosoft AccessOracle DevelopmentPerformance EngineeringSEOSQLTable DesignWriting

Related Work Collections

0 Reviews

This Freelancer has not received any feedback.