Sql query help free lanceKazi

I'm in need of an expert server administrator with exte...Your role would be to assess the current setup, make necessary adjustments and ensure that the server is running optimally. - Troubleshooting: The primary issue I'm experiencing is a DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#' (Errcode: 2), query was: DESCRIBE `sessions`. Your expertise in diagnosing and resolving such issues will be crucial. Skills and Experience Required: - Proven experience in Plesk server administration, particularly in configuring and optimizing servers. - Strong troubleshooting abilities, particularly in resolving database query failures. - Ideally, experience in identifying and resolving security vulnerabilities and ...

This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Applicants with su...

...additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability for creating isolated environments for different entities - Paying $10 for the project. - All work done via AnyDesk, no SSH. Please feel free to reach out to clarify any requirements or suggest any additio...

I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.

WordPress API help needed. I have an API which is giving error.

Looking for someone to help with few quick things. - Help me fetch repo from one aws account and push into another. - copying s3 data from one aws account to another. I believe it is only 10 mins job if someone knows it.

As we are looking to expand our online operations, we are currently in need of an expert in Ecomm...we are currently in need of an expert in Ecommerce product management. You will be responsible for managing both physical and digital products on our website. Despite not having a clear vision of which digital goods might be sold yet, your adaptability in this domain would be highly valuable. Since all transactions will be done directly on our website, your experience in ensuring smooth, trouble-free purchase experiences is vital. Skills and experience: - Proven experience in Ecommerce product management - Familiarity with managing both physical and digital goods - Ability to strategize effectively for different types of products - Experience in ensuring seamless online purchasing ex...

I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of d...

...and professional feel, in line with the nature of our services. The website will have about seven pages: - Home Page - Services Page - Industries Page - About Us Page - Leadership Page - Contact Us Page I'm looking for freelancers who take initiative and can transform basic instructions into a polished product. I will provide the wording and a general overview of the web pages but expect you to help with selecting relevant images and icons. The website must be user-friendly and easy to navigate. Additionally, the freelancer will be expected to provide a minimum of 30 days of support services post-launch to ensure proper functionality and resolution of any website issues. If you're interested, please share some of your past work. The job will be awarded by the end o...

...should have a background in big data, business intelligence, and data visualization, and previous experience in dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate...

### Query: I'm looking to create a WebAR experience without incurring expensive monthly costs. Could you suggest some cost-effective solutions and the necessary requirements for implementation? ### Requirements: 1. **Open-source Libraries**: - ****: - Technology: JavaScript - Compatibility: WebXR, WebRTC - Cost: Free - **MindAR**: - Technology: JavaScript - Functionality: Marker-based AR - Cost: Free 2. **Frameworks**: - **A-Frame**: - Integration: - Cost: Free - Technology: Web-based framework 3. **Combination Solutions**: - ** with WebXR**: - Technology: JavaScript - Functionality: 3D graphics rendering, AR integration - Cost: Free ...

I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.

I'm in need of an experienced ebook writer to help me with a self-help project. The aim is to create a comprehensive, engaging, and relatable book for young adults. Key Project Details: - Subject: The book will fall under the self-help category. - Length: The ideal length for the ebook is between 50 to 100 pages. - Audience: The target audience for this book is young adults. Ideal Skillset: - Proven experience in self-help or motivational writing. - An understanding of the young adult demographic. - Ability to create engaging, relatable content. - Strong research skills to ensure the book is well-informed. - Excellent command of English and an engaging writing style. If you have a passion for writing and helping young people navigate life, I'd lov...

I'm in need of an experienced application developer who can build a robust database application. The application will need to provide th...application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this remains to be finalized. However, skills in handling different types of data - textual, numeric and multimedia - will be considered an advantage. Understanding of standard SQL language, knowledge with various database systems and strong problem-solving skills will be ideal for this project. Strong knowledge of frontend and backend development with user interface design skills will also greatly contribute to our collabo...

listen pal we spoke before i know all u designers are a$#$# to deal with i have started a 3d scanning business i provide scan you make storage box to fit area with bracket simple yeh? i will have ongoing work for the right virtual business partner im located in australia and have cornered an industry which i think would do well in this country, $1 aud = $1.50 USD if you dont like eating the cake straight away i mighht have the right position for you!

...feature into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I'm looking for a ...

I need an experienced Magento developer to help me set up my existing Magento 2.x site on a new server. - The job solely involves migrating the existing site to the new server. No customization or updates are needed. - I have access to both the source code and database of my Magento site, so you'll have everything you need for the migration. Please only bid if you have prior experience in Magento 2.x site migration. It's crucial that the migration is completed with zero downtime and no data loss.

Tafadhali Jisajili ama Ingia ili kuona maelezo.

Initial Scoping Task for ASAP help desk - 2 Hours

Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibility with...

in your Bid, clearly answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and...

I need a dev to translate a JS script to Python, bonus if you have Paypal integration experience Start bid with "node python"

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add the Con...

I'm seeking an AWS expert to help me with configuring and optimizing my AWS server. Key Responsibilities: - Evaluate my existing AWS setup and recommend improvements for performance, security, and cost-effectiveness - Assist in configuring EC2 instances, S3 storage, and RDS databases as needed - Ensure the server is scalable, reliable, and can handle future growth Ideal Skills and Experience: - Proven experience with AWS services, particularly EC2, S3, and RDS - Deep understanding of server optimization, security, and scalability - Excellent troubleshooting skills and an ability to work proactively to prevent issues - Familiarity with best practices for cost-effective AWS usage - Strong communication skills and the ability to explain complex technical concepts clearly Pleas...

I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.

...Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amount...

...and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with RESTful APIs - Strong problem-solving skills - Good understanding of website architecture and aesthetics - Ability to manage priorities and work in a fast-paced environment - Excellent communication skills This is a long-term project, so I'm looking for someone who is dedicated and can work well also in a...

...heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization - Ensuring high availability and reliability of the database - Providing recommendations f...

...Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...

We are in need of a skilled software contractor to provide a comprehensive 2-week review of our existing C# and PHP code. This project involves...recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in software development and code assessment. - Strong understanding of code efficiency, performance, and quality. - Previous work on developing completion scopes for software...

Tafadhali Jisajili ama Ingia ili kuona maelezo.

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

I'm looking for a professional who can help me set up a free SSL certificate on my Linux VPS. Here are some key details about the project: GOT FREE SSL FOR ONE YEAR AND CAN INSTALL ON VPS USING COMMAND LINE. - Operating System: My VPS is running on Linux. - Root Access: I have full root access to the VPS. - Web Server: The VPS is currently running on Apache. Key Responsibilities: - Install and configure a free SSL certificate on my VPS. - Ensure that the SSL is correctly integrated with the Apache server. - Test the SSL setup to guarantee that it works efficiently. Ideal Candidate: - Extensive experience with Linux VPS systems and root access. - Proven track record of setting up SSL certificates on Apache. - Strong understanding of SSL configuration and...

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the SQL dat...

...translator to adeptly translate a self-help book from English to Gujarati. The book is approximately 10,000 to 50,000 words long. Key responsibilities: - Accurately convert the nuances of the self-help genre in Gujarati. - Maintain the integrity and voice of the original text. - Deliver a high-quality translation free from grammatical mistakes. Ideal skills for the job: - Excellent written proficiency in English and Gujarati. - Knowledge and understanding of the self-help genre. - Proven experience in book translation. This project requires a balance of precision and creativity to achieve an engaging and faithful translation of the self-help book. Candidates should have a proven track record in Gujarati translation, particularly within the self-...

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page

Hi. On my shopify website the links tot the product page have gone missing. I need to urgently correct this. I also need to urgently set up another page titled events, and list two events on there like you would a product in the womenswear section. Can someone help with this today? I need it resolved by 5pm/Irish time. Thank you. Kind regards, Angela

We have built a customized website in core php and need another experienced developer to join the team to fix some bugs, We are looking for a very experienced php developer for our project, you must have at least 12-15 years of experience with a good reference . Must have experience in multi-user programming, must know how to do quality coding, fix sql injections Conditions: You must be a independent freelancer. and share with some of your customized applications that u have worked on.

I have a Wordpress website that I've optimized for mobile devices, but it's not displaying correctly on all devices. The text overlaps or is too small to read and the images do not resize or align properly. I've used responsive design for the website, but I'm facing difficulties with the final output. I need an expert to help me: - Ensure that the text is legible and doesn't overlap on any mobile device - Make sure that the images resize and align correctly across all devices The ideal freelancer for this project should have: - Proficient experience in Wordpress website design and development - Expertise in responsive design and mobile optimization - Strong communication skills to explain the process of fixing the issues and teach me how to maintain the ...

We need support with HUAWEI S5731-h48T switches. Specifically, starting from a reset switch, we need to understand: A brief, concise introduction on how the configuration works in general. How to enable SSH connection on all switch ports: 2.a. How to change the default port for SSH connection. How to enable the WEB interface on all available Ethernet ports. How to set ports to TAG mode, both via command line and WEB interface. How to set ports to UNTAG mode, both via command line and WEB interface. How to export and reload the configuration. DETAILS: The support operation must be performed via TEAMVIEWER connection to a laptop that is connected via SERIAL to the reset switch. At the end of the work, we need specific commands along with comments and best practices. Upon completio...

Hi, I am a political science student and I am considering conducting research regarding formal documents' verification services in different countries, focusing on notary and apostille signatures. I am looking for someone who recently went through the process of notarizing documents in the EU, who can answer some basic questions regarding the process. Thank you for contacting me!

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quick...the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine

I'm looking for four fitness experts - 2 males and 2 females, with diverse backgrounds (white and black) - to help me create short, low-intensity home workout videos. These videos will be targeted at individuals looking to lose weight. - Each video should be 1 minute or less in duration. - I need the experts to provide a variety of workouts focusing on different areas of the body. Ideal candidates should have a strong fitness background, experience in creating workout videos and a good understanding of weight loss and low-intensity workouts. A good on-screen presence is also important. The goal is to create engaging videos that are accessible to a wide range of users, with a focus on simplicity and efficacy.

I am looking for a mobile application developer who can help me build a mobile application that allows my customers to fund their betting accounts with the help of MobCash API. The application should be available on both iOS and Android platforms. Design and UI/UX: - Although I don't have a specific design in mind, I want the application to be user-friendly and intuitive. I am open to suggestions and ideas for the design and user interface. Additional Features and Functionalities: - Besides the MobCash API integration, I am not sure about any additional features or functionalities that I may require. I am open to suggestions and recommendations from the developer. Ideal Skills and Experience: - Experience in developing mobile applications for both iOS and Android pla...

I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. Ideal Skills: &bull...

I am seeking a Blender 3D artist to help me create a mid-poly level 3D model. I already created something, but I'm having some issues I need help with. Job details include: - Creating mid-poly 3D models using Blender Ideal freelancers will have experience: - In Blender 3D modeling and sculpting

I'm running a Node.js website where the last user's data is mi...promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Your prompt attention to this ...

... Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Ability in RESTful API development and OAuth security practices. - Excellent problem-solving skills and ability to work effectively in a team environment. Education and Experience: - Bachelor’s or Master’s degree in Computer Science, Software Engineering, or related field. - At least 7 years of full-stack development experience, with a focus on complex cloud-based solut...

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ...features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations shoul...