Small sql query jobs
I'm in need of a meticulous freelancer who can assist me with data entry. The data is currently in physical documents and needs to be entered into a digital format. Ideal Skills: - Proficiency in data entry - Attention to detail - Ability to handle physical documents
I am looking for an experienced Python developer to create a scraper for Lazada. The ideal candidate must be skilled in web scraping and should reverse engineer API from mobile app because lazada blocks and throws captcha on web website is lazada . The script should work like i enter something in search box and it should scrape all the products from that search query Key Responsibilities: - Extract the following information: product names, prices, descriptions, stock, images, seller information, and product URLs. This list encapsulates the attributes you need to pay the most attention to. - Organizing the scraped data: The data, once scraped, must be organized in a well-structured CSV file. Ideal Skills: - Strong experience with Python. - Proficiency in web scraping tools. -...
I am looking to build a small web app, looking for professional android developer.
I'm looking for a skilled web developer to create an e-commerce site for my small business. The depending details are yet to be finalized, hence your inputs will be highly appreciated. The job description includes: - The website will have a variety of products to sell. We are not yet certain whether we'd be focusing on only physical products, digital ones or services, or a mix of all. So, an adaptable, scalable site is key. - I haven’t yet decided who will provide the content – it may be us, it may be the freelancer we hire or both. This means the ability to either work with provided content or to generate it independently is a must have. - We are uncertain whether we need an inventory management system yet, so previous experience developing and implementing t...
MUST READ FIRST =============== MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST - Your price is the one that you REALLY want to have with 10% +- NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. - DO NOT APPLY if your fees can exceed 10% or your bid PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of...
I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-dri...
...months to 15 months Position open: 2 Data scientists Key Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Ability to handle a variety of data sizes and formats, as the size of the data may vary If you have previous experience in the trading industry and can confidently handle data analysis and visualisation, this opportunity is perfect for you. Your work will play a vita...
I'm currently renovating a residential property that's under 1,000 sq ft. I'm seeking a professional engineer who can provide me with expert guidance and plans for the renovation. Specifically, I need your expertise in: - Foundation and Structural Area: I'd need you to assess the current structure, ensure it's sound and make recommendations for any necessary changes. - Electrical Systems: Help me design an efficient, safe electrical system for the property. - Plumbing and HVAC: Assist with the planning and implementation of plumbing and HVAC systems. Ideal candidates for this project should have experience in residential projects, particularly in renovation, and be familiar with local building codes and regulations. A good understanding of cost-effective yet qua...
...few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard wor...
...Standardization: Perform equivalences to standardize information received from APIs. 4. Simultaneous Search in Multiple APIs: Activate search across all configured and active APIs with clear indicators of success or error. 5. Results Visualization: Display results in a table viewer for easy comprehension. 6. Temporary Data Storage: Save information in memory and delete it when performing a new query. Technical Requirements: 1. Experience in frontend development with AngularJS to create interactive interfaces. 2. Proficiency in backend development with Java or Python for handling API requests. 3. Ability to implement temporary storage systems in memory or cache for sensitive data. 4. Capability to create files for automatic deployment in Lambda functions, Docker containers, or a...
...Standardization: Perform equivalences to standardize information received from APIs. 4. Simultaneous Search in Multiple APIs: Activate search across all configured and active APIs with clear indicators of success or error. 5. Results Visualization: Display results in a table viewer for easy comprehension. 6. Temporary Data Storage: Save information in memory and delete it when performing a new query. Technical Requirements: 1. Experience in frontend development with AngularJS to create interactive interfaces. 2. Proficiency in backend development with Java or Python for handling API requests. 3. Ability to implement temporary storage systems in memory or cache for sensitive data. 4. Capability to create files for automatic deployment in Lambda functions, Docker containers, or a...
...this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with 4 models above and related dynamic visualizations. The text preprocessing is required and can be done in any necessary technologies (HADOOP/SPARK,NOSQL/SQL databases) - screenshots of the bash code are required....
As a burgeoning small business, I need a professional to create an E-commerce website for me. The design and functionality should resemble the clean and straightforward structure of amaryahenna.com. The purpose of this website is to sell my products online seamlessly. Key Information: - Type of Store: E-commerce - Volume of Products: Less than 50 items - Website Example: Site Requirements: - Intuitive navigation and easy to use checkout system - Mobile-friendly design - Product pages with high-quality images and detailed descriptions - Engaging and easy-to-update blog section - Basic SEO settings Missing Elements: - I have yet to develop a logo and complete brand identity, so your expertise will be crucial in this area. Ideal Candidate: - Proven experience with WordPress
I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.
I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.
I'm seeking a skilled .Net developer to assist in developing a comprehensive retail system that has features such as user authentication and authorization, inventory and product management. Requirements: - Proficiency in C#, .Net, Entity Framework and SQL Server - Ability to develop a retail project from scratch - Strong understanding of user authentication and authorization - Experience in inventory management and product cataloging It's crucial that the chosen freelancer has prior experience in building online retail systems and a strong understanding of the retail business model. The ideal candidate should be able to deliver a secure, efficient and scalable retail project. Any experience with Angular/react/Node would be plus
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 looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements. Thanks :
I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.
...completion) Whereby; candidates can create a profile upload their CV, images or link to images and videos recruiters can search CVs with a Boolean type search functionality & save searches. Candidates and recruiters can message each other. Admin can manage the back end. Suggested technical skill set but not a complete one… • Cloud-based server solution • Azure or Single server solution • MS SQL Database (NoSQL document database might be more appropriate?) • OAuth • Payment gateway • .net We suggest design led development process where we sign off the look and feel of the web pages… the back end is for the supplier to advise the best scalable solution for the application. Please send your credentials/ skill sets and cost struct...
...managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, menu, pricing, and location details. 6. Capture user profile data such as name, preferences, allergies, and delivery addresses. 7. Manage user records and orders in the backend. 8. Prompt new users to provide necessary details. 9. Facilitate dish selection based on user preferences. 10. Display sorted dish options in sets of four ...
...handle real-time data processing and CRM updates based on interactions within the app. Tasks: 1. Advanced Voice and Text Search Integration: • Enhance the app with both voice-to-text and text-to-speech functionalities for seamless user interaction. • Implement AI-driven prompts to help refine and perfect property searches based on user input. 2. MongoDB Integration: • Develop backend logic to query MongoDB effectively with parameters derived from GPT-processed queries. • Ensure real-time data fetching and updating capabilities. 3. CRM Integration: • Automatically populate CRM systems with details from interactions (both text and voice) conducted via the app. • Ensure data consistency and accuracy for effective client management. 4. Testing and Depl...
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 am seeking a skilled web developer with a proven track record to create my project. My aim is to develop an informational website targeting predominantly small business owners. The site needs to reflect a corporate style, echoing professionalism and reliability. Ideal Skills: - Strong command on website structuring for information accessibility - Knowledge of corporate aesthetic - Experience in creating websites for professional, business-oriented audiences Job Details: - Develop a visually appealing, corporate-styled website - Design site for easy navigation and efficient information dissemination - Ensure optimized site performance and responsiveness across devices - Implement SEO best practices for improved visibility. Please provide samples of your previous work, par...
Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL with experie...
I'm looking for a system that can help me generate donor communications more efficiently for Key Features: - **Email Automation:** I need to be able to send multiple emails at once to eligible donors. - **Scale:** Though my current requirement is for less than 100 emails at once, I would like the system to be scalable for future growth. - **Content:** The emails will mainly include multimedia content, like images and videos. Ideal skills and experience for this job: - **Email Marketing Expertise** - **Proficiency in Marketing Automation Tools** - **Experience with Multimedia Content in Emails** - **Understanding of Donor Outreach and Communication**
I am seeking a proficient Python programmer who can create a web scraper for Lazada. Key Responsibilities Include: - Develop a Python program that will enter query in search box and scrape Lazada for the following data: product name, images, price, description, seller, and URL. - The scraper should be able to handle pagination plus also bypass captcha using 2captcha api Ideal Skills and Experience: - Proficiency in Python and web scraping frameworks. - Familiarity with the Lazada's web structure and data extraction. - Experience creating scrapers for e-commerce platforms. Website lazada .
I'm looking for a talented appointment setter to help me schedule product demonstrations over the phone with small businesses. - Service Type: I provide phone services. - Target Audience: Small businesses. Your role would be to engage potential clients and set appointments for product demonstrations. The primary goal is to showcase the usefulness of our products. Ideal Skills and Experience: - Experience in telemarketing or appointment setting. - Strong communication and negotiation skills. - Understanding of the telecommunications industry is a plus.
Our company develops both desktop and web applications tailored for analysing insurance premiums. These have been developed in Delphi over the past 25 years. We are seeking to establish a long term relationship with an experienced Delphi programmer with exposure to Microsoft SQL databases. ASP.net application experience is also desirable. Our software packages require continued upgrading and enhancement and given the specialist nature of our software we are seeking to establish a long term relationship. The primary requirements include understanding our business process and system design, determining and articulating technical solutions, and implementing the design into build and install stages. Australian based is preferred, our principal office is based in Sydney NSW. If you...
I need a 3D model of a small-sized robotic forklift with moderate detail, including some mechanical elements. Make an image similar - but not identical - to this in the attachment
I'm looking for an experienced .NET developer to assist with a project. This project requires someone who has a strong background in .NET technology, particularly in C# programming, ASP.NET development, and SQL database management. Ideal candidates should have experience in developing web applications, creating software solutions, and improving existing systems. The key functionalities to be implemented by the .NET developer in this project include user authentication, data encryption, and payment integration. If you're a .NET developer with a solid understanding of the above technologies and functionalities, please reach out to discuss the project further.
...in need of an hacker to perform a thorough black-box penetration testing on my WordPress website. Key Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me to achieve this. Your keen eye and tech skills are ...
I need an experienced Python MySql backend programmer to provide support for a web app I'm building. The tasks will include: - Database design and implementation - Query optimization - Data migration - Hands on GoDaddy cPanel Hosting The web app will require the following functionalities; - User registration and authentication - A well-designed Customer Relationship Management (CRM) system - Data fetch by API and Post on API Ideal skills and experiences include Python, MySQL, backend development, and experience with implementing user registration, authentication, and CRM systems. Experience in web-based applications is crucial for this project.
I'm seeking a skilled Android developer to implement a reconfiguration of my app's UI with a fresh, Material Design approach. Key Responsibilities: - Reconfigure the layout of the app in a modern and sleek style, following Material Design principles. Ideal Skills and Experience: - Proven experience in Android UI development. - Proficiency in Material Design principles. - Excellent eye for aesthetics and design. - Strong communication skills. This project demands someone with a keen interest in design and user experience, who can bring a fresh and appealing look to the app.
...of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to automating daily database updates - Your estimated timeline for completing the pro...
Hello everyone! Looking for someone who can make quality detailed renders for a masters thesis paper. The project includes thatched roofs and earthy countyside atmosphere. The project focuses on using alternative natural materials for minimal CO2 footprint. So all the architecture is also kept very simple with tilted roofs and scandinavian forms. There are 7 small scale buildings in total. Location is in Estonian untouched nature, near lakes and rivers. Previous experience with rendering thatched surfaces is important. Same goes to rendering boats and water. Good eye for landscape architecture is a bonus. Very limited time frame (5-6 days). The work includes: 1 aero render of the whole harbour 2 close up renders exterior 1 interior render. Renders have to be very good quality,...
...focused on building brand awareness specifically tailored to small businesses. The website's foundational feature should be built around: * Easily accessible subscription form * Analytics dashboard * Template creation tool Despite these functionalities being optional, I'd highly prefer incorporating them to potentially maximize engagement and conversion rates. The ideal candidate for this project will have: * A strong portfolio of similar projects * Knowledge in email marketing trends and strategies * Experience working with small businesses * Proven understanding of UI/UX principles * Advanced web development skills including HTML, CSS, JavaScript and SEO principles In summary, this website should work seamlessly as a tool for small businesses to eff...
8oz Bottle Label Design for Small Pet Shampoo
I have a storyboard to turn into an Articulate Storyline module. The target audience: new employees of a company. They must follow e-learning introducing them to the fundamentals of Retail. Your mission will be to create some interactive sequences (characters who introduce themselves, an interactive timeline, etc.) and to make the Storyline module fun and pleasant to follow. I'm used to creating Storyline modules, but I don't have the time right now. I estimate the time to create this Storyline at around 3h30. My budget is limited to around 70 to 110 euros.
...pipeline type we want is Appsflyer (app) / GA4 (web) data -> GCP -> Big Query. I will briefly share the necessary information at this time, so please check it. 1. Copying (linking) AppsFlyer and GA4 data to GCP a. GCP is in a contracted state, and environment settings are required (security settings, etc. required) 2. AppsFlyer a. All data supported by AppsFlyer & Data Locker must be linked b. Both raw data and aggregate data must be linked (all data provided by AppsFlyer, including SKAN) 3. GA 4 a. GA 4 is contracted and also includes GA 360 integration b. Both raw data and aggregate data must be linked (including SKAN) 4. Common to AppsFlyer & GA 4 a. Must be linked to a table to be searchable in Big Query b. All periods of saved data...
Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's shor...
We are looking for very well organized & an ambitious self-driven Business Account Manager to join our team (Remote work) <<<<<< Your success measure would be the successful on-boarding of Startup/mid-size organizations every month & min 2 positions to be closed every m...proposition of through proposals and presentations to the prospects. Lead nurturing, engagement, and closing sales. Persuade clients to sign search contracts on an exclusive and/or retainer basis. Provide accurate and detailed forecasts on weekly/ monthly funnel of identified and proposed customers to meet and exceed sales requirements. Email coordination/timely update on whatsapp group by managing query flow of calls/emails/messages from candidate/internal team/clients. Stakeholder ...
I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.
I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm i...security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the peace of my server wor...
As a MongoDB Expert, my primary need is to work with someone who can assist with two key areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to unde...
I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table. Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.
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.
...continuously improve our data solutions Key Skills :- • Bachelor's degree in Computer Science, Information Technology, or related field. • 4-5 years of professional experience as a Data Engineer with a focus on Azure Databricks and Azure Data Factory. • Strong proficiency in SQL, Python, and/or Scala for data manipulation and scripting tasks. • Experience working with data lakes, data warehouses, and ETL processes. • Familiarity with cloud platforms (preferably Azure) and related services such as Azure Blob Storage, Azure SQL Database, etc. • Excellent problem-solving skills and attention to detail. • Effective communication and collaboration skills to work with cross-functional teams. • Azure certifications (e.g., Microsoft ...
need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a precise timeline has...
