Sql query help jobs

I'm seeking a skilled database designer with a strong background in Microsoft Access to create a comprehensive relational database tailored to my business needs. **Core Functionalities Needed:** - **Data Entry Forms:** User-friendly interfaces for efficient data input. - **Report Generation:** Dynamic reporting tools for data analysis and decision making. - **Query Design & Execution:** Advanced query options for effective data retrieval. **Key Requirements:** - Experience with Microsoft Access relational database design. - Proven track record in programming robust data entry forms. - Ability to construct detailed, actionable reports. - Expertise in developing custom queries for complex data sets. - Familiarity with setups accommodating multiple workstations (non...

...our project so its essential that the developer be familiar not only with woocommerce but with customizing and creating plugins for woocommerce. Our projects use: GITLAB -> C# , , Shopify digital product sales, mobile phone eSIM sales, 1.5, Bootstrap 3.0, ag-grid, Ionic framework, Font Awesome MS SQL 2017, webAPI MVC, ASP.NET, Kendo Controls, and all work is delivered via Gitlab Key Responsibilities: You will be working under and have the orientation and help of our project manager to do mostly back end work creating new and also improving existing functionalities of our project as well as create and customize a new store using woocommerce. This is for ongoing long term development and we will start with some short sprints to be delivered in 2-3 days and then start...

Hi I have set up the basics of a website in Wordpress - someone to help with making it useable, easy to locate, easy to read etc… I also need some adjustments to my current website for my psychology business. The new website is about my writing

I need an immediate help to create a PHP script to call one specificc SOAP API. I tested it via SoapUI sith username and password and it works but I cannot let ot work via PHP. It should ve bery bery simple

Aplicación Web para Puntos de Ventas Se requiere un programador FullStack Freelance con conocimiento en React y Sprint Boot, para el desarrollo colaborativo de un Sistema Web de Ventas con Base de Datos SQL Server. Funciones: Desarrollo de Estructura del Proyecto FrontEnd Desarrollo de Componentes FrontEnd Reutilizables Integración con Servicios Web REST (API) Mejoras y Optimizaciones según corresponda Desarrollo de BackEnd de Forma Parcial El proyecto tendrá una duración de 3 meses, entre análisis, diseño y desarrollo. Se coordinara para integrarlo al equipo en las etapas de diseño y desarrollo.

Hello, I've been working as a data engineer at a technology consultancy firm for a year. I'm looking for a mentor to quickly specialize in my job and also to earn extra money through freelance work. The person I'm looking for should be able to help me find freelance jobs. I will allocate all the income from my first three freelance jobs to my mentor. If this person wants to continue working with me, I will directly transfer 50% of the income from the next 10 jobs to them. During this process, what I expect from my mentor is assistance in finding freelance jobs, general guidance once found, and answering my questions when I encounter challenging situations. Apart from that, I will handle the jobs on my own. My goal is to create a win-win strategy by combining the ment...

I need someone to help me file personal and business tax returns for 2021, 2022, and 2023 I have quickbooks date and 2023 bank statements. I will admit my bookkeeping was terrible. the business is now closed

