Add database sqlJobs
...up and configure a MySQL database with Oracle APEX. The main purpose of this setup is to manage and retrieve product inventory and sales transaction data. Key tasks include: - Designing the database to efficiently handle product inventory and sales transactions. This involves creating an Entity-Relationship Diagram (ERD), and writing Database Definition Language (DDL) and Manipulation Language (DML) statements. - Configuring the Oracle APEX environment to interact with the MySQL database and ensure smooth data retrieval and management. - Ensuring the system is secure, ensuring no unauthorized access to the database. - Providing a high-level overview of the system's architecture and functionality. Skills and experience required: - Strong expertis...
I need a Django professional to manage a sensitive task involving the masking of our project's database. Your primary role will entail implementing encryption on our data. Key Responsibilities: - Generate an encryption key. You’ll be responsible for creating a robust and secure encryption key. - Implement Database Encryption. Utilise your Django expertise to seamlessly integrate encryption without compromising the performance or accessibility of our database. - Maintain Data Format. It is critical that the encrypted data retains its original format. Ensure that no distortions occur during this process. Ideal Skills: - Proficient in Django - Knowledgeable in database structures and encryption - Proven ability to generate secure encryption keys - Exp...
Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what SQL databases can achieve...
Need additional hands to add new features and bug fixes in existing web applications Tech Stack .NET6, C#, SQL 2019+, HTML, JQuery, Azure Dev Ops Experience in Deploying application in Windows and Ubuntu 20.04.6 LTS mandatory Preferred fullstack developers with experience in following areas : Messaging, Sharefiles, ShareScreen and Remote Desktop, Audio/Video Calls, Survey cum Poll Platform with real time dashboards enhance UI/UX design and Interactive Graphical Dashboard While its a short term engagement depending on skills can be extended.
I have a project that involves entering textual data from physical documents into a database we are creating. Key details: - The data is textual in nature and will be provided to you in physical document form. You will need to accurately transcribe this information into our database. - The primary goal of this project is to create this database. Ideal skills and experience: - Strong attention to detail is critical for this project as accuracy is a key requirement. - Previous experience with data entry is preferred, especially when working with physical documents. - Familiarity with database software would be a bonus, although not necessary. - Excellent organisational and time management skills to ensure the project is completed efficiently.
write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru
I'm in need of a skilled developer to create an Android application with ASP.NET C# backend and SQL SERVER database. Key Features: - The app should primarily function as an e-commerce platform, allowing users to browse through products and services. - I require the app to have a chat functionality where users can communicate with the sellers. - Users should also be able to leave reviews for products. Specific Chat Features: - The chat functionality should support text messaging, image sharing, and voice messages. Skills and Experience: - Proficiency in Android app development - Strong experience with ASP.NET C# and SQL SERVER - Previous experience in developing e-commerce apps - Proven track record in integrating chat functionalities within an app - Familiarity...
...it to draw IMEI numbers both randomly and from a database based on specific parameters. Key Features: - **Dual Functionality**: The tool should be capable of generating IMEI numbers randomly or by allowing me to specify certain parameters. - **Parameter Selection**: The parameters that I should be able to choose from when generating IMEI numbers are the device brand and the operating system (OS). - **Web Interface**: The tool should be accessible through a user-friendly web interface that allows me to easily generate the IMEI numbers. Skills and Experience: - Proficiency in Python, as I believe the tool can be built on existing scripts like ``. - Experience in working with databases, ideally with knowledge of the TAC database. - UI/UX design skills to create a simple an...
...competent freelancer with an understanding of MS Access Database creation. This project is aimed at developing a food manufacturing cost-tracking function on top of an existing product management database, while cleaning the existing database up and adding reporting functions. The project involves: 1. Cleaning up existing Database file of Products to a new layout (Can start again or build on existing file). 2. Adding the manufacturing cost analysis function to the database (Allows user to define ingredients and fixed costs for a product and calculate it’s cost price). 3. Adding the sub-recipe costing function – same as above, however, for internal products not sold. 4. Adding the ingredient purchase price and tracking to the database...
I need a NoSQL database system that can effectively manage our company's purchases, production, and inventory. The project needs to be completed within a month. Attached the Project details ... Key Features Required: - Scalability: The system should be able to handle large amounts of data and growing demands. - Flexibility in Data Modeling: I'm looking for a system that can adapt to our changing business needs without compromising on performance. - High Performance: It's crucial that the system can process data efficiently and provide real-time insights. Ideal Skills and Experience: - Proven experience in designing and implementing NoSQL database systems. - Strong understanding of data modeling and its impact on system performance. - Ability to d...
I need an experienced IT expert to install SQL Server 2019 and the Landmark Compass software on a Windows Server 2019 based system. Key Responsibilities: - Install SQL Server 2019 on Windows Server 2019 - Setup Landmark Compass on the same server Key Skills: - Familiarity with Windows Server 2019 operations and configurations - Extensive experience in SQL Server 2019 installation and setup - Working knowledge of Landmark Compass software The ideal freelancer should have a proven track record of managing and adjusting settings in Windows Server 2019 and a firm understanding of SQL Server 2019 installation. Your role is primarily installation and setup, so no coding or SQL development is involved.
I'm looking to hire a web developer and designer proficient in building an aesthetically pleasing and functional character-storage site that is equally immersive. Key Features: - A platform for managing and displaying detailed character profiles. - Capabilities to categorize data such as names, descriptions, stats, abilities, and corresponding images or artwork. - An integrated search feature to filter out specific character types. Artwork Requirements: - The site should be able to host a variety of artwork formats like character illustrations, and digital paintings. - The developer should implement features for GIF support, to showcase more dynamic character pieces. The ideal candidate has previous experience designing and developing similar sites, a keen eye for aesthetics, exce...
Just need someone to add a Facebook pixel to my website via GTM, and also create a "Purchase" conversion goal.
I require a proficient Pl/SQL programmer to assist me in writing stored procedures for my database. Your primary goal is to focus on the programming aspect of Pl/SQL, specifically in creating stored procedures. This is key to the project and will require a deep understanding of both database management principles and the syntax of Pl/SQL. Key skills and experience needed: - Proficiency in Pl/SQL programming - Proven experience in writing stored procedures - Strong understanding of database management and architecture - Excellent problem-solving skills - Attention to detail and accuracy in coding Your work will contribute significantly to the efficiency and effectiveness of my database system. Please be sure to have a portfolio or e...
I am looking for an experienced Data Entry Operator for a specific task. The main pur...Data Entry Operator for a specific task. The main purpose of this task is to help organize our customer database. Apart from entering data, the operator should ensure that sensitive customer details are properly handled with care and confidentiality. To apply: * Present a detailed project proposal that shows you have fully understood the requirements of the job. Ideal Skills and Experiences: * Proven data entry work experience. * Sensitive to data privacy issues. * Strong attention to detail. * Proficient with Microsoft Office and data programs. Please note: data migration or data analysis is not needed for this role. The focus is on data organization. Let’s make our customer da...
...operating system. The aim of this project is to ensure a sophisticated and smoothly running CRM solution at the earliest. Specifically, here's what I'm looking for: - Speed: The project should be completed ASAP. Please only bid if you're able to deliver within a short time frame. - Expertise: You should have past experience installing SuiteCRM, particularly on Linux. We will: Set up SQL database Provide database username and password. Provide cPanel access The project is to install SuiteCRM v. 7.10.4 No modifications or importing of data is needed Set up one Admin account – we will provide a username and password When your installation is complete we will (within one business day) test your installation by creating a Lead, and converting th...
1. Adding 5 today and 1 yesterday ATR line 2. Adjusting default values
I'm seeking a skilled graphic designers to use their creativity to add the letter X to my current logo. The X will go after Trick Shot. I need the X to stand out, however, not so much that is takes away from the movement of the balls in the logo. Some Ideas: -I like using the same green color as the tennis ball already used in the logo. -I have thought about making an X with hockey sticks or field hockey sticks to make an X. -Use a font that is an outline of the letter X. -Use a cool sports font. I look forward to seeing how you can incorporate the X into my logo without overpowering the rest of the logo. Thanks!
I am looking to add a cache busting feature to a website. I am receptive to paying for milestones or paying hourly if we end up communicating a lot while the work is done. The PHP site consists mostly of 1 mostly HTML page with a long list of links to a directory full of PDF and MP4 files. Sample code is attached. Each can be opened in a Fancybox Modal window. Sometimes the PDF/MP4 files are overwritten with a newer version with the same exact name. Of course browsers often use the cached version instead. The files are big enough where I want the browser to cache them, but only until they change - then the browser needs to grab the new version from the server. The apache and .htaccess expire headers haven't done what I need. I read that some codebases exist that will assig...
Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other
...developer who can urgently dive into my project and rectify unspecified bugs/errors. The details of the issues are as follows: - Unspecific database connection issues - Pages are not loading as they should - Certain functionalities are not properly working The exact pages or functionalities affected are not clearly pinpointed yet. It's a task that requires you to have an in-depth understanding of Codeigniter, and the ability to quickly identify and resolve problems within the project. Key Skills and Experience: - Strong experience with PHP and Codeigniter framework - Advanced troubleshooting and debugging skills - Proficient in SQL and server/database connections - Ability to detect and fix broken code rapidly Kindly note, this work is time-sensitive an...
I'm in need of an experienced MySQL and Neo4J expert who can help me with designing a database schema and an ERD Diagram from a CSV file. Make a report of the database with proper screenshots and run some queries. more details in chat... Requirements: - Proven expertise in MySQL and Neo4J - Solid understanding of database schema designing - Producing an ERD Diagram
Dear developers, I am looking for a skilled python engineer that is able to create a ML engine which is capable to extract specific datapoints from the pdf files and save them as per set of rules to sql table. system has to run offline, so no online solutions will be accepted as they cannot be used for this project. current problems: 1. large part of documents are scanned, but data is digital. essentially form was printed and scanned upon completion. 2. scanned files are tilted. 3. scanned files have noise which require removal of it. 4. few scanned documents require quality enhancement. 5. some scanned documents have different zoom. 6. all files have checkboxes. 7. specific datapoints can change location within the file, so engine must search for it and find it. there is maste...
I'm looking for a talented data researcher who can scour government databases to identify Pension variables. The data you'll be researching will be at the heart of the project, so it's pivotal that you are efficient, detailed, and reliable. Key Duties: - Methodically research and compile comprehensive data from government databases - Focus on economic indicator data - Ensure accuracy of collected data Ideal Skills & Experience: - Strong research skills, particularly in government databases - Background in economics, with a solid understanding of economic indicators - Keen attention to detail, ability to interpret and organize complex information effectively - Previous experience in data collection or analysis roles is a huge advantage. Perfect for those who prefer wo...
I'm looking for a skilled and experienced developer to architect a database for a Healthcare application using Node.js. The primary goal of this project is designing a robust, efficient and scalable database that can handle the data requirements of a healthcare application. The database should be able to effectively store and manage sensitive patient information, interaction records, and other relevant data. Key requirements include: - Expert level understanding of Node.js and database design principles - Previous experience developing databases for healthcare applications is a plus - Ability to ensure compliance with healthcare data security standards - Strong problem-solving and analytical skills - Effective communication and collaboration abilities, a...
As a thriving business, we're seeking an experienced Laravel and SQL developer for our upcoming web development project. The developer's main task will be to bring to life our concept of designing and implementing a responsive, user-friendly web application. We're in need of: - Laravel Web Development: Building a robust, intuitive web application using Laravel PHP framework. Utilising Laravel's features to their maximum potential. - SQL Database Management: This includes maintaining and optimizing our SQL database for this upcoming project, ensuring the data structures are well-designed and functional. - Backend API Development: We have several third-party services which need to be integrated into our application through backend ...
More details: What specific website(s) do you want to scrape data from? Website 1, Website 2 What specific data do you want to scrape from the selected websites? Text content, Tables What information would you like to extract from the text content and tables? Product names, Prices, Descriptions, reviews, size and color, occasion, return and country of origin, category, fabric, weartype
Skills Required Python Aws services-S3, glue, athena, sagemaker, feature store Sql UI/ API/SWAGGER PAGE Good in ML 5 days in a week Remote support role You will have to help developer for completing the task Timings - 9 to 11 am IST (or evening IST) Payment - You will be paid for those hours while you will be working, You will be informed in advance if there is no work and for those hours you will not be paid. Budget = 400 INR /h
I am in urgent need of a developer to help me delete some crucial files from my server's database. The files in question are related to both orders and affiliate data. Key details: - Urgency: This task needs to be completed within 24 hours. The files do not involve any specific criteria for selection. The process is straightforward, and all relevant files need to be removed. Ideal skills and experience: - Proficiency in database management and SQL - Experience in managing ecommerce and affiliate systems - Ability to work under tight deadlines - Good communication and collaboration skills
I'm seeking an expert to build a PowerBI solution, primarily for financial planning and analysis (FP&A). Key project requirements: - Robust Integration with our SQL database to pull the necessary data. - Proficiency in creating illustrative Charts and Tables in PowerBI, enhancing data interpretation. - The dashboard should effectively track and analyze the key metrics such as Revenue, Profit Margin, and Sales growth. Ideal freelancers applying for this project should have: - Demonstrable experience in PowerBI and SQL database integration. - Solid background in creating visually engaging dashboards, specifically using Charts and Tables. - A solid understanding of FP&A metrics. - Proven track record in delivering similar projects. Please submit...
I need an efficient and detail-oriented freelancer to populate a database with information about my customers. The project involves collecting, inserting and cleaning the following data of around 12,000 rows of potential clients. The main data management tasks would be analyze, identify and delete duplicates, and the main data to be collected would be only: - Customer Name - Email Address These data points will be provided, and your task is to efficiently and accurately compile this information into our database. Experience in data entry, database management, and customer service will be beneficial to complete this project. Knowledge of Excel and other data management tools is essential. The freelancer must be meticulous and trustworthy as they will be handling sensi...
I'm searching for a proficient Python Developer to construct a high-performance database proxy and load balancer. This system should cleverly guide requests to compute engines in a manner that both reduces cost and heightens throughput. This system will run queries with minimal latency and virtually zero queuing. Key Aspects of Project: - Develop a robust database proxy using Python - Implement intelligent request routing to minimize cost and maximize throughput - Guarantee low latency and minimal to zero queuing while executing queries The ideal candidate will have the following experience and skills: - Proficiency in Python - In-depth understanding of database management systems, particularly Snowflake - Experience with handling structured data - Expertise...
I am seeking an experienced PHP developer to fix functional errors in my PHP code that's designed for searching text data in a MySQL database. The primary function of the code is to facilitate this search, hence it's crucial that these errors are addressed in a timely and efficient manner. Key Responsibilities: - Identify and resolve functional errors in the PHP code - Ensure smooth and accurate search functionality for text data in the MySQL database Ideal Skills and Experience: - Proficient in PHP programming with a strong understanding of MySQL database - Previous experience in fixing functional errors in PHP code - Ability to conduct thorough testing to ensure search functionality is robust, accurate and efficient This project is time-sensitive, so th...
Firma szuka wsparcia zespołu zajmującego się rozbudową i utrzymaniem własnego serwisu web na DNN. Doświadczenie w C#, ASP.NET, T-SQL. Zapraszam do współpracy.
I'm looking for a Full-Stack Python programmer with solid SQL and .NET experience. The primary focus of the project is web development. Key Requirements: - Proficiency in Python is a must. You will be working on both the front-end and back-end of a web application. - Strong understanding of SQL and .NET. You'll be handling databases and working on the server-side functions. - A solid background in full-stack development. The project will require a comprehensive approach to both front-end (user interface design) and back-end (server-side functions) development. Your responsibilities will include, but not limited to: - Developing user interactions on web pages, implementing server-side logic, and maintaining the system. - Building the overall structure of the web a...
...into a database file that can be used by Gathid (), exacting governance and instant, actionable insights that transcend traditional IAM limitations. I need a script that run and does it so I can implement that on AWS Lambda or similar Serverless implementation. I think Python would be good but also open to Java. I am not sure if you can or suggest to have multiple script that runs as a different process or you can build a Mono-Repo that can handle all of those providers under one process and can be easily scale to add more applications. Below is the list of Providers: Airflow AWS On-Prem AD Azure AD Control Money Data Lake Data Warehouse GitHub Jenkins Kyriba Loyalty Admin Loyalty API Mode MongoDB NetSuite Octopus Deploy OKTA Pricing Engine Reconart SQL ...
I am looking to take this two photos of sectional sofas and change the background to make it look like they are in a room. I have enclosed an example of what I want the finished project to look like
... Key Features Required: - Customer Database Management: A well-structured and easy-to-use database to store customer details efficiently. - Sales Tracking: Built-in capabilities to track and analyze sales data, which will enable us to better understand our business growth and trends. - Inventory Management: An integrated inventory management system to efficiently monitor stock levels and streamline our operations. - App Integration: A feature that can seamlessly connect our clients to our business through an app. Core Skills and Experience: Ideal freelancers should possess: - Proficient skillset and experience in software development (specifically Windows and macOS compatible software). - Knowledge in developing systems for Customer database, Sales track...
I need a skilled Shopify developer to help rework my website's homepage design and add 8 products in a way that creates a landing page. - You will be tasked with redesigning the navigation menu. This will help improve user experience and aesthetic appeal. - The landing page you will create should seamlessly integrate the 8 new products. These should be displayed in an eye-catching and easy-to-navigate manner. - Your input on how to achieve this is welcomed, especially if it helps to highlight new arrivals, feature sale items or showcase best sellers. To be best suited for this job, you should have: - Proficiency in Shopify and its design tools. - A good eye for design, particularly in creating effective and clean navigation menus. - Experience in creating landing pages ...
I am looking for a detail-oriented freelancer to help convert my existing Excel spreadsheet data into a database format. Requirements: - Import and convert Text Data from Excel Spreadsheets to Database format - Accurate and efficient data entry skills required - Prior experience with Excel and database formatting is a must - The candidate should have an eye for detail and be well-versed in data management By the end of the project, I expect all data from the Excel spreadsheet to be neatly structured and readily accessible in the new Database.
...innovación y mejora continua en los procesos y productos de la Start-Up. Requisitos: - Fuerte experiencia en programación con Python, demostrable a través de un portafolio de proyectos sólidos y eficaces. - Conocimientos avanzados en frameworks de Python como Django o Flask, especialmente en desarrollos de aplicaciones web. - Habilidad para trabajar con distintos tipos de bases de datos, tanto SQL como NoSQL. - Experiencia en la integración de APIs y en el desarrollo de servicios web. - Capacidad de análisis y solución de problemas, orientado a resultados concretos. - Fluidez en español, con habilidades de comunicación efectivas para trabajar en equipo. - Preferencia, aunque no exclusiva, por candidatos ubicados en A...
I'm currently using Oracle and MySQL database management systems and I'm in urgent need of a dedicated database administrator who can expertly handle performance tuning, backup and recovery, and security management. The ideal candidate should have an extensive background in both Oracle and MySQL, as well as a solid understanding of the nuances of these database management systems. Here's what the project covers: - Performance Tuning: I'm experiencing sub-par performance with my existing workloads, and I need someone with a knack for diagnosing and resolving complex performance issues. - Backup and Recovery: An integral part of the project is to safeguard the digital assets by implementing robust backup and recovery strategies, thus to ensure d...
I require an experienced ERPnext developer who can optimize my business operations. Key tasks include: 1. Migrating my database from to hostmonster.com. Due to this, expertise in data migration, specifically regarding these platforms, is vital. 2. Establishing a connection with "ClaimMd" through its API. For this, proficiency in API integrations, preferably with ClaimMd, is essential. I currently have the necessary API credentials on hand. API instructions can be found here: ( ) 3. Implementing a bidirectional connection between a custom doctype, timesheet, and invoicing. Therefore, knowledge in generating, managing and integrating custom doctypes in ERPnext is necessary. Your experience in installing new themes on ERPnext will also be highly regarded
I'm seeking assistance in creating registration forms generated directly from a database. The key deliverable is a dynamic, user-friendly registration form that features predominantly mandatory fields for personal details and contact information, and a few optional ones as well. Specific requirements include: * Fields for personal details such as name, age, gender, etc. * Contact information fields like phone number, email address. * Optional fields that users can choose to fill if they wish. The successful freelancer should have: * Proficiency in database management and form generation. * Experience in user-friendly and intuitive form design. * Attention to detail to ensure all mandatory and optional fields are accurately represented.
I'm experiencing performance issues with 5 stored procedures in my SQL Server. These procedures are significantly slower than expected due to complex JOIN queries involving multiple tables. The project entails: - Diagnosing the cause of the slow performance. - Improving the efficiency and speed of these 5 stored procedures, aiming to achieve at least a 50% increase in speed. - Decreasing high memory usage of a sql server instance Ideal skills and qualifications: - Proficiency in SQL Server and complex JOIN operations. - Proven experience in SQL query optimization and performance improvement. - Understanding of advanced aspects of SQL Server performance tuning. - Excellent debugging and diagnostic skills. - Familiarity with procedures handling mu...
...of a skilled FoxPro developer who can help me in managing my small and simple FoxPro database. The ideal candidate should be equipped to: - Perform regular management tasks such as data entry and data organization. - Conduct troubleshooting and bug fixing when necessary. - Focus on optimizing the database's performance to ensure smooth operations. - Implement data analysis and reporting features for better decision-making processes. The project is relatively straightforward given the size and complexity of the existing database. I am, however, looking for someone who can provide efficient and effective solutions for the aforementioned tasks. Ideal candidate should have: - Proficiency in FoxPro database management and troubleshooting. - Experience in optimi...
Need to add reload function to the script after action is made. So value will be show or removed.
I'm in need of a data entry specialist to assist in the creation of a new database. The primary task will be to input text data from digital files. Key responsibilities include: - Accurate and efficient data entry of text information - Organizing data to ensure it's ready for database implementation - Ensuring data integrity and consistency Ideal skills for this project include: - Proficiency in data entry - Attention to detail - Familiarity with database management - Excellent organizational skills The goal of this project is to have a comprehensive and well-structured database, primarily populated with the text data provided. Please pitch your relevant experience and approach for this task.
I am seeking a professional for a data entry project. The task will involve transferring numeric data from digital files into a specified format in a database. Key tasks will include: - Accurate translation of numeric data from digital files, - Adherence to specific formatting as required by the database, - Ensuring the integrity of the transferred data, - Timely progress and completion of assignments. The ideal candidate should: - Have a keen eye for detail, - Have solid experience in data entry, - Be familiar with database systems, - Have excellent time management and organizational skills. This project will require precision and reliability. It's essential to ensure the accurate and systematic input of the numeric data. I look forward to your support in ...