Sql Projects

opportunityurgent

Raffaello Files

Hi, I have recently brought a company that was closed. It sold online fashion and I have picked up the stock with the assets. I have requested the data files so I can breakdown the stock, gender, brand and product description . However the files have come to me and they apparently I need a SQL or something to be able to open these files and analyse. I am working from an iPad as well so apparently this is not possible either. I have been told it will take a week plus to create something that allows me to view, analyse and extract data. I am told that i need a AWS account or something…. Can anyone help

Occasional T-SQL assistance

I'm finding myself using T-SQL more and more, without the necessary skills or training. I'm fine with basic stuff, but get frustrated at what *should* be a fairly simple query not working as expected. So.. I'm looking for a mentor.. someone who I can email very occasionally with a query and who can not only help with the specific code but - as importantly ! - explain where I was going wrong and why. My current issue is posted below (which I know is wrong !). I'm not looking for a free answer - I've posted this to give respondents an idea of level required. I'm looking to select all records that match in two tables, and insert the value of one field into the other table. Select LocationTracking.Location,Users.Code, Users.LocationControl, Users.NNorDF from LocationTracking INNER JOIN Users ON Users.LocationControl = LocationTracking.Location (Insert into LocationTracking (LocationTracking.Site) Values(Users.NNorDF))

Database upload via Putty expert

I need to upload a 1,7GB database to my SiteGround hosting plan. It is from a WordPress site I am moving there. It is to big to upload it via phpMyAdmin so the next option given by them is to do that via SSH and Putty. If you know another way, no problem to do that your way. The datasabe .sql file is already on the server as file and we also have access to move this from the old server too (as long as we are sure it is 100% safe). I need an expert in this task to do this the next days.

opportunity

API Development from BambooHR to a SQL Database

We are looking for someone who has previously worked with the API from BambooHR who can mobilize the integration between Bamboo and our own internal SQL database or can spit out changes to a new SQL database or email address.

Classic ASP, PHP, Ajax, Bootstrap, MS SQL - Development

I have a website built in Classic ASP, PHP, Bootstrap, Ajax, some Java, HTML5, MS SQL 2016. The site is up and running. It is client management and reporting system. I am looking to hire a support developer (a freelancer) to assist in debugging and maintaining it and also some development work. I need someone with good speed and work hours approx 10 to 20 per week. Payments will be weekly on Fridays. If you have expertise in ALL the following languages Classic ASP, PHP, Bootstrap, Ajax, some Java, HTML5, MS SQL 2016, only then please apply. Mention in your reply you languages skills. You will be tested for your skill. Thanks.

Forensic SQL DBMS Auditing.

Description: I am seeking the expertise of a forensic expert to conduct a thorough audit of my SQL Database Management System (DBMS). The audit will focus on user login/logout, data read/write operations, and schema changes. The goal is to identify any unauthorized access, data tampering, or regulatory compliance issues. The ideal candidate should have a strong understanding of SQL and be familiar with various SQL DBMS (MySQL, PostgreSQL, SQL Server). Experience in forensic auditing of databases is essential, as well as knowledge of compliance regulations. The candidate should be able to detect and interpret signs of unauthorized access and data tampering. Additional information about the project can be discussed further, and I am open to suggestions on what additional information you may require from me. Insert into input field Try agai

opportunity

Insurnace brokerage administration systems (SQL BASED)

