Sql jobs

The project involves setting up AWS IOT Core (or Azure equivalent of it) having following featuers : 1. Basic setup 2. Just in time provision of device registration 3. The data should be inserted into AWS RDS running with SQL Server OR Azure SQL Server 4. Basic handling of "bad data" e.g. empty values or value like $%^&* coming from device instead of a integer I am okay to use either AWS or Azure but happy o hear about your recommendation. The above requirements are POC. A laptop/desktop sending some random values can be used instead of a real device. MS Azure is preferred. Deliverables : 1. Complete IOT setup 2. Basic training 3. Step by step instructions document 4. Certificate/private-public keys and any other files generated in the process

Please Sign Up or Login to see details.

Hi, I need for a customer of mine to update records from Magento/Freshdesk. It's possible to use Zapier or something else. Requests: - sync/update contacts (Magento and Freshdesk) - Sync/update ticket (freshdesk) - Sync order (Magento). Only consultant with experience on Zapier and with SQL. Please don't make proposal without requested properly skills .

Please Sign Up or Login to see details.

please teach me step by step to find the bug domain

...learning to learn by building real-world applications. Our courses are project and outcome-based that promote learning by doing approach. We have over 60,000+ learners across the globe. We are looking for partners who can help us create more content and courses. You will be working with us to create a 20-hour + course on Oracle Database Who is eligible to apply? 1. Must have knowledge of Oracle SQL, Database Design, RDBMS concepts, and Simple and complex queries. Knowledge of MongoDB is a plus. 2. Must be a good writer and has the ability to simplify topics + explain things well. 3. Should have good writing skills 4. Would prefer candidates with a computer science background 5. The content should be unique with unique examples (no plagiarism) Selected individuals day-to-day...

Hello , The aim of the project is to scraping historical and current pre-match odds from three sites : Nowgoal/888 ScoreLine/7mcn and then send the data to a SQL database . Also, the database must cooperating with existing historical odds data (Excel/CSV files) . Thank you for your interest .

...Client-facing skills: Solid experience working with clients directly, to be able to build trusted relationships with stakeholders. 2) In-depth understanding of Data Warehouse, ETL concept and modeling structure principles 3) Expertise in AWS cloud native services 4) Hand-on experience in developing data processing task using Spark on cloud native services like Glue/EMR. 5) Good to have experience Snowflake SQL queries against Snowflake Developing scripts using java scripts to do Extract, Load, and Transform data 6) Good to have experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures. 7) Excellent verbal and written communications skills 8) Ability to collaborate effectivel...

The customer profile page or dashboard should have the following navigation options or hyperlinks to perform the followings actions: a) View – To see the customer's personal details b) Edit – To change the customer's de...displayed, “Your reservation completed successfully!” Using the history option, the customer will cancel the cruise 7 days (1 week) before the departure date. Using JPA-Hibernate implementation, you should define entity classes for Customer, Cruise, and Booking with persistence. Use MySQL to create a “CruiseDB” database with the following tables and use appropriate data types. You should perform SQL CRUD operations and other specified tasks mentioned above. You can add any appropriate fields based on the b...

Adventure works data movement from on Prem SQL server to S3 or snowflake using Apache nifi, talend or other etl tool Kafka etc

1) Code-review Pipeline should be built using AWS tools only 2) It should review sql and python code and provide 1st approval on pull request. Share quotation only if you have worked on such task.

Hi, Need to create a SQL code in SSMS from already built tableau worksheet. Looking for someone with experience in SQL complex queries along with good knowledge of tableau. Thanks

I would like to improve on the Excel spreadsheet attached and turn it into an excel vba database OR sql/microsoft app whatever you advise, have a dashboard summary and be able to generate reports. Want to completely rebuild it to some sort of project management system

I want to make a simple app Including in login and sign up system Last call log Send WhatsApp and verify Upi payment acsept Flow Signup with pay ? Login with number ? In home screen H1 - Text Show avilable balance Buton withdraw now Buton whatsapp now H1= show available balance from database SQL H2= insert row in sql H3 = after press this button Get recent dial number And WhatsApp on this number the particular fix message Insert this record in SQL Add 25 rupees in available balance

