Write sql query jobs

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.

I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm i...security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the peace of my server wor...

As a MongoDB Expert, my primary need is to work with someone who can assist with two key areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand ...

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

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.

...continuously improve our data solutions Key Skills :- • Bachelor's degree in Computer Science, Information Technology, or related field. • 4-5 years of professional experience as a Data Engineer with a focus on Azure Databricks and Azure Data Factory. • Strong proficiency in SQL, Python, and/or Scala for data manipulation and scripting tasks. • Experience working with data lakes, data warehouses, and ETL processes. • Familiarity with cloud platforms (preferably Azure) and related services such as Azure Blob Storage, Azure SQL Database, etc. • Excellent problem-solving skills and attention to detail. • Effective communication and collaboration skills to work with cross-functional teams. • Azure certifications (e.g., Microsoft ...

need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a precise timeline has...

...Azure Cloud Infra/Azure APIs/Connectors/3rd Party AI Model/AI Tools required for Hosting, Processing, and Training of Models, etc. End Users – Website Users Development Timelines- 30 Working Days. Access: Secure Login Part C: Development and Implementation of Virtual Learning Assistance. • We will provide access to Existing learning Databases (Videos, Books, PDFs). • Bidders must develop API Query to enable Virtual Learning Assistance to Website Users. End Users- Website Users Development Timelines- 30 Working Days. Access: Secure Login AMC Requirement: • The bidder must create, set up, and configure a new cloud infrastructure under the name GCC Law Help and may also require creating and setting up third-party generative Accounts under the name GC...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm in need of a website and custom...(Django/Flask), Ruby (Ruby on Rails), or PHP (Laravel).  Database: MySQL, PostgreSQL, MongoDB, or similar.  Web server: Apache, Nginx, or equivalent. 3. Payment Gateway Integration:  Select and integrate with a payment gateway provider that meets the project requirements (e.g., Stripe, PayPal). 4. Security Measures:  Implement secure coding practices to prevent common vulnerabilities (e.g., SQL injection, XSS).  Use encryption for sensitive data storage and transmission. 5. Hosting and Deployment:  Leverage existing hosting provider of the platform supports the required technologies; otherwise recommend an alternative platform.  Set up automated deployment pipelines for continuous integration and delivery (CI/CD).

MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 4- Packages Load from APIs instead of loading from DB (2 APIs) 5- Subscri...

...for mobile development as well. You’ll need: In-depth working knowledge of functional React, preferably 16.8+ In-depth knowledge of ES6 syntax Fluent in Typescript Experience using a 3rd party component library (e.g. MaterialUI) and/or CSS frameworks Experience working with state management tools (e.g. React Query) Familiar with Git, including standard development lifecycle (feature branching, pull requests, CI/CD) Experience with React testing methodologies, or a strong desire to write testing An interest in all aspects of the SDLC, including talking to clients is ideal When you work for us, you’ll enjoy: Rapid career advancement based on initiative and performance A huge variety of work A relaxed, supportive and social environment An opportunity to work a...

This project involves writing high-quality blog posts and web pages to drive more traffic to the website. The content should be easy to understand, engaging, and attract the readers.

My Laravel project is causing ...performance. Key Responsibilities: - Diagnose the root cause of the performance issue, specifically tied to the high CPU usage - Implement Laravel best practices for handling complex queries - Provide recommendations and implement changes to optimize the project's performance Ideal Skills and Experience: - Proven experience in optimizing Laravel projects - Solid understanding of database indexing and query optimization - Familiarity with caching strategies and how to implement them in a Laravel project This is a high-priority task. Immediate availability and quick turnaround will be highly appreciated. Duevto cpu usage website is not accessible. It require experience. Beginners please do not bid as you will be ignored Server is using cpane...

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will...Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excit...

for adult sites (XXX) (¡¡¡¡READ THE DESCRIPTION COMPLETELY !¡¡¡) this is our site, we want a freelancer that can give at least 30 highquality backlinks in at least 15 articles Permanent is a MUST, No Duplicates if you want to be hired, send the list of domains where you will publish the articles with the PR No spam backlinks like blogsport, comments on other postings things won´t be accepted neither Budget: 400 USD don´t harrass me, just bid and send the list, otherwise you will be blocked and reported

...XSLT. Write Efficient, Clean, And Reusable Code That Complies With Company Standards And Best Practices. Collaborate With Project Managers, Business Analysts, And Other Team Members To Understand The Requirements And Provide Technical Solutions. Perform Database Management Tasks, Including Design, Modifications, And Performance Tuning. Assist In The Integration Of New Software And Systems Into Existing Environments. Maintain Documentation For System Processes And Procedures. Participate In Code Reviews, Contribute To Team Knowledge, And Mentor Junior Developers. Required Skills: Strong Proficiency In Perl Scripting And Python Programming. Experience With XML Technologies, Including XML Parsing And XSLT Transformations. Good Understanding Of Relational Database Management Syste...

