Optimize sql queries punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
...Python coder who can develop a program that effectively reads numerous reviews and generates a concise summary, encapsulating the main points in 300 words in multiple bullet points. Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization or related projects is a de...
I'm in need of a professional who can review and optimize my .net Core 6 codebase, enhance the software architecture, and bolster the database security. Key Responsibilities: - Conduct a comprehensive code review to identify inefficiencies, bugs, and areas for improvement in the .net Core 6 code. - Improve software architecture to ensure scalability, maintainability, and performance of the application. - Implement robust measures to enhance the database security, in line with industry best practices. Ideal Skills and Experience: - Extensive experience in .net Core 6 and Entity Framework. - Proven track record of conducting code reviews and optimizing codebases. - Expertise in software architecture design and implementation. - Strong understanding of database security and exp...
I'm looking for an experienced Shopify developer who can help me set up an e-commerce store for my physical goods. Key Requirements: - **Shopify Account**: I currently ...experience with handling a large amount of products on Shopify. I plan to start with over 200 products. - **Design & Functionality**: I need the store to be visually appealing and easy to navigate for users. Skills & Experience: - **Shopify Expertise**: Proven experience in setting up and customizing Shopify stores. - **E-commerce Proficiency**: Understanding of e-commerce best practices and how to optimize for conversions. - **Large Inventory Management**: Experience with handling a website with over 200 products. If you're confident in your ability to deliver a high-quality e-commerce site o...
I am in need of an experienced performance marketer to boost sales conversions for my business. The ideal candidate will be able to focus on Search Engine Marketing and Social Media Advertising. Key Responsibilities: - Devise and implement strategies to increase sales conversion rates - Manage and optimize Search Engine Marketing campaigns - Run effective Social Media Advertising campaigns targeting Millennials and Business Professionals Ideal Skills and Experience: - Proven track record in performance marketing, particularly in increasing sales conversions - Strong understanding and experience in Search Engine Marketing and Social Media Advertising - Ability to target and engage with the Millennial and Business Professional demographics - Excellent analytical and strategic think...
I am looking for a skilled social media marketer with a proven track record in managing and optimizing Facebook ads campaign. The main objective of the campaign is to drive traffic to product pages on my website. Key Responsibilities: - Conceptualize and design engaging and compelling Facebook ads suitable for a young demographic aged between 18-24 - Continuously monitor, analyze and optimize the ads for maximum website traffic The ideal candidate should have: - Extensive experience in designing and managing Facebook Ads campaigns - A clear understanding of the interests and behavior of the youth demographic - Proven ability to drive website traffic through these campaigns.
I'm looking for a skilled designer to optimize my existing Amazon product image, focusing on product placement adjustments. - Your role primarily involves adjusting the product's location within the image to create a more professional appearance and improve its visual impact. - I envision the product to be centered with increased space around it, which plays a crucial role in enhancing its overall visibility and attractiveness to customers browsing Amazon. Key Skills: - Proficiency in graphic design software - Understanding of e-commerce design principles - Experience with Amazon product image requirements - Ability to enhance product visibility and conversion rates
...It is imperative that the provided services are 100% accurate, as the questions and answers will undergo client verification. Therefore, thorough double-checking of work before submission is mandatory. Communication and Updates: The hired individual must commit to providing daily progress updates, preferably in the morning during Indian working hours. Prompt communication is essential, and any queries or concerns should be addressed promptly. Availability: The selected candidate should be available consistently during Indian working hours. Unforeseen circumstances such as internet disruptions or power outages should not hinder communication or progress. It is essential to ensure uninterrupted availability throughout the duration of the project. Agreement to Terms: Before comme...
I am in need of a robust and efficient inventory management system made in Excel. This project requires: - Tracking of product quantities and managing stock levels to ensure seamless operation - Cataloguing of each product's relevant information including its name, SKU/Part number, quantity, batch number and expiry date - Methods of up...updating system quantities should be manual entry and bar code scanning. Knowledge in these methods is required. Ideal candidates should have extensive experience in Excel and inventory management system creation, preferably with a sound understanding of retail or related sectors. They should also be adept at implementing bar code scanning into Excel systems. Sharp attention to detail and ability to optimize for efficiency and usability is ...
...2. Design Requirements: Color Scheme and Logo: Use the colors specified in the CD manual and integrate the logo to strengthen brand identity. Font: Consistent use of the Gotham font for text elements to maintain a uniform appearance. Layout: Clear, user-friendly navigation with a main menu bar that includes pages for "Home," "About Us," "Services," "Contact," and legal pages. Responsiveness: Optimize the website for all device types to appeal to a broad user base. 3. Technical Requirements: CMS: Use WordPress (or others) with appropriate security plugins and regular backups. Hosting and Domain: Recommendation for reliable hosting that meets web traffic and data security requirements. Privacy and Security: Setup according to Swiss data pr...
I'm in need of an expert to set up SQL Server 2019 on a Windows-based virtual machine. The system will be used to support website and desktop applications. Key Responsibilities: - Configuration of SQL Server 2019 on a Windows virtual machine - Ensuring secure and optimal performance of the system - Testing the setup to confirm seamless connectivity with website and desktop apps Ideal Skills: - Extensive experience in managing SQL Server 2019 - Expertise in Windows OS and virtual machines - Should have strong troubleshooting skills on SQL server - Familiarity with website and desktop app integrations.
Excited to work with an experienced ASP.Net webforms developer, who will bring their skills to facilitate the Database integration aspect of our project. Key Responsibilities: - Integrate SQL Server with our existing ASP.Net project. - Create smooth and efficient functionality. - Ensure system robustness and efficiency. Skills and Experience: - Strong proficiency with ASP.Net Webforms. - Knowledge and hands-on experience working with SQL Server. - Excellent troubleshooting capabilities. It is not necessary for this project to migrate data from an existing database to SQL Server. However, the capability to do so may be beneficial in the future. If you are an experienced developer with the aforementioned skills, I would love to have you on board for this project....
...user experience and allows for easy sharing on social media. While the specific functionalities for this feature are not yet determined, I need you to propose and implement industry standard features that will make our URLs effective and user-friendly. - Creating a webpage that adheres to the best SEO practices. The webpage should include essential features such as meta tags and heading tags to optimize our search engine visibility. Your goal is to improve our ranking and online presence through the webpage. - Design and implementation of an OGP markup template and a custom teaser component. This requires overlaying the core component using a data layer. You are expected to create a captivating and innovative teaser component that drives user engagement and interest in our cont...
As a senior web engineer, I need assistance with an older React project that is currently on hold. The main goal for resuming this project is to modernize the application's user interface and optimize its performance. Key Requirements: - Experience with old React projects and updating them to the latest React version - Proficiency in improving scalability and performance in React applications - Ability to modernize a user interface of an existing React project Your contribution will be crucial in getting this project back on track and making it more efficient and user-friendly.
As an ecommerce business, we aim to boost our physical product sales through effective affiliate marketing. We're specifically targeting consumers and seek a savvy marketer with solid knowledge and experience in affiliate marketing, specifically within social media. Your tasks are as follows: - implement successful affiliate marketing strategy on social media (Instagram). - Establish and optimize affiliate relationships within the consumer goods industry. - Leverage social media platform to strengthen our brand and drive sales. Skills and qualifications: - Proven experience in affiliate marketing or able to learn . - Strong understanding of social media (Instagram) . - Excellent communication and relationship-building skills.
I am in need of a proficient individual Java developer ...efficiently. - Proficient socket management. - Ensuring the stability and reliability of the system under high data volume processing. Ideal Skills and Experience: - Expert level of experience with Java Netty framework. - Proven track record in handling high volume TCP connections. - Previous experience in real-time data processing systems. - Strong understanding of socket management. - Ability to optimize system performance and reliability under high volume data processing. Your understanding and experience with Java Netty framework, coupled with your expertise in high volume TCP connections and socket management, will be critical in the successful implementation of this project. Please only apply if you have the required ...
I'm looking for a skilled individual who can manage our TIKTOK account to increase brand awareness. please start with checking Key Responsibilities: - Creating en... Key Responsibilities: - Creating entertaining content on a daily basis - Monitoring and engaging with the audience - Ensuring brand consistency in all posts Ideal Skills and Experience: - Proven experience in managing TIKTOK accounts - Strong understanding of social media and content creation - Creative mindset with a knack for entertaining content - Ability to analyze and interpret data to optimize content strategy - Excellent communication and engagement skills to interact with our audience. Please share your relevant experience and the strategies you'd utilize to boost our brand's presence on TI...
I'm looking for an experienced chatbot developer who is certified with uchat to create a chatbot that will primarily focus on process automation. The chatbot should possess the following features: - Natural language processing to understand and respond to user queries effectively - Integration with the uchat platform for seamless operation - Customizable responses to cater to specific needs and scenarios User interaction will involve both text-based and voice-based communication. The primary goal of this chatbot is to automate various processes. This will require complex logic and an understanding of the business needs behind the processes being automated. Ideal candidates for this project will have: - Proven experience in creating chatbots with natural langu...
I am in need of a web speed expert, specifically someone proficient in optimizing loading times. My site currently loads in less than 3 seconds, which is just not up to par with my standards. Key Requirements: - to achieve passing grade for LCP, FCP ,CLS and TTFB - Pinpoint the images causing the most significant load times and offer optimized solutions. - Suggest best practices for other on-page elements affecting website speed. The ideal candidate will have proven experience in improving website speed, specifically regarding image optimization. All detailed reports, including improvements made and those suggested for the future, need to be shared at project completion.
...quality Executes work efficiently and meets agreed on deadlines Completes most development activities independently Requirements Core Requirements: Strong background in data warehousing concepts, ETL development, data modeling, metadata management and data quality Strong knowledge of SQL running on SQL Server, MySQL, and Snowflake including but not limited to: extensive experience working with complex stored procedures, table definitions, and a proven track-record of performance optimizations and troubleshooting of SQL logic. Proficient at C# running on .NET Core and/or other similar .NET frameworks including but not limited to: writing Unit Tests and implementing algorithms and data structures Strong hands on experience in Microservices, RESTful webservices devel...
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
I have a virtual private server (VPS) running on Linux which is experiencing high CPU usage. This is bogging down the performance of the system and creating a productivity bottleneck. Job Scope: - Analyze the reasons for the high CPU usage - Implement efficient solutions to reduce the CPU usage without compromising on essential processes - Optimize the performance of the system - Establish measures for consistent monitoring and preventive maintenance Ideal skills: - Expertise in Linux server management - Proficiency in performance optimization strategies - Experience in IT troubleshooting and problem-solving - Knowledge of server security strategies - High attention to detail If you have the necessary skills and experience to resolve this server speed issue, I invite you to ...
Hello, guys, I am looking for someone to optimize my web site, for good Google rankings.
I'm looking for a skilled business developer who can assist in turning my idea for a brain computer interface device into a marketable product. Key Requirements: - **Market Research**: You'll need to conduct thorough market research to understand the competitive landscape and identify potential target markets. - **Business Development**: Lev...Focus Analysis: Evaluate and report on user focus levels during specific tasks, aiding in task optimization. Healthy Habit Building: Utilize ML and AI to provide personalized recommendations for cultivating and maintaining healthy cognitive habits. By addressing the current void in tools for monitoring and improving cognitive well-being, this venture seeks to empower individuals to understand, optimize, and maintain their mental c...
I am looking for an exceptional web developer who can create an informational website aimed at the general public. I have all the necessary content available, and I need someone who can perfectly input this content into a sleek, easy-to-navigate design that will engage and...relevant programming languages * Experience in designing and developing websites with a clear and engaging interface * Strong comprehension of UI/UX design, making sure the website is user-friendly for the general public * Proven track record in efficient project delivery * Ability to adhere strictly to my branding and design guidelines. Lastly, I need you to make the website responsive and optimize it for search engines. Please, only bid if you are capable and willing to put forth the effort to meet these exp...
I am looking for a professional who can help me optimize my LinkedIn profile for better job opportunities within the technology sector. Key Aspects for Improvement: 1. Profile Photo and Header: The first impression is crucial, and I believe my current photo and header may need an upgrade to attract the right attention. 2. Summary and Experience Descriptions: These sections need to be refined and tailored for the technology industry to ensure they are appealing and relevant to potential recruiters. 3. Skills and Endorsements: I want to ensure that the skills listed on my profile are well-represented and endorsed, giving a true reflection of my capabilities. Ideal Skills and Experience: - Proven experience in LinkedIn profile optimization, particularly in the technology sector. - St...
E-comerce hecha con React, Tailwind CSS , Framer Motion y cuenta con un chatbot con IA como asistente virtual En el Backend cuenta con una base de datos SQL y node Js y Javascript para la conexión a la BD Tiene una auténticacion de usuarios Y cuenta con integración a MercadoPago
I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.
I'm in need of a skilled professional to create a chatbot whatsapp business integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the
I'm looking to create an application using NoCode developmen...credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skilled with NoCode tools, specifically Bubble and FlutterFlow, has implemented email/password user authentication before, and has experience with SQL Server database management. Please contact to get more deta...
...levels. Specifically, we need a detailed chart that outlines the weight percentage of each component to be added at specific temperatures to achieve optimal cure time. Optimization of MEKP usage and formulation of the cobalt accelerator will lie in particular focus throughout the mission. Ideal candidates should carry substantial prior experience in this domain and demonstrate a keen ability to optimize industry-standard processes, thereby achieving significant waste reduction....
...proposal for your monthly price, we are wanting to find a full-time person who can join our team . We're on the lookout for a skilled HubSpot Automation and Integration Expert to join our team. Responsibilities - Manage and ensure the cleanliness of databases across various clients. - Handle API integrations and effectively connect various systems to HubSpot using tools like Zapier and Make .com. - Optimize HubSpot objects and automate processes, including form submissions that trigger deal creations and associate contacts. - Develop and manage workflows and lifecycle drip email campaigns tailored to different client needs. - Oversee the creation and analysis of custom reports for diverse clients. - Manage sales pipeline visualization and adjustments for various projects. -...
Looking for a web3 AI bot theme of sleek and techy website and logo to be design on Canva Pro. Key requirements: - Must be design on Canva Pro - Web3 AI Bot theme - No coding, no html , intuitive informational website - Design catchy logo with icon In your bid, to showcase following. Cookies cutter bid wi...sleek and techy website and logo to be design on Canva Pro. Key requirements: - Must be design on Canva Pro - Web3 AI Bot theme - No coding, no html , intuitive informational website - Design catchy logo with icon In your bid, to showcase following. Cookies cutter bid will be declined - Previous experience designing AI Bot theme on Canva Pro - Strong graphic design and UI/UX skills - Ability to optimize for mobile devices - Portfolio showcasing creativity and modern design ...
I want to... Features: * E-mail me the Lead with all information collected * Save in Google Sheets as a database * Main thing is to have it look nice and don't look out of place, similar font style, sizing, font size, etc * Use embed code to copy and past into my page builder * Create a plugin to help me customize the quiz, like images, text & size, etc. Desired Programming Language: PHP / SQL * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Complete, After any Bug fixes, and Updates ⭐⭐⭐⭐⭐ Please post "I've read everything" when applying to be considered, too many bots applying. Failure to do this step, you will not be contacted ⭐⭐...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Ex...experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, a...
I am in need of a professional who can significantly optimize a batch of pictures for my Instagram social media account. My primary requirements include: - Increasing the contrast of these images to accommodate Instagram's visual aesthetics. - Enhancing specific facial expressions in the photos and other minor brush-ups The ideal freelancer for this task should possess excellent photo editing abilities and have a keen eye for details. An in-depth understanding of how Instagram optimizes images would be a great advantage, though not mandatory. The overarching goal is to significantly increase the visual appeal of these images for my Instagram viewership. Please include work samples of similar jobs you've done before in your proposal.
I'm looking for a digital marketing professional with a focus on social media, specifically Instagram and LinkedIn. My primary goal is to increase brand awareness for my company. The ideal candidate should: - Have experience in creating engaging image-based content for Instagram and LinkedIn. - Be able to build and execute a strategy that enhances our brand's visibility. - Leverage analytics to optimize performance and growth across platforms. Please, include examples of past work and results in your proposal.
...implimentation support around process documentation, training and setting customisation/set up. Your role will be critical in ensuring our team can effectively utilize our ERP. Key Responsibilities: - Review current implementation of Dynamics 365 and identify gaps in use and documentation - Provide process documentation framework for all tasks and actions - Suggest changes to process or setting to optimize system - Provide comprehensive training on the use and functionality of the Microsoft Dynamics ERP system - Ensure all team members, end users particularly, understand and can navigate the system post-training Desired Skills and Experience: - Prior experience in Microsoft Dynamics 365 ERP, implementation - Deep understanding of ERP systems, with emphasis on finance-related f...
...Metadata-Driven Architecture: The database tables' metadata will be managed externally and stored in and dbo.DataColumns. The API should be capable of reading this metadata to construct and manage API endpoints dynamically. 4. ORM Flexibility: Any ORM tool like Entity Framework, Dapper, or SQLkata can be utilized to facilitate database operations. The choice of ORM should align to optimize performance and simplify maintainability. 5. Advanced Data Handling: Column Selection: API users should be able to specify which columns to retrieve in the query. Filtering and Sorting: Support comprehensive filtering and sorting capabilities to navigate through data efficiently. Pagination: Implement pagination to handle large datasets effectively. Aggregation...
For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.
E-Commerce Site Development with PayPal and Stripe Integration ...essential that the site is designed to allow easy updates and additions to the product catalog. Ideal Skills and Experience: - Proven experience in e-commerce website development, particularly for small to medium-sized businesses. - A strong background in using and integrating payment gateways such as PayPal and Stripe. - Solid understanding of user experience (UX) and user interface (UI) design to optimize the site for conversions. - Ability to create a content management system (CMS) that's intuitive and efficient for managing product listings. - Excellent communication skills to ensure a smooth collaboration and the ability to implement feedback effectively. *Skills Required PHP Website Design Shopping Carts ...
I'm seeking an expert to optimize my Revolution Slider for mobile devices. - The primary issue I'm facing is the slider's lack of compatibility with different screen sizes. - I'd like to prioritize adjusting the content scaling and layout, to ensure the slider looks great and functions well on mobile. - The slider should support a mix of both dynamic content and static images. The ideal candidate for this job should have: - Extensive experience with Revolution Slider, especially in optimizing for mobile - Strong knowledge of responsive design and mobile UX - Ability to work with a mix of dynamic and static content. If you're confident in your ability to make my Revolution Slider look and work perfectly on mobile, I'd love to hear from you.
I'm looking for a talented Metaverse Expert with a strong background in 3D modeling. Key Responsibilities: - Create captivating 3D models for a Metaverse project - Collaborate closely with the team to ensure the virtual environment aligns with the concept - Optimize designs for performance and user experience Ideal Candidate: - Proficient in 3D modeling tools and techniques - Previous experience in creating assets for virtual environments - A solid understanding of mesh optimization and texturing for performance - Strong communication skills and a collaborative mindset If you're excited about the potential of the Metaverse and have a knack for creating immersive 3D environments, I'd love to hear from you.
...looking for a skilled and experienced marketing professional to help create and manage an Amazon ads campaign in the European region. Key Project Details: - Target Region: Europe - Main Goal: Increase product sales - Preferred Amazon Ad Type: Sponsored Products Key Responsibilities: - Create and manage a comprehensive Amazon ads campaign targeting European customers. - Regularly monitor and optimize the campaign to ensure maximum effectiveness in boosting sales. - Provide detailed reports on the campaign's performance, including key metrics like click-through rates and conversion rates. Ideal Skills and Experience: - Proven track record in successfully managing Amazon ads campaigns, especially in the European market. - In-depth knowledge of Amazon's advertising pl...
...schematic designs for commercial, residential, and institutional and healthcare projects an asset. Your role will involve: - Designing electrical design and schematics for commercial spaces including but not limited to office spaces, retail stores and restaurants - Creating detailed layouts that ensure safety and comply with all electrical codes and standards - Conducting thorough load analysis to optimize electrical system performance Having previous experience in electrical design will help to better understand the job requirements and deliver high-quality results. This project involves all aspects of electrical design including residential, commercial, healthcare, and institutional applications. Therefore, the ideal candidate should also have a diverse level of knowledge...
I'm looking for a Control Engineer with proficiency in Matlab to help with a project focused on modeling and simulation. The primary goal of this project is to optimize the performance of a system. Key requirements and responsibilities: - Expertise in modeling and simulation within Matlab - Background in control engineering - Ability to analyze and understand system behavior - Create and implement strategies to enhance system performance - Strong communication skills to collaborate on project goals and updates While the type of system to be optimized hasn't been specified by the client, experience with mechanical, electrical, or hybrid systems would be a plus. Your expertise will be crucial in ensuring the successful optimization of the system.
...should scan the website and extract relevant data for processing. * Extracted data should be stored in a database for future reference. AI Model Integration: * The application should integrate with an AI model capable of answering questions based on the scanned website data. * Preferably, use a free or cost-effective AI API for this purpose. * The AI model should provide accurate responses to user queries based on the scanned website data. Chatbot Integration: * Develop a chatbot feature that can interact with users and provide responses using the AI model. * The chatbot should be modular and easily integratable into other websites as a microservice. * Integration should be seamless with popular website platforms like WordPress, Drupal, etc. User Interface: * Design an intuiti...
