Sql query interview questions and answers pdfcông việc

TERMS AND MILESTONES Essential Details Gathering Essentials 1.1. Please provide all necessary materials—text, logos, images—for the project. 1.2. Approve the design concept before we begin. Project Phases Primary Design Phase Entire Design Phase Revision Policy 3.1. Three complimentary revision rounds are included after each design submission. 3.2. Additional revisions will incur extra charges as agreed. Feedback Etiquette 4.1. Provide feedback within 12-24 hours after submissions. 4.2. Delays in feedback may result in adjusted timelines. Financial Formalities 5. Payments 5.1. 35% upfront payment is required to start. 5.2. Remaining payment due within three workdays after final design approval. 5.3. Cost Breakdown: - Total: $838 - Milestones: 1. Upfront payment: $...

...Adobe Illustrator. The file must meet the following requirements for high-quality printing: *All text must be vector-based (no rasterized text). *Maintain the original design, fonts, colors, and layout. *Ensure the file is set up with proper bleed, trim lines, and in CMYK color mode as per the printer's specifications. Details: The current file includes both text and graphic elements. The Photoshop file will be provided, along with any fonts or images required. The final deliverables are the editable Illustrator file (.AI) and a print-ready PDF. Requirements: Proficiency in Adobe Illustrator and Photoshop. Experience in preparing print-ready artwork. Ability to accurately recreate designs with attention to detail. Familiarity with sett...

...payment platform that supports integration with e-commerce platforms such as Shopify, WooCommerce, Magento, Zed and Salla. The platform provides advanced payment services including Visa, MasterCard, digital currencies, and local payment services in Arab countries. The system is designed to be scalable and withstand the pressure of large operations using independent servers for each department, while providing the highest standards of security and protection. Basic Features: Payment and Transactions: 1. Support for payment methods: • Visa and MasterCard. • Local payment services in Arab countries. • Digital currencies using blockchain technology. • In-app payment (Instagram and Facebook). • One-Touch Payment: A t...

I'm in need of a database. Specifics have not been finalized, and I'm open to suggestions. Your expertise in the field will be invaluable in determining the best approach. Skills and Experience Required: - Proficient in various database management systems (DBMS) - Strong understanding of both relational (SQL) and NoSQL databases - Experience in creating databases for diverse applications - Excellent problem-solving skills to determine optimal database structure - Able to communicate complex technical concepts in simple terms

I'm seeking a professional to create blackline drawings for a patent application for...patent application for a specialized frying pan. This will involve creating 6 specific drawings: an isometric view, a top view, two side views and a cross-sectional view. Requirements: - The final drawings need to be delivered in PDF format. - I can provide hand-drawn sketches of the frying pan design, which will need to be translated into technical drawings. - The drawings will need to be detailed with annotations. Ideal Candidate: - Experience with kitchenware or similar mechanical devices is a plus. - Knowledge of how metal conducts heat is essential. - Proficiency in creating detailed, patent-ready blackline drawings. - Ability to interpret and translate hand-drawn sketche...

Description: I’m looking for a reliable and knowledgeable Teacher’s Assistant to support me with occasional tasks related to teaching university-level science and math. Responsibilities: • Assigning homework questions based on lesson content. • Assisting in creating lesson plans or supplementary teaching materials. • Researching and summarizing additional resources (e.g., practice problems, readings) for students. • Managing student queries related to assignments or coursework, when needed.

Description: I’m looking for a reliable and knowledgeable Teacher’s Assistant to support me with occasional tasks related to teaching university-level science and math. Responsibilities: • Assigning homework questions based on lesson content. • Assisting in creating lesson plans or supplementary teaching materials. • Researching and summarizing additional resources (e.g., practice problems, readings) for students. • Managing student queries related to assignments or coursework, when needed.

