I will design, develop and optimize mysql and postgresql databases

Italy

I speak English, Italian

Data Analyst and Business Insights Analyst

Hello! I'm a Data Analyst with 10+ years of experience helping small and medium-sized organizations transform data into actionable insights. I've worked across healthcare, education, agriculture, and ...
About this Gig

1. Database Design & Architecture

  • Relational database design
  • Database schema creation
  • Entity Relationship Diagrams (ERD)
  • Table and relationship design
  • Primary and foreign key implementation
  • Database normalization
  • Data integrity and constraints

2. SQL Database Development

  • MySQL database development
  • PostgreSQL database development
  • Microsoft SQL Server development
  • Database creation and configuration
  • Tables, views and indexes
  • Stored procedures and functions
  • Triggers and SQL scripts

3. SQL Query Development & Optimization

  • Complex SQL query development
  • SELECT, INSERT, UPDATE and DELETE queries
  • JOIN operations and subqueries
  • Aggregate functions and reporting queries
  • Query performance optimization
  • Index optimization
  • Database troubleshooting

4. Database Management & Maintenance

  • Database structure improvements
  • Data migration and transformation
  • Database backup and restoration assistance
  • Data validation and integrity checks
  • Importing and exporting database records
  • Database performance improvements

5. Database Integration

  • Connecting databases with web applications
  • PHP and Laravel database integration
  • Python and Django database integration
  • Database-driven application support
  • API-related database

Database type:

Centralized database

•

Key-value database

Platform:

MariaDB

•

MongoDB

•

MS Access

•

MS SQL

•

MySQL

•

SQLite

•

SQL Server

Expertise:

Big data

•

Data center

•

Data structure

•

Normalization

•

SQL

My Portfolio