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
i need project for my internship completion. i have concept "hospital management system", front end: react , Backend: wep api C#, database: sql 2019, run file on docker, git repository. user: patient doctor management technician
We are looking for an SQL script to be inserted via PHPmyAdmin and run every two hours. The script must search for products in a specific DB folder on the basis of certain words decided by us and must move the found products to another folder. We do not make payments and/or milestones before the job is done. Do not search for sums other than the amount set in the budget.
Need a freelancer for developing a PLC and SCADA program Program will consist of Application Logic Data Logging Recipe creation upload and download Preferable candidates from mumbai only
Need to create a simple full-stack application (round about 4-5 dynamic webpages) that gets the data from excel files or json and imports to the db. The tool should be implemented in Kotlin using KTor and Typescript. Detailed information will be sent upon discussion with freelancer.
Location: Remote Time: 10:30am – 7:30pm Contract: 6months SSIS Developer Skills / Experience: Required skills: • Must have 6+ yrs of experience in Business Intelligence development/integration or with SQL server development. • Min 2yrs hands-on experience in developing SSIS packages. • Capable and willingness to work single handedly on implementing SSIS solutions. • Must have exposure to at least 1 end-end solution design using SSIS. • Should have experience working with PL/SQL procedures and commands. • Should have a strong experience in SQL Server. • Should have excellent understanding of MS SQL Server & Data Warehousing architecture. • Should have good understanding of business processes and functional programming. • Good communic...
Chinook Database Introduction In this project, you will query the Chinook Database. The Chinook Database holds information about a music store. For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information. To assist you in the queries ahead, the schema for the Chinook Database is provided below. You can see the columns that link tables together via the arrows. All of the below instructions are discussed in detail as you work through this lesson on your way to completing this project. The below serves as a quick reference of what you will be doing as you progress through the completion of this project. Instructions You will need to follow the instructions on the next three concepts to ge...
I would like to have design for a web portal and mobile application. The portal will consist of modules that is customizable for each client. The portal will provide specific tools and data from a database. What I need is a blueprint rather than a complete design. Through this blueprint a software/web developer should be able to understand what should be done and based on that should be able to develop it from scratch. For example; lets say my website url is and my clients will have urls such as , trt.abc.com. Each url will have a login page and users will login to their portal through this page. Moreover the portal will consist of around 20-30 modules. Each module will have specific data for each customer. One client might have 10 modules while the other one can have 20 modules. Mechan...
You must be an experienced (7 years or more) SQL Server Programmer who can write (1) Optimized Queries (2) Clean up our existing stored procedures (3) Introduce transaction handling in the existing procedures (4) Introduce exception handling in existing stored procedures. The highlight of your eligibility for this requirement is your expertise and experience in writing clean and optimized stored procedures. Any experience in ECommerce and Fintech domain would be a great advantage. You will be required to spend around 25-30 hours a week initially abd You must be a person of high integrity , whom we can depend on for long term projects. Some of the consultants working for us have stayed with us for more than 4 years.
There are more than 10k sql records and some records are duplicated i want to learn which records duplicated regarding below conditions Conditions If = and = and = and – <= 95 days and <= 1,5 TABLE Column1 | column2 | column3 | column4 | column5 Row1 | 8800 | pencil | 1234 | 2022-05-05 | -658,5 Row 2 | 8800 | pencil | 1234 | 2022-04-05 | -655,5 Row 3 |8800 | pencil | 1234 | 2021-04-05 | -650 RESULT Row1 | 8800 | pencil | 1234 | 2022-05-05 | -658,5 Row 2 | 8800 | pencil | 1234 | 2022-04-05 | -655,5
Help in testing in prod server python programming language connectivity with oracle
If you have developed web application using php, and latest version of Oracle, I like to consider using your help to complete my project. So, please briefly explain the php with Oracle (v 19 or later) that you have done. We will take it from there. Thank you for considering my project.
I am looking for someone with the following reports on Oracle Apex ERP: 1 - Each report must contain an Excel file, a PDF, a Word file, and the equations for each report are clearly explained and understood. 2- Each report should be detailed (daily, weekly, monthly, quarterly, semi-annually, annually, hourly). Full professional financial reports in detail Professional cost reports and in detail Professional and detailed sales reports Professional and detailed procurement reports Reports professional stores and in detail Professional HR reports in detail Professional supply chain reports and in detail Manufacturing reports in detail, professionally and in detail Professional and detailed production reports Professional CRM Reports in Detail Project Management Professional (PMO) reports i...
We need a tool which can access a local SQL Server database, query a list of unique id values based on a parameter (town name), loop through this list while sending GET requests to the web API in order to retrieve the binary string of each image. We need to access and separately save each image file locally, named by the unique id values retrieved from the database. The API returns a binary string if a PNG. This tool needs to easily change source databases and repeat the process. It would be beneficial if the source databases could be a parameter table or CSV and the tool could be run via scheduling a batch file to run unattended. Two additional nice to haves would be to resize these images to predetermined dimensions (in parameter table) due to a legacy application unable to dynamically ...
ready-made power bi dashboards for oracle EBS finance & supply chain
• Work closely with Systems Architects and Technical Managers to gather requirements and design complex business application, data integration solutions and secured APIs, leveraging the Dell Boomi platform. • Translate business processes and data requirements into technical integration requirements and designs. • Act as subject matter expert on the Dell Boomi AtomSphere integration platform. • Develop new and provide on-going support for existing processes built on the platform. • Recommend best practices for all integrations using Dell Boomi platform. • Ability to solve complex data issues. Qualifications and Skills • Bachelor's degree in Computer Science or related field • 4 plus years of strong hands-on experience on Boomi Process building &a...
We are a startup looking for a Software engineer to help with the development of 2 application The first one is cloud based Electronic medical record system for hospital, clinic and laboratory. The system will always hospital to manage to patient data, chat with the patient. The second application and doctor appointment booking system. Patient can see the doctors profile and time slots , book an appointment , received their results or prescription.
Want to Billing Software (with code) in VB.Net with MySQL/SQL Server Database Desktop Application Facility to generate Einvoice and Eway Bill Invoice Print in Crystel Report Export to Excel and Pdf Format API Integration as per Indian Govt. guide line
I have a MySQL database with some tables and data. I need to add some additional fields to my main table and then have a update routine that that can read the record in the table , get matching data from other tables and update the main table with calculations and the results to be written in the database table. We can connect and share my screen to discuss further, I need this done immediately so must be done today. If you cannot do it today please do not reply and waste time
We're looking for a certified MySQL DBA who has an exceptional experience in DB performance optimization. You will join our engineering team and help client's project for more than 3 months. We're in middle of implementing archiving strategy so your initial project would be to carry out those archiving scripts and update them with ongoing basis. Project stack: MySQL, .NET Web APIs, Entity Framework, GCP Cloud SQL Requirements: • MySQL DBA certification • Fluent in spoken and written English You'll need to be available during the US business hours.
Require somebody who has an experience in bar code label printing in C# with SQL as database
I need to build a search/query engine where a user will type a query in english which will be mapped to a correct or relevant sql query. Post a trigger, sql query will fetch the details and display some insights, graphs and visualisations.
I am using Perfex CRM and a MySQL database. I need a loop routine that must select my data within a date range read the record find the correct price do a calculation and update the same record in the table and then move to the next till all us done. I require this as a option on the menu that we can reuse at any time. Must be able to work live online on my server as we will not be sharing the application or database to any outside person