Build database for sql jobs

I'm in need of an experienced SQL professional to assist me with data warehouse. The ideal candidate is someone who has: - Proven experience in designing data warehouses - Advanced SQL skills - Excellent understanding of data volumes and the implications for data warehousing If you are interested in this project, please provide details of your experience in similar projects. Thank you.

I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.

I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.

I am in immediate need of a comprehensive database containing information about IT professionals with 2-3 years of experience. This is crucial for a current initiative, thus I need it ASAP. The database should provide: - Name - Phone Number - Skills - Educational Background - Work Experience - Salary Precision is of utmost importance to me. Therefore, an ideal freelancer for this task should have proven experience in data collection and data entry, with a keen eye for detail to ensure the accuracy of the database. Experience in the IT or HR industries would be a significant advantage.

I see that you have done UPS shipping API's. They are converting everything over to OAUTH 2.0 with their shipping. Is this something you can do or have done? I have a VB project that was built and added to over the last 10 years and updated. It is written in C# and uses MS SQL. Their current API is ending June 5th of this year. I need this switched over to OAUTH. I just use the shipping, rates, and time in transit within my website. Let me know.

I'm looking for support with a typed data entry project that involves organizing the data into a database. While the data entry itself isn't particularly complex, a certain level of basic data cleaning will be required. Key Requirements: - Data Entry: The main task is to accurately input data from PDFs into a database. The data is mostly textual, so typing proficiency and attention to detail are essential. - Database Organization: The entered data needs to be organized in a clear, logical manner to ensure it's easily searchable and can be efficiently used. - Basic Data Cleaning: The data will need to be reviewed and cleaned up to ensure accuracy and integrity. This will involve identifying and removing any duplicate entries. Ideal Skills and Ex...

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm urgently in need of a skilled professional who can swiftly deploy a database server for me. Key Responsibilities: - Establishing a server primarily intended for databases - Choosing the suitable database management system (DBMS) Ideal Competencies: - Extensive experience with multiple DBMSs as I'm not yet decided on which one to use - Ability to work under pressure and deliver swiftly since the project is urgent - Prior experience with server deployments will be highly advantageous.

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentatio...

I’m experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication...

I am seeking an expert in SQL Server replication. The project involves replicating our business data to facilitate efficient data distribution. The replication has been set up. The snapshot working but Data not delivering to the subscriber. Log reader fails after 10 mins - Key Expertise Required: - Proficient with SQL Server - Extensive experience with data replication - Profound understanding of business data - Knowledge in data distribution strategies

...an Access database that can primarily handle generating reports and analytics. The main goal is to keep track of internal data for further analysis and reporting. Key Features and Functions: - **Reports & Analytics:** The database should have the capacity to generate comprehensive and insightful reports from the data gathered. It's crucial that these reports are insightful and easy to understand. - **Data Tracking:** The database will be used for tracking internal data. This needs to be done with precision and the ability to link data for comprehensive tracking. - **Data Input & Updates:** The system should allow for easy input of data and updating when needed. This will facilitate the generation of accurate and updated rep...

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

...stack developer for initial software development for a pathology lab. The software must be responsive, user-friendly, and robust, catering to patients, staff, and referring doctors. Here's what we need: 1. **Choice of Platform**: As the client, I am open to using Angular, React or PHP for the development along with SQL Server/MySQL for the database. Feel free to recommend a platform when you apply. 2. **Essential Modules**: - Building Patient Database (From existing Lab Software - Which will remain as is). This database will be used for Whatsapp , email , SMS Marketing (This also is part of scope) and also For Patient Web App interface. Whatsapp API interfacing will be required for sending and interactin...

