Database sql query oracle help jobs

I'm looking for a skilled MS Access developer to create a billing and accounting database with a modern, minimalist interface. Key Requirements: - Customizable Reporting: The system should be able to generate a variety of reports on different aspects of the business, such as sales, expenses, and profit margins. These reports should be adaptable for future needs and allow for different levels of detail. - Integration with Existing Systems: The database will need to interact seamlessly with other existing systems and software used by the company, ensuring data consistency and accuracy. - User Permissions and Access Control: The system should have a robust user management system that allows for different access levels and permissions. This will ensure that sensitive financ...

I am looking for a skilled graphic designer to create an effective and eye-catching roll-up banner for my company's booth at a conference. Your design should incorporate the following elements: - Company logo a...- Ability to creatively combine text and graphics to communicate key information. - Experience in designing banners or similar promotional materials. Your understanding of color theory and ability to create a standout design that readily communicates our business offering will be critical for this project. Please incorporate these sentences in the design: Title: Oracle automation and mobility made easy. Subtext: Your Oracle system is complex, your modernization journey doesn’t have to be. Generate API's of your EBS customizations using AuraPlay...

I need assistance with buying a product from a European hosting provider and maintaining the subscription for about a year. Key Responsibilities: - Purchase a hosting subscription from a European provider on my behalf. - Maintain the subscription for the agreed period (approximately a year). Application Requirements: - If possible, please provide examples of your past work in a similar capacity. - The task can only be completed by a European.

...bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project should have: - Extensive experience with...

I'm in need of a skilled web developer highly experienced in both Angular and Javascript. The primary objective for this project is to create a website with a responsive design that aligns with my provided brand guidelines. Key Qualifications: - Proficient in Angular and Javascript - Extensive experience in responsive design - Extensive experience in .Net Core and SQL Responsibilities: - Adhere to design and branding guidelines during web development - Create a website that is user-friendly on all devices. Please ensure to provide examples of past work with responsive web design during your application.

...require("mongodb").MongoClient;” line 2 - Run ‘docker compose up’ to start the code 3 - Fix the code so it does not crash 4 - Demonstrate a working connection between the application and a remote Mongo Atlas database (you will need to create one yourself or point to one). The data does not matter, I just need to see examples of: a) A READ query, b) An UPDATE query, c) A CREATE new record query Error See this file for a description of the error which needs to be fixed - Debugging The application connects to a remote Mongo Atlas database correctly if the code is run outside the container. I’ve developed a simple Mongo connection js file which tests this. The output is shown here -

...applications, with the aim to identify and eradicate any potential vulnerabilities. Key Tasks: - Perform Open Source Intelligence (OSINT) - Port scanning - Man-in-the-middle (MiTM) attack simulation - Focus intensively on injection attacks (SQL, XSS) - Authentication and session management puncturing - Cross-Site Scripting (XSS) evaluation The ideal freelancer will have: - Strong experience in cybersecurity and penetration testing - Excellent knowledge and experience with Linux-based systems - Proven experience in web application security testing - Firm understanding of SQL, XSS and authentication vulnerabilities Your final deliverable will be a complete penetration testing report, detailing vulnerabilities found, their potential impact, and recommended remediation step...

I'm in need of a professional who can help me with installing the Oracle 23c database on my Ubuntu Linux system. Key Skills: - Proficiency in Oracle database installation - Specific experience with Oracle 23c - Strong understanding of Ubuntu Linux The selected candidate should be able to: - Perform a detailed installation of Oracle 23c database (enterprise version) on Ubuntu Linux - Ensure proper configuration to meet the project's requirements - Provide guidance on any post-installation tasks that may be necessary Is there any possibility to install a 23c oracle database enterprise version not free version on docker?

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.

