Mysql interview question ruby rails interviewcông việc

...messaging services to handle asynchronous communications, ensuring efficient and reliable data exchange across system components. SDK Development - Develop and maintain an SDK that provides third-party developers with the tools needed to integrate their AI bots or other services with our platform, including comprehensive documentation and support. Database Management - Manage and optimize MySQL database interactions within the WordPress environment, ensuring efficient data retrieval and storage. System Integration and Testing - Oversee the integration of all system components, employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides...

I'm in need of an experienced Linux and Server Admin who can help me with the following tasks: - Linux and Server Administration: Proficient in CentOS, you'll be managing my server and ensuring its optimal performance. - Web and App Installation: You'll be responsible for installing and configuring various websites - coded in PHP, Node.js, and Rea...administration, and web/app installation. Proficiency in PHP, Flutter, and React Native is required. ------------------------------------------------------------------------------------------ Should have experience in linux VPS, setting up sites apps email dns firewall NO CPANEL. All work to be done using command line Sites are in php wordpress Node React Apps are in React Native Flutter Database: Mysql/mongo Amt pos...

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

...represented. 4. Can use any type of medium. 5. Shape: Square shape logo 6. Design should be original and not infringe on any copyrights. 7. Final deliverables should include Adobe files (Illustrator or Photoshop) with all layers available, and all files used. Submission Guidelines: - Submit your original logo design through the contest platform, we will be active on the messages, if you ask a question, give us a few days and we will get back to you. If you prefer to direct message, you can do that too. - Ensure that your design aligns with the provided instructions and criteria or it may get rejected. - Plagiarized or copyrighted entries will be automatically disqualified and reported. - Rejected entries indicate missing criteria's and will not be considered. This is not ...

...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 need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

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 am in need of a skilled Java developer to create a comprehensive CRUDS (Create, Read, Update, Delete, Search) functionality for a ticket tracker application. The application should be backed by a MySQL database.

I am seeking a skilled Voiceflow professional who can assist me with designing the conversational flow and integration testing for my project. This also includes detailed test question construction. Key Responsibilities: - Designing Conversational Flow - Constructing Test Questions Skills and Experience: - Proven experience in Voiceflow or similar platforms. - Expertise in Integration Testing is pivotal. - Prior experience in designing conversational flows and constructing appropriate test questions. Ideally, you excel in system testing and ensuring dialog flow accuracy, as it's one of the significant functionalities of the project that require testing. You should be organized, detail-oriented, and capable of identifying and handling errors efficiently.

Fix pine script code send alert to telegram group too many signals with to dirction i need it to send once per entry only until the next signal came the code already wrote the message already wrote need to fix the issue only Pine script i dont need any1 full staked and dont know what i need i need it asap if more question what u dont understand will not accept the project its small fix dont request high the pinecoder know that ?? type 2233 if u read this

I'm seeking professional help to rectify a problem with one of my programmes which is presently operational on a Windows 8.1 environment but doesn't launch on Windows 11. I'm not certain about the original coding language as I skipped that question, making it necessary for the freelancer to have adept skills in multiple languages, mainly in C++, Java, and Python. I'm also unsure about specific software or hardware dependencies that might be influencing the situation. However, the freelancer must have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly appreciated. However, the freelancer needs to...

See attached detailed description of project. Ideal Skills: - Proficient in pHp 8 - Extensive experience in database integration, particularly with MySQL® - Strong problem-solving skills - Attention to detail and thorough testing - Previous experience with file processing in pHp I'm looking for a professional who can work efficiently and deliver high-quality results. If you believe you possess the necessary skills and experience for this project, I look forward to reviewing your bid.

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 looking for a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-pa...API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript -> jQuery -> REST API -> MySQL...

...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 developed for Android. The general structure of the application and a sample of the answer sheet are attached. Requirements: - Strong knowledge and experience in OpenCV and image processing - Proficiency in Android development - Familiarity with mobi...

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.

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

...created output file. In column D "IVA 22%" the sum of all the values in column J "totale ordine" of the input 1 file which have the same date in column A "DATA" of the "example output" file and the value 22 in column K of the newly created output file. Ideal Skills: - Proficiency in Excel - Experience in report creation - Data analysis capabilities - Attention to detail If you any any other question please contact me. Thanks, Regards, Marco...

**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 am looking for a developer who could develop a iOS IPhone app. It should do following Use a authentifcation based on a MySQL database table (for login) store that login as session that I not need each time again login. Create a connection between that MySQL and grab data and display that on app. Store that data like on cache that I can see that data also offline. I only will answer to developer who native language are English or German and who could show some iOS work.

