Sql projects jobs
I am looking for an experienced Power BI consultant who is well-versed with the ETL process, Synapse, Fabric, DWH, and more. - Data source: As a part of the project, you will be needed to work on the local SQL database, which acts as my current data source. Familiarity with SQL databases is a must. - Data extraction and transformation: The project requires the extraction and transformation of data In conclusion, candidates with a strong understanding of SQL databases, data extraction/ transformation processes, azure, microsoft service awill be the best fit for this role.
Add ...(Add / Update / Remove) - Projects List: Add Button to create Dummy Project - Projects List: On Select Row or click "View Button", loads all listings connected to this project - Projects List: On "Delete Button", it will delete the project, all the listings and folders connected to it. - Listing List: Change "Create Button" to create dummy data for listing - Listing List: Select Row or click "View Button" loads all the folders connected to the listing - Listing List: On click "Delete Button", deletes this listing and all folders connected to it. - Folders List: Add create button to open "Screen_2" - Screen_2: On close it will save the real data of all fields - Folders Lsiting: On click "Delete But...
Python Development - Building a Web Application with Django Skills and Experience Required: - Expertise in Django framework - Strong proficiency in Python programming - Experience working with existing Python code - Familiarity with web application development and best practices - Knowledge of front-end technologies such as HTML, CSS, and JavaScript - Understanding of database systems and SQL - Ability to collaborate with a team and communicate effectively Project Scope: - The goal of this project is to build a web application using Django framework. - The project involves working with existing Python code to enhance and add new features to the application. - The ideal candidate should have experience in developing scalable and secure web applications. - Knowledge of front-end dev...
I am looking for someone to create a POC for a chatbot with Microsoft Bot Framework and C# Main objective. 1. It should connect to a SQL server database and get the order details if the customer asks "Get my order detail" and give the order number 2. Login the customer and identity the correct order, Don't pull anyone else order if not belongs to the customer The POC may extend to an actual project
...specifically ASP.net Core, ASP.net MVC, and ASP.net WebForms. An anticipated task will be functioning on existing projects that are built on these technologies, hence having prior hands-on experience would be highly valuable. Regarding the database, you'll need to be skilled in the use of SQL Server since the projects involve maintaining databases that are based on this platform. On the functionality front, the critical aspect is development. Therefore, you will play a prominent role in strategizing, building and maintaining the overall structure of the projects. Skills and Experience Required: - Practical experience in ASP.net Core, ASP.net MVC, and ASP.net WebForms - Profound knowledge in SQL Server database management - Demonstrated expe...
We are looking for assistance completing a query comparing in stock and on order raw material and match to it's production demand. SQL 2019
...real estate commercial projects. The ideal candidate should have experience in lead generation within the real estate industry. Target Demographic: - The leads should be targeted towards both businesses and individual investors. Geographic Region: - The leads should be from the local area. Skills and Experience: - Proven track record in lead generation within the real estate industry - Familiarity with local market trends and demographics - Excellent communication and negotiation skills - Ability to identify and qualify potential leads - Knowledge of effective lead generation strategies and tools - Strong attention to detail and ability to meet deadlines If you have the expertise and experience in generating high-quality leads for real estate commercial projects, I ...
I'm looking for a freelancer with extensive Node.JS experience to convert a Java-based des...experience to convert a Java-based desktop application into a web app. Key functionalities of the current app include data entry and storage, file management, and reporting/analytics. - Features to Maintain: The web app must retain database integration functionality, besides that the freelancer will also be required for code review and modification. - Database: Our current desktop application uses SQL Lite. The freelancer must have experience working with this database for a seamless transition. This project requires thorough knowledge of Java and Node.JS, database management, and file handling in a web app environment. Additionally, proficiency in executing code review and refactor...
Web development: The system should be web-based (ASP.Net) with SQL database, allowing users to access and interact with it through a web browser with responsive design. The application should be working perfectly in mobiles (both small and big screens), tablets, all sizes laptops and TVs from 32 inch to 84 inch screens. - Photo uploads: Users should be able to upload photos to the system, which will be displayed alongside their family information. Uploading is available for all but will not be effected until final approval - Relationship mapping: The system should have the capability to map and display relationships between family members. - Advance search options using all fields. - Send messages / WhatsApp / emails - Member card : when clicking on member image on the tree, a car...
I'm in need of a C program that will diligently navigate through a folder and a...software should be capable to run its search and extract function exclusively on text files formats ( .txt , .sql,.xml ... ) . No need for other formats like Word, PDF etc. - Case Sensitivity: The application must consider "No" case sensitivity while executing text searches. For instance, "Hello" and "hello" should be treated as same. - Output: I am interested in seeing the exact instances of the found text & summary. The output needs to directly display the exact instances where the search text is found. Ideal freelancers for this role should have solid experience in C programming, particularly File I/O operations, recursive functions and text parsing. Exposure ...
The application is developed using Visual Studio with Blazor (C#) and utilizes a SQL Server database. The server infrastructure is already set up on AWS. Now, I am looking for an experienced professional to host my application on the AWS server and take care of all the necessary configurations. This includes setting up IIS, publishing the application, configuring the domain with SSL, and handling other related tasks.
I am looking for an expert with Power BI who is adept at connecting to SQL server databases. The requirement is to clearly compile the user data from these servers into a simple, singular table that reflects an view of all identified sources. What the job entails: - Connect to multiple SQL Server databases - Aggregate the users data into one simple table, it should entail server name, database name, user, role, and user type. Skills and Experience: - Comprehensive experience with SQL Server databases - Proficient in the use of Power BI - Familiarity in compiling data into user-friendly tables - Strong data aggregation skills - Attention to detail, particularly with columns and user information.
...copilot, users of our application should have the ability to ask general questions (e.g., when was the first moon landing), which will ultimately be answered by chatGPT. On the other hand, application-specific questions that require access to our MSSQL database should also be answered. The database has over a million entries. Therefore, the copilot should be able to convert textual questions into SQL queries, send the query, and present the answer from the database in textual form for the user. An example question for this would be: What is the dataset with the biggest total amount? As a third requirement for the Copilot, it should also be able to answer questions by extracting information from provided text documents. The copilot should be able to understand inputs in German l...
As part of my team, I'm looking to onboard a proficient competitive programmer with expertise in C++ and Java. The selected individual will participate actively in bi-weekly coding rounds, solving problems across a diverse range of topics: - Data Structures and Algorithms - Database related and SQL query problems - Graph theory problems Ideal candidates should have demonstrated experience in these subjects, and a proven track record in coding competitions would be beneficial. Strong command over C++ and Java is mandatory for this role. It's supremely important to have solid problem-solving skills and the ability to work under time constraints. If you can thrive in a competition scenario, I'm eager to bring you on board.
I've uploaded some basic data. It has 2 columns. Column 1 is a Publication Index and column 2 is an authors name. I need a T-SQL query that will create a pivot table that will put the authors names into columns and the PMID's into rows. The xls sheet has the data and the output that I need. I'm posting the question here because I need a faster answer than posting on StackOverFlow. The data will have over 8,000 rows of data and the columns or names will be over 100. My current T-SQL is SELECT TOP (100) PERCENT PMID, AuthoringName FROM dbo.[] GROUP BY PMID, AuthoringName ORDER BY PMID, AuthoringName I'm using MS SQL 2019
esp32 tasks: 1. create remote updates - by server + bluetooth. 2. lcd show pictures and text from server (5 screens of app) 3. esp work with extrnal memory
...szerkesztésével lehet további egyéni lekérdezésekkel bővíteni a válsztható sablonokat. Ezen lekérdezések megírásához keresünk SQL-ben jártas szakértőt, aki segítene közösen elkészíteni további sablonokat, pl. Teams-es konzultáció keretein belül. Magyar nyelvű kommunikációt preferálunk az egyszerűség és a félreértések elkerülése kedvéért. "You can also modify or add new queries to Data Chart Dashboard components by creating the appropriate SQL Server Script. This can give you more flexibility to control the data th...
Project Description: I am looking for a freelancer who can help me copy my SQL Database using the Azure SDK. The ideal candidate should have experience with Azure and be proficient in using the Azure SDK. Requirements: - Copy SQL Database using Azure SDK - No data migration across different Azure subscriptions required Skills and Experience: - Proficient in using Azure SDK - Experience with SQL Database - Familiarity with Azure - Proficient in TDD must write test code along with it
I am looking for a UI/UX designer to assist me with a Mobile App Design project. I have a specific design style in mind, which is minimalist. Additionally, I have specific features that I would like to include in the mobile app design. Skills and experience required: - UI/UX design experience - Proficiency in mobile app design - Strong understanding of minimalist design principles - Ability to incorporate specific features into the design
I am looking for a skilled freelancer who can help me replicate data from our CRM system in Dataverse to Azure SQL in near real time. Here are the specific requirements for the project: Source of the Data: - The data in our Dataverse comes from our CRM system. Data Replication Method: - We prefer to use transactional replication for the data replication process. Data Update Frequency: - We need the data to be updated in Azure SQL in real-time. Required Skills and Experience: - Strong experience with CRM systems and data replication processes. - Proficiency in setting up and configuring transactional replication. - Knowledge of Azure SQL and the ability to seamlessly integrate it with Dataverse. - Experience in working with real-time data updates and ensuring data i...
...Studio 2019) OF THE SCREEN DESIGN. The project consists of programming a desktop screen in C# and WPF code from Visual Studio 2019 .NET 6 framework for Windows 10/11 and tables in SQL design fully compatible with SQL Server management studio v 18.7.1. The WPF screen need some minor changes of titles, buttons and position of text boxes. I am going to deliver instructions, changes on design and general details in PowerPoint. Also, images of the SQL tables with their columns fields and descriptions will be sent in the PowerPoint. The deliverable must include the following: 1.- C# and WPF source code 2.- The SQL tables used in the program have to be generated automatically when running the executable for the first time. We need to test source codes working 1...
The following is a list of code written in DAX and needs to be converted into Power Query. The problem: we are trying to use DataMart and build report in powerBi service. To create calculated column, we can only use PowerQury or SQL in the DataMart transformation section. The following code was written in PowerBI desktop using DAX. I need someone who knows very well PowerQuery (M), who can quickly convert the following code from DAX to PowerQuey and be able to copy and paste in PowerBI Service DataMart transformation section my using custom column in Query section of the DataMart. To get paid, the code must work without any problem. Anything between ‘ ’ is the table name, and anything between is the field name. If you are an expert in PowerQuery and you have c...
I am looking for a skilled professional to help us with our database backup project. Our sql database is hosted on a physical server in our office, and we need to make backups on specific dates: 1/19, 3/1, and 5/31. Key requirements and ideal skills for this project include: Database Size: - The database is medium-sized, ranging from 1-10 GB. Preferred Backup Method: - We would like to use an external hard drive for the backup. Server Access: - We have physical access to the server. If you have experience with database backups, specifically with medium-sized databases and using external hard drives, we would love to hear from you. Please provide examples of similar projects you have worked on in the past.
We have a working ex...different server. Requires knowledge of Azure SQL, Azure Permissions and PowerShell. All that should be required is to adjust the permissions so it works between instances and change the script for us for the new server. Ongoing part time contract work available for assistance in maintaining our Azure virtual private cloud if this first quick task is completed successfully and you have the additional skills required. Key responsibilities include adjusting permissions within Azure to facilitate seamless communication between instances and modifying the existing PowerShell script to ensure efficient replication on the new server. The successful candidate will be adept at navigating Azure environments, possessing a deep understanding of Azure SQL and Powe...
I'm in need of an experienced GLPI developer who can create a plugin specifically targeted at improving workflow automation. Important features for the plugin: - Automated ticket creation: this should be efficient and without lapses. - Task assignment: the plugin should be capable of assigning tasks automatically. - Status updates: regular...plugin should be capable of assigning tasks automatically. - Status updates: regular and automatic updates on the status of tickets and tasks. The ideal freelancer should have solid experience creating plugins for GLPI, a strong understanding of workflow automation, and the ability to translate these requirements into practical solutions. Proficiency in PHP, SQL, and JavaScript is highly desired. Demonstrated experience with similar p...
I am looking for an experienced ansible developer who can support Windows, Linux, and ESXi hosts. The project involves implementing ansible for these operating systems, but the complexity of the implementation is not yet determined. The timeline for the project is more than 1 month. Ideal skills and experience: - Strong knowledge and experience with ansible,oracle,sql - Proficiency in working with Windows, Linux, and ESXi hosts - Ability to handle both simple and complex implementations - Excellent problem-solving skills - Good communication and collaboration skills If you have the expertise and experience in ansible development for Windows, Linux, and ESXi hosts, and can handle a project with an undetermined complexity within a timeline of more than 1 month, please reach out to d...
I am looking for an experienced freelancer to resolve a 500 error on my aws Plesk server. The error is caused by a SQL connection issue, resulting in too many connections. Project Details: - This project is for an existing business. - The resolution of this issue is of immediate urgency, and I need it resolved within 24 hours. - My budget for this project is $10. Skills and Experience: - Proficient in AWS and Plesk server management. - Strong knowledge of SQL and troubleshooting SQL connection issues. - Ability to quickly identify and resolve server errors. - Excellent communication skills to ensure timely updates and resolution. If you have the necessary skills and experience, please provide your proposal for resolving this issue. Thank you.
Project Description: I am looking for a ...secounds only. *The model is done for both projects I will provide once the artist selected. Each project must have the below and must be different than another project Sound effects. Ojbects. (Mug) Materials. Colors. Animation. Camera Angles Animation details: Project 1 : Scene1- Opening the drawers Scene2- Moving chairs and playing chess Scene3- Open the Door Scene4- Add simple animation from you choice Project 2 : Scene1- Playing chess Scene2- Pour Drink (Must to add cup object) Scene3- Open the Window Scene4- Add simple animation from you choice Skills and Experience: - Proficiency in Cinema 4D The final project file must be provided as c4d file for each project. My deadline is 20/01/2024 and the Budget is 60$ for bot...
We want to use an own GPT-model for first level support. What we provide: - virtual server (you tell us about the requirements) - SQL-database with >10.000 support tickets (customer email and our answer) for additional training - FAQ for additional training What you should do: - install a GPT, e.g. LLaMA on our server - provide a script with which we can feed the GPT with our given databases to fine-tune it - provide an API with which we can connect to the GPT and chat What the result should be: - We receive an email from a customer - We send it to the GPT and ask for pre-qualification the department (is it spam, support request, billing issue, ...) - if it is a support case, GPT should provide an answer and/or a matching FAQ-article (based on the knowledge we provided for fi...
I am looking for an experienced SEO guy for a long-term collaboration on different projects. Specific SEO services needed: - On-page optimization Current SEO situation: - No prior SEO work done Target market or audience: - International ( European ) Ideal skills and experience: - Proven experience in on-page optimization - Knowledge of international SEO strategies - Ability to conduct keyword research and analysis for international markets - Familiarity with optimizing websites for international audiences - Understanding of the unique challenges and opportunities in targeting an international market
I need to develop pdf scrapping in django which cN connect to sql database for website
We are looking for SKILLED FREELANCE NETWORK ENGINEERS to fix routers/replacing/deployment projects onsite near you. We have small to large projects in all countries. Requirements: - Cisco certification - Level 1 - Rack and Stack (R&S) projects - Mostly projects are to physically install and configure the router at your nearby site. - The ideal candidate should have expertise in Cisco networking, specifically in Rack and Stack procedures. If you have the required skills and are interested to work with us, kindly message us.
...refresh materialized views? Data Integration: How does Incorta integrate with different data sources? Have you worked on connecting Incorta with non-relational data sources? SQL and Query Optimization: How comfortable are you with writing SQL queries in Incorta? What strategies would you use to optimize a slow-performing Incorta query? Security and Governance: How does Incorta handle data security and governance? Can you explain the role of access controls in Incorta? Real-Time Analytics: How does Incorta support real-time analytics, and why is it important for certain business scenarios? Have you worked on projects that required real-time data analysis in Incorta? Dashboard Creation: Can you walk me through the process of creating a dashboard in Incorta? What ...
Angular Developer with .Net Core and SQL Experience Needed I need monthly hiring on a daily 8-hour basis. Project Overview: - I am seeking an experienced Angular developer with knowledge in .Net and SQL to assist in the development of my application. - The specific functionalities required for the application include user registration and login, data visualization and reporting, as well as e-commerce functionality. - The application should have a modern and sleek look and feel, with clean and minimalist design elements. - The project timeline is flexible, as it depends on the complexity of the requirements and the availability of the developer.
...scalable, and efficient PHP code for our various projects. Key Responsibilities: Develop and maintain advanced PHP-based web applications. Write clean, maintainable, and efficient code. Collaborate with front-end developers to integrate user-facing elements. Solve complex performance problems and architectural challenges. Implement security and data protection measures. Participate in the entire application lifecycle, focusing on coding and debugging. Contribute to all phases of the development lifecycle. Requirements: Minimum of 5 years of experience in PHP development. In-depth knowledge of object-oriented PHP. Understanding of MVC design patterns. Knowledge of front-end technologies including CSS3, JavaScript, and HTML5. Experience with SQL/NoSQL databases and their d...
I am in need of assistance with exporting a MySQL database from SQL Server in a Windows environment. I am looking for a skilled freelancer who has experience with database management and SQL Server. Skills and experience required for this project: - Proficiency in SQL Server and MySQL - Knowledge of database export and import processes - Familiarity with Windows operating system - Experience with SQL Dump file format Project requirements: - Export the entire MySQL database from SQL Server - Ensure all tables and data are included in the export - Use the SQL Dump file format for the exported database Please note that I do not have any specific tables or data that need to be included in the export. The freelancer will be responsible for exportin...
PeopleCode Development / SQL Project Tasks: - Assistance with PeopleCode development and SQL queries - Intermediate level complexity Skills and Experience: - Strong knowledge and experience in PeopleCode development - Proficiency in writing SQL queries - Ability to handle intermediate level tasks efficiently I want to create some loops and conditions to iterate through tables and queries. Deadline: - The tasks need to be completed within 1 day.
I am in immediate need of a proficient API specialist well versed in UKG Pro API for an upcoming project. I need to extract data to an MS SQL database from a customer's UKG Pro system and need some expertise in this area. The specific functionality details are not ironed out, allowing for flexibility in the role - however, the project's main use of UKG Pro API may involve activities such as retrieving employee data, managing time-off requests or generating payroll reports. Ideal Skills: - Exceptional understanding of UKG Pro API - Relevant experience in managing API integrations Availability: I aim to have the project completed within a month, so freelancers who can dedicate significant time over the coming weeks would be ideal. This project is a fantastic opportun...
I have an ASP.NET MVC application that I built 6 years ago and I would like to continue building it but I somehow forgot how ASP.NET and SQL Server things work exactly so I need some help. I have the following: -The full folder of the project that I built 6 years ago with all the source files -The MDF and Log files of the DB I need the following: -Attach the DB -Setup a website in IIS and link it with the web application -Test one page in the application to make sure it is working
I'm in need of a developer with intermediate level expertise in DAX development for Power BI. Your tasks would involve: - Creating complex DAX formulas - Optimizing existing DAX formulas It's necessary that you know how to connect to SQL databases in Power BI, as this will be our primary data source. Ideal candidates would already be accustomed to these tasks and would have sufficient experience in similar projects. Let's optimize and enhance our reporting with your DAX skillset!
I am looking for a bidder who can help me find leads for projects on a freelancing platform. My main goal is to increase my client base and I am specifically interested in web development and Blockchain projects. I am looking to obtain more than 10 leads. Ideal skills and experience for this job include: - Experience in bidding on freelancing platforms - Knowledge of web development projects and the ability to identify potential leads in this field - Strong communication and negotiation skills to secure projects - Ability to research and find potential clients who are in need of web development services - We can pay per lead or a fixed salary as well - You must mention the answer of eight multiply by two and minus four on top of your proposal to be considered...
My Microsoft SQL Server has been giving me syntax errors when I try to execute certain queries. I'm unclear on what exactly the issue might be, but I'm in desperate need of assistance. Hence, I'm looking for someone experienced with SQL and particularly with Microsoft SQL Server. Please note, this assistance is quite urgent: - You should be proficient in Microsoft SQL Server syntax. - You should be able to identify and rectify syntax errors quickly. - If possible, I also wish to understand the cause of these errors to prevent them in the future. - The project needs to be completed as soon as possible.
I am looking for a freelancer who can help me implement a RASA chatbot with Python Flask and ReactJS. The chatbot will be used to assist users in selecting projects taken up by students. Additionally, I also need a community page where users can discuss projects. Main Purpose of the Chatbot: - Assisting with project selection Chatbot Interface Design: - No specific design in mind, but I can provide some guidelines Number of Pages for the Community Page: - 1-3 pages Ideal Skills and Experience: - Proficiency in RASA chatbot development - Strong knowledge of Python Flask and ReactJS - Experience in designing intuitive user interfaces - Ability to create a community page for discussions - Good communication and collaboration skills
I am looking for a .Net Developer who has experience in EMV Card Processing with Fiserv. Please do not apply if you do not have experience in this arena Skills and Experience: - Strong proficiency in Node.js and SQL Server - .Net Winform - Card Processing The objective is to be able to process payments via Card Present Transactions (EMV) or swipe. Also be able to create a void to cancel a transaction and To Batch Close. The project needs to be completed within 1 week, so the ideal candidate should be able to work efficiently and meet deadlines.
...Technical Overview: 1. Platform Language: Python or similar language, a powerful programming language, ensuring rapid development, long-term maintenance, and a robust foundation for the service. 2. Mobile Platform Language: Flutter, a versatile programming language that allows for the development and distribution of apps to both iOS and Android using the same code base. 3. Database Management: Utilizing SQL database to ensure structured data management, reliability, and strong data integrity, which are crucial for handling sensitive healthcare information. 4. System Architecture: • Cloud-based infrastructure for scalability and reliability. • RESTful API for seamless interaction between the web and mobile applications, ensuring a cohesive user experience. 5. Security &a...
...application currently have local database for 2 modules (1) hotels inventory module, (2) agents and subagents module and live API connection with a third party provider). Full stack developer scope of work and future requirement (hourly cost or fixed cost per job) - Maintains current codes, regular checks and fixes of any future bugs - Optimize server/hosting capacity (currently using digital ocean) MY SQL - Support future clients with API connection to the current application - Integrate new modules (transfer module, cruise module, flight module etc..) - Develop API connection with channel managers or third party providers - Update website with up to date features - Access to database will be given and handover will be organized before hand If you have similar work experien...
I am looking for a skilled developer to create a Help Desk Ticketing System using Angular and MVC, with an MS SQL database. The system should be able to handle less than 100 users and needs to be completed within 1 day. Skills and experience required for this project include: - Strong proficiency in Angular and MVC frameworks - Experience in creating ticketing systems or similar applications - Knowledge of MS SQL database management and integration - Ability to work quickly and efficiently to meet the tight deadline