I'm looking for a seasoned developer with strong proficiency in Blazor web assembly, API, and SQL Server to build a compact application for invoice billing. The main goal of this application is streamlining my billing process. Key Features: - Invoicing/billing: The platform should facilitate automated creation and delivery of invoices. Ideal Skills: - Familiarity with Blazor web assembly, API, and SQL Server - Experience in creating billing systems - Understanding of financial processes - Excellent attention to detail If you have prior experience in a similar role and you're up for the challenge, I'd like to hear from you.

...and back-end technologies. Responsibilities: - Develop and implement user-facing features using front-end frameworks/libraries like React - Build and maintain server-side applications using programming languages such as Python, PHP, or Node.js - Design, develop, and optimize RESTful APIs and web services for data integration - Implement authentication and authorization mechanisms for secure user access - Work with SQL and NoSQL databases to build efficient data storage and retrieval systems - Collaborate with cross-functional teams to translate requirements into technical solutions - Perform testing, debugging, and optimization of web applications for performance and security - Deploy and maintain applications on cloud platforms like AWS or sh...

I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $10/script for easier works (like scrap-data transferring between GS&SQL), - Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Stro...

As a website owner operating 20 sites predominantly run on PHP Wordpress and AS...strong Dbeaver knowledge to equip me with the necessary credentials and permissions to attach an SQL file to IIS Win 10. As a user who needs help with troubleshooting the "Unable to connect" issue in IIS, the assistance in this matter is crucial. Ideal Skills and Experience: - Extensive experience with Dbeaver and SQL-IIS connections - Previous experiences with WordPress and ASP - Good understanding of PHP 8.3.6 - Ability to troubleshoot and resolve “Unable to Connect” issues in IIS - Ability to provide guidance for verifying and establishing necessary credentials and permissions. Bonus if you happen to have experience in understanding and troubleshooting permiss...

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

I'm looking for a proficient person that can go into links and write emails and phone numbers. There are 15,000 Records to revise. Work needs to start asap and be completed with a good team. This is not a one person job. I need all records completed real time from a file on google drive. Must be complete with 24 hours Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong trac...

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

I need a C# .NET programmer to integrate UPS API functionalities into an existing .NET website. UPS is switching over from their current API to OAUTH 2.0. Everything works as it should now, but in June the current API will no longe...of the project is implementing UPS API functionalities. You will need to handle package tracking, calculate shipping rates, and create shipments through the UPS API with OAUTH 2.0 Ideally, you should have experience with C# and .NET, as well as UPS API integration. Previous work with this is ideal and would like to see examples. I will provide the Visual Studio project as well as a MS SQL database for you to test with locally. I also have the keys that will be needed from UPS. If you're confident in your ability to handle this ...

There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar ...

I've been experiencing some difficulties with my MS Access database. Error messages appear indicating missing or broken files namely, ‘’ version 7.0 and ‘’ version 1.0. Some occur as soon as I try to open the application. No recent changes have been made to my computer's operating system or the MS Access software. Ideal applicants for this task should be proficient in MS Access, troubleshooting, and database management. You'll need in-depth knowledge of system files and how they might impact the functionality of the application. A knack for solving complex technical problems is also important. In turn, you should be capable of providing a lasting solution to prevent the recurrence of these errors. Cheers!

I am looking to get this done in two weeks. Please see the included specs and html wireframe layout before bidding. I need someone who is skilled in ASP.NET and experienced with mobile apps. I would rather have the app developed with cross-platform software but it will for now be used in iOS.

I'm seeking a skilled Visual Basic developer to update our existing codebase. The primary goal of this update is to enhance the performance of the application. Ultimately, the application is used primarily by our internal empl...seeking a skilled Visual Basic developer to update our existing codebase. The primary goal of this update is to enhance the performance of the application. Ultimately, the application is used primarily by our internal employees, so ensuring seamless operation is essential. Key Responsibilities: - expericence of Visual Basic Development - Implementing upgrade - have Visual Studio 2022 higer - have MS Sql server Ideal Skills & Experience: - Proficiency in Visual Basic. - Strong experience in code optimization. - Previous work on internal-facing appl...

