Sql query prestashop jobs

Draw a dependency diagram to show the functional dependencies in the relation. Decompose the relations into a set of 2NF. Then produce the final 3NF relations. For each step discuss your reasoning and why you have chosen the 2FN/3FN relations. Manually drawing the dependency diagram, or the set of 3NF relations is NOT acceptable.

Looking for an expert Azure Data Engineer to assist with multiple tasks. Your responsibilities will include: - Implementing and managing Azure Data Lake and Data Ingestion. - Developing ...utilize these platforms to achieve three main objectives: - Perform sophisticated data analysis and visualization. - Enable advanced data integration and transformation. - Build custom applications to meet specific needs. Candidates should have an advanced understanding of Azure Data Lake, Power BI, and Powerapps, bringing a minimum of 6 years experience as Databricks. Proficiency in Python, SQL, PostGre SQL, and Pyspark is also required. Knowledge of GitHub and the CI/CD Process will be beneficial for this role. If you have the skills and expertise needed for this project, I'd ...

...indicate with bold text for that cell to show multi line, or more then cell fit. Basically the ones that double click from last project. 2-Grid feature: Option to retain the horizontal and vertical scroll bar position between reload. Just like the sort/filter etc in the last project. 3-Grid functionality: Edit mode of grid to be able to change values in cell and write it back to database table the query results. Have checkbox to enable on grid, as it should be ready in only first. 4-Merge 2 files data. These are tab delimited files. I need them to be merged so no duplicates. 2notes: a)-a duplicate could also be the left and right on either side. meaning, dog,cat is same as cat,dog. so only one should be there, not both. b)-there is a column for group number. this numb...

