SQL Jobs

Optimized Solution for Real-Time Display of Liked Articles Here’s a robust and efficient solution to address the challenges of merging and displaying data in real-time without relying on Cloud Functions: --- 1. Database Restructure (Recommended for Scalability) Liked Articles as a Separate Collection: Instead of relying on likedItems as an array in the Users collection, create a dedicated LikedArticles collection. This avoids unnecessary nested querying. LikedArticles Collection Structure: Document ID: Auto-generated or composite key (e.g., userId_articleId). Fields: userId: Reference to the user who liked the article. articleId: Reference to the original article in the Articles collection. modifiedFields: Object storing modified values (e.g., price, description). created...

After migrating to Odoo 17, our Azure hosting cost skyrocketed from $300 to $1,100. I need an expert to analyze our current architecture and provide insights on: - Resource Consumption: Identify which applications (Odoo 17, eCommerce app, Power BI, Distribution app) are using significant resources. - Performance Issues: Odoo is experiencing slow loading times, high CPU usage, and high memory usage. - Cost Analysis: Understand why our costs increased post-migration and how we can reduce them moving forward. - Conduct an in-depth review of current resource allocation across applications and identify inefficiencies. - Analyze and optimize database queries and indexing to reduce Odoo's load times and resource consumption. - Configure auto-scaling policies to automatically adjust resour...

I am looking for a proficient developer who can create an online exam platform using ASP.net and vb.net with a SQL database. The platform should support mixed-form exams, including multiple-choice questions and essay/descriptive questions. Key Requirements: - User Role Support: The platform should cater to three user roles: Student, Instructor, and Administrator. Each role should have its own set of permissions and interfaces. - Exam Features: The exams on this platform should be timed, with randomized questions and providing immediate feedback to the students. Ideal Skills and Experience: - Extensive knowledge and experience in ASP.net and vb.net. - Proficiency in SQL Database management. - Prior experience in developing online exam platforms would be a significant advantage. The platf...

I'm seeking a skilled professional to integrate EDI transactions with my Firebird Database. The transactions include Purchase Orders, Invoices, and Shipping Notices. Key Requirements: - Expert knowledge in EDI transaction handling - Proficiency in Firebird database - Capability for setting up automated data exchange - Implementation of error handling and reporting systems - Skills in mapping data fields between EDI and database There's no need for real-time tracking for this project, but ensuring a seamless and efficient automated data exchange process is essential. You will also be responsible for establishing a robust error handling and reporting system to deal with any discrepancies or issues that may arise during the data exchange. Ideal candidates will have a strong b...

Estoy en busca de un desarrollador que pueda crear un servicio web en SQL Server para consumir datos desde mi tienda en WordPress WooCommerce. Este proyecto tiene como objetivo la integración fluida de datos entre ambas plataformas.

More details: What type of database are you using? Microsoft Access What specifically do you need to edit in the database? Both remove password and add new process What kind of process or function do you want to add? generate Purchase Order from the system i have excel + microsoft access database and current i cant edit the report and want to add procees of PO generation from the quotation . currently no purchase PO option . The new process should integrate seamlessly with existing systems.

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I need a skilled professional to integrate Oracle Fusion's Accounts Receivable module with Zatcka. The primary goal of this integration is to automate the processing of invoices. The system should run in real-time, ensuring immediate processing and reducing manual workload. Key Requirements: - Experience with Oracle Fusion, particularly with the Accounts Receivable module. - Familiarity with Zatcka. - Ability to create a real-time integration system. - Skills in automating invoice processing. The ideal candidate will have a strong background in systems integration and automation, with proven experience in handling Oracle Fusion and Zatcka. The goal is to increase efficiency and accuracy in our invoice processing. Should done 4 project for fusion support for 3 month

I'm encountering an error in my Blazor project that states: "An error was generated for warning '': The model for context 'ApplicationDbContext' has pending changes. Add a new migration before updating the database." The problem seems to be related to database migration. I'm looking for an experienced developer who can help me diagnose the issue and implement a fix. Key Requirements: - Expertise in Blazor and Entity Framework Core - Proven experience in bug fixing related to database migration - Ability to create new migrations if necessary - Good understanding of application configuration and code logic Please note, I'm not sure if I have existing migrations that need to be updated or if new ones need to be created. Therefore, the ideal ca...

