SQL Jobs

Consultor Experto Api WhatsApp Business - Chat Bot Crear flujo de chat bot Estandar Preguntas que consultan informacion en bases de datos oracle y Api - Requerimientos : Español Nativo - Experto en Api Chat Bot WhatsApp Business - Api

I need help with error resolution in my grading system app. The error arises from a SQL query and reads as follows: DB Execute Failed. ERROR: syntax error at or near ")" LINE 4: AND MARKING_PERIOD_ID IN () ^ Failure Notice SELECT STUDENT_ID,GRADE_PERCENT,MARKING_PERIOD_ID,EXAM FROM STUDENT_REPORT_CARD_GRADES WHERE COURSE_PERIOD_ID='3139' AND MARKING_PERIOD_ID IN () SQL query The grading system app is built on PostgreSQL and is hosted on a cloud server. Users access the app through a web browser. I need a freelancer who can resolve this issue quickly and effectively. If your quote is reasonable and you deliver results, we can discuss more work in the future.

My static website is in need of migration from its old host to a new one. The site has been down since the old host transitioned from C Panel to a different format. I have access to the original source material. - Website Size: The website is over 5 GB, so you will need to manage a substantial amount of files and data. - Migration Only: The project is strictly a migration task. There won't be any updates or changes to the website during the process, just a straightforward transfer. Ideal skills for this job include: - Website Migration Expertise: Proven experience in migrating websites, particularly static ones. - Server Management Knowledge: Familiarity with C Panel and other server management tools. - Data Handling Proficiency: Ability to efficiently handle and transfer over 5 GB ...

I'm facing an issue with my MSSQL database. I need direct assistance with data deletion as I'm encountering an error stating that the "log for database is full due to 'active_transaction'". I've been trying to delete data using SQL Server Management Studio (SSMS), but I'm unable to resolve the issue. The size of my database log file is between 1GB to 10GB. I'm looking for an expert in MSSQL with experience in database management and troubleshooting. Please provide assistance as soon as possible. Thank you.

We Python, AWS (Athena, Terraform) and SQL experienced developer to work for 3 to 4 hours a day remotely. We will pay 40-50k per month

I need an expert in DBeaver and SQL who can write reports accessing the InforDataLake. Your main tasks will include: - Extracting information from workorders - Analyzing completion status, time tracking, and cost analysis Skills and experience ideal for this job: - Proficient in SQL and DBeaver - Previous experience with reporting on workorders - Strong analytical skills - Familiarity with InforDataLake is a plus.

I'm looking for a skilled C# developer who can create a summary report from my SQL database. The report should be accessible through a desktop application, and it needs to be presented in tables. Ideal Skills: - Proficiency in C# - Experience with SQL database - Desktop application development - Data visualization and presentation

Create scraper for product data in combination with JTL Interface ‘EAN data generator’ Step 1: EAN is entered/scannable Step 2: Checks whether EAN already exists in JTL/SQL database. If yes, display values and ask whether they should be transferred or newly entered Script 3: Script fetches data from eBay via other providers for products with the same EAN → No data found ‘No data available. Please enter manually’ → Data creation successful Step 3: Transfer to JTL → Create article → With characteristics from step 2 → Transfer of the title Step 4: Classification (e.g. B-goods, defective, new, etc.); special features (free text field) Step 5: ‘Please add photos’ → Camera import Step 6: ‘Import to JTL’ button Ste...

I am looking for a strong Power BI Developer who can use DAX, M Query, Calculated Formulas and more. I need someone who is strong with SQL and has a good understanding of creating custom bespoke visuals, so using TypeScript. This is not a basic entry level position, it's creating bespoke, complicated reports using a varitey of things

Ein Großteil des Geschäfts läuft im eigenen Webshop als klassischer B2C Umsatz. Alle Bestellungen gehen in SAP (Business One) ein, in dem auch die Kundendaten verwaltet werden. Das Problem in der Analyse der Kundendaten stellen die Gastbestellungen dar, die SAP nicht mit den registrierten Kunden matchen kann. Aufgrund verschiedener Faktoren sind leider Deutschkenntnisse erforderlich. Und neben einem NDA muss auch ein AVV unterschrieben werden, da es sich um die Analyse personenbezogener Daten handelt. Genaure Infos bitte in der Word Datei.

