Sql query to retrieve data from database jobs

I'm seeking an experienced developer to assist in optimizing database speed for my Node.js website. Key tasks: - Conduct initial review of current setup, hosted on a Hostinger VPS with a configuration of 16GB - Advise and implement changes to improve response time, usining knowledge of different hosting platforms such as Amazon Web Services, Google Cloud Platform or Microsoft Azure. - Familiarity with MySQL as a database management system is a must. Ideal candidate would possess keen problem-solving abilities, strong knowledge in database management and previous experience with Hostinger VPS. Experience is optimizing Node.js websites is advantageous. Please provide examples of similar assignments in your proposal.

Creating a site with Wordpress from a Figma model.

...an expert programmer to build a web scrapping tool that can effectively scrape specific data across 1000's of web pages. The specific websites for this web scrapping operation will be college and university athletic pages. Therefore, among the required skills is the versatility to adapt to different websites' structures and frameworks. In terms of data structure, the scraped data should be organized and stored in a Google Sheets according to categories. This approach allows for a more coherent and systematic pattern for data analysis and representation. The ideal professional for this task should possess: - Proficiency in web scrapping - Expertise in Python or other relevant programming language - Experience with Goo...

I am seeking professional assistance to organize my computer files in a manner that reflects their content and to establish appropriate naming conventions. My digital storage contains a diverse range of files, and the current organization lacks coherence, making it challenging to locate specific documents efficiently. I am looking for a meticulous organizer who can categorize my files based on their content, ensuring that related documents are grouped together logically. Implementing a standardized naming convention is crucial to improving the accessibility of these files, enabling me to quickly identify and retrieve the necessary information.

I am in urgent need of a proficient developer with expertise in AWS, .Net Core, and CloudFormation to create a simple Lambda function to process messages coming from an SQS Queue, and to create a CloudFormation template for easy resourcing and deployment of the function. This needs to be done as soon as possible. Key Requirements: - Design and construct a .Net Core AWS Lambda function to process frequent messages from an SQS queue. Each message contains a small data volume (less than 1MB). Once the message is retrieved the json should be sent to an API (mock API) - Develop a CloudFormation template to build the required resources and deploy the function. - The cloudformation template should also have Environment spec...

I am seeking a skilled data scraper for a specific platform-oriented task. Your task includes: - Extracting product information such as Reference, Type, Value, Bedrooms, Suite, Garage, Area, Neighborhood, City, Address, Captor, Registration Date, Website, Owner's Name, Owner's Email, Owner's Phone, Owner Category, and Owner Captor. - Downloading all images related to each product and saving them in a separate folder named according to the product code reference. Ideal candidates should have proven experience in web scraping, data mining, and handling a substantial volume of data extraction for digital products. A proficiency in automated image scraping and sorting is a must, along with familiarization in accessing various platforms to...

...server setup is causing slow response times for my web application and database system. This project involves optimizing the server settings to enhance the performance of both the web and database applications. Ideal Skills and Experience: - Proven experience in server performance optimization - Expertise in managing servers running web applications and database systems - Familiarity with Laravel, as the web application is built using this technology - Excellent understanding of server-side technologies and configurations Key responsibilities: - Diagnose the current server setup to identify performance bottlenecks - Implement necessary changes to optimize the server settings - Regularly monitor and fine-tune the server to maintain high...

I'm looking for a skilled data scraper who can extract specific information from Hungerstation mobile app and compile it into a spreadsheet. Key Requirements: - The data I'm interested in are the menus and prices of the restaurants listed on the app. Deliverables: - The final output should be a well-structured, easy to navigate spreadsheet containing all the menus and prices from the app. Ideal Skills: - Experience in data scraping and extraction - Knowledge of extracting data from mobile apps - Proficient in compiling data into spreadsheets Please apply if you have the skills and experience required for this task. Feel free to ask any questions for clarifications before you begin.

scraping 2750 records from gold-coast-tweed-heads-nsw

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

I have an Android application that I'd like to enhance with a review feature. - The reviews should be submitted on a third-party platform linked from the app. - Ideally, I'd like to incorporate some form of user authentication before reviews are accepted. I'm open to suggestions on how to best handle the authentication process. The overall goal is to encourage genuine and constructive feedback while preventing spam or irrelevant reviews. I'm looking for a developer with experience in Android app development and implementing user engagement features. It's important that the final solution is user-friendly, secure, and seamlessly integrated with the existing app. Your ability to propose and implement a secure an...

I'm in need of an experienced Tableau Developer/Analyst/Designer to help me enhance an existing dashboard, and improve its performance and functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best...

