Sql test questions and answers pdf jobs

...include: 1. **Addition of Monthly CPR:** - Calculate and plot monthly Central Pivot Range (CPR), including Top Central (TC), Bottom Central (BC), and Pivot Point (P) levels. - Highlight these levels for easy visualization across the chart. 2. **Incorporation of Trap Zones:** - Define and visualize trap zones above resistance levels (e.g., R1, R2) and below support levels (e.g., S1, S2) based on a customizable percentage. - Use shading to clearly indicate these zones on the chart. 3. **Compatibility and Upgrades:** - Update the script to Pine Script™ version 6 for optimal performance and compatibility. - Ensure the script runs smoothly without errors or performance issues. # Deliverables - A fully functional and...

I need a digital PDF brochure that conveys key information about my business to potential franchisees. The brochure should include: - A comprehensive company background to inform potential franchisees about our mission, vision, and values. - A section dedicated to franchisee benefits to highlight the advantages of partnering with us. - Detailed investment information to give prospective franchisees a clear understanding of the financial commitment involved. The ideal freelancer for this project should have a background in corporate communication, marketing or business development, with a proven track record in designing engaging and informative brochures. Creative writing skills and an understanding of franchise business models would be a significant advantage...

I need a web-based order management system that allows for order placement and delivery tracking. Key Features: - Order Creation: I should be able to create orders and attach necessary documents for each order. - Spreadsheet Import: The system should allow for importing a spreadsheet to link different shipments to various open orders. - Shipment Handling: My store boy should be able to scan shipments, review them, and either accept or reject them. - Document Upload: The ability to upload a PDF sheet related to daily deliveries is required. - Tracking: I want to monitor which shipments have not been received, particularly those delayed over 10 or 15 days. Ideal Skills: - Experience in developing web-based management systems - Proficiency in creating user frien...

I'm looking for a skilled typist who can accurately transcribe text from PDF files into a Word document. The primary task will be typing text from various PDF files into a Word document, ensuring that the transcription is accurate and well-formatted. Ideal candidates should have: - Proficiency in English typing. - Excellent attention to detail. - Experience with PDF to Word transcription. - Ability to meet deadlines.

I'm looking for a freelancer to create a new Telegram channel for me. The channel should be set up in a way that it can be approved for Telegram ads. The tasks will include posting conte...new Telegram channel for me. The channel should be set up in a way that it can be approved for Telegram ads. The tasks will include posting content for a few days to establish the channel. Ideal Skills and Experience: - Experience with Telegram and understanding of its advertising policies - Ability to create engaging and relevant content - Familiarity with community management - Previous experience in social media marketing is a plus While I have skipped answering the questions regarding content type, channel goal, and target audience, I am open to recommendati...