I'm seeking an experienced app developer to create a user-friendly application that predicts demand for a specified stock over the upcoming weeks. This is based on user-input parameters: stock ID, number of weeks, and it should also facilitate the download of a CSV file with the forecasted data. Key features: - Display demand forecasts for selected stock - Use exponential smoothing for predictions - Allow user to input stock ID and time frame - Enable CSV file download of forecast data The app will rely on historical sales data associated with the user-inputted stock ID. Ideal skills for this project include: - Proficiency in app development - Experience with demand forecasting models, particularly exponential smoothing - Knowledge of handling and interpreting historical sales dat...

I'm seeking an experienced Snowflake developer to assist with a Execute Immediate block. This needs to execute approximately 100 SELECT queries that are stored in a table column. The results should be stored in a separate table, with each query's result being stored separately. There's no need for data transformation or processing before storage; I want the raw data stored as is. The ideal candidate will have: - Extensive experience with Snowflake and SQL - Proven ability to develop and implement stored procedures - Familiarity with executing multiple queries and handling their results Please note that the data in the table columns is structured as SQL queries.

I'm looking for a professional with substantial experience working with Square, the online POS and Payroll system. The task involves assisting me in transferring data from one Square account to another. Key Responsibilities: - Transfer of various types of data including: - Sales records - Employee payroll - Inventory - Potential assistance with setting up the new Square account after the data transfer (to be determined) Ideal Skills: - Proficient in using Square - Strong data management skills - Experience with setting up Square accounts - Excellent communication skills - Ability to work independently and efficiently Please note, there will be no need for data analysis or reports post-transfer. Your expertise will be primarily focused on the data migration process and pos...

I'm looking for an Oracle APEX expert to modify the invoice page in my application. The changes required include: - Title Modifications: I need the title of the invoice page to be updated when printing the report. The exact text and formatting will be provided, but it should be tailored for printed reports. - Calculation Changes: The total amount calculation needs to be adjusted to apply specific discounts. I will provide the details of these discounts. Ideal freelancer for this project should have: - Extensive experience with Oracle APEX - Strong understanding of invoice page structures and calculations - Good attention to detail for title modifications - Ability to implement specific discount applications into total calculations.

I'm seeking a developer to create a simple CRUD operations API. The API will be built using C Sharp and will interface with a PostgreSQL database. A token-based authentication system will be implemented for securing the API. Ideal Skills: - Proficiency in C Sharp - Experience with PostgreSQL - Understanding of token-based authentication - Knowledge of API development - Familiarity with CRUD operations

I'm seeking a seasoned Data Engineer with SQL and substantial expertise in Azure/ GCP. The ideal candidate will be skilled in Data Warehousing, Data Modeling, and Data Transformation, with experience in both Star and Snowflake Schema design patterns. Key Responsibilities: - Design and implement an Incremental Model in our data warehouse. - Utilize Data Lake for scalable storage and processing. - Transform raw data into insightful business intelligence (BI). Skills & Experience Required: - Proficiency in SQL and Azure is a must. - Extensive knowledge of Data Warehousing and Data Modeling. - Familiarity with both Star and Snowflake Schema. - Experience with Data Transformation processes. - Previous experience working with a Data Lake. Ideal candidates should also have knowledge ...

I'm looking for an expert to migrate my Genexus 17 business application project to Genexus 18. Additionally, the associated MSSQL database needs to be migrated to PostgreSQL. Key Requirements: - Full migration of all project features, including user authentication, data reporting, and API integrations. - Extensive custom code from Genexus 17 project needs to be ported and adapted for Genexus 18. - MSSQL database should be successfully migrated to PostgreSQL without data loss or integrity issues. Ideal Skills: - Deep understanding and experience with Genexus platform, particularly versions 17 and 18. - Strong MSSQL and PostgreSQL database skills. - Proficient in adapting and migrating custom code. - Excellent attention to detail to ensure all features and data are accurately transfer...

