Sql mysql jobs

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

...developer with experience in creating automation tools. We're looking to build a sophisticated website and dashboard, which will be later integrated with API and MySQL. The final product should be a robust, blockchain-based automation platform. Key responsibilities include: - Building a website and dashboard from scratch - Implementing blockchain technology for automation - Ensuring seamless integration with API and MySQL The ideal freelancer should have: - Extensive experience in web development, particularly in creating automation tools - Proven track record in implementing blockchain technology - Strong understanding of API and MySQL integration - Ability to deliver high-quality work within a short timeframe This is an urgent project, and we need someone ...

I need a developer proficient in and a good understanding in API development. I have a parameter I would like to pass which is a string value to pull an entire user object with all of the properties in a database. this would be a string parameter passed into a Get request with a response of an entire record pulled from a MySQL database and using an Interface to extract the properties into a page. This is a very small project and should only take a few minutes of time.

I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases

...Tailored Solutions: We create custom web applications that meet your specific business needs, enhancing productivity and operational efficiency. ● Versatile Applications: Our solutions range from customer portals to complex inventory management systems, each built to address unique business challenges. ● Technology Stack: Node.js, , Ruby on Rails, Django, Laravel, MongoDB, PostgreSQL, MySQL, AWS, Docker....

...talented full stack developer, specialized in Flutter, jQuery, MySQL, AWS, and Google Cloud Platform, to help me bring my vision to life. I plan to develop a premium content platform for the web. The platform will provide a seamless user experience yet restricts premium content behind pay walls. Key requirements: - Develop a web-based premium content platform using Flutter and jQuery - Implement a secure and reliable system for MySQL database management - Integrate an inbuilt payment gateway for user subscriptions - Utilize AWS and Google Cloud Platform to ensure the platform's scalability and performance Ideal candidates should have: - Extensive experience in full stack development - Proven expertise in Flutter, jQuery, MySQL, AWS, and Google Cloud Platform ...

Project Description: I am seeking an experienced freelancer to develop a directory listing website, similar in design and functionality to the following template: The design will be provided by me. Requirements: 1. Technical Specifications: - Framework/Technology: Please suggest suitable technologies. - Database: MySQL, PostgreSQL, or another relational database. - Responsiveness: The design must be fully responsive and work flawlessly on all devices (desktop, tablet, smartphone). - SEO: It must be possible to optimize each individual listing for SEO, as well as the overall website. - Security: Implementation of security measures to protect user data. - Performance: The website must load quickly and

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintai...

I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.

Our ex...script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...

...Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. Documentation: A detailed documentation covering the system design, implementation details, and instructions for setti...

...warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills,...

...up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications  Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred.  8+ years of total experience.  Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle.  Proficiency in SQL and PL/SQL programming languages.  Strong understanding of database design principles and data modeling techniques.  Experience with database performance tuning and optimization.  Excellent communication and leadership skills.  Ability to work effectively in a fast-paced environment and manage multiple priorities.  Relevant certifications in Netezza and Oracle te...

...developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the intricacies of data security and ...

My existing React Native application, which is supported by NodeJS and backed by a MYSQL database, needs immediate attention. Here's what needs to be done: User Interface Updates: The component related to photos in the application requires significant changes. I also need a feature that shows the GPS route to the specified delivery point. This functionality was not implemented in the initial version of the application. Additionally, changing screen configuration doesn't display corresponding states with their color (only changes upon updating the application). Functionality Improvements: On top of the UI changes, the app needs general functionality improvements to enhance user experience and the app's efficiency. Also, create a button for downloading PDF files; the ...

Website Designer , Php , E Commerce having knowledge of MySQL

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

I'm looking for someone to work with me on an automated crypto trading bot. It will use Tradingview alerts, (which uses Webhook URL) to ping a script on a server, which then uses an exchange API to execute crypto trades. I will integrate the script into MySQL using php to track the amount traded and set a e.g. a sell price for the crypto just purchased after the alert... I can do that... But I need help with the integration of alerts from Tradingview and the API code to the exchange.

Project Overview: We are in need of a skilled backend developer to implement the necessary functions for our financial services website. The primary goal is to ensure smooth operation and functionality across various sections of the site. Project Details: Functionality Scope: Implement backend functions to support the frontend interface. Develop APIs ...discussed based on project scope. Timeline: Fastest to complete. Preferred Communication Channel: Freelancer platform messaging system. Additional Notes: Collaborate closely with frontend developers to ensure seamless integration. Prioritize security and data integrity in backend implementation. Skills Required: Node.js RESTful API Development Database Management (e.g., MongoDB, MySQL) Authentication and Authorization Systems

I'm seeking a skilled system administrator to replace my current MariaDB with MySQL 8.0 on a CentOS server. The ideal candidate will be able to: - Completely remove MariaDB ensuring no data loss - Install and configure MySQL 8.0, adhering to: * Default configuration * Custom storage engine Security is a key concern. Remote access to the MySQL installation must be restricted. This is crucial to maintain the integrity and security of the server and its data.

