I will design database create erd diagrams and sql queries

Pakistan

I speak Urdu, English

5 orders completed

God Helps those who help themselves

Skilled in Automation Testing using Selenium Java + Cucumber and JUnit by giving results in Extent Reports. Skill in Angular 8/9/10and also worked on C++, JAVA, and Python. Strong engineering profess...
About this Gig

I have experience working in the following RDBMS


  1. MySQL
  2. MS SQL Server
  3. PHPMyAdmin


Below are the skills which I can provide you regarding Database


  1. Conceptual Model Creation
  2. Entity Relationship Diagram (ERD)
  3. Logical Database Design (Transformation of ERD To Relational Diagram)
  4. Normalization (1NF, 2NF, 3NF, BCNF, 4NF, 5NF)
  5. Making Logical Model and Physical Model
  6. Database Creation
  7. Table Creation
  8. Write Simple and Complex Queries
  9. Apply Constraints on Table
  10. Create Joins and CRUD Functions
  11. Database Objects Creation (Index, View, Sequence, etc)
  12. Bugs Fixing
  13. Query optimization


My solutions will be for the following technologies


  • SQL Server
  • MySQL
  • Oracle 
  • MySQL WorkBench

Database type:

Key-value database

Relational database

Platform:

MS SQL

MySQL

SQLite

SQL Server

Expertise:

Design

ERD

Normalization

SQL

Performance