Designing a relational database, Writing stored procedures. by Swathi

Designing a relational database, Writing stored procedures. by Swathi Designing a relational database, Writing stored procedures. by Swathi

Designing a relational database, Writing stored procedures.

Swathi

Starting at

/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