I'm seeking a seasoned Power BI professional to craft a thorough sales performance report. Key Responsibilities: - Extract data from SQL databases to analyze sales performance - Create a variety of visual representations of the sales data - Compile detailed tables for in-depth data breakdowns Ideal Candidate: - Proficient in Power BI and SQL - Skilled in creating comprehensive and insightful reports - Strong background in data analysis and visualization, particularly in sales Please note, specific sales metrics and types of visualizations will be discussed in detail with the selected freelancer. The frequency of report updates will also be determined at that time.

...frontend and backend development. The ideal candidate should be well-versed in Agile Scrum methodologies, including participating in daily standups, grooming sessions, and retrospective meetings. Requirements: Experience: Proven expertise in full stack development with modern frontend and backend technologies. Familiarity with Agile Scrum processes. Skills: Strong proficiency in frontend technologies (React, Angular, or Vue). Backend development expertise (Node.js, Django, ASP.NET, or similar). Experience with databases (SQL/NoSQL). Interviews: Comfortable with HR interviews. Ability to handle technical questions. Live coding and system design sessions. Additional Requirements: Camera must be on during interviews for better communication. Le...

I have a number of PDF files that need to be typed into a plain text file. The project does not require any specific formatting, so it should be straightforward. Ideal Skills: - Proficient typing skills - Attention to detail - Experience with PDF to text transcription

I'm looking for a freelancer who can export my SQL database to an Excel file. The project involves exporting all tables from the database. Ideal Skills: - Proficient in SQL - Experienced in data export and manipulation - Skilled in Excel Please ensure that the data is accurately transferred and well-organized within the Excel file.

I'm looking for a professional who can craft a comprehensive survey on Kratom use targeted at current users. The survey should be built on SurveyMonkey and focus on open-ended questions. Key Requirements: - Expertise in survey design, preferably with SurveyMonkey. - Understanding of Kratom and its user base. - Ability to create engaging and insightful open-ended questions. The primary aim of the survey is to gather qualitative data from current Kratom users. Please include examples of similar projects you've completed in your proposal.

I'm in need of a skilled web scraper who can make use of Scrapy to extract data from invoices and other documents. The extracted data should be returned in a JSON file. The ideal candidate for this project should: - Have substantial experience with web scraping, specifically with Scrapy. - Be able to create a query that retrieves invoices based on a specific date range. - Have a good understanding of JSON file structures and can ensure the scraped data is formatted correctly. Please reach out if you can help with this project and have the necessary skills and experience. login in a page then, make a query and extract results

We are seeking a skilled freelancer to develop an advanced AI Support Agent. The system shall handle incoming calls, dispatch text messages with website links, provide accurate responses to frequently asked questions, and escalate intricate issues to human agents. Moreover, it will feature a customized voice personality to enhance user interaction and manage client-reported maintenance concerns effectively. Additionally, the system will integrate seamlessly with pre-existing technologies on our website.

I am looking for an experienced Power BI professional to develop a comprehensive report for me. The report will primarily focus on analyzing sales performance. Key Requirements: - Proficient in Power BI - Experience with SQL databases - Ability to create detailed and insightful reports The report will source data from SQL databases and will include: - Various visualizations to represent sales data - Tables for detailed breakdowns of the data If you have a strong background in data analysis and visualization, particularly in relation to sales performance, I would love to hear from you.

I'm in need of an AI support agent for my customer service hotline in the real estate sector. This agent needs to be able to: - Answer common questions - Send text messages with links to pages on our website to incoming callers - Pass callers onto human agents when complex issues arise - Take reports of property maintenance issues Ideal skills for this job include AI programming, natural language processing, and experience in designing customer service bots specifically for the technology industry. Please provide examples of your previous work in this field.