I'm looking for a system that primarily focuses on predicting restaurant prices while also recommending restaurants based on user preferences. Key Features: - The system should have the capability of predicting prices at various restaurants. This will greatly assist users in budgeting their meals. - It should also recommend restaurants tailored to individual user preferences. This could include factors like cuisine type, dietary restrictions, and personal taste based on past reviews. Data Sources: - The system will utilize existing restaurant databases as well as user reviews and ratings. Therefore, experience with data mining and machine learning on these types of datasets would be beneficial. - Ideally, the freelancer will have experience with building similar recommendation syst...

I'm looking for an expert who can help me import a database into Kuzu DB. The data is currently in XML files. I don't require any data transformation or cleaning, so the task is simply to import the data as it is. Ideal Skills and Experience: - Proficiency in working with Graph databases - Extensive experience with Kuzu DB - Expertise in handling XML files - Familiarity with data import processes - Attention to detail to ensure a smooth import process

Requisitos: 1- La aplicación tendrá que tener un módulo de accesos (usuario y contraseña) distintivo para filtrar contenido, reservas, tipos de reservas, solicitudes y consultas. Cada personal accederá a sus módulos para consultas o para interacción con la aplicación. 2- Habrá un usuario de administrador, que será el responsable de OF para validar, consultar y asignar las reservas a los usuarios que necesiten las salas y dará el visto bueno a las reservas, adjudicándolas. Un módulo administrador de las salas de VATC y un módulo administrador de Protocolo y las salas de la misma. 3- Habrá usuarios como Protocolo o VAT, responsables de cada uno de sus salas para que puedan consultar o ...

I'm looking for an expert in Microsoft Access and Quality Management Systems to develop a comprehensive database for our factory's quality department. The database should emulate typical, legacy Quality Management Systems, similar to QT9. Key Features: - Document Control: The system should have a robust document control module to manage quality documents, procedures and work instructions. - Audit Management: A module for planning, executing, and tracking audits. - Non-Conformance Tracking: A system to record, track and manage non-conformities. Reporting: The system will need to generate performance metrics reports, so experience in designing efficient reporting systems is crucial. Access: The database should be a desktop application, so experience in developing standalone soft...

I'm looking for an IT trainer based in Sagar, Madhya Pradesh, who can teach SQL, Linux and similar technologies. The ideal candidate will have: - Intermediate level expertise in these topics - Strong experience in conducting hands-on practice sessions The training should be primarily hands-on, focusing on practical applications of the concepts.

I'm in need of an experienced MS SQL Server professional who can help me create a SQL query to add new shortcut keys based on specific rules. Key Requirements: - Understanding of SQL and experience with MS SQL Server. - Ability to create SQL queries that add new shortcut keys to specific tables. - Experience working with SQL schemas, even though the focus on certain elements will be determined later. Your task will include: - Creating a SQL query that adds new shortcut keys to specific tables. - Ensuring the query is efficient and does not disrupt existing database operations. Please include relevant experience in your bid. I look forward to working with you. Schema select id, menutype menuid, name, parent, parentid, shortcutkey from dbo.tbl_shortcutkeys Rules 1. Shortcut key s...

I'm looking for a proficient developer to create a robust RESTful API for my salon application. This API should be compatible with both mobile and web platforms. Core Functionalities: - User Authentication: The API should facilitate secure login and registration processes for different user roles. - Appointment Scheduling: It should manage and streamline booking systems for clients and salon staff. - Service Management: The API must handle various services offered by the salon and their corresponding details. User Roles: The API needs to cater to three user roles efficiently: - Customers: Regular users who will book appointments and select services. - Salon Staff: Employees of the salon who will manage appointments and provide services. - Administrators: Users with overarching contr...

