Sql query for a mysql database jobs

...Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client needs. Please submit your proposal, detailing...

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

...monthly salary if working on a monthly salary basis. The lowest, but experienced offer will have a better chance. Monthly salary will be considered to calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. ...

I need a focus-driven developer to build a web application for my travel agency. The purpose of the application is to implement a backoffice system for managing bookings. The functionalities I'm aiming are: - User needs to enter details like Agency name, pax name, mobile number, pick up location, pick up time, date of flight travel, flight departure time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, pref...

...creating PDF reports from MYSQL and InfluxDB, capable of not only capturing numerical data but transforming it into Graphical Trends and Text-Based Analysis. Key Role: * Develop logics for data interpretation and representation * Create a Professional and Formal UI/UX design for the report generator * Deliver finalized, error-free reports Ideal Experience: * Python expertise * In-depth knowledge of MYSQL and InfluxDB * Proven experience in creating dynamic PDF reports * A keen eye for formal and professional UI/UX design * Strong abilities in abstract reasoning and complex logic writing. Your role will translate our complex database information into understandable, well-structured and professional-looking reports, ensuring rel...

I'm looking for a PHP script expert who can create a real-time data retrieval system for my MySQL database. The script will connect to the BeachesMLS Matrix RETS Server and download all the properties into my database as soon as they are sold. Key Requirements: - Real-time Data Retrieval: The script should constantly monitor the BeachesMLS Matrix RETS Server and instantly download all the sold properties into my MySQL database. - Comprehensive Property Details: The script should specifically download details like price, location, size, agent information, property status, listing date, amenities, property type and the number of bedrooms for each sold property (all fields available) Ideal Skills and Experience: - P...

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

With a pressing need to secure our Laravel and MySQL voting system, we are looking for a skilled professional who can rectify the voting manipulation issue we are currently experiencing. Here's what we need: - Expert in Laravel and MySQL - Experience in securing web voting systems - Proficiency in server request handling is crucial. We have already introduced a new security measure related to server request handling, but our voting results are still being tampered with. We need an expert to identify the lacunae in the existing system and beef it up to prevent any future breaches. In addition to a strong technical skill-set, your knack for problem-solving would be greatly valued on this mission to restore integrity to our onli...

*READ the attached .docx it's better explained. * For this project, this is just meant to run on any given localhost machine as a project. I'm in need of a skilled developer to build an application for a project. The main focus will be on exploiting the 'Academic World' dataset, incorporating relational (MySQL), document (MongoDB), and graph databases (Neo4j) which will be provided. Key Functionalities: - See .docx (My Approach) Section This is a project-based task, so I don't think there's a need to implement complex user authentication or intricate access control. Candidates with experience in web-based application development using MySQL, MongoDB, Neo4j will be ideal for this project...

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

...JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the full project lifecycle from the front end to the back end and can make informed decisions about SSL types as necessary, then I am looking for you. Long-term relati...

WordPress / MySQL / AJAX / jQuery / PHP / React.js / JavaScript Project Overview This is a simple data driven WordPress site. User 1 registers as a member of “Class 1” User 1 enters a number into class 1 User 2, is also a member of class 1 User 2 searches that number entered by User 1 and is provided instant AJAX search results. User 1 can edit and delete data in his history. User 2 who is a member of class 1, 2 and 3 can view data entered into class 1, 2 and 3. (The chosen classes chosen in the profile. Users can register for up to 3 classes) User 3 who is only registered in class 4 can only view data entered into class 4 I’m needing a bid on the cost and time required to build out this project. If you will be...

I need a highly skilled NODE (puppeteer) expert to undertake a database integration task with my Aviator Game. The game requires MySQL database inclusion and specific features. Key Duties: - Incorporate MySQL database into Aviator Game - Set up the game as needed Essential Features: - Creation of User profiles within the game - Implementation of Leaderboards system Skills and Experience Required: - Proficiency in NODE (puppeteer) language - Extensive experience in MySQL database integration - Familiarity with custom PHP programming

