Sql query to search for a string in a table jobs

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate...

...all to be done on a new Linux STAGING ONLY server. 1) Linux staging server setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is criti...

I'm in need of a Google search expert to help with keyword research and ad campaign management. Key Tasks: - Keyword Research: The primary goal of this research is to increase website traffic. The expert should be able to identify high-performing keywords for our industry. - Ad Campaign Management: The target audience for these campaigns are national customers. The expert should be able to set up and manage effective campaigns on Google. Ideal Skills and Experience: - Proven experience in keyword research and search engine optimization. - Track record of successful ad campaign management, particularly for national audiences. - Knowledge of Google's advertising platform and its functionalities. ...

...PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full ...

...Description Objective: Conduct a detailed analysis of several 3D planner software platforms to compare their offerings and pricing structures. The goal is to provide a comprehensive, visually appealing summary that highlights key features, subscription plans, and costs associated with each software. Scope: Competitors: The platforms to be analyzed include Saninet 3D Planner, MATICAD DOMUS3D, PALETTE CAD, TILE LOOK, VISOFT, and SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for n...

I'm looking for someone experienced in cleaning out toxic backlinks from my website. The main goal is to improve the website ranking. This task is quite urgent and needs to be completed within a day. This is a 1 hour job! Full video here explaining the job This job will also lead to other jobs, such as ranking our website, high DR backlinks, blogging, creating pages to rank for easy keywords, running keyword reports, etc. I will only respond to offers that have confirmed they have watched the video. I will not answer bot responses. Key responsibilities include: - Utilizing SemRush to identify toxic backlinks - Compiling the list of toxic backlinks in a notepad for Google Disavow back...

I need a proficient Microsoft Word expert to design a comprehensive report template that contains all the requisite sections for a detailed report. The ideal freelancer for this project should have: - A solid understanding of Microsoft Word. - Previous experience in creating professional templates or reports. The key sections that the report template should include are: - Title page - Table of contents - Introduction - Body - Conclusion - References Each section should be clearly defined and easy to navigate. For the title page, it should encompass the following elements: - Project title - Client's name - Date - Project logo - Project description - Title block I require standard formatting and styling ...

Graphic Design for 3m x 3m gazebo and a 1.8m long table table cloth Looking to use the attached logo in the middle of the designs This will be for a NAIDOC event (please google NAIDOC week to get an idea of what this means) Australian Indigenous designs/ patterns with reds, oranges and yellows Thank you.

We are seeking a Flask (Python) developer to set up a dashboard for our project using the following template: Please provide a quote for this job and an estimated timeline for completion. Objectives: We need a small application to facilitate user onboarding for our messaging bot. The dashboard will manage new user onboarding and offer basic administrative features. Dashboard Pages: • /signup • /signin • /forgot-password • /reset-password o Authentication logic with two roles: user and admin o Forget / Reset password logic required • /home o Accessible to logged-in users only o Displays bot updates and useful links o Updates data retrieved from the database • /profile o Accessi...

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments)...

...seeking a proficient developer to create a search engine for CommonCrawl.org. The primary goal of this project is to ensure better search accuracy through the implementation of advanced search filters and relevant sorting of search results. Key Responsibilities: - Develop a search engine with advanced search filters for enhanced user experience. - Implement relevant sorting of search results to enable users to easily find what they're looking for. - Ensure the search engine provides search results in both list view and grid view, offering users flexibility in how they interact with the data. Ideal Skills and Experience: - Proficient ...

I am looking for a freelancer who can help me automate my web search for bid opportunities (RFPs) for my telecom company. Currently, I rely on searching manually, but this process is time-consuming and not as efficient as I'd like. Key Project Requirements: - You will be responsible for setting up an automated search that looks for RFPs related to "fiber optic" or other telecom-specific keywords, which are due every May 2024 or similar queries. - This automated search needs to run every 2-3 weeks, ensuring that I stay up-to-date with new bid opportunities and future due dates. - You should have a deep understanding of web scraping and automation to accomplish this task. Ad...

