Query mssql database jobs

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...

...as well as vector databases to store the index. All ingested documentation is cleaned up and divided into smaller chunks and labeled by source. We then use the GPT embedding API to generate a vector representation of each chunk and store it in the vector db index. When a user asks a question, we convert it to an embedding, and perform an advanced semantic search for closest matches to the user's query. Then we take the most relevant chunks, included them as context along with the original question, and use the ChatGPT API to generate a response in markdown format that we then convert to HTML and display to the user. This is from website. They provide a similarity percentage from the sources they use for the generated answer, we can use that similarity percentage for the r...

We are seeking a team of Database Engineers who can combine multiple sources of data into an Azure MySQL database on an automated basis. The operation must comply with HIPAA regulations under an organizational development environment (VDE). All VM's and databases will be deployed through Azure.

I am in need of an investment website that allows users to buy and sell stocks. Key Features: - Database Integration: This website should include a database to facilitate and record stock transactions. - Buying and Selling: The primary function of this site is to allow users to buy and sell stocks. - User-friendly Interface: The site should be intuitive and easy to navigate, ensuring a seamless user experience. Ideal Skills: - Web Development: Experience in developing dynamic websites with database functionality is crucial. - Financial Knowledge: A basic understanding of the stock market and investment is advantageous to ensure the site meets the required standards. - UI/UX Design: A good eye for design and user experience is important to create an engaging and...

I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...

I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

...that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`.`customer_lastname`, `o`.`status`, `o`.`created_at`, GROUP_CONCAT(oi.product_id) AS `products`, `billing_address`.`city` AS `billing_city`, `billing_address`.`company` AS `billing_company`, `billing_address`.`postcode` AS `billin...

...WordPress website's database. The primary reason for this is to lower hosting costs. Key Areas for Optimization: - **Back-end Operations Speed**: The site's backend is significantly slowed down due to the large database. I need a solution that will significantly improve the speed of my back-end operations. Data Types to Address: - **User Data**: The large volume of user data on the site is a significant contributor to the database size. I need to find ways to optimize or archive this data without compromising its integrity. - **Media Files**: The site is media-rich, and the files are taking up a lot of space in the database. I need to find a way to reduce the size of these files without compromising the images or videos' quality. - **Logs an...

We need a good database of Qualified and experienced candidates resumes for us to hire in a Megawatt Solar Clean energy project. Database should be live and good up to date database with full Resumes of the interested candidates.

I'm looking for a skilled and experienced professional to create a comprehensive Farsi database for advanced language learning purposes. This database will be used as a refrence for a text generator Ai Key Project Details: - The focus of this database should be on advanced-level language content - Content should include a mix of literary texts, technical documents, everyday conversations, as well as other forms such as books and poems. Ideal Skills and Experience: - Proficiency in Farsi language - Experience in creating educational content, particularly for advanced learners - Ability to source and organize a variety of content types, including literary and technical material - Strong understanding of language learning methodologies and best practices - Familia...

...connection errors that have arisen on my Windows-based Sal server. The server is primarily used for database management. Key Responsibilities: - Investigate and pinpoint the root cause of the connection errors. - Implement necessary fixes to ensure a stable and reliable database management system. Ideal Skills: - Proficiency in Windows server environments. - Extensive experience in database management, particularly in resolving connection errors. - Strong analytical and problem-solving skills. - Excellent communication to ensure the process is transparent and educative for me. Please provide an overview of your relevant experience and your approach to addressing connection errors in database management systems. Looking forward to working with an individu...

I am looking for a knowledgeable freelancer with solid experience in Android development, particularly in the field of business process optimization apps. Primary Requirements: - Implement bug fixes in User Interface and Database Management. - Optimize pages for enhanced performance. Ideal Freelancer: - Should have extensive experience working with Android applications. - Proficiency in UI enhancements and Database Management. - Knowledge of business process optimization apps is beneficial. Please make sure you can commit time to promptly address and resolve these issues. Let's make my app better together.

As a project manager running an online voting process, I am struggling with a database and performance issue in our Laravel and MySQL setup. We are currently under the pressure of non-stop people voting. Ideal skills and experience for this assignment include: - Expertise in Laravel & MySQL - Experience with high load applications - In-depth understanding of database performance optimization - Experience with online poll/voting systems The specific tasks I need assistance with are: 1. Addressing a database connection error which has arisen due to intense continuous voting. 2. Tackling the query performance problems coming up in our online polling setup. 3. Addressing the data inconsistency issues that have cropped up due to dynamic vote tallying. The vo...

...A data archive is expected to allow users to have a space where they can share data privately to facilitate collaboration prior to publication. Such private enclaves must only last for a defined period of time before that data set is shared with the rest of the data archive will provide an interface that is accessible to anyone with a web browser. A data archive will make appropriate query tools and summary data easily will want to analyze and/or use visualization tools to interact with the data without downloading any data.A data archive is strongly encouraged to use cloud storage and computing possible, a data archive is expected to use existing infrastructures and standards. These could include persistent identifiers such as Digital Object Identifiers