I'm seeking a professional who can create a dynamic pivot report using MSSQL 2005. The report will be called in VB 2008 and printed using Crystal Reports. Key Requirements: - The main purpose of the report is for data analysis, specifically in a tabular layout style. - The MSSQL 2005 stored procedure will need to pull data from multiple tables. - Experience with VB 2008 and Crystal Reports is crucial. - A deep understanding of MSSQL 2005 and its stored procedures is necessary to create the dynamic pivot report. Your ability to deliver a comprehensive and well-structured report will be key to the success of this project.

I will provide u raw data files and u need to provide me .sql file that we can use to import in our site,

i have a /var/lib/mysql backup of my old server that has 2 database i need someone to make them work on new server the new server will have just mysql all i need is to have those databases table shows when i do SHOW TABLES; work will be on anydesk,only bid if you read my project and did that before

We need function by oracle to generate XML and complete all rocess as per ZATCA phase 2 requirement Oracle Apex . Oracle DB 19c

I'm in need of an experienced MS SQL Server developer who specializes in query optimization. The main focus will be on: - Select queries - Insert/Update/Delete queries - Stored procedures The primary goal is to reduce the execution time of these queries. Ideal skills and experience for this job includes: - Extensive knowledge of MS SQL Server - Proven track record in query optimization - Experience with various types of SQL queries - Ability to understand and improve database performance.

I'm in need of an experienced developer to assist with various API integrations into a few third-party services. Key Responsibilities: - Integrating our systems with Xero, Quickbooks, various Sage services (Sage 1, Sage People 300, Sage 300 (accounts), Sage X 3) using APIs. - Ensuring smooth and efficient data flow between systems. Ideal Skills and Experience: - Proven experience with API integrations. - Familiarity with Xero, Quickbooks, and Sage services is a significant advantage. - Excellent problem-solving skills and attention to detail. - Ability to work independently and meet deadlines.

Dear All, We’re looking for a skilled WordPress developer to revamp the homepage of live website (wordpress, customized) and complete one partially completed work. Existing home-page Functionalities: a.1. User's Current location capturing code (GMap API), token expired at the moment. Need to be updated. a.2. SignUp/SignIn functionalities in header, Photo Slider, AJAX in body and certain links in Footer. a.3. AJAX lists the product wherein clicking the product name in listed results, shows description of that particular product. One checkbox and a button with certain functionality is available too, against each product. Note: Website have lot many use cases and functionalities other than mentioned but above are related to home page only which should be functional in target/ne...

I'm seeking a seasoned Oracle Database Administrator with extensive experience in integrating Oracle 19c with Node.js. The database is hosted on Oracle Cloud and the connection is established via the Oracle Database Client. Key responsibilities: - Facilitate seamless connection between Oracle 19c and Node.js - Troubleshoot any connection issues that may arise - Optimize the database for Node.js performance Ideal candidate should have: - Proven experience as an Oracle DBA - Familiarity with Oracle 19c and Oracle Cloud - Proficiency in Node.js - Strong problem-solving skills and attention to detail

I'm looking for an expert in ERP systems, specifically Milltech, who can integrate the OpenAI API into my client’s system. The primary functionality I want to achieve with this integration is Natural Language Processing (NLP) capabilities to help end users easily enter new orders and other basic updating. Requirements: - Expertise in Milltech ERP system or other SQL based ERP - Proficient in OpenAI API integration - Strong understanding of Natural Language Processing - Previous experience with ERP systems and customer data analysis - Ability to create intuitive and accessible querying capabilities within the ERP system This project aims to enhance my ERP system with AI capabilities, making it easier to understand and interact with customer data.

I'm seeking a talented software engineer to create a tablet-based, Android-compatible, In-Vehicle Display Application. This is a unique project, and I require someone with experience in developing utility apps for mobile platforms, specifically Android. The application is basically for an ad-tech startup revolutionising in-vehicle digital advertising. We are developing a platform that delivers interactive, geo-targeted ads to passengers in rideshare vehicles. We’re seeking talented freelancers to help build our MVP. We need a skilled developer to create a tablet-based application that displays ads inside vehicles. The app should: - Display scheduled advertisements (images, videos) based on a provided schedule. - Support interactive features like QR codes and touch interactio...