I am seeking a developers with excellent knowledge of Windows OS and system software development. This project requires creation of a registry monitor that utilizes a hook-based approach for Windows 7, 8, 10, and 11. The monitor will specifically keep an eye on application settings and alert me via email whenever any changes have been made. Key features will include: - Targeting application settings in the registry. - The ability to detect any changes to said settings. - Sending an email alert every time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policie...

I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transfor...

We developed a web portal using PHP and MySQL to be used at places where Internet speed is slow, but it is taking long. We have about 20,000 records and they will quickly grow to a million and more. Here is the PHP code and MySQL database:

I am seeking a ML, Data Science, and software architect specialist to help me conceptualize and design my platform's architecture, specifically experience with embeddings and vector search. I am building a platform where creators can share content across multiple formats and be remunerated fairly. We ingest various content, from podcasts, articles, white papers and infographics, then agglomerate it, extract the most relevant pieces of information based on the end user's profile (demographic data, parameters, queries, etc) and generate a response. Based on the user, the response may have multiple sources with various contributions to the generated answer. Using weighted calculations, we can allocate the proceeds to the content creators. Example: the podcast ...

Im seeking a skilled Full Stack Developer to join our team in building a local freelancer platform. The platform will connect job seekers and posters, facilitating the posting and bidding of jobs, as well as managing project progress and payments. The ideal candidate will have expertise in both front-end and back-end development, with experience in TypeScript frameworks for server-side rendering and React.js or Vue.js for web development, as well as React Native or Flutter for mobile app development. Responsibilities: - Develop user authentication and profiling features, including sign up, basic details collection, and user categorization. - Implement job posting functionalities, allowing users to create detailed job listings with prompts and boilerpl...

We are seeking a team of Database Engineers who can combine multiple sources of data into an Azure MySQL database on an automated basis. The operation must comply with HIPAA regulations under an organizational development environment (VDE). All VM's and databases will be deployed through Azure.

I'm in immediate need of an in-app SEO professional to configure my webapp. When shared on WhatsApp, Twitter, Telegram or any other third-party platforms, the content must appear with a thumbnail. The perfect candidate for this task has: - Expertise and a strong understanding of in-app SEO, and how different social platforms display shared content. - Experience with webapp configuration. - An immediate availability, due to my requirement for swift project completion. The webapp was build with backend php laravel, MySQL, frontend tailwin css vue.js Remember, the more detailed your proposal, the more likely I am to consider it. Including some examples of your past work would be advantageous. Don't wait, apply now!

...Features: - Database Integration: This website should include a database to facilitate and record stock transactions. - Buying and Selling: The primary function of this site is to allow users to buy and sell stocks. - User-friendly Interface: The site should be intuitive and easy to navigate, ensuring a seamless user experience. Ideal Skills: - Web Development: Experience in developing dynamic websites with database functionality is crucial. - Financial Knowledge: A basic understanding of the stock market and investment is advantageous to ensure the site meets the required standards. - UI/UX Design: A good eye for design and user experience is important to create an engaging and interactive platform. For this project...

We developed a web portal using PHP and MySQL to be used at places where Internet speed is slow, but it is taking long. We have about 20,000 records and they will quickly grow to a million and more. Attached is the requirements document, PHP Code and MySQL Database. This is quite urgent. PHP Code and MySQL is here:

I'm looking for a professional who can help me deploy my Spring Boot Maven with MySQL and React app to Google Cloud Platform. Key Responsibilities: - Deploy Spring Boot Maven with MySQL and React app to Google Cloud Platform - Ensure the deployment is running smoothly and is accessible Ideal Skills and Experience: - Strong experience in deploying Spring Boot applications - Familiarity with React app deployments - Prior experience with Google Cloud Platform - Knowledge of CI/CD pipelines is a plus, although not required in this case - Proficiency with Git for version control Looking forward to your bids!

I need a comprehensive web application that can handle various data-related tasks, from generating PDFs to processing scannable sheets, creating data visualizations, and interactive reports. The ideal candidate for this job should have experience with PHP, MYSQL/MariaDB, and an understanding of data processing and visualization. Key features and requirements: - PDF Generation: The application should be able to take XLSX files, and based on the uploaded data, generate PDFs. - Scannable Sheets: The system must be able to process bulk uploads of scannable sheets, interpret the data (including pencil bubbles), and translate it into tables. - Error Reporting: I need the system to either prompt users to fix any errors or flag errors for later attention, ensuring data...

