I will design and develop erd, eer, database, and schema normalization, sql query

5.0
5.0

Bangladesh

I speak English

20 orders completed

Expert Database and SQL Developer

This is Showkat Hossain an Oracle Certified Professional Developer. Over 5 years of experience in Database Design & Development, SQL Query building, Database Programming such as Stored Procedure, Func...
About this Gig

What I offer you?

  • Database Conceptual Design, Logical Design, Physical Design
  • Entity Relational Diagram (ERD), Enhanced Entity-Relationship (EER)

Chen Notation, Crow's foot Notation

  • Database Normalization (1NF, 2NF, 3NF, BCNF)
  • Data Integrity and Relationship building.
  • Database Contraint creation and modification.
  • Table, View Creation.
  • Complex joining (Inner Join, Outer Join, Self Join, Cross Join).
  • Simple and Complex SQL query.
  • Stored Procedure, Function, triggers.
  • Data import from CSV, Excel, Flat file, etc.
  • SQL query scheduling.
  • Query performance tuning, Indexing, Partitioning.


What tool do I use?

  • For ERD, I use draw.io, Microsoft Visio, and Lucidchart.
  • For query, I use SQL Server Management Studio, MySQL Workbench, Oracle SQL Developer, Toad, PgAdmin, and phpMyAdmin.


What database I can work with?

  1. Oracle
  2. MySQL
  3. Microsoft SQL Server
  4. PostgreSQL
  5. MariaDB
  6. Microsoft Access.
  7. MongoDB


Why Me?

  • Over 3 years of experience.
  • 100% client satisfaction.
  • 100% dedication.
  • Work for passion not only for Money.
  • On-time delivery.
  • 24/7 communication.
  • Regular progress update.
  • Revision till client got satisfied.
  • Oracle Certified.


Important: Please contact me before ordering.

Expertise:

Data manipulation

Data upload

Data validation

Technology:

Amazon Redshift

BigQuery

Excel

Google Sheets

Python

SQL

Reviews

3 reviews for this Gig
5.0

(3)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Quality of delivery
    5
  • Value of delivery
    5
Sort By
Most relevant
  • O
    image-docs

    omarhammad523

    Repeat Client

    US

    United States

    5

    I was very pleased with the work that Showkat had done. I presented him with a project to do last minute, and he came through and finished it for me. Definitely do recommend

    Up to $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • M
    image-docs

    marymisss

    Repeat Client

    HK

    Hong Kong

    5

    thanks for your help and support 👍

    Up to $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • O

    ourrundmc

    US

    United States

    5

    Quick delivery and great communication

    $50-$100

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
Reviews

3 reviews for this Gig
5.0

(3)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Quality of delivery
    5
  • Value of delivery
    5
Sort By
Most relevant
  • O
    image-docs

    omarhammad523

    Repeat Client

    US

    United States

    5

    I was very pleased with the work that Showkat had done. I presented him with a project to do last minute, and he came through and finished it for me. Definitely do recommend

    Up to $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • M
    image-docs

    marymisss

    Repeat Client

    HK

    Hong Kong

    5

    thanks for your help and support 👍

    Up to $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
  • O

    ourrundmc

    US

    United States

    5

    Quick delivery and great communication

    $50-$100

    Price

    1 day

    Duration

    Helpful?
    Yes
    No