Sql database schema stored jobs
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...
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....
...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
I'm looking for a skilled freelancer to help me streamline a crucial part of my financial operations. I have multiple invoices stored in Excel files, which need to be accurately formatted into a pre-specified CSV file for ACH banking transactions. The CSV fields will include vendor name, invoice number, amount, routing information, vendor account details, and payment date. Key Requirements: - Proficiency in Excel and CSV data manipulation. - Experience with financial data and understanding of ACH transaction processes preferred. - Ability to design a semi-automated system with checkpoints for manual review to ensure accuracy. - The system must highlight errors in the data and provide a detailed report for necessary manual intervention. - Flexibility to handle Excel files and ...
...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
...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...
...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. Tota...
...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 ...
I need someone proficient at wordpress / css / etc to update an existing template to look like the attached image. you can see the existing template here: When the template is displayed on a wide screen it may show 3 columns, when it is displayed on mobile...update an existing template to look like the attached image. you can see the existing template here: When the template is displayed on a wide screen it may show 3 columns, when it is displayed on mobile it should show one column the template must be SEO optimized. we will scan it with SEO / schema validation tools to verify this.
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.
I need a professional to create backups for all my data from different devices including my laptop, desktop, and smartphone. The types of files to be backed up include documents and text files, media files like images, videos, audio, as well as system and application files. The backup will be stored in a cloud storage. Having any experience in handling various cloud storage providers will be ideal. Familiarity with different file types and knowledge about secure data backup practices is crucial. Key skills and experience required: - Backup and restore of data - Handling diverse devices and file types - Cloud storage management and security - Knowledge of system and application files After the first backup for all the systems is completed a weekly incremental backup needs to b...
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.
Job Title: Freelance ASP.NET Core Developer for Retail Enterprise Application We are seeking an experienced and skilled freelance ASP.NET Core developer to enhance and optimize the schema for our retail enterprise application. The project involves refining the existing schema and introducing new models to meet the evolving needs of our chain of retail stores with a central inventory system. **Business Requirements:** - Chain of retail stores with a central inventory system. - Items supplied by suppliers in batches. - Multiple batches for each item, each with different pricing details. - Items and batches allocated to different branches. - Multiple offers for each batch based on minimum quantity purchased. - Efficient tracking of in and out accounts of items between branche...
...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 ...
...interface for inputting a handful of fields. After submission, all data will need to go into a MySQL database table. The data in the database will be encrypted and can only be decoded using a decryption key provided in a link. The link will then be provided to view the submission, which the user can copy (to send to someone else). 2. One interface for viewing a submission. This interface will require the decryption key or else an error message will be displayed. This page must be really well formatted -- an example will be provided. 3. On the back-end, we also need some clean-up tasks: Data stored in MySQL must be purged based on expiration dates sent during a submission. Also, data stored in MySQL must be purged after it has been accessed X number of times...
...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...
We invite qualified freelancers to submit proposals to develop a mobile application for a research project. We need the freelancer to develop an application that allows us to track the daily locations of study participants through their smartphones and also to establish a secure database where the location data will be stored. The goal is to collect location data while ensuring privacy and data security. Project Scope: The freelancer is expected to develop a mobile application compatible with Android devices, capable of collecting location data. As Android recently updated the capability of tracking app users, the app should be designed such that the location of users is tracked every time they open the application. Given that the new rules require user actively opening the...
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...
Project Title: Database Design for Enterprise Inventory and Sales Management Project Overview: The project involves designing a robust SQL database system 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 transactions of item...
Hello, I need and Android developer that knows how to implement Arcgis Android SDK in order to display three locally stored .tpk files. The application must run on Android above version 12, including Android 14. Please bid only if you know how to use Arcgis SDK for Android and if you developed in the past this kind of projects.
I'm in need of an experienced database developer who is well-versed in MySQL. My current project entails: - Reviewing and possibly redesigning our existing database Schema to streamline and optimize our operations. - Implementing strong data encryption mechanisms to fully secure our data. - Setting up reliable backup and recovery options to prevent or reduce potential data losses. - Ensuring that our database is scalable and performance optimized as our user base grows. - Fully integrating the enhanced database with our website. The perfect candidate should have solid background in MySQL database development and schema design, experience with data encryption and setting up backup and recovery systems, proficiency in optimization for b...
I am seeking an experienced operative to swiftly enact a fix on a datatable with inline editing. This project is perfect for someone skilled in managing data tables json Ajax SQL and c#. Seeing as this project is short-term, the readiness to dive right into the issue is highly favored. Also this will be remote
...payment processing, and receipt generation. - **Customisation Capabilities:** The software should allow for easy adjustment to meet the specific needs of my retail environment, including adding or removing products, pricing adjustments, and promotions. - **Security Features:** Implement secure login mechanisms for staff with different access levels and ensure that all transaction data is securely stored and managed. - **Compatibility:** The software must be compatible with existing hardware or suggest the most cost-efficient hardware options suitable for a retail setting. - **Offline Functionality:** Ensure that the POS system is fully operational even during an internet outage, with the capacity to sync data once the connection is restored. The Software must accommodate multiple...
...sources of my interest are platforms like Spark, AWS, Azure, GCP, and Hive. I want to understand effective methods for data extraction from these particular sources. Ideal Skills and Experience: - Expertise in ETL tools for data extraction - Hands-on experience with Spark, AWS, Azure, GCP, Hive - Profound knowledge in data engineering - Experience in career coaching or mentoring will be a bonus - SQL -Python This assistance will give me a competitive edge in my upcoming interviews by providing me with practical skills, knowledge, and confidence in addressing ETL-related questions. So, a mentor with over 10 years of experience in data engineering, particularly in ETL processes and in touch with modern data extraction techniques, would be ideal....
I'm looking to have business data from my ERP system (Neo4J or opensource) extracted and uploaded into a Graph database. With this shift, my aim is to utilize graph applications to study my data in ways not achievable using ERP applications. The types of data to be extracted include: - Customer data - Transactional data - Product inventory data A successful candidate for this project would be proficient in both Neo4j and open-source graph databases, with demonstrated experience in data extraction from ERP systems. Strong knowledge of different business data types is also crucial, as the candidate will be dealing with customer data, transactional data and product inventory data.
I am in need of an expert Bug Hunter to assist me in identifying and addressing vulnerabilities in some web domain/online services for Key Areas for Exploration: - Cross-site scripting (XSS) - SQL injection - Remote code execution - OAuth redirection issues Ideal Experience and Skills: you MUST have experience and have gotten bounties in the past. I am looking for someone with ative experience. Level of Expertise: I'm specifically interested in freelancers with advanced expertise in bug hunting. I also want you to help me over zoom to achieve my first bug YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN BUG OVER ZOOM. YOU MUST HELP ME ACHIEVE MY OWN
I have recently uninstalled Mariadb 5.5 from my server however, my MySQL database file still exists and have the database in /var/lib/mysql/umedia. . I need that database recovered and sql dump created as soon as possible.
The Role: As a Back-End Developer, you will play a critical role in connecting our dynamic front-end applications with our robust SQL database. Working under the guidance of our Chief Engineer and CTO, you will ensure seamless data integration and functionality across our platforms, contributing to the provision of a stellar user experience. Responsibilities: - Develop and maintain the server-side logic to connect Flutter and React front-end applications with a SQL database. - Implement secure GraphQL API endpoints for efficient data retrieval and manipulation. - Collaborate with the front-end development team to integrate API services. - Optimize back-end processes for maximum speed and scalability. - Ensure data security and protection in line with best pract...
...Implement and optimize data models for efficient storage and retrieval in AWS Redshift. AWS Service Utilization: ● Leverage AWS services such as S3, Lambda, Glue, Redshift, and others to build end-to-end data solutions. ● Stay abreast of AWS developments and recommend the adoption of new services to enhance our data architecture. SQL Expertise: ● Craft complex SQL queries to support data analysis, reporting, and business intelligence requirements. ● Optimize SQL code for performance and efficiency, and troubleshoot any issues related to data retrieval. Performance Optimization: ● Optimize ETL workflows and data warehouse queries to ensure optimal performance. ● Identify and resolve bottlenecks in data processing and storage. Data Integration: ● Collaborate with c...
Hello. I need help to configure my web page. I purchased a script but I don't have the guide for configuring the databases.
I'm seeking an experienced AWS practitioner to execute server setup on my AWS account. Key tasks will include: - Setting up EC2 instances optimized for use with the Linux operating system. - Provisioning S3 storage. Note that the specific contents to be stored in the S3 buckets is yet to be determined, so flexibility and knowledge about different S3 use-cases will be appreciated. Ideal skills and experience for this job: - Strong understanding of AWS; specifically EC2 and S3 services. - Proficiency in operating a Linux-based server infrastructure on AWS. - Previous experience with flexible and comprehensive S3 setup. The successful freelancer must demonstrate ability to follow best practices for server setup and adhere to AWS security protocols.
I am seeking an experienced app developer to build a simple mobile app using MAUI. The primary function of the app should be to scan QR & BAR codes, with the data saved in SQL Lite. This information then needs to be able to be sent via API in bulk or on an individual basis. Key features: - Compatibility with Android platforms - Immediate display of scan results Freelancers who wish to make a bid should include examples of their past work, particularly those related to QR & BAR code scanning and SQL Lite. Familiarity with API integration is a plus. A solid understanding of MAUI and cross-platform mobile app development will also be highly valued.
I am looking for an expert in WordPress and WooCommerce to help restore and rectify issues with my website which include a slow loading speed and various errors. These problems started to occur after updating a number of plugins including WooCommerce. Ideally I would like the website re-stored to how it was before last night, then work through issues with the site. The woo-coomerce shopping cart was having issues before last night. It should send an email through to me with the items the customers has picked out. The website needs to be fully functional once complete: Ideal Skills: - WordPress - WooCommerce - Plugin Management - Speed Optimization * Tried using a cache pluggin which has made the website worse. The task involves: 1. Restoring the website to changes from a day bef...
