Sql일자리

I am looking for an experienced Oracle SQL and Python expert who is comfortable working at an intermediate level. The ideal candidate should have experience in a similar position, and should be able to demonstrate their ability to fulfill this role. The deliverables of the project will be SQL scripts that are built to accomplish a specific goal. This can involve automation of existing databases, as well as writing and improving existing ones. The successful freelancer will also be expected to perform data analysis and create reports from the results. For consideration, please include relevant experience, detailed project proposals and also past work in your application.

I need 19 existing SQLite .db files converted and imported into microsoft SQL server. Each file contains rows of one table. There are a total of 8 million rows of data split into 19 files. A sql server database already exists and the files are all being imported into a new table in that database. I need this today today please. I will send you the files (around 20gb) and you would then connect with my pc (anydesk) after converting and import into my existing sql server db which is on my local pc.

...currently, I'm doing validation using simple HTML, but I want the validation to be done using Jquery, like minimum length requirements and all should be there, I do have the written code for the same but it is not working I do not know why. As it is a CRUD app, I want validation on Create New Item Page and on the Edit Page. 3. For Information: I am using Visual Studio Professional 2019 and Microsoft SQL Server Management Studio 17 for this project since this is the sample project I'm using a local Database. 4. I'm using stored Procedures not the Entity Framework, but have different files for a different stored procedure, therefore I want you to combine all the stored Procedures in One Single File and update the Code Accordingly. 5. In the same way, as you must b...

I'm looking for an Oracle SQL and Python expert to help with a personal project I am working on. I have existing materials that need to be modified and utilized for the given project. The amount of time needed for this project should not exceed 2 hours. This project is for personal use and does not involve starting a new enterprise or working for an existing business. I am a knowledgeable user of SQL and Python, but am looking for someone who may have more experience to give me some extra guidance in completing my project with these languages. If you are an experienced Oracle SQL and Python programmer, I would greatly appreciate your assistance. If you are able to help complete the project in under two hours, please reach out to me and let's discuss fur...

Analysis of changes and massive update of data between two tables of agricultural parcels with a common field. Work environments: GIS, ms access, SQL and python.

...currently, I'm doing validation using simple HTML, but I want the validation to be done using Jquery, like minimum length requirements and all should be there, I do have the written code for the same but it is not working I do not know why. As it is a CRUD app, I want validation on Create New Item Page and on the Edit Page. 3. For Information: I am using Visual Studio Professional 2019 and Microsoft SQL Server Management Studio 17 for this project since this is the sample project I'm using a local Database. 4. I'm using stored Procedures not the Entity Framework, but have different files for a different stored procedure, therefore I want you to combine all the stored Procedures in One Single File and update the Code Accordingly. 5. In the same way, as you must b...

I am looking for an automation anywhere and SQL expert to help with a one-time project. The scope of the project is designed to be completed within a week. My team is not sure whether we have an automation anywhere or sql expert already present. If you have the expertise, I would love to hear from you.

Configure CWP panel for Magento 2 Varnish + Nginx + Apache + FPM - OPcache - SQL MariaDB -PHP 8.2 - Bread - Elasticsearch - email For Magento 2: Redis AQM

Nature of Business - B2B IT infrastructure Solution provider , we have a sales team of close to 30 people , we would like to have an inhouse CRM Tool developed with custom flows and integration with our SQL database. Looking for individual who handle the developemnt part, i have a in-house product manager who can design the flows .

...functionalities: 1. Download data from a the destination type and store as a JSON in a pgSQL DB. 2. take data and upload to the destination I need you to create the following connectors that will include any authenticication parameters needed to access the data source: SQL Server, xls/xlsx, csv, txt (deliminated), Oracle, MySQL/MariaDB, Postgres, IBM DB2, MangoDB, TeraData, DBF, Slowflake, PowerBI, Tableau, Sales Force I require your recommendations on addtional: Azure, Google and AWS DB connectors, SAP, Shopify For DBs like SQL, PG, MySQL I need the ability to read the tables, in one function which will allow me to determine which table to import or query, In addition to building, I need documentation on how to use each the connectors. I will be constantly availabl...

Using a github repo, update the source code to meet the requirement outlined in the statement of work and commit source code back to repo. Requires expertise in Laravel 8, PHP, Javascript/JQuery, SQL, Composer, NPM/Node.js, and CSS/SASS. The bulk of the website is done and working, this project is to provide updates based on new requirements.