I'm seeking a professional freelancer who can meticulously remove text watermarks from various photographs. - Primary Task: Accurate and subtle removal of text watermarks from my photographs, without affecting any area of the images adversely. - Output: Photographs should retain their original quality after the watermark removal. Ideal freelancer must: - Have a proven track record of handling similar projects and using image editing software competently. - Be detail-oriented to ensure that there is no damage to the original image. - Deliver high-quality, original-retaining photographs promptly. Your handling of this task must uphold the integrity of the photographs while removing the watermarks completely.

I am looking for a specialist to create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI test cases, with a clear emphasis on user interaction tests. - Setting up and integrating Routing and Guard Components for authorization. - Developing a backend in Spring Boot. - Saving credentials in a MySQL database. Ideal candidates should have solid experience with React Js, Spring Boot, and MySQL database. Proficiency in creating user interaction tests is also a must. Once completed please provide a GitHub link for the project in .docx file with screenshots of the UI.

...fields (2021 & 2022 passout only)? Are you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opport...

I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. ...Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoD...

...experienced data analyst with expertise in SQL and R to conduct a thorough review and testing of a recently completed data analysis project. The successful candidate will be responsible for evaluating the accuracy and completeness of the work, ensuring all requirements are met, and identifying any potential issues or opportunities for improvement. Responsibilities: Review the SQL queries and R scripts used in the project for accuracy and efficiency. Test the data outputs to ensure they align with the project requirements. Verify that all analysis reports are complete and adhere to the specified guidelines. Provide a detailed report outlining any issues found, confirming requirement fulfillment, and suggesting any potential upgrad...

I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.

I'm looking for a diligent freelancer who can help with entering text data from handwritten documents into a digital format. Requirements: - Entering text data from handwritten documents - Ensuring general accuracy (minor errors are acceptable) - Organizing the data in a clear and coherent manner Ideal Skills: - Proficiency in data entry - Attention to detail - Patience and perseverance - Basic understanding of the English language The task requires someone who is meticulous and can maintain a good level of accuracy throughout the process. If you have experience with data entry and can ensure timelines are met, I'd love to hear from you.

...a seasoned data entry professional who can attentively transcribe information from various online databases into Google Sheets. The role is strictly manual data entry. Skills and Experience: - Proficient with Google Sheets and similar spreadsheet management tools. - Past experience with database interaction, particularly online databases. - Must have a keen eye for detail to ensure accurate data transcription. - Excellent time management skills are essential as deadlines are strict. Although this position emphasizes manual data entry skills, experience in data cleaning and validation pave the path for optimal efficiency. The successful candidate must provide proof of prior similar projects. Your ability to maintain high...

I need a Word file created from the content I will provide. The content will be used for a legal documentation/report. Key Requirements: - Type the provided content into a Word file - Ensure accuracy and appropriate formatting - Comprehension of legal terminologies and conventions is preferred, though not mandatory Ideal Skills: - Fast and accurate typing - Experience with Word processing - Understanding of legal terminology (preferred) Please note, the content will be provided in raw form and will need to be transformed into a cohesive, well-structured document. If you have experience in legal document creation, it would be a huge plus.

I have a hosting on Bluehost that is infected with malware, on this hosting I have around more than 50 websites, but I want to focus on 3 specific websites, I want these sites to be cleaned and migrated to a VPS that I have with another provider , we look for efficient methods that guarantee 100% security that no malware will be transferred to the vps, we seek to be aware of the process and know the methodologies applied, therefore we hope that these 3 websites are completely free of malware at the time they arrive at the new VPS, both the cleaning and the migration is what we are looking for the job.

...a skilled professional to create a robust AI-driven marketing program. This project aims to optimize the marketing database, generate sales, and increase our revenue. Key requirements include: - Building an AI system for data verification to ensure high-quality, accurate information. This includes email verification, phone number verification, and address verification. - Implementing an AI program to sort and segment lists for each campaign. It should consider the following criteria: - Demographic data: Utilizing data such as age, location, gender, and income level. - Customer behavior data: Tracking and understanding customer interactions with the business, such as preferences, buying habits, and engagement. - Purcha...

...professional to develop a very small, two-screen mobile application for Expo. This project does not require integration with any external database or backend creation. There is no login functionality. Your responsibility will be to develop an interface similar to figma and with the functions below. *Does not need to be identical to figma, but maintain logic. Link Figma: How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved in a local sql-lite database