I need a developer with experience in ESP32 programming to create software for me. The project is to develop a BLE (Bluetooth Low Energ...interface to filter by MAC, scan/connect/disconnect, status display etc - Configure Wifi interface to connect to broadband gateway - Remote control for ON/OFF, set forward frequency, configure device etc - Send data from BLE device at a configurable frequency Remote Server (Simple demo server): - Any machine running Python/Node/PHP server - MQTT and Web service with security - Store data into any DB (SQL preferred) - Send configuration (JSON) into the Gateway remotely Ideally, you should have prior experience with BLE and ESP32, with similar project. Your experience with any server stack, BLE, Wifi, and MQTT will be crucial to the success of thi...

... Ideal Skills: - Exceptional Android development experience. - Proven track record in backend development. - Prior experience in matrimonial/social networking app development. - Solid understanding of clean, professional design concepts. Points to note - 1. Android app Code should be in Kotlin with MVVM architecture and modular packaging. 2. Backend should use an SQL or relational database with REST APIs so we can later query on it, also backend should be able to handle Images of the users with scalability is must. 3. Security for backend- since it would contain user confidential data. 4. Design can be normal but just keep it clean with something in blue theme I will get it updated later on from you once I have designer. 5. Support on deployment of backend to web service...

We require an ERP & CRM Cloud Solution that fulfills the following requirements but note that I specifically need my ERP in PERN stack ( Postgres SQL, Express, React, and Node.js). The codes must follow best practices with responsive design as well. - Integration of essential business operations: - Inventory Management - CRM - HR Management - Sales Quotation, Invoices - Purchase Processes - Financial Reporting - Authentication and Authorization using JWT tokens. Technical Requirments. - in backend - React at frontend - PostgreSQL ad Database Note: No outdated technologies, i.e. jQuery, or bootstrap. Key features: - Efficient Stock & Sales Processes - HR & Payroll Management - Accurate Financial Modules - Comprehensive Reporting Systems In detail requ...

I am looking for a PHP programmer to help with various tasks for my website. The project, **-quote the word- includes the following requirements: Functionality improvements: - Adapting data structures (database and website) to a new form of CSV source files. CSV source files: - There is no specific format -csvtodb- for the CSV source files, BUT, there is 1 to follow. Email sending: - Currently, the website uses PHPMailer for sending emails from tables. - I am open to suggestions for -as first word in your answer-alternative platforms or tools, as I am not familiar with the worthiness of PHPMailer. Ideal skills and experience: - Proficiency in PHP programming. - Experience with SQL import from CSV files. - Knowledge of different email sending -to prove you are not auto mei...

...development to support database management. - Create robust APIs using Node.js/Laravel/PHP. - **Skills I'm Looking For:** - Proficiency in HTML, CSS, and JavaScript. - Expertise in React.js for front-end development. - Experience with Laravel or any PHP framework for back-end development. - Strong understanding of Node.js for scalable applications. - Knowledge of database structures and SQL. I need someone with a knack for creating intuitive layouts and who can guide the design process as my vision for the project's looks is not yet defined. Collaboration with me to brainstorm and implement visual concepts is vital. I am also hoping for suggestions to make the user interface as engaging and interactive as possible. In short, the ideal candidate will be a ...

I urgently require an expert to replicate certain data operations from a Qlikview load script into PowerBI power query logic. The output should match the data I currently export to Excel. Here's what's needed: - Filter and sort database records effectively. - Seamlessly join multiple tables as per the existing logic. Ideal candidate skills: - Proficiency in PowerBI power query - Strong understanding of data transformation techniques - Experience with Qlikview to PowerBI migration - Ability to work quickly and accurately under pressure

...seamless registration, and practical job searching features. **Desired Website Capabilities:** - User-friendly interface for company registration (clients) and individual registration (candidates). - Simplified job search functionality with basic filtering options such as job title and location applicable to all users. **Ideal Candidate Should Possess:** - Proficiency in C# and Microsoft SQL Server for backend development. - Experience in creating user registration and job search systems. - Ability to implement an admin panel to manage the website. - Knowledge in ensuring data privacy and secure information handling. **Key Responsibilities:** - Construct a robust backend system tailored to the outlined registration requirements. - Design a search feature that pr...

...designed. The platform should be equipped with a number of advanced features, specifically: 1. AI Integration: The website needs to integrate with following AI tools: - ChatGPT - Bard - Google Colab 2. YouTube Integration: I want to utilize the YouTube feature on my Science website for curating educational science content, in addition to the previously mentioned AI integrations. 3. Query Generation: I want a feature that will allow users to generate queries. This should be based on user input to provide a personalized and interactive user experience. Freelancers with a background in web development, AI integration, and a keen eye for user experience are ideal. Previous experience in educational and/or science-related projects are a plus, but not necessary. Know...

I'm seeking an experienced developer to integrate Apollo for GraphQL functionalities and Mailgun for email automation on my Squarespace website. Your mission: streamline data and enhance communication. **Requirements:** - Set up Apollo integration for: * Real-time data fetching * Query batching * Error handling & metrics - Configure Mailgun for: * Email marketing campaigns * Automated responses * Tracking & analytics **Skills Needed:** - Squarespace development proficiency - Apollo GraphQL expertise - Mailgun setup experience - Strong grasp of DNS configurations - Proficiency in JavaScript Your work will optimize my site's functionality and improve user engagement through timely data updates and efficient email handling. Please share your relevant ex...

I'm currently facing some issues with my Power Query. The data from my Excel file is not loading correctly and there are frequent connection errors that I'm unable to resolve. Additionally, the power query's purpose is to clean and transform the data, but it seems the malfunctioning is causing the process to falter. I'm looking for someone skilled in problem-diagnosing of power query issues, and preferably someone with a strong understanding of Excel file manipulation. If you have expertise in data loading processes and resolving connection errors, you're the ideal candidate for this project. In addition, experience with data cleaning and transforming will be highly beneficial. - Problem Identification with Power Query - Managing Data Load...

In my project, I'm struggling with the following areas: - 3D modeling design (sink) Please check image! Sink is simple, but I stuck... I don't know how to make such loft. Please do not bid if you cannot recreate same or similar 99% of the sink.

I'm seeking a highly skilled Java developer to bring a desktop application to life. Here's what I'm looking for: Ideal Candidate Skills: - Proficient in Java programming - Experienced in desktop application development - Knowledgeable in integrating functionality without third-party APIs Key Requirements: - Develop a robust, user-friendly desktop application - Experience with UI/UX design for desktop software - Apply the best practices in software coding The perfect freelancer will have a portfolio demonstrating relevant experience and must be comfortable working with minimal guidance. Strong communicators preferred, as the project requires regular updates. Ready to innovate with your Java expertise? Let's connect!

Hi, I moved my sites from one small dedicated server to new one 3xmore bigger. I used AlmaLinux 8 with WHM/CPANEL I need one expert to fix my problems on the server because sites not load or if load load so so so slow after 4-50 second and that was not possible on old server If you can fix it and you are expert in servers WHM/CPANEl SQL APACHE contact me. Cheers !

I'm on the look-out for a seasoned Python developer who can proficiently carry out a webscraping project. The main focus is on data analysis, primarily "Stock Prices" and "Financial Ratios" taken ...taken from MarketSmith. Key Skills Required: • Strong Python skills • Proven experience in Data Scraping • Should have an understanding of financial data analysis. Your responsibility on this project includes: • Developing a Python based program for webscraping • Extracting stock price data • Extracting financial ratios • Ensuring the data scraped is suitable for analysis. Inserting data in SQL Database Intricate proficiency with Python is mandatory and past experience scraping for financial data is preferred. Please pro...

I am seeking a skilled interior designer to transform my basement into a place where our son can play, we can watch movies as a family, have a storage area and a home gym. Ideally, a freelancer with prior experience in designing home basemants will be perfect for the task. Your insights on materials, colors, and layout that best suit the atmosphere of a home theater will be highly appreciated. Key skills include spatial planning and an understanding of home entertainment systems.

I'm seeking expertise for my SQLite database to enhance its performance and design. With your knowledge, I'm looking to accomplish: - Streamlined database schema design. - Optimized SQL queries for faster performance. Ideal candidates should have: - Proficiency with SQLite. - Experience in database schema development. - Strong skills in writing and optimizing SQL queries. - Ability to deliver efficient and reliable database solutions.

I need a machine learning model that receives values 1 or 0 in nine questions and an OBSERVATION field. Rules: 1) A continuous model training script. This script will receive the values from the question1 to question9 fields, the OBSERVACAO field and the ADHD field and save it in your learning process. The ADHD field indicates positive in the diagnosis. 2) A model query script. If the sum of these values (question1 to question9) is greater than or equal to 6, it must indicate a positive result. Otherwise, negative. Regardless of the value of the OBSERVATION field. Fixed rule that should not change throughout learning. The model must be able to learn that even if the sum of the values is 5, but there is a high incidence of similar texts in the OBSERVATION field and the ADHD field ...

