Sql interview questions for testersdela

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

I need someone to help me with my weekly projects that involve Quality Assurance Testing and Consultancy services for a few major international tech firms. Projects and work are continuously available so there is plenty of work weekly We will work through remote working software to connect to our local machines using this software, not the other way around so there is nothing to worry about your privacy. Testing will be done on Windows desktop and will mainly involve QA checks and regression Testing of certain software. All testing done are on confidential pre-release test builds so discretion of what you test IS IMPORTANT. Please acknowledge this in your proposal. An NDA will be signed in this regard. I require someone with excellent IT skills and a very good command and underst...

...platform, similar to Coderbyte/ Hackerrank tailored to my specific needs not limited, but similar to . Here's what I'm looking for: 1. AI-Generated Code Assistance** - **Smart Code Suggestions**: Implement AI algorithms 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 sub...

I'm seeking a professional to standardize and aesthetically enhance my existing PDF-based letters and proposals. including adding the attached flo...documents while maintaining a minimalist style. - Required Elements: Each letter and proposal should contain a contact information section and a signature field. The ideal candidate for this project should have: - 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 u...

I need an experienced NextJs (ShadCn) + Prisma (Postgres) developer to build an E-commerce application within a week. Key Requirements: - I already have a DB schema for the App and all the flows mapped out - Need someone to build a test taking app - Users can create online test, generate links and take test using the application - The whole app will be less than 10 pages - The App will have a lot of funtionality like generating common test link, session specific test link, generating test scores/result, question bank support, dynamic questions... The ideal candidate should have: - Solid experience in NextJs, ShadCn, and Prisma. - Proven track record in E-commerce application development. - Ability to deliver high-quality work under tight deadlines. Please only apply...

I'm in need of an expert who can set up Webmin on my Ubuntu server. The primary reason for this is to facilitate server management. Here's a bit more detail on the tasks: - Setup Webmin: The primary task here is installing and configuring Webmin. It should be set up properly and securely to ensure that the server can be effectively managed through the panel. - Additional Server Tasks: Other tasks might include firewall configuration and VPS setup. These tasks are important to ensure the server is secure and running properly. Ideal candidates for this role should have: - Proficiency in Ubuntu server setup - Experience with server panel software, specifically Webmin - Strong understanding of server security - Capability to manage additional server tasks like firewal...

This job is best suited for a tennis fanatic, that also has experience or interest writing scripts. We run a Tennis YouTube channel. Where we do player analysis, match recaps, narratives on different topics in the tennis world. If you do not watch/pay attention to tennis on an almost daily basis then this is not the right job for you. We also have a host for our channel so the script needs to be cohesive and casual enough for someone to read off of it without it sounding like a script. You will be responsible for writing (3,000~) word scripts 1-3 times a month, with reasonable turn around times if you are interested in applying, please show us examples of your previous work. We are looking for someone who is self-driven and makes sure that 100% ...

We are looking for someone long-term who can do cartoon animation with experience in video editing. It will be around 1-2 minute per video. These will be for youtube. We are looking for someone good in communication, can do it on a good price, and delivery time. More details will be provided upon interview.

I require assistance in creating an Adobe fillable PDF form for my clients. This form will be used to collect data. - The PDF form will need to include both text fields for entering information and checkbox fields for multiple choices. - I also need a box around the bottom portion (last two questions) Freelancers must have experience in Adobe fillable forms and demonstrate an understanding of how to create dynamic and user-friendly forms.

I would like an AI chat robot that can answer users questions and send transcripts on email

...actionable advice and best practices for a smooth migration process. Strong communication skills to explain complex concepts in an easy-to-understand manner. Responsibilities: Share your experience and best practices for migrating websites to AWS. Answer any questions we may have regarding the migration process. Guide on optimizing our AWS setup for performance and cost efficiency. Address any potential issues or challenges we might face during the migration. Preferred Experience: Previous experience working with small web agencies or similar businesses. Knowledge of web hosting and server management. Details: Duration: 2 hours (flexible scheduling) Platform: Zoom meeting Payment: Hourly rate If you have the expertise we need and are available for...