I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfaces, or at lea...

I'm seeking a Google Sheets expert to assist me with creating a dynamic client database with a functional search button and also save and modify button . Key tasks will include data analysis, spreadsheet automation, and formula creation. The database needs to store specific information like client name, accountant name, bank names, and sort, amongst others. Ideal freelancers should have extensive experience in Google Sheets with a knack for complex formula creation and automation. Strong data analysis skills will also be useful for this project. Familiarity with creating searchable databases is highly desired.

We already have a database built in Air Table and would like to go back to Access. It would be a fairly straightforward process to see what we have and work to recreate in Access. Prefer English speaking and US resident for ease of communication.

I'm experiencing some issues with my Access database. The data seems to be missing or incorrect. Moreover, I need to add new functionality. The additional function is generating reports. Although I haven't specified the type of reports, I expect freelancers bidding for this project to possess experience in various types of reporting functions. Skills required are: - Proficiency in Microsoft Access - Experience in fixing data errors - Expertise in implementing reporting functions in a database It's crucial that the freelancer grasps the issues and rectifies them, and demonstrates an understanding of database reports functions to add onto the system. Bids from freelancers with relevant experience and skills are welcomed.

Hello, there? I have done the project. We can process as our promise. Is it possible to award? I will wait for you.

...as peer the dashboard screen provided in figma file. The dashboard and others menus must be created in dynamic way as its menus items and widget in dashboards are different according with the user profile. - Menus and Submenus: The SaaS web app has about 18 screens that allow user to interact with some operations like add a new financial product, query data in tables or grids, update and delete data. All this screen must have filters for query and pagination capabilities. - Data Analytics and Reporting: It's essential that the platform has the capability to collect and analyze data, and present these insights in a user-friendly manner. Further details: - The design of the application should be sleek, intuitive, and responsive and must follow the figma design that...

My .csv file needs some serious help. Here’s the deal: - Columns aren't properly aligned - I’m finding incorrect entries in certain columns - There's frustratingly missing data in some cells This mess stands between me and importing the data successfully into my database. If you can efficienty wield the tools of data cleaning and if you excel at attention to detail, this could be the job for you. Skills and Experience: - Proficient in csv files management - Highly skilled in data editing, cleansing and validation Please note, I haven’t determined which software I'll use to import the .csv file. Your input on this area will be valuable! I'm open to MySQL, Oracle or MS SQL Server. Let's make things right!

I'm looking for a seasoned email marketer to help us with a weekly campaign aimed at promoting our services and products to a database we've built over the last six years. Key Points: - We need a strategy that is effective in engaging an audience that we haven't communicated with in a while. - Our emails should primarily focus on presenting our latest products and services. The ideal freelancer for this project should be well-versed in crafting compelling product-focused email content, and should have a strong understanding of re-engagement tactics. A background in both email marketing and e-commerce would be a significant advantage.

I'm seeking an Advanced Data Entry Specialist to support me in inputting data into a database. This is a work-from-home position that will require 10-20 hours per week. Key Responsibilities: - Accurately input data into a database - Verify and cross-reference data to ensure accuracy - Adhere to specified data entry guidelines and procedures The ideal candidate will have: - Advanced data entry skills, with a high level of accuracy and attention to detail - Experience with entering data into databases - Ability to handle a workload of 10-20 hours per week - Strong understanding of data entry guidelines and procedures If you have a proven track record of advanced data entry skills and are looking for a flexible work from home opportunity, I would love to hear from you.

For this project, I am looking for someone to help m...store market data from Interactive Brokers API, specifically stock prices, into a MySQL database. Key requirements for the project include: - Api should be in either js or python - Experience with Interactive Brokers API: The freelancer should have a solid understanding of retrieving data from this particular API. - Proficiency in managing MySQL databases: As the goal is to store data in a MySQL database, experience in this area is a must. - Understanding of market data and stock prices would be beneficial to align the project goals and outcome successfully. I look forward to working with a dedicated professional who can seamlessly bridge the gap between the Interactive Brokers API and my MySQL database with ac...

I have a project that involves entering textual data from physical documents into a database we are creating. Key details: - The data is textual in nature and will be provided to you in physical document form. You will need to accurately transcribe this information into our database. - The primary goal of this project is to create this database. Ideal skills and experience: - Strong attention to detail is critical for this project as accuracy is a key requirement. - Previous experience with data entry is preferred, especially when working with physical documents. - Familiarity with database software would be a bonus, although not necessary. - Excellent organisational and time management skills to ensure the project is completed efficiently.

