Designing a relational database, Writing stored procedures.

Starting at

$

30

/hr

About this service

Summary

As SQL Server Developer delivery tasks related to designing, developing, and maintaining databases using Microsoft SQL Server and Azure SQL Server would be delivered with clear communication and adhering to the timeline committed with at most quality.

What's included

  • Database Design and Development

    Entity-Relationship Diagram (ERD): Visual representation of database structure. Database Schema: Scripts or files defining tables, relationships, constraints, indexes, and keys. Data Dictionary: Documentation explaining tables, columns, data types, and relationships. Normalization/Denormalization Report: Explanation of the chosen schema design approach.

  • Query Development

    SQL Queries: Scripts for SELECT, INSERT, UPDATE, DELETE operations. Stored Procedures: Optimized and reusable scripts for specific tasks. User-Defined Functions (UDFs): Scripts for custom reusable logic. Views: Predefined queries for simplified data access.

  • Performance Tuning

    Query Optimization Report: Analysis and recommendations for query improvements. Index Management: Scripts for creating or updating indexes to improve performance. Execution Plans: Files showing query execution paths for performance diagnosis.


Skills and tools

Database Engineer

Data Engineer

Database Specialist

Azure SQL Database

Azure SQL Database

Microsoft SQL Server

Microsoft SQL Server

MySQL

MySQL

Oracle SQL

Oracle SQL

Tableau

Tableau

Industries

IT Infrastructure