...interface. - Providing Travel Recommendations: The primary function of the AI will be to offer travel suggestions tailored to the user's preferences. - User Interaction: The AI should ask direct questions to the user during interactions. This will help the AI to learn and refine its recommendations based on user feedback. Ideal Skills & Experience: - Proficiency in AI Development: Experience in building AI systems, particularly for personalization. - API Integration: Ability to work with APIs from travel sites to gather and process data. - Instagram Interface: Knowledge of creating chatbots or AI systems for social media platforms, particularly Instagram. - User Interaction Design: Prior experience in designing AI systems that can interact with users effec...

I am looking for a talented professional to develop a mobile application for both iOS and Android platforms. The primary function of this app would be AI-enhancement, particularly focusing on the Computer Vision feature. Ideal Experience and Skills: * Proficient in iOS and Android development * Strong background in AI, especially Computer Vision * Experience in integrating AI capabilities into mobile apps The app will also have an in-built feature to solve questions, further incorporating the AI function. Make sure that the AI is robust enough to provide accurate solutions. Please apply if you have a proven track record in developing AI-based mobile applications. Demonstration of a similar project in your portfolio will be a plus point.

I'm in need of a professional and visually appealing banner for my website. The banner should be a balanced mix of text and images, adhering to a specific color scheme. Please upload the finalized design incorporating our logo for website consideration; any mock-up submissions will be automatically disregarded. You will find the necessary information attached for creating the banner, which focuses on the KTT Telex services offered by the bank. All details about this service are included in the attached file. **Key Requirements:** - Design a website banner with a mix of text and images - Use the specific color scheme as the banner currently showcased on the website: https://prominencebank.com. - Banner Size: 1903x560 cm **Ideal Skills:** - Graphic Design - Web ...

...- We do not have time for budget negotiations. I'm looking for someone to develop an AI machine learning app that can scan all company Office 365 emails and SharePoint files via Azure API; store the data in long-term memory of the AI; and have autogpt agents, chat gpt and custom gpts with chaacter limits that can aswer questions on company emails and documents and also alert you when you or any staff forget to respond to something important. Ideal Skills and Experience: - Strong background in machine learning and artificial intelligence - Proficient in developing applications that can integrate with Office 365 - Experience with building applications that can scan emails and files - Knowledge of setting up alerts and chat functionalities - Ability to create a...

exactly similar to this f-system

