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.Najem SQL Developers
Una calculadora de bonos corporativos, usted puede elegir si le parece mejor una aplicación web o móvil (en cualquier lenguaje de programación). Primero debe haber una pestaña de login, para ingresar usuario y contraseña. Luego de eso, al ingresar, debe mostrar la calculadora. La calculadora de bonos que quiero debe trabajar bajo el método FRANCÉS. Los datos de entrada son precio de venta (puedes alternar el tipo de moneda entre dólares y soles). Cuota inicial (en %), fecha de emisión, número de años, tasa de interés (%, puede ser efectiva o nominal), tasa anual de descuento (%) y finalmente el periodo de la tasa (puede ser diario, mensual, quincenal, etc. Luego de haber ingresado todos esos datos la calcul...
We require the modification of an already operational SQL script that searches for products in our DB according to specific words and moves the products to a new folder. We are only interested in the search being carried out in a folder specified by us. Please answer only if you can do the job now. Answer only after you have read the budget. The work is only paid after proof of success.
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: Mining data from primary and secondary sources (SQL database, Google Analytics, Social Media Platforms, Email Marketing, etc.), then reorganizing said data in a format that can be easily read by either human or machine. 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 process improvements, recommend system modifications, and ...
We are seeking a Data professional who can support establishing/monitoring ETL/ELT processes within Azure Data Factory to support the buildout of an analytics data warehouse for an Ecommerce company. Ideal Freelancer will have: 1. Azure experience, specifically ADF. 2. E-commerce experience, and familiarity with Google Analytics/Ads, Facebook Ads, etc. 3. Strong SQL experience 4. Experience using API / ODBC connections.
Bonjour J'ai besoin de quelqu'un qui parle le français et qui a une bonne maîtrise en SQL pour un travail facile. Je vous prie de répondre aux questions suivantes pour que votre candidature soit considérée Quel est votre niveau de connaissance en SQL de 1 à 10? Dans quel cadre vous avez utilisé SQL? Quelle est votre activité professionnelle en dehors du freelancing? Quel est votre dernier diplôme? Je vous remercie
I have an embedded device that can communicate from TCP/IP with a special protocol. I need an app that will : 1. send a query and responses to/from our embedded device or devices in specific time periods. 2. log these answers on a local database(SQLite) 3. Can send this data to a remote database (MS SQL/PostgresSQL) 4. Show the actual status of data (level temperature etc...) on a dashboard 5. Show logs with filter search options based on date periods or id of devices. 6. Searched logs can be saved as pdf output 7. entering the application will require a password and username. This user will be checked from a local or remote database
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.
Need a trustable Power BI Developer, to co-work with us remotly. Tools and Terminologies: SQL Server Power BI TimeZone: Need to work at US PST Time Zone. Preferred 3 to 5 years experience candidate
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
Necesito continuar con el desarrollo de una aplicación Web en ASPNET Core, lenguaje C# a nivel del servidor y react a nivel del cliente. La aplicación deberá permitir que los empleados de una compañía puedan ingresar por cada uno de los dias del mes, la cantidad de horas invertidas en distintas tareas predeterminadas.