...for an experienced front-end developer to design a professional invoice template using HTML and CSS. This template will be integrated into my CRM, which uses a built-in Chrome engine to generate PDF files. Requirements: Clean, responsive, and professional invoice design. Compatibility with the Chrome PDF engine. Well-structured HTML and CSS code optimized for print. Customizable fields, including: Logo, Client Name, Products/Services, Amounts, Taxes, Totals, etc. Deliverables: A complete HTML/CSS file ready for use. Instructions for integration into the CRM (if needed). Notes: I can provide an example of the desired style for reference. Ideal Candidate: Proficient in HTML/CSS. Familiar with how PDF rendering engines like Chrome work. Detail...

I need a website for a crypto project featuring a custom-named AI chatbot from OpenAI, with a tech-themed identity. The site should also have a GitHub lin...code for a crypto agent capable of locking funds in a wallet. Key Requirements: - A website that showcases the crypto project, allows interactions with the AI chatbot, and provides resources and code for the crypto agent. - The AI chatbot should be tailored to reflect an AI and technology theme. - The chatbot needs to have specific functionalities: answering common questions and providing project updates. Ideal Skills: - Web development (preferably with experience in crypto-related projects) - AI and chatbot integration - Familiarity with GitHub and coding for crypto agents - UX/UI des...

I'm looking for a skilled developer to create a hybrid customer database on my website. This will include a secure login system, payment options, and a user-friendly interface. Key Requirements: - Design and implement a hybrid (SQL & NoSQL) customer database - Incorporate a secure 'Email and Password' login system - Implement payment options: Credit/Debit Card and PayPal - Ensure the system is user-friendly and secure Ideal skills for the job: - Proficiency in SQL and NoSQL databases - Experience in website security and payment integration - Strong understanding of user interface design - Ability to deliver a project on time and within budget I uploaded the photo underneath. look forward to your bi...

I'm seeking a seasoned legal transcriptionist to transcribe a series of depositions for me. The transcriptions will be required in a digital text format, specifically as a Word or PDF file. I can give the transcriptionist to edit the transcript that my software already provides. For computer requirements, you can check out the MaxScribe PC requirements. Key requirements include: - Proficient transcription of deposition recordings into a clear, accurate digital text file - Adherence to standard legal formatting for the transcriptions - Timely delivery of the completed transcriptions Experience in legal transcription, especially with depositions, will be highly valued. Understanding of standard legal formatting

I'm looking for a skilled C# developer with experience in enhancing Windows services and working with APIs, particularly the Milestone Server API. The objective of this project is to enhance an existing C# Windows service to query the status of CCTV cameras via the Milestone Server API. Scope of work: - Implement a function that queries the status of CCTV cameras from the XProtect 2021 R2 Milestone Server API. - Develop an API within the Windows service that lists cameras and displays their status as either "online" or "offline". Key Requirements: - Proficient in C# and Windows service development. - Prior experience with the Milestone Server API is highly desirable. - Ability to create and implement APIs. Please note that if a...

I have a number of digital files in PDF format that I need copy-typed. The project also involves basic formatting of the text. Ideal candidates for this project should have: - Excellent typing skills - Proficient in PDF handling - Basic formatting skills - Attention to detail

I need a professional translator to translate a series of legal documents from Arabic to English. The documents are primarily court transcripts in PDF format.

I need a skilled CodeIgniter developer to troubleshoot and modify my web application. The application is failing to generate customer account statements, and I need this fixed. The statements should be able to be generated in PDF format. Main Issue: - The created account statement not showing customers credit balance due amount Specific requirements: - Identify and rectify the issue preventing the generation of customer account statements. - Modify the application to allow for generation of account statements for any custom period. - Ensure the statements include the outstanding balance (I will provide a sample format). - Should provide the details of modification and codes for future backup. Ideal candidate should have: - Proven experience with CodeIg...

I'm seeking a freelancer to join my Twitch stream as an engaging viewer. Your role will primarily involve: - Asking questions related to the stream content - Engaging in conversations with other viewers The goal is to stimulate interaction and enhance the overall atmosphere of the stream. This position is perfect for someone who enjoys gaming and can contribute to a lively chat.