Hi Do you have experience with both mulesoft and salesforce? It iş sql and salesforce integration using mulesoft For now my task is to solve this error so let see how many hours it takes us and for the new project we will discuss the time per week I need indian time tomorrow morning 7:30 am This support will be on zoom meeting which we will provide u and u will connect with my consultant for support

I am seeking a talented developer who specializes in BioTime database development. The database will primarily be used as an attendance system for my staff. Key Functionalities: - Data Entry and Retrieval: You will implement mechanisms to input and retrieve staff attendance records. Data to be Managed: - Staff Attendance Records: The system should capture and store staff's check-in times, check-out times, and leave entries. Ideal Skills and Experience: - Proficiency in working with BioTime databases. - Demonstrable experience in building data entry and retrieval functionalities. - Prior projects dealing with attendance systems or related fields will be a significant plus.

I am actively seeking an API development expert, specifically for SSO and SAML integration. Let's dive into what I am specifically envisioning for this project: - Proficiency: I will need someone who is familiar with SSO, SAML, React, Node.js and SQL. Your past experience in similar projects will be highly valuable. - Functionality: A primary objective for this task is to develop an API that has Single Sign-On (SSO) and Security Assertion Markup Language (SAML) functionality. - Purpose: The purpose of the API development is to integrate SSO and SAML for user authentication in my system. Maintaining security, ease of use, and adaptability is crucial. In conclusion, your task primarily revolves around strengthening authentication methods via respec...

I have a small FileMaker Pro 12 database that requires a conversion to an SQL-based database. The structure is to largely remain the same, but there are some minor issues that need rectification. Details: - The conversion task requires no major changes to the original data structure. - However, some calculation errors need fixing. Therefore, you'll need a keen eye for identifying and rectifying them. Skills & Experience Required: - Experience with FileMaker Pro 12 and SQL databases. - Understanding of database structures and functionalities. - Ability to identify and correct calculation errors. - Great attention to detail. Please ensure that during the conversion process, no data is lost, and the end product works seamlessly. The bi...

...one or more words. Our task is to identify exact matches for these strings within another dataset that includes complete sentences. Currently, our method of loading the first set into memory as a set variable (ensuring no duplicates) and each string from the second dataset as a separate string variable is proving inefficient. Problem Statement: Iterating through the first dataset to look up each value in the second dataset has been excessively time-consuming. We require a more efficient algorithm to enhance the speed and effectiveness of these exact match lookups. Project Objectives: Develop a Python script that can perform exact match lookups quickly and accurately. Ensure the integrity and accuracy of the lookups to maintain database cleanliness. Key Requirements: Eff...

...process is Visit Search for: Drainage companies Glazing repair Boiler repairs in London Open a google sheet and write the following in the sheet: Company name Website Officers name Establish the limited company name and visit Type in the company name and then go to officers and type the name of the officee on the spread sheet. Visit the website and go to the contact us page. Fill out the contact us page Name: Chris Number: Email Message: Hello (enter the name of the officer) I am the CEO of and I came across your business, we are an AI company for trades people and we are looking for a partner we can offer our Job booking AI tool to for free for a month, please can you send me your email

I'm looking for an expert in data scraping to effectively extract text data from online databases. Primarily, I am interested in customer details. This data will be pivotal to my operations. Key tasks include but are not limited to: - Extracting textual data from specified online databases - Focusing on customer details during extraction - Organizing the extracted data in an easily accessible format The ideal candidate is proficient in data scraping and has a deep understanding of online databases. Proficiency in using tools and scripts for scraping is necessary. Previous experience with customer data extraction will be a plus. A rigid approach to data privacy and ethical scraping standards is imperative. Accuracy, efficiency, and detail-orientation are crucial skills...

