Sql add decimal query oracle jobs
...performance of our aggregation pipeline. The focus is on improving the response time and enhancing our capability to handle large volumes of data proficiently. The goal is to reduce response time to under 100 milliseconds without compromising data accuracy or integrity. WE WILL PROVIDE A PYTHON SCRIPT THAT CONTAINS MongoDB AGGREGATION PIPELINE Key Responsibilities: - Review and enhance the query performance - Optimize our large volume data handling - Analyze and understand the existing aggregation pipeline. - Identify potential bottlenecks and areas for optimization. - Implement efficient algorithms and techniques to enhance pipeline performance. - Ensure that the script returns data in less than 100 milliseconds. - Test and validate optimizations to ensure accuracy...
I HAVE c# windows POS project for inventory management with Azure MS SQL database application. there is also WordPress ecommerce website. I want to display the quantity of each Item in the website based on the stock table in database verse wisa Skills & Experience: - Proficiency in C# programming - Experience in developing Windows applications - Good understanding of inventory systems - Proven experience in WordPress integrations, especially in relation to e-commerce platforms - Quick and effective problem-solving capacities. I am looking for a freelancer who could develop this api professionally with attention to timeliness, accuracy, and secrecy. If you meet the described criteria, I encourage you to bid. who have done same work earlier please bid budget $ 50
An existing STL model needs some updates and I would like to have the STL modified and the 3D file More details: What specific changes do you want to make to the STL file? Adding new features What type of new features do you want added to the STL file? Aesthetic designs What type of aesthetic designs are you thinking of incorporating into the STL file? Modern-style design
I'm looking to create a straightforward and minimalist online clothing webstore, complete with a database that's setup in the 3rd normal form. The database needs to be designed to utilize at least 2 PL/SQL commands. While the site will carry a simple, generic design, it won't require any login/signup feature for customers. Some of the essential skills and experience for the job include: - Proficiency in database design, particularly with establishing a database in the 3rd normal form. - Experience with executing PL/SQL commands. - Ability to create a minimalistic and generic web design. - Experience in creating online stores, specifically clothing stores, would immensely be helpful.
I'm in the process of deploying a SQL API Bicep module code on top of an existing ARM template for our business and I'm facing some issues regarding throughput. I'm looking for a professional who can troubleshoot and ensure the successful deployment of our Azure Cosmos DB setup to meet our business needs. Key Responsibilities: - Troubleshoot and resolve throughput related errors in existing Azure Cosmos DB deployment - Integrate the SQL API Bicep module code with the existing ARM template effectively. Ideal Candidate: - Proven experience with Azure Cosmos DB and SQL API deployment. - Adept at troubleshooting and resolving throughput related issues. - Skilled in integrating APIs with existing systems.
I have an Excel file which have some scripting and data to connect to Oracle Database and download some log files and parse them into Excel Sheets. Also it parse the files looking for values and interpret those values in plain English ( read from a sheet) . i need to convert that Excel VBA to create a website using Microsoft IIS on my machine and be able to add more data to parse the files for more interpretations( reading the hex codes and display a new output with the hex code highlighted and next to it the English meaning of those codes.
I'm looking for a skilled C# developer who can help with database integration, specifically using SQL Server. Key Requirements: - Database Integration: You will be expected to integrate SQL Server into our existing C# application. This will involve working with database tables, writing queries, and ensuring data is accurately and securely stored and retrieved. - Experience: I'm looking for someone with a strong background in C# development and a proven track record of successful database integration projects. Ideal Skills: - Strong C# Development skills - Proficient in SQL Server - Experience in database integration - Ability to write efficient and secure queries - Good communication skills This is a great opportunity for a talented C# developer to put th...
I am currently on the lookout for an expert programmer well-versed in Java, Python, C++, and SQL. You main task is to pass live interview including hackerrank challenges instead of me. Key Requirements: - Extensive experience in programming - Robust problem-solving abilities - Strong knowledge of algorithms and data structures - Proficiency in Java, Python, C++, SQL and pertinent tools or technology Please detail your related experience when applying to gauge if your skill set aligns with the demand of this project. Be ready to demonstrate your problem-solving prowess, thorough understanding of algorithms and data structures, and fluency with the specified languages and tools.
...functionality of the application. Key Responsibilities: - Identify the root cause of the pagination issue - Resolve the bug to ensure the pagination system functions correctly - Test the application thoroughly to verify that the issue has been fixed Ideal Skills and Experience: - Proficiency in PHP and Laravel framework - Prior experience with Laravel's built-in pagination - Strong knowledge of Query Builder - Ability to troubleshoot and debug complex issues - Excellent problem-solving and communication skills It's crucial that the freelancer I work with has a keen eye for detail and a track record of successfully resolving similar issues. The individual should also be comfortable with working in a fast-paced, deadline-driven environment. Here is a video that expla...
I am often facing lot os issues while importing data into MS SQL server, there are different type of errors and issues that I cannot keep track of. I need someone to help me geet rid of all these issues once and for all... I should be able to import all types of data using XLS, XLSX, CSV and all others..
I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any. Key requirements include: - Extracting user's name and completed activities. - Differentiating SCORM packages and calculating time spent on them. - Handling users with no completed activities by including them in the results with zero activity count. If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this tas...
...Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...
I need a macOS application developed in Xcode to accompany a Python script. The script currently converts hex values to decimal and saves the output as a .csv file. I now want to package this functionality into a user-friendly, intuitive desktop application. Requirements: - A clean and intuitive UI that complements the script - Dark mode compatibility would be a bonus - The application should support file upload for inputting hex values Ideal Skills: - Proficient in Xcode for macOS development - Experience in integrating Python scripts with UIs - Understanding of file upload functionality in a macOS application
...the page should not lock up permanently or be flagged permanently with frequent use or fast refreshing of the page. INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. (This check intends to find out wallets with pre-mined tokens). Please have this list collapsed to item 2 below when the page first launches). 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No...
...developer to create a Microsoft Word add-in that can perform a variety of operations on PDFs. This add-in should offer: - A SaaS Gateway - A list of relevant PDFs based on the text typed into Word, further improving workflow. - A way to view and preview the searched PDF files directly within Word. - The ability to duplicate and combine selected PDFs into a new PDF. - Additional functionality such as automatically numbering the pdf and renumbering it whenever additional pages are added to the pdf. . This add-in should be compatible with both Windows and Mac operating systems. As far as the look of the add-in, it should match Microsoft Word's theme to maintain consistency and seamless user experience. Ideal applicants should have a proficiency in develo...
I am experiencing issues...database after moving the database file. After reconnecting the queries to the database, all but one tab of file updated okay. One tab is returning errors. The database is accessed through a desktop application. Key Requirements: - Resolve query errors in the database - Ensure the database functions properly within the desktop application - Investigate and fix any potential issues caused by moving the root file The ideal freelancer for this project should have: - Strong expertise in Microsoft Access - Proficiency in database management and query optimization - Experience in troubleshooting database errors - Ability to work with desktop applications Please include in your bid any relevant experience and your approach to troubleshooting and reso...
I'm seeking a proficient AI expert with the unique skill set in Generative AI and MongoDB. My goal is to automate the query generation process in my mongodb database radiating from chat inputs. WHAT TO DO: * Develop a Generative AI that will use chat inputs to automatically generate complex queries. * While we may have a gamut of queries, for now, we need all-encompassing technology that'll serve a broader purpose. I'm operating on a tight deadline, I need this project completed ASAP. If you're versed in AI and comfortable working with MongoDB, let's get in touch. I'm open to discussing any questions you might have about the project.
I'm in need of a diligent and skilled web developer to create a music website from scratch. The ideal candidate should be proficient in HTML, CSS, JavaScript, PHP, and SQL. The website will primarily function as a music streaming platform. Key Features: - Music Player: The platform should allow users to play music seamlessly. - Artist Profiles: Artists should be able to create profiles to share their music. - Event Calendar: An interactive calendar that showcases upcoming music events. - Playlist Creation: Users should be able to create and customize their music playlists. - Personal Dashboard: Users should have a personal space to manage their playlists, follows, etc. - Explore Option: Users should have the ability to explore new music. - Recommendations: Based on user's...
I'm in need of a skilled Oracle consultant to provide ongoing maintenance and troubleshooting for our Oracle Payables, Oracle Receivables, Oracle General Ledger and Purchasing modules. Key Requirements: - Proficient in Oracle E-Business Suite R12 - Extensive experience with Oracle Payables, Receivables, General Ledger and Purchasing modules - Proven track record of providing ongoing maintenance and troubleshooting support Ideal Skills: - Oracle E-Business Suite R12 - Oracle Payables, Oracle Receivables, Oracle General Ledger, Purchasing modules - Troubleshooting and maintenance experience - Strong problem-solving skills
...data is inside a SQL database than we can write queries to narrow our results and ideally path to the exact MP3 file to play. *** I require a specialist to design, build and implement a system to batch import XML data containing specific call recording metadata into a SQL database. The required data points are: - Caller ID - Call duration - Call start time - Internal employee on call Specialists should possess expert knowledge and experience in handling XML and SQL databases, with an ability to read and interpret XML data structure and write necessary SQL queries/scripts. In addition, I need you to provide a script or process to upload future XML files easily and independently going forward. An ideal freelancer for this project would have: - Proficie...
We are going to add a new page in your existing website based on the details provided by you in the document. Along with this we will also change look of testimonial section on home page. We also have to update social media logo icons with latest updates of logos.
Bro, If the entire website needs to be done, then this project's price will differ, but now previous work milestones have been created.
...WPF and MS SQL is crucial for this component. The second is .NET full stack development, which will require the ability to work with ASP.NET, WCF, Web API, WPF, and MS SQL. Key Responsibilities: - Oversee installation and configuration of casino software - Set-up and manage the associated database - Troubleshoot and debug any issues that arise - Integrate the software with existing systems You should be well-versed in all aspects of casino software installation, .NET full-stack development, and have a strong working knowledge of operating systems including Windows, Linux, and macOS. Your debugging skills must be top-notch. Ideal Skills: - Proficient in casino software installation - Thorough understanding of .NET full stack, including ASP.NET, WCF, Web API, WPF and ...
I am in need of a skilled developer who can create a real-time monitoring dashboard using MySQL. The dashboard will primarily be used for real-time monitoring. Key requirements: - Strong experience with MySQL: You should be proficient with MySQL and able to efficiently manage and query a large amount of data. - Dashboard development: You should have prior experience developing real-time monitoring dashboards. - Custom Date Range Report Generation: The dashboard should include the ability to generate custom date range reports. - Data visualization and real-time monitoring: Although the primary purpose of the dashboard is real-time monitoring, a good understanding of data visualization would be beneficial too. If you have prior experience with similar projects and are confident in y...
As an experienced Golang ...performance using your strong proficiency in microservices architecture, concurrent programming, and web development is crucial. While no specific frameworks or libraries were identified, a broad understanding of Golang's ecosystem will be of great advantage. * senior golang developer * who have hands on experience in building scalable and high throughput system * hands on experience in postgres sql * hands on experience in timescale or any similar time series database * minimum of 3 year experience is needed * hands on experience in production deployment and server maintenance is needed * kubernetes experience is added advantage * hands on experience on redis * hands on experience on websockets * hands on experience on horizontal and v...
I need specialist help from a professional who can perform...vulnerabilities: Your primary task will be to discover any possible security loopholes that could undermine the sanctity of our application. - Focus on SQL injections, XSS, and Broken authentication: I'm most concerned about issues relating to SQL injection, Cross-site scripting (XSS), and broken authentication. Detection and detailing of such lapses will be crucial. - Compliance with GDPR: Beyond identifying vulnerabilities, our project needs to adhere to GDPR standards. Your work will, therefore, need to ensure that the application is in line with these requirements. Please, your ability to identify vulnerabilities, familiarity with GDPR, and skill in SQL, XSS, and authentication are the ideal skil...
I need an expert to install and configure Oracle client 23c with and connect to a remote ORACLE server using TOAD Oracle and guide me step by step to do it. Required Skill: - ORACLE 23c - ORACLE Client - TOAD ORACLE
...use a number of updates across different areas, including React components, Python code, SQL queries, and the API. Visit : Key Tasks: - Fix bugs across React components: Ensure the website is free of any functional errors and that user experience is smooth. - Optimize the performance of SQL queries: Enhance the speed and efficiency of data retrieval. - Refine Python code: Ensure the backend of the website is running efficiently and effectively. - Document API: I would like to have a comprehensive platform documentation explaining how the API works and its various endpoints, as well as how external users can interact with it. I'm looking for professionals with expertise in React, Python, SQL, and API development. Your role will be crucial in ensuring the web...
...wia screen sharing) Resource must have Knowledgeable of the ASP.NET framework, Microsoft SQL Server, and design/architectural patterns (e.g., Model-View-Controller (MVC)). Knowledge of web development languages, such as HTML, XML, CSS, JavaScript, and AJAX. Experience with database servers, particularly Microsoft SQL Server 2016 or newer/ In-depth knowledge of the .NET infrastructure Experience with architecture styles/APIs (REST, RPC). Understanding of the Agile methodology. Knowledge of REST and RPC APIs. Strong communication and interpersonal skills with an ability to work well in a team setting. Advanced proficiency in C#, F#, or VB.NET; preferably all three. Highly experienced using Microsoft SQL. Outstanding analytical, problem-solving, and critical thinkin...
I'm looking for a freelancer 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 info...
I'm seeking a skilled developer who can enhance my online fantasy RPG. Key Requirements: - Proficiency in Python, C++, SQL - Experience with MMORPGs is highly preferred - Ability to improve game mechanics, user interface, and backend systems Your role is crucial in enhancing the overall gameplay experience. I'm also open to creative ideas and suggestions to enrich the game's features. This is a great opportunity for those passionate about RPGs and looking for a flexible pay job. If you are excited about this project, apply now!
Course 1: Statistics, Probability and SQL Course 2: Machine Learning and Predictive models with Python Course 3: Apache Spark: ML on Big Data Course 4: Deep Learning and Neural Networks Course 5: Gen AI : GPT, ChatGPT, Transformers, and SAN Network Course 6: Developing with GPT using chatGPT with OpenAI API Course 7: LLM Intuition and Implementation Course 8: Artificial Neural Networks and CNN Course 9: Model Deployment : AWS, S3, and SageMaker Capstone Projects: Class time = 6 am IST from tuesday to saturday
...other analytical services - Data analysis and visualization: Delivering insights through efficient data analysis and visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work with AI/ML algorithms - Exceptional knowledge of AWS services, including S3, Athena, and Glue - Familiarity with GCP storage and Big Query - Competence in using Power Query for data manipulation and transformation Your skills and experiences will play a crucial role in ensuring the successful delivery of this project, so please be sure to highlight your previous work history in similar projects and pl...
I'm looking for a skilled professional to install and configure Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c on a Windows Server 2022. The primary purpose of this installation is managing databases, so the main focus should be on optimal database functionality. Key Tasks: - Installation of Oracle WebLogic Middleware, Oracle Forms and Reports, and Oracle DB 19.3.0c - Configuring Oracle DB with a high availability setup and performance tuning - Setting Windows environment variables for Java files - Copying 3 applications and 3 URLs from another server running Windows Server 2012 Ideal Skills and Experience: - Proven experience with Oracle WebLogic Middleware, Oracle Forms and Reports, and ...
I need a freelancer who can assist me with moving data from Excel to an Oracle database. Responsibilities: - Copy data accurately from Excel to the database - Ensure all data is consistent and properly formatted Ideal Skills and Experience: - Proficiency in Excel - Experience with Oracle databases - Detail-oriented - Proven track record handling data migration tasks
I'm currently working on a mini project that requires an SQL specialist to conduct descriptive analysis on our customer data. Your task will entail: - Understanding and interpreting the data set provided. - Writing SQL code that analyzes essential aspects of the data. - Providing valuable insights regarding customer behavior and trends. Ideal candidate would possess: - Proven experience in SQL and data analysis. - Ability to break down complex data into understandable format. - Strong knowledge in managing and analyzing customer data. Your input will guide our strategies moving forward and help improve our customer relations. Looking forward to working with someone who is detail-oriented, analytical, and able to meet tight deadlines.
I need two new pages incorporated into my existing website, specifically focusing on cocktails. These pages are "Cocktails" and "Selected Cocktail Recipe". "Cocktails" Page: * Information required for this page includes vivid cocktail images and engaging cocktail descriptions. * I already have a Figma outline representing the desired page layout; your role would be to transform this design into a ready-to-upload Wordpress format. * As shown in the Figma, the cocktail images should be displayed in a particular layout. "Selected Cocktail Recipe" Page: * The nature of the content for this page will be communicated later on. The ideal freelancer for this job will have a deep understanding of web design, proficiency with Wordpress, expertise using...
I will do enlisted task. Renovation Brands needs an analytical assistant to support our FP&A department in a variety of tasks. The ideal candidate will have experience with Excel and running/modifying SQL (no need to have experience writing it). Tasks will include things such as downloading data from ERP or SQL, Refreshing files and validating refresh worked, troubleshooting errors in execution, etc.
...framework. - Expertise in cloud technologies and services (AWS, Google Cloud, or Azure). - Knowledge of serverless architectures, containerization, and orchestration technologies like Kubernetes or Docker. - Experience with message queues and event-driven architectures (e.g., RabbitMQ, Apache Kafka). - Familiarity with cloud-based databases and storage services (e.g., AWS RDS, DynamoDB, Google Cloud SQL). - Understanding of best practices for web scraping, including error handling, rate limiting, and IP rotation. - Strong problem-solving skills and ability to optimize application performance. - Excellent communication and collaboration skills. Nice to have: - Experience with PostgreDB and database optimization techniques. - Knowledge of additional programming languages like Pyth...
I'm looking for a skilled developer to create an API using Oracle PL/SQL code specifically for data sending in XML format. I have written code but it give some error. i need to correct it. Key Requirements: - Utilize Oracle PL/SQL features - Develop API for data sending - Data should be sent in XML format Ideal Skills and Experience: - Proficiency in Oracle PL/SQL - Experience in API development - Strong understanding of XML format - Ability to ensure data integrity and security - Good communication skills for clarifying requirements and providing updates on progress.
...members should be able to see the name of their inviter within their account dashboard. ### **Branding and Design** - The system should be minimally branded to align with our existing design guidelines. (reference site is provided9 ### **Developer Skills Needed** - Proficient in WordPress, including plugin and theme development. - Strong experience with PHP, JavaScript, and CSS. - Familiarity with SQL databases. - Ability to implement secure login and data protection features. - Experience with creating user-friendly admin interfaces and drag-and-drop functionality. ### **Deliverables** - Fully functional membership system integrated into the WordPress site. This project is aimed at enhancing user engagement and administrative efficiency. We are looking for a developer who...
We ...starts;Warning Message No3 Additional Features: Dynamic color changes in columns to distinguish between good and bad hours (e.g., light green for good, red for bad). Implementation of warning messages for inauspicious days, triggered if the date coincides with specific Hijri calendar days (3, 5, 13, 16, 21, 24, 25). Technical Specifications: The script can be developed using PHP, Java, JavaScript, or SQL. This is not a project for earn money it is just for a local information project. So Important thing is budget is very low not looking high class developer. I prefer freelancer who needs good review. Please not give me a chat gpt script. Aim of project determine the write time to pray, and prepare Islamic talisman . Indeed everything is create a simple planetary script...
...freelancer is good. We are looking for professional, sincere and dedicated team player who is willing to contribute to larger goals. Domain expertise: Unmanned Ariel Vehicle/ Drones Technical Expertise: Qt, C++, C, SQL Database Skills •A team player with willingness to contribute to larger goals •Eager to learn, research and improvise – problem solver •Want to invent and build to make things better, faster, easier and cost effective. •Effectively articulate technical challenges and solutions •Project Management •Product development and management •Experience with integrating SQL databases. •Strong understanding of domain knowledge is a plus •Profound knowledge of programming languages and platforms like C++, QT/QML etc....
... Below are the specifics of the project: - Programming Languages: Proficiency in JavaScript, PHP, Laravel, and React is essential. A strong understanding of SQL is also needed. - Skills: A comprehensive knowledge of full stack web development is crucial. This includes front-end and back-end technologies, as well as database management. - Frameworks & Libraries: The project will utilise Laravel and React, so experience with these is a must. The main functionalities and features of the application include: - User Authentication: Develop a secure user authentication system for the web application. - Database Integration: Integrate SQL database to store and manage data efficiently. - Payment Gateway: Implement a reliable payment gateway for users to make transactions. E...
I need a customised Google Sheets add-on that connects with the multiple ad account platform APIs to retrieve specific advertising data. Specifically, I'm interested in: - Retrieving all relevant ad related metrics that the APIs provide that will be selected from a menu add on extension for Google Sheets. Project needs completing within 1.5 to 2 months from start date. The aim of the project is to automate the process of fetching these data, reducing manual efforts and time for users. Ideal freelancer should have: - Profound knowledge of Google Sheets Add-ons - Experience with multiple Ad Account APIs - Understanding of Advertising metrics - Ability to deliver a clear, easy-to-use interface within Google Sheets. Success for this project means p...
...system to scrape data from the App Store. The system must collect information about apps based on specified search criteria, such as categories and keywords. References: 2. Main Functional Requirements 2.1 Scraping Features Category or Keyword Selection: Users should be able to choose a category or enter keywords to search for apps. Concurrent Query Execution: The system must support the simultaneous execution of multiple queries. Data Storage: Data on scraped apps must be stored for further access and analysis. 2.2 Data Management Viewing Scraped Data: Users can view a list of apps and detailed information about each app. Data Export: Capability to export data into a CSV file, including: App name App link Release date and last update Support
I'm in need of a skilled developer who is adept in .net SDK and C# to develop an add-in for ArcGIS on the Windows platform. - The key functionality required for this add-in includes data serialization, network communication and database interaction. - Specialized experience in .net SDK and ArcGIS is highly appreciated. - You'd be expected to make this add-in compatible with Windows. Incase you've developed for this platform in the past, kindly highlight so in your proposal. An ideal candidate would be quick to understand requirements and deliver a clean, efficient solution. Looking forward to your bid.
Support required for vue.js, node.js, .NET and sql