Aim to complete a medium-scale healthcare project requiring expert skills in C#, API development and integration, microservices architecture, and SQL. Specifically, the following features need to be implemented: - Patient Management System: A crucial requirement for managing patient data and interactions comprehensively. - Appointment Scheduling: A manual scheduler is the preferred choice to manage bookings effectively. - Microservices: These imperative components need to be implemented, specifically using AWS Lambda for better system scalability and maintainability. The ideal freelancer for this project should demonstrate proven experience in the mentioned technologies and healthcare projects. Deep knowledge in the practical implementation of microservices using AWS Lambda is a m...

We require an ERP & CRM Cloud Solution that fulfills the following requirements but note that I specifically need my ERP in PERN stack ( Postgres SQL, Express, React, and Node.js). The codes must follow best practices with responsive design as well. - Integration of essential business operations: - Inventory Management - CRM - HR Management - Sales Quotation, Invoices - Purchase Processes - Financial Reporting - Authentication and Authorization using JWT tokens. Technical Requirments. - in backend - React at frontend - PostgreSQL ad Database Note: No outdated technologies, i.e. jQuery, or bootstrap. Key features: - Efficient Stock & Sales Processes - HR & Payroll Management - Accurate Financial Modules - Comprehensive Reporting Systems In detail requ...

