Queries magentoJobs
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.
Need help with learning sql queries and understanding how they work.
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
...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 [log ind for at se 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.
CodeIgniter/Laravel (Must) Core PHP If you have experience in CMS like Magento, Wordpress it would be an added advantage. Client Side Programming HTML (Must) CSS (Must) Javascript (Must) jQuery (Must) Database design and development MySQL (Must) - Should have idea about writing sql queries, joins, optimization etc.
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
...[log ind for at se URL] Essentially, this is a Magento bug where it spawns this type of query, despite the fact that it is a query designed for the MyISAM storage engine, whereas Magento currently runs the InnoDB storage engine. Because this query is not designed to work with Magento in its current state
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
Need to convert splunk queries to logstash
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
...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
Starting a Spiritual w...standards-compliant code. 7. Should be familiar with GIT. 8. Must have exceptional skills writing SQL queries. 9. Should be able to work individually to beat tight deadlines. 10. Should have worked on e-commerce applications and experience with Magento is added advantage. 11. Should have knowledge of Client Server application.
optimize your PHP script and MySQL queries to reduce the PHP script execution time Website using Magento Ver 2.2 Now the server default php version is PHP 7.1. System PHP-FPM service and PHP-FPM service for the domain are turned off.
Preciso reescrever algumas queries que contém funções e comandos que só o MySQL V8.0 consegue interpretar. Preciso reescrever para versão mais utilizada, que é a 5.6. Ou seja, os comandos ROW_NUMBER(OVER PATITION BY blabla...) precisam ser simplificados. As queries em questão estão anexadas. O que precisa ser feito é a...
I have started a personalised products business & need a website to sell & market my products.
We have a site where the index page loads very slowly due to poorly written queries - here is an overview of its issues. Need someone who can write queries with joins and understands what an index is etc. Here are the issues and suggested corrections: Too many sorts are causing temporary tables. Consider increasing sort_buffer_size and/or read_rnd_buffer_size
We have built a system with WordPress, and are using the Quick Chat plugin (...chat system, it begins to slow down, until the site becomes unresponsive. The hosting company have said it is due to most of the load and slowness coming from inefficient sql queries. It is being hosted on a dedicated VPS. We are looking for someone to resolve the issue.
Dallas, TX area - Non-Profit Legal Service Provider, seeking local assistance only. We utilize an Access Database built prior to 2000. The current version of our database runs safely in 2003 access. We upgraded our Server to MS Server 2013 running in 64 bit. We attempted to just run the database in the new environment and learned that it broke most of the reporting modules. Why we are looking to m...
Write queries to get the required data from mongoDB. Details attached. [log ind for at se URL]
Require resource to build Hierarchical Transact-SQL Queries Table 1 Geoboundary: Name (city, state, sales territory) Table 2 GeoboundaryType: Name (categorises geoboundary state, city etc) Table 3 GeoboundaryAssociation: FromGeoboundary - ToGeoboundary Table 4 GeoboundaryAssociationType (describes association- city to state) Table3 contains
I am looking for an elasticserch expert who can tune my elasticsearch queries and give recommendations on reducing the cpu and memory usage
Hi I am looking for an SQL expert to write 10 SQL queries We have to agree on a specific date and time, log in at the same time. i will give you access, and work together. LEVEL REQUIRED : EXPERT ! Thanks A.
i want to write 6 simple sql queries see the [log ind for at se URL]
Running a 2003 access database in 2013 64bit server, need to migrate without breaking functionality. Also, need a special report query, that will utilize several tables, and a unique Identifier of the Birth month, vs. specific birth date on customer record.
Write queries to get the required data from mongoDB. Details attached.
I need a PostreSQL 9.6 syntax expert that can produce simple to medium complexity queries. I'll provide DB access and specifications to what fields of which tables are needed to be queried
...web-form will contain several fields, from 30 to 50 fields. Several fields from the form will use multiple REST queries to web-services like [log ind for at se URL] (requires sign-up and setting the account from scratch). The REST queries should go deep into service to fetch the historical data. Having experience building stock market/trading/brokerage
Hi, mongoDB ----> PostgreSQL I have 3 collections in mongoDB. This is the data source. I have designed 8-10 different tables in excel (column name, where the data is coming from in Mongodb and data type description). There are roughly 8-14 columns in each table. All inserted data is from either mongoDB or one of the 8-10 tables. Need someone to do the following: -Storage file layout: Creat...
I have a data base manged by a system, I want to create some queries to get information from differents tables, in the same queries do some operations and IFs conditions, then download the data in excel, and create a dashboard to manage a special replenishment of requirements as a Distribution Center.