Project Overview: We are seeking a skilled website developer to create an intuitive and user-friendly platform designed to serve as a comprehensive database for fresh produce suppliers. This platform will enable customers to efficiently locate and interact with suppliers, focusing on ease of use and accessibility. The map functionality is a core feature, as it will assist users in finding geographically proximate suppliers. Key Functionalities: 1. Keyword Search: - Enable a basic keyword search to help users identify suppliers using specific terms. - Integrate auto-suggestions to enhance the user experience by providing potential matches as the user types. 2. Advanced Search Filters: - Develop advanced filtering options to refine searches based on various parameters lik...

**Project Description: Database Creation with GPT Assistance in Excel** **Overview:** The aim of this project is to leverage the capabilities of OpenAI's GPT (Generative Pre-trained Transformer) model to assist in the creation of a comprehensive database using Microsoft Excel. The database will serve as a centralized repository of structured information, facilitating efficient data management and analysis. **Objectives:** 1. Develop a structured database architecture suitable for the organization's requirements. 2. Utilize GPT to automate data entry, validation, and enhancement processes. 3. Ensure data integrity, accuracy, and consistency throughout the database. 4. Enable seamless data retrieval and reporting functionalities. 5. Facilitate c...

I'm in need of a professional who can scrape specific data from a website onto an Excel spreadsheet. The requirement is to list information in a table format. Key Requirements: - Scraping of content descriptions from the website - Transferring the extracted data into an Excel database The data should be organized in a clear and structured manner, following the format I will provide.

...number of likes) + users need to be able to browse the previously shown articles. I need to be able to add new articles without resetting the current order of articles (basically, add to the list). Users can like the article, and the app will show the total number of likes of the article. The app will be localised in 3 languages (I have all 3 language versions of articles; you must set up the database system). I also need you to suggest and implement transitions and animations between screens and when browsing between articles. And since I would like to upload the app to the App Store, I need you to help me with it. UI and icon are already done in Figma, link: Thank you

...facing is related to database interactions. I use 2 types of phones: samsung s4 gt-i9505 and samsung s4 gt-i9515. They should be identical, but the application running on gt-i9505 phones frequently gives this error: ": server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request." I need someone to help me debugging this error as the application can't be shared. I appreciate that this isn't a high-urgency task, so you'll have some flexibility with timing. However, it's important to me that the issues are resolved effectively and efficiently. Ideal skills and experience for this project include: - Proficiency in Django development - Strong understanding of database...

I'm looking for a proficient Data Entry Expert for online database management on MySQL. Your tasks will involve entering and managing data in the MySQL database effectively and efficiently. Key Requirements: - Must possess strong online data entry skills. - Should have experience in working with MySQL. - Familiarity with structured form data is essential. - Attention to detail to ensure data accuracy. - Strong organizational skills to manage and track data in a large-scale database. Your responsibility will be to keep the database updated. This project requires an efficient individual who can deliver accurate work within the stipulated timeline. If you think you're suited for this job, let's connect.

I'm in search of an experienced MS SQL professional who can provide online training that covers from intermediate to advanced concepts. This will focus particularly on, but not limited to: - Database Administration - Query Optimization - Stored Procedures Ideal Qualifications: - Proficient with MS SQL - Previous experience in teaching or training - Ability to explain complex concepts in a simple, understandable manner - Capable of tailoring the lessons to my specific needs No preference on the tools or software versions for the training as the focus is more on learning the subjects rather than mastering specific tools. Feel free to propose the platform or versions you are most comfortable teaching with.

...up and configure a MySQL database with Oracle APEX. The main purpose of this setup is to manage and retrieve product inventory and sales transaction data. Key tasks include: - Designing the database to efficiently handle product inventory and sales transactions. This involves creating an Entity-Relationship Diagram (ERD), and writing Database Definition Language (DDL) and Manipulation Language (DML) statements. - Configuring the Oracle APEX environment to interact with the MySQL database and ensure smooth data retrieval and management. - Ensuring the system is secure, ensuring no unauthorized access to the database. - Providing a high-level overview of the system's architecture and functionality. Skills and experience required: - Strong expertis...

I need a Django professional to manage a sensitive task involving the masking of our project's database. Your primary role will entail implementing encryption on our data. Key Responsibilities: - Generate an encryption key. You’ll be responsible for creating a robust and secure encryption key. - Implement Database Encryption. Utilise your Django expertise to seamlessly integrate encryption without compromising the performance or accessibility of our database. - Maintain Data Format. It is critical that the encrypted data retains its original format. Ensure that no distortions occur during this process. Ideal Skills: - Proficient in Django - Knowledgeable in database structures and encryption - Proven ability to generate secure encryption keys - Exp...

Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what SQL databases can achieve...

