Sql query interview questions and answers pdfKazi

I need a simple database to track customer information including name, phone number, serial number, expiry date, and notes. The database should be accessible through a web application. Key Requirements: - Design and build a basic, user-friendly database - Ensure it can be accessed through a web application - Use either WordPress or a custom HTML/CSS/JS framework Ideal Skills: - Experience with SQL and NoSQL databases - Proficient in WordPress and HTML/CSS/JS - Prior experience in creating web-based databases - Good understanding of customer tracking systems I am unsure about the type of database to use, so the freelancer should have the expertise to recommend and implement the most suitable one. The primary goal is to have an efficient system t...

...professional developer to create a mobile application for **Android** and **iOS** using **Flutter**. The app aims to help users monitor their dental health, record the condition of each tooth, log treatment history, and receive appointment reminders. It will also include spaces for displaying customized advertisements. --- ### **App Structure** #### 1. Home Page - The page includes the following elements: - **App Logo** at the top. - **Ad Section**: - Supports displaying customized ads, including images, links, texts, or promotional offers. - Dynamic ads can be updated from the server without requiring an app update. - **Bottom Navigation Bar** with four main sections: - **Home**: Displays the main page with ads and promotional messages. - **...

I'm looking for a skilled WordPress developer & tutor to create a set of sample template pages for a WordPress site to host our all-volunteer podcasts, blogs and videos. Key Requirements: - The site should have a clean design, focusing on ease of navigation, and ability to view episodes by Category or Tag or Author - Incorporation of a Blubrry video podcast player on a sample Podcast episode page - Website to include Pages with Query Loops showing podcasts & blogs & videos by Category or Tag Ideal Skills: - Proficiency in WordPress - Experience with podcast and blog site development - Strong understanding of WordPress query blocks and block design Our current status: - We have an installed site, hosted by GoDaddy, using a Wor...

I have a 242 page PDF payroll report with 9 or 10 employees' data on each page as a row. Format is the same for all pages. Need to take off only 6 of the entries per row that will be the columns. the finished product EXCEL spreadsheet is attached as a file here. One row on person's pay-week. One entry, the pay period ending is at the bottom of each page in the right hand corner. Same date for the employees on that page. A sample page of PDF is also attached as a file.