I'm seeking a skilled app developer to create a streamlined Android application that will intertwine with our current SQL database. The primary functionalities of the app will be customer and device check-ins. Main Features: -Customer Check-in: -Record new check-ins in our SQL database -Generate and print a ticket for every customer who checks in. This will be a .mrt file that gets printed on a star receipt printer -Device Check-in: -Create new tickets in the database for device check-ins --Generate and print a device tag for the device dropped off. This will be a .mrt file that gets printed on a dymo 450 labelwriter. The ideal freelancer for this project has demonstrable experience in mobile app development, specifically for Android, with strong knowledge of SQL database int...

PERFIL: Especialista en Bases de Datos que hable español. EXPERIENCIA: Desarrollador de Bases de Datos Oracle con experiencia mínima de 5 años. TECNOLOGÍA: PL/SQL TIPO DE CONTRATO: 2 meses DESCRIPCIÓN: - Buscamos una persona autónoma y proactiva, con experiencia comprobable en bases de datos relacionales y en procesos de migración de datos. - Creación de procesos almacenados, y la creación de cursores. - Especialmente en el diseño y desarrollo de soluciones ETL mediante stored procedures. - Sus principales funciones serán: Oracle Database Management. - Experiencia sólida en diseño, desarrollo y optimización de bases de datos Oracle. - Capacidad para escribir y optimizar consultas comple...

Objective: Ensure current month values (e.g., December) appear in both: Weekly categories ("Last week," "Last 2 weeks," "Last 4 weeks"). Monthly category ("Monthly" for the full month, e.g., November). Current Issues: Values for the current month are being categorized only into the weekly categories and not the Monthly category. The Monthly category is showing as blank for the current month because values are excluded due to overlapping with the weekly ranges. We need a solution that ensures data appears in both categories without duplication or conflicts. Approach: Isolate Current Month Data: Create a separate calculation specifically for the current month (e.g., November). Enhance TimeFrame: Ensure it categorizes data correctly for both weekly ra...

I need a skilled developer to create a WebADI solution for uploading quality collection records from an Excel spreadsheet into Oracle EBS tables. This will specifically involve inspection results. Ideal skills and experience: - Proficient in Oracle EBS and WebADI - Experienced in handling Excel spreadsheets - Familiar with quality control data - Able to create efficient data upload solutions - Experience in developing and using APIs for data integration

I need a database constructed. It needs automations…. can be no code or sql… there 4 types of users… staff admin clients staff Town olanner staff DA Manager See notes below:- Clients – only have invited access to onboard themselves…. Site Address Name of Entity Do they own the site or applicant Entity address Mailing Address Entity phone number Entity email Contact person Contact person address Contact person email Contact person phone number Notes: Client Updates (view only) Ability for client to leave notes to updates(triggers email to assigned town planner/da manager and also admin) Staff Admin- Access to change remove delete everything Ability to add/remove clients as above Job assigned to Town planner –...

I am looking for an experienced professional to help with a series of IT tasks related to Microsoft 365 and Azure services. The key deliverables for this project include: Physical AD to M365 Azure AD Connect, Migration & Monitoring: - Set up and configure Azure AD Connect for synchronization with the physical Active Directory (AD). - Migrate users, groups, and policies from the physical AD to Azure AD. - Ensure all currently configured Group Policy Objects (GPOs) are replicated and functioning properly in Azure AD. - Provide ongoing monitoring and reporting. File Server to SharePoint Migration: - Conduct an evaluation of the current physical file server to inventory files and data. Design a SharePoint structure that mirrors the existing file server’s setup and migration plan. -...

I am seeking a seasoned developer to upgrade my SQL based web application. The project involves updating Angular from v12 to the latest version, .NET from V4.7.2 to the latest, and NG2 SignalR to the latest. Key Requirements: - Full stack upgrade: This is not limited to just the frontend (Angular), backend (.NET) or real-time communication (NG2 SignalR); all components need to be upgraded. - Maintaining UI layouts: The user interface layouts in the Angular application are crucial and need to be preserved during the upgrade. Ideal Candidate Skills: - Proficient in C#, .NET, Angular. - Experience with LLBLGen ORM, Formly, ag-grid, and Electron Applications. - Able to adapt and update the tech stack to the latest versions for performance improvement, new feature utilization, and compatibili...

