SQL Jobs

I’m running a web application on a custom-built PHP framework and it currently sits on an ageing database that I now want fully migrated to MySQL. The job is strictly a database migration—no codebase refactor is required at this stage—so the focus is on cleanly lifting all existing data structures and records into a fresh MySQL schema while keeping the application functional throughout the transition. What I’ll hand over: the current schema dump (or direct access if you prefer), sample data, and a brief outline of the application’s data flow so you can map dependencies accurately. What I expect back: • A MySQL-ready schema that mirrors the original structure, optimised where obvious gains are available (indexes, data types, constraints). • Reli...

I need a data analytics expert to analyze key datasets. Key requirements include: - Analyze sales, customer, and operational data. - Identify trends, make predictions, and improve efficiency. - Deliver insights for reports, business decisions, and strategy development. Ideal skills and experience: - Proficiency in data analytics tools (e.g., Python, R, SQL). - Strong analytical and statistical skills. - Experience in generating actionable insights from complex datasets. - Ability to communicate findings clearly. If you have a proven track record in data analytics and can work within my budget, I would love to hear from you.

I am looking for a talented developer or small team to build a "Website-as-a-Service" (WaaS) platform for my boutique agency. This system is for attorneys who need a high-quality website with integrated communications. The Scope: Headless WordPress Multisite: Set up a network where I can manually "clone" sites for new clients. 10 Master Templates: Build 10 high-end, clean attorney website templates using Elementor Pro or other. You may ask ai to generate 10 switchable attorney website templates. The color Switcher: After you've created the templates, Create a simple slide-in panel that allows users to pick from 20 pre-set color schemes (using CSS variables). Ask ai to recommend the color schemes or send me the templates and i can decide on the color schemes for yo...

I need a reusable ETL framework built inside Databricks notebooks, version-controlled in Bitbucket and promoted automatically through a Bitbucket Pipeline. All source data arrives via GraphQL APIs, so the job includes handling authentication, pagination, and schema inference before landing raw payloads in Delta tables. A dedicated cleaning stage must then standardise and validate the data before it moves on to the curated layer. The structure should be modular—ideally a bronze/silver/gold notebook hierarchy—so I can slot in new sources or extra transformations without touching the core logic. I also want a lightweight Python package (wheel) that wraps the GraphQL connector and can be attached to any cluster. Acceptance criteria • Parameter-driven notebooks organised by...

