Sql interview questions answersJobb

Hej Logictrix Technologies, jag noterade din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Obs! Detta projekt är en long term projekt!! - Fast and Furious 7 - Jag behöver en som kan skriva 2-4 artiklar/blogginlägg per vecka + bilder/videos med angivna keywords. Freelancern MÅSTE även optimera artiklarna (SEO) samt submitting på olika directories. Articklarna/blogginläggen + bilderna måste passera Copyscape...Articklarna/blogginläggen + bilderna måste passera Copyscape och vara unika likaså bilderna!!! Freelancern kommer behöva skriva artiklar/inlägg om följande subcategories: - Cars - Wallpaper - Quoet - SoundTrack Projektet är långsiktigt, så gör ditt bästa för att jag ska fortsätta med dig! Första månaden är dock en TEST må...

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.

...content on WordPress sites. Proficiency in HTML and CSS to customize and enhance WordPress sites. Excellent command of English for effective communication Strong problem-solving skills to troubleshoot and resolve technical issues. Minimum of 2 years experience in WordPress development or publishing. Additional Information: Application Deadline: May 31, 2024 Interview Process: Selected candidates will go through a 2-round interview process. Location: Remote - Open to candidates throughout Pakistan. Working Hours: Monday to Friday, 4 hours per day (20 hours per week), with working times in consultation. Salary: 15,000 PKR per month (clean from any fees) Application Instructions: Applicants are advised to submit their work portfolio, including previous websites t...

I am in need of a developer who can assist me in converting my existing Flask API into an Assistant GPT openai. The ideal candidate will be skilled in Python and GPTs Assistant and have a proficient understanding of Flask A...need of a developer who can assist me in converting my existing Flask API into an Assistant GPT openai. The ideal candidate will be skilled in Python and GPTs Assistant and have a proficient understanding of Flask APIs. As the project involves converting the API into an Assistant GPT, experience with AI and NLP models will be a huge plus. Please note that there was a technical error in the questions, hence the repeated skips. It is highly important that the converted system maintains the functionalities of the original API while being able to run as an Assi...

I am in need of a creative and professional video editor to assist in repurposing one of my videos into five smaller, engaging marketing videos. Purpose: - These videos will be used to promote a specific product or service across multiple platforms. ...36-45 and above. Therefore, the design, tone, and messaging of the videos should be relatable and appealing to this demographic. Ideal Skills: - Proficiency in video editing softwares - Solid understanding of digital marketing and social media trends - Experience in creating content for age group 36+ - Ability to deliver on time, maintaining the high quality. Should you have any additional questions or need more details, please feel free to ask. I'm looking forward to seeing your creative vision come to life through these ma...

I urgently need a competent videographer with personal camera and sound equipment to produce engaging, high-quality videos over a two-day period amounting to about 10 hours. These videos will include event coverage and conducting interviews. Key Requirements: * Ability to film in indoor locations. * Adeptness in filming both event videos and interviews. * Expertise to create videos aimed at both marketing and promoting our brand and providing educational information. Skills and Experience: * Solid videography experience. * Proficient use of personal camera and sound equipment. * Proven track record of working on marketing and promotional casings, as well as informative and educational projects.

I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in Nottingham, UK. This is a one-time gig with the potential for f...their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for a Reader and input assistance. For this assignment, you are required to be present on-site, sit with the test taker, and read the exam content aloud. You will then enter the answers as instructed by the candidate. The exam is taking place at a professional testing center in Nottingham, UK. Date: Thursday, 23 May, 2024 Time: 12:15 pm to 2:15 pm We provide full training, and this assignment...

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

...functionality: Users can purchase vouchers at half price. - Condition: To avail the voucher, the user must share the app link with 10 other users. - Success criteria: If the user successfully shares the link with 10 users, they can redeem the voucher at half price. - Failure criteria: If the user fails to share the link with 10 users, they will receive a 10% discount on the voucher instead. Some more questions - Can the voucher sharing process be automated or tracked within the app? Ideal Skills and Experience: - Proficient in mobile app development, particularly customization on existing apps. - Strong UI/UX design capabilities to ensure a seamless user experience. - Experience with integrating push notifications and payment gateways. - Familiarity with backend development ...