create a WhatsApp bot that queries a MySQL database. I have a wordpress website (listings). I want the owners to be identified by the bot if their WhatsApp number matches the database and re...Requeriments: WhatsApp bot python Dashboard Installation in my VPS server Configuration Restart command = "Restart" 
 End conversation = After 1 hour without interactivity (Cron) 


 Dashboard: 

 1. General settings 

 API's, keys, emails, etc. 

 2. Conversations 

 View conversations 

 reply chat 

 restart conversation command = "Restart" 

 Warning when user request chat



 MySQL

 query= user_id from= ib_usermeta 
 select ID, post_title, post_name from ib_posts post_type = 'listing' and post_status = 'publish' and post_author = {us...

I am in need of a skilled freelancer who can help me with my personal SQL database project. The main task involves editing a syntax. In order to perform this task effectively, you should: - Have extensive knowledge and experience working with SQL databases. - Be proficient in storing, retrieving, and analyzing data. - Provide an effective solution to the specified problem related to syntax editing. Only those who are experts in database administration and adept at problem solving are encouraged to bid. Being able to address this issue promptly is vital. Looking forward to hearing from you.

I am looking for a freelancer who can help me install the Tamara gateway payment plugin on my PrestaShop website. Skills and Experience: - Experience working with PrestaShop and installing payment gateway plugins - Familiarity with the Tamara gateway payment system - Attention to detail to ensure the installation is done correctly Project Requirements: - Install the Tamara gateway payment plugin on my PrestaShop website - Ensure the plugin is properly integrated and functioning correctly - Test the payment system to ensure it is working smoothly Note: I will provide the Tamara gateway payment plugin for installation. There are no additional features required for the payment system.

...for hosting the application. • Understanding of cloud storage, computing, and networking services. • Knowledge of deploying and managing applications in a cloud environment. Web Security: • Strong understanding of web application security practices. • Experience with implementing SSL/TLS, data encryption, and secure user authentication. • Familiarity with common security vulnerabilities (e.g., SQL injection, XSS) and their prevention methods. Ideal Candidate Profile: • At least 3-5 years of experience in full-stack development, particularly in SaaS platform development. • A strong portfolio demonstrating relevant projects, with a focus on SaaS and marketing tools. • Ability to translate complex requirements into functional, user-friendly...

...maintainable code and resolve software defects and issues up-to-date with the latest .NET technologies and best practices Requirements: 1. Proven experience as a .NET developer 2. Strong proficiency in C# and the .NET framework 3. Experience with ASP.NET, MVC, Web API, and other related technologies with front-end technologies such as HTML, CSS, and JavaScript 5. Knowledge of SQL Server or other relational databases 6. Excellent problem-solving and communication skills How to Apply: Please submit your proposal with the following information: relevant experience as a .NET developer. of previous projects showcasing your skills. hourly rate or project-based pricing. 4. Your availability and estimated time to complete the project. Note: We are looking

Hi, I have a website on PS 1.7.8 and i have an error on category pages. I will explain you better on chat, i need you to fix this error for me.

I am looking for a nutritionist app built in Laravel that includes the following features: - Client management: ability to add and assign clients to nutritionists - Calendar integration: syncing with external calendars and the ability to schedule appointments - Financial tracking: keeping track of payments and expenses...schedule appointments - Financial tracking: keeping track of payments and expenses For the calendar integration, I have specific requirements, including: - Reminders controlers for the apointments and notifications. Ideal skills and experience for this project include: - Proficiency in Laravel framework - Experience in building and integrating calendar features - Knowledge of financial tracking - SQL The App i already in development and we need to add some new...

Hello, I have few prestashop websites.. We are looking for developers can handle those. We will have Frontend and Backend works Regards, VishnuLal

I am looking for a PHP web developer who can quickly complete a project within a week. Skills and Experience: - Proficiency in PHP - Familiarity with Laravel, Symfony, or CodeIgniter frameworks - Strong understanding of web development principles and best practices - Experience working with databases and SQL - Ability to work efficiently and meet deadlines The project may involve working with existing code or starting from scratch, depending on the client's requirements. If you are a skilled PHP web developer who can deliver high-quality work within a tight deadline, please apply for this project.

As the backbone of my project, the MongoDB database performance is currently subpar. I need a Mon...currently subpar. I need a MongoDB expert capable of identifying and rectifying the reasons behind its slow speed. The database is less than 5GB in size and contains semi-structured data. The primary task is to investigate the long, slow queries that are causing the performance issues. The person for this job should: - be proficient in MongoDB and its performance tuning - have a deep understanding of query optimization - have experience working with semi-structured data - be able to analyze and interpret complex data. A detailed report of the issues discovered and actions taken to resolve them will be expected at the end. Your ultimate goal is to improve the database's perform...

I am looking for a skilled .NET developer to work on my defined project for a duration of 1-3 months. The project requires expertise in C#, ASP.NET, and SQL Server. Specific requirements for the project include: - Developing and implementing ASP.NET web applications using C# - Integrating SQL Server for database management and data retrieval - Collaborating with the team to design and develop efficient and scalable solutions - Testing and debugging code to ensure functionality and performance - Providing ongoing support and maintenance as needed Ideal skills and experience for this job include: - Proficiency in C#, ASP.NET, and SQL Server - Strong knowledge of web development principles and best practices - Experience with front-end technologies such as HTML, CSS, a...

...Administration, Cloud Architecture, and Cybersecurity. I'm seeking a qualified Python and SQL instructor who can teach me how to use these languages for practical applications in my current role. - You will help me learn how to use Python and SQL for: - Data analysis and reporting - Automation of repetitive tasks - Database management - Training should specifically cover applications of Python and SQL in: - Network monitoring and analysis - Configuration management - Log Analysis and reporting Please, note that I'm a beginner. Therefore, the course needs to start from the basics and gradually ramp up to more advanced concepts. Ideal candidates will have a strong background in Python, SQL, and IT, as well as experience...

Looking for a Power BI and SQL expert who can assist me with data analysis and visualization, report creation, and dashboard design. The ideal candidate should have experience in query optimization and performance tuning. I require assistance specifically during the time period of 12 AM to 5 AM IST. No specific deadlines have been mentioned for this project.

I need an expert in ABAP and HANA sql to help me coding bind variables. SAP recommended us to switch our WHERE clause to BIND VARIABLES. [Removed by Admin] We are going to work it together on a live call. Payment is hourly.

Hi, I'm looking for a web app developer to create a web app for my existing site (built with Wordpress). The w...Interactive graphic capabilities: the projects that users collaborate on will be interacted with via a dynamic interface - Ideally the web app will be mobile-friendly, but this is not essential, especially in the early stages. Ideal skills and experience: - Strong experience in web app development, specifically with Javascript - Understanding (and ability to explain/teach) how JS links to Wordpress/HTML, SQL (for business logic), and how to maintain/tinker with the system - Knowledge of user login and registration functionality - Familiarity with responsive design principles is a plus, but not required - Ability to suggest and implement a visually appealing design ...

I have a query that performs a calculation that pulls data from my api. It gets the data daily. 1) I need that query put into a new database table, for faster access. The new table should be able to run a cron or something to get the new data daily into the new table. 2) This will ensure that 2 pages (predictions and betting) won't need to calculate or run long queries, but get the predictions direct from the new database table. 3) The profits page, will get information from both: - New Predictions Table - Results Table (with the joins) Please see logic of before and after. 4. Diagnosing and fixing the profit and loss calculations for race, event, and range that are currently malfunctioning. 5. Resolving the issue with filter odds, which is currently not perfor...

