Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
...and a staging server for testing. If you have recent experience migrating large ArcGIS apps and can demonstrate it, I’m ready to get started. The ArcGIS Rest API in not reachable to the internet. Please use your own ArcGIS Rest API for testing. Alternatively we can use VPN but need to request time by time for us to standby and provide the token. App version: - PHP 8.5 - Laravel 13 - Vue.js - SQL Server Total page affected is around 80 pages (blade file). Project timeline: 50% by 15th October 2026 100% by 5th November 2026...
...customer information stored in a database, and I need it cleaned, structured, and exported into professional-looking spreadsheets so my team can work with it easily. All of the data is already digital—no paper scanning involved—but the current tables are messy, contain duplicates, and use inconsistent field names. You’ll connect to the database directly (whether it’s MySQL, PostgreSQL, or Microsoft SQL Server—the exact engine can be confirmed once we start) and pull every customer record. From there, I’m expecting: • One master Excel or CSV file with clear, human-readable headers • Removal of duplicates and obvious data entry errors • Consistent formatting for dates, phone numbers, and addresses • A brief log describ...
I'm looking for an experienced data analyst to help with sales performance analysis using our inventory management system data and analyzing planogram data. Key Metrics: - Sales trends - Stock turnover ratio - Profit margins - Best sellers / range review data Ideal Skills and Experience: - Proficiency in data analysis tools (e.g., Excel, Tableau, SQL) - Strong background in retail analytics - Ability to interpret complex data sets - Experience with planogram data analysis - Excellent communication skills for presenting findings Please provide relevant experience in your bids.
I need an experienced Power BI specialist who can dive straight into an urgent KPI dashboard build for our Bedford-based business. The model must pull live and historical data from three different sources—Excel files stored in SharePoint, our on-premise SQL databases, and several Online APIs—and blend them into a single, well-structured data model. The core story the dashboard must tell is operational efficiency: utilisation rates, throughput times, downtime causes, cost per unit, and any other DAX measures you know will help management spot bottlenecks quickly. Alongside that operational narrative I also want space for two high-level sales indicators—total revenue and sales growth rate—so leadership can see in one view how internal performance is affecting ...
...data myself. The project is to turn this database into a professional, searchable football website, including: Player profiles and statistics Club profiles Match results and details Competition pages Search and filtering Responsive desktop/mobile design The website should be designed so additional statistics, records and features can be added later. Experience with , Supabase, PostgreSQL/SQL and database-driven websites is preferred. Sports/statistics website experience would be a bonus. Please include examples of similar work when applying....
I have a sizeable set of sales transactions exported directly from my e-commerce platform and I need a clear, insight-driven ana...shift demand? I would like the final work delivered as: • A cleaned, well-documented dataset (CSV or database table) that I can reuse. • A concise written report highlighting the main findings, supported by visuals. • Interactive dashboards (Tableau, Power BI, or similar) so I can explore the trends myself. • Action-oriented recommendations grounded in the data. Feel free to use Python, R, SQL, or any other analytics stack you prefer, as long as your code is reproducible and clearly commented. Accuracy, clarity, and a storyteller’s approach to the numbers are what matter most—I want to walk away with insights I can...
...**URS → Development → FAT/SAT → IQ/OQ → Validation/Execution** * Ability to prepare complete compliance/validation documentation **Preferred:** * Previous experience with **FBD, RMG, Blender, Compression, Coating or other pharmaceutical equipment** * Experience with industrial automation platforms such as Siemens, Rockwell, Omron, WinCC, Ignition, AVEVA/Wonderware or equivalent * Experience with SQL databases and industrial data historians * Experience implementing secure user management and electronic signatures ### Important We are **not looking for only a software programmer**. We need a person who can take responsibility for the **complete technical and compliance approach**, recommend the appropriate software/platform and licensing, develop the syste...
I’m under a tight 1...I can present straight away. Here’s what I need from you: • A concise yet complete written solution that walks through your data-analysis steps, key findings, and how they inform project-management decisions. • A section explaining how the deployment process should be handled, showing risks, mitigation tactics, and expected outcomes. • Any calculations, charts, or code snippets (Python, R, SQL—use what best proves your point) embedded or linked so I can trace your logic. • A short executive summary I can copy-paste into a slide deck. Accuracy and clarity are paramount; I won’t have time for major revisions. If you can commit to delivering a polished answer set within the next 12 hours, I’m ready to get ...
Hi, I’m a Full Stack Developer with hands-on experience in **, Node.js, TypeScript, SQL, REST APIs, and frontend development**. I understand that you already have the application architecture and need a developer to extend it with a new feature. For this task, I’ll use: * ** + TypeScript** – to build the new responsive frontend page and user selection interface * **React components & hooks** – to manage UI state, user selections, and interactions * **Node.js** – to develop and integrate the backend functionality * **REST APIs** – to save and retrieve the selected user information * **SQL** – to store and manage the data in the existing database structure * **API integration** – to connect the frontend with the Node.js b...
...specifications and make technical recommendations Test and review computer/business applications using RPG technologies Design DB2/400 and SQL databases as required. Coordinate physical changes to databases applying knowledge of database management systems. Work independently in the absence of supervision. Provide training to other IT Developers on any new development created while on staff Position Details Minimum Qualifications: Bachelor’s degree and 5- experiences; or no degree and 9 years combined education and equivalent work experience 5 years’ programming experience 5 years’ experience in RPGIV or RPGILE/400; 5 years using iSeries technologies such as: SQL, CL, SDA, RDA No immigration sponsorship available for this position. Preferred Qualific...
...You will work on a modern web application, developing new features, fixing issues, improving existing functionality, and helping us migrate functionality from a legacy desktop system to the web. ## What You'll Do * Develop and maintain full-stack web applications. * Build and integrate **REST APIs** and backend services. * Develop responsive and user-friendly frontend interfaces. * Work with **SQL Server** databases, including queries, stored procedures, and data relationships. * Integrate frontend, backend, and database functionality. * Investigate and fix bugs across the full application stack. * Work with existing codebases and understand legacy functionality. * Convert existing legacy functionality into modern web-based solutions. * Write clean, maintainable, and well-...
...MySQL schema so data stays perfectly in sync between web and mobile. Deliverables 1. Source code for the PHP portal and the Android app, both ready to compile or deploy. 2. SQL schema and seed data scripts. 3. Brief setup guide and a walkthrough video showing the end-to-end flow for each role. I’ll consider the project complete once I can install the portal on my server, publish the APK to a test device, and verify that logins, listings, profiles, and push notifications all work seamlessly. Web Development Database Management API Development Android PHP Mobile App Development MySQL Java Database Design SQL, Backend Development, Frontend Development, Documentation, Backend Development, Frontend Development, Documentation...
We're building the new web version of our product and are looking for an experienced front end developer to lead and support the rollout. You'll work primarily in React and , building the interfaces our customers use every day. The frontend integrates with a SQL Server database via a C# API — you won't be modifying the API or database directly, but you'll need to understand relational data and work comfortably against existing APIs. WHAT YOU'LL DO - Build and maintain UI features in React / - Consume and integrate with an existing C# REST API - Translate designs and requirements into performant, accessible, responsive interfaces - Write clean, maintainable, well-tested code and participate in code review - Collaborate with the wider team (and any bac...
...Partner/Developer status is preferred, but not required. Candidates without formal certification are encouraged to apply if they have substantial experience developing with the Zoho ecosystem. Relevant experience includes: Zoho Recruit API Zoho CRM API Zoho Books API Zoho OAuth/API authentication Zoho custom modules and fields Zoho record relationships Zoho attachments/files Deluge Supabase PostgreSQL SQL REST APIs Backend development Database migrations ETL/data pipelines Authentication and authorization Production system maintenance Experience with ATS platforms, recruitment systems, HR software, or job portals would also be helpful. When Applying Please include: Your experience working with Zoho Recruit, Zoho CRM, or Zoho One Examples of projects where you worked direct...
I’m committing the next eight weeks to sharpening my SQL and Excel skills and I’d like you to steer the process. I already work comfortably at an intermediate level, but I’m still spending far too long turning raw data into clear, compelling visuals. My goal is to leave this programme able to move from question to insight quickly—writing tidy, well-structured SQL queries and translating the results into polished dashboards and charts inside Excel (and, where it makes sense, Power BI). Here’s how I picture our collaboration: • A structured learning path that steadily raises the bar each week, mixing short theory explanations with hands-on exercises drawn from real business scenarios. • Screen-sharing or paired-coding sessions where y...
I’m a complete beginner to data engineering and want a structured, guided path that quickly gets me comfortable with real-world workflows. My first priority is solid data modeling, but I’d like each concept tied directly to hands-on practice as well as the “why” behind it, so theory and application move together. The stack I need to master is SQL, dbt, Snowflake, and Fivetran. A typical session might start with designing a dimensional model, move into building that model in Snowflake, automate the ELT with Fivetran, and finish by transforming the data with dbt—all committed to Git so best practices stick from day one. I learn fastest by doing, so please be ready to: • Walk through short, focused explanations, then immediately switch to scr...
New offshore India position - *CST hours till 3 PM CST* *### Mandatory Skills* * **MAUI & React Native** * Basic understanding of native/mobile application development * Understanding of common mobile development challenges, platform-specific issues, performance, deployment, and troubleshooting * **Azure & Backend Services** * Azure Functions * Azure Blob Storage * Cosmos DB * SQL Database * Third-party API integrations * Webhooks * Payment gateway integrations * Understanding of integration-related challenges, error handling, retries, security, and scalability * **.NET Core** * Strong understanding of .NET Core * Dependency Injection (DI) * Authentication and Authorization mechanisms * API development and integration * **Node.js** * U...
...actionable visuals in Power BI. The work is squarely focused on visualization and cleaning rather than heavy statistical modeling. Here’s what I need you to handle regularly: • Remove duplicate records across several CSV and SQL sources • Identify and fill (or flag) missing values in a way that keeps our reporting reliable • Spot and correct inconsistencies in field naming, formats, and codes • Build or update interactive Power BI dashboards so stakeholders can explore trends without digging into raw tables Typical deliverables • A cleaned dataset (or SQL view) ready for downstream use • A PBIX file with refreshed visuals, slicers, and KPIs • A brief change log that notes any assumptions or transformations applied A...
Data Analyst Tutor Needed — Intensive 2-Month Program (Python, SQL, Excel, Power BI) Overview I'm looking for an experienced data analyst or data scientist to tutor me through a structured, self-directed curriculum over the next 2 months, with the goal of being fully job-ready and actively applying for Data Analyst roles by the end of the program. I already have a Master's degree in Data Science and have built out a complete week-by-week study plan — I need a tutor to guide me through it, review my work, unblock me when I get stuck, and run mock interviews at the end. This is not a "teach me from scratch with your own materials" role — I have the curriculum already mapped out day by day. I need someone who can teach to that curriculum, adapt i...
...PDF at a time. 2. Azure AI Document Intelligence handles the parsing. If extra text cleanup or disambiguation is required, feel free to chain Azure OpenAI behind it. 3. Your code pinpoints the first instance of the two labels (“from date” / “to date”) and captures the values in ISO format. 4. The result, together with a unique identifier we generate for that file, is inserted into an Azure SQL Database table. I will provide sample PDFs and the target table schema (id, file_name, from_date, to_date, raw_json). Success means each sample lands in the table with correct dates and zero malformed rows. A short README template that recreates the resources round out the hand-off along with a recorded video call walking through the test and architecture. ...
I need an experienced developer to carry out several coordinated upgrades on my existing e-commerce system. 1. PHP Admin Panel The p...pivot tables—should be scripted and documented so I can run them safely on staging and production. 5. after all changes, deployment of the project Deliverables • Updated PHP admin code with tested product-update functionality • Flutter source with refreshed UI screens compiled and ready for Android/iOS release • Working POS ↔ admin panel synchronisation, including error-handling logs • SQL migration scripts and a short deployment guide I’ll provide current source repositories and a sample database dump once we start. Let me know your typical turnaround time for a job of this scope and any clarific...
Hi, I have a project with backend built on node.js, ...built on node.js, frontend on and backend on sql. I have the architecture setup already. I am looking for a developer to integrate some features. If this project goes well, I shall hire them for a longer term. What you need to do is: 1. Understand the architecture and build a page to take the app to next level. 2. I want a page that lists basic options for the user and lets them choose some. 3. The user chooses them and clicks on the button to save the info. 4. Develop relative APIs for the said task. 5. Integrate them on the frontend. It is a fullstack development project. I shall provide the key details of both the projects once we agree on pricing and deliverables. Skills required: 1. Node.js 2. 3. Typescript 4. Sql...
I’m looking for a sharp analyst to turn my raw sales exports into clear, decision-ready insight focused on revenue growth. The data covers online and in-store transactions plus basic customer attributes; it just hasn’t been cleaned or modeled yet. Your mission: • Prepare and cleanse the files so every sale is ...vs. new buyers, average order value, and seasonality. • Visualise the trends in an interactive dashboard (Tableau, Power BI, or similar) and supply a short slide deck that highlights the biggest growth levers and red flags. I’m flexible on time granularity—monthly, quarterly or annual comparisons—so feel free to recommend the breakdown that will surface the clearest story. Accuracy, readable SQL / Python notebooks, and well-labelle...
I have an existing Excel workbook that currently relies on manual submissions. All the figures we need already live in a SQL Server database; they simply have to appear in the correct cells of the form and then trigger the usual calculations and formatting the sheet already performs. Here is what I need from you: connect Excel to SQL Server, pull the required numeric fields, map them to the form’s input range, and set the process to refresh on demand (button or scheduled refresh—whichever is cleaner). The workbook must stay fully functional for colleagues who are not technical, so the solution should run with a single click and require no additional installs beyond standard Office components. VBA, Power Query, or a lightweight Add-in are all acceptable, provide...
...internal documentation/playbooks the team can reference after the engagement ends Requirements: - Demonstrated hands-on experience using Claude (Claude Code, Claude API, or Claude Desktop/IDE integrations) in real production development workflows - Strong understanding of software development practices — our stack is primarily MERN (React, Node.js), AWS services (Lambda, API Gateway, S3, SQS/SNS), SQL/NoSQL databases, and Jenkins CI/CD - Experience with AI-assisted testing strategies (unit, integration, automated test generation) - Prior experience training or mentoring engineering teams (workshops, pairing sessions, or structured onboarding) - Excellent communication skills — able to explain technical concepts clearly to a team with varying AI familiarity - Familiar...
...routing to bring the standalone script onto the public internet Responsibilities:Review our clean code and generate the required cloud infrastructure configuration manifests (such as and a standard startup Procfile).Deploy the microservice architecture live onto a 24/7 cloud server infrastructure framework (such as Render or Railway).Configure the local relational SQL storage tables to maintain data persistence across cloud server the endpoint's response latency to ensure sub-50ms traffic back a verified, fully active public internet API URL gateway Qualifications & Terms:Strong operational background in Python backend environments, FastAPI execution, and cloud hosting architectures (Render, Railway, or similar platform
...dates; and * Active/inactive status. The professional should be able to implement a fixed CSV schema, UTF-8 encoding, mandatory-field validation, code mapping, duplicate detection, import preview, exception reporting, audit logging and reconciliation. ## Security Requirements The applicant should understand: * Secure password storage and authentication; * Role-based access and least privilege; * SQL injection, XSS and CSRF prevention; * Secure session and cookie configuration; * Secure file-upload validation and storage; * Protection of credentials and configuration files; * Server and database-access restrictions; * Security logging and incident handling; * Vulnerability assessment and remediation; * Backup, restoration and rollback; and * Preparation for an independent secu...
...sheets—filled with customer data that must live in Microsoft SQL Server. The columns include typical customer fields (name, contact details, account numbers, dates, notes), but a few calculated columns and drop-down validations make the file slightly more complex than a flat table. What I need from you is a repeatable, fool-proof process that moves every row from the workbook into SQL Server while preserving data types, relationships and any necessary transformations (e.g., date formats, trimming extra spaces, converting text “NULL” to actual NULL). I’m open to whatever tool you prefer—T-SQL scripts, SSIS package, Python + pandas, or a lightweight C# utility—as long as it runs on Windows and I can rerun it whenever new files arri...
...data specialist to take an old-format XLS file and move it into my SQL database after applying several transformations. The raw worksheet contains multiple sheets of mixed data types, so before anything is loaded I’ll need column mapping, type casting, and a few calculated fields added (we can review the exact logic together). Once the transformation rules are approved, please import everything into the live SQL instance and provide: • A repeatable script or ETL package (Python, SSIS, or similar) • A short README explaining how to rerun the job and tweak the mappings • Verification that every record landed in the correct table with accurate data types and relationships I’ll supply the sample XLS, the current SQL schema, and the...
...use: Develop a data integration system to securely transfer and synchronize accounting data from TallyPrime to a Microsoft SQL Serve database. The system will extract relevant TallyPrime data, transform it into a structured format, validate the data, and store it in SQL Server for centralized access, reporting, analysis, and integration with other business applications. Key Scope * Connect with TallyPrime and extract accounting data. * Transfer masters such as Ledgers, Groups, Stock Items, Customers and Suppliers . * Transfer transactions such as Sales, Purchases, Receipts, Payments, Journals and Contra entries etc. * Map TallyPrime data fields to SQL Server tables. * Validate and transform data before insertion. * Support initial/full data migratio...
...states Accessible controls No ugly default alerts No users stuck on loading/searching screens 20. Real-Time Synchronization Everything server-connected must work between two real devices, including: Matchmaking Username Avatar Country Typing Messages Reactions Voice calls End chat Block Report Reconnect Presence Recent Connections 21. Redis Architecture Redis as the only server-side data store No SQL database TTL-based temporary data 24-hour Recent Connections TTL 24-hour reconnect request TTL Efficient Redis structures Cursor-based Recent Connections retrieval Atomic operations where required No permanent chat archive 22. Reliability Handle: Socket disconnect Network loss App backgrounding App returning to foreground App termination Partner disconnect WebRTC failure Matchmak...
...an organisation-owned device. • Enrol the Mac in our chosen MDM (Intune) and push baseline security: FileVault on, strong password & lock rules, automatic OS updates, recovery keys stored to the organisation. • Grant end users Admin access once the policies are in place. • Pre-install and licence a short list of apps—Microsoft Office, Google Chrome, Cursor, Visual Studio Code, Pg Admin and SQL Server Express—so they appear on first login. No other bloatware. • Ensure the Mac is completely detached from any employee iCloud or personal Apple account. • Provide a concise setup document outlining every step, the profiles deployed, and how we can repeat the process for future Macs. I’m looking for someone who has hands-on exper...
...Form: A clean, modern, and mobile-responsive registration form built with HTML5, CSS3, and JavaScript (or framework of choice). Includes real-time input validation (email format, phone numbers, required fields). Backend & Database: Secure server-side processing (e.g., Node.js, Python/Django, PHP, or similar) connected to a reliable database (MySQL/PostgreSQL) to handle data insertion safely against SQL injection and XSS. File Uploads: Support for document and image uploads (such as profile pictures or credentials) with size and format restrictions. Admin Dashboard: A simple admin view or panel to view, search, filter, and export the registered user data (e.g., to CSV/Excel). Notification System: Automated email confirmation sent to users upon successful registration, and/...
Hi Steve, Phase 2 as discussed: deployment only. Install the delivered SQL Server database on our server, reconnect the Access front-end, test with a control data set, support switch-over. The assessment and migration are done and paid, not included here, and no new development. Our local IT engineer will join this chat and provide server access; you guide and validate. Please confirm scope and fixed price before we set two milestones: install and test, then switch-over and acceptance.
...explored beyond basic reports. My goal is to uncover efficiency-focused insights—think conversion speed, revenue per call, rep productivity—and present them in an interactive, executive-ready format. You may use Tableau, Power BI, or a mix of both if it helps surface the story in the clearest way. The raw data arrives as daily CSV exports, but I can also grant read-only access to the underlying SQL database if a live connection is preferable. Once the data model is clean, I’d like a series of drill-through dashboards that let stakeholders slice performance by region, product line, and individual rep, complete with trend indicators and shareable links. Deliverables • A tidy, well-documented data model (joins, calculated fields, and any ETL scripts) &bu...
I need a fully functional registration form added to an existing PHP website. The form should slot naturally into one of my current pages, c...written to my MySQL database and a clear success message returned. You may code in plain PHP, mysqli or PDO—whatever you are most comfortable with—as long as the final solution is lightweight, secure, and easy for me to maintain. I will supply cPanel and database credentials so you can test directly on a staging copy of the site. Deliverables: • PHP/HTML/CSS files for the registration form • Any SQL needed to create or alter tables • Brief read-me explaining where each file goes and how to tweak settings I will mark the project complete when I can register a new user without errors and see the data correc...
...Provide recommendations for Power BI architecture and best practices Requirements: • Strong hands-on experience with Power BI • Excellent knowledge of DAX and Power Query • Strong understanding of data modeling and relational databases • Experience with Power BI Embedded • Experience implementing Row-Level Security • Experience integrating Power BI with web applications and APIs • Knowledge of SQL and data transformation • Experience optimizing Power BI reports and models • Understanding of authentication, permissions, and secure embedded analytics • Good communication and problem-solving skills Nice to Have: • Experience with Azure • Experience with Power BI REST APIs • Experience with Python • Experience wi...
...documentation Test changes before production deployment Provide recommendations for future improvements Must have: Strong JavaScript/TypeScript Experience with iOS and Android deployment REST API integration Git/GitHub Experience maintaining an existing codebase—not just building new apps React.js/web development experience Ability to troubleshoot independently Nice to have: Node.js / .NET API experience SQL/database experience Firebase Push notifications Authentication CI/CD App Store Connect Google Play Console AWS/Azure Experience working with small startups...
The goal is to create an intelligent Web Application Firewall that sits in front of my custom web applications, inspects traffic in real time, and automatically reacts to threats. The platform must excel at three core functions I have prioritised: Real-Time Threat Detection, Defensive Blocking, and Attack Analytics. Key attack surfaces to guard against are SQL Injection, Cross-Site Scripting (XSS), and Distributed Denial of Service (DDoS). Every request should be scored, logged, and, when required, blocked or rate-limited instantly. I want to see exactly what is happening through a live security dashboard and to manage rules through a clean API that my apps can call programmatically. Integration needs to be seamless: the WAF will be deployed in front of several custom web serv...
...transactions, and pull reports. A lightweight framework such as Laravel, Node.js, or Django is fine as long as it is stable and well documented. • Download landing page – simple responsive page that hosts the APK, shows privacy / T&C, and tracks basic analytics. Tech expectations Android Studio with Kotlin (or Java if you have a compelling reason), REST or WebSocket for live data, any robust SQL/NoSQL backend you are comfortable maintaining, and solid security practices for user data and payment flow. Deliverables 1. Compiled APK ready for Play-store compliant release 2. Source code with clear comments and build instructions 3. Deployed admin panel and landing page on my server (SSH access provided) 4. One-time data seeding and a walkthrough video sho...
I need a professional Data Analyst to develop an interactive Power BI dashboard and transform raw business data into clear and actionable insights. The project may include: Data cleaning, transformation and analysis KPI and performance metric development Interactive Power BI dashboard design Sales, customer and product performance analysis Trend and comparative ...transformation and analysis KPI and performance metric development Interactive Power BI dashboard design Sales, customer and product performance analysis Trend and comparative analysis Data visualization and reporting Recommendations based on the findings The dashboard should be professional, user-friendly, visually clear, and suitable for management reporting. Experience with Power BI, Excel, SQL and data analytics is ...
We are looking for a Senior .NET / Distributed Systems Developer to work on an existing ASP.NET Web Forms + C# + SQL Server based Biometric Attendance & HRMS application. Currently, biometric device communication and HRMS business processing run in the same application/server environment. During high biometric device traffic, the device communication consumes excessive CPU, RAM, database connections and application resources, which can affect or shut down the complete HRMS application. We need to separate the biometric device communication layer from the HRMS application and build an independently scalable architecture. Target architecture: Independent Biometric Device Gateway Persistent TCP/IP device connections Multiple Gateway servers with load balancing Kafka or RabbitMQ...
...the screens relevant to them. Core functionality: • Employees clock in and out directly from the web application. • Managers approve leave and view real-time team attendance. • Admins configure work schedules, create users and run organisation-wide attendance reports. Additional requirements • Secure RESTful API built in .NET Core that the React SPA consumes. • Persistent data store (SQL Server or PostgreSQL—whichever you are most comfortable with) using Entity Framework Core. • Clear separation of layers so future mobile or biometric integrations can plug into the same API. • Responsive UI; basic dashboard widgets for daily status, leave balances and monthly summaries. Deliverables 1. Source code for React app and .NET ...
...exports from fleet management systems, time-series from pressure and torque sensors, and geology logs). From there, I expect a blend of descriptive summaries to frame the current state, followed quickly by predictive or prescriptive modelling that pinpoints concrete opportunities to boost throughput and reduce costs. Key deliverables: • A well-documented data pipeline or notebook (Python, R, or SQL) that ingests the raw files and outputs repeatable analyses • Visual dashboards (Tableau, Power BI, or similar) highlighting KPIs, bottlenecks, and recommended process adjustments • A brief report translating the numbers into operational recommendations my field supervisors can act on tomorrow Your work will be accepted once the pipeline runs end-to-end on a fres...
...you will teach are: • AVEVA E3D / PDMS • AVEVA P&ID / NextGen P&ID • AVEVA Unified Engineering Because the cohort is starting from zero, every concept needs to be demonstrated hands-on, with plenty of practical examples that tie back to EPC and plant-engineering workflows. Integrating topics such as data migration and mapping, ISO 15926/DEXPI standards, Hexagon Smart 3D interoperability, SQL/Oracle back-ends, and light scripting with the AVEVA SDK (PML, C#/.NET) will help the learners see the bigger picture, but the heart of each session must remain tool proficiency. What I need from you 1. A detailed session plan that fits into a 4-to-6-week online schedule (live classes of 2 hrs each, three times a week). 2. Slide decks, demo datasets, and step-...
...all field relationships and ensuring there are no duplicates. You may work directly in the database interface or prepare a clean CSV/SQL file for me to review before we import—whichever is faster for you while still keeping the data intact. The key for me is accuracy and consistency: each service line in the spreadsheet must map to the correct table and column, and any reference keys need to stay usable once the data is inside the system. After you finish, please run a quick spot-check with me so we can confirm totals and sample entries match what’s in the spreadsheet. Let me know: • the database platforms you are comfortable with (MySQL, PostgreSQL, MS SQL, etc.) • your estimated turnaround time once the sheets are shared If you’ve handled...
...Phase)Server Configuration: Provision and optimize a Windows Server 2022 VPS (using a provider like AccuWeb or Contabo). Configure 4 concurrent Remote Desktop Services (RDS) Client Access Licenses (CALs) and set up 4 secure, individual user login Installation: Install and optimize Microsoft SQL Server Express Edition on the server. Ensure proper permissions and local database configurations are Setup & Migration: Install ASI SmartBooks on the server, connect it to the SQL Express database, and map the shared data directories. Assist with migrating our existing data files to the new Check: Test the setup to ensure all 4 users can log in simultaneously via RDP, access Excel/Outlook via Microsoft 365 shared-computer activation, and run the ERP smoothly
...RF gun and in the desktop client without extra keystrokes. 3) A4 content report When users press “Print Content” on a shipment, the system should generate a clean A4 Word document that lists all lines, quantities, and batch numbers laid out for customs. Header, footer, and company logo already exist; your job is to map the data and launch Word printing automatically. Please work directly in SQL, HighJump Architect, and Crystal/Reporting Services as appropriate, commenting any new objects so future upgrades are safe. I’ll provide VPN access to our test instance and sample data the moment we agree on milestones; once I sign off in test you’ll migrate to prod. If you have proven HighJump work, especially around replenishment rules or barcode parsing, let...
Team Required — SQL Backend, Payments and Real-Time Sessions — Fixed Price in CAD Fixed-price budget: CAD $1,060–$1,560 for the complete agreed scope. We are looking for an experienced team to complete the SQL database, backend integrations, payment processing and access management for an interactive avatar service. The service will support complimentary access codes and paid, fixed-duration sessions. The initial paid offering is CAD $0.99 for a 10-minute session, with configurable pricing and duration. The complete system must be delivered, integrated and tested before 7:00 p.m., Quebec time, on Wednesday, September 23, 2026. Your proposal must explicitly confirm this deadline. Existing Work and Integration The session flow, reconnection handling, par...
...months. We need to act fast. • Language: I do not speak local European languages. The preparation must focus strictly on international companies or tech hubs operating entirely in English. • Experience Level: I have very little professional job experience, but I am targeting entry-level Data Analyst roles. What I need from you: • Framework for Technical Interviews: Help me structure my answers for SQL, Excel, and data visualization (Tableau/Power BI) questions, even with limited experience. • Behavioral & Case Prep: Teach me how to handle business case studies and behavioral questions using the STAR method, tailored to European corporate culture. • Portfolio Review: Quickly review how I present my projects/skills to ensure they stand out to recruiter...
Step by step guide for using MySQL database engine from Node.js
Want to expand the freelance services you're offering? Learn a new skill and take an exam that will certify your expertise.