Building search queries sql jobs
To be clear...I'm looking for asp.net EF queries. These could be Raw SQL queries, but NOT LINQtoSQL. Sorry, Freelancer won't let me updated the title of the project. I have several SQL Server tables from which I need to extract data AND perform calculations on that data. The queries will need to accept a date range and another geographic constrai...
Make a simple website which extracts data from Excel sheet according to search. Basically there is a price list on excel sheet, user enters a word and clicks on search and the website displays the price. Two line on the website, one with search and other with price.
i need a very experienced MS access programmer developer t...able to manipulate my Access database to create custom reports, custom look up tables and custom queries to produce formatted custom print out reports all done in MS Access. Must be advanced Access user and be able to easily make custom tables and queries with resultant output for reports.
I need Mysql optimized currently it has Slow queries: 9019 and some other issues which require optimisation perhaps indexing and so on. Centos 7 x64 os on VPS
We want an experienced SQL analyst to write multiple queries to extract value from data generated by our users. Databases are under Google BigQuery. After querying data we´d like to see the results in any Visualization Data Tool.
i have some complex sql queries that i need help understanding
I need the developer to solve SQL queries which are near 4-5 hour total work. Basically, there is an accounting department and payroll flow and asset flow to solve some small queries.
I need three MySQL queries for the project. I will share the schema of the three tables on which i need queries on. Need an expert with table joining and IN, LIKE statements. I need them asap.
...over due training for the selected options) - code is in place just need to add to search form to pull report. * print report and sort from a-z the by training then 30-60-90 day then by Over due then current * change report to match the same as search output run search for example - add option to export results to excel. sample login in attached file
I would like to extract json output into excel from an api endpoint . A parameter in the get is changed with values in a provided excel file. Here is an example [login to view URL] q1 will be changed according to the provided list, all results are to be in one row of excel, for each parameter variable.
...project will leverage AWS Lambda to produce and return proper Elasticsearch (6.5.x) DSL queries from data objects stored in DynamoDB. The developer will be expected to follow rules (that will be provided to the selected candidate) in order to build these queries. The developer must work in Node.js (8+) in AWS Lambda and be familiar with DynamoDB. Experience
Write executable SQL queries to answer these 2 questions. Should be easily completed by someone with SQL experience. Read attached word document. Deliverable will be the SQL queries.
be able to retrieve search queries made on major search engines
This is a pretty fast exercise for someone with experience, there are only 5 tables that need to be denormalized. Easy and quick money before Christmas! I need an expert data model engineer to take an existing physical data model documentation and derive new tables in a denormalized format. Please only apply if you have multiple proven experience working in such an exercise. No time waster.
I need you to develop some software for me. I would like this software to be developed for Mac using SQL.(3 queries)
I need to have ms sql nested query stored procedures written to replace ms access nested queries
This task requires to apply the understanding and ability to use Relational DataBase Management Systems (RD...to apply the understanding and ability to use Relational DataBase Management Systems (RDBMS) as well as use SQL in the modelling of the physical world. Based on business scenarios required to design a database and provide related SQL queries.
Using MySQL #Consider a schema as follows: Supplier(SI...how many records will ittake to represent a DNA molecule if each record can hold exactl 4 nitrogen bases (A,G,C,T) 9. What base can pair with base G and base T 10. Given A SQL Statement of the form "select a,b,c from table t" and its output, can you determine the number of columns in table t?
I have different tables of the project and I need to create some new table with same calculates as average, percentage,...also change the configuration of Database to admit "," for decimals instead of "."
...solve this issue. Some SQL query issues solve which is near about 6-7 convert this whole project to 5.6 to 7.2.1 it's a really easy task just because I am using atom so just 3 query to convert the whole project. Connect with firebase and chat HTML is ready to code that page. Condition: We can't transfer the whole code and SQL database so the programmer
Design User interfaces, ER diagram, Table structures, Table data, Forms, Queries and Reports.
I have a data analysis task and a website where chat support personals are needed.
I have a JSON database, for which I want to develop normal and some complex search queries using Elastic Search
The project requirements are listed in the document attached, it shouldn't be difficult for someone who has moderate experience in Microsoft Access and SQL Server.
create a database with a few tables using csv files provided to you (b) query this database to make certain computations and (c) report on your results
...serverless site runs dynamodb queries which return lots of records in one go. The peaky demand needs to be improved to optimise performance and cost. The data is IoT data collected every second and queries can include data from a few minutes to several years. The job is to optimise the loading and queries so the queries complete in less than a minute
...in Brazil. Marketplace is intended mostly for corporate clients but may be used by individuals. We need 2 lists of Google search queries: 1. Queries that are used by Brazilians to sell agricultural/farmer commodities 2. Queries that are used by Brazilians to buy agricultural/farmer commodities Examples of commodities: vegetables, sugar cane, soybeans
...the front glass. - left side with get - the back side is a wall with box to save the lost items. - a special place for handicapped while chairs. - upper panel written on it queries. - 1 meter down with the branding - a corner for lost children with a table and games - Open source is requested in 3 D max. - the design requested ASAP - more information
I need simple queries to be wrritten to retrieve from a database.
Hi can you help to solve simple sql queries and help to create simple api using python
We have a number of queries (and slow queries) that do not close. We need a fix about this
In this project you have to do below tasks: 1:ER Diagram 2:Normalization 3:Create tables in oracle and insert some data 4:Answer some sql queries This is not a tough project if you have a knowledge of database [login to view URL] detail will be shared in a chat box. Moreover,The budget of this project is limited so bid accordingly. Thanks
I have a Visual studio Form written in c++. This is for a business and i need my sales data put into text boxes on my Visual studio form. The database is already integrated and being used in the project. Thanks Aaron
write influx db queries for reading os metrics
Basically create a switch statement that will do different queries based on input inside the mySQL database given. All the tables are given for mySQL.
identify single fact schema, logical schema. Populate sample date is mySQL. Provide OLAP queries
Show evidence of understanding... understanding of various Business Intelligence concepts, through the design of data marts and implementation of OLAP queries. Implementation is performed in R/MySQL environment, while students need to perform OLAP queries and investigate the use of R for performing multidimensional analysis over Big Data Sets.
We are a small manufacturing shop. We are looking for a mid-to high-level of expertise in using the E2 Shoptech system (which is essentially an Access DB) to perform analyze and make data corrections, perform data entry, and produce reports. Expertise in Crystal Reports would be ideal to create new reporting from the system.
I need a php programmer to create a php script file that performs 10 essential queries on the sql database tables that have information. The results should always be based on 2 specific reference points, which will be user_id and page_id. Please bid with actual cost. this should be able to be inserted into a header file as require once, to be referred
Two short sql queries and three queries that are to be represented in relational calculus, and relation algebra
These are the queries I want you to write. Refer to the attachment for more info. Find all the pairs of musicians (give names) who share an address. Find the songs that are not performed by any musician. Find the musicians (names) who played all the songs written by 'John' (musician author name = 'John'). Find the musicians who perform a song they
I want someone expert to help with the topics and he has good experience with programming
add media queires in my css and add 2-3 javascript, basic level work
We need a MySQL Coder who can write a Stored procedure or Join Queries, I have a PHP code that is timing out so the whole logic of the PHP page has to be written in SQL Queries there are less then 6-8 tables to pull data from. The work has to be done on TeamViewer
Hi i need you to connect and write 9 sql queries asap using SQL server management tool. thanks a
...hosting with 8GB RAM. Issue to be rectified is once there are more calls continuously mysql is not returning/responding which is delaying the queries and very slow responses. There are API calls like 300-500 queries per every 10 seconds,have to fix this and response should be very quick in milliseconds,sometimes its slow and sometimes its fast,when there
