Create an SQL database with a daily refresh and data analysis routine

€100-250 EUR

Dokončeno

Zveřejněno

přibližně před 6 roky

€100-250 EUR

Zaplaceno při doručení

I have a betting algorithm I’ve been deploying manually that I’d like to automate. The first step is to automate the data collection and analysis which creates the betting signals. This project aims to satisfy that. PROJECT [login to view URL] provides all the details. Looking to have this setup and completed within approximately 1 - 2 weeks. I have setup an empty SQL database in my Azure cloud where this needs to be built. The winning bidder will be provided credentials. Other algorithms (still in development) will be built on this same dataset so getting this setup correctly is crucial for me. I am anticipating developing a working relationship for repeat business. PLEASE provide a description of how you'll address the Simple Moving Average calculations in the daily analysis routine in your proposal. Questions are welcome BUT please read the Project Brief FIRST :-)

C# Programming

Database Administration

Microsoft SQL Server

MySQL

SQL

IČ projektu: 16321237

O projektu

15 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@SergioAlfaroV

Hello! I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. I am a near-native English speaker, currently available. I have read your project brief and I can have the routine - in form of a scheduled SQL Stored Procedure (and using a SQL Stored Function to obtain the SMA) - in 4 full working days (32 full working hours) at most. I would do the following: - Use BULK INSERT to insert the data from the CSV file, to a Staging Table in SQL Server. This table would have to be cleared everyday before the loading process. - Then, use the data in the STG table to add the additional columns. The main routine contents (the calculation of the additional columns) would be enclosed in a stored procedure. Finally the main routine would insert the data in a results table (or return a resultset, that can be discussed later). - Regarding the SMA calculation: I have in my mind creating a stored function that receives 2 parameters (team, number of games) and have it calculate and return the results. In my mind, I think the function will use WHERE, ORDER BY, and TOP N statements to get the SMAs in a clear and simple way - the function would have no more than 30 rows, I estimate. Also, this function can be reusable for any SMA needs in the future. Finally! Is important to mention that providing me an Excel file with previous results would absolutely help me. I have done and delivered similar projects before.

€250 EUR v 4 dnech

4,9

(22 recenze)

5,7

15 freelanceři nabízejí v průměru €193 EUR za tuto práci

@liangjongai

I am a full time developer and have high skills in sql database, and software engineering so I can complete this project. My price and time is negotiable. Let's discuss details via chat. I'll provide best service.

€250 EUR v 2 dnech

5,0

(217 recenze)

7,5

@carlosperezit

Hi I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications I'm also available 24 x 7 Regards Carlos

€194 EUR v 10 dnech

4,8

(31 recenze)

5,2

@bnrajumnc

A proposal has not yet been provided

€255 EUR v 15 dnech

4,4

(9 recenze)

3,7

@whitehorsetechn

Greeting, I have understood your Create an SQL database task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in C# Programming, Database Administration, Microsoft SQL Server, MySQL, SQL

€200 EUR v 5 dnech

5,0

(2 recenze)

2,6

@mikhailkozalski

Hi, How are you? If you trust me ,I 'll do my best for you and my reputation. Please let's discuss more detail in this chat. Thanks for your attention.

€194 EUR v 10 dnech