I'm in need of a skilled freelancer to set up and install Primavera P6 EPPM 21.12 locally on Windows. This is a single user setup, with SQL database configuration included. Key Tasks: - Install Primavera P6 EPPM 21.12 on a Windows system - Complete and configure the SQL database for the software Ideal Freelancer: - Experienced with Primavera P6 EPPM installations - Proficient in SQL database setup and configuration - Understands the intricacies of Windows OS - Prompt and clear in communication

...address and make a payment. Rating page. Users will be prompted to login before accessing this. Star ratings will be filled in here, and the welcome text will have each users [first_name]. Generate a custom QR code to a rating page with pre-filled order number (unique identifier from above) Order confirmation email. With animated banner and QR code. SQL database. All data from the users, questionnaires, orders, and ratings will be stored in a postgres SQL. I have specified the database design (see below). Currently there is no API to warehouse/shipping (postage of orders are handled manually, but please set up the database with the future API integrations in mind). Manual order (in backend). Basically, I want to be able to look at the sample ratings for each sample order a...

I'm in need of a skilled .NET developer to create...additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marked as 'unsure', the ability to handle this efficiently would be a plus. Ideal Skills: - Proficiency in .NET development - Strong knowledge of SQL databases and data management - Experience in user authentication and registration systems - Previous work involving user role and permission management - Flexible to adapt and integrate external systems when required If you're a skilled .NET developer with a track record of creating user-centric web applicatio...

I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project sho...

I'm in need of a skilled web developer highly experienced in both Angular and Javascript. The primary objective for this project is to create a website with a responsive design that aligns with my provided brand guidelines. Key Qualifications: - Proficient in Angular and Javascript - Extensive experience in responsive design - Extensive experience in .Net Core and SQL Responsibilities: - Adhere to design and branding guidelines during web development - Create a website that is user-friendly on all devices. Please ensure to provide examples of past work with responsive web design during your application.

...Remove the "//const MongoClient = require("mongodb").MongoClient;” line 2 - Run ‘docker compose up’ to start the code 3 - Fix the code so it does not crash 4 - Demonstrate a working connection between the application and a remote Mongo Atlas database (you will need to create one yourself or point to one). The data does not matter, I just need to see examples of: a) A READ query, b) An UPDATE query, c) A CREATE new record query Error See this file for a description of the error which needs to be fixed - Debugging The application connects to a remote Mongo Atlas database correctly if the code is run outside the container. I’ve developed a simple Mongo connection js file which tests this. The output is shown here - h...

I have a course I am making. it requires 3000 words to be written in English. It will need APA references and I will be selling the course. The course is a leadership course. I will be using plagiarism checker, ai checker and paraphrase checker to ensure no short cuts are taken. So no chat GPT or quillbot should be used to write the content. If you are interested please bid.

...applications, with the aim to identify and eradicate any potential vulnerabilities. Key Tasks: - Perform Open Source Intelligence (OSINT) - Port scanning - Man-in-the-middle (MiTM) attack simulation - Focus intensively on injection attacks (SQL, XSS) - Authentication and session management puncturing - Cross-Site Scripting (XSS) evaluation The ideal freelancer will have: - Strong experience in cybersecurity and penetration testing - Excellent knowledge and experience with Linux-based systems - Proven experience in web application security testing - Firm understanding of SQL, XSS and authentication vulnerabilities Your final deliverable will be a complete penetration testing report, detailing vulnerabilities found, their potential impact, and recommended remediation step...

Hi I will share the details with the shortlisted candidates. Thanks

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

...processes it in Wordpress. The Incremental link makes a POST request to this script containing the data. In the script you see 3 types of actions in a switch: Add (new vehicle) Change (vehicle exists, adjustment is being pushed) Delete (vehicle is deleted) Below is a brief explanation of the three functions involved: add_post Here I build a Wordpress Query containing data from the POST request. Then I run a "wp_inset_post" function with this query. From that Wordpress function you will then receive a "post_id" with which I will add photos to the post. change_post Same as "add_post" but I use the "update_post" function because I already know the post_id. Then I'll delete all the photos from this post and add them again. I do ...

...already converted 50-60% to ) and also transfering our .NET to .NET CORE and our MS SQL to PostgreSQL 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 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 03: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