...thumbnails of the products both the sales order and in the Sales exported pdf, it must be showed like this plugin does (without using plugin) 2- We need to create a generic product that allows through the attributes of its dimensions to define a price based on a price list. For example, the generic product is: “graphics” being this 200x100 (this is requested by Odoo when inserting the product that includes these attributes) when we define that the material is vinyl, the price will be 800, but if we indicate that the material will be Foamboard, the price will be 1500 (this is connecting a price list to this variable). we need a coding that allows the product description to show the measures and the material in the format: Printed vinyl (200

...theme. - Include essential information such as registration details in a clear and compelling manner. - Incorporate one or two QR codes into the flyer, which will link to our league's website for easy access to further information. -The league begins 26 Jan -League takes place at Bourgade Catholic High School -Address is: 4602 N 31st Ave Phoenix, AZ 85017 United States -The flyer once sent over to me needs to be able to be edited so that I can add QR codes. -The game times will be start at 2 PM with the last game starting at 5 PM on Sundays starting 26 January. The opening ceremony for the first season will go about 30 to 45 minutes before the first game. -Please contact with any other questions Ideal Skills and Experience: - Previous experience designing spor...

I'm looking for a seasoned Machine Learning expert who can help me with my project. The details of the project are still being finalized, hence the questions regarding the specifics were skipped. Skills and experience required: - Advanced knowledge of Machine Learning techniques. - Proficiency in handling various data types, including but not limited to image, text, and sensor data. - Previous experience in a similar Machine Learning project is a plus. - Ability to understand and work with project details that are still being finalized. Please provide examples of your previous work in the field of Machine Learning. I'm particularly interested in seeing projects where you had to work with complex data sets. Looking forward to your proposals.

I'm looking for an experienced technical writer to create a comprehensive PDF installation guide for a manufactured water recycling system. Ideal Skills: - Technical writing - Hardware installation expertise - Experience with environmental technology products Please provide examples of similar projects you've completed.

Tecnologías y Herramientas a Revisar: Frameworks y Lenguajes de Programación: Laravel HTML CSS Flutter SQL (Server RDS de AWS) PHP JavaScript nativo Bootstrap Maquetado con UIKit APIs: Creador de Códigos QR (ME-QR) (Falta integrar) CRM (Falta integrar) Fedex/DHL/UPS (Tracking y Label printing) (Falta integrar) Pasarelas de Pago: PayPal (desarrollado) Stripe (desarrollado) Criptomonedas (Falta integrar) Servicios de API: Google Maps (para direcciones cuando el pago es a través de tarjeta de crédito, dirección del usuario [scraper]) Mailgun (para envío de emails del sistema) Servicios en la Nube: AWS (Amazon Web Services) Requisitos de Revisión: 1. Preparación para la Escalabilidad en Múltiples Idiomas: Configurar ...

I'm seeking a proficient typist to transcribe PDF files into a professionally formatted document. Requirements: - Transcribe text from PDF files to a Word document or similar. - Strict adherence to a specific company template and style guide. - Prior experience in professional/business copy typing is essential. - Ability to maintain high levels of accuracy and attention to detail. - Familiarity with standard formatting and ability to follow custom instructions or templates. Please include in your proposal examples of previous similar work. Thank you.

I need a professional map designed to highlight a piece of land for a sales brochure. This will need to include: - Property boundaries - Nearby landmarks - Road access - Power and gas lines The map should have a simple and clean style. The final deliverable should be in PDF format. Ideal skills and experience for the job include: - Proficiency in cartography or GIS software - Graphic design skills - Experience with creating maps for sales or promotional materials

I'm seeking an experienced SQL Database Administrator to assist with a critical issue involving a corrupt Microsoft SQL Server database Must be able to help within a couple of hours if this post. The situation is as follows: - I have restored to an earlier/healthy backup, but I would like to revert back to the corrupted database and attempt repair. - The specific issue encountered with the corrupted database involves data loss. - I do have access to other backups, which may be useful in the repair process. Ideal candidates for this project should have extensive experience with Microsoft SQL Server and database recovery techniques. Proficiency in assessing the integrity of transaction logs and other backups, as well as implementing effecti...

Documento de Requisitos para Revisión de Código Tecnologías y Herramientas a Revisar: Frameworks y Lenguajes de Programación: Laravel HTML CSS Flutter SQL (Server RDS de AWS) PHP JavaScript nativo Bootstrap Maquetado con UIKit APIs: Creador de Códigos QR (ME-QR) (Falta integrar) CRM (Falta integrar) Fedex/DHL/UPS (Tracking y Label printing) (Falta integrar) Pasarelas de Pago: PayPal (desarrollado) Stripe (desarrollado) Criptomonedas (Falta integrar) Servicios de API: Google Maps (para direcciones cuando el pago es a través de tarjeta de crédito, dirección del usuario [scraper]) Mailgun (para envío de emails del sistema) Servicios en la Nube: AWS (Amazon Web Services) Requisitos de Revisión: 1. Preparación...

I have 2 PDF flyer files that I need to be inserted into an Illustrator (AI) template. The flyers will require some image adjustments for proper fit and visual appeal. Ideal skills for this job would include proficiency in Adobe Illustrator and experience with image adjustments. Previous work with similar projects would be advantageous. Please ensure you can handle PDF files and have an understanding of image editing within Illustrator. Attached is the template for the print shop, i need both of our flyers art work put into the template and according to print shots specs please send us the file in PDF, 300 DPIs, in CMYK.

I need a professional to help me edit a 10-page PDF file. The edits primarily involve text changes and some format adjustments. Key Requirements: - Proficient in PDF editing - Able to make text changes seamlessly - Experience with format adjustments to maintain document's aesthetics and readability I have the original document, which is also in PDF format. Please note that there won't be any image changes required for this project. Skills and Experience: - Prior experience with PDF editing software is mandatory - Attention to detail is crucial - Strong background in document formatting is preferred Looking forward to your bids.

...upcoming e commerce Jewelry business. 1. Manage and make social media posts. 2x 2000-word blog articles written monthly. Weekly promotions creation, Biweekly video post. 2. Google Business Profile and other social media profiles launched, verified & optimized 2.1 Google Reviews displayed on the website On-demand reviews collection Monthly Google Business Profile post. 2.2 Displaying Google Reviews on jewelry website, as way to build trust and credibility with potential customers. Here are some steps to be fulfilled: • Collect Reviews: Encourage customers to leave reviews on Google. This can be done by sending follow-up emails after a purchase, asking for feedback, and providing links to your Google My Business page. • Set Up Google My Business...

My PHP application on a Windows Server 2016 is unable to connect to a remote SQL Server. It seems the sqlsrv_driver is missing. I need an expert to troubleshoot this issue and restore connectivity. Must sure work is remote

I'm looking for a professional with extensive experience in Kicad and PCB design. The task involves converting a PDF schematic into a Kicad project and then designing a PCB based on this project. Key Requirements: - Exact replication of the provided PDF schematic in Kicad. - Utilization of standard components as indicated in the schematic. - Design of PCB suitable for industrial applications. Ideal Skills: - Proficiency in Kicad and PCB design. - Prior experience designing PCBs for industrial use. - Attention to detail to ensure an exact replica of the PDF schematic. Please do not bid if you do not have the necessary experience and skills, as I will not be able to consider your application.

I am looking for a freelancer to help integrate GoHighLevel with Zoho CRM. This integration should enable GoHighLevel to be used as a messaging and VOIP solution, while keeping data synchronized with Zoho CRM. The solution should work seamlessly on both web and mobile apps. Since I resell GoHighLevel to my clients, I need this integration to be applicable to selected subaccounts. Below are the detailed requirements for this project: General Integration Requirements: Lead/Contact Details in GoHighLevel Inbox (Web and Mobile) Display lead or contact details in the right sidebar of the inbox or the details section of the LeadConnector mobile app when interacting with messages or calls. Creating New Leads in Zoho CRM Whenever a new message is received (e.g., via WhatsA...

SERIAN PRESENTACIONES EN PPT O PDF, PARA DAR CHARLAS, CAPACITACIONES Y OTROS

Tafadhali Jisajili ama Ingia ili kuona maelezo.

...compelling and visually striking company profile that resonates with our brand's identity. The profile should eloquently narrate our company history, showcase our services, and highlight client testimonials, all within a modern, vibrant design aesthetic. Key Requirements: - Design should be clean yet engaging - Attention to detail is crucial for professional visuals and brand consistency - Timely delivery of high-quality work Ideal Candidate: ✅ Proven experience in designing company profiles or similar branding materials ✅ Proficient in design software like Adobe Illustrator, InDesign, or Canva ✅ Excellent portfolio featuring previous work on company profiles, brochures, or similar projects Final Deliverables: The profile should be available in both a print...

I need a skilled freelancer to design a job application form on Google Forms. The form should have conditional elements, such as additional sections appearing based on the applicant's answers. Key Requirements: - The form should collect specific details including Personal Information, Work Experience, and References. Additional sections may be included, such as right to work. - The form does not require any file uploads or document attachments. Ideal Skills and Experience: - Proficiency in Google Forms - Experience with designing forms with conditional elements - Understanding of job application process to anticipate necessary form sections - Attention to detail to ensure all aspects of the form function correctly

I'm seeking a professional quantity surveyor or cost estimator to assist with pre-construction cost calculations. The data for this task is readily provided. Key Responsibilities: - Analyze pr...professional quantity surveyor or cost estimator to assist with pre-construction cost calculations. The data for this task is readily provided. Key Responsibilities: - Analyze provided data for material and labor costs, as well as total project costs - Conduct detailed cost estimations - Provide clear, concise findings Ideal Candidate: - Extensive experience in quantity surveying - Proficient in cost estimation techniques - Strong analytical skills - Good communication skills for reporting findings My budget is very limited. Let me know if you can do it for $10. There are 2 ...

I'm in need of a Go developer who can write clean and efficient Go code for our backend services. The ideal candidate should have experience with both SQL and NoSQL databases, and a deep understanding of concurrency patterns, RESTful APIs, and microservices architecture. Key Responsibilities: - Writing and optimizing scalable backend services. - Debugging and troubleshooting software issues. - Integrating with both SQL and NoSQL databases to ensure seamless application functionality. - Testing and deploying applications with Docker and Kubernetes. Skills Required: - Proficiency in Go syntax and tooling. - Strong understanding of concurrency patterns (goroutines and channels). - Experience wit...

...web developer who can integrate an instant pro-forma quotation generator into my website. Users should be able to download a PDF invoice after entering some basic details and selecting their desired services. Key Features: - User Input: Users need to enter their company name, email ID, and an optional phone number. - Service Selection: Users can choose from various service packages (Service A, Service A+B, Service A+C, Service A+B+C). - Simple Validation: A straightforward tick mark captcha for validation. - Invoice Options: Users should have the choice to either download the invoice or send it to their email. - Invoice Format: The invoice should be exclusively in PDF format. - after user generates this invoice a copy of the same with the user entered detai...

I am seeking an experienced YouTube Channel Project Manager to help set up and launch a new YouTube channel dedicated to rare and unusual short experimental art films. The master project is to create and launch the new channel, offering 500 short films for the Launch to create a substantial initial offering. I need someone based in the UK, to work with the physical hard archive. The film formats are primarily DVDs and USBs, and also some VHS tapes. The DVD films and the VHS films will need to be converted to MP4 format for uploading to the YouTube Channel. *nota bena the small quantity of VHS films can be omitted, (to be converted and uploaded separately later), if not easily possible to do at this stage. Deliverables 1. Provide a writte...

...streamline the process of showcasing products, receiving RFQs (Request for Quotes), and enabling the business to reply with pricing details efficiently. The website will also allow users to upload references for custom products and capture additional RFQ-specific details like quantity and delivery location. 2. Functional Requirements 2.1 Homepage • Brand Representation: • Display brand name and logo prominently. • Navigation Menu: • Product Categories • About Us • Contact Us • Product Categories: • Categorized display of imitation products for easy browsing. • About Us Section: • A concise company profile highlighting business vision and expertise. • Contact Us Section: • Includes business e...

We are searching for a Nutshell CRM expert for a remote contractual role. The selection process begins with a non-paid Zoom interview to determine candidate suitability. Following successful interviews, an initial one-hour paid assessment will be conducted to evaluate your skills in optimizing and aligning our CRM system with strategic business needs in sales, marketing, and customer service. Based on performance, further contractual work may be offered.

...Coordinator for the Woodland Trust, I am tasked with designing a comprehensive Volunteer Handbook and preparing an accompanying report for our upcoming event. This project will entail: A. Crafting a detailed, engaging, and informative Volunteer Handbook suitable for both new and experienced volunteers in both digital eBook and printable PDF formats. B. Compiling a report that encapsulates: 1. An introduction detailing the mutual benefits of volunteering to the organization and the individuals involved. 2. An outline of the specific job roles and specifications for our volunteers. 3. A rationale justifying the content and structure of the Volunteer Handbook. 4. A Gantt Chart laying out the timeline and tasks for our voluntee...

...navigation and usability. Currently, our platform is only available on the web. Your task will be to elevate the platform’s design, allowing for a more intuitive and user-friendly experience. Ideal Skills: - Proven Experience in Web/App Development: Expertise in creating and enhancing real estate platforms, with a solid understanding of the real estate industry’s needs. - Proficient in Key Technologies: Hands-on experience with , HTML, and website design principles, with a strong ability to integrate front-end and back-end technologies effectively. - UI/UX Design: A good eye for design, able to create intuitive interfaces that enhance user engagement and improve the overall user journey. - Collaboration: Ability to work closely wit...

...allow users to easily add, remove, move, and resize elements such as: • Text boxes • Images • Graphs/Charts • Tables • Buttons • Inputs • Selectors • Rectangles/Circles The interface must be intuitive, supporting drag-and-drop functionality and easy configuration of element properties. We have already prepared a GitHub repository with the communication interface and data structure, along with a basic project structure and a ready-to-use working environment. Additionally, we have a PDF document with a visual outline of the general layout for the editor. Key requirements: • TypeScript, React, and Node.js expertise. • Experience in developing visual, user-friendly interfaces. • Abilit...

I'm looking for a skilled Python developer who can create automation scripts for me. The main task is to modify various properties of PDF files. Key Requirements: - Expertise in Python with a focus on automation scripts - Experience with PDF manipulation - Ability to create efficient and effective automation scripts The ideal freelancer for this project will have a strong background in Python and experience with creating automation scripts specifically for modifying PDF properties. Main requirement is to manipulate the font properties of pdf without changing the actual font used in pdf.

I'm in need of a site plan for a residential development. The plan should include: - Two pads measuring 40' in depth and 160' in length, set 40' off the road for setbacks and driveways. - Two additional pads, each 30' x 300', located at the rear of the property with a road leading in. The use of GIS dimensions for mapping is essential, and all setbacks should be clearly indicated. The final plan needs to be delivered in PDF format. Ideal candidates for this job should have experience with residential site planning and be proficient in creating basic layouts with dimensions. I'll furnish exact locations for final drawings.

I'm looking for an expert in NiFi who can help me establish a real-time data integration system from SQL Developer to PostgreSQL. This is a ground-up project, meaning no existing workflows or systems will be used. Key Responsibilities: - Create NiFi workflows from scratch to facilitate real-time data integration. - Perform necessary data operations in transit, including filtering, enrichment, and aggregation. Ideal Skills and Experience: - Extensive experience with Apache NiFi. - Proficiency in SQL Developer and PostgreSQL. - Strong understanding of data operations like filtering, enrichment, and aggregation. - Ability to create complex workflows from scratch.

Milestone 1: Core System Setup, Wall Upload, and Measurements Timeframe: Week 1 Deliverables: System Setup: Set up the project environment (hosting, database, and front-end framework). Basic UI for file uploads, wall measurements, and system navigation. Wall Image Upload and Measurements: Allow users to upload images of four walls. Add a feature for designers to input wall measurements (height and width). Compile uploaded images into a full wall view, incorporating measurement data for accuracy. Milestone 2: Product Management and Customization Tools Timeframe: Week 2 Deliverables: Product Upload and Management: Allow designers to add products such as wallpapers, furniture, curtains, lighting (downlights), and plaster ceilings ...

Create an image in Photoshop or Illustrator showing 6 snowmen. The faces of the snowmen should again be the 6 people from the portraits in the appendix. In other words, the final image should show the 6 people as snowmen. I am always available for questions. Flo

I’m seeking a creative and experienced graphic designer to design engaging and professional covers for 5 e-books that I will use as "Lead Magnets" to promote my fitness business. These lead magnets are aimed at professional Black women aged 40+ who are looking to improve their health, lose weight, boost energy, and regain confidence. The final covers will be promoted using Facebook Ads, so the designs must comply with Facebook's advertising policies: No images of women with measuring tapes No women standing on scales Focus on empowering, healthy, and confident visuals instead. Design Details Design Goals: Attract professional women aged 40+ who are ready to make a positive change in their health. Reflect values of confidence, health, vi...

I need an expert to redraw some architectural plans from PDF or JPEG into AutoCAD. The redrawn plans must adhere to specific layers I will provide. The final AutoCAD drawings need to be delivered in DWG format. Ideal Skills: - Proficiency in AutoCAD - Experience in architectural drawing interpretation - Attention to detail in layer application - Ability to deliver in specified file format Please ensure you can work with specific layers before bidding.

...project that requires creativity, attention to detail, and mastery of animation techniques. The project involves [briefly describe the nature of the project, e.g., "creating promotional videos," "explainer animations," "logo reveals," etc.]. What We're Looking For: Proven experience in motion graphics and animation. Proficiency in [specific tools, e.g., Adobe After Effects, Adobe Illustrator, Adobe Photoshop]. A creative portfolio showcasing your motion design work. Ability to meet deadlines and communicate effectively. Important Note: To ensure we select the right fit for this project, shortlisted candidates will be required to complete a small test task. This will help us assess your skills, style, and approach to animati...

I need a skilled professional to edit some PDFs and create new ones that match the existing style. The editing mainly involves text modifications and layout adjustments. Ideal Skills and Experience: - Proficiency in Adobe Illustrator or any other vector editing tool. - Strong attention to detail to ensure new PDFs match the style of existing ones. - Experience with text modification and layout adjustments in PDF files. - Able to work with files uploaded directly. Please bid only if you have the necessary skills and experience.

...developer to create a feature-rich PDF application for both iOS and Android. Key Features: - User-friendly interface for general public use: Ability to create and delete folders, save PDF / video / voice files, write notes (both handwritten and typed), and highlight on PDF files with customizable colors. - Comprehensive file management: Users should be able to move, copy, add, delete files and folders seamlessly. - Device Compatibility: The app should function smoothly on regular phones and tablets. - Customizable Branding: I need the flexibility to replace the company icon manually. - High-Level Security: The app requires advanced encryption for managing files and folders to ensure data security. - Search within PD...

I need an experienced architect who can modify my existing house site plan and architectural plan for a renovation project. Key Responsibilities: - Assess and modify the existing architectural plan specifically for the house site. - Ensure the new design meets all necessary building codes and standards. Ideal Skills and Experience: - Proven experience with architectural software - Excellent communication skills to discuss and explain design modifications. Delivery of project must be in editable file (dwg, rvt)and architectural PDF

I'm seeking a talented illustrator wit...children's adventure book to life. The book is targeted at 3-5 year olds, so the illustrations need to be engaging, colorful and easy for this age group to understand. Key requirements: - Cartoonish illustration style - Experience with children's book illustrations - Ability to deliver high-quality work within a one-day timeframe -cover page included -Add the story lines on each page with the illustration Extra: -Ebook/pdf format is a plus The ideal freelancer for this project will have a portfolio showcasing their work in the cartoonish style, particularly with adventure themes and targeting the 3-5 year age group. A quick turnaround time and the ability to understand and implement feedback swi...

..."Pup's CleanUps." I played around with AI and got logo that I like. I've attached a screenshot of it. I like the simplicity of it and how it blends a puppy and a piece of poop together in a cute way. Bonus points if you can make the logo a little more cute and endearing. I also need the designer to recommend which font should be used. I'm looking for a designer who can transform this into a comprehensive logo package. This includes turning it into vector images, designing icons, creating a Favicon, and preparing a business card design. Key requirements: - Artistic creativity to design a modern-style font that complements the logo - Proficiency in delivering the package in specified file formats: PNG, SVG, PDF, and...

I have a set of house plans for a single-story home that I need modified. ...required is converting the garage from a front entry to a side entry. The original house plans are available in a PDF format, and aside from the garage entry modification, no other alterations are needed. On the attached Shadowcrest plan, I want the garage relocated to the right side elevation. The new front elevation where the garage used to be I want to look like the front garage wall from the Oakdale plans that are attached. Ideal Skills: - Proficiency in CAD software - Experience with residential architectural plans - Attention to detail - Ability to work with PDF house plans What I Require: - Modification of house plans for side-entry garage - Return of modified plans in PDF for...

I'm in need of a web scraping expert to extract text data and download approximately 150,000 to 200,000 PDF files from a specific website. Key Tasks: Extracting text content from specific pages/sections of the website. Downloading and organizing a large volume of PDF files available on the site. Delivering: The text data in CSV/Excel format. The PDFs in well-organized folders. The Ideal Freelancer Should Have: Expertise in web scraping tools such as BeautifulSoup, Scrapy, and Selenium. The ability to efficiently handle pagination and dynamic content. Experience managing large-scale scraping projects, especially with high data volumes. A commitment to compliance with the website’s terms of service. A proactive approach to providing r...

I'mlooking for SAP Document Standard training materials specifically focused on SAP Finance. The training should be delivered in PDF format. AC010 AC200 AC205 AC210 AC305

I'm looking for an Android developer to create a straightforward, question-based app. The app will generate a PDF based on user responses. Key Features: - Multiple choice questions - PDF formatting in a table layout - Mandatory user login Ideal Skills and Experience: - Proficient in Android app development - Experienced in creating apps with PDF generation - Familiar with user login systems in apps - Can design user-friendly, simple interfaces