Small sql query trabalhos

I'm seeking an experienced graphics designer, with a knack for bold and colorful designs, to create a captivating packaging for a small medical and sports support belt. I have attached a link for all key source for the design and reference for the box. Need source file with all the fonts and elements. need CDR DOCUMENT WITH the DIECUT frame guide. NEED to be curved every single element in the design. Use PRIMEOX planpro eps or cdr file for vector logo. If you have any questions, please dm me. Thank you! If you fit this description, I would love to hear from you. Please feel free to include any similar past projects in your bid. Thanks!

I need SQL server Export, Store Procedure expert developer

I am looking to take an exisiting Github Project and bring it up to date with a Web App Gui that can be self hosted. Current project is here : This project was originally written in Go and I want the new version to be self hostable. Functionality needed 1. Query DB for latest titles 2. User Can specify location of files 3. Using DB App will sort files / updates int sub folders etc. 4. Further functionality to be added later on.

As the driving force behind this project, I'm seeking a proficient Java Spring Developer capable of creating a compact web application. Primary Tasks: * Develop spring functionality * Having knowledge on old versions of spring and java * Good Communication This web application's main role should be collecting user file uploads efficiently and securely. Skills and Experience: Ideal freelancers will have experience with backend development, working with databases, and ensuring security in web applications, especially when handling user file uploads. Proficiency in Java Spring is a requirement. Kindly reflect this experience in your bid.

I am seeking an instructor who can provide beginner-level classes in Data Analytics - SQL, R, and Power BI. I'm looking for a commitment of 8 hours per week. Ideally, the candidate should have: - Previous experience in teaching or tutoring, particularly with beginner students - Proficiency in SQL, R, and Power BI - The ability to tailor lessons to my progress while also following a structured curriculum I speak Spanish and basic English ( So preferably someone who speaks spanish)

I'm seeking a skilled Python programmer to turn my code into an application. Key Specifications: - The purpose of this coding task is to create a...management. - Applicants should have comprehensive knowledge and applied experience with Python programming. - As the main objective is to develop a software application, freelancers should also possess a strong background in software development to ensure an efficient and robust system design. Ideal Skills and Experience: - Python Programming - Software Development - Data Management Systems - SQL - Building Robust Secure Systems - User Management - API knowledge Interested freelancers should explain their experience with related projects and outline their approach to this task. This will be a one month contract. With pos...

I'm looking for a professional expert skilled in malware analysis. Ideal skills and experience: - Proficiency in malware analysis and risk assessment - Expertise in diagnosis and resolution for windows-based issues - Vast understanding of coding and code analysis methodologies - Proven experience in behavior analysis of malware. - Reverse engineering.

...maker, who is experienced with designing and creating patterns for leather goods, particularly bags. Key Features Required: - The bag is to be in a modern design style, hence contemporary pattern making skills would be ideal. - It's a small-sized crossbody bag I am looking for. Therefore, the pattern needs to focus on size, ensuring it is compact yet functional. Skills and Experience Needed: - Expertise in creating sewing patterns for leather goods, specifically bags - Having a strong understanding of modern design aesthetics - Acquaintance with small-sized bag patterns and design - Strong attention to detail in designing patterns Looking forward to receiving proposals from designers who are knowledgeable in the current fashion trends and have a keen eye for d...

...thorough report documenting the findings. Key Tasks: - Perform penetration tests on my Windows VPS - Conduct vulnerability tests on installed Database systems and Custom software solutions - Compile a comprehensive report explaining test results Ideal Skills - Excellent knowledge and experience with Windows VPS - Proficiency in penetration and vulnerability testing - Proficient understanding of SQL Server - Proficiency with compiled ms access applications I'm open to working with professionals who have a methodical yet efficient approach to accomplishing these tasks. An ideal candidate would be receptive to my inputs, and meticulous in explaining complicated security jargon in simple terms. Your ability to communicate your findings with clarity and actionable solution...

I need assistance with entering less than 500 entries into a spreadsheet. The data is simple, requiring basic text entry with no additional research or verification necessary. The ideal freelancer for the job would be quick, reliable, and experienced with spreadsheet data entry. Details or instructions will be provided upon awarding the project. Efficiency and accuracy are key in this job; familiarity with Excel or Google Sheets is an advantage.

I have ongoing work related to our previous project 'Small Juice Box Artwork 3D / I will provide design'