I have several months of raw sales data sitting in mixed Excel/CSV files and a small SQL dump. I need that information cleaned, organised, and explored so we can finally see what the numbers are really telling us. After the data is trustworthy, I want to zero-in on three priorities: revenue trends over time, customer acquisition and retention behaviour, and sales performance broken down by region. Power BI is my preferred canvas for the visuals. Please build an interactive dashboard that lets managers slice by date, product line, and region while keeping the layout simple enough for non-technical teammates. If you also know Tableau or advanced Excel, great, but the .pbix file is the deliverable that matters most. Once the dashboard is live, I’ll need a short narrative (one-to-two p...

I'm seeking a consultant based in Johannesburg South Africa, with strong experience in Power BI, Power Automate, and knowledge of Syspro for a 6-month engagement. The goal is to build tables and dashboards and automate some of our internal workflows. Key Responsibilities: - Building tables and dashboards in Power BI - Automating internal workflows using Power Automate - Connecting to SQL databases and Excel spreadsheets as data sources - Ensuring that both management and operational teams can effectively use the outputs Ideal Skills and Experience: - Strong expertise in Power BI and Power Automate - Proficiency in SQL and Excel - Familiarity with Syspro - Experience in creating user-friendly dashboards for management and operational teams Please provide examples of similar projects...

I need a Windows-based desktop program that follows each sofa, chair, or table we build from the moment it is sold right through to the truck leaving our dock. The flow should start with order entry, automatically raise the fabric purchase request, then guide the piece through cutting, frame-building, upholstery, packaging, and finally shipping. At every stage I want a clear status board and simple way to update progress so the whole team can see what is waiting, what is in work, and what is finished. A small local SQL database is fine as long as it scales to a few dozen simultaneous users; if you prefer another lightweight option, mention it and why. The interface must be straightforward—touch-friendly for the shop floor, keyboard-driven in the office—so staff can scan a barc...

Our Magento 2 store suddenly refuses to complete the Product Price reindex and shows the familiar “no linked stock” message. Nothing was updated, no extensions were added, and I haven’t tried any quick-fix SQL scripts or CLI commands yet, so you’ll be starting with a clean slate. I’m looking for someone who has already wrestled with this specific indexing glitch and can get the catalog back to a fully reindexed state without disrupting live traffic. Acceptance criteria / deliverables: • Identify the root cause of the “product price index – no linked stock” error and document it briefly. • Apply the corrective fix (database clean-up, configuration adjustment, or code patch) on our staging site, demonstrate a successful bin/magent...

Looking for help to make and Setup account in POWER BI Pro

Please Sign Up or Login to see details.

My goal is to turn a messy collection of raw files into a clean, analysis-ready dataset hosted on Google Cloud so I can make faster, well-informed decisions. The data first needs three specific text-cleaning steps—removing duplicates, correcting typos, and standardising formats. Once those tasks are automated, the cleaned output should flow straight into a Google Cloud environment (BigQuery is ideal, but Cloud Storage plus Cloud Functions works too). After the upload, I want an exploratory analysis that highlights patterns, trends and any obvious outliers that deserve attention. Deliverables • Well-commented scripts or workflows that automate duplicate removal, spell-checking and format standardisation • A repeatable pipeline that loads the cleansed data into Google C...

I need every bit of information currently stored in my Tally company—masters, vouchers, inventory, bank transactions, statutory ledgers, the lot—pulled out once and delivered in a clean, tabular Excel workbook. The extraction must be fully automated (TDL, ODBC, or any method you’re comfortable with) so I can rerun it later, but this engagement covers a single execution and hand-over. Deliverables • An Excel file where each dataset appears as a properly labeled table, with field names matching Tally, dates and numbers intact, ready for analysis or import elsewhere. We will provide Tally data file. Let me know which approach you prefer (TDL, ODBC, etc.) and how quickly you can turn the finished workbook around. Please also advise your working days and hours.

Need help writing a 3-line script in Oracle 4GL based on pseudo logic related to VEE rules and VEE group. The deliverable is the script only, as testing and documentation will be handled separately.

React Native / Expo Developer Needed 7-Day Sprint to Polish & Ship a Mobile App (Non-Profit) We’re looking for an experienced React Native / Expo developer to help us finalize and ship an existing mobile app. This is not a from-scratch build — the app is functional and well underway. We need help refining performance, completing integrations, and preparing for release. Source code is ready and available immediately. About the App The app combines two core experiences: A daily puzzle game — grid-based, touch-driven gameplay with a short interactive sequence after completion. A utility layer — a simple request-and-claim flow where authenticated users can view, claim, and log activity via a dashboard. Current State Built with React Native / Expo (Expo Go t...

I need about three hours of guided, screen-shared help moving product data that currently lives in several related Excel sheets straight into my PostgreSQL database. No transformations are required—just a clean import exactly as the data sits now. During the session we will • create or confirm the target tables and column types, • choose the quickest import method (COPY commands, pgAdmin’s import wizard, or any tool you prefer), • load every sheet accurately, and • finish by writing a few SQL queries to verify row counts, join related tables, and pull sample SKU-level results. Deliverables for me at the end of the call will be: • a working, repeatable import script or step-by-step notes; • the example SELECT queries we ran together; a...

It is my college final year project Basis. This project focuses on the design and implementation of a distributed NoSQL database system capable of handling large-scale, dynamic data with high availability, scalability, and strong consistency. The system uses dynamic sharding to automatically partition and distribute data across multiple nodes based on data growth and access patterns. It incorporates replication and consistency mechanisms such as quorum-based replication or distributed consensus protocols to ensure data integrity even during node failures or network partitions. The project aims to balance the scalability and flexibility of NoSQL systems with the consistency guarantees of traditional databases. Performance, scalability, and consistency are evaluated under different worklo...

I’m looking for a reliable way to mirror my on-premise SQL database to AWS RDS in real time. The web service you build will capture every change that hits the local tables—customer information, inventory data, and transaction records—then push those changes up to the cloud with minimal latency. My priorities are: • Zero data loss and consistent state between the two stores, even when connectivity drops temporarily. • Latency low enough to feel immediate to downstream apps that rely on the cloud copy. • A straightforward deployment path: I should be able to install the service on a Windows or Linux host beside the local database, point it at the RDS instance, and watch it run. Deliverables 1. Source code for the sync service (language and framewor...

I want to replace several manual reporting routines with an end-to-end AI workflow that ingests data from our internal finance databases and live web sources, then produces clear, timely analytics for management. Reporting and analytics are the sole focus—no transaction execution—so the system must excel at pulling, cleaning, and interpreting numbers rather than booking them. We also want to compare legal documents vs term sheets and excel spreadsheets Data sources • Company databases (SQL, flat files, Excel exports) - Dropbox all our files are in drop box • Extensive web scraping for competitor benchmarks and investment-market signals If you have ideas for safely adding external financial APIs later, let me know, but the two feeds above are mandatory. - Th...

I’m spinning up a brand-new SA-MP roleplay server and need a complete Pawn script built entirely from scratch. The end result should feel as if it came out of a polished commercial package: clean, modular, thoroughly commented, and fully optimized for desktop and SA-MP mobile clients alike. Core systems I must have • MySQL-driven account and character handling (registration, login, persistent data) • Job framework with at least a fully functional Police-Officer career path (duty toggle, arrest flow, ticketing, rank promotion, on-duty perks) • Faction, gang, and turf logic that can scale without performance drops • Business ownership with Clothing-Store mechanics (inventory, cash flow, stock restock, employee ranks) • Admin suite that, at minimum, s...

I want a small-scale desktop application built in Java that I can dissect later for study. The core requirement is a clean Swing interface that performs the usual Create, Read, Update and Delete operations against a MySQL database. Think of something like a simple student, product or book manager: one main window with a table view and modal forms for adding or editing records. Please keep the code readable and tutorial-friendly. Inline comments that explain the reasoning behind key sections—especially JDBC connections, prepared statements, and event handling—are essential. Include a concise README that tells me how to import the project, run the SQL script to create the tables, and launch the application. Deliverables • Complete Java source code organised in packages &...

This project focuses on analyzing operational, customer, and outlet-level data for a Swiggy-associated food brand to derive actionable business insights and build interactive dashboards for decision-making. The objective is to track performance across outlets, understand customer complaints, monitor item availability, evaluate marketing campaigns, and identify revenue loss due to operational issues such as stock-outs and downtime. Scope of Work The project includes end-to-end data analysis starting from raw data understanding, cleaning, transformation, and visualization using Power BI and Excel. Key dashboards developed as part of this project include: Consolidated Complaint Dashboard To analyze customer complaints by category, outlet, time period, and severity, helping identify recur...

I need an experienced SQL professional who can take customer data sitting on a remote SQL Server and refresh the corresponding tables on our in-house server every day. The transfer must be reliable, consistent, and handled through SQL Server Management Studio (SSMS), as that is already part of our workflow and permissions model. Your job will be to analyse the source schema, map it cleanly to our destination tables, set up the daily pull / push routine, and keep concise logs so I can trace each run at a glance. Data consistency checks, graceful error handling, and verification reports are essential because the customer records drive several downstream apps on our side. The engagement is straightforward: configure the process, prove a few consecutive successful runs, document the step...

I need a concise technical blueprint that shows exactly how to print in Cityworks environment at through SQL Server Management Studio. The goal is to make sure a field on the form "DUP. BAD CHECK “ L-If a Bad Check fee (L-BADCHECK) is attached to a case, it's owed. Status, type, etc. do not matter. Same for L-DUPLCTE. L-DUPBC - this is either or both a bad check fee and a duplicate fee from historic records (Pre-migration) 30 - BC 20 - Dupe 50 - Both (Rare, if it exists) the Cityworks front-end application, then landing it in the back-end SQL database on a batch schedule. You’ll be working with: • Cityworks PLL (latest build) • Microsoft SQL Server 2019 + SSMS What I expect from you: • A clear, step-by-step document that maps Citywor...

I recently moved our 20-year-old automotive forum from vBulletin 4 to XenForo and everything is running smoothly on CloudLinux v9.7.0. The last piece still stuck in the past is our Photopost gallery. All photos, captions and user comments sit in that ageing MySQL database, tied to the old vBulletin user table. I need those images living in a modern, fully supported gallery that: • keeps the same single-sign-on with XenForo users (no extra log-ins) • preserves existing photo comments and album structure • presents the pictures in a clean carousel / slideshow view I’m open to whichever tool makes the most sense—XenForo Media Gallery, an external PHP/SQL package, or another solution—as long as it installs cleanly on CloudLinux and has an active support c...

I need expert guidance to install a database server on a Windows operating system. Key requirements: - Experience with Windows server environments - Advise and whats required to install Sequoia Server/ sofware. - Ability to provide clear, step-by-step installation instructions and best practices

We are looking for a senior full-stack engineer to take ownership of several live products and Smart TV applications. This is a long-term, part-time role focused on maintenance, improvements, and occasional new features. Our Platforms � � � � Apps Samsung TV (Tizen) LG TV (webOS) Android TV Responsibilities Maintain and improve existing websites and admin dashboards Maintain backend services and APIs Bug fixing, performance improvements, and refactoring Maintain and update Samsung & LG TV applications Assist with app store submissions and updates Communicate clearly about progress and risks Tech Stack Frontend: JavaScript, React / Backend: Node.js, REST APIs Databases: SQL / NoSQL Smart TV: Samsung Tizen, LG webOS Android TV (strong plus) Streaming / IPTV experience is a big plus Requ...

We are looking at consultant who has deep understanding of Oracle Finance, PPM, SCM APIs and their linkages with the functional modules and front end functionality

I need a hands-on Salesforce Marketing Cloud specialist who can jump in immediately and handle three core areas for me: email campaign setup, automated journey creation, and data management/segmentation. I have a mix of brand-new campaigns to launch as well as several live programmes that need ongoing optimisation, so you’ll be switching between building fresh content and fine-tuning what’s already running. Scope of work • Email Studio: build responsive templates, load creative, configure dynamic content, and schedule sends. • Journey Builder & Automation Studio: create multi-step automations, triggered sends, and lifecycle journeys that run reliably without manual intervention. • Contact Builder & Segmentation: audit existing data extensions, w...

I’m a concrete subcontractor who recently brought Trimble FieldLink into our workflow and now I need a focused trainer to get both my field crew and project managers up to speed. Scope of the sessions • Layout and Measurement – hands-on use of the RTS to stake footings, slabs, embeds and anchor bolts with live tolerances. • Point Creation and Management – building and editing point files directly from our Revit/CAD models and exporting accurate as-built data. • Software Integration & Data Management – smooth import / export between FieldLink, Tekla, Revit and our estimating database, plus naming conventions and file hygiene. Audience & format Field workers need practical job-site walkthroughs; project managers need the back-office wo...

I’m standing up a brand-new business-intelligence stack in Snowflake and need a reusable migration framework built with dbt and solid SQL. The framework has to pull from two kinds of sources—existing relational databases and the steady stream of CSV/Excel flat files our teams export—then land, cleanse, validate, and automate each load all the way into analytics-ready tables. Here’s what I’m after: • A dbt project structured for easy extension, complete with models, seeds, macros, and tests that enforce data-quality rules at every stage. • Parameterised SQL and Snowflake tasks/procedures that orchestrate fully automated loads, from raw landing zones through staging to final marts. • Built-in monitoring and reporting—leveraging dbt tes...

Our live data sits in a PostgreSQL instance and some key queries are beginning to drag. I need you to step in, profile what is happening, and carry out light-touch changes that immediately tighten up performance while outlining any deeper work we should schedule later. During the engagement you will: • Capture the worst-offending queries, analyse execution plans, and benchmark current response times. • Review the existing schema and indexing strategy, then create or adjust indexes, vacuum/analyze settings, configuration parameters, and any other low-risk tweaks that deliver quick wins. • Produce a concise report that documents every change, the before-and-after metrics, and recommendations for larger refactors I can present to the wider team. All updates must be backwa...

I have an SSIS package that pulls data from an Oracle database through an connection and loads it downstream for ETL processing. The transfer works, but network-level performance is far below what I need. Here is what I’m looking for: • Diagnose the current ADO.NET-to-Oracle connection, identify any network, buffer, or packet-size bottlenecks, and benchmark the baseline throughput. • Tune the SSIS data flow (buffers, rows per batch, commit size, async settings, etc.) and, if necessary, adjust the Oracle driver or provider configuration. • Provide an updated package or detailed change list so I can reproduce the performance gains in other environments. • Produce a concise report summarizing findings, before-and-after metrics, and next-step recommendations....

I want to build a payroll processing app for internal purposes only using: 1. Vercel → frontend + API 2. Supabase → database + auth + storage 3. Stripe → payments **Summary: The Essential Skill Set** Must know: ### **Languages** - TypeScript - JavaScript - SQL (Postgres) ### **Frontend** - React - - TailwindCSS ### **Backend** - Node.js - Supabase SDK - Stripe SDK ### **Security** - RLS - JWTs - Web security basics

I need help moving structured information that currently sits inside a batch of Word files into my SQL database. Every document follows the same template—think headings like Name, Address, Reference ID, Dates, and a few numeric fields—so once you see one you’ll immediately understand the layout of the rest. The job is pure data extraction from documents. You’ll read each Word file, pull the fields exactly as they appear, and insert them into the SQL tables I’ll provide. I will supply: • a sample of the Word template • the SQL schema with column descriptions • a small set of completed rows so you can confirm formatting Accuracy is key; any typos or misplaced values will create reporting issues downstream. Please make sure each entry match...

Job Description We are looking for an experienced Azure Data Engineer / Data Integration Specialist to design and implement a robust, scalable data pipeline that pulls data from the Blackbaud API and loads it into an Azure SQL Database using Azure Data Factory (ADF). The goal is to have a fully automated, secure, and monitored ETL pipeline that runs on a scheduled basis and supports future scaling. Project Scope 1. Data Ingestion Connect to Blackbaud REST APIs (OAuth authentication) Handle pagination, rate limits, and API throttling Extract multiple endpoints (e.g., constituents, gifts, transactions, etc.) 2. Data Transformation Clean, normalize, and structure raw API JSON Handle nulls, schema drift, and data type conversions Add audit fields (load date, source system, batch id) 3. Data Lo...

I need a professional to create a modern and ATS-friendly resume and cover letter tailored for a mid-level Data Scientist position. Requirements: - Resume for IT/Data Science/Software field - Highlight my skills: Python, SQL, Power BI, Excel - Add internship/project details - Format should be clean, professional, and easy to edit - Delivery in Word and PDF Soft Skills to Emphasize: - Communication - Problem-solving - Teamwork Ideal Skills and Experience: - Proven experience in resume writing for tech roles - Familiarity with ATS requirements - Strong understanding of data science industry and job requirements - Excellent writing and formatting skills

I need all core records—financial, inventory and sales—from our SAP Business One instance migrated into Tally Prime. This is a one-time move, not an ongoing sync, but the imported data must appear in Tally exactly as it does in SAP so the books tie out without manual adjustments. Because I’m not certain how much transformation or field mapping will be required, I’ll rely on your expertise with the SAP B1 DI-API/Service Layer and Tally Prime’s import utilities (XML, ODBC or any gateway you prefer) to identify gaps, create the mapping, and carry out the transfer end-to-end. If lightweight scripts, SQL queries or custom add-ons are needed, please include them and comment your code so I can maintain it later. Deliverables • Clean export from SAP B1 co...

I want to create a custom open AI like Claude, ChatGPT,Gemini etc so I can use for my internal use where I just need to upload customer documents and AI will give full 6-7 pages colurful report with our company logo with below mentioned details Loan eligibilty Details in Tabular Form in Tabular Form documents form Filling Details queries based on Past queried data

I want to create a custom open AI like Claude, ChatGPT,Gemini etc so I can use for my internal use where I just need to upload customer documents and AI will give full 6-7 pages colurful report with our company logo with below mentioned details Loan eligibilty Details in Tabular Form in Tabular Form documents form Filling Details queries based on Past queried data

Recruiting EI conference paper writers. There are four research directions available, and scholars/professionals with research or writing experience in related are cordially invited to cooperate in completing paper writing and submission. The specific topics are as follows: of High-Skill Talent Profiles and Application of Knowledge Graphs for the Hydropower Industry on the Data-Driven Digital Transformation Path of Human Resource Management 3.FP-Growth-Based Intelligent Task-Talent Matching Method in Flexible Organizational Scenarios on Intelligent Evaluation Model of Employee Performance Based on Imbalanced Data Mining Applicants are requested to choose one direction according to their expertise and briefly the relevant research or writing experience. We look forward to cooperating ...

I am completing a capstone project that must showcase end-to-end work inside Power BI. The source data sits in SQL Server and is modest in size—well under 10 k rows—so performance tuning will centre on clean Query Folding rather than heavy aggregation tricks. Here is what I need done: • Connect Power BI to the SQL Server instance through Power Query, document each step, and keep every transformation foldable. • Shape and load the tables, then model them with the correct many-to-many relationship where required. Please do this in the Model view so the links are visually clear. • Create essential DAX measures—CALCULATE(), RELATED(), and any supporting columns you find helpful—so the model answers typical summary and slice-and-dice questions. &bu...

I want to move beyond day-to-day administration and master the advanced stack of Oracle Database technologies through live online sessions. The trainer I am looking for should be an experienced Oracle DBA who can walk me through real-world scenarios, share best practices drawn from production work, and guide me as I practice each topic in my own lab. The areas I need covered are very specific: Performance Tuning, Backup & Recovery (RMAN), Data Guard, RAC, GoldenGate, ASM, and end-to-end migration, Mock interviews and upgrade strategies. Every concept should be backed by live demonstrations, scripts I can reuse, and practical troubleshooting tips. Because I learn best in an interactive setting, I prefer a schedule of live classes where I can ask questions on the spot and share my scre...

Job Title: Zoho Specialist Developer Company: We are a System Strategy and Implementation Australian company Location: Remote / WFH Type: Full-time Salary: Based on skills and Experience; paid in AU currency. Company Overview: Our company is a fast-growing Systems Agency company that provides innovative system solutions to businesses worldwide. We are looking for a Zoho Specialist Developer to join our team and help us build cutting-edge Zoho solutions that empower our clients to achieve their business goals. Job Description: As a Zoho Specialist Developer, you will be responsible for designing, developing, and maintaining system strategic solutions using the Zoho platform. Our team has a focus on providing our clients with 'Evergreen' Zoho system solutions. We focus on imp...

During statement-level regression testing I noticed that any policy carrying a premium tax—examples 01N6000098 and 600000000000809—now shows the wrong death benefit on the client statement. The PDF is pulling DEATH BENEFIT VALUE, yet it should reference TOTAL DEATH BENE VAL on Valm D. I need someone experienced with our policy management system’s data layer, statement generation logic (SQL extracts, mapping tables, Jasper / Crystal templates—whatever tool you prefer to work in), and general insurance data structures to: • Trace the field mapping used when the statement compiles. • Update or override it so the statement fetches TOTAL DEATH BENE VAL for any policy where a premium tax flag exists. • Regression-test at least the two sample policies ...

I need an experienced Workday integration consultant to plug reliable data into the HCM (sometimes called “HMM”) module so we can finally unlock the rich reporting features we’re paying for. The sole objective is to enhance reporting capabilities—no broader HR process overhaul for now, just crisp, automated data flows that feed powerful, real-time reports. Here’s how I see the engagement unfolding: • Assess the current data landscape, spotting gaps or redundancies that prevent us from building accurate reports. • Design and build integrations—EIB, Workday Studio, Workday Prism Analytics, or another tool you recommend—that funnel clean data into Workday tables used by Workday Report Writer. • Configure calculated fields and cust...

Background & Goal We're a medium size ecommerce retailer running on Netsuite for our ERP and Big Commerce for our front end website. We're looking for a data engineer to help build a data warehouse for Netsuite, Big Commerce, and potentially some other data platforms to help us analyse our data faster and more accurately. We wish to engage a third party data Engineer to build a central Data Warehouse in Google BigQuery (or other similar service). We want to analyse data in a data visualisation tool such as Power BI. We are also interested in other capability that we will be able to use the data warehousing for in the future (better exception reporting, better customer analytics, new sales & marketing opportunities, etc) We have a capable internal IT/Analytics team, howe...

Looking for a full-stack engineer to help build features for an early software product. What you'll do Build and improve frontend and backend features Work with existing designs and requirements Write clean, reliable code Ship incrementally and iterate quickly Tech expectations Comfortable with modern frontend (React / similar) Comfortable with backend APIs (Node, Java, Python, or similar) Familiar with databases (SQL or NoSQL) Comfortable using AI tools (e.g., ChatGPT, Copilot) as part of daily development

I need the full set of customer-related records lifted from my SQL database and dropped into a single worksheet that follows a template I’ll send you. The database holds tables for customers, payments, customer relations, sales and units. Your job is to write the necessary SQL (views, joins or stored procedures—whatever is most efficient), run it, and populate the template with: • each customer’s name and contact details • their complete purchase history and account status • the matching payment, sales and unit information Everything must end up in one sheet exactly where the template expects it, so column order and data types have to match. Once the file is filled, deliver it back together with the extraction script or query so I can repeat the proce...

Project Title Database Design & SQL Implementation – Content Management System for Movies and Series (Access Control & User Groups) Project Description I am looking for a database developer or DBMS expert to help design and implement a Content Management Database System for managing movies, series, and episodic content with hierarchical user groups and multi-level access control. This project simulates a real-world digital content platform (similar to a streaming service backend) and focuses on ER modeling, relational schema design, and SQL implementation. Scope of Work 1. Database Design Create a complete ER Diagram including: Content (Movies & Series) Series and Episodes Users User Groups (with nested group hierarchy) Access Levels Reviews and Ratings Con...

I’m looking for an experienced Oracle professional who can both teach and advise on PMI-aligned best practices. The engagement covers two fronts: first, delivering clear, hands-on sessions that walk my team through Oracle concepts mapped to the PMI framework; second, helping us design and fine-tune a practical lab so participants can experiment safely with the same features you demonstrate. Dates are flexible and the commercial terms can be shaped around your availability. I’m open to trainers, consultants, or architects—as long as you have a proven record teaching Oracle in a project-management context and can back it up with real-world examples. At the end of our collaboration I expect: • A concise training plan with slide deck or learning material we can r...