Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
...Desired Expertise: The ideal candidate must have extensive experience across multiple domains: 1. Data Analysis & AI Tools: Proficiency in leveraging platforms like n8n, Zapier, OpenAI, Claude, or equivalent automation tools. 2. Business Growth Strategies: Proven expertise in identifying opportunities for increased productivity and revenue growth. 3. Technical Skills: Knowledge of Python scripting, SQL databases, creating Power BI dashboards, API integrations, web scraping/data collection methods. Additional Skills (preferred): - Experience in digital marketing automation - Hands-on improving operational/business processes - Strong portfolio of driving efficiencies via AI & similar processes - Open to suggesting other relevant tools based on project requirements Note: P...
I need a clean, visually engaging Power BI report focused on financial reporting. The model will draw its data exclusively from a...numbers for testing, and I’ll need a short hand-off video or annotated screenshots showing how to refresh the report when new Excel files arrive. Deliverables • One .pbix file with linked Excel connections, fully formatted visuals and DAX measures • A brief refresh guide (text or video) so the finance team can update figures each month If any future phase requires pulling the same report from SQL or a cloud source, I’d like your design to remain flexible enough to swap the data source without rebuilding everything, but that part is not required right now. Please let me know your estimated timeline along with any clarifying...
...and Spring problems with quick front-end twists (Angular or React) and some database touches in plain SQL. I’m counting on you to: • design or select one cohesive exercise that covers back-end, front-end, and data layers • host a 30-minute live interview, guiding the candidate while observing problem-solving habits • score their solution for correctness, code quality, and architectural thinking, then give concise written feedback within 24 hours I’m looking for someone at a comfortable mid-level of interviewing experience—deep enough to spot nuances but not anchored only in ivory-tower theory. If you regularly work with Java 17+, Spring Boot, Angular or React, and you can read SQL at a glance, you’ll fit right in. Let ...
...experience in service-oriented architecture implementations Proficiency in Oracle Managed File Transfer (MFT) for secure file-based integrations Experience with REST/SOAP web services, XML, XSD, WSDL, and JSON Strong expertise in data mapping, transformations, and canonical models Hands-on experience with XSLT and XQuery for complex transformations Good understanding of relational databases and strong SQL skills (queries, joins, procedures, performance basics) Strong understanding of error handling, fault management, and retry mechanisms in integration flows Unix / Linux experience Experience with Oracle WebLogic Knowledge of Oracle Cloud Infrastructure (OCI) Integrations Supporting / Secondary Skills: Working knowledge of cron jobs / scheduling mechanisms for automation and ...
...structures, relational databases, and complex backend logic ensures that downline calculations, commission triggers, and data integrity remain flawless as the network scales. * Advanced Analytics & Custom Business Intelligence: The client explicitly asks for clear sales-reporting tools filterable by date, team, or product, along with data export capabilities. Your background in business intelligence, SQL, and analytical dashboarding enables you to build intuitive, high-impact reporting tools that deliver actionable insights for both admins and network marketers, going beyond basic off-the-shelf templates. * Full-Stack Competency & Modern Tech Stack: The client is open to modern, maintainable technology choices (e.g., React, Laravel, or headless WordPress). Your end-to-e...
...application. The goal is to identify vulnerabilities, misconfigurations, and potential attack vectors before they can be exploited, and to receive a clear, actionable report of findings. Scope of Work: Full black-box / grey-box penetration testing of the website (login areas, forms, APIs, user roles, and admin panels where applicable) Standard automated vulnerability scanning (OWASP Top 10 coverage: SQL injection, XSS, CSRF, broken authentication, insecure direct object references, security misconfigurations, etc.) Manual testing of business logic and access control (e.g., checking whether one user/account can access another's data) SSL/TLS configuration review Server and infrastructure-level security check (open ports, outdated software, exposed services) Review of sess...
...supported option—you can recommend the best fit). • An admin panel lets me upload/manage ad inventory, set payout rates, monitor user activity, and handle withdrawal requests. • Each user also sees real-time progress: total ads watched, current balance, and payout history. Tech expectations I’m flexible on stack choices, but the solution must be scalable and secure. JWT-based authentication, an SQL or NoSQL database, and a modern front-end framework (React, Vue, or similar) are welcome. For the Android side, Kotlin or Flutter is fine as long as performance is solid. Ad serving can tap into Google Ad Manager or a custom video hosting setup if that’s more efficient. Deliverables 1. Android APK plus Play-Store-ready bundle 2. Fully responsive ...
My current résumé no longer reflects the calibre...positions me immediately as an executive-level contributor. Here’s what I expect: • A refreshed professional summary that highlights senior-level, data-driven compensation expertise • An achievements-focused work-experience section written for both human readers and ATS algorithms • A concise skills matrix tailored to compensation analysis, pay strategy, HR analytics and related tech (Excel, SQL, HRIS, etc.) • Modern, clean formatting delivered in editable Word as well as ready-to-send PDF Please weave measurable results wherever possible, optimise keywords for Compensation Analyst searches, and keep the tone confident yet genuine. I’ll supply my existing résumé and...
... • Audience: principals, department heads, and district leadership. • Data: source or create a realistic high-school data set that covers multiple school years, grade levels, courses, teachers, and demographic fields typical of US districts. What I need you to deliver 1. Clean, well-documented data set (CSV / SQL backup / Excel) with clear data dictionary. 2. Tableau workbook (or .pbix) that: – Connects directly to the data you provide – Shows relevant SQL snippets or calculated fields you used for joins, KPIs, or data reshaping – Contains thoughtfully chosen bar charts, line graphs, heatmaps or other visuals that spotlight the three metrics above – Includes interactive filters (year, grade level, demographic ...
We are looking for an experienced Business Development Executive (BDE) or Freelancer/Upwork Bidder to help us acquire new software development projects. We specialize in .NET, ASP.NET Core, C#, React, Angular, SQL Server, Azure, Web APIs, and Full Stack Development. Your responsibility will be to identify relevant projects, write compelling proposals, communicate with clients, and help us win projects. Responsibilities * Search for relevant projects on Freelancer.com, Upwork, Guru, and other freelancing platforms. * Analyze project requirements and submit high-quality, personalized proposals. * Communicate professionally with prospective clients. * Follow up with clients and respond to messages promptly. * Negotiate project scope and pricing when required. * Maintain a record of s...
...Core Web API with C# for the backend, connected to a SQL Server database using Entity Framework Core. Key Features: • Dashboard with pharmacy statistics and business overview • Medicine and product management • Categories management • Inventory and stock management • Expiry date tracking • Low-stock alerts • Supplier management • Purchase management • Sales and Point of Sale (POS) • Customer management • Invoice management • Sales returns • Purchase returns • Expense management • Sales and inventory reports • Search, filtering, sorting and pagination • User authentication and authorization • Role-based access control • Responsive and user-friendly interface Technology Stack: Fronten...
I need a clean, well-structured SQLite schema for a small student management system. The deliverable is a single .sql file (or files, if you prefer) containing all CREATE TABLE statements, primary and foreign keys, and any helpful indexes. Tables I know I’ll need • Student (with address information either embedded or in a child table, whichever you judge best) • Class list / enrolments • Teacher • Billing for students • Payment records for teachers Order of creation is up to you; the database starts empty, so sequence is only important for satisfying foreign-key dependencies. What to include in each table I’m looking for your guidance on sensible columns. At minimum a student’s name, address, date of birth, and enrolment detail...
AI-Powered Sales Analytics Dashboard & Business Insights Developed an intelligent AI-Powered Sa...Analytics for Business Growth Customer Segmentation and Purchase Pattern Analysis Interactive Power BI Dashboard with Real-Time KPIs Revenue, Profit, Product & Regional Performance Analysis Trend Detection and Data Visualization Automated Reports and Business Insights Data Cleaning, Feature Engineering, and Model Evaluation Technologies Used: Python, Pandas, NumPy, Scikit-learn, Matplotlib, Power BI, SQL, Jupyter Notebook, Excel. This project demonstrates strong expertise in Artificial Intelligence, Machine Learning, Data Analytics, Data Visualization, Predictive Modeling, Business Intelligence, and Dashboard Development, helping organizations convert raw data into intelligent b...
...Unavailable, and toggle that status. Admin extras Drag-and-drop ordering for featured profiles is a must, plus a quick filter or search by role, location, or any skill tag. If you can reuse native WordPress UI patterns (WP_List_Table, custom post types, MetaBox/ACF-style editing) it will keep the learning curve low. Deliverables 1. Production-ready plugin (PHP 8 compatible, WordPress 6+) 2. SQL install/upgrade scripts or use of WordPress schema APIs 3. Brief setup guide and inline code comments so my team can extend it later Acceptance criteria • CRUD operations work for both roles (admin / registered user) without privilege leaks • Skill categories editable on the fly and reflected instantly in forms and filters • Status flags display correctly on...
I need a well-structured database focused on storing customer details for my company. I have not locked myself into any single platform, so I’m open to either a traditional SQL solution (MySQL, PostgreSQL, SQL Server) or a NoSQL option (MongoDB, Firestore) if you can explain why it’s the better fit. Scope of work • Analyse my current customer information flow and recommend the most suitable database architecture. • Design the schema to hold core customer data—at minimum names, phone numbers, and email addresses—plus space for additional fields such as purchase history or demographic insights that we may add later. • Build the database, populate it with a small sample dataset, and document the structure. • Provide clear instru...
Every Friday our bank sends a fresh batch of lockbox figures that must land in our Microsoft SQL Server database before Monday opens. The files are already structured for direct database entry, so the job is simple but must be done with perfect accuracy: take the numeric data, connect to our SQL Server instance, and insert it into the designated tables using the column mapping I’ll provide. You’ll receive: • Remote credentials to the staging and production environments • A short data-dictionary detailing table names, primary keys, and constraints • A weekly hand-off schedule with cut-off times so the accounting team can reconcile on time Your part each week: 1. Import the numeric data set exactly as supplied—no reformatting needed. 2...
...I’m looking for a mentor who can share genuine, real-time experience: how tickets arrive, which logs you pull first, what metrics matter, and where you usually find the root cause. I’d like our sessions to feel like the daily stand-ups and war-rooms that actually happen in production environments. That means screen-sharing while we recreate incidents, stepping through JVM thread dumps, reviewing SQL slow-query logs, debating whether the issue lives in the code, the container, or the underlying infrastructure, and then drafting the kind of crisp RCA report hiring managers love to see. Deliverables I’m aiming for: • Three mock interview calls (45-60 min each) with immediate feedback • A walkthrough of at least two real troubleshooting scenarios, reco...
I have an e-commerce site running on plain PHP and need a fully-functioning user registration m...solution should: • Collect the usual fields (name, email, password). • Hash passwords securely and store them in MySQL. • Validate input server-side and show friendly error messages. • Create a clean login/logout flow with session handling. • Be written in modern, well-commented PHP so I can maintain it later. Deliverables: 1. PHP files (registration, login, logout, helper classes). 2. SQL file for the new user table. 3. A short read-me explaining where to drop the files and how to configure any constants (DB credentials, secret keys, etc.). Once I can register, log in, and see the new user row appear in the database without issues, I’l...
My front-end for a two-tier document dashboard is already in place; what’s missing is the server side. I need the full backend built in ASP.NET Core 8, wired up to a PostgreSQL database, and delivered within the next month. Our Old Database is based on MS-SQL also suggest which one will go for MS-SQL or PostgreSQL. Here’s the flow I have in mind: a single login page routes users to one of two dashboards based on role claims. Administrators must be able to upload, replace, or delete documents, while regular users may only preview or download what the admin makes available. All file operations should be protected by role-based authorization, and responses exposed through clean REST endpoints so the existing UI can consume them without modification. Key deliverable...
My front-end for a two-tier document dashboard is already in place; what’s missing is the server side. I need the full backend built in ASP.NET Core 8, wired up to a PostgreSQL database, and delivered within the next month. Our Old Database is based on MS-SQL also suggest which one will go for MS-SQL or PostgreSQL. Here’s the flow I have in mind: a single login page routes users to one of two dashboards based on role claims. Administrators must be able to upload, replace, or delete documents, while regular users may only preview or download what the admin makes available. All file operations should be protected by role-based authorization, and responses exposed through clean REST endpoints so the existing UI can consume them without modification. Key deliverable...
I need a sharp, achievement-driven resume that positions my dual expertise in WordPress development and data analytics as a cohesive, results-oriented story. Over the past decade I have built custom themes and plugins, optimised performance, and paired those technical wins with data-centric insights—think SQL-powered dashboards, Google Analytics tagging, and business-ready reports in Power BI. The document must highlight that blend clearly so hiring managers can see both the code and the numbers behind my success. Please craft a single primary resume that: • Lands under two pages without sacrificing key metrics or impact statements • Reads smoothly for humans while remaining ATS-friendly, using relevant keywords (PHP, MySQL, JavaScript, REST API, Tableau, Python, ...
I'm looking for an experienced developer to build an enterprise application using C# and SQL Server, primarily for the operations department of our customers. The app's main purpose is data management, focusing on data entry, editing, and inventory tracking. Key Requirements: - Must live in Alberta, Canada - Robust backend using C# and SQL Server - Experience in enterprise application development is a must Ideal Skills and Experience: - Proficiency in C# and SQL Server - Strong background in data management applications - UI/UX design skills for operational efficiency - Previous work with enterprise-level software solutions Please share your portfolio and relevant experience.
I an experienced penetration tester to web application. The primary objective is to identify vulnerabilities, with particular attention paid to three high-risk zones: • Authentication and authorization logic • Database exposure paths (SQL injection, insecure queries, weak configuration) • Input validation and handling that could open the door to XSS, command injection, or similar issues I will provide you with staging and live URLs, test accounts, and any required API keys. Please treat the exercise as a real-world black/grey-box engagement—no source code will be shared. You may use industry-standard tooling such as Burp Suite, OWASP ZAP, sqlmap, or custom scripts as you see fit, as long as methodology aligns with the OWASP Testing Guide.
I need a sharp, achievement-driven resume that positions my dual expertise in WordPress development and data analytics as a cohesive, results-oriented story. Over the past decade I have built custom themes and plugins, optimised performance, and paired those technical wins with data-centric insights—think SQL-powered dashboards, Google Analytics tagging, and business-ready reports in Power BI. The document must highlight that blend clearly so hiring managers can see both the code and the numbers behind my success. Please craft a single primary resume that: • Lands under two pages without sacrificing key metrics or impact statements • Reads smoothly for humans while remaining ATS-friendly, using relevant keywords (PHP, MySQL, JavaScript, REST API, Tableau, Python, ...
...program’s value proposition based on approved guidelines. Freelancers will be responsible for handling standard objections, capturing accurate prospect information, maintaining activity records, and ensuring all submitted leads meet the required qualification criteria. Successful candidates will manage daily field activities, maintain updated CRM or tracking records, meet agreed activity and SQL targets, and provide complete lead information for smooth handoff to the sales team. Full onboarding, sales scripts, qualification tools, and operational support will be provided. Candidates must follow data privacy requirements, represent the program professionally, and comply with all field engagement guidelines. This opportunity is ideal for individuals with experience in f...
...reports * Ticket reports * Reservation reports * Music sales reports * Export to Excel/PDF 11. Notifications * Email notifications * SMS-ready architecture * Push notification-ready architecture 12. Security * SQL Injection protection * CSRF protection * XSS protection * Secure authentication * Brute-force login protection * Audit logs Responsive Design The website must work perfectly on: * Desktop * Tablet * Mobile Performance * Fast loading * Optimized database * Clean code * Scalable architecture * Well-documented source code Deliverables * Complete source code * Database SQL * GitHub repository * Installation guide * API documentation (if applicable) * cPanel deployment support * Three months of bug fixes after delivery Sample Websites (Reference Only) T...
...data from APIs or bulk datasets * Parsing and transforming source data * Mapping source fields into our existing schema * Deduplicating products * Importing and linking product images where available * Building reliable, resumable ETL pipelines * Creating incremental update jobs * Producing validation and import reports * Documenting the ingestion process Required Skills * Python * PostgreSQL * SQL * ETL / ELT pipeline development * Data modeling * REST APIs * JSON / CSV / XML processing * Data validation and deduplication * Git * Docker (preferred) Experience with food datasets, product catalogs, or large-scale data ingestion is a strong plus. Long-Term Opportunity This engagement represents the first phase of a much larger data infrastructure initiative. There is a strong ...
...star schema data model, SQL scripts for data extraction and transformation (using joins, CTEs, window functions, aggregations, and data validation), and six interactive Tableau dashboards: Executive Overview, Attendance Analytics, Academic Performance, MTSS Analytics, Equity Analysis, and Student Detail. The dashboards should incorporate advanced Tableau features such as LOD expressions, parameter actions, set actions, drill-down navigation, dashboard actions, forecasting, clustering, dynamic KPI selection, Viz in Tooltip, and interactive filters. Every KPI, visualization, calculation, and design choice should have a clear business purpose and support actionable recommendations for district leadership. The final deliverables should include the Tableau workbook, dataset, SQL...
I have a series of Customer-Experience (CX) reports that were built by someone else and I’m running into two persistent headaches: the layouts never look quite right and the whole thing slows to a crawl whenever I refresh or filter the data. I’d like you to dive into the existing codebase—whatever language or mix of SQL, Python, R, or something else it was written in—and clean it up so the reports render cleanly, run quickly, and draw from a richer, better-structured data set. Here’s what I need from you: • Audit the current report logic and pinpoint the root causes of the formatting problems and performance issues. • Refactor or rewrite the underlying scripts/queries so visuals line up perfectly and refreshes complete in a reasonable tim...
...important, yet data integrity is critical, so every step must be logged and verifiable. The workflow starts in Excel: you will clean, normalise and de-duplicate each weekly batch using advanced functions—pivot tables, VLOOKUP/HLOOKUP and macros are the usual tools here. Once the data is spotless, you will prepare import-ready CSVs and load them into the CRM, either through its native wizard or via an SQL script if that proves faster and keeps the audit trail intact. Throughout the process you will spot discrepancies early, note them in a change log and adhere to strict information-security guidelines (encrypted files, restricted access, no data leaving the workspace). Deliverables • Weekly migration of ~10,000 records with 99.8 % or better accuracy • Clea...
My PHP-based matrimony platform, , needs a focused refresh to improve both aesthetics and usability on mobile and desktop. I am Use Unlimited Domains This Script Setup: Bulk OTP SMS Front-end refresh • Homepage only: I want a cleaner color palette and a new arrangement of the existing ...field integrates seamlessly with existing profile data, search, and export functions. Key expectations • All changes must be responsive and thoroughly tested on common breakpoints. • Code base is vanilla PHP with standard HTML/CSS; please stay within that stack and comment modifications clearly so future updates remain simple. • Deliver the updated theme files, modified PHP templates, and SQL needed to create the new field, along with a short change log for reference.
I need a well-structured database focused on storing customer details for my company. I have not locked myself into any single platform, so I’m open to either a traditional SQL solution (MySQL, PostgreSQL, SQL Server) or a NoSQL option (MongoDB, Firestore) if you can explain why it’s the better fit. Scope of work • Analyse my current customer information flow and recommend the most suitable database architecture. • Design the schema to hold core customer data—at minimum names, phone numbers, and email addresses—plus space for additional fields such as purchase history or demographic insights that we may add later. • Build the database, populate it with a small sample dataset, and document the structure. • Provide clear instru...
Project Name : Retail Chain Project Details : Converting Main frame DB2 legacy application into Azure application using APIS and Azure key vault code . Project technology: Dotnet , API,SQL,Azure key vault,Azure Dev,Azure AI, Azure ADMIN .
...with our current records—no loss, no duplicates. I’m open on stack choice as long as it supports these goals and you can justify it (Laravel, Django, Node.js, or comparable frameworks are all fine). Please outline the tools, libraries, or frameworks you prefer, your timeline to deliver each module, and a brief sample of similar work. If you’ve integrated custom applications with an existing SQL or NoSQL backend before, that experience will be invaluable here. I’ll share schema details and credentials after kick-off so you can map your models straight to our tables, run migrations, and test live data flows. The finish line is a fully operational ERP where: 1. New students can be enrolled, edited, and searched instantly. 2. Teachers can take dai...
... This is a unique opportunity for someone who wants to grow with an early-stage company. Instead of a traditional salary, compensation will be based on a profit-sharing model, allowing you to share in the company's success as we grow. Requirements Based in Latin America (LATAM) Fluent in English and Spanish Strong experience with at least one of the following: Python Node.js C# Experience with SQL and/or NoSQL databases Familiarity with GitHub and Git workflows Understanding of CI/CD pipelines Strong communication and collaboration skills Available to work full-time Nice to Have Experience with cloud platforms (AWS, Azure, or GCP) Docker and containerization Startup or SaaS experience Compensation This is a profit-sharing opportunity rather than a salaried position. As the...
...structured dataset and need an expert who can turn that raw volume into reliable, actionable insight. The core of the engagement is data analysis—everything from designing an efficient pipeline that ingests, cleans, and joins the tables at scale, to writing performant queries and statistical routines that surface trends I can use in decision-making. The stack is open: Apache Spark, Hadoop, distributed SQL engines, or another platform you’re confident will keep runtimes reasonable and costs under control. What matters most is that the solution handles billions of rows without sacrificing accuracy or maintainability and that every step you take is reproducible. Acceptance for the work will be based on: • A documented workflow (code notebooks or scripts plus a s...
I need help installing PowerApps and connecting it to my SQL Server database via an on-premises connection using a Gateway. Key tasks include: - Correctly installing PowerApps - Setting up an on-premises connection to SQL Server via Gateway - Resolving Power BI Gateway issues Additional details: - The work will be done remotely on my laptop, with live coordination and communication. - Preference for someone available this evening. Ideal skills and experience: - Expertise in PowerApps and SQL Server - Experience with on-premises data gateways - Problem-solving skills for potential follow-up tasks
...ArcOne Technical Architect Experience: 10–15+ years of overall IT experience 5+ years of ArcOne technical implementation experience Strong Oracle Utilities CCS and MDM integration experience Experience supporting enterprise utility environments Key Skills: ArcOne Platform Administration Workflow Engine Configuration To Do Automation and Queue Management Oracle Utilities CCS, MDM, OUAF Java, SQL, PL/SQL REST APIs, SOAP Services, Web Services Solution & Integration Architecture Responsibilities: Design end-to-end ArcOne solution architecture Define integration architecture between ArcOne and Oracle Utilities applications Lead technical troubleshooting and performance optimization Develop integration design specifications Support workflow automation and production...
I need a full-featured employment portal whose core purpose is smooth candidate and employer management. Both job seekers and employers should be able to search and list jobs, track applications, and communicate through the platform. Three distinct account types ha...schema, and basic deployment documentation Acceptance criteria • All three account types can sign up, sign in, and reset passwords without errors • Employers can post, edit, and archive jobs; candidates can search and apply; admins can view and manage every record • Page load times stay under three seconds on standard broadband • Code passes a security scan for common vulnerabilities (SQL injection, XSS, CSRF) Once these points are met and validated on a staging server, the project i...
I need a web-based control panel that lets my staff log in securely, upload or key in product details, and place mul...crucial requirement is suppressing or bypassing delivery charges whenever the site would normally add them; the order should only proceed once the cart shows a zero delivery fee. Whether that means hitting a hidden JioMart API or using headless browser automation such as Puppeteer or Playwright, you can decide, but the outcome must be reliable. Deliverables • Source code with clear comments • SQL file or migration scripts for the database schema • Step-by-step deployment guide for Ubuntu VPS • Short screen-capture demo proving bulk ordering, tracking updates, user creation, and the delivery-charge bypass all work Handing these over ...
...practiced application-security judgment.** Not "I've read the OWASP Top 10" — you've designed an authorization model, found the hole in someone else's, and can explain why a given design is wrong in terms of what an attacker actually does. - **Hands-on with authentication internals.** Session management, token design, password and secret handling, TOTP, and ideally WebAuthn/passkeys. - **Strong SQL and relational data modeling.** You reach for a database constraint before you reach for an application-layer check. - **Production TypeScript** and comfort in a modern codebase. Deep *specialization* isn't required — a strong backend engineer picks up the App Router quickly. Security judgment is the part we can't teach. - **You write.**...
Job Description We are looking for a skilled SQL Data Engineer with hands-on experience in Microsoft SQL Server, Azure Data Factory (ADF), Azure Databricks, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS). The candidate will be responsible for designing and developing ETL/ELT pipelines, creating and optimizing SQL queries, developing reports and dashboards, managing data integration processes, ensuring data quality, and supporting business intelligence and data warehousing initiatives. The ideal candidate should have strong analytical and problem-solving skills, experience with database performance tuning, and the ability to work collaboratively in a remote team environment. Prefered Skills Microsoft SQL Server, A...
... Objective: Once a customer completes payment, the entire order processing workflow runs automatically. Phase 4 – Inventory & Purchasing ⬜ Inventory Management ⬜ Warehouse Management ⬜ Barcode / SKU Management ⬜ Minimum Stock Alert ⬜ Purchase Orders (PO) ⬜ Supplier Management Objective: Efficiently manage inventory, warehouse operations, and purchasing processes. Phase 5 – Accounting ERP ⬜ SQL Database ⬜ Chart of Accounts (COA) ⬜ Journal Entries ⬜ General Ledger (GL) ⬜ Accounts Receivable (AR) ⬜ Accounts Payable (AP) ⬜ Automatic Profit & Loss (P&L) ⬜ Balance Sheet ⬜ Cash Flow Statement Objective: Integrate website sales, purchasing, inventory, and financial transactions into a centralized ERP accounting system. Phase 6 – Artificial Intelligenc...
...Notifications Objective: Once a customer completes payment, the entire order processing workflow runs automatically. Phase 4 – Inventory & Purchasing Inventory Management Warehouse Management Barcode / SKU Management Minimum Stock Alert Purchase Orders (PO) Supplier Management Objective: Efficiently manage inventory, warehouse operations, and purchasing processes. Phase 5 – Accounting ERP SQL Database Chart of Accounts (COA) Journal Entries General Ledger (GL) Accounts Receivable (AR) Accounts Payable (AP) Automatic Profit & Loss (P&L) Balance Sheet Cash Flow Statement Objective: Integrate website sales, purchasing, inventory, and financial transactions into a centralized ERP accounting system. Phase 6 – Artificial Intelligence (AI) AI C...
...unique Hardware UID or encoded UUID (e.g., PRC-847291), which maps to the backend database record. Key Deliverables Source Code: Fully documented and clean repository (GitHub / GitLab). Mobile App Builds: Working APK (Android) and TestFlight / IPA (iOS). Web Dashboard: Deployed web admin portal. API Documentation: OpenAPI / Postman collection for all endpoints. Database Schema: Well-documented SQL migration scripts. Developer Requirements / Qualifications Proven experience with NFC integration in mobile apps (Flutter nfc_manager or React Native NFC libraries). Strong background in building inventory management or asset tracking solutions. Ability to design clean UI/UX for both mobile and web interfaces. Clear communication and regular progress updates. How to Apply Plea...
...Data Warehousing, Azure Data Platform, Microsoft Fabric, Power BI, SQL Server, SSIS, and Azure Synapse Analytics. Experienced in designing scalable ETL pipelines, developing interactive Power BI dashboards, migrating on-premises solutions to Azure, and delivering enterprise reporting solutions. Strong expertise in SQL performance tuning, Azure Data Factory, Synapse Pipelines, Microsoft Fabric, Git, Azure DevOps, and data modeling. Adept at working with global clients in Agile environments and delivering freelance consulting assignments independently. Key Skills • Cloud Platforms: Azure Data Factory, Azure Synapse Analytics, Azure SQL, Microsoft Fabric • Databases: SQL Server, Azure SQL Database, PostgreSQL • Programming: T-SQL, DA...
Job Description We are looking for a skilled SQL Data Engineer with hands-on experience in Microsoft SQL Server, Azure Data Factory (ADF), Azure Databricks, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS). The candidate will be responsible for designing and developing ETL/ELT pipelines, creating and optimizing SQL queries, developing reports and dashboards, managing data integration processes, ensuring data quality, and supporting business intelligence and data warehousing initiatives. The ideal candidate should have strong analytical and problem-solving skills, experience with database performance tuning, and the ability to work collaboratively in a remote team environment. Prefered Skills Microsoft SQL Server, A...
I keep all of my customer information inside a MySQL database and I nee...existing rows to eliminate duplicates and obvious errors. • Routine clean-up: correcting formatting issues, standardising phone and address fields, and flagging incomplete records for my review. • Simple SQL queries or views that let me pull segmented customer lists quickly. Everything must stay compatible with the current MySQL setup; no changes to the underlying schema unless we agree on them first. A brief progress report after each batch and a final export of the updated tables will be the acceptance criteria for every milestone. If you’re comfortable navigating MySQL, writing basic SQL, and paying close attention to data quality, I’d like to hear how you would approach t...
...to them. • Reporting dashboards for sales, inventory, and customers, exportable to PDF/Excel. All code must follow Laravel best practices (service layer, policies, queues where needed) and be cleanly documented. Responsive Blade or Vue components are fine as long as they integrate smoothly with the backend APIs. Deliverables 1. Fully functional modules deployed on my staging server. 2. SQL migration files and an ER diagram of the database. 3. Seed data for quick testing plus a short README for setup. 4. Unit / feature tests covering critical paths. Acceptance criteria will be a live demo on my server that shows each listed feature working under the assigned access roles. When you send your proposal, include: • A brief CV or portfolio link. • L...
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.