Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
I need a Microsoft SQL Server specialist who can take stacks of paper‐based records, design the appropriate tables, and manually key every field into a clean, well-structured database. Once the information is in place, I want meaningful statistical insight extracted—basic descriptive stats, variance and correlation figures, and any notable outliers that should be flagged. To succeed you will be comfortable with SQL Server Management Studio and T-SQL for schema design, indexing and data validation rules that prevent transcription errors. After entry, apply your preferred statistics toolkit (native SQL functions or an external package you connect to the database) to run the agreed analyses and return concise results. Deliverables • Normalised SQL...
...needs to be migrated and deployed on to a VPs server…host is well known it is a little jibe just need some quotes it is a spring boot website with database. Here is what I expect: • A minimal but complete codebase that compiles and runs with a single `./mvnw spring-boot:run`. • All database connection details externalised in ``, ready for me to swap in my own credentials. • A SQL script (or Flyway/Liquibase migration) that creates the necessary schema and seeds a couple of sample rows so I can see data flowing end-to-end. • Simple HTML (Thymeleaf or similar) served from the backend—no heavy frontend build pipeline is needed. • Clear README instructions covering project structure, how to build, run, and import the database. I wi...
I want a web–based School ERP that unifies three core modules—Student Management, Attendance Tracking and a Grade Book—inside ...printable transcripts. Authentication must be secure (JWT or session, your call) and the UI should feel modern on desktop, tablet and mobile. I will provide the basic colour palette and logo; everything else—from database schema through deployment documentation—comes from you. Deliverables: 1. Source code (preferably React + Node/Express or another open stack you recommend). 2. Normalised SQL (or comparable NoSQL) schema dump. 3. A one-click deployment script or Docker setup. 4. Brief user guide covering each role’s full-access workflow. When handing over, please host a demo link so I can run through all t...
...spans printed pages, handwritten notes, and a handful of digital files; I will supply high-resolution scans or the originals as needed. The job is straightforward: transcribe every field exactly as shown, double-check for typos or missing values, and standardise dates, numbers, and names so the final dataset is clean and immediately usable. Excel works well on my end, though I’m open to CSV or an SQL dump if that streamlines your workflow. Deliverables • A single, well-organised data file in the agreed-upon format • A brief log highlighting any unclear entries or duplicates you encountered Acceptance criteria • ≥ 99 % accuracy when spot-checked • Uniform formatting across all columns/fields • Delivered within the timeline we agree on ...
We are launching a new web application. It is to help hosts manage events. It is a small application (first release) with a form for host to create, share the link, allowing guests to respond. Also there are email notifications. The requirements are not explicitly specified. Tester will have to understand the functionality and test. There is a SQL server backend application, hosted on Godaddy. Tester must test for security risks, vulnerability, unauthorised access, encryption, confidentiality, leakages, cyber security / penetration. Tester will also have to find out issues with coding standards, cookies, encryption in data exchange to ensure that plain data is not saved or transferred. The application is mobile/desktop/devices compatible. And needs to be tested on those. Teste...
I need a dynamic sales dashboard built in Excel that helps me monitor my coffee business in real time. The finished file must pull data from both a set of Excel spreadsheets I provide and a small SQL-based database we currently use for inventory. Once connected, the dashboard should let me: • Filter results by any custom date range • Hover over charts or data points to reveal additional details (totals, percentages, underlying records) • Click column headers to sort tables on the fly Beyond wiring up those interactive elements, I’d like clean visuals—charts, trend lines, and summary cards—that instantly show how my different coffee products are performing without forcing me to dig through raw sheets. Deliverables • An .xlsx file with al...
I have a live MySQL database waiting for a batch of new customer contact records—names, emails, phone numbers a...then insert the clean records into the designated table. You may work directly in phpMyAdmin, MySQL Workbench, or via your own scripted INSERTs; the only requirement is that the final table structure, indexes and auto-increment keys stay untouched. Deliverables • All supplied records accurately entered into the database • A brief log noting any duplicates or corrections you had to make • SQL dump or confirmation query proving the row count matches the source Accuracy and consistent formatting matter more to me than raw speed, but I’d still like the first chunk delivered within 24 hours so I can spot-check the process. If that works ...
My WooCommerce store on a shared SiteGround plan keeps hitting their resource ceiling. SiteGround automatically suspends the site several times a day and their logs show waves of unfinished SQL queries piling up until new requests tip us over the limit. As a result I’m facing frequent downtime, very high CPU usage and painfully slow page loads that are costing sales. I need someone who knows WordPress, WooCommerce and SiteGround’s architecture inside-out to: • trace and fix the slow queries or loops that are stacking up • review theme, plugin and custom-code interactions that might be spawning excess calls • configure or fine-tune caching (SiteGround Optimizer, object cache, browser cache) so requests are served faster instead of re-querying the data...
I need a seasoned developme...HIPAA/GDPR-style data safeguards, audit logging, and encrypted data at rest and in transit. The final product should be container-ready for cloud hosting so we can scale horizontally when new facilities come onboard. I’m open on the tech stack—as long as it is modern, maintainable, and supports responsive UI (React, Angular, or Vue on the front end; Node.js, Django, Laravel, or similar on the back end; SQL or NoSQL where appropriate). We’ll iterate through clearly defined milestones: requirements sign-off, clickable prototype, MVP release, then production hardening and documentation. If you have a track record delivering secure, large-scale healthcare or enterprise platforms, I’d like to see a short demo or code sample along wi...
...recommended next action. 5. The backend validates the action. 6. The appropriate CRM record/task is updated. 7. The result is logged for later review. The AI should operate through controlled backend functions rather than having unrestricted access to the CRM. Preferred Technical Stack Python is the primary language. Experience with some of the following is preferred: * FastAPI * Django * REST APIs * SQL * PostgreSQL/MySQL/MSSQL * Pandas * pytest * LLM APIs * Git We are open to discussing the exact architecture with the selected developer. First Milestone The first milestone will be intentionally limited. Expected deliverables: 1. Python project structure 2. CRM API client 3. Authentication/configuration setup 4. Database schema 5. Basic API endpoints 6. One working AI-...
...platforms. Data Engineering: Python, SQL, Spark, Databricks, Snowflake, BigQuery, Redshift, Airflow, Kafka, ETL/ELT, data lakes and data warehouses. How to Apply: Send a direct message containing: • Your résumé • LinkedIn profile • Primary technical area • Years of relevant experience • Current availability • A short pre-interview video introducing yourself, describing your technical background and explaining one recent project The pre-interview video is required before an applicant can qualify as a candidate. Candidates must personally participate in every stage of the interview process. #Hiring #DevOps #CloudEngineering #SRE #MachineLearning #ArtificialIntelligence #MLOps #DataEngineering #AWS #Azure #GCP #Kuber...
...improvement, and every millisecond we save lets us serve more users on the same hardware. Here’s what I would like delivered: • A baseline health audit of the current AI stack, highlighting failure points and noisy alerts • A monitoring dashboard (Elevenlabs) wired to real-time metrics, with clear alert rules and SLAs documented • A short, actionable report outlining algorithm-level optimizations—SQL refactors, model pruning, smarter caching, vectorized operations, etc.—plus measured before/after results • A monthly maintenance log template so future work and incident responses are tracked consistently I am looking for someone to take on the overall maintenance, monitoring and health of the the AI & Automation system in place whi...
I’m rebuilding the backbone of my application and need an experienced ba...the Google Cloud ecosystem. Here’s what I’m after: • Analyse my current data requirements and model an efficient, scalable structure. • Create and provision the chosen Google Cloud database service (Cloud SQL, Firestore or another you recommend) with best-practice security settings. • Configure automated backups, monitoring and role-based access so the environment is production-ready. • Deliver clear documentation covering the schema, deployment steps and maintenance routines. Please detail relevant Google Cloud database projects you’ve handled, the tools you prefer (e.g., Cloud SQL Admin, Terraform, gcloud CLI) and an estimated timeline. I’m re...
...back end I require an admin panel where I can: • create and schedule new tournaments • adjust odds / colour ratios before a round begins • view live participation stats and settled results • trigger manual payouts or let the system distribute them automatically • export user and financial reports to CSV The site should be responsive, lightweight, and secured against typical exploits (SQL injection, CSRF, etc.). A modern stack—React or Vue for the front end, Node.js / Laravel / Django for the API, with a real-time layer via WebSocket or Pusher—will keep everything snappy, but I’m flexible on exact tools if they achieve the same result. Please deliver: 1. Fully functional website with Instagram login and tournament gameplay ...
...finished file, and if everything matches the rules (no missing rows, correct column order, validated totals), we move on to the next batch. I handle quality checks within 24 hours and give feedback right away so you always know where you stand. Please be comfortable with Excel functions such as VLOOKUP/XLOOKUP, pivot tables, text-to-columns, and basic data validation. If you also know a bit of SQL or Google Sheets that is a bonus, but not required—the core task is disciplined spreadsheet work. When you reply, tell me how soon you can start and share one example of a similar processing job you completed. I’m ready to send the first file as soon as I find the right match....
I have a collection of text-based records that need to be inserted directly into an existing MySQL database. The tables are already created; what’s missing ...referential integrity is maintained. I will supply: • The database schema with field definitions and constraints • Source files organised by table • Clear mapping notes showing which column each text element belongs to What I expect back: • All rows entered without duplication • Primary and foreign keys respected • A brief log of any anomalies you encounter and how you resolved them • A final SQL dump so I can verify the new state of the database on my end If you’re experienced with MySQL imports, character-set handling, and quick spot checks for data cleanliness, thi...
...quirks. • Where the raw files already sit in SQL Server, create T-SQL or Python-based routines that achieve the same checks and corrections in-database so I can schedule them in an Agent job. • Document each step clearly so I can port the logic later to R or even a small C/C++ utility if performance becomes critical. Acceptance criteria – The script ingests a folder full of mixed-encoding files and leaves a clean UTF-8 version plus a detailed log of any corrections made. – A sample table in SQL Server is fully cleansed using your routine, with before/after counts matching exactly. – Code is delivered via Git with concise README and in-line comments. If you are comfortable working with numeric data, encoding issues, and the u...
Category tags: Intuit QuickBooks · Accounting · Python · API Integration · Financial Analysis · Data Management · SQL Budget: Fixed price, milestone-based. Bid the full scope. Timeline: 3–4 weeks from kickoff. What I need A reproducible synthetic dataset for a fictitious solid-waste hauling company, covering 24 consecutive months of operations. This is for internal staff training, reporting/BI sandbox testing, and month-end close practice. No real company, customer, vendor, or employee data will be used or accepted. The scope has two linked layers: Financial layer — a populated QuickBooks company file (GL, AR, AP, payroll, fixed assets). Operational layer — the underlying service, tonnage, container, and route data tha...
...problems—intermittent disconnections, time-outs, and the odd Entity Framework hiccup against SQL Server. While the spotlight is on the backend, you should be comfortable skimming an Angular front end whenever a trace leads there, but the core deliverable is a stable, reliably connected API layer. Schedule & cadence • Monday to Friday, 2 hours a day (ideally in the morning IST, though I can shift slightly if needed). • We’ll work live over Teams/Zoom; I’ll share the repo and any logs ahead of time so you can dive straight into the issue queue. Tech you’ll touch C#, .NET Core, Entity Framework, SQL Server, a bit of Angular 12+, Git. If you prefer additional diagnostic tools—MiniProfiler, SQL Profiler, Postman, e...
Key Features & Deliverables: Member Management & Onboarding: Digital membership registration, profile management, ID generation, p...expense tracking with one-click PDF/Excel export. Role-Based Access Control (RBAC): Distinct permission levels for Super Admin (owner), Staff/Receptionists, and Trainers to keep sensitive financial data secure. Technology Stack: Front-End: HTML5, CSS3, JavaScript, Bootstrap / Tailwind CSS Back-End: PHP Database: MySQL (Relational Schema Design & Optimization) Security & Tools: Password hashing, SQL injection prevention, session management, and responsive mobile-first UI Business Outcome: Delivered a lightweight, secure administrative portal that reduces front-desk administrative overhead by over 70% and prevents revenue leakage...
...logins, and expose an API so I can hook it into my existing CRM later. A responsive interface (React, Vue, or similar) backed by a solid RESTful or GraphQL service (Node, Laravel, Django, etc.) is ideal, but I’m open to your proven stack as long as it is well-documented and easy for another developer to maintain. Deliverables 1. Source code in a private repo with clear setup instructions 2. SQL or NoSQL schema scripts 3. Admin credentials for testing plus one demo user for each role 4. Short video or live demo walk-through 5. Deployment guide so I can move the app to my own server or a cloud instance I will review against the feature list above, clean UI/UX, bug-free operation, and code readability. If something here is unclear, ask before you build—I&...
...• Full-text and filtered search, plus category browsing to keep discovery quick. • Secure REST or GraphQL API endpoints to support a future mobile app. • Deployment to a production server with SSL, backups, and basic monitoring in place. Acceptance criteria 1. Pages load in under three seconds on a standard broadband connection. 2. OWASP Top-Ten vulnerabilities are mitigated (CSRF, XSS, SQL injection, etc.). 3. All core user flows—registration, listing creation, checkout, payout—are demonstrated live on a staging URL before final hand-off. 4. Complete documentation (setup steps, environment variables, database schema, and code comments) is delivered alongside the source. Please outline your proposed stack, any off-the-shelf packages you wo...
...Observability Self-Hosted Essentials for Enterprise licence (EE1500, covering up to 1 500 nodes) and now need Network Performance Monitor installed and fully configured in a brand-new environment. Nothing from SolarWinds is running yet, so the engagement starts with clean servers and blank databases. What I need is complete, production-ready deployment: sizing and architecture guidance, Windows Server and SQL prerequisites, installation of the NPM engine, web console, additional polling engines or HA pairs if your design shows we need them, followed by initial discovery and onboarding of devices. Once the platform is stable I also want core alerting rules, reports and dashboards set up so my team can see value on day one. Deliverables • Design document that maps EE1500 c...
...an older version of Vtiger CRM (Version 7.3). We are currently getting a "503 Service Unavailable" error on the login screen because the legacy code cannot process the new PHP have a very tight budget for this fix, but we have made the job as clean and organized as possible for you. We have a complete, uncorrupted backup of both our CRM file directory (.zip) and our complete database (.sql) safely downloaded from CodeGuard from just before the tasks will be:Set up a temporary local development environment on your own computer running older PHP our Vtiger 7.3 backup files and database into your environment to make sure it loads run the sequential Vtiger migration patches in the exact required order: Vtiger 7.3 → 7.4 → 7.5 (adds initial PHP 8
...is the complete server-side engine that will actually run the shop. Scope of work I’m looking for a developer who can build every major e-commerce module from scratch: secure user authentication with role-based authorization, robust product and inventory management, reliable cart and order processing, and a clean admin dashboard to control it all. Because I’m undecided between a traditional SQL stack or a more flexible NoSQL approach, I’m open to your recommendation—just explain why it fits our growth plans. Key integrations & expectations • Payment: Razorpay must be fully integrated, handling standard payments, refunds, and webhooks in both test and live modes. • APIs: well-documented REST (or GraphQL if you convince me) endpoint...
We have Oracle and MS-SQL environments that need expert support, and for compliance purposes the work must be performed by someone who is physically located in Canada. Here is the immediate scope: Oracle upgrades – Plan and execute version upgrades on Development and Production databases, ensuring minimal downtime and a clean rollback path. – Review current backup, recovery and high-availability strategies and adjust them to suit the new versions. Ongoing operational support – Handle day-to-day administration, performance tuning, security patching and capacity planning. – Document every change clearly so our internal team can trace what was done and why. Integration assistance for active projects – Our developers are building ...
...“Submit”, I want the sheet to carry out three things automatically: 1. Check every field against built-in validation rules (no missing mandatory items, correct number formats, valid choices). 2. Auto-populate any look-ups or calculated fields so the person filling the form never sees #N/A or has to open another tab. 3. Push a clean, single-row record straight into an external database table (SQL Server is preferred, but I’m open to other engines you suggest if they integrate as smoothly). Please build whatever VBA, Power Query, Office Scripts, or add-ins are necessary so the flow is seamless: enter data → click submit → record lands in the database with zero pop-ups or security warnings. Deliverables • The updated Excel file with all co...
...understanding the existing application and implementing new features, modifications, improvements, bug fixes, reports, dashboards, and other business requirements as needed. Key Responsibilities: Understand and work with the existing VB.NET desktop application and its current architecture. Work extensively with DevExpress WinForms controls and components. Understand and work with the existing SQL Server or relational database structure. Modify and enhance existing modules based on business requirements. Develop new modules and features when required. Make UI improvements and enhancements using DevExpress controls. Develop and modify reports, dashboards, charts, and printable documents using DevExpress Reporting. Work on user roles, permissions, login security, applicatio...
I need a lightweight vehicle-management tool focused squarely on load handling. The core requirement is accurate, real-time load weight tracking for every vehicle that passes through ou...staff can add or edit entries. • Clear installation guide and commented source code. Acceptance criteria 1. Weight entry must save in under two seconds on a standard office network. 2. Database can be backed up and restored without data loss. 3. CSV export opens correctly in Excel with no formatting issues. Tech stack is up to you—common choices like .NET, Java, or Python with a lightweight SQL database are all acceptable—as long as it remains maintainable and license-free for production use. Let me know your proposed stack, a brief outline of milestones, and any clarifyin...
...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: 10% by 20th September 2026 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...
...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...
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.