We have a running API based website. There are some SQL database related errors that need to be resolved.

Open We have a number of clients where our software is hosted on our client's server. The clients own the server as well as the SQL database licenses. They create our SQL access. Our clients makes backups of the databases so have full visibility of our database and Source Intellectual property, because they do backups of the databases they can restore our solutions onto any server without us knowing

My Existing Project is developed in Asp.net c# project. I need a module in which a Pdf or Jpg File can be upload in OneDrive using Asp.net C# Code. And the Computer Generated File Name will be save in ms sql server database database example Column S. No. Unique ID File Name

Need responsive customer satisfaction system to be developed on asp.net webform and ms sql The system will have admin page to create the survey and view all data

The aim of our project is to make a web based Parcel Management System which supports the vast availability of parcel services to businesses and customers. A system in which a customer can make his/her account and track their parcels. This system would further check the parcel details when the names and consignment id are added to it when...system in which a customer can make his/her account and track their parcels. This system would further check the parcel details when the names and consignment id are added to it when someone picks their parcel up from the designated area. The Parcel Management System would : 1. Create new customer logins (manage sign ups and logins) 2. Track the package 3. Update these input queries in the SQL server. (database) 4. Verify ownership of ...

Project Overview With great experience come great projects. Just imagine: you can develop a product that should completely change the business of one of the world's largest companies! Our client is an innovative global company from the Fortune 500. Consumer Goods Producer and Retailer with headquarter...verbal communication skills; -Excellent English. Nice to have: -Experience with data modeling/warehousing techniques and data integration; -Experience working with the latest tools & techniques in the field of data. Advantage if it is data warehousing project, data platforms or marketing automation; -Hands-on experience with Microsoft Azure Data & Analytics Services such as Data Lake, CosmosDB, SQL APIs and DevOps (building CI/CD pipelines (GitLab) and complete knowle...

...an iOS app and finally create a similar Android version to handle some logistic activities from load dispatch to delivery by Truck Driver. We have an existing mobile web application being used and tightly coupled with ASP.NET, SQL Server based application to share database and information. Project should be completed with source code delivered with documentation, and launch on the app store features including 1. User Authentication while login/ OTP 2. Scan Docs and update to database & send to email via SMTP loads assigned to driver - already stored in SQL Databases e.g. Check the current load assigned to the driver 3. Delivery Directions on Google Map 4. Send/ Receive messages from desktop application 5. Driver can mark On, Off, Checkin, Checkout, Driving Mode, ...

My WordPress site stopped responding, it says "redirected you too many times". I tried to disable plugins and themes in File Manager, but it didn't help. I think the issue is with SQL database. Need someone to check it

Need to know fully about erd and related topica

I have projects on Wordpress plugins and theme development. Candidate must have knowledge on Wordpress Plugin development which includes hooks, add_actions, add_filter, add_shortcode . In js need to have knowledge to slide images, hide & show, must use AJAX in jquery and most important PHP and SQL queries. Those who want to work with me place bid on this project If any freshers are here also welcome. I will give enough project so you don't have to bid on other projects.

We have a running API based website. There are some SQL database related errors that need to be resolved.

...years of experience in Magento 2 backend development -Deep knowledge of Magento 2 architecture - DI, plugins, preferences, repositories, layouts, cache, API, etc. -Understanding of the latest coding standards: Magento coding standard, PSR-1,2,12, etc. -Good knowledge of web technology, ability to write object-oriented code on PHP7+, proper usage of type hinting and strict mode -Good knowledge of SQL, including things like indexes, foreign keys, transactions -Knowledge and understanding of basic web dev tools: CSS, HTML 4/5,JavaScript -Experience using JavaScript frameworks/libraries: KnockoutJS, jQuery, RequireJS -Basic knowledge of server environment setup (Apache/Nginx, PHP-FPM, MySQL, Redis, Elasticsearch, etc.) -Ability to pass a technical interview in English and communicat...