I'm in need of a skilled video editor who can help me bring my creative stories to life. I have some great ideas that I want to turn into engaging videos, and I need someone who can help me with this. Key requirements: - Proficient in video editing software - Ability to turn raw footage into a polished, engaging final product - Creative and able to bring fresh ideas to the table - Strong storytelling and narrative skills - Experience with editing videos longer than 5 minutes If you have a keen eye for detail, a passion for storytelling, and enjoy bringing creative ideas to life, I would love to work with you on this project.

I'm looking for a skilled wix web developer to create a booking page for an existing flight booking website using Wix. This project will involve the following modifacations: - Add a searchbar in homepage - Redirect to all flights page upon search - Book and pay directly using wix payment gateway.

I need an experienced SEO strategist to help me increase traffic to my website. I'm looking for someone with extensive experience and strong professionalism. If the results are significant, we are open to long-term collaboration.

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedur...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performanc...

I am in search of an experienced email marketer who is proficient in Klaviyo. My email list currently exceeds 10,000 subscribers and my main goal is to boost product sales through strategic email campaigns and flows. Note we are an established brand so do need for basic flows. Key Responsibilities: - Develop and execute effective email marketing strategies to drive product sales - Ensure high deliverability and open rates - Create and optimize email templates for maximum engagement - Monitor and analyze campaign performance, making data-driven adjustments as needed Skills and Experience: - Proven track record of success in email marketing, specifically with Klaviyo - Prior experience working with large email lists - Strong understa...

I'm in search of a full-stack developer to join me in building a scalable, multi-tenant web application. The project requires expertise in Golang and React for back-end and front-end development, respectively. Ideal Candidate: - Proficient in Golang, JavaScript (React) - Skilled in Cassandra, OKTA - Experience with Docker, Kubernetes - Familiarity with Google Cloud Platform -Apply with Github and sample projects The project entails creating a robust, multi-tenant web application that can handle multiple users with varying requirements. It is imperative that the selected developer is competent in ensuring the application's scalability and reliability. If you have previous experience building simi...

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the ...

...am in need of an experienced web developer who can effectively redirect 6-10 newly acquired domain names to my main website. The purpose of this redirection is primarily to consolidate my online presence, thereby increasing the reach of my brand. The successful applicant should be proficient in: - Domain management and redirection - Implementing SEO-friendly redirects - Providing individual traffic metrics for each domain redirected Your responsibility will include setting up the redirections in a manner that optimizes search engine visibility as well as providing a way to track the traffic from each individual domain separately. The aim is to gather data on the effectiveness of our domain strategy. Proven ...

...assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered ...

Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people ...