WE ARE LOOKING FOR DEVELOPERS SRI-LANKA BASED ONLY ILLUSTRATOR/PHOTOSHOP DESIGNER 32H/WEEK - 45/65$ PHP/SQL DEVELOPER 32H/WEEK - 60/85$ C#/UNITY DEVELOPER 32H/WEEK - 60/85$ C++/UNREAL DEVELOPER 32H/WEEK - 60/100$ RECORD YOUR PROGRESS WITH TIMETRACKER AND SCREEN RECORDING

We are having issues with our Snipe IT Asset Management System. When removing assets or updating assets some fields are not getting updated. Example : When I check out an item it should lower the number of stock but currently it stays at the same quantity. Its like the SQL database values are not getting updated. Also when removing an item completely, the database value still stays the same. Need someone who knows Snipe IT asset System, Php and MYSQL to help fix whats going on with our Asset DB. Should be a quick job for someone who understands whats going on

OpenCBS System requirements are relatively low. As such the system could be installed on any computer with windows as operating system. OpenCBS is a system working as an interface between the user and a database containing the information of microfinance activity. As such using OpenCBS requires the installation of a database management system, in our case SQL Express as minimum requirement. The reporting section of the software requires as well the installation of Crystal Report Viewer, the software managing the visualization of report in the software. 2. Milestones 1. Analyse & Deploy the existing source code provide within the 2 folders (client & Server) 2. Minor customisation the existing application as phase 1 covering 50%+ of our requirements as per below table under...

...JDBC to connect to multiple data sources Nice to have skills: Good experience on Spring Security based Authentication and Authorization protocols Good knowledge and hands on experience working on AWS based technologies and services and integrating them with your Java application. Good knowledge of front end charting libraries like in both Angular and React is desired Good knowledge of SQL queries, specially using Oracle database Duration of the Project: 6 to 12 months ...

Hello, I am looking for an experienced freelancer to help me with SQL server queries. I will test with one query first. But would use you for others if proficient. Example query: Two tables joined by one column. One of the tables contains time stamps. I want the rows split into groups whenever there is a gap of more than 5 mins between timestamps. Eg Timestamp 1min - grp1 1.1min grp1 2min grp1 6min - grp1 12min grp2 16min grp2 23min grp3 The groups will then have a column edited The size of the database I need to query is medium. I would prefer someone with past experience working on similar project who understands the particulars involved in such a task. If you think you can help me out, please let me know. Thank you!

...Minimum of 5 years of experience in Java development In-depth knowledge of website design and programming In-depth knowledge and understanding of Java and Java EE Excellent analytical, problem-solving, and troubleshooting skills Ability to work both independently and as part of a team Knowledge of hardware and operating systems (Unix-based systems a plus) Understanding of relational databases (Oracle, SQL Server, DB2) Agile experience with application servers and web application servers...

Looking for a dynamic innovative Database developer who has experience working on both SQL/No-SQL Must have Familiarity with SQL, MongoDB and NoSQL data models Must have experience working on Domain Driven Architect Job is to: 1. Understand Business 2. Create Schema, Database Model on SQL 3. Create Catalog/Data models on MongoDB (NoSQL) using SQL as a source

Software that connects an SQL database to Shopify inventory and orders using the Shopify API. Take the query of the balance line every 30 minutes and subtract every incoming order from that value. When the value reaches zero make every product go out of stock till a sufficient balance is returned.

I am experiencing an issue with my Magento 2 store whereby when I try to log in or change store view, I get an SQL error (column not found: 1054 Unknown column). My site is currently at Magento 2.4.5 version. I am looking for someone who can assist me with rectifying this issue? You can see sql error at attached file.

I'm looking for someone to help me setup a Symfony website from a backup/dump. I already have the VPS setup with Nginx (no phpmyadmin). Your mission will be to setup the website on the VPS based on the files I'll provide you with: - (git export) - assets (uploads/medias) - sql db dump - VPS & mysql credentials Then, I'll update the DNS to point to the server. It should be done ASAP, within next 24h. Thanks Best

