Sql仕事

This is rosemarylaw office, lawyer in Japan. We are searching freelancer of PHP, SSIS, SSRS programer. We are continue to develop CS system, MS SQL +SSIS ,SSRS of server side and PHP front with IIS. All MS solution based. We have Server side engineer in house. and test server with dummy data, you can try from remote. development can do english based with skype, github,mail and so on. We hope to good offshore appications. Thanks now we are searching below project enginner. 1 upgrade SQL server SSIS import program 2005 to 2012 SSIS side is improt form exel to dbo and job lancher is C# based exe. Req Skill C# 2000, SSIS, SQL prototype, ex- version will remained Documets also you need to upgarede customizing and version up job. Becase some field ...

...CS system, MS SQL +SSIS ,SSRS of server side and PHP front with IIS. All MS solution based. We have Server side engineer in house. we have test server with dummy data, you can try from remote. development can do english based with skype, github,mail and so on. We hope to good offshore appications. Thanks now we are searching below project enginner. 1 upgrade SQL server SSIS import program2005 to 2012 SSIS side is improt form CSV to DB, job lancher is C# based. Req Skill C# 2000, SSIS, SQL 2 upgarde SSRS program 2005 to 2012 small customizing upgarde checking. over 100 report should upgarde 3 php with sql add new searching view etc stored exec, view,dbo, will be made by server side so you only made front side. need github and wrike ...

