Codility test questions and answers sql jobs

...Social Media and Gaming Platform We are looking for an experienced development team to build an innovative social media and gaming platform tailored to the needs of gamers. The project spans several interconnected features, ensuring an immersive experience for users. Below is an overview of the key requirements: 1. Social Media Platform Features: Authentication and Authorization: Support for third-party sign-ins like Google and Discord, along with native email/password login. Engagement System: Users can create posts (text, images, videos, or links), ask and answer questions, comment, react, reply in threads, and share content. Temporary "Stories" (24-hour visibility) are also included. Chat System: Real-time communication thro...

...validations Main Functionality: The module must automatically generate crossword puzzles based on two input parameters: 1. Crossword theme 2. Desired language Output Specifications: * Format: .txt file containing a JSON * Required JSON structure: * cols: number of columns * rows: number of rows * cells: array with the letters of the crossword * words: array with the positions of the words * questions: array with the corresponding clues Example: {"cols":13,"rows":13,"cells":["B","E","W","I","T","C","H","","C","Y","C","L","E","E","","H","","O","","O",&q...

...with the team and contribute to game design discussions You should at least have: 0 to 3 years of experience working in the game dev industry An ability to reason about algorithms and performance Worked on at least 1 published game Experience publishing games to the iOS App Store and the Google Play Store Excellent communication skills Experience working with Unity Experience working with an object-oriented programming language like C++, C#, Java, etc Sound fundamentals in 3D game development (like 3D math, rendering, materials/shaders, etc) An ideal candidate also has experience: With animation systems Working with a 3D game engine like Cocos2D-X, Unreal, etc With OpenGL ES or DirectX Please apply for this position by emailing our contact address with your resume, ...

I need someone to type the letter "a" for a technical test or experiment. You will be compensated $25.01 for this task. Please reach out if you're able to assist.

I’m dealing with a few issues on my VPS email server managed via WHM/cPanel. The primary problem seems to be DNS misconfigurations, but I also need assistance with frozen emails and ensuring the server's security against unauthorized login attempts. Tasks: - Troubleshoot and fix DNS records (A, MX, SPF, DKIM, DMARC, etc.) - Resolve frozen emails and restore normal mail flow - Secure the server from potential threats - Test and verify functionality of email sending/receiving Requirements: - Proven experience with WHM/cPanel and Exim/Dovecot - Deep understanding of DNS configurations - Strong troubleshooting and server security skills I made recent changes to my DNS settings on OVH, which might have contributed to these issues.

I'm seeking an experienced QA professional for extensive testing of my web application. Key Responsibilities: - Conduct thorough functional testing to ensure all features are working as intended. - Implement security ...application. Key Responsibilities: - Conduct thorough functional testing to ensure all features are working as intended. - Implement security testing, with emphasis on: - Vulnerability scanning - Penetration testing - Security auditing - Test across various platforms: - Desktop browsers - Mobile browsers - Tablets Ideal candidate should have: - Proven experience in web application testing - Strong understanding of functional and security testing - Familiarity with testing across various platforms - Excellent attention to detail a...

...members and confidently show their faces during the interviews. Here’s what you’ll do: - **Take interviews** instead of our team members, showcasing your excellent English fluency and professional demeanor. - Act as a team member and appear polished and confident during the interview. Here’s what we offer: - **A 25% revenue share** for every job secured through your efforts. - **Full preparation and support**, including technical details and answers, to pass the interviews easily. ⚠️ **Important:** We'd prefer it if you had knowledge of the computer science industry. If you’re uncomfortable showing your face during interviews, please do not message me. This role requires confidence in representing us visual...

I'm in need of a professional web developer to help me build a website. The specifics of the project, including the main purpose of the site, design style and required pages, are yet to be determined, as I have skipped these questions. Ideal skills for this job: - Proficiency in web development languages (HTML, CSS, JavaScript, etc.) - Experience with e-commerce platforms (if that becomes a need) - Strong understanding of SEO principles - Ability to create modern, clean, classic or colorful designs based on client's needs - Excellent communication skills for discussing project specifics and updates.

...design, integration, and management services. We lead the entire mobile app development process from ideation and concept to delivery and ongoing support. With over two decades of expertise, we build solutions that meet market needs, empower companies’ brand identity, and encourage business growth and comprehensive service includes:Custom app developmentNative and cross-platform solutionsSecond platform app developmentUI/UX designConsulting and prototypingAutomated QA and testingPower managementNotification and geofencingEmbedded Android customizationsMaintenancePost-warranty supportWe use the latest technologies to produce fully-fledged, stable, and scalable mobile applications, including Kotlin, Java, React N...

Hello I got the module for VM Marketplace 5.2 for Virtuemart. I need a programmer to install or reinstall this module and install the login page on my left side of each page, also test the module to be sure it is working. - SMTP server mail fix - 3 lines text to change

...project requires implementing a system where users can buy/sell stocks, track their portfolio, and experience simulated stock price fluctuations. Key Requirements: - Understanding of REST APIs for data fetching and interaction. - Proficient in multithreading to handle simultaneous user actions and stock updates smoothly. - Experience with SQL Database integration for storing user data, transaction history, and stock information. User Authentication: - The simulator must incorporate Two-Factor Authentication (2FA) for enhanced security. Please ensure you have experience implementing 2FA in web applications. Skills and Experience: - Proficiency in web development, particularly in creating interactive and dynamic web applications. - Deep ...

Please Sign Up or Login to see details.

We are a new insurtech company launching Pet insurance in Germany, and we need a seasoned, mother-tongue German content creator. Our focus is on creating engaging, friendly and playful content around pet wellbeing and protection. We also want to incorporate our support for non-profits into our content. Key Responsibilities: - Develop and implement a social media strategy primarily on Facebook, Instagram, and TikTok - Create content focused on pet wellbeing and protection - Integrate our social cause initiatives into the content - Update our followers with company news and promotions - Build and grow our social media presence Ideal Skills and Experience: - Native German speaker with a deep understanding of the culture - Prove...

...website for my startup, similar to The site should embody the same functionality and sleek, modern design aesthetic as the reference site. Stack Preferred : MERN Stack Key project requirements include: - **Design**: The website should have a modern and sleek design. Minimalist elements may be incorporated, but the overall look should be clean, contemporary and sophisticated. - **Functionality**: The website will primarily serve as a portfolio showcase, so it should be capable of displaying a variety of work in an organized and visually appealing manner. - **Contact Form**: An essential feature of the site is a functional contact form. This should be user-friendly and seamlessly integrated into the overall design of the site. Ideal candidates for...

I've got the module for VM Marketplace 5.2 for VirtueMart. I need a professional programmer to install o...the module for VM Marketplace 5.2 for VirtueMart. I need a professional programmer to install or reinstall this module and set up a login page on the left side of each page. The programmer will also test the module to ensure it's functioning correctly. Specific tasks include: - Adjusting minor text modifications I have. - Checking SMTP for automatic mail sending. The ideal freelancer for this project should have: - Expertise in VirtueMart. - Proficiency in module installation and customization. - Strong programming skills to design a login page from scratch. - Excellent troubleshooting abilities to test module functionality. - Attention to detai...

I'm in need of a sophisticated, luxurious design for my cosmetics product's packaging and labeling. The design should be minimalistic yet exuding a sense of luxury. Key Requirements: - Design for a Skincare product - Luxurious and minimalist design style - Glossy finish for the packaging Ideal Candidates: - Experienced in packaging design, particularly for Skincare - Portfolio showcasing luxurious and minimalist design - Familiarity with glossy finishes and how to design for them Label Design Instructions Front Label Product Name & Highlight: Place "C to It Anti-Age Moisturizer" prominently at the top-center in an elegant, modern font. Highlight "Vitamin C-Infused" below the name as a key selling point. Key Features: Add th...

...Transactions keep failing. I provide you with a Jetton, 2 Ton coins, and a wallet in test-net for testing your code and development. What I want to receive is a react project that a user can connect its wallet from tonkeeper app on his phone, and then the user inputs the amount of token to transfer and then your code should prepare a message and send it to his wallet to sign. If he can sign and transfer successfully without any error or failing from tonkeeper or TON blockchain, then it is done. The project should be dockerized and delivered on my github repository. The jetton address, jetton decimal, and recipient address should be read from environment variables. I am looking for someone who has done it before and...

...Detection and Response (NDR) software designed to enhance cybersecurity for small and medium-sized businesses. The project involves building a comprehensive solution for real-time network traffic monitoring, threat detection, and prevention, with interactive visualization tools. Key Responsibilities: Develop Real-Time Monitoring Features: Utilize tools like Zeek and Suricata for traffic monitoring and anomaly detection. AI Integration: Build and train AI models to process network traffic data and detect potential threats with high accuracy. Dashboard Development: Create an interactive and user-friendly dashboard (preferably customized) to display alerts, logs, and analytics using the Elasticsearch database. Data Securi...

Just trying to test this to see if it goes through if I give you the $50 will you be able to get started and then I paid the rest upon completion? Is that how that works?

...CHAT-GPT AI-powered personalized dating and relationship advice chatbot with the following features and tasks: 1. Backend Framework: To handle user data, authentication, and database management. 2. AI Engine: For conversational logic, personalization, and natural language processing (NLP). 3. Frontend Interface: For users to interact with the application. 4. Database: To store user profiles, conversations, and other metadata. Below is a simplified implementation plan with Python using Flask for the backend, SQLite for the database, and OpenAI's GPT-based model for the AI engine. Logic and Architecture 1. User Management: Authenticate users (register/login). Save user profiles and preferences. 2. AI Conversation: Engage user...

I want a professional to help me creat interview questions and formats for my phd

I'm in need of an expert HVAC designer to help with the air-conditioning design for my single-family double storey home. The project will primarily focus on a new installation of the system. Ideal skills for the job: - Extensive knowledge in HVAC systems and design - Experience with installations in residential buildings - Ability to propose efficient and cost-effective solutions Please feel free to ask any questions if further clarification is needed. Your expertise in this field is greatly appreciated.

...subjects: primarily Algebra but additional help such as test prep may be needed for English, US History, and Biology. This tutoring will involve daily review of homework, ensuring comprehension of class topics, and preparing for quizzes/exams. In addition to subject-specific tutoring, we would like the tutor to work on helping the student develop better organizational and time management skills. The tutor should provide strategies to keep the student on track with assignments, improve study habits, and ensure overall academic success. Key Responsibilities: Daily review and explanation of homework in Algebra and occasional help with English, US History & Biology Prepare the student for quizzes, tests, and exams. Provide organi...

...option for LearnPress questions options, as well as for explanations and hints. - Create a 'filter by tag' feature. This will allow me to filter questions according to their tags when adding them to quizzes. - Modify LearnPress to permit the use of the same question in multiple quizzes. Please write '333' at the start of your bid. I'll read only the bids staring with '333'. Additionally, I am currently experiencing issues with LearnPress and WooCommerce integration. Even though I have the LearnPress WooCommerce addon and have selected WooCommerce as the payment gateway for LearnPress, I receive a 'no gateway found' message during checkout. I need this resolved as well. The most important feature for me is t...

Hello, Thank you for discussing your project with me. This is the official quote for your Logo & Social Media Design project. Please review the details and accept the quote to proceed further. If you have any questions or need adjustments, feel free to let me know. Looking forward to working with you! Best regards, MD Mostafizur Rahman

...for a Python Developer with strong experience in Django and web scraping to help build and enhance chatbot applications. You will develop backend services, integrate web scraping tools, and manage data to improve chatbot functionality. Responsibilities: Develop and maintain backend services using Python and Django. Implement web scraping techniques to gather data from external websites. Integrate scraped data into chatbot systems for improved responses. Work with databases (SQL/NoSQL) and APIs to support chatbot features. Collaborate with frontend developers to ensure smooth integration. Requirements: Strong experience with Python, Django, and web scraping tools like BeautifulSoup or Scrapy. Familiarity with database management ...

...information capture & backend database 2. Must be appraised of the industry best UI/UX for requirement 3. App must be built to allow addition/deletion of additional inputs required for onboarding professionals to build database of professionals 4. Must understand & replicate industry standards for building & maintaining database 5. Must be aware of the basic laws of the land on information storage Test Scenario: 1. Users will have to access to app/website from any part of the country 2. Users should be able to enter the required information - details will be shared 3. Workflow must be trigerred to admin for Accept/Reject/Request Modify 4. User profile must be successfully created with unique ID 5. Database of all users will have to be retrieved upon request at the ...

Hi, I am looking to create a SPX 0DTE volume alert/indicator on TOS or possibly Active trader pro. Is it possible to create a volume indicator/alert that will notify you when a particular volume threshold is crossed on a 1 min basis, without having a chart for the o...possible to create a volume indicator/alert that will notify you when a particular volume threshold is crossed on a 1 min basis, without having a chart for the option open? My idea would be to create a watchlist of the particular option chains that are of interest and set an batch alert/indicator, when volume on a one minute basis is greater than say 400 contracts for example. Is something like this possible to create, without having to have each option contract chart open? Let me know if you have any additional ...

Make minor edits to my WordPress site and test it for comparability on all browsers and mobile browsers. Remove plugins that are not useful.

...these videos is to showcase the app’s features, benefits, and how it solves key pain points for cleaning business owners. The videos will be featured on my website and used as promotional material to attract potential customers. Exact video descriptions will be discussed with the successful applicant. Each video should be professional, engaging, and visually appealing, with a clear focus on communicating how the app helps cleaning businesses save time, money, and reduce scheduling errors. Project Deliverables: *5 animated videos (2-3 minutes each) *Scriptwriting assistance if needed (optional but preferred) *Professional voiceover (if required) *High-quality visuals and animations *Revisions to ensure the final videos meet our brand and...

...for my subscription-based business. The primary focus of these sequences will be to engage and retain our subscribers. Key Responsibilities: - Design engaging workflows tailored to different lead stages - Segment our audience effectively, primarily by lead stage - Test and optimize campaigns for performance Content Strategy: - Create content that varies depending on the lead stage - Incorporate a mix of news, updates, educational articles, and exclusive offers Skills & Experience: - Proven track record with Active Campaign - Strong understanding of email marketing strategies - Experience in creating effective drip campaigns - Passionate about email marketing If you are experienced in these areas and can create effective strategies to drive our ...

I'm in search of a skilled Android developer who already has a published app on the Play Store. The task is to integrate our ads SDK into your app and perform testing. Having your own published app in playstore is mandatory for this project. The app must have atleast 100 daily active users, and at least a 1000 downloads. Requirements: - Integrate various types of ads: Banner, Interstitial, and Rewarded video ads. - Work with multiple ad networks including Google AdMob, AdX, ironsource, and Applovin. - The purpose is to test our ads SDK by integrating and publishing it in playstore, and get your feedback on the SDK product. Ideal Skills and Experience: - Proficient in Android app development. - Experience with integrating ads S...

*TEST PROJECT DO NOT BID* *TEST PROJECT DO NOT BID* *TEST PROJECT DO NOT BID* I'm looking for a skilled app developer to create a healthcare application focused on facilitating online consultations between patients and healthcare providers. Key Features: - The app will cater to both patients and healthcare providers, providing a seamless interaction platform. - The online consultation section needs to be robust and feature-rich. It should include: - High-quality video call functionality - A reliable chat messaging system - Capability for file uploads, specifically for medical documents Ideal Skills: - Proficiency in mobile app development, preferably with a focus on telehealth solutions. - Experience integrating video call, chat a...

3D modeling and nine photorealistic renders. Two projects. I offer unlimited corrections focused on a main idea, which are included: - Scale / proportions adjustments - Color / Material adjustments - Lighting adjustments - Image Composition - Distribution - Camera configuration / location - Personal mistakes Test different variations of complex objects are not included. But example, if you want to test 2 - 3 floors that is possible.

...Type: Contract Job Overview: We are looking for a skilled and self-motivated Computer Programmer to develop a software solution that will automate the process of collecting property tax delinquent data from public property records. The solution will allow for filtering and sorting between different property types (houses and land) and should extract specific property-related information including owner names, addresses, APN (Assessor’s Parcel Number), delinquency status, county details, lot size, assessed value, and market value. The ideal candidate should have experience building web scrapers, APIs, or data collection tools, with strong programming skills and a focus on extracting and organizing real estate data efficiently. T...

...Available Budget: $20 per unique creative $30 per unique creative with 5 variations (includes headline/color changes) About Us: We're a growing LinkedIn ad creative agency working with B2B Tech clients. We're seeking a reliable designer for ongoing collaboration, with potential for a monthly retainer position in the coming months. Here are some examples of designs (you must go through all of these AND be able to make all of these to the same quality level or better): https://www

The domain name is We sell alot of products. I am looking for a mobile and desktop version on this new page. Type in the url to see it at the moment. The logo will stay the same. And i will provide it below. I am looking for graphic design (image) only I will relocate the design to my shopify store. If you have any questions i am here to help. I would prefer 2 images. One desktop and one mobile Thanks

I'm in need of a modern styled inv...of a modern styled invoice template designed in Microsoft Word. This should be tailored for my company and will include my company name and logo at the top. Key Features: - Design should be modern and clean - Set boxes for pictures labeled as 'Before pic' and 'Test spot pic' - Designated text area to describe the aforementioned pictures - Specific area for detailing the scope of labor - Section dedicated to pricing per foot The ideal freelancer for this project should be proficient in Microsoft Word with a strong design sense, particularly in modern aesthetics. Experience in creating invoice templates or similar documents would be highly beneficial. The goal is to create a professional an...

...implemented, including creating a hierarchical outline and sending requests to the API for article generation. However, an issue has been identified in the final looping process, which requires debugging and modification. Existing Script Functionality: 1. Outline Creation: The script generates an outline in a hierarchical structure, formatted as follows: H2: Topic 1 H3: Subtopic 1.1 H4: Detail 1.1.1 H4: Detail 1.1.2 H3: Subtopic 1.2 H3: Subtopic 1.3 H2: Topic 2 H2: Topic 3 H3: Subtopic 3.1 H3: Subtopic 3.2 H3: Subtopic 3.3 H4: Detail 3.1.1 H4: Detail 3.1.2 H4: Detail 3.1.3 - Each H2 represents a primary topic. - Subheadings (H3, H4, H5, etc.) are nested under their respective H2 headings. 2. Group-Based Article Generation: - Each H2 and its corresponding subhead...

I'm seeking an expert in Wyn Report Designer to help generate customizable reports from SQL/Pulseway databases. I'm looking to build managed Pulseway RMM Systems report containing Monthly reports on the current status of usage of components ie Hard drive size vs used, Ram amount vs average use, CPU type vs average load, Backup Status and AV status/preventions, failed logins/network intrusions. All of which I can currently obtain as seperate reports but want contained in single report laid out in format for my clients. The ideal freelancer should be adept at utilizing pre-built templates within the software to expedite the report creation process. Experience with Specifically Wyn Report Designer is crucial, as all reports will be Created from here. Ideally, th...

...data and technology company specializing in technology consulting and digital transformation. We work with startups, small and mid-size businesses to optimize processes, data and technology strategies, and deliver business value. We’re looking for a Freelance specialist or small digital marketing agency to help us increase our B2B Sales Qualified Leads (SQL) and monthly revenue goals. What We’re Looking For: We’re seeking a highly motivated freelance business development professional or digital marketing/sales agency with experience in B2B lead generation, digital marketing, email marketing, SEO, LinkedIn and social media. The ideal candidate/agency has a proven track record of delivering results, works independe...

...Job Description: I'm looking for a highly skilled and experienced Senior Software Engineer to handle outsourcing project. The ideal candidate will have a strong background in building and managing cloud infrastructure for machine learning applications, following the MLOps model. This role is fully remote. I'm looking for an Asian developer who is willing to work across EST and PST hours. ● Key Responsibilities - Build and maintain scalable cloud infrastructure to support machine learning operations (MLOps). - Design, develop, and implement public and internal APIs. Create event-driven and streaming-based services for efficient data processing. - Develop and maintain batch data pipelines for machine learning on massive da...

...Responsibilities: - Manage delivery schedules: You'll need to ensure that all deliveries are on time and efficiently planned. - Coordinate with delivery drivers: Your role will involve liaising with our team of delivery drivers, making sure they have the information they need and are following their routes efficiently. - Resolve customer inquiries: Handling customer queries is a vital part of this role. Your excellent communication skills will be put to the test as you interact with our clients, addressing their concerns and queries in a professional and timely manner. Ideal Candidate: - Previous experience in logistics: Your understanding of logistical planning will be key to managing our delivery schedules and coordinating with drivers. ...

...designer with a passion for branding and marketing materials? We're looking for a Part-Time Graphic Designer to join our team! If you’re skilled in creating impactful designs and comfortable collaborating remotely, we want to hear from you. Requirements: Proven experience in graphic design, with a strong portfolio showcasing branding and marketing projects. Proficiency in design tools such as Adobe Creative Suite (Illustrator, Photoshop, InDesign, etc.) and familiarity with AI-driven design tools. Reliable and self-motivated, with excellent time management skills to meet deadlines. Strong communication skills and comfort using video conferencing tools for collaboration. Bonus Skills: Photo editing expertise. Familiarity with AI-bas...

...nutrient tracking, and personalized recipe recommendations to improve user engagement and dietary habits. Key Features 1. User Account Creation Users should be able to create accounts and input basic personal details such as: Name, age, gender, email, and password. Height and weight (to calculate BMI in the backend). Personal history of illnesses, Family history of illnesses (e.g., diabetes, heart disease). Enable secure login and account management, including password recovery. 2. Image-Based Meal Logging Image Upload: Users can upload images of their meals. The system identifies the dish using GPT4o and prompts for confirmation or manual input if needed. Follow-Up Questions: Ask predefined questions to refine meal details...

...seeking a skilled Python developer with expertise in web scraping to create a script that extracts product information from websites. The solution must be efficient, reliable, and capable of handling diverse website structures. Project Requirements: Domain Extraction: Start with a large array of email addresses and extract their respective domains. PDF Search: For each domain, search for downloadable product sheets in PDF format. HTML Product Extraction: If PDFs are unavailable, extract product information directly from the HTML content of the website. Robustness: Ensure the script is adaptable to handle varying formats and structures of product information across different websites. Desired Qualifications: Proven experience in Python web scraping (e.g., using li...

I'm on the lookout for a skilled 3D designer with experience in creating and adapting models for , specifically for crafting 3D Map Assets used in decorating the in-game area. Key Responsibilities: - Create low-poly 3D models that fit the game's aesthetic. - Work on various types of models, including urban and nature elements. - Collaborate with me to determine the specific types of assets needed. Ideal Skills: - Proficiency in 3D design software. - Prior experience with or similar projects. - Strong understanding of low-poly design principles. Please note, the specific types of low-poly assets to be created will be discussed in detail during the project.

...skilled WordPress expert to configure and customize our pre-installed taxi booking theme and plugin. The goal is to optimize the website for a seamless user experience, ensuring all functionalities work perfectly while maintaining a professional and modern design. Additionally, we aim to make the website fully mobile-responsive and explore options for converting it into a functional Android and iOS application. The theme and plugin are already installed, and you will receive the following: Content in 5 languages along with the requested images. A clear structure for the menu: * Home * About Us * Services * Destinations: (Page only, I will add the destinations. Add the booking plugin here for fixed pricing.) * FAQ: (Page only, ...

It's about conversion! This project is a test to gauge the response of 5,000 current clients to a special offer. Familiarity with affiliate business and casino and sports betting helpful. Knowledge of sending bulk email and reduced bounce is required. I'm looking for an expert in email marketing with a focus on promoting new products. The ideal candidate will help me connect with my existing customers via promotional offers, with the ultimate goal of driving product awareness and sales. Key responsibilities: - Craft engaging promotional emails aimed at product promotion - Develop a strategy to reach all existing customers - Track and report on the effectiveness of each campaign Skills and experience: - Proven experience in emai...

I am looking for an experienced and skilled individual (no agencies, please) to work with my developer on a quality assurance and testing project for an upcoming social media app. This role requires someone who can thoroughly review the code, test various app components, and ensure the app is bug-free, responsive, and capable of running smoothly across platforms. Key Responsibilities: -Perform manual quality assurance testing for app responsiveness across iOS and Android platforms, including varying screen sizes, platforms, and network conditions. -Conduct backend code inspections to identify flaws, oversights, and bottlenecks, focusing on: JavaScript (NodeJS and ExpressJS - no TypeScript). PostgreSQL (tables, relations, const...