I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP ...

I have MySQL running on my Linux system and I'm looking for a professional to help me install Kannel and set it up as an SMS Gateway with fake dlr

In my ongoing project, I'm facing a thorny issue. Some numeric data is missing from the transaction data table in our MySQL database report. In order to move forward with my work, I need a professional to: - Diagnose the source of this missing data - Fix the issue to ensure all numeric data is correctly pulled into the report from the transaction data table The successful candidate should have: - Extensive familiarity with MySQL databases, specifically in generating and troubleshooting reports - Sound understanding of database architectures and data tables relation - Proven problem-solving abilities I look forward to your proposals and getting our report up to speed.

I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise ...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm currently experiencing some problems with SQL Server 2019 regarding a synchronization error in my Snapshot Replication model. Present issue: - Synchronization process follows an error. Desired solution: - Ability to correct the synchronization errors to allow for smooth data replication. Ideal Skills: - SQL Server 2019 expertise - Solid understanding of Snapshot Replication model - Proven experience in troubleshooting synchronization errors. I'm seeking assistance from someone with these expertise, who can provide a quick and efficient resolution to this problem.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing...with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in Vue.js. - Attention to Detail: Ability to ensure high-quality results and maintain consiste...

Knowledge of technology required -> Frontend: ReactJS or Vue.js or AngularJS Backend Language: PHP Framework: Laravel Database Modeling: MongoDB, PostgreSQL, MySQL We want to create a CRM app with MERN/MEAN stack or Laravel and JS.

I am looking for a Magento 2 developer who can help me fix a specific cron job error I've been experiencing. The error states "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in". Ideal Skills and Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTA...

...WordPress website's database. The primary reason for this is to lower hosting costs. Key Areas for Optimization: - **Back-end Operations Speed**: The site's backend is significantly slowed down due to the large database. I need a solution that will significantly improve the speed of my back-end operations. Data Types to Address: - **User Data**: The large volume of user data on the site is a significant contributor to the database size. I need to find ways to optimize or archive this data without compromising its integrity. - **Media Files**: The site is media-rich, and the files are taking up a lot of space in the database. I need to find a way to reduce the size of these files without compromising the i...

An enterprise client is looking for 1- 2 experienced front-end developers who can translate existing UI/UX designs into a functional learning platform that seamlessly integrates with the backend. The ideal candidate should have a front-end background with NextJS 14, TailwindCSS, and NodeJS and some knowledge of RestfulAPI and MySQL. Deliverables: - Develop the front-end based on the provided Figma files, with provisions for client-side and server-side rendering features that will be added by the back-end team. - Collaborate with the project and back-end team to understand project requirements and objectives. - Develop reusable UI components and design patterns to ensure consistency and maintainability across the website. - Implement responsive design tec...

I'm currently seeking an experienced developer who can skillfully enable the resharing of my ...upload of thumbnails to accompany reshared content. - Audiomark API Integration: Additionally, i need audiomark integration so that when user A post their audiomark music link user B can stream it on our website without leaving our webapp, therefore, proficiency with Audiomark API is a must. Ideal Skills: - Expertise in API integration - Social Media platform protocols understanding - Experience with content resharing functions - Skillfulness with thumbnail configurations Backend was build PHP laravel MySQL , frontend tailwin css vue.js Test the webapp @ If you have the detailed know-how in these areas, your expertise would be a perfect fit. We are excited ...

I'm seeking a talented full stack developer for initial software development for a pathology lab. The software must be responsive, user-friendly, and robust, catering to patients, staff, and referring doctors. Here's what we need: 1. **Choice of Platform**: As the client, I am open to using Angular, React or PHP for the development along with SQL Server/MySQL for the database. Feel free to recommend a platform when you apply. 2. **Essential Modules**: - Building Patient Database (From existing Lab Software - Which will remain as is). This database will be used for Whatsapp , email , SMS Marketing (This also is part of scope) and also For Patient Web App interface. Whatsapp API i...