We are seeking experienced freelance developers to design and build a comprehensive system for administering and managing insurance broking activities. The system should provide a seamless platform to handle client policies, premium collections, claims processing, and regulatory compliance while ensuring data security and operational efficiency. 2. Project Overview The proposed Insurance Broking Administration and Management System will streamline end-to-end brokerage operations, integrating policy management, customer service, document handling, financial tracking, and reporting into one user-friendly platform. 3. Key Objectives Automate policy issuance, renewals, and endorsements. Improve client and policy tracking. Enable premium collection and reconciliation. Simplify claims processing and settlements. Ensure compliance with insurance regulations. Enhance reporting and analytics for decision-making. 4. Scope of Work The freelancer(s) will be responsible for: System Analysis & Design Understanding workflows of insurance broking operations. Creating system architecture and UI/UX design. Development & Implementation Building a web-based or cloud-based system. Implementing key modules for: Client and Policy Management Premium Accounting & Collections Claims Management Compliance & Regulatory Reporting Customer Communication Integration with payment gateways and accounting software. Security & Compliance Implementing data encryption and role-based access control. Ensuring compliance with industry standards and regulatory guidelines.

SQL Data Base Administrator

Role: Database Administrator Experience: 5 to 7 Years Location: Saket (Delhi) About The Company: At WeCredit, we partner with heading NBFCs to help Customers find the best online financial solutions, including quick and hassle-free loans. Our skilled team provides assistance every step of the way, from Completing your loan documents to ensuring fast disbursal of funds. About the Role: We are seeking a skilled and detail-oriented Database Administrator (DBA) to manage and maintain our company’s databases. The ideal candidate will have extensive experience in database management, performance tuning, and ensuring data integrity and security. As a DBA, you will be responsible for overseeing database systems, ensuring their reliability and performance, and supporting business applications Responsibilities: • Install, configure, and maintain database management systems (DBMS) such as MySQL, SQL Server • Design and implement backup and recovery strategies to safeguard data against loss or corruption. • Manage database security, including user access controls and data encryption, to protect sensitive information. • Diagnose and resolve database issues, including performance problems, corruption, and connectivity issues. • Work closely with developers, system administrators, and other IT staff to support application development and ensure seamless integration. • Apply software updates, patches, and upgrades to database systems as needed. Qualifications: • 5 to 7 Years of experience as a Database Administrator or similar role, with expertise in managing databases and performance tuning. • Proficiency in SQL and experience with DBMS such as MySQL or SQL Server. • Strong analytical and troubleshooting skills with the ability to resolve complex database issues. • Query Optimization. • Internal DB Level.

I need Mariadb Mysql expert to restore my Databases

Hello, I have a server running Ubuntu with Webmin, Apache, and MariaDB. Unfortunately, three days ago, MariaDB stopped working. I attempted several fixes but couldn’t resolve the issue, so I decided to reinstall MariaDB. Before reinstalling, I made a full backup of the /var/lib/mysql/ directory, which I still have. After reinstalling MariaDB, I restored the old database files. However, when I try to access the databases through the Webmin Database Management Panel, I receive the following error for every database: Fatal Error! SQL show index from atwp_actionscheduler_claims failed: Table 'abiyetakim.atwp_actionscheduler_claims' doesn't exist in engine. I host several small WordPress sites, and all my websites are affected. I’m looking for an expert who can help me restore the databases. I’ve checked the backup files on my local machine, and I can see the text inside them, indicating the files are not corrupted. I am offering a $20 reward for someone who can help me resolve this issue. If you’re an expert and can help, I will provide my server’s root password once your proposal is accepted. I look forward to receiving proposals from reliable professionals. Thank you!

opportunity

Convert MS Access project (.adp) to MS Access 365

We have an MS Access project 2010 (.adp) file that connects to an MS SQL Server (2012 or higher). The application is used for contact and address management. The goal is to upgrade the application to the latest version of MS Access. The application connects to a database backend that has 10 tables. Please provide your quotes for the database upgrade. Any other solutions you can give are welcome too.

Help Writing 3 SQL Statements

I need to right 3 SQL statements for part of a report query within our WMS system - Orderwise. I have all the fields, and the statements need to use case to combine the fields into a calculation to return a figure. Will require a call to demonstrate the tables and the desired outcome from the statements

opportunity

Webpage data scrapped to XML in react native coding

i need to build a email scrapped and a webbased scrapped to be able to put data into my sql database where front in react native. will need to be like a HIT console that extracts data where needed.