I'm seeking a skilled web developer to create a contemporary, user-friendly flight booking website. Key functionalities should include: - Search and Book Flights: The core functionality of the site should allow users to easily search for and book flights. - User Account Management: There should be a secure and efficient system for user registration, login, and account management. - Payment Gateway Integration: The site needs to be equipped with a reliable and secure payment gateway for processing transactions. In addition to these primary functionalities, the website should also incorporate the following additional features: - Flight Status Updates: Users should be able to track their flights in real time. - Price Alerts: A system for notifying users when flight prices change would...

I am seeking a professional with expertise in SAP Concur and Oracle Financials for a two-hour, step-by-step training session. The focus of the training will be on data synchronization between the two platforms. Key Requirements: - In-depth knowledge and experience with SAP Concur, with a special emphasis on data synchronization. - Proficiency in Oracle Financials. - Ability to create and deliver a clear, concise, step-by-step training guide. - Excellent communication skills to explain complex concepts in an easy-to-understand manner.

I'm looking for a certified Power BI professional with MS PL300 power BI Data Analyst certification who can train a small team over a 30 day period. The training needs to be at an intermediate level and should focus on Power BI DAX, SQL T-SQL, and report generation. Key Requirements: - Must have MS A300 Power BI certification or can train for the specified exam - Extensive experience in training individuals in Power BI DAX and report generation - Proficiency in Hindi and English - Based in India - Able to provide intermediate-level training to a small group - Able to train on SQL T-SQL Ideal Skills: - Power BI DAX expertise - SQL T-SQL mastery - Report generation proficiency - Excellent communication skills in Hindi and English - Previous experience as a Power BI trainer / BI develo...

I'm in need of a detailed report from my Mysql database, specifically focusing on a pricelist. The report should be generated ad-hoc and include the specific details of product names and their corresponding prices. The report is generated from two parts: CSV text import Linking to URL image link from clients webserver folder. Report result is 9 thumbnail boxes pricelist with fields: URL Link, Description (300 character limit), Price, Stock Number. Each report will return around 80 to 100 pages, to be able to download in PDF format in full colour. Ideal skills for this job include: - Proficiency in Mysql and database management - Experience in data analysis and report generation - Attention to detail to ensure all relevant data is captured - Coding the routine making a user fr...

I'm in need of an expert who can assist me with uploading my SQL database into cPanel using PuTTY and FTP. My requirements include: - Custom Configurations: The SQL database will need some specific settings beyond the default options. This includes setting up a Master-Slave Replication. - Performance Optimization: Although not explicitly mentioned, if you can help with tuning the database for better performance, that would be a plus. The ideal candidate should have extensive experience with SQL database management, cPanel, PuTTY, and FTP. Knowledge about setting up Master-Slave Replication is crucial. Please provide examples of similar projects you have completed.

I am seeking a seasoned freelancer with a strong background in QT QML, Firebase, and SQL. The task involves enhancing an existing application, primarily focusing on improving its database integration. Key Requirements: - Expertise in QT QML for UI enhancements - Proficient in Firebase for real-time database management - Strong SQL skills for data handling - Experience in enhancing database operations, specifically data storage and updates The urgency of this project cannot be overstated. Prompt and effective communication coupled with swift execution will be key to our success.

I am experiencing slow queries on my MSSQL database and I need help identifying the issues. The ideal candidate for this project should have substantial experience with MSSQL, able to analyze the database and pinpoint performance bottlenecks. Skills in both query and index optimization are necessary to enhance the database's speed and efficiency.

Design reports only. I will give a query, and you only have to add fields in specific area. Some code in specific fields. Ex.: 1) Text appear red 2) Text with case

I'm embarking on a library project and need a seasoned freelancer to develop the backend, specifically for a borrowing and returning system. Additionally, I require detailed step-by-step tutorials for the front-end setup. Key Responsibilities: - Develop a robust backend for a borrowing and returning system. - Provide detailed, easy-to-understand tutorials for front-end guidance. Ideal Skills: - Proven experience in backend development. - Prior work with library or similar projects is a plus. - Excellent teaching and communication skills. I'm uncertain about the type of database to use, so I would appreciate your guidance in selecting between SQL-based or NoSQL-based databases. Your expertise will be instrumental in helping me understand the process and making this project a su...