...processes it in Wordpress. The Incremental link makes a POST request to this script containing the data. In the script you see 3 types of actions in a switch: Add (new vehicle) Change (vehicle exists, adjustment is being pushed) Delete (vehicle is deleted) Below is a brief explanation of the three functions involved: add_post Here I build a Wordpress Query containing data from the POST request. Then I run a "wp_inset_post" function with this query. From that Wordpress function you will then receive a "post_id" with which I will add photos to the post. change_post Same as "add_post" but I use the "update_post" function because I already know the post_id. Then I'll delete all the photos from this post and add them again. I do ...

I need a developer to build a PHP app using Google Sheets as a database. I want add a text on a field it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in the sheet, and vice versa. As far...

I'm seeking a skilled Drupal expert to help me to export form submissions from the Drupal website to csv More details will share - Implement a user-friendly CMS system with Drupal - Ensure the system is easy to navigate for non-technical staff - Customise the CMS to suit our business needs Ideal Skills and Experience: - Proficient in Drupal CMS - Prior experience setting up content management systems - Ability to tailor CMS systems to specific business needs - Good communication skills to ensure our team can effectively use the CMS.

...already converted 50-60% to ) and also transfering our .NET to .NET CORE and our MS SQL to PostgreSQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and

I have working telegram bot that send message in plain form. I need it working with HTML message better formatting

...not receive any pre-existing design templates such as Figma, but you may refer to a competitor's website for inspiration. The goal is to build a platform that efficiently categorizes Telegram channels and groups by country and category, facilitating easy navigation. This website will be developed using React, Node.js, and PostgreSQL. It must be fast, secure against common web threats including SQL injections, Cross-Site Scripting, and IDOR's. It should also be optimized for search engines to achieve high visibility online. Key Features of the Website: * Channel and Group Organization: Separate listings for channels and groups, categorized by countries and specific categories. * Search Functionality: Advanced search options allowing users to find channels and groups...

I am looking for a skilled professional who can help with various aspects of data processing, storage and workflow management using Pyspark, SQL, Airflow, S3, Hadoop, and Kubernetes. Key areas of support required include: - Data processing in Pyspark: Assistance with data cleaning and transformation tasks in PySpark. - Querying databases in SQL: Advanced optimization techniques, custom queries and data retrieval. - Workflow management in Airflow: Custom workflow automation and scheduling tasks. - Data storage and manipulation in S3 and Hadoop: Support for large-scale data storage and processing. - Container orchestration in Kubernetes: Assistance with container deployment and scaling. Specifically, the ideal candidate should be able to set up tables on Iceberg in P...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.

I'm in need of a Spark Developer who has a good, intermediate level competence in Scala. Your primary task will include: - Processing and analyzing structured data similar to SQL databases. Given the nature of this project, prior experience with data processing and working with SQL databases would be a huge advantage. While performing machine learning algorithm implementation or real-time data streaming isn't explicitly required, any exposure to these areas would be beneficial.

I'm looking for a skilled ASP .NET web developer to work on a small project. Key requirements: - Fullstack development: The project involves both front-end and back-end development. The ideal candidate should be proficient in C# and ASP .NET. - Database Integration: The project will be using SQL Server, so experience with this database type is needed. Skills required: - Proficiency in C#, ASP .NET, and SQL Server - Experience in fullstack web development - Strong understanding of database integration and management Your role will be to take the project from concept to completion, ensuring that all elements are well-integrated and functioning smoothly. If you are a reliable, detail-oriented developer with a strong track record in ASP .NET web proje...

We are currently facing an urgent requirement for the implementation of Oracle SCM/demand planning modules. We are in search of SCP experts or IT consultancy partner companies with proven experience in SCM/demand planning module implementation in Oracle EBS R12. The scope of work will cover the following aspects within Oracle SCM EB R12: Predictive Analysis based on MRP Demand forecasting for peak and off seasons Demand Sensing Multi-Dimensional Analysis: Analyze demand by product, customer, region, channel, and other relevant dimensions for deeper insights and better decision-making Supply chain integration Forecast accuracy tracking Reporting and Analytics

