Tricky sql queries for interview pdf jobs

Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure comp...

...fingertips; the need for speed; and the drive for mass personalisation, all mean that brands need different solutions. Our global team of over 6,000 craft and technology experts brings together creative, production and innovation to help clients navigate this exciting and ever-changing world of today’s content experience. Overview This vacancy is for upcoming short-term projects that will happen intermittently. Each project is likely to last between 3-5 weeks and would most likely require the team to work full days on-site at the office in Singapore. Working alongside a Content Studio team, you will execute and create all required localised images featured within our Client's website and other marketing materials. Responsibilities include reviewing co...

I have a set of PDF documents that I need to convert into Microsoft Word for the purpose of creating a digital archive. Key Requirements: - Copy typing from PDF to Microsoft Word - Include all images and charts from the original PDF I need someone who is meticulous and proficient with Microsoft Word to ensure that the final document retains all the necessary elements and details. The ideal candidate for this project should have experience with data entry and be detail-oriented.

I have a set of old drawings in IMG format that I need converted to PDF format that is acceptable to a building dept for upgrade permits. We want to add a deck in front of the garage which will be the width of the garage appx 19' x 15'. If you have experience in architectural drawing, drafting and design, and proficiency in working with PDF formats, then you're the freelancer I'm looking for. Unfortunately, I do not have specific features or elements that I want to incorporate in my deck plan. It'll be great if you can provide some suggestions on possible seating. I'm only looking for help with the drawing and end result would be something I can submit to city of San Diego building dept for a deck that I'm goin...

...typist to assist with my data typing project. - The task involves typing up a variety of data, which may include text, numbers, and alphanumeric characters. - The volume of this data will vary, but it will be of moderate size, falling within the range of 100 - 500 pages. - The format of the existing data that I need to be typed is likely to be a mix of scanned documents and PDF files. - You must have a keen eye for detail, excellent typing skills, and be proficient in handling different types of data. - Experience with data entry and typing projects, especially those involving numerical or alphanumeric data, will be highly beneficial. - Confidentiality and the ability to maintain the integrity and accuracy of the original data is of the utmost importance. If you ha...

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong backg...

This project will accomplish a One Minute Animation in motion graphic. This Project Will Take Information From The PDF the client send Before

I need a local representative in Basra, Iraq, or nearby to conduct a business verification. Below is the task: 1. Visit the target address 2. Take photos 3. Conduct a mini-interview Requirements: 1. Living in (or nearby) Basra, Iraq 2. Available to do the job during business hours (9 AM - 4 PM) Notes: - 1 project can only be taken by one freelancer (on a first-come, first-served basis) - The milestone will be released the following week (Monday) after the verification to give us time to organize the report and contact you if we need additional clarification.

This is for freelancers located in the U.S. ONLY. I need an Adobe Acrobat Pro expert to “Embed Videos” and “Create Links” inside a PDF document using Adobe Acrobat Pro. Just to be clear, not hyperlinks to other files outside the PDF document, not hyperlinks to websites, webpages or web located videos. When complete, and the PDF document is forwarded to another individual, they need to be able to "click on" an icon in the document and have the video play. We are a forensic investigation company and often have legal cases where these types of efforts are needed. Unfortunately, the documents cannot be sent to you. You will be working remotely on a computer in our office. The tasks pay $50 per hour with a one hour minimum. I...

...and intuitive mockup for a web application focused on optimizing the recruitment process for various users. It is crucial that the submitted designs are entirely original. Submissions that utilize pre-existing templates or closely mimic designs from platforms like ThemeForest will be outright rejected and may receive a negative review. The design must adhere to the features specified in our project outline while showcasing a distinct and fresh aesthetic. Design Requirements 1. User Management -User Registration/Login: Separate workflows for candidates and companies. Each form should gather specific information as per the provided documentation. Design should clearly differentiate between these two processes. -Email Verification & Secure Password Management: In...

in your Bid, clearly answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and...

I have a PDF document that needs to be translated from English to Spanish. The document primarily contains marketing materials, and I'm looking for a skilled translator who can accurately convey the original message in Spanish. Key Requirements: - Translate the content from English to Spanish, maintaining the core marketing message. - Preserve the same format and layout as the original PDF. An exact match is not necessary, but a similar layout is expected. - Prior experience with marketing translation is preferred. Please note: - The document is relatively short, with about 3-4 pages of text. - The translation should be delivered in a timely manner.