I am seeking a creative ad designer who specialises in Facebook advertising. The aim is to produce an advert which can be translated into multiple languages to target different countries. The ad is for a downloadable video course, for those whose native language is not English, teaching what to say in a job interview in English. Predominantly my market would be working professionals aged between 25 and 50 who are likely to have to attend job interviews in English. Main tasks would be : - Creating an engaging Facebook ad - zeroing in on target group of potential customers (possible later task) - designing an effective landing page for ad clicks current page (in Italian) can be found at I can

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Manag...agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is required, a...

I'm in need of a skilled survey designer to help me create a structured questionnaire that'll measure the success and efficiency of our IT services. Key Requirements: - Create a comprehensive survey that includes various KPIs related to IT services. - Focus on measuring areas like response time, uptime/downtime, and customer satisfaction. - Ensure the su...be deployed on a monthly basis - The survey should be easily understandable by the respondents and generate actionable insights for our IT team. Ideal Skills and Experience: - Proficiency in designing surveys with a focus on KPIs - Knowledge of IT services and various KPIs associated with them - Experience in designing reports for IT service performance - Ability to create clear and concise questions that will yield m...

Hi there, I am looking for a professional Digital Marketer for my affiliate product link promotion who has confidence enough in their skills to bring me sales, You must be an expert digital marketer with enough Experience in the market, otherwise, you will just be wasting your money and time, your work is to promote my affiliate link and bring me sales and you will ONLY get...link promotion who has confidence enough in their skills to bring me sales, You must be an expert digital marketer with enough Experience in the market, otherwise, you will just be wasting your money and time, your work is to promote my affiliate link and bring me sales and you will ONLY get paid after you bring me sales. Apply only if you are sure you can bring sales. Contact me if you have any questions about...

...looking for a developer who can create an Android mobile optical reader application using OpenCV for image filtering. The main purpose of the application is to apply image filtering effects to the captured images. I would like to have an application made that will read the rectangular optical form with 25 questions and 5 options specified in the appendix, with a phone camera. Through the application, first the user will enter the answer key of the exam, then the correct/wrong/blank questions should be calculated by determining the options marked with the appropriate image processing algorithm. In addition, the number of times each question was marked as correct, how many times as incorrect and blank should be kept during each determination. The application must be develop...

I'm looking for an experienced videographer to capture various aspects of a visit to a company HQ in London. This project will include: - Filming interior shots of the HQ - Filming interviews with employees (YouTube presenter will conduct the interviews) - Capturing B-roll footage of the surrounding area The visit date is Tuesday 18th May. The purpose of the video is to generate a YouTube video that will captivate and engage YouTube viewers. The ideal freelancer should have prior experience in corporate videography, and creating dynamic YouTube content. Please provide samples of previous work of a similar nature when applying.

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.

**About the Role** We are currently seeking a highly skilled Front-End Developer with a strong focus in React(using Typescript) and a minimum of 12+ months of experience in creating web applications. You will be responsible for the development, design, and implementation of our new website's front-end aspects. This is a **6-month contract** position with a competitive hourl...Github profile. 4. Detail your most recent projects where you extensively utilized React and TypeScript. 5. We value your time and aim to respond to qualified candidates within 3 business days. **Note:** Please provide a robust portfolio demonstrating your expertise and versatility in front-end development. in React. We appreciate your interest in our company. Only candidates selected for interview wil...