I am looking for someone familiar to Microsoft Server to help me with a simple project evolving databases creation and configure a snapshot replication.

...to in the POST REST API must be saved to MySQL Database 4. The NodeJS should query and retrieve all these Client Enquiries data from the MySQL database 5. The GET REST API should return the list of Client Enquiries in JSON Format to the FrontEnd. 6. The above must work when tested in any REST clients such as Postman or Advanced Rest Client and any database clients such as MySQL WorkBench or SQL Pro. Please refer to the attachment to understand the context, Note: we already have the UX/UI developed. Please demo the project end to end and push the code to Github after completion. OUT OF SCOPE: UI/UX work is out of scope for this project, since its already developed. Thank you and Happy Coding :-) ...

Flutter web app to allow uploading and browsing photos, and corresponding api (Golang) to store photos on server, and integrate with existing Sql server database. See attached text file for full specifications.

Hello there, I have done a mock-up of a booking reservations system in Visual Studio. I wrote a small bit of C# to get some things behaving like I want them to, otherwise it's just a shell of a program. Additionally, there is a splash screen, lock screen, switchboard, and about half a dozen other functions (for things ... etc. I would prefer to design the visual layouts of the reports and forms myself, so all I need is for the data to be linked to appropriate tables and presented on the right pages so I can design them to my liking. Even though I've selected pay-by-the-hour, I can also accommodate fixed amounts for those freelancers who prefer to work that way. If you are confident and proficient in C#, SQL, and database design, then I would really look forward ...

The person I am looking for is someone with minimal 7 years of Oracle experience that can work remotely as Oracle pl/sql and Apex developer for my clients in the Netherlands. Daily work consist of bug fixing, Query writing for data migration project, Apex development, Rest calls development. Oracle version is currently 11 but we will be upgrading to 12 and then to 18 or higher. It is important that the candidate has good English skills spoken and in writing as there will be communication with the client. This project is for about 6 months but can be extended for longer. The project for now is on a hour contract basis for about 32 houres a week.

Looking for a back end developer for a new start up, full time position. Will give more details Tech Stack required: LAMP Python || Java SQL Experience in creating REST API´s Docker || Kubernetes Good English communication skills , Problem solver , Dedication

Looking for a backend Dev with excellent .Net & SQL Minimum 7years of experience Should be available from 730PM to 1AM(IST)

Here at our university lab we need to update a No-Sql database using Excel files that are "provided" by the No-Sql engine. So..., we download an excel file from the server, but we can't modify it using formulas, macros or adds-on. We can only modify some data, and we can only do it from an starting particular row until EOF() Many settings and established conditions will be established at an external settings file, type txt. 1) One process, named "UPDATE", will... Typical file pick-up with "Select" button. Considering general settings that will tell the app "how" to match any excel row, with the CSV file, some changes are going to be made at the matching rows. Here some conditions will be evaluated prior to apply changes. The...

Opportunity for Laravel Developers. Opportunity to work on our projects (software) on a fixed-price basis. Please send your expected salary as above. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Send your Industry experience in Application developments, type of applications developed, etc for us to select the best offer. Also, mention your working hours per day, (Including the time band), and the number of days per week/month. Recruitment is for a long-term big project as such, all the developers are subject to practical skill task tests. Good prospect for the right developers, based on the performances evaluated over a period of time

I need some help with some Database queries. I will provide you with the data and scenario and you just need to create SQL query. I will be using Postgresql, so I hope you have an understanding of SQL

About the role: As a Web Technology Specialist your core responsibility is to deliver exceptional customer experience via multiple channels of communication. You will be the first point of contact for our clients and it requires you to provide a professional level of support and...using IMAP/POP/SMTP. ● Troubleshooting server-side scripts. (Good to have) Technologies involved (prior knowledge of these would be a plus): ● Domain name system (DNS) ● Domain names and domain name registration ● Web Hosting ● cPanel/Plesk ● PHP,Perl,ASP, dotNET, Perl and FastCGI ● Wordpress, Drupal, Joomla, Magento, other web-based applications ● Basic knowledge of Relational databases (MySql. MS Sql) ● Email Solutions ● POP/IMAP/SMTP ● Digital Certificates ● Cloud, VPS & Dedicated Servers