I'm looking for an experienced Xamarin developer to create an Android app for my real estate business. The app should have similar functionalities to the app and should connect to my SQL Server database. Key Features: - Property Search: Users should be able to search for properties in my database - Property Details: Users should be able to view detailed information about the properties - Favorites List: Users should be able to save properties to a favorites list User Authentication: - The app should allow users to sign in using their Email and Password. Property Search: - The property search feature should integrate a map view for a better user experience. Users should be able to visualize the location of the pr...

I need a developer to create a proctoring exam application using Python and SQL Server. The primary role of this app is to monitor candidate behavior during online exams. Key features include: 1. Online Registration Of Candidates: A feature for students to easily register for exams. 2. Password-Based Authentication: To authenticate candidates before they can access the exams. Prior experience in implementing secure login mechanisms is preferred. 3. Advanced Browser Disablement: Unfortunately, there will be instances when candidates try to cheat the system. I need to prevent this by disabling browsing other tabs, accessing other applications, and the copy-paste function during the exam period. 4. Random Image Capturing & Video Monitoring: To f...

I require an expert to set up a CPanel template for my NeoBank website. Files are already uploaded, just need installing and SQL setup. Links to website setup provided.

We need a good database of Qualified and experienced candidates resumes for us to hire in a Megawatt Solar Clean energy project. Database should be live and good up to date database with full Resumes of the interested candidates.

I'm seeking a skilled WordPress developer to make a modification to the ExportCSV plugin. Key Requirements: - Implement a new field "Identification No" in the plugin's export list - This field should be sourced from a custom input form - The field should be editable by users Ideal Skills: - Proficiency in WordPress plugin development - Strong understanding of PHP and MySQL - Experience with custom form input and data export functionality - Attention to detail and ability to deliver projects on time - Previous experience with user-editable fields is a plus Your job will be to modify the ExportCSV plugin to accommodate this new field from the custom form, ensuring it's both displayed and editable in the export list. Please...

...produce a PHP website, utilizing Laravel, MySQL, HTML, CSS, and JavaScript. The primary objective of this online platform is to sell excess food, enabling a connection with farms, with comprehensive product listings available. Key Requirements are: - Development of a user-friendly website to facilitate the sale of surplus food efficiently. - Incorporation of a payment gateway that supports transactions made via credit cards. - Mobile optimization of the website ensuring a seamless experience for smartphone users. Preferably, the successful candidate will have proven experience creating similar e-commerce platforms. Knowledge in integrating credit card payments and optimizing mobile websites is a must. Familiarity with Laravel f...

Please Sign Up or Login to see details.

We are in search of a skilled Flutter developer to create an Android and iOS mobile app for an event package. The developer should possess the skills necessary to create an interface that is intuitive, visually appealing, and seamlessly navigable for users. Prior experience in designing and implementing user friendly UI/UX elements is crucial. The app's core functionalities include providing event details, schedules, committee info, speaker profiles, multi participant registration, cost estimation, secured logins, profile, payments history. Please note that no payments will be processed through the app, and there is no requirement to integrate with any Payment Gateways. The app must seamlessly sync registration data with a MySQL backend. It should ...

I'm in...an experienced developer to complete the CRM for my ecommerce business. The current developer has done an incredible job, with 85% of the project completed. However, there are a few functions and bugs that need to be fixed. The ideal candidate should have: - A strong background in Laravel - A proficient understanding of PHP & MySQL - Experience in handling complex CRM systems - Excellent problem-solving skills - A good eye for detail - Previous experience in eCommerce development would be a plus Your main task will be to: - Fix the remaining bugs in the system - Implement missing functions. - Ensure the system is fully operational, functional and secure Please only apply if you have a strong portfolio o...

"Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, in case of change not applied through Service. 6. Reading Frequency - 1 min, 10 min etc needs to be update in Regedit - HKEY_LOCAL_MACHINESOFTWAREVShieldService, Polling -1 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local. api/logs/ { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { "Policy3": &...