Kami sedang mencari freelancer dari indonesia yang berpengalaman untuk mengajar kursus di bidang Flutter, Data Science, dan Data Analyst. Tujuan utama dari proyek ini adalah untuk memberikan pelatihan berkualitas kepada peserta yang ingin mengembangkan keterampilan mereka di bidang teknologi dan analisis data. Pengajar yang terpilih akan bertanggung jawab untuk merancang materi kursus, memberikan sesi pelatihan, serta memberikan bimbingan praktis kepada peserta. Kualifikasi yang Dibutuhkan: --> Flutter: Pengalaman mendalam dalam pengembangan aplikasi menggunakan Flutter-. --> DataScience: Pengalaman dalam Data Science, termasuk pemahaman yang baik tentang algoritma, statistik, pembelajaran mesin, dan bahasa pemrograman seperti Python. --> Data Analyst: Pengalaman dalam Data Analy...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I need a PHP expert to enhance my current program. It interacts with a MySQL database holding a mixed dataset of both text and numeric data. The program needs to be optimized to return results in under 2 seconds, even with large dataset rows. Key Requirements: - PHP programming expertise - MySQL database management knowledge - Experience with optimizing database structures - Ability to handle mixed data types (text and numbers) - Expertise in creating and optimizing indexes for large MySQL tables. The ideal candidate will be skilled at both PHP programming and MySQL database management. They should also have a proven track record of optimizing database structures and can handle mixed data types efficiently. The goal is to make the PHP program run efficiently and fast. Programmer is to ...

I'm in need of a professional who can build a database for tracking my hourly sales. The project involves: - Using an Excel file that contains data on my inventory of physical products - Creating a system that can generate reports based on this data Ideal candidates should have strong skills in database management and Excel, with a proven track record of creating systems for data analysis and report generation.

I am seeking a data quality expert who has hands-on experience writing custom data quality rules specifically in Collibra from scratch based on provided specifications. The rules to be developed focus on the validity and completeness of the data. Key Requirements: - Design and implementation of data quality rules in Collibra - Focus on both validity and completeness of data - Application of rules to specified data sources: SAP and Cloud based Databases Ideal Skills and Experience: - Extensive experience with Collibra (Specifically, how to write DQ rule logic) - Strong understanding of data quality dimensions, particularly validity and completeness - Proficiency in working with SAP and Cloud based databases - Ability to translate specifications into practical data quality rules - Expert ...

The following features need to be added to an existing web application (you are not required to build the project from scratch, only to implement these additional functionalities). The web application is designed for scheduling client appointments and is built using PHP and SQL. The required features are as follows: 1. Appointment Confirmation via Email Add functionality to send a confirmation email to the user with their appointment details whenever they schedule an appointment. The email should be sent to a preconfigured Mailtrap account, which is already functional. The application already stores client information in the database, so this feature only requires the integration of the email-sending functionality. 2. Admin Control for User Access In the existing admin panel, ...

I'm in need of an Oracle Visual Builder expert who can assist me with a specific task in my application. The task involves: 1. Calling a GET REST endpoint using Action Chains in Oracle Visual Builder. 2. Capturing the response from the REST call. 3. Displaying the response text dynamically on the UI. I find the most challenging aspect of this task is calling the REST endpoint using Action Chains.

I am looking for a skilled software developer to create a bespoke accounting software for me. The software is primarily intended for managing daily service reports. Key features should include: - Generation of financial reports, specifically a profit and loss statement and a fleet management report. - Comprehensive fleet management functionalities such as vehicle tracking, maintenance scheduling and monitoring of fuel consumption. The ideal freelancer for this project should have: - Proven experience in software development, particularly in creating accounting software. - Prior work with fleet management software is a plus. - Strong understanding of financial reporting requirements. The software should be a desktop application. The software should be developed to run on Windows only. T...

More details: What type of project supervision do you need? Technical Supervision What area of technical supervision do you need assistance with? Database Management What specific tasks do you need help with in database management? Data Migration

I'm in need of a Redshift SQL specialist who can assist me with writing intricate queries primarily focused on analytics and ETL processes. This will involve integrating my existing datasets. Ideal Skills: - Proficiency in Redshift SQL - Experience with writing complex queries using redshift Please note, the task will not involve database optimization or data migration.