I'm currently experiencing a set of issues, namely a syntax issue in a SQL file, as well as a critical JavaScript error which is preventing me from uploading the code. The issues at hand are: - SQL syntax error that needs rectification - A sudden, fatal JavaScript error preventing code upload The exact error message I receive during the JavaScript code upload is stating 'JavaScript Fatal Error'. The error is produced when I attempt the upload process, preventing successful completion. I'm looking for a professional who has significant experience in solving both SQL and JavaScript coding issues. Ideally, you are: - Proficient in JavaScript and SQL - Able to quickly troubleshoot and resolve coding errors - Highly detail-oriented and acc...

Hi Lisa D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Please Sign Up or Login to see details.

I'm looking for a professional with experience in React and PostgreSQL to help create a user authentication registration process for our web application. This feature is crucial as it will be the first point of interaction for users before they can access the exclusive features of our app. Key responsibilities include: - Collecting specific user information including username, password, account name, and email during registration. - Implementing password security. You'll need to apply a hashing process to password security in the registration process. Experience in password security and knowledge on hashing are must-haves. The ideal candidate should have previous experience in developing a secure and efficient registration process, particularly for React web apps backed...

Hi, we have windows application for restaurant , We need make android app for 2 form one for login and second for selecting table and select food and you will send data to Sql server

I'm seeking a talented developer to create a sophisticated help desk ticket system that is accessible across desktop and mobile platforms. Your expertise will help us deliver an efficient way to manage customer issues and streamline our support operations. Key Features & Requirements: - Cross-platform compatibility for desktop and mobile usage. - Robust issue tracking capabilities. - Facility to upload/download multimedia: images, audio, video, documents. - Automatic technician assignment to reduce response time. - In-built functionality for emailing reports and logging faults efficiently. - Customization is not strictly necessary – no distinct design or branding requirements. - Interface should be user-friendly and intuitive. Ideal Candidate Should Possess:...

We wish to hire an experienced full stack develop. You must have a love and devotion to Jesus. You will be required to assist in the continued development and management of our platform. Must be fluid in CSS, HTML, PHP, SQL, AJAX and JAVASCRIPT.

More details: What specific functionalities or features are you looking to include in your Governance, Risk & Compliance Tool? Document Management,Audit Management,Risk Management,Task Management How would you like the layout and design of your Governance, Risk & Compliance Tool to be? Modern and sleek Which user roles do you want to have differentiated access and permissions within the Governance, Risk & Compliance Tool? Administrators,Auditors,End Users

I am encountering an issue with my SQL UNION operation, which is creating duplicate values. This problem is not due to duplicate records in the underlying tables rather originates from the UNION operation itself. The ideal candidate to solve this problem would be an individual who: - Has demonstrated proficiency in SQL debugging. - Has a deep understanding of SQL UNION operations. - Can effectively communicate what changes have been made to resolve the issue. Your main task will be to: - Identify the source of the duplicate value issue within the UNION operation. - Correct the SQL command to prevent future instances of this problem. - Validate the changes by ensuring accuracy in resulting data. Please provide your proposed approach to solving this problem i...