I am in need of an experienced .NET developer with specific expertise in Xamarin, Blazor, HTML, CSS, C# and SQL for a web development project. The primary purpose of this project is to create a fully-functional, dynamic website that requires: - User authentication to control access to certain pages or features, - API integration to streamline functionalities and work with other applications, - Dynamic content update capabilities; changes to the web contents should be easy and efficient. The ideal candidate would be someone with a significant amount of experience navigating both back-end (Xamarin, Blazor, C#, SQL) and front-end (HTML, CSS) development in .NET environment. I need someone who can transform complex functionality needs into practical, efficient web solutions. ...

I need support for a task converting Crystal Reports into Telerik Reports in ASP.NET. I have al...all necessary Crystal Reports files (.rpt) on hand. Need atleast 2 years of experience in Telerik Reporting Key Components: - The original Crystal Reports contain complex formulas that must be fully incorporated during conversion. - The current data source for these reports is MS SQL Server and this needs to remain consistent. Ideal Experience and Skills: • Expertise in ASP.NET • Advanced knowledge of Crystal Reports and Telerik Reports • Understanding of complex report formulas(a must) • Experience with MS SQL Server. For a successful deliverable, all converted Telerik Reports should function identically to original Crystal Reports, with all special func...

Requiero una aplicación para manejar una base de datos en sql, que pueda hacer consultas y modificar valores. Sería una base de datos principal de 10 columnas y otras pequeñas anidadas, se trata de datos obtenidos automáticamente en una línea de Produccion. El programa es libre, puede ser una aplicación web o en .Net por ejemplo.

...freelancer skilled in Power Query for some targeted tasks. These tasks include: 1. Data Cleaning and Transformation: I need assistance to clean and transform my data ensuring its integrity, relevant, and useful for further analysis. 2. Data Merging and Consolidation: I have different datasets that need to be merged and consolidated. The goal is to improve data accessibility and usability in analysis. 3. Data Modeling and Analysis: After cleaning and consolidating, I would like the freelancer to insights from the data through data modeling and analysis. 4. Custom Functions: Alongside the tasks above, I require help in creating custom functions in Power Query to make the process more streamlined and efficient. The data source in use for these Power Query...

...Microsoft365 for my small business without any delays. The office comprises only four staff, and ideally, we would have access to all office-related programs, email, and of course, Microsoft Teams. Highlights of the task are: - Migration from our current Outlook based system. - Configuration of other services like Word, Excel, PowerPoint, OneNote, and especially Teams. Our team needs to utilize the full functionality of Teams: - Chat and Collaboration - Video Conferencing - File sharing and editing Although we don't currently use any other applications along with Microsoft 365, potential for integration with other apps in the future would be a plus. The ideal freelancer for us would have demonstrated experience with managing and setting up Microsoft 365 for small...

...issues with my SQL database and Windows-Based POS system which resulted in a loss of connection between the two. Your main task would be to restore this essential connection, thereby enabling the smooth functioning of the system. • Identify and fix connection issues: My POS system and SQL database are not communicating as they should. Your priority will be to identify what's causing this and to implement a solution. • Handling pertinent data: The SQL database in question manages both customer purchase information and Inventory records. Possessing experience with or knowledge of these data types will significantly aid in this task. The ideal candidate for this project should be proficient with Windows-based POS systems, have a strong understanding...

Hi Mahbubul H., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I need an experienced developer to implement MySQL database management using Python. The selected professional will utilize the python connector 'mysql-connector-python' to establish a connection...database management using Python. The selected professional will utilize the python connector 'mysql-connector-python' to establish a connection with the database and do two tasks of a project. The database management includes: - Creating an efficient system design - load, extract and manipulate the data Key skills required for the job include: - Strong Python programming skills - expertise in SQL and specifically working with MySQL databases - Experience with 'mysql-connector-python' - Knowledge of data management best practices Previous work wi...

...experienced SQL Server DBA to perform several critical tasks for us: I'm a database designer with 20+ years experience, but we need a dba to compliment my skills. - Security and Access Control: We have a user creation bug I cannot solve. - Troubleshooting and Performance Tuning: We have intermittent record locking which we need to fix. - XML Parsing: We have a 10 year old xml parsing codebase, which causes serious performance issues when there are hundreds of fields, we need a way to speed this up. - Converting SQL Server to MySQL: We also need to convert the entire codebase to mysql so we can run on both database engines and keep them syncronised. This is a nice to have skill, but we expect we might need a second person with different skills for this. Presently, we...

I am seeking freelancers who can assist in creating detailed floor plan and elevation drawings, documenting an existing small size building (less than 5000 Sq. Ft.). Specific requirements include: - Precise drawings of the floor plan. - Detailed elevation drawings. Priority should be given to: - Height and roof - Interior Floor plan. Ideal candidates would be someone who drafts with experience in building height measurements. Proficiency in drawing for floor plans and elevations. Must be willing to make one in-person visit to Livermore, CA to measure the existing building..