I am looking for a freelancer to develop an asset register for me. This asset register needs to include software and have the additional feature of notif...authorized personnel. Features required are: * QR Code / Bar Code Tracking * Accessories for Asset (sub level) * Maintenance Schedule (time based / periodic) * Mobile App (QR Code Scan) to retrieve Asset Information) * Asset categories and Groups * Reporting / Dashboard * Admin / Setting Functionality * Multi language - choose language for navigation and data columns * Data hosted on cloud server (SQL Server / Azure) The freelancer should be knowledgeable about asset management systems and have experience delivering high-quality asset management applications. If you think you could help with this project, please contact me. ...

I am looking for expert assistance to create a SAP HANA SQL stored procedure.

Job Summary: We are seeking an experienced Python Senior Developer to join our team and contribute to developing algo trading products. In this role, you will be responsible for designing, developing, and mentoring other developers to create well...business teams to identify current and future business requirements. Qualifications: • Bachelor's Degree in Computer Science or a related field • 1-3 years of Python development experience • Experience with Python libraries such as Panda, Numpy, and Django • Experience with REST API, OAUTH 2 Mechanism, Redirect URLs and Excel • Strong algorithmic and data structures skills • Strong database skills (SQL) • Previous work with REST services and cloud infrastructure • Experience in deploying appli...

We are seeking an experienced API Integration Developer to build a channel...experience in API development and integration with third-party platforms. Experience in working with Airbnb, , and VRBO APIs is required. Familiarity with OAuth 2.0 authentication and API authentication mechanisms. Knowledge of webhooks, data synchronization, and data mapping. Strong proficiency in programming languages such as PHP, Python, or Node.js. Experience in database management and SQL query optimization. Strong problem-solving and debugging skills. Excellent communication skills and ability to work collaboratively with a remote team. If you meet the above requirements and are excited about the opportunity to work on this project, please submit your application. We look forward to hearing from you!

...products. You will also be required to manage a technical team and work collaboratively with technical and business teams to identify current and future business requirements. Skills: • Strong experience with Python libraries such as Panda, Numpy, and Django • Experience with REST API, OAUTH 2 Mechanism, Redirect URLs and Excel • Strong algorithmic and data structures skills • Strong database skills (SQL) • Previous work with REST services and cloud infrastructure • Experience in deploying applications at scale in production systems Responsibilities: • Design, develop and mentor other developers to create well-written, high-performing APIs and services • Analysis and design of application interfaces and integrations • Integration of ...

We have a microfinance management software called OpenCBS that is relatively easy to install on a Windows computer. However, to use it, we need to install a database management system like SQL Express and Crystal Report Viewer for report visualization. We have four milestones to achieve: We need to analyze and deploy the existing OpenCBS source code found in two folders, client, and server. We need to customize the existing software to meet at least 50% of our specific requirements, focusing on the existing modules in the software. We want to rebrand the software to match our organization's branding guidelines. We need to develop new modules not found in OpenCBS, with a timeline for deployment, a rollout plan, and User acceptance testing (UAT). We will also maintain version...

upgrade an existing Ms Access 2010 adp project with a backend Ms sql 2014 database needs upgrading/MIgration to MS access 365 / back end MS SQL 2019 express

