Upper sql jobs
...and experience required: - Expertise in Ruby on Rails, specifically Rails 6 and 7 - Experience maintaining and upgrading RESTful APIs and API integrations - Proficiency in RSpec for testing - Strong SQL skills for database maintenance Responsibilities: - Perform regular maintenance and updates on the Ruby on Rails project as needed - Address any bugs or issues that arise - Upgrade and improve existing features and functionalities Ideal candidate: - Has experience working with Rails 6 and 7 - Familiarity with RESTful APIs and API integrations - Proficient in RSpec for testing - Strong SQL skills for database maintenance - Detail-oriented and able to troubleshoot and debug effectively This is an ongoing project with maintenance and updates required on an as-needed b...
...new pending limit order anymore until I manually place it. The opposite direction (existing pending limit order if any is placed by me) must still remain there so it should NOT be auto deleted. All other trading symbols (both directions) remain untouched. The X value is the same for every symbol and every trend position direction. Extra feature2: If entire (including shadows/tails if any: both upper if any and lower if any) SIZE (or height - however you define it) of the candle exceeds Y value (I define this in settings of requested tool) then any/each pending limit order for this exact trading symbol (other symbols remain untouched) gets immediately deleted so it will NOT be opened. Disrespecting (ignoring) extra feature1 (X value). Then it's up to me when I manually want ...
As someone seeking assistance with my Oracle SQL project, my need is precise and task-oriented. I'm grappling with some update operations on tables and would benefit from expert guidance. - Task: The primary help that I need is updating a table. It's not just about changing existing data, but the process is conditional. The condition is slightly more complex than just concerning one column value. It revolves around multiple column values. - Expertise: A suitable candidate would ideally have experience in managing data migration, query optimization, and database design. The task involves sophisticated data handling, so someone with substantial Oracle SQL experience will be an asset. Proficiency in understanding and writing conditional SQL queries is essen...
I'm looking for an experienced Azure Data Engineer who can assist in continuously syncing data from an On-premises SQL Server to Azure SQL Database. The specifics of the data that need to be synced are Tables, Stored Procedures, and Views. Ideally, the freelancer should possess the following: - Proficient in Azure SQL VM operations. - Experience with data migration from on-premises SQL Server to Azure SQL Database. - Understanding of syncing Tables, Stored Procedures, and Views. - Capable of setting up an hourly sync schedule. The end goal is to keep the Azure SQL Database updated hourly to reflect the changes made in the on-premises SQL Server. Ensure seamless, error-free data transfer and verify the integrity of synced data regula...
Project Title: Snowflake, DBT, Dataiku project Support - Urgent I am in need of a data engineer freelancer who can provide urgent support for the project. The ideal candidate should have ex...source and target as snowflake warehouse. - Integration of Dataiku with existing systems and databases. - Experience with data ingestion. - create jobs in octopus, tidal Skills and Experience: - Proven experience in implementing Snowflake, DBT and Dataiku - Strong knowledge of Dataiku features and functionalities - Familiarity with data integration and data management best practices - Proficiency in SQL, Python, and other relevant programming languages - Excellent problem-solving skills and ability to troubleshoot issues Timeline: - This project requires urgent support and requires few month...
...discussed. Features: - Live Bidding functionality is the most important feature that needs to be included on the website. Ideal Skills and Experience: - Experience in working with APIs, specifically the Copart and Iaai APIs, is required. - Strong web development skills and the ability to create a user-friendly and intuitive interface. - Knowledge of user registration/login functionality using SQL or local MongoDB and search/filter options. -User to submit ID for verification. - User most make a minimum Deposit of $400 to get bidding power of $4000 or more to enabling placing bet either proxy bet or live auctions -User place bet on our site and it goes directly to Copart or Iaai through our premium account. -User can see the final price calculator to see services fees a...
Looking for new postcard design for 4 inch x 6 inch print postcards. 1) I want a large magnifying glass with my logo in the center on white background in center of glass area of magnifying glass. (My logo is attached) 2) background color of postacrd design will be #FF6700 neon Orange 3) Additional text for postcard: Get more exposure ...background color of postacrd design will be #FF6700 neon Orange 3) Additional text for postcard: Get more exposure from Dispatchers, Trucker's & RVer's Got to: mywebsitename/getlisted or call 1-877-555-5555 4) IN Small print Along bottom of card design: online since 2003 - Helping Truckers and Repair service providers for more than 21 years! 5) rear of card will have logo in upper left corner with address below it (to be provided lat...
Project Title: Fact pack on themes relative to employee experience I am looking for a freelancer to create a comprehensive fact pack on employee engagement for upper management. The fact pack should include detailed information and data analysis on this theme. Specific Requirements: - The fact pack should focus on employee engagement and its impact on overall employee experience. - The freelancer should provide a comprehensive analysis of employee engagement, including case studies and data analysis. - The fact pack should be tailored for upper management, providing them with valuable insights and recommendations. - The freelancer should be able to present the information in a concise and visually appealing manner. Ideal Skills and Experience: - Strong research and analyti...
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 Logic to C# Wpf Software. - Controllers : Add Json Support (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 "Creat...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 Button" removes folders ...
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
...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 experience in end-to-end project development and management. To conclude, if you are well-equipped with these ski...
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
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 all its subfolders to identify and extract given search text from files. The core specifics of the project are as follows: - File Type: The 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 t...
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...
i reaserch a trader account wich can be upper my count of 1k to 10k i offer a %
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
...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 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 a...without lapses. - Task assignment: the 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 proj...
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.
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...
Qoblex is an e-commerce operations management software derived from the Norwegian word "Koble," meaning "connect," which shows our goal to link backend systems smoothly. We want this incorporated in our logo. - Design for Qoblex or qoblex font case, not all upper case. - Color preference is black (#1A202C) and purple (#8600A7). No gradient color. - Flat design, modern, and minimalistic. - You can get creative with the "Q" of Qoblex, which would also serve as our icon. Or spell out Qoblex on a normal font, with an accompanying logo. - Final output in original editable file (i.e. AI). We look forward to your designs!
I need to develop pdf scrapping in django which cN connect to sql database for website
...Incorta? What are schema objects in Incorta, and how are they used in data modeling? Materialized Views: What are materialized views in Incorta, and why are they important? How do you create and 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 busines...
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.
...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 declarative query languages. Excellent problem-solving skills and ability to work under pressure. What We Offer: Opportunity to work on exciting and challenging projects. A supportive and collaborative work environment. Competitive compensation. Flexible work hours and 100% remote work. How to Apply: Please send your resume, a cover letter, and a portfolio ...
Business Name: Picturesque AZ (This is a Photo Booth Rental business) We are looking for a round logo that encapsulates a silhouette of people enjoying themselves, like at a party or something, with either the company name wrapping around the logo or going across the logo. The wording should be modern but elegant and goes with the name "picturesque". Then add maybe a flash or shutter icon in the upper right corner. We would also like to see a few other color schemes that have modern, elegant, flashy, and eye-popping options. Auto reject for those who don't follow the above instruction/request. Thank you, and Good Luck!
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.
Thumbnail updated. Upper left text: NEW!! Centered or lower right text: Home Theater Products Please see the sample image attached
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...
...exams 2. 6. Paid Subscription Offer: • Encourage students, post free content exploration, to opt for a paid subscription, granting access to nine additional exams per quarter. • Present the subscription offer through a pop-up or explore other engaging alternatives. 7. Payment Prompt: • For access to additional content, prompt users to make a payment when clicking on documents displaying only the upper part of the first page. 8. Automated SMS Reminders: • Post free subscription, automate SMS reminders for payment renewal at specific intervals, with a maximum of three reminders per year. 9. Subscription Packages: • Present three subscription options: one quarter, two quarters, or three quarters. Consider offering a special discount for the annual subscripti...
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!
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.
