Mysql interview questionsроботи

Front: Vuejs3 (routing, vuetify) Back-API: flask( SQLAlchemy, flask-restful, uwsgi), jwt, mysql Нужно реализовать SPA. Два типа пользователей (юзер, админ), доступ к SPA только после авторизации (пара логин/пароль). Для юзера: (страница №1) - реализовать поиск по базе данных, поиск по всех полях (отдельно по дате, фио, заказу), предусмотреть последующую фильтрацию результатов пользователем (фильтрация: пользователь вводит текстовую строку и если она может быть включением любой ячейки своей колонки результата поиска то отображается, остальные прячем), предусмотреть пагинацию. (страница №2) - как и страницы №1, но база другая, поля базы совпадают. Для админа: добавление новых юзеров админом, и доступ к функционалу описанному у юзера. База данных: ФИО (текстовое), ДатаРожд...

Для нашого онлайн ...найсучасніших веб-технологій для різних пристроїв (мобільних, планшетів) Профіль: • Хороші знання з програмного забезпечення (об'єктно-орієнтований дизайн, шаблони проектування, тестування) • самостійна робота та вирішення проблем • високий рівень мотивації • Досвід роботи з PHP, Symfony, Laravel або Zend, є перевагою • Вільне володіння німецькою чи англійською мовами • Дуже хороші знання PHP, MySQL та JavaScript • Добре знання HTML (5) та CSS (3)

Будь ласка, вкажіть 1-3 проекти, де Ви працювали із таксономіями (WordPress) та як Ви їх застосовували, де робили кастомну адмінку PHP+MySQL. Очікую на оцінку вартості та термінів, або уточнювальних запитань. Посилання на ТЗ:

Потрібно розгорнути на віртуальному сервері 1. веб сервер (apache/nginx/ +PHP) 2. СУБД (mysql/postgresql) 3. сам сайт

1) Є портали відкритих даних. наприклад 2) Потрібно розробити засоби завантаження відкритих наборів даних. вимоги: 1) Веб рішення (далі сервіс). на базі наприклад PostgreSQL / MySQL 2) конфігурація процесу завантаження конкретного набору даних: - даємо посилання на набір даних - Сервіс парсить структуру - на підставі парсинга конфігуруємо таблицю БД, куди будемо завантажувати дані - вказуємо періодичність завантаження даних - зберігаємо конфігурацію. 3) Сервіс повинен виконувати завантаження за розкладом. 4) Сервіс веде лог завантаження 5) Перегляд інформації повинен мати: графік та лог завантаження, таблицю з даними, конфігурацію процесу(тобто url, тип файлу)

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Привіт chnazar, бачив твоє резюме на рахунок пошуку роботи якщо тебі цікавий довготривалий проект (PHP,JS,HTML,CSS,MySQL) можемо обговорити деталі

...or Vendor Central accounts • Uploading new content the team provides on to seller central or vendor central of the client account • Doing regular checks on our Amazon Seller Central accounts for any policy violations or account health warnings • Doing regular audits to our product listings to ensure proper operations • Inventory Forecast and Review Management • Communicate with clients (e.g. questions about shipping, content revisions, etc.) • Staying informed with Amazon’s best practices, new trends and technologies, and platform updates • Inspecting landing pages, product information and all other listings to check if they conform to your checklist Preferred skills • Minimum 3+ years of experience working as an Amazon Account Manag...

Optimizar una página web de comercio electrónico Wordpress / Woocomerce / Divi y añadir algunas funcionalidades de uso interno, que implican incorporar nuevas tablas MySQL, CRUD y consultas. A. Cambiar la organización y visualización de los productos en la web B. Incorporar algunas tablas relacionadas, su CRUD correspondiente y algunos informes sólo para uso interno.

I have an iOS app ready to go and an active Apple Developer account. I've managed to set up the app's metadata and assets for the App Store. However, I need someone to assist me with the final step of actually p...actually publishing the app. Ideal skills and experience: - Experience with publishing iOS apps to the App Store - Knowledge of Xcode and the iOS development process - Proficiency in managing and navigating the Apple Developer account interface - Ability to troubleshoot and resolve any publishing issues that may arise - Excellent communication skills to guide me through the process and answer any questions I may have This project is quite straightforward as most of the work has already been done. I just need someone to take the reins and ensure the app gets pub...