I need a skilled professional who can transcribe my scanned Arabic PDF document into a Word document. Key Requirements: - The PDF is scanned, and the freelancer should have experience in converting scanned documents to text. - Arabic language proficiency is a must for accurate transcription of the text. - The final Word document should be in the exact same format as the original PDF. - No images or charts need to be included, so the project is focused on text transcription. Ideal Skills: - Expertise in Arabic language - Proficiency in OCR software for scanned PDFs - Proficient in Microsoft Word - Attention to detail for an exact format replication.

I'm looking for an experienced software developer to create an AI recruiting software tailored for the healthcare industry. The ideal candidate should have previous experience with LMS and building recruitment tools. Key features: - Resume Screening: The software should be able to effectively screen resumes for healthcare positions. - Candidate Ranking: Implement a system that ranks potential candidates based on their qualifications and experience. - Interview Scheduling: The tool should also have a built-in feature that enables easy and efficient interview scheduling. Preferred Resume Screening method: - Keyword Matching: A system to match keywords in resumes to job requirements - Machine Learning Algorithms: An algorithm to predict candidate sui...

I'm necessitating a freelancer with proficient skills in PDF modification to assist me with a few changes on my bank statement. The task will include: - Text editing, specifically modifying transaction details. - Image modification, focusing on the removal of a particular deposit. Competent experience in PDF editing tools will be essential for this project. The job will require keen attention to detail and accuracy due to the delicate nature of the document. Please only apply if you can guarantee confidentiality and professionalism.

I am looking for a Nepali interpreter for a client's asylum interview tomorrow, May 20th, from 11:00 AM PST. Please let me know your availability since it is something urgent

As a small business owner seeking to enhance my Go High-Level (GHL) membership courses and sales pages with an AI chatbot, I'm looking for a specialist who can achieve the following: - Answer Customer Queries: The AI chatbot should be able to address queries from potential customers about the courses and sales offerings. - Provide Course Recommendations: It should be able to suggest relevant courses based on users' needs and interests. - Collect User Feedback: I'd like the chatbot to gather feedback from users, which can be valuable for improving the offerings. I'm particularly interested in integrating the AI chatbot in a text-based format. Key Skills: - Proficiency in AI Chatbot Development: Extensive experience in developing, implement...

Always visible MENU with : 1. Webflow "7 categories" menu + "contact" and "about" 2. Webflow LIST/ filtering sorting each of the 7 categories. On a click the listed projects can be shown as ImageA or ImagesB PROJECT PAGE With Home buttons With 4 blocks of text on the top + max.10 images and text + links to PDF WEB DESIGN (layout) Provide or adapted from the draft CONTENT Instructions to fill it by us

I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.

Are you a driven sales professional ready to take control of your income and achieve unparalleled success? Buzz Circuit Media is seeking highly motivated Sales Outreach Specialists to expand our client base for our social media management services. With our commission-only structure and powerful tools, you can unlock your earning potential and enjoy the benefits of recurring passive income. Compensation Structure: 10% commission on the monthly revenue generated by Tier 1 clients (client pays $199/month) 15% commission on the monthly revenue generated by Tier 2 clients (client pays $399/month) 20% commission on the monthly revenue generated by Tier 3 clients (client pays $599/month) Bonus Structure: $250 bonus when a client reaches 3 months $500 bonus at 6 months $1,000 bonus a...

I urgently need a professional who can edit the text in my PDF document. I need two different versions of this resume. One where the location at the top of the resume is changed to New York City, NY, and one where location isn’t listed. Just please make sure everything is centered, symmetrical and so on. The project must be completed ASAP.

I am in need of a professional website developed to s...navigable way. Each publication must have its abstract summary and a link to access the full text PDF. - Organization: The publications should be organized by research topic, allowing visitors to quickly navigate to their areas of interest. Ideal skills for the job: - Web Design: You should have a portfolio demonstrating your ability to create professional, clean, and user-friendly sites. - Content Management: Familiarity with content organization is crucial, specifically in handling academic or research materials. Overall, this project requires a keen eye for details and a robust understanding of academia and research publications. Your ability to create an intuitive user interface will also be pivotal for...

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document. The job has to be completed in the next 12 hours.

...comprehensive dashboard for our POS (Point of Sale) system involves several key components and technologies. Here’s a detailed outline of the project requirements and the ideal skills needed to build the solution: Project Overview The goal is to develop a dashboard for an existing POS and inventory management system that consolidates sales and collection reports, provides inventory management, and includes customer data analysis. The dashboard should be accessible via web browsers and mobile devices. Key Features 1. Sales Reports o Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data ...

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document.