Node JS Hosting on Google Cloud Platform I am looking for a developer who can help me with hosting my exist...Node JS Application: Yes Database: Node JS Skills and Experience Required: - Experience with Node JS hosting on the Google Cloud Platform - Strong knowledge of Google Cloud Platform and its services - Familiarity with deploying and managing Node JS applications - Understanding of database management in a Node JS environment, specifically NoSQL databases like MongoDB or Firebase - Knowledge of SQL databases like MySQL or PostgreSQL is a plus - Ability to troubleshoot and resolve any issues related to hosting and deployment on the Google Cloud Platform If you have the expertise and experience in Node JS hosting on the Google Cloud Platform, please feel free to reach out. ...

...for text data. Uncertainty persists about whether to use SQL database for storage, so your expertise is needed. The ideal candidate will have: - Proven experience with data repository creation. - Comprehensive understanding of data types, particularly text data. - Expertise in helping clients to choose the best database for their needs. In this case, helping me decide whether to go with SQL for text data storage. - Familiarity with various data format structures. While there's a preference for SQL, this is not set in stone. This project will require you to: - Develop a structure uniquely suited to storing text data. - Provide expert advice on the most suitable form of database for this type of data - we are currently considering SQL. - Ensure the sele...

...functionalities. - Database management: Implement and manage a secure and efficient database system. 2. Python Roles - Data analysis: Extract insights from provided data sets to guide website development. - Web scraping: Acquire necessary information from different sources to enrich content. Expected Skills & Qualifications - Proficiency and demonstrated experience in CodeIgniter, Python, and SQL. - Good knowledge and experience in data analysis and web scraping. - Ability to design and manage an efficient and secure database system. - Strong front-end and back-end development skills. - Attention to detail, creativity, and a problem-solving mindset. By joining this project, you will bring a novel application to life and provide data-driven insights to guide its development...

I am in need of a PrestaShop developer for theme customization. Specific tasks include: - Customizing the theme to match my brand and aesthetic preferences Design elements and features: - While I don't have specific features in mind, I have a general idea of what I want the theme to look like and the functionality it should have Timeline: - The project completion timeline is more than 2 weeks Ideal skills and experience for the job: - Proficiency in PrestaShop development - Experience in theme customization - A strong understanding of design principles and aesthetics - Ability to work within a given timeline and meet project deadlines

We need a prestashop developer if you have an experience in this field definitely we will talk in the chat

I'm in the process of securing my personal blog against potential threats. As such, I need an expert in SQL injections to: - Identify vulnerabilities: Look at my current SQL system, unearth weak points that could potentially be exploited, and advise on these possible vulnerabilities. - Implement security measures: Fix identified flaws, close up holes, and reinforce the security of my SQL to make it more robust and resistant to cyber attacks. - Conduct penetration testing: Run tests on the new security measures to ensure their effectiveness. Try to penetrate the website using different methods and provide a detailed report of the findings. The primary purpose of this project is to test my website's security, so experience with security audits and penetration...

I am looking for help to create a local containerized environment (docker-compose) of our existing LAMP website at so can effectively have a local development environment. Containerized components to include are apache, mysql, php, phpmyadmin Website is running on the following version components Apache Version: 2.4.57 ...help to create a local containerized environment (docker-compose) of our existing LAMP website at so can effectively have a local development environment. Containerized components to include are apache, mysql, php, phpmyadmin Website is running on the following version components Apache Version: 2.4.57 PHP Version 5.4.45 MySQL Version 5.5.62 Will provide you with database sql file to import and the app files of the website

