Using MySQL Database from Node.js [Guide]
Step by step guide for using MySQL database engine from Node.js
...Server on a dedicated Windows PC. The goal is to bridge our local, on-premise SQL Database with AI tools (such as Microsoft Copilot, Claude Desktop, or Cursor) so we can query our database securely using natural language. Remote Access & Working Method (Important): Full Remote PC Access Provided: You will be given direct remote desktop access to our dedicated Windows PC using AnyDesk, TeamViewer, or UltraViewer to perform the entire installation and configuration. Database Access: We will provide you with a secure, Read-Only SQL credential strictly for testing the database connectivity from the MCP server. Technical Environment: Host OS: Dedicated Windows 10/11 Pro PC (connected via local LAN). Database: On-Premise SQL Server (Local Network). MCP Protocol: ...
**Project:** Autism Therapy & Rehabilitation Centre Website **Technology:** ASP.NET Core (.NET 8/9) + SQL Server + Admin Panel **Languages:** English & Arabic (RTL Support) **Responsive:** Mobile, Tablet & Desktop --- # 1. Home Page * Hero Banner * About Us Summary * Services Overview * Why Choose Us * Statistics Counter * Testimonials * Parent Stories * Upcoming Events * Latest News * Videos * Call to Action * Book Appointment * Contact Information * Footer --- # 2. About Us * About Organization * Director's Message * Mission * Vision * Core Values * Our Team * Employee Testimonials --- # 3. Services Each service should have its own detailed page. * ABA Therapy * Speech Therapy * Occupational Therapy * Psychology * Any future services (manageable from Adm...
...experienced UiPath Solution Architect or Senior RPA Consultant to assist with a variety of automation projects on an as-needed basis. Requirements: Extensive experience with UiPath and enterprise-level RPA programs Strong knowledge of UiPath AI capabilities, Document Understanding, Intelligent Document Processing (IDP), UiPath Apps, Maestro, and related products Experience with API integrations, SQL, and system integrations Ability to gather requirements, analyze business processes, and design scalable automation solutions Experience building automation solutions from scratch, enhancing existing solutions, and migrating Windows-Legacy projects to Windows Ability to provide architecture guidance, best practices, and technical recommendations Preferred Experience: Large enterpr...
I am an older database programmer in need of up-to-date training on how to access and manipulate MySQL databases. I have had one of my website applications updated. It uses Hostinger Hosting for the host sql database on their Linux server. I am using Visual Studio 2026 Community with local host MySQL database. 1. I need someone in USA that can talk to me over the phone and Any Desk onto my desktop 2. Take a look at my Local Host MySQL database and show me a simple way to identify and view the tables, make direct changes to the data within the database, and insert new tables into the database. 3. Show me how to Back-up my operational database on the host server, and to copy my local host database over to the Hostinger server to replace the old database with the updated one. I...
I’m looking for a seasoned database administrator to take charge of our SQL Server environment for a Bank of India–related platform. The immediate focus is on keeping the core banking data layer fast, resilient, and secure. Here’s what the assignment covers: • Database optimisation – analyse slow queries, tune indexes, and improve overall throughput without disrupting live operations. • Backup & recovery – design and automate point-in-time backups, test restores regularly, and document the full recovery strategy. • Security management – harden user roles, apply the latest patches, set up auditing, and make sure compliance standards are met. You’ll be handed full access to a staging instance first, followed by product...
Swiggy Sales Data Analysis Analyzed a large Swiggy orders dataset (196K+ records) using SQL and Python. Performed data cleaning, handled missing values and outliers, and conducted exploratory data analysis to identify sales trends, customer behavior, restaurant performance, and order patterns. Created visualizations and generated actionable business insights to support data-driven decision-making. Blinkit Sales Dashboard (Power BI) Designed an interactive Power BI dashboard to analyze sales performance, product categories, outlet performance, and customer purchasing trends. Used Power Query for data transformation and DAX measures to calculate KPIs, enabling stakeholders to monitor business performance effectively. Used Car Price Prediction Built a machine learning regression model ...
...generation system. • Modify or recreate the report template. • Ensure reports are generated in the required format. • Test the changes and provide the updated project files. Required Skills • Strong experience with Beijer HMI (iX Developer or Information Designer, depending on project). • Experience with HMI backup restoration. • Experience in report template design/modification. • Knowledge of SQL/CSV/XML reporting is a plus. • Ability to work remotely via AnyDesk or TeamViewer if required. Deliverables • Updated Beijer HMI project. • Modified report template. • Tested report generation. • Source files and project backup. Please Include in Your Proposal • Your experience with Beijer HMI projects. • Similar rep...
Full Stack developer having 10+ .NET Core/Angular exp Design, develop, and maintain robust and scalable web applications using .NET Core for the backend and Angular 19 for the frontend. Implement server-side logic, APIs, and database interactions using C#, .NET Core, Entity Framework, and SQL Server (or other relevant databases). Develop responsive and interactive user interfaces using Angular, HTML, CSS, JavaScript/TypeScript, and related libraries (e.g., Angular Material, RxJS). Integrate frontend and backend components, ensuring seamless data flow and communication via RESTful APIs. Write clean, efficient, and testable code, adhering to coding standards and best practices. Participate in all phases of the Software Development Life Cycle (SDLC), including requirements gathering, ...
...slicers for date ranges, channels, devices, and customer segments, plus eye-catching KPI cards that flag outliers automatically. Deliverables 1. A .pbix file with all visuals, DAX measures, and a data model optimized for incremental refresh 2. A short video walkthrough (or step-by-step PDF) explaining navigation, key calculations, and how to add future data fields 3. Basic documentation of the SQL or Power Query steps used to connect to the sales database so my internal team can maintain it Acceptance criteria • All figures reconcile 100 % with a validation export I will provide • Page-load time under five seconds on first open • Filters update visuals in real-time without errors If you have built similar regional sales dashboards before and can shar...
...• A lightweight dashboard should let me set or change the VPS credentials, target directory/bucket, and basic scheduling/queue rules. • A simple activity log (with date, time, and status) must show successful transfers and flag any failures so we can resend with one click. Preferred stack I’m comfortable with you using Java/ C#/.NET (WinForms or WPF) plus a small local SQLite or lightweight SQL database for logs, but I’m open to alternatives that meet the same reliability and security standards. Deliverables 1. Compiled Windows installer (x64) 2. Full source code with build instructions 3. Local machine installetion /Cloud deployment (we have linux server) /connection guide for at least one mainstream VPS option 4. Brief user manual and change ...
We are seeking a...the United States and Canada. This comprehensive application will feature an automated Claims Processing System with secure document uploads and fraud detection, a robust Policy Management System handling billing, renewals, and reporting, and a highly responsive web and mobile Customer Portal built with React and React Native. The backend must run on Node.js with Express, utilizing a relational SQL database fully compliant with North American insurance regulations and connected via clean REST APIs. To successfully complete this project, the chosen freelancer must deliver a fully functional staging environment, lint-clean source code in a CI-enabled Git repository, reproducible database migration scripts, and complete documentation, including a short setup walkthro...
...develop scalable ETL and ELT pipelines • Integrate data from APIs, databases, files, and third-party platforms • Build and optimize data warehouse models • Write efficient Python and SQL code • Configure workflow orchestration, monitoring, logging, and error handling • Troubleshoot pipeline failures and performance issues • Implement data-quality checks and validation processes • Document the architecture, pipelines, and deployment procedures • Communicate progress and technical risks clearly through Freelancer.com Required experience: • Strong professional experience in data engineering • Advanced Python and SQL skills • Experience with ETL and ELT pipeline development • Experience with relational databases and...
...acquisition specialists who regularly receive technology projects but may not have the execution capacity or technical team to deliver them. If you can bring qualified client projects, I can manage the complete delivery through my trusted technical network. ### Our Delivery Capabilities AI / Machine Learning Solutions Python Development PHP Laravel Web Development Manual Software Testing (QA) SQL & Data Solutions Project Management Product Ownership & Product Management Technical Project Coordination Business Process Automation Technical Documentation & Process Mapping ### How It Works -- You bring the client/project. -- We mutually finalize the project scope, budget, timeline, and delivery plan before work begins. -- I coordinate the project and collaborate with...
I’m running a commercial off-the-shelf application whose back-end is a PostgreSQL database. All image assets live inside the tables in a proprietary, native format, and I now have to extract every file to disk so they can be used as regular JPEG, PNG or TIFF images. What I need from you is a small, well-documented set of scripts—SQL to query the right tables plus a helper utility (Python, Bash or any portable language you prefer)—that will: • Locate every image record, read the binary/native data and write it out to disk • Convert or rename the output so it ends up as standard JPEG, PNG or TIFF, preserving original metadata wherever possible • Organise the exported files into a sensible folder structure (by ID or timestamp) • Produce a s...
...actionable insight that drives day-to-day and strategic decision making. During a two-week training period you will be onboarded to our current databases, data-collection procedures, and reporting cadence; that phase is compensated at $25 per hour. Once fully ramped, regular work is billed at $60 per hour, with monthly earnings expected in the $25k–$45k range. Scope of work • Connect to existing SQL tables, cloud storage, and Excel feeds, then clean and consolidate the data. • Build repeatable Python or R scripts (your choice) that automate descriptive and diagnostic metrics. • Design intuitive dashboards in Power BI or Tableau so non-technical managers can track KPIs in real time. • Present findings and recommendations in brief, executive-ready...
I need an experienced systems engineer who can dive straight into our Windows Server 2012 R2 environment and a fleet of Windows 10 workstations. The first assignment is to stabilise, harden, and document these platforms, but you will also touch the broader estate that includes LAN/WAN gear, backups, MS-SQL, IIS 8+, and collaboration services such as Office 365, OneDrive, and G-Suite. Day-to-day you will: • Review and correct Active Directory, Group Policy, DNS, DHCP, and IIS configurations. • Patch servers and desktops, close security gaps, and verify compliance. • Optimise login scripts, roaming profiles, and folder redirection for Windows 10 users. • Troubleshoot escalated tickets through our help-desk tool and provide clear resolution notes. • ...
...role. We're looking for someone who can find potential clients, communicate with them professionally, understand their requirements, and close deals. Once the client is onboarded and the advance payment is received, our technical team takes over the project. Services We Offer Power BI Dashboard Development & Data Visualization Data Analytics & Business Intelligence KPI Dashboard & MIS Reporting SQL Database & Data Management Custom Software Development Website Development Android App Development Manual Software Testing & QA API Testing (Postman) Bug Reporting & Quality Assurance Your Responsibilities Find businesses that require any of our services. Reach out through your preferred channels (LinkedIn, cold email, networking, etc.). Communicate on beha...
I have a brief BCA homework-style exercise that should take a seasoned developer no more than 10–15 minutes. The front-end portion must be written in JavaScript, and if dropping the snippet into React makes things faster for you, feel free. For the back-end you can use Python with either SQL or NoSQL storage—whatever lets you ship clean, working code quickest. Here is what I need from you: 1. A fully functioning solution that compiles/runs without tweaks. 2. Code that is clearly organised and easy to read. 3. A concise explanation (a few sentences or well-commented lines) so I can understand the approach and reference it later. I’m online right now and ready to test as soon as you share the files or repo link, so please only bid if you can start immediately and w...
Azure Data Factory + Azure SQL Expert Needed to Debug and Implement Data Processing Change Description I'm looking for an experienced Azure Data Engineer with strong knowledge of Azure Data Factory, Azure SQL, SQL Stored Procedures, and Databricks to help implement a change in an existing production data pipeline. Environment Azure Data Factory Azure SQL Database Mapping Data Flows Azure Data Lake Storage (ADLS) Databricks SQL Stored Procedures Current Situation I have already completed the initial analysis: Identified the source table. Traced the ADF pipeline. Reviewed the Mapping Data Flow. Identified the destination Azure SQL table. Identified SQL views and stored procedures referencing the table. Reviewed one of the stored proc...
...acquisition specialists who regularly receive technology projects but may not have the execution capacity or technical team to deliver them. If you can bring qualified client projects, I can manage the complete delivery through my trusted technical network. ### Our Delivery Capabilities AI / Machine Learning Solutions Python Development PHP Laravel Web Development Manual Software Testing (QA) SQL & Data Solutions Project Management Product Ownership & Product Management Technical Project Coordination Business Process Automation Technical Documentation & Process Mapping ### How It Works -- You bring the client/project. -- We mutually finalize the project scope, budget, timeline, and delivery plan before work begins. -- I coordinate the project and collaborate with...
I need a skilled full-stac...database. Key expectations • Clean, well-commented code organized by MVC best practices. • Fast load times, on-page SEO fundamentals (semantic markup, meta tags, friendly URLs), and accessibility considerations. • Protection against common attacks (CSRF, XSS, SQL injection) and sensible rate-limiting on auth routes. • Clear setup documentation so I can deploy the project on a typical LAMP/LEMP server. When handing over the project, please include: 1. The complete Laravel project folder with all source files. 2. SQL export of the schema and seed data. 3. A short README detailing installation, environment variables, and build steps. If you have recent Tailwind + Laravel work to show, I’d love to review it a...
...creation, renewals, billing & payments, plus on-demand report generation. • Customer Portal – a responsive web and mobile experience that lets policyholders track claims, download documents, pay invoices, and update account details. All front-end work will be written in React for the web and React Native for iOS and Android. The back-end will run on Node.js with Express, relying on a relational SQL schema that you will design for compliance with North-American insurance data standards. Clean REST APIs, unit tests, and clear documentation are expected so that future actuarial and underwriting services can plug in without friction. Acceptance criteria 1. Each module functions end-to-end in a staging environment, passing user flows and edge-case tests. 2. Sour...
**Project Title:** Data Processing & Clea...* Handle inconsistent or incorrect data entries * Perform basic transformations and feature engineering * Generate summary statistics and insights * Output clean dataset in CSV / Excel format **Technical Skills Required:** * Python * Pandas, NumPy * Data Cleaning & Preprocessing * Basic Data Analysis **Optional (Preferred):** * Data visualization using Matplotlib / Seaborn * Experience with SQL or database integration **Deliverables:** * Well-structured Python script * Cleaned and processed dataset * Brief documentation explaining the workflow **Project Goal:** To convert raw, unstructured data into a clean and usable format for analysis and decision-making. **Budget & Timeline:** (Open for discussion based on experienc...
...access policies, service accounts, and role-based access control (RBAC) for enhanced cloud security. * Designed and configured Google Cloud VPCs, subnets, firewall rules, private networking, Cloud NAT, Cloud Router, and Private Service Networking. * Configured Google Cloud DNS, SSL certificates, HTTPS load balancing, and Kubernetes Ingress for secure internet-facing applications. * Managed Cloud SQL PostgreSQL databases, including provisioning, connectivity, authentication, backups, and performance optimization. * Implemented Redis caching using Google Memorystore to improve application performance and reduce database load. * Integrated Google OAuth 2.0 authentication into the application with secure client configuration and redirect URI management. * Configured NGINX as a ...
Customer Data Analysis using SQL: Recently completed a hands-on Customer Data Analysis Project using SQL, where I explored and analyzed 81,446+ customer transaction records to uncover valuable business insights. Key Analysis Performed: Identified total transactions based on gender, product category, and payment method. Analyzed which gender purchased the highest number of products. Calculated total revenue generated by each gender. Compared category-wise transactions, units sold, and revenue. Evaluated purchase patterns across categories and genders. Examined payment method-wise revenue and transaction performance. Segmented customers into different age groups to analyze buying behavior. Found the age group with the highest product purchases. Identified the most fr...
I need a full-stack ASP.NET web application—C# on the back end, SQL Server for data—delivered in both English and Arabic with complete RTL rendering on every screen. The build is split into two clear areas: External Applicant Portal • Public registration form that captures entity details and uploads supporting documents. • Submission triggers a reference number so applicants can log in later and track real-time status updates. • All outward-facing pages must switch seamlessly between English (LTR) and Arabic (RTL) without layout shifts. Administrative Portal • Review queue showing every incoming application and its attachments. • Configurable, multi-level approve / reject workflow. Each step records the acting user, decision, and time...
I have an active MySQL database that has gathered duplicates, incomplete fields, and a few broken relationships over time. I need focused help cleaning this existing data set so every table is consistent and reliable again. Your task is limited to data cleaning; I will handle any future insertion work or query tuning myself. Deliverables • A cleaned SQL dump or set of migration scripts ready for direct import • A short report outlining the issues you found, the steps you took to fix them, and any preventive measures you suggest Acceptance Criteria • Duplicate rows and orphaned records are removed • Mandatory fields contain valid, properly formatted values • All foreign-key relationships pass integrity checks without errors Feel free to work wi...
...sheets, model the data cleanly, and design compelling visuals that let me slice and drill down without having to touch the underlying files. You are free to suggest the most meaningful charts and KPIs once you see the data, but the refresh must remain one-click simple: whenever I replace the source Excel files, the dashboard should update automatically. If you think an additional source—such as a SQL database or an online service—would improve insights later on, please note it in your proposal; for now everything needs to function with Excel alone. Deliverables: • A fully-functional .pbix file linked to my Excel data • Any DAX measures and data-cleaning steps documented within the file • A brief PDF or video walkthrough showing how to refresh and...
...Database * PostgreSQL * Redis * MongoDB (optional for analytics) ### Authentication * JWT Authentication * OAuth (Google, GitHub) * Two-Factor Authentication (2FA) ### Cloud & Deployment * Docker * Nginx * AWS / Azure / DigitalOcean * CI/CD Pipeline using GitHub Actions --- # Security Requirements * HTTPS encryption * Role-based access control * Secure authentication * Password hashing * SQL injection protection * XSS protection * CSRF protection * API rate limiting * Automated backups * Activity logging --- # Performance Requirements * Fast page loading * Server-side rendering (SSR) * Image optimization * CDN support * Database indexing * Caching with Redis * Lazy loading * API optimization --- # Future Enhancements * AI-powered content recommendations * AI wri...
...Analytics concepts right through to intermediate-level AI insights. The audience is a batch of students who already use data in their daily roles, so the sessions must balance theory with immediately applicable, tool-driven practice—think exploratory data analysis, statistical modelling, predictive analytics and an introduction to generative AI techniques using mainstream platforms such as Excel, SQL and Power BI. I need offline trainer: • A complete training roadmap broken into daily objectives, and assessment checkpoints • Slide decks, datasets and code notebooks that I can keep for future cohorts • Brief post-training reports on participant progress and next-step recommendations Deployment details • Venue: Vijayawada campus (fully equipped la...
...take real time on its own. What I need help with: Download, safely unzip, and inspect the contents of the backup — ideally in an isolated/local environment, not uploaded directly to a live server, since the original site was compromised Determine what's actually in the archive — specifically whether it includes only site files (theme, plugins, wp-content/uploads) or also a database export (a .sql file), since my articles/post text live in the database, not in the file structure, unless a database dump was included If a database file is present: extract and recover my articles/blog posts from it If no database file is present: help recover as much article content as possible through alternative means (e.g., reconstructing from cached files, checking for Word...
I’m updating an existing database and need a reliable hand specifically for data entry work focused on database updating. The core of the assignment is data cleaning and val... then correct or flag them. • Validate key fields using simple logic checks or cross-referencing with reference lists I’ll provide. • Upload the cleaned data back into the database (MySQL via phpMyAdmin) and confirm row counts match. Deliverables will be weekly cleaned-data files plus a brief change log that notes what was fixed, removed, or added. Familiarity with Excel functions, basic SQL commands, and an eye for detail is essential. If you’ve handled similar data entry and maintenance tasks before and can commit a few hours each week, I’d be happy to hear how you c...
...already use on the web version • A payment gateway to handle one-time and recurring purchases All endpoints must return JSON, follow REST conventions, and include basic rate limiting and error handling. I’ll share the current app flow, screen states, and sample payloads the moment we start, so you can stub everything quickly and then move to production-ready code. Deliverables • MySQL schema (SQL dump + ERD) • Deployed MySQL instance (cloud of your choice) • API source code with clear instructions to reproduce locally and on the chosen host • Postman or cURL collection for testing every route • Integration inside FlutterFlow with working data queries and mutations Acceptance criteria 1. CRUD operations complete in under 300...
...Maintenance Contract) management SLA monitoring and escalation Spare parts and inventory tracking Dashboard with real-time ticket status and analytics Email/WhatsApp notifications Role-based user access (Admin, Manager, Coordinator, Technician) Mobile-friendly interface for field technicians Report generation and export (PDF/Excel) Preferred Technology: Modern web-based application REST API architecture SQL database Cloud or on-premises deployment Experience integrating with third-party systems is an advantage...
...Develop and maintain modern web applications. Build responsive, user-friendly frontends. Design and implement scalable backend APIs. Integrate third-party services and APIs. Improve application performance and reliability. Collaborate on new features and technical decisions. Preferred Skills JavaScript / TypeScript React, , Vue, or Angular Node.js (Express or NestJS) REST APIs and/or GraphQL SQL or NoSQL databases Git and modern development workflows Cloud platforms (AWS, Azure, or GCP) are a plus We're Looking For Someone Who Is currently based in the United States. Has strong communication skills. Writes clean, maintainable code. Can work independently and meet deadlines. Is reliable and interested in a long-term collaboration. Nice to Have Experience with AI integrations ...
...AI or rule-based automations—for example, predicting bottlenecks or surfacing overdue tasks—so managers see issues before they escalate. • Provide an architecture that leaves room to add classic workflow features such as task management, automated notifications, or progress tracking when we scale. Preferred stack I’m most comfortable with common analytics tools—Python (Pandas, scikit-learn), SQL, Power BI or Tableau for visualization, and a cloud database (PostgreSQL, BigQuery, or similar). If you have an alternative stack that hits the same goals, feel free to suggest it. Deliverables 1. A functioning web-based (or easily hosted) workflow optimization dashboard tied to my three data streams. 2. Annotated source code plus an ETL script or pi...
...The platform must be architected for high scalability and security, offer a responsive SPA-style interface, and feel instantly familiar to corporate users. Scope of work • Back-end: Design and implement a modular service layer (REST or GraphQL) that handles employees, clients, projects, jobs, attendance, gate passes, documents, KPIs, and reporting. A relational store such as PostgreSQL or MS SQL is preferred, with ORM migrations and role-based access control baked in from day one. • Front-end: Build a clean, lightning-fast UI in React, Angular, or Vue with TypeScript, real-time validation, and adaptive layouts that work equally well on desktop dashboards and tablets used on-site. • DevOps: Containerise the stack (Docker, Kubernetes or similar), wire up CI/CD...
...model and workflows. • Outline an extensibility plan (plugin or micro-services) so future features can be added without major refactoring. • Recommend a CI/CD pipeline for automated builds, unit tests and signed installers for Windows. Deliverables (acceptance criteria) 1. Architecture document (PDF/Docx) clearly describing design decisions, diagrams and technology choices. 2. ERD and SQL scripts ready to run on the suggested database engine. 3. Clickable wireframe or prototype demonstrating the main data-entry, search and reporting screens. 4. Source-controlled skeleton project that compiles on Windows 10/11, implements the agreed layering, and includes sample unit tests. 5. Read-me file that details build prerequisites and deployment steps. I can pro...
...overdue accounts and show real-time revenue dashboards. • Reporting – export attendance logs, membership statistics and financial summaries to CSV/PDF at the click of a button. I’ll need both the compiled installer and full source code, plus concise setup instructions so staff can deploy the app on multiple front-desk PCs. A modern, clean UI, easy navigation and solid local database (SQLite, SQL Server or your recommended option) are essential. Acceptance criteria: 1. Fingerprint scan records appear instantly in the member’s profile. 2. New member form captures all required fields and edits save without error. 3. Invoice PDF matches our sample template and marks as “paid” once a receipt is entered. 4. All reports export correctly a...
I’m updating an existing database and need a reliable hand specifically for data entry work focused on database updating. The core of the assignment is data cleaning and val... then correct or flag them. • Validate key fields using simple logic checks or cross-referencing with reference lists I’ll provide. • Upload the cleaned data back into the database (MySQL via phpMyAdmin) and confirm row counts match. Deliverables will be weekly cleaned-data files plus a brief change log that notes what was fixed, removed, or added. Familiarity with Excel functions, basic SQL commands, and an eye for detail is essential. If you’ve handled similar data entry and maintenance tasks before and can commit a few hours each week, I’d be happy to hear how you c...
I have a small (under 5 GB) Azure SQL Database that must be brought in-house and run on SQL Server Express 2022. Every object—tables with their data, stored procedures, functions, views and indexes—needs to make the trip intact so the system behaves exactly as it does today. Once the database is sitting in SQL Server Express, the legacy VB6 application that currently points to Azure has to reconnect seamlessly. That means updating the connection logic, testing all critical screens and reports, and confirming read/write operations work without timeout or syntax issues. Preferred workflow • Export or script out the Azure database, then restore or import into SQL Server Express 2022 using SSMS, Azure Data Studio, or the Data Migration Assistant...
...need an SSRS specialist to design and/or refine several tabular reports that sit on top of an existing SQL Server data source. The goal is to achieve clean, parameter-driven output that users can export instantly to Excel or PDF without additional formatting. Here is what I will provide: • Access to the database (SQL Server 2019) with sample data and the current schema • Business rules that determine which fields, filters, and aggregations must appear • Branding guidelines (logos, colours, fonts) What I expect from you: • Well-structured .rdl files that follow SSRS best practices (shared datasets, expressions kept in code where possible, consistent naming) • Optimised T-SQL queries or stored procedures where report performanc...
...applications from idea to deployment. Key Requirements (Must-Have): ✅ Language: FULLY BILINGUAL in English and Spanish (professional fluency – C1 or above). You will be interviewed and tested in BOTH languages. ✅ Frontend: Strong experience with React.js, , or Vue.js. ✅ Backend: Strong experience with Node.js () or Python (Django/Flask). ✅ Databases: Experience with SQL (PostgreSQL/MySQL) or NoSQL (MongoDB). ✅ Tools: Git, GitHub, and comfortable with remote collaboration tools (Slack, Zoom, etc.). Nice-to-Have: Experience with Docker, Kubernetes, or cloud platforms (AWS/GCP/Azure). Previous experience working in fully remote teams. What We Offer: Fully remote work (flexible hours). Starting rate: $30/hour (negotiable based on experience). Long-term opportunit...
...library/database. • A dedicated About Me/Team section drawn from the existing page content and formatting. You are free to reinstall Divi (if you hold a license) or replicate the design with an alternative theme or builder—Elementor, Gutenberg blocks, or custom PHP/CSS are all acceptable as long as the final result matches the original styling and responsiveness. I’ll provide: • Full site files and SQL backup • cPanel / hosting credentials for a staging sub-domain • Screenshots of the former design for reference Completion is confirmed when the rebuilt site: 1. Displays all portfolio items in a responsive grid on desktop, tablet, and mobile. 2. Shows the About Me/Team section styled consistently with the rest of the site. 3. Pass...
Need a website for our boutique brand. Need a modern, visually "stunning" website with smooth animations an...Media connectivity and access, Instagram recent posts and other necessary sections. Out of scope: User Accounts, online shopping. Should be functioning on all screen sizes. We will provide: logos, brand colour palette, videos and photos. Bonus: if website content should be configurable. Technical Requirements: To be designed in React.js with Redux Following strict component based design pattern A SQL/MySQL database holding Product and configuration. Behavioural Tests to be delivered for all workflows and critical component in Selenium/Playwright. Inspirations: Winning project will be between => 14,000 - 18000 INR
I n...edits. Core Functionality • Contact Us page must include a form that validates input and saves each submission to a MySQL table. • A lightweight success message (or modal) should confirm to users that their message was received. Deliverables • Fully responsive Home, About Us and Contact Us pages. • PHP scripts that handle form processing, input sanitisation and database insert. • SQL file (or clear setup notes) to create the required table. • Brief deployment/read-me so I can drop the project onto my server and go. Timing & Collaboration I’m aiming to sign off within 10 days, so clear checkpoints and a sensible milestone split will help us both stay on track. Links to similar work or quick wireframes are a plus&mda...
I need a seasoned SSRS developer to turn a SQL Server data set into a polished compliance-audit report. My top priority is the visual structure—nested tablixes, precise grouping, conditional colour cues, warning/approval symbols, image placeholders, and reliable page breaks all have to work together so the PDF reads like a board-ready document. You will receive the database objects, sample data, and a style guide. From there, build the RDL yourself (no AI-generated one-click templates), and keep notes on why each region, expression, and parameter exists; I’ll ask you to walk me through that reasoning once the draft is ready. Deliverables • Production-ready .rdl file matching the style guide • A short design brief (1–2 pages) explaining layout choice...
...anything that falls outside the accepted formats, and leave me with a reliable, production-ready dataset. The work is entirely validation-driven: you will compare stored values against the reference rules I supply, normalise units, fix capitalisation, catch misplaced decimals, and make sure linked fields stay in sync. A portion of it will be manual review, but you’re welcome to speed things up with SQL queries, Excel filters, or any data-wrangling tool you prefer, as long as the final result is accurate. Deliverables • A cleaned and validated database file (same structure, corrected content) • A concise log or report of the changes made, so I can audit what was touched Acceptance criteria • No duplicate primary keys or records • All required fie...
...- Conduct a complete security audit of our application. - Identify vulnerabilities in the web application, APIs, database, and server. - Perform penetration testing and vulnerability assessment. - Review the application against the OWASP Top 10. - Analyze authentication, authorisation, session management, and input validation. - Review API security and identify potential attack vectors. - Assess SQL injection, XSS, CSRF, SSRF, IDOR, file upload, and other common vulnerabilities. -Review Linux server configuration and security hardening. - Assess cloud security configuration (if applicable). - Review source code for secure coding practices. - Investigate any suspicious activity or security incidents if discovered. - Provide a detailed report of findings, risk levels, proof of conc...
We are a financial service company looking for an experienced Full-Stack Developer or a small team to deploy our pre-built React-based Loan Management System, migrate its data layer from Firebase/Mock to a robust SQL Database (MySQL or PostgreSQL) with a secure Node.js backend, and build 2 companion Android apps that sync with this centralized database. The web portal's user interface, screens, states, and business logic are 100% complete and built in React (TypeScript) + Tailwind CSS + Vite. You only need to build the SQL backend, wire the API endpoints, build the Android applications, and go live on our custom domain.
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.