Online now
Hire Me!
Rate: $15.00 USD/hour
Follow Invite to Project
Browse Similar Freelancers:

Truong nguyen

Oracle Developer - cmc software

Username: truongnguyen86

  • Has not made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is verified.

Location: Ha Noi, Vietnam

Member since: October 2013



(72 reviews)

[see more]

4 users have recommended this freelancer.

My projects:

  • $65.00 USD
    Profile image for Seller raj170709


    7 days ago

    nguyen has the knowledge and experience to do complex tasks on sql server . Will definitely hire him again

    Project Description:I have a good size mysql database . i need a database expert to optimize the design and write a query to remove duplicate records from the database . 2) need to write a procedure which recalculates percentages based on the highest Value I need the project to be completed today ...
  • $50.00 USD
    Profile image for Seller num11


    17 days ago

    Thank you for your quality work. Will work with you next time.

    Project Description:Be able to complete task within 12 hours. Follow the specification of the task. Using Oracle SQL only.
  • $110.00 USD
    Profile image for Seller awestbha


    19 days ago

    Great work!<br/>

    Project Description:Briefly: I need to calculate how many members our membership organisation has had over time. I would like a MySQL query that shows a running total of membership numbers, grouped by whatever time period I specify...
  • $260.00 USD
    Profile image for Seller alfrwan


    20 days ago

    Excellent developer, completed task without problems and always happy to help

    Project Description:Please read the attachment file (it&#039;s include All requirements) and be sure that you&#039;re a professional in ORACLE DEVELOPER + ORACLE SQL Other requirements: 1- The deadline is 07/02/2014 2- At the end, you have to guide me to operate and run the project...
  • $150.00 USD
    Profile image for Seller gridironcoach


    24 days ago

    Excellent Work...Very concise PL/SQL.ThanksDan

    Project Description:Convert SQL Server Relative Date Function to Oracle Function. The custom function has been written by me in SQL Server and now I need the function to be replicated and possibly improved in Oracle 11g R2
  • $30.00 USD
    Profile image for Seller rstewart1


    Jun 27, 2014

    One of the best in his field!<br/>

    Project Description:N/A
  • $35.00 USD
    Profile image for Seller rstewart1


    Jun 26, 2014

    Fast &amp; Accurate

    Project Description:N/A
  • $150.00 AUD
    Profile image for Seller connectedthinkin


    Jun 26, 2014

    Amazing work. Excellent communication, super quick. Will definitely hire again. Very appreciative. Many, many thanks.

    Project Description:A very simple SQL assignment. Must be done in Oracle SQL. I will give access to the online SQL processor. Must work in that. Must be completed in the next 8 hours. Project should take no longer...
  • $75.00 AUD
    Profile image for Seller brodiej


    Jun 23, 2014

    Great Freelancer, will certainly hire again. Enthused to deliver a quality product and did succeed. Thanks.<br/>

    Project Description:We have a &#039;Firebird&#039; database that I need to procure a number of queries against to put into our reporting engine. These will include creating stored procedures where required. This will be one of many projects, a simple one to begin with creating a Time Sheet Report...
  • $110.00 USD
    Profile image for Seller alfrwan


    Jun 20, 2014

    I have no words to say about this guy. He is just more than perfect. I had a project and he did more than my requirements which was totally perfect. Don't think about it. Hire him asap

    Project Description:Please read the attachment file (it&#039;s include All requirements) and be sure that you&#039;re a professional in ORACLE PL/SQL. Other requirements: 1- The deadline is 06/17/2014 2- At the end, you have to guide me to operate and run the project...
    Truong nguyen has not completed any projects.
  • $13 USD/hr In Progress

    Design a performant database schema to aggregate all of our supplier product feeds into a single normalised catalogue.Multiple suppliers can provide the same product so the ability to track differing images, descriptions, location of stock, quantities and and costs is mandatory.

  • $15 USD/hr In Progress

    Tune insert, update and delete queries that update a live table from staging table in mysql

  • $250 USD In Progress

    TASKS:1.Produce an E-R and an EER diagram to model the required system. Comment on the differences. [25]2.Use the UML notation to model the required system. You should include at least a use case diagram and a class diagram. Comment on how useful each of these diagrams is. [15]3.Describe how the subclass/superclass relationships and the type of specialisation involved in each were developed. [5]4.Identify the problems for implementation in the EER and class model. [5]5.Specify the Tables (include keys and data types) which you would propose to implement and explain how you have overcome the problems identified above. [15]6.Implement the tables you have designed. Pay particular attention to adding as much of the semantics (meaning of the data - constraints) as possible at this stage. You may use Oracle, SQL Server or MySQL [20]7. Create examples of appropriate processing with procedures and triggers. [15] The attacthed documents will further your understanding of the outlined tasks above.

  • $8 USD/hr In Progress

    Private project for Truong for creating procedures.

  • $15 AUD/hr In Progress

    •This is a Courier export into a shipping provider.•Their format and example CSV has been attached.Further details are provided in the attached requirements document.

  • $15 USD/hr In Progress

    Hour rate project assisting with SQL query and procedures

  • $30 USD In Progress

    5 home work assignemts q4. Using an Explicit Cursor Create a block to retrieve and display pledge and payment information for a specific donor. For each pledge payment from the donor, display the pledge ID, pledge amount, number of monthly payments, payment date, and payment amount. The list should be sorted by pledge id and then by payment date. For the first payment made for each pledge, display “first payment” on that output row

  • $35 USD 2 days ago

    I have 2 sql stored procedures that when run repeatedly result in concurrency issues. Both of them are being executed in the scope of a transaction so it just doesn&quot;t make sense. I need a sql expert to review them, I have attached them. Basically the Count can go way over 50, sometimes over 100. When UpdateTokenCount is called, the Decrement value is in the range of 0-7.

  • $35 USD 2 days ago

    need a little fix on my server something is wrong but don&quot;t have time to fix.

  • $200 USD 3 days ago

    Using the Oracle database engine, design and develop a relational database to store user information to support a large online shipping company. Information that needs to be stored includes user name, detailed mailing address, and shipping information including number of packages, weight, cost, destination, origin, and tracking information allowing users to determine where a package is, and when and who signed for the package once it arrives. Other business data should be present showing how much the shipment costs and invoicing capability to send bills to customers.2.Your design should allow for inserting, updating, selecting and deleting information 3.A trigger should be used to generate invoices once a customer reaches $200 in shipping costs. 4.An instead-of trigger should be employed to update and/or populate multi-table views.5.You should include packages, indexes, views and other helpful database components that will assist you in your design. 6.Your scripts should work perfectly allowing the creation of all of the tables, triggers, views and other database components and provide test scripts that demonstrate the use of the system. 2.An ERD diagram of your database design showing primary keys, foreign keys and other constraints

  • $170 USD 3 days ago

    I want to design a database to track our inventory and some other data from quickbase

  • $30 USD 3 days ago

    There is an SQL file which you need to fill in the blanks in the comments to do whatever is requested. The file will be sent upon request. File size is small. I have future work as well.

  • $35 USD 6 days ago

    Very easy project hopefully shouldn&quot;t take longer then 30 mins will send details

  • $60 USD/hr 6 days ago

    10 session ( 5 hours each) for preparation for OCA

  • $150 USD 7 days ago

    Need your help with a database design assignment. Due soon so I Can work on some of it if you cannot complete it all in time.

  • £200 GBP 7 days ago

    Need a MySQL guru to help with work on one of the existing projects.

  • $25 USD/hr 8 days ago

    Hello There I need help with my exam coming up in 6 hours on database designSimple course, I have attached the lecture notes and pdfs the exam will be based off of

  • $100 USD 9 days ago

    Hello,I have a project. I have 2 excel files. One has a column that says pictures the other one does not. I want to move or copy the data that&quot;s in the picture field to the one with out by matching the product number field. If you can do this let me know.

  • $35 USD 15 days ago

    Need help writing queries can&quot;t share database but i will give you screen shots od diagram

  • $50 USD 16 days ago

    Small database project. Should take a professional less than 2 hours (Approximately 1 hour or so). Future work available if performance is satisfactory.

  • $35 USD 17 days ago

    Hello,using sql 2008, trying to convert a string to intExampleTable1 has a varchar which i want to cast to int00125000000 to int 125000000i used the followingcast(B.[Assessment] as int) as [USER1_01],with the result 125000000Table2 has the same field in a different format.0.00125i need to find a way to convert one of them so they both match. if i did a join and matched the fields.I tried cast (10000000000 * cast([USER1_01] as NUMERIC(6,6)) as INT) as [USER1_01]but for some reason it dosent look like they match, although they look the same. maybe a type problem?.I hope someone can shed some help me, been working on this for a long time :(

  • $150 AUD 19 days ago

    Need to complete the rest of my assignment that I can&quot;t do - involves SQL and ER DiagramsQ.A group of people are setting up a car pooling arrangement and require a database to manage the information about pickup locations, drivers, passengers and the routes that will be driven. Use the following information to draw an ER diagram for the required database with the symbols and notation used in lectures and notes. You must not submit scanned or bit-mapped diagrams. This will result in reduced marks. A route is identified by a Route ID and has an associated departure time. There are many Pickup locations. Each one has a unique number known as an L number. There is also a description with details of precisely where the pickup is for that location.Each route is made up of many locations. Individual locations can appear on more than one route. People who register to use the service as a passenger are each given a P number and their name and mobile number is recorded. Other people register as drivers. They are each given their own D number and also supply their name and mobile number. Based on their needs, passengers in the system select the pickup location they prefer and record the time they expect to be at the pickup location. Routes are allocated to drivers. There are always more drivers than routes so every route has a driver. Each route starts and

  • $35 USD 20 days ago

    Hello,I have installed Oracle XE 11.2 on my laptop.I need someone to set it up correctly, i.e. create a sample database and some dummy tables.I then need you to create an ODBC connection so that I can connect to that database via PL/SQL developer.After I can successfully connect via PL/SQL developer, I should be able to see those tables.We can do this via a join me session.Please know what you are doing, if you have any questions about this, please let me know.Thanks.

  • $35 USD 20 days ago

    have them written but don&quot;t have time to correct small errors

  • $250 USD 22 days ago

    I need a mysql schema design (which when i execute to my database created the database for me)Specification1. Is a generic reservation system2. Use case is &quot;A user U want to book a carpenter B for T hours&quot;. So we will need all details of U, B and T (User, Resource to be booked, Time/Date details)3. I am looking for something similar that you already have, so that i can buy it out and start working on.4. Looking for simple, yet complete schema. Ideal one should be one that i will never need to change ever for any of my client apps.Let me know if any additional details required.

  • $500 USD 24 days ago

    Database design for health care product- creating data model and writing queries.using mysql database

  • $200 USD 26 days ago

    Moro,Mulla olisi sulle työtarjous!Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin.Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

    Truong nguyen does not have any open projects.
    Truong nguyen does not have any work in progress.
[see more]


[see more]



My jobs

Apr 2008 - Present (6 years)


Design database, PLSQL Developer, Oracle admin and system intergration......



Truòng Dai hoc Bách Khoa Hànôi



IBM Websphere Application Server 7.0


About ibm software that looks like IIS, Apache Tomcat, allow application, web application run on it, but it's stronger and more security




A chance will come to a person who try hard, work hard and never stop learning to make job perfectly