...previous versions when needed. SEO Optimization Features: - SEO-Friendly URLs: The system should support custom URLs that are easy to read, relevant to the page content, and optimized for search engines. - Meta Tags Customization: The CMS should allow clients to customize meta tags, including title tags, meta descriptions, and keywords for each page. - XML Sitemap Generation: The CMS should automatically generate and update an XML sitemap, making it easier for search engines to crawl and index the site. Security Features: - Vulnerability Protection: Ensure the CMS is robust against common web vulnerabilities like SQL injection and XSS attacks. Skills and Experience: - Strong PHP and CMS development background. - Proficiency in implementing SEO best practi...

...automated as much as possible. - It should have the capability to save both sent and received - The add-in should be efficient, ensuring that no emails are missed in the process - A simple yet effective interface that is easy to navigate and use is crucial The add in will: - query a SQL database and find clients linked to the sender/recipient and prompt the user to select the relevant client - Save a copy of that email to the relevant folder for the selected client - again based on a SQL query. The SQL query information can be provided to facilitate this. Ideal Skills and Experience: - Proven experience in developing Outlook add-ins. - Knowledge of Microsoft Outlook's functionality. - Strong attention to detail to ensure proper emai...

I'm facing a challenging issue where my ASP.net application can't connect to a MySQL database. I need a fast solving of this problem and want to start in the next hour !! Here are the issues I'm dealing with: - The database I'm using is MySQL - using AWS mySQL RDS - Asp.net server is on Amazon EC2 - There's no connection to the database at all message: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Check image below with error message. It is an older database, maybe we need update some libary for connecting or whatever. I prefer to connect with anydesk or other remote desktop software. Before...

I'm looking for an experienced backend developer to handle database management and API integration for my project. Key Responsibilities: - Implement and manage a MySQL database efficiently. - Develop and integrate APIs to ensure seamless communication between front-end and database. Ideal Skills: - Proficiency in MySQL is a must. - Strong experience in API integration. Experience with other databases and backend technologies like Python, Java, and Node.js would be a plus. The chosen freelancer will need to understand the project's requirements thoroughly and communicate effectively with the front-end team to ensure a well-functioning, reliable backend system.

I'...perform detailed data analysis. Key Responsibilities include: - Designing and creating visually stimulating Power BI dashboards that succinctly translate complex data into understandable and actionable information - Generating impressive data visualizations - Conducting thorough data analysis The data for this project will be sourced mainly from Excel spreadsheets and SQL databases. Ideally, you should be proficient in handling and interpreting data from these sources. Data refreshes are planned for a weekly interval. Experience with such a schedule and understanding how it impacts and influences dashboard functionality and data visualization will be beneficial. Only those with proven track record in Power BI dashboard development, data visualization, an...

I am currently looking for an MS SQL trainer to help with physical training in chennai. - Expertise: While the selected trainer needs to have intermediate level skills in MS SQL, having advanced skills could be a bonus. However, the ability to explain complicated topics in a simplified manner is paramount. - Topics: Though a choice was not specifically provided, your comfort with a range of MS SQL subjects will be beneficial. From database administration, querying data to data integration, any and all skills are welcome. - Time frame: This is an immediate requirement. Hence, applicants who are available to start at the earliest will be preferred. Ideal candidates should have considerable experience in training others, a strong grasp of MS SQL, an...

I need a Full Stack Developer comfortable with React, Sass, .NetCore, and SQL Server to work on my website, web application, and mobile/desktop app. The primary goal of this project is to develop a responsive, high quality website that also functions as a web application, with the potential for further expansion into mobile and desktop applications. We are looking forward to have a complete Computerized Maintenance Management System (CMMS) / Maintenance Work Order(MWO). A Complete Control Pannel on Web based asapplication along with the Mobile APP + Desktop APP. With the below added features.:- + It will have Website Fully responsive, Mobile APP, Control Pannel Application + It must fully SAAS Based means related to the SAAS Based all the screen to be designed and implem...

I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.