opportunity

Making an internal website pretty

We have an internal website for our staff which has worked well for the last five or six years. I'd like to make it look pretty (it's definitely functional rather than nice to look at). It's running bootstrap.css, but that's about the only visual thing on there. I've attached some screenshots. What I want to do is: change the way the tables shrink on a mobile Add a logo css zone Add a footer with its own css Implement a new colour scheme (we have the scheme already. Make the front page a lot more responsive, and more visually pleasing What I'd like to do in addition is create a new page which carries out a select query and displays information from the back end of the database for that specific task. I'd like to be able to justify how it's displayed on the screen rather than using a grid layout - so I need someone to create the basics of a responsive page (possibly with tab controls) to display information to my staff. Type of information could be: Address, List of camera locations (what3words), instructions on how to enter a property, codes and key details, and so on. I would like another page which allows the staff member to type up their incident report and send it through also attaching unlimited photographs if they wish. For each photograph they should be able to add a title. When they are uploaded, the photographs should be resized to within a constraint we can set in the code, then stored in a folder (virtual directory) on the server. Each photograph should have a record in an evidence folder. Back end DB is currently MS Access 2019 (this will be SQL one day, but won't be changing for the foreseeable) Server is Windows 2019, running .net - locally hosted on our network Language of choice is ASP.net VB (not negotiable) Please quote for the style updates and the two additional pages separately.

Develop Python-Based Web Version of StoryMii

We are looking for an experienced Python developer to create a fully functional web version of our existing Story Mii platform. Story Mii is an AI-powered storytelling application designed to generate, customize, and analyze children’s stories. We need a web-based version that will allow users to access the **current story database**, write new stories to the database, and interact with the system as they do on our existing mobile and desktop applications. Key Requirements: - Develop a web application that seamlessly integrates with our existing database. - Allow users to retrieve, edit, and create stories within the platform. - Ensure secure authentication and account-based access. - Maintain compatibility with our AI-driven story generation and analysis tools. - Frontend should be user-friendly, responsive, and align with our brand’s UI/UX. - Implement database connectivity to read and write stories efficiently. - Deliver the fully functional web version within 6 weeks. - Python expertise required for backend development. - Experience with Azure & AI-driven applications is strongly preferred. Additional Considerations: - Understanding of OpenAI’s GPT models and AI integration is a plus. - Experience in database management (SQL) and REST API development. - Previous work in children’s applications, or AI-powered platforms is highly desirable. - The developer should provide an estimated cost breakdown for development, testing, documentation and deployment. If you have experience in AI-powered web applications and can deliver within the timeframe, please submit your proposal with a portfolio of relevant work.

Fullstack Typescript developer

We’re an innovative Fintech based in California focused on Investment Banking. We’re looking for a skilled Fullstack Typescript developer to join our team. Technical Requirements: • Experience with Typescript, Javascript in both backend and frontend roles. • Strong algorithmic foundations. • Experience with SQL Databases (One or more of MySQL, Postgres, SQL Server). • Experience with NPM package management and private packages. • Experience with NPM, Git, Github • Experience with REST API endpoints, reverse proxies. • Experience with Linux Nice to have: • Experience with message queues like RabbitMQ or Kafka. • Experience with Javascript Microsoft Office Add-ins. • Experience with Github Actions, DevOps practices • Experience with Monitoring with Grafana, Promtail, Prometheus • A background in Math. • Interest in Finance, or previous experience in Fintechs. Other requirements: • Strong English language skills, as our domain is complicated and a good understanding of language is needed. • Should work minimum 35 hours a week. • A modern laptop running Linux. Why Join us? • Be an early-stage hire in an innovative team shaping the future of investment banking. • Work on meaningful projects that have a real impact on the financial industry. How to Apply Please see the attached screening question. Solve the problem and add the resulting number to the top of your application. For example, if the solution is the number 42, add “42” to the top of your application.