...learning. Strong analytic skills related to working with unstructured datasets. Experience with big data tools: Hadoop, Spark, Kafka, etc. Experience with data pipeline and workflow management tools. Experience with AWS cloud services: EC2, EMR, RDS, Redshift. Experience with object-oriented/object function scripting languages: Python, Java, Scala, etc. Proficiency in SQL and experience with relational databases, query authoring (SQL) as well as familiarity with a variety of databases. Excellent problem-solving skills and ability to work independently or as part of a team. Strong communication and collaboration skills to effectively work with teams across the organization. What We Offer: Competitive salary and comprehensive benefits package. Opportunities for prof...

...importance of validating user input to prevent common vulnerabilities, such as SQL injection and cross-site scripting (XSS) attacks. 6. Secure Transaction Processing: The application will incorporate secure transaction processing mechanisms to ensure the integrity and confidentiality of financial transactions. This section discusses the implementation of secure communication protocols, such as HTTPS, to protect sensitive data during transit. It also highlights the need for transaction validation and auditing to maintain a transparent and accountable system. 7. Data Encryption and Storage: Sensitive user data, including financial information, will be encrypted and securely stored in the application's database. This section explores encryption techniques and sec...

I have a need for a comprehensive listing of Oracle EBS customers within the manufacturing sector in USA. This is a sizable task as it requires the creation of a list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelancer with a keen unders...

...Start by updating libraries to their latest versions. Consider migrating to a modern framework (React, Angular, Vue.js) for better performance and maintainability in the long run, but weigh the learning curve and development effort. Performance Optimization: Implement code splitting, lazy loading, caching strategies, and image optimization techniques. Tools like Lighthouse or PageSpeed Insights can help you identify areas for improvement. Accessibility Enhancements: Use semantic HTML, provide alternative text for images, and ensure proper keyboard navigation to cater to users with disabilities. Security Measures: Update dependencies regularly, implement secure coding practices, and use HTTPS for data encryption. Testing: Establish automated unit, integration, and end-to-end tests...

I'm seeking an experienced professional to perform a data migration from Oracle to Snowflake.

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm in urgent need of a Python Django developer to help me deploy my old website files on Namecheap. Here's a rundown of the tasks and requirements: - Deploying old website files on Namecheap: I need you to swiftly and effectively set up and configure the database for my project. - No new development or integrations: You won't be tasked with front-end or API work, just the deployment of the existing files. Your experience with Django and database setup are paramount. Time is of the essence, so I need a professional who can work efficiently and effectively.

I'm looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.

I need someone to review my self-help book, providing an honest critique from a reader's perspective. Your review should specifically focus on the book's usefulness: - Evaluate how useful the content is for someone seeking self-help. - Provide constructive feedback on the relevance of the information provided. - Suggest improvements on how the advice can be better implemented. Ideal Skills: - Experience in book reviewing, particularly in the self-help genre. - Excellent analytical skills, able to dissect content and provide valuable insights. - Ability to deliver honest, constructive feedback. Your perspective will help me understand the reader's point of view and improve future editions of the book. BUDGET : MAX 15 EUR. NUMBER OF WORDS YOU...

I am in need of a professional who can help me with my social media marketing campaign, focusing on increasing brand awareness, driving website traffic, and generating leads and sales. The ideal candidate should also have a background in website design and optimization, and be skilled in video editing and graphics design. (open to side contacts as well) Key Responsibilities: - Plan and execute social media marketing strategies to achieve the above-mentioned goals - Re-Design and optimize a business website - Edit engaging video content and graphics for social media (posts & reels) Ideal Skills and Experience: - Proven experience in social media marketing with a focus on brand awareness, website traffic, lead generation, and sales - Proficiency in website design and optimizatio...

I’m seeking a data expert to scrape a specific database and transfer all available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all...

