SQL Jobs

The project is needed to be done One day

From scratch 5-8 websites as our products are ready

Looking to switch from using a local shared access file to an online version that can be accessed from anywhere with access control. Questions to be answered: • Would you be able to install a SQL database in something like MySQL on a Windows computer? Or would it require an actual SQL Server? • Approximately how long would it take for the database to be built? • How much would it cost to build it? • Will you support the database if we needed support?

This project is based on sql and details of this project are in uploaded file.

Built a web platform that can help individual investors to track their dividends.

all about data compression in SQL server. this involves text fields and fields with Notes with POC ( proof of concept)

Build data base or basic program for CRUD

I have multiple excel sheets linked with each other to transform the data and get insights. Everything gets stored in the output excel file after transformation which contains roughly 50 data points. I also have sheets that explain the process and the logic behind excel formulas, filters and how they are used. I want to use SSIS for data transformation instead of doing the whole thing on excel to obtain similar results. Also, I only want to do the transformation on 4 data points initially and am mainly interested in the calculations that we can do the calculations in SSIS. This is a simple project requiring simple calculations and maybe a walk in the park for someone who is well versed with SSIS. It also has a potential opportunity for extension once the Proof of Concept (4 data points) ...

I have a flutter app for which I need to develop backend. I am planning to use NodeJS for developing APIs and Stored Procedures for DB SQL queries. If you have good experience and pace are not too occupied in office or other freelance projects, then please bid.

I need someone helping me fixing this issue which is implementing missing instruction and create a branch for it

Hi, developers. I need help for Multi layer BOM Selection in SQL. I have a project related to multi-layer BOM. Each BOM has multiple levels (layers). The columns in the BOM table include final product id, component id, quantity, level, and location id, component category, progress. I'll provide table detail, and rules once you take this project, thank you.

I need someone helping me fixing this issue which is implementing missing instruction and create a branch for it

The Data Analyst is responsible for developing Finance dashboards and reporting solutions, analyzing and modeling large database.

Hi, I need someone to urgently fix my xml feed: I get the following error: there are 10 listings in the XML and they are rejected due to the location, please note that you need to fill at least the first 2 levels of the location.

Project fix the welcome for MEM’s

Need dot net Developer to customize reports and makes some pages on web using SQL database

some data post or receive to my another project in php

I have erp already developed. Based on db structure power bi reports needs to be designed. Around 40-45 reports. Report should reflect in real-time. If any data entry is done in erp, it should be reflected in dashboard.

Have table which have trade list, Create MySql query for TradeVolume Changes 24h/7d/30d/1y Reference daily trade volume changes in %