...and experienced developer for the creation of a business proposal management platform. This platform is specifically tailored to meet the needs of procurement teams within large organizations. Responsibilities: Incorporate a design from an existing wireframe and build the interface in React.js. Features: Create and verify user accounts Ability for user to log in, add authentication features See existing projects on a dashboard Create a new project Upload PDF documents, allow for secure storage and easy organization Send documents to an AI LLM API for processing (via Lambda) Handle results and store in PostgreSQL Implement secure payment systems and automatic notification features Provide scripts for provisioning resources in AWS Adhere to ...

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate tran...

1. Create a chatbot. 2. Use an open-source LLM. 3. Use an iterative method to get a very large response with some custom logic( I will explain it ) . 4. Add a button in the chatbot. When enabled, it can show responses from public sources; otherwise, it must show results from a private source, such as a Pinecone database. Additionally, there should be a page where I can upload my text and PDF files. The response will be displayed like ChatGPT, with a typewriter effect.

I'm in need of a WordPress expert with advanced knowledge in both plugin and theme development. The perfect candidate for this project should have a good grasp of PHP, JavaScript and databases. Key Responsibilities: - Develop and customize WordPress plugins - Develop and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with RESTful APIs - Strong problem-solv...

Hi, How are you? I know you have several tempting proposals here, but I guarantee you to be impressed by my work. I have various skills in design, illustration, Illustrator, Illustration, Graphic Design, Logo Design and Photoshop. If you give me this chance you will be impressed, because I guarantee that I will meet yo...have various skills in design, illustration, Illustrator, Illustration, Graphic Design, Logo Design and Photoshop. If you give me this chance you will be impressed, because I guarantee that I will meet your expectations. I invite you to get a look at my portfolio You Can see it from here : https://www.freelancer.com/u/cri8ive007 If you have any questions or queries, do not hesitate to contact me. I hope to start working with you. Thank you!

We are an engineering company in need of a P&ID drawing for our margarine plant process. This project requires the completion of 1 P&ID done in AutoCAD. Files must be delivered in DWG and PDF (monochrome) format and adhere to best drafting practices for P&IDs. Please do not bid if you lack direct experience with P&ID drawings for industrial processes. We will provide the PFD. Additionally, the process must be simulated using HYSYS, with the simulation results included as part of the project output. The project must be completed in 5 days. Project Details: - Create a standard P&ID from the provided PFD. - Simulate the process using HYSYS and include the simulation results. - Use of layers is required and should be consistent throughout all dr...

I'm seeking a skilled C# .net developer to improve the performance of my application. - Scope: The project involves fine-tuning the existing codebase, optimizing database queries, and enhancing the overall performance of the application. - Skills: The ideal candidate should have a profound understanding of C# .net development, experience in performance optimization, and a strong grasp of database management. If you're proficient in identifying bottlenecks and implementing solutions to boost system speed and efficiency, I'd like to hear from you. Please share your past relevant experience.

I'm looking for a professional who can convert my PDF document to an editable Word document, ensuring that the layout, font styles, tables, images, and page numbering are all maintained. Key Requirements: - Preserving font styles and formatting: It's important that the text in the Word document appears exactly as it does in the PDF. - Keeping tables and images intact: The tables and images should be accurately reproduced and remain in their original positions. - Maintaining page numbering and headers/footers: The Word document should mirror the PDF in terms of its pagination and any header or footer content. Evaluation: - Accuracy of text conversion: I will compare the text of the original PDF with the Word document to ensure that there are n...

I need a professional to set up an automated workflow system using Zapier for my WordPress site. The system should: - Allow me to easily upload PDF documents for conversion - Automatically create AI optimized SEO article based on the document text - Categorize the extracted content into predefined sections - Generate a structured post on my WordPress site based on the categorized content. Ideal Skills: - Proficient in Zapier and WordPress - Experience in creating automated workflows - Knowledgeable in data extraction and categorization techniques

An Ecommerce Store requires a cartoon character (A panda ) with thes...Standing - Sitting - Training with dumbells/ any sort of training Pose - Lying on on sided and saying hi - Motivated pose/ pose after an achievement - Any added poses are most welcome , along with the above poses. * Each panda pose should made in separate page with HD quality pixels. * STRICTLY NO PLAGARISM IS ALLOWED, WILL BE THOROUGHLY CHECKED. * No AI images allowed. How to send ? A PDF file can be sent. By combing all pages. Each panda pose should be in separate pages. SUPRISE ! If the Artwork is really amazing and is very satisfactory . An additional INR.500 will be Given to the Winner along with the Winning Prize. ALL THE VERY BEST ! SURPASS YOUR LIMITS ! FLOW LIKE A RIVER? BURN LI...