...FlutterFlow. - Data handling: I need to learn how to efficiently handle data within my applications and understand the best practices. I am a veteran PHP SQL developer and I find it difficult to wrap my mind around nosql and mobile app development in general. I am looking for: - An individual with advanced knowledge and experience in FlutterFlow. - Someone who can teach effectively in a one-on-one setting. - A patient mentor who can break down complex ideas into easily digestible concepts. - IMPORTANT: we need to understand each other, so you need to be fluent in ENGLISH I am not looking for general Flutter knowledge but rather need help specifically on the data handling, Firebase rules, state management. Please only apply if you have experience in these areas and are ...

Hi there, I am currently working on a few projects. As a busy professional, I need someone who is capable of creating simple portfolio pages that showcase my projects. On another freelance site, I am having a hard time getting clients and I want you to work with me together to organize the current project files I have and get images of work done, a portfolio title and a description created for my other freelance profile to showcase all kinds of tasks I have done. I have completed over 61 projects and we need all of them organized and input in my g drive. Start date: Today Time: Now Availability: beginner level freelancer someone who is capable and free to get this done.

...to come in and optimize my code for efficiency, particularly in the areas of database queries and load times. Your skills and experience: • You have at least 5 years of experience in Laravel and you're familiar with Laravel 11. • You've previously developed websites using Laravel 11. • Your forte is optimizing code efficiency and database queries. • You have a strong understanding of how to improve page load times and database query speed. Your task: • Optimize my existing codes in Laravel 11, for open source project • Main areas for optimization include database queries and code efficiency • The goal is to achieve faster page load times and improved database query speed. • Test subsc...

Buscamos incorporar especialista programador .net freelance con conocimientos en: c# .net, asp, sql server se valorará experiencia en: integraciones api, en back-end y front-end. Trabajo principalmente en remoto, para colaboración continuada en desarrollos propios de nuestra empresa, con un mínimo de 40 horas mensuales.

Proofreading and editing of 7+ thousand words. I can pay up to $70 - $90 with some bonus for great work. Be available for a short test Please answer the following questions in your bid: => What is your recent academic qualification? => Have you every published your own research article in any Scopus indexed journal? This is a fixed budget project - not an hourly paid gig

I'm in search of a developer experienced in designing mobile apps on the Wix platform. Project details: - The app should include features such as user registration and login, in-app messaging, and payment gateway integration. - The platform is intended for the general public, so it must be user-friendly and intuitive. - I'm seeking a minimalistic and clean design that is simple yet eye-catching. Skills and Experience: - Expert knowledge in Wix mobile app development - Experience in integrating a payment gateway into a mobile app - Proven track record in creating user-friendly apps - A keen eye for clean, minimalistic design Please note, my budget for this project is $3000. Only those with relevant knowledge and experience should apply. Let's create an app that stands ...

As a startup in AI and AI/ML solutions, we are seeking a part time senior data scientist to help us to design a text 2 sql solution using existing open source solution, integrate with other data service. Having a deep understanding of ,LLms , NLP, Text2SQL and AI Agent (OpenAI) , stream-lit will be essential. 3 hours days in average for a part time jobs for months; - The successful applicant must be fluent in Python and have a solid understanding of latest GPTs, GenAI and langchain, GenAI etc The ability to develop and fine-tune algorithms as per project requirements is paramount. If you are able to make AI comprehend and utilize human language, efficiently and effectively, your expertise is needed here.

Hi there, I am currently working on a few projects. As a busy professional, I need someone who is capable of creating simple portfolio pages that showcase my projects. On another freelance site, I am having a hard time getting clients and I want you to work with me together to organize the current project files I have and get images of work done, a portfolio title and a description created for my other freelance profile to showcase all kinds of tasks I have done. I have completed over 61 projects and we need all of them organized and input in my g drive. Payment: 4 AUD Start date: Today Time: Now Availability: beginner level freelancer someone who is capable and free to get this done.