...be arranged in tables, generally organized like in the attached image. A list of departments is in another of the attached images. User should be able to click to hide/display prior years and click to hide/display min/avg/max values as well. At the bottom of the report, a grand total section that includes all departments should be displayed in a similar fashion as the departments. The MySQL query that is used to obtain a given total from the data is: ------------------------ SELECT SUM(llx_facturedet.total_ht) AS Total FROM llx_facture AS t LEFT JOIN llx_societe ON t.fk_soc = LEFT JOIN llx_facturedet ON = llx_facturedet.fk_facture LEFT JOIN llx_product ON llx_facturedet.fk_product = WHERE llx_product.accountancy_code_sell = "4012"

I'm in desperate need of assistance with a database management assignment. The tool of choice for this project is MySQL, necessitating an expert familiar with the specifics of this particular database system. With an urgent closure time frame of 2 hours, you will need to hit the ground running. The assignment centers on two key areas: 2. Understanding Database Concepts - In addition to query writing, a solid understanding of core database concepts is necessary. Part of the task may involve explaining these database concepts to me, so clear communication is important.

Merhaba, Windows işletim sistemine sahip bilgisayarımda çalışacak bir SQL Server yedekleme programına ihtiyacım var. Bu programın öncelikle aşağıdaki özelliklere sahip olmasını istiyorum: - SQL Server veritabanımın otomatik olarak yedeklenmesini sağlayabilir. - Firebase veritabanı veritabanımın otomatik olarak yedeklenmesini sağlayabilir. - Yedeklerin belirli bir zaman aralığında alınmasını sağlayabilir. - Yedeklemeyi başarısız durumda, hata bildirimleri gönderebilir. Bu projenin bir ay içerisinde tamamlanmasını istiyorum. İdeal adayın SQL Server, veritabanı yönetimi ve Windows programlama konularında deneyime sahip olmasını tercih ederim. Ayrıca c# veya .Net dillerinde yazılım geliştirme deneyimi de büyük bir avantaj olaca...

I need to setup latest mysql (v8.x) on C++ on my windows 64. The C++ is installed using Msys64 (not visual studio). I need you to figure out how set up the mysql for this c++ for me on my computer. Before I hire you, you must provide a video demonstrating the installation steps successfully on your own computer, and showcase a test by writing c++ code to run a basic mysql query. If the video convinces me that you can do the job correctly, then I will hire you so that you do it on my computer. I will give you control thru anydesk, and you will have to repeat the installation steps on my computer too. And after that, I will do the steps from scratch once again while you watch me, and you troubleshoot me if I get stuck somewhere. PAY: 3000 INR + 2 reviews of 5-star each

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

I am looking to redesign my existing Wordpress website to greatly enhance its appeal and functiona...light on the eyes whilst also being engaging is my objective. 3. **Inspiration** - There are specific websites that I admire and want my website to resemble. I will share the links of these websites for reference. I want my website to be redesigned to look similar to this: It should have math Jax and chem Jax allowed. My website is very simple, it’s a small job. Budget $50. Time 1-2 days. Ideal candidate for this task must have extensive experience with Wordpress and website redesign, a strong understanding of minimalist design principles, and a proven track record of improving user experience. Previous experience with similar projects is a plus.

