Sql xml insert database jobs
I'm looking for a seasoned SQL developer with an extensive background and demonstrated expertise in MySQL. My project involves pinpoint optimization of specific tables in my database system. Ideal candidates should: - Have a mastery of query optimization techniques in MySQL - Have a keen eye for identifying inefficiencies within tables - Be able to implement successful solutions to enhance performance Individuals with extensive experience in analyzing and improving the performance of specific MySQL tables will be more suited for this task. This is not a general optimization assignment; hence, a careful, detail-oriented approach is paramount.
I need a demo on how to connect, access TimescaleDB (PostgreSQL) using latest .NET Core and C#; * insert, update and delete The demo should insert TEXT data into a TimescaleDB instance and also retrieve the same data DEMONSTRATION multiple and typical queries. SQL or something of the sort to create the tables in the table shall be provided, as should anything that I will need to successfully build and run the demo on my Windows 11 64-bit computer. Finally, examples for the above using pgAdmin4 shall be supplied. Tools: Visual Studio 2022 Latest PostgreSQL and TimescaleDB (with tools) Any additional tools/lbraries shall be discussed and approved before acceptance.
Hi, I want someone to write a quick SQL query to extract from our dataset
I need an expert to install the SAP B1 SQL Server for the primary purpose of streamlining my purchasing processes. I also require assistance in purchasing professional user licenses. Essential tasks for this project include: - The seamless transition of 6,000 stocks, 30+ suppliers, and 30+ customers from Excel spreadsheets to the SAP platform without data loss. - Training on how to use the new system, specifically focusing on utilizing the SQL server effectively. Although I skipped the question about specific reporting features, I would like the freelancer to provide suggestions on what features could be beneficial for my business, both in terms of inventory management and supplier/customer management. Ideal Skills: - Experience with SAP B1 SQL server installation a...
Hello We are looking for hotel database having following Name of the hotel/ cottages/ Resort Category 2 star/ 3 star etc Location Reviews Hotel contact no Hotel email I'd I need all verified and in Excel sheet
I'm currently experiencing some difficulties with my React Native Expo SQLite, namely it is not importing the tables f...precreated file and its not creating/updating another table entries with the information it needs to. , thus I'm open to suggestions, strategies, or proven methods. Additionally, both the insert and update functions require optimization. IDEAL CANDIDATE: Would be a seasoned React Native developer with an in-depth understanding of Expo SQLite. A background in database structuring could prove instrumental with the current project challenges. Understanding of complex query execution is a must. KEY TASKS: - Diagnose and resolve current SQLite issues - Advise on SQLite schema implementation - Optimize the Insert and Update functions it must...
We are evaluating the possibility of a project with artificial intelligence, for machine learning with judicial information collected in the Court of Justice, we want AI to analyze the best deals for lawyers and metrics of judicial decisions and sentences, the volume of data averages 50tb in SQL and NoSQL, before closing the job I want guarantees of operation, I need someone with experience and solutions, I don't need adventurers.
I am currently using WhatTicket with some modifications to suit my needs. Just thinking about scaling I have been having huge problems in relation to the PostgreSQL database which is very slow. I need to change my database to MongoDb so that I gain performance
I'm in need of a proficient Excel and SQL professional to assist with data analysis, manipulation, and cleaning. This project involves managing a medium-sized data set, typically between 1,000 and 10,000 rows. • Responsibilities: - Scrubbing or cleaning data - Identifying, comparing, and interpreting patterns in complex data sets - Transforming raw data into finished products The ideal candidate should have strong Excel and SQL skills, with past experience in data analysis and processing. Before the conclusion of this project, I require detailed reports for the data processed. Your ability to offer insights based on data trends would be a plus.
I'm seeking an experienced WooCommerce professional to manage the upload of products onto my online store. Requirements: - Product data format: No specific format provided, therefore your versatility with CSV, Excel, and XML formats will be highly beneficial. - Quantity of Products: An unspecified number of products needs to be uploaded. Your ability to handle high volumes efficiently will be advantageous. - Timeframe: An exact timeline has not been established, so your flexibility in terms of project completion will be highly appreciated. Key skills and experience: - Extensive experience with WooCommerce product uploads - Proficiency in handling multiple product data formats - Highly efficient and flexible regarding volume and timeframe
I'm seeking a proficient Qlik developer in Bangalore with expertise in data modeling and dashboard design. The purpose of this project is to optimize my data visualization capabilities. In this role, you'll be working with Microsoft SQL Server. I anticipate this project will: - Establish effective data models - Create engaging dashboard designs The ideal candidate should have an in-depth understanding of data visualization, be experienced in Microsoft SQL Server, and have excellent skills in data modeling and dashboard design. Your role will be instrumental in improving the way data is visualized, making it easier to interpret and analyze information.
I need help designing a database for sensor logging. and then setup the database at some cloud providers servers. After setup and design, I need performance testing done, so you also need to be able to make a simple script (etc. coded in C#, I will review and compile the code my self) bombarding the server with data, to simulate real life situations. please see attached documents for further details. Database EER file will be sent in PM later in the process.
I'm seeking a proficient Data Scientist specialized in e-commerce. Key responsibilities include: - Conducting comprehensive data analysis - Creating predictive models - Delivering effective data visualization The ideal candidate should be experienced in Python and SQL programming languages. A deep understanding and experience in the e-commerce industry is required to effectively interpret and analyze data trends. I look forward a data scientist who can use these skills to provide invaluable insights into my e-commerce business operations.
I have about 15 wordpress sites I need to find a webmaster that know Wordpress, SQL, Plesk to help me in microactivities like - Upgrade wordpress sites - Correct site problems - Speed up sites - Correct Seo links If have Joomla competence too, i have 20 Joomla sites more. This microactivity to quote is about a site that was in developer migrated from Joomla ( i have original site in .... site migrate to before become www. After became www. i discover that there are a loto of absolute links to so candidate have to know wordpress tables and with SQL substitute test. with www. I will appreciate low hourly price and availability to answer and complete work in few hours when discovered problems.....
This is a simple, small job. I have a MySQL database that runs a schedule. The schedule works from the recurrence column, with seven numbers (0 or 1). These numbers represent the days of the week (Monday to Sunday). 1s will trigger an event, 0s will not. For example, if the recurrence column has 1000000, the task will only trigger on a Monday. 1100100 will trigger on Mondays, Tuesdays and Fridays There are also fields for start date and end dates. I would like to view on a website what events in the schedule are coming up next. The events in the schedule also have a start and end date. I would also like to be able to add / edit information through the website. Uploaded SQL code. Example table Recurrence Startdate Enddate Descrption 1000000...
As the owner of the website, I'm seeking a proficient SEO specialist who can effectively increase my site's traffic, improve search engine ranki...visibility - Generating valuable Leads My target audience comprises both consumers and businesses. Therefore, a versatile approach that appeals to both sectors would be massively beneficial. The area of SEO that requires the most significant improvement on my website is Technical SEO. I'm looking for a professional with adept skills and comprehensive experience in: - Site-speed optimization - XML sitemap - Website architecture - Mobile optimization - SSL Certification - Error code handling If you have a track record of improving a website's technical SEO dramatically and can provide exceptional results, I'm ea...
Hello We are looking for hotel database having following Name of the hotel/ cottages/ Resort Category 2 star/ 3 star etc Location Reviews Hotel contact no Hotel email I'd I need all verified and in Excel sheet
We're in the process of enhancing our custom in-memory database system and require an experienced developer to implement and optimize indexing. Your task will involve creating indexes for improved data lookup efficiency on various columns, beyond the primary key. This role demands a deep understanding of indexing strategies and their impact on database performance. I will share you our existing system as well. Skills Required: Strong proficiency in database design and optimization Experience with indexing and query performance enhancement Knowledge in handling large datasets and memory management Proficiency in Python or relevant programming languages used in our project Familiarity with version control systems, preferably GitHub Your contribution will be crucia...
Hi there, I'm in need of a skilled .NET developer who can dedicate 2-3 hours each day to help with both front-end and database tasks. This is a long-term project and therefore, not being rushed. Ideal Skills: - Extensive experience with .NET - Strong front-end development capabilities - Database management experience There's no specific framework you need to be familiar with, I'm looking for someone who knows their way well around .NET. Your main duties will include: - Working on the user-interface - Managing and upgrading the existing database These tasks likely require daily attention, hence the need for 2-3 hours of consistent effort each day. I am flexible with time and can give remote access to my system for patch work. New development can be d...
...Familiarity or experience with Avalara Tax API would be beneficial. • Meticulous attention to detail. Unfortunately the previous freelancer was not well fit for this type of project and was not able to properly transmit the data from the POS to avalara as he did not have the proper understanding of POS systems and invoicing. There are multiple ways of approaching this project as I have access to the SQL database, and the API endpoints along with the API documentation....
...mission to optimize a XML file, with make more beautiful, with a focus on refining readability for my andriod application. The ideal candidate for this task possesses intricate knowledge of XML files and best practices for organizing and formatting them. Here's what I'm looking forward to: Note: Current look attached. - Beautifying Indentation: Your job will be to go through the XML file and ensure indentation is consistent throughout. - Consistent Formatting: Maintaining uniformity in formatting across the file is essential, this adds to the aesthetic appeal and improves the overall readability. A keen eye for detail, experience in XML file optimization and being well-versed in XML best practices are properties of the ideal candidate. B...
...be able to RSVP. - Chat: Those who use the app should be able to exchange messages with one another. - Toolbox and Rent: More specific details will follow regarding the functionalities these sections should possess. - Push Notifications and Ads: Incorporate support for push notifications and advertisements. - SQL Integration: The application should integrate with our SQL database for smooth data exchange. Ideal Expertise: - Experience developing iOS and Android apps. - Knowledge of SQL and how to integrate it into mobile applications. - Experience building a web interface that syncs with a mobile application. - Graphic design experience for logo and splash screen implementation. - App developers with a background in ad integration and capability to enable ...
Please see the attached screenshot. I have a stack of sortable <div>s which are pulled from a MySQL database. They are ordered from 1, 2, 3 onwards based on the ID number in the database. I would like to make it so that when you drag and drop the <div>, it updates the MySQL database with the new orders of the <div>s. This is basically a quick jQuery function with Ajax. Opportunities for further projects if well suited.
As a detailed and organized individual, I want a comprehensive database of all the chambers of commerce in the state of Illinois. The information should include: - The contact name of an individual - The title of the contact individual - Email address of the contact individual This information should be structured in spreadsheet format and further subdivided by city for easy identification and access. Ideal freelancers for this task would possess excellent research skills, be meticulous with data entry, and proficient in using spreadsheet designing tools. Experience in a similar database creation or research-based role would be highly beneficial and valued. Here is one resrouce to use but there's man more than listed here:
I need 1 professionel user for Sap Business and I can start use SAP. We have 6.000 types stock and we want transfer to SAP with excel
This is a basic project I need help to connect the Cloud Firestore database to save the item data when the button clicked and retrieve the saved data back
...am experiencing an unauthorized error in Power BI Pro. Specifically, a 401 error presents itself when trying to retrieve the Embed URL. The environment we use is a hybrid, suggesting that the problem could stem from multiple sources. Our current data sources are SQL Server and various cloud services. The ideal candidate for this assignment should: - Have excellent knowledge of Power BI Pro, its use in a hybrid environment and experience with troubleshooting authorization errors. - Possess strong technical insight into SQL Server and cloud services. - Provide a clear and concise resolution to the error, and possibly be prepared to respond to any related issues that could arise after the execution. Overall, the project's main objective is to rectify the 401 e...
I'm in need of a SQL expert to help import my CSV files into any SQL program. Once the files have been uploaded, the task will involve deleting all duplicated data. Since the format of the CSV files is unknown, the ability to work with different possible formats, such as comma-separated, tab-separated, or space-separated values, will be beneficial. After this process, the final data will be reviewed with Python for testing purposes. Ideal candidate for this job: - Has previous experience with SQL and file conversion - Understands data cleaning: particularly in removing duplicate entries - Possesses basic Python skills for testing purposes pls don't apply if you don't have previous experience in similar projects
...tags on the text in body tag and should not break the web site’s layout or function. (Don’t add Ruby tag on css or js functions or comments etc) 3. Update Ruby Tag. If I inject the ruby tags by No1, and I execute the same code with different data(word and meaning), if there is a ruby tag existed on the word, then just update the meaning in the ruby tag, if there is no ruby tag for a word, then insert a ruby tag for the word. 4. Disable Link I have a bool value by JsVariable.disableLink. If it is true, make LINK disable to stay in the web site(Eg clicking an image) 5. Modify value of css 6. Cancel appending Ruby Tag ———- I will set the milestone payment upon making a deal and will not make any payment in advance. I will release half of the miles...
...fields to assist us in handling our expansive course catalog. We offer a wide array of IT courses from Web and App Development, SEO, Digital Marketing, to Graphic Designing, AI, Machine Learning, Basic Computer literacy, Advanced Excel, and languages such as Java, Python, SQL, AWS, and more. Our goal extends beyond providing these courses. We're also involved in website and app development, digital marketing and graphic design services, implementation of AI and Machine Learning solutions, and development of Java, Python, SQL, AWS applications. Our target audience is broad, as our services cater to students, professionals, small to large businesses, individuals who seek personal development, across non-profit organizations, government organizations and everything in b...
Project Title: Laravel Project Site lost file Project Description: I am in need of a Laravel developer who can help...processes - Strong problem-solving skills - Attention to detail Requirements: - Recover the lost file for my Laravel project - Ensure compatibility with the current version of Laravel - Verify the integrity and functionality of the recovered file - Implement any necessary fixes or updates to the file Timeline and Deliverables: - Complete the recovery and restoration process within [insert timeline] - Provide a fully functional file for the Laravel project - Test and verify the functionality of the recovered file If you have experience in Laravel development and file recovery, and are available to start immediately, please submit your proposal.
...components: 1) Mobile App development (Android and iPhone packages): using Flutter language. 2) Backend development: using JavaScript or Python. The backend should be built as a microservice architecture to be able to handle thousands of requests per minute with ability to scale up and down and ability to have multiple databases read instance. For data storage we need your recommendation to use SQL or/and no-SQL data storage. 3) Web Console Development (Salon Console and Central Console): using HTML5/CSS/JavaScript (NodeJS) 4) Simple Website to present our service to the public: using HTML5/CSS/JavaScript (NodeJS) The design already made for all the components; PDF-exported Figma design is already shared here: :f:/g/personal/hmohammad_microbeaver_com/EsSZ
I need an expert C# and Powershell programmer to create a utility that transfers Terminal Server Session Logs to a MS SQL database. Data to be moved to SQL Server : - EventRecordID - Date and Time - Guid - User - EventID - Computer - SessionID / Target SessionID - Address - Source Session ID Event Ids RemoteDesktopService - SessionServices - Operational : 21, 23, 24, 25, 39 Last EventRecordID to be stored in Registry or anywhere else so next time fetch data greater then last stored EventRecordID SQL Server 3 Tables need to be updated 1. Rawlogs (above mentioned dump of Logs) 2. LoginandLogout (GUID, Date, User Name, Login Time, Logout Time, Logon Time, Computer, Address, Reason, Status (Approval Pending/Approved)) for each event 3. Total (Date, User...
...a second-hand item website to life, with a built-in SQL database. Key Features: - A secure login and authentication system based on email and password. The chosen developer should have experience in creating secure systems to prevent unauthorized access. - A second-hand item listing and viewing system. Every item listing should include details like price, a clear description, and the seller's information. As such, a skillful grasp on user interface and experience is crucial. - An intelligent search and filter system that includes keyword search and category filter features. Having prior experience in creating such search mechanisms would be a significant advantage. In summary, I need a freelancer who's adept in website development, SQL databases, has a ...
We are looking for an Informatica BDM developer with 7+ yrs of experience, who can support us for 8 hours in a day from Mon - Friday. Title : Informatica BDM Developer Experience : 5 + Yrs 100%Remote Contract : Long term Timings: 10:30 am - 07:30 pm IST Required Skills: Informatica Data Engineering, DIS and MAS • Databricks, Hadoop • Relational SQL and NoSQL databases, including some of the following: Azure Synapse/SQL DW and SQL Database, SQL Server and Oracle • Core cloud services from at least one of the major providers in the market (Azure, AWS, Google) • Agile Methodologies, such as SCRUM • Task tracking tools, such as TFS and JIRA
...with the specific tasks of bug fixing and feature implementation. Here’s what's expected: - Diagnose and troubleshoot bugs throughout the application - Implement new features as per given requirements - Optimize application for maximum speed and scalability - Collaborate with the team to ensure consistent project progression Ideal skills: - Proficient understanding of TypeScript, Node.js, MS SQL, preferably with knowledge in trading and understanding of some basic technical analysis will be added advantage. - Previous experience in bug fixing and feature implementation - Ability to determine causes of operating errors and deciding what to do about it - Strong problem solving and critical thinking skills - able to work via remote anydesk or ultraviewer for entire pro...
I'm in swift need of an adept freelancer who can build an extensive email database for customer outreach purposes. However, I missed specifying the industry during my initial input. Key Tasks to Accomplish: * Build an extensive, ready-to-use email database. * Ensure all the emails are active and working. * Be prompt in communication and updates. What I'm seeking: * Experience in data gathering and identification of potential customers for outreach. * Strong research skills and knowledge on how to parse data to come up with active, valid email addresses. * Ability to complete tasks at a rapid pace without sacrificing data accuracy. I need this robust, reliable email database ASAP. The perfect candidate possesses solid organizational skills, dedication to ...
Job Title: Talented Graphic Designer with Strong Editing Skills Needed for Seafood Product Catalogue Booklet Description: We are searching for a talented graphic designer with strong editing skills to develop a printed booklet that effectively showcases our range of seafood products. In addition to designing the layout an...Corporate Identity Covers & Packaging Brochure Design Editing Project ID: 37799776 If you possess the necessary skills and are passionate about creating stunning printed materials while also excelling in content editing, we encourage you to apply. Please include your portfolio showcasing relevant work, along with any examples demonstrating your editing capabilities. Deadline for Applications: [Insert Deadline] Contact Information: [Provide instructions on...
I'm seeking a skilled developer capable of connecting my regular website with a database. You will be primarily focusing on building a system to manage random information. There's no rush for the completion of the project, allowing time for all requirements to be fulfilled meticulously. Ideal capabilities include: - Experience in website to database integration - Knowledge about handling 'random information' - Patience and a strong eye for detail The deadline is flexible, giving you ample time to construct a quality system.
Come do some interesting GIS programing. *** Please no AI responses. *** Please respond by telling me what is a 3-4. **Requirements:** - Proficiency in spatial SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, with a portfolio of previous projects involving visual data exploration and user interaction. - Fluency in Python programmin...
I am looking for a professional who can provide JOB SEEKERS Database. First i need job seekers database from UK and then i will be needing from other countries as well. I need this info of job seekers 1. Name 2. Email 3. Mobile 4. Location 5. Age You can give me job seekers database from any website but it must be from UK only at first. This is on going on, so don't try to hit the prices to high.
I'm looking for a seasoned web developer who has strong experience in Classic ASP to assist me in setting up hosting and database connection for my site. Key Responsibilities: - Help set up the hosting for the Classic ASP site. - Enable database connection and ensure its performing optimally. What I Expect from you: - Proven experience of working with Classic ASP. - Keen attention to detail. - Strong understanding of database management and setup, including SQL. - Good problem-solving skills. - Exceptional communication skills. Note: No specific functionalities or pages need to be created or handled. The sole focus of this project is on setting up hosting and database connection. Please ensure to include a detailed proposal indicating your appro...
I have an issue on my WordPress website where with each page load, several queries are being sent to a page that does not exist. When you delete the nav menu, this issue goes away. However, when you create the menu again, the issue returns. I need help troubleshooting this, because we obviously need a nav menu - but the constant duplicate queries to a page that doesn't exist are hurting our performance.
...user-friendly login process is vital. - User profile management: This involves the creation, editing, and managing user profiles. Furthermore, an integral part of this project is to include features that handle billing and database assignment. There will be the need to implement a simple system that assigns a billing plan and a database to each company using the system. This code already exists in the current functioning ASP.Net project. Proficiency in both C# and Angular is required, alongside experience with Bootstrap 5.x, and a solid understanding of SQL Server database operations and Identity user management functionalities. The successful freelancer should have proven experience in handling similar conversion tasks and a portfolio showing completion ...
...project owner, I am facing issues with SQL Server connection in my windows server. Whenever I am trying to connect, it is showing error messages. The application's behavior leads me to believe that there is a problem with the database connection. Interestingly, I haven't tested if other applications or utilities can access this database. The application works well in development, and I can connect to a copy of the database as expected. This task will require: • Proficiency in SQL Server • Experience with windows server • Diagnostic skills relating to database connectivity issues • Ability to ensure that other applications can smoothly interact with the database The project will be considered successful whe...
...creative professional to help me enhance my currently active portfolio site: 1. Design Update: The candidate should bring their own ideas with them to update the design and layout. On-trend aesthetics and easy site navigation for users are two key factors for this part of the project. 2. Content Expansion: The site should include new projects. The freelancer will have to demonstrate their ability to insert these into a gallery or other well-organised design interface, maintaining the portfolio’s overall professional appeal. 3. Showcasing Work: The primary goal is to exhibit my work in the best light possible to attract more views. I need this project to be completed ASAP due to immediate requirements. Hence, the preferred freelancer should have experience in fast-paced,...
Project Title: Database Design (Models and DbContext) for Enterprise Inventory and Sales Management Project Overview: The project involves designing a robust .Net core models layer for an enterprise engaged in Inventory Management and Sales Management. The system should efficiently handle inventory tracking, stock management, sales operations, and related functionalities for multiple branches. Requirements: Inventory Management: a. Items are received at a central warehouse from multiple suppliers. b. Items are received in batches, with each batch having different pricing (cost price and MRP). c. Each batch can have multiple offers based on the quantity purchased by the customer. d. Maintain and calculate stock levels for each item per batch. e. Track the in and out transact...