...サービス要件 1. 特定のゲームタイトルに関連する記事を取得すること 2. プログラムの特定の一か所に記述されたゲームタイトルパラメーターを変更するだけで対応したデータが取得できること 3. 海外ゲームタイトルであっても取得可能であること 4. 1日に1回バッチを回した際、以前に取得したことがない記事をリストとして取得できること 5. 記事のタイトル・サムネイル・記事本文の一部を取得すること ■ システム要件 1. PHP + MySQLで構築すること 2. PHP5.3で推奨されていない表現を用いないこと 3. Cronによって動作すること 4. プログラムを動かすサーバー OR dbサーバーに対して必要以上の負荷をかけないこと ■ 納品物については以下の通りとなります 1. プログラム本体の納品（PHP） 2. データの格納先DB-Tableの納品（SQLクエリ） ■ 応募条件 1. 応募時にどのような方法で実現する予定なのかを簡潔に明記してください （Ex. TwitterSerch API　と Bing Serch APIを用いて実現します、など） ▽参考Webサイト サイト名：スマートニュース/newspicksなどのバックエンド ▽使用するプログラミング言語/ツール/特殊技術（テクノロジー） ・PHP(5.3） ・MySQL ▽注意点・禁止事項 ※ 他で登録されているデザインや商標の転用など、他社の知的財産権を侵すこと ※ 商用利用できないライセンスのプログラムを用いること ※ ▽その他コメント ※実際のWebサイト開発/アプリケーション開発の進め方・別途詳細は、 　クラウドワークスのメッセージでやりとりして決められればと思...

Fix a magento error SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction MagentoのSQLをバックアップ後に管理画面にログインしようとすると以下のエラーが表示されてログインできない。 SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction 希望： 問題の解決と原因の究明と説明、今後への対処の説明と実行をお願いします。 緊急です。 重要視する項目：金額、スピード、作業内容及び方法の説明 予想される作業内容：（あくまでも予想です） 未実行クエリの再実行または未実行クエリの削除 innodb_lock_wait_timeoutの値変更 50秒->180秒

I need a clean, interactive dashboard that lets our management team see at a glance how well we are moving product from warehouse to customer. The focus is delivery progress, so the visuals must surface three core metrics: on-time deliveries, route efficiency, and customer satisfaction scores. Data sources are already available in our internal SQL database and a daily CSV export from our last-mile partner. I can supply sample tables and field definitions; you will handle the ETL so the numbers refresh automatically each morning. A browser-based tool such as Power BI Service, Tableau Online, or a lightweight React-D3 build is fine—whichever you are fastest with. Key expectations • Single-page overview with KPI cards, trend lines, and a map or heat-grid for route effici...

...payment gateways or logistics services, and supporting database-related tasks. The project also includes creating new modules or enhancements as per business requirements. The developer should have experience working on live production systems and must be comfortable troubleshooting real-time issues. Required Technical Skills: Strong experience in ASP.NET / C# development Knowledge of Microsoft SQL Server and database optimization Experience in REST API development and integrations Basic frontend knowledge (HTML, CSS, JavaScript or Angular/React) Understanding of authentication systems and secure integrations Familiarity with Windows Server / IIS deployment is preferred This will initially be a small paid task-based project. Based on performance, long-term freelance supp...

...full-stack developer, or team, to build a multi-tenant logistics management system built on Angular 14 for the front-end, .NET Core for the API layer, and SQL Server as the data store. The one capability that must be solid from day one is Fleet management—vehicles, routes, and operational data must stay completely segregated per tenant while sharing the same codebase and database. Everything has to scale cleanly as new companies sign up, so tenant isolation, role-based access, and configurable settings are essential parts of the architecture. Core scope • Set up the tenant-aware user authentication/authorization flow (JWT or similar) • Design the SQL Server schema with row-level or schema-level isolation to keep each tenant’s fleet data separate &bu...

I will turn your raw business data into a clean, reliable model and then build a modern Power BI—or, if you prefer, Excel—dashboard around it. Using SQL and Power Query I’ll handle the full preparation pipeline so every refresh runs automatically. The finished dashboard will surface your key sales, order, and performance indicators through intuitive charts, drill-through views, and slicers that non-technical users can explore with confidence. Colour palette, fonts, and layout will match your brand, and advanced filters will let you zero in on any segment or period in seconds. Deliverables • PBIX (or XLSX) file with documented queries and DAX formulas • Fully interactive report pages, mobile-friendly layout included • One-click refresh conne...

...on their own machines. Recordings of each session, slide decks, and any code or spreadsheet templates you use should be shared afterward so the group can review. By the end of the program, participants should comfortably import raw data, perform basic cleaning, create simple summaries, and interpret the results they see in charts or tables. I’m open to your preferred stack—Excel, Google Sheets, SQL, or entry-level Python/R—so long as the learning curve stays gentle and the concepts are explained in plain language. When you reply, please outline: • The number and length of live sessions you recommend for beginners • The main topics you would cover • Examples of similar training you have delivered and the outcomes achieved I’m looki...

...schema in PostgreSQL, and use Redis for low-latency caching and message queues. Because the app is completely standalone, there are no third-party or legacy integrations to worry about—every decision you make will directly shape the core product. Key expectations • Produce readable, documented code that passes automated unit and integration tests. • Keep performance front-of-mind: efficient SQL, sensible indexing, and thoughtful Redis usage are essential. • Push work to our Git repository in small, reviewable increments; I review every merge request myself. • Participate in a brief daily sync (15 min) and a more detailed walkthrough at the end of each sprint. Acceptance criteria at project hand-off • All back-end services run locally via...

I'm looking for an experienced SQL Server professional to provide robust application support for our desktop software. Key requirements: - Primary focus on data backup and recovery. - Ensure data integrity and availability. Ideal skills and experience: - Strong background in SQL Server management. - Expertise in data backup and recovery processes. - Experience with desktop application support. Please include relevant experience in your bids.

...core AI capabilities into my current workflow: a predictive-analytics engine driven by machine-learning techniques and an image-recognition module powered by computer vision. Both tools should be production-ready, well-documented, and callable through REST or Python APIs so they slot cleanly into our existing stack. The predictive component will ingest historical data that I will provide (CSV and SQL sources) and return forward-looking metrics such as demand forecasts and risk scores. Accuracy must be benchmarked against a held-out test set, with clear reporting on feature importance and model performance (precision, recall, F1). The image-recognition piece will classify and tag uploaded photos, surfacing confidence values for each label. A lightweight front-end demo or noteboo...

...Architecture & Design: Creating highly optimized, scalable, and secure database schemas. UI/UX & Web Design: Crafting modern, user-centric, and highly engaging interfaces that guarantee a great user experience. My Technical Expertise: Backend: Node.js, , ASP.NET, .NET Framework Frontend & Design: React.js, HTML5, CSS3, JavaScript, UI/UX Principles, Wireframing & Prototyping Databases: MongoDB, SQL, Advanced Database Design Core Skills: Full Stack Development, API Integration, Problem Solving, Clean Code Architecture I take pride in writing clean, maintainable code and solving complex logical problems efficiently. I am highly responsive, detail-oriented, and committed to delivering premium projects on time. Let’s discuss your project requirements and buil...

...know are standard for Lawson’s payroll tables). Here is what matters to me: • Source: Lawson (on-premise LSF, version 10) • Scope: Financial data tied specifically to payroll—nothing HR-only or attendance-related. • Delivery: A single Excel file, cleanly formatted and ready for pivoting or upload into Power BI. You may use whatever extraction method you are most comfortable with—Lawson SQL queries, the Lawson API, or an ETL tool such as Informatica or SSIS—as long as the process is repeatable. Document each step briefly so my internal analyst can rerun the pull next month. Acceptance criteria • All requested payroll fields present and populated. • No duplicate rows or orphaned records. • Refresh instructions va...