...site built out to match our Photoshop design. A PDF of the design is attached, the Photoshop file and resources will be provided after we start the project. Looking for someone to start on this ASAP. Project details are below. * We want someone to work on this over this weekend so we can have something on Monday. Does not need to be completed, but need to have progress. 1. We have already setup the site and installed a theme here: 2. We are using the Avada theme and page builder. We've installed demo content. This content should all be replaced. 3. This is a single page website, but has quite a bit of content on it. 4. Style this page to match the attached design. 5. Menu: the design does not have a menu, but we want the current menu ...

My WordPress website is currently displaying "Error establishing a database connection" and I can't access the admin dashboard. I need an experienced freelancer with deep expertise in WordPress troubleshooting and database issues resolution. Tasks will include: - Diagnosing the cause of the database connection issue - Fixing the problem to get the website back online - Ensuring all website features are functioning as they should post-fix I'm using a Cpanel on Godaddy for hosting. So, familiarity with Cpanel and Godaddy is a requirement for this task. Also, I'd prefer someone with immediate availability as this is a high-priority issue. Skills required: - Advanced WordPress proficiency - Strong understanding of databases - Experienc...

I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link

I'm looking for a skilled photo editor to remove unwanted objects from the background of 8 photos. The objects include vehicles, power lines, partial buildings, and roads. The ideal freelancer will have expertise in photo editing and manipulation, with a sharp eye for detail and a strong portfolio that demonstrates previous work in similar projects. Key requirements: - Removing vehicles, power lines, partial buildings, and roads from the background of 8 photos. - Ensuring the new background looks like natural scenery. Please submit your past work for review.

I need a proficient SolidWorks designer to distinctively translate my 2D CAD drawing into a Solid 3D model. This model is primed for manufacturing purposes. Therefore, accuracy and adherence to provided specifications are key. • Skills & Experience: - Expert in SolidWorks software and solid modeling. Familiar with manufacturing processes. Previous experience dealing with manufacturing-oriented models is a significant advantage. Please note: I've already selected a material for manufacturing, so no suggestions are needed in that regard. Your task would revolve solely around 3D modeling. Let's create a model that facilitates effective manufacturing! Your expertise is appreciated.

Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', '...

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the abi...

I have an online database searching service and I'm looking to upgrade its current features and introduce some new ones. Key Features to Add: - Advanced Search Options: I'm interested in building on my current search function to offer more refined search capabilities. - Scraping: I'm looking to add a data scraping capability to my service. This will involve extracting data from various websites and integrating it into my existing database. - AI Data Analysis: I'd like to incorporate AI data analysis functionality into my service. Specifically, I'm interested in pattern recognition and data clustering. Other Enhancements: - Batch Searching: I need to impleme...

...engineer to construct a minimalist portfolio website for me on a custom domain. I believe the minimalist design will promote simplicity and emphasise my portfolio itself rather than the design aspects of the site. Ideal Skills and Experience: - Proven experience in website creation on custom domains - A strong understanding and appreciation for minimalist design principles - Ability to bring concepts to life, balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional portfolio site. Things ...

I'm in need of a skilled video shooter to create a short promotional video for our hospital. Person must be from Delhi. The purpose of this video is to engage our audience and communicate the essence of our hospital. I am looking for an engaging, high quality video resolution.

...on MongoDB for data. As of late, there have been noticeable delays during actions that involve fetching data from the MongoDB database, significantly impacting the user experience. I'm seeking a skilled developer who can help me address these performance issues. Key Tasks Include: - Investigating and identifying the root cause of the slowdown when fetching data from MongoDB - Implementing optimizations and solutions to improve the performance of the server actions, particularly those related to database interactions - Testing and validating the improvements before deployment to ensure they effectively address the issue without causing any unintended consequences Ideal Freelancer: - Proficient in and MongoDB ...

...professional to create a comprehensive database ( 10,000 to 20,000) of Non-Resident Indians (NRI) working and/or residing in foreign countries like USA, UK, SIngapore, Canada, Australia, Dubai. Their age group may be between 22 years to 42 database will be used for marketing and promotions for my existing business. Key Elements Needed: - Name - Email - Mobile - Company Name (if available) - Country of Residence or Work Data Collection Methods: - Online Surveys - Social Media Platforms - Public Records Skills and Experience Needed: - Experience in data collection and database creation - Proficiency in using online survey tools - Familiarity with social media data mining - Ability to identify and use relevant public...