I am in need of an exp...developer to create an interactive, transactional platform with the ability for information sharing, social interaction, and query resolution. This platform should be accessible both as a mobile app and a website, with seamless functionality across Android, iOS, and various web browsers. The ideal candidate for this job would have the following skills and experience: - Expertise in both app and web development, with a portfolio of interactive, transactional sites/apps. - Experience with Android & iOS app development. - Understanding of user experience, particularly in relation to e-commerce and social networking. - Proven problem-solving skills in the area of query resolution. Please provide examples of your work and detail your experience w...

I'm looking for someone experienced in WordPress maintenance. The main issue I'm facing is related to my Gravity Form not submitting. This issue has appeared without any recent changes to the site, and I need it to be resolved urgently. Key requirements: - Identify the issue with the Gravity Form that is preventing submissions. - Fix the issue without causing any downtime to the website. - Ensure all other aspects of the website are still functioning properly after fixing the form. Ideal skills and experience: - Proficient in WordPress maintenance, specifically with addressing Gravity Form issues. - Strong troubleshooting and problem-solving skills. - Ability to work efficiently and effectively to resolve the issue without causing disruption to the site.

I'm eager to find an accomplished Power BI and DAX expert who can help me develop a comprehensive dashboard for data analysis. Key Responsibilities: - Create a data analysis dashboard in Power BI that is user-friendly, visually appealing, and easy to interpret. - Establish reliable connections to SQL databases to pull in the necessary data. - Implement DAX functions and calculations to ensure accurate data analysis. Ideal Candidate: - Previous experience in developing Power BI dashboards for data analysis. - Proficient in working with SQL databases and connecting them to Power BI. - Strong knowledge and understanding of DAX functions and calculations. - Excellent communication skills and ability to work collaboratively. The current data is being updated manual...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I need a Full Stack Developer comfortable with React, Sass, .NetCore, and SQL Server to work on my website, web application, and mobile/desktop app. The primary goal of this project is to develop a responsive, high quality website that also functions as a web application, with the potential for further expansion into mobile and desktop applications. We are looking forward to have a complete Computerized Maintenance Management System (CMMS) / Maintenance Work Order(MWO). A Complete Control Pannel on Web based asapplication along with the Mobile APP + Desktop APP. With the below added features.:- + It will have Website Fully responsive, Mobile APP, Control Pannel Application + It must fully SAAS Based means related to the SAAS Based all the screen to be designed and implemented +...

I have a plain PHP script where users can select teams, but I haven't imported the players yet. I already have SQL queries for this, so they need to be imported and linked to their respective teams. When a user selects League 1 and, for example, Team Feyenoord, they should automatically get access to the players from that league. A league can only start if there is at least one real user active in that league. There are 10 leagues in my database. Nothing should happen if there is no active user linked to a league/team. Now, here's the exciting part. Every match should be generated at 00:00 with certain random variables. So, for example, if a player is in League 1, I want all matches in that league to be generated. I've created an example of how I want to visu...

I'm in need of a skilled developer to create a robust course management database for our educational institution. Key Functionalities: - Student Registration and Enrollment: The database should be able to store and manage student information. - Grades and Transcripts Management: The system should have a feature to track, store, and manage students' grades and transcripts. - Attendance Tracking: The database needs to have a reliable attendance tracking system. - Multiple Courses: The system should be designed to manage multiple courses efficiently. Expectation: - The database should be able to handle 50-100 users accessing it simultaneously. - It needs to be user-friendly, secure, and scalable for future expansion. - Preferably, a responsive design w...

I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus....

...specifics of the data extraction are as follows: - I require product details and price information from the site. - The main task involves capturing a comprehensive car database, including all car brands and models present on the site. The focus here is on the complete car directory, not just specific brands or models. If you have experience in web scraping, particularly in the automotive sector, this project is for you. Accuracy and completeness are key, as the success of the project hinges on the comprehensive nature of the dataset. I attached RAR file (Scraping code). by running this script, fetching yourself full database of cars. pocketbase queries to supoprt filters and run them on pocketbase server side routes, so that they can be used to feed data to views. (...