...set of lessons to follow. Ideal candidates for this project would have: * Proficiency in video creation and editing * An understanding of art and conveying it through lessons * Experience crafting effective marketing reels for a similar audience * Ability to communicate well and teach the artist basics of recording and editing own videos I attach a sample of works. Please feel free to ask any questions. As this is a trial project, it is on limited budget....

...pads for 2-5-year-olds. Our product is thriving in China, and we're now targeting the U.S. market. Now, we need a talent to take on game card designing. I will send you a video and some materials about our product. The page size is only:244mm*152.5mm DPI: 300 Please let us know if you are interested in this project. We're excited about the potential collaboration. Don’t hesitate to ask any questions....

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds...primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database ...

Vanakkam Editing Enthusiastic, I hope this message finds you well. I'm reaching out because I'm in search of a talented YouTube editor based in Bangalore for a Tamil cooking channel who knows Tamil language both read and write. Here's a brief overview of what I'm looking for: Experienc...I'm looking for: Experience in editing cooking videos, particularly Tamil cuisine. Proficiency in latest video editing software and AI tools. Ability to add subtitles in both Tamil and English. Creativity in enhancing video quality and engagement. If this opportunity interests you, I'd love to discuss further details, including compensation and workflow. Feel free to reach out if you have any questions or if you'd like to see samples of our content. Looking f...

I am hiring for a Full Stack Web3 developer for my team. Tech Stack: Blockchain: Blast (EVM) Frontend: Typescript + NextJS + Tailwind + Vercel + WAGMI + Ethers V5 + Typechain Backend: Typescript + Vercel Lambda + tRPC + AWS + Prisma ORM + Ethers V5 + Typechain + Upstash Redis Database: MySQL (Planet Scale) + AWS S3 Storage Randomization: Gelato VRF Static File Hosting: AWS S3, Pinata Smart Contracts: Foundry, Hardhat Monorepo. Here you go: Objective: Design and implement a scalable backend and frontend system for tracking and displaying NFT transactions similar to the "Activity" feature on OpenSea The system should handle varying loads seamlessly, from 500 to 50,000 users. Tasks: System Architecture Design: Task: Design the overall architecture for the activity

*PLEASE READ THE GOOGLE DOCK BELOW CAREFULLY AND CONTACT US FIRST IF YOU HAVE QUESTIONS* Details of our current project STACK can be seen here -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we

I'm seeking an energetic and engaging actor who can boldly approach people on the street and ask them trivia questions centered around pop culture. - The right candidate would ideally have a background in an interactive and spontaneous form of entertainment such as improv or stand-up comedy. - This job requires a friendly and approachable demeanor to establish quick rapport and get people to participate on camera. - The goal of this project is to create humorous responses from the public - so, a great sense of humor and quick wit would be beneficial. - Additionally, some knowledge of pop culture would be advantageous in facilitating engaging and entertaining exchanges.

I need between 1-2 freelance interviewers to: - Conduct market research interviews in key areas around Vietnam including Hanoi, Ho Chi Minh City, and Da Nang. (Phone/online interview available as well) The ideal candidate should have: - Proven experience in market research interviews, with excellent command of Vietnamese and English languages. - Strong skills in communication, recording, and documentation of research data. Please apply if you fulfill these criteria. I look forward to your bids.

...impactful visual content to make changes to an existing electronic survey I have in Survey Monkey. Here is some insight into the specific tasks you'll be undertaking: - Update and enhance the current survey: This involves infusing fresh content by updating existing questions, introducing new questions, and replacing the current graphics. - Create an entirely new survey: This will include a mix of existing and new questions, along with logos and product images. The goal of this survey will be to gather customer feedback, so creating questions that retrieve valuable customer insights will be essential. - Build a survey flow and link answers for follow up automated EDMS and other forms of communication. - Survey results will then collate into an existi...

I have a PDF file that needs its background changed. I'm looking for a professional who can assist with this task. Your responsibilities would include: - Changing 4 pages the background of a PDF file to a specific color (color to be advised) - Selecting a suitable color to enhance readability and aesthetic appeal It would be helpful if you have: - Expertise in PDF editing - A good unders...responsibilities would include: - Changing 4 pages the background of a PDF file to a specific color (color to be advised) - Selecting a suitable color to enhance readability and aesthetic appeal It would be helpful if you have: - Expertise in PDF editing - A good understanding of color theory and design - The ability to provide guidance on color selection Please let me know if you have any ...

