Small sql query jobs
I'm searching for an astute Product Manager to help create a blueprint for the development of a Minimum Viable Product (MVP) aimed at Small Businesses. The main goal of this MVP is to: It's essential for the MVP to have functionalities tailored specifically to the needs of business owners. Required skills and Experience: - Solid experience in product management - Proven track-record in planning and releasing successful MVPs - In-depth understanding of the needs and dynamics of small businesses - Ability to incorporate feedback into product improvements Your expertise will guide us in developing an MVP that will captivate potential investors while meeting the needs of our target market. Anticipate a collaborative environment where your inputs will be highly valu...
I'm looking for a ...in Classic ASP to assist me in setting up hosting and database connection for my site. Key Responsibilities: - Help set up the hosting for the Classic ASP site. - Enable database connection and ensure its performing optimally. What I Expect from you: - Proven experience of working with Classic ASP. - Keen attention to detail. - Strong understanding of database management and setup, including SQL. - Good problem-solving skills. - Exceptional communication skills. Note: No specific functionalities or pages need to be created or handled. The sole focus of this project is on setting up hosting and database connection. Please ensure to include a detailed proposal indicating your approach to these tasks, alongside examples of past work and experiences, in yo...
Hello, in need an animation for a "TOP 5" video series which going about animals. Please do it it in "Canva". The video should go ~20 seconds. also the startpage should have a animal as background. Pls prepare a good template with free copyright music. after top2, next animal comes... you can use any sample texts Thanks
I have an issue on my WordPress website where with each page load, several queries are being sent to a page that does not exist. When you delete the nav menu, this issue goes away. However, when you create the menu again, the issue returns. I need help troubleshooting this, because we obviously need a nav menu - but the constant duplicate queries to a page that doesn't exist are hurting our performance.
...- Profit calculation. **Models and Schema:** 1. Item 2. Batch 3. Offer 4. Branch 5. InventoryTransaction 6. Customer 7. RewardPoints **Additional Related/Mapping Models:** - BranchAllocation - OfferAllocation - InventoryRequest **Requirements:** - Solid experience with ASP.NET Core development. - Proficient in designing efficient database schemas. - Familiarity with indexing for optimized query performance. - Ability to work on related models and mapping for seamless data flow. - Previous experience in retail or inventory management systems is a plus. **Deliverables:** - Enhanced and optimized schema with the introduction of new models. - Efficient indexing for various queries. - Well-documented code and models. - Testing to ensure reliability and performance. We look f...
Hello, I want to make a few small modifications to the website. I'm using OpenCart 3.0.3.8 with an auto parts search module that works on any CMS, so it's not an OpenCart-specific module. It's well integrated, but I want to move the search box to the top where I indicated with the arrow. However, when I adjust the position with -, I can no longer click to search something in the search box. I'm using the Journal 3 theme, and I would like to add the module to the "" page, or move the banners - sliders to "/auto-parts" where the module is located. I have only 140$ for this project.
...this project is to include features that handle billing and database assignment. There will be the need to implement a simple system that assigns a billing plan and a database to each company using the system. This code already exists in the current functioning ASP.Net project. Proficiency in both C# and Angular is required, alongside experience with Bootstrap 5.x, and a solid understanding of SQL Server database operations and Identity user management functionalities. The successful freelancer should have proven experience in handling similar conversion tasks and a portfolio showing completion of similar projects. This project includes converting ASP.Net controllers to WebApi controllers (ApiController) for use as endpoints by the new Angular code. All logic currently functio...
As a project owner, I am facing issues with SQL Server connection in my windows server. Whenever I am trying to connect, it is showing error messages. The application's behavior leads me to believe that there is a problem with the database connection. Interestingly, I haven't tested if other applications or utilities can access this database. The application works well in development, and I can connect to a copy of the database as expected. This task will require: • Proficiency in SQL Server • Experience with windows server • Diagnostic skills relating to database connectivity issues • Ability to ensure that other applications can smoothly interact with the database The project will be considered successful when the error messages no longer ap...
I'm looking for an experienced accountant to handle my business's financial tasks. As a small business owner, I require a comprehensive range of services, including: - Bookkeeping: Maintain accurate records of all monetary transactions and ensure they're up to date. - Financial Statement Analysis: Provide insights into my business's financial health and identify areas for growth or improvement. - Tax Preparation: Ensure my business complies with tax regulations, and provide assistance during tax filing periods. Knowledge in using Holded accounting software is a requirement for this project. Ideally, the freelancer should understand the needs of a small business earning less than $1 million in revenue. Your experience with similar businesses and their uni...
Hi there, We are looking at building a query builder in React.js which will allow us to generate reports from existing relational database that has multiple tables. A video to give an idea of what we require is attached. Tech stack React.js MUI Redux Key Skills: - Extensive experience in React.js, Redux and MUI. - Good knowledge of relational database and their query language - Ability to brainstorm on the requirement - Need good, clean, well commented code Thanks, Rahul
Project Title: Database Design (Models and DbContext) for Enterprise Inventory and Sales Management Project Overview: The project involves designing a robust .Net core models layer for an enterprise engaged in Inventory Management and Sales Management. The system ...are allocated to different branches, with variations across branches. e. At any given time, only one active batch should be available for selling items in a store. f. Calculate stock levels per item per batch per store. g. Track stock sold, stock available, and calculate profit. h. Capture and manage customer details. i. Store and manage invoice details. Technical Specifications: Utilize SQL to ensure data integrity, security, and efficient querying. Create appropriate relationships between tables for seamless ...
Project Title: Database Design for Enterprise Inventory and Sales Management Project Overview: The project involves designing a robust SQL database system for an enterprise engaged in Inventory Management and Sales Management. The system should efficiently handle inventory tracking, stock management, sales operations, and related functionalities for multiple branches. Requirements: Inventory Management: a. Items are received at a central warehouse from multiple suppliers. b. Items are received in batches, with each batch having different pricing (cost price and MRP). c. Each batch can have multiple offers based on the quantity purchased by the customer. d. Maintain and calculate stock levels for each item per batch. e. Track the in and out transactions of items with date/ti...
I'm looking for a skilled architect who can provide me with a traditional home plan. * The home needs to be small, having 3bhk * An important feature of the plan must be a well-thought-out layout for a 3BHK (3 Bedroom, Hall, Kitchen) structure and if Pooja hall also separately or in the kitchen or some other place traditionally. * I would prefer someone who has substantial experience with traditional home designs and can deliver a unique and functional space that adheres to the quintessential aesthetics of such designs. * Use of natural materials, craftsmanship detailing and a harmonious bond with surroundings should be the key elements of this project. I value creativity and am open to any kind of suggestions. Looking forward to witnessing some amazing concepts! I got a sa...
I am seeking an experienced operative to swiftly enact a fix on a datatable with inline editing. This project is perfect for someone skilled in managing data tables json Ajax SQL and c#. Seeing as this project is short-term, the readiness to dive right into the issue is highly favored. Also this will be remote
...sources of my interest are platforms like Spark, AWS, Azure, GCP, and Hive. I want to understand effective methods for data extraction from these particular sources. Ideal Skills and Experience: - Expertise in ETL tools for data extraction - Hands-on experience with Spark, AWS, Azure, GCP, Hive - Profound knowledge in data engineering - Experience in career coaching or mentoring will be a bonus - SQL -Python This assistance will give me a competitive edge in my upcoming interviews by providing me with practical skills, knowledge, and confidence in addressing ETL-related questions. So, a mentor with over 10 years of experience in data engineering, particularly in ETL processes and in touch with modern data extraction techniques, would be ideal....
I am in need of an expert Bug Hunter to assist me in identifying and addressing vulnerabilities in some web domain/online services for Key Areas for Exploration: - Cross-site scripting (XSS) - SQL injection - Remote code execution - OAuth redirection issues Ideal Experience and Skills: you MUST have experience and have gotten bounties in the past. I am looking for someone with ative experience. Level of Expertise: I'm specifically interested in freelancers with advanced expertise in bug hunting. I also want you to help me over zoom to achieve my first bug YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN
I have recently uninstalled Mariadb 5.5 from my server however, my MySQL database file still exists and have the database in /var/lib/mysql/umedia. . I need that database recovered and sql dump created as soon as possible.
The Role: As a Back-End Developer, you will play a critical role in connecting our dynamic front-end applications with our robust SQL database. Working under the guidance of our Chief Engineer and CTO, you will ensure seamless data integration and functionality across our platforms, contributing to the provision of a stellar user experience. Responsibilities: - Develop and maintain the server-side logic to connect Flutter and React front-end applications with a SQL database. - Implement secure GraphQL API endpoints for efficient data retrieval and manipulation. - Collaborate with the front-end development team to integrate API services. - Optimize back-end processes for maximum speed and scalability. - Ensure data security and protection in line with best practices and compl...
...Implement and optimize data models for efficient storage and retrieval in AWS Redshift. AWS Service Utilization: ● Leverage AWS services such as S3, Lambda, Glue, Redshift, and others to build end-to-end data solutions. ● Stay abreast of AWS developments and recommend the adoption of new services to enhance our data architecture. SQL Expertise: ● Craft complex SQL queries to support data analysis, reporting, and business intelligence requirements. ● Optimize SQL code for performance and efficiency, and troubleshoot any issues related to data retrieval. Performance Optimization: ● Optimize ETL workflows and data warehouse queries to ensure optimal performance. ● Identify and resolve bottlenecks in data processing and storage. Data Integration: ● Collaborate with c...
I am seeking an experienced app developer to build a simple mobile app using MAUI. The primary function of the app should be to scan QR & BAR codes, with the data saved in SQL Lite. This information then needs to be able to be sent via API in bulk or on an individual basis. Key features: - Compatibility with Android platforms - Immediate display of scan results Freelancers who wish to make a bid should include examples of their past work, particularly those related to QR & BAR code scanning and SQL Lite. Familiarity with API integration is a plus. A solid understanding of MAUI and cross-platform mobile app development will also be highly valued.
I am looking for an experienced professional to implement a fitting lighting solution in my small office space. This involves the use of natural light, task lighting and also ambient lighting to create an optimal environment for desk work. The ideal freelancer should have: •Experience in interior design or office design •Knowledge of appropriate task and ambient lighting •Skills in maximizing natural light The project will involve: •Understanding the layout of the small office space (1-5 rooms) •Striking a balance between natural light, task lighting, and ambient lighting •Providing a design that ensures adequate light for desk work •Executing the project while ensuring minimal disruption of work Your proposal should detail previous si...
...Laravel query builder. Responsibilities: - Migrating all existing MySQL database structures (tables, views) to MongoDB (collections, and equivalent to MySQL views). - Upgrade Laravel from 5.2 to the latest Laravel version. - Switch all queries (query builder) in the whole Laravel project to MongoDB. - MongoDB testing, and make sure the two main databases are working correctly, and the Laravel auto-install function is working correctly (Auto-create database with preconfigured collections and documents). - Testing hole Laravel project (Make sure all pages, and API functions are working correctly after DB migration). Policies: - All the tasks should be done on the development environment using RDP (Remote desktop connection) - Create a Trello board and break down the main...
I'm looking for a freelancer to help me model the data in POWER BI and create some tables and DAX formulas if it's necessary. I don't need any dashboard, I just need the data modeling part (data is already connected from SQL) Please consider that I can't provide any credentials to work with the data, I need YOU TO GUIDE ME while I do it (I have some knowledge)
...dispatch systems and mobile apps for both Android and iOS. - Knowledge of real-time tracking technologies, such as GPS and geolocation. - Expertise in automated dispatching algorithms and customer management systems. - Proficiency in programming languages such as Java, Swift, and PHP. - Strong communication and project management skills. We have a system that was built 20 plus years ago, with a SQL Server database. It is very basic as to what we want now. The site is and we can send you a username and password to get into the system. Generally, a transport company will enter a vehicle into the system. The year, make, and model of the car, where it is being transport to, the VIN, and the price they are will to pay to have it moved. Once it is entered, it will be able to be
I need a commission-based salesman who is well-versed in B2B sales and confident in reaching potential customers through recommending our products through blogs and social media. Your focus will be on small businesses, promoting our top-notch commercial printers. Skills and Experience Required: - Proven B2B sales experience. - Familiarity with the small business sector is a plus. - Knowledge of commercial printers is not necessary, but willingness to learn is essential. Please provide proof of your experience with similar tasks in your bid.
Como do some interesting GIS programing. Please no AI responses. Please respond by telling me what is a 3-4. **Requirements:** - Proficiency in spatial SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, with a portfolio of previous projects involving visual data exploration and user interaction. - Fluency in Python programmin...
...Functionalities Required: - **API Integration:** Ideally, customer data should be directly integrated via APIs. It's crucial that you have the expertise to handle this kind of integration and verify data integrity effectively. - **SQL Databases Interaction:** As the SaaS product's backbone, it's essential for it to interact successfully with SQL databases. You'll be tasked with setting this up to ensure smooth ongoing operations. Ideal skills: - Proven experience with NestJs and full stack development - Strong background in API integration - Solid knowledge of SQL databases - Proficiency in creating SaaS applications I'm looking for someone ready to leverage these skills in order to bring this project to fruition. If you're passion...
...development environment on a cloud platform. Although I am still undecided on whether to use Azure, Google Cloud, or Amazon Web Services, your valuable input will guide my decision. I have developed a prototype using a low-code platform, (running on AWS and Microsoft SQL) but I need to start a parallel project to produce a fully scalable and more generic version. I am able to create the database and user interface once the development environment is all set up. I will probably need help with some code. I have a strong preference for SQL database as this is what I know.. Key requirements for this project: - Demonstrate mid-level experience in cloud platform setup - Proficient in Azure, Google Cloud, or Amazon Web Services - Ability to analyze and recommend the best pla...
I'm looking for an expert web developer/designer to overh...Thus, the redesign should solve this problem. Key responsibilities will include: • Rework the design to guarantee visual appeal and user-friendly navigation • Integrate interactive elements to make the site more engaging. This will consist of interactive infographics that illustrate various processes closely related to our services. • Incorporate seamless contact forms to facilitate easy query resolution • Design an online booking system for consultation appointments The ideal candidate will have a solid track record in interactive web design, experience with UX/UI and knowledge of how to make complex processes understandable via infographics. Past work on professional service or consulti...
...seamless database integration - Develop and integrate APIs for mobile app communication - Reskinning for the Flutter template - Upload to google and Apple store Ideal Experience: - Proven track record with Flutter and Laravel projects - Deep understanding of RESTful API conventions - Experience in OAuth and JWT for secure authentication - Ability to write clean, maintainable code - Familiarity with SQL databases The Project Scope: - Collaborate to refine a specified Flutter template - Implement backend solutions tailored to the template's features - Test thoroughly to ensure reliability and performance I'm excited to see your approach and how your skills can drive my project’s success. Please include examples of similar projects you've worked on, particu...
...Functionalities Required: - **API Integration:** Ideally, customer data should be directly integrated via APIs. It's crucial that you have the expertise to handle this kind of integration and verify data integrity effectively. - **SQL Databases Interaction:** As the SaaS product's backbone, it's essential for it to interact successfully with SQL databases. You'll be tasked with setting this up to ensure smooth ongoing operations. Ideal skills: - Proven experience with NestJs and full stack development - Strong background in API integration - Solid knowledge of SQL databases - Proficiency in creating SaaS applications I'm looking for someone ready to leverage these skills in order to bring this project to fruition. If you're passion...
I'm seeking a skilled interior designer to help reorganise our open-concept workspace. The area currently facilitates computer-based and desk work, with the aim to transition it into a more comfortable environment for our team. We are currently running at maximum capacity with morning/night shift change-over and are interested in maximizing our small space so that everyone had a place they can sit and work. Here's what I envision: - A layout that encourages comfort without impeding workflow. - Aesthetically pleasing setup. - Smart usage of space, ensuring each team member has adequate room. The freelancer with past experience in corporate office layouts and a strong understanding of open-concept spaces would best fit this project. Show me some examples of similar work y...
...candidate would be proficient in HTML, CSS, JavaScript, React, PHP, SQL, and have experience in integrating APIs. The main goal of this project is to construct an engaging and interactive site offering relevant information about the college. While the client has skipped providing specific design or functionality requirements, we expect the site to be consistent with current best practices, intuitive, and user-friendly in its design. Responsibilities include, but are not limited to: - Creating an attractive front-end that aligns with the college’s brand - Building a robust back-end management system - Handling and integrating APIs as required Skills and experience preferred: - Proficiency in HTML, CSS, JavaScript, React, PHP, SQL - Extensive experience with API...
As a small retail business owner, I have a set of sales data that is both intricate and valuable to me. I'm seeking an expert in Python who can assist with the analysis of this data. Here's an outline of what our collaboration could be like: - Analyze our small-sized datasets (<100MB) to deliver actionable insights. - Interpret sales figures and patterns for our retail business. - Efficiently manage the data extraction, preparation, and analysis process. The ideal freelancer for this project would have: - Detailed knowledge and proficient experience in Python. - A strong background in data analysis, specifically with retail sales data. - Ability to distill complex data into clear, actionable insights. Please note that the capacity to manage this job within a...
...follows a client-server architecture, with a frontend built using modern web technologies such as React.js for dynamic user interfaces. - The backend utilizes a scalable and secure architecture, with a RESTful API developed using Node.js and Express.js. **4.2 Databases:** - The app integrates multiple databases to support various sports leagues and player/team profiles. - Databases are designed using SQL or NoSQL technologies for efficient data storage and retrieval. **4.3 AI Integration:** - The app leverages AI algorithms for generating dynamically personalized user interfaces. - AI technologies such as machine learning may be utilized for data analysis, player performance prediction, and user engagement optimization. **4.4 User Experience Design:** - The user interface is d...
...with a fast-paced, high-stakes project. Take the initiative to showcase your qualifications and how you plan to meet the project's demands. I look forward to seeing your proposal and discussing how we can work together to meet my business's urgent needs. The PowerBI Dashboard needs to have the following details: Query Page: Filters: Customer Level: Allow users to filter data based on specific customers. Query Type Level: Allow users to filter data based on different query types. Date Range: Users should be able to select a date range for the queries. Visuals: Count of Queries Created: Display a visual representation of the total number (sum) of queries created at the customer level. Bar chart or table showing the count of queries for each customer....
In need of a professional editor to edit a small picture. The task may require excellent skills in photo editing tools and software, with keen attention to detail. Here's what an ideal freelancer for this task should have: - Proficiency in photo editing software such as Adobe Photoshop or Lightroom - High attention to detail and creativity - Previous experience in similar projects, showcasing past work would be a plus - Ability to provide a detailed project proposal outlining their approach Please, in your bid, provide examples of past work and a detailed proposal on how you plan to approach the task. Your proposal would increase your chances of being hired. Looking forward to your bids!
I need an experienced C# developer to update a Windows service to improve email functionality. The task includes: - Updating the existing program to send an email with an attached PDF - Integrating SQL database queries to generate this PDF - Designing a process that converts the results from the SQL database stored procedure into PDF format before emailing The ideal candidate will have strong understanding and experience in C#, .NET framework, Windows services, SQL database management and converting SQL queries to PDF. Knowledge of email systems and attachments will be a significant advantage. While this project focuses on a specific update, there may be potential for continuing collaboration depending on the successful completion of this task.
I'm in need of a skilled developer with experience constructing ETL pipelines that extract data from CSV files. Main project tasks: - Extract data from CSV file source - Perform necessary transformations including data cleaning and data enrichment. Required experience and skills: - Proven track record in developing ETL pipelines - Proficiency in handling and processing CSV files - Expertise in performing data cleaning and data enrichment actions. This task requires fine attention to detail and a pragmatic approach to data management. I'm expecting an efficient and error-free pipeline construction. Your responsibility will be to ensure high-quality, cleaned, and enriched data output from the provided CSV files.
...should include features to assist with this. Key Features: - The microcontroller must be programmable with tinyGo - Inclusion of GPRS for internet connectivity (only one provider available) - Incorporation of a single phase and tri-phase relay (50v - 400v) - 4inch max ePaper for screen display - Four functional buttons - Battery-operated - Hermetic Case design The desired size of the PCB card is small, between 2 and 5 square inches. All materials used should not exceed a total cost of $30. Ideal skills and experience: - Proficiency in electronic design, specifically with PCB - Familiarity with tinyGo programming - Understanding of GPRS integration - Experience in designing battery-operated systems. Proposed plans for the design alongside relevant professional experience will...
...efforts, particularly focusing on texting and voicemail campaigns. The ideal candidate will possess strong skills in SQL, experience with BigQuery and Dataform, and proficiency in data visualization tools. Familiarity with Airtable is a plus. This role demands a combination of technical expertise, analytical thinking, and a keen understanding of marketing dynamics to provide actionable insights that drive strategic decision-making. RESPONSIBILITIES: -Integrate data from QuickBooks, Airtable, BigQuery, and Follow Up Boss into a cohesive analytics framework. -Develop and maintain automated tracking systems for leads and conversion rates across various marketing channels. -Utilize SQL for data manipulation and analysis within BigQuery. Experience with -Dataform for managing ...
I'm seeking a cloud professional who can efficiently link an Azure Function App to an Azure SQL DB. This integration will enable the Azure Function to be called directly from an Azure SQL Function and the response returned to the Azure SQL Function too. Specific skills and experience needed: - Proficiency in managing Azure Function Apps - Strong knowledge of Azure SQL DBs - Experience in setting up and managing cloud interactions - Familiarity or background in handling transactional records To note: - The Azure Function App needs to be callable from Azure SQL Functions Your proposal should outline your past experience with similar setups and your approach to the task.
I need help with the creation of a MongoDB view on a basic array collection. This is a personal project. Here's what I expect: - You need to be experienced with MongoDB, particularly with creating views. - The task will only involve creating the MongoDB view, no data import or query optimization. - The complexity of the task is on the simple side, dealing with basic operations. Required Skills: - MongoDB - Database management - Basic understanding of array collections
I am seeking a professional to conduct pre-employment vetting for less than 10 candidates. The specific vetting process will require: - An in-depth employment verification check Ideal candidates for this project should have previous experience in HR or related fields, specifically in conducting background checks and employment verification. A keen attention to detail is necessary to ensure no stone is left unturned during the verification process. Your skills and integrity will directly impact our hiring decisions.
1. adding state country city list & 2. other small work file attached
I am in need of an experienced PL/SQL developer who is efficient in Oracle database management system. The scope of the job would include: - Creating stored procedures: Structuring new procedures for data manipulation, validation, and reporting. - Writing triggers: Implement a triggering system for efficient database management. - Optimizing SQL queries: Ensuring that SQL queries are optimized for best performance. The PL/SQL code will be used for data manipulation, data validation, and reporting & analysis. Experience in Oracle database is a must for this role, along with a strong understanding of PL/SQL development to ensure the efficiency and accuracy of the database management system.
I am looking to develop a custom application to manage my financial transactions securely and efficiently. The main idea is to ensure that each transaction is verified by an anti-fraud microservice before updating its status. This application will simplify my financial life by providing clear tracking of each transaction made. Key Features: Transaction V..."Guid", "transferTypeId": 1, "value": 120 } Resource for Retrieving Transactions: Implementation of an endpoint to retrieve transaction details, with the following format: { "transactionExternalId": "Guid", "transactionType": { "name": "" }, "transactionStatus": { "name": "" }, "value": 120, ...
We are seeking a skilled photographer to capture the intimate moments of a small wedding event. The ceremony will take place in an apartment setting, creating a cozy and personal atmosphere. With only 10 attendees, including the couple, this event promises an intimate and relaxed ambiance. Requirements: Duration: The event will span approximately 1-2 hours, including the ceremony and any post-ceremony celebrations. Intimate Approach: We're looking for a photographer who can adeptly navigate small spaces and capture candid moments that reflect the warmth and closeness of the occasion. Minimalist Setting: The apartment setting offers a unique backdrop for this event. The photographer should be able to work creatively within this space to capture the essence of the celebr...