I am looking for a skilled professional who can take the content of my PDF book and make automations it into multiple SEO articles that will get automated post on Wordpress. These articles should be approximately 1500 words each, and should be generated automatically. Key requirements: - Understand SEO principles: The generated articles should be optimized for search engines, with appropriate keyword usage and content structures. - Automation skills: You should have experience with tools like Make or similar AI-powered software to automate the article generation process. - Attention to detail: The content should maintain the integrity of the original material, ensuring a high standard of readability and coherence. I am looking to generate several articles, so please ...

I'm looking for a DevOps expert to help me with my interview process. My current focus is on Continuous Integration and Delivery, utilizing Jenkins, Docker, and Kubernetes, GCP cloud run. Key Responsibilities: - Setting up and configuring environments: The most crucial aspect of the support I need is in this area. Your expertise in configuring these environments is paramount. Ideal Candidate: - Proficient in Jenkins, Docker, and Kubernetes. - Skilled in Continuous Integration and Delivery. - Experienced in setting up and configuring environments. This is a great opportunity for you to showcase your DevOps skills while helping me with my interview process. Looking forward to hearing from you!

...integrity and availability, necessitating a system designed for data replication and recovery in the occurrence of a fault. - Parallel processing: Optimum speed during file operations can be achieved through parallel processing functionality and the miniGFS should capitalize on this. - Data distribution across multiple nodes: To ensure efficient space use and increase speed, data distribution across various system nodes is crucial. - System redundancy: In case of any systemic failures, the system should have a fallback mechanism where data recovery is achievable. Ideal skills/experience would encompass deep C++ knowledge, experience with parallel processing, large data handling, and fault tolerance measures. Specific requisites are in the PDF uploaded. Only need to g...

**Please read the attached job post carefully and apply if interested. This is a full-time at least 6 months contract to be renewed. An interview will be required before selecting the right candidate.** I am looking for a marketing specialist with a strong understanding of various marketing strategies and the ability to target specific audiences. The goal of the campaign is to increase brand awareness. Ideal skills for this job include: - Flyers creation - Proficiency in social media marketing, email marketing, and influencer marketing. - Experience in creating and executing multi-channel marketing campaigns. - Strong understanding of the target audience of young adults (18-24), working professionals (25-35), and parents (30-45). - Ability to analyze campaign succes...

We are in need of a skilled software contractor to provide a comprehensive...Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in software development and code assessment. - Strong understanding of code efficiency, performance, and quality. - Previous work on developing completion ...

Please Sign Up or Login to see details.

Hello, I have a webpage ready designed. And a wordpress template to create the site. I need someone to put it together. And some help with finishing it. Also I need Elementer installed and cms.

Please Sign Up or Login to see details.

I'm looking for a proficient video editor who can cut three video tracks of an interview from into a 20-40 minute video podcast. The major tasks include: - Add existing opening and closing graphic - Edit between 2-shot and two single recordings of interviewer and interviewee - Add intro/ outro music - Removing unwelcome background noise - Adjusting the overall mix to yield a clearer sound If compatible, this could be a recurring job 1-2x per month.

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the SQL dat...

1. Right now I think there are 3 courses - I want there to be 5 (Anatomy, Biochemistry, Microbiology, AI Medical Mnemonics, ZAP-70 Resources) 2. Each course should have its own thumbnail, similar in style (I'll send these to you) 3. Lets discuss what each course needs done: -Anatomy: this course is only at its beginning. I have 5-6 videos, whi...are 3 courses - I want there to be 5 (Anatomy, Biochemistry, Microbiology, AI Medical Mnemonics, ZAP-70 Resources) 2. Each course should have its own thumbnail, similar in style (I'll send these to you) 3. Lets discuss what each course needs done: -Anatomy: this course is only at its beginning. I have 5-6 videos, which I will send you, and these need to be uploaded. Each video has an associated pdf or image that should be add...

- Moving from Iubenda to Mirasvit (I will buy and install extension) - Fixing Alpinejs and Google consent exceptions (as seen on Firefox), double check exceptions cross browser. - Check Mageplaza blog (): for example it seems that is needed by extension, I removed it because is useless in frontend, but need to be double checked.

I need an experienced graphic design professional to scale an image to meet the following specifications: - Dimensions: 50x70cm - Resolution: 300dpi - Color Mode: CMYK - Output PSD and/or PDF The scaled image will be used for both indoor and outdoor graphic design purposes. I need it now, in 1hour max.

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page

I already hired one person for this position but work is increasing so I am looking for a second one. A plus if you can do video editing or graphic design. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: Social media Content editing or creating CRM management Email marketing Writing an ebook Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job w...