I'm looking for a skilled professional to help load structured finance data into Azure Fabric, generate insights using co-pilot, and recommend corrective actions based on these insights. Key tasks include: - Loading structured data from SQL databases into Azure Fabric - Using co-pilot to derive prescriptive insights from the data - Recommending corrective actions based on co-pilot's insights Ideal candidates should have: - Proficiency with Azure Fabric and SQL databases - Experience in data analysis within the finance domain - Ability to use co-pilot for generating insights - Strong skills in making data-driven recommendations

hi, i need crud app in asp.net c# and connected to sql server?  login and register site too. without design, simple greetings

I require assistance via AnyDesk to install Akaunting on my Windows PC. - You'll need to help me install Akaunting on prem on my PC using the documentation from the official site: download from here

Description: Collaborate with me on integrating SQL Server and Oracle APIs using SSIS. This project involves setting up a robust ETL pipeline for efficient data management, building a data model for HR and Procurement, and developing an interactive 8 dashboard in Power BI deployed on Power BI Report Server. Tasks: SSIS and SQL Server Integration: Configure SQL Server and SSIS, ensuring a seamless ETL pipeline. Design and execute workflows to extract, transform, and load (ETL) data between sources. Oracle API and Excel Integration: Set up secure Oracle API integration for real-time or scheduled data extraction. Integrate data from Excel files and APIs for HR and Procurement departments. Map and load data into SQL Server, ensuring schema compatibility. Power BI Model Development: Build a...

Bună, Am nevoie de ajutor pentru a construi un sistem automatizat care să mă ajute să colectez și să organizez date din imagini (de exemplu, screenshot-uri) într-o bază de date. Iată ce trebuie să facă acest sistem: 1. Extrage informații din imagini: Am imagini care conțin texte și am nevoie ca aceste texte să fie extrase automat și organizate. 2. Filtrarea datelor: Vreau să pot selecta doar anumite tipuri de informații din aceste texte, pe baza unor filtre stabilite de mine (ex: cuvinte cheie, etichete, categorii). 3. Identificarea și organizarea pattern-urilor: Sistemul trebuie să fie capabil să recunoască anumite tipare repetate în aceste date (de exemplu, combinații de cuvinte sau fraze care apar frecvent). Aș vrea ca aceste pattern-uri să fie salvate separat și organ...

I need a solution to track Solana mempool transactions and store relevant details in a MySQL database. The focus will be on capturing transaction times and fees, transaction payload details, along with sender and receiver addresses. Ideal Skills: - Extensive knowledge in Solana blockchain. - Experience in tracking mempool transactions. - Proficient in MySQL database management. - Understanding of transaction times, fees, payload details, and addresses. Key Requirements: - Design a system that captures and stores the specified transaction data in real-time. - Ensure the MySQL database is structured for efficient data retrieval. - Provide documentation outlining the system's design and operation. This is an exciting opportunity for a blockchain expert with a strong background in dat...

Presupuesto 80 dólares Cuento con un programa de escritorio desasollador en visual studio .Net que genera xml, cuento con certificado digital y claves para poder generar xml, firmarlo y enviarlo a sunat . Utiliza sql server. Xml lo tengo estructurado con los parámetros requeridos por sunat.

school managment system backend with .NET Web API. It was a great learning experience, and I'm proud of what I achieved ⚡ Features: -?️ Design Patterns Using Clean Architecture ,CQRS And Generic Repository. -? Authentication & Authorization - Integration of Multi-Factor Authentication (MFA) to enhance security. - Detailed logging of user activities for auditing and tracking purposes. - Enabling password recovery options such as email-based password resets. - Policies to lock user accounts after multiple failed login attempts. Identity Integration Integrated ASP.NET Core Identity for role-based access control (administrators ,Manager ,Instructor, and students). Secured APIs with JWT (JSON Web Tokens) and JwtBearer middleware JWT Token-Based Authentication Custom passw...

Presupuesto 80 dólares Cuento con un programa de escritorio desasollador en visual studio .Net que genera xml, cuento con certificado digital y claves para poder generar xml, firmarlo y enviarlo a sunat . Utiliza sql server. Xml lo tengo estructurado con los parámetros requeridos por sunat.

I'm in need of a specialist who can assist with authentication, API usage, and data extraction from websites. The primary requirement is to extract text data from the web. This data will be stored in an SQL database. Ideal skills and experience for the job include: - Expertise in web scraping and data extraction - Familiarity with SQL databases - Proficiency in using APIs - Experience with authentication processes - Strong understanding of handling text data Please reach out if you have the necessary skills and experience to fulfill this project.

