Database sql query oracle help jobs

...devices and browsers Integrate third-party APIs and services as needed Conduct thorough testing to identify and resolve any bugs or issues Provide ongoing support and maintenance for the website and plugins Requirements: Proficiency in WordPress development, including theme and plugin development Strong understanding of PHP, HTML, CSS, and JavaScript/jQuery Experience with MySQL databases and SQL queries Familiarity with version control systems such as Git Knowledge of WordPress security best practices Ability to troubleshoot and debug issues effectively Excellent communication and collaboration skills Attention to detail and a commitment to delivering high-quality work Duration: This is initially a one-month project with the possibility of extension based on project needs and...

I have a recent backup from 4/1/24 on a hard drive attached to my new computer. My previous computer died, the motherboard went out and somehow my SQL Server data was not saved on the original hard drive. I need to pull the data from a ".DATA" file, or find the missing SQL Server backup files and copy them into my existing program for use. Can anyone help?

I'm looking for a skilled Perl expert to help me remove duplicates in an Excel dataset. The removal process should be based on multiple columns, ensuring a thorough cleanup. Ideal Skills & Experience: - Strong proficiency in Perl programming - Proficiency in data analysis - Expertise in Excel and handling large datasets - Prior experience in removing duplicates from Excel based on multiple columns Communication: I prefer to have project updates through video calls, so please be comfortable with this form of communication. Your ability to walk me through the process will be highly appreciated.

