Sql create database työt
...of data structure, the scraped data should be organized and stored in a Google Sheets according to categories. This approach allows for a more coherent and systematic pattern for data analysis and representation. The ideal professional for this task should possess: - Proficiency in web scrapping - Expertise in Python or other relevant programming language - Experience with Google Sheets and database creation - High attention to detail - Demonstrable ability to classify and categorize data. The goal of this project is to track changes over time, based on the data scrapped. This requires a design that will facilitate easy updates and quick overview of changes. Hence, knowledge and experience in data visualization will be an added advantage. I've added a few screenshots of...
Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.
...functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professional who is not only skilled in Tableau but also understands the importance of user experience in data visualization. Please pr...
I am looking for a specialist to create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI test cases, with a clear emphasis on user interaction tests. - Setting up and integrating Routing and Guard Components for authorization. - Developing a backend in Spring Boot. - Saving credentials in a MySQL database. Ideal candidates should have solid experience with React Js, Spring Boot, and MySQL database. Proficiency in creating user interaction tests is also a must. Once completed please provide a GitHub link for the project in .docx file with screenshots of the UI.
...you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualifications: - While we do not have any specific certificat...
I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. ...Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoD...
...analyst with expertise in SQL and R to conduct a thorough review and testing of a recently completed data analysis project. The successful candidate will be responsible for evaluating the accuracy and completeness of the work, ensuring all requirements are met, and identifying any potential issues or opportunities for improvement. Responsibilities: Review the SQL queries and R scripts used in the project for accuracy and efficiency. Test the data outputs to ensure they align with the project requirements. Verify that all analysis reports are complete and adhere to the specified guidelines. Provide a detailed report outlining any issues found, confirming requirement fulfillment, and suggesting any potential upgrades or improvements. Requirements: Proven expertise in ...
My current server setup is causing slow response times for my web application and database system. This project involves optimizing the server settings to enhance the performance of both the web and database applications. Ideal Skills and Experience: - Proven experience in server performance optimization - Expertise in managing servers running web applications and database systems - Familiarity with Laravel, as the web application is built using this technology - Excellent understanding of server-side technologies and configurations Key responsibilities: - Diagnose the current server setup to identify performance bottlenecks - Implement necessary changes to optimize the server settings - Regularly monitor and fine-tune the server to maintain high performance - Provi...
I am in need of a seasoned data entry professional who can attentively transcribe information from various online databases into Google Sheets. The role is strictly manual data entry. Skills and Experience: - Proficient with Google Sheets and similar spreadsheet management tools. - Past experience with database interaction, particularly online databases. - Must have a keen eye for detail to ensure accurate data transcription. - Excellent time management skills are essential as deadlines are strict. Although this position emphasizes manual data entry skills, experience in data cleaning and validation pave the path for optimal efficiency. The successful candidate must provide proof of prior similar projects. Your ability to maintain high standards of accuracy and confidentiality ...
I'm seeking an experienced developer to assist in optimizing database speed for my Node.js website. Key tasks: - Conduct initial review of current setup, hosted on a Hostinger VPS with a configuration of 16GB - Advise and implement changes to improve response time, usining knowledge of different hosting platforms such as Amazon Web Services, Google Cloud Platform or Microsoft Azure. - Familiarity with MySQL as a database management system is a must. Ideal candidate would possess keen problem-solving abilities, strong knowledge in database management and previous experience with Hostinger VPS. Experience is optimizing Node.js websites is advantageous. Please provide examples of similar assignments in your proposal.
Create 3 videos for Rosemira Organics Skincare line meant for showcasing on TikTok. Website rosemira.com. If you need source images or products to use we can talk : ) Woman-owned business. Price negotiable! Need a model displaying the effectiveness of our organic skincare. There are products available for women and men. These are products for moisturizing dry skin, calming rosacea, sensitive skin, eczema, sun protection, wrinkle prevention, anti-aging, lip balms for dry lips, collagen healing aloe vera.
Create 3 videos for Rosemira Organics Skincare line meant for showcasing on TikTok. Website rosemira.com. If you need source images or products to use we can talk ! Need a model displaying the effectiveness of our organic skincare. There are products available for women and men. These are products for moisturizing dry skin, calming rosacea, sensitive skin, eczema, sun protection, wrinkle prevention, anti-aging, lip balms for dry lips, collagen healing aloe vera.
I'm looking for a skilled professional to create a robust AI-driven marketing program. This project aims to optimize the marketing database, generate sales, and increase our revenue. Key requirements include: - Building an AI system for data verification to ensure high-quality, accurate information. This includes email verification, phone number verification, and address verification. - Implementing an AI program to sort and segment lists for each campaign. It should consider the following criteria: - Demographic data: Utilizing data such as age, location, gender, and income level. - Customer behavior data: Tracking and understanding customer interactions with the business, such as preferences, buying habits, and engagement. - Purchase history data: Analyzing past...
...with any external database or backend creation. There is no login functionality. Your responsibility will be to develop an interface similar to figma and with the functions below. *Does not need to be identical to figma, but maintain logic. Link Figma: How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved in a local sql-lite database. Summary: - Create app with Expo 50 and TypeScript; - The data must be saved in a local database. This project
My WordPress website is currently displaying "Error establishing a database connection" and I can't access the admin dashboard. I need an experienced freelancer with deep expertise in WordPress troubleshooting and database issues resolution. Tasks will include: - Diagnosing the cause of the database connection issue - Fixing the problem to get the website back online - Ensuring all website features are functioning as they should post-fix I'm using a Cpanel on Godaddy for hosting. So, familiarity with Cpanel and Godaddy is a requirement for this task. Also, I'd prefer someone with immediate availability as this is a high-priority issue. Skills required: - Advanced WordPress proficiency - Strong understanding of databases - Experience with ...
I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link
I'm looking for a developer who can replicate a person based on gpt. The functions I want are as follows. Development environment: Python 1. When I put in a YouTube link, I create a gpt model that has the person's personality, tone, and knowledge. 2. The model made in No. 1 and the app that can chat using gpt api (this is already made with flutter). What I want is to develop No. 1 into Python. If I have to use llm other than gpt, it doesn't matter if I can just get an answer with api. If I can't completely replicate a person with YouTube link alone, I welcome anyone who has other options. The key is to create a chatbot that has the way a particular person speaks, personality, and knowledge. An example is caryn ai on the market.
Project Description: We are looking for a skilled WordPress developer to build a website for , a company specializing in property and business loans overseas. The website should support multiple languages and feature a multi-currency loan calculator, secure loan application processing, and user account management. Objectives: Develop a clean, professional-looking website using WordPress. Include key functionalities such as a loan calculator, multi-language support, secure application forms, and customer login areas. Required Features: Multi-currency loan calculator Secure application processing User registration and management Responsive design for all devices SEO-friendly structure Skills Required: Proficient in WordPress, PHP, HTML, CSS, and JavaScript Experience with financial servi...
Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.
...through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') INSERT INTO #Order VALUES (2, 1, '02/17/2024 07:22 AM', 'Cancelled') INSERT INTO #Order VALUES (3, 1, '02/19/2024...
I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace ...
I have an online database searching service and I'm looking to upgrade its current features and introduce some new ones. Key Features to Add: - Advanced Search Options: I'm interested in building on my current search function to offer more refined search capabilities. - Scraping: I'm looking to add a data scraping capability to my service. This will involve extracting data from various websites and integrating it into my existing database. - AI Data Analysis: I'd like to incorporate AI data analysis functionality into my service. Specifically, I'm interested in pattern recognition and data clustering. Other Enhancements: - Batch Searching: I need to implement a batch search functionality. - Additional Database Integration: I'm interes...
I'm in need of a CV expert who can assist in both the formatting and design, as well as content improvement of a completely new CV from scratch. This new CV should be specifically tailored to highlight my skills and experience for management roles. Key aspects I am looking for are: - A clear, professional layout that meets standard formatting expectations for management roles. - Strong, compelling content that effectively showcases my achievements and capabilities. Content should be powerful yet succinct. - Solid understanding of what hiring managers in the management sector are looking for in potential candidates. In an ideal world, the freelancer should have strong experience in developing CVs for clients targeting management roles. A proven track record in creating successful C...
...final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional portfolio site. Things to be done Load an API data into on premise SQL server database Client will do some data calcution The new data will be available in the database and needs to be show in website with some base UI. Project involves show some other API data on the website as well Need not have a lot of experience in UI design but need experience showing data into a page. Website would look like this --- Odds data should be displayed like this show in the page. Along
...noticeable delays during actions that involve fetching data from the MongoDB database, significantly impacting the user experience. I'm seeking a skilled developer who can help me address these performance issues. Key Tasks Include: - Investigating and identifying the root cause of the slowdown when fetching data from MongoDB - Implementing optimizations and solutions to improve the performance of the server actions, particularly those related to database interactions - Testing and validating the improvements before deployment to ensure they effectively address the issue without causing any unintended consequences Ideal Freelancer: - Proficient in and MongoDB - Experienced in optimizing server actions and database interactions for performance - Familiar wi...
I'm looking for a skilled professional to create a comprehensive database ( 10,000 to 20,000) of Non-Resident Indians (NRI) working and/or residing in foreign countries like USA, UK, SIngapore, Canada, Australia, Dubai. Their age group may be between 22 years to 42 database will be used for marketing and promotions for my existing business. Key Elements Needed: - Name - Email - Mobile - Company Name (if available) - Country of Residence or Work Data Collection Methods: - Online Surveys - Social Media Platforms - Public Records Skills and Experience Needed: - Experience in data collection and database creation - Proficiency in using online survey tools - Familiarity with social media data mining - Ability to identify and use relevant public records - Att...
Create LSTM model in python to predict price for six month in the future.
Hello freelancers, I am seeking someone with a keen eye for detail who can assist me in entering a large amount of numeric data into a database. Here's what the ideal candidate would bring to the table: - Expertise in data entry, particularly with a focus on numeric data. - Proficiency with databases; experience with both creating and updating entries is necessary. - Demonstrated ability to manage large datasets, as the volume of data for this project is over 1000 entries. - Strong analytical skills with a propensity for accuracy. Your task will involve accurately capturing the numeric data and ensuring its successful entry into our database system. The success of this project is reliant on not just swiftly completing the task, but maintaining a high level of accuracy ...
We are looking for someone to take a T-Shirt mockup from a supplier and make a Photoshop action the shirt transparent so it can be used in an online customiser with the background colour set. This should retain highlights and shadows, and work correctly to show the correct colour through when any colour is set as the background. You can see an example of how this should work in the attached files (we have original and completed files). Any queries please ask.
We are looking for a talented copywriter to create catchy and engaging slogans for our social media advertising campaigns. As a copywriter, you will be responsible for developing creative and compelling content that captures our brand's voice and resonates with our target audience. Your slogans will be used across various social media platforms to promote our products and services. Responsibilities: - Brainstorm and develop unique slogans for social media advertising - Collaborate with the marketing team to understand brand guidelines and target audience - Conduct market research to identify trends and competitor strategies - Ensure slogans are concise, persuasive, and aligned with brand messaging - Revise and refine slogans based on feedback from stakeholders ...
I've run across an issue in my WordPress / WooCommerce site that I'm not sure how to fix. I keep getting the error: "WordPress database error Commands out of sync; you can't run this...". This error is not related to specific actions or queries on my site. It's clear I require someone skilled in problem-solving and debugging with: • Extensive WordPress and WooCommerce experience • Clear understanding of WP databases and commands • Proven ability to address and correct site errors Please, I need this problem solved urgently. Your expertise and prompt attention to this will be greatly appreciated.
...proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly in automation applications. - Experience working with Websocket and...
Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Ex...web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed ...
I need a Python expert to scrape tabular data from a series of PDFs and store it in a database. Ideal Skills and Experience: - Proficiency in Python. - Strong experience in web scraping with PDFs. - Familiarity with database management. The PDFs are consistent in format and all contain tables. The scraped data needs to be stored in a database.
Tengo trabajo constante relacionado con proyectos anteriores '3D Designer to Create Realistic Statue from Photos'
I'm in need of an experienced developer who's well-versed in ASP.NET and VB.NET. The project involves the event pages i need where user can login and acess the event throught calender with s...throught calender with specific functionality.. i will share feature to slected one ... Ideal Skills and Experience: - Proficiency in ASP.NET & VB.NET is a must, with a proven track record of projects involving user authentication and database integration. - Strong understanding of SQL Server databases and how to effectively integrate them into a .NET environment. - Experience in implementing user authentication systems that cater to both roles and individual accounts. This project requires a developer who can deliver secure and efficient user authentication and dat...
Video editing skill should be excellent and I want the ad a little creative
I require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Server. We would like to move the application to AWS using a windows OS and SQL Server Database. Please guide as to which option would be better. The selected freelancer would have to set up a Windows operating system. Skills and Experience Required: - Proficiency in AWS, - Demonstrated experience deploying Please ensure to include examples of your previous AWS work in your bid. Your ability to efficiently handle tasks in the AWS environment is paramount for this project.
I need to configure my Postgres database software to authenticate users with local Active Directory (AD) credentials. Key Requirements: - Authentication: Set up the database to authenticate users with their local AD credentials. This is crucial for security and access control. - Seamless Integration: Ensure that the connection between the database and the AD server is seamless and reliable. - User Management: The system should allow for easy management of user privileges, ensuring that the right people have the right levels of access. Ideal Skills and Experience: - Experience with Postgres: You should have a strong background in working with Postgres, particularly in a configuration and security context. - AD Integration: A deep understanding of Active Directory ...
...candidates should have plenty of experience with Flutter Development, as well as a portfolio of past work to demonstrate their expertise. - Proficiency in Flutter development - Experience in developing for both iOS and Android platforms - Ability to work independently with minimal guidance You have to setup and configure both the flutter application (iOS and android) as well as the backend PHP, my SQL, firebase, docker etc. As the client, I did not specify the key features to be prioritized, giving you the flexibility to design the app in a way you find most effective. Similarly, there is no predesignated design requirement for the app, paving the way for creative freedom. Given the lack of specifications, the ideal freelancer should be highly creative and intuitive, capable...
We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.
Create webflow memebrstack and connect to zapier for email marketing. Also integrate mail chimp with double verification
I have Excel sheet in the are all products added with all the categ...will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This will be regular work per week to create 10-15 images.
I want a individual, to tell me how feasible it is, to copy this extension, We take inspiration from this extension and get something similar up, in the shopify app store, of course you need to ensure it is not a dumb copy, to avoid copyrights, make some tweaks etc In your proposal I expected, to have a plan included, how long it will take, any suggestions, and if you have done something similar before, if you have created extensions, share the link. Please include Hello world to the top of proposal.
Function is done, amend the label that is stored and the value show. Only with ftp
I want a individual, to tell me how feasible it is, to copy this extension, We take inspiration from this extension and get something similar up, in the shopify app store, of course you need to ensure it is not a dumb copy, to avoid copyrights, make some tweaks etc In your proposal I expected, to have a plan included, how long it will take, any suggestions, and if you have done something similar before, if you have created extensions, share the link. Please include Hello world to the top of proposal.
I run an ecomm store and I'd like to include a "Cost Per Wear" section on each product page so that the user can understand the product cost for various wears. Ex: a $100 item Cost per wear: 3: wears: $33 15 wears: $6.66 50 wears: $2 The price could be a sliding scale and would need to adjust automatically based on the product price. See the photo attached to better illustrate the vision.
I need a skilled professional who can compile a comprehensive spreadsheet of massage and beauty therapists. The data will come from provided databases which include salon details. Key Requirements: - Compile names, addresses, and phone numbers from the databases. - Organize the data in the spreadsheet by type of service (massage or beauty). The ideal candidate for this job should possess: - Proficiency in data entry and management. - Excellent attention to detail to ensure accuracy in the information gathered. - Familiarity with Excel for organizing the data by type of service. - A good understanding of the beauty and massage therapy industry would be advantageous. Please note that the final deliverable should be in Excel format.
Logo Brief: Urban Social House Overview: We are seeking a logo design for "Urban Social House," a small bites, heavy hors d'oeuvres, charcuterie boards restaurant, and craft cocktail lounge located in a renovated historical house in a revitalized downtown setting. The establishment features an open-concept contemporary design and caters to an upscale clientele. Design Requirements: The logo should include both a word mark ("Urban Social House") and a monogram emblem utilizing the initials "USH" which can stand alone for various marketing purposes. The primary signage will be a hanging di-bond sign with a raised logo, so the design should be suitable for this application. (see attached) Colors should complement the style and ambiance of the business, re...