I'm in need of a talented 3D designer who can bring my vision to life. The project involves creating a realistic 3D rendering for mattresses, providing a clear representation of both the internal components and top cover. Key Project Requirements: - Capability to visualize and create the internal components of a...custom artwork into 3D designs - Proficiency in creating realistic 3D artwork for a top cover I'm looking for a freelancer who is skilled in 3D design and rendering, with a keen eye for detail. Experience in the furniture or textile industry would be a plus. Details of the number of mattresses, details and requirements are included in the attached brief. Feel free to reach out if you have any questions or need further clarification before bidding. Look forwa...

...full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Experience programmers - Knowledge in Google Mapping - Knowledge with AWS and setting up Linux servers and MySql databases Your team will be replicating our current s...

I'm looking for a talented designer to create a logo for my business. The logo should be unique, visually appealing, and help establish a strong brand identity. All requirements are in the attached. Any questions please DM me. Thank you

...experienced in Apache NiFi to create a workflow pipeline. This will involve converting and integrating data into MySQL. Key Requirements: - Proficiency in Apache NiFi: You must have a solid understanding of the platform to develop efficient and reliable data conversion workflows. - MySQL Integration: Experience in integrating data with MySQL is essential. - Data Conversion: You will be responsible for converting the data - previous experience in this area is highly desirable. Please note the following: - The type and source of data to be converted is not yet defined. - The triggering mechanism and frequency of workflow runs are also pending. Ideal Skills: - Proficient in Apache NiFi - Strong MySQL Integration skills - Previous experience in data conversion...

Objetivo El proyecto implica el desarrollo de un MiniCRM con las siguientes características principales: Autenticación y Gestión de Perfiles Implementación de un sistema de inicio de sesión seguro. Gestión de perfiles y roles de usuario para garantizar accesos independientes a cada módulo del sistema. Diseño ...Mantenimiento de un historial detallado de cada transacción de entrada y salida de stock, incluyendo observaciones para el seguimiento del movimiento de inventario y el usuario que realizó cada transacción. Consideraciones Adicionales El sistema se desarrollará utilizando PHP sin el uso de frameworks, asegurando una solución personalizada y optimizada para las necesidades específicas d...

Here is the next video for Groups. All the files are here: Let us know if you have any questions.

I'm a student/recent graduate in Mechanical Engineering. I have a few general questions I'd need a competent and knowledgeable mechanical engineer to help me with. I will send you the questions and would require a very prompt response. I'm looking for someone who can assist me with open-ended mechanical engineering questions that might include but not limited to: - Basics of Mechanical Engineering - Understanding and applying engineering principles - Problem-solving in mechanical design - Thermodynamics and heat transfer - Fluid mechanics - Any other relevant topics in mechanical engineering The ideal candidate should: - Be a Mechanical Engineering student or recent graduate. - Have a good grasp of general mechanical engineering concepts and theorie...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complex...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

Our Company Trans-Continental Textile Recycling Ltd. is a textile recycling company established in 1990, with 34 years of growth. We are based in Surrey BC with an operation in Calgary. We recycle textiles from the whole of Western Canada and ship finished pro...o Sign Shop o Print Shop o Adobe Illustrator • Knowledge of Roland TrueVIS VG540 would be highly valued. • Quick learner of new printing and finishing equipment • Strong attention to detail and ability to meet deadlines. • Excellent understanding of digital printing principles Please feel free to present your portfolio to support work experience with a cover letter or during an in-person interview. Benefits: • Hybrid position • Part-Time opportunity with flexible schedule weekdays and w...

...verses in that chapter for selection. ELSE the app prompts the user is incorrect and also prompts the correct chapter answer. C. THEN, IF the user selects the correct verse, then the app prompts that the user is CORRECT and scores an additional point. ELSE, the app prompts the user is incorrect and also prompts the correct verse answer. Repeat until the 10 questions of the questionnaire is complete. 3. At the end of the 10 questions, it displays your total score out of 10. 4. Afterwards, it returns to the home page, to START. The app should meet the following requirements: - Conduct a simple questionnaire based on the provided API - The app should be mobile compatible, as in looks aesthetically sound on mobile. - Should be compatible with all major browsers on PC, Ma...