I have a project that requires some custom work done via Woocommerce, as well as implementing some design work. Budget is fixed (if you ask for more, you will be blocked and if you...logins only once I have awarded. I am not giving out logins ahead of time. If you ask during the messaging process, you will be blocked. Also, I anticipate that quite a few will be capable of completing this task. If I reach out to you, after I send the project details, you must explain to me why you are the one I should pick. You are welcome to ask questions in there but I have been very thorough in my project details. If you need to ask alot of questions, you will not be picked. If you have read this, please say “Wolves” in your bid so I know you read this. If you do not, your bid w...

I'm looking for a professional who can convert my Amibroker AFL script into a TradingView Pine Script. The converted script should be able to generate buy/sell signals and provide backtesting capability. The ideal candidate should have experience in: - Amibroker AFL and TradingView Pine Script languages - Developing buy/sell signals - Implementing backtesting functionality Moreover, my tra...my trading strategy is based on breakout patterns. The converted script should reflect this strategy and incorporate the following indicators: - Moving Averages - Relative Strength Index (RSI) - Supertrend I'm looking for a freelancer who can deliver a polished and fully functional script that mirrors the performance of the original AFL script in TradingView. Feel free to ask any addition...

Develop an WhatsApp bot to sell to our clients, based in IA chat and voice like Twillo, with Integration of the clients CRM/ERP's so that the bot can answer to the client with human language. with the Intranet. 2 When the CUSTOMER CALLS DETECT FROM AND Customer or not. 3...clients CRM/ERP's so that the bot can answer to the client with human language. with the Intranet. 2 When the CUSTOMER CALLS DETECT FROM AND Customer or not. 3 Hello Mr (name of the client) , how are you? 4. Hello, we have verified that you are not yet our Client 5 . What do you intend. 6. Speak to Our Commercial Department: Technical department Another subjects. After answering the questions, read our intranet If there is no response, I will pass it on to my colleague and pass it on to Human.

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Set...framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to deliver on...

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

I need assistance in integrating an automatically generated Order ID within my Google Forms. Many people do it so, AT THE END the form, it will generate an ID number that will go into the Google Sheet where the responses go. In this case, I need it to be in form of a Short Question INSIDE THE GOOGLE FORM, Not at the end. So this way, the number generated will be pa...Order ID within my Google Forms. Many people do it so, AT THE END the form, it will generate an ID number that will go into the Google Sheet where the responses go. In this case, I need it to be in form of a Short Question INSIDE THE GOOGLE FORM, Not at the end. So this way, the number generated will be part of the info the client sunbmits like Name, Phone Number, Zip Code, etc. Please ask questions before agreeing...

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...

...should be user-friendly and engaging, allowing users to receive responses to their prompts seamlessly. - Basic customization: Although we seek a simplistic design, the chat interface should still maintain a professional and appealing look. This means including preset themes for customization. We have a model on google colab which uses GEMINIAI and answers based on the prompt. I need to integrate this into the website. The website will answer questions on "How to fix___?" by returning the tools required and the steps to perform. Additionally, I need the links for buying those tools included at the end so an API call needs to be added. Ideal candidates for this project should have: - Proficiency in GeminiAI use, NLP, API, chatbot development, and web development. ...

We are seeking a skilled AI developer to create a custom AI script capable of generating answers based on specific datasets for multiple products. This AI model will provide accurate responses using only the data provided for each product. If the model cannot find a matching answer, it should prompt the user to contact us for further assistance.

We are seeking a skilled AI developer to create a custom AI script capable of generating answers based on specific datasets for multiple products. This AI model will provide accurate responses using only the data provided for each product. If the model cannot find a matching answer, it should prompt the user to contact us for further assistance.

...Key Responsibilities: - Extracting insights from unstructured text and numerical data - Utilizing machine learning techniques like LDA, NMF, etc. - Ensuring an ethical approach to data analysis - Asking the right questions for analysis and providing detailed insights Requirements: - Extensive experience in data analysis, particularly with unstructured data - Proficiency in machine learning techniques like LDA and NMF - Strong ethical understanding and the ability to consider ethical implications in data analysis - An analytical mindset with the ability to ask the right questions and provide detailed insights Ideal skills and experience for this job would include a background in data science, machine learning, natural language processing, and a strong foundation in data a...

...freelancer's remuneration is an agreed upon percentage of the NFT token sale amount minus applicable commissions and fees. All payments are made in the cryptocurrency accepted for payment for the NFT collection. The customer reserves the right to request additional information or documents necessary to confirm the fact of sale and the legitimacy of payments. Please let us know if you have any questions or need additional information....

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

I am seeking a full stack PHP developer to assist me with my project. I'm l...you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you're avail...

I'm looking for an experienced Django developer to work on the backend of my project. Key Project Goals: - The primary focus of this project is on backend development. You should have a strong understanding of Django and be able to handle complex backend tasks. Ideal Skills and Experience: - Extensive experience with Django is a must. - Strong understanding of backend ...- Extensive experience with Django is a must. - Strong understanding of backend development. - Ability to work on complex backend tasks. - Good communication skills. - Previous experience with similar projects is a plus. Please note that the project is already defined and the focus will be solely on backend tasks. Your role will be to improve the backend of the website. Feel free to ask any questions for mo...

I need a skilled individual to help me create a professional slide deck - the presentation is attached below and is titled Freelancer's Global Interview Standards The presentation is to be around 15 to 20 slides in length. I have highlighted in blue in the below presentation document, the titles I want you to focus on creating for the slide deck. Please feel free to use images wherever necessary. Key requirements: - Creating a visually-engaging, professional slide deck - Incorporating provided branding guidelines - Ensuring the slides are clear and concise - Good project management and communication skills, as I aim to be involved in the process to ensure it aligns with my vision

...health-conscious individuals as primary audience The selected freelancer should have: - Demonstrable experience in creating educational motion graphic content - A portfolio showcasing previous work in the field - Understanding of the principles of designing for specific audiences, especially health-conscious individuals. Looking forward to seeing your bids, and please feel free to ask any questions if you need more details. Example of scrip: A low carb diet is great for reducing blood sugar levels. If you have diabetes or high insulin levels, reducing your carb intake can have a significant impact on your health, Studies have found that a low card diet can dramatically lower your blood sugar levels, and in some cases, help reverse type 2 diabetes.! "

I am in need of a skilled professional who c...Microsoft Word’s functionalities and be able to create a fully custom template. - Design Skills: The template should not only be functional but also visually appealing and in line with our brand image. - Attention to Detail: It is crucial that the template is designed specifically for external client communications. - Communication: I require clear communication on the progress and any potential questions or issues that may arise. Please note that I will provide you with the specifications that the template should adhere to. Your role will be to implement these requirements in a user-friendly, professional, and attractive manner. If you have experience in creating similar templates and are up for the task, I look forward to hea...

I'm looking for a skilled professional to help me with advanced data processing tasks using Power BI and Macros. Key Responsibilities: - Data Cleansing: You will be responsible for ensuring that the data is clean and free of any inconsistencies or errors. Ideal Skills and Experience: - Proficiency in Power BI and Macros - Strong background in data processing - Ability to clean and tra...clean and free of any inconsistencies or errors. Ideal Skills and Experience: - Proficiency in Power BI and Macros - Strong background in data processing - Ability to clean and transform data effectively Please note that the main objective of this project is advanced data processing. The tasks would primarily involve data cleansing and transformation. Feel free to reach out if you have any ...

...Grammar on the topics given here in the attachment. It can be discussed in Chat. You should have a good, professional grade Mic. An electronic Pen is desirable. Topics for which you need to create the videos are Narration , voice change, parts of speech, sequence of tense, gerund, creating wh questions etc. Each topic should be minimum of 60 minutes length. You first need to explain the main concept, use examples and use some questions and then its answers with explanation.. also create 10 MCQ questions on each topic. Instructions to be in ENGLISH only. Use Screen recording Software and/or Whiteboard. VOICE MUST BE LOUD & CLEAR. NO BACKGROUND NOISE/SHAKY VIDEOS NOT ALLOWED. See my attached sample video. You need to give me the full copyright of all the vi...

...hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Perso...

...that provide real-time code suggestions and auto-completions similar to tools like GitHub Copilot. - **Code Snippets**: AI can suggest commonly used code snippets based on the problem statement and context. - **Problem Solving Hints**: AI can offer hints or guide candidates through difficult problems without giving away the solution. - **Adaptive Learning**: Use AI to adjust the difficulty of questions based on the candidate's performance in real-time. ### **2. AI-Based Cheat Detection** - **Plagiarism Detection**: Use AI to compare submitted code against a vast database of existing code to identify copied or modified solutions. - **Behavioral Analysis**: Monitor typing patterns, speed, and other behaviors to detect unusual activity that may indicate cheating. - **Proctorin...

I'm seeking a professional to standardize and aesthetically enhance my existing PDF-based letters and proposals. including adding the attached flow chart in the document Key Points: - Standardization: The primary objective is to ensure all letters and proposals maintain a consistent and professional format. - Aesthetics: I aim to modernize the design of the d...Expertise in PDF document creation and formatting - Strong graphic design skills, with a portfolio showcasing modern and minimalist aesthetics - Ability to enhance the current documents without deviating from the original content - Attention to detail to ensure all necessary elements are included - Previous experience with proposals or business letters is a plus Feel free to ask any further questions to better understa...