I need to add the new Users ID that was added to the database in a email. The code is already done, I just need someone to make the SQL that gets the last MAX userID form table USERS and adds + 1, and puts that in the line below $email_message .= "firstname: ".clean_string($_POST['firstname'])."n"; $email_message .= "lastname: ".clean_string($_POST['lastname'])."n"; $email_message .= "username: ".clean_string($_POST['username'])."n"; $email_message .= "email: ".clean_string($_POST['email'])."n"; $email_message .= "street1: ".clean_string($_POST['street1'])."n"; $email_message .= "street2: ".clean_string($_POST['str...

We need to integrate the front end with the backend. We have the ux, what we have to do is integrated stripe and manage the properties and user in the admin panel. This is the workflow Be ready to work

Need an sql developer to support my job in error and bug fixing sometimes creating views,procedures and queries as well

We are currently looking for someone that can help us design actionable reporting and dashboards for our subscription-based e-commerce company. Responsibilities will include: Write SQL queries and stored routines to return and manipulate data per business needs Debugging and troubleshooting queries, stored procedures, and data integration solutions Optimize query performance tuning Develop and build analytic reports from conception to publication Connecting our SQL data source to reporting applications such as Power BI to create visual reports that can show us KPIs and Business Drivers, Customer Analytics, and more that effectively communicate trends, patterns, and predictions using relevant data. Collaborating with programmers and organizational leaders to identify opportunities for ...

We need implement automation to the process of developing / mantaining database objects with repository, versioning, CI/CD, etc.

We have several established .NET applications and SSRS Reports. Due to a promotion, we need additional resources to help maintain and develop additional reports and data feeds to BI platform. The Reports are manufacturing/Engineering based using data feeds from 123 Insight and the SDK interface.

I have a mysql databse but i need the data mapped as they are not represented with the same column name

Need to develop a web based dental clinic practice management software...

The website should be as a main tool for a company providing the service of collecting information from members about certain objects they used and their ratings of these objects. Feature to see detailed and cumulative ratings are able for paid memberships only..

CREATE TABLE [dbo].[TRANSPORTSERIALTRACKING]( [PREFIX] [nvarchar](10) NOT NULL, [SERIALNUMBER] [nvarchar](30) NOT NULL, [DENOMID] [int] NOT NULL, [CURRENCYCODE] [nvarchar](30) NOT NULL, [DENOMINATION] [nvarchar](30) NOT NULL, [SERIES] [nvarchar](30) NOT NULL, [NUMERICSERIALNUMBER] [bigint] NULL, [SUFFIX] [nvarchar](10) NULL, [LASTINCASHCENTERID] [int] NOT NULL, [DATEFIRSTIN] [date] NULL, [DATEFIRSTOUT] [date] NULL, [COUNTRETURNS] [int] NOT NULL, [DATELASTIN] [date] NULL, [DATEDESTROYED] [date] NULL, [SORTINGDATEINSEQUENCE] [nvarchar](2000) NULL, [SORTINGSITEINSEQUENCE] [nvarchar](2000) NULL, [SORTINGQUALITYINSEQUENCE] [nvarchar](2000) NULL, [SORTINGMACHINEINSEQUENCE] [nvarchar](2000) NULL, [TRANSPORTFILEIDINSEQUENCE] [nvarchar](2000) NULL, [HEADERCARDINSEQUENCE] [nvarch...

Hi All, I have attached a workbook wherein I have compared Variance of year/quarter/month with any different year/quarter/month. So far I have achieved it with help of Parameter that gives user flexibility to choose amongst the period and then filter values display accordingly. But now I have a requirement to have different filters for each column (Previous and Current) as follows: Therefore, to keep “Select Period” filter, and add “Periods Filter” above each Current and Previous Period columns and name each filter accordingly Column header should update based on which period is being filtered (for previous or current)

See document for details. Short: I would like 1 php page that will have 3 tabs. tab1 -> contains all fixed items like a BAG, SACK, BOX tab2 -> the options -> like a red ball, blue ball, organge ball tab3 -> will contain all options possible.. bag -> blue ball bag -> blue ball + red ball etc

Hello I would like some one to create a snowflake query to get the data in the format as shown in tab 3 in the attached document. The table is present in tab 1 and the requirements are detailed in tab 2 .

Need someone having knowledge of sql, data visualization. Data science expert.

convert xml data and load into database

Please Sign Up or Login to see details.

THERE ARE FOUR PROJECTS WITH R TWO WITH SQL AND TWO WITH TABLEAU I NEED A SOLUTION FILES OR DETAILS SOLVING TECHNIQUE ON THESE

Hello, I want a website where I can store information. The functions should be as this one

We require a programmer for a large MS Access/SQL Server project for 2-3 months. Please write me, if you are an experinced MS Access and MS SQL Server developer.

The business evaluator provides a blueprint for scaling your business to the next level, and the blueprint will establish your baseline with your peer group and advise you on what you need to do (people and budget) to accelerate to the next level. It is to be used for lead generation and a resource for anyone who needs to evaluate an MSP for Non-Competitive Interest, Development Capital, Ownership disputes, Potential Sale, Retirement Succession Planning, Investment, Scale of Your MSP, or Curiosity A competitive Website: The functionality is currently written in Excel. It needs to utilize a WordPress-enabled SQL currently in an Excel array. We are using WordPress with an Avada-purchased theme. The system is to generate reports based on customer input and retrieves text and data (per...

Create excel based tool which link to SAP and automates data extraction from SAP. Example of requirement: 1) Input data parameters in Excel 2) Basis mentioned data parameters, Excel connects to SAP in backend and downloads report 3) Perform some basic data validation and formatting on the downloaded SAP output

To install SQL Server 2016 in linux VMs Installation in a Private cloud. Installation on NVME drives wil logs and data on separate location Database LB and HA environment essential. Add existing databases to the new instance Good Knowledge on Database replication, Indexing and Log Truncation

I have a access 2003 data base with so many send keys functions it will not work on access 2020 or later, need someone to add code to clean it up

E-commerce subscription based application for customers and vendors. Admin panel/CMS are also needed.

Job Description Business Intelligence Support Analyst – Junior – user access management Duration: Project based, indefinite Start date: August 2022 Reports to: Head of Business Intelligence Capacity: part time – up to a few MDs per months Location: FULLY REMOTE Overview Company serves over 700 airline customers, with more than 35,000 staff at over 200 locations across 6 continents. There is a high demand for an accurate global view of the business and the efficient dissemination of information throughout the organisation. The Business Intelligence Support Analyst in the company is being re-launched and this position is an exceptional opportunity to take part in the transformation of the BI systems team. The business intelligence Support Analyst Junior will be pa...

Need a Database expert who has great experience in database administration and available for 5 to 6 hours in a day with minimum experience of 5+ year in same domain You'll ensure that: 1. Data remains consistent across the database 2. Data is clearly defined 3. Users access data concurrently, in a form that suits their needs 4. There is provision for data security and recovery control (ensuring all data is retrievable in an emergency). As a database administrator, you'll Responsibilities to: 1. Establish the needs of users and monitor user access and security 2. Monitor performance and manage parameters to provide fast responses to front-end users 3. Consider both back-end organisation of data and front-end accessibility for end-users 4. Refine the logical design so that it c...

Need a Database expert who has great experience in database administration and available for 5 to 6 hours in a day with minimum experience of 5+ year in same domain You'll ensure that: 1. Data remains consistent across the database 2. Data is clearly defined 3. Users access data concurrently, in a form that suits their needs 4. There is provision for data security and recovery control (ensuring all data is retrievable in an emergency). As a database administrator, you'll Responsibilities to: 1. Establish the needs of users and monitor user access and security 2. Monitor performance and manage parameters to provide fast responses to front-end users 3. Consider both back-end organisation of data and front-end accessibility for end-users 4. Refine the logical design so that it c...

It would be nice to get the suite fully up and running, if that succeeds there will be modifications. But that would be the most important thing!

Bus booking app, involves login page, payment system , booking history, last journeys, on going journey , Basic app is already developed.

Project Requirements: You are asked to design and implement a Database for a new University called MTUC as follows: MTUC has Academic staff, general staff and students who are working or attending this new University. Each person is either academic staff, or a general staff, or a student. A person is uniquely identified by a PerId (person's ID), and has a Name, and an Address. An Address is composed of HouseNo, Street, and City. A characteristic property of a student is that she/he has 1 course and 12 modules for this course in one year. An academic staff has a Position (Head of Department, Lecturer, Assistant Lecturer) and an academic qualification. A general staff has a job title. An academic staff teaches at most one course, whereas a student takes at one course wit...

Need to build a mobile app using react native and node js. Need to work seriously and work accordingly as instructed. The project detials will be shared upon contacting.