Sql database schema stored jobs
I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.
...implement functions to: Open or create the IndexedDB database. Add, update, and delete estimate data within the database. Retrieve estimate data from the database when the application loads or when needed. 6. Image Capture using MediaDevices API (iPhone): The developer will leverage the API to capture images from the device camera (focusing on iPhone users for this initial phase). Upon user interaction, the API will be used to request camera permission and capture an image. The captured image data (base64 encoded string) will be linked to the corresponding garden space object in the Pinia store. The image data will be stored locally within IndexedDB alongside the garden space information. Images should NOT be stored in the user's Photos ...
I'm seeking an expert professional to configure a music player controller to play stored voice using a button press. You should understand the nuances of basic sound quality to ensure the voice playback meets the expected low-definition audio requirement. - Ideal Experience: Candidate should have experience in programming music player controllers, specifically in the area of audio playback functionality. An understanding of audio quality levels is a plus.“ - Key Skill: Knowledge of how to trigger voice playback through button press. Understanding of basic quality sound output is crucial. The sound should not be high end but it should be clear and audible. Your task will be to implement this with efficiency and effectiveness in mind, considering the functionality of t...
I'm seeking a skilled .Net developer to assist in developing a comprehensive retail system that has features such as user authentication and authorization, inventory and product management. Requirements: - Proficiency in C#, .Net, Entity Framework and SQL Server - Ability to develop a retail project from scratch - Strong understanding of user authentication and authorization - Experience in inventory management and product cataloging It's crucial that the chosen freelancer has prior experience in building online retail systems and a strong understanding of the retail business model. The ideal candidate should be able to deliver a secure, efficient and scalable retail project. Any experience with Angular/react/Node would be plus
I'm looking for a skilled software engineer. THi...task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements...
I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.
...Whereby; candidates can create a profile upload their CV, images or link to images and videos recruiters can search CVs with a Boolean type search functionality & save searches. Candidates and recruiters can message each other. Admin can manage the back end. Suggested technical skill set but not a complete one… • Cloud-based server solution • Azure or Single server solution • MS SQL Database (NoSQL document database might be more appropriate?) • OAuth • Payment gateway • .net We suggest design led development process where we sign off the look and feel of the web pages… the back end is for the supplier to advise the best scalable solution for the application. Please send your credentials/ skill sets and cost struc...
...managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, menu, pricing, and location details. 6. Capture user profile data such as name, preferences, allergies, and delivery addresses. 7. Manage user records and orders in the backend. 8. Prompt new users to provide necessary details. 9. Facilitate dish selection based on user preferences. 10. Display sorted dish options in sets of four ...
I am looking for a professional who could potentially help me create accountant Databases. Prefer for recent ready database. Ideal skills and experience: • Data entry • Report generation • Customizable fields Contact urgent.
It is basically an app that helps the sales see the account profile data that is attached. We already have the designs ready, workflow will be decided in collaboration with the freelancer. Expertise required is app development and not design
...looking for a skilled WordPress developer to enhance our WooCommerce product pages with schema rating code. We want to optimize our product pages for search engines and provide users with valuable information directly in search results. Requirements: Experience with WordPress and WooCommerce development. Proficiency in schema markup implementation. Ability to ensure compatibility with WooCommerce and display product ratings in search engine results. Clean and efficient coding practices to maintain website functionality. Payment: We will make payment upon successful completion and verification of the project deliverables. Deliverables: Implementation of schema rating code on all product pages. Schema markup compatible with WooCommerce. Product ratings di...
HI, We are looking for a skilled WordPress developer to enhance our WooCommerce product pages with schema rating code. Our website specializes in Skin Care. We want to optimize our product pages for search engines and provide users with valuable information directly in search results. Requirements: Experience with WordPress and WooCommerce development. Proficiency in schema markup implementation. Ability to ensure compatibility with WooCommerce and display product ratings in search engine results. Clean and efficient coding practices to maintain website functionality. Deliverables: Implementation of schema rating code on all product pages. Schema markup compatible with WooCommerce. Product ratings displayed in search engine results. Payment: We will make p...
Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL with ...
We are cur...primary function of this extension will be to monitor the data displayed on the website's user interface (UI). When any alterations in this data occur, the extension should perform API calls to transmit this data to an API that stores it within a database. Additionally, there may be instances where the extension needs to make API calls based on UI events, retrieve data from the database, and display this information on the UI. There will also be certain situations requiring the extraction of data from external sources for storage in the database. The stored data will then be utilized by the extension via API calls. Further details regarding these requirements will be provided upon discussion. We look forward to exploring your capabilities...
Here's a paraphrase of the summaries for the tasks: **Extracting data from images (Task 1a):** * You'll need to add a new function to existing code that can grab specific values from images stored on Google Earth Engine (GEE). * These values, representing features of the land, will be used to train a machine learning model later. **Creating a new feature (Task 1b):** * You'll write some new code to define a new feature based on existing data (called NDVI). * This involves creating a new class that inherits from existing ones to handle this specific feature extraction. **Training machine learning models (Task 2a):** * Using all the features you extracted in Task 1, you'll train different machine learning models for a client. * The client has collected soil s...
Our company develops both desktop and web applications tailored for analysing insurance premiums. These have been developed in Delphi over the past 25 years. We are seeking to establish a long term relationship with an experienced Delphi programmer with exposure to Microsoft SQL databases. ASP.net application experience is also desirable. Our software packages require continued upgrading and enhancement and given the specialist nature of our software we are seeking to establish a long term relationship. The primary requirements include understanding our business process and system design, determining and articulating technical solutions, and implementing the design into build and install stages. Australian based is preferred, our principal office is based in Sydney NSW. If you...
I'm in need of a seasoned developer who can design a dynamic, responsive, and custom database synchronization system. Key Requirements: - Custom Data Mappings: The system should allow the designation of unique data mappings for seamless sync across various platforms. - Conditional Sync: The system should support conditional sync to ensure only relevant data is shared. - Automation: The synchronization process should be automated to reduce manual intervention and enhance efficiency. Platforms and Websites: The system should sync data with: - Social media platforms - Mobile devices Ideal Freelancer: - Proficient in database synchronization and mapping - Experienced with integration across websites and devices - Capable of designing automation processes - Knowledgeable ...
Follow directions in video. Maidstone and Unity - Janessa and Kenzie Turtleford/Shellbrook/North Battleford - Juan David and Eduardo Meadow Lake - Cody/Tristan
I'm looking for an experienced .NET developer to assist with a project. This project requires someone who has a strong background in .NET technology, particularly in C# programming, ASP.NET development, and SQL database management. Ideal candidates should have experience in developing web applications, creating software solutions, and improving existing systems. The key functionalities to be implemented by the .NET developer in this project include user authentication, data encryption, and payment integration. If you're a .NET developer with a solid understanding of the above technologies and functionalities, please reach out to discuss the project further.
...in need of an hacker to perform a thorough black-box penetration testing on my WordPress website. Key Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me to achieve this. Your keen eye and tech skills are ...
...data and then stores it in a MySQL database. Key Components: - Unstructured Data: The quotes come in the form of text documents and images. The images have price information marked on them. The system should be able to interpret both types of data. - ChatGPT Integration: You'll be responsible for integrating GPT-3 or similar to process the received data. - Structured Data Storage: The structured data should be stored in a MySQL database. - Automated Database Updates: While batch updates are acceptable, the ideal system will be able to automatically update the database whenever new data is received. Requirements: - Prior experience working with ChatGPT, GPT-3 or similar technology. - Expertise in MySQL, with experience in setting up autom...
I'm looking to develop a web-based check-in page that validates the age of individuals. Key Requirements: - The check-in page should capture the user's CPF (Brazilian taxpayer ID) and Date of Birth. - If a user is of legal age, the check-in should be approved and data stored in the backend. The project is divided into two main areas: - Front End: - The front end should be user-friendly and have a smooth check-in process. - It should include an age validation feature that cross-references the user's date of birth with the legal age limits. - Back End: - The backend should collect and store specific data about the user, including their name, CPF, date of birth, and the time of check-in. - This data should be easily accessible for administrative purposes. S...
I'm looking for a skilled Data Engineer to assist in a large-scale data project that involves data cleaning and preprocessing. Key Responsibilities: - Integrate and process data from various sources including...preprocessing techniques to ensure quality and consistency Ideal Skills: - Proficiency in handling large-scale data sets - Strong experience with integrating and processing data from diverse sources - Expertise in data cleaning and preprocessing techniques - Knowledge of relevant tools and frameworks for data engineering Prior experience in similar large-scale data cleaning projects and proficiency in SQL, Python, and ETL tools would be highly advantageous. Your ability to ensure data quality and integrity in a high-volume environment will be critical to the success o...
...goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to...
...professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL, data merging, and database...
...relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories * Experience in applying normal...
...additional parameters required by any of the connectors for any operation can be passed through the ‘params’ argument. Automating OAuth 2.0 might be a challenge. We are okay if some of it is handled manually. - The authorization_grant received by the redirect_url can be saved manually. - Similarly, the tokens received after ‘exchangeToken’ or ‘refreshToken’ can be saved manually. These manually stored tokens can then be hardcoded in the code to make the subsequent API requests. Demonstrating the working of all the functions is required for a successful entry. The demonstration will be in a google meet and will have to include english language review/explanation of the developed source code as well as demonstration of the functionality. &lsquo...
...integrating effectively with its native or third-party voice capabilities. Performance Benchmarks: Establish criteria for evaluating the accuracy and responsiveness of the voice interactions and summarization functionality. Security and Data Handling: Data Protection: Implement essential security measures to ensure that all user data, including interview content and summaries, are handled and stored securely, complying with standard data protection protocols. Skills Required: Mobile Development: Extensive experience in iOS and/or Android development, with proficiency in languages such as Swift, Kotlin, or using cross-platform frameworks like Flutter or React Native. Speech Processing: Proficiency in integrating speech-to-text and text-to-speech services, such as Google Cloud...
Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's shor...
I am seeking a PHP developer who is experienced in frontend development, and an expert in PHP frameworks and MySQL database integration. The focal point of the project is database management. • Main responsibility of the PHP developer will be to build new databases, thus experience in this is essential. • A background working with PHP frameworks and MySQL is crucial for success in this role. • The role also entails some front-end development tasks. Successful applicants will illustrate these skills throughout their portfolio in relation to past projects. If you are a self-starter with a penchant for database management, I look forward to receiving your bid.
I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.
Here's a paraphrase of the summaries for the tasks: **Extracting data from images (Task 1a):** * You'll need to add a new function to existing code that can grab specific values from images stored on Google Earth Engine (GEE). * These values, representing features of the land, will be used to train a machine learning model later. **Creating a new feature (Task 1b):** * You'll write some new code to define a new feature based on existing data (called NDVI). * This involves creating a new class that inherits from existing ones to handle this specific feature extraction. **Training machine learning models (Task 2a):** * Using all the features you extracted in Task 1, you'll train different machine learning models for a client. * The client has collected soil s...
I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm i...security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the peace of my server wor...
I am seeking a talented freelancer to conduct an audit of our company's data and create an availability map. - **Data Audit**: Your primary task will be to delve into our data sources and types, understanding what we have and how they're stored. - **Data Availability Mapping**: Based on your audit, you'll then create a clear, comprehensive map of where our data is and how it can be accessed. Ideal candidates for this job should have a solid understanding of data management, analysis, and storage. Experience in data auditing and creating data maps would be a significant advantage. A meticulous eye for detail is crucial, as we need a thorough and accurate representation of our company's data landscape. A data audit refers to the examination of data to assess it...
...areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand our specific needs and tailor solutions accordingly. - Familiarity with perfor...
I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table. Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.
...continuously improve our data solutions Key Skills :- • Bachelor's degree in Computer Science, Information Technology, or related field. • 4-5 years of professional experience as a Data Engineer with a focus on Azure Databricks and Azure Data Factory. • Strong proficiency in SQL, Python, and/or Scala for data manipulation and scripting tasks. • Experience working with data lakes, data warehouses, and ETL processes. • Familiarity with cloud platforms (preferably Azure) and related services such as Azure Blob Storage, Azure SQL Database, etc. • Excellent problem-solving skills and attention to detail. • Effective communication and collaboration skills to work with cross-functional teams. • Azure certifications (e.g., Mic...
need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a precise timeline has...
...website from scratch. The project will involve handling both front-end and back-end development, as well as database management. Key Responsibilities: - Front-end development: Crafting a visually appealing and user-friendly interface. - Back-end development: Building the necessary server-side logic. - Database management: Ensuring that the site's data is stored and accessed efficiently. The developer should have a strong understanding of Laravel, as the website will be primarily built using this framework. Ideal Skills and Experience: - Proficiency in LAMP stack development. - Extensive experience with Laravel. - Proven capability in front-end development. - Strong understanding of database management. The end goal of this project is a fully functi...
I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing
I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing
I'm in need of a comprehensive business owner database specifically in Tamilnadu, Chennai. The database should include detailed information of business owners Contact number, Email ID from various industries like GST Filling Database, Distributors, Industries, Dealership and more
I need a fast turnaround to correct error messages in my PHP code and database. The main goal of my PHP application is to upload content to the database and ensure the site displays it correctly. Key Responsibilities: - Fixing error messages in PHP code - Addressing database issues - Ensuring smooth content uploading functionality - Ensuring the site can retrieve and display content from the database Ideal Skills and Experience: - Proficient in PHP - Strong understanding of database management - Prior experience in troubleshooting and fixing error messages - Ability to work fast and deliver under tight deadlines.
I'm looking for a task-oriented individual who can assist me with saving documents from an online database. Your assignment would primarily revolve around focusing on documents and seamlessly saving them off. Key responsibilities: - Download documents with my full permissions. - Make sure that all downloaded files are in audio file format and labelled correctly. The ideal candidate will have: - Relevant experience and proficiency in saving files to dropbox. - Excellent attention to detail ensuring the correct files are stored. May be 1-2 days of work.
...seeking a highly skilled data engineer with a strong proficiency in Apache Kafka to work on a data integration project. The main objectives of this project are: - Integrate various data sources: structured (SQL database), semi-structured (XML, JSON), and unstructured (emails, documents) - Develop a robust data flow architecture - Ensure efficient data transmission across systems The perfect freelancer for this job should possess the following characteristics: - In-depth knowledge and practical expertise with Apache Kafka - Experience with integrating diverse data sources, such as SQL databases, XML, JSON and unstructured data (emails, documents) - Proven track record of successful data integration projects Feel free to schedule a meeting using this link.
...experience in iOS app development - Familiarity with creating apps requiring user authentication and account setup - An understanding of backend programming for data storage - Experience with healthcare field is a plus The main function of the app will be to conduct medical surveys. Users will need to create an account, log in and answer health-related questions. This sensitive data needs to be stored securely. The app should have an intuitive, user-friendly interface that can easily be navigated by individuals with various tech skill levels. This is something that would be an ADDITION to apps like MyChart and it conducts an AI based survey to give a patient a rough diagnoses, based on multiple choice questions. Skilled in Swift or Objective-C is preferable. The ability to com...
... and license usage. Non-functional Requirements: 1. Security:  Implement HTTPS for secure communication.  Apply role-based access controls to restrict unauthorized access to sensitive data.  Regularly update and patch software components to address security vulnerabilities. 2. Performance:  Ensure fast loading times and responsiveness of the website, even under heavy traffic.  Optimize database queries and server-side processing for efficient performance. 3. Scalability:  Design the system to handle a growing number of users and transactions over time.  Employ cloud-based infrastructure to scale resources dynamically as needed. 4. Compatibility:  Ensure compatibility with popular web browsers (e.g., Chrome, Firefox, Safari).  Support responsive design for seamless u...
I have C# MVC Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Error message appear with no details, need to make the error message has Show More to display the details of the error. 2- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 3- Packages Load from APIs instead of loading from DB (2 APIs) 4- SubscribedPackages Call API instead of inserting into a DB (1 API) 5- Schemes Load from APIs instead of loading from DB (1 API) 6- Uploads Call API instead of inserting into a DB (1 API) 7- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# MVC experience. ----...