Designing queries help job search accessemplois
On veut développer une application qui gère les rencontres des tournois de Tennis d’une saison donnée. Chaque joueur a un nom et un sexe. Deux joueurs peuvent former une équipe. Un tournoi est identifié par son nom et se déroule dans un pays donné à une date prévue. À la fin d’un tournoi, un jou...
We have a list of slow logs that needs to be addressed. For this we need a developer with good skills in php and mysql as queries needs to be optimized
We are coming to the end of the implementation stage of SAP B1 HANA 9.3 and will require ongoing queries and reports to be created or amended.
Hello there! We want to implement TecsDoc Sql to implement in to our shop search engine which base on wordpress. Only expert needed Note! mention in proposal that you have read the the project >TecDoc< on top in proposal.. Happy bidding
...(coding + sql database) and also understands ad technology (ad tags, conversion tracking, debugging pixels) - familiar with the retargeting mechanism. I have some doubts and queries - you just need to assist me with the right solution. Budget is $30 AUD, only bid if you are happy with it. Have more projects ongoing basis, if this is successful. Thanks
...(coding + sql database) and also understands ad technology (ad tags, conversion tracking, debugging pixels) - familiar with the retargeting mechanism. I have some doubts and queries - you just need to assist me with the right solution. Budget is $30 AUD, only bid if you are happy with it. Have more projects ongoing basis, if this is successful. Thanks
Need some help making some custom SQL queries to generate csv files to use for import to a second system
Going to be following a list of directions/steps to creat queries in Microsoft Access (Removed by Freelancer.com Admin)
...database and/or WordPress expert who can query WP databases to extract specific information based on customer purchases, as well as invoice data and then create away for us to access that data in a digestible way - ideally, CSV or excel spreadsheets with the data clearly organized and sortable. We are looking for the implementation of a system that can
We need some helping in understanding C++ concepts and also some code if required
I need help with a few XPath queries in selenium [se connecter pour voir l'URL] -> how to tick the T&C checkbox [se connecter pour voir l'URL] -> how to select the dropdowns [se connecter pour voir l'URL] -> how to click Join Now button for 100% Bonus Up To £200 at the bottom of page, also for registration, how to select the country prefix
Searching an Expert who can optimize some mysql queries and optimize the database
...A player’s position should be one of ‘G’, ‘D’, ‘M’ or ‘S’ representing a goalkeeper, defender, midfielder or striker, respectively. PART 2 Write the queries below in relational algebra. Your queries should work for any database that satisfies those constraints. 1. Report the country of the team that has played in every stadi...
I have created (2) MS Access databases that I want help with similar functions. Both databases I want to be able to have one command button that opens a file browser to locate the specific excel spreadsheet I want to import, have it add that spreadsheet to a temporary table so a query can be ran to remove new duplicates that may already be in the
...collection of latitude/longitude data belonging to different devices, looks like this: deviceid,lat/lon,timestamp I need someone professional in postgresql and/or mysql to write queries that do the following: - for each device, find the most frequent location between 2 time ranges over a period of x months - find the intersection frequency between a device
...collection of latitude/longitude data belonging to different devices, looks like this: deviceid,lat/lon,timestamp I need someone professional in postgresql and/or mysql to write queries that do the following: - for each device, find the most frequent location between 2 time ranges over a period of x months - find the intersection frequency between a device
...collection of latitude/longitude data belonging to different devices, looks like this: deviceid,lat/lon,timestamp I need someone professional in postgresql and/or mysql to write queries that do the following: - for each device, find the most frequent location between 2 time ranges over a period of x months - find the intersection frequency between a device
Hi I have a high traffic CMS website which is facing alot of High load due to %ysql Queries The CMS is Vivvo script . we need someone to optimise server queries ( caching issue and check our CMS caching system ) If he is Expert with server optimisation and NginX it will be good Regards
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 constraint
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 that is 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 [se connecter pour voir l'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 (RDBMS) as well as use SQL in the modelling of the physical ...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(SID,NAME,SUPPLIER_ZIP) Parts(PID,PNAME,PTYPE,SID) Sale(SHOPID,PID,SALES_DATE,QTY) Shop(SHOPID,SHOP_ZIP) Use VOLUME = SUM(QTY) #SUPPLIER with SID supplies this part. PTYPE can be Perishable or Imperishable. # there can be more than one SHOPID per SHOP_ZIP and more than one Supplier per Supplier_ZIP # more than one supplier can supply a PART ...
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 "."
The project is using PHP 5.6 the work is near taking 2 hours to 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 S...
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.