I'm seeking a proficient Delphi programmer for an urgent project. The scope of work involves: - User interface design: You'll develop an intuitive and user-friendly interface ensuring seamless navigation. - Database integration: You should be able to effectively integrate SQL databases with the Delphi application. Ideally, you possess the following skills and experiences: - Strong expertise in Delphi programming - Proficient with SQL and Pascal - Experienced in UI design and database integration - Ability to work under tight deadlines - Knowledge of Fire Monkey (in Delphi) for Mobile app development The project needs to be completed ASAP. If your skill set aligns well with these requirements, I'm eager to discuss the project in detail

Query needs to be updated to pick the right record and send an email.

I'm seeking a seasoned sales professional to boost the sales of my medical devices within the Indian market. These devices are primarily for hospitals, diagnostic centers, and clinics. My aim is to significantly increase revenue. Key Responsibilities: - Identify and establish relationships with key stakeholders in hospitals, diagnostic centers, and clinics. - Pitch ...experience, preferably in medical devices. - Knowledge of hospital equipment and diagnostic device market in India. - Strong negotiation and communication skills. The ideal candidate will have a track record of success in the healthcare sector and the drive to meet sales goals. Experience in medical device sales is a must. If you have the skills and experience, I look forward to your proposal to help drive my bu...

Setting: Own domain Router (Fritzbox) with fixed IP Synology NAS with docker Lets Encrypt certificates Vaultwarden installed on this docker Goal: Access Vaultwarden from all devices via the internet with https I need help to set all the correct settings in the docker, reverse proxy, router port forwarding and finally get ssl for the access

Project Title: Enquiry Form Integration in Website Project Overview: The goal of this project is to integrate an enquiry form seamlessly into the existing website. The enquiry form has already been developed, and now we aim to enhance its functionality by ensuring that submitted queries are efficiently managed. This involves sending a copy of the submitted query to three designated email addresses, storing all enquiries in a database, and making them accessible through our Customer Relationship Management (CRM) system. Project Objectives: Email Integration: Configure the system to send a copy of each submitted enquiry to three specified email addresses. Ensure that the email content is well-formatted and includes relevant details from the enquiry form. Database Integration: Imp...

I need a freelancer well-versed in multivariable calculus to complete 4 assignments (hand-written) and 4 quizzes (multiple-choice questions). Each task will be of increasing difficulty and will released about once every 3 weeks and involves a comprehensive understanding and application of advanced calculus concepts. Skills Required: - Expertise in multivariable calculus - ...integrals, and line integrals - Ability to work within tight deadlines Ideal Candidate: - Has relevant academic or practical experience - Can showcase similar past work - Ready to discuss a detailed approach to the assignment What I Provide: - Complete assignment requirements - Open communication for any queries Project Deadline: 7 days for each task Feel confident in your calculus skills? Help me ace thi...

Hello hello. We are looking for a freelancer or team to help us with Go High Level and Active Campaign. You will need experience in building and mangaing funnels in Go High Level . Also, We need someone who can assist us in setting up/ updating our email automation. The main tasks include creating automation workflows, updating emails. The ideal candidate should be able to optimize funnel and email campaigns for maximum conversions. The current website is Also if you know about advertisments FB, Google this is a plus Skills required: - Go High Level - Active Campaign - Marketing Automation - CRM Integration This is a on going position. Looking for long term hire. The budget is per month.

I'm in need of a talented developer to create a plugin for Outlook 2016 that interfaces with ChatGPT. This plugin needs to enhance my email writing experience by suggesting content through a convenient sidebar or updating the email content directly. Here's what I'm looking for: Required Features: - Five pre-set prompts for email content suggestions. - One custom prompt where I can type any query. - Sidebar interface that displays ChatGPT's responses. - Compatibility with Outlook and content in English. Ideal Candidate Should Have: - Proven experience with Outlook plugin development. - Familiarity with integrating AI, particularly OpenAI's GPT models. - Strong proficiency in English required for testing and UI elements. - Ability to produce a user-friendly ...

