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.Hire SQL Developers
Want real estate web based responsive application where seller can post his property and Buyer/Renter can send his request. Application should be developed in ASP .Net.
Write the SQL code to create two (2) stored procedures to populate transactional tables. Write the SQL code to create two (2) business rules leveraging User-Defined Functions (UDF) in addition to a sentence or two to describe the purpose/intent of each business rule. Write the SQL code to create two (2) computed columns leveraging UDFs. Write the SQL code to create two (2) different complex queries. Here is a breakdown of what is expected of you: Correct use of parameters, variables, error handling, and explicit transaction. Correct use of User-Defined Function, ALTER TABLE statement. Correct use of User-Defined Function, parameters, and ALTER TABLE statement. Correct use of at least three components below: multiple JOIN statements leveraging OUTPUT parameters declaring/populating var...
DotNet developers required for errors removal thenafter synchronisation of sourcecodes & host. Lots of good opportunities and financial benefits for DotNet, Xamarin, Cordova, Android, iOS developers after Launch. Explaining 'Basic functionalities' video- Explaining 'Errorlist' video- Website address- Useremailid- @gmail.c Password- kaspersky
Job description: · 5+ years of experience in ETL and Data warehousing · Should be able to handle the ETL team · Good Experience in AWS such as AWS Aurora, AWS Redshift & AWS S3. · Strong expertise in writing complex SQL Queries, Stored procedures and functions · Experience in Talend ETL and Agile Methodology. · Experience in Core Java and JasperSoft is a plus
The SQL PROC will need to compare two database tables ( I will provide the table structure and sample data) New additions to the table are new staff that have joined the organisation and should be emailed to the Service Desk within the PROC. Leavers are records which do not exisit in the table and should be emailed to the Service Desk within the PROC. Changes in staff departments or roles should be emailed to the Service Desk within the PROC. Teh PROC will need to maintain an audit trail of record changes
Need someone proficient with php to work on an ongoing project - with an on demand type of style - will be paid per hour worked. Will need the dev to create endpoints, create/modify some api and create new tabs on sql
Project duration: Upto December 2022 Hours required : 40+ per week Payment per hour Mandatory Skills and Knowledge: Core Java/J2EE/REST API/Spring MVC/Sprint Boot/XML/Hibernate Must have experience in REST API and Spring and Dev Ops (Maven/Bit Bucket/automated build) Good in Java Security Concepts Experience in PL/SQL, SQL Server Good Communication Skills Roles and Responsibilities: Write Java code modules and as per coding standards Experience and Knowledge of Agile and Scrum Process and coordinate with teams Participate in client meetings to communicate status or give demos Abide by team coding standards, development processes and best practices Develop low level design documents and review technical documents from Solution Architects for projects Perform code review and follow iterat...
Project Objective: 1. Build tally plugin which can download ledger data from tally to the local machine and then publish the same online using our APIs 2. Extend the tool to be able work with all Tally version About NAKAD: NAKAD is founded by former graduates of IIM Ahmedabad, IIT Bombay and IIT Guwahati who previously worked at BCG, HUL and Oracle, The company is transforming supply chain finance through their tokenization mechanism. This way Anchor's creditworthiness traverses across supply chain making easy and cheap credit available to MSMEs.
We are looking for a Data Analytics expert with the below mentioned skills : Mandatory skills : SQL, Python, Py-Spark Required experience : 3-7 years Location : India Hours required : 40+ per week Payment per hour
Module to be covered: Introduction to SAP and SAP Overview SAP Business Suite 3 Tier structure and S/4 HANA overview Overview on the key function modules like SD,MM & FI, PP, PM, PS, HCM etc Overview on the SAP Organization structure ERP/SAP Overview ABAP Language Overview and Workbench Concepts and Tools Programming Techniques Overview of SAP cloud and Saas, Pass and Lass ABAP Language Overview and Workbench Concepts and Tools SAP Database Architecture SAP GUI and Netweaver Search help in SAP transactions & SAP Library Exception handling Overview of SAP cloud ABAP List Processing File Handling Techniques & OSS Notes Application Debugging & Dump Analysis Programming Database access and updates Batch Data Communications (BDC)/BAPI/LSMW Module Pool Development SapScript/Smart...
We are looking for Python ETL Developer Minimum Experience- 3 Years Shift -Indian Shift Contract- 6 Months (Can be Extended)
Need a procedure to create database schema as per the user_name. 1. Create a public database with sample data table. 2. Create a procedure to create a user and id. 3. Create a procedure to create a user based on user name and copy in new user schema.
We are looking for full time Oracle Software Developers who are able to undertake support and development in Oracle 19c using PL/SQL and SQL. Preference will be given to those who can work from home on a full time, dedicated basis for our project wholly.
I need to build a basic CRM/database (Ideally with airtable) of customer name a demographics that also links through to multiple documents per record in a separate table with other information
I need someone with skillset of database CDM that can help with development, validation programming, discrepancy management, database release, extraction and graphical representation of safety data during study conduct, review of data before database lock, review of CSRs.
I need a trainer who can give corporate training on Data Engineering on Microsoft Azure Total Number of Day - 15 Topics need to be cover 1. Overview of Azure ecosystem 2. Relational Databases 3. NoSQL Databases 4. Data Warehousing 5. Azure Synapse (formerly SQL Data Warehouse) 6. PySpark and Components 7. Azure Data Engineering Services introduction 8. Explore compute and storage options for data engineering workloads 9. Run interactive queries using serverless SQL pools 10. Data Exploration and Transformation in Azure Databricks 11. Explore, transform, and load data into the Data Warehouse using Apache Spark 12. Ingest and load data into the data warehouse 13. Transform data with Azure Data Factory or Azure Synapse Pipelines 14. Integrate data from notebooks with Azure Dat...
IMPORTANT: My budget is very limited This task is super basic: Connect to MSSQL database and display a sample SELECT query results in a datagridview You only have to connect to my MSSQL. Then fetch data with this query: SELECT TOP (1000) [SiteID] ,[ResourceID] ,[ItemNmbr] ,[QtyOnHand] ,[StockDT] FROM [AIMS].[dbo].[TrxDailyStock] Then display it in a datagridview (attached image). I will provide access to the VPS that has the database and also the C# project.
I’m looking for someone to help me build a portfolio management and analysis program. We have been using an excel based system for a long time which works really well, but we want to try and wrap it up in a software program that is more solid and robust. the program works by sucking data from a financial administration (eg netwealth or HUB24) platform in CSV format. This data contains information about clients, investments, values, units held, cost base information, transactions etc. the excel program slices and dices the data to present it in a way that we want. It’s very dynamic
My server crashed so i was only able to recover data, had no access to phpmyadmin or sql Hi, I downloaded all data and i have the mysql folder from the server It contains all folder and tables for my databses but the files are frm file and ibd files I need to use those in anyway to be able to export sql file that i can upload to my new server It might be possible the ibd or frm are corrupted, so should be able to fix those. Thanks
I have a Volusion store. I need to retrieve Order details for each order that I can then use to build excel spreadsheets. I want to be able to control which data fields from the Orders database are pulled. I think the best way to do this is through API but open to suggestions.
We provide gyms and health clubs with sales, marketing and membership services to help them grow. We are looking to build a new mobile App that will allow our gym and health club customers to provide their members with useful functionality to help manage their memberships. The app needs to be available in multiple languages (EN and DE initially) and should be designed to allow further languages to be added easily in the future. Our Health Clubs should be able to: - Publish news and information about their club to the Newsfeed for App users to view - Share local offers and information with their members - Send updates/ push notifications to their members The apps will need to integrate with our enrolment process for new user registration and our internal SQL data to allow memb...
hey i have an excel file with 16K rows containing a website urls column and additional columns with data on that website i have lots of dupluicated rows i need uniqu values in the website column, removing duplicates, merge values to 1 line per website
This module will collect all the Appreciation/Suggestion/Feedbacks from the will go though a approval process from HR. After approval Appreciation will show on our website & Suggestion should have acknowledgement from HR & Feedback will be given to that person though mail. Reports will be required on this. Note - Application should be Mobile Responsive, Database connectivity and hierarchy (Reporting to Reportees) in Laravel/8 or Laravel/9 and Login Page and session and Email for each process(stage) and approval cycle.
PLEASE READ (do not waste my time) Need untouched fresh UK phone number lists. Old people phone numbers are preferred. I do not need scraped or easily accessible data. Do not message me offering scraped data, or old used up data that has been run through call centres. The data must come from a websites database (not scraped), or from marketing campaigns such as CPA etc... Again - please do not waste my time with bad data, I will not buy anything until I have an adequate sample of at least 3,000 phone numbers!
Job Title: Technical Analyst- ETL Dev Experience : 3 to 8 Yrs Relevant Experience: Tech Analyst ETL - Overall experience of 3 to 5 Yrs and 3+ Yrs into Informatica Power Center and experience into IICS will be plus. Analyst ETL - Overall experience of 7+ Yrs and 4+ Yrs into Informatica Power Center and 1+ Years of experience into IICS Notice Period: Immediate or Max 15 days Job Location: Bangalore Shift Time: 1 PM to 10 PM Experience and Mandatory Skills: ETL development using Informatica Power Center. 3+ years of experience in developing SQL code in Snowflake/Oracle/MS SQL. Good knowledge about Business Intelligence, Data warehousing concepts and methodologies and Reporting tools Experience designing complex ETLs extracting data through RDBMS, Flat file, XML files, Json sources Shou...
Hi I am receiving report on CSV file and wants to upload on my server. Admin can upload these report and user can check those Basic User system also required. Admin create user and user can see those report with some unique password (Predefine password can add)
Create, design and implement a web-based application capable of running SQL queries and displaying the results of said query. The application must include a space which accepts SQL queries in the form of user inputs, then runs the given query, and displays the result within the application.. Please note: - **This is a dummy application**. - **You must include a space to accept SQL queries**. This can be as simple as a textarea or as complex as a full-blown code-editor. This does not figure in the judging criteria though. - Your application **does not need to have a backend, a query engine or query validation**. - You **do not need to add any syntax validation**. - The data that your application displays can be any chunk of data. It does not need to be the actual result that the query wou...
I am looking for someone with expertise in R/Python to build a web based app where user will upload data on a webpage (a set of excel files) and should be able to generate a visualization report. The files will undergo transformation and upon clicking download, it should generate a report with static visualizations and descriptions. Qualifications and Skills: - R/Python - Computer Science/ IT/ MCA - B.E (Final year students)
Remote: UK / EU / Americas time-zones Flexible Contract / Part-time TBA Salary: £45,000 - £60,000 pro-rata We are looking for a senior developer with experience of full-stack web application development and the Django framework. Who we are Assemble has created a web platform powering the campaigns for over three thousand films and tv shows - think of it as wordpress for movies. We believe that creators thrive when they have the right tools in front of them, and the right infrastructure behind them. Our web platform is the force behind the official websites for award-winning films, books and tv shows. Our product philosophy for our users has always been - let users focus on their design, keep the set up simple and automate everything else. The Role You will be working with the...