I'm looking for a proficient freelancer who can convert a PDF containing text only into a neatly organized Excel file. The main purpose of this conversion is for data manipulation, so the data will need to be structured in a way that facilitates this. Ideal skills for this job include: - Proficiency in Excel - Experience with data manipulation - Attention to detail The data should be organized in a single sheet. Freelancers with experience in similar projects would be preferred.

I have a 22-page PDF that needs to be converted into an Excel workbook. Each page of the PDF should correspond to a separate tab in the Excel file. The project involves reformatting images and adding specific information. Specific Tasks: - Convert each page of the PDF into its own tab in the Excel workbook. - Reformat the content of images on each page into text within Excel. - Add ordering information and my logo to the bottom of each page. - Transform images into text using OCR (Optical Character Recognition). Ideal Skills: - Proficiency in Excel and PDF conversion. - Experience with OCR software or tools. - Attention to detail for accurate transcription and formatting.

...checkout process and customer account management. The ideal candidate should be proficient in .NET, HTML, CSS, JavaScript, SQL Server and Bootstrap. Key Responsibilities: - Develop three new pages for checkout and customer account management - Implement functionalities including profile updates, order history tracking and wishlist management - Ensure all new pages adhere to the existing design and are optimized for both desktop and mobile - Significantly simplify the navigation to improve the overall user experience The ideal freelancer for this project should have: - Extensive experience in .NET and eCommerce application development - A strong background in front-end technologies such as HTML, CSS, JavaScript and Bootstra...

To export PDF with enhanced data from excel sheet and chatgpt integration. The goal is to automate this process including data extraction, data enhancement, pdf export

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

...an experienced and detail-oriented Social Media & Customer Service Manager to enhance the online presence of our mission-driven brand. We promote diversity and inclusion for young kids through thoughtfully designed products. This role combines managing social media interactions with providing excellent customer service and handling order management to foster a positive community and ensure customer satisfaction. Key Responsibilities: Social Media Management: - Develop and schedule regular posts across various social media platforms (Instagram, Facebook, Twitter, etc.) using provided content. - Respond promptly to comments, direct messages, and tags to engage with followers and build community. - Monitor social media trends and...

Ich suche eine/n erfahrene/n Netzwerk-Spezialisten/in für die Erstellung einer Praxisarbeit im Fach "Netzwerk Planung, Design & Optimierun...Netzwerk-Spezialisten/in für die Erstellung einer Praxisarbeit im Fach "Netzwerk Planung, Design & Optimierung" (NPDO). Ziel ist die Umsetzung eines redundanten Netzwerkdesigns sowie die Planung von VLAN, Subnetzen und Routing mit OSPF in Cisco Packet Tracer. Die vollständige Aufgabenstellung ist als PDF beigefügt. Voraussetzungen: - Erfahrung mit Cisco-Netzwerkkomponenten - Sicherer Umgang mit Cisco Packet Tracer - Kenntnisse in VLAN- und Subnetzplanung sowie Netzwerksicherheit Abgabeformat: Word & PDF-Dokument und .pkt-Datei (siehe Aufgabenstellung) Für das genaue Format der Arbeit ...

...both Word Document and Publisher for Grades 5, 7, 8, and 9. I will provide the topics and types of questions, as well as the textbook students are using to ensure the assessments are at the appropriate level. Key Responsibilities: - Create 1 assessment for each grade - Follow provided guidelines in terms of format, fonts, sizes, etc. - Produce 3-5 sample questions for review and approval before proceeding Ideal Candidate: - Proficient in both Word and Publisher - Prior experience in creating educational assessments - Strong understanding of math topics appropriate for Grades 5-9 - Excellent attention to detail and ability to follow specific instructions Please note, the types of questions will include a mix of multiple c...