We have two sites on windows server that we would like to move to linux, without having to rewrite code for both sites. The current code is ASP and ASPX (vbscript) with Acess dbase. I am looking for someone that can make our ASP and ASPX pages to work on linux server with mysql dbase. We have a VPS on godaddy server, that we can host the two sites on. You are only qualified if you have done this many times before. You may not use our sites to "try" to do this after doing research, we only want experienced individuals on this.

...automated bids that it just wastes time. Also bid responsibly and don't ask " What's your budget" Bid what you think it's worth to you. I want a clean new Quasar Application that you load "@anthropic-ai/sdk": "^0.21.0", and makes a call using Setting up a demo Quasar app takes less than 5 min. my sample code: async sendMessageToClaudeChatbot(message) { this.Claude_question = "Claude Question"; const anthropic = new Anthropic({ apiKey: process.env.CLAUDE_COLAB, }); (anthropic); const anthropic_message = await ({ // mode: "no-cors", max_tokens: 1024, messages: [{ role: "user", content: "Hello, Claude" }], model: "cla...

i need my aws rds mysql connceted with retool. it gives error and i am unable to link it. i need help fast so only if you can help in this moment not in 1 h

I'm in need of an experienced PHP MySQL developer to handle data management and manipulation, database design and optimization, as well as web application development for my project. The goal is to create a robust e-commerce website with the following features: - Product listing and details - Payment gateway integration Ideal candidates should have a rich background in PHP MySQL, web application development, particularly in e-commerce platforms, and database design and optimization. Your skills in crafting systems that are user-friendly, secure, and streamlined will be essential. Emphasizing on data management and security is also paramount in this project. Let's connect if you possess these skills.

I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.

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 part of the info the client sunbmits like Name, Phone Number, Zip Code, etc. Please ask questions before agreeing to begin.

...begin with; these will come in pairs. One partition will be high priority (aimed at running uninterruptible workloads) and the second will be low priority (spot), both using the same VM SKU. In the first instance, I would like to use HB120v2 for the two CPU partitions and the A100 GPU for the two GPU partitions. I would also like to have SLURM accounting set up within the cluster i.e. not using the MySQL service on Azure. Lastly I would like the cluster to have Prometheus/Graphana monitoring capability so that individual users can monitor job statistics. Eventually, we would like users to also be able to interact with the cluster via VS Code and Jupyter. Delivery : within 1 week -- please only bid if you have done this before. Please provide your past experience and any relevant...

...details to the remote server. Design and develop a secure admin panel using Laravel 10, MySQL 8, and PHP 8: User registration and management. Device registration with approval workflow. Device blocking functionality. SMS panel to send SMS commands to registered devices. Ability to set the remote server IP for each registered device. Implement user authentication with: Login ID generation based on device MAC address. User-selectable password after admin approval. Login expiration for enhanced security. Write well-documented and commented source code for both the Android application and admin panel. Qualifications: Proven experience in Android app development (Java/Kotlin). Proficiency in Laravel framework, MySQL, and PHP. Strong understanding of security best practices for...

...AWS and Digital Ocean. - Design and deploy modern frontend user interfaces using the latest UI technologies. - Build secure and scalable mobile app REST APIs. - Manage databases using MySQL and NoSQL. - Use DevOps tools to monitor and scale applications. Looking For: - 3+ years of experience in software development - Experience with LAMP and MERN stacks - Knowledge of PHP, CSS, and JS and web technologies - Familiar with S3, cloud hosting, DNS, web security - Ability to use vanilla code and minimal libraries/frameworks - Can code fast and effective with simple Bootstrap and jQuery - Strong skills with MySQL and NoSQL (Firebase, MongoDB) - Good english communication skills in Slack and in meetings - Availability to work ~20hrs per week between 9AM-6PM PST - A passion for c...

It is necessary finish a web application in python + django regard the statistic of stocks. So it is necessary: some fetaures of some filter; -. make some change to mysql database and api to datafeed. -. verify the formulas and add some features; -. make better the design. - create an admin page with security login and import stocks manually. Please answer only if you can show similar experiences