The project consists of developing with python the necessary code to read data from a database and send this data to an external system. The external system receives the data through a Restfull API, a post method must be created to send the data according to the Restfull API requirements. Restfull API specifications are attached.

1. Required strong real time experience in Xamarin, C#.Net , Web API and SQL Server. 2. Design, develop, test and maintain mobile applications using Xamarin / C# for both iOS and Android. 3. Help us implement manual & automated testing into our development process. Experience with the Perfecto test suite a plus. 4. Responsible for developing and maintaining the cross platform Mobile Applications using net technologies using Xamarin. 5. Extensive database work writing complex stored procedures and reports. 6. Rich experience in Xamarin Form based UI development using XAML . 7. Good Understanding of Azure Mobile Platform NET development environment as well as implement new cloud based mobile testing tools.

This url /catalogsearch/result/?q= on page 4/5/6/7 keeps running out of memory. I have increased but the higher the page number the more memory it used, there must be a sql in Magento 2 which is bad written? a bug with MAgento 2?

Write a SQL Stored Procedure to write random values to the Bonus field of the AdventureWorks table. I have SQL Server 2022 Developer Edition. I'd like it to run every 5 seconds and write a new Bonus value to all 17 records in the table. I'd like this Stored Procedure to be written in the most simple way. I have TeamViewer to share my screen.

We need someone to Install pterodactyl panel and configure it to support Install, optimise and secure SQL Import and test eggs for discord bot hosting (JS,Java,Python,Golang) I know prices of this on Fivver so no stupid quotes For the Freelancer team who have no clue what the project is about and removed the last post before asking a question The BOT hosting is not for the creation of bots, but allowing the hosting of moderation or ticket bots on their own private discord servers, not damaging a company's reputation, spam or anything blackhat The bots actually prevent spam, these are created by the customer to protect their own discord servers or perform actions on their own websites such as discord API sign in Next time ask a question before being trigger happy to remo...

Minimum 7 - 10 years of experience. (Can be higher also) C#, MVC, Web/REST API, WCF, WPF, Windows component development and PowerShell scripting. Experience in Azure could storage, Azure Service Fabrics, Azure Cosmos DB MS SQL, Entity Framework, Good to have Razor view, TypeScript, Angular / Reach JS. Contract 3 months max

Hi There, we have got the frontend in MS Access for database filtering, however, since the database size is around 900 GB, we are looking to integrate it with SQL. Overall what we are looking for is that the database filtration time should be effective when we integrate Access with SQL. Currently we do not have SQL software.

Please Sign Up or Login to see details.

To develop the C#, Blazor code needed to populate 33 tables with data (some are simple lookup tables) from 20 Pages (Mockup designed and provided) using Visual Studio, Syncfusion and Blazor on a SQL Server Database (designed, deployed and provided). Responsive Design: The pages are expected to be responsive but only optimised for 1080p desktop at this stage. CSS: Default SyncFusion Fluent theme is fine but a new follow-on project will include styling the site to meet a primary parent WordPress site look and feel later. Login: The VS Solution has the default “Individual Credentials” classes which will be fine for this project. A new follow-on project later will look at SSO by passing the WordPress user credentials over to this site (sub-domain site). Reports: The 20 page...

SQL to Wialon API improvements.

Need developer help who knows Java, Hibernate, Adobe Experience Manager, SQL

I made a bokeh app that generates graphs from a SQL Server database. I need someone who can replicate and improve it for Dash Plotly in python. Please post if you have good experience with plotly and making good layouts, designs. I need this done in a day, maximum two. The graphs on my app are not static, they keep updating themselves. Write "PLOTLY" on your bid so I know you read it.

Api upoad to ok.ru. @Requirement. Remote Upload to via php, save uploaded video url to sql database with name of file. Their official api - Eg: # Upload - this should upload file from that url to and save the generated link to mysqldb with filename. :// # Get - this should get the url of the video file from mysql db. get url of that = Budget - 200$ Negotiable