I'm seeking a pre-built, live demo of a comprehensive, custom-coded PHP NGO management system. It should cater to three user roles: Admin, Staff, and Volunteer, with the Admin solely managing administrative functions. Key Features: - Project and Donor Management: This includes registration, editing, deletion and reporting. - Employee Management: Registration, editing, deletion and reporting, alongside tracking attendance and payroll. - Financial Management: A central transactions module encompassing general ledger accounting, debtor & creditor management, journal entries, payments and receipts, plus bank accounts and reconciliation. - Communication: An integrated chat system. - Project Documentation: File uploads for each project. - Expense Tracking - Year-End Financial Reporting...

I'm in need of a professional to create an advanced, interactive dashboard using MS Business Intelligence tools. This dashboard should cater to a variety of data sources and metrics. Key Requirements: - Connect the dashboard to SQL Database and Excel Sheets - Visualize and display key metrics including Sales data, Financial information and Customer Relationship Management (CRM) data - Incorporate advanced interactivity features, employing drill-down capabilities and interactive graphs Ideal Skills and Experience: - Extensive experience with MS BI tools - Proficiency in SQL and Excel - Prior experience working with sales metrics and financial data - Ability to create user-friendly, interactive dashboards - Strong understanding of CRM data analysis

I've encountered a grave issue with my Microsoft Access database. I accidentally deleted a table and now I'm unable to sign in. This situation is quite urgent and I need a professional who can help me recover my database and restore my access. Ideal Skills: - Proficiency in Microsoft Access - Experience in database recovery - Strong problem-solving skills Please note that I do not have a recent backup of the database, which adds to the urgency of the situation. Your prompt assistance would be greatly appreciated. The database is in Microsoft Access for Microsoft 365 MSO (Version 2401 Build 16.0.17231.20236) 64-bit. The table that you accidentally deleted and its related data fields are crucial for recovery. Remote access has not been set up and will need to be configured. We ...

Migration of Access 2003 ADP Project to a Modern Cloud-Based Solution Description: We are seeking a skilled developer to migrate and modernize an existing Access 2003 ADP application that manages real estate leases and pseudo-accounting functionalities. Current System Details: Database: Hosted on SQL Server 2000, consisting of 43 tables (primarily lookup and accessory tables). Application: Includes 50 forms and 15 reports. Core Application Features: * Real estate lease management: * Entities: landlords, tenants, contracts, periods, payments received. Pseudo-accounting system: * Journal book: Records detailed entries in pseudo double-entry format. * Ledger accounts: Groups, accounts, subaccounts, and vendors. Reports: * Monthly payment details for tenants. * Receipts for payments. * J...

I need an expert to help me set up Employment Hero for my SME with 30-50 staff. Key features to be set up include: - Payroll management - Employee onboarding - Performance reviews - Employee benefits: Configure and manage employee benefits programs. - Compliance management: Ensure compliance with legal and regulatory HR requirements. - Leave management: Enable management of employee leave requests and balances. I have already set up the basics of Employment Hero but need assistance to fully maximize its potential. This includes: - Advanced reporting and analytics - Integration with other tools - Automating workflows Ideal Skills: - Extensive experience with Employment Hero - Knowledge in payroll systems - Expertise in HR processes such as onboarding and performance reviews - Proficient...

I need a database designed primarily for generating quotations. This database should be able to store several types of data, including: - Product details - Client information - Past quotations - Cost - Project timelines - 3 months - Supplier details - Discounts offered The data should be inputted into the database automatically using forms. Ideal skills for this job include: - Database design and development - Understanding of costing and quotation processes - Experience in creating user-friendly input forms Please submit your bid if you have the relevant experience and skills. The database should be developed using MS Excel or accept recomendation.

I am facing an issue when sending emails containing Arabic text from an Oracle 11g database. The Arabic text appears as garbled characters or symbols when the email is received, indicating a problem with character encoding. Problem: Arabic text is not displayed correctly in the received emails. Details: Database: Oracle 11g Current Character Set: AR8MSWIN1256 Attempts to Resolve: Modified NLS_LANG settings Tried using UTF-8 encoding Used UTL_SMTP for sending emails : Please provide your approach to solving this issue and any relevant experience you have. Thank you! Feel free to modify any part of this description to better fit your needs!