...`11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game. ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Ideal skills for this project: - Strong experience with WordP...

We are looking for a skilled CFD & FEA expert to conduct simulations for our boat design project. Our goal is to optimize the hull design for two specific configurations: 1. Twin-Engine/Surface Drive Design: We anticipate using twin engines and a surface drive for optimal performance. The primary focus here is on optimizing the hull for handling, speed, and efficiency. We also aim to identify the performance sweet spot for this configuration. 2. Single Engine/Jet Design: We also want to explore the possibility of using a single engine with a jet propulsion system. The goal here is to optimize the hull for maneuverability and handling, rather than top speed. We want to determine if any drastic changes, such as a smaller hull, are needed...

...skilled freelancer to implement Continuous Integration and Continuous Deployment (CI/CD) using GitHub Actions, set up logging for each service, and configure an HTTPS domain for our web application hosted on Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. ...

...chapter summary!) while you're at it. We need your help creating short, clear summaries of existing gynaecology chapters. Think of it as the ultimate study guide - for you and your classmates! Bonus: Summarizing this stuff will actually solidify your own understanding of the material. Double win! Sound good? Here's what we're looking for: A fellow med student with a good grasp of gynaecology Someone who can take complex info and turn it into clear, easy-to-understand gold ? (think bullet points, key takeaways) Strong writing and editing skills (grammar police welcome!) ‍♀️ The process is super quick: Answer a few questions to show us your gynaecology knowledge. Summarize a short excerpt from a chapter. Easy peasy! Ready to ditch the textbook...

Conquer Gynecology Exams: Create Short, Clear Chapter Notes (Medical Students Only!) Need a study edge in Gynecology but short on time? We're looking for medical students to create concise, high-impact chapter summaries on gynecological topics. This is a fantastic opportunity to solidify your understanding while earning money! Fast Track Your Learning: Help Fellow Students: Create clear, informative chapter summaries for struggling students. Reinforce Your Knowledge: Condensing information strengthens your grasp of key concepts. Flexible Schedule: Work on summaries at your own pace. Competitive Pay: Earn 3 dollars per completed chapter summary. Ideal Candidate: Medical student with a solid foundation in gynecology. Strong reading comprehension and summarizing skills....

...which delves into the connection between ESG scores and real estate company performance. The main questions I'm looking to address in the study are; - Are real estate companies with high ESG scores more profitable? - Does having a high ESG score increase investor interest in real estate companies? - What is the correlation between ESG scores and stock performance of real estate companies? The data for this analysis should be sourced from the past 5 years, and the report should be comprehensive and well-structured, with clear methodology and results. The study should be global in scope, encompassing a range of real estate companies and markets worldwide. This project would be best suited for someone with a background in finance, real estate, and/or sustainab...

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for...

I'm in need of a skille...platforms. Programming Language: - While I have no specific preferences for the programming language, developing the AI agent using Google App Script is preferred for the first version. However, feel free to propose alternative languages that can efficiently meet the project requirements. Ideal Skills: - Proficiency in AI development, with a focus on chatbots, automated responses, and data retrieval. - Bilingual proficiency in English and Hebrew would be an advantage. - Experience in creating and deploying AI agents for web and mobile platforms. - Competency in Google App Script development would be highly appreciated. - Abilety to show samples of similar projects you did. Feel free to ask any further questions for clarif...

I'm in need of an English-Portuguese interpreter in Elvas, Portalegre, Portugal for an important in-person marriage interview. Key Requirements: - The interview is expected to last for less than 1 hour. This is a crucial detail to bear in mind. - The interpreter must be able to translate Portuguese to English and vice versa. It's essential that they are proficient in both languages. - Knowledge of legal terms is a must, as the interview will involve legal discussions related to marriage. Ideal Skills and Experience: - Fluency in both English and Portuguese is a prerequisite. - Prior experience with legal terminology and processes will be highly beneficial. - Previous experience in translating during marriage interviews or similar situations w...

ATTENTION!! Do NOT make an AI-generated proposal. Just answer the following questions: 1) You will be responsible for 3 social media (IG&X&Linkedin). Answer your years of experience in each platform. 2) Can you create content in mental care in English? 3) Can you make one collaboration per week? 4) Can you interact with the audience via 10 comments and 10 likes every day on each platform? 5) If you answer "yes" to the above questions, please go to Expathy Org IG page, make one sample post OR reels for Expathy and submit it between 20th of May- 26th of May. Colors: Green (#012b28) Yellow (#ebb42c) We are looking for an experienced social media expert who can manage and promote EXPATHY across Facebook, Twitter, and LinkedIn. Key ...

We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.

...Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, ...

...effective admin dashboard with user authentication. The template for the dashboard is ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email an...

We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.

Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.

I am looking for an experienced CodeIgniter developer to upgrade my existing CodeIgniter 3 project to CodeIgniter 4. The project is currently live and needs to maintain the same database structure and functionality. The key tasks include: Upgrade CodeIgniter Version: Migrate the entire project from CodeIgniter 3 to CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. ...

I am in need of a freelancer who is both proficient in web development and has a good grasp of writing and editing. Here's a bit more detail about what I am looking for: Specific Tasks: - Website Design: I would like a sleek and modern design for my website. It's crucial that you have an eye for aesthetics and can create a visually appealing layout. - Back-end Development: This includes setting up the functionality of the website. I need someone who can make sure the website runs smoothly and can handle the back-end processes efficiently. - Product Listing: Since the main purpose of the website is for information display, I would also need you to set up a product listing section. This would require good organizational skills and an understanding of ...

I'm seeking a capable interviewee who can confidently step into an interview for an Area Manager role at Amazon on my behalf. It's not essential for you to have previous experience in this role at Amazon, but you should be able to demonstrate a plausible simulation of the qualities an Area Manager should have. Key Responsibilities: - Understanding the responsibilities and skills required for the Area Manager role - Effectively representing the role during the Amazon interview Ideal Skills and Experience: - Experience in undertaking job interviews - Strong understanding of the Amazon work culture - Excellent communication skills - Demonstrable leadership skills - Knowledge about Amazon's Area Manager role would be a plus.

I'm in need of an expert developer to establish a pop-up chatbot for my PHP project, and an admin's data analytic dashboard. Chatbot Requirements: - Interactive conversation capabilities: Enable human-like engagement with users. - Natural language processing: Understand and respond accurately to user inquiries. - Integration with existing database: The bot should pull information from our present database to answer user questions. Admin's Dashboard Requirements: - Data visualization: Clear, intuitive graphical representation of data is required. - Data filtering: The dashboard should feature tools for sorting through data effectively. - Registered User Counts: Display the number of registered users on our platform. - Service Booking Record: Display...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

...idea for a mobile app focused on cricket match scheduling. As a cricket enthusiast, I have often faced the challenge of finding available teams to play matches against on short notice. To address this issue, I envision an app that can connect teams and simplify the process of organizing cricket matches. Project Overview: The primary goal of the app is to help cricket teams find and schedule matches with each other. Teams can mark their availability for matches, view other available teams, and communicate directly to arrange matches. Core Features: User Registration and Profiles: Teams and individual players can create profiles. Profile information includes team name, location, contact details, skill level, and availability. Match Availability: Teams can post their ava...

I am looking for a skilled and creative 3D designer to create a dynamic and futuristic live logo for my brand. The ultimate goal is to enhance brand recognition. Required Logo Specifications: - Style: The style has to be futuristic. Comfort in designing in this genre is important. - Color Scheme: The logo should predominantly use cool colors (Blue, Green, Purple). Ideal Skills and Experience: - Proficiency in 3D design software - Previous experience creating live logos - Familiarity with or interest in futuristic aesthetics Your bid should include a portfolio demonstrating your expertise in creating 3D live logos. Feel free to include any questions you may have about the project in your bid. Looking forward to your creative proposals!

...detailed cricket schedule for the upcoming English summer season. Tasks Include: - Including International, Domestic, and Club tournaments and teams in the schedule - Organizing fixtures based on the date Additional Details: - Each fixture should have comprehensive information about the venue - Match timings should be included - Broadcast details for each match should be provided Ideal Skills: - Proficiency in Google Sheets - Knowledge of cricket and its various tournaments - Attention to detail to ensure that all necessary information is included - Time management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Data Entry Expert for Cricket Schedule **Objective:** Create a comprehensive cricket schedule ...

...Q&A functionality. - **Integration Method**: I intend to use the ChatGPT API where I'll send text and image data for processing. The desired outcome is a response that can be used to engage with users. Ideal Skills: - **Spring Boot**: A strong understanding of Spring Boot is crucial to ensure seamless integration of ChatGPT within my application. - **ChatGPT API**: Experience working with the ChatGPT API or similar natural language processing (NLP) tools is highly desirable. - **Q&A Functionality**: Knowledge of creating Q&A systems or similar chatbot implementations would be beneficial. The end product I'm looking for is an integrated system where users can ask basic questions and receive relevant responses from the ChatGPT engine. The goal ...

...techniques, timing, and quality control measures. Project Goal: The ultimate goal is to create a page that educates consumers on what makes our vanilla truly special and compellingly tells our unique brand story. The page should convey our deep commitment to quality, sustainability, and supporting our farming communities. It should engage viewers' senses and emotions, instilling a greater appreciation for the artistry and care behind our vanilla. Key Project Requirements: 1. Visual Storytelling: - Organize the page's flow to follow our vanilla's journey, guiding users through the process in an intuitive, engaging way - Draw all steps, Incorporate high-quality images, illustrations, and/or animations to richly visualize each step and bring our process to life - D...

I'm in need of a skilled writer for an assignment in project management. The assignment should be done in 3000 words. It is actually 2 questions. Each question should be answered in 1500 words. There will be a sample answer to help you understand the way we should answer the assignment. Kindly write how much your price for 3000 words including references and check the whole written answer in Turnitin, Quillbot and Grammarly. Ideal Skills and Experience: - Proficient in various writing styles (informative, persuasive, descriptive) - Flexibility and adaptability in terms of topic - Experience in writing a variety of word counts - Strong grammar and editing skills Please note that the assignments details will be sent to you after I accept your price.

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Kn...

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 (template creation and eventual API ...

...programmer who is 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 fro...