Job Description: We are seeking a Senior Dotnet Developer with excellent English communication skills to join our remote team. This role is open to professionals based anywhere in t...effectively with global teams using clear English communication. -Participate in design discussions, code reviews, and problem-solving sessions. -Write clean, efficient, and maintainable code following best practices. Requirements: -Excellent English communication skills are mandatory (written and spoken). -Proven experience as a Dotnet Developer (C#, Dotnet Core, ASP.NET). -Experience with databases (SQL Server, MySQL, or similar). -Familiarity with cloud platforms (Azure, AWS, or equivalent) is a plus. -Must reside in the Americas, outside the United States. Benefits: -Fully remote work. -Competiti...

...existing Supabase schema 2. Map all current tables and queries 3. Rebuild the data structure into three layers: Raw Data Layer Transformation / Analytics Layer Dashboard Metrics Layer 4. Write optimized SQL queries to calculate operational metrics 5. Connect these views to dashboards (Retool or similar) ⸻ Expected Outcome A stable and scalable data pipeline where dashboards read clean metrics directly from Supabase. The COO cockpit should allow us to quickly see: • sales trends • stock levels • purchase planning • forecasting indicators ⸻ Required Skills • Supabase / PostgreSQL • SQL data modeling • API integrations • Retool or dashboard tools • Experience with ERP integrations (Odoo is a strong plus) ⸻ Imp...

I need a data engineer to implement liquid clustering with z-ordering to enhance performance. This project is critical for optimizing our data processing and retrieval speeds. Key Requirements: - Expertise in data engineering - Strong understanding of z-ordering and liquid clustering - Experience in performance optimization techniques Ideal Skills: - Proficiency in SQL and relevant data processing frameworks - Background in managing large datasets - Ability to work independently and meet deadlines Please provide examples of similar work and your approach to the task.

...database --------------------- Your Deliverables ------------------------------- Take the offline MySQL database file which I will provide to you, and restore it on my live MySQL server Here are the offline backups: -----------------------Hosting, domain and webspace ------------------------------- We will provide the winning bidder with login access to the My SQL space for the database, via cPanel ---------------------- Your ideal skills and experience ------------------------------------- - Strong experience in PHP coding, MySQL databases and building customer-facing applications - Excellent attention to detail - Ability to work efficiently and meet strict deadlines Note: Only freelancers with proven experience in PHP and MySQL should apply. Accuracy

Require online class Key Areas to Focus On: 1. Understanding Database & Data Management (for PMS & Maintenance Transfers) Since you’re working with data migration from NSE to Mary Apps, you need a basic understanding of: SQL (Structured Query Language) – Helps in understanding how data is stored, retrieved, and transferred between systems. Course: “SQL for Beginners” (on Udemy, Coursera, or W3Schools) Data Cleaning & Structuring – Since you deal with PDFs and manual data entry, knowing how to extract, structure, and validate data will be useful. Tool: Power Query in Excel (already in Excel 365, can automate data cleaning). 2. Excel 365 & Microsoft Teams (For Efficient Meetings & Data Handling) Learn Teams for Business &nda...

I want to turn our raw data into clear, actionable customer insights. Your task is to design and run a full analytics workflow—everything from choosing the right architecture and cleaning the data to building the models and presenting the findings in an easy-to-follow format. Please show examples of past work where you un...cases to judge fit and approach. At project hand-off I expect: • A concise technical outline of the pipeline you implemented • Interactive visualisations or dashboards that explain the key insights • A short, plain-language brief summarising recommended next steps for the business Familiarity with distributed processing (Hadoop, Spark), cloud storage, and common analytics tools (Python, SQL, Tableau or similar) will help you mo...

I need a clean, interactive dashboard that lets our management team see at a glance how well we are moving product from warehouse to customer. The focus is delivery progress, so the visuals must surface three core metrics: on-time deliveries, route efficiency, and customer satisfaction scores. Data sources are already available in our internal SQL database and a daily CSV export from our last-mile partner. I can supply sample tables and field definitions; you will handle the ETL so the numbers refresh automatically each morning. A browser-based tool such as Power BI Service, Tableau Online, or a lightweight React-D3 build is fine—whichever you are fastest with. Key expectations • Single-page overview with KPI cards, trend lines, and a map or heat-grid for route effici...

...role-based access using ASP.NET Core Identity (or another approach you recommend, as long as it stays within the framework). • Build interactive charts/graphs that pull data from my existing EF Core models; I’m open to your preferred library—, Highcharts, or any option that works smoothly with Razor. • Create and document the service layer that calls the external API, persists responses to SQL Server, and surfaces them to the UI. Acceptance will be based on: 1. Clean, well-commented code that follows standard ASP.NET Core conventions. 2. A working demo showing sign-up / sign-in, live charts, and successful API calls. 3. Brief hand-off notes so I can maintain or extend the app myself. If this sounds like your wheelhouse, let’s talk and set...

...Monolith (v1) but must be designed microservice-ready so modules can be extracted into independent services in the future. We want clean architecture with clear module boundaries and good long-term maintainability. Planned Technology Stack Backend • ASP.NET Core / .NET Frontend • Blazor API Layer • GraphQL Cloud • Microsoft Azure Hosting • Azure App Service Database • SQL Server and/or Cosmos DB Architecture style • Modular Monolith • Domain Driven Design (DDD) principles • Event-driven communication internally where appropriate DevOps • GitHub for CI/CD Core Platform Features The system will contain several major modules. Identity & Access Management • User registration...

I’m ready to have my website professionally stress-tested so I can patch every weak spot before it becomes a problem. The engagement centres on two critical areas that hold our most sensitive logic and data—the Login System and the User Data Storage modules. Within those components I want you to probe specifically for SQL Injection, Cross-Site Scripting (XSS) and Broken Authentication issues, emulating real-world attack scenarios while staying fully within ethical boundaries. Industry-standard tooling such as Burp Suite, OWASP ZAP, sqlmap, or their equivalents is expected so results are reproducible and mapped against OWASP Top 10. All findings must be compiled in a comprehensive, developer-friendly document that not only confirms each vulnerability but explains impact,...

I’m ready to have my website professionally stress-tested so I can patch every weak spot before it becomes a problem. The engagement centres on two critical areas that hold our most sensitive logic and data—the Login System and the User Data Storage modules. Within those components I want you to probe specifically for SQL Injection, Cross-Site Scripting (XSS) and Broken Authentication issues, emulating real-world attack scenarios while staying fully within ethical boundaries. Industry-standard tooling such as Burp Suite, OWASP ZAP, sqlmap, or their equivalents is expected so results are reproducible and mapped against OWASP Top 10. All findings must be compiled in a comprehensive, developer-friendly document that not only confirms each vulnerability but explains impact,...

Saya memiliki sebuah toko online ya...terhubung ke email admin serta disimpan ke database untuk keperluan pencatatan. • Menampilkan testimoni pelanggan secara dinamis, lengkap dengan opsi tambah-hapus-edit melalui halaman admin. Kebutuhan teknis: – Familiar dengan stack LAMP/LEMP, jQuery atau vanilla JS, dan struktur basis data MySQL. – Peka terhadap keamanan dasar e-commerce (input validation, sanitasi, dan proteksi CSRF/SQL injection). – Mampu bekerja pada repo Git sederhana agar perubahan mudah saya tinjau. Saya akan menyediakan akses FTP, database, dan catatan bug yang sudah teridentifikasi. Tolong cantumkan contoh singkat proyek serupa yang pernah Anda tangani, perkiraan durasi, serta langkah kerja yang biasa Anda lakukan untuk audit kode s...

I’m looking for someone who has already moved Microsoft SSIS workloads into Google Cloud and can guide me through a clean, production-ready rebuild of our existing pipelines. Right now the jobs pull from a mix of relational databases and nightly flat-file drops; the goal is to land everything in BigQuery with the same—or better—performance, data quality, and monitoring we have today. Here’s what I need from you: • Assess the current SSIS packages, map out every source table and file feed, and document the equivalent flow on GCP. • Design and build the new pipelines using native services (Dataflow, Cloud Data Fusion, Cloud Composer, or any combination you feel is best) with full error handling, logging, and retry logic. • Automate scheduling and...

We are looking for an experienced GraphQL Engineer with stron...Build backend services using C# .NET Deploy and operate applications on Microsoft Azure Collaborate with frontend teams consuming the API Requirements 5+ years of software engineering experience Strong experience building production GraphQL APIs Solid skills in C# .NET Experience with Azure cloud services Understanding of REST APIs, microservices, and distributed systems Experience with SQL / NoSQL databases Nice to Have Kafka / event-driven architecture Docker / Kubernetes Azure observability tools (App Insights, Azure Monitor) Project Details Remote Freelance / contract Potential for long-term collaboration Please share your GraphQL project experience, especially your role in schema design and API ar...

...but feel free to use whatever you prefer. Deliverables 1. Complete backend source code, clearly organised. 2. Database migration or SQL script. 3. Admin/back-office interface styled simply to match the existing site. 4. Deployment instructions plus brief user guide (PDF or Markdown). 5. A short hand-over call or screen-share to walk through the CMS. Acceptance criteria • New content saved through the CMS appears on the live page without breaking the layout. • Image uploads under 2 MB are accepted and optimised server-side. • All authentication routes are protected against unauthorised access and basic security tests pass (CSRF, XSS, SQL injection). • Code runs on a standard server with no proprietary dependencies. Everything visual ...

I have two ZIP archives—one for the main PHP site and another for its admin panel—plus the accompanyin...the backup, get the site running locally, reach the admin panel with standard credentials, and then hand back every piece of data and code in a clean export. Critical items you will work with: • Main site ZIP file • Admin panel ZIP file • MySQL database dump Deliverables I expect at the end: 1. A fully functioning local copy running in Wamp (or the environment we agree on). 2. A complete SQL dump of the database. 3. A zipped package of all site and admin panel files exactly as they appear after extraction. 4. A quick confirmation that the admin dashboard is accessible with default or standard access. This is a single-run task; once the ex...

I have a project that contains both a mature WinForms application and ASP.Net web interface. The Winforms application (PileOps V5.5.4.0) is built on .NET 4.7, DevExpress V25.1.4, Entity Framework and a SQL backend, protected with Dinkey dongles. The web interface is ASP.net and bootstrap. The codebase still serves the business well, yet it suffers from out-of-memory crashes and sluggish data operations. My priority is clear: noticeable performance improvements while preserving every ounce of existing business logic and keeping the current database schema intact. Here is where I need your expertise: • Target framework: migrate the solution to .NET 10 (or the newest stable LTS) and shift the UI to the latest DevExpress WPF controls. • Performance focus areas – thes...

...the experience stays consistent on mobile and desktop. Acceptance criteria 1. I can log in as Admin, create a plan, and see it instantly available to new sign-ups. 2. A test user registers through an affiliate link, and both wallets update accurately according to the plan. 3. The payout module exports a CSV and marks entries as paid once processed. 4. Pages pass a basic security audit (SQL injection, XSS, CSRF). Hand-off should include full source code, database schema, brief setup guide, and one live demo session so I can verify everything runs as promised....

...every transaction and status change. For data persistence I would like you to work with a SQL database—MySQL or PostgreSQL are both fine—so please structure your models and migrations accordingly. Beyond our own data store, the service must connect smoothly to several third-party providers: a credit-score API to pull applicant scores in real time, a payment gateway for disbursements and repayments, and notification services that let us push SMS and email updates at each milestone. Key deliverables • RESTful (or GraphQL, if you prefer) API endpoints covering auth, application submission, underwriting status, payment events, and notifications • Clean schema and migration scripts for the chosen SQL engine • Integration modules for the credit...

...talking fluently to our dedicated Microsoft SQL Server so that business users can run natural-language, read-only queries through Grok’s interface. The task breaks down into two core pieces of work: • Implement the xAI Grok API on our side and map its request / response cycle to T-SQL. • Establish a rock-solid SSL/TLS-encrypted connection to the database using SQL Server Authentication. The server is already isolated behind our corporate firewall; your job is to add the secure transport layer, handle credential storage safely, and make sure Grok can reach the database without exposing write or admin rights. Acceptance criteria 1. A small PoC script (language of your choice) that accepts a Grok prompt and returns the matching result set from ...

...compensation, and benefits. Experience supporting system integrations and data flows between HR platforms. Excellent problem-solving, communication, and stakeholder management skills. Preferred Qualifications: Familiarity with integration middleware (e.g., MuleSoft, Boomi) or Workday Studio. Experience working in fast-paced tech environments or growth-stage organizations. Knowledge of Jira, Confluence, SQL, and reporting tools such as Tableau or Looker. ...

...contests. Requirements: • Create responsive leaderboard interfaces that load quickly on mobile. • Display player position, streak or win count, and relevant stats such as W/L or completion rate. • Keep the design consistent with the existing site styling. • Show Top 10 players by default with an option to expand. ________________________________________ Deliverables 1. Updated Supabase migrations / SQL schema for the new contests. 2. Automated grading logic using Edge Functions or scheduled jobs. 3. API or RPC endpoints to expose leaderboard data. 4. Leaderboard UI integrated into the existing WordPress site. 5. Brief documentation explaining the grading logic and leaderboard structure. ________________________________________ Goal Extend the existing contest ...

...full archive of both files and database. I do have an older backup, but I’d like you to create this fresh one first so nothing is missed. Scope of work 1. Create and download the full backup exactly as described above. 2. Wipe the existing OpenCart files and database from the server. 3. Perform a fresh install of OpenCart 3.0.4.1 and set up a new, empty MySQL database. 4. Edit the exported SQL so table prefixes and any other identifiers match the new install, then import it. 5. Restore only user-generated content—product images, logs, etc.—leaving core files untouched. 6. Install and activate the Antropy MultipurposeTheme-oc3. 7. Test the front-end, admin area, checkout flow, and any reports to confirm everything works as expected. Deliverable: a...

...can: • return existing records (GET) • add or modify items (POST / PUT) • remove items (DELETE) You are free to work with native PHP, Slim, Lumen, or a full Laravel setup—whichever will let you keep the codebase modular and easy to extend. Just keep the dependencies light and document any third-party packages you bring in. My acceptance check is simple: spin up the project, import the sample SQL I’ll provide, hit each route with cURL or Postman, and see properly formatted JSON with the expected status codes (200, 201, 204, 400, 404). If a route fails validation or an exception slips through, graceful error handling should still return JSON. Please structure the folders sensibly, comment where needed, and include a short README so I can deploy on...

I’m an ...login, password reset, optional social OAuth) • E-commerce functionality (product catalogue, cart, checkout, payment-gateway integration) • Real-time chat for users, sellers and support, delivered via WebSockets or a comparable technology A modern JavaScript stack feels right—React or Vue on the front end, with Node.js/Express (or a similar framework) on the back end—and I’m open to either SQL or NoSQL for the database. Clean, well-commented code in a Git repository, a concise README, and deployment to a cloud host such as AWS, Heroku or Vercel are part of the expected hand-off. Acceptance criteria will be a fully functional, responsive web app that passes manual feature testing for all three core areas and can be demonstrated li...