...seeking a skilled Laravel and Vue JS developer to create an interactive Quotations module for our project. This initial module will include basic CRUD functionalities like List/View, Create, Edit, Delete, and Search. If this module proves successful, there's potential for a long-term contract involving the development of 10 additional modules. Key Requirements: - Develop a modern and interactive user interface for the Quotations module. - Implement basic CRUD features. - Integrate with our existing user authentication system, which includes login and various other features. - Incorporate additional features such as exporting to PDF and sending email notifications. - Ideally, the freelancer for this project will have significant experience ...

Office Assistant (Arabic and Indonesian Language Proficiency Required) We are looking for a full-time online Office Assistant who must be fluent in Arabic and Indonesian. The role primarily involves office-related tasks, and key responsibilities include: 1. Welcoming and interacting with 7-9 clients daily, explaining the benefits of our services, addressing their questions, and persuading them of the value of our offerings. 2. Demonstrating excellent communication skills, persuasiveness, quick thinking, and professionalism are essential. This is a position with no requirement to attend our office physically. However, the following conditions must be met: 1. A quiet room free from noise and distractions. 2. A stable and...

I'm seeking a skilled Excel expert to create an interactive, monthly reusable Excel document based on the Georgia ST-3 form. I've got a PDF version, but I need a tailored Excel one with formulas to compute specific totals. Key Requirements: - The layout should be similar to the PDF but does not need to match exactly. - Formulas to total Sales Tax and State Tax - Inclusion of a 'Clear' button to reset data - Pre-filled templates for each month Ideal skills for this job include advanced Excel proficiency, experience with tax forms, and a good eye for detail.

...interact with users by asking career-related questions about their profile. Based on their responses, the site will conduct an analysis using data from public industry reports to provide insights on industry trends and benchmarks. Key Features: - User Interaction: The website should be able to ask users a series of career-related questions. - Data Analysis: After collecting the responses, the site will analyze the data against public industry reports. - Insights Generation: The analysis should include insights on industry trends and benchmarks. Ideal Skills: - Web Development: Strong skills in creating interactive websites. - Data Analysis: Experience in interpreting and analyzing data. - Industry Knowledge: Understanding of public industry reports ...

...industry. This tool will be used to keep comprehensive records of all our manuals, guidelines, and overhauling reports. It should be able to generate responses based on these records when needed, with references to particular documents. Key Requirements: - The AI tool should process information from our current documents, which are all in PDF format (sizes may go upto 50MB). - It should be able to generate summarized information and direct excerpts from the documents. - The primary users of this tool will be our engineers. Ideal Skills and Experience: - Expertise in AI and machine learning. - Experience in software development for the engineering or power plant industry. - Ability to understand and process technical documents. - Experience in ...

I'm in need of a creative, cartoonish-style birthday card for my daughter. The design should incorporate her photo and be delivered as a printable PDF sized as a standard greeting card (5x7 inches). Given the urgency, I require this within a week. Ideal skills for this project would include graphic design, photo editing, and a knack for playful, kid-friendly aesthetics.

I'm looking for a talented full-stack developer to help with my website project. Ideal Skills: - Proficiency in both front-end (HTML, CSS, JavaScript) and back-end (Node.js, Ruby, Python, PHP) technologies. - Experience with responsive design and mobile-first approach. - Familiarity with database management (SQL, MongoDB). Experience: - Previous work on website development. - Proven track record of delivering quality work on time. Please note, the purpose and design style of the website have not been determined yet, so flexibility and creativity are key.

...reliable and accurate information to our client. JOB DESCRIPTION: • Arrive at the location at least one hour before the appointment with the subject company and make sure you have arrived at the correct location. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the subject company’s environment • Conduct an interview inside the premises following the client's guidance using Zoom virtual meeting application • Obtain the necessary documents as per requirements • Do not leave the site without permission from Confirmis Business Analyst REQUIREMENTS: • Must be living in Singapore (preferably near Cuppage Road) • Own a sm...

Hello Designer, I need a vectorized PDF of the image in the attachment. The motif should be adopted exactly as it is. Final size is about 130x70 inches.