Project Title: Radiologist Database Creation for Victoria, Australia Project Description: I am looking for a skilled and creative freelancer to compile a comprehensive list of all radiologists currently working in Victoria, Australia. The goal is to create a detailed database that includes their names, contact information, and relevant professional details. Requirements: Research and Data Collection: The freelancer should be proficient in online research and data scraping. Identify reputable sources, databases, and directories where radiologist information can be found. Collect accurate and up-to-date details for each radiologist. Data Fields: Full Name Clinic/Hospital Name Clinic Address Phone Number Email Address (if available) Specialization (e.g....

We are a leading wildlife management and pest control company, renowned for our innovative approaches and award-winning services. We are looking to revolutionize the pest control industry by developing an all-in-one SaaS platform that will streamline operations, offer new-to-industry reporting and transparency, and redefine customer experience. Project Overview: We are seeking a talented freelancer or agency to develop a cutting-edge SaaS platform that will serve as the backbone of our pest control management system. This platform will encompass various modules including CRM, sales, field service management (FSM), asset management (GIS), pest activity reporting, client interaction, and technician reporting. Our company will be the first and primary user of this platform, we will s...

I'm building a site in Oxygen with Advanced Custom Fields. I have created a custom post type with several different categories. I have then also created a custom archive template using a repeatable element. However, I can't get the archive template to display just the posts in the relevant categories. When I go to the front end categories, they either display nothing or all of them.

I am looking for someone to help me create a comprehensive database of art galleries in Dallas, Texas. This will be used for market research purposes. Key Requirements: - The database should include the names, phone numbers, and email addresses of the art galleries. - For each entry, I also need the street address, city, state, and zip code to be included. Ideal Skills and Experience: - Prior experience in data collection and database creation would be highly valued. - Strong attention to detail is crucial to ensure accurate and complete information. - Familiarity with art-related databases would be a definite plus. The end goal is to have a well-organized, accurate and comprehensive database that can be used effectively for marke...

I'm seeking a Flutter developer to build an application that integrates with an API to perform CRUD operations on an SQL database. Key Requirements: - CRUD Operations: The app should be able to create, read, update, and delete records from the SQL database. - Database: The SQL database is the preferred choice for this project. - API Integration: The app should be able to read data via an API, handle user profiles, transactional data, and real-time updates. Ideal Skills: - Proficiency in Flutter development - Experience with SQL databases - Familiarity with integrating APIs - Understanding of CRUD operations - Ability to handle various types of data, including user profiles and real-time updates.

I'm looking for an expert in MS SQL databases to help me with a specific task. I’m using an MSSQL database and need to create a Param scalar. This is to store specific customer information in a structured manner. The ideal freelancer should be experienced with: - SQL, specifically MSSQL - Parameter creation within databases - Experience working with customer information In your proposal, please provide an example of a similar task you've completed in the past.

...PHP/SQL script. I want it to help me capture, store and manage user reviews. The script will also redirect positive reviews to Google/Facebook for example. DEMO: The script aims to help business owners manage their business details, review sites, and customer feedback effectively by sending positive reviews to external review sites such as google or facebook and negative reviews are sent to a feedback form. —-> Please see example for exactly how I want website to look! Must be very clean and dynamic and perfect for mobile first. <— The project's requirements include: - User Review Capturing: The script should allow users to leave reviews without needing to register. - Database Integration: The script should store all revi...

data base design (model, sql) 590 laravel auth customized for phone (ALMOST DONE) 2360 Referral logic 2360 referral page register configuration Event Script (creates new even every 3 min will be a cron job for linux) 3540 Additional Pages 2478 { withdrawal page 708 Account details 472 Recharge page 708 Contact us page 826 } Betting Page 4720 includes the following { time and result feature 2000 betting feature 1000 events feature 500 my history feature 500 } Admin Panel 8378 withdrawl 1600 user manage 2000 manage result 1700 past events 800 earnings 1000 TOTAL 21950