My project requires developing intermediate-level lessons focusing specifically on Relational Database Management Systems. As an educator, I ne...- Structure the lessons to build upon pre-existing basic knowledge, without leaping too quickly into advanced topics. Ideal skills: - Experience as a Database Administrator or in a related role. - A robust understanding of Relational Database Management Systems. - Educational skills, though not mandatory, would be highly beneficial to ensure clarity and quality of lessons. - Proficient in using SQL and other database languages. The successful freelancer will have the opportunity to contribute significantly to a student's journey in mastering Database Management. Further opportunities may present, like the creation of beginner and ad...

The Flutter app is : The app backend is : Files Included JavaScript JS, HTML, CSS, Sass, PHP, SQL Software Framework Laravel. after changes made submit the new version to both android and iOS store The Change is: The Application In mobile data and the internet that is not Wi-Fi is not working say” connect to the internet”. When using YouTube links as coarse videos it always shows 360 and 720 quality. Can we change it?. Reduce the radius value all to be like the dashboard image -The price label have radius like other image boxes and be same value -All font must be Rabar_21 -Instructors border must be like other sections -In

I'm currently looking for a skilled freelancer who is an expert in Hive HQL to assist with a series of tasks I have. Here's what I need help with: - Crafting intricate Hive queries - Managing a dataset that is less than 1TB - Conducting both data aggregation and transformation The ideal freelancer should have: - Proven experience writing efficient Hive queries - Knowledge about handling and optimizing queries for data under 1TB - Expertise in data aggregation and transformation using Hive - Ability to write clean, well-documented HQL code Please include examples of previous Hive projects you've worked on, especially those involving data aggregation and transformation. A strong understanding of the underlying principles of big data and database optimization would h...

...SEO, similar to the formats found on established directories. For instance, when searching for "2 bedrooms apartment for rent in Orlando," the URL should reflect a clean and optimized structure. I have examples of the current and desired URL formats that I will provide for guidance. **Key Requirements:** 1. **Automated URL Rewriting:** Develop an automated system that rewrites dynamic search query URLs to static, keyword-rich URLs. This system should also allow for manual editing of URLs if needed for customization or further optimization. 2. **SERP Optimization:** Configure the ListingPro theme to improve the title and meta descriptions for listings, ensuring that they are dynamically generated with SEO in mind. 3. **Technical SEO:** Implement technical SEO enhance...

...our project so its essential that the developer be familiar not only with woocommerce but with customizing and creating plugins for woocommerce. Our projects use: GITLAB -> C# , , Shopify digital product sales, mobile phone eSIM sales, 1.5, Bootstrap 3.0, ag-grid, Ionic framework, Font Awesome MS SQL 2017, webAPI MVC, ASP.NET, Kendo Controls, and all work is delivered via Gitlab Key Responsibilities: You will be working under and have the orientation and help of our project manager to do mostly back end work creating new and also improving existing functionalities of our project as well as create and customize a new store using woocommerce. This is for ongoing long term development and we will start with some short sprints to be delivered in 2-3 days and then start...

I'm looking for a professional to perform data analysis using Databricks on our SQL databases. Key tasks include: - Setting up Databricks for connection to our SQL databases - Executing and developing comprehensive data analysis methods - Creating reports and dashboards to visualize key findings The perfect candidate will have: - Extensive experience with Databricks for data analysis - Proficiency in SQL databases - Ability to create comprehensive reports and dashboards. Experience in Machine Learning or Real-time Streaming would be beneficial but is not required for this project.

...experienced in crafting engaging query letters, specifically aimed at garnering the interest of literary agents for a novel. The work is a young adult ficition thriller novel that sits around 60,000 words. I am specifically looking for someone who has helped create successful query letters in the past and has experience in the marketing arena for literature. The ideal candidate would also enjoy the creative aspect of developing an ideal book synopsis, working with the author to portray the book as best as possible. Key Tasks: - Edit my current query letter targeting literary agents to be more compelling and more fluid. - Ensure that the book synopsis resonates with the written work itself. Brainstorm on changes, alterations, other points from the plot to include. ...