I need a Pdf Document catalogue altered to replace all references of KASHON with DARVIS. This includes images, the body of the text, and the logo. The correct DARVIS logo will be supplied. Also change the highlighted reference numbers starting with KSR to be changed to DAR. All pages not highlighted to be removed and the index to reflect what is left in the catalogue. Appropriate page numbers and index numbers to reflect what is on each page Key Tasks: - Replace all instances of KASHON with DARVIS - Update the catalogue with the supplied DARVIS logo - Edit text content as specified Ideal Skills: - Proficient in Microsoft Word - Attention to detail - Capable of editing images and text within a Word Document This is a straightforward task requiring n...

I need an intelligent app or program that ...program that can extract data from various document types and layouts and then transfer it into a standardized form. The app should utilize AI to accurately interpret different terminologies for the same data points across documents. Key Requirements: - The app should process PDF, Word documents, and scanned images. - It should extract both text and tables from these documents. - After data extraction, it should transfer the information into a standardized Word document. Ideal Skills: - Proficiency in AI and machine learning - Experience in creating intelligent document processing systems - Strong programming skills for app development This project is perfect for someone who has a knack for creating ...

Customized Form in PHP with Secure SQL Database including online deployment We are seeking to develop a aesthetically pleasing, and secure web-based form integrated with a SQL database. This form will facilitate and receive applications for a monthly token draw for 10,000 lucky users, each winning 1,000 tokens(Max application per month 1 Million). Selection of winners will be taken care separately and is not part of the project. The project requirements are as follows: User Authentication and Entry Implement Telegram API integration for user login, ensuring unique entries. Display the current draw month prominently after login, e.g. Heading, " Draw for the month of January 2025." Prevent multiple entries: Check if the user has alrea...

I'm looking for a skilled mobile app developer to create a CV Builder app. The app should allow users to select from predefined resume templates and have a user-friendly interface to input details. Key Features: - Template Selection: Users should be able to choose from various predefined resume templates. - Automated Content Suggestions: The app should provide intelligent, automated content suggestions to help users build their CVs. - Download Options: Users should be able to download their CVs in PDF or Word format. - User-friendly Interface: A key requirement is a simple and intuitive interface for users to input their details. The ideal candidate for this project should have: - Proven experience in mobile app development, preferably with CV or resume builder ...

...store their answers locally. Goal is to create an MVP of this app. The app will have two potential options: Option 1: Simplified Local App Users can add players directly within the app. For each player an subcategory year can be created The subcategory "Year" will have 40 fields, to type in their answers All data is stored locally on the user’s device. No registration or login required. Option 2: QR Code-Based Data Transfer Same features as Option 1 but with the ability to transfer data between devices using an encrypted QR Code. Data is stored locally on the user's device, and the QR Code enables portability without requiring a backend. For each option, I would like a fixed-price offer that includes the following: Estimated development tim...

I'm seeking a freelancer who can assist me with typing out content from Scanned Images and text document PDFs. The primary goal is to create an editable document that closely mirrors the original formatting of the PDFs. Ideal Skills and Experience: - Excellent typing speed and accuracy - Proficiency in word processing software - Attention to detail to replicate original formatting

I need a freelancer who can automate the extraction of text data from PDF files. The extracted data will need to be stored in a clean and organized manner. Experience with data extraction, automation tools and scripting languages is highly desirable.

...Purpose To create feature-rich, paid educational website focused on OC (Opportunity Class) and Selective School Test preparation which is mobile phone compatible as well. Both test formats will have two sections on Thinking Skills and Mathematical Reasoning. The website aim to deliver exceptional user experiences, seamless content management, and advanced SEO practices to maximize visibility, traffic, and user acquisition. All questions are multiple-choice. OC Test Overview • Test Sections: each test contains o Thinking Skills: Number of questions: 30 questions. Time allowed: 30 minutes Options for each question: 4 o Mathematical Reasoning: Number of questions: 35 questions. ...