We are looking for a videographer who can shoot an interview and b-roll for a tech company corporate video, in Oklahoma. Including use of a basic set of lights (in case the location requires it), and sound recording. No editing needed.

We are looking for a videographer who can shoot an interview and b-roll for a tech company corporate video, in San Antonio, TX. Including use of a basic set of lights (in case the location requires it), and sound recording. No editing needed.

...the assigned Digital Strategist and Graphic Designer. Responsible for the publication of content, on time, taking care of spelling aspects. Work hand in hand with the Graphic Designer assigned to the team, for the execution of creative content, proposing and ensuring the fulfillment of goals and objectives. Writing creative blogs and current trends. Ability to communicate clearly with users to interview them to create compelling customer success stories Position requirements/ Skills: 3 to 5 years of experience as a Marketing Content Manager, Community Manager, or related positions. Previous experience working with SaaS B2B Edtech companies is a plus. Bachelor's degree in Communication Sciences, Marketing, or related field is a plus. Experience executing different social me...

Bids cannot be changed once made, so bid accordingly or ask questions before you bid to get a feel for what is required... I am looking for an experienced UX/UI designer to refine and enhance my funnel pages. Although the elements already exist, their arrangement and optimization need attention to significantly increase conversion rates. The optimal candidate should have a solid portfolio of similar past work for review and have strong skills in CSS/HTML along with design skills. I'm interested in seeing examples explicitly demonstrating your skill in effective funnel page design meant for conversion increase. I will primarily measure success through increased conversion rates. I will provide the list of several items I would like improved over my existing site. Skills and...

I need assistance to effectively integrate a post form into my project. The form should be skillfully designed to send data to a MySQL database, and to handle CRUD operations. Key Requirements: - Collaborate with me to understand the form's workflow and user interaction. - Skillfully implement the form to effectively send user data to a MySQL database. - Ensure the form is able to perform Create, Read, Update and Delete operations, where necessary. Ideal Skills: - Proficiency in form implementation. - Strong experience with MySQL databases. - Good understanding of web project workflows. Your bid should demonstrate your understanding of the requirements and provide a clear strategy for how you intend to approach this project.

Crea un sistema en Java, usando el IDE NetBeans y Xampp para la simulación de un sistema de control de empleados. En este proyecto desarrollarás las funcionalidades básicas del uso de Java e interacción con gestor de base de datos (MySQL) el uso de la biblioteca Swing de Java. Puntos para evaluar Uso de Variables Uso de Operadores Uso de Sentencias Uso de Instrucciones Uso de Arreglos Uso de Programación orientada a objetos Uso de Variables de texto Uso del controlador JDBC

...structure, directories, and templating system (Liquid). Experience manipulating orders, grabbing data from the database, and crafting custom views using Liquid shortcodes. Proven ability to develop custom Shopify plugins to achieve complex functionalities. Technical Skills: Proficiency in Shopify development languages (Liquid, JavaScript, HTML, CSS). Experience with database manipulation (likely MySQL). Communication & Collaboration: Excellent written and verbal communication skills in English. Ability to clearly explain technical concepts to non-technical stakeholders. Comfortable participating in regular video calls to discuss project progress. This is a long-term project for a passionate developer who thrives on pushing boundaries. Are you ready to take Shopify to the ne...

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, ...

the workbook consists of the below sections: - Section 1 - Vocational Education & Training - Section 2 - Core & Employability Skills - Section 3 - Learning Design - Section 4 - Learning Delivery - Section 5 - Assessment - Section 6 - Administration - Section 7 - Work Health & Safety each section contains between 15 to 26 questions, i will provide martial to help with finding the answers. the workbook is a training and assessment work book

I am looking for only Indians. I'm in need of a skilled writer for two key tasks: a business report and a blog post. Please note that some details were omitted by the client, so you may need to clarify them as you work. For the business report, I'll provide ...audience is also not clearly defined, so the content should be versatile and appeal to a broad range of readers. The ideal candidate for this project is: - Experienced in business writing and market analysis - Proficient in creating engaging, SEO-friendly blog content - Able to adapt writing style to different target audiences - Comfortable with some degree of ambiguity and able to ask clarifying questions - Able to deliver high-quality work within agreed timelines. Please include samples of your previous wo...