...looking for a skillful interior decorator to revamp my living room into a modern and eye-pleasing space. My aim is to achieve: - A stylish and pleasant ambiance in line with current trends. - Intelligent furniture layout. So this living room will now serve as a bedroom/living room. Hence efficient furniture planning and save spacing furniture is a must. - Innovative inclusion of freestanding bookcases, and storage ottomans or benches that are both aesthetic and practical. - I would also need a wardrobe to store my clothes and suitcases, a large table(which would have a monitor + laptop on it along with my keyboard and mouse - Right now my living and dining area are connected, I would like...

I'm on the lookout for experienced professionals to build a comprehensive ecommerce platform for my services. We'll have to move quickly, as I need this project completed as soon as possible. Here are some specifics: - The platform will be primarily used for selling services. - Since I opted to skip the question about service categories, I am open to any skill sets you might bring to the table with regards to diverse service offerings. - Rapid response and fast development timelines are crucial for this project. Ideal candidates for this job should have: - A strong background in ecommerce development, specifically focused on service platforms. - Proven track record of del...

I'm in need of a minimalist logo for my tailor shop. The ideal candidate should be able to design a modern, simple logo that captures the essence of my business without any excessive elements. Key requirements: - Experience in creating minimalist logos - A portfolio that demonstrates an understanding of modern design and brand representation - Ability to deliver a versatile logo that can be used for both online platforms (like the website and social media) and traditional print materials (such as business cards and brochures). I'm looking for a professional who can bring their creativity and expertise to the table. A strong sense of aesthetics, combined with an understandi...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting ...

...seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note ...

I'm looking for an experienced PHP developer who is well-versed with MySQL to help me with editing the search module of my website. The primary focus of this project is on modifying the way images are retrieved then displayed in the search results. Key Requirements: - Modify the retrieval of images in the search results to use URLs for specific sizes as opposed to the current methodology of storing images locally and then displaying. - No specific enhancements are needed for the image thumbnails, just an adjustment in the retrieval and subsequent display methodology. Ideal Skills: - Proficiency in PHP and MySQL - Experience with implementing search modules in web development - F...

...verification process is incomplete. I'm looking for a freelancer with the right skills to assist me in resolving this issue. Key Requirements: - Diagnose the source of the issue: Identify why the error message isn't displaying, even after the update. - Resolve the issue: Implement a solution that will allow for successful verification with Google Search Console. - Test and validate: Ensure the verification process is successful and that the error message is correctly displaying. Ideal Candidate: - Experience with Yoast SEO plugin: Proven track record of working with Yoast SEO and fixing similar issues. - Proficient in Google Search Console: Understanding of how Google Search Console works and how to...

Google Search Ads Cold Traffic Analysis - Select best countries and why - budget requiremetns - KPIs to follow

...looking for an experienced Azure Analytics specialist who could coach me in the areas of Data Analysis and Data Visualization. The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in progr...

As we are Manpower Supply Agency, We would like to incorporate attendance day to day entry of our workers from this info we would like to automate payroll, billing and Government salutatory. and also a dashboard for overall performance of our agency. Skills and experience: - Human Resources and Employee Management expertise - Ability to create user-friendly interfaces - Experience with Single Sign-On (SSO) integration and other login methods - Capable of adding features like search functionality, photo upload, and editable fields - Excellent communication skills to understand our needs and translate them into a functional system.

I'm looking for a skilled professional who can assist me with my Air Table. Key Responsibilities: - Create Airtables - Customize Air Table views and filters to maintain a clean and minimalist look. - Create automated search workflows to improve team collaboration. Ideal Skills & Qualifications: - Proven experience in working with Air Table and customizing views. - Proficiency in setting up automated workflows that enhance team collaboration. - Ability to understand and implement a minimalist design approach. Your experience in creating automated workflows and customizing Air Table views is crucial. Please share your relevant past work and suggest how you'd approach ...

LegalSearch aims to be an artificial intelligence-based application that enables effective search and analysis of legal decisions. This application aims to provide users with fast and accurate access to information in legal documents by using OpenAI's GPT integrated search engine. LegalSearch aims to be a valuable resource for legal professionals, students, and general users. Objectives and Benefits: Save time and effort with effective search of legal decisions and documents. Accelerate legal research processes and support decision-making. Facilitate users' access to accurate and up-to-date information in the legal field. Assist legal professionals in their analytical work to...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. E...

...looking for an SEO person who has worked for Off-page SEO including Profile link building, social media bookmarking, local citation, and related. I want to create around 100 profile links for one of my money site. You will be given all required details to create profile that given below. - Email address and password to create profile - Name - Bio - Address - Profile Image - Money website address Requirements: - Should have knowledge of Off-page SEO - Should be able to create profile links in bulk - Should be able to create different variations to prevent duplication Key Responsibilities: - Create profile links with given details - Create a table with the created profile link URL (I will provide the ...

I will create and enable "Custom Search Feature" in Google Adsense.

I'm looking to improve search engine rankings for my website from Quora, specifically focusing on technical topics. Key Requirements: - Promoting technical content: The answers should be SEO-optimized for technical topics, with relevant keywords and phrases. - Linking to my website: The answers should also include links to my website for more information, without appearing spammy or overly promotional. -Most Searched Questions About Dry Fruits Ideal Freelancer: - Experience in Quora SEO: I need someone who knows how to optimize Quora content for search engines effectively. - Technical background: A background or strong understanding of technical topics will be a big plus for this projec...

In order to realize the scientific research project of "International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query...

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: - Inventory management: Ensuring that the software effectively tracks the inventory of returned products - Reporting & Analytics: Enhancing the software's capability to generate insightful reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose of thi...

I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large data sets.

Hi, Nee one simple PhP,MySQL app which will prompt/require for Document-URL: and extract all the short abbreviations inner in (....) from entire document(with PDF,...extensions). The report/result will like this table with 2 columns: sentence | terms-founded | string of terms | check-selection | button "do-it" Then I will select the terms by checking and then I will press the button "do-it" and the selected terms founded between (...) will be savet into MysQl Table. So for Document-URL: this is simple example of line from this report -sentence: "With the deployment of

I'm looking for a talented game developer to create a captivating word search game for mobile platforms, specifically iOS and Android. This game is intended to be highly detailed and animated, so experience with creating visually engaging mobile games is a huge plus. Key Requirements: - Development for Mobile Platforms: The game should be compatible with both iOS and Android, ensuring a wide audience reach. - Visual Excellence: The game is expected to have highly detailed and animated graphics. A strong portfolio showcasing similar work would be highly beneficial. Optional Requirements: - Social Features: While I'm open to the idea of incorporating social features within the game such a...

I'm in need of a skilled social media professional who can help me establish a strong online presence across Facebook, Instagram, TikTok, and Google. Key Tasks: - Create Facebook, Instagram, and TikTok pages from scratch, ensuring they are optimized for maximum engagement and visibility - Generate high-quality, attention-grabbing videos and photos to post on these platforms - Develop a content strategy that aligns with my objectives of increasing brand awareness, engaging with customers, and driving traffic to my website - Attract and engage with a target audience of young adults, adults, and businesses Skills: - Proven experience in creating and managing social media accounts across various platforms - Proficiency i...

I am Shoaib Akhter, a skilled video editor specializing in basic video editing. I'm seeking a professional to help enhance the quality of my personal vlogs through editing. Key Requirements: - Basic video editing expertise: I need someone with a solid foundation in video editing techniques to help enhance the overall quality of my content. - Understanding of personal vlog content: Experience in editing personal vlogs is a plus. You should be able to maintain the authentic and personal feel of the videos while enhancing their visual appeal. - Creativity: I need an editor who can think outside the box and bring fresh ideas to the table. I want my videos to stand out and engage my audience. Ideal...

I'm looking for a skilled interior designer who can help me transform my home into a combination of modern and ethnic (Indian) living space. The project involves designing five key areas: - Living Room - Kitchen - Bedroom - Bathroom - Study The ideal candidate must have a strong background in modern and ethnic Indian interior design and ample experience in transforming various spaces into sleek, contemporary environments. You should be able to bring fresh, innovative ideas to the table and harmoniously blend functionality with aesthetic appeal. A keen eye for detail, excellent communication skills, and the ability to understand and incorporate my preferences into the design are essential. If you have...

I'm looking for an experienced designer to create engaging and visually appealing banners and ad sets for my Web3 project. The main aim of this project is to drive traffic to my website. Key Requirements: - The banners and ads will be used across various platforms, including social media, search engines, and partner websites. Hence, they should be tailored to suit these different platforms. - The target audience for this project is primarily between the ages of 18-44, so the designs should be attractive and relevant to this demographic. Ideal Skills and Experience: - Previous experience in creating web banners and ads, particularly for diverse platforms and audiences. - A good understanding of Web3 p...

I'm in search of a Shopify expert, proficient in troubleshooting and SEO. Currently, I'm facing an issue where some of my products aren't appearing on Google despite optimizing my website. I'm not using any SEO plugins on my Shopify site and I manually enter product details, so I need a professional who can provide a solution to this issue and help boost my product visibility on Google. Key Responsibilities: - Troubleshoot and identify the root cause of the products not appearing in Google search results - Implement solutions to improve product visibility on Google - Provide expert guidance on SEO best practices for Shopify store Skills and Experience: - Extensive experience with Shopify tr...

You will need to visit and search for the following categories. Drainage Glazing repair Appliance repair Plumber Electrician Roofer Use the postcode W2 4DP After you have the search results You will need to open a google sheet and have the following categories Name of Business Website (you will need to find this either from checkatrade or google if you use google do not put LTD on the end) Companies house link for each business use this link The task is to complete 500 companies - please bid knowing this and only bid if you read the brief and understand it