I want to insert a DYNAMIC logo and text into my header bar just now all i have is 1 static logo however i want the logo to be dynamic (Store Logo) which will depend on the stores_id of the user then next to the logo will be the Store Name the stores_id is in the session and has been declared after login as $manager_stores_id = stores_id so we will need a query like $stores_query = tep_db_query("select stores_name, stores_image from `stores` where stores_id = $manager_stores_id); Then we load the logo top left which is stores_image and the name in plain white text (same styling as on the page) stores_name stores_image stores_name

I want to insert a DYNAMIC logo and text into my header bar just now all i have is 1 static logo however i want the logo to be dynamic (Store Logo) which will depend on the stores_id of the user then next to the logo will be the Store Name the stores_id is in the session and has been declared after login as $manager_stores_id = stores_id so we will need a query like $stores_query = tep_db_query("select stores_name, stores_image from `stores` where stores_id = $manager_stores_id); Then we load the logo top left which is stores_image and the name in plain white text (same styling as on the page) stores_name stores_image stores_name

...help me convert US addresses from the National Address Database into a useable form for an API. This important task aims to strengthen my marketing strategies by enhancing the quality of data I use for these efforts. This is where the addresses are: I want you to place them into a database so that we can build and API around it and query the addresses for validation. Specifically, you will: - Retrieve and convert a vast number of US addresses from the source, which is currently in an online database format - Ensure the converted data is compatible and easily integrated with APIs for seamless utilization - Handle the entire range of addresses from the National Address Database, not missing out on any specific city or state Ideal

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

...high-level performance concerning query response time and system throughput. Load balancing efficiency and resource utilization are as crucial. • Scalability: I'm anticipating the system to be able to handle normal user requests from 100 - 1000 per second and sustain its performance, with an elasticity for peak loads. • Development environment: You should be comfortable working with Python and Docker containerization to develop the project. Crucially, design tactics must be adopted for creating a scalable and adaptable system design. The ideal freelancer for the job would have experience with software development using Python, building scalable systems, and Docker containerization. A robust understanding of performance metrics, including system throughput, qu...

I'm in need of a proficient web developer to construct a modern and visually appealing website for the purpose of sharing personal IT blogs. The aesthetic need...appealing website for the purpose of sharing personal IT blogs. The aesthetic needs to be contemporary and engaging, while being easy on the eye. Key Requirements: - Expertise in modern web design - Ability to implement easy-to-navigate functionality As I'm focused in sharing personal experiences, the site has to encourage reader engagement and discussion. However, please note: I skipped the query regarding the main website functionalities for now, this will be discussed in further detail once initiated on the project. Please provide examples of your prior work in this sector. Your creativity and innovation a...

I require a data analyst with proficiency in PowerBI to create a dashboard focused on analyzing compensation rates based on demographic details. I've attached a rough markup and source data. Will need this completed in a short timeframe due March 7th by 8am PT. The data source will probably need some cleaning in Power Query to be able to be presented accurately. You don’t need to recreate exactly, so feel free to add anything that you think would be worthwhile to look at. Thanks!!

I am urgently in need of a SQL expert proficient in MySQL. I require assistance with writing data definition queries. Work Expectations: - Writing proficient data definition SQL queries. - Extensive knowledge of MySQL. Below is my query. Need to modify the query and get the count as 0 for the column srce_syst_paty_i SELECT COUNT(*) FROM ( SELECT CASE WHEN PATY_IDNN_BK LIKE '%SAP%' THEN SUBSTR(PATY_IDNN_BK, INSTR(PATY_IDNN_BK, '+') + 1) WHEN PATY_IDNN_BK LIKE '%BCB%' THEN SUBSTRING_INDEX(PATY_IDNN_BK, '~', -1) END AS srce_syst_paty_i, * FROM dev_enr.cpln_svrq_paty_detl WHERE day = '02' AND month = '06' AND year = 2023 ) src INNER J...

I'm looking for an experienced freelancer to help with the deployment of a .NET Framework 4.7.2 code on a Plesk panel Windows hosting. Key Responsibilities: - Configure the SQL database settings - Adjust config file settings for database connections Given the specialized nature of this project, I need someone proficient in .NET Framework 4.7.2 and Plesk panel configuration. Familiarity with database connectivity and MSSQL is also a must. I expect a quick and efficient deployment without any loss of data or functionality. Let's get this done right the first time!

I'm in need of a skilled Selenium developer with significant experience in enhancing internet security. You'll need to perform three key tasks: 1. Adjusting proxy settings 2. Enabling developer tools 3. Configuring privacy settings accordingly Ideal candidates should have a solid understanding of Selenium and browser security configura...developer with significant experience in enhancing internet security. You'll need to perform three key tasks: 1. Adjusting proxy settings 2. Enabling developer tools 3. Configuring privacy settings accordingly Ideal candidates should have a solid understanding of Selenium and browser security configurations. Experience in Chrome user agent configuration, cybersecurity, and expertise in dealing with SQL injection attacks and da...

I require a website for my courier business with a primary focus on service description and pricing. The website should prominently feature: - Detailed service descriptions - Transparent pricing models Additional Requirements: - An integrated live chat support for immediate customer query resolution. Ideal candidates for this project must prominently highlight their past work related to website development in their applications. Previous experience with logistics/courier service websites will be a plus.

I am hunting for an entity extraction and vision technology expert. My need is to develop a Proof of Concept (PoC) to validate these technologies for potential larger-scale use. Here's what you ...a text dataset. These entities will then need to be categorized into pre-defined categories. 2. **PoC Creation**: All these will culminate in the creation of a PoC to validate the feasibility of using an Entity Extractor and Vision technology. Please note, This project related to query over doctor Presciption. Ideal Skills: - Experience in Entity Extraction technology - Experience in Vision technology - Proficiency in sentiment analysis - Proven track record in PoC development - Ability to work with small datasets and identify useful patterns and insights Looking forwar...

Description du projet : Nous sommes à la recherche d'un développeur web talentueux et expérimenté pour créer un simulateur d'a...utilisateur optimale sur tous les appareils (responsive design). Compétences recherchées : Forte expérience en développement web, notamment avec des frameworks modernes tels que React, Vue.js, ou Angular. Expérience dans la conception d'interfaces utilisateur attractives et réactives. Maîtrise des langages de programmation tels que JavaScript, CSS et HTML. Expérience avec les bases de données SQL ou NoSQL. Connaissance des meilleures pratiques en matière de sécurité web pour protéger les informations sensibles des u...

I am looking for someone to complete a simple task for a small start-up company and to fill out a quick survey afterwards.

2 small issue to fix. I will share one by one after fix. Today must complete it

I am looking for a talented draftsperson to create a basic, clear and usable schematic layout of our campgrounds, which are less than 10 acres. This layout should highlight all essential features which includes all the buildings, roads, and boundary lines of the site. It is not required to illustrate minor details like trees or footpaths. Ideally, the freelancer should have previous experience in landscape design or architectural drafting and possess a great sense of spatial awareness. Skills in CAD software or other drafting tools would be beneficial. Phase 1 of drawing will be used to show placement of electric poles. We need this asap today. I have the staffing getting the measurements now. You can use the layout from the soil sample document, as the baseline schematic. We will pay...

I'm in need of a highly skilled software developer to build a website for an engineering project. The professional I am seeking should have extensive experience in: - Python - HTML - CSS - SQL - Javascript - Node.js The main goal of this project is to deliver a user-friendly, practical and efficient website that can facilitate project management and monitoring for engineering tasks. The end-users of this website will be individuals working on an engineering project. Your expert touch on this will help to streamline their work, enhancing productivity and communication. Please, only apply if you have a proven track record in these programming languages and the capacity to meet strict deadlines. Your portfolio showing completed similar projects will be a plus. Thank you.

I'm seeking an experienced Financial Planner who specializes in serving small businesses. My primary objective is to offer budgeting and forecasting services. The ideal bidder should demonstrate: - Expertise in financial planning, particularly budgeting and forecasting. - Previous experience serving small businesses. - Ability to communicate complex ideas clearly to non-experts. - Proven track record of successful financial planning outcomes for clients. This project requires deep knowledge of various financial planning strategies and tools, as well as an understanding of the unique needs and challenges of small businesses. Bid with confidence if you have the skills and experience to help these businesses thrive.

i have a mysql query i need to add some JOIN or WHERE / AND condition i tried but not working help call first to show the issue then once i award u u will work in real time live must be done realtime live

...expansions and updates. Skills and Qualifications: Strong proficiency in C++, Python, and Java for system control and automation. Experienced in mobile app development using React Native, Swift (iOS), and Kotlin (Android). Skilled in web development with a focus on responsive design and secure payment processing. Deep understanding of backend development, including API services, database design (SQL and NoSQL), and server-side logic. Familiarity with sensor integration and real-time data processing. Experience with automation systems, robotics, or similar technologies is highly desirable. Knowledge of machine learning and optimization algorithms is a plus. Excellent problem-solving abilities and attention to detail. Strong communication skills and the ability to work as part of a...

I need a menu for my fast food restaurant with a simple, eye-catching design (online shop)

I am currently using Microsoft Access 2013 and need help in migrating data from Access to PostgreSQL. This involves handling: - Text and Date/Time data types - Number and Currency data types -arabic unicode name The database that needs transformation contains between 1table The ideal candidate should be: - Familiar with both Microsoft Access and PostgreSQL - Have Proficiency in SQL - Have an understanding of data types, and how they're handled in Access and PostgreSQL - Able to accurately and securely migrate the data. If you meet these requirements, please bid on this project. Remember, it's more than just a simple transformation, I need a solution that ensures maximum data integrity during the migration.

...renowned for optimizing and streamlining query performance, specifically for numerical data. Having identified inefficiency in indexing as the root cause of my concern, my aim is to significantly improve the speed and efficacy of our system. Here's what this project entails: - Diagnosing the existing MongoDB indexing setup - Analyzing and suggesting improvements for indexing of text and numerical data - Practically implementing recommended changes and optimizing query performance - Providing detailed reports before and after optimization An ideal candidate for this project would be someone with a solid background in MongoDB, specifically in optimizing query performance. Familiarity with numerical datasets is a plus. Your skills should include MongoDB quer...