I am looking for an experienced freelancer capable of creating a simple web scraping tool, able to extract text content, images, and links from a specific url (you just need to do one single url and I take it from there). The extracted information should be in a python dictionary and saved to pkl Skills: - Experience in web scraping - Proficient in handling js and automation This is a very simple project for the right individual. I need all the visible info and images (no maps) plus the info in the JS that must be reached by clicking a button. This is a couple of hours of work max, and needs to be done in Python and for today. I will provide the URL when I make sure you can handle the job. Thanks

- all history and Engineering , Economics , Physics , Earth Sciences, Mathematics , Computer Science All PDFs in these categories will be downloaded!

I'm in need of a professional who can access and retrieve information from a partner's iPhone without physical access to the device. Specifically, the task involves obtaining: - Message history - Media shared - Contact list A deep knowledge of iPhone's security, WhatsApp functionality and ethical hacking is desirable. Understanding of remote data retrieval is essential. Please note that this task should be done ethically and within legal confines.

I need a...who can assist with a critical data entry task. This job requires pinpoint accuracy and being meticulous in handling alphanumeric data. The data, which will be extracted from PDF documents, will then need to be organized and written up in a document. Key responsibilities and skills include: - Expertise in data entry, specifically with alphanumeric data - Proficient in handling PDF documents - Can accurately transcribe data into a document - Attention to detail to ensure all data are captured as needed - Strong organization skills to ensure the final document is clean and easy to comprehend Experience in a similar undertaking will prove advantageous. Please provide examples of any releva...

The goal of this project is to develop a web application called "AI Scanner" that allows users to input any website URL or document, scan the website/document for relevant data, and then interact with an AI model to retrieve information from the scanned website. The application will also include a chatbot feature that can be easily integrated into other websites as a microservice. Additionally, the application will support payment methods for premium features. Requirements: Website / Document Scanning Functionality: * Users should be able to input any website URL or document into the application. * The application should scan the website and extract relevant data for processing. * Extracted data should be stored in ...

Hello fr...large amount of numeric data into a database. Here's what the ideal candidate would bring to the table: - Expertise in data entry, particularly with a focus on numeric data. - Proficiency with databases; experience with both creating and updating entries is necessary. - Demonstrated ability to manage large datasets, as the volume of data for this project is over 1000 entries. - Strong analytical skills with a propensity for accuracy. Your task will involve accurately capturing the numeric data and ensuring its successful entry into our database system. The success of this project is reliant on not just swiftly completing the task, but maintaining a high level of accuracy throughout the process. Thank you and I...

...an expert to create a detailed PowerPoint template from a provided PDF. The purpose of the template is for marketing. The following are the project requirements: - More than 20 unique slide designs. Total number of slides: 37. The PowerPoint presentation should accurately reproduce the PDF document without any inconsistencies or variations. Images, icons, and other assets will be provided. - 3 colour schemes: The primary colour scheme should match the PDF, and two additional unique colour schemes are required for variety. We will define the two additional colour schemes. - No animation is needed. Just transitions. The ideal freelancer for this project should be a PowerPoint design expert with a meticulous eye for detail. A profound understanding of colour theory is a...

We are looking for someone to take a T-Shirt mockup from a supplier and make a Photoshop action the shirt transparent so it can be used in an online customiser with the background colour set. This should retain highlights and shadows, and work correctly to show the correct colour through when any colour is set as the background. You can see an example of how this should work in the attached files (we have original and completed files). Any queries please ask.

ib gw docker build from source

I'm in need of a highly skilled freelancer who can develop an AI-bas...ranking: The system should be capable of ranking search results based on their relevance to the search query. -Personalized recommendations: The ultimate goal is to personalize user experience, thus the engine should be capable of generating recommendations based on user behavior and preferences. In terms of data sourcing, the AI engine should primarily draw information from databases. A background in data mining and database management would therefore be advantageous. Proven experience in AI, machine learning, and natural language processing is a must-have. Understanding of UX design to foster user-friendly interactions is also highly desirable. If you ...

Hi, I am looking for a person to do a data entry job. I will provide a group of 80 files. The job comprises of 3 tasks : For each file: 1. Replace the logo 2. Replace text 3. Create prompt for the text, copy paste from chatgpt Finish!

I've run across an issue in my WordPress / WooCommerce site that I'm not sure how to fix. I keep getting the error: "WordPress database error Commands out of sync; you can't run this...". This error is not related to specific actions or queries on my site. It's clear I require someone skilled in problem-solving and debugging with: • Extensive WordPress and WooCommerce experience • Clear understanding of WP databases and commands • Proven ability to address and correct site errors Please, I need this problem solved urgently. Your expertise and prompt attention to this will be greatly appreciated.

...proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly in automation applications. - Experience worki...