...not receive any pre-existing design templates such as Figma, but you may refer to a competitor's website for inspiration. The goal is to build a platform that efficiently categorizes Telegram channels and groups by country and category, facilitating easy navigation. This website will be developed using React, Node.js, and PostgreSQL. It must be fast, secure against common web threats including SQL injections, Cross-Site Scripting, and IDOR's. It should also be optimized for search engines to achieve high visibility online. Key Features of the Website: * Channel and Group Organization: Separate listings for channels and groups, categorized by countries and specific categories. * Search Functionality: Advanced search options allowing users to find channels and groups...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm looking for a skilled ASP .NET web developer to work on a small project. Key requirements: - Fullstack development: The project involves both front-end and back-end development. The ideal candidate should be proficient in C# and ASP .NET. - Database Integration: The project will be using SQL Server, so experience with this database type is needed. Skills required: - Proficiency in C#, ASP .NET, and SQL Server - Experience in fullstack web development - Strong understanding of database integration and management Your role will be to take the project from concept to completion, ensuring that all elements are well-integrated and functioning smoothly. If you are a reliable, detail-oriented developer with a strong track record in ASP .NET web projects, I'd love to...

...secure authentication practices, such as password hashing and the use of access tokens, to prevent unauthorized access. 5. Input Validation and Sanitization: To mitigate the risk of security vulnerabilities, the application will implement strict input validation and sanitization techniques. This section emphasizes the importance of validating user input to prevent common vulnerabilities, such as SQL injection and cross-site scripting (XSS) attacks. 6. Secure Transaction Processing: The application will incorporate secure transaction processing mechanisms to ensure the integrity and confidentiality of financial transactions. This section discusses the implementation of secure communication protocols, such as HTTPS, to protect sensitive data during transit. It also highligh...

...JavaScript framework (React, Angular, Vue.js) considering factors like project complexity, team expertise, and desired features. Back-end: Select a server-side technology (Node.js, Python with Django/Flask, PHP with Laravel) based on performance requirements, scalability needs, and developer familiarity. Database: Choose a suitable database (MySQL, PostgreSQL, MongoDB) based on data structure, query complexity, and scalability requirements. Other Considerations: Authentication/authorization, payment processing (if applicable), CMS (if needed). 3. Development Process: Front-end Development: Implement the user interface and user experience using your chosen framework, following component-based architecture for maintainability. Back-end Development: Build your server-side APIs usin...

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 looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.

...understand and implement complex backend features in my apps. - Firebase rules: A good understanding of how to set secure and efficient rules in Firebase is essential. - State management: I need to understand advanced state management techniques in FlutterFlow. - Data handling: I need to learn how to efficiently handle data within my applications and understand the best practices. I am a veteran PHP SQL developer and I find it difficult to wrap my mind around nosql and mobile app development in general. I am looking for: - An individual with advanced knowledge and experience in FlutterFlow. - Someone who can teach effectively in a one-on-one setting. - A patient mentor who can break down complex ideas into easily digestible concepts. - IMPORTANT: we need to understand each othe...

As an exper...experience in Laravel and you're familiar with Laravel 11. • You've previously developed websites using Laravel 11. • Your forte is optimizing code efficiency and database queries. • You have a strong understanding of how to improve page load times and database query speed. Your task: • Optimize my existing codes in Laravel 11, for open source project • Main areas for optimization include database queries and code efficiency • The goal is to achieve faster page load times and improved database query speed. • Test subscription and plans, if it works fine or not Please, only apply if you have the mentioned skills and experience and you're able to demonstrate evidence of past projects you've optimized for p...

Buscamos incorporar especialista programador .net freelance con conocimientos en: c# .net, asp, sql server se valorará experiencia en: integraciones api, en back-end y front-end. Trabajo principalmente en remoto, para colaboración continuada en desarrollos propios de nuestra empresa, con un mínimo de 40 horas mensuales.

As a startup in AI and AI/ML solutions, we are seeking a part time senior data scientist to help us to design a text 2 sql solution using existing open source solution, integrate with other data service. Having a deep understanding of ,LLms , NLP, Text2SQL and AI Agent (OpenAI) , stream-lit will be essential. 3 hours days in average for a part time jobs for months; - The successful applicant must be fluent in Python and have a solid understanding of latest GPTs, GenAI and langchain, GenAI etc The ability to develop and fine-tune algorithms as per project requirements is paramount. If you are able to make AI comprehend and utilize human language, efficiently and effectively, your expertise is needed here.

