Database queriesJobs

Hi I need you to reformat the sentiwordnet and insert them into the MySql database. I need the following things to be added in the sentiwordnet -- Add 3 glossary use for each word. -- Convert the positive and negative score into "Measure Score" the formula is as below: If the word is dominant positive the MS = (Positive Score - Negative

...knowledge in PHP web frameworks like Yii, CodeIgniter. Understanding of MVC patterns Good knowledge of any relational database like MySql, Oracle and should have a solid hold in creating and executing database queries. Knowledge of web technologies including HTML5, Javascript, jquery, CSS3. Should have experience in creating end-to-end

...web forms project to facilitate the data entry of new car information. Components: * SQL Server database with a single table (we will supply the schema) * ASP.Net Website, coded using C# with the following pages: - Intro/summary page with some basic database stats (e.g. number of cars in system, number added in the past N days, number edited in the past

Excesivas consultas a la base de datos de prestashop están causan que se bloquee el serv...consultas a la base de datos de prestashop están causan que se bloquee el servidor y la página web no cargue correctamente. -------------------------- Excessive queries to the prestashop database cause the server to be blocked and the web does not load well.

...bazar), Register form manager (extension bazar), and eu vat validator ( Jorim van Hove, opencart marketplace) using a custom field to check vat number is valid against the VIES database. Extension Bazar have fixed several bugs in their own extensions and included support for the custom field with euvat checking and it works fine as a B2B customer, but due

...Kreative. For more information, please visit my site: [log ind for at se URL] Plugin description I need an plugin developed, which will filter WooCommerce products. The queries to the database should be performed in AJAX for better performance and user experience. The plugin should be similar to this product filter (note that this is just an example so

We need a database for our business as freelancers, recording our projects, our incomes, calculating our taxes, profits and outgoings. For now, we use excel files as databases, but we would like something more dynamic, professional and with the option of having a better view of our business. I've already created something in MS Access but I'm not experienced

[log ind for at se URL] Website database connection down within seconds of restarting server or the mysql service. I've included the database logs on queries that our stuck. When I run these same queries in phpadmin they complete within a fraction of a second. NEED HELP ASAP!!

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

...Deal Information app The purpose of the Key Deal Information app is to store some data in a (my)SQL-Database in order to (i) Visualize the different persons/parties involved in a deal and (ii) To have access on the information stored in the SQL-Database by third-party apps. Export of stored data into OData-format is required. All the information which

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.

...• C# (need to be able write basic C# to fill the gaps in Telerik Test Studios) • Strong knowledge of SQL and able to write complex queries • Advanced knowledge of SDLC (e.g., Agile, Scrum) and QA methodologies (e.g., Smoke, Functional, Integration, Regression, System, Black box, White box,

...[log ind for at se URL] and store the initial data and any change (for instance price change, km change) on a Postgre database. The script should be developed with Python and should not be blocked by the website due to too frequent queries. The information for each car should be stored in a tabular form on Postgre. When the ad is not available anymore,

...language: C#, Java - Experience in Object-Oriented Language and Database Testing using API - Experience using BDD/TDD approach to software development - Experience in Web and API Automation testing - Good experience in service Test management - Solid experience in building SQL queries - Solid knowledge of Continuous Integration & Continuous Delivery

I need a Senior level DBA to help with database indexing and speeding up our php queries and Lookup table creation. We are getting page timeouts and slow query responses for a very Active site. You'll work with my Front and Backend developers to help speed up our pages and database queries. Full Time Freelancer wanted for ongoing work with a very

...ecommerce store onto Woocommerce and the database is causing real issues. There are slow queries and the site causes high account executions. We are told the database is too large at 1.9 GB but the previous database was 30 GB. The site has a little over 26,000 products. We need someone to optimize our queries and database structure so that the site will...

Tune/repair SQL database to optimize queries and reduce server CPU load New website using Word Press causing excessive load on CPU resources. Need help identifying and repairing slow queries causing increased resource consumption and the utilization of CPU

...functions, primarily to contact landowners who have potential energy development opportunities. We will provide a sales script (telephone, mail, email and voicemail) and a database of leads. Some data mining or internet research may be required to find the contact number of some landowners. The lead generation specialist is expected to: - Initiate

I have a web app based on php /mysql . I need this as shopify version. It's a reporting app , Queries database and shows result. 1) Please mention which language you will need 2) Please mention if you have worked on such app before 3) Please mention if you are a full time dev or not. If you are full time dev what is your work hours. I need this

Google Trends Search Data Related Queries Keywords Extract and Save MySQL. Details: Step1 : Data Available here... in google trends > [log ind for at se URL] trends/ explore?date=all&q=wallpapers Step2: Get All related queries (keywords)... Trending and TOP Step3: Save these related queries to MySQL database. Send me message for more details...

We wo...Web App. We need to discuss first the database(normalize or any improvement). Then to convert the Access forms to web form, using Bootstrap 4, PHP PDO and little ajax. The app will store customers with their appointment and finances. Also, suppliers and expenses. And finally, settings to app with statistics(queries). It is a simple app CRUD.

Need to create an access database forms, queries and reports in a required format.

i need a very experien...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.

...styles ✓ Follow industry naming conventions FTP: ✓ Understand the way servers and database communicate to put your HTML + CSS file on World Wide Web ✓ Make site go live! ✓ Update site after it went live ✓ Explain FTP to a 5-year-old Media Queries: ✓ Create media queries for standard device sizes ✓ Translate a static website into a responsive one ✓

The project involves creating reports from relational database. What I need is to have somebody built SQL queries for different metrics and then exporting the data into Excel sheets. The database is MS SQL Server. More information will be sent additionally.

We have a hosted database application containing some information we want to make available to our clients on their mobile phones, preferably via both push and pull methods. For pull requests we require some form of security and id so clients only obtain their data subset. The hosted application has a supported API. Number of customer is low (<5,000)

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

...Kreative. For more information, please visit my site: [log ind for at se URL] Plugin description I need an plugin developed, which will filter WooCommerce products. The queries to the database should be performed in AJAX for better performance and user experience. The plugin should be similar to this product filter (note that this is just an example so

I need a DBA to help with database indexing and speeding up our php queries. We are getting page timeouts and slow query responses for a very Active site. You'll work with my Front and Backend developers to help speed up our pages and database queries.

...website where people should come login /signup that details should save in database where i can reuse later , every person should have separate room /space to post heir questions , similarly problem solver should have separate profile who will come and answer people queries . this can be seen by remaining people . simply my website should be like people

Need to create a chart (dynamically using data provided by several queries. I will provide the queries. The main result includes two tables, one table for the nodes and another for the links between the nodes. The charted items will be determined from a query string ID Database is MS sql server. Code is C#/Javascript/jquery. Application will be hosted

...Server 2012 and 2016 databases * Thorough understanding of relational databases with good Knowledge of SSRS, SSIS, SSAS, Cubes * Should have worked in tables designing, Complex queries, CTEs, Views, Stored procedures, Function * High degree of communications and interpersonal skills * Extensive knowledge of product lines and technical knowledge * Excellent

...video gaming club, not a corporation. We are looking for a full stack solution, preferably deployed in AWS. The three main components would be a web site front end, a simple database on the back end, and lambda (or cron job?) to pull data from a 3rd party via web API. We are thinking a Beanstalk, RDS, Lambda combo but are open to other architectures.

...comparison websites in EU. Create SQL database in Azure. What kind of fields? 1. Product number, manufacturer number, description, price, Promo price, Dealer Price, currency, date, Qty, Manufacturer, Supplier name, Status of product, Product group 1, Product group 2, What do we want to see? Automatic daily queries Visual in a simple web interface

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.

...an IOS function to send PGP messages to BlackBerries within one of our app. Most of our app will already be coded when you will be starting. The app will have a MySQL database with users and a VOIP function, but we need a button that will allow people to send messages to PGP BlackBerries through our iOS app. - The app's dev has to have a wide

Write SQL queries for ETL job.

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.

...'+'), available in database as seperate columns. c) Search box & home button should remain consistently on top while on the search result page. d) Display picture should be there for each medicine on its page which could be uploaded from admin panel. e) 2 tabs would be added on the medicine result page, achievable using SQL queries i. Substitutes with