...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we

I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portfolio when applying. Your app...

...an experienced AWS DevOps specialist to host my business management tool which consists of a React-based front-end, an ASP.NET API and a MySQL database on AWS, specifically using Elastic Compute Cloud (EC2). Key requirements: - Hosting: Set up and manage the hosting environment on AWS EC2, ensuring the site is stable and accessible. - Scalability: Implement strategies to accommodate low traffic, up to 100 users per day. - Security: Ensure the highest level of security and integrity of the data. Ideal candidates should have: - Proven experience in DevOps and cloud hosting, particularly with AWS EC2. - Background or familiarity with React, ASP.NET, and MySQL. - An understanding of best practices for hosting and optimizing web applications. This project is crucial for my b...

...seeking a skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled full stack developer t...

??? ?????: ????? ?????? ????????? (????-????, ??????) Salary: up to 4000$ USD/month The ideal candidate will have a passion for algorithmic trading and extensive experience with the NinjaTrader platform software. This is a fully remote position with a flexible schedule, but the candida...Experience with version control and continuous integration tools such as GitHub/GitLab • Knowledge of third-party libraries and APIs • Proficiency in building enterprise web solutions using the MERN stack • Strong proficiency in HTML, CSS, JavaScript, and JavaScript frameworks like Dart, React, and Node • Experience with server-side languages such as Python, PHP, and C# • Knowledge of databases such as MySQL, NoSQL, and GraphQL Ability to accurately forecast and communicate ...

We have a website developed in PHP & MySQL database. We need to add news section in the home page. The same should be available to be edited from the Admin Section for the user to change contents in the News Section.

I'm seeking a skilled C# developer to create a software solution aimed at processing data from a Winsock for a wifi connected Weight Scale and get the reading and put in a Microsoft SQL database.

I am currently looking for a professional to help integrate PayPal legacy buttons into my existing shopping cart system. PayPal's documentation for the legacy buttons is not helpful. My add-to-cart button gets information from a mySQL database, but I'm unable to get the add-to-cart and view-cart buttons to work together. These used to work on an older web site. Key Requirements: - The main functionality is to enable my shopping cart to be able to process payments via PayPal. - The integration should direct customers to the PayPal website for payment processing. - I am looking for a manual coding integration, so experience in this is a must. Your Skills: - Proficiency in PayPal integration - Experience in manual coding for shopping carts - Attention to detail to ensure...

I'm seeking a skilled developer to build a professional and user-friendly dashboard using NextJS Ideal Skills: - Proficiency in NextJS for building feature-rich, responsive dashboards. - Experience with Paddle API integration, particularly for subscription management. - Strong knowledge of MySQL for robust database functionality. - A keen eye for UX design to ensure the dashboard is intuitive and user-friendly. - Ability to work efficiently and communicate effectively throughout the development process.

I'm currently looking for a skilled and experienced developer for backend CMS development. Key responsibilities: - Develop a Content Management System using PHP, Laravel, MySQL, and Python. - Design, implement and maintain python-based backend application. Essential Skills: - Proficient in PHP, Laravel, MySQL, Python. - Extensive experience in backend development. - Knowledge in CMS development and implementation. - Strong understanding of data structures and algorithms. Your analysis skills will also be put to good use to solve complex problems in this role. As an experienced backend CMS developer, you can expect to work closely with me to deliver a robust, performant, and scalable system.

I'm looking for an experienced and knowledgeable SQL Server professional who can help me resolve a connection issue I'm experiencing. - **Connection Method**: I'm currently using Windows Authentication to connect to the SQL Server. - **SQL Server Version**: I'm using SQL Server Management Studio 20. - **Error Message**: When trying to connect, I receive an error message indicating that the connection has failed. Ideal candidates for this project should have: - Extensive experience with SQL Server, particularly with the version I'm using. - Proficiency in troubleshooting connection issues. - Strong communication skills to guide me through the resolution process.

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

...my project. Key Responsibilities: - Enhancing the existing backend system: Your primary responsibility is to enhance the functionality of the current system and optimize its performance. - Integrating SQL/NoSQL Databases: Your expertise in SQL/NoSQL databases is crucial to ensure smooth integration and efficient data handling. - Experience with Python and Minio: If you're familiar with Minio that's a big plus, but Python is the key language you'll be working with on this project. Ideal Candidate: - Proven experience in enhancing existing backend systems. - Proficient in working with SQL/NoSQL Databases and designing queries. - Strong Python skills are a must. - Experience with Minio is an advantage, but not a necessity. This is a great opportunity...

