Step by step guide for using MySQL database engine from Node.js
Get your SQL development project outsourced from an efficient and reliable team. Freelancer.com is the ideal solution for jobs relating to your companies\' SQL needs. This job can be outsourced to any freelancer individually or to any group of people if your project is huge in size. There are many freelance SQL developers and experts working from all over the world who will take on your project at a full-time or part-time basis.
SQL developing jobs are in great demand these days due to its sophistication in the corporate world. The SQL developer will have loads of experience in Pl/SQL and Oracle. He/she should also possess the required skill for Perl scripting and UNIX shell, SQL tuning and optimization, be skillful in the SQL loader and UTL file processing, handle external table process, data modeling, script writing for data movement, backup or recovery, schema changes and many more. If you are a hard working and energetic SQL freelancer willing to work for any employer, get a job from Freelancer.com.Zaměstnat SQL Developers
ecommerce web app with used items and users can add items and also same can buy in product user can add item for maintainance first then show for sale and admin panel for managemnet and reports
Building an ETL process to load data from Source system to a SQL datawarehouse. You must have experience building ETL process using SQL scripts, Stored procedure or SSIS. Experience in Datawarehouse design and setting dimension and fact tables.
I would like somebody to help with a two page web application to render some data for a personal project.
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?
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.
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.
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
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 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.
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 .
Actualmente la empresa se dedica al desarrollo de sistemas ERP a empresas nacionales. Entre los proyectos se encuentran: El desarrollo del sistema interno a la empresa Papiro S.A (empresa líder en el mercado de impresiones digitales). Desarrollo interno del sistema del hotel Patagonia Green. Desarrollo del sistema de información de Mercator S.A. Entre otros. El estilo de trabajo se enmarca en la metodología Ágil. Específicamente se realizan sprints cada 2 semanas donde se revisan los resultados y se vuelve a planear el trabajo. Además actualmente se trabaja mediante una metodología semi-presencial, donde los programadores vienen a la oficina los días que se estimen conveniente. La cultura de trabajo sigue también lo estipul...
THERE ARE FOUR PROJECTS WITH R TWO WITH SQL AND TWO WITH TABLEAU I NEED A SOLUTION FILES OR DETAILS SOLVING TECHNIQUE ON THESE
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
Temos plataforma de e-commerce própria e gostaria de integrar o gateway de pagamentos da GetNet. Para integração da nossa API, 0 desenvolvedor terá que se basear na nossa documentação: Obs: Banco de Dados MySQL e código fonte desenvolvido utilizando Visual Studio 2013
App para desarrollar en c# extraer datos de una bd en sql y exportar en formato xml debe hacer preview y envío de datos a una web se da todo el esquema de trabajo para integrar y enviar
App en c# que debe funcionar con una app local para extraer datos de sql convertir en plantilla xml , realizar un preview , modo de aprobación y enviar a un servidor todo el esquema de funcionamiento se da en manual