I am looking for a wordpress expert who ca...our site suspended. We need someone that can convert the Wordpress cron to an actual cron job, Configuring caching for the site, and optimizing our sites mysql database, and mysql queries so that there is less demand on resources. Someone who is able to work on this now and have completed in 2 to 3 hours.

...and execute database queries and conduct analysis • Develop and update technical documentation Technical skills • Proven experience as a BI Developer • Experience in Qlikview • Understanding of enterprise BI and data warehousing • Background in data warehouse design (e.g. dimensional modelling) and data mining • Knowledge of SQL queries, SQL S...

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.

We are planning to develop a web application in Hospitality domain. Expert need to give advise for the following queries. 1. Choosing relation vs document-oriented database for POS with offline support 2. Mimized development time 3. Explaining the Features so that we can choose that technology 4. How the technology will minimize the time for fixing

We are planning to develop a POS web application in Hospitality domain. Expert need to give advise for the following queries. 1. Choosing relation vs document-oriented database for POS with offline support 2. Mimized development time 3. Explaining the Features so that we can choose that technology 4. How the technology will minimize the time for

...management system, the key technology and problems to establish TGIS are: the construction of tourism geographic information database; the establishment of data structure and the data model; the design of Tourism Geographic Information Database System. The essay also proposes the development prospects of the combination of GIS with new information technologies

...their locations. Bus location is updated every 2 seconds, so it's almost real-time. Each bus is running an app which writes their location to our database every 1 - 2 seconds. The website queries the database and uses Google maps to plot the locations of stops and bus pins. What we want to do is add an ETA onto each bus, to show approx how long until

I am setting up a database which brings in accounting information from a number of entities and attempts to pool the information together into a series of consolidated group reports. Each Table represents an entity within the group. The Fields are months dating back 3 years or so, and the Records represent a numerical value for a financial account at

I have a website and need some changes made, see attached list with website logon to view what needs to be done. * termdate field needs fixed - does not update termfield * Add - "are you sure " when you click the delete * change "subadmin" to only allow view only * add report for subadmins - add 30-60-90 over due report email to each subadmin for each location. * fix report pag...

...each dataset to look for patterns, use clustering algorithms and other algorithms; like k means. Take facts and statistics on road traffic accidents I give you, use mysql as database. More Information below. ............................................................................................................ Create a Java application, plotting