I am looking for an experienced freelancer to build a custom AI chatbot that answers questions related to laws, policies, and regulations for specific countries (Arab countries). The chatbot must: 1) Support the Arabic language and provide accurate, context-aware responses. 2) Be trained on custom legal documents (PDFs, Word files, images, or web pages) that I will provide. 3) Provide responses with references to specific legal articles or clauses. 4) Be integrated into my website or WhatsApp for easy access. To reduce cost and time, the freelancer must: - Use ready-made models (e.g., OpenAI GPT, Claude, or open-source models like LLaMA 2) and avoid building models from scratch. - Use no-code or low-code platforms (e.g., CustomGPT, Botpress, or ...

I'm seeking a freelancer to assist with editing my PDF food menu. The tasks include adjusting the aspect ratio, adding and removing items. The specific aspect ratio will need to be determined collaboratively. Ideal skills and experience: - Proficiency in PDF editing - Graphic design experience is a plus - Attention to detail - Good communication skills for collaborative decision making

...developed according to your specifications, ensuring efficiency, security, and scalability. HTML & CSS: Responsive form design for an optimal user experience across all devices. MySQL Database: Integration with MySQL to store form data and provide future access. File Uploads: Safe and secure handling of attachments (PDF and Word files), ensuring they are uploaded without issues. Timeline: I am confident that I can complete the project within the next [X days], allowing time for testing and revisions to ensure everything works perfectly. Why Choose Me? Proven experience with PHP, Laravel, and MySQL. Strong understanding of file handling and security, ensuring attachments are uploaded and stored correctly. Attention to de...

I'm looking for a skilled Flutter developer to create a simple Iyzico payment integration template in my app. Key Requirements: - Design a single page that captures essentia...subscription. - Implement a process for creating subscriptions with the payment gateway, complete with success/failure alerts via AlertDialogs. - Include a method for users to cancel existing subscriptions. I will provide the test account API keys and secret keys, or you can create a test account yourself - it's quick and easy. The purpose of this template is for me to understand: - How to create a subscription plan or 'Seller product'. - How to make a user subscribe and process their payment. - How to unsubscribe a user. The template should support both iOS ...

... username: User's WHMCS username. password: User's WHMCS password. domain: Domain name provided by the user. Implement error handling and logging for successful and failed requests. Provide detailed documentation for installation, configuration, and usage within WHMCS. Deliverables: A fully functional WHMCS provisioning module. Installation and configuration instructions. Documentation for troubleshooting and future maintenance. Required Skills: Proficiency in PHP. Experience with WHMCS module development. Familiarity with HTTP protocols and API integrations. Strong debugging and error-handling capabilities. Preferred Qualifications: Previous experience in WHMCS or ...

I need an expert to install SQL 2019 on my server, which currently has SQL 2014 Express. The primary purpose of this installation is to facilitate a database migration involving mixed data types. Your responsibilities will include: - Installing SQL 2019 on the existing server - Assisting with both the database schema and data migration Ideal candidates for this project should have extensive experience with SQL installations, particularly SQL 2019, and a deep understanding of both database schema and data migration processes.

I'm looking for a detail-oriented data input operator to handle text data sourced from typed documents. The primary task will involve extracting and inputting text from PDF files. Ideal skills and experience include: - Proficiency in data entry - Excellent attention to detail - Ability to work with PDF files - Good understanding of text processing - Familiarity with handling typed documents. This is a straightforward project but requires a high level of accuracy and efficiency.

As a Web Developer you will be responsible for building and maintaining our websites and web applications. You’ll work closely with our design, marketing, and product teams to ensure that we provide a seamless and engaging online experience for our users. Key Responsibilities: Develop, test, and deploy user-facing features for web applications. Build reusable code and libraries for future use. Ensure the technical feasibility of UI/UX designs. Optimize applications for maximum speed and scalability. Collaborate with back-end developers to integrate APIs and other services. Stay up-to-date with emerging web development trends and best practices. Troubleshoot and debug issues to ensure seamless performance. ...

Transcribing music sheet from pdf to Sibelius

My OVH Ubuntu server is failing to boot after some configuration file modifications. While I can access recovery mode, I need a seasoned server administrator with OVH VPS experience to help fix the boot partition. I am unable to back up my hosted websites due to lack of SQL and FTP access. Ideal candidates for this job should: - Have extensive experience with OVH VPS - Be adept at server administration and recovery - Have a deep understanding of Ubuntu server configurations

Title: Customization, Hosting, and Deployment of Ludo Multiplayer App Description: I have purchased the source code for a Ludo Multiplayer Real Cash Game (Codecanyon Link) that includes essential features like real-time multiplayer, Google Sign-In, Razorpay Payment Gateway, and more. The app is built using Unity3D, with a Node.js server, MySQL database, and a PHP admin panel. I need a skilled developer to customize, host, and deploy the app on my Hostinger VPS server (Linux) using aaPanel as the control panel and successfully upload it to both Google Play Store and Apple App Store. Key Requirements: 1. App Customization: Modify the app to comply with Google Play Store and Apple App Store policies: Replace real-money transactions with a poi...

...overall aesthetic of brands like LuvLap and Babyhug, focusing on bold, vibrant, and appealing visuals. Key Requirements: 1. Design Enhancements: - Maintain the overall design format and essence of the original logo. - Improve color quality to be vibrant, professional, and brand-ready. - Ensure perfect alignment of text, icon, and overall elements for a cohesive look. - Experiment with capitalization styles: hesheeKids (lowercase + uppercase mix) HesheeKids (uppercase first letter + uppercase 'Kids'). 2. Icon Design: - Incorporate the icon directly into the logo in a bold and visible format (no fading or transparency). - Ensure the icon aligns seamlessly with the logo's color palette and professional feel. 3. Deliverable...

Creation of a copy-trading bot on Solana chains. Frontend website (domainname needs to be chosen) needs to be developed with the following options: - Login with 2-factor authentication (after creating an account, and Google Authentication) - Creation of a new Sol address. (on chain), when the user had created the account. This wallet will then be used to trade with after a deposit is made. - The user must have the possibility to withdraw/deposit in the user section of the account. Also, it must be possible to export the private key - The user needs to have the following options on the Copytrading tab/section: o Tag for the specific wallet which is copied. o Target Wallet Adress o Buy Percentage (of the initial wallet) o Max Buy: for example, 0.5 sol o Minimum Buy: for example, 0.4 ...

...scraping and web development, with proficiency in various Python libraries and frameworks such as BeautifulSoup, Requests, Scrapy, and Selenium WebDriver. Responsibilities: -- Build and maintain automated web scraping solutions using Python and Selenium. -- Scrape data from websites and efficiently process it. -- Develop and integrate databases with frontend applications. -- Work closely with the frontend team to ensure seamless integration and functionality. -- Collaborate in building and maintaining the business’s web-based systems. -- Work on web development projects using Python and associated tools. -- Ensure code is scalable, maintainable, and efficient. Required Skills: -- Strong experience in Py...

...to design and develop an e-commerce website to sell their clothing and accessories online. The website should be visually appealing, user-friendly, and optimized for search engines. # Project Requirements: 1. Design a custom website theme that reflects the fashion brand's style and aesthetic. 2. Develop the website using a popular e-commerce platform such as Shopify, WooCommerce, or Magento. 3. Create a responsive design that adapts to different screen sizes and devices. 4. Set up payment gateways such as PayPal, Stripe, or credit card payments. 5. Integrate shipping options and calculate shipping costs based on location and weight. 6. Develop a product management system to easily add, edit, and remove products. 7. Optimize t...

UNLIMITED REVIEWS AND REALISTIC MOCKUPSI am very excited to work with you! I promise fast response times, unlimited reviews, customer service, and 100% original designs! My 110% satisfaction guarantee ensures that your success is our success. You will receive the following files:- AI (Original design file in Adobe Illustrator)- PDF (Original design file in Adobe Acrobat)- JPG (Image)- PNG (image without background)- Social Media- Font used- Color code

Finish the implementation of sessionWatcher and DefaultWorkItemProvider. SessionWatcher will be responsible for tracking user inactivity in the app for a given period of time. If there was no user action received during the given session time then onTimeExceeded completion should be called from SessionWatcher instance. Creation of a DispatchWorkItem will take place in DefaultWorkItemProvider. The created work item will be used in the SessionWatcher Class. Requirements Provide an implementation for the following methods and classes: DefaultWorkItemProvider func workItem(actionBlock: @escaping () -> ()) -> DispatchWorkItem? This method should return DispatchWorkItem with the given actionBlock to execute SessionWatcher start() o The start method will be called when t...

I'm looking for a skilled video editor/software developer who can generate a single MP4 video from two in...single MP4 video from two input videos. The final product should have a 9:16 aspect ratio, with the first video positioned on the top half and the second video on the bottom half. Key Requirements: - Create a generator that is able to combine any 2 videos - The top video should be closed captioned with text derived from its audio. - The captions should use customizable fonts similar to those trending on social media platforms. Ideal Skills and Experience: - Able to create a software algorithm - Proficient in video editing software and MP4 format. - Experience with creating closed captions. - Ability to replicate trending social media fonts Please see ...

...that serves as a mobile and desktop booking platform for classes and courses within Japan. The site should accommodate both students and course providers with a two-tier member back-end. Key Features: - Course Creation & Calendar: Course providers should be able to create courses and set them on a calendar based on training class locations. - Individual Calendars: Each location needs to have an individual calendar with no overlap for classes at the same time. - Student Back-end: Students should be able to view their enrolled courses and download course materials. Custom date request via email - Course Provider Back-end: Course providers should be able to create courses, track applications, see payout amounts, request payout, and upload doc...

...We are seeking a talented and experienced designer to develop the screendesign and overall visual concept for our new product – the LEDBOX. This innovative backlit aluminum frame system aims to outperform traditional roll-up displays by featuring illuminated front and back fabric panels, primarily targeted at event organizers. Project Goals and Requirements Product-Centric Presentation Clear showcasing of the LEDBOX’s unique features and benefits High-quality images, graphics, or visual elements to highlight its functionality and impact Integration of customer testimonials to build trust and credibility User-Friendly Layout Straightforward navigation with a focus on driving conversions Prominent placement of calls to action...

...someone with a basic understanding of content creation, eager to grow and develop their skills. Since the content type, industries/topics, and article length are not yet defined, flexibility and a willingness to learn are essential for this role. Compensation: ₹8,000 per month Ideal Skills: - Basic adaptability in writing styles for different audiences - General awareness of a variety of topics - Willingness to learn and improve task management - Familiarity with grammar basics to produce error-free content - Eagerness to develop technical and social media writing skills - Basic editing skills with attention to clarity and coherence - Enthusiasm to learn time management and audience analysis - Openness to multitask and handle mult...

I'm looking for an expert who can set up an Inbound IVR system for my customer support. The IVR will be used to handle incoming calls, directing them to the appropriate department or providing pre-recorded answers to common queries. Key requirements: - Experience in setting up IVR systems, particularly for customer support - Ability to integrate the IVR with existing Helpdesk software - Knowledge of best practices for IVR design to ensure user-friendly experience I expect the freelancer to understand the nuances of customer support IVR systems and deliver a setup that optimally assists in managing incoming calls.

We are seeking an agency to assist in collecting selfies and videos from 800 brown teenagers for AI training purposes. The agency should help us collect data from 800 Brown teenagers (aged 9-15) from Egypt or Southeast Asian countries (excluding India). The collected data will consist of one selfie photo and two speaking videos per participant, adhering to the requirements listed below. Requirements: Target Demographic: Teenagers aged 9-15. Ethnicity: Brown (from Egypt or Southeast Asian countries, excluding India). Skin tone must align with provided examples (details in the attached document). Collection Content: Photo: One selfie per participant, resolution of 1080p (1920x1080), file size of at least 1MB. Videos: Two speaking videos per participant, recorded ...

...to design and develop an e-commerce website to sell their clothing and accessories online. The website should be visually appealing, user-friendly, and optimized for search engines. # Project Requirements: 1. Design a custom website theme that reflects the fashion brand's style and aesthetic. 2. Develop the website using a popular e-commerce platform such as Shopify, WooCommerce, or Magento. 3. Create a responsive design that adapts to different screen sizes and devices. 4. Set up payment gateways such as PayPal, Stripe, or credit card payments. 5. Integrate shipping options and calculate shipping costs based on location and weight. 6. Develop a product management system to easily add, edit, and remove products. 7. Optimize t...

I'm in need of an expert in Optical Character Recognition (OCR)...Optical Character Recognition (OCR) technology who can help extract specific information from lab reports. The primary aim is to retrieve patient details and test results from these documents. Key Requirements: - Proficiency in OCR technology - Experience with processing and interpreting medical lab reports - Ability to accurately extract patient details and test results - Competency in formatting and saving data into JSON Ideal Skills: - Medical data processing - JSON data structuring - Attention to detail - Data accuracy and verification Please note, the extracted information will be saved in a JSON format. Your attention to detail and ability to work with med...

...Use the FCM to compute the final selling price based on certain margin. Extract the per unit price Outputs: 1. Quotation Appendix Creation • Automatically generate a quotation appendix in Excel format, based on the FCM data. Get the per unit price from FCM. 2. Approval Email Preparation • Auto-generate an email text for approval, with the FCM file attached in both Excel and PDF formats for approvers to review and sign. 3. Auto insert these info into another excel, project pipeline table...

I'm looking for a skilled video editor/software developer who can generate a single MP4 video from two in...single MP4 video from two input videos. The final product should have a 9:16 aspect ratio, with the first video positioned on the top half and the second video on the bottom half. Key Requirements: - Create a generator that is able to combine any 2 videos - The top video should be closed captioned with text derived from its audio. - The captions should use customizable fonts similar to those trending on social media platforms. Ideal Skills and Experience: - Able to create a software algorithm - Proficient in video editing software and MP4 format. - Experience with creating closed captions. - Ability to replicate trending social media fonts Please see ...

...the range of 15,000 to 30,000 words. You must be careful about Originality and Relevance of Project Topic to avoid Project Rejection at a later stage. Therefore, you are required to submit a plagiarism report acknowledging 85% originality.  The extended abstract should case the following aspects: (a) The abstract for 500-1000 words An abstract is an overview or a brief summary of project work, which helps the reader to ascertain the purpose of carrying the project work. It acts as a stand-alone entity for the complete project work. (b) The study hypotheses(null or alternative hypotheses, if applicable) (c) Literature Review Literature review(secondary sources) is the evaluation of substantive findings and theoretical and methodological contribution to a particular ...

All details are in the PDF file

MUST READ I'm looking for an expert who can help me create a comprehensive database of leads for businesses dealing with electrical instruments, specifically targeting retailers and manufacturers. i need 50 list, and only targeted from DUBAI - to test the quality i need 2 lead as per the blow requirement here is a sample for key words - Requirements: - The database should include: - Contact name and email - Business address - Phone number - The final data should be delivered in an Excel spreadsheet.

...answer the question: “Should we use DuckDB for building a Text-to-SQL API?” I would like a comparison of DuckDB’s performance and features with other databases for this use case, and a brief recommendation based on your findings. Deliverables include: - Code Demo: Your project should be hosted using Vercel for deployment. - Analysis Report: A concise 1-page analysis answering the research question. For the suggested user experience, you can employ OpenAI APIs or Gemini API to implement the Text-to-SQL feature. You may refer to a suggested UI/UX demo for inspiration. Ideal candidates should have: - Proficiency in the MERN tech stack. - Experience with DuckDB and understanding of its capabilities. - Skills in database comparison ...

I need a comprehensive online registration system for new students. The system should collect and store the following information: - Personal Information - Academic Background - Parent/Guardian Details Once this information is collected, it should be stored in PDF format for easy access and sharing. Ideal skills for this project include: - Web Development - Database Management - PDF Generation - User Interface Design Please provide examples of similar projects you've completed.

I am looking for an experienced Data Integration Specialist for a 3-mon...based in Pune or Bangalore. The ideal candidate will have over 6 years of experience, with a strong focus on Informatica PowerCenter, SQL, and Microsoft SQL Server. Key Responsibilities: - Creating and maintaining end-to-end source to target flows using Informatica PowerCenter. - Conducting data analysis and reporting, utilizing SQL expertise. - Basic Unix commands and shell scripting to support tasks. - Direct communication with users to understand and fulfill requirements. Compensation will be based on experience. Strong communication skills are essential, as the role involves independent task completion based on user requirements. Production monitoring ...

I'm looking for a professional architect / interior designer to redraw a simple floor plan (attached floor plan according to scale) of an apartment from PDF to one of the following apps. 1. MagicPlan () OR 2. HomeByMe () OR 3. Planner5D () Key Deliverables: 1. Create 2D/3D floor plan in one of the above apps based on the PDF provided 2. Provide source Files / share project in one of the above apps so that any further changes/edits in the future can be incorporated easily.

...acquire the needed source code, AI's, Software, and API's that will be needed to build what I need. You must get approval or verify it is allowed to be used in my software construction and use for profit for my business and that I own the copyrights to all work it creates for my business. Create a platform that replaces actors in live-action footage with CG characters. The system should automate body motion capture, facial animation, and scene integration using open-source or one-time purchase software (no subscriptions). All source code programs and AI's and software programs used to build my software must allow my software to be used for profit and for my business. Key Requirements: 1. Motion Capture from Video: T...

I need assistance with a PDF document which is primarily for research and information gathering. The document contains a mix of text, images, and charts. Some materials need to be sourced, so a degree of data gathering is involved. Ideal Skills and Experience: - Proficient in typing and data entry - Familiar with Google tools - Able to interpret and transcribe content from images and charts - Research skills to source some materials - Attention to detail

I am looking for a professional who can assist me with PDF content entry services. Ideal skills and experience for the job include: -Proficiency in extracting and formatting data from PDF files. -Experience in accurate and efficient data entry. -Familiarity with tools like Adobe Acrobat, OCR software, and similar tools. -Ability to organize and structure data in formats like Excel, Word, or custom databases. Strong attention to detail and adherence to formatting guidelines.

...adding new functionalities and passing specific end-to-end test cases. Key Responsibilities: - Enhance current code to pass specific end-to-end test cases - Ensure the following functionalities are properly implemented: - User authentication process - Profile data fetching and display - Visualizations of GitHub activity Skills and Experience: - Proficiency in React.js is a must - Experience with GitHub API is preferred - Previous experience in writing end-to-end tests is a big plus - Strong understanding of web development and UI/UX principles - Attention to detail and the ability to write clean, maintainable code I have provided the link to the repository and look forward to working with a skilled React developer. T...

...10 testers to thoroughly test my small Android app, Egg Master. This app has only 4 simple screens and is designed to help users boil eggs perfectly every time with customizable timers and notifications. Your job will be to: Test the app's functionality, usability, and overall experience. Report any bugs or issues with detailed reproduction steps. Payment Details: €2 per tester for completing the testing process. A bonus of €1 for each new, valid bug found (not previously reported). Requirements: Access to an Android device. Ability to install apps outside the Play Store (APK testing). Detail-oriented and able to provide clear feedback. Deliverables: A list of any bugs or issues discovered (with steps to reproduce). Genera...

Description: I’m looking for an advanced developer with expertise in PHP and Adobe Dreamweaver to update the existing website The site has been worked on by multiple programmers, so the code may be disorganized. Tasks include improving functionality, fixing bugs, optimizing performance, and updating the file for the registration form. Dreamweaver proficiency is required because updates to the template will apply across the entire site. Requirements: • Expertise in PHP and Adobe Dreamweaver • Strong problem-solving skills for handling unorganized or legacy code • Ability to optimize the site for performance and responsiveness • Experience with updating and testing PHP forms • Knowledge of responsive web design Deliv...

I need a small task done on my PDF file. The page margins need to be fixed and the center alignment on the cover page needs to be corrected. Ideal skills for this project include: - Proficient in PDF editing software - Attention to detail - Good understanding of layout design principles

I need a freelancer who can extract data from structured tables in a PDF and input it into a spreadsheet. The ideal candidate should have experience in data entry and be proficient with Excel. Attention to detail is critical to ensure all data is accurately transferred.

...for KuCoin Futures Bot with Bot-Managed Stop Loss and Take Profit Description I am seeking a Python developer to build a WebSocket-based module for managing positions in a KuCoin Futures trading bot. The module will dynamically handle position entries, bot-managed Stop Loss (SL) and Take Profit (TP), and real-time synchronization of wallet and trading data. It will integrate with a Redis database for state management, providing seamless performance. Below are the detailed requirements and expectations. Key Features and Requirements 1. WebSocket Integration The module must utilize KuCoin’s WebSocket API to ensure real-time updates and precise control over trading operations: • Position Monitoring Subscribe to /contract/positio...

... and popular property management systems (PMS) like Guesty, Hostaway, etc. Calry () is our all-in-one tool that’s already connected to these PMS platforms, letting us centralise data and APIs in one place. MotoPress, on the other hand, is the plugin we use in WordPress to manage the booking side of things (e.g. reservations, booking rules, etc.). The goal is to ensure that: Booking data captured in MotoPress is sent to the PMS via Calry. We pull rates, calendar availability, pictures, and descriptions from Calry (which in turn pulls this data from the PMS) and update MotoPress accordingly. OBJECTIVE Develop a WordPress plugin that synchronises booking and availability data between Calry (and the PMS platforms it connects to) and ...

...health-conscious and proactive pet parents who want the best for their dogs. Key Features and Functionalities 1. Ingredient Dictionary • Purpose: Help users evaluate the quality and safety of dog food ingredients. • Features: • Searchable database of ingredients. • Color-coded categories: • Red: Dangerous. • Yellow: Not useful/neutral. • Green: Okay/good. • Blue: Highly beneficial. • Detailed explanations for each ingredient. • Option to mark “favorites” or commonly searched ingredients for easy access. 2. Food Portion Calculator • Purpose: Ensure owners feed their dogs the right amount based on individual needs. • Features: • Inputs for dog’s age, size, body typ...