Job Description: We are looking for a freelance database expert to design and implement a MySQL database schema to automate the process of generating customized travel packages for our sales team. This schema will streamline the creation of trip packages for Kerala, varying by duration, place selection, and hotel type, allowing for dynamic PDF generation. Key Responsibilities: Design a relational database schema in MySQL to store details for dynamic travel package generation, including: Destinations (e.g., Kerala) Travel information (travel dates, duration, and number of travelers—adults and children) Place selections and day-wise itineraries (title, distance & duration, night stay, photo, description) Accommodation options (room types, extra beds, CWB, CNB) Vehicle options (veh...

I'm embarking on a library project and need a seasoned freelancer to develop the backend, specifically for a borrowing and returning system. Additionally, I require detailed step-by-step tutorials for the front-end setup. Key Responsibilities: - Develop a robust backend for a borrowing and returning system. - Provide detailed, easy-to-understand tutorials for front-end guidance. Ideal Skills: - Proven experience in backend development. - Prior work with library or similar projects is a plus. - Excellent teaching and communication skills. I'm uncertain about the type of database to use, so I would appreciate your guidance in selecting between SQL-based or NoSQL-based databases. Your expertise will be instrumental in helping me understand the process and making this project a su...

Description: I am looking for a professional developer to create the backend of a ticketing platform. The project involves developing a SQL database for data storage and retrieval, as well as creating a user-friendly web interface and implementing backend functionality with API integration. Key Components: 1. SQL Database Development of a SQL database for efficient data storage and retrieval. 2. UI Design A visually appealing, client-facing web interface that offers an intuitive user experience for browsing. Must ensure the UI is responsive, fast, and easy to navigate. 3. Backend Framework Open to backend frameworks such as Node.js, Django, or Ruby on Rails, with a preference for proficiency in any of these. The backend will manage data flow between the frontend and the database, inclu...

I'm looking for an experienced web developer to create a portfolio website for me. The site should showcase my work in application development. Key requirements: - Design a sleek, professional portfolio site - Include a fully functional Music Player application with features akin to Spotify - A dedicated page in the application for facial emotion detection of the user and recommending song playlist according to their mood - An added parameter that is absent in Spotify or other music player Ideal candidates will have: - A strong background in web development and application development - Experience creating interactive, application-based portfolio sites - A portfolio demonstrating previous work in application development

I'm looking for a skilled PHP and SQL developer who can help me modify the osTicket software to better suit my needs. Key requirements: - Add new features to the PHP code, specifically, custom ticket statuses and advanced reporting tools. - Modify existing tables or fields in the SQL database to support these new features. Ideal skills and experience: - Proficient in PHP and SQL, with previous experience working with osTicket highly desirable. - Proven track record of adding features to software and modifying SQL databases. - Excellent problem-solving skills with the ability to think creatively to deliver the desired functionality. - Strong communication skills to ensure we are aligned on project goals and progress.

I'm in need of an expert who can revive an existing project (Xero Connector). Xero Connector - Acts as a stand alone web service which: 1. Allow customers to auth with Xero and create a connection within the XeroConnector Database. 2. XeroConnector can then process API calls, performing various tasks e.g. create invoice / create contact from our other services. Current API End-Points • CreateContact • CreateInvoice Solution Info: MVC / Visual Studio The project is al already a working solution, and can process api calls however the setup and front end needs some work. Phase 1: 1. Streamline the create connection process allowing any visitor to create a connection if desired. Home / Create Connection / Xero Auth and redirects / Create Connection. 2. Add a swagger page to...

I need to Integrate my Insurance Management System with Nphies Portal. So, i am looking for the experienced one who have done this before. This project requires implementation of specific functionalities: - Claims Submission - Eligibility Check - Authorization Request I have technical specifications ready for this integration, so no need to create documentation from scratch. Ideal candidates for this project should have experience with Nphies, and technical specification interpretation. Kindly bid only who is having experience in Nphies Integration