Sql query interview questions and answers jobs
Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.
Greetings, I am looking for a professional both able and creative to deliver our group presence to the web in style. Our project is based in Brazil and should be multilingual (native in Brazilian Portuguese with the ability to include further languages like english, spanish and french in the future) Our idea of the whole website concept and areas are as follow, Home Page: Presentation of Equità Ltda. Links to the main areas of the site (Equita Club Deals, Equità Bio Casa Imobiliária, Equità Construction Products and Services). Equita Club Deals (private P2P functionality): Login/Register Projects page Investor dashboards Access to documents and contracts Equità Bio Casa Imobiliária: Property listings (...
...well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation ...
Give me what you can for 2 hours of transcription to text of oral interview “Gums and Gossip” Interview
Project Overview: I am developing an RC plane equipped with a processor and a camera, designed to stream real-time video to a React Native Android application. While I have already built the plane and the application, I am currently experiencing a latency of 1-2 seconds in the video stream. My goal is to reduce this latency to 100-200 milliseconds. I am seeking a freelancer to develop a script that will run on the processor mounted on the RC plane, ensuring the video stream meets the desired latency requirements. Project Requirements: Objective: Develop a script to reduce video stream latency to 100-200 milliseconds. Ensure the script runs efficiently on the processor mounted on the RC plane. Integrate the low-latency video stream with the existi...
...freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user interface for three distinct profiles: clients (bailiffs), service providers (drivers, couriers, movers, locksmiths), and administrators. Integrate a real-time booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and...
...**About the Role:** We are on the lookout for a talented Full Stack Developer with a flair for mobile development and UI/UX design. You'll take charge of designing, coding, and modifying mobile applications to enhance user experience. This role requires collaboration with cross-functional teams to bring new features to life and ensure our applications are both robust and responsive. **Key Responsibilities:** - Design and build advanced applications for both iOS and Android using frameworks like Flutter. - Work alongside other teams to define, design, and deploy exciting new features. - Focus on application performance and user experience. - Maintain high standards of code quality and push for continuous improvement. ...
...messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous t...
I'm currently in need of an Android app developer to assist in a production task app on Google Play Consol Your main tasks will include: - Assisting with finalizing the app for production - Providing insights on submission process I'm unable to provide specifics on the app's features, main purp...currently in need of an Android app developer to assist in a production task app on Google Play Consol Your main tasks will include: - Assisting with finalizing the app for production - Providing insights on submission process I'm unable to provide specifics on the app's features, main purpose or target audience as I have skipped those questions. The project will require someone with experience in Android app development, especially in the deployment and...
I'm in need of a mid-level recruitment specialist to assist me w...recruitment specialist to assist me with recruitment tasks. Key Responsibilities: - Conducting initial screening procedures for potential candidates - Sourcing and identifying suitable candidates for the role - Assisting with the interview processes via email I'm looking for someone who has experience in recruitment, particularly at the mid-level. It's essential that the freelancer is able to handle the recruitment process with minimal supervision. The ideal candidate will be able to provide insights and suggestions on improving our recruitment strategy. The candidate should have a good understanding of recruitment best practices, be organized and have good communication skill...
I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The project I have in mind is a custom web application that will require: - Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in thes...
...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Expe...
...who could provide critical assistance for an aerospace design project I'm currently working on. The tasks at hand include: - Answering a set of questions related to the project - Deriving concepts based on the information provided - Using MATLAB to conduct an aerodynamics analysis The main focus of this project is to improve the aerodynamics of the aircraft, which ultimately aims to enhance the overall efficiency and performance. This is a time-sensitive task, so I'm in need of someone who can deliver within the same day. Ideal Skills: - Aerospace engineering background - Proficiency in MATLAB for aerodynamics analysis - Strong problem-solving and concept development skills - Ability to work under tight deadlines Your expertise will be crucial in ensur...
We need logo for our fitness product brand "Styfit" which is a fitness brand, which we are going to lanuch in our e-commerce store I have attached a sample logo for your reference. Need source file with all the fonts and elements. if you have any questions, please dm me. Thank you!
...website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the database, and a Google Drive link. This way, buyers can easily access and use the leads without any hassle. Ideal candidates for this project ...
I'm looking to construct a unique and professional logo that will effectively represent the identity of my brand. The ideal design should: Brand Name : TATIF - Brand name to sell car accessories (Kindly avoid specifying as car accessories in logo ) - Reflect a professional, innovative, and trustworthy image - Use two elegant colors of your recommendation - Be versatile enough for marketing and social media usage - Need source file with all fonts and elements If you have any questions please DM me. A successful candidate will have proficiencies in branding and logo design. Your creativity will be the key to the final outcome.
...practice. The questions should cover Pharmacology, Biochemistry, and medicinal chemistry, providing moderate detail with references. This is a crucial resource for students aiming to pass their pharmacy practice exams. Key Responsibilities: - Develop a comprehensive question bank for pharmacy practice exams - Ensure the inclusion of questions from Pharmacology, Biochemistry, and medicinal chemistry - Provide moderate detail with references for each question Ideal Skills and Experience: - Proven experience in creating educational content, especially in the field of pharmacy practice - Strong understanding of pharmacology, biochemistry, and medicinal chemistry - Familiarity with the educational standards and requirements for pharmacy pra...
I...over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past work and a brief...
I'm preparing for the Azure AI 102 exam and specifically looking for help with the Natural Language Processing section. I need a comprehensive set of practice questions and answers specifically tailored to this area. Key Requirements: - Development of practice questions and answers: These should cover a broad range of topics within Natural Language Processing, aligning well with the exam's requirements. I need help in some questions and answers with right explanations
Hey there, I’m interested in building a kind of niche product, basically a coloring app framework for iOS and Android, but the app would use my own artwork. I’d like to be able to reskin it, update it, and add more images as I wanted - so maybe a template with placeholders that I could reskin? I did some basic coding long ago and I’ve bumped around in Swift a bit, so I think if placeholders were inserted I’d be okay doing the reskinning. Functionality that I’d be looking for: - iOS and Android both (maybe quote for each individually, in case we’d have to do one at a time due to cost?) - splashscreen while itloads, then on to the main screen - thumbnails of images, divided into themes - when the user clicks an image it’d...
Thank you for your responsiveness Tafsir. Let me know if you have any questions.
I'm in need of someone with strong experience in PostgreSQL for some critical tasks....in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your ...
i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it
We require a professional logo th...It needs to communicate reliability, credibility and expertise. - Please note that we do not have specific colours in mind for the logo. Feel free to suggest a color scheme that aligns with a professional image. - The design should be versatile and adaptable for use across different mediums, such as print, digital, and social media. Ideal Skills and Experience: - Experience in designing logos for brand identity. - Understanding of colour psychology and its application in creating professional and trustworthy visuals. - Proficiency in creating versatile logo designs that can be used across various platforms. - Ability to understand and incorporate the needs and values of a professional brand in...
I'm in need of 4 consumers based in Karlsruhe, and visit 8 stores per city. Your task will be to gather data specifically on the promotional displays and materials used for a well-known dairy brand. Important: Candidate has to be based in Karlshue or very close to it. Project outline: - 20 SKUS (Products) need to be assessed for the following: -Tidiness of shelves, package quality, time to find product and etc. -3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. -Consumer will assess 31 samples per a product in total. -No purchases required -Products include water, plant based and diary. -All data will be captured via an App thus good quality photos are needed. --Answer questions related to the p...
I'm looking for someone to integrate an existing machine learning model into a Di...cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient ...
...automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection a...
...for someone who can help craft UPSC civil services (CSE) mains exam questions for a coaching institution. Here are the details: - The questions should cover various subjects, with a primary focus on Science and Technology, Internal Security, and Indian Society. - The level of difficulty for these questions should be medium, striking a balance between challenging and accessible. - The end goal is to use these questions for mock exams, so they should be suitable for this purpose. Ideal candidates for this job would have experience with question framing, particularly in the context of competitive exams like the UPSC. I'm looking for someone who can provide a good mix of comprehension, analytical, and application-based quest...
Hello, I would like to pitch you my idea for a drawing. I have attached a couple of pictures to this message and have included my logo. This will be going on a white tee shirt. I would like it to be full of vibrant popping colors. I would like an old man sitting in the morning smoing a cigar, finishing his cup of coffee remebering his past love, a beautiful woman that he worked with at a cigar factory. The woman in his remberance would be rolling a cigar on her leg. I would like the memory to be coming out of the smoke that he is blowing out. I would like either burlop bags of coffee by his rocking chair with a coffee cup on it or on a barrel or rock or stool, something of that nature. I would like the background to be similar to the example picture i attached to this message. Mount...
For our upcoming company video, we need a proficient videographer who can come to our office to record an interview in a Studio interview-style. Key Requirements: - Capture the footage onsite at our office - Expertise in Studio interview-style videography - To bring lighting and backdrop elements Ideal Skills: - Excellent videography skills - Good knowledge in studio lighting techniques - Strong editing abilities We look forward to having a videographer with a good eye for detail and creativity to work with us on this project.
I'm looking to hire someone to design our food packaging bags. Specifically I need more than 10 packing designs for different food products. I'm open to suggestions from the professional I hire and will be guided by their expertise. Please let me know if you have any questions or suggestions for this project.
Beginner level freealancer to create an mcq list for mo...know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th...
Please Sign Up or Login to see details.
...monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to navigate for non-technical users. It is essential that this application runs efficiently on a Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL ...
I'm in need of a skilled SEO professional to help me improve my website's visibility and search engine rankings. Your main goals will be to increase organic traffic and ultimately increase leads/sales. Key Tasks: - Conduct an SEO audit to identify current gaps in the website's SEO - Implement on-page and off-page SEO strategies - Monitor and report on performance and any improvements Ideal Skills: - Proven experience in SEO optimization with tangible results - Knowledge of the latest SEO trends and best practices - Familiarity with tools like Google Analytics, SEMrush, and Moz - Great analytical skills to interpret data and adjust strategies accordingly Feel free to reach out if you have any questions ...
I'm searching for a skilled Agile Scrum Master to lead a team of very experienced team members... Key Responsibilities: - Utilize Agile methodologies to enhance team performance - Facilitate daily stand-ups, sprint planning, and retrospectives - Collaborate closely with Product Owners to ensure priorities are clear - Identify and help resolve any impediments hindering team progress - Provide regular updates to me via phone calls The ideal candidate should have: - A proven track record of implementing Agile methodologies - Excellent communication skills, particularly over the phone - Ability to lead a team of very familiar Agile practitioners - Strong conflict resolution skills - Familiarity with Scrum practices Please do not hesitate to ask any questions if yo...
I'm looking for a capable content writer who specializes in educational materials, specifically in physics and biology, for high school and 12th-grade students. Tasks will involve: - Writing comprehensive articles. - Creating problem-solving content for each topic. Each teaching aid will include 10-20 questions. Ideal applicants should have: - A strong grasp of high school level biology and physics. - Previous experience with educational content creation. - An ability to write in an engaging and understandable manner for high school students.
...Python programming and data science, specifically with a focus on finance who can help complete a project within the next 7 days. Here are the key skills and qualifications I think might be required to successfully complete this project, although I am not experienced in Python so you might find this easier and possible to do well without using as much. > Python Proficiency, as it is the primary tool for this project. > Familiarity with essential Python libraries such as pandas, NumPy, (Matplotlib, Seaborn?), Scikit-learn > Data Science and Analysis: - Data Manipulation: Ability to clean, preprocess, and manipulate large datasets. Skills in visualizing and understanding data trends and patterns. - Statistical Analysis: Knowledge...
...involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create persona...
We have print data for packaging but in the wrong format. It's a PDF and all single elements needed to create the new print data are delivered. We need someone who can build this 1:1 If there are questions - just let us know.
...practice). *Easy to work with: We reply to questions fast, will provide valuable input and feedback on every single task you complete. *We've been in the content writing and marketing business for 15 years and have worked with more than 2000 clients. As part of our team, you'll have the opportunity to learn from experienced team members on a daily basis. What we expect: *You'll be part of an International team with a base in Serbia that works for many clients which means you must be able and willing to research various topics. *Your English writing, spelling, and grammar skills need to be of a high standard. *You take feedback well and want to improve your writing skills. *Creativity and a big vocabulary are p...
...spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of ex...
I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused
...retailers, and manufacturers. We are looking for a logo that reflects our brand. We want our primary color to be green with our secondary colors as white, gold, and /or black. We want to create a brand that communicates the following: Hardworking, reliable, efficient, honest, competitive pricing, superior service. We want a logo and letter that makes people feel good when they look at it and people feel like this will be a great company to work with. Some examples of trailer leasing companies are as follows. We need an image that is unique, easily and quickly identifiable for our brand as well as lettering that communicates our brand value. Please be creative, we want the logo to be clean, modern, and professional
...data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered o...
...Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quali...
Hello my brother! I hope you and your family are doing great! I have a project for you! See doc - and let let me know if you have any questions.
...expertise in both electrical and mechanical engineering. Our aim is to design a high-power attachable biking dynamo/alternator for bicycles. The primary objective of this project is to create a device that can generate and store significant power for storage in high-capacity batteries. This dynamo/alternator should deliver a high power output, mainly focusing on efficiency, ease of use and weight. Key requirements: - Designing a high-power dynamo/alternator that can support extensive power needs. - The device should be attachable to a standard bicycle without impacting its performance or aesthetics. - Prioritizing power output over size or weight, meaning the final product can be robust as needed. Your role will be to: - Combine your expertise in electrical a...
...provider with 13 years of experience and a team of 25 in-house developers. Currently, we are looking to hire some freelancers because we are at full capacity and do not have sufficient resources to handle some of our work. We are seeking a long-term partnership and are willing to provide 20-30 hours of work per week. We welcome both experienced freelancers and those new to this platform who have significant prior experience, such as working in a company before starting their freelance career. This job post is open to all qualified candidates. Now, let's discuss the job requirements, which are urgently needed: We require an expert Laravel Developer who is well-versed in third-party APIs. The candidate must have experience working on incomplete projects...