I am in need of an exp...developer to create an interactive, transactional platform with the ability for information sharing, social interaction, and query resolution. This platform should be accessible both as a mobile app and a website, with seamless functionality across Android, iOS, and various web browsers. The ideal candidate for this job would have the following skills and experience: - Expertise in both app and web development, with a portfolio of interactive, transactional sites/apps. - Experience with Android & iOS app development. - Understanding of user experience, particularly in relation to e-commerce and social networking. - Proven problem-solving skills in the area of query resolution. Please provide examples of your work and detail your experience w...

...accomplished Power BI and DAX expert who can help me develop a comprehensive dashboard for data analysis. Key Responsibilities: - Create a data analysis dashboard in Power BI that is user-friendly, visually appealing, and easy to interpret. - Establish reliable connections to SQL databases to pull in the necessary data. - Implement DAX functions and calculations to ensure accurate data analysis. Ideal Candidate: - Previous experience in developing Power BI dashboards for data analysis. - Proficient in working with SQL databases and connecting them to Power BI. - Strong knowledge and understanding of DAX functions and calculations. - Excellent communication skills and ability to work collaboratively. The current data is being updated manually, so a part of this project ...

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 need a Full Stack Developer comfortable with React, Sass, .NetCore, and SQL Server to work on my website, web application, and mobile/desktop app. The primary goal of this project is to develop a responsive, high quality website that also functions as a web application, with the potential for further expansion into mobile and desktop applications. We are looking forward to have a complete Computerized Maintenance Management System (CMMS) / Maintenance Work Order(MWO). A Complete Control Pannel on Web based asapplication along with the Mobile APP + Desktop APP. With the below added features.:- + It will have Website Fully responsive, Mobile APP, Control Pannel Application + It must fully SAAS Based means related to the SAAS Based all the screen to be designed and implemented +...

I have a plain PHP script where users can select teams, but I haven't imported the players yet. I already have SQL queries for this, so they need to be imported and linked to their respective teams. When a user selects League 1 and, for example, Team Feyenoord, they should automatically get access to the players from that league. A league can only start if there is at least one real user active in that league. There are 10 leagues in my database. Nothing should happen if there is no active user linked to a league/team. Now, here's the exciting part. Every match should be generated at 00:00 with certain random variables. So, for example, if a player is in League 1, I want all matches in that league to be generated. I've created an example of how I want to visually pr...

I've devised a dummy website primary for understanding log analysis which is a major concern in today's advanced technology world. To test its vulnerabilities, I require a well-rounded professional equipped with proficiency in PHP and Node.js. - Focus Area: Your tasks will encompass SQL injection techniques over my website's user login systems, data retrieving systems, and contact forms. - Skill Set: An experience with SQL injection tests is crucial. Knowledge of web technologies such as PHP and Node.js is essential. Understanding of website log analysis will also be advantageous. Your comprehensive reports on the performed tests and findings will enhance the robustness of my website and will aid in my understanding of the log analysis for future developmen...

I'm looking for an experienced SQL Developer with a strong background in MS SQL and data warehousing. You'll be responsible for designing and optimizing a new database system. The project involves working with Microsoft SQL Server Analysis Services in an Azure SQL environment. Key Responsibilities: - Designing a new database system - Optimizing queries for better performance - Utilizing Microsoft SQL Server Analysis Services - Ideal Candidate: - Strong experience in database design and optimization - Proficiency in SQL, specifically with Microsoft SQL Server - Familiarity with data warehousing concepts - Experience with Microsoft SQL Server Analysis Services - Experience working in an Azure SQL environment - Exper...

Looking for a talented Full-Stack Dev Team, ready to take College Recruit Pro to the next level. Our needs are vast, as such, expertise in AWS, SQL, React, Django, Flutter and other relevant technologies is strongly desired. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Introduction: Join us at College Recruit Pro as we aim to revolutionize the collegiate athlete recruitment process. We seek an experienced Full-Stack Development Team to finalize critical functionalities and prepare for future mobile app development. This remote contract opportunity may lead to a full-time hire based on performance. Project Overview: College Recruit Pro is in a soft deployme...

I am in need of an interactive Python dashboard to help me track the performance of multiple departments. The dashboard will be focused on week-over-week performance data, sourced from a data file to build it out then linked to BQ via SQL Code. I'm primarily interested in tracking the following metrics: - Case Per Hour week over week for various departments, and types of CPH. - Volumes and hours used per job process The ideal freelancer for this project should be proficient in Python and have experience in creating engaging and informative dashboards. Experience in data visualization and the ability to source and manipulate data will be important to ensure the dashboard is intuitive and accurate. Please note that the data is to be pulled from a data file, and I would like t...