I need a complete, web-based rent management agreement system that I can confidently submit ...payment, or creating a lease—should be stored in a relational database and surfaced in concise reports I can show during my viva. I will supply my college’s marking rubric once we begin; however, the project will be evaluated mainly on functionality, code quality, and documentation. To make my presentation smooth, I need: • Fully commented source code (any modern stack you are comfortable with) • SQL export or migration scripts • A short, step-by-step setup guide and a brief user manual • Screenshots or a quick demo video illustrating key flows If you have a ready framework or prefer to start from scratch, let me know your approach so I can align it...

...complements the back-end stack • Understanding relational data design and hands-on querying with MS SQL Server, PostgreSQL and MySQL All sessions must happen at our office, Monday to Saturday, and I want a balanced rhythm—short, concept-driven lectures immediately followed by guided lab work so the class can internalise each topic before moving on. What I expect from you 1. A day-by-day curriculum outline delivered before kick-off 2. Slide decks, sample projects and database scripts that remain with us after the engagement 3. Simple checkpoints or mini-assessments every week so I can track each trainee’s progress 4. A capstone exercise that pulls Web API, Python scripting and SQL together into one working demo we can showcase internally You ...

...should primarily use Microsoft technologies such as: Microsoft Azure Azure OpenAI Service Azure AI Speech (Speech-to-Text and Text-to-Speech) Azure Communication Services (Voice & SMS) Azure Bot Service / Conversational AI Azure Functions or Azure App Services Microsoft Graph API (for Microsoft Calendar integration) Azure Key Vault Azure Monitor / Application Insights Azure Storage or Azure SQL for secure data storage Microsoft Entra ID (Azure AD) for authentication Compliance & Security Requirements The architecture must support: HIPAA compliance PIPEDA compliance Secure handling of personal and potentially health-related information Encryption of data in transit and at rest Secure authentication and role-based access control Audit logs and monitoring ...