I need an elastic search export, to help me create a function/query to correctly generated faceted search, basically i have dynamic attributes and when generating the buckets i need to exclude the filter from each same attribute name/group so i can get the values without the group condition to provide good use experience. Example: i have dynamic attribute like this Attribute name: Type Attribute values: Type1, Type2, Type 3; Attribute name: Length Attribute values: Length1, Length2, Length3; if i have condition with type=type1 and length = length1 I need foreach of them to get all the other values from the same attribute name while ignore the condition from the same attribute name but applying the conditions from other attribute names. I will provide an existing php function ...

Azure MS SQL Having High I/O Utilization. There are two unwanted processes that need to be killed. Conditions: 1. Issue to be resolved on my device remotely. 2. Complete knowledge sharing on successful completion 3. Payment on successful completion of task. Success Criteria 1. I/O Utilization to become normal below avg 20% 2. Removal of two processes Spid:64 & 65.

I'm in need of a Tableau and SQL specialist who can guide me through the creation of a KPI dashboard based on revenue vs target data. While I have intermediate knowledge of the software, specific assistance is required in building a clear, informative visualization of my company's revenues growth rate. This involves not just creating a standard dashboard, but really getting into the depth of what Tableau and SQL can offer. The ability to work collaboratively and communicate complex data in a comprehensible manner is vital. Ideal skills and experiences: - Advanced expertise in Tableau and SQL - Prior experience with sales data visualization - Exceptional skills in interpreting and showcasing KPI data - Proven ability to teach or guide others. (Videos and vid...

...experienced in Laravel framework. The successful candidate will be tasked with executing key improvements to my website including: - Front-end and back-end development: We want the entire UI and the server side to be developed and improved, making it more interactive and efficient. - Database integration: This involves storing, retrieving and using data from our server. We require someone proficient in SQL and can comfortably work with large datasets. - API integration is essential. You will connect reusable resources with applications and devices. Knowledge in RESTful API is preferred. Hence, experts in Laravel with the ability to manage front-end and back-end development along with database and API integration are welcome to apply. Your contribution will undoubtedly bring the...

Project Description: AI Installation on Ubuntu I am looking for an experienced freelancer to assist me with installing AI software on Ubuntu. I already have an Ubuntu platform setup but I am somewhat new to the Linux world. My rig has a...Looking for the AI model to be primarily CPU/RAM based to be able to answer questions in a chatbot format. Want everything to be run locally without connecting to other bots using API keys. Wanting it to use the Bloom checkpoint at Also wanting another local model setup that can do picture generation. Again no APIs are to be used. All information and query responses are to be only kept locally as well not uploaded anywhere. After both AI bots installed, if you could run me through a breakdown on how to use.

I'm urgently seeking an experienced freelancer to design a WordPress page that has a search query functionality capable of retrieving data from a MySQL database running on an external linux server (AWS EC2). Although I skipped outlining the specific dataset required, a comprehensive understanding of MySQL databases is vital. The ideal freelancer for this job should: - Have profound Wordpress and MySQL experience - Possess a solid understanding of Search query forms and DataTables - Be capable of a speedy project turnover Please note, the completion time for this project is ASAP, demonstrating its high priority status. Speed without compromising quality is highly favored.

...need of a developer who is well-versed in both Node.js and MySQL. The task that requires assistance includes the following: - Front End Changes & Bug Fixes - Backend functions - Query optimization While the specifics about the task weren't specified, it would be ideal for you to have a solid experience in the areas mentioned above. To further your success in your application, please include the following: - Examples of previous work, specifically projects where Node.js and MySQL were utilized. - Details of your experience with these technologies. - A project proposal including your approach to database design, query optimization, and data migration. In addition, this project might also involve frontend development. Therefore, having skills in frontend techno...

...need of a developer who is well-versed in both Node.js and MySQL. The task that requires assistance includes the following: - Front End Changes & Bug Fixes - Backend functions - Query optimization While the specifics about the task weren't specified, it would be ideal for you to have a solid experience in the areas mentioned above. To further your success in your application, please include the following: - Examples of previous work, specifically projects where Node.js and MySQL were utilized. - Details of your experience with these technologies. - A project proposal including your approach to database design, query optimization, and data migration. In addition, this project might also involve frontend development. Therefore, having skills in frontend techno...

I have the attached report in PHP that is generated by a query in mySQL based on date. I want to dynamically sort the reports by the headers in the report. I need to keep the report in the same format. There should be carats to sort the columns ascending and depending. Below is the mySQL as well. $dbRegionImpact = mysqli_query($conn, "SELECT COUNT(*) AS Cars, SUM(Families), SUM(People), Zipcode, ZipCode_Detail.Zipcode_D, , , FROM Greeter_Detail LEFT JOIN ZipCode_Detail ON = ZipCode_Detail.Zipcode_D WHERE $dateRange GROUP BY Zipcode");

I require an experienced Flutter expert who can integrate a Federated Learning model into my project. Below are the specific needs: - Machine Learning integration using the Federated Learning model - You'll be expected to train a new model for this task - We'll be providing you with structured data, primarily from Excel spreadsheets and SQL databases The perfect freelancer for this job would ideally hold the following skills: - Proficient in Flutter framework - Experience in Machine Learning (specifically Federated Learning) models, and their integration - Expertise in handling and analysing structured data for the training of machine learning models Your ability to provide assistance, strategies and methods regarding the training and integration process will be highly...

I am looking for someone that is fluent in html, css and javascript I need to fix a bug "create a normalize css file" and "Have a media query for another size."

I am looking for a freelancer who has strong skills in SQL, Python, and Business Intelligence. The main goal of utilizing Business Intelligence in this project is to improve decision making. The specific tasks that I need help with are query optimization in SQL and data analysis in Python. Ideal skills and experience for this job include: - Strong knowledge and experience in SQL query optimization - Proficiency in Python for data analysis - Familiarity with Business Intelligence concepts and tools - Ability to write complex SQL queries - Attention to detail and ability to extract and transform data efficiently If you have expertise in these areas and are ready to take on this project, please submit your proposal.

As the driving force behind our project, you'll be responsible for creating a modern and sleek online code compiler. Not only should this tool be aesthetically pleasing, but it also needs to be functional and user-friendly. You'll be required to: - Implement support for diverse programming languages that include (but are not limited to) Python, C++, C, SQL, and Java. - Incorporate key features such as a code sharing feature and debugging tools, taking account of our drive for a collaborative and user-friendly platform. Ideally, you're an experienced developer versed in the programming languages specified and have a keen eye for design. We value creativity and innovation, thus we’re interested in individuals who can offer fresh perspectives and ideas. Profici...

I am looking for a freelancer who can help me integrate my Java code into Oracle Database 11 using PL/SQL. The purpose of this integration is to call the Java code for external API integration. Skills and Experience: - Proficiency in Java Stored Procedures - Strong knowledge of Oracle Database 11 and PL/SQL - Experience with external API integration - Ability to set up the environment for the integration The ideal candidate should be able to assist me in setting up the environment for this integration as well.

I'm in need of a seasoned PHP developer for the development of a web application. Though specifics were not laid out, a well-rounded skill set is necessary. Key Tasks: - Backend development - Create database queries It's important to note that the purpose of this undertaking is to develop a web ...necessary. Key Tasks: - Backend development - Create database queries It's important to note that the purpose of this undertaking is to develop a web application. Unfortunately, the specifics of the type of application haven't been determined yet. So, proficiency across a wide array of web applications is essential. Ideal Skills & Experience: - PHP development - Backend programming - Database query creation - API Integration - Versatility and experience with ...

I am looking for a freelancer who can assist me with asset/facilities management tasks for my project. The ideal candidate should have experience in spatial data analysis, asset/facilities management, and 3D visualization. Preferred Skills and Experience: - Strong knowledge and experience in asset/facilities management - Proficiency in spatial data analysis and 3D visualization - Expertise in PostgreSQL database management system - Experience with data integration services Project Requirements: - Assist in managing assets and facilities within the project - Perform spatial data analysis to optimize asset/facilities management - Create 3D visualizations for better understanding and presentation of assets and facilities - Utilize PostgreSQL as the preferred database management system - Int...

I am in need of an expert Python programmer to aid in the refactoring of my code to enhance its efficiency. The code is well-documented but would still benefit from improvements specifically in the following areas: - Algorithm optimization - Database query optimization The ideal candidate for this project will have extensive experience in both algorithm design and database management, and should have a track record of being able to enhance the efficiency of code. An understanding of Python language is a must for this project, and your job will involve utilizing this skill to identify bottlenecks and high-traffic areas in the code that could be made more efficient. You will not only need to debug the code, but also provide recommendations on how to improve it for better performance.

...intuitive user experience - Optimize the website for mobile responsiveness - Implement search engine optimization techniques for better visibility on search engines Ideal Skills and Experience: - Proficiency in web development languages such as HTML, CSS, and JavaScript - Experience in building custom e-commerce websites with complex functionalities - Knowledge of database management systems and SQL - Familiarity with web security best practices and PCI compliance - Ability to create responsive and mobile-friendly designs - Strong problem-solving and troubleshooting skills If you have prior experience in developing custom e-commerce websites and possess the necessary skills, please submit your proposal along with relevant portfolio examples. I am open to suggestions and would a...

...graph. Sorting and Searching Algorithms: Implement quicksort or mergesort. Write an algorithm for binary search. Find the kth largest element in an unsorted array. Dynamic Programming: Find the longest increasing subsequence in an array. Compute the minimum path sum in a grid. Solve the 0/1 knapsack problem. Databases and SQL Queries: Write a SQL query to find the second highest salary. Design a database schema for a given problem statement. Optimize a given SQL query. Solution Design: Design a parking lot system using object-oriented principles. Propose a data model for an e-commerce platform. Outline an approach to scale a given algorithm for large datasets. Big Data Technologies (if applicable): Basic questions on Hadoop, Spark, or other big da...

Hi, I am seeking a skilled .NET developer to assist me with an ASP.NET project. This project involves working with existing code and requires someone with experience in ASP.NET. The ideal candidate should have a strong understanding of the ASP.NET framework and be able to work with ADO.NET. The project is expected to be long term and having knowledge of SQL Server. Freelancer and Team both are welcome. Looking forward. Dipak

...particularly with slow queries. I require an experienced database professional to analyze and clean up my current database system to improve performance. The primary operations causing slow queries are unclear at this stage, hence your task would include diagnosing the root cause of the issue. The successful candidate should possess: - Extensive MySQL experience - Expertise in troubleshooting slow query problems - Strong analytical skills to identify and resolve issues. Your main responsibility will be to eliminate any bottleneck in the database system, optimize queries and ensure smooth functionality. Experience with data insertion, data retrieval, and data update operations will be an asset, as these may be the potential sources of issues. We are looking for quick resol...

I'm in desperate need of a PrestaShop developer who excels in problem solving. My existing website is experiencing frustrating performance issues that urgently require a remedy. A successful candidate for this project will have: - Proven experience with PrestaShop and its various modules - Expertise in performance optimization - A keen eye for diagnosis and effective trouble shooting methods - Excellent communication skills to walk me through their problem-solving process Looking forward to working with you and enhancing the performance of my online storefront.

I am...my PrestaShop plugin. The specific issue I am experiencing is that the plugin is not installing correctly. I am using version 8.1.2 of PrestaShop. I will tell you some points to check, and you need to find the bugs and fix it. The plugin is moderate complex, but the installation is quite straight forward. Please mention Dingo in your proposal. The project is only limited to the bugs during installation and not including possible bugs in other functionality (whereas I would be happy if you mention it if you find one). Skills and Experience: - Strong knowledge of PrestaShop and plugin development - Experience in troubleshooting and fixing installation bugs - Attention to detail and ability to thoroughly test the plugin installation process - Familiarity with ver...

...am looking for a highly skilled developer with a deep knowledge in backend development and Flutter. Ideal Skills: • Backend Development • Flutter Framework • SQL Database Management Your primary focus will be on the development of the real-time data synchronization feature. The ideal candidate would have significant experience with SQL database technology. This project will involve bringing the concept to life by applying your advanced understanding in both backend development and Flutter. This is an exciting opportunity to work on a dynamic and innovative project where your expert skills in Flutter, backend development, and SQL will be vital. I look forward to partnering with a knowledgeable individual who can see this project through to completi...