I have a project that involves entering textual data from physical documents into a database we are creating. Key details: - The data is textual in nature and will be provided to you in physical document form. You will need to accurately transcribe this information into our database. - The primary goal of this project is to create this database. Ideal skills and experience: - Strong attention to detail is critical for this project as accuracy is a key requirement. - Previous experience with data entry is preferred, especially when working with physical documents. - Familiarity with database software would be a bonus, although not necessary. - Excellent organisational and time management skills to ensure the project is completed efficiently.

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

I am seeking a skilled programming expert, proficient in either Ruby or Python, with intermediate-level ElasticSearch querying capabilities. The primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV...

...it to draw IMEI numbers both randomly and from a database based on specific parameters. Key Features: - **Dual Functionality**: The tool should be capable of generating IMEI numbers randomly or by allowing me to specify certain parameters. - **Parameter Selection**: The parameters that I should be able to choose from when generating IMEI numbers are the device brand and the operating system (OS). - **Web Interface**: The tool should be accessible through a user-friendly web interface that allows me to easily generate the IMEI numbers. Skills and Experience: - Proficiency in Python, as I believe the tool can be built on existing scripts like ``. - Experience in working with databases, ideally with knowledge of the TAC database. - UI/UX design skills to create a simple an...

...competent freelancer with an understanding of MS Access Database creation. This project is aimed at developing a food manufacturing cost-tracking function on top of an existing product management database, while cleaning the existing database up and adding reporting functions. The project involves: 1. Cleaning up existing Database file of Products to a new layout (Can start again or build on existing file). 2. Adding the manufacturing cost analysis function to the database (Allows user to define ingredients and fixed costs for a product and calculate it’s cost price). 3. Adding the sub-recipe costing function – same as above, however, for internal products not sold. 4. Adding the ingredient purchase price and tracking to the database...

...in MS Access database management. The project involves merging and transforming existing MS Access databases. Key Tasks: - Database Merging: You will be required to merge multiple MS Access databases into a single, coherent database. - Data Transformation: The data within these databases will need to be transformed to fit the new structure. - Query Optimization: Your role will also include optimizing queries to ensure efficient data retrieval and manipulation. Key Objectives: My main goal is to facilitate easier data management through this process. The end result should be a well-structured, consolidated database that is optimized for performance. Ideal Skills: - Proficiency with Python and MS Access - Extensive experience in database mergi...

I need a NoSQL database system that can effectively manage our company's purchases, production, and inventory. The project needs to be completed within a month. Attached the Project details ... Key Features Required: - Scalability: The system should be able to handle large amounts of data and growing demands. - Flexibility in Data Modeling: I'm looking for a system that can adapt to our changing business needs without compromising on performance. - High Performance: It's crucial that the system can process data efficiently and provide real-time insights. Ideal Skills and Experience: - Proven experience in designing and implementing NoSQL database systems. - Strong understanding of data modeling and its impact on system performance. - Ability to deliver a sca...

I'm looking to hire a web developer and designer proficient in building an aesthetically pleasing and functional character-storage site that is equally immersive. Key Features: - A platform for managing and displaying detailed character profiles. - Capabilities to categorize data such as names, descriptions, stats, abilities, and corresponding images or artwork. - An integrated search feature to filter out specific character types. Artwork Requirements: - The site should be able to host a variety of artwork formats like character illustrations, and digital paintings. - The developer should implement features for GIF support, to showcase more dynamic character pieces. The ideal candidate has previous experience designing and developing similar sites, a keen eye for aesthetics, exce...

...application's backend, ensuring all new integrations are seamless. - Database Optimization: I am specifically looking for you to boost the performance of my existing application by optimizing the database, which includes indexing, query optimization, and normalization wherever necessary. - API Integration: Your experience integrating APIs will be crucial, as a key part of this project will involve utilizing various APIs to extend the functionality of the application. - User Interface Improvement: The right candidate will not solely focus on the technical side, they must also be able to make necessary improvements to the UI ensuring a smooth and intuitive user experience. - Performance Enhancement: Aside from Database Optimization, I’m searching...

I am looking for an experienced Data Entry Operator for a specific task. The main pur...Data Entry Operator for a specific task. The main purpose of this task is to help organize our customer database. Apart from entering data, the operator should ensure that sensitive customer details are properly handled with care and confidentiality. To apply: * Present a detailed project proposal that shows you have fully understood the requirements of the job. Ideal Skills and Experiences: * Proven data entry work experience. * Sensitive to data privacy issues. * Strong attention to detail. * Proficient with Microsoft Office and data programs. Please note: data migration or data analysis is not needed for this role. The focus is on data organization. Let’s make our customer da...

We're developing a scanner app coupled with an query response system. Seeking a Flutter expert with Django knowledge for UI and backend development, respectively. The ideal candidate will excel in Flutter UI design and possess the skills to manage data storage in Django backend, along with handling API integrations seamlessly.

Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other