...need a fully self-hosted USDT (TRC20) deposit flow. Here is what the job entails: • Each user must receive an automatically generated, unique TRC20 wallet address. • A service written in the language of your choice should monitor those addresses—either through TronGrid or a locally synchronised Tron node—and detect confirmed USDT transfers in real time. • Once a transfer is confirmed, an SQL call must update the user’s available balance in my existing database tables. • The entire stack must remain under my control; please keep third-party payment gateways (CoinPayments, NowPayments, Plisio, etc.) out of the solution. • Apply standard encryption protocols for key storage, address generation, and any communication between the m...

...Excellence: Build fluid, responsive, and accessible user interfaces that provide exceptional user experiences. Database Mastery: Manage SQL Server environments, focusing on schema design, query optimization, and performance tuning. Team Influence: Elevate team output through deep code reviews, technical mentorship of mid-level and junior engineers, and clear communication with stakeholders. Requirements Experience: 5+ years of professional fullstack development experience. Tech Stack: Advanced proficiency in C#, .NET Core / .NET 5+, and React.js. Modern Web: Strong experience with TypeScript, Web API, and modern frontend state management. Data: Strong experience in SQL Server management, complex stored procedures, and performance tuning. Cloud & DevOps: Deep understan...

My pharmacy-inventory site on Hostinger is roughly 70...Acceptance criteria 1. Inventory page lists all items with real-time stock levels. 2. Updates made via the interface reflect instantly in the database. 3. All fields—item name, code, quantity, supplier—display correctly and stay aligned on mobile and desktop. 4. No existing pages break; unit test file included or at least clear manual test steps. 5. Final delivery: updated source files + SQL patch (if any) + short README showing where you touched the code. Optional enhancements such as automatic restocking alerts or batch/expiry management can be discussed later, but for now the focus is solid stock-level visibility. I’m ready to hand over access as soon as you confirm you can take it from here and h...

