Oracle sql query jobs

Filter

My recent searches
Filter by:
Budget
to
to
to
Type
Skills
Languages
    Job State
    2,000 oracle sql query jobs found, pricing in USD

    ...for the pre and post development area for the roof of 205sqm. 3. Please include calculations demonstrating how the stormwater discharge will be restricted to pre development rates for the 205sqm. Note: The pre development roof area of the existing building is 90sqm pre renovation Engineering for the area has been submitted and was thought to be finalised though they came back with the further query above. Happy to supply all existing calculations and stormwater management plans Thanks for your help!...

    $249 (Avg Bid)
    $249 Avg Bid
    16 bids
    Identity Analytics 6 days left
    VERIFIED

    Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to attached document for b...

    $12 (Avg Bid)
    $12 Avg Bid
    1 bids

    I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.

    $75 (Avg Bid)
    $75 Avg Bid
    32 bids

    ...hours for £10, rent for 3 hours for £15, rent for 4 hours for £20, rent for 5 hours for £25, or rent for 6 hours for £30. Instead, could this be a dropdown. Instead, I would like to replace this with a tick box that users tick to bring their own rifle or leave unticked if they would like to rent a rifle. The system should calculate the price automatically. I will give you a wp-content folder and sql file you can import and work with to make these changes. Simply import these folders in the zip to WP Local, which can be downloaded at or use any other software you choose. The maximum deadline where all files should be handed back by is Friday 24th May 2024 at 23:59 BST....

    $101 (Avg Bid)
    $101 Avg Bid
    49 bids

    ...speech recognition and natural language processing - Experience in developing software compatible with Windows and Mac - Strong understanding of calendar integration and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Inclu...

    $516 (Avg Bid)
    $516 Avg Bid
    17 bids

    A. give users interfaces that would allow them to do the following: 1. Build unlimited number of customized questionnaires, by adding all common form elements, plus Conditional fields. 2 build unlimited customized search/ query screens by adding same common form elements as their questionnaire. 3. Build customized output/ report screens to present search results. B. All of the above are build on a 100% normalized MySql database, which will become the centralized database for all future data collection, search, and report generation for third party or custom made plugins/apps.

    $1000 (Avg Bid)
    $1000 Avg Bid
    1 bids

    I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to link with Quickbooks Online seamlessly, either through Zapier or an SQL database connection. This will allow completed job cards to be sent to Quickbooks for automatic invoice creation. Managers can then authorize on Quickbooks before sending. Key Functionalities: - Creation and Editing of Job Cards: The system should enable the easy creation and editing of job cards through a user-friendly web form by both employees and managers. Employees can then select their name from a drop-down combo box if they have worked on...

    $17 / hr (Avg Bid)
    $17 / hr Avg Bid
    52 bids

    ...APIs, web scraping, and web page reengineering processes to extract information and structure it in the expected format. The system should generate a record of each query made, indicating whether results were obtained, no results were obtained, or if the source was not available. A document detailing all the sources of information from which data should be extracted will be provided. Main Features: 1. Automatic Querying of External Sources: Perform queries to multiple external sources according to the provided specifications. 2. Data Structuring: Process the obtained information and structure it in the required format. 3. Query Log Generation: Create a detailed log of all queries made and their results. 4. Response Handling: Identify and record whether results were obtain...

    $4177 (Avg Bid)
    $4177 Avg Bid
    32 bids
    AI Chatbot Saas 9 days left

    AI Chatbot Saas of existing with only rebranding (colors, logos, fonts etc.) The existing can be found at 7 Days support included after delivery for any query . Duration 5-7 days.

    $7 / hr (Avg Bid)
    $7 / hr Avg Bid
    1 bids

    ...Demonstrated ability to create visually appealing and informative charts and dashboards using tools like Tableau, Power BI, or similar. • Cloud Platforms: In depth experience with major cloud platforms (AWS, Google Cloud, Azure) and database automation. • Bachelor's degree in Computer Science, Data Science, Geography, or related field. • Familiarity with programming languages such as Python, R, or SQL. • Experience with API integrations and data manipulation techniques. • Strong understanding of machine learning and AI concepts, and the ability to integrate predictive models into software applications • Stay up-to-date with the latest industry trends, technologies, and best practices in data engineering, analytics, and AI Additional Desirable S...

    $22 / hr (Avg Bid)
    $22 / hr Avg Bid
    20 bids

    I'm looking for a web scraping expert to help me gather personal profiles, email, and phone numbers from LinkedIn. The data I need should be based on broad search queries. Key Requirements: - Extract specific data: personal profiles, email and phone numbers - Data source: LinkedIn - Search type: Broad search query - Search criteria: Job title or role, Geographic location Ideal Skills: - Proficient in web scraping - Experience extracting data from LinkedIn - Ability to create custom search queries - Prior experience in gathering personal contact information

    $12 (Avg Bid)
    $12 Avg Bid
    25 bids

    This project focuses on configuring an existing high-performance computer to process and query large datasets using the Llama3 (70b) language model. The objective is to enable efficient data handling and querying capabilities on the local system. Configure the existing computer with the following specifications for optimal performance: CPU: Intel Core i7-12700F GPU: Nvidia RTX 3070 Memory: 32GB DDR5 RAM Storage: 1TB SSD Operating System: Windows 11 or Linux Set up and optimize the Llama3 (70b) language model on the local system. Process 2,300MB of data to be optimized for use with the Llama3 model. Develop a user interface or command line utility to facilitate local data queries using the Llama3 model. Deliverables: Con...

    $168 (Avg Bid)
    Featured
    $168 Avg Bid
    26 bids

    ...converters, and Chat GPT. • Design encrypted communication systems for secure email interactions between customers and third parties. • Automate database updates and manage structured databases for different user types. • Collaborate with frontend developers to ensure system consistency and reflect design changes. Requirements: • Profound knowledge of PHP and Laravel framework. • Strong experience with SQL database management, design, and optimization. • Ability to implement APIs and manage external data integrations. • Understanding of encryption and secure communication protocols. • Ability to work in a team and adapt to evolving project requirements. Desired Skills: • Prior experience in the travel industry or similar sectors. &bu...

    $16 / hr (Avg Bid)
    $16 / hr Avg Bid
    166 bids
    next.js setup witn mysql 6 days left
    VERIFIED

    things to be include in that - Register and login option with forget password and reset password with sendinblue email integration - After login redirect to dashboard (empty page, only need to show user name) - If user open login page a...email integration - After login redirect to dashboard (empty page, only need to show user name) - If user open login page and he already login must be redirect to dashboard and wise versa - Profile page -> with image upload Needed basic UI for frontend, we will use boostrap, no other UI lib with mysql must use with proper middleware must be secure way of write the database query need to create from scatch, do not use any ready made template No un-necceeory plugin install Auth must be handle is proper, if requires use redux, no context

    $18 (Avg Bid)
    $18 Avg Bid
    14 bids

    ...will share data to an SQL server. This needs to function within a SAAS environment with subscription per device. Main features include: - Admin and User Modules - Managed subscriptions per device - Real-time data alerts In the Admin Module, the following functionalities should be available: - User Management: Admin can manage and monitor users - Device Permissions: Admin can determine how much data a user can view - Monitor Device Data: Admin can view data from all devices - Payment Module: Ability to process transactions For the User Module, users should be able to: - View specific device data as permitted by the administrator - Receive alerts via data changes - Make payments for their subscriptions The ideal freelancer would have experience with IoT systems, SQL data...

    $386 (Avg Bid)
    $386 Avg Bid
    9 bids
    API Developer 6 days left

    I'm looking for an API developer who can help me with a project. The ideal candidate should be Responsibilities: Design and implement highly flexible, asynchronous, secured and scalable API Build and modify high-performance APIs and programs using C#, .NET Core based on architecture frameworks and guidelines Prepare API Collection and Documentation Co...GraphQL and gRPC is an added advantage Knowledge of Web Services and understanding of service-oriented architecture (SOA) Proficiency with common API development frameworks/tools, including .NET Core 6+, MS Visual Studio, XML, JSON, TFS, GitHub, Postman and IIS Experience in integration of external systems, third-party APIs, payment gateways and cloud services are added advantage Knowledge in MS SQL Server and DB First appro...

    $364 (Avg Bid)
    $364 Avg Bid
    33 bids

    ...You will be primarily responsible for backend development and Database management, but also need to handle some Frontend Development tasks. Key Responsibilities: - Backend Development: You should have a strong understanding of Node.js, and be able to build efficient, scalable, and secure backend systems. - Database Management: Proficiency in database management is crucial. Experience with both SQL and NoSQL databases will be a plus. - Frontend Development: While the primary focus is on backend, you should also have some experience with frontend technologies to assist with the development when needed. Ideal Skills: - Proficient in Node.js - Strong background in Backend Development - Experience with Database Management - Basic understanding of Frontend Development Please note t...

    $332 (Avg Bid)
    $332 Avg Bid
    50 bids

    I'm seeking an adept vb.net coder to design a desktop-based GST billing software that primarily integrates with SQL Server. While there aren't any specific features I've outlined, I'm hoping to work with someone who's knowledgeable about the typical functionalities of GST billing software. This expertise will be critical in shaping the software's development. Critical skills and experience required: - Strong proficiency in vb.net - Familiarity with SQL Server - Previous experience designing billing software - Understanding of GST's impact on invoice generation, tax calculation, and inventory management

    $2 / hr (Avg Bid)
    $2 / hr Avg Bid
    13 bids

    My project requires an experienced Java SpringBoot developer with a strong understanding of Kafka for asynchronous communication. The ideal candidate should also have: - Proficiency in building and managing REST APIs, focusing on CRUD operations - Ability to integrate with external APIs and service data repository calls - Expertise in crafting and handling SQL queries, preparing for moderate traffic and frequent daily queries - Competence in setting up batch schedulers - Proficiency in sending email notifications This project offers an excellent opportunity to apply and enhance your Java SpringBoot and Kafka skills.

    $15 (Avg Bid)
    $15 Avg Bid
    7 bids

    I'm on the lookout for a seasoned professional who can help me set up Womac and JAS 12 forms on Oracle OC RDC, ensuring a seamless integration. Key Responsibilities: - Configure Womac and JAS 12 forms on Oracle OC RDC - Ensure smooth functionality of the forms - Provide recommendations for best practices in utilization Duration of project - 2 days Pay- 8000/-INR

    $143 (Avg Bid)
    $143 Avg Bid
    1 bids

    I am in need of a Programmer who is experienced in Python, Machine Learning , SQL and have working knowledge of full stack development. We need someone who can help us training a LLM coding assistant. You would not be working on coding side of LLM, you would be working mainly on creating conversations for a programming problem to train LLM. Ideal Skills and Experience: - Proven expertise in Python programming and Django framework - Hands-on experience with Scikit-learn library for model training - Demonstrated knowledge and experience in Machine Learning and AI Model Training - Working knowledge of ReactJS & NodeJS If you think that you fulfill above criteria. I would be more than happy to talk to you.

    $91 (Avg Bid)
    $91 Avg Bid
    10 bids

    I am in need of a project manager/scheduler for...Allocation: The application should have the ability to handle resource allocation efficiently. I would like a combination of manual allocation by the project manager and automatic allocation based on availability and skill set. - Budget Tracking: The application should also include a budget tracking feature to ensure that projects remain within defined budgets. It would be ideal if you are familiar with Oracle Primavera 6. Experience with this tool or similar project management applications would be highly beneficial. An additional requirement for this project is the need for Defence Security Clearance. Please only bid on this project if you possess this clearance. This is a 6-month project and can be based in Perth, Adelaide or ...

    $26 / hr (Avg Bid)
    $26 / hr Avg Bid
    16 bids

    I'm seeking a highly skilled fullstack developer who is proficient in PHP, .NET, and especially SQL for diverse web application projects. Your primary role will be equal focus on both front-end and back-end development on multiple platforms, including WordPress and PHP. Mandated Features: * Database Integration - Structuring, optimizing, and ensuring smooth functioning of databases within applications. * API Integration - Implementing third-party APIs comprehensively. Ideal Skills and Experience: * Proficient in PHP, .NET, and SQL. * Strong experience with WordPress. * Proven full-stack capabilities. * Expertise in Database and API integration. * Good problem-solving abilities and attention to detail. We're expecting high quality work with minimal supervision....

    $566 (Avg Bid)
    $566 Avg Bid
    153 bids

    I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.

    $89 (Avg Bid)
    $89 Avg Bid
    40 bids
    Trophy icon Make a Linkedin cover photo for me 3 days left

    ...Credential SKILLS Programming: Python, JavaScript, RUST, Golang, C, C++ Frontend Development: HTML, CSS, JavaScript, ReactJs Responsive design, Cross-browser compatibility Web performance optimization Backend Development: , Flask, RESTful API Microservices, Websockets, OAuth Nginx server management, Kubernetes, Kafka CI/CD integration Databases: RDBMS (MySQL, PostgreSQL) NoSQL (MongoDB) Query optimization, ORM/ODM (SQLAlchemy, Mongoose) Data warehousing, Distributed systems Machine Learning: Deployment Pipelines, Production management Data and Model Pipelines Neural Networks, Deep Learning, Algorithms Applied ML, Network Models Cybersecurity: IDS, SIEM tools, Network Security Linux, Cloud Computing, Cryptography Risk and Incident Management Database security Data Analytics:...

    $11 (Avg Bid)
    $11
    15 entries

    ...will be essential to provide a comprehensive analysis. - Data Visualization & Reporting: Building a robust reporting system will be necessary for clear, concise insights. - Automation & Migration: Implement RPA to automate repetitive tasks and ensure a smooth transition from PowerBI to Tableau. Skills Required: - Proficiency in PowerBI, Tableau, MicroStrategy, Excel, RPA, Data Bricks, Postgres SQL, and Python. - Experience in automating business analytics workflows. - Strong understanding of data cleaning, integration, and visualization. - Proven track record in successful migrations between data visualization platforms. I'm looking for someone who can take ownership of this project and deliver it with high precision and efficiency. A proactive approach to proble...

    $34 (Avg Bid)
    $34 Avg Bid
    11 bids

    I'm in search of a seasoned DevOps consultant with strong expertise in Kafka and Akka. The role centers around the design, implementation, and monitoring of our cloud-based infrastructure on AWS. Strong scala programming skills and experience with Scala frameworks such as Akka. Efficient in designing and developing REST API’s. Experience with SQL and NoSQL databases. Proficiency in software design patterns and principles. Experience with version control tools such as Git. Good understanding of Agile methodologies and a collaborative mindset. Excellent problem- solving and analytical skills. Experience in unit testing (eg. JUnit/ Mockito). Experience in cloud- based environments such as AWS or Azure. Experience with Kafka and Elasticsearch. Experience : 5+ years only

    $2431 (Avg Bid)
    $2431 Avg Bid
    8 bids

    ...must have experience in developing RESTful APIs. You should be able to design and implement API endpoints that are efficient and scalable. - Integrating SQL Databases: In this specific project, we're focusing on SQL databases - MySQL and PostgreSQL. Your expertise in database integration should be strong. You should be able to design database schemas that align with the overall structure of the project and implement effective data retrieval and storage mechanisms. The ideal candidate for this position should have: - Proven experience working with Java Spring Boot - A solid understanding of RESTful API development - Extensive experience with SQL databases, particularly MySQL and PostgreSQL - Strong communication skills, as you'll be required to assist and...

    $90 (Avg Bid)
    $90 Avg Bid
    21 bids

    I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.

    $18 / hr (Avg Bid)
    $18 / hr Avg Bid
    59 bids

    ...accomplish With our team always here to help Ability to communicate and solve exciting tasks will be essential. We all collaborate together closely, work at same time with real time communication very important Experience: 1. PHP and related such as CodeIgniter, Laravel, .. 2. JavaScript and other front end technologies 3. Mobile App Cross Platform is plus for upcoming challenge 4. PostgreSQL, My SQL, etc. Work Requirements: 1. One Dedicated Programmer working on project 2. Agreed upon start finish each day to work at same time as our team 3. In addition to this site time tracker, Live Screen Sharing when paid hourly In your response: 1. Confirm agreed to above work requirements 2. Resume, Skill Listing, Example work 3. What days and times can you work in your time zone ? 4....

    $2 - $8 / hr
    Sealed
    $2 - $8 / hr
    41 bids

    ...seasoned software engineer with specialization in Artificial Intelligence, Machine Learning, MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and comprehensive Microsoft technologies. Preference will be given to candidates in the USA time zone. Key Details: - Main Objective: The main goal of this project is to develop a new software application. - Platforms: The application will be developed for Web, iOS and Android. Ideal Skills & Experience: - Proficient in Artificial Intelligence and Machine Learning with a proven track record in similar projects. - Expertise in MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and Microsoft technologies. - Prior experience in developing cross-platform applications ...

    $25 / hr (Avg Bid)
    $25 / hr Avg Bid
    46 bids

    I'm looking for a professional with a deep understanding of SQL injection to help me identify vulnerabilities in a MySQL database. If you're experienced in this area, I'd be glad to work with you. Key Expectations: - Identify vulnerabilities: Your primary task will be to thoroughly test the database for potential vulnerabilities, considering various injection techniques. - No access: Since I don't have any access to this database, I'm looking for someone who can perform this task remotely. You'll be expected to provide a detailed report on the vulnerabilities identified, so I can address them with my database administrator. - Change database values: Additionally, I'd like you to demonstrate the ability to change database values, as a proof of con...

    $23 (Avg Bid)
    $23 Avg Bid
    12 bids

    ...structures. ......" ] } 1 1 (b) s2/s2 : All the 100 queries. Each query has 2 fields: i. qid: The unique id of the query ii. query: The text of the query Some query entries from the file are: { "qid": "1", "query": "deep learning" }, { "qid": "2", "query": "artificial intelligence" }, { "qid": "3", "query": "information retrieval" }, . . . (c) s2/: The relevance values of research papers for each query is given in this file. The columns are: i. qid: id of the query for which the relevance value is marked ii. docno: document id of the research paper for which the relevance is marked iii. relevanc...

    $61 (Avg Bid)
    $61 Avg Bid
    4 bids

    Google big query - for writing sql queries for the complex data

    $24 / hr (Avg Bid)
    $24 / hr Avg Bid
    25 bids

    Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

    $24 (Avg Bid)
    $24 Avg Bid
    34 bids

    ...functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professional who is not only skilled in Tableau but also understands the importance of user experience in data visualization. Please pr...

    $146 (Avg Bid)
    Local
    $146 Avg Bid
    23 bids

    Are you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualifications: - While we do not have any specific ce...

    $40 (Avg Bid)
    $40 Avg Bid
    8 bids

    I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. ...Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoD...

    $85 (Avg Bid)
    $85 Avg Bid
    42 bids

    ...analyst with expertise in SQL and R to conduct a thorough review and testing of a recently completed data analysis project. The successful candidate will be responsible for evaluating the accuracy and completeness of the work, ensuring all requirements are met, and identifying any potential issues or opportunities for improvement. Responsibilities: Review the SQL queries and R scripts used in the project for accuracy and efficiency. Test the data outputs to ensure they align with the project requirements. Verify that all analysis reports are complete and adhere to the specified guidelines. Provide a detailed report outlining any issues found, confirming requirement fulfillment, and suggesting any potential upgrades or improvements. Requirements: Proven expertise in ...

    $22 (Avg Bid)
    $22 Avg Bid
    11 bids

    ...com/file/LJsytcax2WmStFrLOWBgM6/FitApp?type=design&node-id=3-65&mode=design How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved in a local sql-lite database. Summary: - Create app with Expo 50 and TypeScript; - The data must be saved in a local database. This project is offline, but there must be online synchronization support with the offline-first approach. Save user coins, projects and days complete; - Number of days on screen 2 must be dynamic, according to what is selected by the user; - Create a service wh...

    $168 (Avg Bid)
    $168 Avg Bid
    35 bids

    Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.

    $601 (Avg Bid)
    $601 Avg Bid
    53 bids

    Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') INSERT...

    $23 (Avg Bid)
    $23 Avg Bid
    14 bids

    I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL commands accurate...

    $128 (Avg Bid)
    $128 Avg Bid
    87 bids

    ...balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional portfolio site. Things to be done Load an API data into on premise SQL server database Client will do some data calcution The new data will be available in the database and needs to be show in website with some base UI. Project involves show some other API data on the website as well Need not have a lot of experience in UI design but need experience showing data into a page. Website would look like this --- Odds data should

    $347 (Avg Bid)
    $347 Avg Bid
    202 bids

    We are in need of an Oracle Database Administrator (DBA) who can provide coverage from ~8pm to ~4am PDT for one or two weeks starting May 27th, while a current employee is on vacation. Those hours are somewhat flexible. Ideal candidates should have the following skills and experience: - Proficiency in Oracle database administration for versions 11 through 19 - Must be proficient from the Linux command line - there is *no* OEM for these databases - Will respond to emails & alerts for end-clients - Will Investigate any reported problems during that shift - Must be completely fluent in English It is possible there will be nothing to do during the shifts, but if something comes up, rapid response is required. There may also be a need for weekend coverage, and possible futu...

    $28 / hr (Avg Bid)
    $28 / hr Avg Bid
    24 bids

    ...skilled freelancer who can develop an AI-based search engine tailored towards the customers and employees use for a company. The key features required for this project include: -Natural language processing: Understanding and interpreting human language effectively is crucial. -Relevance ranking: The system should be capable of ranking search results based on their relevance to the search query. -Personalized recommendations: The ultimate goal is to personalize user experience, thus the engine should be capable of generating recommendations based on user behavior and preferences. In terms of data sourcing, the AI engine should primarily draw information from databases. A background in data mining and database management would therefore be advantageous. Proven experien...

    $15772 (Avg Bid)
    $15772 Avg Bid
    75 bids

    ...proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly in automation applications. - Experience working with Websocket and...

    $21 / hr (Avg Bid)
    $21 / hr Avg Bid
    83 bids

    Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in buil...project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed within ...

    $80 (Avg Bid)
    $80 Avg Bid
    14 bids

    I'm in need of an experienced developer who's well-versed in ASP.NET a...well-versed in ASP.NET and VB.NET. The project involves the event pages i need where user can login and acess the event throught calender with specific functionality.. i will share feature to slected one ... Ideal Skills and Experience: - Proficiency in ASP.NET & VB.NET is a must, with a proven track record of projects involving user authentication and database integration. - Strong understanding of SQL Server databases and how to effectively integrate them into a .NET environment. - Experience in implementing user authentication systems that cater to both roles and individual accounts. This project requires a developer who can deliver secure and efficient user authentication and database inte...

    $44 - $103
    Sealed
    $44 - $103
    26 bids