Hourly paid job with great PERFORMANCE BONUSES. [please read it carefully, I'm here to really hire someone, so be attentive to the details] I'm starting a new business and using Instagram and LinkedIn as marketing channels. I need help with various small and simple activities such as: (1) Mining (searching for) viral Instagram Reels and (2) creating a relation with my niche - could be a description, comment or title. I need to post 1 Reel per day. You'll send me a few Reels per day and I will remix the one I see more potential. Evaluation: I will evaluate your job constantly based on the quality of your searches and of course, if it goes viral, that's an indicator too. ***If the Reels goes viral, I will give you 1 PERFORMANCE BONUS (A). ***If we reach 5...

I am looking for an expert in MS Excel and navigating a website. We will provide a list of certain colleges and universities in the United States, 258 of them. Go to and type the name of the school, then type “athletics staff directory” and hit enter/search. The first site listed will be the staff directory for the athletic department. Scroll down to the Football staff. For every member of the Football Staff who has an email address listed, you need to enter that staff member’s information (School Name, First Name, Last Name, Title, Email Address, Twitter) into the spreadsheet. This is a single project that would need to be completed each year. Pay would be made upon completion of the project. Mode of communication is English.

...based on prices from local stores or average costs. Technologies: Frontend: Vue.js or React for a dynamic and responsive user interface. Backend: Python with Flask or Django, using machine learning libraries like TensorFlow or Scikit-Learn for AI functionalities. APIs: Integrate with APIs for nutritional data (like Spoonacular or Edamam) and possibly grocery prices from online retailers. Database: Use SQL (like PostgreSQL) for structured data storage of user profiles, meal plans, and feedback. Machine Learning: Implement machine learning algorithms to personalize meal recommendations and learn from user feedback. The developer should be passionate about creating user-friendly experiences and should have a keen eye for detail to ensure seamless functionality of our applic...

...Objectives for the system: 1. It has to be completely offline (no online solutions will be accepted); 2. System has to be integrated with LLM (Llama or similar); 3. LLM must be capable on answering questions (via chatbot interface on GUI) on: a. DP’s; and b. Text it read while it was scanning the PDF and looking for DP’s; c. Previously read documents related to the same client. 4. DP’s are to be saved to SQL table; 5. We need a dashboard, to train the engine on finding DP’s in the document. Current problems: A. Large part of documents are scanned, but regardless if the document is scanned or not, it’s all in digital form format. It just so happens that some forms were populated digitally, printed, and scanned; B. As such, scanned documents are: a. T...

I'm in need of an experienced SQL professional to assist me with data warehouse. The ideal candidate is someone who has: - Proven experience in designing data warehouses - Advanced SQL skills - Excellent understanding of data volumes and the implications for data warehousing If you are interested in this project, please provide details of your experience in similar projects. Thank you.

...including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and custom query builders. - Strong analytical and data organizing skills. - Experience in converting independent Excel worksheets into a master file. - Knowledge in NDT industry would be beneficial but not paramount. The goal is to provide an automated and streamlined approach to handle inspection reports, making analysis and generation of summary statistics a bree...

I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.

I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.

I am in immediate need of a comprehensive database containing information about IT professionals with 2-3 years of experience. This is crucial for a current initiative, thus I need it ASAP. The database should provide: - Name - Phone Number - Skills - Educational Background - Work Experience - Salary Precision is of utmost importance to me. Therefore, an ideal freelancer for this task should have proven experience in data collection and data entry, with a keen eye for detail to ensure the accuracy of the database. Experience in the IT or HR industries would be a significant advantage.

I'm in need of a PowerPoint presentation that I will use for a 10-minute lecture about Vitamin B in developed countries. The target audience for this lecture will be students, so the content should be engaging and informative but at a general level. Key Points: - The PowerPoint should be a high-level overview, explaining the importance of Vitamin B in the context of developed countries. - The content should not be too detailed - the focus should be on providing a clear and concise understanding of Vitamin B. - The presentation should be structured in such a way that allows for a smooth and engaging delivery within a 10-minute timeframe. The ideal freelancer for this project should have: - Experience in creating educational content, particularly for students. - A good understanding...

I see that you have done UPS shipping API's. They are converting everything over to OAUTH 2.0 with their shipping. Is this something you can do or have done? I have a VB project that was built and added to over the last 10 years and updated. It is written in C# and uses MS SQL. Their current API is ending June 5th of this year. I need this switched over to OAUTH. I just use the shipping, rates, and time in transit within my website. Let me know.

...data into a database. While the data entry itself isn't particularly complex, a certain level of basic data cleaning will be required. Key Requirements: - Data Entry: The main task is to accurately input data from PDFs into a database. The data is mostly textual, so typing proficiency and attention to detail are essential. - Database Organization: The entered data needs to be organized in a clear, logical manner to ensure it's easily searchable and can be efficiently used. - Basic Data Cleaning: The data will need to be reviewed and cleaned up to ensure accuracy and integrity. This will involve identifying and removing any duplicate entries. Ideal Skills and Experience: - Proficient in Data Entry: Experience with data entry tasks, particularly those inv...

Postgres data query system Docker across multiple servers

Need someone who has experience in android apps for hell in fixing errors

We are seeking a talented full stack developer to create a mobile application for a medical start up. The application will serve as a platform for patients to perform home based outdoors exercise, receive general information about their condition and comm...responsive and compatible with various devices and platforms - Conduct thorough testing and debugging to ensure high-quality and bug-free code Requirements: - Proven experience as a full stack developer - Familiarity with mobile application development, particularly in the medical industry - Strong programming skills in JavaScript, HTML, CSS, and relevant frameworks - Proficiency in database management and query optimization - Knowledge of RESTful APIs and best practices for integration - Excellent problem-solving and com...

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm urgently in need of a skilled professional who can swiftly deploy a database server for me. Key Responsibilities: - Establishing a server primarily intended for databases - Choosing the suitable database management system (DBMS) Ideal Competencies: - Extensive experience with multiple DBMSs as I'm not yet decided on which one to use - Ability to work under pressure and deliver swiftly since the project is urgent - Prior experience with server deployments will be highly advantageous.

...who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment information and be on...

I’m experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication.

I am seeking an expert in SQL Server replication. The project involves replicating our business data to facilitate efficient data distribution. The replication has been set up. The snapshot working but Data not delivering to the subscriber. Log reader fails after 10 mins - Key Expertise Required: - Proficient with SQL Server - Extensive experience with data replication - Profound understanding of business data - Knowledge in data distribution strategies

...an Access database that can primarily handle generating reports and analytics. The main goal is to keep track of internal data for further analysis and reporting. Key Features and Functions: - **Reports & Analytics:** The database should have the capacity to generate comprehensive and insightful reports from the data gathered. It's crucial that these reports are insightful and easy to understand. - **Data Tracking:** The database will be used for tracking internal data. This needs to be done with precision and the ability to link data for comprehensive tracking. - **Data Input & Updates:** The system should allow for easy input of data and updating when needed. This will facilitate the generation of accurate and updated reports. Ideal Skills: - Pro...

? Seeking Participants for a Focus Group Survey and WhatsApp Activity! ? Are you a user ...survey and 5-day WhatsApp group activity! Activities: -Focus Group Survey: Participate in a 2-hour online focus group session to share your insights and experiences with Associates Management Software. -WhatsApp Group Activity: Engage in daily 10-minute discussions on WhatsApp over 5 days. Requirements: Current user of Associates Management Software (examples include): -SAP SuccessFactors -Oracle HCM Cloud -Workday HCM -BambooHR -Namely -ADP Workforce Now -Paycor -Zenefits -Able to commit to the full duration of both activities. -Must have access to WhatsApp. Benefits: Compensation: RM 150 upon completion of both activities. Opportunity to directly influence software development and imp...

I need some help with various classified websites. I need expert who knows various procedure like phone verification for account set up etc.

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

Need a backend developer to implement bel...client's existing code base. 1. Feign clients 2. Request and the response interceptors 3. For opt in, only mobile number to be passed as param to the feign client's method - ("919999784665"); 3. For sending sms, only mobile number and msg to be passed as param to the feign client's method - ("919999784665", "Hey there I am using whatsapp"); 4. All other query params to be inserted via request interceptor 5. userid and password to be picked from yml file, they will be different for different environments. 6. For both the APIs we'll have response interceptors which will check if the 'id' given in 'response' corresponds to one of the error codes. If they do, then we...

...client, I am open to using Angular, React or PHP for the development along with SQL Server/MySQL for the database. Feel free to recommend a platform when you apply. 2. **Essential Modules**: - Building Patient Database (From existing Lab Software - Which will remain as is). This database will be used for Whatsapp , email , SMS Marketing (This also is part of scope) and also For Patient Web App interface. Whatsapp API interfacing will be required for sending and interacting with Patients. - Patient Web App interface to start with - Appointment for Home Collection booking system, payment of charges, and to check all historical reports for his/her tests done at lab and his/her family members. These reports database has to be built from existing lab softw...

I'm looking for a seasoned developer with strong proficiency in Blazor web assembly, API, and SQL Server to build a compact application for invoice billing. The main goal of this application is streamlining my billing process. Key Features: - Invoicing/billing: The platform should facilitate automated creation and delivery of invoices. Ideal Skills: - Familiarity with Blazor web assembly, API, and SQL Server - Experience in creating billing systems - Understanding of financial processes - Excellent attention to detail If you have prior experience in a similar role and you're up for the challenge, I'd like to hear from you.

...authorization mechanisms for secure user access - Work with SQL and NoSQL databases to build efficient data storage and retrieval systems - Collaborate with cross-functional teams to translate requirements into technical solutions - Perform testing, debugging, and optimization of web applications for performance and security - Deploy and maintain applications on cloud platforms like AWS or shared hosting environments Requirements: - Proven experience as a Full Stack Web Developer with a strong portfolio - Proficiency in front-end technologies: HTML5, CSS3, JavaScript (ES6+) - Expertise in React front-end framework - Strong skills in back-end programming languages (Python, PHP, Node.js) - Familiarity with database management systems (SQL and NoSQL) - Knowledge of ...

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $10/script for easier works (like scrap-data transferring between GS&SQL), - Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge o...

As a website owner operating 20 sites predominantly run on PHP Wordpress and AS...strong Dbeaver knowledge to equip me with the necessary credentials and permissions to attach an SQL file to IIS Win 10. As a user who needs help with troubleshooting the "Unable to connect" issue in IIS, the assistance in this matter is crucial. Ideal Skills and Experience: - Extensive experience with Dbeaver and SQL-IIS connections - Previous experiences with WordPress and ASP - Good understanding of PHP 8.3.6 - Ability to troubleshoot and resolve “Unable to Connect” issues in IIS - Ability to provide guidance for verifying and establishing necessary credentials and permissions. Bonus if you happen to have experience in understanding and troubleshooting permiss...

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

I'm looking for a proficient person that can go into links and write emails and phone numbers. There are 15,000 Records to revise. Work needs to start asap and be completed with a good team. This is not a one person job. I need all records completed real time from a file on google drive. Must be complete with 24 hours Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong track recor...

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

I need a C# .NET programmer to integrate UPS API functionalities into an existing .NET website. UPS is switching over from their current API to OAUTH 2.0. Everything works as it should now, but in June the current API will no ...core of the project is implementing UPS API functionalities. You will need to handle package tracking, calculate shipping rates, and create shipments through the UPS API with OAUTH 2.0 Ideally, you should have experience with C# and .NET, as well as UPS API integration. Previous work with this is ideal and would like to see examples. I will provide the Visual Studio project as well as a MS SQL database for you to test with locally. I also have the keys that will be needed from UPS. If you're confident in your ability to handle this project...

I'm on the lookout for a skillful writer, passionate about personal growth and career development. Your task will be to craft a compelling self-help book that provides insightful guidance on advancing in specific career fields. Experience and Skills: - Proficiency in English and content writing - In-depth knowledge of the self-help genre - Familiarity with career advancement strategies - Ability to resonate with readers in specific job sectors The finished project should be a well-structured guide that inspires and equips professionals in their pursuit of a fruitful career. As a writer, your creativity, industry experience, and enthusiasm are vital to the success of this project.

There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style o...

I am making a Django web app that is meant to be a portal to show inspections for their rental property. I am having trouble setting up uploading their inspection and displaying it for the inspected user. I also want help on the frontend. Lastly I want help containerizing it to help me deploy it. I would like a video or a live call where you explain to me all of these things so I can learn it.

I've been experiencing some difficulties with my MS Access database. Error messages appear indicating missing or broken files namely, ‘’ version 7.0 and ‘’ version 1.0. Some occur as soon as I try to open the application. No recent changes have been made to my computer's operating system or the MS Access software. Ideal applicants for this task should be proficient in MS Access, troubleshooting, and database management. You'll need in-depth knowledge of system files and how they might impact the functionality of the application. A knack for solving complex technical problems is also important. In turn, you should be capable of providing a lasting solution to prevent the recurrence of these errors. Cheers!

Need a Windows program that logs into an account, allows the user to enter a 2FA code in a browser window, enters queries into a search from an input XLS file, and on output saves the search status for that query.

I am looking to get this done in two weeks. Please see the included specs and html wireframe layout before bidding. I need someone who is skilled in ASP.NET and experienced with mobile apps. I would rather have the app developed with cross-platform software but it will for now be used in iOS.

I'm seeking a skilled Visual Basic developer to update our existing codebase. The primary goal of this update is to enhance the performance of the application. Ultimately, the application is used primarily by our internal empl...seeking a skilled Visual Basic developer to update our existing codebase. The primary goal of this update is to enhance the performance of the application. Ultimately, the application is used primarily by our internal employees, so ensuring seamless operation is essential. Key Responsibilities: - expericence of Visual Basic Development - Implementing upgrade - have Visual Studio 2022 higer - have MS Sql server Ideal Skills & Experience: - Proficiency in Visual Basic. - Strong experience in code optimization. - Previous work on internal-facing appl...

Hi Do you have experience with both mulesoft and salesforce? It iş sql and salesforce integration using mulesoft For now my task is to solve this error so let see how many hours it takes us and for the new project we will discuss the time per week I need indian time tomorrow morning 7:30 am This support will be on zoom meeting which we will provide u and u will connect with my consultant for support

I am seeking a talented developer who specializes in BioTime database development. The database will primarily be used as an attendance system for my staff. Key Functionalities: - Data Entry and Retrieval: You will implement mechanisms to input and retrieve staff attendance records. Data to be Managed: - Staff Attendance Records: The system should capture and store staff's check-in times, check-out times, and leave entries. Ideal Skills and Experience: - Proficiency in working with BioTime databases. - Demonstrable experience in building data entry and retrieval functionalities. - Prior projects dealing with attendance systems or related fields will be a significant plus.

I am actively seeking an API development expert, specifically for SSO and SAML integration. Let's dive into what I am specifically envisioning for this project: - Proficiency: I will need someone who is familiar with SSO, SAML, React, Node.js and SQL. Your past experience in similar projects will be highly valuable. - Functionality: A primary objective for this task is to develop an API that has Single Sign-On (SSO) and Security Assertion Markup Language (SAML) functionality. - Purpose: The purpose of the API development is to integrate SSO and SAML for user authentication in my system. Maintaining security, ease of use, and adaptability is crucial. In conclusion, your task primarily revolves around strengthening authentication methods via respective API development.

I have a small FileMaker Pro 12 database that requires a conversion to an SQL-based database. The structure is to largely remain the same, but there are some minor issues that need rectification. Details: - The conversion task requires no major changes to the original data structure. - However, some calculation errors need fixing. Therefore, you'll need a keen eye for identifying and rectifying them. Skills & Experience Required: - Experience with FileMaker Pro 12 and SQL databases. - Understanding of database structures and functionalities. - Ability to identify and correct calculation errors. - Great attention to detail. Please ensure that during the conversion process, no data is lost, and the end product works seamlessly. The bid propo...