The rendering will be in the form of a report with the list of commands an...format Drop the data in the directory (use the processesor putHdfs) HDFS /common/raw/DATABASE_M1/ETUDIANT_M1_PART/DateRecep=202210ddHHmm (this value must be generated dynamically by nifi, (use an attribute of the flowfile with a date value in the requested format ex: Variable_DateRecep with value DateRecep=${now():format('yyyyMMddHHmm')} Do a select on the table, what do you notice? Run the following sql command Msck repair table DATABASE_M1.ETUDIANT_M1_PART; Copy the data (via an hql query executed by NIFI) from the ETUDIANT_M1_PART table to the ETUDIANT_M2 table so as to keep only the latest version of the file sent (used the OVERWRITE keyword and in the where clause of the select use the value ...

Well-versed with Java language, Core Java, Client-side programming, Server-side programming, and J2EE technologies. Knowledge of presentation languages such as JSP, HTML, Style Sheets, and JavaScript. Familiarity with AJAX, JQuery, and equivalent technologies Good understanding of relational databases, SQL & MySQL Understanding of Struts, Hibernate framework. Responsibilities and Duties Develop & implement new software programs. Maintain & improve the performance of existing software. Test & maintain software products to ensure strong functionality & optimization. Recommend improvements to existing software programs as necessary. Required Experience, Skills, and Qualifications. Qualifications and Skills Should have good written and verbal communication skills...

The Business request for this data analyst project was an executive sales report for sales managers. As per the request , company need to improve their internet Sales reports and want to move from static reports to visual dashboards. To create the necessary dat...for this data analyst project was an executive sales report for sales managers. As per the request , company need to improve their internet Sales reports and want to move from static reports to visual dashboards. To create the necessary data model for doing analysis and fulfilling the business needs defined in the user stories the following tables were extracted using SQL and also we have manipulate and cleansed the data using SQL. As per the request we have made creative Dashboards with the help of visualization too...

I am looking for an experienced freelancer to assist me with coding a script for a MS Access database. The intended result will be a table with...No data input, manipulation or validation is necessary for this particular project. The freelancer should be familiar with Microsoft Access and be able to write efficient code to quickly complete this project. I expect the script to be properly documented and tested, and all tables to be optimized and organized for easy updating and retrieval. Experience in working with other databases such as SQL Server and MySQL is also a major plus. Please provide samples of your previous work if available. If you have the skills, ability, and knowledge needed to complete this project then please do not hesitate to contact me. I look forward to your ...

We are looking for an experienced back-end developer to join our team for long-term cooperation, with knowledge of Node.js. We develop a web application in area of finance. We use Azure services and tools. Most of the work we do from home. We are looking for someone with whom we will enjoy working together. Requirements: - Node.js - SQL at least the basics - Git or a similar system - orientation in cloud solutions Expected start: April 2023 If you are interested, do not hesitate to contact us.

I am looking for someone to convert a CSV file into a SQL database file. I have attached a sample document to show the structure, however please note that the original CSV is 25GB. I understand this can be achived via a python script, however I am happy to consider other methods. I require this document very quickly. Please also note there are many columns (A-WRJ)

I am in need of assistance troubleshooting an issue that I am experiencing when connecting to MSSQL. The exact error I am receiving is a 'network connection issue' and I am currently using MSSQL 2017 with SQL Authentication. I am looking for someone experienced in this area who can help me resolve this issue quickly and efficiently.

I am looking for a resource to help with setting up an Azure App Service and SQL managed instance backup to an on-premises storage solution. This requires backing up both application and database data. The desired storage solution for the backup is on-premises storage. I am open to suggestions on estimated costs, timeline and project plan.

...maintain and execute automation scripts for Digital Channels Projects (Web, Content, Accessibility, Performance testing, Mobile) incorporating QTS Automation Solutions Service – Engagement & Operating Model WHAT WILL YOU DO? Functional and integration test manual and automation testing Test case planning and review of existing scripts Development of automation scripts Test data preparation and SQL scripting Support testing efforts during business UAT Performance requirements gathering Support performance benchmarking, testing and monitoring Support integration with DevOps tools & automated build /deployment processes Participate in agile sessions, daily standup etc. Assist with defect management and reporting Integration with Jenkins (CICD) UI,API &DB testing ...

...you. What ever price you quote, I expect you to stick to it. The previous freelancer offered a delivery deadline of 40 days and failed to deliver. You will be required to set a delivery deadline and this is to be included in your proposal. Please indicate a daily bonus (if you deliver the project early) amount as well as a daily penalty rate (if you deliver the project late). I have a IIS & SQL server ready and running for this project. You will be able to use WebPublish to push progressive updates of this task to it. There are already futher features planned for this project and so it is ongoing for the right person. Please note, there is a requirement to incorporate another task posted on Freelancer. Proposals that do not specify the current year in the first line (v...

Minor PHP/SQL Edit - Looking to add a "Change Pricing Button" Wordpress based website, I have all files and locations of the files to make this edit very easy

Java developer with strong knowledge and experience in spring reactive, graph QL, spring boot, Oracle Sql developer, putty, experience in dealing P1, P2 tickets in production. Need to be on all support if necessary. and will be increased based on performance and open for negotiations…. Payments will be made monthly Salary 25k/month

We are looking for development experts, with the following requirements: - Proficient with .Net Core, Web API, Angular Material and MS SQL Server - Should be ready to complete the task in stipulated time - Should have minimum of 5 years hardcore development experience in these technologies required.

We need a Django application to display using plotly ( or similar ) interactive graphs in elegantly arranged format on webpages... This is for my company to be able to see all the data in one place. 1. Pull data from database 2. Plot time trend ( parameter by week) of "Critical" parameters in a say 3x3 grid . 3. rest of the graphs ("normal") should be on second page also in a grid but no more than 8 graphs in one page. Database Notes: You can use dummy database that contains 20 parameters like - sales , profit , inventory etc . This data is weekly data. 5/10 parameters should be marked as "Critical" parameter. Rest should be "Normal" And please check attached image. Please apply if you can deliver this project within 1 day or soon with fixed budg...

web and android app with back office  Design and development of the Matrimony website and Android app can download if the user wish with SQL DB  integration of the website and app with a back-office panel for managing content and data Adds and google admob  Implementation of a search engine for users to find their ideal life partner with their matching content with percentage bar and display the most matches  Integration of messaging and communication tools for users to interact with each other –  Development of a membership system for users to sign up for paid services ->Ongoing maintenance and support services- Verifying the members Email and phone otp  Multilanguage only 3  PayPal/Payaneer integration

Hi, We have a food app that we brought from the code canyon marketplace, which is having a multivendor app and a user app along with its backend... we need to integrate this vendor app into the user app so that user also can post their restaurants if in case needed also we need to integrate a chat between the user and other users, basically when we integrate the user app and vendor app then it w..... All apps that we brought are not tested from our side, but they should work...so the basic bug fixes also should be taken care of along with this integration in case of blocker issues... we are expecting this outcome in a 1 week time or max 2 weeks with fixing all the basic issues + 2 apps integration in one app and a chat integration.............. Technology: Flutter android Laravel Php ...

...Microsoft Excel dashboard that has pulled data from an SQL server from ERP (Enterprise Resource Planning) software called CENCO. It has acted as a means for the viewer to have a full insight and overview into our business in real-time; being able to view KPI's into multiple areas of the business, including sales and invoice figures, production numbers, sales rep budgets, labour capacity, purchase orders from international suppliers, currency exchange rates and branch comparisons. The current Excel dashboard would be used as a base to work off - but we are not after a like to like comparison that's just copy and paste into Power BI. We would like the same data to be displayed in a Power BI dashboard. It would need to pull data from an SQL server, ALS data...

I have multiple excel files that needs to be uploaded to sql database with specifications that are explained in the document file. I have a python code that creates a sql query to upload the specific rows. I will provide the code wich its open with google connect, what I want is to create a program that will be run one time and it will upload the files straight into sql. To proceed with the project I will need to share screens with you through teamviewer or zoom so you can work through my computer since I am not able to share the database. Please place a bid if you are willing to share screens. thank you!

Criação tabelas e views em mysql com calculos matemáticos, com condições especificas, confirmações de datas e períodos horários ante de obter os resultados, execução de queries com condições , etc

These websites allows sellers to manage inventory with rest api My desire is to use the RestAPI to manage my inventory and possible orders Currently I manually create the product listings and when we sell on a website I have to manually remove from other websites. I do have my data in a sql database so I can assist with the data table but you will have to do the api I have no experience in that JIm

...must be built using the Laravel PHP framework and should be able to gather, store, process, and analyze data from multiple sources to generate insights that can help drive our business decisions. Project Scope: The proposed Business Intelligence software should be able to provide the following functionalities: Data Integration: Ability to integrate data from multiple sources such as CSV, Excel, SQL databases, etc. Data Warehousing: Ability to store and organize large volumes of data in a structured manner for easy access and analysis. Data Visualization: Ability to present data in a visually appealing and interactive way using charts, graphs, tables, etc. Data Analysis: Ability to analyze data using various statistical methods and generate reports that can help us make informed b...

...creationfrom zero::::::::::::::::::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::::BUDGET CHECK 400$ ::::::::::::::::::: Website creation !!!!!!!!!from zero 1- Design 2- Functionality 3- Debug/Test 4- Deployment ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;do with latest version;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; JavaScript JS, JavaScript JSON, HTML, CSS, PHP, SQL Software Version PHP 8.x, PHP 7.x, MySQL 8.x, MySQL 5.x ................................................................................................................................................................................................... creation of a complete website with all similar functions :::DEMO REFERENCE look at demo reference links: