Sql query sql query jobs

In this project, I am aiming to have a freelancer bring my vision to life by querying text data using an API, focusing particularly on search keywords. The returned data should then be cleanly displayed as single entries on separate pages: • The targeted data type - I am looking for someone who can work with text data specifically. Experience working with text API queries would be beneficial. • Displaying data - The ideal candidate for the job would have experience in and a strong understanding of displaying queried data as single entries on individual pages. This is crucial for the project's success. • Text parameters - An in-depth understanding of search keywords is needed, as this will be the main focus of our API queries. Experience working with keyword-focused que...

I have created a Wordpress site and I need you to upload and run my backup file with .sql to ftp. But the content that is on the site needs to stay and just add this extra backup folder to it and make it display just fine.

Project Description: Solve Website Database Connection Error The following errors occurred: SQLSTATE[HY000] [1045] Access denied for user 'root'@'' (using password: NO) (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from where table_schema = 'botble_cms' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

Fix problem with /tmp in whm "“MySQL” database “mysql”: 1021 (Disk full (/tmp/#);"

I am seeking a proficient Microsoft Power Query specialist to extract data from selected integrity sources for data-driven decision-making purposes. Despite the lack of stated specific data sources, the professional should be able to utilize a broad range of sources including but not limited to: - Excel Spreadsheets - CSV files - Database tables I did not provide a specific criteria for freelancer applications, which suggests an openness to various professional backgrounds and proposals. However, any of the following inclusions in your application could substantially strengthen your bid: - Past work demonstrating your proficiency with Power Query and data extraction skills - Experience you've gained that's relevant to Power Query and data extraction - A d...

I'm seeking skilled developers for creation of an interactive, blog-oriented website. The main objective is fostering a community of engaged rea...approved/denied by admin) * Admin Account Management – to moderate content and maintain the blog’s integrity. * Interaction Forum – to foster a community of knowledgeable and engaged readers. *Database to retrieve the blogs from and store account information Competence in website development and a keen eye for user-friendly design is necessary. A strong understanding of blog management systems, SQL, Laravel or other relevant programming languages would be of great benefit. Previous experience in constructing dynamic blog platforms would be highly regarded. Please provide examples of previous work that highlights ...

For my ongoing SQL projects, I require assistance on a monthly basis. Primarily, the role entails focusing on aspects of database administration. Key tasks that need attention include: - Overseeing optimal backup and recovery processes - Ensuring ongoing performance monitoring - Maintaining the security management of the database The ideal freelancer for this role should have substantial experience in SQL database administration, with a particular emphasis on the areas specified above. Demonstrable skills in managing database security, monitoring database performance and conducting effective database recovery are essential.

I need to create an automated system that efficiently processes Sales Order data. This system should be capable of retrieving PDF files fr...minor variations in layout or design. 3. Data Structuring and Transformation: Transform the extracted data into a structured format that aligns with our MySQL database schema. This process should include data validation to ensure accuracy and integrity. 4. Database Management: Develop the functionality to connect to a MySQL database and insert the structured data. This includes writing efficient SQL queries and handling potential database errors or exceptions. 5. Logging and Error Handling: Implement comprehensive logging for tracking the system's performance and error handling mechanisms to manage and resolve issues proactively. Deliv...

...and experience required: - Expertise in Ruby on Rails, specifically Rails 6 and 7 - Experience maintaining and upgrading RESTful APIs and API integrations - Proficiency in RSpec for testing - Strong SQL skills for database maintenance Responsibilities: - Perform regular maintenance and updates on the Ruby on Rails project as needed - Address any bugs or issues that arise - Upgrade and improve existing features and functionalities Ideal candidate: - Has experience working with Rails 6 and 7 - Familiarity with RESTful APIs and API integrations - Proficient in RSpec for testing - Strong SQL skills for database maintenance - Detail-oriented and able to troubleshoot and debug effectively This is an ongoing project with maintenance and updates required on an as-needed b...

As someone seeking assistance with my Oracle SQL project, my need is precise and task-oriented. I'm grappling with some update operations on tables and would benefit from expert guidance. - Task: The primary help that I need is updating a table. It's not just about changing existing data, but the process is conditional. The condition is slightly more complex than just concerning one column value. It revolves around multiple column values. - Expertise: A suitable candidate would ideally have experience in managing data migration, query optimization, and database design. The task involves sophisticated data handling, so someone with substantial Oracle SQL experience will be an asset. Proficiency in understanding and writing conditional SQL queries i...

I'm looking for an experienced Azure Data Engineer who can assist in continuously syncing data from an On-premises SQL Server to Azure SQL Database. The specifics of the data that need to be synced are Tables, Stored Procedures, and Views. Ideally, the freelancer should possess the following: - Proficient in Azure SQL VM operations. - Experience with data migration from on-premises SQL Server to Azure SQL Database. - Understanding of syncing Tables, Stored Procedures, and Views. - Capable of setting up an hourly sync schedule. The end goal is to keep the Azure SQL Database updated hourly to reflect the changes made in the on-premises SQL Server. Ensure seamless, error-free data transfer and verify the integrity of synced data regula...

Project Title: Snowflake, DBT, Dataiku project Support - Urgent I am in need of a data engineer freelancer who can provide urgent support for the project. The ideal candidate should have ex...source and target as snowflake warehouse. - Integration of Dataiku with existing systems and databases. - Experience with data ingestion. - create jobs in octopus, tidal Skills and Experience: - Proven experience in implementing Snowflake, DBT and Dataiku - Strong knowledge of Dataiku features and functionalities - Familiarity with data integration and data management best practices - Proficiency in SQL, Python, and other relevant programming languages - Excellent problem-solving skills and ability to troubleshoot issues Timeline: - This project requires urgent support and requires few month...

"I am looking for a skilled developer with experience in .NET core SDK for the development of a REST API. The API should be capable of connecting with databases, selecting data based on various query filters. The work also involves deploying the API on Azure Kubernetes. Key requirements: - Fluency in .NET core SDK for API development. - Proficiency in working with databases. - Experience in deploying applications on Azure Kubernetes. - Handling content data through the API is essential. - The API should support real-time data updates. Your past experience working with Azure and real-time data handling APIs will be a significant plus."

Develop REST api on .NET core sdk , which connects with database and select data based on query filters . Deploy API ON AZURE KUBERNETES

...discussed. Features: - Live Bidding functionality is the most important feature that needs to be included on the website. Ideal Skills and Experience: - Experience in working with APIs, specifically the Copart and Iaai APIs, is required. - Strong web development skills and the ability to create a user-friendly and intuitive interface. - Knowledge of user registration/login functionality using SQL or local MongoDB and search/filter options. -User to submit ID for verification. - User most make a minimum Deposit of $400 to get bidding power of $4000 or more to enabling placing bet either proxy bet or live auctions -User place bet on our site and it goes directly to Copart or Iaai through our premium account. -User can see the final price calculator to see services fees a...

I'm in need of a talented developer with proficiency in PHP, MySQL, and JQuery to I need someone to integrate with the mySQL query below to capture the values. Integration should be as an include to a PHP file. The integration also needs to update the values in the pie-chart when the date is changes by the $dateRange. This date is changed from a drop down in the PHP file and ueses the the Jquery below. Attached is the php file where the integration will be as an include file. The Query $dbDemographicsQuery = "SELECT Race, COUNT(Race) AS totalRace, Ethnicity FROM Greeter_Detail WHERE $dateRange GROUP BY Race"; JQ used to update dates: $('#month, #year').on('change', function() { var url = ; url += '?month=' + $('#month'...

I am looking for an experienced Power BI consultant who is well-versed with the ETL process, Synapse, Fabric, DWH, and more. - Data source: As a part of the project, you will be needed to work on the local SQL database, which acts as my current data source. Familiarity with SQL databases is a must. - Data extraction and transformation: The project requires the extraction and transformation of data In conclusion, candidates with a strong understanding of SQL databases, data extraction/ transformation processes, azure, microsoft service awill be the best fit for this role.

Add Logic to C# Wpf Software. - Controllers : Add Json Support (Add / Update / Remove) - Projects List: Add Button to create Dummy Project - Projects List: On Select Row or click "View Button", loads all listings connected to this project - Projects List: On "Delete Button", it will delete the project, all the listings and folders connected to it. - Listing List: Change "Creat...Select Row or click "View Button" loads all the folders connected to the listing - Listing List: On click "Delete Button", deletes this listing and all folders connected to it. - Folders List: Add create button to open "Screen_2" - Screen_2: On close it will save the real data of all fields - Folders Lsiting: On click "Delete Button" removes folders ...

Python Development - Building a Web Application with Django Skills and Experience Required: - Expertise in Django framework - Strong proficiency in Python programming - Experience working with existing Python code - Familiarity with web application development and best practices - Knowledge of front-end technologies such as HTML, CSS, and JavaScript - Understanding of database systems and SQL - Ability to collaborate with a team and communicate effectively Project Scope: - The goal of this project is to build a web application using Django framework. - The project involves working with existing Python code to enhance and add new features to the application. - The ideal candidate should have experience in developing scalable and secure web applications. - Knowledge of front-end dev...

I am looking for someone to create a POC for a chatbot with Microsoft Bot Framework and C# Main objective. 1. It should connect to a SQL server database and get the order details if the customer asks "Get my order detail" and give the order number 2. Login the customer and identity the correct order, Don't pull anyone else order if not belongs to the customer The POC may extend to an actual project

...functioning on existing projects that are built on these technologies, hence having prior hands-on experience would be highly valuable. Regarding the database, you'll need to be skilled in the use of SQL Server since the projects involve maintaining databases that are based on this platform. On the functionality front, the critical aspect is development. Therefore, you will play a prominent role in strategizing, building and maintaining the overall structure of the projects. Skills and Experience Required: - Practical experience in ASP.net Core, ASP.net MVC, and ASP.net WebForms - Profound knowledge in SQL Server database management - Demonstrated experience in end-to-end project development and management. To conclude, if you are well-equipped with these ski...

We are looking for assistance completing a query comparing in stock and on order raw material and match to it's production demand. SQL 2019

Please Sign Up or Login to see details.

I'm looking for a freelancer with extensive Node.JS experience to convert a Java-based des...experience to convert a Java-based desktop application into a web app. Key functionalities of the current app include data entry and storage, file management, and reporting/analytics. - Features to Maintain: The web app must retain database integration functionality, besides that the freelancer will also be required for code review and modification. - Database: Our current desktop application uses SQL Lite. The freelancer must have experience working with this database for a seamless transition. This project requires thorough knowledge of Java and Node.JS, database management, and file handling in a web app environment. Additionally, proficiency in executing code review and refactor...

Web development: The system should be web-based (ASP.Net) with SQL database, allowing users to access and interact with it through a web browser with responsive design. The application should be working perfectly in mobiles (both small and big screens), tablets, all sizes laptops and TVs from 32 inch to 84 inch screens. - Photo uploads: Users should be able to upload photos to the system, which will be displayed alongside their family information. Uploading is available for all but will not be effected until final approval - Relationship mapping: The system should have the capability to map and display relationships between family members. - Advance search options using all fields. - Send messages / WhatsApp / emails - Member card : when clicking on member image on the tree, a car...

I'm in need of a C program that will diligently navigate through a folder and all its subfolders to identify and extract given search text from files. The core specifics of the project are as follows: - File Type: The software should be capable to run its search and extract function exclusively on text files formats ( .txt , .sql,.xml ... ) . No need for other formats like Word, PDF etc. - Case Sensitivity: The application must consider "No" case sensitivity while executing text searches. For instance, "Hello" and "hello" should be treated as same. - Output: I am interested in seeing the exact instances of the found text & summary. The output needs to directly display the exact instances where the search text is found. Ideal freelancers for t...

I am seeking an experienced desktop application developer to build a platform that scrutinizes and audits financial data. Key functionalities include: - Analyzing financial data - tax compliance check , gst income tax Find below the ideal skills and experience: - Expertise in rule based software development - Str...understanding of data analysis and accounting - tally integration knowledge - tally tdl knowledge - Api access to gst / income tax portal needed Please note that there is no deadline for project completion, but a high-quality end product is paramount. Your commitment to maintain open and regular communication throughout the process is appreciated. Also I have already developed software in power query you need to understand code from here and convert into commercia...

The application is developed using Visual Studio with Blazor (C#) and utilizes a SQL Server database. The server infrastructure is already set up on AWS. Now, I am looking for an experienced professional to host my application on the AWS server and take care of all the necessary configurations. This includes setting up IIS, publishing the application, configuring the domain with SSL, and handling other related tasks.

I am looking for an expert with Power BI who is adept at connecting to SQL server databases. The requirement is to clearly compile the user data from these servers into a simple, singular table that reflects an view of all identified sources. What the job entails: - Connect to multiple SQL Server databases - Aggregate the users data into one simple table, it should entail server name, database name, user, role, and user type. Skills and Experience: - Comprehensive experience with SQL Server databases - Proficient in the use of Power BI - Familiarity in compiling data into user-friendly tables - Strong data aggregation skills - Attention to detail, particularly with columns and user information.

...users of our application should have the ability to ask general questions (e.g., when was the first moon landing), which will ultimately be answered by chatGPT. On the other hand, application-specific questions that require access to our MSSQL database should also be answered. The database has over a million entries. Therefore, the copilot should be able to convert textual questions into SQL queries, send the query, and present the answer from the database in textual form for the user. An example question for this would be: What is the dataset with the biggest total amount? As a third requirement for the Copilot, it should also be able to answer questions by extracting information from provided text documents. The copilot should be able to understand inputs in German lan...

In this project, I need assistance converting my Access based forms and reports to ASP.net. Below are the specifics regarding what's required: - Retaining the below functionalities from the existing Access forms/reports: 1. Data entry forms 2. Data validation rules 3. Query-based reports - I would like the following design aspects to be considered for the ASP.net forms and reports: 1. Simple and intuitive layout 2. Responsive and mobile-friendly design - For the technology stack, I require ASP.NET Core to be used. In terms of skills and experience, it's essential you have proven experience with Access and ASP.Net, particularly in the conversion of forms and reports. Proficiency with creating a simple, intuitive and responsive layout is k...

As part of my team, I'm looking to onboard a proficient competitive programmer with expertise in C++ and Java. The selected individual will participate actively in bi-weekly coding rounds, solving problems across a diverse range of topics: - Data Structures and Algorithms - Database related and SQL query problems - Graph theory problems Ideal candidates should have demonstrated experience in these subjects, and a proven track record in coding competitions would be beneficial. Strong command over C++ and Java is mandatory for this role. It's supremely important to have solid problem-solving skills and the ability to work under time constraints. If you can thrive in a competition scenario, I'm eager to bring you on board.

I've uploaded some basic data. It has 2 columns. Column 1 is a Publication Index and column 2 is an authors name. I need a T-SQL query that will create a pivot table that will put the authors names into columns and the PMID's into rows. The xls sheet has the data and the output that I need. I'm posting the question here because I need a faster answer than posting on StackOverFlow. The data will have over 8,000 rows of data and the columns or names will be over 100. My current T-SQL is SELECT TOP (100) PERCENT PMID, AuthoringName FROM dbo.[] GROUP BY PMID, AuthoringName ORDER BY PMID, AuthoringName I'm using MS SQL 2019

...szerkesztésével lehet további egyéni lekérdezésekkel bővíteni a válsztható sablonokat. Ezen lekérdezések megírásához keresünk SQL-ben jártas szakértőt, aki segítene közösen elkészíteni további sablonokat, pl. Teams-es konzultáció keretein belül. Magyar nyelvű kommunikációt preferálunk az egyszerűség és a félreértések elkerülése kedvéért. "You can also modify or add new queries to Data Chart Dashboard components by creating the appropriate SQL Server Script. This can give you more flexibility to control the data th...

Project Description: I am looking for a freelancer who can help me copy my SQL Database using the Azure SDK. The ideal candidate should have experience with Azure and be proficient in using the Azure SDK. Requirements: - Copy SQL Database using Azure SDK - No data migration across different Azure subscriptions required Skills and Experience: - Proficient in using Azure SDK - Experience with SQL Database - Familiarity with Azure - Proficient in TDD must write test code along with it

Adding manual entry form and synchronize with the power query table.

I am looking for a skilled freelancer who can help me replicate data from our CRM system in Dataverse to Azure SQL in near real time. Here are the specific requirements for the project: Source of the Data: - The data in our Dataverse comes from our CRM system. Data Replication Method: - We prefer to use transactional replication for the data replication process. Data Update Frequency: - We need the data to be updated in Azure SQL in real-time. Required Skills and Experience: - Strong experience with CRM systems and data replication processes. - Proficiency in setting up and configuring transactional replication. - Knowledge of Azure SQL and the ability to seamlessly integrate it with Dataverse. - Experience in working with real-time data updates and ensuring data i...

...Studio 2019) OF THE SCREEN DESIGN. The project consists of programming a desktop screen in C# and WPF code from Visual Studio 2019 .NET 6 framework for Windows 10/11 and tables in SQL design fully compatible with SQL Server management studio v 18.7.1. The WPF screen need some minor changes of titles, buttons and position of text boxes. I am going to deliver instructions, changes on design and general details in PowerPoint. Also, images of the SQL tables with their columns fields and descriptions will be sent in the PowerPoint. The deliverable must include the following: 1.- C# and WPF source code 2.- The SQL tables used in the program have to be generated automatically when running the executable for the first time. We need to test source codes working 1...

Please accept the mvc part and MSSQL database

The following is a list of code written in DAX and needs to be converted into Power Query. The problem: we are trying to use DataMart and build report in powerBi service. To create calculated column, we can only use PowerQury or SQL in the DataMart transformation section. The following code was written in PowerBI desktop using DAX. I need someone who knows very well PowerQuery (M), who can quickly convert the following code from DAX to PowerQuey and be able to copy and paste in PowerBI Service DataMart transformation section my using custom column in Query section of the DataMart. To get paid, the code must work without any problem. Anything between ‘ ’ is the table name, and anything between is the field name. If you are an expert in PowerQuery ...

I am looking for a skilled professional to help us with our database backup project. Our sql database is hosted on a physical server in our office, and we need to make backups on specific dates: 1/19, 3/1, and 5/31. Key requirements and ideal skills for this project include: Database Size: - The database is medium-sized, ranging from 1-10 GB. Preferred Backup Method: - We would like to use an external hard drive for the backup. Server Access: - We have physical access to the server. If you have experience with database backups, specifically with medium-sized databases and using external hard drives, we would love to hear from you. Please provide examples of similar projects you have worked on in the past.

We have a working ex...different server. Requires knowledge of Azure SQL, Azure Permissions and PowerShell. All that should be required is to adjust the permissions so it works between instances and change the script for us for the new server. Ongoing part time contract work available for assistance in maintaining our Azure virtual private cloud if this first quick task is completed successfully and you have the additional skills required. Key responsibilities include adjusting permissions within Azure to facilitate seamless communication between instances and modifying the existing PowerShell script to ensure efficient replication on the new server. The successful candidate will be adept at navigating Azure environments, possessing a deep understanding of Azure SQL and Powe...

I'm in need of an experienced GLPI developer who can create a plugin specifically targeted at improving workflow automation. Important features for the plugin: - Automated ticket creation: this should be efficient and without lapses. - Task assignment: the plugin should be capable of assigning tasks a...without lapses. - Task assignment: the plugin should be capable of assigning tasks automatically. - Status updates: regular and automatic updates on the status of tickets and tasks. The ideal freelancer should have solid experience creating plugins for GLPI, a strong understanding of workflow automation, and the ability to translate these requirements into practical solutions. Proficiency in PHP, SQL, and JavaScript is highly desired. Demonstrated experience with similar proj...

I am looking for an experienced ansible developer who can support Windows, Linux, and ESXi hosts. The project involves implementing ansible for these operating systems, but the complexity of the implementation is not yet determined. The timeline for the project is more than 1 month. Ideal skills and experience: - Strong knowledge and experience with ansible,oracle,sql - Proficiency in working with Windows, Linux, and ESXi hosts - Ability to handle both simple and complex implementations - Excellent problem-solving skills - Good communication and collaboration skills If you have the expertise and experience in ansible development for Windows, Linux, and ESXi hosts, and can handle a project with an undetermined complexity within a timeline of more than 1 month, please reach out to d...

1. Generate Dublin(or dynamic given location) routes used by passengers using min 2 public transport hops(best route). For example :- using 2 bus stops, 2 Luas stop, Dart Stop or combination of all these. Example :- Source A -> B -> C -> D. A=Starting Point, D= Final Destination. Need t...passengers use in Dublin since 1 year. - Generate destination locations where people walk more than 10 mins to reach workplace using public transport(bus/train/tram etc) since 1 year within Dublin(or dynamic given location) - Generate which Dublin(or dynamic given location) routes are max distance travelled by pedestrians(no public transport) on foot since 1 year. ** All reports should have query string over googlemaps or weblink to generate report in csv/xls format with given locatio...

I am looking for an experienced freelancer to resolve a 500 error on my aws Plesk server. The error is caused by a SQL connection issue, resulting in too many connections. Project Details: - This project is for an existing business. - The resolution of this issue is of immediate urgency, and I need it resolved within 24 hours. - My budget for this project is $10. Skills and Experience: - Proficient in AWS and Plesk server management. - Strong knowledge of SQL and troubleshooting SQL connection issues. - Ability to quickly identify and resolve server errors. - Excellent communication skills to ensure timely updates and resolution. If you have the necessary skills and experience, please provide your proposal for resolving this issue. Thank you.

We want to use an own GPT-model for first level support. What we provide: - virtual server (you tell us about the requirements) - SQL-database with >10.000 support tickets (customer email and our answer) for additional training - FAQ for additional training What you should do: - install a GPT, e.g. LLaMA on our server - provide a script with which we can feed the GPT with our given databases to fine-tune it - provide an API with which we can connect to the GPT and chat What the result should be: - We receive an email from a customer - We send it to the GPT and ask for pre-qualification the department (is it spam, support request, billing issue, ...) - if it is a support case, GPT should provide an answer and/or a matching FAQ-article (based on the knowledge we provided for fi...

I need to develop pdf scrapping in django which cN connect to sql database for website

...are they used in data modeling? Materialized Views: What are materialized views in Incorta, and why are they important? How do you create and refresh materialized views? Data Integration: How does Incorta integrate with different data sources? Have you worked on connecting Incorta with non-relational data sources? SQL and Query Optimization: How comfortable are you with writing SQL queries in Incorta? What strategies would you use to optimize a slow-performing Incorta query? Security and Governance: How does Incorta handle data security and governance? Can you explain the role of access controls in Incorta? Real-Time Analytics: How does Incorta support real-time analytics, and why is it important for certain business scenarios? Have you worked on project...

Angular Developer with .Net Core and SQL Experience Needed I need monthly hiring on a daily 8-hour basis. Project Overview: - I am seeking an experienced Angular developer with knowledge in .Net and SQL to assist in the development of my application. - The specific functionalities required for the application include user registration and login, data visualization and reporting, as well as e-commerce functionality. - The application should have a modern and sleek look and feel, with clean and minimalist design elements. - The project timeline is flexible, as it depends on the complexity of the requirements and the availability of the developer.