Designing a relational database, Writing stored procedures.
Starting at
$
30
/hrAbout this service
Summary
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
Microsoft SQL Server
MySQL
Oracle SQL
Tableau
Industries