...has been included in the advice document. All fees have been disclosed, all the correct products have been mentioned, recommendations, and reasons, no incorrect client names have been used (sometimes we cut and paste from other advice documents, so we need to check that the wrong name has not been included) etc. Again, the above is not an exhaustive list, but it is to give you an idea. My questions: 1. Can the above be done? 2. Can it be done with one prompt, or will there need to be several prompts that are ‘layered’. This will be important as I will be asking AI / Technology unsavvy people to use these prompts, so they need to be easy to use. 3. What would be the cost of this project for you to design…something. 4. Do you provide a guarantee? I do no...

Estoy buscando un experto que me ayude a migrar una aplicación web PHP y Ruby on Rails desde Node JS a un servidor con Cpanel. Detalles clave del proyecto: - La aplicación web actual está construida utilizando una combinación de PHP y Ruby on Rails. - La aplicación interactúa principalmente con una base de datos MySQL. Habilidades y experiencia ideales: - Competente en Node JS, PHP - Fuerte conocimiento de MySQL. - Experiencia previa con tecnologías del lado del servidor y migraciones. - Familiaridad con Cpanel. El candidato seleccionado debe poder garantizar que el proceso de migración sea fluido, sin pérdida de funcionalidad o datos. Este proyecto es urgente, por lo que estoy buscando a alguien que pueda real...

...scalable backend infrastructure that can handle high volumes of bookings while ensuring a smooth user experience. I need a skilled Core PHP Developer to build a custom web application with database management capabilities, using MySQL as the preferred database management system. The application should be well-structured and efficient with an emphasis on data handling. Key Requirements: - Extensive experience working with Core PHP. - Proven track record of developing dynamic, secure, and efficient web applications. - Strong understanding and experience with MySQL database management. - Ability to ensure the application is well-structured and follows best practices for data handling. - Strong problem-solving skills and the ability to work independently. ?️ Key Responsibi...

Hello, this is a simple task. One of my friend got french nationality after 7 years live in France. All he want write a simple and nice text for post all of his social media profile to tell his story.. little bit motivations will appreciate on the text. 500 words maximum. If possible give a photo with textes. But no obligation.. ask all the questions need to ask in private. Small budget. Thanks.

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience ...Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQL or other r...

I'm looking for an experienced PHP developer who is well-versed with MySQL to help me with editing the search module of my website. The primary focus of this project is on modifying the way images are retrieved then displayed in the search results. Key Requirements: - Modify the retrieval of images in the search results to use URLs for specific sizes as opposed to the current methodology of storing images locally and then displaying. - No specific enhancements are needed for the image thumbnails, just an adjustment in the retrieval and subsequent display methodology. Ideal Skills: - Proficiency in PHP and MySQL - Experience with implementing search modules in web development - Familiarity with retrieving and displaying images in various sizes - Strong problem-solving ...

I'm in need of a skilled Python developer with knowledge of RAG and Chainlit to create an AI-powered chatbot. - Specific Tasks: - Develop an interactive chatbot to be used by customers - Implement RAG and Chain...interactions and provide accurate information - Integrate the chatbot seamlessly into our systems and platforms - Desired Qualifications: - Proficiency in Python, particularly in relation to chatbot development - Expertise in RAG and Chainlit - Experience in creating chatbots with strong interactive capabilities The primary functionality for this chatbot will be answering frequently asked questions. The successful developer will need to be able to create a user-friendly interface and ensure the bot is able to provide clear, concise answers to a vari...

Basic hello world sketch project for screen. Connect to Xiao_ESP32S3 sense via screen. No time wasters please, questions welcome. Immediate start preferred, follow up opportunity for successful completion.

I'm looking for a Google Sheets expert to help me automate a process involving day by day data input process I'm seeking a freelancer who can streamline and automate the repetitive task of data import and export in Google Sheets. The ideal candidate should possess the following skills and experience: - Proficient in Google...streamline and automate the repetitive task of data import and export in Google Sheets. The ideal candidate should possess the following skills and experience: - Proficient in Google Sheets: You should have in-depth knowledge of Google Sheets and be able to manipulate data effectively. - Automation Skills: Experience in automating processes in Google Sheets is essential. Feel free to ask any questions, and please provide relevant examples of your p...