I have an Azure Databricks SQL warehouse that needs to read from an external Hive metastore hosted on HDFS using thrift service. The moment the warehouse tries to reach that store, the job fails with an “authentication failure” coming back from HDFS. I am using a token-based authentication flow rather than Kerberos or a simple username/password combination, and I suspect the problem lies either in how the token is passed or in mismatched Hadoop core-site settings inside Databricks.

...single, flat-file database—CSV is fine, but feel free to suggest a lightweight relational structure if you think it will add value. Include the transformation script (Python, R, or similar) so the process is fully reproducible. Acceptance criteria 1. Row counts in the final dataset match the original ledger pages (no dropped or duplicated lines). 2. All numeric fields import into Excel or a SQL table as numbers, not text. 3. Your anomaly log lists every transaction you could not confidently parse and explains why. 4. The script runs end-to-end on my machine with only standard open-source libraries. If you have experience wrangling messy PDFs with tools like Python (pandas, tabula-py, camelot) or R (tidyverse, tabulizer), that will be a plus, but feel free to use a...

I have several production PL SQL scripts that are starting to show their age: execution times have crept up and they are consuming more CPU and memory than I am comfortable with. The primary focus of this project is therefore PLSQL itself, not application-level logic or UI work. What I need from you is a careful optimisation of the existing codebase. The goal is two-fold—raise overall performance and cut back on resource usage—without changing the functional output in any way. You will be working with code that is already in use, so a light-touch, incremental approach that can be verified against current results is essential. Deliverables I expect • Revised PL SQL scripts ready for drop-in replacement • A short before/after performance summary (timin...

...ready to go, and I’d like the two talking cleanly through Lovable. The goal is simple: trigger Resend emails from Supabase and capture delivery / event data back into a table, all through a small, clearly documented API layer. Here is how I picture the hand-off: • A Lovable workflow (or equivalent code) that authenticates to both services, exposes the endpoints I need, and runs without errors. • SQL or RPC functions in Supabase that I can call to send an email via Resend and to store the resulting webhook payloads. • Environment-variable placeholders for keys and secrets, so I can drop them straight into my .env file. • A short README—or quick screen-record—showing the setup steps and a sample request / response. I have set aside a t...

I need a reliable freelancer to pull a blend of text and numerical information from several specified online sources and enter it directly into our live database. You will receive secure database access, c...our live database. You will receive secure database access, complete field guidelines, and a short orientation video so you understand the required structure before you begin. Accuracy is critical; each record must match the formatting rules I provide and all values need to be double-checked for consistency. You should already be comfortable working inside a web-based database interface or with SQL tools, and able to keep a clear audit trail of changes. When the assignment is complete I’m expecting the database to be fully populated, error-free, and ready for immediate ...