I have a Wordpress plugin called Sales Agents B2B and I'm looking for a skilled Wordpress developer to make 4 small customizations to it. The customiz...subagents created by agents in their account - Showing the assigned sales agent in the list view of users - Modifying existing features: - Ensuring sales agent visibility in the list view of users The ideal candidate should have experience in: - Expertise in Wordpress plugin development - Understanding of user roles and permissions - Proficiency in PHP and MySQL for plugin customization - Previous experience in CRM system integration would be a plus Please only apply if you have relevant experience and can deliver quality work within a reasonable timeframe. I'm looking forward to hearing from you.

I am seeking a skilled PHP developer to create a distance calculating sript for me. This script will be responsible for calculating the distance between multiple coordinates stored in a MySQL database. No user interface required as the coordinates will be retrieved from the database directly. Key requirements for the project include: - Create a script that can fetch the coordinates from a MySQL database - Calculating the distance between these multiple coordinates accurately If you're a developer with experience in MySQL PHP and distance calculations, I would love to hear from you.

As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.

...bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project is intermediate, focusing on tasks like joins and subqueries. Ideal candidat...

I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI

I am looking for a freelancer who can help me with Web Scraping. We have a list of websites that we would like to scrape specific data from, and have them put into a set of MySQL Databases (or maybe something else). The website that we would like to scrape data from each contain thousands of articles, and we would also want other metadata, such as Author name, article date, number of views, or any other metadata that we can take from the pages. Please bid, and we can discuss the first website, you can tell us how long you think it'll take to write the scraper. There are maybe 50 websites to begin with that we would like to do this for, in this one project, and we also have another couple of similar projects. Ideally, the scraper will run form a program, so that we can run it...

We are the largest and fastest growing UK charity community delivering support through multiple services via our website. Our website and AI machine learning and GPT are handled by others. We need dev support for the core SQL system and 2 small SQL directories, plus running reports and system admin. We need full stack Microsoft .NET development experience, strong SQL knowledge and exposure to Azure Microsoft services. We require a range of services. We’ll begin with the ad hoc work to begin to build a working relationship and then build that up to the following on an ongoing basis. • Ad hoc tasks for minor tweaks and changes on an ongoing basis. • Larger pieces of work, such as creating a moving from a free to a free and premium versions, with up...

I need a professional NextJS dashboard created that integrates Paddle for subscription management and MySQL as database Key requirements: - Create a NextJS dashboard: The design needs to be clean and professional. I'm not looking for something overly complex, but rather a streamlined and user-friendly interface. - Integrate Paddle for Subscription Management: This functionality is crucial for the success of my project. I need the dashboard to seamlessly handle subscription management through Paddle. Ideal skills and experience: - Proficiency in NextJS: You should have a good understanding and experience working with NextJS. - Experience with E-commerce integrations: Ideally, you have previously worked on projects that involved integrating billing systems like Paddle. - Desig...

I'm currently in need of a proficient backend developer who specializes in Node.js. Key responsibilities include: - Developing user authentication - Integrating the database - API Development The chosen candidate will preferably be experienced in and MySQL, although this isn't obligatory. knowledge is a bonus. In light of a tight deadline, applicants who can start as soon as possible will be prioritized.

Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to attached document for b...

I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.

Please Sign Up or Login to see details.

...student data collection, storage, and retrieval, along with student-related functionalities. * Improvement of Attendance Tracking module, allowing real-time tracking and management of student attendance. * Development and implementation of a functional Gradebook module, enabling easy, efficient tracking, storage, and retrieval of student grades. As for the technology stack, we work with Laravel, MySQL, and HTML/CSS. These are the tools you'll be using to modify and improve the functionalities. Finally, our project strives towards a modern and minimalist design approach. We believe in sophistication and elegance over extravagance. Experience with the aforementioned technology stack and a knack for minimalist design is highly appreciated. Join us and be part of an ever-evo...

I'm looking for a skilled developer in CodeIgniter and MySQL to help me enhance a school grading system. Please note, developers who can communicate in Spanish are particularly welcome. Key Upgrades Needed: - **New Features**: Primarily, I want to introduce online grade submission for teachers and a parent portal for keeping track of students' progress. These features will significantly elevate the utility of the existing system. - **Optimization**: It's crucial that the performance of the system is optimized during these upgrades to ensure it remains fast and responsive. Specific Design Requirements: - **Modern and Sleek Design**: The new features should be incorporated into a modern-looking interface. - **Simple and Intuitive Layout**: The design should be user-fr...

...student data collection, storage, and retrieval, along with student-related functionalities. * Improvement of Attendance Tracking module, allowing real-time tracking and management of student attendance. * Development and implementation of a functional Gradebook module, enabling easy, efficient tracking, storage, and retrieval of student grades. As for the technology stack, we work with Laravel, MySQL, and HTML/CSS. These are the tools you'll be using to modify and improve the functionalities. Finally, our project strives towards a modern and minimalist design approach. We believe in sophistication and elegance over extravagance. Experience with the aforementioned technology stack and a knack for minimalist design is highly appreciated. Join us and be part of an ever-evo...