For i in oracle pl sqlpekerjaan
I am looking for someone to create a POC for a chatbot with Microsoft Bot Framework and C# Main objective. 1. It should connect to a SQL server database and get the order details if the customer asks "Get my order detail" and give the order number 2. Login the customer and identity the correct order, Don't pull anyone else order if not belongs to the customer The POC may extend to an actual project
Being on a quest for a versatile and experienced ASP.net developer, I'm seeking someone who's proficient in various frameworks, specifically ASP.net Core, ASP.net MVC, and ASP.net WebForms. An anticipated task will be functioning on existing projects that are built on these technologies, hence having prior hands-on experience would be highly valuable. Regarding the database, you'll need to be skilled in the use of SQL Server since the projects involve maintaining databases that are based on this platform. On the functionality front, the critical aspect is development. Therefore, you will play a prominent role in strategizing, building and maintaining the overall structure of the projects. Skills and Experience Required: - Practical ex...
We are looking for assistance completing a query comparing in stock and on order raw material and match to it's production demand. SQL 2019
Sila Dafter atau Log masuk untuk melihat butiran.
I'm looking for a freelancer with extensive Node.JS experience to convert a Java-based desktop application into a web app. Key functionalities of the current app include data entry and storage, file management, and reporting/analytics. - Features to Maintain: The web app must retain database integration functionality, besides that the freelancer will also be required for code review and modification. - Database: Our current desktop application uses SQL Lite. The freelancer must have experience working with this database for a seamless transition. This project requires thorough knowledge of Java and Node.JS, database management, and file handling in a web app environment. Additionally, proficiency in executing code review and refactoring is...
Web development: The system should be web-based (ASP.Net) with SQL database, allowing users to access and interact with it through a web browser with responsive design. The application should be working perfectly in mobiles (both small and big screens), tablets, all sizes laptops and TVs from 32 inch to 84 inch screens. - Photo uploads: Users should be able to upload photos to the system, which will be displayed alongside their family information. Uploading is available for all but will not be effected until final approval - Relationship mapping: The system should have the capability to map and display relationships between family members. - Advance search options using all fields. - Send messages / WhatsApp / emails - Member card : when clicking on member image on t...
I'm in need of a C program that will diligently navigate through a folder and all its subfolders to identify and extract given search text from files. The core specifics of the project are as follows: - File Type: The software should be capable to run its search and extract function exclusively on text files formats ( .txt , .sql,.xml ... ) . No need for other formats like Word, PDF etc. - Case Sensitivity: The application must consider "No" case sensitivity while executing text searches. For instance, "Hello" and "hello" should be treated as same. - Output: I am interested in seeing the exact instances of the found text & summary. The output needs to directly display the exact instances where the search text...
The application is developed using Visual Studio with Blazor (C#) and utilizes a SQL Server database. The server infrastructure is already set up on AWS. Now, I am looking for an experienced professional to host my application on the AWS server and take care of all the necessary configurations. This includes setting up IIS, publishing the application, configuring the domain with SSL, and handling other related tasks.
I am looking for an expert with Power BI who is adept at connecting to SQL server databases. The requirement is to clearly compile the user data from these servers into a simple, singular table that reflects an view of all identified sources. What the job entails: - Connect to multiple SQL Server databases - Aggregate the users data into one simple table, it should entail server name, database name, user, role, and user type. Skills and Experience: - Comprehensive experience with SQL Server databases - Proficient in the use of Power BI - Familiarity in compiling data into user-friendly tables - Strong data aggregation skills - Attention to detail, particularly with columns and user information.
I am looking for a skilled .NET developer to create a copilot application for our existing .net application. With the copilot, users of our application should have the ability to ask general questions (e.g., when was the first moon landing), which will ultimately be answered by chatGPT. On the other hand, application-specific questions that require access to our MSSQL database should also be answered. The database has over a million entries. Therefore, the copilot should be able to convert textual questions into SQL queries, send the query, and present the answer from the database in textual form for the user. An example question for this would be: What is the dataset with the biggest total amount? As a third requirement for the Co...
As part of my team, I'm looking to onboard a proficient competitive programmer with expertise in C++ and Java. The selected individual will participate actively in bi-weekly coding rounds, solving problems across a diverse range of topics: - Data Structures and Algorithms - Database related and SQL query problems - Graph theory problems Ideal candidates should have demonstrated experience in these subjects, and a proven track record in coding competitions would be beneficial. Strong command over C++ and Java is mandatory for this role. It's supremely important to have solid problem-solving skills and the ability to work under time constraints. If you can thrive in a competition scenario, I'm eager to bring you on board.
I've uploaded some basic data. It has 2 columns. Column 1 is a Publication Index and column 2 is an authors name. I need a T-SQL query that will create a pivot table that will put the authors names into columns and the PMID's into rows. The xls sheet has the data and the output that I need. I'm posting the question here because I need a faster answer than posting on StackOverFlow. The data will have over 8,000 rows of data and the columns or names will be over 100. My current T-SQL is SELECT TOP (100) PERCENT PMID, AuthoringName FROM dbo.[] GROUP BY PMID, AuthoringName ORDER BY PMID, AuthoringName I'm using MS SQL 2019
...válsztható sablonokat. Ezen lekérdezések megírásához keresünk SQL-ben jártas szakértőt, aki segítene közösen elkészíteni további sablonokat, pl. Teams-es konzultáció keretein belül. Magyar nyelvű kommunikációt preferálunk az egyszerűség és a félreértések elkerülése kedvéért. "You can also modify or add new queries to Data Chart Dashboard components by creating the appropriate SQL Server Script. This can give you more flexibility to control the data that is queried from the ACT! database by the Data Chart. To do this, the file may be edited, which already...
Buongiorno, ho necessità di creare un database personalizzato, con interfaccia molto semplice, per raccogliere le ore di produzione del sito industriale in cui lavoro su tablet, molto semplice (i dati da raccogliere sono ad esempio "Ditta, nome lavoratore, commessa, lavorazione, n°ore"). Servono poi una serie di query altrettanto semplici per estrapolare le ore mensili o per commessa. Valutare assieme l'interazione con il nostro software gestionale Business per il caricamento/Estrapolazione di alcuni dati. Per favore, avrei bisogno di interlocutori Italiani per problemi linguistici.
Project Description: I am looking for a freelancer who can help me copy my SQL Database using the Azure SDK. The ideal candidate should have experience with Azure and be proficient in using the Azure SDK. Requirements: - Copy SQL Database using Azure SDK - No data migration across different Azure subscriptions required Skills and Experience: - Proficient in using Azure SDK - Experience with SQL Database - Familiarity with Azure - Proficient in TDD must write test code along with it
I am seeking an expert Project Manager for a year-long Oracle ERP implementation. The project will encompass three key Oracle ERP modules: Financials, Supply Chain Management, and Human Resources. Essential Skills and Requirements: - Expert level experience with Oracle ERP system - Previous experience in deploying all three Oracle ERP modules - Ability to meet project deadlines, aiming for a completion date of 1 year - Exceptional organizational and leadership skills 10+ years of IT experience in handling Oracle fusion projects end-to-end implementation. -Well-versed with project planning, execution, & completion of large-scale complex projects. -Expertise in establishing common goals across multiple teams. ...
I'm looking for someone proficient in Oracle Apex Development to create an application focused on data entry and management. The app will need to handle various types of data including text, numeric, and date and time data. Here are the required functionalities: - Form Submissions: The application should enable effortless entry of different types of data through well-designed forms. - File uploads: The app should allow for right and efficient file uploads, this is imperative for effective data management within the application. The skills and experience needed for this project include: - Oracle Apex: In-depth knowledge of Oracle Apex app development is essential, given the platform we're using for the app...
I am looking for a skilled freelancer who can help me replicate data from our CRM system in Dataverse to Azure SQL in near real time. Here are the specific requirements for the project: Source of the Data: - The data in our Dataverse comes from our CRM system. Data Replication Method: - We prefer to use transactional replication for the data replication process. Data Update Frequency: - We need the data to be updated in Azure SQL in real-time. Required Skills and Experience: - Strong experience with CRM systems and data replication processes. - Proficiency in setting up and configuring transactional replication. - Knowledge of Azure SQL and the ability to seamlessly integrate it with Dataverse. -...
I WILL DELIVER THE SOURCE CODE IN WPF (Visual Studio 2019) OF THE SCREEN DESIGN. The project consists of programming a desktop screen in C# and WPF code from Visual Studio 2019 .NET 6 framework for Windows 10/11 and tables in SQL design fully compatible with SQL Server management studio v 18.7.1. The WPF screen need some minor changes of titles, buttons and position of text boxes. I am going to deliver instructions, changes on design and general details in PowerPoint. Also, images of the SQL tables with their columns fields and descriptions will be sent in the PowerPoint. The deliverable must include the following: 1.- C# and WPF source code 2.- The SQL tables used in the program have to be gener...
...of code written in DAX and needs to be converted into Power Query. The problem: we are trying to use DataMart and build report in powerBi service. To create calculated column, we can only use PowerQury or SQL in the DataMart transformation section. The following code was written in PowerBI desktop using DAX. I need someone who knows very well PowerQuery (M), who can quickly convert the following code from DAX to PowerQuey and be able to copy and paste in PowerBI Service DataMart transformation section my using custom column in Query section of the DataMart. To get paid, the code must work without any problem. Anything between ‘ ’ is the table name, and anything between is the field name. If you are an expert ...
I am looking for a skilled professional to help us with our database backup project. Our sql database is hosted on a physical server in our office, and we need to make backups on specific dates: 1/19, 3/1, and 5/31. Key requirements and ideal skills for this project include: Database Size: - The database is medium-sized, ranging from 1-10 GB. Preferred Backup Method: - We would like to use an external hard drive for the backup. Server Access: - We have physical access to the server. If you have experience with database backups, specifically with medium-sized databases and using external hard drives, we would love to hear from you. Please provide examples of similar projects you have worked on in the past.
We have a working existing Azure Runbook written in PowerShell that is replicating a database and we want that database replicated to a different server. Requires knowledge of Azure SQL, Azure Permissions and PowerShell. All that should be required is to adjust the permissions so it works between instances and change the script for us for the new server. Ongoing part time contract work available for assistance in maintaining our Azure virtual private cloud if this first quick task is completed successfully and you have the additional skills required. Key responsibilities include adjusting permissions within Azure to facilitate seamless communication between instances and modifying the existing PowerShell script to ensure efficient replication on t...
I'm in need of an experienced GLPI developer who can create a plugin specifically targeted at improving workflow automation. Important features for the plugin: - Automated ticket creation: this should be efficient and without lapses. - Task assignment: the plugin should be capable of assigning tasks automatically. - Status updates: regular and automatic updates on the status of tickets and tasks. The ideal freelancer should have solid experience creating plugins for GLPI, a strong understanding of workflow automation, and the ability to translate these requirements into practical solutions. Proficiency in PHP, SQL, and JavaScript is highly desired. Demonstrated experience with similar projects is a plus.
I am looking for an experienced ansible developer who can support Windows, Linux, and ESXi hosts. The project involves implementing ansible for these operating systems, but the complexity of the implementation is not yet determined. The timeline for the project is more than 1 month. Ideal skills and experience: - Strong knowledge and experience with ansible,oracle,sql - Proficiency in working with Windows, Linux, and ESXi hosts - Ability to handle both simple and complex implementations - Excellent problem-solving skills - Good communication and collaboration skills If you have the expertise and experience in ansible development for Windows, Linux, and ESXi hosts, and can handle a project with an undetermined complexity withi...
I am looking for an experienced freelancer to resolve a 500 error on my aws Plesk server. The error is caused by a SQL connection issue, resulting in too many connections. Project Details: - This project is for an existing business. - The resolution of this issue is of immediate urgency, and I need it resolved within 24 hours. - My budget for this project is $10. Skills and Experience: - Proficient in AWS and Plesk server management. - Strong knowledge of SQL and troubleshooting SQL connection issues. - Ability to quickly identify and resolve server errors. - Excellent communication skills to ensure timely updates and resolution. If you have the necessary skills and experience, please provide your proposal for...
...to use an own GPT-model for first level support. What we provide: - virtual server (you tell us about the requirements) - SQL-database with >10.000 support tickets (customer email and our answer) for additional training - FAQ for additional training What you should do: - install a GPT, e.g. LLaMA on our server - provide a script with which we can feed the GPT with our given databases to fine-tune it - provide an API with which we can connect to the GPT and chat What the result should be: - We receive an email from a customer - We send it to the GPT and ask for pre-qualification the department (is it spam, support request, billing issue, ...) - if it is a support case, GPT should provide an answer and/or a matching FAQ-article (based on the knowl...
...Generation Service for Real Estate Objective: Develop a comprehensive, AI-driven solution to identify and score potential real estate leads in India, leveraging modern technologies and data-driven insights. Key Components: Data Collection and Integration: Implement robust data collection mechanisms using Oracle APIs (where available), alongside other industry-standard APIs, to gather data from real estate websites, social media, and government databases. Utilize Oracle Integration Cloud or similar platforms for efficient data integration and management. Data Processing and Analysis: Employ cloud-based AI services, possibly Oracle AI Services or similar, for scalable data processing. Use Oracle Analytics Cloud for advanc...
I need to develop pdf scrapping in django which cN connect to sql database for website
...approach data modeling in Incorta? What are schema objects in Incorta, and how are they used in data modeling? Materialized Views: What are materialized views in Incorta, and why are they important? How do you create and refresh materialized views? Data Integration: How does Incorta integrate with different data sources? Have you worked on connecting Incorta with non-relational data sources? SQL and Query Optimization: How comfortable are you with writing SQL queries in Incorta? What strategies would you use to optimize a slow-performing Incorta query? Security and Governance: How does Incorta handle data security and governance? Can you explain the role of access controls in Incorta? Real-Time Analytics: How does Incorta supp...
Angular Developer with .Net Core and SQL Experience Needed I need monthly hiring on a daily 8-hour basis. Project Overview: - I am seeking an experienced Angular developer with knowledge in .Net and SQL to assist in the development of my application. - The specific functionalities required for the application include user registration and login, data visualization and reporting, as well as e-commerce functionality. - The application should have a modern and sleek look and feel, with clean and minimalist design elements. - The project timeline is flexible, as it depends on the complexity of the requirements and the availability of the developer.
We are looking for a highly skilled and experienced Senior PHP Developer to join our dynamic team on a fully remote basis. The ideal candidate will have a strong background in PHP development, with a proven track record of working on complex web applications. You will be responsible for developing high-quality, scalable, and efficient PHP code for our various projects. Key Responsibilities: Develop and maintain advanced PHP-based web applications. Write clean, maintainable, and efficient code. Collaborate with front-end developers to integrate user-facing elements. Solve complex performance problems and architectural challenges. Implement security and data protection measures. Participate in the entire application lifecycle, focusing on coding and debugg...
...currently facing an urgent need for a specialist who can help us with starting our server from a full backup. Our server operates on a CentOS 7 OS with an Oracle 11g database handling our business data. - Knows Oracle 11g: As our server operates on Oracle 11g, the freelancer will need to have experience with this version in order to successfully restore the database. - Understands CentOS 7: Since our server OS is CentOS 7, the freelancer needs to be well adept in managing this OS. - Experienced in Backup Restoration: The professional should have prior experience in backup restoration. A full understanding of restoring full backups is essential. - Business Data: As our database holds important business data, discretion and profe...
I'm searching for a skilled Power BI Developer with experience in dashboard creation. My focus is on: - Developing a dashboard that effectively displays Key Performance Indicators (KPIs), real-time analytics, and trend analysis graphs. - Incorporating data from Oracle ERP into the dashboard. The person I'm looking for should have a deep understanding of data visualization, reporting, analytics, and most importantly, Power BI dashboard creation. Experience in pulling data from an Oracle ERP system would be a bonus. Efficiency and accuracy are crucial for this project. These requirements are just a foundation, but a polished, comprehensive, and practical dashboard is the end goal.
I am in need of assistance with exporting a MySQL database from SQL Server in a Windows environment. I am looking for a skilled freelancer who has experience with database management and SQL Server. Skills and experience required for this project: - Proficiency in SQL Server and MySQL - Knowledge of database export and import processes - Familiarity with Windows operating system - Experience with SQL Dump file format Project requirements: - Export the entire MySQL database from SQL Server - Ensure all tables and data are included in the export - Use the SQL Dump file format for the exported database Please note that I do not have any specific tables or data that need to be i...
PeopleCode Development / SQL Project Tasks: - Assistance with PeopleCode development and SQL queries - Intermediate level complexity Skills and Experience: - Strong knowledge and experience in PeopleCode development - Proficiency in writing SQL queries - Ability to handle intermediate level tasks efficiently I want to create some loops and conditions to iterate through tables and queries. Deadline: - The tasks need to be completed within 1 day.
I am in immediate need of a proficient API specialist well versed in UKG Pro API for an upcoming project. I need to extract data to an MS SQL database from a customer's UKG Pro system and need some expertise in this area. The specific functionality details are not ironed out, allowing for flexibility in the role - however, the project's main use of UKG Pro API may involve activities such as retrieving employee data, managing time-off requests or generating payroll reports. Ideal Skills: - Exceptional understanding of UKG Pro API - Relevant experience in managing API integrations Availability: I aim to have the project completed within a month, so freelancers who can dedicate significant time over t...
I have an ASP.NET MVC application that I built 6 years ago and I would like to continue building it but I somehow forgot how ASP.NET and SQL Server things work exactly so I need some help. I have the following: -The full folder of the project that I built 6 years ago with all the source files -The MDF and Log files of the DB I need the following: -Attach the DB -Setup a website in IIS and link it with the web application -Test one page in the application to make sure it is working
I'm in need of a developer with intermediate level expertise in DAX development for Power BI. Your tasks would involve: - Creating complex DAX formulas - Optimizing existing DAX formulas It's necessary that you know how to connect to SQL databases in Power BI, as this will be our primary data source. Ideal candidates would already be accustomed to these tasks and would have sufficient experience in similar projects. Let's optimize and enhance our reporting with your DAX skillset!
My Microsoft SQL Server has been giving me syntax errors when I try to execute certain queries. I'm unclear on what exactly the issue might be, but I'm in desperate need of assistance. Hence, I'm looking for someone experienced with SQL and particularly with Microsoft SQL Server. Please note, this assistance is quite urgent: - You should be proficient in Microsoft SQL Server syntax. - You should be able to identify and rectify syntax errors quickly. - If possible, I also wish to understand the cause of these errors to prevent them in the future. - The project needs to be completed as soon as possible.
I am looking for a .Net Developer who has experience in EMV Card Processing with Fiserv. Please do not apply if you do not have experience in this arena Skills and Experience: - Strong proficiency in Node.js and SQL Server - .Net Winform - Card Processing The objective is to be able to process payments via Card Present Transactions (EMV) or swipe. Also be able to create a void to cancel a transaction and To Batch Close. The project needs to be completed within 1 week, so the ideal candidate should be able to work efficiently and meet deadlines.
I require a comprehensive solution that includes website development and apps on iOS, Android and web-based platforms. The primary objective of these developments is to aid in patient registration. - The project will focus on providing digital products and services. For this role, the ideal candidate should have previous experience developing websites and apps for similar purposes. Key Skills and Experience: - Expertise in iOS, Android, and Web-based application development - Experience in creating platforms for digital products and services - Background in healthcare app creation or patient registration systems would be an advantage. This project requires a system that seamlessly integrates with digital and service-based chann...
...podstron) Strona działać będzie w 3 językach (pl, en i ar) z czego: w j. polskim: będą wszystkie powyższe strony ze struktury w j. angielskim: te same co w języku polskim w j. arabskim: tylko strona główna Aktualizacja wyglądu strony na urządzenia mobilne Dodanie osobnej zakładki z interaktywnym cennikiem usług + dodanie cennika równie na podstronach zabiegów Przeniesienie na nową stronę wszystkich treści (teksty, zdjęcia, wpisy blogowe) Przeniesienie treści SEO z poprzedniej strony na nową (w tym m.in. budowa linków, meta tytuły i meta opisy) Dodanie nowej lokalizacji we Wrocławiu i usunięcie pozostałych Dodanie baneru cookie oraz politykę prywatności Zmiana hosting strony z HitMe na LH Pozostałe rzeczy: Optymalizacja strony ...
I am seeking a full stack developer with experience in Java Spring, Angular and React for further work. Current set up We have a small enterprise Java application for a B2B travel OTA (Online Travel agent). The application currently have local database for 2 modules (1) hotels inventory module, (2) agents and subagents module and live API connection with a third party provider). Full stack developer scope of work and future requirement (hourly cost or fixed cost per job) - Maintains current codes, regular checks and fixes of any future bugs - Optimize server/hosting capacity (currently using digital ocean) MY SQL - Support future clients with API connection to the current application - Integrate new modules (transfer module, cruise module, flig...
I am looking for a skilled developer to create a Help Desk Ticketing System using Angular and MVC, with an MS SQL database. The system should be able to handle less than 100 users and needs to be completed within 1 day. Skills and experience required for this project include: - Strong proficiency in Angular and MVC frameworks - Experience in creating ticketing systems or similar applications - Knowledge of MS SQL database management and integration - Ability to work quickly and efficiently to meet the tight deadline
I am looking for a skilled SQL developer who can create a query in Google BigQuery to manipulate data from JSON format. The desired output of the query is to manipulate the data from JSON. Specifically, the data manipulation required is to transform data types. The ideal candidate for this project should have experience with SQL and Google BigQuery. They should be proficient in extracting specific fields and transforming data types from JSON format.
Looking for sql expert who can help me optimise queries.
I am in search of an experienced Oracle Developer to solve beginner level exercises focused on SQL queries and PL/SQL programming. These exercises should foster a solid foundation in these Oracle topics. Requirements: - solve 10-20 exercises each for both SQL queries and PL/SQL programming, totaling in 20-40 exercises - Tailor the exercises towards absolute beginners, ensuring a progressive learning curve - Each exercise should challenge me to think, solve, and code effectively Ideal Skills: - Proficient in Oracle database management - Solid foundation in SQL queries and PL/SQL programming - Experience in creating effective educational materials - ...
Your mission : 1. Comprehensive Web Application Security Assessment 2. Thorough Vulnerability Identification 3. Exploit Simulation and Risk Mitigation 4. Detailed Security Assessment Reports 5. Customized Recommendations for Strengthening Defenses Your abilities : - Bypass Authentication, Code Execution - SQL injection - Security monitoring - XSS (Cross-site scripting) - HTML injection - LFI (Local Life Inclusion) attack - CSRF - Network Security, Backdoors - URL Redirection attack - Host header injection - No Re-direct attack - Brute force attack etc. Certified Ethical Hacker (CEH), Offensive Security Certified Professional (OSCP), or Certified Information Systems Security Professional (CISSP) would be an advantage.
Hello there! I'm searching for a skilled full-stack freelancer, ideally with 8+ years of experience. Key Responsibilities: • You should have experience in full-stack development. • Expertise in React, Node or Java, Javascript, Vue.JS, and SQL/NOSQL is crucial for this position. • Familiarity with managing a project from conception to final product, developing detailed project scopes and drafting technical documents will be beneficial. Additional Requirements: • As the time is of the essence, we need support ASAP. • You have proven experience working remotely, effectively and efficiently. • Ability to work within tight timelines and collaborate with a team is important. Please, submit your project examples and proo...
