Concluído

Few MySQL statements for existing MySQL database

I need the following for a basic DB with dummy data project

Using ERD and Database which will be provided, I need to develop and populate a real life Relational Database (with dummy data) to hold business data and ALSO a Data Mart to support the reporting requirements of the Databse that I will provide. In order to implement this Data Mart I need you to automate the loading of the data from the live production database to the Data Mart. This should be done by scripting.

documentation needs to be break down as follows:

Project Report Document

a. Background Information Document and relevant graphs connected via Excel to each report defined below.

b. Script File to Create the Data Mart database and tables

c. Script file to populate the Data Mart tables

d. Scripts to complete the following reports

Reports and scripts for the following queries need to be provided

1. Show all transactions for a given week in your business. (Stored Procedure)

2. Create a trigger that stores stock levels once a sale takes place.

3. Create a View of stock (by supplier) purchased by you.

4. Total stock sold to general public (by supplier). (A Group By with Roll-Up)

5. Detail and total all transactions for the month-to-date. (A Group By with Roll-Up)

6. Detail and total all revenue for the year-to-date. (A Group By with Roll-Up)

7. Detail & total transactions broken down on a monthly basis for 1 year. (A Group By with Roll-Up)

8. Display the growth in sales/services (as a percentage) for your business, from the 1st month of opening until now.

9. Use a reporting tool of your choice to connect to your data and create a graphical representation of each of your previous SQL report results.

10. Add both the SQL statements and graphs into a Word document report.

Habilidades: Administração de Bancos de Dados, Programação de Banco de Dados, MySQL, Oracle, SQL

Veja mais: mysql create or replace table, mysql create database, mysql example, get insert statement for existing row in sql, mysql create view example, mysql create table, mysql create view from multiple tables, get insert statement for existing row in mysql, front end database mysql, database mysql con link mp3, importing large database mysql, import database mysql, add existing database mysql, import existing database folder mysql, mysql document tracking database, php mysql document archive database, order product online stores database mysql php, mysql document management database, creat document database mysql, import existing mysql database mysql database

Acerca do Empregador:
( 8 comentários ) Dublin, Ireland

ID do Projeto: #19160966

Concedido a:

mtdevil369

hi,I am 9 years experienced professional in data collection, transformation, modelling, analysis and visualization using Excel & Access automation, Tableau, PowerBI, SAS and SQL. Have worked as BI & Analytics Manager a Mais

€100 EUR em 1 dia
(9 Comentários)
3.9

17 freelancers estão ofertando em média €163 para esse trabalho

limillion819

Hi there. I got really excited with your project and I can say that really matches to my skills. Along as my worth experience of database programs, I can help and support you 100% bringing fully satisfactory result. Mais

€250 EUR in 3 dias
(15 Comentários)
6.0
bianyunzhi95

Hello Nice to meet you. I'm full stack developer with 4 years experience in sql programming. Please contact me if you are looking for a database administration expert. I can start work right now. Thanks

€222 EUR in 3 dias
(15 Comentários)
5.6
ludwig333

Hi. i am a full web developer with over 5 years on freelancer.com. ****In SPECIAL very familiar with PHP, MYSQL***** I have read your description and have interests in your project. I have rich experiences in proj Mais

€80 EUR in 3 dias
(19 Comentários)
5.1
adeelpirzada

HI, I would be able to execute dummy db and script requirements for mysql database. I am an Experienced Full Stack Lead Developer with a Decade of Experience in versatile software development methods and technologi Mais

€222 EUR in 3 dias
(5 Comentários)
5.1
KGeorgy

Hello, I am pleasure with your job for Few MySQL statements for existing MySQL database. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do ha Mais

€155 EUR in 3 dias
(10 Comentários)
4.9
bluesea1990

I'm powerful database manager. Well designed SQL will make your project useful and powerful. I can make nice SQL for your project. Please shake with me for your project.

€155 EUR in 3 dias
(20 Comentários)
4.7
HadiDar786

Hey I have great command in sql statements so I am willing to assist you with your tasks so feel free to contact

€150 EUR in 5 dias
(14 Comentários)
4.6
Abhishek2117

Hello Hope you are doing well.. I have gone though your post for SQL management and details experience with technology required. We have 7+ years of diverse experience in php. -experience with PHP ( corePHP, CI Mais

€250 EUR in 5 dias
(3 Comentários)
4.3
bluestar1027

**************Hi! Nice to meet you!! We have over 10 years IT experience as a back-end, front-end. We've been successfully completing many projects from simple project to complex one. Our key skills are: C - jav Mais

€111 EUR in 3 dias
(4 Comentários)
3.6
sodiqa32

I have gone through your project details "MySQL statements for existing MySQL database"Looking for a candidate that is extremely familiar with the responsibilities associated with the role and can perform them confiden Mais

€30 EUR em 1 dia
(3 Comentários)
3.9
scar20181206

Hello dear. My name is Sel, I am a fullstack web developer. I read your text carefully and I want to work on your project. I am good at php and have much experience with web applications. I am good at database desig Mais

€111 EUR in 3 dias
(10 Comentários)
4.5
AlexeyKala

SQL(Mysql, Oracle, MSSQL, ...) Expert Here! Web(CSS, HTML, PHP, Website Design, WordPress, CI, Laravel ) expert whom you find is here. I have 6+ years rich experience in developing web site using various frameworks. Mais

€333 EUR in 3 dias
(5 Comentários)
3.5
sagom

I'm a software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft te Mais

€238 EUR in 3 dias
(2 Comentários)
1.7
EastIndiacom

Hello, It will be a pleasure to work for you on this project as I have understood the requirement and it is perfect for me as as I have worked on similar projects before too.I will deliver exactly what you need and als Mais

€125 EUR in 3 dias
(2 Comentários)
1.3
EngSharafzaaneen

Dear Sir, I'm a senior in MySql and MS SQL and I can do anything in it. I read your requirements and i can do it I have many projects MySql and MS SQL and I will do it in Short time and high quality code and i w Mais

€83 EUR in 3 dias
(0 Comentários)
0.0
databasedba

Dear Hiring Manager, I am an Oracle Certified Database Professional (OCP). I have complete masters in computer science. I am a database professional with 15 years’ experience. After carefully reviewing the experience Mais

€155 EUR in 3 dias
(0 Comentários)
0.0