...WordPress Developer, you will be responsible for both the frontend and backend development of our WordPress websites. Your main tasks will include creating and editing custom themes and plugins, optimizing website performance, and implementing new features (such as translating plugin language, or overwriting some existing AI features). The ideal candidate should have strong knowledge of WordPress, PHP, MySQL, and frontend technologies such as HTML, CSS, and JavaScript. Responsibilities: - Develop and maintain WordPress websites - Create custom themes and plugins - Optimize website performance - Implement new features and functionalities Requirements: - Proven work experience as a WordPress Developer - Strong proficiency in WordPress, PHP, HTML, CSS, and JavaScri...

Busco desarrollador web para realizar una página exclusivamente con Java, Javascript, HTML, CSS (puede usar Bootstrap) con base de datos MySQL utilizando XAMPP (phpmyadmin) y Apache NetBeans/Eclipse como entorno. La pagina tiene que tener un inicio de sesión/registro de 2 tipos de usuario (usuario cliente y administrador). La pagina tendrá un menú de navegación en la parte superior con varias pestañas: inicio (introduccion a la web, ultimas noticias, etc), videojuegos (aqui estaran todos los videojuegos de la web con un filtro de busqueda por genero y plataforma sacado de la base de datos donde se ve el nombre de cada uno, foto de su portada, genero, plataforma, fecha de lanzamiento, etc. y alguna opcion para ponerles nota, opinar, añ...

...frameworks, MySQL database, and E-commerce development to build a website. The developer should also have experience with Wordpress and integrating various platforms and APIs. Key project details: - The ideal candidate should have strong knowledge and experience in PHP frameworks like Laravel or Symfony, as well as Wordpress. - E-commerce development experience is essential, especially in designing and building secure and user-friendly online stores. - Proficiency in MySQL database is required. - The website will require integrating payment gateways, social media, and email marketing platforms. Hence, the developer should have experience in these areas. Ideal skills and experience: - PHP frameworks (Laravel, Symfony, CodeIgniter) - Wordpress - E-commerce site developmen...

...who will be responsible for carrying out the tasks listed on the job cards and the managers/administrators who oversee these tasks. Employees will need access to all past completed, active jobs, quotes, parts and customers. Managers will need to have access to send the completed job to QuickBooks, add / remove employee names and set an hourly labour rate. Ideal Skills: - Proficient in PHP and MySQL - Experience in developing web-based forms - Knowledge of job management systems - UX/UI Design capabilities for a user-friendly interface Please see the attached Specification PDF or view at: Please consider the functionalities I'm looking for and the primary users of the system when bidding. Please contact for

I have a scanned PDF document that needs some alterations. The primary tasks include changing the company name and updating contact information. Your expertise in both text editing and formatting is cr...be replaced with the new information provided. Skills and Experience Required: - Proficiency in PDF editing: Experience with editing text in scanned PDFs is necessary, as the document is not in its original format. - Attention to detail: It's essential that the changes are made accurately without affecting other parts of the document. - Familiarity with formatting: Although the user skipped a question regarding specific formatting changes, having a good eye for layout and design would be an added advantage. Please provide a brief summary of how you'll approach this proje...

I'm in need of an experienced Java Full Stack Developer to build a comprehensive application with the following features and requirements: - **Fea...ability for users to share content and interact with the application through social media platforms. - Payment gateway integration: A reliable and secure payment gateway to facilitate transactions. - Email marketing services integration: Integration with email marketing services to streamline communication with users. Your expertise with Core Java, Java 8 features, J2EE, JDBC, servlets, MySQL, JSPs, HTML, Spring MVC, Spring Boot, ORM, MVC Architecture, and API Development will be essential. Additionally, experience with integrating and implementing third-party services will be highly valued. Looking forward to seeing ...

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

I'm in need of an experienced PHP ...following requirements: - User Authentication and Authorization: The developer will need to create secure login and registration systems for our websites. - Database Integration and Management: Proficiency in MySQL is a must. The developer will be responsible for managing and integrating databases effectively into our sites. - Payment Gateway Integration: The developer will have to implement payment gateways, ensuring a smooth and secure payment process for our users. Ideal Skills: - Proficiency in Core PHP and Wordpress Development - Strong understanding and experience with MySQL - Previous experience in User Authentication and Authorization - Previous experience in Database Integration and Management - Previous experience in Payme...

...require a proficient PHP programmer to handle a variety of tasks on my project. These tasks will include: - Website development: The core of this project involves visualization of the key concepts, hence proficiency in creating efficient and visually appealing websites is a must. - Database integration: The website functionality will be backed by a responsive and robust database. Expertise in MySQL or similar database is critical. - Custom script development: You will need to develop tailored scripts to meet the specific needs of my project. Familiarity with CodeIgniter is essential for this project since we will be using this framework for our site. Given the complexity of the work, I prefer a mid-level developer who has substantial experience in the aforementioned areas. Your...

I'm in need of an animation expert to create a high-quality map style animation video for my upcoming project. Key Project Details: - The purpose of this animation video is to {user skipped this question}. - The specific locations or regions to be included in the video will be determined by the expert. - The length of the video will not exceed 3 minutes. Ideal Candidate: - Proficient in animation with a strong portfolio showcasing similar work. - Experience with map style animations is a plus. - Ability to create engaging and informative content. - Excellent communication skills and a collaborative spirit. Please provide examples of your previous work if possible. Looking forward to working with a talented animator for this project.

I'm looking for a skilled PHP developer with experience in CodeIgniter for a new project in the e-commerce space. Ideal Skills and Experience: - Proficiency in PHP and CodeIgniter framework - Previous experience in e-commerce platform development - Strong understanding of front-end technologies, such as jQuery, JavaScript, HTML5, and CSS3 - Knowledge of MySQL and other relational databases - Familiarity with RESTful APIs and Web Services - Ability to work with version control systems like Git The primary goal of the project is to create a robust, scalable, and user-friendly e-commerce platform. The platform should be able to handle a large number of products, facilitate smooth transactions, provide a secure payment gateway, and have a user-friendly interface. A key part of th...

...not just correctness but also code efficiency and style. 2. **Real-Time Coding Environment** - Integrated Development Environment (IDE) enhanced with AI suggestions. - Live Collaboration with AI assistance features. - Code Execution with AI-driven optimization suggestions. 3. **Candidate Management** - User Profiles enriched with AI-driven insights based on past performance. - Interview Scheduling integrated with AI to suggest optimal times. - Feedback and Notes augmented by AI analysis. 4. **Test Customization and Delivery** - Custom Test Creation with AI recommendations. - Adaptive Testing dynamically adjusting questions using AI. - Timed Tests managed by AI to ensure fair play. 5. **Reporting and Analytics** - Performance Analytics enhanced by...

I need an exp... 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 if you are confident in your ability to meet these requirements and can deliver the project within the given ...

I'm looking for a PHP developer with substantial CodeIgniter framework expertise. The project at hand involves upgrading and optimizing an existing PHP application. Key Requirements: - Strong PHP skills and extensive experience with the CodeIgniter framework - Proficiency in MySQL database management for database optimization and management. - Familiarity with front-end development to be able to enhance the UI/UX as part of the upgrade. Your main responsibility will be to improve the existing codebase, making it more efficient and scalable. This will involve database optimizations, code refactoring, and possibly some UI/UX upgrades. An understanding of security best practices in web development will also be highly beneficial. If you have previous experience with similar pro...

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.

Website Development for Education Purpose - I am looking for a developer to create a website for education purposes. - The website will primarily be used for uploading question papers in PDF format and providing a student login dashboard. - I prefer the website to be developed on WordPress. - The key functionalities I require are user registration and login. - Additionally, I would like the ability to upload and download content, as well as an interactive dashboard. _Conducting online quiz with ranking and candidate wise SWOT analysis. Ideal Skills and Experience: - Proficiency in WordPress development - Experience in creating user registration and login systems - Ability to implement content upload and download features - Knowledge of creating interactive dashboards - Fa...

Objective of the project The goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, ...from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to improve it. Automatically publish enhanced content to a WordPress blog and various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools to correct errors in the part described in the technical document, so the development is...

...Programmer to join our team and work on our B2B ecommerce website and app development. The ideal candidate will have a strong background in PHP and Laravel, with experience in building and maintaining ecommerce platforms. This is a remote position, offering the flexibility to work from anywhere. Key Responsibilities: Develop, test, and maintain high-quality ecommerce solutions using PHP, Laravel, MySQL, HTML, CSS, JavaScript, and related technologies. Collaborate with the design and product teams to implement new features and improvements. Optimize and enhance the performance of the website and app to ensure a seamless user experience. Troubleshoot and resolve issues as they arise, ensuring the stability and reliability of the platform. Write clean, well-documented, and maintai...

I'm seeking a skilled professional to help me understand the basics of the Zig programming language, specifically in relation to MySQL/MariaDB. I would like assistance in the following areas: - Learning how to incorporate MySQL/MariaDB within Zig projects

...create a new one called Booking Category. This will need look up the `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