I will design, develop and optimize mysql and postgresql databases

Algumas informações são exibidas no idioma inglês.

Itália

Eu falo Inglês, Italiano

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 ...
Sobre este Serviço

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

Tipo de banco de dados:

Banco de dados centralizado

Plataforma:

mariadb

•

MongoDB

•

ms access

•

MS SQL

•

mySQL

•

SQLite

•

SQL Server

Especialidade:

Big data

•

Centro de processamento de dados

Meu portfólio